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.

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


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:
    1. Favourite video game system

      Grade 3 ‎‎‎‎‎‎‎[Math]‎‎‎‎‎‎‎ A1: My Fave...

    2. Favourite pet
    3. Favourite food
    4. Favourite sport
    Next, the students could generate a survey question to ask fellow classmates. For example:

    What is your favourite video game system?
    1. Wii/WiiU
    2. PS3/4
    3. Nintendo DS
    4. 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.

    Science 6 ‎‎[Sky Science]‎‎ A2: Sundials and Length of Shadows

    Students use their data work sheets during this discussion:
    1. What did you observe? What did the shadows do?
    2. When was the shadow the longest? Where was the Sun?
    3. When was the shadow the shortest? Where was the Sun?
    4. Why do you think the shadows change length? How can you explain what you are observing?
    5. How could you use a shadow to tell the time of day?
    6. 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
    1. CLICK HERE to open the Build a Zoo Google Sheet Template
    Math: Fractions, Ratio, Percent
    Dr. Hermann VonEgghead's clinic

    Math: Fractions, Ratio and Percent Final Assessment [ DOC ]


    Math: Fractions, Ratio and Percent Final Assessment [ FORM ]