FP20 Data-Driven Education Management Challenege by Arun

Summary

Report submitted for FP20 Analytics ZoomCharts Challenge 13 (Jan 17 – Feb 15, 2024). The report was built with Education Management dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI. 

Author's description:
Year Wise Key Points for 2022-2024
1. Total No. of Students enrolled are 6392.
2. Total No. courses taught in the schools 784.
3. Total No. Teachers in Schools 314.
4. Total No. of tests given by students 44483, out of which 21084 test are given by females and 23399 tests are given by males.
5. Total No. of Students given test are 3210, out of which 1532 students are female and 1678 students are male.
6. Fivinp Ezngutzb, Oesnut Cqqz Litz scored maximum score 159 in 2022-2024.
7. 2501 (26.1%) maximum students are in average assessment level, out of which 1245 are females and 1256 are males.
8. 2568 (51.51%) maximum students are in average and above assessment level group., out of which 1288 are females and 1295 are males.
9. 3192 (33.66%) maximum students given assessment on Comprehension, 1523 are females and 1669 are males.
10. Maximum Students (804, 11.1%) got grade 4 in test, 365 are females and 439 are males.
11. In Female Students, Maximum Female students (374, 10.9%) get grade 2 in test.
12. Zyjxi, Mirri Gybls scored maximum score 154 in male students and Fivinp Ezngutzb, Oesnut Cqqz Litz scored maximum score 159 in 2022-2024.

Fall Semester Wise Key Points for 2022-2024
1. 18281 tests are given by students in Fall semesters, out of which 8655 are given by Females and 9626 tests are given by males.
2. 3048 students given test in Fall semesters out of which 1455 are Females and 1593 are males.
3. Fivinp Ezngutzb, Oesnut Cqqz Litz scored maximum score 159 in 2022-2024 in Fall Semester
4. 2187 (30.0%) maximum students in Fall semesters are in average assessment level, out of which 1092 are females and 1095 are males.
5. 2295 (52.21%) maximum students in Fall Semesters are in average and above assessment level group., out of which 1163 are females and 1139 are males.
6. 3009 (33.53%) maximum students given assessment on Comprehension in Fall Semesters, 1435 are females and 1574 are males.
7. Maximum Students (782, 12.6%) got grade 4 in test in Fall Semesters, 357 are females and 427 are males.
8. In Female students, Maximum Female students (362, 12.6%) get grade 2 in test in Fall Semesters.
9. Rituin, Wztgin Azhb scored maximum score 147 in male students and Fivinp Ezngutzb, Oesnut Cqqz Litz scored maximum score 159 in 2022-2024 in Fall Semesters.

Spring Semester Wise Key Points for 2022-2024

1. 12507 tests are given by students in spring semesters, out of which 5906 are given by Females and 6601 tests are given by males.
2. 2719 students given test in spring semesters out of which 1287 are Females and 1432 are males.
3. Zyjxi, Miri Gybls scored maximum score 154 in 2022-2024 in Spring Semesters.
4. 1974 (32.9%) maximum students in Spring semesters are in average assessment level, out of which 978 are females and 996 are males.
5. 2167 (58.95%) maximum students in Spring Semesters are in average and above assessment level group., out of which 1086 are females and 1081 are males.
6. 2692 (34.82%) maximum students given assessment on Comprehension in Spring Semesters, 1274 are females and 1418 are males.
7. Maximum Students (508, 11.6%) get grade 2 in test in Spring Semesters, 228 are females and 280 are males.
8. In Female students, Maximum Female students (239, 11.5%) got grade 1 in test in Spring Semesters.
9. Zyjxi, Miri Gybls scored maximum score 154 in male students and Ruiavnioep, Ybbsadt Gitzi scored maximum score 151 in 2022-2024 in Spring Semesters.

