Curated OER
Trends of Snow Cover and Temperature in Alaska
Students gather historical snow cover and temperature data from the MY NASA DATA Web site. They compare this data to data gathered using ground measurements from the ALISON Web site for Shageluk Lake. They graph both sets of data and...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
One, Two, Three...and They're Off
Students make origami frogs to race. After the race they measure the distance raced, collect the data, enter it into a chart. They then find the mean, median, and mode of the data. Next, students enter this data into Excel at which time...
Curated OER
Graphing
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Curated OER
Student Costs Data Table
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Curated OER
Getting Into Shapes: Identifying and Describing Two-Dimensional Shapes
Young scholars examine their classroom to find examples of various types of shapes. After identifying and describing the various shapes, they draw as many as they can on a piece of paper. They organize them into an image based on their...
K12 Reader
Displaying Data
It's important to learn how to display data to make the information easier for people to understand. A reading activity prompts kids to use context clues to answer five comprehension questions after reading several paragraphs about...
Curated OER
Don't Settle for a Byte... Get the Megabyte on Technology
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson plan, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint...
Curated OER
Students Favorites
Students complete activities using a frequency table and construct a pie graph for the data. For this frequency table lesson, students complete a survey to find data for a frequency table. Students use the given link to make a pie graph...
Curated OER
Generate Measurement Data Word Problems
Bar and line graphs are an excellent way to visually analyze data: give your scholars practice both analyzing graphs and creating their own! First, they examine five basic bar graphs, indicating the number of squares on specific days....
Curated OER
Seasons and Cloud Cover, Are They Related?
Students use NASA satellite data to see cloud cover over Africa. In this seasons lesson students access data and import it into Excel.
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Spreadsheet Graphs
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Curated OER
Charting Seasonal Changes
Students research the Earth's patterns of rotation and revolution, create a chart and graph of these patterns and use them to explain the causes of night and day and summer and winter.
Curated OER
Graphing on the Computer
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Curated OER
Creating Circle Graphs with Microsoft Excel
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Curated OER
Graphing Your Favorite Pizza Topping
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Curated OER
Meet The Graphs
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
Curated OER
Graphing Data on Ellis Island
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Curated OER
Student Costs Graph
Young scholars calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.