USA: +1(669)289-8683 
Sign in
YO16_AC_CH01_GRADER_PC_HW_Instructions x
Office 2016 – myitlab:grader – Instructions Your Office – Access Chapter 1: Prepare Case
YO16_AC_CH01_GRADER_PC_HW – Red Bluff Golf Course Putts for Paws Charity Tournament
Project Description:
The Red Bluff Golf Course and Pro Shop is sponsoring a charity tournament, Putts for Paws, to raise money for the Santa Fe Animal Center. An intern created a database to help run the tournament but did not finish it before leaving. You have been asked to finish the database to track the participants who enter the tournament, the orders they have placed, and the items they have purchased.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Access. Open the downloaded file named a01ch01_grader_pc_Putts.accdb. Save the file with the name a01ch01_grader_pc_Putts_LastFirst, using your last and first name. If necessary, enable the content. 0
2 Import the tblParticipant table from the a01ch01Participant.accdb Access database. 15
3 Edit the first record in the tblParticipant table so that the LastName field is Student and the FirstName field is Access. 7
4 Add a new record to the append row of the tblParticipant table using the following data. ParticipantID 30 LastName Fox FirstName Jeff StreetAddress 1509 Las Cruces Drive City Las Cruces State NM ZipCode 88003 ContactPhoneNumber 5055558786 CorporatePhoneNumber (leave blank) Close the tblParticipant table. 10
5 Use the Query Wizard to select the following fields from tblParticipant (in this order): LastName, Firstname, and City. Save the query as qryParticipantSantaFe. 7
6 Switch to Design View of qryParticipantSantaFe and type Santa Fe in the criteria row of the City field. 6
7 Sort the results of the query by LastName in ascending order and then by FirstName in ascending order. Run the query. 7
8 Create a form using the tblParticipant table and save it as frmParticipant. 10
9 Edit the title to be Participant Form and then save the form. 8
10 Add a new record to tblPartcipant using the form and the following data. ParticipantID 31 LastName Silva FirstName Jackson StreetAddress 1509 Main Street City Santa Ana Pueblo State NM ZipCode 87044 ContactPhoneNumber 5055553355 CorporatePhoneNumber (leave blank) Close the form. 10
11 Use the Report Wizard to create a report displaying the following fields from tblParticipant (in this order): LastName, FirstName, City, and ContactPhoneNumber. Group the participants by City, sort the participants by LastName and then by FirstName in ascending order. Display the report with a stepped layout and portrait orientation. Save the report as rptParticipantsByCity. 15
12 In Layout view, drag the left border of the ContactPhoneNumber heading to the left until the entire column heading is visible. Edit the title of the report to be Tournament Participants By City.
Save and close the report. 5
13 Close the database, exit Access, and then submit your file as directed by your instructor. 0
Total Points 100
Updated: 03/30/2016 1 YO16_AC_CH01_GRADER_PC_HW_Instructions x
Nyarko_a01ch01_grader_pc_Putts.accdb
ID mSysRowId
1 6Ha/JPf1QQElROn3o1RCOL7x3LGPT8fuGv58zijYNBk=-~jvYZopfcyJoq7i2boj5pYg==
ItemID Itemdescription QuantityAvailable AmountToBeCharged Notes mSysRowId
CART Cart sponsor 40 ¤ 2,000.00 Logo or brand displayed on cart DTj3oZusDSoLk+Sp2xDL+nB0GdpVKJWBNsecPFiFrfM=-~ZmeqCzHJkGn2d+uhmVfxpQ==
CTEAM Golfers – corporate team of four 10 ¤ 850.00 Includes hole sponsorship STdKA9WGFM/u3onmeuLaDtIpa7VbgC+4wWXb4q1GnnI=-~PwNrzKCAuLT3y0clrdlifg==
FLAG Flag sponsor 18 ¤ 500.00 Logo or brand displayed on flagstick rbWiaE4Edr6iWWnmTveqi3lw+riPMTfHou63i9ww8iU=-~1z3g5RrQJPTG6VoG3Fp8Ag==
G1 Golfer – one 100 ¤ 200.00 V+EyuWce1Hb9AXCE7cCmUEdIt1ZjAI8Mk0AZgubTYoE=-~8xaiD2Y77MZ8bgbov0/+Cw==
HOLE Hole sponsor 18 ¤ 500.00 Logo or brand displayed on hole sgFvpbnFIsYUvgo+JuVjKLunnVIzCnF4xulRrXHYACQ=-~HxdFVRgbvsXsJGPeDFI1nw==
TEAM Golfers – team of four 10 ¤ 550.00 37QvRS/UHaplh+TsTh5amk45AwFvDzNzuN5giWNgqsg=-~vmErpIyCKJQMN/MTCZAMiQ==
OrderID AmountPaid MethodOfPayment ResortRoomNumber ParticipantID mSysRowId
1 ¤ 2,550.00 CC 2 Uf7DNrskeGwSM8W0j1mbxv4UuimTeqGOf500yU1iNc4=-~15w0v5JLO+KBgyLSuvr4NA==
2 ¤ 2,000.00 CC 3 cufUvisoExr5dGguo9Wntvpdg3cCl97fdrHwHtgNNMs=-~697M2T2JjnhRCuS/9IiDcw==
3 ¤ 1,000.00 CC 17 5o2XrFMlx/XP6sAKJdEv3rbtjEzfWIoPdtpPsdxZM7A=-~pPXS1tZxrPfak/9aRrNiAQ==
4 ¤ 2,850.00 CC 5 ypGKbgU1sODxMbjl4/gIuWr38PYjZ/WbCpzD+Cxo0oc=-~Xjv8YbypWc5c9tsjzc5yLg==
5 ¤ 400.00 ROOM 217 24 rI+IZ6LB3nJ/AVYHDCjEg8w+6Gtf3mP8S4jHNDDy9kw=-~4M1uBDdpiEBUD0t8tz8wSQ==
6 ¤ 200.00 CC 29 I75zzeMJlioWhZYwuh2z+JQyqVJYO6JiTAYrZCvD8j8=-~+hzJ3b44/oLMWzX8+wSiNQ==
7 ¤ 3,000.00 CC 15 Amm94QET7so33GsijQMHxneFjuA1ZWxh+grS7lW/9Vg=-~8ljdaeV4odbVzzvIqyviaQ==
8 ¤ 550.00 ROOM 283 9 1v9R/lS/fs/gCjZNRzUrcCiOd4X3FSiz/bxU6nHRtPc=-~2FEwmaZBrcjopMAI7M00ow==
9 ¤ 0.00 16 7f0skhMgHTCcuu4IdR9L+O6siYJmumyE7UaBkmFN48s=-~p7ysZvtw1t9vc/Xqg19Zng==
10 ¤ 0.00 8 jqtJU6RV9KKkc3K/IS/WrZK4yF44MI/zxIRpghhqPp0=-~7tsKQzFnAWUFFcUhEVNGWQ==
11 ¤ 850.00 CC 19 0DycA8wicmR0bS1vhCRpljqnNQJh13+Ds8ifmxRKFeM=-~KqsziDcYqgAq2mZxG2PJHQ==
OrderID LineNum ItemID Quantity mSysRowId
1 1 CART 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
1 2 TEAM 1 zKKkIVnwTrWnxpga6EhDYBD1d1W47obIo50J1h0pHbw=-~Otv0q8yit8ldxnklTkNN/A==
2 1 CART 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
3 1 FLAG 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
3 2 HOLE 1 zKKkIVnwTrWnxpga6EhDYBD1d1W47obIo50J1h0pHbw=-~Otv0q8yit8ldxnklTkNN/A==
4 1 CTEAM 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
4 2 CART 1 zKKkIVnwTrWnxpga6EhDYBD1d1W47obIo50J1h0pHbw=-~Otv0q8yit8ldxnklTkNN/A==
5 1 G1 2 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
6 1 G1 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
7 1 CART 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
7 2 HOLE 1 zKKkIVnwTrWnxpga6EhDYBD1d1W47obIo50J1h0pHbw=-~Otv0q8yit8ldxnklTkNN/A==
7 3 FLAG 1 QPnYhJvhPJloUQmevS8X5srKxWhumZgXZEwnh7RNshQ=-~9uXaDCKFlVySqNf68N3mpA==
8 1 TEAM 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
9 1 G1 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
10 1 G1 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
11 1 CTEAM 1 6HKyoPo26rHQZMivsvQ0MQdK/4tzKTiaqHNOMgcSTfQ=-~piM3Ip8goYKZrJt/FxBEDw==
SELECT DISTINCTROW *
FROM TblItem;
SELECT DISTINCTROW *
FROM TblOrder;
SELECT TblOrder.OrderID, TblOrder.AmountPaid
FROM TblOrder
WHERE (((TblOrder.AmountPaid)>1000));
a01ch01Participant.accdb
ParticipantID LastName FirstName StreetAddress City State ZipCode ContactPhoneNumber CorporatePhoneNumber
1 Last First 1563 Catalina Dr Santa Fe NM 87508 5055551754
2 Trujillo John 427 Kanengiser Rd Santa Ana Pueblo NM 87045 5055558217
3 McShane Ian 823 4th St NW Albuquerque NM 87106 5055554149 5055551800
5 Fresquez Marge 534 Asiento Blvd Pueblo NM 81232 5055553800 5055551111
8 Maestas Marcus 83 Vuelta Rancho Santa Fe NM 87508 5055552525
9 Marquardt Keith 228 E Alejo Rd Palm Springs CA 92262 7605554836
11 Neidhart Kate 54 E Dona Rosa Tr Las Vegas NM 87701 5055554103 5055551800
15 Reed Thomas 743 Windstone Dr. Albuquerque NM 87105 5055557943 5055552000
16 Reid Cynthia 158A Calle Derecho Las Vegas NM 87701 5055550247
17 Andrews Joseph 819 Calle Don Roberto Santa Fe NM 87502 5055553242
19 Sanchez Ricardo 158 Tesuque Village Rd Agua Fria NM 87507 5055556243 5055551111
20 Sanchez Julie 158 Tesuque Village Rd Agua Fria NM 87507 5055556243 5055551111
21 Schilling John 15365 Sombra Del Monte Santa Fe NM 87508 5055559244
24 Thomas Joe 4355 Celsior St Brougham CA 92267 7605553227
26 Trent Eileen 433 Tortuga Ln Las Cruces NM 88003 5055554101 5055551111
27 Brevard Jacque 23 Calle Montoya Bernanillo NM 87001 5055551828 5055551111
29 Winston Mary 157 Green Galliard Rd Agua Fria NM 87506 5055551756
YO16XLCH05GRADERPS1HW_-_University_Call_Center_13_Instructions x
Office 2016 – myitlab:grader – Instructions Excel Project
YO16_XL_CH05_GRADER_PS1_HW – University Call Center 1.3
Project Description:
The University’s call center needs a workbook developed that will use data to analyze the performance of the call center. The call center contacted your professor and she recommended you for the task. The workbook will set up a variety of tools that will help assess the efficiency of the center and its staff. Your will develop a workbook for the call center manager that will help with the center’s data analysis.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Excel. Open the downloaded Excel file named e03ch05_grader_h1_CallCenter.xlsx. Save the file with the name e03_grader_h1_CallCenter_LastFirst, using your last and first name. 0.000
2 On the Lists worksheet, create the following named ranges to use within formulas:
A2:A6 as Department
A14:B18 as GradeScale
B9:H9 as DayofWeek
Select the range E1:I5, and create named ranges using the top row as the range values. 4.000
3 Select the CallData worksheet. In cell A9, format the data as an Excel table with headers using the current data set. Apply White, Table Style Light 1.
In cell H9, type Issue as the field label.
In cell I9, type Grade as the field label.
In cell J9, type Weekday as the field label.
Note, depending upon the Office version used, the table style name may be Table Style Light 1. 9.000
4 On the CallData worksheet, select range A9:J128, and then name the entire data set, including the labels, as CallDataAll. Next, create named ranges using the top row as the range values.
6.000
5 In cell H10, enter an INDEX function that will use a nested INDIRECT reference to the Dept named range listed in column C (C10), and use the Reason field in column B (B10) as the row number to return for the department name in the referenced named range.
Nest the function inside an IF function so that issues currently displaying as a 0 will display as a blank cell. Resize the column width as needed. 4.000
6 In cell I10, enter a VLOOKUP function that will convert the Satisfaction Rating to a grade found in the second column of the GradeScale named range. The formula is not looking for an exact match.
4.000
7 In cell J10, enter an INDEX function that will convert the Call Day to the actual weekday found in row 1 of the DayofWeek named range. Resize the column width as needed. 4.000
8 On the CallData worksheet:
In cell C2, type Public_Affairs
In cell G2, type Y
Run an advanced filter on the table data set using the criteria range A1:J2. 2.000
9 On the CallCenterReport worksheet, add formulas that will summarize the issues for the department entered in cell B3.
In cell B6, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9. 4.000
10 In cell C6, add a COUNTIFS function that will count the number of departments on the CallData worksheet. Use the Dept named range as criteria_range1, and then use an absolute reference to B3 as criteria1. Use the Reason named range as criteria_range2, and then use cell A6 as criteria2. Copy the formula down to cell C9. 4.000
11 In cell D6, add a COUNTIFS function that will count the number of calls coming from the department listed in B3. Use the Dept named range as criteria_range1, and then use an absolute reference to B3 as criteria1. Use the Reason named range as criteria_range2, and then use cell A6 as criteria2. Use the On_Hold named range as criteria_range3, and then use “Y” as criteria3. Copy the formula down to cell D9. 4.000
12 In cell E6, add an IF statement with a nested AND that will enter a status notice. If the number of calls on issue in cell C6 is greater than 3 and the number of calls on hold in cell D6 is greater than 2, then “Check Hold Issue” should display. Otherwise, nothing should display. Copy the formula down to cell E9. 4.000
13 In cell B12, add an AVERAGEIF function that will find the average call length for the Dept named range and the criteria specified in cell A12.
In cell C12, add a COUNTIF function that will count the number of calls for the Dept named range and the criteria specified in cell A12.
8.000
14 In cell D12, add a formula that sums two COUNTIFS formulas. The first COUNTIFS will count the number of calls associated with the Dept named range and criteria specified in cell A12 that received a grade F, and the second COUNTIFS will do the same for grade D. 4.000
15 In cell E12, add an IF statement using a nested OR function that will return any notes associated with the issue. If there are more than 10 issues reported with a grade below a C in cell D12, or when the number of scores less than C divided by the total calls in cell C12 is greater than 50%, then “Explore Issues” should display. Otherwise, the result will be blank. Copy the formulas in B12:E12 down through row B16:E16. 4.000
16 In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range.
In cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match. 8.000
17 In cell H13, add an INDEX function that will pull the satisfaction rating associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length range with an exact match. 4.000
18 On the CallCenterReport worksheet, in cell G19, type Y. In cell J19, type Friday. Name the range A18:J19 Call_Criteria.
In cell B22, add a DCOUNT function for the CallDataAll database to find the count of the satisfaction rating currently listed in cell B21 using the Call_Criteria named range. 7.000
19 In B23:B26, add database functions that find the DAVERAGE (B23), DSUM (B24), DMAX (B25), and DMIN (B26) for the CallDataAll named range. Use named ranges in the formulas.
Select the cell range B22:B26, and then copy the formulas to column C. 16.000
20 Save the workbook, exit Excel, and then submit your file as directed by your instructor. 0.000
Total Points 100.000
Updated: 10/17/2017 1 Current_Instruction x
Nyarko_e03ch05_grader_h1_CallCenter.xlsx
CallData
Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold Issue Grade Weekday
Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold
8 2 Accounting 6 4.5 4 Y
16 1 Public_Affairs 6.7 3.7 5 Y
15 2 Accounting 5.5 5.9 1 N
3 1 Public_Affairs 3.7 9.2 2 N
21 1 Admissions 6.5 5.9 1 N
15 3 Public_Affairs 8.8 6 3 N
22 1 Human_Resources 6.3 6.4 4 N
12 2 Admissions 2 7.2 2 Y
19 3 Accounting 5.4 7.6 6 N
15 1 Financial_Aid 5.9 4.2 5 Y
19 1 Public_Affairs 3.3 9.2 3 N
14 2 Accounting 4.9 5.1 3 N
12 4 Public_Affairs 4 5.9 5 N
20 2 Public_Affairs 4.3 8.2 2 N
14 2 Public_Affairs 5.3 6.7 5 N
11 2 Public_Affairs 5.1 6.8 5 N
15 1 Admissions 3.5 6.5 2 Y
16 1 Admissions 5.4 8.4 6 N
10 2 Public_Affairs 3.6 6.8 5 Y
15 2 Admissions 7.2 4.2 7 Y
1 2 Public_Affairs 3.3 9.9 7 N
9 3 Admissions 6.3 8.3 6 N
13 2 Public_Affairs 2.6 6.5 4 Y
20 3 Admissions 7.2 6.6 5 N
17 2 Admissions 1.8 7.5 2 N
11 1 Admissions 2.5 8.3 1 N
14 2 Admissions 4.7 6.6 2 N
17 3 Public_Affairs 7.6 5.3 3 N
21 1 Financial_Aid 5.7 5.4 7 Y
16 1 Public_Affairs 3 6.7 5 Y
2 1 Admissions 3.7 9.4 4 N
13 1 Accounting 1.5 7.8 1 N
11 3 Public_Affairs 3.3 9.3 1 N
18 3 Admissions 4.4 5.4 5 Y
20 2 Accounting 5 4 1 Y
23 2 Public_Affairs 3.2 8 3 Y
8 1 Public_Affairs 4.5 4.9 5 Y
8 2 Admissions 8.1 4.1 4 Y
5 1 Human_Resources 6.5 6.2 4 N
21 1 Public_Affairs 5.7 8.5 6 N
20 2 Admissions 4.5 5.6 7 N
19 3 Admissions 4.8 9 2 N
4 1 Admissions 5.9 8.2 4 N
22 2 Admissions 4.4 4.5 7 Y
20 1 Public_Affairs 3.2 9.4 7 N
20 3 Admissions 4 3.8 3 Y
16 4 Financial_Aid 4.9 6.5 2 N
11 1 Public_Affairs 5.7 6.2 5 Y
7 2 Public_Affairs 5 9.9 5 N
12 2 Public_Affairs 4.6 8.8 4 N
16 1 Financial_Aid 3.5 8.3 1 N
20 2 Public_Affairs 5.7 7.1 1 N
14 4 Admissions 4 6.1 2 N
12 1 Admissions 3.1 9.6 5 N
6 2 Admissions 3.5 10 7 N
17 2 Admissions 2.7 8.1 1 N
21 2 Human_Resources 5 5 7 Y
6 4 Admissions 2.7 7.7 3 N
20 2 Public_Affairs 6.1 6.7 6 N
20 1 Admissions 6 4.4 1 Y
22 2 Public_Affairs 4.7 8.1 3 N
3 1 Public_Affairs 5.3 5 4 Y
9 1 Admissions 3.4 8.9 6 N
13 2 Accounting 4.9 6.3 2 Y
23 1 Accounting 5.5 7.2 3 N
24 2 Admissions 4.5 7.1 3 N
10 3 Admissions 7.3 3.8 6 Y
20 4 Human_Resources 4.5 6.5 1 N
9 3 Human_Resources 5.8 4.9 2 Y
14 2 Accounting 4.2 7.6 3 N
11 1 Human_Resources 3.8 10 5 N
18 2 Public_Affairs 4.5 8.1 2 N
20 2 Admissions 3.5 10 2 N
6 2 Accounting 1.4 9.5 4 N
6 2 Admissions 3.8 10 2 N
13 1 Accounting 4.5 6.1 2 N
21 1 Accounting 4.6 6.8 3 N
23 1 Admissions 4.5 6.6 5 Y
10 1 Admissions 2.6 7.3 4 Y
19 1 Public_Affairs 6.3 7.7 1 N
13 3 Admissions 1.3 8.8 4 N
18 2 Human_Resources 4.9 5.5 2 N
18 2 Human_Resources 4.8 5.4 6 Y
12 2 Accounting 3.9 8 1 N
19 2 Accounting 6.8 6.6 4 Y
11 1 Public_Affairs 6.2 8.7 7 N
4 4 Human_Resources 5 6.2 2 N
24 3 Human_Resources 2.4 8.1 6 N
21 2 Accounting 6.8 6 4 N
12 3 Human_Resources 3.1 8.3 6 N
14 2 Human_Resources 3.2 7.4 1 N
14 3 Admissions 7.8 6.9 1 N
9 3 Admissions 5.4 4.8 2 N
14 2 Public_Affairs 6.6 5.8 6 Y
12 3 Admissions 3.5 8.6 5 Y
19 3 Human_Resources 5.7 7.2 3 N
4 1 Public_Affairs 6.3 6.5 5 N
8 3 Admissions 8.3 6 6 N
7 2 Human_Resources 4 7.2 6 N
1 2 Human_Resources 4.8 7.7 4 N
11 1 Accounting 3.1 9.8 6 N
15 2 Accounting 5 4.6 3 Y
10 1 Public_Affairs 5.5 8.9 5 N
12 1 Admissions 5.2 5 7 Y
9 2 Public_Affairs 4.6 8.9 1 N
5 3 Admissions 2.2 7.3 1 Y
20 4 Accounting 6.1 7.8 6 N
24 1 Accounting 4.4 8.3 4 N
20 3 Admissions 6 4.7 5 Y
9 3 Financial_Aid 3.9 10 7 N
10 3 Accounting 5.2 7.2 2 N
14 2 Accounting 4.6 5.5 3 N
22 4 Accounting 6.5 8.3 3 N
15 3 Financial_Aid 7.1 5.1 1 Y
2 4 Financial_Aid 6.3 6.6 7 N
10 1 Admissions 4.5 8.5 4 N
2 1 Admissions 7.4 6.4 5 N
18 3 Financial_Aid 5.4 6.9 5 N
23 1 Financial_Aid 5.3 5 2 Y
&F
Lists
Department Public Affairs Human Resources Admissions Accounting Financial Aid
Public Affairs 1 Frozen screen Blackboard Banner Blackboard Internet
Human Resources 2 Voicemail Electrical Intranet Internet Blackboard
Admissions 3 Other Internet Blackboard Intranet
Accounting 4 Intranet Internet
Financial Aid
Day of Week Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Financial Aid
Satisfaction Rating Grade
0 F
4 D
6 C
8 B
9 A+
&F
CallCenterReport
Call Center Report
Department Financial_Aid
Your Office: Public_Affairs
Human_Resources
Admissions
Accounting
Financial_Aid
Student_Life
Issues # Calls on Issue # On Hold Status
1
2
3
4
Department Average Call Length Total Calls Below C Notes Longest Call
Public_Affairs Department
Human_Resources Score
Admissions
Accounting
Financial_Aid
Call Hour Reason Dept Call Length Satisfaction Rating Call Day On Hold Issue Grade Weekday
Satisfaction Rating Call Length
Count
Average
Sum
Max
Min
&F
