MANAGERIAL USE OF ICT IN SCHOOL
GRADE BOOK : CLASSROOM LEVEL MARKS MANAGEMENT
Class tests and exams for aggregating and positioning
School teachers have to conduct end of month tests. These
are tallied for the various subjects and are displayed for
presentation on parent visits. The same marks are managed
and are included in the end of term reports. Some schools
have a scheme where these tests contribute to the end of term
evaluation. In Uganda, there will soon be a system where continous
assessment will contribute to the Primary Leaving Examinations.
In the tertiary institutions, this is already the case.
Accordingly, the application of ICT for class management
liberates the teacher to concentrate on more demanding and
unstructured tasks such as lesson plans, and professional
A spreadsheet application is very appropriate for such a
task. We have developed a simple spreadsheet to demonstrate
marks management in class.
Click here to view this example.
This is the tutorial that explains this example.
The spreadsheet is set up with names of pupils in Column A;
The Subject names as set up in columns C, D, E and F.
Student marks are Aggregated (totalled) via the sum function
in column G.
A sort is performed of the data on the total Column in descending
order to obtain their order of merit.
Finally a function is developed in column H, to determine
the position of each student. The function uses an if as follows:
The top student is ranked first with a 1 in cell H6. A relative
formula is applied to determine subsequent positions as follows:
G7= If (G7=G6) then H7=H6
But we notice that this fails if there are ties in position
beyond just one.
Accordingly, we introduce a count on the
number of ties in Colum I.>/span>
The tie for the first student I6 is set
to 0 and subseqent ties are computed as:If (H7=H6) then
I7 = I6+1;
Then the formula for position is modified
G7 = If (G7=G6) then H7=H6
Else H7 = H6+1+I6