Business Applications

Not a customer? Learn More


Estimated Time:12 minutes

Score Type:Auto Score

This lesson automatically provides a score to your 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.


Critical Thinking and Decision Making Process 

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

Data Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Digital Literacy > Student Use > Data Collection for Decision Making 

Data Mining

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

Data Mining

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


Mathematics > Geometry > Formulas > General


Mathematics > Geometry > General


Mathematics > Measurement > General

Geometric Relationships

Mathematics > Geometry > Geometric Relationships

Listening / Pay Attention

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


Information Technology > Connects to Other Disciplines > Mathematics 


Mathematics > Geometry > Area > Measure/Calculate

Problem Solving 

Information Technology > Student Use > Problem Solving 


Mathematics > Geometry > Area > Rectangle/Parallelogram


Mathematics > Number Operations > Computation/Technology > Spreadsheets


Information Technology > Software Applications > Spreadsheets


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

Teacher Notes:

  • 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.

Extension Ideas:

  • 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).


S.5.b Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
1B-DA-06 Organize and present collected data visually to highlight relationships and support a claim. (P7.1)
1B-DA-07 Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea. (P7.1)
ELA-Literacy.SL.4.2 Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.SL.5.2 Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
Math.Practice.MP5 Use appropriate tools strategically.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards