Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:12 minutes

Grades:4-5

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.

Subjects:

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 

General

Mathematics > Geometry > General

General

Mathematics > Measurement > General

General

Mathematics > Geometry > Formulas > General

Geometric Relationships

Mathematics > Geometry > Geometric Relationships

Internet

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

Listening / Pay Attention

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

Mathematics 

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

Measure/Calculate

Mathematics > Geometry > Area > Measure/Calculate

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Rectangle/Parallelogram

Mathematics > Geometry > Area > Rectangle/Parallelogram

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Symbols

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