Reference no: EM131146382
In this project, determine what core courses that are required to complete degree in Information Systems Management. You are trying to determine which classes will be offered and how much longer it will take you to complete your degree. Once you complete your pivot table and chart, you will now be able to visually see what courses are available and which semester offers the most courses that you will need to successfully graduate.
To complete the assignment, perform the following tasks:
1-Openthis Excel workbookand save the workbook as "FirstInital_LastName_PivotIPA04_.xlsx."
2-Highlight the entire data set, and insert a pivot table on a new worksheet.
3-For more information on how to create a pivot table, clickhere.
4-Sort the pivot table as follows:
5-Move Student level to the Column level.
6-Move the Year to Values, change your values to count instead of sum.
7-Move the Course to Row Label.
8-Insert a Column chart. Select Chart Layout 3, and also change your chart to design to style 2.
9-Change the title of your chart to "Course Availability".
10-Name the worksheet as "Course Availability," and save your document as "FirstInitial_LastName_PivotIPA04_solution."
11-Return to the Data sheet, highlight all the data, and click on Insert a pivot chart on a new worksheet.
For more information on how to create a pivot chart, clickhere.
Sort the pivot chart as follows:
•Filter the Year.
•Move Courses to Axis Fields.
•Move the Count of Student to Value.
Change your chart type to columns if the type is not columns and choose a style from the design tab. Insert the name "Course Overview" as your title.
Add two more courses at the end of the list and adjust your new chart to include the two courses.
Rename the worksheet to "Course Overview." Submit your Excel spreadsheet.
Attachment:- _EXCEL-WORKBOOK-.rar
Created a team and filled in the team nomination form
: All students need to submit an individual copy of this activity. This has to be each students own work (not team based). Created a team and filled in the team nomination form. Anybody without a team member will be put into the team randomly for the..
|
Record the two transactions for bill law firm
: Bill's law firm perfumed legal services for a client who could not pay immediately. The business expects to collect $11000 the following month. Later the business received $6600 cash from client. Record the two transactions for Bill Law firm. Include..
|
Initial assessment methods
: Answers the question related to the topic "Initial Assessment Methods"Which of the following is(are) initial assessment methods
|
Find the expected change in the natural frequency
: Find the expected change in the natural frequency of the beam-machine system.
|
Complete the given assignment
: determine what core courses that are required to complete degree in Information Systems Management.- complete your pivot table and chart.
|
Differences of an effective leader and an ineffective leader
: Discuss the similarities and differences of an effective leader and an ineffective leader that you have either personally encountered or researched. Responses should be on topic, original, and contribute to the quality of the Discussion by making..
|
History of the health care insurance
: History of the Health care Insurance. (where this start, years and beginning of health care insurance and how the Health Insurance evolve( years, facts, policies, coverage)
|
Advantages of internal and external equity for organizations
: Identify advantages and disadvantages of internal and external equity for the organizations. Explain how each plan supports that organization's total compensation objectives and the relationship of the organization's financial situation to its pla..
|
Find the natural frequency of vibration
: A mass m is attached to a cord that is under a tension T, as shown in Fig. 2.67. Assuming that T remains unchanged when the mass is displaced normal to the cord,
|