You, me, we all do, and always will!
Spreadsheet queries are a bit more complicated. I still do not fully understand them in all honesty. They can do a lot of the same functions that a pivot table can do, but they can take it a step further by requesting only specific data from a spreadsheet. It involves a query function that can get very long and very complicated. The function pulls data from the data set and organizes neat and clean. One of the ROTC teachers at my school created a rubric to assess cadets attendance, dress, grooming, and other items in their evaluation. The query that he created then pulls students by class, date, whether they were present, and overall scores. He set up the parameters in the function of what exactly he wanted to have pulled. He was having trouble with the function showing an error that we were eventually able to figure out. However, this is something that I am definitely going to need to do my research on further.
The greatest surprise of the past couple of weeks was the discovery of the response with file option in Google Forms. I understand that has been around for a bit now, but sometimes you miss things. Obviously, I missed this one! Forms give you several different types of questions to choose from, like long text, multiple choice, and dropdown menu. Forms now give an option of inserting a file for a response! You can upload images, Google Drive files, audio, video, and pdf files. When the form is submitted, it creates a Drive link to the file in the response sheet, while also creating a new folder in your Drive that is named after the question. There is one kicker: the form can only be shared with others within your domain to use this option. I discovered this tool by accident when our student council advisor was looking for a way to have students send proof that they had attended a school event when she was not there to verify. Her students are going to complete the form and upload a picture of themselves at the event (ex. basketball game).
Some of the other tools that I have discovered in the past few days include Sock Puppets and Chatterpix, two iOS apps. Sock Puppets is a digital storytelling app that allows users to create sock puppet shows and record their voice to tell a story. Chatterpix takes a picture, allows you to draw a line over the mouth of the character in the image, record your voice, and make the picture talk. My 5-year-old daughter and I had a lot of fun with both of the apps! I also discovered Soundtrap, a web-based music and podcasting service that is similar to Apple's Garage Band. It is compatible across all devices and the free version is very robust. It also has a collaboration piece where users can video conference on the site to create songs together! The paid version allows unlimited songs and more choices in instruments and whatnot, but there are tons of options in the free version as well.
This weekend, I am attending and presenting at the Las Vegas Google Summit. I will be providing a post on some of the great things that I learn there.
Until next time...