Program Name Auto Body Mechanics Automotive Service Technology Business Intelligence Business Management Business Technology Systems CAD/Drafting CNC Machining Computer Science Construction Management Cosmetology Culinary Arts Database Management Dental Hygiene Diesel Mechanics Digital Filmmaking Early Childhood Education Emergency Medical Technician Fire Science Graphic Design Horticulture Hospitality & Tourism Interior Design Marketing Medical Assisting Medical Laboratory Technology Medical Transcription Multimedia Network Support Nursing Paralegal Para-Professional Accounting Police Science Programming Social Services Technical Support Ultrasound Technology Web Marketing Welding Fabrication and Maintenance X Ray Technology Division Industrial Industrial Technology Business Technology Industrial Industrial Technology Industrial Social Science Social Science Technology Science Industrial Technology Social Science Science Social Science Technology Science Social Science Social Science Business Science Science Science Technology Technology Science Social Science Business Social Science Technology Social Science Technology Science Technology Industrial Science Program Program Credit Preview Hours Days Time Room 90 F 0900-1200 WC300 30 TR 0100-0400 CC607 60 M 0100-0400 EC101 45 M 0100-0400 CC607 90 F 0900-1200 CC607 30 TR 0100-0400 EC101 90 W 0100-0400 EC101 30 M 0100-0400 WC300 90 W 0900-1200 WC300 90 W 0900-1200 EC101 30 F 0900-1200 CC607 30 W 0900-1200 EC101 30 TU 0900-1200 EC101 90 F 0100-0400 WC300 45 TR 0100-0400 CC607 30 M 0100-0400 CC607 90 W 0900-1200 CC607 30 M 0100-0400 EC101 30 TR 0900-1200 CC607 45 M 0100-0400 EC101 30 TU 0900-1200 EC101 90 W 0900-1200 EC101 30 M 0900-1200 EC101 45 W 0900-1200 EC101 45 TU 0100-0400 CC607 90 TR 0900-1200 EC101 30 W 0100-0400 WC300 90 M 0100-0400 WC300 90 M 0100-0400 CC607 90 TU 0100-0400 WC300 90 F 0900-1200 CC607 90 M 0900-1200 CC607 90 M 0900-1200 WC300 45 TR 0100-0400 CC607 90 M 0100-0400 EC101 90 M 0100-0400 EC101 30 T 0100-0400 EC101 30 W 0100-0400 CC607 90 W 0100-0400 CC607 Seats 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 Enrolled 8 20 7 10 20 6 11 14 7 10 11 10 20 6 11 16 14 13 10 20 16 14 12 7 21 8 12 8 20 15 10 15 11 11 6 11 13 10 21 Campus MAIN WEST MAIN MAIN MAIN WEST EAST MAIN EAST MAIN MAIN EAST MAIN MAIN MAIN MAIN MAIN EAST WEST MAIN MAIN EAST MAIN WEST MAIN WEST EAST MAIN MAIN MAIN MAIN MAIN EAST MAIN EAST MAIN MAIN WEST MAIN Program Chair Wilson, James Moore, Joshua Davidson, Jeffrey Patel, Ankara Lui, Marcia Powell, Josh Patel, Ankara Davidson, Jeffrey Hernandez, Javier Oden, Sandra Santos, Lupe Carlton, Elkis Reid, Jonathon Weiss, Rachael Boyum, Bill Thompson, Seth Anderson, Nina Astor, Linda Thomas, Donnielle Patel, Ankara Sarto, Barbara Reid, Jonathon McIntrye, Alice Ricciardo, George Zelnik, Caryn Rodgers, Adam Walsh, Sam Davidson, Jeffrey Anderson, Nina Matthews, Christina Dahl, Ruth Desprez, Joan Davidson, Jeffrey Philips, Michael Davidson, Jeffrey Davidson, Jeffrey Thomas, Donnielle Hiltz, Rick Weinstein, Jacob Course Delivery Mode Program No. 57836 14386 77622 111853 47593 303033 97826 36978 57823 48539 19375 782145 47523 12968 74625 32699 55812 65377 25436 54896 48539 19231 43655 65485 85234 201154 13258 Program Para-Professional Accounting Business Management Marketing Medical Assisting Horticulture Medical Transcription Nursing X Ray Technology Ultrasound Technology Dental Hygiene Medical Laboratory Technology Emergency Medical Technician Business Technology Systems Technical Support Network Support Programming Computer Science Business Intelligence Database Management Multimedia Web Marketing Digital Filmmaking Graphic Design Auto Body Mechanics Construction Management Welding Fabrication and Maintenance Diesel Mechanics Division Business Business Business Science Science Science Science Science Science Science Science Science Technology Technology Technology Technology Technology Technology Technology Technology Technology Technology Technology Industrial Industrial Industrial Industrial Division Office A242 A242 A242 L100 L100 L100 L100 L100 L100 L100 L100 L100 N250 N250 N250 N250 N250 N250 N250 N250 N250 N250 N250 C220 C220 C220 C220 Primary Delivery Mode Online Hybrid Online Online Classroom Online Classroom Classroom Classroom Classroom Classroom Classroom Online Classroom Classroom Online Online Online Online Online Online Online Online Classroom Classroom Classroom Classroom Secondary Delivery Mode Classroom Online Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Hybrid Online Online Hybrid Classroom Classroom Hybrid Hybrid Hybrid Hybrid Classroom Classroom Classroom Classroom Classroom Number of Students 48 69 35 22 18 28 60 60 60 60 41 26 112 31 36 42 21 19 25 40 44 21 35 20 36 15 15 Program Chair Stipends Program No. 13258 14386 46395 65485 85234 57823 77622 47593 65122 54896 57836 74625 303033 97826 36978 18884 48539 19375 782145 201154 85249 111853 18466 54887 21987 28965 19375 124596 47523 12968 48752 32699 55812 65377 25436 54896 48539 19231 43655 Program Diesel Mechanics Business Management Early Childhood Education Auto Body Mechanics Construction Management Ultrasound Technology Marketing Horticulture Automotive Service Technology Hospitality & Tourism Para-Professional Accounting Network Support Medical Transcription Nursing X Ray Technology CAD/Drafting Dental Hygiene Medical Laboratory Technology Emergency Medical Technician Welding Fabrication and Maintenance Culinary Arts Medical Assisting Fire Science Police Science Cosmetology Interior Design Paralegal Social Services Business Technology Systems Technical Support CNC Machining Programming Computer Science Business Intelligence Database Management Multimedia Web Marketing Digital Filmmaking Graphic Design Division Industrial Business Social Science Industrial Industrial Science Business Science Industrial Social Science Business Technology Science Science Science Industrial Science Science Science Industrial Social Science Science Social Science Social Science Social Science Social Science Social Science Social Science Technology Technology Industrial Technology Technology Technology Technology Technology Technology Technology Technology Program Chair Stipend $7,500 $7,500 $6,000 $3,000 $3,000 $7,500 $7,500 $6,000 $7,500 $4,500 $7,500 $7,500 $6,000 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $3,000 $6,000 $4,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 Grader - Instructions Excel 2019 Project Excel_5F_Career_Programs Project Description: In this project, you will you will edit a worksheet, with data that has been sorted, filtered, and grouped that analyzes Delivery Modes for programs at Laurel College. Steps to Perform: Step Points Possible Instructions 1 Open the Excel workbook Student_Excel_5F_Career_Programs.xlsx downloaded with this project. 0 2 On the Main-East-West worksheet, insert a table using the range A1:J40. Display the Table Styles gallery, and then under Light, in the last row, apply the first style. 10 3 Sort the table by Campus using a Custom List in the following order: MAIN, EAST, WEST. (Mac users, create the custom list in the Excel, Preferences, Custom Lists dialog box.) Add a second level sort by Division and a third level sort by Program Name both in ascending order. 10 4 Display the second worksheet, Delivery Mode Comparison. Copy the range A6:G7, and then Paste the range to cell A1. Change the title in cell A1 to Criteria and then select the range A2:G3 and name it Criteria. 10 5 Copy the range A1:G2, and then Paste the range to cell A36. Change the title in cell A36 to Online-Hybrid Delivery Modes and then select the range A37:G37 and name it Extract Select the range A7:G34, and then name this range Database 15 6 Create an advanced filter that will place in the Extract area the records from the Database range in which Online is the primary delivery mode and Hybrid is the secondary delivery mode. 12 7 Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend. 10 8 Apply subtotals to the Program Chair Stipend column at each change in Division. AutoFit columns C: D and then collapse the outline so that the Level 2 summary information is displayed. 20 9 Group all three worksheets. Insert a footer in the left section that includes the file name, and in the right section, insert the Sheet Name. Center the worksheets Horizontally, and then set the Width and Height to 1 page. 9 10 Display the workbook Properties. As the Tags, type career programs and as the Subject, type your course name and section number. 4 11 Save and close the file, and then submit for grading. 0 Total Points Created On: 08/23/2019 1 100 GO19_XL_CH05_GRADER_5F_HW - Career Programs 1.0 Criteria 11 Program Chair Stipends 1 mom 1 W 1 1 8 Apply subtotals to the Program Chair Stipend column at each change in Division. AutoFit columns C: D and then collapse the outline so that the Level 2 summary information is displayed 5.5 20 Blank row [46] was not detected in the submission. Engine reported the failure as 'In the Cell 'D46' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,D35:D45)'.' 0 2 Blank row [47] was not detected in the submission. Engine reported the failure as 'In the Cell 'D47' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,D3:D45)':' 0 2 In the Cell 'D6' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,D3:05)'. 0 0 2 Blank row [46] was not detected in the submission. Engine reported the failure as 'In the Cell 'D46' of Sheet 'Stipends by Division', the 'Formula Result Value' was not set to '82500'' 0 0.5 In the Cell 'D14' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,07:D13)'. 0 2 Blank row [47] was not detected in the submission. Engine reported the failure as 'In the Cell 'D47' of Sheet 'Stipends by Division', the 'Formula Result Value' was not set to 267000'.' 0 0.5 In the Cell 'D24' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,D15:D23)'. 0 2. In the Cell 'D34' of Sheet 'Stipends by Division', the 'Formula' was not set to 'SUBTOTAL(9,D25:D33)'. 0 2. In the Cell 'D6' of Sheet 'Stipends by Division', the 'Formula Result Value' was not set to "22500'. o 0.5 In the Cell 'D14' of Sheet 'Stipends by Division', the 'Formula Result Value' was not set to "39000'. 0 0 0.5 In the Cell(s) 'D34' of Sheet 'Stipends by Division', the 'Formula Result Value' was not set to '61500'. 0 0.5 7 Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend. 0 10 Sorting condition(s) was not detected in the submission. Engine reported the failure as 'For the 'Sort Level 1' in Sort Range 'A3:D45', the 'Sort By' was not set to 'Column C. o 0 1.666 Sorting condition(s) was not detected in the submission. Engine reported the failure as 'For the 'Sort Level 2' in Sort Range 'A3:D45', the 'Sort By' was not set to 'Column D'' o 0 1.667 Sorting condition(s) was not detected in the submission. Engine reported the failure as 'For the Sort Range 'Sort Level 1','Sort Level 2' in Sort Range 'A3:D45', the 'Sort On' was not set to "Value'' 0 0 3.334 Sorting condition(s) was not detected in the submission. Engine reported the failure as 'For the Sort Range 'Sort Level 1' in Sort Range 'A3:045', the 'Order' was not set as per the instruction.' a 0 1.666 Sorting condition(s) was not detected in the submission. Engine reported the failure as 'For the Sort Range 'Sort Level 2' in Sort Range 'A3:045', the 'Order' was not set as per the instruction.' 0 1.667
Purchase answer to see full attachment