week 4

summary

 
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:

Open this Excel workbook and save the workbook as “FirstInital_LastName_PivotIPA04_.xlsx.”
Highlight the entire data set, and insert a pivot table on a new worksheet.

For more information on how to create a pivot table, click here.

Sort the pivot table as follows:

Move Student level to the Column level.
Move the Year to Values, change your values to count instead of sum.
Move the Course to Row Label.

Insert a Column chart. Select Chart Layout 3, and also change your chart to design to style 2.
Change the title of your chart to “Course Availability”.
Name the worksheet as “Course Availability,” and save your document as “FirstInitial_LastName_PivotIPA04_solution.”
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, click here.

Sort the pivot chart as follows:

Filter the Year.
Move Courses to Axis Fields.
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.
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.”
Save the workbook. Close the workbook and then exit Excel.

unit 4 IP
 
One of the more important measures in regard to international economics is the balance of payments. Think of it as a national accounting measure that looks at the flow of goods and services into and out of an economy in a given period of time. It also shows capital flows into and out of a country. Until 1980, the United States tended to run a positive-to-neutral balance of payments position and was a creditor nation. In the course of the past 30 years, the United States has moved to a negative balance of payments and to being a debtor nation.

Review and discuss the following:

Discuss the importance of the balance of payments as an accounting measure.  
Discuss the current account and its components and the capital and financial accounts and their components.  
How important is the U.S. deficit in traded goods in regard to the balance of payments?

Here are some relevant articles to help you with this assignment:

The Changing Nature of the U.S. Balance of Payments 
Balance of Payments