Google Sheets

Practical classroom ideas

Google Spreadsheets can be used to create your yearplan, keep track of student's homework, and can be used for student assignments. Again, collaboration with a colleague is simple - work together on a spreadsheet in real-time.

**is a free app that you can use to mark Google Form based quizzes and tests**

mark*N*mail

mark*N*mail

Data Collection

*Grade 3 Math*

**General Outcome:**

- Collect, display and analyze data to solve problems.

**Specific Outcomes:**

- Collect first-hand data and organize it using:
- tally marks
- line plots
- charts
- lists

*This exercise would be a great introduction into the objective: Construct, label and interpret bar graphs to solve problems.*

**Prep:**

Create a template Spreadsheet before hand that the students can use and email it to your students or provide them with the link somehow.

When they log into their Google accounts, they will have a link to the template in their email inbox.

**Procedure:**

Have students generate a list of potential survey ideas for the data they want to collect. For example:

- Favourite video game system
- Favourite pet
- Favourite food
- Favourite sport

**What is your favourite video game system?**

- Wii/WiiU
- PS3/4
- Nintendo DS
- Xbox 360/ONE

Students can collect the results using a tall sheet then transfer the results of their survey into a Google Spreadsheet to be shared with you for marking. The spreadsheet could be initially shared as a ready to go template, or for advanced users, you could show them how to make the spreadsheet and chart.

Data Collection

*Grade 6 Science - Sky Science: Plotting the Sun*

### Objectives:

- SLE 3: I can recognize that the APPARENT movement of objects in the sky is regular and predictable and related to Earth's rotation.
- SLE 5: I can construct a device for plotting the apparent movement of the Sun over the course of the day.

Procedure:

Place a marker in the ground (pencil, rod, etc). Make estimates and collect data in the form of measurements.

**Students use their data work sheets during this discussion:**

- What did you observe? What did the shadows do?
- When was the shadow the longest? Where was the Sun?
- When was the shadow the shortest? Where was the Sun?
- Why do you think the shadows change length? How can you explain what you are observing?
- How could you use a shadow to tell the time of day?
- How accurate were your predictions? What could you do to make them more accurate?

Math: Fractions, Ratio, Percent

*Design a Zoo*

**METHOD 1:**share materials via**Google Classroom**as an assignment**METHOD 2:**share materials with students via email or website links

Math: Fractions, Ratio, Percent

*Dr. Hermann VonEgghead's clinic*

**METHOD 1:**share materials via**Google Classroom**as an assignment**METHOD 2:**share materials with students via email or website links- PART 1: Final Assessment Google Doc - solve problems first
**PART 2:**Create a spreadsheet to complete the work from PART 1- PART 3: Final Assessment Form - complete the self-reflection form