In $$Visual Studio Code$$ using Python, I was asked to work on this assignment attached in the file.Please make sure to do all the requirements and use $($simple python code for beginners$)$

Instructional Computer programming II $($TECH$3224)$

College of Education $-$ Instructional & Learning Technology Department

Homework Assignment #$2$

Python Data Analysis Assignment

Objective:

To gain hands$-$on experience in analyzing and visualizing data using Python, Pandas, and Matplotlib.

Dataset Description:

The provided XLSX file contains student records with the following columns:

YRSEM: Year and Semester

GENDER: Gender of the student

STDNO: Student number or ID

LOADSTAT: Load status of the student for the semester

COHRT: Cohort year

MAJ: Major of the student

GRADE: Grade obtained $($A$,$ B$,$ C$,$ D$,$ F$)$

GRADEPOINT: Grade point corresponding to the grade

Tasks:

Pass$/$Fail Analysis

a$)$ Create a summary table showing the count of pass and fail students for each YRSEM. Include columns: YRSEM, PASS, and FAIL.

b$)$ Use pie charts to show the percentage of pass and fail students per semester, customizing labels for clarity.

Grade Distribution Analysis

c$)$ Calculate the number of students scoring each grade $($A$,$ B$,$ C$,$ D$,$ and F$)$ for the semester $23$SP$.$

d$)$ Generate a bar chart with customized colors and annotations for the grade distribution for the semester $23$SP$.$

$1$

Peer Review:

Exchange your analysis with a fellow student. Review their work and provide constructive feedback. Focus on the methodology, clarity of visualization, and the insights derived.

Scoring Rubric

$\backslash$table$[[$Criteria$,$Unsatisfied $(0),$Needs Improvement $(1),$Good $(3)],[$Code Structure,$\backslash$table$[[$Code is disorganized with$],[$no clear structure$]],\backslash$table$[[$Code has some structure$],[$but may be difficult to$],[$follow in places$]],\backslash$table$[[$Code is well$-$structured,$],[$modular$,$ and easy to$],[$follow$]]],[$Code Documentation,$\backslash$table$[[$No comments or$],[$documentation provided$]],\backslash$table$[[$Minimal comments, some$],[$parts of the code are not$],[$documented$]],\backslash$table$[[$Comprehensive$],[$comments and clear$],[$documentation$],[$throughout the code$]]],[$Accuracy of Analysis $1$a$,\backslash$table$[[$Incorrect data or no$],[$submission$]],$Minor errors in analysis,$\backslash$table$[[$Accurate and complete$],[$analysis$]]],[$Accuracy of Analysis $1$b$,\backslash$table$[[$Incorrect visualization or$],[$no submission$]],\backslash$table$[[$Visualization lacks clarity$],[$or detail$]],\backslash$table$[[$Clear and informative$],[$visualization$]]],[$Accuracy of Analysis $1$c$,\backslash$table$[[$Incorrect data or no$],[$submission$]],$Minor errors in analysis,$\backslash$table$[[$Accurate and complete$],[$analysis$]]],[\backslash$table$[[$Clarity of Analysis $1$d$],[$Visualization$]],\backslash$table$[[$Unclear or missing$],[$visualization$]],\backslash$table$[[$Visualization lacks some$],[$detail$]],\backslash$table$[[$Clear and informative$],[$visualization$]]],[\backslash$table$[[$Significance of Analysis$],[2]],\backslash$table$[[$Chosen analysis lacks$],[$significance or insight$]],\backslash$table$[[$Chosen analysis is$],[$somewhat insightful$]],\backslash$table$[[$Analysis is significant and$],[$offers deep insights$]]],[\backslash$table$[[$Clarity of Analysis $2],[$Visualization$]],\backslash$table$[[$Unclear or missing$],[$visualization$]],\backslash$table$[[$Visualization lacks some$],[$detail$]],\backslash$table$[[$Clear and informative$],[$visualization$]]],[$Quality of Peer Review,$\backslash$table$[[$Doesn$\text{'}$t provide$],[$constructive feedback$]],\backslash$table$[[$Provides basic feedback$],[$without much detail$]],\backslash$table$[[$Provides detailed and$],[$constructive feedback$]]]]$

$$

Instructional Computer programming II $($TECH$3224)$

College of Education $-$ Instructional & Learning Technology Department

Homework Assignment #$2$

Python Data Analysis Assignment

Objective:

To gain hands$-$on experience in analyzing and visualizing data using Python, Pandas, and Matplotlib.

Dataset Description:

The provided XLSX file contains student records with the following columns:

YRSEM: Year and Semester

GENDER: Gender of the student

STDNO: Student number or ID

LOADSTAT: Load status of the student for the semester

COHRT: Cohort year

MAJ: Major of the student

GRADE: Grade obtained $($A$,$ B$,$ C$,$ D$,$ F$)$

GRADEPOINT: Grade point corresponding to the grade

Tasks:

Pass$/$Fail Analysis

a$)$ Create a summary table showing the count of pass and fail students for each YRSEM. Include columns: YRSEM, PASS, and FAIL.

b$)$ Use pie charts to show the percentage of pass and fail students per semester, customizing labels for clarity.

Grade Distribution Analysis

c$)$ Calculate the number of students scoring each grade $($A$,$ B$,$ C$,$ D$,$ and F$)$ for the semester $23$SP$.$

d$)$ Generate a bar chart with customized colors and annotations for the grade distribution for the semester $23$SP$.$

$1$

Peer Review:

Exchange your analysis with a fellow student. Review their work and provide constructive feedback. Focus on the methodology, clarity of visualization, and the insights derived.

$$