{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Saisie","Guide","Modèle"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Saisie","index":0,"n_rows":107,"n_cols":16,"rows_kept":107,"cut":false,"hidden":false,"merged":[[3,15,3,19],[3,12,5,12],[4,4,4,5],[5,4,5,5],[4,6,4,7],[5,6,5,7],[4,8,4,9],[5,8,5,9],[2,1,2,2],[3,13,6,13],[0,2,0,7],[3,10,6,10],[0,8,1,13],[2,3,2,9],[103,6,106,6],[103,8,106,8],[103,0,106,0],[103,1,106,1],[103,2,106,2],[103,3,106,3],[103,4,106,4],[95,6,98,6],[95,8,98,8],[99,0,102,0],[99,1,102,1],[99,2,102,2],[99,3,102,3],[99,4,102,4],[99,6,102,6],[99,8,102,8],[95,0,98,0],[95,1,98,1],[95,2,98,2],[95,3,98,3],[95,4,98,4],[87,6,90,6],[87,8,90,8],[91,0,94,0],[91,1,94,1],[91,2,94,2],[91,3,94,3],[91,4,94,4],[91,6,94,6],[91,8,94,8],[87,0,90,0],[87,1,90,1],[87,2,90,2],[87,3,90,3],[87,4,90,4],[79,6,82,6],[79,8,82,8],[83,0,86,0],[83,1,86,1],[83,2,86,2],[83,3,86,3],[83,4,86,4],[83,6,86,6],[83,8,86,8],[79,0,82,0],[79,1,82,1],[79,2,82,2],[79,3,82,3],[79,4,82,4],[71,6,74,6],[71,8,74,8],[75,0,78,0],[75,1,78,1],[75,2,78,2],[75,3,78,3],[75,4,78,4],[75,6,78,6],[75,8,78,8],[71,0,74,0],[71,1,74,1],[71,2,74,2],[71,3,74,3],[71,4,74,4],[63,6,66,6],[63,8,66,8],[67,0,70,0],[67,1,70,1],[67,2,70,2],[67,3,70,3],[67,4,70,4],[67,6,70,6],[67,8,70,8],[63,0,66,0],[63,1,66,1],[63,2,66,2],[63,3,66,3],[63,4,66,4],[55,6,58,6],[55,8,58,8],[59,0,62,0],[59,1,62,1],[59,2,62,2],[59,3,62,3],[59,4,62,4],[59,6,62,6],[59,8,62,8],[55,0,58,0],[55,1,58,1],[55,2,58,2],[55,3,58,3],[55,4,58,4],[47,6,50,6],[47,8,50,8],[51,0,54,0],[51,1,54,1],[51,2,54,2],[51,3,54,3],[51,4,54,4],[51,6,54,6],[51,8,54,8],[47,0,50,0],[47,1,50,1],[47,2,50,2],[47,3,50,3],[47,4,50,4],[27,1,30,1],[23,3,26,3],[19,0,22,0],[23,0,26,0],[23,1,26,1],[27,0,30,0],[39,6,42,6],[39,8,42,8],[43,0,46,0],[43,1,46,1],[43,2,46,2],[43,3,46,3],[43,4,46,4],[43,6,46,6],[43,8,46,8],[39,0,42,0],[39,1,42,1],[39,2,42,2],[39,3,42,3],[39,4,42,4],[31,6,34,6],[31,8,34,8],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[35,6,38,6],[35,8,38,8],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[11,8,14,8],[6,4,6,5],[6,6,6,7],[6,8,6,9],[15,8,18,8],[27,2,30,2],[15,2,18,2],[27,4,30,4],[27,6,30,6],[27,8,30,8],[15,3,18,3],[15,4,18,4],[19,2,22,2],[23,2,26,2],[23,4,26,4],[27,3,30,3],[15,6,18,6],[11,6,14,6],[23,6,26,6],[23,8,26,8],[19,6,22,6],[19,8,22,8],[11,0,14,0],[11,1,14,1],[11,4,14,4],[19,1,22,1],[19,4,22,4],[19,3,22,3],[11,3,14,3],[15,0,18,0],[15,1,18,1],[11,2,14,2],[7,1,10,1],[7,0,10,0],[3,4,3,5],[3,6,3,7],[3,8,3,9],[7,4,10,4],[7,6,10,6],[7,8,10,8],[7,3,10,3],[7,2,10,2]]}
[null,null,"Suivi PFMP et Epreuves professionnelles (EP) en CCF \nBac Pro ASSP Option A \"à domicile\""]
[null,null,null,"Session"]
[null,"6 semaines de PFMP\nen seconde",null,"16 semaines de PFMP dont au moins 8 semaines en terminale et \ndont 10 au moins dans le secteur de l'aide ou du maintien à domicile",null,null,null,null,null,null,null,null,null,null,null,"Nom du chef d'établissement"]
["Période","PFMP 1","PFMP 2","PFMP 3","PFMP 4",null,"PFMP 5",null,"PFMP 6",null,"E32\n en CF",null,"BILAN\nPFMP","BILAN \nEP CCF BAC "]
["Date début"]
["Date fin"]
["Durée\n(en semaines)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B7:J7)","v":0}]
["Elève 1",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 2",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 3",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 4",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 5",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 6",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 7",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 8",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 9",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 10",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 11",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 12",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 13",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 14",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 15",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 16",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 17",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 18",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 19",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 20",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 21",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 22",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 23",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 24",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]
["Elève 25",null,null,null,null,"E 13",null,"E 13",null,"E 13","E 13",null,0,"E 13"]
[null,null,null,null,null,"E 31",null,"E 31",null,"E 31","E 31",null,0,"E 31"]
[null,null,null,null,null,"E 32",null,"E 32",null,"E 32","E 32",null,0,"E 32"]
[null,null,null,null,null,"E 33",null,"E 33",null,"E 33","E 33",null,0,"E 33"]

{"sheet":"Guide","index":1,"n_rows":68,"n_cols":4,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,2,8],[54,2,55,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[42,2,42,8]]}
["Guide pour les utilisateurs"]
[]
["La feuille \"Saisie\" est protégée.\nVous ne pouvez modifier que les cellules où une saisie est prévue."]
[]
["Plusieurs types de saisie sont à effectuer :"]
[null,"1. Globalement, à la première utilisation"]
[null,null,"La session (année d'examen)"]
[null,null,"Le nom et l'adresse (la ville seulement ?) de l'établissement scolaire (Alt+Entrée pour passer à la ligne à l'intérieur de la cellule)."]
[null,null,"Le nom du chef d'établissement (pour être reporté automatiquement sur les fiches élèves)"]
[null,null,"La durée (en semaines) de chaque PFMP (total automatique en colonne bilan)"]
[null,null,"Les dates de début et fin de chaque PFMP (format jj/mm/aaaa)"]
[null,null,"Les noms et prénoms des élèves"]
[null,"2. Pour chaque élève"]
[null,null,"Le lieu de PFMP"]
[null,null,"Le secteur"]
[null,null,"Les CCF réalisés"]
[]
["Pour chaque élève, 3 saisies différentes :"]
[null,"1. Le lieu de la PFMP"]
[null,null,"Clic gauche dans la cellule de la PFMP pour saisir ses coordonnées (Alt+Entrée pour passer à la ligne à l'intérieur de la cellule)."]
[null,"2. Le secteur"]
[null,null,"Clic droit dans la cellule de la PFMP effectuée pour faire apparaître la couleur correspondant au secteur concerné. "]
[null,"                          ","Cliquer jusqu'à obtenir la couleur correspondant au code ci-dessous"]
[]
["       ",null,null,"PFMP non déterminée"]
[null,null,null,"Secteur \"Structure\""]
[null,null,null,"Secteur \"Domicile\""]
[]
[null,"3. Les CCF réalisés"]
[null,null,"Clic droit dans la cellule pour identifier les CCF réalisés. Cliquer jusqu'à obtenir la couleur \ncorrespondant au code ci-dessous."]
[null,null,"Attention : un CCF ne peut être réalisé que si les conditions préalables sont remplies."]
[]
[null,null,null,"CCF non réalisé"]
[null,null,null,"CCF envisagé"]
[null,null,null,"CCF réalisé"]
[null,null,null,"CCF non réalisable"]
[]
["Les 4 épreuves en CCF :"]
[]
[null,"E 13","Conduite d'un projet d'accompagnement\nOral en CF à partir d'un dossier réalisé en PFMP domicile de 4 semaines"]
[null,"E 31","Accompagnement des actes de la vie quotidienne à domicile\nBilan PFMP de 4 semaines à domicile"]
[null,"E 32","Organisation d'intervention à domicile\nOral en CF à partir d'une situation du secteur de l'aide à domicile"]
[null,"E 33","Aménagement et équipement de l'espace privé\nOral en CF à partir d'un dossier réalisé sur PFMP à domicile"]
[]
["La colonne BILAN PFMP (pour chaque élève)"]
[null,"Cette colonne se met à jour automatiquement."]
[null,null,"Nombre de semaines de PFMP effectuées. \nLa cellule devient verte quand la durée réglementaire de 22 semaines est atteinte."]
[null,null,"Nombre de semaines effectuées en PFMP secteur \"Structure\"."]
[null,null,"Nombre de semaines effectuées en PFMP secteur \"Domicile\"."]
[null,null,"Nombre de semaines effectuées en PFMP secteur \"Domicile\" en 1ère et Terminale."]
[null,null,"La cellule devient verte quand la durée réglementaire de 10 semaines à domicile est atteinte."]
[]
["La colonne BILAN EP CCF"]
[null,"Cette colonne se met à jour automatiquement."]
[null,null,"La cellule devient verte si le CCF a été réalisé."]
[]
[]
["Création des fiches élèves"]
[null,"Clic droit sur le bouton prévu à cet effet (coté droit de la feuille \"Saisie\")"]
[null,"Cette opération va créer 25 feuilles (une par élève) nommées El_1 à El_25 par recopie de la feuille \"Modèle\"."]
[null,"Chaque feuille contient les données d'un élève (nom, PFMPs, épreuves CCF…)."]
[null,"Cette opération est à faire seulement en fin d'année d'examen mais on peut s'entraîner avant…"]
[]
["Effacement des fiches élèves"]
[null,"Clic droit sur le bouton prévu à cet effet (coté droit de la feuille \"Saisie\")"]
[null,"Cette opération va détruire les 25 feuilles nommées El_1 à El_25 (et seulement celles-là)"]
[null,"Cette opération est à faire obligatoirement avant de créer de nouvelles fiches élèves."]
[null,"(sinon Excel refuse de créer les fiches car il y a conflit de nom de feuilles, ex : 2 fois El_1)"]

