Microsoft Excel Assignment. Help Please!

  

Hi! I am in need of help from a tutor who has expert knowledge and experience in Microsoft Excel application. I have an assignment that requires the use of this program. I have attached the assignment instructions on this post which is titled (CIS310Spring2015ExcelAssignment). All the steps and tasks to complete the assignment are all posted in this document. CIS310Spring2015ExcelAssignment The second attached document titled “CIS310Spring2015ExcelAssignmentInput” is a supplemental document which is needed to complete the assignment tasks.CIS310Spring2015ExcelAssignmentInput The assignment is due by Sunday April 26,2015 11 PM PST. Please contact me if you have any questions. Thank you for your help!-Joseph
cis310spring2015excelassignment.pdf

cis310spring2015excelassignment.pdf

Don't use plagiarized sources. Get Your Custom Essay on
Microsoft Excel Assignment. Help Please!
Just from $13/Page
Order Essay

cis310spring2015excelassignment.pdf

cis310spring2015excelassignment.pdf

cis310spring2015excelassignmentinput.xlsx

cis310spring2015excelassignmentinput.xlsx

Unformatted Attachment Preview

CIS 310 – Excel Assignment
Decision Support with Excel Project
Fred Pryor Seminars
Spring 2015
DUE DATE: 4 / 2 7 / 2 0 1 5 a t 6 P M
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 allowed. All work must be original for this project in this quarter.
You may not use work (yours or someone else’s) from other classes or other
quarters. Students violating this academic integrity policy will receive zero points
for this Assignment, an “F” grade in CIS310, and will be referred to the Office of
Judicial Affairs.
Project Objectives:
The purpose of this project is perform an in-depth decision-making analysis of complex and
inter-related data using Microsoft Excel. The software we will be using for Excel assignment
is Microsoft Excel 2010 or 2013.
Project Background:
Fred Pryor 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 a 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 10 fulltime, 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 customer
satisfaction survey upon the completion of their courses. These surveys are then reviewed by Dr.
Fred Pryor, 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. Pryor 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. Pryor hires you as a
consultant to develop a Pryor Survey Results workbook that will enable him to enter and track
the results of the satisfaction surveys.
1
Once the surveys are collected by one of the staff members from FPS, Dr. Pryor’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 (Pryor Survey Results), containing multiple worksheets as per assignment
specifications detailed in this write-up. The purpose of the Pryor Survey Results workbook is to
enter, track, and analyze customer satisfaction surveys for Fred Pryor Seminars.
Dr. Pryor hands you a copy of an incomplete workbook called Pryor Survey
(CIS310Spring2015ExcelAssignmentInput.xlsx). This workbook currently contains one
worksheet (Initial Data) with a sample survey data. You are to use this data when designing the
Pryor 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).
2
Exhibit 1. Customer Satisfaction Survey
Pryor 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
Disagree
Strongly Disagree
Disagree
Strongly Disagree
4. I will take another course with Prior Seminars.
Strongly Agree
Agree
Neutral
5. The information presented will be useful on my job.
Strongly Agree
Agree
Neutral
6. The instructor was knowledgeable about the subject matter.
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Neutral
Disagree
Strongly Disagree
Disagree
Strongly Disagree
7. The seminar’s content was timely.
Strongly Agree
Agree
8. The instructor met the stated course objectives.
Strongly Agree
Agree
Neutral
Exhibit 2. Customer Satisfaction Survey Codes
If Response Is:
No
Yes
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Code
1
2
5
4
3
2
1
3
Exhibit 3. General Course Information Codes
Column
A
B
C
D
E
Codes
Uses the actual course number
1 = Client’s Site
2 = Pryor Seminars
3 = Another Location
Explanation
Contains the course number
Specifies where the course
was offered. The course can
be offered at the client’s
site, at Pryor Seminars or at
another location
Uses the instructor’s identification
Specifies the instructor’s
number
identification number
Uses the number of students enrolled Specifies the number of
in the class.
students enrolled in the class
(Note: Note all students
submit a survey)
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:
U
Task1. Preparing for Excel Project.
Read through the entire assignment.
U
Task2. Download the input file from Blackboard
1) From Blackboard, download the input file –
CIS310Spring2015ExcelAssignmentInput.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 or 2013 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. Pryor 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 a two-week period.
2) Copy data (from the Initial Data worksheet in
CIS310Spring2015ExcelAssignmentInput.xlsx) and paste it into the Response worksheet.
4
Format the Response worksheet by including descriptive headings for each column and the
following title: (note: The title 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.)
Fred Pryor Seminars
Consolidated Survey Results
For March 2015 (Two-Week Period)
3) When the survey forms are returned from the survey respondents, Dr. Pryor’s secretary
will code and enter the individual survey results into the Response worksheet. When
entering survey data into the Response worksheet, Dr. Pryor 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.
Survey
Respon
dent
1
2
Course
No.
Locati
on
Instructor
ID
RTS1
RTS1
1
1
3
3
Class
Size
20
20
Seminar
End Date
Question 1:
PS
Attendance
03/20/2015
03/27/2015
Question
2:
Attended
Another
2
2
Other
columns
…
…
1
2
(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
1
2
Course No.
RTS1
RTS1
Question 1:
PS Attendance
2
1
Question 2:
Attended
Another
Attended a
Seminar
Before
Other
columns
2
2
…
…
4
3
(note: other columns of the Response worksheet are not displayed in Exhibit 5)
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 PS 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 did attend the PS seminar AND did attend 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 did attend the PS seminar AND 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 PS seminar AND did attend 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 is “2”, which means that the respondent DID attend Another
Seminar; thus, according to the rule d (listed above), the value of 3 must be computed
(using an Excel function) 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.
6
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:
03/27/2015
? 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:
03/27/2015
? 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:
03/27/2015
? 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:
03/27/2015
? Questions 1 – 8:
See codes in Exhibit 2.
? Attend a Seminar Before:
Derive a value as per Task 4A-4
(use Excel function)
7
Exhibit 6
Pryor Seminars
Satisfaction Survey
1. Have you previously attended a seminar offered by Pryor 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
Disagree
Strongly Disagree
Disagree
Strongly Disagree
4. I will take another course with Prior Seminars.
Strongly Agree
Agree
Neutral
5. The information presented will be useful on my job.
Strongly Agree
Agree
Neutral
6. The instructor was knowledgeable about the subject matter.
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Neutral
Disagree
Strongly Disagree
Disagree
Strongly Disagree
7. The seminar’s content was timely.
Strongly Agree
Agree
8. The instructor met the stated course objectives.
Strongly Agree
Agree
Neutral
8
Exhibit 7
Pryor Seminars
Satisfaction Survey
1. Have you previously attended a seminar offered by Pryor 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
Disagree
Strongly Disagree
Disagree
Strongly Disagree
4. I will take another course with Prior Seminars.
Strongly Agree
Agree
Neutral
5. The information presented will be useful on my job.
Strongly Agree
Agree
Neutral
6. The instructor was knowledgeable about the subject matter.
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Neutral
Disagree
Strongly Disagree
Disagree
Strongly Disagree
7. The seminar’s content was timely.
Strongly Agree
Agree
8. The instructor met the stated course objectives.
Strongly Agree
Agree
Neutral
9
Exhibit 8
Pryor Seminars
Satisfaction Survey
1. Have you previously attended a seminar offered by Pryor 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
Disagree
Strongly Disagree
Disagree
Strongly Disagree
4. I will take another course with Prior Seminars.
Strongly Agree
Agree
Neutral
5. The information presented will be useful on my job.
Strongly Agree
Agree
Neutral
6. The instructor was knowledgeable about the subject matter.
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Neutral
Disagree
Strongly Disagree
Disagree
Strongly Disagree
7. The seminar’s content was timely.
Strongly Agree
Agree
8. The instructor met the stated course objectives.
Strongly Agree
Agree
Neutral
10
Exhibit 9
Pryor Seminars
Satisfaction Survey
9. Have you previously attended a seminar offered by Pryor 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
Disagree
Strongly Disagree
Disagree
Strongly Disagree
12. I will take another course with Prior Seminars.
Strongly Agree
Agree
Neutral
13. The information presented will be useful on my job.
Strongly Agree
Agree
Neutral
14. The instructor was knowledgeable about the subject matter.
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
Neutral
Disagree
Strongly Disagree
Disagree
Strongly Disagree
15. The seminar’s content was timely.
Strongly Agree
Agree
16. The instructor met the stated course objectives.
Strongly Agree
Agree
Neutral
11
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 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. Pryor 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.
12
Task 6. Create several new worksheets (in the workbook) for data analysis.
Dr. Pryor 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. Pryor 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 very good tools for this type of analysis. He likes your suggestion and requested 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 Pryor 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 (Course No. as the Row Labels and Class Size as the
Column Labels) AND a PivotChart report (Exploded Pie Chart) in the worksheet
titled Q2CrsPopularity …
Purchase answer to see full
attachment

  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more