{% load static %} {% load dict_extras %} FORM SIX REGIONAL MOCK REPORT – PRINT MASTER
FLAG watermark

UNITED REPUBLIC OF TANZANIA

Coat of Arms

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

{{ project.name }}

{{ region_name }}

{{ project.year }} MOCK EXAMINATION RESULTS

DIV I–III
{{ pass_pct }}%
DIV IV + 0
{{ fail_pct }}%
{% 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=220 %}

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: {% with max_value as max_val %} {% 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 %} {% endwith %}
Page 1
PMO-RALG - {{ region_name }}
{{ project.name }}
FORM SIX REGIONAL MOCK {{ project.year }} – 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 E S 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.E }} {{ overall_table.grades.S }} {{ overall_table.grades.F }} {{ overall_table.overall_gpa }}
Subject GPA: {{ overall_table.subject_gpa }} {% if academic_level_id == 1 %} (A=1, B=2, C=3, D=4, F=5) {% elif academic_level_id == 2 %} (A=1, B=2, C=3, D=4, E=5, S=6, F=7) {% elif academic_level_id == 3 %} (A=1, B=2, C=3, D=4, E=5) {% endif %}
Division GPA: {{ overall_table.division_gpa }} {% if academic_level_id == 3 %} (Based on Average Grades: A=1, B=2, C=3, D=4, E=5) {% else %} (I=1, II=2, III=3, IV=4, 0=5) {% endif %}
Overall GPA: {{ overall_table.overall_gpa }} (Subject GPA + Division GPA) ÷ 2
Academic Level: {% if academic_level_id == 1 %} O-Level (Form 4) {% elif academic_level_id == 2 %} A-Level (Form 6) {% elif academic_level_id == 3 %} Diploma/Certificate {% endif %}
Page 2
PMO-RALG - {{ region_name }}
{{ project.name }}
BEST PERFORMING SCHOOLS – {{ project.year }}

BEST 10 SCHOOLS (OVERALL)

{% for s in best_10_all %} {% endfor %}
#CENTRESCHOOLDISTRICTOWNER#SATGPA
{{ forloop.counter }}{{ s.school.school_code }}{{ s.school.name_short }} {{ s.school.district.name }}{{ s.school.ownership }} {{ s.with_results }}{{ s.sch_gpa|floatformat:4 }}

BEST 10 GOVERNMENT SCHOOLS

{% for s in best_10_gvt %} {% endfor %}
#CENTRESCHOOLGPA
{{ forloop.counter }}{{ s.school.school_code }}{{ s.school.name_short }}{{ s.sch_gpa|floatformat:4 }}

BEST 10 NON-GOVERNMENT SCHOOLS

{% for s in best_10_nongvt %} {% endfor %}
#CENTRESCHOOLGPA
{{ forloop.counter }}{{ s.school.school_code }}{{ s.school.name_short }}{{ s.sch_gpa|floatformat:4 }}

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

{% for s in best_40_std_andabove %} {% empty %} {% endfor %}
# CENTRE SCHOOL OWNER CANDIDATES GPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short }} {{ s.school.ownership }} {{ s.candidates_count|default:s.with_results }} {{ s.sch_gpa|floatformat:4|floatformat:4 }}
No schools with 30+ candidates

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

{% for s in best_40_less %} {% empty %} {% endfor %}
# CENTRE SCHOOL OWNER CANDIDATES GPA
{{ forloop.counter }} {{ s.school.school_code }} {{ s.school.name_short }} {{ s.school.ownership }} {{ s.candidates_count|default:s.with_results }} {{ s.sch_gpa|floatformat:4|floatformat:4 }}
No schools with less than 30 candidates
Note: Rankings include only schools with valid GPA scores. "Candidates" refers to students who sat for exams (excluding absentees).
End of School Ranking
PMO-RALG - {{ region_name }}
{{ project.name }}
FORM SIX REGIONAL MOCK {{ project.year }} – TOP PERFORMING STUDENTS

🏆 OVERALL BEST 10 STUDENTS (Lowest Points)

{% for s in best_students %} {% empty %} {% endfor %}
# CAND NO NAME SEX SCHOOL COMB POINTS DIV
{{ forloop.counter }} {{ s.student.student_number }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|truncatechars:30 }} {{ s.student.combination.code|default:"-" }} {{ s.total_points }} {{ s.division }}
No data available

👩 BEST 10 GIRLS

