Lesson Plan
Curated OER

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Lesson Plan
Curated OER

Beginning Graphs in MS Excel

For Teachers 3rd - 5th
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  For this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

Small Business

For Teachers 6th - 12th
Students simulate owning and running a small business by playing Lemonade Stands. They play the game for three weeks, then work with a partner to produce a Power Point presentation which would be given to a Board of Directors showing...
Lesson Plan
Curated OER

What's Your Shoe Size? Linear Regression with MS Excel

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

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Lesson Plan
Curated OER

Excel for Beginners

For Teachers 4th - 5th
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Lesson Plan
Kenan Fellows

Let's Move

For Teachers 6th - 12th Standards
Find a statistical reason for a fresh start. Using a hypothetical scenario, individuals research statistical data of three different cities. Their goal? Find the best statistical reason for a business to move to a new location. Their...
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...
Unit Plan
Curated OER

GSE Foundations of Algebra: Equations and Inequalities

For Students 7th - 9th
Need lessons on writing and solving one- and two-step linear equations and inequalities, as well as systems of equations? This comprehensive 106-page module from the Georgia Department of Education contains many different lessons for a...
Lesson Plan
Curated OER

World of Work

For Teachers 12th
Twelfth graders research want ads on the Internet or in the newspaper. They calculate the estimated weekly, monthly, and yearly pay for an hourly, salary and commission positions. They calculate a paycheck including state tax, federal...
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Students write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Young scholars construct spreadsheets from raw data. In this spreadsheet construction activity, students compile data into Microsoft Excel. Young scholars familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Technobiz

For Teachers 8th - 12th
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Lesson Plan
Curated OER

Cook Me Up Some Equations

For Teachers 7th - 12th
Students study a variety of math concepts in the context of cooking up a meal. In this math lesson, students calculate surface area and volume. They draw and interpret different types of graphs.
Lesson Plan
Curated OER

Journalism

For Teachers 7th - 10th
Students insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
Lesson Plan
Curated OER

Buy Low, Sell High

For Teachers 7th - 10th
Students investigate the stock market and investing in corporate stocks by creating an investment portfolio. They develop database worksheets that track their stock's performance over a specified period of time. Students use their...
Lesson Plan
Curated OER

Getting Into Shapes: Identifying and Describing Two-Dimensional Shapes

For Teachers K - 2nd
Young scholars examine their classroom to find examples of various types of shapes. After identifying and describing the various shapes, they draw as many as they can on a piece of paper. They organize them into an image based on their...