ISYS 363 – Excel Assignment

hhuegi

ISYS363Summer2020_ExcelAssignment.pdf

Home >Business & Finance homework help >Operations Management homework help >ISYS 363 – Excel Assignment

ISYS 363 – Excel Assignment Decision Support with Excel

Frank Perry Seminars

Summer 2020

DUE DATE: 7 / 0 1 / 2 0 2 0

Academic Integrity Policy: This is an individual assignment. Collaboration with another student is not allowed. Any sharing of work or factual data between

students is not permitted. Students violating this academic integrity policy will

receive zero points for this assignment, an “F” grade in ISYS 363, and will be

referred to the Office of Judicial Affairs. Project Objectives:

The purpose of this project is to perform an in-depth decision-making analysis of complex

and inter-related data using Microsoft Excel. The software we will be using for the Excel

assignment is Microsoft Excel 2010/2013/2016.

Project Background:

Frank Perry Seminars (FPS) is a national provider of professional seminars in technology, finance,

HR, accounting, and project management. The company strives to provide corporate and

individual clients with high-quality, convenient, current, and practical business-related training.

Over the past few years, FPS has seen steady growth in its business and has a reputation for

providing quality instructions to its clients. The company’s reputation is due in part to its ten

full- time, highly qualified instructors with practical knowledge of the topics they teach. The

instructors teach a variety of courses, ranging from productivity to certification courses. The

courses are typically one-week courses and are limited to 24 students per course. FPS offers its

courses on school campuses, at corporate sites, and other off-site locations.

As part of the company’s quality strategy, seminar students are asked to complete a customer

satisfaction survey upon the completion of their courses. These surveys are then reviewed by Dr.

Frank Perry, the founder of FPS, to ensure the quality of the courses, as well as the instructors.

Exhibit 1 shows a copy of the satisfaction survey.

Until now, Dr. Perry has just reviewed the survey data but had little time to analyze it. He

realizes that the surveys contain a wealth of information about his company’s training, and wants

to have a more in-depth analysis of the data with an Excel application. Dr. Perry hires you as a

consultant to develop a Perry Survey Results workbook that will enable him to enter and track

the results of the satisfaction surveys.

Once the surveys are collected by one of the staff members from FPS, Dr. Perry’s secretary will

code each survey respondent’s answers. For each question, the possible responses are given a

unique number. For example, if the respondent answers “No” for Question1, then the secretary

will record “1” in the worksheet cell. If the respondent answers “Yes” for Question 1, then “2” is

recorded in the worksheet cell. Exhibit 2 shows how the questionnaire responses are coded.

Your consulting assignment consists of several tasks, including the completion of an Excel

workbook (Perry Survey Results), containing multiple worksheets as per assignment

specifications detailed in this write-up. The purpose of the Perry Survey Results workbook is to

enter, track, and analyze customer satisfaction surveys for Frank Perry Seminars.

Dr. Perry hands you a copy of an incomplete workbook called Perry Survey (ISYS 363 Summer

2020_Excel Assignment_Data.xlsx). This workbook currently contains one worksheet (Initial

Data) with sample survey data. You are to use this data when designing the Perry Survey Results

workbook.

Columns A through E of the Initial Data worksheet provide general information about the

course. As the general information is readily available, it is not necessary to collect this

information from the survey respondent. Instead, the secretary enters the general course

information as she enters the respondent’s answers into the worksheet. Exhibit 3 explains the

codes for Columns A through E.

Columns F through M of the Initial Data worksheet contain data that have been captured on the

survey forms. The data displayed in these columns have been coded, meaning the survey

responses have been coded using the codes displayed in Exhibit 2. For example, if a student

circled “No” as her answer for Question 1 on the survey form, then a “1” is displayed in Column

F. Likewise, if a student circled “Yes” as her answer for Question 1, then a “2” is displayed in

Column F. (The codes help facilitate the analysis of the survey data).

Exhibit 1. Customer Satisfaction Survey

Perry Seminars Satisfaction Survey

1. Have you previously attended a seminar offered by Prior Seminars?

a. No b. Yes

2. Have you attended a seminar offered by another company?

a. No b. Yes

3. Overall, I am satisfied with the course.

Strongly Agree Agree Neutral Disagree Strongly Disagree

4. I will take another course with Prior Seminars.

Strongly Agree Agree Neutral Disagree Strongly Disagree

5. The information presented will be useful on my job.

