Curated OER
kind of Bean
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
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
Pets Galore!
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Discovery Education
Sonar & Echolocation
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
Teach Engineering
Searching for Bigfoot and Others Like Him
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data layer.
Curated OER
"Living in the Limelight The Universal Dream"
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
Council for Economic Education
Loan Amortization - Mortgage
When you buy a home for $100,000, you pay $100,000—right? On the list of important things for individuals to understand, the lesson plan presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Curated OER
Tears of Joy Theatre Presents Anansi the Spider
Accompany the African folktale, Anansi the Spider, with a collection of five lessons, each equipped with supplemental activities. Lessons offer multidisciplinary reinforcement in English language arts, social studies, science, and arts...
Curated OER
Daily Time Ratios
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent...
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Made Round To Go Round
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
Curated OER
Stress, Strain and Hooke's Law
Learners study Hooke's Law and stress-strain relationships. For this spring lesson students create a strain graph in Microsoft Excel.
Curated OER
What's your favorite pi?
Sixth graders toss popcorn kernels at a 12? circle inscribed in a 12? square. By counting the number of popcorn kernels that land inside the circle and inside the square the students calculate estimates for the value of pi.
Curated OER
Traffic Problem- Solved Using Microsoft Excel
Young scholars relate algebra to real life scenario. In this algebra instructional activity, students design a plan to help traffic flow smoothly using velocity and speed. This assignment is done using Microsoft Excel.
Curated OER
Terrific Tessellations
Students create to pieces of artwork using two primary colors and tessellation techniques. This is an excellent lesson plan that can be accomplished using standard art techniques or educational software such as Adobe Photoshop or...
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
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
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
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
Peopling the New World -- An Archaeological Exercise in Excel
Young scholars examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in...
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
Using Imported Data in Excel
Students import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
Education World
A Spooky Adlib Story
Learners navigate a simple spreadsheet and develop their creativity. They answer questions, filling in cells on Excel, using a template after filling in all the fields, a silly spooky story is created from the answers they give. Students...