{"sheet":"Modèle","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,4,7,5],[0,1,0,4],[0,5,1,5],[3,0,3,1],[3,2,3,4],[6,4,6,5],[18,0,18,2],[16,0,16,3],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5]]}
[null,"        Suivi PFMP et Epreuves professionnelles (EP) en CCF \nBac Pro ASSP Option A \"à domicile\"",null,null,null,{"$f":"Saisie!I1","v":0}]
[null,null,"Session",{"$f":"Saisie!E2","v":0}]
[]
["Nom de l'élève : ",null,"A8"]
[]
[]
["PFMP","Date\ndébut","Date\nfin","Durée\n(en semaines)","Structure"]
["PFMP1","B5","B6","B7","B8"]
["PFMP2","C5","C6","C7","C8"]
["PFMP3","D5","D6","D7","D8"]
["PFMP4","E5","E6","E7","E8"]
["PFMP5","G5","G6","G7","G8"]
["PFMP6","I5","I6","I7","I8"]
[]
["Nombre total de semaines de PFMP :",null,null,null,"M8"]
[]
["Nombres de semaines réalisées dans le secteur de l'aide ou du maintien à domicile :",null,null,null,"M11"]
[]
["Epreuves en CCF réalisées :"]
[null,"E13","N8"]
[null,"E31","N9"]
[null,"E32","N10"]
[null,"E33","N11"]
[]
[]
[{"$f":"\"Je, soussigné, \"&Saisie!P4&\", chef d’établissement, certifie que l’élève a\"","v":"Je, soussigné, , chef d’établissement, certifie que l’élève a"}]
["effectué les 22 semaines de périodes de formation en milieu professionnel obligatoires :16"]
["réparties en classes de première et terminale dont 8 minimum en classe de terminale."]
[]
["Date",null,null,"Signature et cachet du centre de formation"]