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...
Curated OER
"Living in the Limelight The Universal Dream"
High schoolers, 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...
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 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,...
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...
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, 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
Students study Hooke's Law and stress-strain relationships. In 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
Students relate algebra to real life scenario. In this algebra lesson, 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 instructional activity, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend...
Curated OER
Building Arrays Using Excel Spreadsheets
Young scholars create arrays using Microsoft Excel. For 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 activity, 9th graders record the number of hits on their favorite web site for twenty days. Students explore the data to determine if the...
Curated OER
Peopling the New World -- An Archaeological Exercise in Excel
Students 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 other...
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
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.
Alabama Learning Exchange
The State Capital of Stem and Leaf
Students explore the concept of stem and leaf plots. For 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...
Curated OER
Creating Your Own Web Site
Pupils explore and explain how to design Web pages complete with text, graphics, and hypertext links. After adding backgrounds, navigation buttons, and audio-visual effects, and revising their work based on comments from peers and...
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...