Design your Dream Bedroom!!

Imagine you could decorate your bedroom anyway you wanted. It could be a cozy retreat, a funky and modern pad, or an entertainment paradise.

Here are the rules:

1.  You have $3000.00 to spend and you cannot go over your budget.

2.  You have to keep track of these things when selecting items for your room:

a.  The website you located the product on.

b.  The description of the product

c.  The PRICE!!

3.  Your room is 10’ x 12’ and you need to keep that in mind when looking at paint or flooring.

4.  You can buy anything you want, however, you will have buy these things for your room first:

a.  Bedding (comforters, sheets, pillows)

b.  Paint or wallpaper (remember your room is 10’ x 12’ and you will need to determine how much of this item you will need)

c.  Flooring (carpet, hardwood, rugs, laminate, etc., remember your room is 10’ x 12’ and you will need to determine how much of this item you will need)

d.  At least one large piece of furniture. (bed, entertainment cabinet, dresser, etc.)

5.  You will create a basic spread sheet that will keep track of your expenses. The columns will have the following titles:

a.  Item

b.  Vendor

c.  Description

d.  Price

e.  Total

Your spreadsheet should begin like this:

(Your Name)
My Dream Bedroom Budget Sheet
Item / Vendor / Description / Price / Total
Beginning Balance / $3000.00
(First item) / (website) / (product description) / ($xx.xx) / (Formula)

Here is a list of websites that you can use to do your research:

Wal-Mart.com

Target.com

Lowes.com

Ikea.com

Pier1.com

Bass Pro Shops.com

Cabelas.com

JCPenney.com

Sears.com

Dillards.com

Best Buy.com

Circuit City.com

If you know of somewhere else you can find what you need that is fine, too. Make sure you list where go.

Some things to do:

1.  Merge and center the title of your project “My Dream Bedroom Budget Sheet” and make the font size bigger than the rest of your text.

2.  Bold the column headings.

3.  Insert an appropriate picture making sure it does not cover up any of the text or numbers in your spreadsheet.

4.  Insert a formula that takes your original budgeted amount and shows a running total of what you have left over after each item you purchase.

5.  When you print the spreadsheet, make sure everything fits on one page.

6.  Format the spreadsheet with borders around each cell.

Dream Bedroom Project

Project Due Date______

Student Agreement Sheet

I understand the instructions and my responsibilities for completing this project.

I promise to work on this project while I am in class and to use all of the available class time to complete this project.

I also understand that this is how I will be graded:

Objective / Points Possible / Points Earned
Student spent all (or almost all) of their budgeted amount / 10
Student purchased all of the required items / 15
Student set up spreadsheet as instructed / 20
Student entered the correct formula / 15
Student entered information into all of the fields in the spreadsheet / 20
Student entered a picture into their spreadsheet / 5
Student used borders properly in their spreadsheet / 10
This sheet is signed and stapled to the completed spreadsheet / 5
Extra Credit: Spreadsheet contains extra formatting and design elements that are not required for the project / 10

Signature:______