Strongly Agree Agree Neutral Disagree Strongly Disagree

6. The instructor was knowledgeable about the subject matter.

Strongly Agree Agree Neutral Disagree Strongly Disagree

7. The seminar’s content was timely.

Strongly Agree Agree Neutral Disagree Strongly Disagree

8. The instructor met the stated course objectives.

Strongly Agree Agree Neutral Disagree Strongly Disagree

Exhibit 2. Customer Satisfaction Survey Codes

If Response Is: Code

No 1

Yes 2

Strongly Agree 5

Agree 4

Neutral 3

Disagree 2

Strongly Disagree 1

Exhibit 3. General Course Information Codes

Column Codes Explanation

A Uses the actual course number Contains the course number

B 1 = Client’s Site

2 = Perry Seminars

3 = Another Location

Specifies where the course was offered. The course can

be offered at the client’s

site, at Perry Seminars or

another location

C Uses the instructor’s identification

number

Specifies the instructor’s

identification number

D Uses the number of students enrolled in the class.

Specifies the number of

students enrolled in the class

(Note: Note all students

submit a survey)

E Uses the end date of the seminar Specifies the end date of the

seminar

Follow the tasks listed below to complete Excel Project.

Project Tasks:

UTask 1. Preparing for Excel Project.

Read through the instructions for the assignment.

UTask 2. Download the input file from iLearn

1) From iLearn, download the input file – ISYS 363 Summer 2020_Excel Assignment

Data.xlsx. This file is the starting point of your project, as it contains the initial survey data

you will use to create the new workbook for the assignment.

Task 3. Create a new Excel 2010/2013/2016 workbook

1) Create a new Excel workbook and title it myWorkbook.xlsx. This workbook will

contain multiple worksheets created in the subsequent tasks for this assignment. The

completed workbook will enable Dr. Perry to be more effective in evaluating his

company’s course offerings and instructor performance.

Task 4A Create a new Response worksheet in the workbook.

1) Create a new worksheet (titled Response) in the workbook (myWorkbook.xlsx) created in

Task 3. This worksheet will contain survey results for two weeks.

2) Copy data (from the Initial Data worksheet in ISYS 363 Summer 2020_Excel Assignment

Data.xlsx) and paste it into the Response worksheet. Format the Response worksheet by

including descriptive headings for each column and the following title: (note: The title

Survey Respon

dent

Course No.

Locati on

Instructor ID

Class Size

Seminar End Date

Question 1: PS

Attendance

Question 2:

Attended Another

Other columns

1 RTS1 1 3 30 04/14/2020 2 2 …

2 RTS1 1 3 30 04/14/2020 2 1 …

should be located above all descriptive headings. The title should not be placed in a Header

section, but directly onto the worksheet using the insert cells function (Right click the top-

most cell>Insert…>Entire row. Insert a row for each line.)

Frank Perry Seminars Consolidated Survey Results

For April 2020 (Two Weeks) 3) When the survey forms are returned from the survey respondents, Dr. Perry’s secretary

will code and enter the individual survey results into the Response worksheet. When

entering survey data into the Response worksheet, Dr. Perry wants the results for each

survey assigned a respondent number. This requires the insertion of a new (left-most)

column titled Survey Respondent into the Response worksheet. For example, for the first 20 surveys, the surveys would be numbered 1 through 20, respectively. For the next five surveys, they would be numbered 21 through 25, etc.

You are required to add a new column (left-most column) to the Response worksheet

and title it Survey Respondent; assign a unique value, starting at 1 and incremented by 1,

to each row of the new column to specify survey respondent number. Refer to the

Exhibit 4 for a fragment of a partial data sample in the Response worksheet after the

Survey Respondent column was added to the worksheet.

Exhibit. 4 Partial Sample of the left-most data in the Response worksheet.

(note: other columns of the Response worksheet are not displayed in Exhibit 4)

4) Add a new column (right-most column) to the Response worksheet and title the column

Attended a Seminar Before. (See Exhibit 5 for a fragment of a partial data sample in the

Response worksheet after the Attended a Seminar Before column was added to the

worksheet as the right-most column).

Exhibit. 5 Partial Sample of data in the Response worksheet.

Survey Respondent

Course No.

Question 1: PS Attendance

Question 2: Attended Another

Other columns

Attended a Seminar Before

1 RTS1 2 2 … 4

2 RTS1 2 1 … 3

