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.
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.
Collecting data and finding the strength of the relationship between the variables, a method used in statistics. Making a scatterplot and finding the line of best fit or trendline in Excel was a piece of cake. I could never do it in Google Sheets until I found a solution! It is easy to build a meaningful scatterplot, put in a trendline and find the correlation coefficient within a couple of clicks.
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.
Are you a Google Sheets novice? Does just the sound of the word ‘sheets’ send shivers down your spine? That used to be me. Then I discovered ready made templates that gave me the confidence to dive into the world of cells and formulas. Read on to find out about four easy ways to access Google Sheets templates.
In this short video, Samantha will show you how to embed Google Drawings, Google Slides and Google Sheets in Google Docs.
We know giving effective feedback to students is important. Here’s a simple way to create your own personalised feedback that is fun and actually encourages students to look back at work they have submitted to you. Combine digital stickers and Google Keep for a quick way to comment on student’s work.
