Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:15 minutes

Grades:6-8

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: bar graph, data, graph, line graph, pie chart, spreadsheet, table


Primary Objectives:

  • Student learns to use spreadsheet software to create a pie chart, bar graph, and line graph.
  • Student learns to label pie charts, bar graphs, and line graphs, made from a spreadsheet.
  • Student learns to choose and modify charts to effectively communicate information.
  • Student practices reading and interpreting data on a pie chart, bar graph, and line graph.
  • Student learns to graph two sets of data simultaneously.
  • Student learns to add legends and label the axes on bar and line graphs.
  • Student learns to modify data and update pre-created graphs in a spreadsheet.

Secondary Objectives:

  • Student learns the appropriate uses for different types of graphs.
  • Student interprets and analyzes information in different types of graphs.
  • Student will learn to use digital tools to gather, organize and evaluate information.

Subjects:

Communication

Mathematics > Process Standards > Models/Representations > Communication

Compare

Mathematics > Process Standards > Models/Representations > Compare

Compare/Different Data Sets

Mathematics > Statistics Probability > Graphs and Charts > Compare/Different Data Sets

Construct Display/ Histograms/Bar

Mathematics > Statistics Probability > Graphs and Charts > Construct Display/ Histograms/Bar

Construct Display/ Line

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

Construct Display/Circle

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

Construct Display/General

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

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 

Database Applications 

Technology Education > Information Technology > Software Applications > Database Applications 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

Draw Conclusions

Language Arts > Communication > Listening Strategies / Context > Interpret / Infer > Draw Conclusions

General

Mathematics > Statistics Probability > General

Graphic Applications (includes pictures, labels, diagrams, charts) 

Technology Education > Information Technology > Software Applications > Graphic Applications (includes pictures, labels, diagrams, charts) 

Graphic Organizers (Venn Diagrams,etc.) 

Technology Education > Information Technology > Software Applications > Graphic Organizers (Venn Diagrams,etc.) 

Histograms/Bar

Mathematics > Statistics Probability > Graphs and Charts > Histograms/Bar

Identify Message

Language Arts > Communication > Media Literacy / Viewing > Main Idea > Identify Message

Line

Mathematics > Statistics Probability > Graphs and Charts > Line

Parts

Mathematics > Statistics Probability > Graphs and Charts > Parts

Problem-solving

Mathematics > Process Standards > Models/Representations > Problem-solving

Purpose

Language Arts > Communication > Media Literacy / Viewing > Purpose

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Student Evaluation and Selection of Tools / Software for Task 

Technology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for Task 

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically
Show More
  • Using an application or software to create graphs can be easy enough for students to learn, but students should understand that a certain type of graph can convey specific information more effectively than others. Ensure that your students have time after this lesson to create different types of graph from the same set of data in order to explore how a type of graph can better communicate the information they wish to highlight or present.

  • Students can break into teams to develop a presentation on what type of graph is most effective for different sets of data. Students should brainstorm and decide what information they want to present. Students can gather quick data facts from any number of sources, including websites, almanacs, and other reference materials. Have students enter data into a spreadsheet application and then create graphs from the data. Students should choose the best type of graph to use for the information they chose and be prepared to defend their choice of graph. The students could also present ineffective uses of graphs.
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.
S.6.d Students publish or present content that customizes the message and medium for their intended audiences.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
ELA-Literacy.SL.6.2 Interpret information presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how it contributes to a topic, text, or issue under study.
ELA-Literacy.SL.7.2 Analyze the main ideas and supporting details presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how the ideas clarify a topic, text, or issue under study.
ELA-Literacy.SL.8.2 Analyze the purpose of information presented in diverse media and formats (e.g., visually, quantitatively, orally) and evaluate the motives (e.g., social, commercial, political) behind its presentation.
Math.Content.6.SP.B.4 Display numerical data in plots on a number line, including dot plots, histograms, and box plots.
Math.Practice.MP4 Model with mathematics.
Math.Practice.MP5 Use appropriate tools strategically.
ELA-Literacy.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).