Council for Economic Education
Using an Excel Checkbook
High school is the time that many scholars get their first jobs. Help young entrepreneurs apply economic principles to crucial skills for their new jobs and for functioning in society in general. They use Excel to balance a checkbook by...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
How Big Is Your Head?
Students explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
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.
Curated OER
Comp Tech: Format Cells Scavenger Hunt
Students begin their use of Microsoft Excel. Individually, they practice using the program, formatting cells and changing the appearance of the spreadsheet. To end the lesson, they participate in a scavenger hunt completing different...
Curated OER
Using a Spreadsheet
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Curated OER
Graphing
Learners 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.
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...
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics lesson, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
Data Displays with Excel
Students collect and analyze data. In this statistics lesson, students display their data using excel. They plot the data on a coordinate plane and draw conclusion from their data.
Curated OER
Daily Time Ratios
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...
Curated OER
Made Round To Go Round
In this lesson plan 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...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Pupils study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
Making a Spreadsheet
Students explore spreadsheet software. In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer. Students represent hotel, food, transportation, and entertainment costs on a graph...
Curated OER
Excel temperature Graphs
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.
Curated OER
What's your favorite physical fitness activity?
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Curated OER
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Curated OER
Graphing Pockets
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
Curated OER
Building My Dream House
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up to...
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
There's No Accounting for Good Journals
Tenth graders create journals on their spending habits. For this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...