Lesson 7
Spreadsheet Computations
Lesson Narrative
This lesson is optional. The purpose of this sequence of three lessons is to introduce spreadsheet functionality to students who are unfamiliar with it. It is assumed that students know nothing about spreadsheets. If students have already learned to use spreadsheets as computation tools previously, this sequence of lessons can be safely skipped.
In this lesson, students learn to use a spreadsheet to perform basic operations with numbers. They also begin to notice the power of spreadsheets in such calculations by using the dynamic nature of the autocalculating features. In future lessons, students will have the opportunity to access spreadsheets to aid in calculating values such as mean, median, and standard deviation.
Learning Goals
Teacher Facing
- Use a spreadsheet to calculate values in word problems.
Student Facing
Let's use spreadsheets as calculators.
Required Materials
Required Preparation
Acquire internet-enabled devices. It is ideal if each student has their own device.
Learning Targets
Student Facing
- I can use a spreadsheet as a calculator to find solutions to word problems.
Print Formatted Materials
Teachers with a valid work email address can click here to register or sign in for free access to Cool Down, Teacher Guide, and PowerPoint materials.
| Student Task Statements | docx | |
| Cumulative Practice Problem Set | docx | |
| Cool Down | Log In | |
| Teacher Guide | Log In | |
| Teacher Presentation Materials | docx |