Reference no: EM131150423
Spreadsheet IP4
Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
Be sure to download the companion resources using the link provided in the reading assignments.
In this project, you will determine what core courses that are required to complete your 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. Open this Excel workbook and save the workbook as "FirstInital_LastName_PivotIPA04_.xlsx."
2. Highlight the entire data set, and insert a pivot table on a new worksheet.
3. Sort the pivot table as follows:
o Move Student level to the Column level.
o Move the Year to Values, change your values to count instead of sum.
o Move the Course to Row Label.
4. Insert a Column chart. Select Chart Layout 3, and also change your chart to design to style 2.
5. Change the title of your chart to "Course Availability".
6. Name the worksheet as "Course Availability," and save your document as "FirstInitial_LastName_PivotIPA04_solution."
7. Return to the Data sheet, highlight all the data, and click on Insert a pivot chart on a new worksheet.
o For more information on how to create a pivot chart, click here.
8. Sort the pivot chart as follows:
o Filter the Year.
o Move Courses to Axis Fields.
o Move the Count of Student to Value.
9. 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.
10. Add two more courses at the end of the list and adjust your new chart to include the two courses.
11. Rename the worksheet to "Course Overview." Submit your Excel spreadsheet.
Reference
Microsoft. (n.d.). Create or delete a PivotTable or PivotChart report. Retrieved from https://office.microsoft.com/en-us/excel-help/create-or-delete-a-pivottable-or-pivotchart-report-HP010342375.aspx?CTT=1#_Toc254687657
Attachment:- U4IP.xlsx
|
Which supervisory techniques were not effective
: How does a high stress environment like war or the emergency room affect supervisory techniques, as compared to peacetime (or a less stressful environment)? What supervisory trait do you most relate to and why? You should include a personal account..
|
|
Determine yield strength
: Determine- yield strength,- modulus of elasticity,- tensile strength, and- percent elongation.- Plot the engineering stress strain curve.
|
|
Discuss the pros and cons of a national sales tax
: Discuss the pros and cons of a National Sales Tax. Your paper should include a title page, a reference page and at least 2 pages of double spaced content.
|
|
Examine netflix relationship with amazon
: What is the role of Reed Hastings in leading Netflix amidst significant technological changes? Examine Netflix relationship with Amazon. What other dangers does Netflix face
|
|
What core courses that are required to complete your degree
: In this project, you will determine what core courses that are required to complete your degree in Information Systems Management.
|
|
What would to encourage and increase technological advances
: The availability of technology has a profound effect on the health care costs and the availability of medical care. Local, state and national policy makers have an impact on these systems. Explain what you would do to encourage and increase techno..
|
|
Explain how local state and federal policymakers can impact
: For this Journal entry, explain how local, state, and federal policymakers can impact the delivery of healthcare in this country. Your Journal entry should be at least 400 words, and cite appropriate references.
|
|
Facts about impacts of early college model
: Write a Expository Essays on the topic :"Facts about Impacts of Early College Model that will blow your mind"
|
|
Discuss the workforce planning process.
: Discuss the workforce planning process. After discussing each step, explain what would happen if an organization did not follow the workforce planning process. Explain from the perspective of the employer and the employees.
|