{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["COMMENT UTILISER CE CLASSEUR","RELEVÉ DE NOTES"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"COMMENT UTILISER CE CLASSEUR","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"INSTRUCTIONS"]
[null,"Utilisez la feuille de calcul RELEVÉ DE NOTES pour calculer les notes. Chaque devoir compte pour un nombre de points défini. "]
[null,"Instructions : Pensez à enregistrer des copies de vos notes."]
[null,"1. Indiquez le nom de l’établissement, les informations relatives au cours, le nom des étudiants et éventuellement leur identifiant.   "]
[null,"2. Personnalisez le tableau Note et Moyenne cumulative afin de l’adapter à votre système de notation."]
[null,"3. Entrez le nom des devoirs ou tests à partir de la cellule G7, ainsi que le pourcentage représenté par chacun (par ex. « Final » et « 50 % »). "]
[null,"4. Entrez les notes des étudiants pour chaque devoir ou test. Les colonnes « Note », « Note sous forme de lettre » et « Moyenne cumulative » sont calculées automatiquement, mais vous pouvez les remplacer. La méthode de calcul des notes, la moyenne et la note finale sont incomplètes tant que toutes les notes ne sont pas entrées."]
[null,"Utilisez la commande « Zone d’impression » du menu Mise en page pour modifier la zone à imprimer."]
[null,"Les sections Note, Note sous forme de lettre et Moyenne cumulative ne sont pas valides tant que tous les devoirs et tests ne sont pas terminés. "]
[null,"Entrez chaque devoir ou test ainsi que son pourcentage dans la note totale dans les cellules G7 à W8."]

{"sheet":"RELEVÉ DE NOTES","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"NOM DE L’ÉTABLISSEMENT"]
[]
[{"$nulls":6},"Note",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"Note sous forme de lettre","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"Moyenne cumulative",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Nom de l’enseignant"]
[null,"Cours/projet",null,null,"Nom du devoir ou test"]
[null,"Année/Semestre/Trimestre",null,null,"Pourcentage (total 100 %)"]
[{"$nulls":4},{"$f":"\"Pourcentage total: \"&SUM(G8:W8)*100&\"%\"","v":"Pourcentage total: 0%"}]
[null,"Nom de l’étudiant","ID étudiant","Note","Note sous forme de lettre","Moyenne cumulative","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne21","Colonne22"]
[{"$nulls":3},{"$f":"(IF(SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]),ROUND(SUMPRODUCT($G$8:$W$8,Notes[[#This Row],[Colonne6]:[Colonne22]]),2),\"\"))","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,2),\"\")","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]),ROUND(SUMPRODUCT($G$8:$W$8,Notes[[#This Row],[Colonne6]:[Colonne22]]),2),\"\"))","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,2),\"\")","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]),ROUND(SUMPRODUCT($G$8:$W$8,Notes[[#This Row],[Colonne6]:[Colonne22]]),2),\"\"))","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,2),\"\")","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]),ROUND(SUMPRODUCT($G$8:$W$8,Notes[[#This Row],[Colonne6]:[Colonne22]]),2),\"\"))","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,2),\"\")","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]),ROUND(SUMPRODUCT($G$8:$W$8,Notes[[#This Row],[Colonne6]:[Colonne22]]),2),\"\"))","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,2),\"\")","v":""},{"$f":"IF(Notes[[#This Row],[Note]]<>\"\",HLOOKUP(Notes[[#This Row],[Note]],TableauNotes,3),\"\")","v":""}]
[]
[null,"Synthèse classe",null,"Note","Note sous forme de lettre","Moyenne cumulative","","","","","","","","","","",""]
[null," Moyenne",null,{"$f":"IFERROR(AVERAGE(Notes[[#All],[Note]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,TableauNotes,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(Notes[[#All],[Moyenne cumulative]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Note maximale",null,{"$f":"IFERROR(MAX(Notes[[#All],[Note]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,TableauNotes,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(Notes[[#All],[Moyenne cumulative]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Note minimale",null,{"$f":"IFERROR(MIN(Notes[[#All],[Note]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,TableauNotes,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(Notes[[#All],[Moyenne cumulative]]),0)","v":0},"","","","","","","","","","","","","","","","",""]