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
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 that can be accomplished using standard art techniques or educational software such as Adobe Photoshop or Microsoft...
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
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.
Education World
A Spooky Adlib Story
Students 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...
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 their stem and...
Curated OER
Creating Your Own Web Site
Young scholars 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...
Curated OER
Using Excel to Draw a Best Fit Line
Students 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. Students print graphs without trend lines and manually draw...
National Research Center for Career and Technical Education
Depreciation (Double Declining)
Have you ever been told that your new car begins to lose its value as soon as you drive it off the lot? Aspiring accountants take on the concepts of depreciation and book value through an easy-to-deliver career and technology...
Howard Hughes Medical Institute
Human Feet Are Strange
Feet are neat! So, if you've already walked the path of examining animal footprints with your class, put them in the shoes of early humans! A well-designed lesson incorporates video, discussion, and hands-on learning to demonstrate how...
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
Graphing on the Computer
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Curated OER
Integrated Project
Middle schoolers participate in a project that integrates Microsoft Word, Excel and PowerPoint. In groups, they write a proposal for their project and complete the necessary steps to create and design it. To end the lesson, they are...