{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instruction","Grille-classe","Recap-classe"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Saisie des noms et prénoms des élèves"]
["Vous avez à disposition une grille d'évaluation avec 30 élèves. ",null,null,null,"Utilisation du mode plan pour personnaliser les affichages"]
[null,null,null,null,"afficher les colonnes au niveau 1 : afficher les résultats de la classe"]
["Commencez par compléter les noms et prénom des élèves dans la  feuille  Recap-classe",null,null,null,"afficher les colonnes au niveau 2 : afficher les points et les commentaires"]
["> vous avez plus de 30 élèves ? Vous avez besoin de 2 fichiers. A vous de dupliquer le fichier",null,null,null,"afficher les lignes au niveau 1, mais masquer certains niveaux"]
["> vous avez moins de 30 élèves ? Laisser simplement les nom et prénom \"vides\" dans la feuille Grille-Classe"]
["Saisie des résultats puis impression par élève",null,null,null,"cliquez sur les flèches pour déclencher l'affichage souhaitée:"]
["Les différents options d'affichage vous permettent de vous partager le travail de correction par tâche",null,null,null,"Affichages à disposition"]
["Pour chaque tâche, il est possible de saisir les points et commentaires par élève dans la feuille Grille-classe",null,null,null,"une page par élève (nommer fichiers - toutes tâches)"]
["L'impression reflètera l'affichage que vous avez choisi.",null,null,null,"une page par élève - tache PréAO"]
[null,null,null,null,"une page par élève - tache TABLEUR"]
["Pour changer de tâche, vous pouvez utiliser les flèches ci-contre, la liste déroulante de la feuille Grille-Classe",null,null,null,"une page par élève - tache TRAITEMENT DE TEXTE"]
["ou le menu Affichage > Affichage personnalisé, choisir une des options pré-enregistrées",null,null,null,"une page par élève - tache COMMUNICATION"]
[]
[null,null,null,null,"les résultats de la classe"]
["Travail collaboratif (plusieurs correcteurs)"]
["Il est possible de partager le fichier excel si vous êtes plusieurs à corriger la même classe (révision > partager le classeur)"]
["Vous pouvez également faire les corrections de manière individuelle et ensuite consolider (copier/coller)"]
[]
["Impression des résultats"]
["Vous pouvez  imprimer la feuille Recap-classe."]
["Si vous souhaitez des impressions par élève, utilier les affichages prédéfinis de la feuille Grille-Classe, "]
["puis imprimez. Vous obtenez 6 pages par élève (impression avec 1 page par tâche)"]
["Si vous souhaitez n'imprimer qu'une seule des tâches pour tous vos élèves, utilisez simplement l'affichage approprié,"]
["puis imprimez avec le bouton impression tâche(s)."]
[]
["Le classeur tout comme les feuilles ne peuvent pas être protégés pour des raisons techniques."]

