Grade Distribution CSIT copy.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Grade distribution by course
2
3
4	Summary dashboard and course-level grade distribution
5
6	Total courses		Courses with data		To be added later		Average fail rate		Total grade records
7	26		25		1		20.7%		2430
8	Across Year 1 to Year 3		Ready for reporting		Blank grade rows kept		Complete courses only		Recorded outcomes
9
10	Overall grade mix			Year summary
11	Grade	Count		Year	Pass count	Fail count	Success rate	Average fail rate	Courses with data	Courses pending	Total records
12	High Distinction	537		Year 1	654	218	75.0%	25.1%	9	1	872
13	Distinction	591		Year 2	682	184	78.8%	21.7%	9	0	866
14	Credit	450		Year 3	597	95	86.3%	13.8%	7	0	692
15	Pass	355
16	Fail	497
17	Note: blank grade cells and pending course rows have been kept visible so new grade distributions can be added later.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35	Detailed course data
36	Year	Course	High Distinction	Distinction	Credit	Pass	Fail	Total	Success rate	Fail rate	Status	Enrolment
37	Year 1	Computing Innovations of the Modern World	1	13	26	26	31	97	68.0%	32.0%	Complete	342
38	Year 1	Structured Data	29	20	13	10	26	98	73.5%	26.5%	Complete	779
39	Year 1	IT Systems	24	28	12	3	19	86	77.9%	22.1%	Complete	481
40	Year 1	Probability and Statistics	8	14	23	29	25	99	74.7%	25.3%	Complete	118
41	Year 1	System Requirements									To be added later
42	Year 1	Maths for Machine Learning	56	19	7	8	8	98	91.8%	8.2%	Complete	84
43	Year 1	Discrete Mathematics	13	10	22	28	27	100	73.0%	27.0%	Complete	142
44	Year 1	Foundations of Mathematics	5	9	11	22	48	95	49.5%	50.5%	Complete	193
45	Year 1	Network Foundations	16	26	21	15	22	100	78.0%	22.0%	Complete	73
46	Year 1	Security Foundations	42	33	8	4	12	99	87.9%	12.1%	Complete	342
47	Year 2	Software Development Practices	12	16	17	10	41	96	57.3%	42.7%	Complete	242
48	Year 2	Data Structures and Algorithms	3	28	31	15	21	98	78.6%	21.4%	Complete	144
49	Year 2	Algorithm and Data Structure Analysis	13	23	17	22	24	99	75.8%	24.2%	Complete	111
50	Year 2	Computer Systems	17	12	11	16	34	90	62.2%	37.8%	Complete	146
51	Year 2	Artificial Intelligence	35	31	20	10	3	99	97.0%	3.0%	Complete	210
52	Year 2	Network Design	8	15	17	14	32	86	62.8%	37.2%	Complete	189
53	Year 2	Ethical and Legal Challenges in Technology	16	45	20	9	8	98	91.8%	8.2%	Complete	169
54	Year 2	Topics in Computer Science	44	31	19	0	6	100	94.0%	6.0%	Complete	16
55	Year 2	Unstructured Data	13	27	23	22	15	100	85.0%	15.0%	Complete	228
56	Year 3	Cybersecurity Fundamentals	4	17	25	37	16	99	83.8%	16.2%	Complete	236
57	Year 3	Event Driven Computing	11	24	30	22	12	99	87.9%	12.1%	Complete	105
58	Year 3	Artificial Intelligence (UoA)	13	16	16	7	46	98	53.1%	46.9%	Complete	61
59	Year 3	ICT Capstone 1	23	43	20	3	10	99	89.9%	10.1%	Complete	247
60	Year 3	ICT Capstone 2	36	29	18	10	6	99	93.9%	6.1%	Complete	242
61	Year 3	STEM Internship	81	19	0	0	0	100	100.0%	0.0%	Complete	14
62	Year 3	Design Patterns in C++	14	43	23	13	5	98	94.9%	5.1%	Complete	148
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100