We are moving our free videos to YouTube and retiring student functionality on 7/15. Learn more

Lesson plan

Lesson 8: Spreadsheet Shortcuts

Lesson 8: Spreadsheet Shortcuts

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 last lesson about using spreadsheets, students learn to include cell references in formulas by clicking on a cell instead of typing its address and also how to continue patterns by dragging to generate a sequence of numbers based on a formula.

To engage in this lesson, students must have access to internet-enabled devices. Ideally, they should navigate to the digital version of the materials with the embedded applets. A direct link to each applet is also provided.

Lesson overview

  • 8.1 Warm-up: Tables of Equivalent Ratios (10 minutes)
  • 8.2 Optional Activity: The Birthday Trick (15 minutes)
    • Digital applet in this activity
    • Includes "Are you Ready for More?" extension problem
  • 8.3 Optional Activity: Using Spreadsheet Patterns (10 minutes)
    • Digital applet in this activity
  • 8.4 Cool-down: Doubling in a Spreadsheet (5 minutes) 

Learning goals:

  • Use spreadsheet shortcuts such as clicking on cells or filling cells with a pattern.

Learning goals (student facing):

  • Let's explore recursive formulas in spreadsheets.

Learning targets (student facing):

  • I can use shortcuts to fill in cells on a spreadsheet.

Required materials:

  • Internet-enabled device

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.