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

Soil Excavation

For Teachers 10th - 11th
Students comprehend how percent of change and multipliers are used to determine volume for removal and replacement of soils. They calculate soil volume percent changes using data tables. They apply formulas to solve a variety of...
Lesson Plan
Curated OER

Color Matters

For Teachers 6th - 8th
Middle schoolers create a spreadsheet to chart favorite colors, then collect data, create appropriate charts, and use percentages to describe quantities.
Worksheet
Curated OER

Star Light...Star Bright

For Students 9th - 12th
In this brightness of stars worksheet, high schoolers use a given formula using the temperature in Kelvins of a star to find its brightness. Students solve 4 problems using this equation.
Lesson Plan
Curated OER

Don't Trash the Earth

For Teachers 6th - 8th
Students experience a hands-on environmental science project. They access about recycling as they collect data on their own family's trash production. Students analyze the data with worksheets, chart the data, and present their findings.
Worksheet
Curated OER

Worksheet 2 - Spring 1996

For Students 11th - Higher Ed
In this math worksheet, students state the two fundamental laws of Calculus. Then they investigate finding the area of a rock in cross-sectional pieces.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions

For Students 9th - 10th
In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.
Website
Goodwill

Gcf Global: Excel 2016

For Students 9th - 10th
A website with 33 links plus a quiz on how to use Microsoft Excel 2016. Topics include Excel 2016 Basics, Working with Cells and Sheets, Formulas and Functions, Working with Data, Doing More with Excel, and Extras.
Unit Plan
Goodwill

Gcf Global: Excel Formulas: Functions

For Students 9th - 10th
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions

For Students 9th - 10th
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Activity
University of Illinois

University of Illinois: Quadratic Formula

For Students 9th - 10th
This site from the University of Illinois offers an excellent simulation of the quadratic formula, where you can type in different values for a, b, and c, and then view the change in the answer for x.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
Website
Royal Society of Chemistry

Royal Society of Chemistry: Gridlocks: Level 3

For Students 11th - 12th
A collection of grid puzzles that cover a wide variety of topics in advanced high school chemistry. These are excellent for topic review and reinforcement. The puzzles can be played online and also downloaded as worksheets. Answers are...
Lesson Plan
Other

Personal: Let's Go Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Lesson Plan
Other

Tonya Skinner Business Ed Lesson Plans: Grocery Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...