Monitor the grades of students in selected courses . The dashboard displays, for each students currently enrolled in primary and secondary school, the history of it's grades for all courses belonging to the same group of selected courses. The dashboard conditionally renders the student status for current and last year. The dashboard also provides an annual portrait of the student The dashboard also provides an annual portrait of the school. to have the courses grade we need to activate the table :core.dashboards_store/models/dashboards/educ_serv/res_scolaires/pbi_tables/resco_report_res_bilan_comp_eco.sql

Deployment

tag:suivi_resultatsnew in v0.10.0

Database

The GPI database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

Dashboards

This dashboard depends on the res_scolaires dashboard. Make sure to deploy the res_scolaires dashboard before deploying the suivi_resultats dashboard.

DBT project specification

Update your cssXX.dashboards_store/dbt_project.yml file with the following snippet and add the cod_css variable.

#cssXX.dashboards_store/dbt_project.yml
models:
  core_dashboards_store:
    marts:
      educ_serv:
        +enabled: True
    dashboards:
      educ_serv:
        suivi_resultats:
          +enabled: True
        res_scolaires:
          +enabled: True
    interfaces:
      gpi:
        +enabled: True

configuration

The configuration is optional. If you don't provide a configuration, the dashboard will use the default configuration.

Customizing the tracked courses

This table needs some seeds. Make sure to run dbt seed --full-refresh to populate the seeds.

  • To add a list of in-house courses to be tracked :
    1. Add a .csv file in your cssXX.dashboards_store/seeds/dashboards/educ_serv/suivi_resultats folder. The file must be named custom_tracked_courses.csv. The file must be populated with the colums described in core.dashboards_store/seeds/dashboards/educ_serv/suivi_resultats/schema.yml (refers to the custom_tracked_courses seed). You might want to use the core.dashboards_store/models/marts/educ_serv/staging/stg_descr_mat table to find the appropriate mapping.
    2. Trigger a refresh of your seeds
dbt seed --full-refresh
Please refer to the seeds section for more information about how to use and populate seeds.