(note: other columns of the Response worksheet are not displayed in Exhibit 5)

Attended a Seminar Before column must keep track of whether a given respondent

attended “both”, “either one”, or “neither one” of the seminars. The possible values

for this column are 2, 3, or 4. Do not enter these values manually! You must use an

Excel function to derive the column’s value for each row based on the following

rules:

a. If a respondent did not attend the Perry seminar AND did not attend a

seminar offered by another company, value 2 must appear in the Attended a Seminar Before column for the given row;

b. If a respondent attended the Perry seminar AND attended a seminar offered by another company, value 4 must appear in the Attended a Seminar Before column for the given row;

c. If a respondent attended the Perry seminar, BUT did not attend a seminar offered by another company, value 3 must appear in the Attended a Seminar Before column for the given row;

d. If a respondent did not attend the Perry seminar, BUT attended a seminar offered

by another company, enter value 3 in the Attended a Seminar Before column for the given row.

Question: As you review Exhibit 5, why is there a value of 3 in the Attended a

Seminar Before column for Survey Respondent #2?

Answer: The code for “Question # 1 PS Attendance” is “1”, which means (see

Exhibit 2 for survey codes) that the respondent DID NOT attend the PS seminar;

furthermore, the code for “Question #2 Attended Another” is “2”, which means that

the respondent attended Another Seminar; thus, according to the rule d (listed

above), the value of 3 must be computed (hint: use SUM function in Excel) in the

Attended a Seminar Before column for the second row (i.e., Survey Respondent #2).

Next, you should use an Excel function to compute the values of the Attended a Seminar

Before column for each and every row in the Response worksheet.

Task 4B. Add results of four additional surveys to Response Worksheet.

Exhibits 6, 7, 8 and 9 provide the results of four additional surveys. Enter the results for EACH

survey at the end of the Response worksheet. You will need to code the response data for

Questions 1 – 8 using the survey codes in Exhibit 2. (The answers for each survey question on

Exhibits 6, 7, 8 and 9 are underlined and are in bold red text). Other information for each of the

four surveys is provided below.

1) For the survey in Exhibit 6, use the following information for the Response worksheet:

• Survey Respondent: 282

• Course No: RTS6

• Location: 3

• Instructor Id: 2

• Class Size: 18

• Seminar End Date: 04/21/2020

• Questions 1 – 8: See codes in Exhibit 2. • Attend a Seminar Before: Derive a value as per Task 4A-4

(use Excel function) 2) For the survey in Exhibit 7, use the following information for the Response worksheet:

• Survey Respondent: 283

• Course No: RTS8

• Location: 1

• Instructor Id: 5

• Class Size: 15

• Seminar End Date: 04/21/2020

• Questions 1 – 8: See codes in Exhibit 2.

• Attend a Seminar Before: Derive a value as per Task 4A-4 (use Excel function)

3) For the survey in Exhibit 8, use the following information for the Response worksheet:

• Survey Respondent: 284

• Course No: RTS7

• Location: 2

• Instructor Id: 7

• Class Size: 22

• Seminar End Date: 04/21/2020

• Questions 1 – 8: See codes in Exhibit 2.

• Attend a Seminar Before: Derive a value as per Task 4A-4 (use Excel function)

4) For the survey in Exhibit 9, use the following information for the Response worksheet:

• Survey Respondent: 285

• Course No: RTS8

• Location: 2

• Instructor Id: 9

• Class Size: 15

• Seminar End Date: 04/21/2020

• Questions 1 – 8: See codes in Exhibit 2.

• Attend a Seminar Before: Derive a value as per Task 4A-4 (use Excel function)

Exhibit 6 Perry Seminars

Satisfaction Survey

1. Have you previously attended a seminar offered by Perry Seminars?

b. No b. Yes

2. Have you attended a seminar offered by another company?

b. No b. Yes

3. Overall, I am satisfied with the course.

Strongly Agree Agree Neutral Disagree Strongly Disagree

4. I will take another course with Prior Seminars.

Strongly Agree Agree Neutral Disagree Strongly Disagree

5. The information presented will be useful on my job.

Strongly Agree Agree Neutral Disagree Strongly Disagree

6. The instructor was knowledgeable about the subject matter.

Strongly Agree Agree Neutral Disagree Strongly Disagree

7. The seminar’s content was timely.

Strongly Agree Agree Neutral Disagree Strongly Disagree

8. The instructor met the stated course objectives.

