Content Obj:SWBAT demonstrate creative thinking, construct knowledge, and develop innovative products and processes
using technology.
Language Obj:SWBAT use content vocabulary correctly
Carpet Squares:
CARPET SPREADSHEET
1. Create a spreadsheet similar to the one posted on the edmodo assignment. First type in the labels. To get your four titles to look like mine select them and click on wrap text which is on the alignment section of the ribbon, and do not use the space bar! Set the width of the first column to 6 (41 pixels) the next two columns to 8 (61 pixels) and the next three to 9 (68 pixels). The last column should have a width of 10 (75 pixels). Center the alignment of everything, labels and values. Place boarders around the data. This is found in the font section of the Home tab, select more boarders then select a boarder. Should look just like mine when you finished.
2. Rosa is going to buy a new carpet for her office. The office consists of three rooms. Calculate the cost of carpeting each room and the total cost for the three rooms. The carpet costs $20.50 per square yard installed. The room sizes are given in feet, (Square feet is calculated as length * width). To convert square feet to square yards, divide square feet by 9. When you have the square yards you can then create a formula to figure the cost of carpeting each room.
3. Next then create the formulas. Use cell addresses for the formulas. There will be six multiplication formulas, three division formulas and one addition formula. Total the cost for the three rooms in cell G6. Format square feet and square yards to one decimal place. Reducing the decimal is on the home tab above number. Format the cost per square yard, $20.50, the room cost and total for the three rooms to accounting. That is found above number, click on the arrow next to general and select accounting.
4. Copy the whole worksheet and place below the first, click in cell A8 and paste. After pasting change the room size in the second worksheet to: Room A, length =18, width = 20; room B: length = 10, width =15; and room C: length = 6, width = 12.
5. Create a pie chart that shows the percent of the total carpet used in each room, (use the Square yards data from the first table). Highlight the data including the title and go to Insert, charts, pie. Place below the 2nd spreadsheet.
6. Place your name in a header. Submit your assignment to edmodo. Spelling, capitalization, and proper formatting count! No formulas with cell addresses, no credit!
using technology.
Language Obj:SWBAT use content vocabulary correctly
Carpet Squares:
CARPET SPREADSHEET
1. Create a spreadsheet similar to the one posted on the edmodo assignment. First type in the labels. To get your four titles to look like mine select them and click on wrap text which is on the alignment section of the ribbon, and do not use the space bar! Set the width of the first column to 6 (41 pixels) the next two columns to 8 (61 pixels) and the next three to 9 (68 pixels). The last column should have a width of 10 (75 pixels). Center the alignment of everything, labels and values. Place boarders around the data. This is found in the font section of the Home tab, select more boarders then select a boarder. Should look just like mine when you finished.
2. Rosa is going to buy a new carpet for her office. The office consists of three rooms. Calculate the cost of carpeting each room and the total cost for the three rooms. The carpet costs $20.50 per square yard installed. The room sizes are given in feet, (Square feet is calculated as length * width). To convert square feet to square yards, divide square feet by 9. When you have the square yards you can then create a formula to figure the cost of carpeting each room.
3. Next then create the formulas. Use cell addresses for the formulas. There will be six multiplication formulas, three division formulas and one addition formula. Total the cost for the three rooms in cell G6. Format square feet and square yards to one decimal place. Reducing the decimal is on the home tab above number. Format the cost per square yard, $20.50, the room cost and total for the three rooms to accounting. That is found above number, click on the arrow next to general and select accounting.
4. Copy the whole worksheet and place below the first, click in cell A8 and paste. After pasting change the room size in the second worksheet to: Room A, length =18, width = 20; room B: length = 10, width =15; and room C: length = 6, width = 12.
5. Create a pie chart that shows the percent of the total carpet used in each room, (use the Square yards data from the first table). Highlight the data including the title and go to Insert, charts, pie. Place below the 2nd spreadsheet.
6. Place your name in a header. Submit your assignment to edmodo. Spelling, capitalization, and proper formatting count! No formulas with cell addresses, no credit!