Google Docs: write, edit, and share ideas together in real-time.

🔍 What does it do?

Google Docs is an online word processor that allows pupils to create reports, essays, and stories. Its most powerful feature is “Live Collaboration” – multiple pupils can work on the same document simultaneously, seeing each other’s changes as they happen. It removes the need for “saving” and “emailing versions,” as everything is stored live in the cloud via Glow.

🎓 Why is it useful?

• Instant Collaboration: Perfect for group writing projects. Pupils can be in different parts of the classroom (or in other locations) and contribute to the same piece of work at once.

• Voice Typing (Accessibility): Pupils who struggle with typing can use the “Dictation” feature (via the iPad keyboard) to turn their speech into text directly on the page.

• Version History: (Accessible via browser version) Teachers can see exactly who contributed what to a group project and “roll back” the document if something is accidentally deleted.

• Feedback Loop: Teachers and peers can highlight text and leave Comments, allowing for a digital dialogue about the work without changing the original text.

⚙️ How does it work?

1. Launch: Open the Google Docs app on iPad or login to Google Docs on your internet browser.

2. Sign In: Use your Glow email (e.g., gw15smithjohn@fa.glow.scot) and use your normal Glow password.

3. Create: Tap the ‘+’ icon to start a new document or pick from a template like “Report” or “Letter.”

4. Share: Use the Share button to add collaborators or send a link to the Google Doc.

5. Classroom: If using Docs with Google Classroom you can directly create an assignment that is based in Docs by going to ‘classwork’ > ‘+create’ >  ‘assignment’ > ‘+create’ and selecting Docs. From there you can choose whether learners can view the Doc, edit it as one group or make a copy for each student. If you want to add a scaffolded Doc with information or instructions already in it, it is the same process but instead of clicking ‘+create’ as the last step, click ‘upload’ and choose the Doc you have already made to support learners.  

🚀 Beyond the Basics

• Collaborative Storytelling: Start a “Pass the Story” activity. One pupil writes the introduction, a second writes the problem, and a third writes the resolution—all in the same Doc at the same time.

• Structured Reports: Use the ‘Insert Table’ feature to help pupils organize their research into categories like “Climate,” “Culture,” and “History.”

• Smart Chips: Type ‘@’ to bring up a menu that lets you quickly insert smart chips, files or building blocks like dates, drop downs, links to other Google files. This helps pupils keep their resources organised in one place.

• Suggested Edits: Teach pupils how to use “Suggesting” mode (under the ‘three dots’). This allows them to propose changes to a partner’s work that the original author can choose to ‘Accept’ or ‘Reject.’

• Meeting Minutes: Teachers can use the built-in “Meeting Notes” template which automatically pulls in the date and participants, making it easy to share notes with a department instantly via Glow.

💡 Top Tips for Google Docs

• Reading Mode: If a document is long, pupils can change the ‘Print Layout’ toggle in the menu to see how it will look on paper, or keep it in mobile view for easier reading on the iPad.

• The ‘Explore’ Tool: While the iPad app is streamlined, opening Docs in Safari allows you to use the “Explore” feature to research topics and find images without ever leaving the document.

• Offline Working: Tap the ‘three dots’ on a file in the main list and select ‘Available offline’. This is vital for pupils who may not have reliable Wi-Fi at home but want to finish their homework.

🔗 Teacher Quick Links

Google Docs Training and Help

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?

1. Launch: Open the Google Sheets app on your iPad or login to Google Sheets on your internet browser.

2. Sign In: Tap ‘Sign In’ and enter your Glow email (e.g., gw15smithjohn@fa.glow.scot) and use your normal Glow password.

3. Create: Tap the ‘+’ icon to start a new spreadsheet or choose a template like a “To-do list” or “Budget.”

4. 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 =).

5. Share: Use the Share button to add collaborators or send a link to the sheet.

6. 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.

🔗 Teacher Quick Links

Google Sheets Training and Help