Winter Semester Wise Key Points for 2022-2024
1. 13695 tests are given by students in Winter semesters, out of which 6523 are given by Females and 7172 tests are given by males.
2. 2922 students given test in Winter semesters out of which 1385 are Females and 1029 are males.
3. Zyjxi, Miri Gybls scored maximum score 151 in 2022-2024 in Winter Semesters.
4. 2087 (31.4%) maximum students in Winter semesters are in average assessment level, out of which 1058 are females and 1103 are males.
5. 2235 (54.77%) maximum students in Winter Semesters are in average and above assessment level group., out of which 1132 are females and 1507 are males.
6. 2885 (33.82%) maximum students given assessment on Comprehension in Winter Semesters, 1378 are females and 1507 are males.
7. Maximum Students (520, 10.8%) get grade 3 in test in Winter Semesters, 241 are females and 279 are males.
8. In Female students, Maximum Female students (246, 10.7%) got grade 1 in test in Winter Semesters.
9. In Male Students, 280 (11.1%) got grade 2 in tests in Winter Semesters
10. Zyjxi, Miri Gybls scored maximum score 151 in male students and Idinkait, Hibbz Xzgibstt scored maximum score 149 in 2022-2024 in Winter Semesters.

Key points for academic year 2021-22
1. Total No. of tests given by students 19136, out of which 9137 test are given by females and 9999 tests are given by males.
2. Total No. of Students given test are 2503, out of which 1188 students are female and 1315 students are male.
3. Zyjxi, Mirri Gybls scored maximum score 154
4. 1947 (29.8%) maximum students are in average assessment level, out of which 967 are females and 980 are males.
5. 2025 (54.41%) maximum students are in average and above assessment level group., out of which 1015 are females and 1010 are males.
6. 2478 (33.4%) maximum students given assessment on Comprehension, 1180 are females and 1298 are males.
7. Maximum Students (263, 10.5%) got grade 2 in test, 121 are females and 142 are males.
8. In Female Students, Maximum Female students (124, 10.4%) get grade 6 in test.
9. Zyjxi, Mirri Gybls scored maximum score 154 in male students and Ruiavnioep, Ybbsadt Gitzi scored maximum score 150.
10. 10.92% more tests and 1.13 % less tests are given by students in Winter and Spring semesters w.r.t Fall Semester.
11. 10.39 % and 3% more students gave tests in Winter and Spring Semesters w.r.t. Fall Semester.

Key points for academic year 2022-23
1. Total No. of tests given by students 19268, out of which 9071 test are given by females and 10197 tests are given by males.
2. Total No. of Students given test are 2664, out of which 1270 students are female and 1394 students are male.
3. Ruiavnioep, Ybbsadt Gitzi scored maximum score 151
4. 1957 (29.0%) maximum students are in average assessment level, out of which 976 are females and 981 are males.
5. 2085 (54.21%) maximum students are in average and above assessment level group., out of which 1050 are females and 1035 are males.
6. 2658 (35.84%) maximum students given assessment on Comprehension, 1266 are females and 1392 are males.
7. Maximum Students (292, 10.9%) got grade 3 in test, 130 are females and 162 are males.
8. In Female Students, Maximum Female students (140, 11.0%) get grade 1 in test.
9. Aznadta, Hnztgp Vinnitoi scored maximum score 146 in male students and Ruiavnioep, Ybbsadt Gitzi scored maximum score 151
10. 13.57% and 6.22 % more tests are given by students in Winter and Spring semesters w.r.t Fall Semester.
11. 20.72 % and 7.39 % more students gave tests in Winter and Spring Semesters w.r.t. Fall Semester

Key points for academic year 2023-24
1. Total No. of tests given by students 6079, out of which 2876 test are given by females and 3203 tests are given by males.
2. Total No. of Students given test are 2062, out of which 976 students are female and 1086 students are male.
3. Fivinp Ezngutzb, Oesnut Cqqz scored maximum score 159.
4. 1348 (34.8%) maximum students are in average assessment level, out of which 686 are females and 662 are males.
5. 1478 (54.21%) maximum students are in average and above assessment level group., out of which 745 are females and 733 are males.
6. 2036 (35.84%) maximum students given assessment on Comprehension, 960 are females and 1076 are males.
7. Maximum Students (280, 13.6%) got grade 4 in test, 121 are females and 159 are males.
8. In Female Students, Maximum Female students (136, 13.9%) get grade 2 and 5 both in test.
9. Rituin, Wztgin Azhb scored maximum score 147 in male students and Fivinp Ezngutzb, Oesnut Cqqz scored maximum score 159
10. 13.57% and 6.22 % more tests are given by students in Winter and Spring semesters w.r.t Fall Semester.
11. 20.72 % and 7.39 % more students gave tests in Winter and Spring Semesters w.r.t. Fall Semester