Strongly Agree Agree Neutral Disagree Strongly Disagree

Exhibit 7 Perry Seminars

Satisfaction Survey

1. Have you previously attended a seminar offered by Perry Seminars?

a. No b. Yes

2. Have you attended a seminar offered by another company?

a. No b. Yes

3. Overall, I am satisfied with the course.

Strongly Agree Agree Neutral Disagree Strongly Disagree

4. I will take another course with Prior Seminars.

Strongly Agree Agree Neutral Disagree Strongly Disagree

5. The information presented will be useful on my job.

Strongly Agree Agree Neutral Disagree Strongly Disagree

6. The instructor was knowledgeable about the subject matter.

Strongly Agree Agree Neutral Disagree Strongly Disagree

7. The seminar’s content was timely.

Strongly Agree Agree Neutral Disagree Strongly Disagree

8. The instructor met the stated course objectives.

Strongly Agree Agree Neutral Disagree Strongly Disagree

Exhibit 8 Perry Seminars

Satisfaction Survey

1. Have you previously attended a seminar offered by Perry Seminars?

a. No b. Yes

2. Have you attended a seminar offered by another company?

a. No b. Yes

3. Overall, I am satisfied with the course.

Strongly Agree Agree Neutral Disagree Strongly Disagree

4. I will take another course with Prior Seminars.

Strongly Agree Agree Neutral Disagree Strongly Disagree

5. The information presented will be useful on my job.

Strongly Agree Agree Neutral Disagree Strongly Disagree

6. The instructor was knowledgeable about the subject matter.

Strongly Agree Agree Neutral Disagree Strongly Disagree

7. The seminar’s content was timely.

Strongly Agree Agree Neutral Disagree Strongly Disagree

8. The instructor met the stated course objectives.

Strongly Agree Agree Neutral Disagree Strongly Disagree

Exhibit 9 Perry Seminars

Satisfaction Survey

9. Have you previously attended a seminar offered by Perry Seminars?

b. No b. Yes

10. Have you attended a seminar offered by another company?

b. No b. Yes

11. Overall, I am satisfied with the course.

Strongly Agree Agree Neutral Disagree Strongly Disagree

12. I will take another course with Prior Seminars.

Strongly Agree Agree Neutral Disagree Strongly Disagree

13. The information presented will be useful on my job.

Strongly Agree Agree Neutral Disagree Strongly Disagree

14. The instructor was knowledgeable about the subject matter.

Strongly Agree Agree Neutral Disagree Strongly Disagree

15. The seminar’s content was timely.

Strongly Agree Agree Neutral Disagree Strongly Disagree

16. The instructor met the stated course objectives.

Strongly Agree Agree Neutral Disagree Strongly Disagree

Task 5. Create a new Summary worksheet in the workbook.

1) Create a new worksheet (titled Summary) in the workbook (myWorkbook.xlsx) created

in Task 3. The purpose of this worksheet is to summarize the data contained in the

Response worksheet. For each question, the Summary worksheet should provide a count

for each possible response. The count should reflect the number of times a particular

response for the question was given. For instance, the Summary worksheet should show

how many “1” entries, “2” entries, and “3” entries appear in the Location column for the

Response worksheet. For questions 3 – 8, Dr. Perry wants to see their averages, modes,

and medians displayed in the Summary worksheet. The Summary worksheet should also

provide the average, mode, and median class size.

The content and format of the Summary worksheet must be based on the Summary

Worksheet Layout in Exhibit 10.

IMPORTANT NOTE: Use Excel functions to derive appropriate values for each

row/column of the Summary worksheet. Excel functions MUST be used to derive every

value in the sheet to receive full credit (Note: the function used, not the value, must

appear in the function bar when the cell is selected). No credit will be given to

assignments in which Excel functions are not used to derive values in the cells of the

Summary worksheet.

Exhibit. 10 Summary Worksheet Layout. (note: this is a sample layout. For this assignment, each cell of the worksheet must have an Excel function to compute the

actual values)

Questionnaire Responses Summary

For April 2020 (two-week period) Class Size Location

Average xx Client Site (1) xx

Mode xx PS (2) xx

Median xx Another (3) xx

Question 1:

PS Attendance

Question 2: Attended Another

Attended Both PS and

Another

Attended One or

Another

Attended At Least

One Seminar

Never Attended

No (1) xx xx

Yes (2) xx xx xx xx xx xx

