Module | Java | Semestre | Printemps | Annee | 2021/2022 | ||
---|---|---|---|---|---|---|---|
Enseignant | Tarik | Session | Normale | Classe | GI1 | ||
ID | CNE | NOM | PRENOM | Element 1 | Element 2 | Moyenne | Validation |
1 | H1829 | Lahyane | Mohamed | 16 | 17 | Formule | Formule |
- make sure header infos are correct:
- teacher-name (compare with one in the db)
- study-year
- the other elements
- the class name is coherent
- make sure grades in [0, 20]
- les formules de moyenne et validation
data = array of excel data
-
get the info of the prof (module, elements, )
-
how many elements in the module
-
make sure the formulas are correct
-
get the number of the students who registered in the module
-
make sure all the data of the students are correct
-
if already imported notes ask if the teacher wants to replace them with the new grades
-
insert the grades in the db