This engaging and interactive digital lesson provides direct instruction and practice as the learners work with line charts in a spreadsheet program. They will use data found in a spreadsheet to create and label line charts, then practice reading and interpreting data found in a line chart.
Estimated Time:8 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: column , data, line chart, line graph, row, spreadsheet
CommunicationMathematics > Process Standards > Models/Representations > Communication
CompareMathematics > Process Standards > Models/Representations > Compare
Create PresentationsTechnology Education > Information Technology > Digital Communications > Create Presentations
Data Collection for Decision MakingLibrary Media > Information Technology > Student Use > Data Collection for Decision Making
Data Collection for Decision MakingTechnology Education > Digital Literacy > Student Use > Data Collection for Decision Making
Data FormatsTechnology Education > Information Technology > Basic Operations and Concepts > Data Formats
Data MiningLibrary Media > Information Literacy > Reference and Research > Research Skills > Data Mining
Design Sorting AlgorithmsTechnology Education > Information Technology > Programming > Design Sorting Algorithms
DisplaysMathematics > Statistics Probability > Computation/Technology > Displays
GeneralMathematics > Statistics Probability > Graphs and Charts > General
InstructionsLanguage Arts > Communication > Listening Strategies / Context > Follow Directions > Instructions
InternetScience > Concepts and Processes > Tools / Instruments > Software Tools > Internet
LineMathematics > Statistics Probability > Graphs and Charts > Line
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
Listening / Pay AttentionLanguage Arts > Communication Spanish > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
Problem SolvingTechnology Education > Information Technology > Student Use > Problem Solving
SpreadsheetsMathematics > Number Operations > Computation/Technology > Spreadsheets
SpreadsheetsLibrary Media > Information Technology > Software Applications > Spreadsheets
SpreadsheetsMathematics > Statistics Probability > Computation/Technology > Spreadsheets
SpreadsheetsTechnology Education > Information Technology > Software Applications > Spreadsheets
Student Evaluation and Selection of Tools / Software for TaskTechnology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for Task
TableMathematics > Statistics Probability > Graphs and Charts > Table
Technical / SpecializedLanguage Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized
Use appropriate tools strategicallyMathematics > Process Standards > Common Core > Use appropriate tools strategically
Visual/GraphMathematics > Number Operations > Models/Representations > Visual/Graph
Vocabulary DevelopmentLanguage Arts > Communication > Listening Strategies / Context > Vocabulary Development
The data used in this lesson charts the monthly rainfall in the Belize rainforest. You might want to have students find Belize on a map, and then discuss the qualities that make up a typical rainforest.
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 line chart using data markers. Data markers are dots or shapes located at data points that make recognizing milestones on a line chart easier to see. Students also turn on gridlines, so you might want to discuss gridlines and how they can sometimes help make a chart clearer.
This lesson discusses the X and Y axis orientation in charts. To help students remember which axis is which, suggest to students that they think of the Y axis as an extension of the vertical portion of the letter Y.