Lesson Plan
Curated OER

Roofing and Right Triangles

For Teachers 9th - 11th
Young scholars use models and symbols to represent properties of the Pythagorean Theorem. In this right triangle instructional activity, students connect real jobs to properties of right triangles. They solve word problems applying the...
Lesson Plan
Curated OER

Color Matters

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

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Worksheet
Curated OER

Worksheet 2 - Spring 1996

For Students 11th - Higher Ed
In this math learning exercise, students state the two fundamental laws of Calculus. Then they investigate finding the area of a rock in cross-sectional pieces.
Lesson Plan
Curated OER

Statistical Pictures of School and Life

For Teachers 9th - 10th
Students explore how mathematical data is used to summarize and illustrate everyday life. They apply mathematical concepts and skills to analyze data. Students conduct a five question survey of 50 people or more and graph the data.
Lesson Plan
Curated OER

Don't Trash the Earth

For Teachers 6th - 8th
Learners 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.
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.
Interactive
Goodwill

Gcf Global: Excel Formulas

For Students 9th - 10th
In this interactive tutorial, learn how to create formulas to solve real-world problems.
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....
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
Department of Defense

Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions

For Students 9th - 10th
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
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...