Tag: Google Sheets

How to Track Changes in Google Sheets

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.

Pre-filled links in Google Forms – make sorting and filtering a breeze!

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.

How to make a single Google Doc available offline

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.

Tips for inserting pictures into Google Docs and Slides

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

How to Fix Language & Country settings in Google Docs, Sheets & Slides

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.

How to Convert Google Classroom Grades into Letter Grades.

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.

How to Create Line of Best Fit & Scatterplots in Google Sheets

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.

How to Display Date Picker in a Google Sheets Cell

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.

Photo Gallery by Awesome Table

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.

Four ways to access Google Sheet Templates

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.

What Industry Are You In?