Reference no: EM132771973
Question
University students undergo a significant change during their time at Miami. Beginning with the Entry Year 2015, the university implemented programs to help students become better students with the hope that student GPA's might improve as students move from the Freshman ranks to the upper class ranks. Provide an analysis that compares GPA's earned by students as Freshman with scores earned by those same students as Juniors, for Entry Years 2015-2019, and make an assessment whether the programs have been effective or not. Note: in order to complete this assignment, we will not worry about calculating a GPA by student, rather we will calculate an "aggregate GPA" for Freshman for each Entry Year and aggregate GPA as Juniors for each Entry Year - this approach is similar, but not exactly the same, as CLA #16. In this analysis, we will evaluate the GPA's earned by male students as Freshman with the scores earned by those same male students as Juniors. We will then do the same for the female students.
1. If you need a reminder about how to extract data for Freshman and how to extract data for Juniors. The DatabaseDesign.pdf document included in your folder has a "notes" section on page 2 which outlines this information. In order to understand this, be sure to watch the DataBaseDesign video on the P2 assignment page on Canvas before proceeding.
2. You will use the database completed in the P1 activity and add to it in the P2 activity. COPY your uniqueID_UniversityDB_P1.accdb (in your P1 folder) into your P2 folder. Rename the database as ....P2.accdb. In the P2 folder rename Analysis_P2.xlsx as uniqueID_Analysis_P2.xlsx.
3. Open the database and modify the FRESHMAN query based on the SampleSolution for P1. Then further modify the query to include Gender as one of the group-by fields.
4. Do the same for the JUNIOR query.
5. Open Excel and use Sheet1 to create a documentation page with your name and date. Copy data from the FRESHMAN query into Sheet2 of Excel using a simple "Copy and Paste" method. Name this worksheet FreshmanData.
6. Follow a process similar to the P1 activity to translate the Grade into a point value (A=4; B=3, C=2, D=1, F=0) and to calculate total credits and the total number of points.
7. Follow a process similar to P1 to create a pivot table on a new sheet named FreshmanPivot. Summarize the Total Points and Total Credits by Entry Year and calculate GPA for MALE students. On the same sheet, set up a Pivot Table for FEMALE students.
8. Repeat the above steps in Excel for the JUNIOR query - naming the sheets in Excel appropriately. 9. Use the same method as the P1 activity to copy the data onto a new sheet named AnalysisP2. On the AnalysisP2 sheet, create one chart (of an appropriate type) by Entry Year that plots the Freshman and Junior GPA for MALE students, and a second chart that plots the Freshman and Junior GPA for FEMALE students.
10. Organize and format the AnalysisP2 sheet and the Charts to that it is easy to view and understand.
11. Create a Textbox on the AnalysisP2 Sheet. Using about 3-5 complete and well-written sentences, summarize your analysis and indicate whether your analysis suggests the program has or has not been effective and whether the program affects MALE students differently from FEMALE students. 12. Compact and save your database and save your spreadsheet. Submit BOTH of your files as indicated on Canvas.