{% load static %} {% load dict_extras %} O-LEVEL JOINT EXAMS REPORT – PRINT MASTER
FLAG watermark

THE UNITED REPUBLIC OF TANZANIA

Coat of Arms

PRIME MINISTER'S OFFICE – REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT (PMO-RALG)

{{ project.project_place }}

{{ project.name }}

GENERAL PERFORMANCE GRAPH

{% with total_sat=gender_div.T.total_sat|default:1 %} {% with pass_i_iv=gender_div.T.total_I_IV|default:0 %} {% with fail_0=gender_div.T.0|default:0 %} {% with pass_i_iii=gender_div.T.total_I_III|default:0 %} {% with fail_iv_0=gender_div.T.IV|add:gender_div.T.0|default:0 %} {% widthratio pass_i_iv total_sat 100 as pass_i_iv_pct %} {% widthratio fail_0 total_sat 100 as fail_0_pct %} {% widthratio pass_i_iii total_sat 100 as pass_i_iii_pct %} {% widthratio fail_iv_0 total_sat 100 as fail_iv_0_pct %}
DIVISION I-IV vs DIVISION 0
DIV I-IV
{{ pass_i_iv }} ({{ pass_i_iv_pct }}%)
DIV 0
{{ fail_0 }} ({{ fail_0_pct }}%)
DIVISION I-III vs DIVISION IV+0
PASS I-III
{{ pass_i_iii }} ({{ pass_i_iii_pct }}%)
FAIL IV+0
{{ fail_iv_0 }} ({{ fail_iv_0_pct }}%)
{% endwith %} {% endwith %} {% endwith %} {% endwith %} {% endwith %} {% with max_value=gender_div.T.I|add:gender_div.T.II|add:gender_div.T.III|add:gender_div.T.IV|add:gender_div.T.0 %} {% with max_bar=200 %}

DIVISION PERFORMANCE BREAKDOWN

DIV I
{{ gender_div.T.I }}
DIV II
{{ gender_div.T.II }}
DIV III
{{ gender_div.T.III }}
DIV IV
{{ gender_div.T.IV }}
DIV 0
{{ gender_div.T.0 }}
Total: {{ max_value }} candidates | Peak: {% if gender_div.T.I >= gender_div.T.II and gender_div.T.I >= gender_div.T.III and gender_div.T.I >= gender_div.T.IV and gender_div.T.I >= gender_div.T.0 %} DIV I ({{ gender_div.T.I }}) {% elif gender_div.T.II >= gender_div.T.III and gender_div.T.II >= gender_div.T.IV and gender_div.T.II >= gender_div.T.0 %} DIV II ({{ gender_div.T.II }}) {% elif gender_div.T.III >= gender_div.T.IV and gender_div.T.III >= gender_div.T.0 %} DIV III ({{ gender_div.T.III }}) {% elif gender_div.T.IV >= gender_div.T.0 %} DIV IV ({{ gender_div.T.IV }}) {% else %} DIV 0 ({{ gender_div.T.0 }}) {% endif %}
{% endwith %} {% endwith %}
PMO-RALG - {{ project.project_place }}
{{ project.name }}
REGISTRATION & ATTENDANCE SUMMARY

STUDENTS REGISTRATION SUMMARY

DESCRIPTION F M TOTAL
REGISTERED STUDENTS {{ registered_f|default:"0" }} {{ registered_m|default:"0" }} {{ registered_total|default:"0" }}
STUDENTS SAT FOR EXAMS {{ sat_f|default:"0" }} {{ sat_m|default:"0" }} {{ sat_total|default:"0" }}
ABSENTEES {{ absent_f|default:"0" }} {{ absent_m|default:"0" }} {{ absent_total|default:"0" }}
ATTENDANCE RATE: {% widthratio sat_total registered_total 100 %}% ({{ sat_total }} out of {{ registered_total }} students)

DIVISION PERFORMANCE BY GENDER

