Curated OER
Microsoft Office Excel
Students use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
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
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. In 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
Skittle it Up
Students make a graph. In this graphing and Excel instructional activity, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a...
PBL Pathways
Students and Teachers 2
Examine trends in student-to-teacher ratios over time. Building from the first task in the two-part series, classes now explore the pattern of student-to-teacher ratios using a non-linear function. After trying to connect the pattern to...
Curated OER
Graphing Our Marbles
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a...
PBL Pathways
Medical Insurance
Design a plan for finding the best health insurance for your money. Learners compare two health plans by writing and graphing piecewise functions representing the plan rules. Using Excel software, they create a technical report...
Curated OER
Graphing Weather
Students make a graph. In this weather lesson, students fill in a KWL chart about different types of weather. Students watch a PowerPoint presentation about weather and natural disasters and where these types of weather are common....
Curated OER
Apple Graph
Learners sample three types of apples. They choose their favorite apple. They create a graph, charting the favorite apples of their classmates. They answer a series of questions.
Curated OER
All Choked Up By Smoking Statistics
Scholars use the article "More College Learners Are Smoking, Study Says" as a springboard for discussion on the reasons why people smoke cigarettes. They investigate different methods of graphing statistics by using the data provided in...
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
Presenting Painless Breast Cancer Detection!
Students depict a tumor inside a healthy body using a graph in Microsoft Excel. in this breast cancer lesson plan, students also design a brochure that advertises a new form of painless breast cancer treatment.
Curated OER
Graphing With Paper and Computers
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Curated OER
Polar Bears in Peril - Climate Change Culprit?
High schoolers explore the changes in sea ice over several years. In this life science instructional activity, students review and examine 20 years of data. They use Excel to graph data and analyze trends.
Alabama Learning Exchange
What's Your Favorite Chocolate Bar?
Students complete a math survey. In this math graphs lesson, students complete a survey about their favorite candy bars. Students create different kinds of graphs using Microsoft Excel to show their results.
Curated OER
Is the Rainbow Fair?
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Curated OER
Earth Energy Budget Pre Lab
Students explore energy by conducting an in class experiment. In this climate change activity, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and...
PBL Pathways
Medical Insurance 3
Create a technical report explaining the components of a medical plan through a function. The project-based learning activity gives a medical insurance scenario that young mathematicians model using piecewise functions. Their analyses...
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
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
Band Tour Across America
Students plan the trip of a band across America. In this money planning lesson, students create a budget for the band using excel basic functions. They manage the band and its budget and relate the tour to future budgeting needs of the...
PBL Pathways
Potassium-Argon Dating
Find the age of a fictional sample of rocks using a genuine approach. A well-designed lesson asks young mathematicians to use exponential modeling to analyze half-life. As a project-based learning activity, scholars communicate...