Creating an Online Spreadsheet
Tech Integration Classroom Project
Subject: Health/Life Skills
Grade Range: 9 - 12
Application: Google Sheets
The process for creating the example project using Google™ Spreadsheets is described below. The Completed Project Movie shows what the finished product might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct the example spreadsheet using the data provided in the downloadable resource packet. This project can be easily modified or adapted for other subject areas or other grade/skill levels. For a complete project description, including goals, objectives, and materials, see the Project Overview.
What's in a Project?
Each project provides:
- Project activity guide
- Copy of the completed project
- All the resources needed to recreate the example project
- Step-by-step tutorial movies that walk students through the project
- Assessment rubric
Information for Teachers
This project can be easily modified or adapted for other subject areas or other skill levels.
All example files, an assessment rubric, and information about adapting and extending the example project are included in the resource materials available for download with this project.
Creating Your Own Project
This project uses an Internet-based spreadsheet application that allows for collaboration between groups of learners who could be located anywhere in the world. Learners may work individually or in groups to record their data. The example project involves recording rainfall data for six cities around the world. Collaborators are entering monthly totals into the spreadsheet online. They will set up formulas in the spreadsheet to figure totals and averages, as well as explore different ways to share and report on their collective data.