Reference no: EM13992772
In 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 worksheet as "FirstInital_LastName_PivotIPA04_.xlsx."Highlight the entire data set, and insert a pivot table.
For more information on how to create a pivot table, click here.
Create a new worksheet, and sort the pivot table as follows:
Move Student level to the Column level. Move the Year will move to Values, changing your values to count instead of sum.
Move the Course to Row Label.Insert a Column chart and expand your chart. Select Chart Layout 3, and also change your chart design style
2. Add a title "Course Availability" for your table. Save 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.For more information on how to create a pivot chart, click here.
Create a new worksheet, and 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 and choose a style from the design tab. Insert the name "Course Overview" as your title.
Adjust your new chart by expanding it from cells A22 to G48.
Rename the worksheet to "Course Overview."
Submit your Excel spreadsheet.
Attachment:- U4IP.xlsx
|
Within a computing investigation
: Within a computing investigation, the ability to perform a series of steps again and again to produce the same results is known as ???a. repeatable findings
|
|
Relationship between community relations programs
: For this week's second assignment, you will write a one page essay about the relationship between community relations programs and minority communities. Be sure to address all prompts and cite your sources in APA format. This is worth 50 points, s..
|
|
What is the experimental value of centripital force
: In a centripital force experiment mass m=300 grams, attatched to a spring is revolved around a circle with a radius R=15cm. The frequency is measured to be 1.5 rev/s. What is the experimental value of Centripital force?
|
|
Identify each entry with a keyword or key phrase
: List at least seven (but no more than ten) major ideas or concepts you are taking away from Unit I and Unit II (taken together-i.e., seven total, not seven per unit). Identify each entry with a keyword or key phrase, and then briefly characterize ..
|
|
Create a new worksheet and sort the pivot table
: Determine what core courses that are required to complete your degree in Information Systems Management - Change your chart type to columns and choose a style from the design tab.
|
|
How much time does the man have to get out of the way
: When the block is 10.3 m above the ground, a man, 1.80 m tall, looks up and notices that the block is directly above him. How much time, at most, does the man have to get out of the way?
|
|
What is the time constant of a thick membrane
: What is the time constant of a 8.5 nm -thick membrane surrounding a 3.8 x 102 mm -diameter spherical cell? Assume the resistivity of the cell membrane as 3.6 x 106 m and the dielectric constant is approximately 9.0.
|
|
What is the expected direction of rotation of the loop
: A rectangular loop consists of 124 closely wrapped turns and has dimensions 0.400 m by 0.300 m. The loop is hinged along the y-axis, and the plane of the coil makes an angle of 30.0o with the x-axis (see figure below). What is the magnitude of the ..
|
|
What is the maximum radius of the pulsar
: What is the maximum radius of the pulsar, if no part of its surface can move faster than the speed of light (3x 108 m/s)?
|