- Measure and calculate the area of the computer lab or classroom using a yard stick or tape measure (i.e. square fteet).
- Decide on the size of your dream room.
- Based on your knowledge of measurement, use an Excel spreadsheet to record dimensions of your dream room and create formulas to calculate surface area of ceiling, walls and floor. Calculate the volume of the room. The volume must be between 860 and 1200 cubic feet. (e.g. length x width x height = ? cubic feet). Use that information to shop for ac/heater.
- Save to filename: room_design_calculations_lastname.xls
- Use the Resource Links to shop for: the paint, wallpaper, floor covering, items to furnish your room, and air conditioning/heating unit appropriate for the room's volume.
- Record the details of materials in your room_design_calculations.xls file
- Add image of product, enter price, calculate quantity needed based on quantity sold, and calculate total cost of materials.
- Create a second spreadsheet with filename: shopping_list_lastname.xls. The column titles are: item description, dimensions, unit price, quantity, total price, picture, floor plan item# and URL. Convert measurements to metric or standard as needed. Measurements are used to scale furnishings accurately for the floor plan.
- Use the Resource Links to shop for furniture and other necessary items such as: bedding, pillows, mattress, furniture, electronics, chairs, desk etc. Type the details into the shopping file.
- Use Cad Standard Lite (a free software download) to draw your floor plan to scale. Add correctly scaled symbols to represent the furnishings.
- Student present their project via a Gallery Walk format,
- i.e. Set up 4-6 display computers/areas and have small groups of students rotate through each exhibit.
- Presentation should include the Excel files and screen capture or jpg image of the CadStandard lite floor plan.
- Optional: Student will create a visual presentation of their dream room using one of these programs: Inspiration, PowerPoint, Microsoft Word, webpage
Examples and Resources Calculations Floor Plan
Shopping List Mattress Size