{% for s in best_girls %} {% empty %} {% endfor %}
# NAME SCHOOL POINTS DIV
{{ forloop.counter }} {{ s.student.full_name }} {{ s.student.school.name_short|truncatechars:15 }} {{ s.total_points }} {{ s.division }}
No data

👨 BEST 10 BOYS

{% for b in best_boys %} {% empty %} {% endfor %}
# NAME SCHOOL POINTS DIV
{{ forloop.counter }} {{ b.student.full_name }} {{ b.student.school.name_short|truncatechars:15 }} {{ b.total_points }} {{ b.division }}
No data

🏫 BEST 10 STUDENT - GOVERNMENT SCHOOLS

{% for s in best_gvt_students %} {% empty %} {% endfor %}
# NAME SEX SCHOOL POINTS DIVISION
{{ forloop.counter }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|truncatechars:15 }} {{ s.total_points }} {{ s.division }}
No data

🏫 BEST 10 STUDENT - NON-GOVERNMENT SCHOOLS

{% for s in best_nongvt_students %} {% empty %} {% endfor %}
# NAME SEX SCHOOL POINTS DIVISION
{{ forloop.counter }} {{ s.student.full_name }} {{ s.student.sex }} {{ s.student.school.name_short|truncatechars:15 }} {{ s.total_points }} {{ s.division }}
No data
Note: Lower total points indicate better performance. Only students with points ≥ 3 are included. Points range: 3-21 (A-Level) where 3 = Best, 21 = Worst.
End of Best Perfoming Students
PMO-RALG - {{ region_name }}
{{ project.name }}
FORM SIX REGIONAL MOCK {{ project.year }} – SUBJECT PERFORMANCE ANALYSIS

📚 SUBJECT GRADES PERFORMANCE

{% for subject in processed_subject_summary %} {% empty %} {% endfor %} {% if processed_subject_summary %} {% endif %}
CODE SUBJECT SAT GRADE DISTRIBUTION A - E A - S SUBJECT GPA
A B C D E S F Total % Total %
{{ subject.subject_code }} {{ subject.subject_name }} {{ subject.sat }} {{ subject.A }} {{ subject.B }} {{ subject.C }} {{ subject.D }} {{ subject.E }} {{ subject.S }} {{ subject.F }} {{ subject.A_E_total }} {{ subject.A_E_percent }}% {{ subject.A_S_total }} {{ subject.A_S_percent }}% {{ subject.gpa_display }}
No subject data available
TOTALS / AVERAGE: {{ subject_totals.A }} {{ subject_totals.B }} {{ subject_totals.C }} {{ subject_totals.D }} {{ subject_totals.E }} {{ subject_totals.S }} {{ subject_totals.F }} {{ subject_totals.A_E_total }} {{ subject_totals.overall_A_E_percent }}% {{ subject_totals.A_S_total }} {{ subject_totals.overall_A_S_percent }}% {{ subject_totals.avg_gpa_display }}

🏆 TOP 10 SUBJECTS BY GPA (Lower is Better)

{% for subject in top_subjects_by_gpa %} {% endfor %}
RANK CODE SUBJECT SAT A-E % A-S % GPA
{{ forloop.counter }} {{ subject.subject_code }} {{ subject.subject_name }} {{ subject.sat }} {{ subject.A_E_percent }}% {{ subject.A_S_percent }}% {{ subject.gpa_display }}
Subject GPA Formula: (A×1 + B×2 + C×3 + D×4 + E×5 + S×6 + F×7) ÷ Total Candidates
Lower GPA indicates better performance. Values shown with 4 decimal places precision.
Page 6
PMO-RALG - {{ region_name }}
{{ project.name }}
FORM SIX REGIONAL MOCK {{ project.year }} – TOP STUDENTS PER SUBJECT

🏆 BEST 10 STUDENTS IN EACH SUBJECT

Ranked by highest percentage score | Only non-null scores included

{% for subject in subject_best_list %}

{{ subject.name }} ({{ subject.code }}) Top 10 Students

{% for student in subject.rows %} {% endfor %}
# CAND NO NAME SEX SCHOOL OWNER SCORE % GRADE
{{ student.rank }} {{ student.student_number }} {{ student.full_name }} {{ student.sex }} {{ student.school_name }} {{ student.school_ownership }} {{ student.percentage_score }} {{ student.grade }}
{% with subject.rows|first as first_student %} {% if first_student %} Top Score: {{ first_student.percentage_score }}% (Grade {{ first_student.grade }}) {% endif %} {% endwith %}
{% empty %}

No subject performance data available

There are no valid percentage scores for any subject.

{% endfor %}
Page 7