
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
Spreadsheet
G912: 1.18 Define and use functions of a spreadsheet application
(e.g., sort, filter, find).
G912: 1.19 Enter formulas and functions; use the autofill feature
in a spreadsheet application.
G912: 1.20 Explain and use advanced formatting features of a spreadsheet
application (e.g., reposition columns and rows, add and name worksheets).
G912: 1.26 Identify the use of spreadsheet skills in various careers.
Communication
G912: 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.
Rubric 


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. 

