Lesson plan

Lesson 7: Spreadsheet Computations

teaches Minnesota State Standards
teaches Pennsylvania State Standards CC.2.4.HS.B.1.

Lesson 7: Spreadsheet Computations

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. 

Lesson overview

  • 7.1 Warm-up: Dust Off Those Cobwebs (5 minutes)
  • 7.2 Optional Activity: A Spreadsheet Is a Calculator (10 minutes)
  • 7.3 Optional Activity: Use the Contents of a Cell in a Calculation (5 minutes)
  • 7.4 Optional Activity: Solve Some Problems (15 minutes)
  • 7.5 Cool-down: Good Old Raisins and Peanuts (5 minutes) 

Learning goals:

  • Use a spreadsheet to calculate values in word problems.

Learning goals (student facing):

  • Let's use spreadsheets as calculators.

Learning targets (student facing):

  • I can use a spreadsheet as a calculator to find solutions to word problems.

Required materials:

  • Spreadsheet technology

Required preparation:

  • Acquire internet-enabled devices. It is ideal if each student has their own device.






IM Algebra 1, Geometry, Algebra 2 is copyright 2019 Illustrative Mathematics and licensed under the Creative Commons Attribution 4.0 International License (CC BY 4.0).

The Illustrative Mathematics name and logo are not subject to the Creative Commons license and may not be used without the prior and express written consent of Illustrative Mathematics.