|
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
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.
Communication
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.
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. |
|
|