{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COMPETENCES","GRILLE VIERGE","Liste","CCF_Maths_ln_proba"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"COMPETENCES","index":0,"n_rows":109,"n_cols":16,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
["Satisfaction","Tice","Nombre de niveaux","Nombre de compétences","Nombre d'items","Compétences",{"$f":"F2","v":"S_APPROPRIER"},{"$f":"F3","v":"ANALYSER_RAISONNER"},{"$f":"F4","v":"RÉALISER"},{"$f":"F5","v":"VALIDER"},{"$f":"F6","v":"COMMUNIQUER"},0,0,{"$f":"F9","v":0},{"$f":"F10","v":0},{"$f":"F11","v":0}]
[0,"OUI",{"$f":"COUNTA(A2:A6)","v":3},{"$f":"COUNTA(F2:F11)","v":5},{"$f":"COUNTA(G2:G4)","v":1},"S_APPROPRIER","Rechercher, extraire et organiser l'information","Emettre une conjecture","Choisir ou exécuter une méthode de résolution","Contrôler la vraissemblance d'une conjecture","Rendre compte d'une démarche"]
[1,"NON",null,null,{"$f":"COUNTA(H2:H4)","v":2},"ANALYSER_RAISONNER",null,"Proposer une méthode de résolution","Choisir un protocole expérimental, éxécuter, simuler","Critiquer un résultat, argumenter"]
[2,null,null,null,{"$f":"COUNTA(I2:I4)","v":2},"RÉALISER"]
[null,null,null,null,{"$f":"COUNTA(J2:J4)","v":2},"VALIDER"]
[null,null,null,null,{"$f":"COUNTA(Comp5)","v":1},"COMMUNIQUER"]
[null,null,null,null,{"$f":"COUNTA(L2:L4)","v":0}]
[null,null,null,null,{"$f":"COUNTA(M2:M4)","v":0}]
[null,null,null,null,{"$f":"COUNTA(N2:N4)","v":0}]
[null,null,null,null,{"$f":"COUNTA(O2:O4)","v":0}]
[null,null,null,null,{"$f":"COUNTA(P2:P4)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nombre de compétences",{"$f":"Nb_Compétences","v":5}]
["Taille grille évaluation",null,"Taille grille notation"]
["Nature du classeur","CLASSE"]
["Stats déjà faites",0]
["NB items par compétences",{"$f":"E2","v":1},{"$f":"E3","v":2},{"$f":"E4","v":2},{"$f":"E5","v":2},{"$f":"E6","v":1},{"$f":"E7","v":0},{"$f":"E8","v":0},{"$f":"E9","v":0},{"$f":"E10","v":0},{"$f":"E11","v":0}]
["Intitulés de compétences",{"$f":" F2","v":"S_APPROPRIER"},{"$f":"F3","v":"ANALYSER_RAISONNER"},{"$f":"F4","v":"RÉALISER"},{"$f":"F5","v":"VALIDER"},{"$f":"F6","v":"COMMUNIQUER"},{"$f":"F7","v":0},{"$f":"F8","v":0},{"$f":"F9","v":0},{"$f":"F10","v":0},{"$f":"F11","v":0}]
["Couleurs compétences",65535,4911395,12698107,49407,15773696,10615289,9803737]
["Intitulés d'items",{"$f":"G2","v":"Rechercher, extraire et organiser l'information"},{"$f":"H2","v":"Emettre une conjecture"},"Choisir ou exécuter une méthode de résolution","Contrôler la vraissemblance d'une conjecture","Rendre compte d'une démarche",0,0,0,0,0]
[null,{"$f":"G3","v":0},{"$f":"H3","v":"Proposer une méthode de résolution"},{"$f":"I3","v":"Choisir un protocole expérimental, éxécuter, simuler"},{"$f":"J3","v":"Critiquer un résultat, argumenter"},{"$f":"K3","v":0},{"$f":"L3","v":0},{"$f":"M3","v":0},{"$f":"N3","v":0},{"$f":"O3","v":0},{"$f":"P3","v":0}]
[null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"GRILLE VIERGE","index":1,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":true,"merged":[[20,11,20,14],[0,17,0,18],[1,17,1,18],[3,17,3,18],[5,17,5,18],[7,17,7,18],[13,15,13,16],[17,15,17,16],[9,17,9,18],[11,17,11,18],[13,17,13,18],[15,17,15,18],[5,15,5,16],[9,15,9,16],[0,0,0,1],[1,0,1,1],[0,2,0,7],[1,2,1,7],[0,8,1,8],[0,9,1,9],[0,10,0,16],[1,11,1,14],[1,15,1,16],[2,15,2,16]]}
["CLASSE",null,null,null,null,null,null,null,null,"GRILLE DE NOTATION",null,null,null,null,null,null,null,"PONDÉRATION"]
["ELEVE",null,null,null,null,null,null,null,null,null,"Barème","Appréciation du niveau",null,null,null,"Note",null," Mathématiques"]
["Exercice","Question","Attendu","Niveau","Compétence","Item de compétence visé"," Barème","Note","TICE","S_APPROPRIER",null,"TI","I","S","TS",null,null,"Note","Barème"]
[null,null,null,null,null,null,0,{"$f":"G4*D4/2","v":0},"NON","Rechercher, extraire et organiser l'information",{"$f":"SUMIF($F$4:$F$50,J4,$G$4:$G$50)","v":0},{"$f":"IF(K4=0,\"\",IF(P4/K4<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K4=0,\"\",IF(AND(P4/K4<0.5,P4/K4>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K4=0,\"\",IF(AND(P4/K4<0.75,P4/K4>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K4=0,\"\",IF(P4/K4>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J4,$H$4:$H$50)","v":0},null,"S_APPROPRIER"]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K4:K4)","v":0},null,null,null,null,{"$f":"SUM(P4:P4)","v":0},null,{"$f":"P5/K5*S5","v":{"$error":"#DIV/0!"}},1,{"$f":"K5/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","ANALYSER_RAISONNER",null,"TI","I","S","TS",null,null,"ANALYSER_RAISONNER"]
[null,null,null,null,null,null,0,0,"NON","Emettre une conjecture",{"$f":"SUMIF($F$4:$F$50,J7,$G$4:$G$50)","v":0},{"$f":"IF(K7=0,\"\",IF(P7/K7<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(AND(P7/K7<0.5,P7/K7>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(AND(P7/K7<0.75,P7/K7>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(P7/K7>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J7,$H$4:$H$50)","v":0},null,{"$f":"P9/K9*S7","v":{"$error":"#DIV/0!"}},1,{"$f":"K9/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","Proposer une méthode de résolution",{"$f":"SUMIF($F$4:$F$50,J8,$G$4:$G$50)","v":0},{"$f":"IF(K8=0,\"\",IF(P8/K8<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K8=0,\"\",IF(AND(P8/K8<0.5,P8/K8>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K8=0,\"\",IF(AND(P8/K8<0.75,P8/K8>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K8=0,\"\",IF(P8/K8>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J8,$H$4:$H$50)","v":0},null,"RÉALISER"]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K7:K8)","v":0},null,null,null,null,{"$f":"SUM(P7:P8)","v":0},null,{"$f":"P13/K13*S9","v":{"$error":"#DIV/0!"}},1,{"$f":"K13/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","RÉALISER",null,"TI","I","S","TS",null,null,"VALIDER"]
[null,null,null,null,null,null,0,0,"NON","Choisir ou exécuter une méthode de résolution",{"$f":"SUMIF($F$4:$F$50,J11,$G$4:$G$50)","v":0},{"$f":"IF(K11=0,\"\",IF(P11/K11<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K11=0,\"\",IF(AND(P11/K11<0.5,P11/K11>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K11=0,\"\",IF(AND(P11/K11<0.75,P11/K11>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K11=0,\"\",IF(P11/K11>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J11,$H$4:$H$50)","v":0},null,{"$f":"P17/K17*S11","v":{"$error":"#DIV/0!"}},1,{"$f":"K17/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","Choisir un protocole expérimental, éxécuter, simuler",{"$f":"SUMIF($F$4:$F$50,J12,$G$4:$G$50)","v":0},{"$f":"IF(K12=0,\"\",IF(P12/K12<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(AND(P12/K12<0.5,P12/K12>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(AND(P12/K12<0.75,P12/K12>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(P12/K12>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J12,$H$4:$H$50)","v":0},null,"COMMUNIQUER"]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K11:K12)","v":0},null,null,null,null,{"$f":"SUM(P11:P12)","v":0},null,{"$f":"P20/K20*S13","v":{"$error":"#DIV/0!"}},1,{"$f":"K20/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","VALIDER",null,"TI","I","S","TS",null,null,"TOTAL"]
[null,null,null,null,null,null,0,0,"NON","Contrôler la vraissemblance d'une conjecture",{"$f":"SUMIF($F$4:$F$50,J15,$G$4:$G$50)","v":0},{"$f":"IF(K15=0,\"\",IF(P15/K15<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K15=0,\"\",IF(AND(P15/K15<0.5,P15/K15>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K15=0,\"\",IF(AND(P15/K15<0.75,P15/K15>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K15=0,\"\",IF(P15/K15>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J15,$H$4:$H$50)","v":0},null,{"$f":"SUM(R5,R7,R9,R11,R13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(S5,S7,S9,S11,S13)","v":5}]
[null,null,null,null,null,null,0,0,"NON","Critiquer un résultat, argumenter",{"$f":"SUMIF($F$4:$F$50,J16,$G$4:$G$50)","v":0},{"$f":"IF(K16=0,\"\",IF(P16/K16<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K16=0,\"\",IF(AND(P16/K16<0.5,P16/K16>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K16=0,\"\",IF(AND(P16/K16<0.75,P16/K16>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K16=0,\"\",IF(P16/K16>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J16,$H$4:$H$50)","v":0},null,"Dont TICE"]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K15:K16)","v":0},null,null,null,null,{"$f":"SUM(P15:P16)","v":0},null,{"$f":"SUMIF($I$4:$I$50,\"OUI\",$G$4:$G$50)","v":0},{"$f":"R17/K21","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,0,"NON","COMMUNIQUER",null,"TI","I","S","TS"]
[null,null,null,null,null,null,0,0,"NON","Rendre compte d'une démarche",{"$f":"SUMIF($F$4:$F$50,J19,$G$4:$G$50)","v":0},{"$f":"IF(K19=0,\"\",IF(P19/K19<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K19=0,\"\",IF(AND(P19/K19<0.5,P19/K19>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K19=0,\"\",IF(AND(P19/K19<0.75,P19/K19>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K19=0,\"\",IF(P19/K19>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J19,$H$4:$H$50)","v":0}]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K19:K19)","v":0},null,null,null,null,{"$f":"SUM(P19:P19)","v":0}]
[null,null,null,null,null,null,0,0,"NON",null,{"$f":"SUM(K5,K9,K13,K17,K20)","v":0},null,null,null,null,{"$f":"SUM(P5,P9,P13,P17,P20)","v":0}]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[null,null,null,null,null,null,0,0,"NON"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nombre de compétences",5]
["Taille grille évaluation",{"$f":"COUNTA(E4:E50)","v":0},"Taille grille notation",21]
["Nature du classeur","CLASSE"]
["Stats déjà faites",0]
["NB items par compétences",1,2,2,2,1,0,0,0,0,0]
["Intitulés de compétences","S_APPROPRIER","ANALYSER_RAISONNER","RÉALISER","VALIDER","COMMUNIQUER",0,0,0,0,0]
["Couleurs compétences",65535,4911395,12698107,49407,15773696,10615289,9803737]
["Intitulés d'items","Rechercher, extraire et organiser l'information","Emettre une conjecture","Choisir ou exécuter une méthode de résolution","Contrôler la vraissemblance d'une conjecture","Rendre compte d'une démarche",0,0,0,0,0]
[null,0,"Proposer une méthode de résolution","Choisir un protocole expérimental, éxécuter, simuler","Critiquer un résultat, argumenter",0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Liste","index":2,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTA(A2:A36)","v":0},{"$f":"COUNTA(B2:B36)","v":0},0,0,0,{"$f":"COUNTA(F2:F36)","v":0},0,0,0,0]

{"sheet":"CCF_Maths_ln_proba","index":3,"n_rows":109,"n_cols":20,"rows_kept":109,"cut":false,"hidden":false,"merged":[[0,17,0,18],[1,0,1,1],[1,2,1,7],[1,11,1,14],[1,15,1,16],[0,0,0,1],[0,2,0,7],[0,8,1,8],[0,9,1,9],[0,10,0,16],[1,17,1,18],[2,15,2,16],[3,17,3,18],[5,15,5,16],[5,17,5,18],[3,1,4,1],[5,1,11,1],[12,1,16,1],[9,15,9,16],[9,17,9,18],[11,17,11,18],[13,15,13,16],[13,17,13,18],[15,17,15,18],[7,17,7,18],[17,1,20,1],[22,1,23,1],[25,1,26,1],[27,1,28,1],[17,15,17,16],[20,11,20,14]]}
["CLASSE",null,null,null,null,null,null,null,null,"GRILLE DE NOTATION","CCF_Maths_ln_proba",null,null,null,null,null,null,"PONDÉRATION"]
["ELEVE",null,null,null,null,null,null,null,null,null,"Barème","Appréciation du niveau",null,null,null,"Note",null," Mathématiques"]
["Exercice","Question","Attendu","Niveau","Compétence","Item de compétence visé"," Barème","Note","TICE","S_APPROPRIER",null,"TI","I","S","TS",null,null,"Note","Barème"]
[null,"1.","Protocole correct (lecture graphique ou etude de fonction)",null,"ANALYSER_RAISONNER","Proposer une méthode de résolution",0.75,{"$f":"G4*D4/2","v":0},"OUI","Rechercher, extraire et organiser l'information",{"$f":"SUMIF($F$4:$F$50,J4,$G$4:$G$50)","v":2.25},{"$f":"IF(K4=0,\"\",IF(P4/K4<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K4=0,\"\",IF(AND(P4/K4<0.5,P4/K4>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K4=0,\"\",IF(AND(P4/K4<0.75,P4/K4>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K4=0,\"\",IF(P4/K4>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J4,$H$4:$H$50)","v":0},null,"S_APPROPRIER"]
[null,null,"Communication correcte",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON",null,{"$f":"SUM(K4:K4)","v":2.25},null,null,null,null,{"$f":"SUM(P4:P4)","v":0},"/2,25",{"$f":"P5/K5*S5","v":0},1,{"$f":"K5/K21","v":0.22500000000000001}]
[null,"2.","Tableau les bornes adaptées",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.25,0,"NON","ANALYSER_RAISONNER",null,"TI","I","S","TS",null,null,"ANALYSER_RAISONNER"]
[null,null,"Tableau les signes et le zéro et x",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.5,0,"NON","Emettre une conjecture",{"$f":"SUMIF($F$4:$F$50,J7,$G$4:$G$50)","v":0},{"$f":"IF(K7=0,\"\",IF(P7/K7<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(AND(P7/K7<0.5,P7/K7>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(AND(P7/K7<0.75,P7/K7>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K7=0,\"\",IF(P7/K7>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J7,$H$4:$H$50)","v":0},null,{"$f":"P9/K9*S7","v":0},1,{"$f":"K9/K21","v":0.17499999999999999}]
[null,null,"Tableau variations de f cohérente avec signe de f'(x)",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON","Proposer une méthode de résolution",{"$f":"SUMIF($F$4:$F$50,J8,$G$4:$G$50)","v":1.75},{"$f":"IF(K8=0,\"\",IF(P8/K8<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K8=0,\"\",IF(AND(P8/K8<0.5,P8/K8>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K8=0,\"\",IF(AND(P8/K8<0.75,P8/K8>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K8=0,\"\",IF(P8/K8>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J8,$H$4:$H$50)","v":0},null,"RÉALISER"]
[null,null,"Tableau bornes de f",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.5,0,"NON",null,{"$f":"SUM(K7:K8)","v":1.75},null,null,null,null,{"$f":"SUM(P7:P8)","v":0},"/1,75",{"$f":"P13/K13*S9","v":0},1,{"$f":"K13/K21","v":0.32500000000000001}]
[null,null,"Calcul de la dérivée",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.5,0,"NON","RÉALISER",null,"TI","I","S","TS",null,null,"VALIDER"]
[null,null,"equation f'(x)=0",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON","Choisir ou exécuter une méthode de résolution",{"$f":"SUMIF($F$4:$F$50,J11,$G$4:$G$50)","v":3.25},{"$f":"IF(K11=0,\"\",IF(P11/K11<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K11=0,\"\",IF(AND(P11/K11<0.5,P11/K11>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K11=0,\"\",IF(AND(P11/K11<0.75,P11/K11>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K11=0,\"\",IF(P11/K11>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J11,$H$4:$H$50)","v":0},null,{"$f":"P17/K17*S11","v":0},1,{"$f":"K17/K21","v":7.4999999999999997E-2}]
[null,null,"Calcul valeur inférieure et supérieure à 5",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON","Choisir un protocole expérimental, éxécuter, simuler",{"$f":"SUMIF($F$4:$F$50,J12,$G$4:$G$50)","v":0},{"$f":"IF(K12=0,\"\",IF(P12/K12<0.25,\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(AND(P12/K12<0.5,P12/K12>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(AND(P12/K12<0.75,P12/K12>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K12=0,\"\",IF(P12/K12>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J12,$H$4:$H$50)","v":0},null,"COMMUNIQUER"]
[null,"3.","Tracer de la fonction",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.5,0,"OUI",null,{"$f":"SUM(K11:K12)","v":3.25},null,null,null,null,{"$f":"SUM(P11:P12)","v":0},"/3,25",{"$f":"P20/K20*S13","v":0},1,{"$f":"K20/K21","v":0.2}]
[null,null,"Intervalle respecté",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"OUI","VALIDER",null,"TI","I","S","TS",null,null,"TOTAL"]
[null,null,"Recherche y=7,5 ",null,"ANALYSER_RAISONNER","Proposer une méthode de résolution",1,0,"OUI","Contrôler la vraissemblance d'une conjecture",{"$f":"SUMIF($F$4:$F$50,J15,$G$4:$G$50)","v":0.25},{"$f":"IF(K15=0,\"\",IF(P15/K15<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K15=0,\"\",IF(AND(P15/K15<0.5,P15/K15>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K15=0,\"\",IF(AND(P15/K15<0.75,P15/K15>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K15=0,\"\",IF(P15/K15>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J15,$H$4:$H$50)","v":0},null,{"$f":"SUM(R5,R7,R9,R11,R13)","v":0},{"$f":"SUM(S5,S7,S9,S11,S13)","v":5}]
[null,null,"Donner les solutions x=2,68 et x=8,38",null,"COMMUNIQUER","Rendre compte d'une démarche",0.5,0,"OUI","Critiquer un résultat, argumenter",{"$f":"SUMIF($F$4:$F$50,J16,$G$4:$G$50)","v":0.5},{"$f":"IF(K16=0,\"\",IF(P16/K16<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K16=0,\"\",IF(AND(P16/K16<0.5,P16/K16>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K16=0,\"\",IF(AND(P16/K16<0.75,P16/K16>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K16=0,\"\",IF(P16/K16>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J16,$H$4:$H$50)","v":0},null,"Dont TICE"]
[null,null,"Utilise un vocabulaire adapté",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON",null,{"$f":"SUM(K15:K16)","v":0.75},null,null,null,null,{"$f":"SUM(P15:P16)","v":0},"/0,75",{"$f":"SUMIF($I$4:$I$50,\"OUI\",$G$4:$G$50)","v":3},{"$f":"R17/K21","v":0.3}]
[null,"4.","Réponse à la problématique x= 5000",null,"VALIDER","Contrôler la vraissemblance d'une conjecture",0.25,0,"NON","COMMUNIQUER",null,"TI","I","S","TS"]
[null,null,"Rédaction de la réponse",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON","Rendre compte d'une démarche",{"$f":"SUMIF($F$4:$F$50,J19,$G$4:$G$50)","v":2},{"$f":"IF(K19=0,\"\",IF(P19/K19<0.25,\"x\",\"\"))","v":"x"},{"$f":"IF(K19=0,\"\",IF(AND(P19/K19<0.5,P19/K19>=0.25),\"x\",\"\"))","v":""},{"$f":"IF(K19=0,\"\",IF(AND(P19/K19<0.75,P19/K19>=0.5),\"x\",\"\"))","v":""},{"$f":"IF(K19=0,\"\",IF(P19/K19>0.75,\"x\",\"\"))","v":""},{"$f":"SUMIF($F$4:$F$50,J19,$H$4:$H$50)","v":0}]
[null,null,"y=9,09",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.25,0,"NON",null,{"$f":"SUM(K19:K19)","v":2},null,null,null,null,{"$f":"SUM(P19:P19)","v":0},"/2"]
[null,null,"Valeur du bénéfice 90,9€",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON",null,{"$f":"SUM(K5,K9,K13,K17,K20)","v":10},null,null,null,null,{"$f":"SUM(P5,P9,P13,P17,P20)","v":0},"/10"]
[null,"5.","Entre 2680 et 8380 piéces",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.5,0,"NON"]
[null,"6.","Bonnes valeurs au bonne endroit",null,"S_APPROPRIER","Rechercher, extraire et organiser l'information",0.25,0,"NON"]
[null,null,"Calcul des valeurs manquante",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON"]
[null,"7.","Calcul de p=4/2000=2.10-3",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON"]
[null,"8.","Traduire l'union",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON"]
[null,null,"Calcul de l'union = 80/2000+100/2000-4/2000=176/2000",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.5,0,"NON"]
[null,"9.","Traduire l'inter",null,"COMMUNIQUER","Rendre compte d'une démarche",0.25,0,"NON"]
[null,null,"Calcul de l'inter ",null,"RÉALISER","Choisir ou exécuter une méthode de résolution",0.25,0,"NON"]
[null,"10.","Réponse justifier",null,"VALIDER","Critiquer un résultat, argumenter",0.5,0,"NON"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nombre de compétences",5]
["Taille grille évaluation",{"$f":"COUNTA(E4:E50)","v":27},"Taille grille notation",21]
["Nature du classeur","CLASSE"]
["Stats déjà faites",0]
["NB items par compétences",1,2,2,2,1,0,0,0,0,0]
["Intitulés de compétences","S_APPROPRIER","ANALYSER_RAISONNER","RÉALISER","VALIDER","COMMUNIQUER",0,0,0,0,0]
["Couleurs compétences",65535,4911395,12698107,49407,15773696,10615289,9803737]
["Intitulés d'items","Rechercher, extraire et organiser l'information","Emettre une conjecture","Choisir ou exécuter une méthode de résolution","Contrôler la vraissemblance d'une conjecture","Rendre compte d'une démarche",0,0,0,0,0]
[null,0,"Proposer une méthode de résolution","Choisir un protocole expérimental, éxécuter, simuler","Critiquer un résultat, argumenter",0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]