Summary of "105 - Technology and Data Analysis - Session 2 - Lesson 3"

High-level summary

The video is a teacher-led walkthrough showing how Google tools (Slides, Sheets, Forms, Docs, Keep) are used to plan lessons, deliver content, collect student data, communicate with parents, and stay organized. The presenter shares practical classroom applications, examples, and specific workflows/shortcuts that save time and support assessment and collaboration.

The presenter notes the district later adopted iPads and Apple apps (Keynote, Notes, Pages, Sheets). Those are similar in some ways, but the focus here is on Google tools because they were initially easiest and remain heavily used.

Detailed breakdown by product

Google Slides — primary classroom content and delivery tool

Uses

Create online presentations for lessons, digital anchor charts, planning calendars, worksheets, and multimedia slides (text, images, audio, video).
Add hyperlinks (to external resources or specific slides) to navigate directly to a day/unit or resource.
Collaborate and share with teachers and students (Google or non-Google accounts).

Practical examples & workflows

Weekly lesson deck with a daily index: each date links to that day’s slide so the teacher can present or share as an assignment.
Trick-word/fluency slides: sight/trick words on separate slides; students screen-record while slides auto-advance for a timed fluency check.
Digital anchor charts: create visually appealing charts, display on the smartboard, let students add responses or take screenshots to archive.
Embed curriculum worksheets as hyperlinks inside Slides to open and annotate during instruction.

Step-by-step method — Trick-word fluency check

Create a slide deck containing the trick words (one word per slide or frame).
Share the deck with students (for example, via Canvas).
Have students set up a screen-recording on their device and set auto-advance to 3 seconds per slide.
Student screen-records themselves reading aloud as slides advance; the recording captures audio.
Teacher reviews recordings: reading within the 3-second window meets the fluency benchmark; missed timing flags need for intervention.

Google Sheets — data collection, analysis, checklists, and digital plan book

Uses

Store assessment data, analyze student performance and standards mastery, and identify patterns.
Create checklists and to-do lists for teacher tasks and quick student checks.
Apply conditional formatting to visualize progress.
Maintain a digital lesson-planning calendar/plan book with times/blocks and hyperlinks to resources for yearly reuse.

Practical examples & workflows

Teacher task checklist (what’s done/needs copying).
Assessment spreadsheets to track standards needing practice; conditional formatting highlights trends.
Student reading checklists duplicated periodically to track progress.
Digital plan book with lesson times, unit names, and links to resources/PDFs for easy access and printing.

Google Forms — surveys, assessments, sign-ups, and data collection

Uses

Create surveys, reflection forms, formative assessments/quizzes, parent sign-ups, and communication logs.
Automatically aggregate responses into a linked spreadsheet and produce charts/graphs.
Include images for visual questions (useful in primary grades).
Build timed quizzes with immediate feedback for students and parents.

Practical examples & workflows

Parent communication log: submit interactions during phone calls and later print responses for records.
Party sign-ups that distribute volunteer duties.
Student quick facts quizzes shared on iPads; teacher sees a summary of most/least correct items.
Icebreaker forms projected on the smartboard to learn student preferences.
End-of-year anonymous parent reflection form for feedback.

Google Docs — word processing, resource indexing, collaborative notes

Uses

Create letters, flyers, essays, reworded assignments, PLC notes, and resource indexes.
Use hyperlinks to connect to Slides, Sheets, or PDFs.
Collaborate in real time with colleagues and share documents with administrators or team members.

Practical examples

Central document linking all assignments/resources for a curriculum so coworkers can access materials quickly.
Typed PLC meeting notes shared with school leadership.
Rewriting poorly worded curriculum pages into clearer Google Docs assignments.

Google Keep — personal/task organization and reminders

Uses

Quick notes, checklists, reminders, voice notes, and location-based reminders; syncs across devices (phone, iPad, desktop).
Simple visual tags/headers (the presenter used Canva to create headers) to separate work/home/burnout-prevention tasks.
Collaborative checklists shared with co-teachers to track joint tasks.

Practical examples

Weekly goals checklist with reminders for recurring meetings (e.g., PLC every Thursday).
Capture meeting notes via voice-to-text and set follow-up reminders.

Other tools & classroom tech workflow elements

Canvas: share Slides as assignments/homework.
Smartboard: display Slides and Forms for whole-group responses.
Clicker/laser pointer: remote navigation of Slides and directing student attention.
Screen recording on student devices: capture timed fluency assessments or student responses.
Canva: design visual headers for Google Keep notes.
Apple iPads & Keynote/Notes/Pages: district devices; similar functionality to Google tools for many workflows.

Key lessons and tips

Use hyperlinks liberally in Slides and Docs to centralize access to resources and speed navigation.
Automate routine assessment and data collection with Forms and Sheets to save grading time and get immediate feedback.
Use screen recording and auto-advance timing as a scalable way to assess oral fluency without one-on-one testing.
Maintain shared planning calendars and digital plan books so teams stay coordinated and can easily adjust schedules.
Keep a personal task/reminder system (Google Keep) to protect work-life boundaries and prevent burnout.
Digital anchor charts and smartboard interaction let teachers capture and archive student responses quickly.

Potential limitations / context

Some workflows depend on student device capabilities (screen recording, Canvas access).
The presenter used Google products before district adoption of iPads/Apple devices; equivalent Apple workflows may be possible but could differ in setup.
Subtitles were auto-generated and may contain transcription errors, though core workflows and examples are clearly described.

Speakers / sources featured

Unnamed presenter (teacher/trainer) — main speaker explaining classroom uses of Google products.
Background music (non-speaking audio).
Video/session title: “105 - Technology and Data Analysis - Session 2 - Lesson 3” (YouTube; subtitles auto-generated).