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.
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.
Send a request and include the steps you already tried.