Scribd
Upload
17 views7 pages

Primary Education Student Data Analysis

The dataset provides insights into primary education pupils, including attributes like gender, race/ethnicity, parental education, and test scores. Analysis reveals that females generally outperform males in average scores across subjects, while students who completed test preparation courses achieve better results. Additionally, parental education significantly influences student performance, with a static Excel dashboard created to present the findings.

Uploaded by

azarias jorge chambule
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
17 views7 pages

Primary Education Student Data Analysis

The dataset provides insights into primary education pupils, including attributes like gender, race/ethnicity, parental education, and test scores. Analysis reveals that females generally outperform males in average scores across subjects, while students who completed test preparation courses achieve better results. Additionally, parental education significantly influences student performance, with a static Excel dashboard created to present the findings.

Uploaded by

azarias jorge chambule
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

This dataset contains information about pupils in primary education.

The data attributes include student gender, race/ethnicity, parental


education, lunch type, information about whether students have
completed a test preparation course, and students scores for maths,
reading and writing. Data has 8 columns and 1001 row. Data is
formatted into a table.

By analysing this data set we could answer the following questions:

 How effective is the test preparation course?


 Which major factors contribute to test outcomes?
 Is there a correlation between race/ethnicity, parental education and pupils test score?
 What patterns and interactions in the data can you find?

Data source: Public Domain, Kaggle dataset

ROCCC (reliable, original, comprehensive, current, cited) integrity: The data integrity and credibility is
insufficient to provide reliable and comprehensive insights as we have no information about how and when
was the data collected, data sample selection and data source, therefore instead of completing full analysis I
will apply my Excel skills to create Data visualizations/Dashbords to show my key findings

Analysis tool: MC Excel

Process/clean data
1. Check for empty cells.
Conditional formatting – New rule – Format only cells that contain ‘Blanks’

No empty cells identified.


2. Remove duplicates.
We are unable to use this data cleaning action due to the lack of unique data keys e.g. student’s name/id

3. Make sure score value’s are in consistent by using LEN function

Some students scored 100 or 0 which is completely normal, and we haven’t found any inconsistent format data in
columns F-H. Temporarily columns can be deleted.

Phase 4: Analysis
I am going to name my table ‘tbl’ to make it easier to perform calculations. I have added another column to
the table to calculate the average score for each student for all 3 subjects. The cell has been formatted to a
number.

Lets also count the population of males and females in the total amount of students in the Education
establishment using COUNTIF function. We have 52% of female against 48% of male.
Students gender population

48%, males
52%, females

females males

Let’s try to analyse our data by creating some Pivot tables and conditional formatting to highlight the highest
and the lowest average scores in our pivot tables to be able to draw some conclusions. Don’t forget to change
values to Average.

1. As we can see even though males get higher average score in maths, females generally are getting
higher average score in all 3 subjects.

Student Average score by gender

69.00
68.00
67.00 Average of math score
66.00 Average of reading score
Average of writing score
65.00
Average of Average score
64.00
63.00
62.00
61.00
60.00
male
Student Average score by gender

74.00
72.00
70.00 Average of math score
Average of reading score
68.00 Average of writing score
66.00 Average of Average score

64.00
62.00
60.00
58.00
female

2. From our next Pivot table we can see, that Group E ethnicity get the highest score, where Group A get the
lowest score the average and for each subject.

Student average score by ethnicity


74
72
70
68
Average of math score
66 Average of reading score
64 Average of writing score
62
60
58
56
54
group A group B group C group D group E

3. By using COUNTIF function we also can find the percentage of the students, who gets prepared for
the exam against those who aren’t. The students, who completed Test preparation course are getting
better score results than those, who hasn’t.
Precentage of students who have/haven't
completed test preparation

36%

64%

Completed test preparation Not completed test preparation

Average score of those who have/haven't completed


preparation

74
72
70 Total

68
66
64
62
60
completed none

