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 pdf docx
Cumulative Practice Problem Set pdf docx
Cool Down Log In
Teacher Guide Log In
Teacher Presentation Materials pdf docx

Additional Resources

Google Slides Log In
PowerPoint Slides Log In