{% for sex in "FMT"|make_list %} {% endfor %}
SEX DIVISION COUNTS I - II I - III I - IV
I II III IV 0 Total % Total % Total %
{% if sex == 'F' %}FEMALE {% elif sex == 'M' %}MALE {% else %}TOTAL {% endif %} {{ gender_div|get_item:sex|get_item:"I"|default:"0" }} {{ gender_div|get_item:sex|get_item:"II"|default:"0" }} {{ gender_div|get_item:sex|get_item:"III"|default:"0" }} {{ gender_div|get_item:sex|get_item:"IV"|default:"0" }} {{ gender_div|get_item:sex|get_item:"0"|default:"0" }} {{ gender_div|get_item:sex|get_item:"total_I_II"|default:"0" }} {{ gender_div|get_item:sex|get_item:"percent_I_II"|default:"0.00" }}% {{ gender_div|get_item:sex|get_item:"total_I_III"|default:"0" }} {{ gender_div|get_item:sex|get_item:"percent_I_III"|default:"0.00" }}% {{ gender_div|get_item:sex|get_item:"total_I_IV"|default:"0" }} {{ gender_div|get_item:sex|get_item:"percent_I_IV"|default:"0.00" }}%
TOTAL SAT: F: {{ gender_div.F.total_sat|default:"0" }} | M: {{ gender_div.M.total_sat|default:"0" }} | Total: {{ gender_div.T.total_sat|default:"0" }}

OVERALL DIVISION AND GRADES PERFORMANCE SUMMARY

DIV I II III IV 0 GRADE A B C D F OVERALL
TOTAL {{ overall_table.divisions.I }} {{ overall_table.divisions.II }} {{ overall_table.divisions.III }} {{ overall_table.divisions.IV }} {{ overall_table.divisions.0 }} GRADES {{ overall_table.grades.A }} {{ overall_table.grades.B }} {{ overall_table.grades.C }} {{ overall_table.grades.D }} {{ overall_table.grades.F }} {{ overall_table.overall_gpa }}
Subject GPA: {{ overall_table.subject_gpa }} (A=1, B=2, C=3, D=4, F=5)
Division GPA: {{ overall_table.division_gpa }} (I=1, II=2, III=3, IV=4, 0=5)
Overall GPA: {{ overall_table.overall_gpa }} (Subject GPA + Division GPA) ÷ 2
PMO-RALG - {{ project.project_place }}
{{ project.name }}
BEST PERFORMING SCHOOLS – {{ project.year }}

BEST 10 SCHOOLS (OVERALL)

{% for s in best_10_all %} {% endfor %}
# CENTRE SCHOOL DISTRICT OWNER #SAT DIVISION COUNTS I - III I - IV GPA
I II III IV 0 Total % Total %
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:20 }} {{ s.school.district.name }} {{ s.school.ownership }} {{ s.total_sat|default:"0" }} {{ s.t_i|default:"0" }} {{ s.t_ii|default:"0" }} {{ s.t_iii|default:"0" }} {{ s.t_iv|default:"0" }} {{ s.t_o|default:"0" }} {{ s.pass_i_iii|default:"0" }} {{ s.pass_i_iii_pct|floatformat:1 }}% {{ s.pass_i_iv|default:"0" }} {{ s.pass_i_iv_pct|floatformat:1 }}% {{ s.gpa|floatformat:4 }}

BEST 10 GOVERNMENT SCHOOLS

{% for s in best_10_gvt %} {% endfor %}
# CENTRE SCHOOL DISTRICT #SAT DIVISION COUNTS I - III I - IV GPA
I II III IV 0 Total % Total %
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:20 }} {{ s.school.district.name }} {{ s.total_sat|default:"0" }} {{ s.t_i|default:"0" }} {{ s.t_ii|default:"0" }} {{ s.t_iii|default:"0" }} {{ s.t_iv|default:"0" }} {{ s.t_o|default:"0" }} {{ s.pass_i_iii|default:"0" }} {{ s.pass_i_iii_pct|floatformat:1 }}% {{ s.pass_i_iv|default:"0" }} {{ s.pass_i_iv_pct|floatformat:1 }}% {{ s.gpa|floatformat:4 }}

BEST 10 NON-GOVERNMENT SCHOOLS

{% for s in best_10_nongvt %} {% endfor %}
# CENTRE SCHOOL DISTRICT #SAT DIVISION COUNTS I - III I - IV GPA
I II III IV 0 Total % Total %
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:20 }} {{ s.school.district.name }} {{ s.total_sat|default:"0" }} {{ s.t_i|default:"0" }} {{ s.t_ii|default:"0" }} {{ s.t_iii|default:"0" }} {{ s.t_iv|default:"0" }} {{ s.t_o|default:"0" }} {{ s.pass_i_iii|default:"0" }} {{ s.pass_i_iii_pct|floatformat:1 }}% {{ s.pass_i_iv|default:"0" }} {{ s.pass_i_iv_pct|floatformat:1 }}% {{ s.gpa|floatformat:4 }}