Question 3: Satisfaction

Question 4: Another Course

Question 5: Course

Usefulness

Question 6: Knowledgea

ble

Question 7:

Timely Content

Question 8: Course

Objectives

Strongly Agree (5) xx xx xx xx xx xx

Agree (4) xx xx xx xx xx xx

Neutral (3) xx xx xx xx xx xx

Disagree (2) xx xx xx xx xx xx Strongly Disagree (1)

xx xx xx xx xx xx

Average xx xx xx xx xx xx

Median xx xx xx xx xx xx

Mode xx xx xx xx xx xx

Course No. Respondent

Count

RTS1 xx

RTS2 xx

RTS3 xx

RTS4 xx

RTS5 xx

RTS6 xx

RTS7 xx

RTS8 xx

RTS9 xx

RTS10 xx

Total xx

Note: use Excel functions (e.g., COUNTIF) to determine values in Summary worksheet. HINT1: When counting Course No.’s, you’ll need to put quotes around the criteria since it is alphanumeric (i.e. “RTS1”). HINT2: To compute the values for the following columns: “Attended Both PS and Another”, “Attended One or Another”, “Never Attended”, you will need to use the value of the “Attend Seminar Before” column in the Response Worksheet

Attended At Least One Seminar column = Attended Both PS and Another + Attended One or Another.

Task 6. Create several new worksheets (in the workbook) for data analysis.

Dr. Perry wants to analyze the survey data at varying levels of detail. So far, you have entered the survey data

into a Response worksheet and computed summarized results in the Summary worksheet. Dr. Perry also wants to

view data based on multiple conditions (such as satisfaction ratings for instructors by course). You have

suggested to him that the PivotTable and PivotChart reports are excellent tools for this type of analysis. He likes

your suggestion and requests that you use these tools to provide answers to the following questions:

1) Which instructor was the most knowledgeable about the subject matter being taught?

That is, which instructor had the highest percentage of strongly agreed responses (for Question 6)

with respect to the total number of the strongly agreed responses given? Filter your PivotTable by

Course No.

• Create a PivotTable report in the worksheet titled Q1InstrKnow.

2) What is the popularity of Perry Seminar courses? Of the total number of students who have taken

classes, give the percentages of the popularity of each course (in terms of the number of enrolled

students) in comparison to all courses combined. Create a pie chart showing the percentage of offerings

for each course as compared to the total courses offered.

• Create a PivotTable report (Put Course No. in the Rows Labels and Class Size in Values) AND

a PivotChart report (Exploded Pie Chart) in the worksheet titled Q2CrsPopularity. Make sure to

include BOTH, the PivotTable and PivotChart, on the same worksheet. Add a descriptive title to

the PivotChart and format it with appropriate labels for a user-friendly presentation style. Be

creative in formatting the chart.

• Note: Before you create the PivotTable and PivotChart, what you need to do first is to process Response worksheet to remove duplicate data (class size). On Response worksheet, you can find

that RTS1 that was taught by instructor#3 at location #1 on 4/14/2020 had a class size of 30.

Before you create the pivot table and chart, you need to remove duplicate data so that you can get

the actual number of students who took RTS1 or any other courses.

• How to remove duplicate data o First, create a copy of Response worksheet and name it as UniqueClassSize. o Second, select all rows of data on UniqueClassSize, including the headers of each

column.

o Third, go to Data ribbon on excel and use Sort function to sort the data on Course No. o Fourth, go to Data ribbon on excel and select Remove Duplicates. o Fifth, click on Remove Duplicates and check Course No., Location, Instructor ID, Class

Size and Seminar End Date to remove duplicate rows.

o Sixth, use UniqueClassSize worksheet to create a pivot table and chart. Simply put Course No. in Row Label and Class size in Values. Use Sum as value type and show values as

% of Grand Total to complete the pivot table.

