Teacher-Facing Resources

Type:Lesson

Estimated Time:11 minutes

Grades:2-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: bar chart, bar graph, column , data, row, spreadsheet


Primary Objectives:

  • Student learns to create a bar chart from data in a spreadsheet.
  • Student learns to label bar charts and their axes.
  • Student practices reading and interpreting data on a bar chart.

Secondary Objectives:

  • Student investigates the natural world and identifies some traits of ungulates (hoofed animals).
  • Student recognizes the concept of using height, weight, volume, speed, distance, and time as comparative measurements.
  • Student learns the purpose of using a bar chart to represent data.
  • Student practices analyzing and interpreting bar chart data.

Subjects:

Bar Graphs

Science > Concepts and Processes > Visual Representations > Tables / Graphs / Charts > Bar Graphs

Communication

Mathematics > Process Standards > Models/Representations > Communication

Compare

Mathematics > Process Standards > Models/Representations > Compare

Construct Display/ Histograms/Bar

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

Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

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

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

Design Sorting Algorithms 

Technology Education > Information Technology > Programming > Design Sorting Algorithms 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

General

Mathematics > Statistics Probability > Graphs and Charts > General

Histograms/Bar

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

Instructions

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

Internet

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

Interpret/Analyze

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

Listening / Pay Attention

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

Mathematics 

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

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > 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 

Technical / Specialized

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

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically

Visual/Graph

Mathematics > Number Operations > Models/Representations > Visual/Graph

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More
  • The data used in this lesson compares the speeds of ungulates. Ungulates are hoofed animals, such as zebras, goats, hippopotamuses, giraffes, and so forth. You might want to point out that hoofs are actually overgrown toenails and that ungulates are often classified by the number of toes they have.

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

  • In this lesson, students create a bar chart using horizontal bars. You might want to emphasize that horizontal bars are usually used to compare speed, distance, and time while vertical bars are used to compare height, weight, and volume. After students create a chart, they also update it by changing the chart's table data. You might want to reinforce the idea that graphs and charts are updated dynamical when the data in the data table is changed.

  • To help students understand the differences between vertical and horizontal bar charts, first draw two simple bar charts without axes labels on the board to represent a horizontal and vertical bar chart. Then name a type of data you want to represent in a bar chart, such as amount of water a set of buckets holds, how fast different types of dogs can run, and so forth. Point to a bar chart and ask students to raise their hand if they think you should use that style of bar chart. Repeat the exercise until most of the class seems to understand the difference between horizontal and vertical bar charts. You might also consider having volunteers name data sets and point to the bar charts as the class works through the exercise.

See how our curriculum can help you meet your instructional goals

Check it out