+
Lesson Plan
Curated OER

Class Birthday Graph

For Teachers 2nd - 3rd
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
+
Lesson Plan
Curated OER

What's the Scoop?: Our Favourite Ice Cream Flavours

For Teachers 6th
Sixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a "Favorite Flavors" spreadsheet. Students graph and analyze the data.
+
Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
+
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
+
Lesson Plan
Curated OER

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Pupils participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.
+
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

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

Sales Spreadsheet

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

Shopping Around

For Teachers 3rd
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
+
Lesson Plan
Curated OER

What are they like Today

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

Kindergarten Class Favorites

For Teachers K
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
+
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
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.
+
Worksheet
Curated OER

Spreadsheet Means What

For Students 6th - 8th
For this technology worksheet, students find the words in the word bank that correlate to the fifteen definitions for explaining a spreadsheet.
+
Worksheet
Curated OER

Spreadsheet

For Students 6th - 8th
In this technology worksheet, students find the answers to the problems using the skills of defining and using a computer spreadsheet to find the total costs.
+
Worksheet
Curated OER

Spreadsheet Name The Parts

For Students 6th - 8th
In this technology instructional activity, students examine the sheet that portrays an excel spreadsheet. They name the parts by filling in each bubble.
+
Worksheet
Curated OER

Spreadsheet Definitions

For Students 6th - 8th
For this technology worksheet, students examine the example of the spreadsheet that is listed. The words and definitions are listed.
+
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
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
+
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
+
Lesson Plan
Curated OER

Circles and Stars

For Teachers 3rd - 4th
Students solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
+
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

Creating a "Concrete" Spreadsheet

For Teachers 10th - 11th
Young scholars create a spreadsheet that calculate the amount of concrete needed to pour various concrete forms.
+
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders use data from volcanoes to organize a spreadsheet and make a graph.
+
Lesson Plan
Curated OER

Graphing Climate Information

For Teachers 7th
Seventh graders plot the data for the average monthly precipitation for three cities. They make a graph using a spreadsheet.
+
Lesson Plan
Curated OER

Using a spreadsheet and the Internet to learn about stock market performance

For Teachers 9th - 12th
Students record the progress weekly of a business of their choice on the stock market, graph those results, research and report on current news and how it pertains to the companies recent performance.