📊 TOP 10 SCHOOLS WITH 40+ CANDIDATES (High enrollment schools)

{% for s in best_40_std_andabove %} {% empty %} {% endfor %}
# CENTRE SCHOOL DISTRICT OWNER #SAT DIVISION COUNTS I - III I - IV GPA
I II III IV 0 Total % Total %
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:20 }} {{ s.school.district.name }} {{ s.school.ownership }} {{ s.total_sat|default:"0" }} {{ s.t_i|default:"0" }} {{ s.t_ii|default:"0" }} {{ s.t_iii|default:"0" }} {{ s.t_iv|default:"0" }} {{ s.t_o|default:"0" }} {{ s.pass_i_iii|default:"0" }} {{ s.pass_i_iii_pct|floatformat:1 }}% {{ s.pass_i_iv|default:"0" }} {{ s.pass_i_iv_pct|floatformat:1 }}% {{ s.gpa|floatformat:4 }}
No schools with 30+ candidates

📋 TOP 10 SCHOOLS WITH LESS THAN 40 CANDIDATES (Small enrollment schools)

{% for s in best_40_less %} {% empty %} {% endfor %}
# CENTRE SCHOOL DISTRICT OWNER #SAT DIVISION COUNTS I - III I - IV GPA
I II III IV 0 Total % Total %
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short|default:s.school.name|truncatechars:20 }} {{ s.school.district.name }} {{ s.school.ownership }} {{ s.total_sat|default:"0" }} {{ s.t_i|default:"0" }} {{ s.t_ii|default:"0" }} {{ s.t_iii|default:"0" }} {{ s.t_iv|default:"0" }} {{ s.t_o|default:"0" }} {{ s.pass_i_iii|default:"0" }} {{ s.pass_i_iii_pct|floatformat:1 }}% {{ s.pass_i_iv|default:"0" }} {{ s.pass_i_iv_pct|floatformat:1 }}% {{ s.gpa|floatformat:4 }}
No schools with less than 30 candidates
Note: Rankings include only schools with valid GPA scores. Lower GPA indicates better performance.
End of School Ranking
PMO-RALG - {{ project.project_place }}
{{ project.name }}
TOP PERFORMING STUDENTS

🏆 OVERALL BEST 10 STUDENTS (Lowest Points)

{% for s in best_students %} {% empty %} {% endfor %}
# CAND NO NAME SEX SCHOOL AVERAGE AVG GRADE POINTS DIV
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|default:s.student.school.name|truncatechars:25 }} {{ s.std_average|floatformat:1|default:"-" }} {{ s.std_averagegrade|default:"-" }} {{ s.total_points|default:"-" }} {{ s.division|default:"-" }}
No data available

👩 BEST 10 GIRLS

{% for s in best_girls %} {% empty %} {% endfor %}
# CAND NO NAME SCHOOL AVERAGE AVG GRADE POINTS DIV
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name }} {{ s.student.school.name_short|default:s.student.school.name|truncatechars:20 }} {{ s.std_average|floatformat:1|default:"-" }} {{ s.std_averagegrade|default:"-" }} {{ s.total_points|default:"-" }} {{ s.division|default:"-" }}
No data available

👨 BEST 10 BOYS

{% for b in best_boys %} {% empty %} {% endfor %}
# CAND NO NAME SCHOOL AVERAGE AVG GRADE POINTS DIV
{{ forloop.counter }} {{ b.student.student_number }} {{ b.student.full_name }} {{ b.student.school.name_short|default:b.student.school.name|truncatechars:20 }} {{ b.std_average|floatformat:1|default:"-" }} {{ b.std_averagegrade|default:"-" }} {{ b.total_points|default:"-" }} {{ b.division|default:"-" }}
No data available

🏫 BEST 10 STUDENTS - GOVERNMENT SCHOOLS

