Google Sheets

Google Sheets is allows your child to create spreadsheets. Your child can use the powerful tools in Google Sheets for organising, visualising, and calculating their data.

Google Sheets Cheat Sheet

All About Google Sheets

Practical advice and common pitfalls
Keep one type of information per column and use a header row. If totals look wrong, check whether numbers were entered as text and whether filtered or hidden rows affect the calculation. Before sharing a sheet containing pupil information, restrict access and check for hidden tabs containing personal data.

Before you begin

Make a copy before changing a shared spreadsheet. Confirm whether the first row contains headings and whether numbers are stored as numbers rather than text.

Check the result and troubleshoot

When sorting, select the entire data range so names and associated values remain together. Check formula results against a small manual example and preview printing before distributing a sheet.

When to contact school IT support

If the problem remains, include the article title, device type, approximate time, exact error wording and the checks already completed. Do not include passwords, sign-in codes or sensitive pupil information.

Still need help?

Send a request and include the steps you already tried.

Submit a ticket

Rate this article

How useful was this article?
Add a correction or suggestion (optional)
Do not include passwords, pupil details, or other private information.