Other Key Points:
1. No. of Students in test decrease by 2.83% and 2.55% in Fall 2022-23 and Fall 2023-24 w.r.t Fall 2021-22. But there is no major change in number of students in test in Fall semesters.
2. 1.08% increase in no. of students in test in spring semester in 2022-23 w.r.t 2021-22.
3. 5.88 % more students given tests in winter semester 2022-23 w.r.t 2021-22.
4. 10.98% increase and 7.58 % decrease in tier 2 students in winter and spring semesters resp. w.r.t fall semester in 2022 while 3.68% and 28.99 % decrease in tier 3 students in winter and spring semesters resp. w.r.t fall semester in 2022.
5. 13.78% and 0.26% increase in tier 2 students in winter and spring semesters resp. w.r.t fall semester in 2023 while 5.73% increase and 24.78 % decrease in tier 3 students in winter and spring semesters resp. w.r.t fall semester in 2023.
6. 1% decrease in tier 2 students in 2023 Fall semester w.r.t 2022 Fall Semester and 3.3% decrease in tier 2 students in 2024 Fall semester w.r.t 2023 Fall Semester. This implies that Every year No. of students in tier 2 are decreasing in Fall Semester.
7. 0.61% increase in tier 3 students in 2023 Fall semester w.r.t 2022 Fall Semester and 2.8 % decrease in tier 3 students in 2024 Fall semester w.r.t 2023 Fall Semester.
8. 7.35 % and 6.57 % increase in tier 2 and tier 3 students resp. in 2023 spring Semester w.r.t 2022 spring semester.
9. 1.55% and 5.84% overall increase in tier 2 and tier 3 students from 2022 to 2023.
10. 10.39 % increase and 7.79% decrease in tier 2 teachers in winter and spring semesters resp. w.r.t fall semester in 2022 while 3.68% and 28.83 % decrease in tier 3 teachers in winter and spring semesters resp. w.r.t fall semester in 2022.
11. 15.78 % increase and no change in tier 2 teachers in winter and spring semesters resp. w.r.t fall semester in 2023 while 5.48 % increase and 25% decrease in tier 3 teachers in winter and spring semesters resp. w.r.t fall semester in 2023.
12. 1.29 % decrease in tier 2 teachers in 2023 Fall semester w.r.t 2022 Fall Semester and 3.94% decrease in tier 2 teachers in 2024 Fall semester w.r.t 2023 Fall Semester. This implies that Every year No. of tier 2 teachers required in fall semester are decreasing.
13. 0.61 % increase in tier 3 teachers in 2023 Fall semester w.r.t 2022 Fall Semester and 3.00% decrease in tier 3 teachers in 2024 Fall semester w.r.t 2023 Fall Semester.
14. 6.57 % and 6.03% increase in requirement in tier 2 and tier 3 teachers resp. in 2023 spring Semester w.r.t 2022 spring semester.
15. 2.22 % and 5.75 % overall increase in requirement in tier 2 and tier 3 teachers resp. from 2022 to 2023.
16. Total testing cost is 0.73% more and 22.30% less in winter and spring semesters as compared to fall semester in 2022.
17. Total testing cost is 5.25 % more and 14.57 % less in winter and spring semesters as compared to fall semester in 2023.
18. Total Testing cost decreases 1.22% in Fall Semester in 2023 as compared to fall semester in 2022 and 1.46 % increase in testing cost in fall semester 2024 as compared to fall semester 2023.
19. Total testing cost increases 3.2% and 8.59 % in winter and spring semesters in 2023 as compared to 2022.
20. Overall increase in testing cost in 2023 as compared to 2022 is 3.11%.
21. 34.35% and 26.19 % more courses have been started in schools in 2021-22 as compared to 2020-21 and 2022-23 as compared to 2021-22 respectively.
22. 38.99% and 9.04 % more teachers were in schools in 2021-22 as compared to 2020-21 and 2022-23 as compared to 2021-22 respectively. This implies that increase in appointment of teachers is decreasing every year due to decrease in more courses in each year.
23. In view of assessment cost, 2227 students are giving test of assessment cost 1 Euro, out of which 1447 are tier 2 students and 1612 are tier 3 students.