+
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.  In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the computer and...
+
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

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
+
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson, students enter data into the excel program to find averages and organize data.
+
Lesson Plan
Curated OER

Water Chestnut Graphing Activity

For Teachers 9th - 12th
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
+
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. For 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 plan, young scholars 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
Curated OER

Farming: It's a Fact

For Teachers 6th - 8th
Understanding where our food and textiles come from is key to understanding business, economics, and the importance of modern agriculture. Learners play a game, read text to determine farm fact from opinion, and itemize a grocery receipt...
+
Lesson Plan
Curated OER

PowerPoint Project for Creating a New Business

For Teachers 9th - 12th
Pupils create a mock new business for which they design a PowerPoint presentation. They include company information, financial statements, graphs, advertising and management promotion pages in the final presentation.
+
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
Curated OER

BUS: Farming: It's A Fact (Ag)

For Teachers 9th - 12th
Learners create two different types of graphs from the information in the "Farm Facts" booklet (i.e., bar graph, pie chart, etc.). They calculate where your food dollars are spent (on and off farm).
+
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
Students construct spreadsheets from raw data. For 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

Zebra Mussel Population Simulation

For Teachers 9th - 12th
Young scholars are taught how to format and enter data into an Excel spreadsheet. They make a graph, and interpret graphed data. Students discuss the possible impacts of zebra mussels on the Hudson river. They graph zebra mussel data.
+
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 instructional activity, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced...
+
Lesson Plan
Curated OER

Farming: It's a Fact!

For Teachers 7th - 9th
Students use worksheets, food items, and computer programs to learn about the path of food from the farm to their meals. In this agriculture lesson, students use a provided worksheet to learn facts about farming. They use a bag of...
+
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.