80 likes | 169 Views
This project involves building playhouse models for children affected by Hurricane Katrina. Compare costs of Cape Cod and Victorian models. Learn about building features and trimmings involved. Use spreadsheet fundamentals for cost calculations.
E N D
Hurricane Katrina Help the children!
Helping the children • Build a model of a playhouse • Find the cost of the models: Katrina.xls • Compare the costs of the models • A donor has been identified!!!!
A Cape Code Model • What are the building features for this house? • Trimming • Dutch door • Shutters
A Victorian Model • What are the features of this house? • Child dutch door • Flowerboxes • Trimming
Your turn to work on the problem How much do these playhouses cost to build?
Spreadsheet Fundamentals • Avoid numeric values in formulas • Refer to values by cell referencing • Use built in formulas • Be careful with cell referencing (absolute vs. relative) • =sum(B2:B10)/8 • =sum(B2:B10)/B1 • =average(B2:B10) • = $B$3*B5 + $C$3