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
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
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
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
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
Sales Spreadsheet
Middle schoolers use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
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
What's Up With My Class
Middle schoolers collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display...
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
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
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...
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.
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
What are they like Today
Sixth graders compare the modern day countries that exist in the areas they study in Ancient History. They use a spreadsheet on the computer to organize data that includes population of the countries, along with other various types of...
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
Thinking Outside the Box
Now this lesson sounds fun! Students throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
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
Credit Cards: The Good, the Bad, and the ugly
Learners 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
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
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...
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
ARKive
Biodiversity and Evolution – Darwin’s Finches
Teens experience natural selection firsthand (or first beak) in an activity that has them act as finches foraging for food. Using different household items to act as different beak styles, your little finches will collect as much food...
Curated OER
Sequences and Series
High schoolers use Excel Database to explore sequences and series. They examine how to calculate term positions and Sigma Notations. Students use Excel to calculate the values and they print the pages for grading.