score2grade is a program what will use the exam scores to predict DSE grades.
Core subjects include Chinese, English, Mathematics and Liberal Study. The full mark of these subjects is 300. Make sure the grading ranges have 300 as full mark.
The full mark of electives subjects is 200 (with the exception of M2). Make sure the grading ranges have 200 as full mark.
M2 will be treated as an elective subject, but the full mark of M2 is 100.
Combined science (cscb) is an elective subject, consisted of 2 parts: Biology (csb) and Chemistry (csc). The exam score of each part be graded separately. The final grade of cscb will be the rounded average of two parts.
Users have to provide THREE (3) xlsx documents for converting the exam scores to DSE grades.
The file should have the format as below:
| grade | chi | eng | math | ls | bafs | bio | ... |
|---|---|---|---|---|---|---|---|
| 0 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 1 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 2 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 3 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 4 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 5 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 6 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
| 7 | min, max | min, max | min, max | min, max | min, max | min, max | min, max |
Each column (beyond the first) corresponds to a the grade ranges for an exam.
Scores have to be rounded first, the grading ranges are not continuous. So both min and max are inclusive.
The score file stores the all exam scores of all students. Each sheet only contains score of one subject, the sheet name should be named with subject code. The following table is an example of Subject Chinese in sheet named with chi
| classcode | ename | cname | chi |
|---|---|---|---|
| 6A01 | xx | xx | xx |
| 6A02 | xx | xx | xx |
| 6A03 | xx | xx | xx |
| 6A04 | xx | xx | xx |
| 6A05 | xx | xx | xx |
| 6A06 | xx | xx | xx |
| 6A07 | xx | xx | xx |
The students file stores all the student basic information where x1 and x2 is the subject code of their electives. If student also takes m2, the value in m2 is any truthy value.
| classcode | ename | cname | x1 | x2 | m2 |
|---|---|---|---|---|---|
| 6A01 | xx | xx | bio | hist | |
| 6A02 | xx | xx | chist | cscb | m2 |
| 6A03 | xx | xx | phy | chem | m2 |
| 6A04 | xx | xx | bafs | econ | |
| 6A05 | xx | xx | bafs | ict | |
| 6A06 | xx | xx | va | ||
| 6A07 | xx | xx | ths | ict | m2 |
The output will be an xlsx document with the following information:
- classcode
- ename
- cname
- ...grades of the student for core subjects
- x1 (subject code of student's x1)
- x1_grade (grade of student's x1)
- x2 (subject code of student's x2)
- x2_grade (grade of student's x2)
- m2 (grade of student's m2)