Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Curated OER
Earth Energy Budget Pre Lab
Students explore energy by conducting an in class experiment. In this climate change lesson plan, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and...
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
Counting Coins
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Curated OER
EXCEL It!
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
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
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
Data Handling
In this data handling worksheet, students interpret data found in table, graphs and charts. They organize data and draw bar charts. This two-page worksheet contains 2 multi-step problems.
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...
Space Awareness
The Climate in Numbers and Graphs
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
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
Maryland’s Chesapeake Bay Landscape Long Ago and Today
Combine a fantastic review of primary source analysis with a study of Captain John Smith's influence on the Chesapeake Bay region in the seventeenth century. Your young historians will use images, a primary source excerpt, and maps...
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
Data Collection
Students write a journal exercise that relates to pets. They collect information from each other in order to practice making and interpreting bar graphs. They Continue building different kinds of graphs with the group.
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the...
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
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
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
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Learners, 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
Using Excel To Teach Probability And Graphing
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
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
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
Pet Count Excel Graphing
Students 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 they tabulate a bar chart and present their findings to the class.
Curated OER
Math Lesson: What Do You Want to Know? - Country Statistics
High schoolers 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...