If you are looking for a way to expose your students to a project chalk full of cool Math functions, you have come to the right place. In this comprehensive project, students enter in fictional data for some students relating to how they spend their time when not in school. Time is broken into the following categories; homework, reading, exercise, watching TV and playing video games. The data is on a per-week basis.
A summary sheet, which is separate from the time tracker data sheet, provides summary information at a glance. The goal is to mine the activity tracker sheet which contains the data for some interesting nuggets such as a Count of the number of boys and girls, and the average of time spent on "healthy habits", and many tidbits. This project allows for differentiated learning, as suggested extensions are provided for those fast finishers or students who are looking for a challenge.
Students learn to quickly use alternating rows of color to give their data tables organization and a punch of color. On the main sheet, students make use of a drop-down list for gender. This drop-down list exposes the students to the concept of data validation, the idea of minimizing typos and human error when possible.
The instructions come in the form of an interactive .pdf file, which allows students to navigate throughout the document by clicking buttons, click on a linked up Table of Contents, and toggle between full screen mode and normal viewing mode. Students enjoy this measure of control over how they get around the instructions, and they are quickly and easily able to backtrack and review information using the Table of Contents.
Google Sheets is basically like an online version of Excel. It is a great alternative to Excel in that it allows for student collaboration and for students to access their work wherever they have an internet connection!
Please feel free to contact me with questions or comments regarding this assignment! I hope that you find it useful and I look forward to hearing from you.
Included in this package:
- a .pdf teacher instruction file with plenty of screenshots and clear instructions.
- a text file which includes links to the answer files.
- Take the time to do this activity yourself prior to presenting to the students so you are familiar with the steps.
Others you might like:
Google Sheets Bundle - 10 Great Lessons for Beginners
Google Sheets - School Grades Math Lesson
Google Docs Lesson Bundle - 4 Essential lessons for beginners
Excel 2010 Beginner Lesson Bundle