Classroom Learning Activity 2 Painting Estimate (Part 1) Start-up Instruction: Download the starting file from the assignment page in Canvas to your computer Starting Filename: Blank_File.xlsx Submission Filename: uniquelD_Painting1.xlsx 1. a. c. This activity is the first in a sequence of two activities. Our ultimate goal is to prepare a worksheet that a painting contractor can use to estimate the cost of a painting job. Perform the Start-up Instruction. Extract the CLA02 folder from CLA02.zip and move the CLA2 folder to your M-Drive > CSE 148 > CLA folder. Then in your CLA02 folder, open Blank_File.xlsx and then select Save As..., and save the file as uniquelD_Painting1.xlsx. 2. Prepare a Documentation worksheet containing a title, author, date, and purpose of this worksheet 3. Create an Estimate worksheet to estimate the cost painting. 4. On the Estimate worksheet, provide: rows for up to 10 rooms that require painting. b. column headings to specify: the name of the room, the dimensions of the room in feet (length, width, and height), the square footage to be painted (computed from the dimensions - 4 walls and a ceiling), the labor cost per square foot, the paint cost per square foot and the total cost per room computed from the labor and paint cost per square foot. [Note: square footage (area) is NOT Length times Width times Height, that would be volume] Use the three sample rooms shown in the step below and enter the information into the spreadsheet. d. Use formulas for the square footage and the total cost per room columns so that the formulas for the first room can be copied to compute the square footage and cost for up to 10 rooms in the worksheet. (Even though the example has three rooms to be painted, your spreadsheet should be set up to handle up to ten rooms] e. Create a Total below the 10th room and sum the square footage and the cost per room to provide a total cost estimate for the job. 5. Test your spreadsheet using the following data (dimensions = L x W x H): Dining room: 18' x 15' x 10' Bedroom 1: 17' x 17' x 10' Bedroom 2: 10' x 14' x 8' Labor cost per square foot: $0.18 Paint cost per square foot: $0.14 a. Check Your Work: Square Ft. for Dining Room=930; Total cost based on the example above is $775.36 6. Use number formatting, alignment, and cell formatting options as appropriate to produce an attractive and easily understandable spreadsheet. 7. The cost of an additional room should be added automatically by entering a room name and appropriate dimensions. Don't worry if some formulas compute zero for now. Continued on next page 8. Format the sheet to print on 1 page. Place your name in the left portion of the header and use the filename tool in the right portion of the header. Set page orientation which best fits your spreadsheet (Portrait or Landscape). 9. Add one more room with the following information: a. Study: 12' x 10' x 8' [Overall total cost = 926.40] 10. Save the file & close Excel: Save the file (with the latest changes). Then submit the completed file to the assignment page in Canvas. Course Objectives: Text Reference: Problem Source: 2.1; 2.2; 2.4; 4.1 Excel tutorials 1-2 Succeeding in Business with Microsoft Excel 2007, page 278 I J K L M N o P. Q R S T U V W X Y z AA AB AC AC WN - OOOOOOO A B E F 1 Painting Estimate Sheet Paint cost per Sq. Ft. 0.14 Labor cost per Sq. Ft. 0.18 Squar Total 4 Room Length Width Height Cost 5 Dining room 18 15 10 930 = 6 Bedroom 1 17 17 10 969 7 Bedroom 2 10 14 8 524 8 9 0 10 11 12 13 14 15 Estimat 2423 $ 16 17 18 19 20 21 22 23 COUNT VS COUNTA- based on the instructions provided, which 24 function as used provides an accurate count of the rooms being 25 painted? 26 Canswer here> 27 28 29 Documentation Estimate - + Classroom Learning Activity 2 Painting Estimate (Part 1) Start-up Instruction: Download the starting file from the assignment page in Canvas to your computer Starting Filename: Blank_File.xlsx Submission Filename: uniquelD_Painting1.xlsx 1. a. c. This activity is the first in a sequence of two activities. Our ultimate goal is to prepare a worksheet that a painting contractor can use to estimate the cost of a painting job. Perform the Start-up Instruction. Extract the CLA02 folder from CLA02.zip and move the CLA2 folder to your M-Drive > CSE 148 > CLA folder. Then in your CLA02 folder, open Blank_File.xlsx and then select Save As..., and save the file as uniquelD_Painting1.xlsx. 2. Prepare a Documentation worksheet containing a title, author, date, and purpose of this worksheet 3. Create an Estimate worksheet to estimate the cost painting. 4. On the Estimate worksheet, provide: rows for up to 10 rooms that require painting. b. column headings to specify: the name of the room, the dimensions of the room in feet (length, width, and height), the square footage to be painted (computed from the dimensions - 4 walls and a ceiling), the labor cost per square foot, the paint cost per square foot and the total cost per room computed from the labor and paint cost per square foot. [Note: square footage (area) is NOT Length times Width times Height, that would be volume] Use the three sample rooms shown in the step below and enter the information into the spreadsheet. d. Use formulas for the square footage and the total cost per room columns so that the formulas for the first room can be copied to compute the square footage and cost for up to 10 rooms in the worksheet. (Even though the example has three rooms to be painted, your spreadsheet should be set up to handle up to ten rooms] e. Create a Total below the 10th room and sum the square footage and the cost per room to provide a total cost estimate for the job. 5. Test your spreadsheet using the following data (dimensions = L x W x H): Dining room: 18' x 15' x 10' Bedroom 1: 17' x 17' x 10' Bedroom 2: 10' x 14' x 8' Labor cost per square foot: $0.18 Paint cost per square foot: $0.14 a. Check Your Work: Square Ft. for Dining Room=930; Total cost based on the example above is $775.36 6. Use number formatting, alignment, and cell formatting options as appropriate to produce an attractive and easily understandable spreadsheet. 7. The cost of an additional room should be added automatically by entering a room name and appropriate dimensions. Don't worry if some formulas compute zero for now. Continued on next page 8. Format the sheet to print on 1 page. Place your name in the left portion of the header and use the filename tool in the right portion of the header. Set page orientation which best fits your spreadsheet (Portrait or Landscape). 9. Add one more room with the following information: a. Study: 12' x 10' x 8' [Overall total cost = 926.40] 10. Save the file & close Excel: Save the file (with the latest changes). Then submit the completed file to the assignment page in Canvas. Course Objectives: Text Reference: Problem Source: 2.1; 2.2; 2.4; 4.1 Excel tutorials 1-2 Succeeding in Business with Microsoft Excel 2007, page 278 I J K L M N o P. Q R S T U V W X Y z AA AB AC AC WN - OOOOOOO A B E F 1 Painting Estimate Sheet Paint cost per Sq. Ft. 0.14 Labor cost per Sq. Ft. 0.18 Squar Total 4 Room Length Width Height Cost 5 Dining room 18 15 10 930 = 6 Bedroom 1 17 17 10 969 7 Bedroom 2 10 14 8 524 8 9 0 10 11 12 13 14 15 Estimat 2423 $ 16 17 18 19 20 21 22 23 COUNT VS COUNTA- based on the instructions provided, which 24 function as used provides an accurate count of the rooms being 25 painted? 26 Canswer here> 27 28 29 Documentation Estimate - +