Zach Ripley - Sheets add-ons (50), teacher question: middle school PE with data. Functions and formulas … import range function: master spreadsheet, one at a time: open student spreadsheet (only do once), copy key from URL, paste URL into import range function, master spreadsheet: import data from student sheet, real-time update (not copy paste) as students update.
Sara Reed (Aledo, TX) -- Google Classroom: see time stamp when a student turns in an assignment or mark it as done? If not, how do you handle students that say they did it and it doesn’t reflect in Classroom? (Click on “done” from assignment>then click on the student’s name from the roster on the left>then click “see history”)
Beth Cohen (Pennsylvania) -- HI Matt and Kasey! I love all the tips, tricks, and resources you share! Every year our Freshmen complete a unit on Academic Integrity. We have been using Moodle, which includes a self-grading quiz that lets students know whether they have achieved the minimum score and prompts them to review the resources and retake the quiz if they didn't pass. We will have GAFE instead of Moodle next year, so I want to reproduce the quiz in Forms, but I can't figure out how to set a minimum passing grade and notify the student whether he/she passed at the end. I could use branching and direct students back to the resources after every wrong response so that ultimately everyone ends up with a perfect score, but I'm hoping for a final pass or fail submission response. Hope you have some ideas! Thanks, Beth
Ben Whitaker (Oswaldtwistle, Lancashire, UK) Sheets: In Excel, can lock down certain tabs so they can’t be edited in collab spreadsheet. Is there a way in Sheets? Add-on? Keep up great work!