{% for s in best_gvt_students %} {% empty %} {% endfor %}
# CAND NO NAME SEX SCHOOL AVERAGE AVG GRADE POINTS DIVISION
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|default:s.student.school.name|truncatechars:20 }} {{ s.std_average|floatformat:1|default:"-" }} {{ s.std_averagegrade|default:"-" }} {{ s.total_points|default:"-" }} {{ s.division|default:"-" }}
No data available

🏫 BEST 10 STUDENTS - NON-GOVERNMENT SCHOOLS

{% for s in best_nongvt_students %} {% empty %} {% endfor %}
# CAND NO NAME SEX SCHOOL AVERAGE AVG GRADE POINTS DIVISION
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|default:s.student.school.name|truncatechars:20 }} {{ s.std_average|floatformat:1|default:"-" }} {{ s.std_averagegrade|default:"-" }} {{ s.total_points|default:"-" }} {{ s.division|default:"-" }}
No data available
Note: Lower total points indicate better performance. Average is shown with 2 decimal places.
Points range: 7-35 (O-Level) where 7 = Best, 35 = Worst.
End of Best Performing Students
PMO-RALG - {{ project.project_place }}
{{ project.name }}
SUBJECT PERFORMANCE ANALYSIS (O-LEVEL)

📚 SUBJECT GRADES PERFORMANCE

{% for subject in processed_subject_summary %} {% empty %} {% endfor %} {% if processed_subject_summary %} {% endif %}
CODE SUBJECT SAT GRADE DISTRIBUTION A - D SUBJECT GPA
A B C D F Total %
{{ 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 }}
No subject data available
TOTALS / AVERAGE: {{ 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 }}% -

🏆 TOP 10 SUBJECTS BY GPA (Lower is Better)

{% for subject in top_subjects_by_gpa %} {% endfor %} {% if top_subjects_by_gpa %} {% endif %}
RANK CODE SUBJECT SAT GRADE COUNTS A - C A - D GPA
A B C D F # % # %
{{ forloop.counter }} {{ subject.subject_code }} {{ subject.subject_name|upper }} {{ subject.sat }} {{ subject.A|default:"0" }} {{ subject.B|default:"0" }} {{ subject.C|default:"0" }} {{ subject.D|default:"0" }} {{ subject.F|default:"0" }} {{ subject.A|default:0|add:subject.B|default:0|add:subject.C|default:0 }} {% with pass_ac=subject.A|default:0|add:subject.B|default:0|add:subject.C|default:0 %} {% widthratio pass_ac subject.sat 100 %}% {% endwith %} {{ subject.A|default:0|add:subject.B|default:0|add:subject.C|default:0|add:subject.D|default:0 }} {% with pass_ad=subject.A|default:0|add:subject.B|default:0|add:subject.C|default:0|add:subject.D|default:0 %} {% widthratio pass_ad subject.sat 100 %}% {% endwith %} {{ subject.subject_gpa|floatformat:4 }}
TOTALS / AVERAGE: {{ subject_totals.A|default:"0" }} {{ subject_totals.B|default:"0" }} {{ subject_totals.C|default:"0" }} {{ subject_totals.D|default:"0" }} {{ subject_totals.F|default:"0" }} {{ subject_totals.A|default:0|add:subject_totals.B|default:0|add:subject_totals.C|default:0 }} {% widthratio subject_totals.A|default:0|add:subject_totals.B|default:0|add:subject_totals.C|default:0 subject_totals.sat 100 %}% {{ subject_totals.A|default:0|add:subject_totals.B|default:0|add:subject_totals.C|default:0|add:subject_totals.D|default:0 }} {% widthratio subject_totals.A|default:0|add:subject_totals.B|default:0|add:subject_totals.C|default:0|add:subject_totals.D|default:0 subject_totals.sat 100 %}% {{ subject_totals.avg_gpa|floatformat:4|default:"-" }}
O-Level GPA Formula: (A×1 + B×2 + C×3 + D×4 + F×5) ÷ Total Candidates
Lower GPA indicates better performance. A-D = Pass, F = Fail
PMO-RALG - {{ region_name|default:"REGION" }}
{{ project.name }}
TOP STUDENTS PER SUBJECT (O-LEVEL)

🏆 BEST 10 STUDENTS IN EACH SUBJECT

Ranked by highest percentage score | Only valid scores (A-D) are included

{% if subject_best_list and subject_best_list|length > 0 %} {% for subject in subject_best_list %}

