b'Google News and Updates
Zach Ripley - Sheets add-ons (50), teacher question: middle school PE with data. Functions and formulas \\u2026 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\\u2019t reflect in Classroom? (Click on \\u201cdone\\u201d from assignment>then click on the student\\u2019s name from the roster on the left>then click \\u201csee history\\u201d)
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\\u2019t be edited in collab spreadsheet. Is there a way in Sheets? Add-on? Keep up great work!
3 Ways to Protect You Google Sheets Data
On The BlogsHosted on Acast. See acast.com/privacy for more information.
'