{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Fiche du projet","Création docs élèves","Cahier Des Charges","Déclinaison projet","Synthèse conduite","Synthèse présentation","Elève A","Elève B","Elève C","Elève D","Elève E","MODE EMPLOI","parametres"],"not_rendered":{"charts":90,"images":2,"macros":1,"external_links":0,"defined_names":52,"comments":4,"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":"Fiche du projet","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,11,30,12],[0,7,2,11],[2,2,2,5],[6,2,6,3],[18,2,18,3],[16,2,16,3],[5,2,5,4],[7,2,7,5],[17,2,17,3],[10,2,11,5],[9,3,9,5],[12,3,12,5],[6,9,6,12],[7,7,9,12],[13,2,14,5],[11,8,13,11],[15,18,15,23],[25,12,26,12],[23,2,23,3],[22,7,22,8],[15,7,20,9],[15,11,20,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[null,null,"Projet déjà réalisé au "]
[null,null,"INTITULE DU PROJET ",null,null,null,null,"POINT DE DEPART"]
[]
[]
[null,null,"ENJEU","Question de société"]
[null,null,null,null,null,null,null,null,"ILLUSTRATION "]
[]
[null,null,"PROBLEMATIQUE","Problème scientifique à résoudre"]
[]
[null,null,null,null,null,null,null,"PRODUCTION(S) ATTENDUE(S)             ",null,null,null,"REALISATION(S) FINALE(S)"]
[null,null,null,null,"Nom","Prénom"]
[null,null,"PROFESSEUR REFERENT :"]
[null,null,"EQUIPE PEDAGOGIQUE associée :",null,"Nom","Prénom"]
[]
[]
[]
[]
[null,null,"Effectif :  ",1,null,null,null,"COMPETENCES EVALUABLES"]
[null,null,"ELEVES du groupe de projet : ",null,"Nom","Prénom",null,"CONDUITE","PRESENTATION","HORAIRES"]
[null,null,null,null,null,null,null,0,0,{"$f":"'Déclinaison projet'!AP8","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"'Déclinaison projet'!AQ8","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"'Déclinaison projet'!AR8","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"'Déclinaison projet'!AS8","v":0}]
[null,null,null,null,null,null,null,0,0,{"$f":"'Déclinaison projet'!AT8","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version du 1er Juillet 2017"]

{"sheet":"Création docs élèves","index":1,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,true]
[null,null,null,null,null,null,null,null,{"$f":"OR(I1,I2,I3)","v":true}]

{"sheet":"Cahier Des Charges","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,4,1,6],[4,6,5,6],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
[]
[null,null,null,null,{"$f":"'Fiche du projet'!C8","v":0}]
[]
[]
[null,null,null,"FONCTIONS DE SERVICE","CRITERES","NIVEAUX","FLEXIBILITE"]
[]
[null,null,"FP"]
[null,null,"FC1"]
[null,null,"FC2"]
[null,null,"FC3"]
[null,null,"FC4"]
[null,null,"FC5"]
[null,null,"FC6"]

{"sheet":"Déclinaison projet","index":3,"n_rows":171,"n_cols":55,"rows_kept":171,"cut":false,"hidden":true,"merged":[[104,27,105,34],[136,27,137,34],[3,27,3,38],[4,27,4,38],[2,28,2,29],[2,30,2,31],[2,32,2,33],[2,34,2,35],[2,36,2,37],[5,27,6,31],[5,32,6,34],[5,35,6,38],[9,32,9,34],[1,28,1,29],[1,30,1,31],[1,32,1,33],[1,34,1,35],[1,36,1,37],[168,5,168,24],[9,21,9,24],[4,40,4,45],[4,5,4,24],[5,5,6,12],[5,13,6,20],[5,21,6,24],[104,5,105,12],[104,13,105,20],[104,21,105,24],[136,5,137,12],[136,13,137,20],[136,21,137,24],[40,5,41,12],[40,13,41,20],[40,21,41,24],[8,47,8,48],[7,5,7,6],[7,7,7,12],[72,5,73,12],[72,13,73,20],[72,21,73,24],[9,5,9,12],[9,13,9,20],[40,27,41,34],[72,27,73,34],[7,27,7,28],[7,29,7,31],[7,32,7,33],[7,36,7,38],[9,27,9,31],[3,5,3,24],[1,5,1,7],[7,13,7,15],[7,16,7,20],[7,21,7,24],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18]]}
[null,null,null,null,null,null,null,null,null,1,0,0]
[null,null,null,null,null,null,null,null,null,"Elève A",null,"Elève B",null,"Elève C",null,"Elève D",null,"Elève E",null,null,null,null,null,null,null,null,null,null,"Elève A",null,"Elève B",null,"Elève C",null,"Elève D",null,"Elève E"]
[null,null,null,{"$f":"'Fiche du projet'!C8","v":0},null,null,null,null,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,null,null,null," INDICATEURS DE PERFORMANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," INDICATEURS DE PERFORMANCE"]
[null,null,null,null,null,"CONDUITE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESENTATION",null,null,null,null,null,null,null,null,null,null,null,null,"REPARTION DES TÂCHES"]
[null,null,null," LA REPARTITION DES TÂCHES",true,"B - Modéliser",null,null,null,null,null,null,null,"C - Expérimenter",null,null,null,null,null,null,null,"D - Communiquer",null,null,null,null,null,"A \nANALYSER",null,null,null,null,"C\nEXPERIMENTER",null,null,"D\nCOMMUNIQUER",null,null,null,null,null,"Elève A:","Elève B:","Elève C:","Elève D:","Elève E:"]
[null,null,null,"        LES INDICATEURS DE  CONDUITE",true,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Fiche du projet'!E25","v":0},{"$f":"'Fiche du projet'!E26","v":0},{"$f":"'Fiche du projet'!E27","v":0},{"$f":"'Fiche du projet'!E28","v":0},{"$f":"'Fiche du projet'!E29","v":0}]
[null,null,null,"                     LES INDICATEURS DE PRESENTATION",true,"B3",null,"B4",null,null,null,null,null,"C1",null,null,"C2",null,null,null,null,"D1",null,null,null,null,null,"A1",null,"A3",null,null,"C1",null,"C2","D1","D2",null,null,null," Horaire élève",{"$f":"IF(parametres!H2>1,SUM(AY10:AY171),\"X\")","v":0},{"$f":"IF(parametres!H3>1,SUM(AZ10:AZ171),\"X\")","v":0},{"$f":"IF(parametres!H4>1,SUM(BA10:BA171),\"X\")","v":0},{"$f":"IF(parametres!H5>1,SUM(BB10:BB171),\"X\")","v":0},{"$f":"IF(parametres!H6>1,SUM(BC10:BC171),\"X\")","v":0}]
[null,null,null,"ETAPES / TACHES",null,"B31","B32","B41","B42","B43","B44","B45","B46","C11","C12","C13","C21","C22","C23","C24","C25","D11","D12","D13","D14",null,null,"A11","A12","A31","A32","A33","C14","C15","C26","D15","D21","D22","D23",null,"volume horaire (h)",null,null,null,null,null,null,"Contribution de professeurs non-STI",null,null,"tA","tB","tC","tD","tE"]
[null,"NOMBRE LIGNES",4,"SPECIFICATION / PLANIFICATION",null,null,null,4,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discipline(s)",null,{"$f":"IF(AP10=\"x\",$AO10,0)","v":0},{"$f":"IF(AQ10=\"x\",$AO10,0)","v":0},{"$f":"IF(AR10=\"x\",$AO10,0)","v":0},{"$f":"IF(AS10=\"x\",$AO10,0)","v":0},{"$f":"IF(AT10=\"x\",$AO10,0)","v":0}]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP11=\"x\",$AO11,0)","v":0},{"$f":"IF(AQ11=\"x\",$AO11,0)","v":0},{"$f":"IF(AR11=\"x\",$AO11,0)","v":0},{"$f":"IF(AS11=\"x\",$AO11,0)","v":0},0]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP12=\"x\",$AO12,0)","v":0},{"$f":"IF(AQ12=\"x\",$AO12,0)","v":0},{"$f":"IF(AR12=\"x\",$AO12,0)","v":0},{"$f":"IF(AS12=\"x\",$AO12,0)","v":0},0]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(AT27=\"x\",$AO27,0)","v":0}]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"REVUE DE PROJET - Planification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP41=\"x\",$AO41,0)","v":0},{"$f":"IF(AQ41=\"x\",$AO41,0)","v":0},{"$f":"IF(AR41=\"x\",$AO41,0)","v":0},{"$f":"IF(AS41=\"x\",$AO41,0)","v":0},0]
[null,"NOMBRE LIGNES",4,"CONCEPTION PRELIMINAIRE",null,null,null,4,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"discipline(s)",null,{"$f":"IF(AP42=\"x\",$AO42,0)","v":0},{"$f":"IF(AQ42=\"x\",$AO42,0)","v":0},{"$f":"IF(AR42=\"x\",$AO42,0)","v":0},{"$f":"IF(AS42=\"x\",$AO42,0)","v":0},0]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"REVUE DE PROJET - Conception préliminaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"NOMBRE LIGNES",4,"CONCEPTION DETAILLEE",null,null,null,4,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"discipline(s)",null,0,0,0,0,0]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP76=\"x\",$AO76,0)","v":0},{"$f":"IF(AQ76=\"x\",$AO76,0)","v":0},{"$f":"IF(AR76=\"x\",$AO76,0)","v":0},{"$f":"IF(AS76=\"x\",$AO76,0)","v":0},0]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(AT91=\"x\",$AO91,0)","v":0}]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"REVUE DE PROJET - Conception détaillée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"NOMBRE LIGNES",4,"PROTOTYPAGE / REALISATION",null,null,null,4,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"discipline(s)",null,0,0,0,0,0]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"REVUE DE PROJET - Réalisation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"NOMBRE LIGNES",4,"QUALIFICATION - INTEGRATION - VALIDATION",null,null,null,4,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,"discipline(s)",null,0,0,0,0,0]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP141=\"x\",$AO141,0)","v":0},{"$f":"IF(AQ141=\"x\",$AO141,0)","v":0},{"$f":"IF(AR141=\"x\",$AO141,0)","v":0},{"$f":"IF(AS141=\"x\",$AO141,0)","v":0},0]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(AT155=\"x\",$AO155,0)","v":0}]
[null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"REVUE DE PROJET - Validation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,"CONDUITE ET REVUES DE PROJET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AP170=\"x\",$AO170,0)","v":0},{"$f":"IF(AQ170=\"x\",$AO170,0)","v":0},{"$f":"IF(AR170=\"x\",$AO170,0)","v":0},{"$f":"IF(AS170=\"x\",$AO170,0)","v":0},{"$f":"IF(AT170=\"x\",$AO170,0)","v":0}]
[null,null,null,"PRESENTATION DU PROJET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]

{"sheet":"Synthèse conduite","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,4,1,8],[2,1,3,2],[36,2,36,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[4,4,4,8],[15,4,15,8],[26,4,26,8]]}
[null,null,null,null,"Indicateurs évaluables"]
[]
[null,{"$f":"'Fiche du projet'!C8","v":0},null,null,"Elève A:","Elève B:","Elève C:","Elève D:","Elève E:"]
[null,null,null,"Poids",{"$f":"'Fiche du projet'!E25","v":0},{"$f":"'Fiche du projet'!E26","v":0},{"$f":"'Fiche du projet'!E27","v":0},{"$f":"'Fiche du projet'!E28","v":0},{"$f":"'Fiche du projet'!E29","v":0}]
[null,"B","MODELISER",0.4,"MODELISER"]
[null,null,"B3 - Résoudre et simuler : Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni"]
[null,null,"Les paramètres de simulation sont adaptés aux grandeurs à simuler"]
[null,null,"Les plages de simulations retenues sont correctement définies"]
[null,null,"B4 - Valider un modèle : Valider un modèle fourni, interpréter les résultats obtenus, préciser les limites de validité du modèle utilisé et modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux"]
[null,null,"Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques "]
[null,null,"Les principales limites sont explicitées "]
[null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers ceux attendus au cahier des charges"]
[null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux"]
[null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges"]
[null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux"]
[null,"C","EXPERIMENTER",0.5,"EXPERIMENTER"]
[null,null," C1 - Identifier les grandeurs physiques à mesurer, décrire une chaîne d'acquisition"]
[null,null,"Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies"]
[null,null,"Les éléments de la chaîne d'acquisition sont correctement identifiés"]
[null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités"]
[null,null,"C2 - Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni  / Traiter les données mesurées en vue d’analyser les écarts"]
[null,null,"Le système est correctement mis en œuvre"]
[null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre"]
[null,null,"Le protocole d'essai est respecté "]
[null,null,"Les règles de sécurité sont connues et respectées"]
[null,null,"Les méthodes et outils de traitement sont cohérents avec le problème posé"]
[null,"D","COMMUNIQUER",0.1,"COMMUNIQUER"]
[null,null,"D1 - Rechercher des informations / Analyser, choisir et classer des informations"]
[null,null,"Les outils de recherche documentaire sont bien choisis et maîtrisés. "]
[null,null,"Une synthèse des informations collectées est correctement réalisée"]
[null,null,"Les informations sont traitées selon des critères pertinents"]
[null,null,"Les informations sont vérifiées et mises à jour"]
[]
[null,null,"Taux d'indicateurs évaluables pour B: MODELISER",null,0,0,0,0,0]
[null,null,"Taux d'indicateurs évaluables pour C: EXPERIEMNTER",null,0,0,0,0,0]
[null,null,"Taux d'indicateurs évaluables pour D: COMMUNIQUER",null,0,0,0,0,0]
[null,null,"Taux global d'indicateurs évaluables",null,0,0,0,0,0]

{"sheet":"Synthèse présentation","index":5,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":true,"merged":[[10,10,10,14],[14,10,14,14],[0,10,1,14],[18,2,18,3],[18,4,18,8],[4,10,4,14],[4,2,4,8],[10,2,10,8],[14,2,14,8],[13,2,13,3],[13,4,13,8],[15,2,15,3],[15,4,15,8],[16,1,18,1],[16,2,16,3],[16,4,16,8],[17,2,17,3],[17,4,17,8],[11,1,12,1],[11,2,11,3],[11,4,11,8],[12,2,12,3],[12,4,12,8],[7,1,9,1],[7,2,7,3],[7,4,7,8],[8,2,8,3],[8,4,8,8],[9,2,9,3],[9,4,9,8],[5,1,6,1],[5,2,5,3],[5,4,5,8],[6,2,6,3],[6,4,6,8]]}
[null,null,null,null,null,null,null,null,null,null,"Indicateurs évaluables"]
[]
[null,null,null,null,null,null,null,null,null,null,"Elève A:","Elève B:","Elève C:","Elève D:","Elève E:"]
[null,null,null,null,null,null,null,null,null,"Poids",{"$f":"'Fiche du projet'!E25","v":0},{"$f":"'Fiche du projet'!E26","v":0},{"$f":"'Fiche du projet'!E27","v":0},{"$f":"'Fiche du projet'!E28","v":0},{"$f":"'Fiche du projet'!E29","v":0}]
[null,"A","ANALYSER",null,null,null,null,null,null,0.3,"ANALYSER"]
[null,"A1"," Définir le besoin  ",null,"Le besoin et la fonction globale sont bien définis "]
[null,null,"Traduire un besoin fonctionnel en problématique technique",null,"Le problème technique est bien décrit"]
[null,"A3 ","Comparer les résultats expérimentaux avec les critères du cahier des charges et interpréter les écarts",null,"Les écarts constatés sont expliqués"]
[null,null,"Comparer les résultats expérimentaux avec les résultats simulés et interpréter les écarts",null,"Les écarts constatés sont expliqués"]
[null,null,"Comparer les résultats simulés avec les critères du cahier des charges et interpréter les écarts",null,"Les écarts constatés sont expliqués"]
[null,"C","EXPERIMENTER",null,null,null,null,null,null,0.3,"EXPERIMENTER"]
[null," C1 ","Identifier le comportement des composants",null,"Le comportement est précisément décrit"]
[null,null,"Justifier le choix des essais réalisés",null,"Un protocole expérimental adapté est décrit"]
[null,"C2","Traiter les données mesurées en vue d'analyser les écarts",null,"Les résultats expérimentaux sont traités et présentés clairement"]
[null,"D","COMMUNIQUER",null,null,null,null,null,null,0.4,"COMMUNIQUER"]
[null,"D1 ","Analyser, choisir et classer des informations",null,"Les informations présentées sont bien choisies "]
[null,"D2 ","Choisir un support de communication et un média adapté, argumenter",null,"Le support est bien choisi et adapté à l'objectif de présentation"]
[null,null,"Produire un support de communication",null,"Un document multimédia est bien réalisé et scénarisé"]
[null,null,"Adapter sa stratégie de communication au contexte",null,"La production respecte le cahier des charges (écrit/oral, texte/vidéo, durée, public visé, …)"]

{"sheet":"Elève A","index":6,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":true,"merged":[[37,14,37,16],[38,14,38,16],[37,7,37,11],[38,7,38,11],[31,3,31,8],[31,9,31,10],[31,11,31,12],[39,7,39,11],[39,3,39,6],[33,3,33,6],[34,2,36,2],[34,3,36,6],[37,3,37,6],[38,3,38,6],[30,3,30,8],[30,9,30,10],[30,11,30,12],[21,1,21,13],[22,1,25,1],[22,2,23,2],[22,3,22,7],[26,3,26,7],[26,8,26,12],[27,3,27,7],[27,8,27,12],[28,3,28,7],[28,8,28,12],[29,2,29,7],[29,9,29,12],[22,16,23,16],[23,3,23,7],[24,2,25,2],[24,3,24,7],[24,16,25,16],[25,3,25,7],[14,16,15,16],[15,3,15,7],[16,2,19,2],[16,3,16,7],[16,16,19,16],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[6,1,11,1],[6,3,6,7],[7,3,7,7],[8,2,9,2],[8,3,8,7],[12,1,12,13],[13,1,15,1],[13,3,13,7],[14,2,15,2],[14,3,14,7],[16,1,20,1],[4,16,5,16],[5,3,5,7],[8,16,9,16],[9,3,9,7],[10,2,11,2],[10,3,10,7],[10,16,11,16],[11,3,11,7],[0,1,0,2],[0,3,0,7],[1,4,1,7],[2,1,2,2],[2,3,2,7],[0,8,0,10],[0,11,0,14],[19,24,22,24],[19,25,22,25],[25,24,26,24],[13,24,15,24],[0,24,0,25],[10,24,10,25],[12,24,12,25],[13,25,15,25],[16,25,18,25],[16,24,18,24],[3,1,3,13],[4,1,5,1],[4,2,5,2],[4,3,4,7]]}
[null,"Baccalauréat S Dominante SI",null,"Conduite de projet ",null,null,null,null,{"$f":"'Fiche du projet'!E25","v":0},null,null,{"$f":"'Fiche du projet'!F25","v":0}]
[]
[null,"COMPÉTENCES ÉVALUÉES",null,"                                      Indicateurs de performance                        ",null,null,null,null,"Non",0,0.33333333333333331,0.66666666666666663,"3/3",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,"Identifications"]
[null,"B-Modéliser",null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,{"$f":"SUM(Q5:Q12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R5:R12)","v":0},{"$f":"SUM(S5:S12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V5:V26)","v":20},{"$f":"IF(V4=20,1,0)","v":1},null,"Diplôme ","Baccalauréat Scientifique \"Sciences de l'Ingénieur\" (S-SI)"]
[null,"B3 ","Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni","Les paramètres de simulation sont adaptés aux grandeurs à simuler",null,null,null,null,{"$f":"IF('Synthèse conduite'!E7=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U5>1,\"◄\",(IF(U5<1,\"◄\",\"\")))","v":""},null,1,{"$f":"SUM(S5:S6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<>\"\",0,P5)","v":0},{"$f":"(IF(K5<>\"\",1/3,0)+IF(L5<>\"\",2/3,0)+IF(M5<>\"\",1,0))*P$4*10*R5/SUM(R$5:R$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"5-COUNTBLANK(I5:M5)","v":1},{"$f":"COUNTBLANK(N5)","v":1},null,null,"Épreuve","Projet : évaluation de la conduite du projet "]
[null,null,null,"Les plages de simulations retenues sont correctement définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!E8=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U6>1,\"◄\",(IF(U6<1,\"◄\",\"\")))","v":""},null,1,null,{"$f":"IF(I6<>\"\",0,P6)","v":0},{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I6:M6)","v":1},{"$f":"COUNTBLANK(N6)","v":1},null,null,"Coefficient ","6x0,25 ou 8x0,25 si le candidat choisit la spécialité SI (la note de projet compte pour un quart dans la note SI)"]
[null,"B4","Interpréter les résultats obtenus","Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques ",null,null,null,null,{"$f":"IF('Synthèse conduite'!E10=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I7:M7)","v":1},1,null,null,"Établissement du candidat",{"$f":"D35","v":"Etablissement"}]
[null,null,"Préciser les limites de validité du modèle utilisé ","Les principales limites sont explicitées ",null,null,null,null,{"$f":"IF('Synthèse conduite'!E11=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S8","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Session  ",{"$f":"INDEX(parametres!A1:A9,'Fiche du projet'!M2)","v":"Session"}]
[null,null,"Modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux","Les paramètres modifiés sont pertinents et font évoluer  les résultats simulés vers ceux attendus au cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!E12=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S9:S10)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Nom du candidat",{"$f":"'Fiche du projet'!E25","v":0}]
[null,null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!E13=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Prénom du candidat ",{"$f":"'Fiche du projet'!F25","v":0}]
[null,null,"Valider un modèle optimisé fourni ","Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!E14=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S11:S12)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!E15=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Titre du projet :",{"$f":"'Fiche du projet'!C8","v":0}]
[null,"C-Expériementer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q14:Q21)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R21)","v":0},{"$f":"SUM(S14:S21)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Description sommaire du projet"]
[null," C1","Identifier les grandeurs physiques à mesurer "," Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!E18=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S14","v":{"$error":"#DIV/0!"}},{"$f":"IF(I14<>\"\",0,P14)","v":0},{"$f":"(IF(K14<>\"\",1/3,0)+IF(L14<>\"\",2/3,0)+IF(M14<>\"\",1,0))*P$13*10*R14/SUM(R$14:R$21)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N14)","v":1},null,null,"Problématique :",{"$f":"'Fiche du projet'!C14","v":0}]
[null,null,"Décrire une chaîne d'acquisition","Les éléments de la chaîne d'acquisition sont correctement identifiés",null,null,null,null,{"$f":"IF('Synthèse conduite'!E19=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités",null,null,null,null,{"$f":"IF('Synthèse conduite'!E20=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,"C2 ","Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni ","Le système est correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!E22=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S17:S20)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Point de départ :",{"$f":"'Fiche du projet'!H8","v":0}]
[null,null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!E23=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Le protocole d'essai est respecté ",null,null,null,null,{"$f":"IF('Synthèse conduite'!E24=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les règles de sécurité sont connues et respectées",null,null,null,null,{"$f":"IF('Synthèse conduite'!E25=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Production attendue :",{"$f":"'Fiche du projet'!H16","v":0}]
[null,null,"Traiter les données mesurées en vue d’analyser les écarts","Les méthodes et outils de traitement sont cohérents avec le problème posé",null,null,null,null,{"$f":"IF('Synthèse conduite'!E26=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S21","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,"D-Communiquer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"SUM(Q23:Q34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R23:R30)","v":0},{"$f":"SUM(S23:S26)","v":{"$error":"#DIV/0!"}}]
[null,"D1 ","Rechercher des informations","Les outils de recherche documentaire sont bien choisis et maîtrisés. ",null,null,null,null,{"$f":"IF('Synthèse conduite'!E29=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S23:S24)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K23<>\"\",1/3,0)+IF(L23<>\"\",2/3,0)+IF(M23<>\"\",1,0))*P$22*10*R23/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N23)","v":1}]
[null,null,null,"Une synthèse des informations collectées est correctement réalisée",null,null,null,null,{"$f":"IF('Synthèse conduite'!E30=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K24<>\"\",1/3,0)+IF(L24<>\"\",2/3,0)+IF(M24<>\"\",1,0))*P$22*10*R24/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N24)","v":1}]
[null,null,"Analyser, choisir et classer des informations","Les informations sont traitées selon des critères pertinents",null,null,null,null,{"$f":"IF('Synthèse conduite'!E31=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S25:S26)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$22*10*R25/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N25)","v":1},null,null,"Conduite de projet","Noms et prénoms des professeurs évaluateurs","Établissement des professeurs évaluateurs"]
[null,null,null,"Les informations sont vérifiées et mises à jour",null,null,null,null,{"$f":"IF('Synthèse conduite'!E32=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$22*10*R26/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N26)","v":1},null,null,null,{"$f":"C39","v":" "},{"$f":"D39","v":"Etablissement"}]
[null,null,null,"Taux d'indicateurs évalués pour B",null,null,null,null,{"$f":"R4/SUM(P5:P12)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour C",null,null,null,null,{"$f":"R13/SUM(P14:P21)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour D",null,null,null,null,{"$f":"R22/SUM(P23:P26)","v":0}]
[]
[null,null,null,"Note obtenue par calcul automatique",null,null,null,null,null,{"$f":"IF(OR(W4=0,I27<0.5,I28<0.5,I29<0.5),\"!\",(Q4+Q13+Q22))","v":"!"},null,"/10"]
[null,null,null,"Note sur 10 proposée au jury pour la conduite de projet\n (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,null,null,null,"/10"]
[]
[null,null,"Nom et prénom du candidat","Établissement du candidat"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E25,\" \",'Fiche du projet'!F25)","v":" "},{"$f":"INDEX(parametres!B1:B23,'Fiche du projet'!$M$1)","v":"Etablissement"}]
[]
[]
[null,null,"Nom et prénom des professeurs                                                         attribuant la note de conduite du projet","Établissement d'origine des examinateurs",null,null,null,"Signatures",null,null,null,null,null,null,"Date"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E17,\" \",'Fiche du projet'!F17)","v":" "},{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"}]
[null,null,null,{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,null,null,"Page 2/2",null,null,null,null,null,null,null,null,null,null,null,null,"Page 1/2"]

{"sheet":"Elève B","index":7,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,24,0,25],[2,1,2,2],[2,3,2,7],[3,1,3,13],[4,1,5,1],[4,2,5,2],[4,3,4,7],[4,16,5,16],[5,3,5,7],[1,4,1,7],[0,1,0,2],[0,3,0,7],[0,8,0,10],[0,11,0,14],[9,3,9,7],[10,2,11,2],[10,3,10,7],[10,16,11,16],[8,2,9,2],[8,3,8,7],[10,24,10,25],[11,3,11,7],[12,1,12,13],[12,24,12,25],[13,1,15,1],[13,3,13,7],[13,24,15,24],[13,25,15,25],[14,2,15,2],[14,3,14,7],[14,16,15,16],[15,3,15,7],[6,1,11,1],[6,3,6,7],[7,3,7,7],[8,16,9,16],[16,24,18,24],[16,25,18,25],[17,3,17,7],[18,3,18,7],[19,3,19,7],[19,24,22,24],[27,3,27,7],[27,8,27,12],[19,25,22,25],[20,3,20,7],[21,1,21,13],[22,1,25,1],[22,2,23,2],[22,3,22,7],[22,16,23,16],[23,3,23,7],[24,2,25,2],[24,3,24,7],[16,1,20,1],[16,2,19,2],[16,3,16,7],[16,16,19,16],[24,16,25,16],[25,3,25,7],[25,24,26,24],[26,3,26,7],[26,8,26,12],[28,3,28,7],[28,8,28,12],[29,2,29,7],[29,9,29,12],[30,3,30,8],[30,9,30,10],[30,11,30,12],[31,3,31,8],[31,9,31,10],[31,11,31,12],[33,3,33,6],[34,2,36,2],[34,3,36,6],[39,3,39,6],[39,7,39,11],[37,3,37,6],[37,7,37,11],[37,14,37,16],[38,3,38,6],[38,7,38,11],[38,14,38,16]]}
[null,"Baccalauréat S Dominante SI",null,"Conduite de projet ",null,null,null,null,{"$f":"'Fiche du projet'!E26","v":0},null,null,{"$f":"'Fiche du projet'!F26","v":0}]
[]
[null,"COMPÉTENCES ÉVALUÉES",null,"                                      Indicateurs de performance                        ",null,null,null,null,"Non",0,0.33333333333333331,0.66666666666666663,"3/3",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,"Identifications"]
[null,"B-Modéliser",null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,{"$f":"SUM(Q5:Q12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R5:R12)","v":0},{"$f":"SUM(S5:S12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V5:V26)","v":20},{"$f":"IF(V4=20,1,0)","v":1},null,"Diplôme ","Baccalauréat Scientifique \"Sciences de l'Ingénieur\" (S-SI)"]
[null,"B3 ","Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni","Les paramètres de simulation sont adaptés aux grandeurs à simuler",null,null,null,null,{"$f":"IF('Synthèse conduite'!F7=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U5>1,\"◄\",(IF(U5<1,\"◄\",\"\")))","v":""},null,1,{"$f":"SUM(S5:S6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<>\"\",0,P5)","v":0},{"$f":"(IF(K5<>\"\",1/3,0)+IF(L5<>\"\",2/3,0)+IF(M5<>\"\",1,0))*P$4*10*R5/SUM(R$5:R$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"5-COUNTBLANK(I5:M5)","v":1},{"$f":"COUNTBLANK(N5)","v":1},null,null,"Épreuve","Projet : évaluation de la conduite du projet "]
[null,null,null,"Les plages de simulations retenues sont correctement définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!F8=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U6>1,\"◄\",(IF(U6<1,\"◄\",\"\")))","v":""},null,1,null,{"$f":"IF(I6<>\"\",0,P6)","v":0},{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I6:M6)","v":1},{"$f":"COUNTBLANK(N6)","v":1},null,null,"Coefficient ","6x0,25 ou 8x0,25 si le candidat choisit la spécialité SI (la note de projet compte pour un quart dans la note SI)"]
[null,"B4","Interpréter les résultats obtenus","Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques ",null,null,null,null,{"$f":"IF('Synthèse conduite'!F10=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I7:M7)","v":1},1,null,null,"Établissement du candidat",{"$f":"D35","v":"Etablissement"}]
[null,null,"Préciser les limites de validité du modèle utilisé ","Les principales limites sont explicitées ",null,null,null,null,{"$f":"IF('Synthèse conduite'!F11=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S8","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Session  ",{"$f":"INDEX(parametres!A1:A9,'Fiche du projet'!M2)","v":"Session"}]
[null,null,"Modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux","Les paramètres modifiés sont pertinents et font évoluer  les résultats simulés vers ceux attendus au cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!F12=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S9:S10)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Nom du candidat",{"$f":"'Fiche du projet'!E26","v":0}]
[null,null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!F13=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Prénom du candidat ",{"$f":"'Fiche du projet'!F26","v":0}]
[null,null,"Valider un modèle optimisé fourni ","Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!F14=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S11:S12)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!F15=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Titre du projet :",{"$f":"'Fiche du projet'!C8","v":0}]
[null,"C-Expériementer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q14:Q21)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R21)","v":0},{"$f":"SUM(S14:S21)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Description sommaire du projet"]
[null," C1","Identifier les grandeurs physiques à mesurer "," Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!F18=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S14","v":{"$error":"#DIV/0!"}},{"$f":"IF(I14<>\"\",0,P14)","v":0},{"$f":"(IF(K14<>\"\",1/3,0)+IF(L14<>\"\",2/3,0)+IF(M14<>\"\",1,0))*P$13*10*R14/SUM(R$14:R$21)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N14)","v":1},null,null,"Problématique :",{"$f":"'Fiche du projet'!C14","v":0}]
[null,null,"Décrire une chaîne d'acquisition","Les éléments de la chaîne d'acquisition sont correctement identifiés",null,null,null,null,{"$f":"IF('Synthèse conduite'!F19=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités",null,null,null,null,{"$f":"IF('Synthèse conduite'!F20=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,"C2 ","Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni ","Le système est correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!F22=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S17:S20)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Point de départ :",{"$f":"'Fiche du projet'!H8","v":0}]
[null,null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!F23=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Le protocole d'essai est respecté ",null,null,null,null,{"$f":"IF('Synthèse conduite'!F24=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les règles de sécurité sont connues et respectées",null,null,null,null,{"$f":"IF('Synthèse conduite'!F25=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Production attendue :",{"$f":"'Fiche du projet'!H16","v":0}]
[null,null,"Traiter les données mesurées en vue d’analyser les écarts","Les méthodes et outils de traitement sont cohérents avec le problème posé",null,null,null,null,{"$f":"IF('Synthèse conduite'!F26=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S21","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,"D-Communiquer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"SUM(Q23:Q34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R23:R30)","v":0},{"$f":"SUM(S23:S26)","v":{"$error":"#DIV/0!"}}]
[null,"D1 ","Rechercher des informations","Les outils de recherche documentaire sont bien choisis et maîtrisés. ",null,null,null,null,{"$f":"IF('Synthèse conduite'!F29=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S23:S24)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K23<>\"\",1/3,0)+IF(L23<>\"\",2/3,0)+IF(M23<>\"\",1,0))*P$22*10*R23/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N23)","v":1}]
[null,null,null,"Une synthèse des informations collectées est correctement réalisée",null,null,null,null,{"$f":"IF('Synthèse conduite'!F30=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K24<>\"\",1/3,0)+IF(L24<>\"\",2/3,0)+IF(M24<>\"\",1,0))*P$22*10*R24/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N24)","v":1}]
[null,null,"Analyser, choisir et classer des informations","Les informations sont traitées selon des critères pertinents",null,null,null,null,{"$f":"IF('Synthèse conduite'!F31=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S25:S26)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$22*10*R25/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N25)","v":1},null,null,"Conduite de projet","Noms et prénoms des professeurs évaluateurs","Établissement des professeurs évaluateurs"]
[null,null,null,"Les informations sont vérifiées et mises à jour",null,null,null,null,{"$f":"IF('Synthèse conduite'!F32=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$22*10*R26/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N26)","v":1},null,null,null,{"$f":"C39","v":" "},{"$f":"D39","v":"Etablissement"}]
[null,null,null,"Taux d'indicateurs évalués pour B",null,null,null,null,{"$f":"R4/SUM(P5:P12)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour C",null,null,null,null,{"$f":"R13/SUM(P14:P21)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour D",null,null,null,null,{"$f":"R22/SUM(P23:P26)","v":0}]
[]
[null,null,null,"Note obtenue par calcul automatique",null,null,null,null,null,{"$f":"IF(OR(W4=0,I27<0.5,I28<0.5,I29<0.5),\"!\",(Q4+Q13+Q22))","v":"!"},null,"/10"]
[null,null,null,"Note sur 10 proposée au jury pour la conduite de projet\n (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,null,null,null,"/10"]
[]
[null,null,"Nom et prénom du candidat","Établissement du candidat"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E26,\" \",'Fiche du projet'!F26)","v":" "},{"$f":"INDEX(parametres!B1:B23,'Fiche du projet'!$M$1)","v":"Etablissement"}]
[]
[]
[null,null,"Nom et prénom des professeurs                                                         attribuant la note de conduite du projet","Établissement d'origine des examinateurs",null,null,null,"Signatures",null,null,null,null,null,null,"Date"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E17,\" \",'Fiche du projet'!F17)","v":" "},{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"}]
[null,null,null,{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,null,null,"Page 2/2",null,null,null,null,null,null,null,null,null,null,null,null,"Page 1/2"]

{"sheet":"Elève C","index":8,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,24,0,25],[2,1,2,2],[2,3,2,7],[3,1,3,13],[4,1,5,1],[4,2,5,2],[4,3,4,7],[4,16,5,16],[5,3,5,7],[1,4,1,7],[0,1,0,2],[0,3,0,7],[0,8,0,10],[0,11,0,14],[9,3,9,7],[10,2,11,2],[10,3,10,7],[10,16,11,16],[8,2,9,2],[8,3,8,7],[10,24,10,25],[11,3,11,7],[12,1,12,13],[12,24,12,25],[13,1,15,1],[13,3,13,7],[13,24,15,24],[13,25,15,25],[14,2,15,2],[14,3,14,7],[14,16,15,16],[15,3,15,7],[6,1,11,1],[6,3,6,7],[7,3,7,7],[8,16,9,16],[16,24,18,24],[16,25,18,25],[17,3,17,7],[18,3,18,7],[19,3,19,7],[19,24,22,24],[27,3,27,7],[27,8,27,12],[19,25,22,25],[20,3,20,7],[21,1,21,13],[22,1,25,1],[22,2,23,2],[22,3,22,7],[22,16,23,16],[23,3,23,7],[24,2,25,2],[24,3,24,7],[16,1,20,1],[16,2,19,2],[16,3,16,7],[16,16,19,16],[24,16,25,16],[25,3,25,7],[25,24,26,24],[26,3,26,7],[26,8,26,12],[28,3,28,7],[28,8,28,12],[29,2,29,7],[29,9,29,12],[30,3,30,8],[30,9,30,10],[30,11,30,12],[31,3,31,8],[31,9,31,10],[31,11,31,12],[33,3,33,6],[34,2,36,2],[34,3,36,6],[39,3,39,6],[39,7,39,11],[37,3,37,6],[37,7,37,11],[37,14,37,16],[38,3,38,6],[38,7,38,11],[38,14,38,16]]}
[null,"Baccalauréat S Dominante SI",null,"Conduite de projet ",null,null,null,null,{"$f":"'Fiche du projet'!E27","v":0},null,null,{"$f":"'Fiche du projet'!F27","v":0}]
[]
[null,"COMPÉTENCES ÉVALUÉES",null,"                                      Indicateurs de performance                        ",null,null,null,null,"Non",0,0.33333333333333331,0.66666666666666663,"3/3",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,"Identifications"]
[null,"B-Modéliser",null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,{"$f":"SUM(Q5:Q12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R5:R12)","v":0},{"$f":"SUM(S5:S12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V5:V26)","v":20},{"$f":"IF(V4=20,1,0)","v":1},null,"Diplôme ","Baccalauréat Scientifique \"Sciences de l'Ingénieur\" (S-SI)"]
[null,"B3 ","Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni","Les paramètres de simulation sont adaptés aux grandeurs à simuler",null,null,null,null,{"$f":"IF('Synthèse conduite'!G7=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U5>1,\"◄\",(IF(U5<1,\"◄\",\"\")))","v":""},null,1,{"$f":"SUM(S5:S6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<>\"\",0,P5)","v":0},{"$f":"(IF(K5<>\"\",1/3,0)+IF(L5<>\"\",2/3,0)+IF(M5<>\"\",1,0))*P$4*10*R5/SUM(R$5:R$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"5-COUNTBLANK(I5:M5)","v":1},{"$f":"COUNTBLANK(N5)","v":1},null,null,"Épreuve","Projet : évaluation de la conduite du projet "]
[null,null,null,"Les plages de simulations retenues sont correctement définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!G8=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U6>1,\"◄\",(IF(U6<1,\"◄\",\"\")))","v":""},null,1,null,{"$f":"IF(I6<>\"\",0,P6)","v":0},{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I6:M6)","v":1},{"$f":"COUNTBLANK(N6)","v":1},null,null,"Coefficient ","6x0,25 ou 8x0,25 si le candidat choisit la spécialité SI (la note de projet compte pour un quart dans la note SI)"]
[null,"B4","Interpréter les résultats obtenus","Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques ",null,null,null,null,{"$f":"IF('Synthèse conduite'!G10=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I7:M7)","v":1},1,null,null,"Établissement du candidat",{"$f":"D35","v":"Etablissement"}]
[null,null,"Préciser les limites de validité du modèle utilisé ","Les principales limites sont explicitées ",null,null,null,null,{"$f":"IF('Synthèse conduite'!G11=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S8","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Session  ",{"$f":"INDEX(parametres!A1:A9,'Fiche du projet'!M2)","v":"Session"}]
[null,null,"Modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux","Les paramètres modifiés sont pertinents et font évoluer  les résultats simulés vers ceux attendus au cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!G12=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S9:S10)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Nom du candidat",{"$f":"'Fiche du projet'!E27","v":0}]
[null,null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!G13=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Prénom du candidat ",{"$f":"'Fiche du projet'!F27","v":0}]
[null,null,"Valider un modèle optimisé fourni ","Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!G14=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S11:S12)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!G15=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Titre du projet :",{"$f":"'Fiche du projet'!C8","v":0}]
[null,"C-Expériementer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q14:Q21)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R21)","v":0},{"$f":"SUM(S14:S21)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Description sommaire du projet"]
[null," C1","Identifier les grandeurs physiques à mesurer "," Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!G18=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S14","v":{"$error":"#DIV/0!"}},{"$f":"IF(I14<>\"\",0,P14)","v":0},{"$f":"(IF(K14<>\"\",1/3,0)+IF(L14<>\"\",2/3,0)+IF(M14<>\"\",1,0))*P$13*10*R14/SUM(R$14:R$21)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N14)","v":1},null,null,"Problématique :",{"$f":"'Fiche du projet'!C14","v":0}]
[null,null,"Décrire une chaîne d'acquisition","Les éléments de la chaîne d'acquisition sont correctement identifiés",null,null,null,null,{"$f":"IF('Synthèse conduite'!G19=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités",null,null,null,null,{"$f":"IF('Synthèse conduite'!G20=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,"C2 ","Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni ","Le système est correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!G22=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S17:S20)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Point de départ :",{"$f":"'Fiche du projet'!H8","v":0}]
[null,null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!G23=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Le protocole d'essai est respecté ",null,null,null,null,{"$f":"IF('Synthèse conduite'!G24=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les règles de sécurité sont connues et respectées",null,null,null,null,{"$f":"IF('Synthèse conduite'!G25=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Production attendue :",{"$f":"'Fiche du projet'!H16","v":0}]
[null,null,"Traiter les données mesurées en vue d’analyser les écarts","Les méthodes et outils de traitement sont cohérents avec le problème posé",null,null,null,null,{"$f":"IF('Synthèse conduite'!G26=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S21","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,"D-Communiquer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"SUM(Q23:Q34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R23:R30)","v":0},{"$f":"SUM(S23:S26)","v":{"$error":"#DIV/0!"}}]
[null,"D1 ","Rechercher des informations","Les outils de recherche documentaire sont bien choisis et maîtrisés. ",null,null,null,null,{"$f":"IF('Synthèse conduite'!G29=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S23:S24)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K23<>\"\",1/3,0)+IF(L23<>\"\",2/3,0)+IF(M23<>\"\",1,0))*P$22*10*R23/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N23)","v":1}]
[null,null,null,"Une synthèse des informations collectées est correctement réalisée",null,null,null,null,{"$f":"IF('Synthèse conduite'!G30=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K24<>\"\",1/3,0)+IF(L24<>\"\",2/3,0)+IF(M24<>\"\",1,0))*P$22*10*R24/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N24)","v":1}]
[null,null,"Analyser, choisir et classer des informations","Les informations sont traitées selon des critères pertinents",null,null,null,null,{"$f":"IF('Synthèse conduite'!G31=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S25:S26)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$22*10*R25/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N25)","v":1},null,null,"Conduite de projet","Noms et prénoms des professeurs évaluateurs","Établissement des professeurs évaluateurs"]
[null,null,null,"Les informations sont vérifiées et mises à jour",null,null,null,null,{"$f":"IF('Synthèse conduite'!G32=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$22*10*R26/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N26)","v":1},null,null,null,{"$f":"C39","v":" "},{"$f":"D39","v":"Etablissement"}]
[null,null,null,"Taux d'indicateurs évalués pour B",null,null,null,null,{"$f":"R4/SUM(P5:P12)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour C",null,null,null,null,{"$f":"R13/SUM(P14:P21)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour D",null,null,null,null,{"$f":"R22/SUM(P23:P26)","v":0}]
[]
[null,null,null,"Note obtenue par calcul automatique",null,null,null,null,null,{"$f":"IF(OR(W4=0,I27<0.5,I28<0.5,I29<0.5),\"!\",(Q4+Q13+Q22))","v":"!"},null,"/10"]
[null,null,null,"Note sur 10 proposée au jury pour la conduite de projet\n (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,null,null,null,"/10"]
[]
[null,null,"Nom et prénom du candidat","Établissement du candidat"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E27,\" \",'Fiche du projet'!F27)","v":" "},{"$f":"INDEX(parametres!B1:B23,'Fiche du projet'!$M$1)","v":"Etablissement"}]
[]
[]
[null,null,"Nom et prénom des professeurs                                                         attribuant la note de conduite du projet","Établissement d'origine des examinateurs",null,null,null,"Signatures",null,null,null,null,null,null,"Date"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E17,\" \",'Fiche du projet'!F17)","v":" "},{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"}]
[null,null,null,{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,null,null,"Page 2/2",null,null,null,null,null,null,null,null,null,null,null,null,"Page 1/2"]

{"sheet":"Elève D","index":9,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,24,0,25],[2,1,2,2],[2,3,2,7],[3,1,3,13],[4,1,5,1],[4,2,5,2],[4,3,4,7],[4,16,5,16],[5,3,5,7],[1,4,1,7],[0,1,0,2],[0,3,0,7],[0,8,0,10],[0,11,0,14],[9,3,9,7],[10,2,11,2],[10,3,10,7],[10,16,11,16],[8,2,9,2],[8,3,8,7],[10,24,10,25],[11,3,11,7],[12,1,12,13],[12,24,12,25],[13,1,15,1],[13,3,13,7],[13,24,15,24],[13,25,15,25],[14,2,15,2],[14,3,14,7],[14,16,15,16],[15,3,15,7],[6,1,11,1],[6,3,6,7],[7,3,7,7],[8,16,9,16],[16,24,18,24],[16,25,18,25],[17,3,17,7],[18,3,18,7],[19,3,19,7],[19,24,22,24],[27,3,27,7],[27,8,27,12],[19,25,22,25],[20,3,20,7],[21,1,21,13],[22,1,25,1],[22,2,23,2],[22,3,22,7],[22,16,23,16],[23,3,23,7],[24,2,25,2],[24,3,24,7],[16,1,20,1],[16,2,19,2],[16,3,16,7],[16,16,19,16],[24,16,25,16],[25,3,25,7],[25,24,26,24],[26,3,26,7],[26,8,26,12],[28,3,28,7],[28,8,28,12],[29,2,29,7],[29,9,29,12],[30,3,30,8],[30,9,30,10],[30,11,30,12],[31,3,31,8],[31,9,31,10],[31,11,31,12],[33,3,33,6],[34,2,36,2],[34,3,36,6],[39,3,39,6],[39,7,39,11],[37,3,37,6],[37,7,37,11],[37,14,37,16],[38,3,38,6],[38,7,38,11],[38,14,38,16]]}
[null,"Baccalauréat S Dominante SI",null,"Conduite de projet ",null,null,null,null,{"$f":"'Fiche du projet'!E28","v":0},null,null,{"$f":"'Fiche du projet'!F28","v":0}]
[]
[null,"COMPÉTENCES ÉVALUÉES",null,"                                      Indicateurs de performance                        ",null,null,null,null,"Non",0,0.33333333333333331,0.66666666666666663,"3/3",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,"Identifications"]
[null,"B-Modéliser",null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,{"$f":"SUM(Q5:Q12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R5:R12)","v":0},{"$f":"SUM(S5:S12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V5:V26)","v":20},{"$f":"IF(V4=20,1,0)","v":1},null,"Diplôme ","Baccalauréat Scientifique \"Sciences de l'Ingénieur\" (S-SI)"]
[null,"B3 ","Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni","Les paramètres de simulation sont adaptés aux grandeurs à simuler",null,null,null,null,{"$f":"IF('Synthèse conduite'!H7=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U5>1,\"◄\",(IF(U5<1,\"◄\",\"\")))","v":""},null,1,{"$f":"SUM(S5:S6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<>\"\",0,P5)","v":0},{"$f":"(IF(K5<>\"\",1/3,0)+IF(L5<>\"\",2/3,0)+IF(M5<>\"\",1,0))*P$4*10*R5/SUM(R$5:R$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"5-COUNTBLANK(I5:M5)","v":1},{"$f":"COUNTBLANK(N5)","v":1},null,null,"Épreuve","Projet : évaluation de la conduite du projet "]
[null,null,null,"Les plages de simulations retenues sont correctement définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!H8=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U6>1,\"◄\",(IF(U6<1,\"◄\",\"\")))","v":""},null,1,null,{"$f":"IF(I6<>\"\",0,P6)","v":0},{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I6:M6)","v":1},{"$f":"COUNTBLANK(N6)","v":1},null,null,"Coefficient ","6x0,25 ou 8x0,25 si le candidat choisit la spécialité SI (la note de projet compte pour un quart dans la note SI)"]
[null,"B4","Interpréter les résultats obtenus","Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques ",null,null,null,null,{"$f":"IF('Synthèse conduite'!H10=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I7:M7)","v":1},1,null,null,"Établissement du candidat",{"$f":"D35","v":"Etablissement"}]
[null,null,"Préciser les limites de validité du modèle utilisé ","Les principales limites sont explicitées ",null,null,null,null,{"$f":"IF('Synthèse conduite'!H11=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S8","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Session  ",{"$f":"INDEX(parametres!A1:A9,'Fiche du projet'!M2)","v":"Session"}]
[null,null,"Modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux","Les paramètres modifiés sont pertinents et font évoluer  les résultats simulés vers ceux attendus au cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!H12=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S9:S10)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Nom du candidat",{"$f":"'Fiche du projet'!E28","v":0}]
[null,null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!H13=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Prénom du candidat ",{"$f":"'Fiche du projet'!F28","v":0}]
[null,null,"Valider un modèle optimisé fourni ","Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!H14=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S11:S12)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!H15=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Titre du projet :",{"$f":"'Fiche du projet'!C8","v":0}]
[null,"C-Expériementer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q14:Q21)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R21)","v":0},{"$f":"SUM(S14:S21)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Description sommaire du projet"]
[null," C1","Identifier les grandeurs physiques à mesurer "," Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!H18=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S14","v":{"$error":"#DIV/0!"}},{"$f":"IF(I14<>\"\",0,P14)","v":0},{"$f":"(IF(K14<>\"\",1/3,0)+IF(L14<>\"\",2/3,0)+IF(M14<>\"\",1,0))*P$13*10*R14/SUM(R$14:R$21)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N14)","v":1},null,null,"Problématique :",{"$f":"'Fiche du projet'!C14","v":0}]
[null,null,"Décrire une chaîne d'acquisition","Les éléments de la chaîne d'acquisition sont correctement identifiés",null,null,null,null,{"$f":"IF('Synthèse conduite'!H19=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités",null,null,null,null,{"$f":"IF('Synthèse conduite'!H20=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,"C2 ","Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni ","Le système est correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!H22=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S17:S20)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Point de départ :",{"$f":"'Fiche du projet'!H8","v":0}]
[null,null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!H23=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Le protocole d'essai est respecté ",null,null,null,null,{"$f":"IF('Synthèse conduite'!H24=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les règles de sécurité sont connues et respectées",null,null,null,null,{"$f":"IF('Synthèse conduite'!H25=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Production attendue :",{"$f":"'Fiche du projet'!H16","v":0}]
[null,null,"Traiter les données mesurées en vue d’analyser les écarts","Les méthodes et outils de traitement sont cohérents avec le problème posé",null,null,null,null,{"$f":"IF('Synthèse conduite'!H26=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S21","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,"D-Communiquer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"SUM(Q23:Q34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R23:R30)","v":0},{"$f":"SUM(S23:S26)","v":{"$error":"#DIV/0!"}}]
[null,"D1 ","Rechercher des informations","Les outils de recherche documentaire sont bien choisis et maîtrisés. ",null,null,null,null,{"$f":"IF('Synthèse conduite'!H29=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S23:S24)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K23<>\"\",1/3,0)+IF(L23<>\"\",2/3,0)+IF(M23<>\"\",1,0))*P$22*10*R23/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N23)","v":1}]
[null,null,null,"Une synthèse des informations collectées est correctement réalisée",null,null,null,null,{"$f":"IF('Synthèse conduite'!H30=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K24<>\"\",1/3,0)+IF(L24<>\"\",2/3,0)+IF(M24<>\"\",1,0))*P$22*10*R24/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N24)","v":1}]
[null,null,"Analyser, choisir et classer des informations","Les informations sont traitées selon des critères pertinents",null,null,null,null,{"$f":"IF('Synthèse conduite'!H31=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S25:S26)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$22*10*R25/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N25)","v":1},null,null,"Conduite de projet","Noms et prénoms des professeurs évaluateurs","Établissement des professeurs évaluateurs"]
[null,null,null,"Les informations sont vérifiées et mises à jour",null,null,null,null,{"$f":"IF('Synthèse conduite'!H32=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$22*10*R26/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N26)","v":1},null,null,null,{"$f":"C39","v":" "},{"$f":"D39","v":"Etablissement"}]
[null,null,null,"Taux d'indicateurs évalués pour B",null,null,null,null,{"$f":"R4/SUM(P5:P12)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour C",null,null,null,null,{"$f":"R13/SUM(P14:P21)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour D",null,null,null,null,{"$f":"R22/SUM(P23:P26)","v":0}]
[]
[null,null,null,"Note obtenue par calcul automatique",null,null,null,null,null,{"$f":"IF(OR(W4=0,I27<0.5,I28<0.5,I29<0.5),\"!\",(Q4+Q13+Q22))","v":"!"},null,"/10"]
[null,null,null,"Note sur 10 proposée au jury pour la conduite de projet\n (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,null,null,null,"/10"]
[]
[null,null,"Nom et prénom du candidat","Établissement du candidat"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E28,\" \",'Fiche du projet'!F28)","v":" "},{"$f":"INDEX(parametres!B1:B23,'Fiche du projet'!$M$1)","v":"Etablissement"}]
[]
[]
[null,null,"Nom et prénom des professeurs                                                         attribuant la note de conduite du projet","Établissement d'origine des examinateurs",null,null,null,"Signatures",null,null,null,null,null,null,"Date"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E17,\" \",'Fiche du projet'!F17)","v":" "},{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"}]
[null,null,null,{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,null,null,"Page 2/2",null,null,null,null,null,null,null,null,null,null,null,null,"Page 1/2"]

{"sheet":"Elève E","index":10,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,24,0,25],[2,1,2,2],[2,3,2,7],[3,1,3,13],[4,1,5,1],[4,2,5,2],[4,3,4,7],[4,16,5,16],[5,3,5,7],[1,4,1,7],[0,1,0,2],[0,3,0,7],[0,8,0,10],[0,11,0,14],[9,3,9,7],[10,2,11,2],[10,3,10,7],[10,16,11,16],[8,2,9,2],[8,3,8,7],[10,24,10,25],[11,3,11,7],[12,1,12,13],[12,24,12,25],[13,1,15,1],[13,3,13,7],[13,24,15,24],[13,25,15,25],[14,2,15,2],[14,3,14,7],[14,16,15,16],[15,3,15,7],[6,1,11,1],[6,3,6,7],[7,3,7,7],[8,16,9,16],[16,24,18,24],[16,25,18,25],[17,3,17,7],[18,3,18,7],[19,3,19,7],[19,24,22,24],[27,3,27,7],[27,8,27,12],[19,25,22,25],[20,3,20,7],[21,1,21,13],[22,1,25,1],[22,2,23,2],[22,3,22,7],[22,16,23,16],[23,3,23,7],[24,2,25,2],[24,3,24,7],[16,1,20,1],[16,2,19,2],[16,3,16,7],[16,16,19,16],[24,16,25,16],[25,3,25,7],[25,24,26,24],[26,3,26,7],[26,8,26,12],[28,3,28,7],[28,8,28,12],[29,2,29,7],[29,9,29,12],[30,3,30,8],[30,9,30,10],[30,11,30,12],[31,3,31,8],[31,9,31,10],[31,11,31,12],[33,3,33,6],[34,2,36,2],[34,3,36,6],[39,3,39,6],[39,7,39,11],[37,3,37,6],[37,7,37,11],[37,14,37,16],[38,3,38,6],[38,7,38,11],[38,14,38,16]]}
[null,"Baccalauréat S Dominante SI",null,"Conduite de projet ",null,null,null,null,{"$f":"'Fiche du projet'!E29","v":0},null,null,{"$f":"'Fiche du projet'!F29","v":0}]
[]
[null,"COMPÉTENCES ÉVALUÉES",null,"                                      Indicateurs de performance                        ",null,null,null,null,"Non",0,0.33333333333333331,0.66666666666666663,"3/3",null,null,"Poids de la compétence","Notes","Éval","Notes",null,null,null,null,null,"Identifications"]
[null,"B-Modéliser",null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,{"$f":"SUM(Q5:Q12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R5:R12)","v":0},{"$f":"SUM(S5:S12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(V5:V26)","v":20},{"$f":"IF(V4=20,1,0)","v":1},null,"Diplôme ","Baccalauréat Scientifique \"Sciences de l'Ingénieur\" (S-SI)"]
[null,"B3 ","Simuler le fonctionnement de tout ou partie d’un système à l’aide d’un modèle fourni","Les paramètres de simulation sont adaptés aux grandeurs à simuler",null,null,null,null,{"$f":"IF('Synthèse conduite'!I7=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U5>1,\"◄\",(IF(U5<1,\"◄\",\"\")))","v":""},null,1,{"$f":"SUM(S5:S6)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I5<>\"\",0,P5)","v":0},{"$f":"(IF(K5<>\"\",1/3,0)+IF(L5<>\"\",2/3,0)+IF(M5<>\"\",1,0))*P$4*10*R5/SUM(R$5:R$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"5-COUNTBLANK(I5:M5)","v":1},{"$f":"COUNTBLANK(N5)","v":1},null,null,"Épreuve","Projet : évaluation de la conduite du projet "]
[null,null,null,"Les plages de simulations retenues sont correctement définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!I8=\"\",\"X\",\"\")","v":"X"},null,null,null,null,{"$f":"IF(U6>1,\"◄\",(IF(U6<1,\"◄\",\"\")))","v":""},null,1,null,{"$f":"IF(I6<>\"\",0,P6)","v":0},{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I6:M6)","v":1},{"$f":"COUNTBLANK(N6)","v":1},null,null,"Coefficient ","6x0,25 ou 8x0,25 si le candidat choisit la spécialité SI (la note de projet compte pour un quart dans la note SI)"]
[null,"B4","Interpréter les résultats obtenus","Les résultats obtenus sont bien interprétés, en amplitude et variation, de façon conforme aux lois et principes d'évolution des grandeurs physiques ",null,null,null,null,{"$f":"IF('Synthèse conduite'!I10=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,{"$f":"5-COUNTBLANK(I7:M7)","v":1},1,null,null,"Établissement du candidat",{"$f":"D35","v":"Etablissement"}]
[null,null,"Préciser les limites de validité du modèle utilisé ","Les principales limites sont explicitées ",null,null,null,null,{"$f":"IF('Synthèse conduite'!I11=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S8","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Session  ",{"$f":"INDEX(parametres!A1:A9,'Fiche du projet'!M2)","v":"Session"}]
[null,null,"Modifier les paramètres du modèle pour répondre au cahier des charges ou aux résultats expérimentaux","Les paramètres modifiés sont pertinents et font évoluer  les résultats simulés vers ceux attendus au cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!I12=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S9:S10)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Nom du candidat",{"$f":"'Fiche du projet'!E29","v":0}]
[null,null,null,"Les paramètres modifiés sont pertinents et font évoluer les résultats simulés vers les résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!I13=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Prénom du candidat ",{"$f":"'Fiche du projet'!F29","v":0}]
[null,null,"Valider un modèle optimisé fourni ","Les résultats obtenus, en amplitude et variation, sont conformes aux attendus du cahier des charges",null,null,null,null,{"$f":"IF('Synthèse conduite'!I14=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S11:S12)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les résultats obtenus, en amplitude et variation, sont conformes aux résultats expérimentaux",null,null,null,null,{"$f":"IF('Synthèse conduite'!I15=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Titre du projet :",{"$f":"'Fiche du projet'!C8","v":0}]
[null,"C-Expériementer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"SUM(Q14:Q21)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R14:R21)","v":0},{"$f":"SUM(S14:S21)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Description sommaire du projet"]
[null," C1","Identifier les grandeurs physiques à mesurer "," Les grandeurs à mesurer sont bien identifiées, leur nature et caractéristiques bien définies",null,null,null,null,{"$f":"IF('Synthèse conduite'!I18=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S14","v":{"$error":"#DIV/0!"}},{"$f":"IF(I14<>\"\",0,P14)","v":0},{"$f":"(IF(K14<>\"\",1/3,0)+IF(L14<>\"\",2/3,0)+IF(M14<>\"\",1,0))*P$13*10*R14/SUM(R$14:R$21)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N14)","v":1},null,null,"Problématique :",{"$f":"'Fiche du projet'!C14","v":0}]
[null,null,"Décrire une chaîne d'acquisition","Les éléments de la chaîne d'acquisition sont correctement identifiés",null,null,null,null,{"$f":"IF('Synthèse conduite'!I19=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les choix et réglages des capteurs et appareils de mesure sont correctement explicités",null,null,null,null,{"$f":"IF('Synthèse conduite'!I20=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,"C2 ","Conduire les essais en respectant les consignes de sécurité à partir d’un protocole fourni ","Le système est correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!I22=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S17:S20)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1,null,null,"Point de départ :",{"$f":"'Fiche du projet'!H8","v":0}]
[null,null,null,"Les capteurs et les appareils de mesure sont correctement mis en œuvre",null,null,null,null,{"$f":"IF('Synthèse conduite'!I23=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Le protocole d'essai est respecté ",null,null,null,null,{"$f":"IF('Synthèse conduite'!I24=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1]
[null,null,null,"Les règles de sécurité sont connues et respectées",null,null,null,null,{"$f":"IF('Synthèse conduite'!I25=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$error":"#DIV/0!"},null,1,1,null,null,"Production attendue :",{"$f":"'Fiche du projet'!H16","v":0}]
[null,null,"Traiter les données mesurées en vue d’analyser les écarts","Les méthodes et outils de traitement sont cohérents avec le problème posé",null,null,null,null,{"$f":"IF('Synthèse conduite'!I26=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"S21","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},null,1,1]
[null,"D-Communiquer",null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,{"$f":"SUM(Q23:Q34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R23:R30)","v":0},{"$f":"SUM(S23:S26)","v":{"$error":"#DIV/0!"}}]
[null,"D1 ","Rechercher des informations","Les outils de recherche documentaire sont bien choisis et maîtrisés. ",null,null,null,null,{"$f":"IF('Synthèse conduite'!I29=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S23:S24)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K23<>\"\",1/3,0)+IF(L23<>\"\",2/3,0)+IF(M23<>\"\",1,0))*P$22*10*R23/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N23)","v":1}]
[null,null,null,"Une synthèse des informations collectées est correctement réalisée",null,null,null,null,{"$f":"IF('Synthèse conduite'!I30=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K24<>\"\",1/3,0)+IF(L24<>\"\",2/3,0)+IF(M24<>\"\",1,0))*P$22*10*R24/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N24)","v":1}]
[null,null,"Analyser, choisir et classer des informations","Les informations sont traitées selon des critères pertinents",null,null,null,null,{"$f":"IF('Synthèse conduite'!I31=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,{"$f":"SUM(S25:S26)","v":{"$error":"#DIV/0!"}},0,{"$f":"(IF(K25<>\"\",1/3,0)+IF(L25<>\"\",2/3,0)+IF(M25<>\"\",1,0))*P$22*10*R25/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N25)","v":1},null,null,"Conduite de projet","Noms et prénoms des professeurs évaluateurs","Établissement des professeurs évaluateurs"]
[null,null,null,"Les informations sont vérifiées et mises à jour",null,null,null,null,{"$f":"IF('Synthèse conduite'!I32=\"\",\"X\",\"\")","v":"X"},null,null,null,null,"",null,1,null,0,{"$f":"(IF(K26<>\"\",1/3,0)+IF(L26<>\"\",2/3,0)+IF(M26<>\"\",1,0))*P$22*10*R26/SUM(R$23:R$26)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"COUNTBLANK(N26)","v":1},null,null,null,{"$f":"C39","v":" "},{"$f":"D39","v":"Etablissement"}]
[null,null,null,"Taux d'indicateurs évalués pour B",null,null,null,null,{"$f":"R4/SUM(P5:P12)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour C",null,null,null,null,{"$f":"R13/SUM(P14:P21)","v":0}]
[null,null,null,"Taux d'indicateurs évalués pour D",null,null,null,null,{"$f":"R22/SUM(P23:P26)","v":0}]
[]
[null,null,null,"Note obtenue par calcul automatique",null,null,null,null,null,{"$f":"IF(OR(W4=0,I27<0.5,I28<0.5,I29<0.5),\"!\",(Q4+Q13+Q22))","v":"!"},null,"/10"]
[null,null,null,"Note sur 10 proposée au jury pour la conduite de projet\n (la cellule est rouge si la note n'est pas validable)  ",null,null,null,null,null,null,null,"/10"]
[]
[null,null,"Nom et prénom du candidat","Établissement du candidat"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E29,\" \",'Fiche du projet'!F29)","v":" "},{"$f":"INDEX(parametres!B1:B23,'Fiche du projet'!$M$1)","v":"Etablissement"}]
[]
[]
[null,null,"Nom et prénom des professeurs                                                         attribuant la note de conduite du projet","Établissement d'origine des examinateurs",null,null,null,"Signatures",null,null,null,null,null,null,"Date"]
[null,null,{"$f":"CONCATENATE('Fiche du projet'!E17,\" \",'Fiche du projet'!F17)","v":" "},{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-07"}]
[null,null,null,{"$f":"D35","v":"Etablissement"},null,null,null,null,null,null,null,null,null,null,null,null,"Page 2/2",null,null,null,null,null,null,null,null,null,null,null,null,"Page 1/2"]

{"sheet":"MODE EMPLOI","index":11,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,"MODE D'EMPLOI"]
[]
[null,"CE DOSSIER permet de caractériser un projet proposé par les équipes pédagogiques en classe de terminale, S-SI ou STI2D, en vue d'une validation académique."]
[null,"Pour fonctionner, il faut autoriser l'activation des macros (avec une version de MSexcel 2008 au moins)."]
[null,"Cet outil est encore au stade de développement, et sera rendu plus \"robuste\" au fil du temps et des retours d'expérience"]
[]
["1.","Remplir le premier onglet (\"Synthèse\") en indiquant les éléments donnant le cadre général du projet"]
[null,"Veiller en particulier à indiquer pour chaque élève sa section (STI2D-AC, EE, ITEC, SIN ou S-SI)"]
[null,"Le contenu des menus déroulants peut être modifié en éditant les paramètres définis dans l'onglet \"paramètres\"."]
[]
["2.","Compléter le deuxième onglet (\"CdC\") définissant le cahier du charge du projet"]
[]
["3.","Décliner le projet en tâches (onglet \"Déclinaison projet\")"]
[null,"- Pour chaque étape jalonnant le projet, lister les tâches prévisionnelles à accomplir en associant à chaque tâche une estimation du temps requis"]
[null,"Pour faciliter la lecture, vous pouvez ajuster le nombre de lignes à afficher pour chaque étape du projet suivant le besoin à l'aide du menu déroulant; chaque étape est limitée à une déclinaison en 30 tâches"]
[null,"- Répartir les tâches entre les élèves en cochant les cases de la partie droite du tableau; la charge horaire pour chaque élève se calcule automatiquement"]
[null,"- Ajuster la répartition des tâches pour viser un équilibre de la charge horaire par élève d'approximativement 70h"]
[null,"- Lorsque le projet est pluri-disciplinaire, vous pouvez préciser les tâches pour lesquelles les professeurs non-STI apporte plus scpécifiquement leur contribution."]
[]
["4.","Pour chaque élève (onglet \"Eleve A\", \"Eleve B\", …):"]
[null,"Une grille apparaît avec les compétences à évaluer dans le cadre du projet, conforme à la section d'appartenance de l'élève"]
[null,"Cliquer sur l'îcone \"Mettre à jour les tâches\"; les tâches affectées à l'élève sont automatiquement reportées"]
[null,"Indiquer pour chaque tâche les compétences qui sont mobilisées, et qui seront donc évaluABLES, en cochant les cases correspondantes; il faut noter qu'une compétence évaluable ne sera pas forcément évaluée… en revanche si une compétence n'est pas évaluable, elle ne sera forcément pas évaluée! Pour respecter le cadre défini au BO, où 50% au moins des indicateurs doivent être évalués, il faut s'assurer lors de la validation qu'un nombre supérieur d'indicateurs sont évaluables, laissant ensuite de la \"marge\" lors de l'évaluation. Pour cette raison le taux affiché reste rouge entre 0 et 50%, passe à l'orange entre 50 et 75%, et passe au vert au delà de 75%."]
[null,"Le pourcentage d'indicateurs associés aux compétences évaluables est calculé automatiquement; deux valeurs sont calculeées :"]
[]
[null,"% d'indicateurs évaluables en cours d'année par rapport au total des indicateurs à évaluer en revues de projet, qui compteront pour la moitié de l'évaluation totale"]
[null,"en STI2D, le BO précise que 50% au moins des indicateurs de la grille de revues de projet devront être évaluES"]
[]
[null,"% d'indicateurs évaluables lors de la soutenance finale par rapport total des indicateurs à évaluer lors de la soutenance finale, qui compteront pour l'autre moitié de l'évaluation totale"]
[null,"en STI2D, le BO précise que 50% au moins des indicateurs de la grille de soutenance finale devront être évaluES"]
[]
[null,"% d'indicateurs globalement évaluables"]
[null,"en SSI, le BO précise que 50% au moins des indicateurs de la grille unique d'évaluation devront êtres évaluES"]
[]
["5.","Vérifier sur l'onglet \"Synthèse\" que les voyants sont au vert, ou éventuellement à l'orange."]
[]
[]
[null,"REMARQUES IMPORTANTES:"]
[null,"L'onglet \"Synthèse\" permet de s'assurer de la validité du projet"]
[null,"La spécification du projet, une fois définie, est figée (onglet CdC) pour toute la durée du projet."]
[null,"Par contre, les grilles de déclinaison du projet et validation de tâches par élèves sont renseignées initialement de façon prévisionnelles, et peuvent évoluer en cours de réalisation du projet, pour laisser la place à la dimension créative de la démarche de projet. Les équipes devront s'assurer que ces évolutions laissent toutefois les indicateurs au vert."]

{"sheet":"parametres","index":12,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Session","Etablissement","NOUVEAU PROJET",3,"Ref","Section","Eleves","choix","Production(s) attendue(s)","Nb tâches","Question"]
["Session 2018","Lycée Jules Verne","Lycée Jules Verne",4,2,"S-SI","Elève A",2,"Justifications scientifiques, technologiques, socio-économiques",1,"OUI"]
["Session 2019","Lycée Jean Macé","Lycée Jean Macé",5,3,null,"Elève B",2,"Architectures de solutions",2,"NON"]
["Session 2020","Lycée  Joliot-Curie","Lycée  Joliot-Curie",null,4,null,"Elève C",2,"Documents de formalisation de la solution imaginée ",3]
["Session 2021","Lycée Pierre MECHAIN","Lycée Pierre MECHAIN",null,5,null,"Elève D",2,"Supports de communication ",4]
["Session 2022","Lycée Condorcet (St Quentin)","Lycée Condorcet (St Quentin)",null,6,null,"Elève E",2,"Prototype ou une maquette numérique ou matérielle",5]
["Session 2023","Lycée Léonard de Vinci","Lycée Léonard de Vinci",null,null,null,null,null,null,6]
["Session 2024","Lycée Paul-Langevin","Lycée Paul-Langevin",null,null,null,null,null,null,7]
["Session 2025","Lycée Mireille GRENET","Lycée Mireille GRENET",null,null,null,null,null,null,8]
[null,"Lycée jules Uhry","Lycée jules Uhry",null,null,null,null,null,null,9]
[null,"Lycée Jean Monnet","Lycée Jean Monnet",null,null,null,null,null,null,10]
[null,"Lycée Condorcet (Méru)","Lycée Condorcet (Méru)",null,null,null,null,null,null,11]
[null,"Lycée Marie Curie","Lycée Marie Curie",null,null,null,null,null,null,12]
[null,"Lycée Jean Calvin","Lycée Jean Calvin",null,null,null,null,null,null,13]
[null,"Lycée Boucher De Perthes","Lycée Boucher De Perthes",null,null,null,null,null,null,14]
[null,"Lycée Lamarck","Lycée Lamarck",null,null,null,null,null,null,15]
[null,"Lycée Edouard Branly","Lycée Edouard Branly",null,null,null,null,null,null,16]
[null,"Lycée La Providence","Lycée La Providence",null,null,null,null,null,null,17]
[null,"Lycée Saint Riquier","Lycée Saint Riquier",null,null,null,null,null,null,18]
[null,"Lycée de l'Authie","Lycée de l'Authie",null,null,null,null,null,null,19]
[null,"Lycée Du Vimeu","Lycée Du Vimeu",null,null,null,null,null,null,20]
[null,"Lycée Jean Racine","Lycée Jean Racine",null,null,null,null,null,null,21]
[null,"Lycée Pierre Mendés France","Lycée Pierre Mendés France",null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"…"]
[null,"…"]
[null,"…"]
[null,"…"]