Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day. They...
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

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

Made Round To Go Round

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

Stress, Strain and Hooke's Law

For Teachers 10th - 12th
Students study Hooke's Law and stress-strain relationships.  In this spring lesson students create a strain graph in Microsoft Excel.
Lesson Plan
Curated OER

What's your favorite pi?

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

Traffic Problem- Solved Using Microsoft Excel

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

Terrific Tessellations

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

Excel temperature Graphs

For Teachers 4th - 6th
Learners 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.  Learners will find the average weather and add a trend line to their graph.
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

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

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I instructional activity, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine...
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

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

Pet Count Excel Graphing

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

Using Imported Data in Excel

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

Creating Your Own Web Site

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

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
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...
Lesson Plan
National Research Center for Career and Technical Education

Depreciation (Double Declining)

For Teachers 9th - 12th
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 lesson. The...
Lesson Plan
Howard Hughes Medical Institute

Human Feet Are Strange

For Teachers 9th - 12th Standards
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 instructional activity incorporates video, discussion, and hands-on learning to...
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

Graphing on the Computer

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

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Microsoft Excel Lesson Plan

For Teachers 5th
Fifth graders collect, organize, interpret data. In addition, they compare different textures, color including graphical representations such as bar graph, line graph .Students also describe the uses of rocks and how to use that to...
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...