Subject: Wood Shop
1. Topic-
Calculate Project Cost Using a Spreadsheet
2. Content-
Massachusetts Vocational Technical Education Frameworks - Construction Cluster - Cabinetmaking

2.G Estimate the costs of a project.
2.G.01 Compile a material takeoff

Massachusetts Technology Literacy Standards - Grades 9 through 12

G9-12: 1.18 Define and use functions of a spreadsheet application (e.g., sort, filter, find).
G9-12: 1.19 Enter formulas and functions; use the auto-fill feature in a spreadsheet application.
G9-12: 1.20 Explain and use advanced formatting features of a spreadsheet application (e.g., reposition columns and rows, add and name worksheets).
G9-12: 1.26 Identify the use of spreadsheet skills in various careers.

G9-12: 3.6 Use a variety of media to present information for specific purposes (e.g., reports, research papers, presentations, newsletters, Web sites, podcasts, blogs), citing sources.
3. Goals: Aims/Outcomes-
1. to successfully produce a spreadsheet to calculate project cost
2. to successfully enter and use formulas in a spreadsheet
3. to work cooperatively as a member of a team
4. to successfully present their spreadsheet to the class
4. Objectives-
1. Students will be able to identify and create a spreadsheet.
2. Students will successfully calculate the cost of a simple project.
3. Students will properly enter formulas into their spreadsheet.
4. Students will work cooperatively as a member of a group.
5. Materials and Aids-
Students will be provided a computer in the lab.
Students will use Microsoft Excel to build their spreadsheet.
Students will be provided a parts list for a simple woodworking project.
Students will be provided a rubric for this activity.
An LCD projector will be used for presentations.
The TPS network will be used to save student work.
6. Procedures/Methods-

A. Introduction-

1. Discuss what students already know about calculating project cost.
2. Discuss what students already know about spreadsheets.
3. Teacher to assign students in groups of two.

B. Development-

1. Teacher will start by creating a baseball themed spreadsheet projected for the class to see.
2. Students participate by adding a player and a few statistics at the teacher's workstation.
3. Teacher will demonstrate how to sort and perform calculations on the data.

C. Practice-

1. Students will take the existing template and add more categories to it.
2. Students will use the sort and function utility to manipulate the spreadsheet.

D. Independent Practice-

1. Students will work in groups of two to build a project cost calculating spreadsheet.
2. Students will use the parts list from a simple woodworking project to enter data into their spreadsheet.
3. Students will check their progress as they move through the activity.

E. Accommodations (Differentiated Instruction)-

1. All required accommodations from IEP's will be followed.
2. Students will be grouped heterogeneously.

F. Checking for understanding-

1. Teacher will informally assess students as they work on their spreadsheets.
2. Students will assess their partner.

G. Closure-

1. Each team will present their spreadsheet to the class.
2. Students will write a self reflection about the process.
7. Evaluation-
1. Spreadsheet presentation will be assessed using rubric.
2. Completed rubric will be provided to the teams.

This Lesson Plan is available at (