Google Sheets in Glow is a digital spreadsheet, Organize data, perform calculations, and visualise results in real-time.
🔍 What does it do?
Google Sheets is a cloud-based spreadsheet tool. It allows pupils to collect data, use formulas to perform calculations (from simple addition to complex statistics), and turn those numbers into clear, colorful charts. Because it is part of Glow, pupils can work together on the same sheet at the same time, seeing each other’s edits instantly.
🎓 Why is it useful?
-
Single Sign-On: Pupils log in with their Glow credentials, automatically saving all work to their secure Google Drive.
-
Real-Time Collaboration: Entire groups can contribute to one data set. For example, a whole class can input their height or eye color into one shared sheet to create a “class profile.”
-
Mathematical Accuracy: It teaches pupils the logic of formulas. Instead of just doing a sum, they learn how to “tell the computer” to do the work, a vital STEM skill.
-
Automatic Saving: There is no “Save” button. Every change is tracked, and pupils can use Version History (on the web version) to go back if they make a mistake.
⚙️ How does it work?
-
Launch: Open the Google Sheets app on your iPad or login to Google Sheets on your internet browser.
-
Sign In: Tap ‘Sign In’ and enter your Glow email (e.g., gw15smithjohn@fa.glow.scot) and use your normal Glow password.
-
Create: Tap the ‘+’ icon to start a new spreadsheet or choose a template like a “To-do list” or “Budget.”
-
Enter Data: Tap a cell and use the keyboard to type numbers or text. Tap the ‘fx’ bar at the bottom to enter a formula (starting with =).
-
Share: Use the Share button to add collaborators or send a link to the sheet.
- Classroom: If using Sheets with Google Classroom you can directly create an assignment that is based in Sheets by going to ‘classwork’ > ‘+create’ > ‘assignment’ > ‘+create’ and selecting Sheets. From there you can choose whether learners can view the Sheet, edit it as one group or make a copy for each student. If you want to add a scaffolded Sheet with data or instructions already in it, it is the same process but instead of clicking ‘+create’ as the last step, click ‘upload’ and choose the Sheet you have already made to support learners.
🚀 Beyond the Basics
-
Budgeting Challenges: Give pupils a “Virtual £100.” They use a Sheet to list items they want to buy, using the =SUM() formula to keep track of their total and ensure they don’t go over budget.
-
Experiment Results: When doing a “Dissolving” or “Growth” experiment, pupils record their daily measurements in a Sheet. They can then highlight the data and tap + > Chart to instantly create a line graph showing the change over time.
-
Spelling Checkers: Pupils can build their own self-marking spelling tests. Using simple “IF” statements, they can program a cell to turn green and say “Correct!” when the word is spelled right.
-
Demographic Charts: Research populations or climate data. Pupils can use Conditional Formatting to automatically colour cells (e.g., Red for hot temperatures, Blue for cold) to spot patterns in the data visually.
-
Checklists & Visual Organisers: Teachers can create a “Digital Planner” for pupils. Using Checkboxes (found in the ‘Insert’ menu), pupils can tick off their tasks as they complete them, giving them a sense of progress and structure.
💡 Top Tips for the Google Sheets
-
App vs. Browser: The iPad App is best for quick data entry and basic charts. For more complex features (like advanced conditional formatting or Pivot Tables), open Sheets in the Safari browser and “Request Desktop Website.”
-
Offline Access: Pupils can tap the ‘three dots’ on a file and toggle ‘Available Offline’ if using the Sheet outside of school wifi range (when outdoor learning for example). They can keep working, and it will sync back to Glow once they are back online.
-
Clean Data: Use the ‘Sort and Filter’ tools (under the ‘three dots’ menu) to help pupils organise messy data sets without needing to re-type everything.