o Lastly, use the pivot table to create the pivot chart (pie chart) (insert pie chart-->select data-->ok-->use the PivotChart Tools to add data labels and chart title.

3) How many respondents who have taken a seminar course with another company (Respondents who

answered “Yes”, coded as “2”, on survey question #2) agreed or strongly agreed (answered 4 or 5 on

survey question #4) that they would take another course with Perry Seminars?

• Create a PivotTable report in the worksheet titled Q3TakeAnother

• Hint: place Question #2 in Rows label and filter the values to show only “2” (because we only care about the respondents who answered YES on question

#2). Then, place Question #4 in Columns label and filter the values to show only

“4” and “5” (because we only care about the respondents who answered Agree

or Strongly Agree on question #4)

4) How did the students rate their instructor on the instructor’s ability to provide timely content? For each

instructor, provide a percentage for each response. (Each instructor’s total percentage should equal

100%)

• Create a PivotTable report AND a PivotChart report (100% Stacked Column) in the worksheet titled Q4TimelyContent. Make sure you include the PivotTable and PivotChart on the same

worksheet. Add a descriptive title to the PivotChart and format it with appropriate labels for a

user-friendly presentation style. Be creative in formatting the chart.

• Hint: place Instructor in Rows label and Question #7 in Columns label.

5) For each course, how many students agreed or disagreed (answered 4 or 2 on survey question #5) that the

course was useful?

Filter the report by class size, so that Dr. Perry could analyze for correlations (if any) between the

class size and the perception of the course usefulness. For example, Dr. Perry wonders if students in

smaller classes perceive the information presented in the course as more useful to their job than

students enrolled in larger classes.

• Create a PivotTable report AND a PivotChart report (clustered 3-D bar) in the worksheet

titled Q5CrsUsefulness. Make sure you include the PivotTable and PivotChart on the same

worksheet. Format the PivotChart report using the Layout and Design tabs as follows:

i. Add a descriptive chart title

ii. Use Chart Style 2 for the chart’s design

iii. Show data table with legend keys

iv. Show primary vertical gridlines, and within that, show major and minor gridlines.

Excel Project Deliverable: Excel Project is worth 15% of the overall grade, but the grading scale for the assignment is 100

points. You will turn in one excel file for the assignment. The file will be an electronic, working

copy of your Excel workbook that meets the criteria specified in Tasks 1 - 6 (see above). The file

will be in Excel 2010, 2013, or 2016 format (.xlsx) and will contain ALL of the worksheets

created by you (Tasks 1 – 6). When you turn in Excel Project file for grading, your worksheets

MUST appear in the following order (from left to right):

1. Response worksheet (15 points)

2. Summary worksheet (15 points)

3. Q1InstrKnow (10 points)

4. UniqueClassSize worksheet (8 points)

5. Q2CrsPopularity (10 points)

6. Q3TakeAnother (10 points)

7. Q4TimelyContent (16 points)

8. Q5CrsUsefulness (16 points)

Rename the Excel file you created (i.e., myWorkbook.xlsx) to the following naming

convention: LastnameFirstname_EA (e.g., for Andy Smith's assignment the file will be named

SmithAndy_EA.xlsx). By clicking on the excel assignment, you can find the Browse My

Computer button to attach your file. Click on Submit button to complete the submission.

Excel Assignment Grading Rubric (100 points):

The following list shows the points for each worksheet. Partial credit may be earned for each

worksheet. It also shows the order that these worksheets are expected in the Excel workbook.

Please make that your final workbook has the worksheets in the order listed below (i.e,

Response, Summary, Q1InstrKnow, etc.). Adherence to these instructions will facilitate the

assessment of your project results.

RUBRIC CODE DESCRIPTION TOTAL POINTS

Response Worksheet

• Missing or incorrect surveys at the end of the Response Worksheet

• Incorrect formula for Attended a Seminar column

• Missing respondent number

Up to 15 points

Summary Worksheet

• Incorrect formulas used to derive values for the cells of the worksheet

• No formulas used; values “hard coded” into the worksheet

Up to 15 points

Q1InstrKnow Worksheet • Incorrect PivotTable results

Up to 10 points

Q2CrsPopularity Worksheet • Inclusion of UniqueClassSize worksheet

• Incorrect PivotTable results

• Incorrect PivotChart results

• Wrong PivotChart type

• PivotChart lacks formatting (e.g., chart title, labels)

Up to 18 points (8

points for the

UniqueClassSize

worksheet)

Q3TakeAnother Worksheet • Incorrect PivotTable results

Up to 10 points

Q4TimelyContent Worksheet • Incorrect PivotTable results

• Incorrect PivotChart results

• Wrong PivotChart type

• PivotChart lacks formatting (e.g., chart title, labels, etc)

Up to 16 points

Q5CrsUsefulness Worksheet

• Incorrect PivotTable results

• Incorrect PivotChart results

• Wrong PivotChart type

• PivotChart lacks the required formatting

Up to 16 points