Spreadsheet Development

Spreadsheet Development

Course(s)/Subject(s): Middle School Mathematics-Introducing Microsoft Excel

Grade Level(s): 8th Grade

Key Words: spreadsheets, MS Excel

Developer(s) Name: John L. Herring

School: Lake Braddock Middle School

Attached Files: SPRDSHT

Approximate Time Frame: 45-60 minutes

Materials/Equipment Needed: Computer lab with computers for no more than two students per computer, Microsoft Office 97 with Excel, and sufficient copies of the handouts (one per student).

Description of Lesson (includes context): The lesson presents students with a walk-through introducing the basics of spreadsheet development using Microsoft Excel.


1. What is the objective of this lesson? Students will be able to develop simple spreadsheets using basic formulae to calculate cell entries.

VA FCPS POS Standards: Standard 1: Solve problems involving arithmetic and algebra.

VA FCPS POS Benchmarks: 1.3 Students utilize current technologies to solve problems.

VA FCPS POS Indicators: 1.3.1 Students use technologies to represent and solve algebraic problems. Use and construct computer-based spreadsheets and data bases to solve problems.

VA SOL(s) (including Computer/Technology): C/T8.1 The student will communicate through application software. Communicate spreadsheets by entering data and setting up formulas, analyzing data, and creating graphs or charts to visually represent data.


2. What will we examine as evidence of students’ knowledge and/or skill?

Product(s): Student will produce a spreadsheet on the monitor.

Performance(s): Students will be able to select cells, enter text, numbers, dates and times, and formulas into cells, and use a spreadsheet to track the total cost of stock shares.


3. What exactly will the students and teacher do during the lesson?

Directions to students for proceeding with the lesson:

Read the handout very carefully! Follow the directions exactly as written. Note that italics are used to show when you should enter something into the computer. Raise your hand for questions, and at the appropriate place as described in the handout.

Directions to teacher/administrator using the lesson?

Make sufficient copies of the handout (one per student). Because the appropriate software may be stored differently on your computer, the initial directions may need revising. Please go through the lesson first so you know what you should see on the students’ screens.


4. What options in presentation(s) and/or response(s) are suggested in order to provide the opportunity for all students to demonstrate achievement of the benchmark(s) and indicator(s)?

None necessary.


Page # of #