Google News and Updates

• Add custom links to the navigation bar in the new Google Sites
• New in Google Slides: linking in Docs, guides and rulers, and improved commenting
• Checkboxes in Google Sheets
• Get more control over chart data labels in Google Sheets

Featured Content Stay composed: here’s a quick rundown of the new Gmail With new security and intelligent features, the new Gmail means business

• Improved security
  • Confidential mode
  • 2-step verification to open
  • Block forwarding and printing
  • can also make messages expire after a certain time
• Busy
• New tasks
  • Improved functionality and you can SEE it!
• Calendar and Keep integration
• Hover
• Similar to Inbox by Gmail features
• How to get it
  • Don’t feel left out b/c some of these features aren’t even available yet
• Cannot control size of sidebar
• Display density
• Settings looks mostly the same
• Expect add-ons to continue to grow
• Fancy splash page
• Default view: icons with G Suite files (under Settings > Display density)
• Snooze items until later (“someday”)
• AI suggested responses (like Inbox)
• Warnings for risky emails

Google Teacher Tribe Mailbag

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!

3 Ways to Protect You Google Sheets Data

On The Blogs

• Matt - 10 ways Google tools can make the end of the year rock
• Kasey - When the Lecture Ends, the Learning Begins from @Mo_Physics (Mike Mohammad)

  [shortcode-variables slug="signature"]

Hosted on Acast. See acast.com/privacy for more information.