Lesson Plan
Science Education Resource Center at Carleton College

Serc: Westward Ho! How Far Is Yonder Mountain

For Teachers 9th - 10th
In this activity quantitative skills in geologic context are reinforced. Students create a spreadsheet to calculate the distance of a peak using vertical angles sighted from a wagon train heading directly for the peak. The spreadsheet...
Activity
Texas Instruments

Texas Instruments: Numb3 Rs: Up to Speed

For Teachers 9th - 10th
Based off of the hit television show NUMB3RS, this lesson builds upon the familiar d=rt formula for distance to include elements of acceleration as well. The lesson is framed in the context of traffic flow theory, but makes some very...
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...
Activity
TeachEngineering

Teach Engineering: Measuring G

For Teachers 7th - 8th
Using the LEGO MINDSTORMS NXT kit, students construct experiments to measure the time it takes a free falling body to travel a specified distance. Students use the touch sensor, rotational sensor, and the NXT brick to measure the time of...
Activity
Texas Instruments

Texas Instruments: Grandparents and Special Friends Day

For Teachers 6th - 8th
This lesson was designed for our Grandparents and Special Friends day. It can be used for any visitation day, or an open house. The lesson is designed to review percent of a whole and the sector of the circle representing the percentage....
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Mn Step: Statistical Analysis of Lincoln

For Teachers 9th - 10th
For this activity, students first work in groups to collect information about a set of pennies. They measure and record the mass for each one in a table using a spreadsheet program if possible. They also record its year and, for 1982...
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,...
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...
Handout
Computer Hope

Computer Hope: Tips Relating to Microsoft Excel

For Students 9th - 10th
A listing of various tips that can be used with Microsoft Excel. Find out ways to work better and more efficiently with this spreadsheet program.
Unit Plan
Goodwill

Gcf Global: Excel Formulas: Simple Formulas

For Students 9th - 10th
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we'll show you how to use cell references...
Website
Other

Think Free Office

For Students 9th - 10th
ThinkFree allows you to create, view, publish, edit, and share word processing documents, spreadsheets, and presentations, all online. Sign up and have access to all of your documents from anywhere that you have web access. The website...
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
Professional Doc
Apple

Apple Learning Interchange: Classroom Ideas

For Students 9th - 10th
Do you use Appleworks in your classroom? Would you like some ideas that others have used? This site presents some exemplary lessons from other teachers.
Lesson Plan
Council for Economic Education

Econ Ed Link: Education: Weigh Your Options

For Teachers 9th - 10th
Getting and keeping a job often requires special education or training. While an employer may provide or pay for some additional education or training, workers often have to obtain it on their own. In this lesson, students use a weighted...