Tech Tip Tuesday
8 September 2015
Teacher Battle of the Books Teams
rowCall Add-On for Google Sheets
If you ever have students complete a Google form--and especially if you have multiple classes complete the same Google Form, this add-on is for you. Typically, all of your classes are thrown in the same spreadsheet together. Even if you sort them by class period, it's still a lot of information on one sheet.
rowCall sorts rows from your main sheet by the column you select and creates individual sheets for every unique cell in that column. First, make sure one of your questions is "Class Period" on your Google Form. Then, after using this add-on, each class period will be separated onto a separate sheet/tab. Check out the video below to see how it works, and then add rowCall to Google Sheets.
Before: All 200+ students were on one page of your spreadsheet.
After: Each class is on it's own tab on the spreadsheet.
Learn how rowCall works.
Bonus Article
Shout-Outs
Photo Credits:
- creative commons licensed (BY-NC-ND) flickr photo by venspired:http://flickr.com/photos/venosdale/6774128801
Tricia LaRue, Teacher Librarian
- Tech Tips and Library News
- The Library's Delicious Page (filter by tags)
- MRHS Databases
- MRHS Database and eBook Login Info
- Library Catalog
- MLA Cornell Notes
- Suggest a Book
Email: patricia.larue@adams12.org
Website: http://bit.ly/MRH_Library
Phone: 720-972-6345
Facebook: facebook.com/MRHSLibrary
Twitter: @MRH_Library