We can also find out which gender seem to get more prepared for the test by making some
calculations. I’ve found the total amount of males and females who have complete/not completed
preparation for the test by using COUNTIF function.
I’ve created a multi-level donut chart to compare which gender seems to get more prepared for the
test. From the chart we can see, that even though we have slight difference in numbers of
females/males preparing for the test, both genders equally getting prepared for the test with 36% of
both: females and males are preparing for the test.

Hierarchical relationships between the gender


and test preparation
Males

Females
334; 184;
64% 36%

308; 64% 174; 36%

Completed preparation Not completed preparation


4. Parental education also influences students score, as the students with the highest parental education
are getting higher scores for all 3 subjects, where the lowest score shown for those students, who’s
parents have high school education.

Student average score vs parental education


80
70
60
50
Average of math score
40
Average of reading score
30 Average of Average score
20 Average of writing score
10
0
ee ee ol ee ge ol
e gr egr cho egr l le cho
sd d h
s d co h
s
te' or's hig e r's m
e
hig
l t so
cia he as e
s so b ac m s om
a
Deliverable.
We have analysed data, and we can make the following conclusions:
- There are more females in the school than males in proportion of 52% females to 48% males.
- Even though males get higher average score in maths, females generally are getting higher average
score in all 3 subjects.
- Group E ethnicity get the highest score, where Group A get the lowest score the average and for each
subject.
- The students, who completed Test preparation course are getting better score results than those, who
hasn’t with 36% of students getting prepared for the test against 64% of student who doesn’t out of
all student population.
- Males and females are equally getting prepared for the test.
- Parental education also influences students score, as the students with the highest parental education
are getting higher scores for all 3 subjects, where the lowest score shown for those students, whose
parents have high school education.
- To make it easier for the teachers to navigate our analysis I have created static Dashboard in Excel.

Common questions

Powered by AI

Parental education has a substantial impact, as students with parents having higher education achieve better scores. Ethnicity also plays a notable role with certain groups scoring consistently higher. While gender differences affect certain subject scores, overall these demographic factors interplay to influence academic outcomes .

Demographic features such as gender, race/ethnicity, and parental education intersect to shape academic outcomes. For instance, while females generally score higher, Group E ethnicity outperforms others, and students with higher parental education achieve better results. Understanding these interactions can help design targeted interventions .

Participation in test preparation is evenly split between genders but those students whose parents have higher education tend to perform better even with similar preparation levels. This indicates that test preparation alone is not a comprehensive solution and must be viewed alongside demographic factors .

Among different ethnic groups, Group E students achieved the highest scores while Group A had the lowest scores for each subject. This demonstrates a clear correlation between ethnicity and academic performance, indicating that demographic factors can significantly influence student outcomes .

Data visualization, such as pivot tables and dashboards, allows educators to identify patterns and differences in academic performance across demographics, such as gender and ethnicity. Visual insights make it easier to comprehend large datasets quickly, highlight high and low performers, and support data-driven educational strategies .

Both males and females participate equally in test preparation, with 36% of students from each gender completing it. This suggests no significant gender disparity in the participation in test preparation courses .

Students whose parents have attained higher education levels tend to score higher across all subjects compared to those whose parents only completed high school. This suggests that parental education is a significant factor in determining student academic achievement .

Females constitute 52% of the student population while males make up 48%. Despite more females, both genders equally engage in test preparation. However, females show consistently higher scores in reading and writing, contributing to an overall higher average performance for females .

Students who completed a test preparation course scored better than those who did not. About 36% of the students completed the preparation, and these students achieved higher average scores across subjects compared to the 64% who did not complete the course . This suggests that participation in a test preparation course positively impacts academic performance.

Females generally achieve higher average scores across all subjects compared to males, despite males scoring higher in mathematics alone. This indicates that females outperform males in reading and writing, thereby raising their overall average scores .

You might also like