{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["COMMENT UTILISER CE CLASSEUR","RELEVÉ DE NOTES"],"not_rendered":{"defined_names":7},"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, questionnaires ou tests (par ex., « Devoir 1 ») à partir de la cellule H8, ainsi que les points que vaut chaque devoir. "]
[null,"4. Entrez les notes des étudiants pour chaque devoir ou test. Les colonnes « Moyenne », « Note », « Note sous forme de lettre » et « Moyenne cumulative » sont calculées automatiquement, mais vous pouvez les remplacer. Pour attribuer des points supplémentaires, indiquez simplement un nombre de points supérieur au nombre de points total possible pour un devoir."]
[null,"Utilisez la commande « Zone d’impression » du menu Mise en page pour modifier la zone à imprimer."]
[null,"Les notes correspondant aux lettres sont basées sur une échelle de pourcentage standard en fonction du nombre total de points indiqués dans les lignes 8 et 9. Ajustez le nombre de points de chaque devoir ou test, puis le pourcentage associé à chaque note. Remplacez manuellement les notes indiquées pour les modifier."]
[null,"Entrez chaque devoir, questionnaire ou test ainsi que le nombre de points associé dans les cellules H8 à X9."]

{"sheet":"RELEVÉ DE NOTES","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[1,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[19,1,19,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"NOM DE L’ÉTABLISSEMENT"]
[null,"Nom de l’enseignant"]
[{"$nulls":7},"Note",{"$f":"I4*TotalPoints","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Cours/projet",{"$nulls":5},"%",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"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%"}]
[null,"Année/Semestre/Trimestre",{"$nulls":5},"Note sous forme de lettre","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":7},"Moyenne cumulative",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Nom du devoir ou test",null,null,"HW1","HW2","T1"]
[{"$nulls":4},"Nombre total de points disponibles",null,null,50,50,100]
[]
[{"$nulls":4},"Nombre total de devoirs et tests :",null,null,{"$f":"COUNTA(H8:X8)","v":3}]
[{"$nulls":4},"Nombre total de points possibles :",null,null,{"$f":"SUM(H9:X9)","v":200}]
[]
[null,"Nom de l’étudiant","ID étudiant","Moyenne","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"]
[null,"Étudiant 1",null,{"$f":"IFERROR(IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]])/TotalPoints),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]))","v":182},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,3),\"\"),0)","v":"A-"},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,4),\"\"),0)","v":3.67},45,45,92]
[null,"Étudiant 2",null,{"$f":"IFERROR(IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]])/TotalPoints),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]))","v":200},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]))","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]))","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Notes[[#This Row],[Colonne6]:[Colonne22]])=0,\"\",SUM(Notes[[#This Row],[Colonne6]:[Colonne22]]))","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Notes[[#This Row],[Moyenne]]<>\"\",HLOOKUP(Notes[[#This Row],[Moyenne]]*TotalPoints,TableauNotes,4),\"\"),0)","v":""}]
[]
[null,"Synthèse classe",null,"Moyenne",null,"Note sous forme de lettre","Moyenne cumulative","","","","","","","","","","",""]
[null," Moyenne",null,{"$f":"IFERROR(AVERAGE(Notes[[#All],[Moyenne]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoints,TableauNotes,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(Notes[[#All],[Moyenne cumulative]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Note maximale",null,{"$f":"IFERROR(MAX(Notes[[#All],[Moyenne]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoints,TableauNotes,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(Notes[[#All],[Moyenne cumulative]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Note minimale",null,{"$f":"IFERROR(MIN(Notes[[#All],[Moyenne]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoints,TableauNotes,3),\"\")","v":"A-"},{"$f":"IFERROR(MIN(Notes[[#All],[Moyenne cumulative]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]