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.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.yml
file with the following snippet and add thecod_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 :
- Add a
.csv
file in yourcssXX.dashboards_store/seeds/dashboards/educ_serv/suivi_resultats
folder. 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_courses
seed). You might want to use thecore.dashboards_store/models/marts/educ_serv/staging/stg_descr_mat
table to find the appropriate mapping. - Trigger a refresh of your seeds
- Add a
dbt seed --full-refresh
Please refer to the seeds section for more information about how to use and populate seeds.