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!!

2

>Sheet

1

umber of

bsences in

day Program

1

6

2 H 5

.5

FAIL YES

3 H 2

.5

FAIL YES

4 H 0

FAIL YES

=Black

5

2 58

6 B 0

.5

PASS

7 W

17

FAIL NO

8 W 3

.5

PASS NO

9 B 0

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

17 B 0

72 75 PASS NO

W 1 67 90

PASS NO

N 0

51

.5

FAIL NO

20 B 22 23 17 20 FAIL NO

B 1 89 100

.5

PASS NO

22 O 3 67 95

PASS NO

23 W 0 78

82 PASS NO

24 H 6

37

FAIL YES

O 2

FAIL NO

26 B 3

.5

FAIL NO

B 5 78 58 68 PASS NO

28 N 2 67 87 77 PASS NO
28 N 1 97 87 92 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

34 H 0 7 80

FAIL YES

35 H 3 11 82

.5

FAIL YES W=White

W 4 78 90 84 PASS NO N=Native Amer.

37 W 9

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

42 A 0 80 92 86 PASS NO
43 B 13 54 43

.5

FAIL NO

H 0 80 80 80 PASS NO GED Program

45 W 12 32 21

FAIL NO 60 Days

46 B 0 56 76

PASS NO

47 B 1 73 76

PASS NO

48 B 3 84 21

FAIL NO

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

PASS NO

53 W 0 89

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

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

																							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
																	H										3	3			4			7	8						5																									FAIL															YES
		28			57			42		Ethinicity
			37						82	5		9		H=Hispanic
			58		71	64.5																		B
														W				76				67																																			PASS								N				O		W=White
					90		85			87																																			NO		N=Native Amer.
				17		35			26		O=Other
	68		77			72
	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
			78
18		78.5
19				56			53
			21		94
81
	86
	34	35.5
25		52			73	62.5
		54			47		50
27
30				43	42.5
Number of Absences in 60 day Program
31							84								80
	32	94.5
33	92.5
	43.5	B=Black
	46
	36
	45		55
38
39	98.5
40		91	95.5
41	77.5	65%
	48
44
26.5
66
74.5
52.5
49
69.5
	93
90.5

Student Ethnicity

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

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
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

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
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.

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:
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.