Question
Test Results Project Thrivikram Reddy Chamala Ph.D. in Information Technology University of the Cumberland’s Analysing and Visualizing Data
Project Statement:
Input parameters:
Assessment scores of students in final exam
8 Attributes:
Index (Student#) – Integer
Ethnicity – [A,B,H,N,O,W]- Categorical
Absences – Integer
English Scores(%)- Integer
Math Scores(%) – Integer
Assessment Percent – Float
Assessment Result [Yes/No] – Categorical
English Second Language [Yes/No] - Categorical
60 rows of data
Output :
1. To analyze and summarize the data visually.
2. To make recommendations to improve the quality of instruction.
Student population distribution vs Ethnicity :
Around 84% of the students are from Hispanic, White and Black ethnic backgrounds.
And we can’t make strong conclusions for the other categories, because of statistically insignificant amount of data.
Assessment Score(<65%),English vs Ethnicity
Most of the Students who failed in Assessment, scored under 65% in English.
80% of Black ethnic students who scored under 65% in English, failed in Assessment
It is evident that students over 65% in English outperformed in Total Assessment.
In general, we can make a conclusion that if a student failed in the assessment they have scored less than 65% in English.
Assessment Score(<65%),Math vs Ethnicity
Most of that Black and Native Americans who failed in total assessment, scored under 65% in math.
Around 60% of Whites who failed in assessment, scored under 65% in math.
With skewed data, 100% of students with ethnicity other scored more than 65% in math.
Assessment Score(>=65%),English vs Ethnicity
25% of Black and 10% of White ethnic students scored under 65% in English when they passed in assessment.
Except white and black ethnic students, the remaining passed in assessment with more than 65% in English.
Assessment Score(>=65%), Math vs Ethnicity
Student who passed the assessment, performed well in Math.
Assessment result – “Pass”, has a strong correlation with Math score.
With English as second language, Assessment Scores
Most of the students who failed in assessment and having English as their second language are from Hispanic ethnicity.
60% of Hispanics and 40% of A ethnic students passed in assessment with English as second language.
Number of Hispanics who failed the assessment have strong correlation between English score and English as second language.
Without English as second language, Assessment Scores
There’s no correlation in passing the assessment and having English as second language for both Black and White ethnic students.
Recommendations:
There is a need for mentoring students in English (Hispanics), which helps them in passing the total assessment.
Students who performed well in total assessment, out performed in math.
To get better assessment results, it would be better to have weighted average of English and Math scores with math having higher weightage.
More conclusions can’t be drawn on some of the ethnic groups because of insignificant amount of data.