{{ subject.name|upper }} ({{ subject.code }}) Top {{ subject.rows|length }} Students

{% for student in subject.rows %} {% endfor %}
# CAND NO NAME SEX SCHOOL DISTRICT OWNER SCORE % GRADE
{{ student.rank }} {{ student.student_number|default:"-" }} {{ student.full_name|default:"-"|truncatechars:25 }} {{ student.sex|default:"-" }} {{ student.school_name|default:"-"|truncatechars:25 }} {{ student.district|default:"-" }} {{ student.school_ownership|default:"-" }} {{ student.percentage_score|default:"0" }} {{ student.grade|default:"-" }}
{% with subject.rows|first as first_student %} {% if first_student %} 🏆 Top Score: {{ first_student.percentage_score|default:"0" }}% (Grade {{ first_student.grade|default:"-" }}) {% endif %} {% endwith %}
{% endfor %} {% else %}

No subject performance data available

There are no valid percentage scores for any subject in this project.

{% endif %}
End of Subject Performance
SCHOOL RANKING OVERALL
{% for school in school_ranking_overall %} {% empty %} {% endfor %}
No. SCHOOLS DISTRICT REGION OWNERSHIP SAT DIVISION PERFOMANCE GPA RANK
I II III I - III IV I - IV 0 Overall --- --
No. % No. % No. %
{{ school.overall_rank }} {{ school.name_short|default:school.school_name|truncatechars:25 }} {{ school.district }} {{ school.region }} {{ school.ownership }} {{ school.total_sat }} {{ school.t_i }} {{ school.t_ii }} {{ school.t_iii }} {{ school.pass_i_iii }} {{ school.pass_i_iii_pct }}% {{ school.t_iv }} {% widthratio school.t_iv school.total_sat 100 %}% {{ school.pass_i_iv }} {{ school.pass_i_iv_pct }}% {{ school.t_o }} {{ school.gpa|floatformat:4 }} {{ school.overall_rank }} {{ school.region_rank|default:'-' }} {{ school.district_rank|default:'-' }}
Hakuna data ya shule
SCHOOL RANKING - SCHOOL WITH OR MORE THAN 40 CANDIDATES
{% for school in school_ranking_30plus %} {% empty %} {% endfor %}
No. SCHOOLS DISTRICT REGION OWNERSHIP SAT DIVISION PERFOMANCE GPA RANK
I II III I - III IV I - IV 0 Overall --- --
No. % No. % No. %
{{ forloop.counter }} {{ school.name_short|default:school.school_name|truncatechars:25 }} {{ school.district }} {{ school.region }} {{ school.ownership }} {{ school.total_sat }} {{ school.t_i }} {{ school.t_ii }} {{ school.t_iii }} {{ school.pass_i_iii }} {{ school.pass_i_iii_pct }}% {{ school.t_iv }} {% widthratio school.t_iv school.total_sat 100 %}% {{ school.pass_i_iv }} {{ school.pass_i_iv_pct }}% {{ school.t_o }} {{ school.gpa|floatformat:4 }} {{ school.overall_rank }} {{ school.region_rank|default:'-' }} {{ school.district_rank|default:'-' }}
No School with Greater than or Equal to 40 Candistaed
SCHOOL RANKING - Schools with Less than 40 Students)
{% for school in school_ranking_under30 %} {% empty %} {% endfor %}
No. SCHOOLS DISTRICT REGION OWNERSHIP SAT DIVISION PERFOMANCE GPA RANK
I II III I - III IV I - IV 0 Overall --- --
No. % No. % No. %
{{ forloop.counter }} {{ school.name_short|default:school.school_name|truncatechars:25 }} {{ school.district }} {{ school.region }} {{ school.ownership }} {{ school.total_sat }} {{ school.t_i }} {{ school.t_ii }} {{ school.t_iii }} {{ school.pass_i_iii }} {{ school.pass_i_iii_pct }}% {{ school.t_iv }} {% widthratio school.t_iv school.total_sat 100 %}% {{ school.pass_i_iv }} {{ school.pass_i_iv_pct }}% {{ school.t_o }} {{ school.gpa|floatformat:4 }} {{ school.overall_rank }} {{ school.region_rank|default:'-' }} {{ school.district_rank|default:'-' }}
No school with Less than 40 Students