Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Curated OER
Excel Lesson
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Curated OER
Creating Circle Graphs with Microsoft Excel
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Curated OER
Using Spreadsheets and Graphs
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
Curated OER
Favorite Food
Students are given three choices of food. They then decide on their favorite and predict what the class's favorite food will be. After the teacher enters the data into the computer, students gather around the computer to view the...
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
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
Reading Graphs
Learners read graphs and charts to interpret results. In this algebra activity, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. In this data analysis lesson plan, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts...
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
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.
Curated OER
How do We Treat Our Environment?
Seventh graders explore the concept of collecting data. In this data collection lesson, 7th graders survey others about their environmental habits. Students graph their data.
Curated OER
Tracking Your Favorite Web Sites
Ninth graders track the hit count on their favorite web sites. In this Algebra I lesson, 9th graders record the number of hits on their favorite web site for twenty days. Students explore the data to determine if the relation defines a...
Curated OER
Bias in Statistics
Students work to develop surveys and collect data. They display the data using circle graphs, histograms, box and whisker plots, and scatter plots. Students use multimedia tools to develop a visual presentation to display their data.
Curated OER
Quarter, Nickel, Dime....
An engaging game called, "Quarter, Nickel, and Dime" is presented in this math lesson. Players are given an envelope with slips of paper that represent the three coins. In pairs, they play the game 18 times, and the whole class charts...
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
Trends of Snow Cover and Temperature in Alaska
High schoolers 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...
Curated OER
Simple Machines
Here is an inventive plan that should get your young scientists excited! In it, groups of pupils test out the work done by six different simple machines. The machines are: the wedge, the lever, the inclined plane, the pulley, the screw,...
Curated OER
Graphing and Analysis of Water Quality Reports
Learners practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Curated OER
The Racing Heart
Fifth graders locate their own pulse rate from their carotid or radial artery, and graph their pulse rates after completing various exercise activities. They graph their data on a pie graph using Microsoft Excel software.
Radford University
Sleep and Teen Obesity: Is there a Correlation?
Does the number of calories you eat affect the total time you sleep? Young mathematicians tackle this question by collecting their own data and making comparisons between others in the class through building scatter plots and regression...
Curated OER
Seasons and Cloud Cover, Are They Related?
Students use NASA satellite data to see cloud cover over Africa. In this seasons instructional activity students access data and import it into Excel.
Curated OER
Virtual Field Trip
This hands-on resource has future trip planners analyze graphs of mileage, gasoline costs, and travel time on different routes. While this was originally designed for a problem-solving exercise using a Michigan map, it could be used as a...