Question

TestResultsProject2.pptx

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.