+
Assessment
Concord Consortium

Broken Spreadsheet I

For Students 8th - 11th Standards
There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...
+
Lab Resource
Pingry School

The Water Lab – Spreadsheet Simulation

For Students 9th - 12th Standards
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
+
Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 9th - 12th
Students create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.
+
Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 7th - 9th
Students experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.
+
Lesson Plan
Curated OER

Dino-Myte Spreadsheet

For Teachers 4th - 8th
Do your learners like dinosaurs and theme parks? An ambitious activity invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
+
Assessment
Concord Consortium

Broken Spreadsheet II

For Students 11th - 12th Standards
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
+
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
+
Lesson Plan
Curated OER

Creating a Spreadsheet and Graph

For Teachers 4th - 5th
Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the graph are...
+
Lesson Plan
Curated OER

Spreadsheet formulas

For Teachers 6th - 8th
Learners, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...
+
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
+
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

Analyzing Discrete and Continuous Data in a Spreadsheet

For Teachers 6th - 12th Standards
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
+
Lesson Plan
Curated OER

Creating a "Concrete" Spreadsheet

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

M&M Graphing

For Teachers 4th
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
+
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

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

Writing Fables

For Teachers 7th - Higher Ed
Students write their own fables. For this writing fables lesson, students use handheld computers to write a fable. The class designs a spreadsheet to organize common elements of fables. Students also edit each others' work.
+
Lesson Plan
Curated OER

Adding and Subtracting Decimals With Excel

For Teachers 5th
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.
+
Lesson Plan
Curated OER

Metrically Me!

For Teachers 4th - 6th
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
+
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

Making a Spreadsheet

For Teachers 5th - 8th
Learners explore spreadsheet software.  In this personal finance and computer technology instructional activity, students develop a vacation spreadsheet on the computer.  Learners represent hotel, food, transportation, and entertainment...
+
Lesson Plan
Curated OER

Mythology Spreadsheet

For Teachers 4th - 8th
Students read a large variety of myths and discuss the characters and their attributes found in mythology. Then they identify and learn to set up an appropriate spreadsheet program. Students also enter the data to the class spreadsheet...
+
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.
+
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology instructional activity, 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.

Other popular searches