Reference no: EM131263304
Course Availability
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. 1-Openthis Excel workbookand save the workbook as "FirstInital_LastName_PivotIPA04_.xlsx."
2. 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.
3. 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.
4. 8-Insert a Column chart. Select Chart Layout 3, and also change your chart to design to style 2.
5. 9-Change the title of your chart to "Course Availability".
6. 10-Name the worksheet as "Course Availability," and save your document as "FirstInitial_LastName_PivotIPA04_solution."
7. 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.
8. Sort the pivot chart as follows:
· Filter the Year.
· Move Courses to Axis Fields.
· Move the Count of Student to Value.
9. 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.
|
How can forming a strategic alliance guide a company
: How did the alliance formed by Aegis with Honeywell and Rockwell affect the overall business of Aegis and its products - How important were the specific expertise of both Jahn and Neway in the forming of Aegis? In other words, how did their prior wo..
|
|
Describe the etl process for building a data warehouse
: As discussed in this chapter, the IRS maintains a large data warehouse of 10 years of tax return data. What other types of data warehouses do you think the federal or state government might have pertaining to U.S. residents? What purposes might th..
|
|
Characteristic of national stock exchange
: The stock market is very close to a perfect competitive market. The price of a stock usually is determined by the market forces of demand and supply of the stock and individual buyers and sellers of the stock have little effect on price (they are ..
|
|
Change the title of your chart to course availability
: Change the title of your chart to "Course Availability". Highlight the entire data set, and insert a pivot table on a new worksheet. For more information on how to create a pivot table.
|
|
Discuss the factors contributing to miscommunication
: Discuss the factors contributing to this miscommunication. What went wrong in the process of communication? What role did feedback play?
|
|
Describe nutrients of concern or special concerns
: Define nutrient, energy, and fluid needs during your assigned life stage. Describe nutrients of concern or special concerns during your assigned life stage. Identify physical activity recommendations during your assigned life stage.
|
|
Should firm increase or decrease the amount of capital usedg
: Is the firm using the cost minimizing combination of labor and capital? if not, should the firm increase or decrease the amount of capital used in its production process?
|
|
What they are doing to support the sustainability effort
: At least 3 sources of information as footnotes or separate bibliography, As a conclusion of your report, state your opinion whether this company is using the right (or wrong) approach and should other companies start adopting their methods?
|