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...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
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 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
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
Balloon Graphing
Fourth graders explore data, charts and graphs. They create graphs using titles, labels, axes, intervals, and scale correctly. Students enter their data into Excel and create a graph.
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
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.
Curated OER
Reading Graphs
Students read graphs and charts to interpret results. In this algebra lesson, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. For this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
Curated OER
Math Lesson: What Do You Want to Know? - Country Statistics
Students are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing the...
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. For this data analysis lesson, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts online...
Curated OER
Earth Energy Budget Pre Lab
Learners explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Learners utilize graphs and charts to analyze the results of the experiment and help...
Curated OER
What's My Pattern?
Students recognize, describe and extend patterns in three activities. They organize data, find patterns and describe the rule for the pattern as well as use the graphing calculator to graph the data to make and test predictions. In the...
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to their graph.
Curated OER
Skittle it Up
Young scholars make a graph. In this graphing and Excel lesson, students work in groups and are given a bag of skittles. Young scholars count the number of each color skittle and create a table in Excel. Students learn how to make a pie...
Curated OER
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
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
Creating Bar Graphs and Pie Graphs
Second graders observe a demonstration of the creation of a bar graph and a pie graph of their favorite colors. They gather information about various topics from their classmates, then organize the information, creating a bar and a pie...
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
Meet The Graphs
Learners 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
Pet Count Excel Graphing
Pupils used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson plan they tabulate a bar chart and present their findings to the...
Curated OER
Graphing Pockets
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.