{"sheet":"Grille-classe","index":1,"n_rows":78,"n_cols":66,"rows_kept":78,"cut":false,"hidden":false,"merged":[[66,3,66,5],[68,0,68,5],[69,1,69,5],[77,3,77,5],[49,3,49,5],[51,0,51,5],[52,1,52,5],[58,3,58,5],[60,0,60,5],[61,1,61,5],[28,3,28,5],[30,0,30,5],[31,1,31,5],[37,3,37,5],[39,0,39,5],[40,1,40,5],[22,58,22,59],[22,60,22,61],[22,62,22,63],[25,1,25,5],[22,46,22,47],[22,48,22,49],[22,50,22,51],[22,52,22,53],[22,54,22,55],[22,56,22,57],[22,34,22,35],[22,36,22,37],[22,38,22,39],[22,40,22,41],[22,42,22,43],[22,44,22,45],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,28,22,29],[22,30,22,31],[22,32,22,33],[21,42,21,43],[21,44,21,45],[21,46,21,47],[21,48,21,49],[21,50,21,51],[21,28,21,29],[21,30,21,31],[21,34,21,35],[21,36,21,37],[22,64,22,65],[24,0,24,5],[21,38,21,39],[21,16,21,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[21,24,21,25],[21,26,21,27],[21,64,21,65],[22,1,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[21,52,21,53],[21,54,21,55],[21,56,21,57],[21,58,21,59],[21,60,21,61],[21,62,21,63],[21,40,21,41],[19,64,19,65],[21,0,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[19,46,19,47],[19,48,19,49],[19,50,19,51],[19,52,19,53],[19,54,19,55],[19,56,19,57],[19,34,19,35],[19,36,19,37],[19,38,19,39],[19,40,19,41],[19,42,19,43],[19,44,19,45],[19,22,19,23],[19,24,19,25],[21,32,21,33],[19,32,19,33],[18,64,18,65],[19,1,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[18,52,18,53],[18,54,18,55],[18,56,18,57],[18,58,18,59],[18,60,18,61],[18,62,18,63],[18,40,18,41],[18,42,18,43],[18,44,18,45],[18,46,18,47],[19,58,19,59],[19,60,19,61],[19,62,19,63],[18,16,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[18,26,18,27],[19,26,19,27],[19,28,19,29],[19,30,19,31],[16,22,16,23],[16,24,16,25],[16,26,16,27],[16,28,16,29],[18,48,18,49],[18,50,18,51],[18,28,18,29],[18,30,18,31],[18,32,18,33],[18,34,18,35],[18,36,18,37],[18,38,18,39],[16,64,16,65],[16,42,16,43],[16,44,16,45],[16,46,16,47],[16,48,16,49],[16,50,16,51],[16,52,16,53],[18,0,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[16,54,16,55],[16,56,16,57],[16,58,16,59],[16,30,16,31],[16,32,16,33],[16,34,16,35],[16,36,16,37],[16,38,16,39],[16,40,16,41],[16,18,16,19],[16,20,16,21],[15,64,15,65],[16,1,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[15,48,15,49],[15,50,15,51],[15,52,15,53],[15,54,15,55],[15,56,15,57],[15,58,15,59],[15,36,15,37],[15,38,15,39],[15,40,15,41],[15,42,15,43],[15,44,15,45],[15,46,15,47],[15,24,15,25],[15,26,15,27],[16,60,16,61],[16,62,16,63],[15,34,15,35],[15,12,15,13],[15,14,15,15],[15,16,15,17],[15,18,15,19],[15,20,15,21],[15,22,15,23],[15,60,15,61],[15,62,15,63],[12,0,12,5],[13,0,13,5],[15,0,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,28,15,29],[15,30,15,31],[15,32,15,33]]}
[null,5,1,null,null,null,{"$f":"'Recap-classe'!B10&\"\"","v":"Eleve 1"},null,{"$f":"'Recap-classe'!B11&\"\"","v":"Eleve 2"},null,{"$f":"'Recap-classe'!B12&\"\"","v":"Eleve 3"},null,{"$f":"'Recap-classe'!B13&\"\"","v":""},null,{"$f":"'Recap-classe'!B14&\"\"","v":""},null,{"$f":"'Recap-classe'!B15&\"\"","v":""},null,{"$f":"'Recap-classe'!B16&\"\"","v":""},null,{"$f":"'Recap-classe'!B17&\"\"","v":""},null,{"$f":"'Recap-classe'!B18&\"\"","v":""},null,{"$f":"'Recap-classe'!B19&\"\"","v":""},null,{"$f":"'Recap-classe'!B20&\"\"","v":""},null,{"$f":"'Recap-classe'!B21&\"\"","v":""},null,{"$f":"'Recap-classe'!B22&\"\"","v":""},null,{"$f":"'Recap-classe'!B23&\"\"","v":""},null,{"$f":"'Recap-classe'!B24&\"\"","v":""},null,{"$f":"'Recap-classe'!B25&\"\"","v":""},null,{"$f":"'Recap-classe'!B26&\"\"","v":""},null,{"$f":"'Recap-classe'!B27&\"\"","v":""},null,{"$f":"'Recap-classe'!B28&\"\"","v":""},null,{"$f":"'Recap-classe'!B29&\"\"","v":""},null,{"$f":"'Recap-classe'!B30&\"\"","v":""},null,{"$f":"'Recap-classe'!B31&\"\"","v":""},null,{"$f":"'Recap-classe'!B32&\"\"","v":""},null,{"$f":"'Recap-classe'!B33&\"\"","v":""},null,{"$f":"'Recap-classe'!B34&\"\"","v":""},null,{"$f":"'Recap-classe'!B35&\"\"","v":""},null,{"$f":"'Recap-classe'!B36&\"\"","v":""},null,{"$f":"'Recap-classe'!B37&\"\"","v":""},null,{"$f":"'Recap-classe'!B38&\"\"","v":""},null,{"$f":"'Recap-classe'!B39&\"\"","v":""}]
[null,null,null,null,null,null,{"$f":"'Recap-classe'!C10&\"\"","v":"Prenom 1"},null,{"$f":"'Recap-classe'!C11&\"\"","v":"Prénom 2"},null,{"$f":"'Recap-classe'!C12&\"\"","v":"Prénom 3"},null,{"$f":"'Recap-classe'!C13&\"\"","v":""},null,{"$f":"'Recap-classe'!C14&\"\"","v":""},null,{"$f":"'Recap-classe'!C15&\"\"","v":""},null,{"$f":"'Recap-classe'!C16&\"\"","v":""},null,{"$f":"'Recap-classe'!C17&\"\"","v":""},null,{"$f":"'Recap-classe'!C18&\"\"","v":""},null,{"$f":"'Recap-classe'!C19&\"\"","v":""},null,{"$f":"'Recap-classe'!C20&\"\"","v":""},null,{"$f":"'Recap-classe'!C21&\"\"","v":""},null,{"$f":"'Recap-classe'!C22&\"\"","v":""},null,{"$f":"'Recap-classe'!C23&\"\"","v":""},null,{"$f":"'Recap-classe'!C24&\"\"","v":""},null,{"$f":"'Recap-classe'!C25&\"\"","v":""},null,{"$f":"'Recap-classe'!C26&\"\"","v":""},null,{"$f":"'Recap-classe'!C27&\"\"","v":""},null,{"$f":"'Recap-classe'!C28&\"\"","v":""},null,{"$f":"'Recap-classe'!C29&\"\"","v":""},null,{"$f":"'Recap-classe'!C30&\"\"","v":""},null,{"$f":"'Recap-classe'!C31&\"\"","v":""},null,{"$f":"'Recap-classe'!C32&\"\"","v":""},null,{"$f":"'Recap-classe'!C33&\"\"","v":""},null,{"$f":"'Recap-classe'!C34&\"\"","v":""},null,{"$f":"'Recap-classe'!C35&\"\"","v":""},null,{"$f":"'Recap-classe'!C36&\"\"","v":""},null,{"$f":"'Recap-classe'!C37&\"\"","v":""},null,{"$f":"'Recap-classe'!C38&\"\"","v":""},null,{"$f":"'Recap-classe'!C39&\"\"","v":""}]
[null,null,null,null,null,null,1,1.5,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25,null,26,null,27,null,28,null,29,null,30]
[null,null,null,null,null,"Points maximum","Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus",null,"Points obtenus"]
["Tâche Nommer les fichiers",null,null,null,null,{"$f":"B29","v":4},{"$f":"G29","v":0},null,{"$f":"I29","v":0},null,{"$f":"K29","v":0},null,{"$f":"M29","v":0},null,{"$f":"O29","v":0},null,{"$f":"Q29","v":0},null,{"$f":"S29","v":0},null,{"$f":"U29","v":0},null,{"$f":"W29","v":0},null,{"$f":"Y29","v":0},null,{"$f":"AA29","v":0},null,{"$f":"AC29","v":0},null,{"$f":"AE29","v":0},null,{"$f":"AG29","v":0},null,{"$f":"AI29","v":0},null,{"$f":"AK29","v":0},null,{"$f":"AM29","v":0},null,{"$f":"AO29","v":0},null,{"$f":"AQ29","v":0},null,{"$f":"AS29","v":0},null,{"$f":"AU29","v":0},null,{"$f":"AW29","v":0},null,{"$f":"AY29","v":0},null,{"$f":"BA29","v":0},null,{"$f":"BC29","v":0},null,{"$f":"BE29","v":0},null,{"$f":"BG29","v":0},null,{"$f":"BI29","v":0},null,{"$f":"BK29","v":0},null,{"$f":"BM29","v":0}]
["Tâche Finaliser une présentation",null,null,null,null,{"$f":"B38","v":16},{"$f":"G38","v":0},null,{"$f":"I38","v":0},null,{"$f":"K38","v":0},null,{"$f":"M38","v":0},null,{"$f":"O38","v":0},null,{"$f":"Q38","v":0},null,{"$f":"S38","v":0},null,{"$f":"U38","v":0},null,{"$f":"W38","v":0},null,{"$f":"Y38","v":0},null,{"$f":"AA38","v":0},null,{"$f":"AC38","v":0},null,{"$f":"AE38","v":0},null,{"$f":"AG38","v":0},null,{"$f":"AI38","v":0},null,{"$f":"AK38","v":0},null,{"$f":"AM38","v":0},null,{"$f":"AO38","v":0},null,{"$f":"AQ38","v":0},null,{"$f":"AS38","v":0},null,{"$f":"AU38","v":0},null,{"$f":"AW38","v":0},null,{"$f":"AY38","v":0},null,{"$f":"BA38","v":0},null,{"$f":"BC38","v":0},null,{"$f":"BE38","v":0},null,{"$f":"BG38","v":0},null,{"$f":"BI38","v":0},null,{"$f":"BK38","v":0},null,{"$f":"BM38","v":0}]
["Tâche Compléter des feuilles de calculs",null,null,null,null,{"$f":"B50","v":28},{"$f":"G50","v":0},null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"M50","v":0},null,{"$f":"O50","v":0},null,{"$f":"Q50","v":0},null,{"$f":"S50","v":0},null,{"$f":"U50","v":0},null,{"$f":"W50","v":0},null,{"$f":"Y50","v":0},null,{"$f":"AA50","v":0},null,{"$f":"AC50","v":0},null,{"$f":"AE50","v":0},null,{"$f":"AG50","v":0},null,{"$f":"AI50","v":0},null,{"$f":"AK50","v":0},null,{"$f":"AM50","v":0},null,{"$f":"AO50","v":0},null,{"$f":"AQ50","v":0},null,{"$f":"AS50","v":0},null,{"$f":"AU50","v":0},null,{"$f":"AW50","v":0},null,{"$f":"AY50","v":0},null,{"$f":"BA50","v":0},null,{"$f":"BC50","v":0},null,{"$f":"BE50","v":0},null,{"$f":"BG50","v":0},null,{"$f":"BI50","v":0},null,{"$f":"BK50","v":0},null,{"$f":"BM50","v":0}]
["Tâche Mettre en page un document",null,null,null,null,{"$f":"B59","v":16},{"$f":"G59","v":0},null,{"$f":"I59","v":0},null,{"$f":"K59","v":0},null,{"$f":"M59","v":0},null,{"$f":"O59","v":0},null,{"$f":"Q59","v":0},null,{"$f":"S59","v":0},null,{"$f":"U59","v":0},null,{"$f":"W59","v":0},null,{"$f":"Y59","v":0},null,{"$f":"AA59","v":0},null,{"$f":"AC59","v":0},null,{"$f":"AE59","v":0},null,{"$f":"AG59","v":0},null,{"$f":"AI59","v":0},null,{"$f":"AK59","v":0},null,{"$f":"AM59","v":0},null,{"$f":"AO59","v":0},null,{"$f":"AQ59","v":0},null,{"$f":"AS59","v":0},null,{"$f":"AU59","v":0},null,{"$f":"AW59","v":0},null,{"$f":"AY59","v":0},null,{"$f":"BA59","v":0},null,{"$f":"BC59","v":0},null,{"$f":"BE59","v":0},null,{"$f":"BG59","v":0},null,{"$f":"BI59","v":0},null,{"$f":"BK59","v":0},null,{"$f":"BM59","v":0}]
["Tâche Créer un publipostage",null,null,null,null,{"$f":"B67","v":12},{"$f":"G67","v":0},null,{"$f":"I67","v":0},null,{"$f":"K67","v":0},null,{"$f":"M67","v":0},null,{"$f":"O67","v":0},null,{"$f":"Q67","v":0},null,{"$f":"S67","v":0},null,{"$f":"U67","v":0},null,{"$f":"W67","v":0},null,{"$f":"Y67","v":0},null,{"$f":"AA67","v":0},null,{"$f":"AC67","v":0},null,{"$f":"AE67","v":0},null,{"$f":"AG67","v":0},null,{"$f":"AI67","v":0},null,{"$f":"AK67","v":0},null,{"$f":"AM67","v":0},null,{"$f":"AO67","v":0},null,{"$f":"AQ67","v":0},null,{"$f":"AS67","v":0},null,{"$f":"AU67","v":0},null,{"$f":"AW67","v":0},null,{"$f":"AY67","v":0},null,{"$f":"BA67","v":0},null,{"$f":"BC67","v":0},null,{"$f":"BE67","v":0},null,{"$f":"BG67","v":0},null,{"$f":"BI67","v":0},null,{"$f":"BK67","v":0},null,{"$f":"BM67","v":0}]
["Tâche Rédiger une invitation",null,null,null,null,{"$f":"B78","v":24},{"$f":"G78","v":0},null,{"$f":"I78","v":0},null,{"$f":"K78","v":0},null,{"$f":"M78","v":0},null,{"$f":"O78","v":0},null,{"$f":"Q78","v":0},null,{"$f":"S78","v":0},null,{"$f":"U78","v":0},null,{"$f":"W78","v":0},null,{"$f":"Y78","v":0},null,{"$f":"AA78","v":0},null,{"$f":"AC78","v":0},null,{"$f":"AE78","v":0},null,{"$f":"AG78","v":0},null,{"$f":"AI78","v":0},null,{"$f":"AK78","v":0},null,{"$f":"AM78","v":0},null,{"$f":"AO78","v":0},null,{"$f":"AQ78","v":0},null,{"$f":"AS78","v":0},null,{"$f":"AU78","v":0},null,{"$f":"AW78","v":0},null,{"$f":"AY78","v":0},null,{"$f":"BA78","v":0},null,{"$f":"BC78","v":0},null,{"$f":"BE78","v":0},null,{"$f":"BG78","v":0},null,{"$f":"BI78","v":0},null,{"$f":"BK78","v":0},null,{"$f":"BM78","v":0}]
[null,null,null,null,null,{"$f":"SUM(F5:F10)","v":100},{"$f":"SUM(G5:G10)","v":0},null,{"$f":"SUM(I5:I10)","v":0},null,{"$f":"SUM(K5:K10)","v":0},null,{"$f":"SUM(M5:M10)","v":0},null,{"$f":"SUM(O5:O10)","v":0},null,{"$f":"SUM(Q5:Q10)","v":0},null,{"$f":"SUM(S5:S10)","v":0},null,{"$f":"SUM(U5:U10)","v":0},null,{"$f":"SUM(W5:W10)","v":0},null,{"$f":"SUM(Y5:Y10)","v":0},null,{"$f":"SUM(AA5:AA10)","v":0},null,{"$f":"SUM(AC5:AC10)","v":0},null,{"$f":"SUM(AE5:AE10)","v":0},null,{"$f":"SUM(AG5:AG10)","v":0},null,{"$f":"SUM(AI5:AJ10)","v":0},null,{"$f":"SUM(AK5:AK10)","v":0},null,{"$f":"SUM(AM5:AM10)","v":0},null,{"$f":"SUM(AO5:AO10)","v":0},null,{"$f":"SUM(AQ5:AQ10)","v":0},null,{"$f":"SUM(AS5:AS10)","v":0},null,{"$f":"SUM(AU5:AU10)","v":0},null,{"$f":"SUM(AW5:AW10)","v":0},null,{"$f":"SUM(AY5:AY10)","v":0},null,{"$f":"SUM(BA5:BA10)","v":0},null,{"$f":"SUM(BC5:BC10)","v":0},null,{"$f":"SUM(BE5:BE10)","v":0},null,{"$f":"SUM(BG5:BG10)","v":0},null,{"$f":"SUM(BI5:BI10)","v":0},null,{"$f":"SUM(BK5:BK10)","v":0},null,{"$f":"SUM(BM5:BM10)","v":0}]
[]
["Total des points attribués",null,null,null,null,null,{"$f":"ROUNDUP(G11,0)","v":0},null,{"$f":"ROUNDUP(I11,0)","v":0},null,{"$f":"ROUNDUP(K11,0)","v":0},null,{"$f":"ROUNDUP(M11,0)","v":0},null,{"$f":"ROUNDUP(O11,0)","v":0},null,{"$f":"ROUNDUP(Q11,0)","v":0},null,{"$f":"ROUNDUP(S11,0)","v":0},null,{"$f":"ROUNDUP(U11,0)","v":0},null,{"$f":"ROUNDUP(W11,0)","v":0},null,{"$f":"ROUNDUP(Y11,0)","v":0},null,{"$f":"ROUNDUP(AA11,0)","v":0},null,{"$f":"ROUNDUP(AC11,0)","v":0},null,{"$f":"ROUNDUP(AE11,0)","v":0},null,{"$f":"ROUNDUP(AG11,0)","v":0},null,{"$f":"ROUNDUP(AI11,0)","v":0},null,{"$f":"ROUNDUP(AK11,0)","v":0},null,{"$f":"ROUNDUP(AM11,0)","v":0},null,{"$f":"ROUNDUP(AO11,0)","v":0},null,{"$f":"ROUNDUP(AQ11,0)","v":0},null,{"$f":"ROUNDUP(AS11,0)","v":0},null,{"$f":"ROUNDUP(AU11,0)","v":0},null,{"$f":"ROUNDUP(AW11,0)","v":0},null,{"$f":"ROUNDUP(AY11,0)","v":0},null,{"$f":"ROUNDUP(BA11,0)","v":0},null,{"$f":"ROUNDUP(BC11,0)","v":0},null,{"$f":"ROUNDUP(BE11,0)","v":0},null,{"$f":"ROUNDUP(BG11,0)","v":0},null,{"$f":"ROUNDUP(BI11,0)","v":0},null,{"$f":"ROUNDUP(BK11,0)","v":0},null,{"$f":"ROUNDUP(BM11,0)","v":0}]
["Note attribuée",null,null,null,null,null,{"$f":"ROUND((G11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((I11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((K11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((M11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((O11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((Q11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((S11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((U11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((W11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((Y11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AA11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AC11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AE11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AG11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AI11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AK11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AM11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AO11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AQ11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AS11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AU11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AW11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((AY11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BA11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BC11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BE11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BG11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BI11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BK11/$F$11*5+1)*2,0)/2","v":1},null,{"$f":"ROUND((BM11/$F$11*5+1)*2,0)/2","v":1}]
[]
["Remarques générales",null,null,null,null,null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève",null,"Remarques pour cet élève"]
[]
[]
["Enseignant-examinateur (nom prénom date et signature): ",null,null,null,null,null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)",null,"Enseignant pour cet élève (si différent)"]
[]
[]
["2e expert (nom prénom date et signature): ",null,null,null,null,null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)",null,"2ème expert pour cet élève (si différent)"]
[]
[]
[{"$f":"\"Grille de correction - \" &A5","v":"Grille de correction - Tâche Nommer les fichiers"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Tous les fichiers rendus doivent être nommés selon les indications figurant à la fin de chaque tâche. ",4,3,2,1,0]
[{"$f":"A$5&\" - Points max\"","v":"Tâche Nommer les fichiers - Points max"},{"$f":"SUM(B28:B28)","v":4},null,"Points obtenus",null,null,{"$f":"SUM(G28:G28)","v":0},null,{"$f":"SUM(I28:I28)","v":0},null,{"$f":"SUM(K28:K28)","v":0},null,{"$f":"SUM(M28:M28)","v":0},null,{"$f":"SUM(O28:O28)","v":0},null,{"$f":"SUM(Q28:Q28)","v":0},null,{"$f":"SUM(S28:S28)","v":0},null,{"$f":"SUM(U28:U28)","v":0},null,{"$f":"SUM(W28:W28)","v":0},null,{"$f":"SUM(Y28:Y28)","v":0},null,{"$f":"SUM(AA28:AA28)","v":0},null,{"$f":"SUM(AC28:AC28)","v":0},null,{"$f":"SUM(AE28:AE28)","v":0},null,{"$f":"SUM(AG28:AG28)","v":0},null,{"$f":"SUM(AI28:AI28)","v":0},null,{"$f":"SUM(AK28:AK28)","v":0},null,{"$f":"SUM(AM28:AM28)","v":0},null,{"$f":"SUM(AO28:AO28)","v":0},null,{"$f":"SUM(AQ28:AQ28)","v":0},null,{"$f":"SUM(AS28:AS28)","v":0},null,{"$f":"SUM(AU28:AU28)","v":0},null,{"$f":"SUM(AW28:AW28)","v":0},null,{"$f":"SUM(AY28:AY28)","v":0},null,{"$f":"SUM(BA28:BA28)","v":0},null,{"$f":"SUM(BC28:BC28)","v":0},null,{"$f":"SUM(BE28:BE28)","v":0},null,{"$f":"SUM(BG28:BG28)","v":0},null,{"$f":"SUM(BI28:BI28)","v":0},null,{"$f":"SUM(BK28:BK28)","v":0},null,{"$f":"SUM(BM28:BM28)","v":0}]
[]
[{"$f":"\"Grille de correction – \" &A6","v":"Grille de correction – Tâche Finaliser une présentation"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Masque adapté\n- logo en haut à gauche (1)\n- titres en rouge sans chevauchement (1)\n- bandeau rouge placé à droite (1)\n-Diapositive de résumé\n- diapositive créée avec une liste partielle des émissions (1)",4,3,2,1,0]
["- animation appliquée élément par élément sur la dia résumé  (1)\nPied-de-page\n- comprend le texte demandé (1)\n- le numéro de diapositive (1), sur toutes les pages sauf la première (1)",4,3,2,1,0]
["Nouvelles Diapositives\n- 2 diapositives avec texte disposé selon modèle (2)\n- présence d'une image par diapositive (2)",4,3,2,1,0]
["Transition\n- identique entre toutes les diapositives (1)\n- transition automatique (1)\n- durée d'affichage 10 secondes par diapositive (1)\n- tourne en boucle (1)",4,3,2,1,0]
[{"$f":"A$6&\" - Points max\"","v":"Tâche Finaliser une présentation - Points max"},{"$f":"SUM(B34:B37)","v":16},null,"Points obtenus",null,null,{"$f":"SUM(G34:G37)","v":0},null,{"$f":"SUM(I34:I37)","v":0},null,{"$f":"SUM(K34:K37)","v":0},null,{"$f":"SUM(M34:M37)","v":0},null,{"$f":"SUM(O34:O37)","v":0},null,{"$f":"SUM(Q34:Q37)","v":0},null,{"$f":"SUM(S34:S37)","v":0},null,{"$f":"SUM(U34:U37)","v":0},null,{"$f":"SUM(W34:W37)","v":0},null,{"$f":"SUM(Y34:Y37)","v":0},null,{"$f":"SUM(AA34:AA37)","v":0},null,{"$f":"SUM(AC34:AC37)","v":0},null,{"$f":"SUM(AE34:AE37)","v":0},null,{"$f":"SUM(AG34:AG37)","v":0},null,{"$f":"SUM(AI34:AI37)","v":0},null,{"$f":"SUM(AK34:AK37)","v":0},null,{"$f":"SUM(AM34:AM37)","v":0},null,{"$f":"SUM(AO34:AO37)","v":0},null,{"$f":"SUM(AQ34:AQ37)","v":0},null,{"$f":"SUM(AS34:AS37)","v":0},null,{"$f":"SUM(AU34:AU37)","v":0},null,{"$f":"SUM(AW34:AW37)","v":0},null,{"$f":"SUM(AY34:AY37)","v":0},null,{"$f":"SUM(BA34:BA37)","v":0},null,{"$f":"SUM(BC34:BC37)","v":0},null,{"$f":"SUM(BE34:BE37)","v":0},null,{"$f":"SUM(BG34:BG37)","v":0},null,{"$f":"SUM(BI34:BI37)","v":0},null,{"$f":"SUM(BK34:BK37)","v":0},null,{"$f":"SUM(BM34:BM37)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A7","v":"Grille de correction – Tâche Compléter des feuilles de calculs"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Onglets Contrats\n- figer les volets (1)\n- tri d'une table de données (1)\nOnglet Contrats filtre\n- copie d'une feuille de calcul + nouveau nom (1)\n- filtre d'une table de données (1) (78 enregistrements)",4,3,2,1,0]
["Onglets Contrats\nPréparer une impression\n- orientation du papier paysage (1)\n- ajustement de la largeur des colonnes (1)\n- 4 pages (1)\n- première ligne répétée (1)",4,3,2,1,0]
["Onglet Sponsors 2020\n- format personnalisé \"ans\" (1)\n- durée du contrat en années complètes (2) \n  (DATEDIF, ARRONDI.INF, FRACTION ANNEE, ANNEE-ANNEE)\n- format CHF comptabilité appliqué à tous les montants (1)",4,3,2,1,0]
["Onglet Sponsors 2020\n- affichage restaurant RECHERCHEV + recopie (2)\n- calcul prix spot durée SI (1)\n- création/utilisation de constantes (1)",4,3,2,1,0]
["Onglet Sponsors 2020\n- calcul rabais SI (1) \n  et arrondi rabais 5 cts (1)\n- calcul prix spot région SI(SI) (2)",4,3,2,1,0]
["Onglet Sponsors 2020\n- calcul prix net (1)\n- mise en forme automatique contrats 2019 (1)\n- moyenne prix net (1)\n- max prix net (1)",4,3,2,1,0]
["Onglet Sponsors 2020\n- nombre sponsors / canton NB.SI + copie (2)\n- prix net / canton SOMME.SI() + copie (2)",4,3,2,1,0]
[{"$f":"A$7&\" - Points max\"","v":"Tâche Compléter des feuilles de calculs - Points max"},{"$f":"SUM(B43:B49)","v":28},null,"Points obtenus",null,null,{"$f":"SUM(G43:G49)","v":0},null,{"$f":"SUM(I43:I49)","v":0},null,{"$f":"SUM(K43:K49)","v":0},null,{"$f":"SUM(M43:M49)","v":0},null,{"$f":"SUM(O43:O49)","v":0},null,{"$f":"SUM(Q43:Q49)","v":0},null,{"$f":"SUM(S43:S49)","v":0},null,{"$f":"SUM(U43:U49)","v":0},null,{"$f":"SUM(W43:W49)","v":0},null,{"$f":"SUM(Y43:Y49)","v":0},null,{"$f":"SUM(AA43:AA49)","v":0},null,{"$f":"SUM(AC43:AC49)","v":0},null,{"$f":"SUM(AE43:AE49)","v":0},null,{"$f":"SUM(AG43:AG49)","v":0},null,{"$f":"SUM(AI43:AI49)","v":0},null,{"$f":"SUM(AK43:AK49)","v":0},null,{"$f":"SUM(AM43:AM49)","v":0},null,{"$f":"SUM(AO43:AO49)","v":0},null,{"$f":"SUM(AQ43:AQ49)","v":0},null,{"$f":"SUM(AS43:AS49)","v":0},null,{"$f":"SUM(AU43:AU49)","v":0},null,{"$f":"SUM(AW43:AW49)","v":0},null,{"$f":"SUM(AY43:AY49)","v":0},null,{"$f":"SUM(BA43:BA49)","v":0},null,{"$f":"SUM(BC43:BC49)","v":0},null,{"$f":"SUM(BE43:BE49)","v":0},null,{"$f":"SUM(BG43:BG49)","v":0},null,{"$f":"SUM(BI43:BI49)","v":0},null,{"$f":"SUM(BK43:BK49)","v":0},null,{"$f":"SUM(BM43:BM49)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A8","v":"Grille de correction – Tâche Mettre en page un document"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Document\n- sommaire automatique avec no de page (1)\n- titre sommaire (1)\n- alternance de l'orientation portrait / paysage (2)",4,3,2,1,0]
["- bordure de page assortie à gauche 1re page (1) \nPied de page\n- complété avec logo et slogan (1)\n- numérotation : page x sur y (1)\n- ajusté sur toutes les pages / absent page de titre (1) ",4,3,2,1,0]
["Styles\n- nouveau style créé (1) avec une puce personnalisée (1)\n- nouveau style pour mise en évidence appliqué (1)\n- titres et sous-titres hiérarchisés (1)",4,3,2,1,0]
["Mise en forme du texte\n- page 2 : création de 4 colonnes (1)\n- page 3 : objet regroupant texte et 2 images (2)\n- page 4 : création d'un tableau de 2 colonnes (1)",4,3,2,1,0]
[{"$f":"A$8&\" - Points max\"","v":"Tâche Mettre en page un document - Points max"},{"$f":"SUM(B55:B58)","v":16},null,"Points obtenus",null,null,{"$f":"SUM(G55:G58)","v":0},null,{"$f":"SUM(I55:I58)","v":0},null,{"$f":"SUM(K55:K58)","v":0},null,{"$f":"SUM(M55:M58)","v":0},null,{"$f":"SUM(O55:O58)","v":0},null,{"$f":"SUM(Q55:Q58)","v":0},null,{"$f":"SUM(S55:S58)","v":0},null,{"$f":"SUM(U55:U58)","v":0},null,{"$f":"SUM(W55:W58)","v":0},null,{"$f":"SUM(Y55:Y58)","v":0},null,{"$f":"SUM(AA55:AA58)","v":0},null,{"$f":"SUM(AC55:AC58)","v":0},null,{"$f":"SUM(AE55:AE58)","v":0},null,{"$f":"SUM(AG55:AG58)","v":0},null,{"$f":"SUM(AI55:AI58)","v":0},null,{"$f":"SUM(AK55:AK58)","v":0},null,{"$f":"SUM(AM55:AM58)","v":0},null,{"$f":"SUM(AO55:AO58)","v":0},null,{"$f":"SUM(AQ55:AQ58)","v":0},null,{"$f":"SUM(AS55:AS58)","v":0},null,{"$f":"SUM(AU55:AU58)","v":0},null,{"$f":"SUM(AW55:AW58)","v":0},null,{"$f":"SUM(AY55:AY58)","v":0},null,{"$f":"SUM(BA55:BA58)","v":0},null,{"$f":"SUM(BC55:BC58)","v":0},null,{"$f":"SUM(BE55:BE58)","v":0},null,{"$f":"SUM(BG55:BG58)","v":0},null,{"$f":"SUM(BI55:BI58)","v":0},null,{"$f":"SUM(BK55:BK58)","v":0},null,{"$f":"SUM(BM55:BM58)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A9","v":"Grille de correction – Tâche Créer un publipostage"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Mise en page\n- format  A5 (1)\n- orientation paysage (1)\n- présentation sur deux colonnes (1) avec ligne séparatrice (1) \n  (tableau ou colonne)",4,3,2,1,0]
["Contenu\n- insertion texte  (1)\n- insertion et positionnement du timbre (1)\n- positionnement adresse destinataire (1)\n- présentation ordre des champs : disposition de l'adresse (1)",4,3,2,1,0]
["Fusion\n- accord par \"si alors sinon\" (2)\n- filtre sur le code annonceur = \"A\" (1)\n- résultat fusion publipostage (1)",4,3,2,1,0]
[{"$f":"A$9&\" - Points max\"","v":"Tâche Créer un publipostage - Points max"},{"$f":"SUM(B64:B66)","v":12},null,"Points obtenus",null,null,{"$f":"SUM(G64:G66)","v":0},null,{"$f":"SUM(I64:I66)","v":0},null,{"$f":"SUM(K64:K66)","v":0},null,{"$f":"SUM(M64:M66)","v":0},null,{"$f":"SUM(O64:O66)","v":0},null,{"$f":"SUM(Q64:Q66)","v":0},null,{"$f":"SUM(S64:S66)","v":0},null,{"$f":"SUM(U64:U66)","v":0},null,{"$f":"SUM(W64:W66)","v":0},null,{"$f":"SUM(Y64:Y66)","v":0},null,{"$f":"SUM(AA64:AA66)","v":0},null,{"$f":"SUM(AC64:AC66)","v":0},null,{"$f":"SUM(AE64:AE66)","v":0},null,{"$f":"SUM(AG64:AG66)","v":0},null,{"$f":"SUM(AI64:AI66)","v":0},null,{"$f":"SUM(AK64:AK66)","v":0},null,{"$f":"SUM(AM64:AM66)","v":0},null,{"$f":"SUM(AO64:AO66)","v":0},null,{"$f":"SUM(AQ64:AQ66)","v":0},null,{"$f":"SUM(AS64:AS66)","v":0},null,{"$f":"SUM(AU64:AU66)","v":0},null,{"$f":"SUM(AW64:AW66)","v":0},null,{"$f":"SUM(AY64:AY66)","v":0},null,{"$f":"SUM(BA64:BA66)","v":0},null,{"$f":"SUM(BC64:BC66)","v":0},null,{"$f":"SUM(BE64:BE66)","v":0},null,{"$f":"SUM(BG64:BG66)","v":0},null,{"$f":"SUM(BI64:BI66)","v":0},null,{"$f":"SUM(BK64:BK66)","v":0},null,{"$f":"SUM(BM64:BM66)","v":0}]
[]
[{"$f":"\"Grille de correction – \"&A10","v":"Grille de correction – Tâche Rédiger une invitation"}]
[null,"Points à attribuer"]
["Elements évalués","Excellent","Bon","Satis-\nfaisant","Juste acquis","Non acquis","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires","Points\nattribués","Commentaires"]
["Contenu : éléments formels\n- lieu et date, destinataire (circulaire) (1)\n- objet et appel adaptés (1)\n- salutations et signature (1)  \n- copie à (1)",4,3,2,1,0]
["Contenu : fond\n- introduction et mention de l'invitation (1)\n- date, lieu de l'invitation (1)\n- programme de l'inauguration cohérent (1)\n- conclusion (1)",4,3,2,1,0]
["Contenu : fond\n- incitation au sponsors à renouveler leur soutien (2)\n- pertinence des éléments pour les inscriptions (2)",4,3,2,1,0]
["Contenu : structure de la lettre\n- ordre logique et idées reliées régulièrement par des mots de liaison (2)\n- qualité de la solution, la lettre pourrait-elle être envoyée sans retouche fondamentale ? (2)",4,3,2,1,0]
["Contenu : forme\n- syntaxe et grammaire (2)\n- orthographe et ponctuation (2)",4,3,2,1,0]
["Contenu : forme\n- style (2)\n- vocabulaire et répétitions (2)",4,3,2,1,0]
[{"$f":"A$10&\" - Points max\"","v":"Tâche Rédiger une invitation - Points max"},{"$f":"SUM(B72:B77)","v":24},null,"Points obtenus",null,null,{"$f":"SUM(G72:G77)","v":0},null,{"$f":"SUM(I72:I77)","v":0},null,{"$f":"SUM(K72:K77)","v":0},null,{"$f":"SUM(M72:M77)","v":0},null,{"$f":"SUM(O72:O77)","v":0},null,{"$f":"SUM(Q72:Q77)","v":0},null,{"$f":"SUM(S72:S77)","v":0},null,{"$f":"SUM(U72:U77)","v":0},null,{"$f":"SUM(W72:W77)","v":0},null,{"$f":"SUM(Y72:Y77)","v":0},null,{"$f":"SUM(AA72:AA77)","v":0},null,{"$f":"SUM(AC72:AC77)","v":0},null,{"$f":"SUM(AE72:AE77)","v":0},null,{"$f":"SUM(AG72:AG77)","v":0},null,{"$f":"SUM(AI72:AI77)","v":0},null,{"$f":"SUM(AK72:AK77)","v":0},null,{"$f":"SUM(AM72:AM77)","v":0},null,{"$f":"SUM(AO72:AO77)","v":0},null,{"$f":"SUM(AQ72:AQ77)","v":0},null,{"$f":"SUM(AS72:AS77)","v":0},null,{"$f":"SUM(AU72:AU77)","v":0},null,{"$f":"SUM(AW72:AW77)","v":0},null,{"$f":"SUM(AY72:AY77)","v":0},null,{"$f":"SUM(BA72:BA77)","v":0},null,{"$f":"SUM(BC72:BC77)","v":0},null,{"$f":"SUM(BE72:BE77)","v":0},null,{"$f":"SUM(BG72:BG77)","v":0},null,{"$f":"SUM(BI72:BI77)","v":0},null,{"$f":"SUM(BK72:BK77)","v":0},null,{"$f":"SUM(BM72:BM77)","v":0}]

{"sheet":"Recap-classe","index":2,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,0,2,1],[7,14,8,14],[7,22,8,22],[7,23,8,23],[3,1,3,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,12,8,12]]}
["Procédures de qualification 2020"]
["ICA"]
[null,null,"Profil E"]
["Ecole"]
["Date"]
["# élèves",{"$f":"COUNTA(B10:B39)","v":3}]
[]
["Numéro","Nom","Prénom","Classe","Nommer les fichiers\n(pts)","Tâche\nPréAO\n(pts)","Tâche\nTABLEUR\n(pts)","Tâche\nTTT\n(pts)","Tâche\nTTT\n(pts)","Tâche\nCORRESP\n(pts)",null,"Total\n(pts)","Note",null,"Note \nsans arrondi",null,"Tâche \"nommer\"\n(%)","Tâche\nPréAO\n(%)","Tâche\nTABLEUR\n(%)","Tâche\nTTT\n(%)","Tâche\nTTT\n(%)","Tâche\nCORRESP\n(%)","% des points","Moyenne %"]
[null,null,null,null,{"$f":"'Grille-classe'!$F$5","v":4},{"$f":"'Grille-classe'!$F$6","v":16},{"$f":"'Grille-classe'!$F$7","v":28},{"$f":"'Grille-classe'!$F$8","v":16},{"$f":"'Grille-classe'!$F$9","v":12},{"$f":"'Grille-classe'!$F$10","v":24},null,{"$f":"SUM(E9:K9)","v":100},null,null,null,null,{"$f":"E10/E$9","v":0},0,0,0,0,0]
[1,"Eleve 1","Prenom 1",null,{"$f":"'Grille-classe'!G$5","v":0},{"$f":"'Grille-classe'!G$6","v":0},{"$f":"'Grille-classe'!G$7","v":0},{"$f":"'Grille-classe'!G$8","v":0},{"$f":"'Grille-classe'!G$9","v":0},{"$f":"'Grille-classe'!G$10","v":0},null,0,{"$f":"ROUND((L10/$L$9*5+1)*2,0)/2","v":1},null,{"$f":"L10/$L$9*5+1","v":1},null,{"$f":"E10/E$9","v":0},{"$f":"F10/F$9","v":0},{"$f":"G10/G$9","v":0},{"$f":"H10/H$9","v":0},{"$f":"I10/I$9","v":0},{"$f":"J10/J$9","v":0},{"$f":"IF(L10=$L$9,0,L10/L$9)","v":0},{"$f":"AVERAGE(Q10:V10)","v":0}]
[2,"Eleve 2","Prénom 2",null,{"$f":"'Grille-classe'!I$5","v":0},{"$f":"'Grille-classe'!I$6","v":0},{"$f":"'Grille-classe'!I$7","v":0},{"$f":"'Grille-classe'!I$8","v":0},{"$f":"'Grille-classe'!I$9","v":0},{"$f":"'Grille-classe'!I$10","v":0},null,0,{"$f":"ROUND((L11/$L$9*5+1)*2,0)/2","v":1},null,{"$f":"L11/$L$9*5+1","v":1},null,0,0,0,0,0,0,0,0]
[3,"Eleve 3","Prénom 3",null,{"$f":"'Grille-classe'!K$5","v":0},{"$f":"'Grille-classe'!K$6","v":0},{"$f":"'Grille-classe'!K$7","v":0},{"$f":"'Grille-classe'!K$8","v":0},{"$f":"'Grille-classe'!K$9","v":0},{"$f":"'Grille-classe'!K$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[4,null,null,null,{"$f":"'Grille-classe'!M$5","v":0},{"$f":"'Grille-classe'!M$6","v":0},{"$f":"'Grille-classe'!M$7","v":0},{"$f":"'Grille-classe'!M$8","v":0},{"$f":"'Grille-classe'!M$9","v":0},{"$f":"'Grille-classe'!M$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[5,null,null,null,{"$f":"'Grille-classe'!O$5","v":0},{"$f":"'Grille-classe'!O$6","v":0},{"$f":"'Grille-classe'!O$7","v":0},{"$f":"'Grille-classe'!O$8","v":0},{"$f":"'Grille-classe'!O$9","v":0},{"$f":"'Grille-classe'!O$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[6,null,null,null,{"$f":"'Grille-classe'!Q$5","v":0},{"$f":"'Grille-classe'!Q$6","v":0},{"$f":"'Grille-classe'!Q$7","v":0},{"$f":"'Grille-classe'!Q$8","v":0},{"$f":"'Grille-classe'!Q$9","v":0},{"$f":"'Grille-classe'!Q$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[7,null,null,null,{"$f":"'Grille-classe'!S$5","v":0},{"$f":"'Grille-classe'!S$6","v":0},{"$f":"'Grille-classe'!S$7","v":0},{"$f":"'Grille-classe'!S$8","v":0},{"$f":"'Grille-classe'!S$9","v":0},{"$f":"'Grille-classe'!S$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[8,null,null,null,{"$f":"'Grille-classe'!U$5","v":0},{"$f":"'Grille-classe'!U$6","v":0},{"$f":"'Grille-classe'!U$7","v":0},{"$f":"'Grille-classe'!U$8","v":0},{"$f":"'Grille-classe'!U$9","v":0},{"$f":"'Grille-classe'!U$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[9,null,null,null,{"$f":"'Grille-classe'!W$5","v":0},{"$f":"'Grille-classe'!W$6","v":0},{"$f":"'Grille-classe'!W$7","v":0},{"$f":"'Grille-classe'!W$8","v":0},{"$f":"'Grille-classe'!W$9","v":0},{"$f":"'Grille-classe'!W$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[10,null,null,null,{"$f":"'Grille-classe'!Y$5","v":0},{"$f":"'Grille-classe'!Y$6","v":0},{"$f":"'Grille-classe'!Y$7","v":0},{"$f":"'Grille-classe'!Y$8","v":0},{"$f":"'Grille-classe'!Y$9","v":0},{"$f":"'Grille-classe'!Y$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[11,null,null,null,{"$f":"'Grille-classe'!AA$5","v":0},{"$f":"'Grille-classe'!AA$6","v":0},{"$f":"'Grille-classe'!AA$7","v":0},{"$f":"'Grille-classe'!AA$8","v":0},{"$f":"'Grille-classe'!AA$9","v":0},{"$f":"'Grille-classe'!AA$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[12,null,null,null,{"$f":"'Grille-classe'!AC$5","v":0},{"$f":"'Grille-classe'!AC$6","v":0},{"$f":"'Grille-classe'!AC$7","v":0},{"$f":"'Grille-classe'!AC$8","v":0},{"$f":"'Grille-classe'!AC$9","v":0},{"$f":"'Grille-classe'!AC$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[13,null,null,null,{"$f":"'Grille-classe'!AE$5","v":0},{"$f":"'Grille-classe'!AE$6","v":0},{"$f":"'Grille-classe'!AE$7","v":0},{"$f":"'Grille-classe'!AE$8","v":0},{"$f":"'Grille-classe'!AE$9","v":0},{"$f":"'Grille-classe'!AE$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[14,null,null,null,{"$f":"'Grille-classe'!AG$5","v":0},{"$f":"'Grille-classe'!AG$6","v":0},{"$f":"'Grille-classe'!AG$7","v":0},{"$f":"'Grille-classe'!AG$8","v":0},{"$f":"'Grille-classe'!AG$9","v":0},{"$f":"'Grille-classe'!AG$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[15,null,null,null,{"$f":"'Grille-classe'!AI$5","v":0},{"$f":"'Grille-classe'!AI$6","v":0},{"$f":"'Grille-classe'!AI$7","v":0},{"$f":"'Grille-classe'!AI$8","v":0},{"$f":"'Grille-classe'!AI$9","v":0},{"$f":"'Grille-classe'!AI$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[16,null,null,null,{"$f":"'Grille-classe'!AK$5","v":0},{"$f":"'Grille-classe'!AK$6","v":0},{"$f":"'Grille-classe'!AK$7","v":0},{"$f":"'Grille-classe'!AK$8","v":0},{"$f":"'Grille-classe'!AK$9","v":0},{"$f":"'Grille-classe'!AK$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[17,null,null,null,{"$f":"'Grille-classe'!AM$5","v":0},{"$f":"'Grille-classe'!AM$6","v":0},{"$f":"'Grille-classe'!AM$7","v":0},{"$f":"'Grille-classe'!AM$8","v":0},{"$f":"'Grille-classe'!AM$9","v":0},{"$f":"'Grille-classe'!AM$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[18,null,null,null,{"$f":"'Grille-classe'!AO$5","v":0},{"$f":"'Grille-classe'!AO$6","v":0},{"$f":"'Grille-classe'!AO$7","v":0},{"$f":"'Grille-classe'!AO$8","v":0},{"$f":"'Grille-classe'!AO$9","v":0},{"$f":"'Grille-classe'!AO$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[19,null,null,null,{"$f":"'Grille-classe'!AQ$5","v":0},{"$f":"'Grille-classe'!AQ$6","v":0},{"$f":"'Grille-classe'!AQ$7","v":0},{"$f":"'Grille-classe'!AQ$8","v":0},{"$f":"'Grille-classe'!AQ$9","v":0},{"$f":"'Grille-classe'!AQ$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[20,null,null,null,{"$f":"'Grille-classe'!AS$5","v":0},{"$f":"'Grille-classe'!AS$6","v":0},{"$f":"'Grille-classe'!AS$7","v":0},{"$f":"'Grille-classe'!AS$8","v":0},{"$f":"'Grille-classe'!AS$9","v":0},{"$f":"'Grille-classe'!AS$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[21,null,null,null,{"$f":"'Grille-classe'!AU$5","v":0},{"$f":"'Grille-classe'!AU$6","v":0},{"$f":"'Grille-classe'!AU$7","v":0},{"$f":"'Grille-classe'!AU$8","v":0},{"$f":"'Grille-classe'!AU$9","v":0},{"$f":"'Grille-classe'!AU$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[22,null,null,null,{"$f":"'Grille-classe'!AW$5","v":0},{"$f":"'Grille-classe'!AW$6","v":0},{"$f":"'Grille-classe'!AW$7","v":0},{"$f":"'Grille-classe'!AW$8","v":0},{"$f":"'Grille-classe'!AW$9","v":0},{"$f":"'Grille-classe'!AW$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[23,null,null,null,{"$f":"'Grille-classe'!AY$5","v":0},{"$f":"'Grille-classe'!AY$6","v":0},{"$f":"'Grille-classe'!AY$7","v":0},{"$f":"'Grille-classe'!AY$8","v":0},{"$f":"'Grille-classe'!AY$9","v":0},{"$f":"'Grille-classe'!AY$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[24,null,null,null,{"$f":"'Grille-classe'!BA$5","v":0},{"$f":"'Grille-classe'!BA$6","v":0},{"$f":"'Grille-classe'!BA$7","v":0},{"$f":"'Grille-classe'!BA$8","v":0},{"$f":"'Grille-classe'!BA$9","v":0},{"$f":"'Grille-classe'!BA$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[25,null,null,null,{"$f":"'Grille-classe'!BC$5","v":0},{"$f":"'Grille-classe'!BC$6","v":0},{"$f":"'Grille-classe'!BC$7","v":0},{"$f":"'Grille-classe'!BC$8","v":0},{"$f":"'Grille-classe'!BC$9","v":0},{"$f":"'Grille-classe'!BC$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[26,null,null,null,{"$f":"'Grille-classe'!BE$5","v":0},{"$f":"'Grille-classe'!BE$6","v":0},{"$f":"'Grille-classe'!BE$7","v":0},{"$f":"'Grille-classe'!BE$8","v":0},{"$f":"'Grille-classe'!BE$9","v":0},{"$f":"'Grille-classe'!BE$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[27,null,null,null,{"$f":"'Grille-classe'!BG$5","v":0},{"$f":"'Grille-classe'!BG$6","v":0},{"$f":"'Grille-classe'!BG$7","v":0},{"$f":"'Grille-classe'!BG$8","v":0},{"$f":"'Grille-classe'!BG$9","v":0},{"$f":"'Grille-classe'!BG$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[28,null,null,null,{"$f":"'Grille-classe'!BI$5","v":0},{"$f":"'Grille-classe'!BI$6","v":0},{"$f":"'Grille-classe'!BI$7","v":0},{"$f":"'Grille-classe'!BI$8","v":0},{"$f":"'Grille-classe'!BI$9","v":0},{"$f":"'Grille-classe'!BI$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[29,null,null,null,{"$f":"'Grille-classe'!BK$5","v":0},{"$f":"'Grille-classe'!BK$6","v":0},{"$f":"'Grille-classe'!BK$7","v":0},{"$f":"'Grille-classe'!BK$8","v":0},{"$f":"'Grille-classe'!BK$9","v":0},{"$f":"'Grille-classe'!BK$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]
[30,null,null,null,{"$f":"'Grille-classe'!BM$5","v":0},{"$f":"'Grille-classe'!BM$6","v":0},{"$f":"'Grille-classe'!BM$7","v":0},{"$f":"'Grille-classe'!BM$8","v":0},{"$f":"'Grille-classe'!BM$9","v":0},{"$f":"'Grille-classe'!BM$10","v":0},null,0,1,null,1,null,0,0,0,0,0,0,0,0]