Teacher-Facing Resources


Estimated Time:13 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 additional experience using the sum command.
  • Student gains experience entering data into a spreadsheet.
  • Student learns the advantages of using cell names in formulas rather than numbers.
  • Student learns the correlation between what is typed into a cell and what appears on the screen.
  • Student learns to enter formulas in cells.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student identifies some traits of different types of marsupials.
  • Student practices adding and subtracting.
  • Student practices using formulas to solve problems.
  • Student practices using tables to organize information.
  • Student recognizes different polygon shapes and calculates their perimeters.


Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

Critical Thinking and Decision Making Process 

Technology Education > Information Technology > Student Use > Critical Thinking and Decision Making Process 

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 > Formulas > General


Mathematics > Geometry > General


Mathematics > Measurement > General


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 > Perimeter > Measure/Calculate


Mathematics > Geometry > Formulas > Perimeter

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 


Mathematics > Number Operations > Computation/Technology > Spreadsheets


Mathematics > Statistics Probability > Computation/Technology > Spreadsheets


Library Media > Information Technology > Software Applications > 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
  • Formulas in spreadsheet formula bars begin with an equal sign. You might want to point out how this setup might look different than formulas students work out on paper. Emphasize that either way, the effect is the same because an equal sign simply means that the equations or amounts on each side of the equal sign are the same.

  • In this lesson, students find the perimeters of polygons. Students use the perimeter information to find out how much fencing the zoo needs in order to update the enclosures in the zoo's marsupial exhibit. You might want to reinforce with students how to find a polygon's perimeter. Students also subtract the length of one shared fence, so you might want to discuss why they would do this to find the total perimeters of two adjoining shapes.

  • The data used in this lesson involves polygons and marsupials. Marsupials are pouched animals. A couple interesting facts about marsupials are that koala babies are the size of jellybeans. Among the kangaroo types, wallabies are the smallest, wallaroos are midsized, and kangaroos are the largest.

  • To help practice finding polygon perimeters, conduct a game of Polygon Playoffs. First, divide the class into two teams. Have a representative from each team draw a polygon on the board. Then choose another representative from each team to estimate the perimeter of the other team's polygon. Have the student write the estimate inside the other team's polygon. Next have team members measure and label their own polygon's sides. Then, have a member from each team write how they would enter the formula in a spreadsheet program to calculate the polygon's perimeter (i.e. =4+6+4+6). Finally, have students calculate the perimeter. Whichever team guesses nearest to the actual perimeter measurement of the other team's polygon earns a point.

See how our curriculum can help you meet your instructional goals

Check it out