Business Applications

Not a Learning.com customer? Learn More

Type:Lesson

Estimated Time:10 minutes

Score Type:Auto Score

This lesson automatically provides a score to your gradebook

Available Languages: English, Spanish


Vocabulary: column , data, graph, pie chart, row, spreadsheet


Primary Objectives:

  • Student learns to label pie charts made in a spreadsheet.
  • Student practices reading and interpreting data on a pie chart.
  • Student learns to create a pie chart from data in a spreadsheet.

Secondary Objectives:

  • Student investigates the natural world and identifies some traits of wild cats.
  • Student learns the purpose of using a pie chart to represent data.
  • Student practices analyzing and interpreting pie chart data.
  • Student translates geographic data into a graph.
  • Student uses percents and division to show a pattern.

Subjects:

Circle

Mathematics > Statistics Probability > Graphs and Charts > Circle

Construct Display/Circle

Mathematics > Statistics Probability > Graphs and Charts > Construct Display/Circle

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 

Data Formats 

Technology Education > Information Technology > Basic Operations and Concepts > Data Formats 

Data Mining

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

Data Mining

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

Instructions

Language Arts > Communication > Listening Strategies / Context > Follow Directions > Instructions

Interpret/Analyze

Mathematics > Statistics Probability > Graphs and Charts > Interpret/Analyze

Interpretation

Mathematics > Statistics Probability > Data > Interpretation

Listening / Pay Attention

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

Mathematics 

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

Part of Whole

Mathematics > Number Operations > Percents > Part of Whole

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Statistical

Mathematics > Statistics Probability > Computation/Technology > Statistical

Technical / Specialized

Language Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More

Teacher Notes:

  • In this lesson, students create a pie chart using the default style. In spreadsheet software, students can select subtypes to create 3-D, exploding, and other styles of pie charts. You might want to discuss the other styles of pie charts before students use a spreadsheet software program to create a chart.

  • The data used in this lesson pertains to the percentage of wild cat species that are native to each continent. Both big and little wild cats are included in the data. The main division between big and little cats is that big cats can roar and little cats can't (because their voice boxes are different). The big cat group includes lions, tigers, leopards, and jaguars, and excludes all other wild cats, including mountain lions, snow leopards, and cheetahs.

  • This lesson provides prepared data for students. You might want to discuss the process of researching and compiling data. Note that charts and graphs display information, and that they can only be created in a spreadsheet program after the data has been organized into a table.

Extension Ideas:

  • This lesson discusses percentages and pie charts. Students can work together to put cardboard pie charts together to help reinforce the concept of pie charts showing parts of a whole and percentages representing a portion of 100%. To do this activity, you must first use poster board to create a few pie charts that present true or fictional data. Make sure each part of each pie is cut from a different color of poster board, and label each pie piece with its appropriate percentage number. Then, give each student a piece of a pie and instruct students to work together to create complete pie charts so that each pie equals 100% and doesn't repeat any colors. After the students successfully re-create the pie charts, glue the pie charts together, and hang them in the room.

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.
1A-DA-05 Store, copy, search, retrieve, modify, and delete information using a computing device and define the information stored as data. (P4.2)
1A-DA-06 Collect and present the same data in various visual formats. (P7.1, P4.4)
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.L.2.6 Use words and phrases acquired through conversations, reading and being read to, and responding to texts, including using adjectives and adverbs to describe (e.g., When other kids are happy that makes me happy).
ELA-Literacy.L.3.6 Acquire and use accurately grade-appropriate conversational, general academic, and domain-specific words and phrases, including those that signal spatial and temporal relationships (e.g., After dinner that night we went looking for them).
ELA-Literacy.L.4.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal precise actions, emotions, or states of being (e.g., quizzed, whined, stammered) and that are basic to a particular topic (e.g., wildlife, conservation, and endangered when discussing animal preservation).
ELA-Literacy.SL.2.2 Recount or describe key ideas or details from a text read aloud or information presented orally or through other media.
ELA-Literacy.SL.3.2 Determine the main ideas and supporting details of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
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.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards
Feedback