{% extends "exams/base.html" %} {% load static %} {% load dict_extras %} {% block content %}

O-Level Combined Report: {{ project.name }}

{{ project.year }} | {{ project.academic_level.name }}

Registered Students
{{ registered_total }}
F: {{ registered_f }} | M: {{ registered_m }}
Pass Rate (I-III)
{{ gender_div.T.percent_I_III }}%
Div I-III: {{ gender_div.T.total_I_III }} / {{ gender_div.T.total_sat }}
Pass Rate (I-IV)
{{ gender_div.T.percent_I_IV }}%
Div I-IV: {{ gender_div.T.total_I_IV }} / {{ gender_div.T.total_sat }}
Overall GPA
{{ overall_table.overall_gpa|floatformat:4 }}
Subject: {{ overall_table.subject_gpa|floatformat:4 }} | Div: {{ overall_table.division_gpa|floatformat:4 }}
TOTAL SCHOOLS
{{ total_schools_count }}
{{ total_students_count }} Students
GOVERNMENT SCHOOLS
{{ govt_schools_count }}
{{ govt_students_count }} Students
NON-GOVERNMENT SCHOOLS
{{ nongvt_schools_count }}
{{ nongvt_students_count }} Students
Registration & Attendance Summary
Description Female Male Total
Registered Students {{ registered_f }} {{ registered_m }} {{ registered_total }}
Students Who Sat {{ sat_f }} {{ sat_m }} {{ sat_total }}
Absentees {{ absent_f }} {{ absent_m }} {{ absent_total }}
Attendance Rate: {% widthratio sat_total registered_total 100 %}% ({{ sat_total }} out of {{ registered_total }} students)
GPA Performance Summary
Subject GPA

{{ overall_table.subject_gpa|floatformat:4 }}

Based on A=1, B=2, C=3, D=4, F=5
Division GPA

{{ overall_table.division_gpa|floatformat:4 }}

Based on I=1, II=2, III=3, IV=4, 0=5
Overall GPA

{{ overall_table.overall_gpa|floatformat:4 }}

(Subject GPA + Division GPA) รท 2
Division Performance by Gender
{% for sex in "FMT" %} {% endfor %}
SEX Division Counts I - III I - IV Total SAT
IIIIIIIV0 Total% Total%
{% if sex == 'F' %}FEMALE {% elif sex == 'M' %}MALE {% else %}TOTAL {% endif %} {{ gender_div|get_item:sex|get_item:"I" }} {{ gender_div|get_item:sex|get_item:"II" }} {{ gender_div|get_item:sex|get_item:"III" }} {{ gender_div|get_item:sex|get_item:"IV" }} {{ gender_div|get_item:sex|get_item:"0" }} {{ gender_div|get_item:sex|get_item:"total_I_III" }} {{ gender_div|get_item:sex|get_item:"percent_I_III" }}% {{ gender_div|get_item:sex|get_item:"total_I_IV" }} {{ gender_div|get_item:sex|get_item:"percent_I_IV" }}% {{ gender_div|get_item:sex|get_item:"total_sat" }}
Top Performing Schools
๐Ÿ† TOP 10 SCHOOLS OVERALL
{% for s in best_10_all %} {% endfor %}
#CODESCHOOL NAMEDISTRICTOWNERSATGPAGRADE
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:35 }} {{ s.school.district.name }} {{ s.school.ownership }} {{ s.with_results }} {{ s.gpa|floatformat:4 }} {{ s.gpa_grade|default:"-" }}
๐Ÿ† TOP 10 GOVERNMENT SCHOOLS
{% for s in best_10_gvt %} {% endfor %}
#CODESCHOOLGPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|truncatechars:30 }} {{ s.gpa|floatformat:4 }}
๐Ÿ† TOP 10 NON-GOVERNMENT SCHOOLS
{% for s in best_10_nongvt %} {% endfor %}
#CODESCHOOLGPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|truncatechars:30 }} {{ s.gpa|floatformat:4 }}
๐Ÿ“Š TOP 10 SCHOOLS WITH 30+ CANDIDATES
{% for s in best_40_std_andabove %} {% empty %} {% endfor %}
#CODESCHOOLSATGPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|truncatechars:25 }} {{ s.total_sat }} {{ s.gpa|floatformat:4 }}
No schools with 30+ candidates
๐Ÿ“‹ TOP 10 SCHOOLS WITH LESS THAN 30 CANDIDATES
{% for s in best_40_less %} {% empty %} {% endfor %}
#CODESCHOOLSATGPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|truncatechars:25 }} {{ s.total_sat }} {{ s.gpa|floatformat:4 }}
No schools with less than 30 candidates
Top Performing Students
๐Ÿ‘จโ€๐ŸŽ“ TOP 10 STUDENTS OVERALL
{% for s in best_students %} {% endfor %}
#CAND NONAMESEXSCHOOLPOINTSDIV
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name|truncatechars:25 }} {{ s.student.sex }} {{ s.student.school.name_short|truncatechars:30 }} {{ s.total_points }} {{ s.division }}
๐Ÿ‘ง TOP 10 GIRLS
{% for s in best_girls %} {% endfor %}
#NAMESCHOOLPOINTS
{{ forloop.counter }} {{ s.student.full_name|truncatechars:25 }} {{ s.student.school.name_short|truncatechars:25 }} {{ s.total_points }}
๐Ÿ‘ฆ TOP 10 BOYS
{% for s in best_boys %} {% endfor %}
#NAMESCHOOLPOINTS
{{ forloop.counter }} {{ s.student.full_name|truncatechars:25 }} {{ s.student.school.name_short|truncatechars:25 }} {{ s.total_points }}
Subject Performance Summary
{% for subject in processed_subject_summary %} {% endfor %}
CODE SUBJECT SAT A B C D F PASS (A-D) % GPA
{{ subject.subject_code }} {{ subject.subject_name }} {{ subject.sat }} {{ subject.A }} {{ subject.B }} {{ subject.C }} {{ subject.D }} {{ subject.F }} {{ subject.pass_total }} {{ subject.pass_percent }}% {{ subject.subject_gpa|floatformat:4 }}
TOTAL / AVERAGE: {{ subject_totals.sat }} {{ subject_totals.A }} {{ subject_totals.B }} {{ subject_totals.C }} {{ subject_totals.D }} {{ subject_totals.F }} {{ subject_totals.A|add:subject_totals.B|add:subject_totals.C|add:subject_totals.D }} {{ subject_totals.overall_pass_percent }}% -
๐Ÿ“Š GPA Scale (O-Level): A=1, B=2, C=3, D=4, F=5 | Lower GPA indicates better performance
Generated on {% now "F j, Y H:i:s" %} | {{ project.name }} ({{ project.year }}) | O-Level Combined Report
{% endblock %}