Test Results Project with no plagiarism
Project should have no plagiarism. Please see the attachments. Even example PPT is attached for reference, this is just reference, this project shouldn’t have any reference to the attached example.
Every day we use data in one way or another in our daily lives, we find ways to analyze situations and create viable solutions based on quantitative and qualitative information that we collect mentally as well as physically. For this project, you are going to become an educational advisor for a fictional educational institution. The Vice President of Instruction of the institution has provided you with the raw data of the assessment scores of their students’ final exam in their GED Preparation Course. The course consists of scores in mathematics and English and Pass or Fail Overall Score. There is also information in regard to the demographics of the students.
Based on the raw data that you have been provided(attached in form of pdf and excel file), you are going to develop a presentation using visuals of the data that have been provided. You are going to make recommendations to the Vice President of Instruction of the University of suggested improvements that can be made based on your analysis of the data that has been provided to you.
Within your data presentation include:
A variety of graphics that illustrate the represented data
An explanation of what each graphic represents
Explain how the graphics should be interpreted (include a key)
Finally, summarize your analyzation of the data and provide the VP with some suggestions to improve the quality of instruction within the school. Refer to your visuals within your summary.
For this assignment, you can use any method that you want to use. Some students use Microsoft Word, some students have used Powerpoints.
Please make sure that you look at the example that is also attached!!
>Sheet umber of bsences in day Program
6
.5
FAIL YES .5
FAIL YES FAIL YES =Black
2 58 .5
PASS 17 FAIL NO .5
PASS NO 71 PASS NO B 10 FAIL NO W 0 .5
PASS NO %
A 1 100 100 100 PASS YES B 3 72 PASS NO H 1 FAIL YES O 5 37 65 FAIL NO Days
B 1 PASS NO 72 75 PASS NO W 1 67 90 PASS NO N 0 51 .5
FAIL NO B 1 89 100 .5
PASS NO PASS NO 82 PASS NO 37 FAIL YES O 2 FAIL NO .5
FAIL NO B 5 78 58 68 PASS NO W 0 42 FAIL NO Student Ethnicity English Score in Precent Math Score in Percent Assessment Score in Percent Assessment Results English Second Language Assessment Key W 0 76 PASS NO W 0 95 94 PASS NO Ethinicity A 1 100 85 PASS YES H=Hispanic FAIL YES .5
FAIL YES W=White W 4 78 90 84 PASS NO N=Native Amer. 65 FAIL NO O=Other H 2 36 70 53 FAIL B 1 97 100 PASS O 2 100 PASS NO Passing Score H 5 80 75 PASS NO .5
FAIL NO H 0 80 80 80 PASS NO GED Program FAIL NO 60 Days PASS NO PASS NO FAIL NO H 3 89 75 82 PASS YES PASS NO 91 PASS NO PASS NO Student Ethnicity
Number of
Absences in
60 day
Program
English
Score in
Precent
Math
Score in Percent
Assessment
Score in Results
English Second
Language Assessment Key
1 H 3 34 78 56 FAIL YES
2 H 5 28 57 42.5 FAIL YES Ethinicity
3 H 2 37 82 59.5 FAIL YES H=Hispanic
4 H 0 58 71 64.5 FAIL YES B=Black
5 W 2 58 76 67 PASS NO W=White
6 B 0 90 85 87.5 PASS NO N=Native Amer.
7 W 17 35 17 26 FAIL NO O=Other
8 W 3 68 77 72.5 PASS NO
9 B 0 59 83 71 PASS NO
10 B 10 24 20 22 FAIL NO Passing Score
11 W 0 100 95 97.5 PASS NO 65%
12 A 1 100 100 100 PASS YES
13 B 3 69 75 72 PASS NO
14 H 1 23 92 57.5 FAIL YES GED Program
15 O 5 37 65 51 FAIL NO 60 Days
16 B 1 89 70 79.5 PASS NO
17 B 0 78 72 75 PASS NO
18 W 1 67 90 78.5 PASS NO
19 N 0 56 51 53.5 FAIL NO
20 B 22 23 17 20 FAIL NO
21 B 1 89 100 94.5 PASS NO
22 O 3 67 95 81 PASS NO
23 W 0 78 86 82 PASS NO
24 H 6 34 37 35.5 FAIL YES
25 O 2 52 73 62.5 FAIL NO
26 B 3 54 47 50.5 FAIL NO
27 B 5 78 58 68 PASS NO
28 N 2 67 87 77 PASS NO
28 N 1 97 87 92 PASS NO
30 W 0 43 42 42.5 FAIL NO Student Ethnicity 31 W 0 76 84 80 PASS NO
32 W 0 95 94 94.5 PASS NO Ethinicity
33 A 1 100 85 92.5 PASS YES H=Hispanic
34 H 0 7 80 43.5 FAIL YES B=Black
35 H 3 11 82 46.5 FAIL YES W=White
36 W 4 78 90 84 PASS NO N=Native Amer.
37 W 9 45 65 55 FAIL NO O=Other
38 H 2 36 70 53 FAIL
39 B 1 97 100 98.5 PASS
40 O 2 91 100 95.5 PASS NO Passing Score
41 H 5 80 75 77.5 PASS NO 65%
42 A 0 80 92 86 PASS NO
43 B 13 54 43 48.5 FAIL NO
44 H 0 80 80 80 PASS NO GED Program
45 W 12 32 21 26.5 FAIL NO 60 Days
46 B 0 56 76 66 PASS NO
47 B 1 73 76 74.5 PASS NO
48 B 3 84 21 52.5 FAIL NO
49 H 3 89 75 82 PASS YES
50 H 11 26 22 24 FAIL YES
51 W 2 47 65 56 FAIL NO
52 B 1 57 82 69.5 PASS NO
53 W 0 89 93 91 PASS NO
54 H 0 93 75 84 PASS YES
55 W 1 84 73 78.5 PASS NO
56 H 2 84 80 82 PASS NO
57 B 6 97 84 90.5 PASS NO
58 H 4 90 90 90 PASS YES
59 H 1 17 70 43.5 FAIL NO
60 H 3 21 65 43 FAIL YES Test Results Project Project Statement: Student population distribution vs Ethnicity : Around 84% of the students are from Hispanic, White and Black ethnic backgrounds. 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 Assessment Score(>=65%), Math vs Ethnicity With English as second language, Assessment Scores Without English as second language, Assessment Scores Recommendations:
2
1
Student
Ethnicity
N
A
6
0
English Score in Precent
Math Score in Percent
Assessment Score in Percent
Assessment Results
English Second Language
Assessment Key
1
H
3
3
4
7
8
5
FAIL
YES
2 H 5
28
57
42
Ethinicity
3 H 2
37
82
5
9
H=Hispanic
4 H 0
58
71
64.5
B
5
W
76
67
PASS
N
O
W=White
6 B 0
90
85
87
NO
N=Native Amer.
7 W
17
35
26
O=Other
8 W 3
68
77
72
9 B 0
59
83
10
24
20
22
Passing Score
11
100
95
97
65
12
13
69
75
14
23
92
57.5
GED Program
15
51
60
16
89
70
79.5
17 B 0
78
18
78.5
19
56
53
20 B 22 23 17 20 FAIL NO
21
94
22 O 3 67 95
81
23 W 0 78
86
24 H 6
34
35.5
25
52
73
62.5
26 B 3
54
47
50
27
28 N 2 67 87 77 PASS NO
28 N 1 97 87 92 PASS NO
30
43
42.5
Number of Absences in 60 day Program
31
84
80
32
94.5
33
92.5
34 H 0 7 80
43.5
B=Black
35 H 3 11 82
46
36
37 W 9
45
55
38
39
98.5
40
91
95.5
41
77.5
65%
42 A 0 80 92 86 PASS NO
43 B 13 54 43
48
44
45 W 12 32 21
26.5
46 B 0 56 76
66
47 B 1 73 76
74.5
48 B 3 84 21
52.5
49
50 H 11 26 22 24 FAIL YES
51 W 2 47 65 56 FAIL NO
52 B 1 57 82
69.5
53 W 0 89
93
54 H 0 93 75 84 PASS YES
55 W 1 84 73 78.5 PASS NO
56 H 2 84 80 82 PASS NO
57 B 6 97 84
90.5
58 H 4 90 90 90 PASS YES
59 H 1 17 70 43.5 FAIL NO
60 H 3 21 65 43 FAIL YES
Percent
Assessment
Number of
Absences in
60 day
Program
English
Score in
Precent
Math
Score in
Percent
Assessment
Score in
Percent
Assessment
Results
English
Second
Language Assessment Key
Dr LaMar D. Brown PhD, MBA
Ph.D. in Information Technology
University of the Cumberland’s
Analysing and Visualizing Data
This is an example of a presentation.
DO NOT COPY THIS CONTENT. YOU HAVE TO CREATE YOUR OWN PRESENTATION. USING YOUR OWN THOUGHTS AND IDEAS BASED ON YOUR EVALUATION OF THE RAW DATA.
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.
And we can’t make strong conclusions for the other categories, because of statistically insignificant amount of data.
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.
Student who passed the assessment, performed well in Math.
Assessment result – “Pass”, has a strong correlation with Math score.
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.
There’s no correlation in passing the assessment and having English as second language for both Black and White ethnic students.
Here you need to create all least 5 recommendations that you would make to the VP based on the students scores and outcomes.
Make sure your recommendations are related to the data and presentation.