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.sqlDeployment
tag:suivi_resultatsnew in v0.10.0Database
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.ymlfile with the following snippet and add thecod_cssvariable.
#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: Trueconfiguration
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-refreshto populate the seeds.
- To add a list of in-house courses to be tracked :
- Add a
.csvfile in yourcssXX.dashboards_store/seeds/dashboards/educ_serv/suivi_resultatsfolder. The file must be namedcustom_tracked_courses.csv. The file must be populated with the colums described incore.dashboards_store/seeds/dashboards/educ_serv/suivi_resultats/schema.yml(refers to thecustom_tracked_coursesseed). You might want to use thecore.dashboards_store/models/marts/educ_serv/staging/stg_descr_mattable to find the appropriate mapping. - Trigger a refresh of your seeds
- Add a
dbt seed --full-refreshPlease refer to the seeds section for more information about how to use and populate seeds.
