#Exp22_Excel_Ch10_Cumulative – Student Enrollment
#Exp22 Excel Ch10 Cumulative Student Enrollment
#exp22_excel_ch10_cumulative – student enrollment
#Excel Chapter 10 Cumulative – Enrollment Report
You are a student enrollment analyst at a local university. Currently your data management systems contain student information, course offerings, and student grades. You want to create a report to examine total enrollment and student performance. You will use Power Query to import data, Power Pivot to analyze grades, and Power Maps to visualize student demographic information.
Start Excel. Download and open the file named Exp22_Excel_Ch10_Cumulative_EnrollmentReport.xlsx. Grader has automatically added your last name to the beginning of the filename.
Use Get & Transform to import the file e10c1StudentEnrollment.csv into a new worksheet. Be sure to load the table to the data model during import.
Rename the worksheet StudentEnrollment.
Use Get & Transform to import the ClassesOffered table located in the database e10c1ClassOfferings.accdb into a new worksheet. Be sure to load the table to the data model during import.
Import the GradeReport table from the e10c1Grades.accdb database into a new worksheet. Be sure to load the table to the data model during import.
Open the StudentEnrollment query in the Power Query Editor. Split the Name column using space as a delimiter. Rename the split columns Last Name and First Name respectively. Close and load the query.
Use Get & Transform to import the file e10c1StudentEnrollment2024.txt into a new worksheet. Prior to loading the data into the worksheet, use the Power Query Editor to split the Name column using space as a delimiter. Rename the split columns Last Name and First Name respectively.
Append the e10c1StudentEnrollment table with the data from the e10c1StudentEnrollment2024 table. Close and Load the table.
Define the following relationship between the Grade Report table and Classes Offered table:
Define the following relationship between the Grade Report table and the e10c1StudentEnrollment table:
Use Power Pivot to create a PivotTable on Sheet1 starting in cell A1. Add ClassName from the ClassesOffered table to the Rows area, Grade from the GradeReport table to the Values area, and ClassNumber from the ClassesOffered table to the Filters area.
Change the Implicit measure of GPA created in the previous step from Sum to Average.
Rename the worksheet GradeAnalysis.
Format the grades in the range B4:B19 to display 2 decimal places.
Insert a Clustered Column PivotChart. Add the chart title Grade Analysis. Move and resize the chart so that the upper-left corner is inside cell D4 and lower-right corner is inside cell K18.
Create a 3D Map based on student addresses in the enrollment table. Add Address as the Location dimension. Add Grade as the Height dimension and change the aggregation from Sum to Average.
Add Grade as the Height dimension and change the aggregation from Sum to Average. Zoom and tilt the map so the entire US is visible. Edit Scene 1 by changing the name to Over View, setting the Scene duration to 6 seconds, and then setting the Transition Effect to Dolly.
Add a new scene called East Coast. Zoom out and reposition the map to view the Eastern seaboard. Set the Scene duration to 6 seconds and set the Transition Effect to Dolly.
Edit the connection properties so all queries do not refresh in the background and do not refresh on Refresh All.
Save and close Exp22_Excel_Ch10_Cumulative_EnrollmentReport.xlsx. Exit Excel. Submit the file as directed.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Quality Essay Help has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At Quality Essay Help, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.