Business Applications

Not a Learning.com customer? Learn More

Type:Lesson

Estimated Time:13 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 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.

Subjects:

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 

General

Mathematics > Geometry > General

General

Mathematics > Geometry > Formulas > General

General

Mathematics > Measurement > General

Listening / Pay Attention

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

Mathematics 

Information Technology > Connects to Other Disciplines > Mathematics 

Measure/Calculate

Mathematics > Geometry > Perimeter > Measure/Calculate

Perimeter

Mathematics > Geometry > Formulas > Perimeter

Problem Solving 

Information Technology > Student Use > Problem Solving 

Spreadsheets

Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets 

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

Teacher Notes:

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

Extension Ideas:

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

Standards:

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
Feedback