
Subject: Engineering the Future 

1. Topic

Make Your Building Energy Efficient 


2. Content

Massachusetts Technology/Engineering Framework (grade 912}
2. Construction Technologies
Central Concepts: The construction process is a series of actions
taken to build a structure, including preparing a site, setting a
foundation, erecting a structure, installing utilities, and finishing
a site. Various materials, processes, and systems are used to build
structures. Students should demonstrate and apply the concepts of
construction technology through building and constructing either fullsize
models or scale models using various materials commonly used in construction.
Students should demonstrate the ability to use the engineering design
process to solve a problem or meet a challenge in construction technology.
2.1 Identify and explain the engineering properties of materials used
in structures (e.g., elasticity, plasticity, R value, density, strength).
4. Energy and Power Technologies"�Thermal Systems
Central Concepts: Thermal systems involve transfer of energy through
conduction, convection, and radiation, and are used to control the
environment. Students should demonstrate the ability to use the engineering
design process to solve a problem or meet a challenge in a thermal
system.
4.1 Differentiate among conduction, convection, and radiation in a
thermal system (e.g., heating and cooling a house, cooking).
4.2 Give examples of how conduction, convection, and radiation are
considered in the selection of materials for buildings and in the
design of a heating system.
Massachusetts Technology Frameworks (grade 912)
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.21 Differentiate between formulas with absolute and relative
cell references.
G912: 1.22 Use multiple sheets within a workbook, and create links
among worksheets to solve problems.
G912: 1.23 Import and export data between spreadsheets and other
applications.
G912: 1.24 Create and use pivot tables.
G912: 1.25 Explain how various formatting options are used to convey
information in charts or graphs.
G912: 1.26 Identify the use of spreadsheet skills in various careers. 


3. Goals: Aims/Outcomes

1. Students will be able to understand their role and work cooperatively
within a group.
2. Students will accurately collect data over a specified time period.
3. Students will understand the value of graphically utilizing a spreadsheet
to compare complex data. 


4. Objectives

Students will be able to:
1. Work cooperatively and understand their role within a group.
2. Construct a spreadsheet to graphically compare temperature change
values.
3. Explain the conditions and variables that affect how energy moves. 


5. Materials and Aids

* 4 insulated boxes
* 4 light bulb assemblies
* 4 digital thermometers
* timing device
* computer lab w/ MS Office
* LCD projector 


6. Procedures/Methods

A. Introduction
1. Teacher will lead a large group discussion about the usage of
spreadsheets.
2. Teacher will construct simple spreadsheet projected for class to
see.
3. Teacher will input values for current class, then show simple functions
and sorting capabilities. 


B. Development
1. Students will be paired up.
2. The pairs will brainstorm ideas and then choose the best idea to
develop their spreadsheet.
3. Teacher will check the spreadsheet after completion. 


C. Practice
1. Students will gather data to be input into their spreadsheet.
2. Students will utilize their spreadsheet to analyze the data they
collected.
3. Students will manipulate their data by sorting and performing various
calculations on it. 


D. Independent Practice
1. Students will perform the data collection exercise for the temperature
rise in the 4 insulated boxes.
2. Students will work within their group to determine the best way
to present the gathered data using a spreadsheet.
3. Students will generate a spreadsheet and input all data from all
4 boxes into their spreadsheet. 


E. Accommodations (Differentiated Instruction)
1. All required accommodations from IEP's will be observed.
2. I will pair one high achieving student with one low achieving student.



F. Checking for understanding
1. Teacher will informally assess each group of students as they
work on their spreadsheet.
2. Each group member will assess other group members for effort, participation,
and teamwork.
3. Spreadsheet presentation and findings will be assessed through
use of a rubric. 


G. Closure
1. Each group will present their spreadsheet for the class to see.
2. Students will write a self reflection about the process. 


7. Evaluation

1. Peer evaluation of effort, participation, and teamwork.
2. Teacher evaluation of team based on rubric. 


8. Teacher Reflection

Teacher will reflect after the exercise is complete. 

