Lesson Plan
Curated OER

Presenting Painless Breast Cancer Detection!

For Teachers 10th - 12th
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.
Lesson Plan
Curated OER

Skittle it Up

For Teachers 6th - 8th
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...
Lesson Plan
Curated OER

Graphing Our Marbles

For Teachers K
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.
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
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...
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
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.
Lesson Plan
Curated OER

Apple Graph

For Teachers K - 1st
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.
Activity
PBL Pathways

Students and Teachers 2

For Students 10th - Higher Ed Standards
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...
Lesson Plan
Curated OER

Polar Bears in Peril - Climate Change Culprit?

For Teachers 9th - 12th
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.
Activity
North Haven Middle School

Environmental Expert Presentation

For Teachers 6th - 12th
Individuals or groups select an environmental issue, then spend time researching and creating a presentation to share in class. By allowing learners to choose the issue that matters most to them, you will motivate them to do...
Lesson Plan
Curated OER

Graphing Weather

For Teachers 2nd - 3rd
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....
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
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.
Lesson Plan
Curated OER

Fairy Tales

For Teachers 6th
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...
Lesson Plan
Curated OER

Microsoft Office Excel

For Teachers 6th - 8th
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. 
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
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...
Lesson Plan
Curated OER

Bias in Statistics

For Teachers 7th - 8th
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.
Lesson Plan
Curated OER

All Choked Up By Smoking Statistics

For Teachers 9th - 12th
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...
Activity
PBL Pathways

Medical Insurance

For Students 10th - Higher Ed Standards
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...
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 7th
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...
Lesson Plan
Curated OER

Food Groups in our Lunch

For Teachers 3rd - 5th
Students make a graph. In this food groups and graphing lesson, students pack a sack lunch and then work in groups to tally the number of foods from each food group that they have. Students use the data collected to create a graph using...
Activity
PBL Pathways

Doctors and Nurses

For Students 11th - Higher Ed Standards
How many nurses does it take to support one doctor? A project-based activity asks learners to analyze state data to answer this question. Classes create polynomial functions from the data of doctors and nurses over a seven-year...
Lesson Plan
Curated OER

Is the Rainbow Fair?

For Teachers 3rd
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....
Lesson Plan
Alabama Learning Exchange

The State Capital of Stem and Leaf

For Teachers 5th - 10th Standards
Students explore the concept of stem and leaf plots.  In this stem and leaf plots lesson, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state.  Students compare...
Lesson Plan
Curated OER

How Do Plants Grow?

For Teachers 3rd - 5th
Students investigate plant growth. In this plant growth lesson, students investigate what would happen to plants if they did not have water and sunlight. Students conduct experiments to determine what plants need. Students create a...
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
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...

Other popular searches