Teacher-Facing Resources


Estimated Time:10 minutes


Score Type:Automatically Graded

Work completed by a student will be automatically graded and the grade will be sent to the Learning Management System (LMS) gradebook

Available Languages: English, Spanish

Vocabulary: copy and paste, data, formula, function, spreadsheet, table

Primary Objectives:

  • Student gains additional experience with formulas in spreadsheets.
  • Student learns that copying and pasting formulas in a spreadsheet is relative and not exact.
  • Student understands the advantages of the relative copy and paste in spreadsheets.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student identifies some traits of different types of lizards.
  • Student practices adding numbers and dollar amounts.
  • Student practices finding the average of a group of numbers.
  • Student practices using formulas to solve problems.
  • Student practices using tables to organize information.



Mathematics > Number Operations > Mean > Arithmetic

Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

Data Collection for Decision Making

Library Media > Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Technology Education > Digital Literacy > Student Use > Data Collection for Decision Making 

Data Mining

Library Media > Information Literacy > Reference and Research > Research Skills > Data Mining

Data Mining

Technology Education > Digital Literacy > Reference and Research > Research Skills > Data Mining


Mathematics > Number Operations > General


Mathematics > Algebra > Formulas > General

Info/Data Collection

Mathematics > Process Standards > Problem Solving > Info/Data Collection


Science > Concepts and Processes > Tools / Instruments > Software Tools > Internet

Listening / Pay Attention

Language Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention


Technology Education > Information Technology > Connects to Other Disciplines > Mathematics 


Language Arts > Reading / Literature > Comprehension / Analysis > Word Study > Nonfiction

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 


Library Media > Information Technology > Software Applications > Spreadsheets


Mathematics > Number Operations > Computation/Technology > Spreadsheets


Technology Education > Information Technology > Software Applications > Spreadsheets 


Mathematics > Number Operations > Operations > Symbols

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically
Show More
  • In this lesson, students calculate the costs of feeding lizards in a zoo exhibit. Students should be familiar with using basic operators, calculating monetary amounts, and entering formulas into spreadsheets.

  • The process of cutting, copying, and pasting is the same in spreadsheet programs as in other programs. Students should be familiar with these basic tasks before taking the lesson. One notable difference is that when you paste a formula, the formula calculates data relative to its position. In other words, when you paste a formula, the formula stays the same but the cell names in the formula change to calculate a relative set of data.

  • The syntax used for formulas and functions from one software title to another may differ. For example, a cell range in some spreadsheet software is specified with a colon between the two cells like this: A1:D8, while in others it is specified by two periods like this: A1..D8. In most cases, the differences are slight and syntax is quite similar from one software title to another. Before applying skills with an activity, be sure to review the syntax used in the software title available to your students and make any clarifications necessary with your students.

  • This lesson also involves using a formula to find an average. Students should be familiar with the mathematical process of averaging a set of numbers.

  • As a class, create a list of common breakfast and lunch items and then assign values to each item. Post the list somewhere in the classroom or provide a handout so the values are available to students. Then have students calculate the values for their breakfasts and lunches over the course of a week. At the end of the week, each student should create a table that shows each day's breakfast value, lunch value, and daily total as well as weekly totals for each meal. Then have students find the average cost of breakfast, average cost of lunch, and average daily cost for both meals. After students complete their tables, discuss with the class how they created their tables and compare students' results.

See how our curriculum can help you meet your instructional goals

Check it out