If you have multiple people contributing to a shared Google Sheet, it can be difficult to keep track of all the changes being made. However, Google Sheets has some really useful features that can tell you when something has been changed and help you pinpoint exactly what was changed and by whom.
Tag: Google Sheets
Google Forms are an awesome tool for gathering information from groups of people. One issue with Google Forms can be the way that users enter information – a slight difference in punctuation or spelling will mean that your ability to sort and filter the results in Google Sheets can be impacted. This blog will show you how to use a ‘Pre-filled link’ to stop this.
Many of us are now working with a G Suite account as our primary source of a digital word processing tool. Some of us are using it as our secondary source – but whichever way we are doing it, there are times when we just may want to access it offline. Here’s a way to do it with just a few minutes of forward planning.
More and more teachers and students are using G Suite to redefine the learning journey. Teachers are using technology to increase student agency by supporting students to reflect on their learning and think critically and creatively. By showing students how to use the insert > camera image tool in G Suite students will be well placed to do this
Have you been frustrated by your Google Docs, Sheets or Slides having the wrong measurement, date, currency or language settings for your country? If so, you’ll love this simple fix! In this blog post, I’ll explain how changing the language settings in your Google account (via Google Drive) will solve this problem for good.
In Google Classroom you have the ability to give feedback, manage and grade student work all in one place. Teachers are able to give students a number grade and the total grade can be customised to your marking system. There is also the ability to copy all grades into a Google Sheet, allowing teachers to work with student data in powerful ways.
I recently learnt a nifty trick in Google Sheets that will force a cell to display a pop-up date picker box when you double click on it. This is a great alternative to typing in dates manually! The secret is to use the Data validation feature to limit the cell data to dates only.
Photos are a great way to capture evidence of the activities and the learning that happen within a classroom. Sharing those photos can sometimes be frustrating though- but not with the Photo Gallery by Awesome Table add-on for Google Sheets. Read on to see how easy it can be to embed a folder of folders into your Google Site with this awesome tool.