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