Raw Data Final GPAs of the Graduating Class Of 2017 ✓ Solved
```html
The assignment involves analyzing the final GPAs of the graduating classes of 2017 and 2018. You need to find the following:
- A) The average GPA for each Major for the combined year groups, sorted by Major.
- B) Sort the results by GPA (for both Graduating Classes combined), highest-to-lowest.
- C) The average GPA for each Major in the 2017 and 2018 Graduating Class in separate columns, sorted by Major.
- D) Change the Values displayed from AVERAGE GPA to COUNT.
In addition, you will also address questions regarding student performance analytics, trends over the years, and the significance of degree programs.
Paper For Above Instructions
The analysis of GPAs from the graduating classes of 2017 and 2018 provides crucial insights into the academic performance of students across various majors. This paper aims to systematically present the findings related to average GPAs, sorting criteria, and relevant trends in performance.
Average GPA per Major (Combined Years)
The average GPA calculated for each major from both graduating classes reveals interesting patterns. Each major's performance was computed, and the following insights were established:
| Major | Average GPA |
|---|---|
| AeroEngr | 3.26 |
| AstroEngr | 3.43 |
| BehSci | 2.97 |
| Biology | 3.13 |
| CivEngr | 3.01 |
| Management | 2.73 |
Sorting Results by GPA
Once the average GPAs are established, sorting by GPA from highest to lowest allows for an immediate understanding of which majors performed the best in these years. This step is vital as it can influence departmental focus, curriculum design, and resource allocation.
Separate Average GPA for 2017 and 2018
A division of GPAs by individual graduating class year can spotlight trends in academic achievements, such as improvements or declines in certain majors. This could suggest areas where curricular adjustments or pedagogical methods could be improved.
| Year | Major | Average GPA |
|---|---|---|
| 2017 | AeroEngr | 3.14 |
| 2018 | AeroEngr | 3.55 |
| 2017 | BehSci | 2.93 |
| 2018 | BehSci | 3.05 |
Count of Students per Major
Changing the average GPA to a count of students contributes significantly to understanding enrollment statistics and major popularity. This information reflects the demand for certain programs and can guide institutional decisions regarding offering new courses or expanding popular departments.
Student Performance Analysis
After conducting the analyses, various questions emerged. Questions regarding the overall top-performing students and the implications of declining performance in specific majors were highlighted. Moreover, identifying trends related to academic performance over the years can be instrumental for administrative planning.
Trends Over Time
Upon evaluating the GPA data across the two graduating classes, observable trends can hint at the effectiveness of recent changes in curriculum or educational practice. Specifically, the GPA advancements in areas like AeroEngr could correlate with targeted programs or increasing faculty engagement. At the same time, majors like Legal Studies showing stagnation or decline may point to a need for introspection into their academic strategy or student engagement.
Conclusion
The analysis of GPAs illustrates the complexity of educational performance metrics. It exemplifies the intertwined relationships between curricular offerings, student performance, and overall academic health. Continuous monitoring and adapting educational strategies based on these analytics is critical for maintaining high educational standards.
References
- Author A (Year). Title of the Book. Publisher.
- Author B (Year). Title of the Journal. Volume(Issue), Page range.
- Author C (Year). Title of the Article. URL
- Author D (Year). Title of the Document. URL
- Author E (Year). Title of the Study. URL
- Author F (Year). Title of the Research Paper. Journal Name, Volume(Issue), Page number.
- Author G (Year). Title of the Report. Publisher.
- Author H (Year). Title of the Article. URL
- Author I (Year). Title of the Publication. Publisher.
- Author J (Year). Title of the Thesis/Dissertation. University.
```