Teacher-Facing Resources


Estimated Time:12 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: cell address, data, formula, spreadsheet, summation function, table

Primary Objectives:

  • Student gains experience entering data into a spreadsheet.
  • Student gains experience using numerical formulas in a spreadsheet.
  • Student learns the advantages of using cell names in formulas rather than numbers.
  • Student learns to enter cell names in formulas to perform mathematical calculations.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student calculates the area in square feet.
  • Student identifies some traits of different types of bears.
  • Student practices multiplying, dividing, and adding.
  • Student practices using formulas to solve problems.
  • Student practices using tables to organize information.


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 


Mathematics > Geometry > General


Mathematics > Measurement > General


Mathematics > Geometry > Formulas > General

Geometric Relationships

Mathematics > Geometry > Geometric Relationships


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 


Mathematics > Geometry > Area > Measure/Calculate

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 


Mathematics > Geometry > Area > Rectangle/Parallelogram


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 spreadsheet programs, multiplication and division symbols are shown as an asterisk (*) and forward slash (/) instead of the standard multiplication and division symbols that students might be used to seeing. You might want to ensure that students know what an asterisk and forward slash look like. You also might want to make sure that students know where to find the asterisk and forward slash symbols on a keyboard.

  • In this lesson, students find the area of enclosures. Students use the area information to find out how much space different types of bears need for a bear exhibit at a zoo. You might want to remind students that the formula used to calculate an area is area=height*width.

  • The data used in this lesson involves bears. Different types of bears require different areas of space for optimal living conditions. The required area for each type of bear is generally based on the bears' full-grown size.

  • Use sidewalk chalk to draw different sized squares and label or name each square. Divide the class into teams and have students work together to measure and find the area of each square. Students should record their answers. Students should also find out how many students can stand in each square and record those answers as well. Return to the classroom and have each team create a table using the data they recorded. Each table should include a column for each square's name, area, and number of students. You might also have students write the formula for calculating an area below the table in the same way they would enter it into a spreadsheet program (for example, =8*10).

See how our curriculum can help you meet your instructional goals

Check it out