{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Accueil","S1","S1 - Notes","S2","S2 - Notes","S3","S3 - Notes","S4","S4 - Notes","S5","S5 - Notes","S6","S6 - Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,5,17,5],[14,2,15,2],[5,9,5,11],[10,9,15,11],[4,2,4,11],[12,2,13,2],[12,5,13,5],[14,5,15,5],[2,2,2,11],[6,2,7,2],[6,5,7,5],[8,2,9,2],[10,2,11,2],[5,3,5,5],[10,5,11,5],[3,15,19,15],[21,2,21,11],[19,2,19,11],[20,2,20,11],[16,2,17,2],[8,5,9,5],[16,8,17,8],[6,11,7,11],[8,11,9,11],[16,11,17,11],[5,6,5,8],[10,8,11,8],[12,8,13,8],[14,8,15,8],[6,8,7,8],[8,8,9,8]]}
[]
[]
[null,null,"Calcul des Résultats",null,null,null,null,null,null,null,null,null,null,null,null,"Fonctionnement du fichier - Version 2.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ce fichier vous permet de calculer automatiquement vos résultats. Il ne faut modifier que les noms, notes, coefficients et bonus dans les feuilles correspondantes au semestre souhaité (SX - Notes).\nSi vous ne connaissez pas les coefficients, vous pouvez les mettre à 1.\nSi vous souhaitez directement indiquer vos moyennes pour chaque ressource, remplissez une seule note pour chacune d'elles avec un coefficient de 1.\n\nAfin de préserver votre saisie tout en utilisant la dernière version de ce tableau, vous pouvez facilement extraire vos données de ce tableau puis les importer dans la nouvelle version. L'export génère un fichier CSV à l'endroit où est enregistré ce fichier. L'import se fait à partir d'un fichier CSV nommé \"donnees.csv\" placé au même endroit que ce tableau.\n\nL'export/import nécessite l'autorisation de l'exécution des macros. Pour activer cela, vous devez modifier les propriétés du fichier (clic droit → Propriétés) et cocher la case \"Débloquer\" (en bas de la fenêtre dans l'onglet \"Général\") puis cliquez sur \"Appliquer\". Ouvrez ensuite le fichier et cliquer sur \"Autoriser les macros\" dans le message qui apparait."]
[null,null,"Récapitulatif"]
[null,null,null,"BUT1",null,null,"BUT2",null,null,"BUT3"]
[null,null,"Compétence 1 - Réaliser","U1.1",{"$f":"'S1'!J11","v":0},{"$f":"AVERAGE(E7:E8)","v":0},"U3.1",{"$f":"'S3'!J13","v":0},{"$f":"AVERAGE(H7:H8)","v":0},"U5.1",{"$f":"'S5'!J22","v":0},{"$f":"AVERAGE(K7:K8)","v":0}]
[null,null,null,"U2.1",{"$f":"'S2'!J13","v":0},null,"U4.1",{"$f":"'S4'!J14","v":0},null,"U6.1",{"$f":"'S6'!J16","v":0}]
[null,null,"Compétence 2 - Optimiser","U1.2",{"$f":"'S1'!J21","v":0},{"$f":"AVERAGE(E9:E10)","v":0},"U3.2",{"$f":"'S3'!J27","v":0},{"$f":"AVERAGE(H9:H10)","v":0},"U5.2",{"$f":"'S5'!N22","v":0},{"$f":"AVERAGE(K9:K10)","v":0}]
[null,null,null,"U2.2",{"$f":"'S2'!J24","v":0},null,"U4.2",{"$f":"'S4'!J27","v":0},null,"U6.2",{"$f":"'S6'!N16","v":0}]
[null,null,"Compétence 3 - Administrer","U1.3",{"$f":"'S1'!J31","v":0},{"$f":"AVERAGE(E11:E12)","v":0},"U3.3",{"$f":"'S3'!N14","v":0},{"$f":"AVERAGE(H11:H12)","v":0}]
[null,null,null,"U2.3",{"$f":"'S2'!J36","v":0},null,"U4.3",{"$f":"'S4'!N13","v":0}]
[null,null,"Compétence 4 - Gérer","U1.4",{"$f":"'S1'!N11","v":0},{"$f":"AVERAGE(E13:E14)","v":0},"U3.4",{"$f":"'S3'!N26","v":0},{"$f":"AVERAGE(H13:H14)","v":0}]
[null,null,null,"U2.4",{"$f":"'S2'!N13","v":0},null,"U4.4",{"$f":"'S4'!N26","v":0}]
[null,null,"Compétence 5 - Conduire","U1.5",{"$f":"'S1'!N20","v":0},{"$f":"AVERAGE(E15:E16)","v":0},"U3.5",{"$f":"'S3'!R15","v":0},{"$f":"AVERAGE(H15:H16)","v":0}]
[null,null,null,"U2.5",{"$f":"'S2'!N25","v":0},null,"U4.5",{"$f":"'S4'!R14","v":0}]
[null,null,"Compétence 6 - Collaborer","U1.6",{"$f":"'S1'!N31","v":0},{"$f":"AVERAGE(E17:E18)","v":0},"U3.6",{"$f":"'S3'!R26","v":0},{"$f":"AVERAGE(H17:H18)","v":0},"U5.6",{"$f":"'S5'!R21","v":0},{"$f":"AVERAGE(K17:K18)","v":0}]
[null,null,null,"U2.6",{"$f":"'S2'!N36","v":0},null,"U4.6",{"$f":"'S4'!R26","v":0},null,"U6.6",{"$f":"'S6'!R17","v":0}]
[]
[null,null,"Pour rappel, il faut valider (moyenne ≥ 8) un minimum de 4 compétences pour valider la 1re année. De plus, il ne faut avoir aucune compétence en-dessous de 8."]
[null,null,"Pour valider la 2e année, c'est le même principe, mais il faut, en plus, impérativement valider les compétences qui ne sont plus présentes en 3e année, à savoir les compétences 3, 4 et 5."]
[null,null,"Pour obtenir le BUT, il faut avoir valider l'ensemble des compétence à l'issue de la 3e année."]

{"sheet":"S1","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,13],[2,2,2,13],[4,11,4,13],[21,11,21,13],[13,11,13,13],[4,2,4,5],[18,2,18,3],[21,2,21,5],[30,2,30,3],[13,7,13,9],[23,7,23,9],[4,7,4,9],[29,4,29,5]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 1"]
[]
[null,null,"RESSOURCES",null,null,null,null,"UE1.1",null,null,null,"UE1.4"]
[null,null,"Code","Nom","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R1.01","Initiation au Développement",{"$f":"I7+I16","v":66},{"$f":"'S1 - Notes'!D10","v":""},null,"R1.01",42,{"$f":"F7","v":""},null,"R1.05",36,{"$f":"F11","v":""}]
[null,null,"R1.02","Développement d'Interfaces Web",{"$f":"I8+M16+M24","v":35},{"$f":"'S1 - Notes'!$D17","v":""},null,"R1.02",12,{"$f":"F8","v":""},null,"R1.06",18,{"$f":"F12","v":""}]
[null,null,"R1.03","Introduction à l'Architecture des Ordinateurs",{"$f":"I17+I26","v":27},{"$f":"'S1 - Notes'!$D24","v":""},null,"R1.10",6,{"$f":"F16","v":""},null,"R1.09",6,{"$f":"F15","v":""}]
[null,null,"R1.04","Introduction aux Systèmes d'Exploitation et à leur Fonctionnement",{"$f":"I27","v":21},{"$f":"'S1 - Notes'!$D31","v":""},null,"S1.01",40,{"$f":"F24","v":""},null,"S1.04",40,{"$f":"F27","v":""}]
[null,null,"R1.05","Introduction aux Bases de Données et SQL",{"$f":"M7","v":36},{"$f":"'S1 - Notes'!$D38","v":""},null,"Total et moyenne",{"$f":"SUM(I7:I10)","v":100},{"$f":"SUMPRODUCT(J7:J10,I7:I10)/I11","v":0},null,"Total et moyenne",{"$f":"SUM(M7:M10)","v":100},{"$f":"SUMPRODUCT(N7:N10,M7:M10)/M11","v":0}]
[null,null,"R1.06","Mathématiques Discrètes",{"$f":"I18+M8","v":33},{"$f":"'S1 - Notes'!$D45","v":""}]
[null,null,"R1.07","Outils Mathématiques Fondamentaux",{"$f":"I19","v":15},{"$f":"'S1 - Notes'!$D52","v":""}]
[null,null,"R1.08","Introduction à la Gestion des Organisations",{"$f":"M17+M25","v":38},{"$f":"'S1 - Notes'!$D59","v":""},null,"UE1.2",null,null,null,"UE1.5"]
[null,null,"R1.09","Introduction à l'Économie Durable et Numérique",{"$f":"M9+M26","v":17},{"$f":"'S1 - Notes'!$D66","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R1.10","Anglais",{"$f":"I9+I28+M27","v":29},{"$f":"'S1 - Notes'!$D73","v":""},null,"R1.01",24,{"$f":"F7","v":""},null,"R1.02",18,{"$f":"F8","v":""}]
[null,null,"R1.11","Bases de la Communication",{"$f":"I29+M18+M28","v":32},{"$f":"'S1 - Notes'!$D80","v":""},null,"R1.03",6,{"$f":"F9","v":""},null,"R1.08",27,{"$f":"F14","v":""}]
[null,null,"R1.12","Projet Professionnel et Personnel",{"$f":"M29","v":11},{"$f":"'S1 - Notes'!$D87","v":""},null,"R1.06",15,{"$f":"F12","v":""},null,"R1.11",15,{"$f":"F17","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E18)","v":360},{"$f":"SUMPRODUCT(F7:F18,E7:E18)/E19","v":0},null,"R1.07",15,{"$f":"F13","v":""},null,"S1.05",40,{"$f":"F28","v":""}]
[null,null,null,null,null,null,null,"S1.02",40,{"$f":"F25","v":""},null,"Total et moyenne",{"$f":"SUM(M16:M19)","v":100},{"$f":"SUMPRODUCT(N16:N19,M16:M19)/M20","v":0}]
[null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(I16:I20)","v":100},{"$f":"SUMPRODUCT(J16:J20,I16:I20)/I21","v":0}]
[null,null,"SAÉ",null,null,null,null,null,null,null,null,"UE1.6"]
[null,null,"Code","Nom","Coef.","Note",null,null,null,null,null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"S1.01","Implémentation d'un Besoin Client",{"$f":"I10","v":40},{"$f":"'S1 - Notes'!$D94","v":""},null,"UE1.3",null,null,null,"R1.02",5,{"$f":"F8","v":""}]
[null,null,"S1.02","Comparaison d'Approches Algorithmiques",{"$f":"I20","v":40},{"$f":"'S1 - Notes'!$D101","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"R1.08",11,{"$f":"F14","v":""}]
[null,null,"S1.03","Installation d'un Poste pour le Développement",{"$f":"I30","v":40},{"$f":"'S1 - Notes'!$D108","v":""},null,"R1.03",21,{"$f":"F9","v":""},null,"R1.09",11,{"$f":"F15","v":""}]
[null,null,"S1.04","Création d'une Base de Données",{"$f":"M19","v":40},{"$f":"'S1 - Notes'!$D115","v":""},null,"R1.04",21,{"$f":"F10","v":""},null,"R1.10",11,{"$f":"F16","v":""}]
[null,null,"S1.05","Recueil de Besoins",{"$f":"M10","v":40},{"$f":"'S1 - Notes'!$D122","v":""},null,"R1.10",12,{"$f":"F16","v":""},null,"R1.11",11,{"$f":"F17","v":""}]
[null,null,"S1.06","Découverte de l'Environnement Économique et Écologique",{"$f":"M30","v":40},{"$f":"'S1 - Notes'!$D129","v":""},null,"R1.11",6,{"$f":"F17","v":""},null,"R1.12",11,{"$f":"F18","v":""}]
[null,null,"P1.01","Démarche Portfolio","non évalué",null,null,"S1.03",40,{"$f":"F26","v":""},null,"S1.06",40,{"$f":"F29","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E24:E29)","v":240},{"$f":"SUMPRODUCT(F24:F29,E24:E29)/E31","v":0},null,"Total et moyenne",{"$f":"SUM(I26:I30)","v":100},{"$f":"SUMPRODUCT(J26:J30,I26:I30)/I31","v":0},null,"Total et moyenne",{"$f":"SUM(M24:M30)","v":100},{"$f":"SUMPRODUCT(N24:N30,M24:M30)/M31","v":0}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S1 - Notes","index":2,"n_rows":129,"n_cols":4,"rows_kept":129,"cut":false,"hidden":false,"merged":[[100,3,100,18],[102,2,102,18],[106,3,106,18],[107,3,107,18],[109,2,109,18],[99,3,99,18],[72,3,72,18],[74,2,74,18],[78,3,78,18],[79,3,79,18],[81,2,81,18],[85,3,85,18],[95,2,95,18],[93,3,93,18],[92,3,92,18],[86,3,86,18],[88,2,88,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[71,3,71,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[57,3,57,18],[58,3,58,18],[60,2,60,18],[64,3,64,18],[65,3,65,18],[67,2,67,18],[113,3,113,18],[114,3,114,18],[15,3,15,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18],[43,3,43,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[29,3,29,18],[30,3,30,18],[128,3,128,18],[116,2,116,18],[120,3,120,18],[121,3,121,18],[123,2,123,18],[127,3,127,18]]}
[]
[]
[null,null,"Notes du semestre 1"]
[]
[null,null,"R1.01 - Initiation au Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R1.02 - Dévoleppement d'Interfaces Web"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R1.03 - Introduction à l'Architecture des Ordinateurs"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R1.04 - Introduction aux Systèmes d'Exploitation et à leur Fonctionnement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R1.05 - Introduction aux Bases de Données et SQL"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R1.06 - Mathématiques Discrètes"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"R1.07 - Outils Matématiques Fondamentaux"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"R1.08 - Introduction à la Gestion des Organisations"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"R1.09 - Introduction à l'ÉcoNomsie Durable et Numérique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D63:S63,D64:S64)/SUM(D64:S64)+D65),20),\"\")","v":""}]
[]
[null,null,"R1.10 - Anglais"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D70:S70,D71:S71)/SUM(D71:S71)+D72),20),\"\")","v":""}]
[]
[null,null,"R1.11 - Bases de la Communication"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D77:S77,D78:S78)/SUM(D78:S78)+D79),20),\"\")","v":""}]
[]
[null,null,"R1.12 - Projet Professionnel et Personnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D84:S84,D85:S85)/SUM(D85:S85)+D86),20),\"\")","v":""}]
[]
[null,null,"S1.01 - Implémentation d'un Besoin Client\t\t\t\t\t\t\t"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D91:S91,D92:S92)/SUM(D92:S92)+D93),20),\"\")","v":""}]
[]
[null,null,"S1.02 - Comparaison d’approches algorithmiques"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D98:S98,D99:S99)/SUM(D99:S99)+D100),20),\"\")","v":""}]
[]
[null,null,"S1.03 - Installation d'un Poste pour le Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D105:S105,D106:S106)/SUM(D106:S106)+D107),20),\"\")","v":""}]
[]
[null,null,"S1.04 - Création d'une base de données"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D112:S112,D113:S113)/SUM(D113:S113)+D114),20),\"\")","v":""}]
[]
[null,null,"S1.05 - Recueil de Besoins"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D119:S119,D120:S120)/SUM(D120:S120)+D121),20),\"\")","v":""}]
[]
[null,null,"S1.06 - Découverte de l'Environnement ÉcoNomsique et Écologique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D126:S126,D127:S127)/SUM(D127:S127)+D128),20),\"\")","v":""}]

{"sheet":"S2","index":3,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,2,2,13],[4,2,4,5],[4,7,4,9],[4,11,4,13],[14,11,14,13],[26,11,26,13],[35,2,35,3],[15,7,15,9],[37,2,37,13],[27,7,27,9],[20,2,20,3],[26,2,26,5]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 2"]
[]
[null,null,"RESSOURCES",null,null,null,null,"UE2.1",null,null,null,"UE2.4"]
[null,null,"Code","Nom","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R2.01","Développement Orienté Objet",{"$f":"I7+I18","v":36},{"$f":"'S2 - Notes'!D10","v":""},null,"R2.01",21,{"$f":"F7","v":""},null,"R2.06",30,{"$f":"F12","v":""}]
[null,null,"R2.02","Développement d'Applications avec IHM",{"$f":"I8+M17+M29","v":28},{"$f":"'S2 - Notes'!$D17","v":""},null,"R2.02",21,{"$f":"F8","v":""},null,"R2.08",12,{"$f":"F14","v":""}]
[null,null,"R2.03","Qualité de Développement",{"$f":"I9+M18","v":18},{"$f":"'S2 - Notes'!$D24","v":""},null,"R2.03",12,{"$f":"F9","v":""},null,"R2.10",12,{"$f":"F16","v":""}]
[null,null,"R2.04","Communication et Fonctionnement Bas Niveau",{"$f":"I19+I30","v":48},{"$f":"'S2 - Notes'!$D31","v":""},null,"R2.13",6,{"$f":"F19","v":""},null,"R2.12",6,{"$f":"F18","v":""}]
[null,null,"R2.05","Introduction aux Services Réseaux",{"$f":"I31","v":15},{"$f":"'S2 - Notes'!$D38","v":""},null,"S2.01",38,{"$f":"F29","v":""},null,"S2.04",38,{"$f":"F32","v":""}]
[null,null,"R2.06","Exploitation d'une Base de Données",{"$f":"M7","v":30},{"$f":"'S2 - Notes'!$D45","v":""},null,"P2.01",2,{"$f":"F35","v":""},null,"P2.01",2,{"$f":"F35","v":""}]
[null,null,"R2.07","Graphes",{"$f":"I20+M19","v":27},{"$f":"'S2 - Notes'!$D52","v":""},null,"Total et moyenne",{"$f":"SUM(I7:I12)","v":100},{"$f":"SUMPRODUCT(J7:J12,I7:I12)/I13","v":0},null,"Total et moyenne",{"$f":"SUM(M7:M12)","v":100},{"$f":"SUMPRODUCT(N7:N12,M7:M12)/M13","v":0}]
[null,null,"R2.08","Outils Numériques pour les Statistiques Descriptives",{"$f":"M8","v":12},{"$f":"'S2 - Notes'!$D59","v":""}]
[null,null,"R2.09","Méthodes Numériques",{"$f":"I21","v":12},{"$f":"'S2 - Notes'!$D66","v":""},null,null,null,null,null,"UE2.5"]
[null,null,"R2.10","Introduction à la Gestion des Système d'Information",{"$f":"M9+M20","v":42},{"$f":"'S2 - Notes'!$D73","v":""},null,"UE2.2",null,null,null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R2.11","Introduction au Droit",{"$f":"M30","v":17},{"$f":"'S2 - Notes'!$D80","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"R2.02",3,{"$f":"F8","v":""}]
[null,null,"R2.12","Anglais",{"$f":"I32+M10+M21+M31","v":35},{"$f":"'S2 - Notes'!$D87","v":""},null,"R2.01",15,{"$f":"F7","v":""},null,"R2.03",6,{"$f":"F9","v":""}]
[null,null,"R2.13","Communication Technique",{"$f":"I10+I33+M22+M32","v":29},{"$f":"'S2 - Notes'!$D94","v":""},null,"R2.04",12,{"$f":"F10","v":""},null,"R2.07",6,{"$f":"F13","v":""}]
[null,null,"R2.14","Projet Professionnel et Personnel",{"$f":"M33","v":11},{"$f":"'S2 - Notes'!$D101","v":""},null,"R2.07",21,{"$f":"F13","v":""},null,"R2.10",30,{"$f":"F16","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E20)","v":360},{"$f":"SUMPRODUCT(F7:F20,E7:E20)/E21","v":0},null,"R2.09",12,{"$f":"F15","v":""},null,"R2.12",6,{"$f":"F18","v":""}]
[null,null,null,null,null,null,null,"S2.02",38,{"$f":"F30","v":""},null,"R2.13",9,{"$f":"F19","v":""}]
[null,null,null,null,null,null,null,"P2.01",2,{"$f":"F35","v":""},null,"S2.05",38,{"$f":"F33","v":""}]
[null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(I18:I23)","v":100},{"$f":"SUMPRODUCT(J18:J23,I18:I23)/I24","v":0},null,"P2.01",2,{"$f":"F35","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(M17:M24)","v":100},{"$f":"SUMPRODUCT(N17:N24,M17:M24)/M25","v":0}]
[]
[null,null,"SAÉ",null,null,null,null,null,null,null,null,"UE2.6"]
[null,null,"Code","Nom","Coef.","Note",null,"UE2.3",null,null,null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"S2.01","Développement d'une Application",{"$f":"I11","v":38},{"$f":"'S2 - Notes'!$D108","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"R2.02",4,{"$f":"F8","v":""}]
[null,null,"S2.02","Exploration Algorithmique d'un Problème",{"$f":"I22","v":38},{"$f":"'S2 - Notes'!$D115","v":""},null,"R2.04",36,{"$f":"F10","v":""},null,"R2.11",17,{"$f":"F17","v":""}]
[null,null,"S2.03","Installation de Services Réseaux",{"$f":"I34","v":38},{"$f":"'S2 - Notes'!$D122","v":""},null,"R2.05",15,{"$f":"F11","v":""},null,"R2.12",17,{"$f":"F18","v":""}]
[null,null,"S2.04","Exploitation d'une Base de Données",{"$f":"M11","v":38},{"$f":"'S2 - Notes'!$D129","v":""},null,"R2.12",6,{"$f":"F18","v":""},null,"R2.13",11,{"$f":"F19","v":""}]
[null,null,"S2.05","Gestion d'un Projet",{"$f":"M23","v":38},{"$f":"'S2 - Notes'!$D136","v":""},null,"R2.13",3,{"$f":"F19","v":""},null,"R2.14",11,{"$f":"F20","v":""}]
[null,null,"S2.06","Organisation d'un Travail d'Équipe",{"$f":"M34","v":38},{"$f":"'S2 - Notes'!$D143","v":""},null,"S2.03",38,{"$f":"F31","v":""},null,"S2.06",38,{"$f":"F34","v":""}]
[null,null,"P2.01","Démarche Portfolio",{"$f":"I12+I23+I35+M12+M24+M35","v":12},{"$f":"IF(NOT(ISBLANK('S2 - Notes'!$K146)),'S2 - Notes'!$K146,\"\")","v":""},null,"P2.01",2,{"$f":"F35","v":""},null,"P2.01",2,{"$f":"F35","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E29:E35)","v":240},{"$f":"SUMPRODUCT(F29:F35,E29:E35)/E36","v":0},null,"Total et moyenne",{"$f":"SUM(I30:I35)","v":100},{"$f":"SUMPRODUCT(J30:J35,I30:I35)/I36","v":0},null,"Total et moyenne",{"$f":"SUM(M29:M35)","v":100},{"$f":"SUMPRODUCT(N29:N35,M29:M35)/M36","v":0}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S2 - Notes","index":4,"n_rows":146,"n_cols":4,"rows_kept":146,"cut":false,"hidden":false,"merged":[[29,3,29,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18],[15,3,15,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[57,3,57,18],[30,3,30,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[43,3,43,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[85,3,85,18],[58,3,58,18],[60,2,60,18],[64,3,64,18],[65,3,65,18],[67,2,67,18],[71,3,71,18],[72,3,72,18],[74,2,74,18],[78,3,78,18],[79,3,79,18],[81,2,81,18],[127,3,127,18],[86,3,86,18],[102,2,102,18],[106,3,106,18],[107,3,107,18],[109,2,109,18],[113,3,113,18],[114,3,114,18],[116,2,116,18],[120,3,120,18],[121,3,121,18],[123,2,123,18],[144,2,144,18],[145,2,145,9],[145,10,145,18],[142,3,142,18],[88,2,88,18],[92,3,92,18],[93,3,93,18],[95,2,95,18],[99,3,99,18],[100,3,100,18],[128,3,128,18],[130,2,130,18],[134,3,134,18],[135,3,135,18],[137,2,137,18],[141,3,141,18]]}
[]
[]
[null,null,"Notes du semestre 2"]
[]
[null,null,"R2.01 - Développement Orienté Objets"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R2.02 - Développement d'Applications avec IHM"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R2.03 - Qualité de Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R2.04 - Communication et Fonctionnement Bas Niveau"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R2.05 - Introduction aux Services Réseaux"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R2.06 - Exploitation d'une Base de Données"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"R2.07 - Graphes"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"R2.08 - Outils Numériques pour les Statistiques Descriptives"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"R2.09 - Méthodes Numériques"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D63:S63,D64:S64)/SUM(D64:S64)+D65),20),\"\")","v":""}]
[]
[null,null,"R2.10 - Introduction à la Gestion des Systèmes d'Information"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D70:S70,D71:S71)/SUM(D71:S71)+D72),20),\"\")","v":""}]
[]
[null,null,"R2.11 - Introduction au Droit"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D77:S77,D78:S78)/SUM(D78:S78)+D79),20),\"\")","v":""}]
[]
[null,null,"R2.12 - Anglais"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D84:S84,D85:S85)/SUM(D85:S85)+D86),20),\"\")","v":""}]
[]
[null,null,"R2.13 - Communication Technique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D91:S91,D92:S92)/SUM(D92:S92)+D93),20),\"\")","v":""}]
[]
[null,null,"R2.14 - Projet Professionnel et Personnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D98:S98,D99:S99)/SUM(D99:S99)+D100),20),\"\")","v":""}]
[]
[null,null,"S2.01 - Développement d'une Application"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D105:S105,D106:S106)/SUM(D106:S106)+D107),20),\"\")","v":""}]
[]
[null,null,"S2.02 - Exploration Algorithmique d'un Problème"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D112:S112,D113:S113)/SUM(D113:S113)+D114),20),\"\")","v":""}]
[]
[null,null,"S2.03 - Installation de Services Réseau"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D119:S119,D120:S120)/SUM(D120:S120)+D121),20),\"\")","v":""}]
[]
[null,null,"S2.04 - Exploitation d'une Base de Données"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D126:S126,D127:S127)/SUM(D127:S127)+D128),20),\"\")","v":""}]
[]
[null,null,"S2.05 - Gestion d'un Projet"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D133:S133,D134:S134)/SUM(D134:S134)+D135),20),\"\")","v":""}]
[]
[null,null,"S2.06 - Organisation d'un Travail d'Équipe"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D140:S140,D141:S141)/SUM(D141:S141)+D142),20),\"\")","v":""}]
[]
[null,null,"P2.01 - Démarche Portfolio"]
[null,null,"Note"]

{"sheet":"S3","index":5,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,2,28,17],[5,15,5,17],[2,2,2,17],[22,2,22,5],[25,4,25,5],[16,11,16,13],[17,15,17,17],[20,2,20,3],[26,2,26,3],[4,2,4,5],[4,7,4,9],[5,11,5,13],[16,7,16,9]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 3"]
[]
[null,null,"RESSOURCES",null,null,null,null,"UE3.1"]
[null,null,"Code","Nom","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"UE3.3",null,null,null,"UE3.5"]
[null,null,"R3.01","Développement Web",{"$f":"I7+I19+M8+M19","v":35},{"$f":"'S3 - Notes'!D10","v":""},null,"R3.01",15,{"$f":"F7","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R3.02","Développement Efficace",{"$f":"I8+I20","v":23},{"$f":"'S3 - Notes'!$D17","v":""},null,"R3.02",10,{"$f":"F8","v":""},null,"R3.01",5,{"$f":"F7","v":""},null,"R3.03",10,{"$f":"F9","v":""}]
[null,null,"R3.03","Analyse",{"$f":"I9+I21+Q8","v":27},{"$f":"'S3 - Notes'!$D24","v":""},null,"R3.03",12,{"$f":"F9","v":""},null,"R3.05",22,{"$f":"F11","v":""},null,"R3.04",8,{"$f":"F10","v":""}]
[null,null,"R3.04","Qualité de Développement",{"$f":"I10+Q9+Q20","v":28},{"$f":"'S3 - Notes'!$D31","v":""},null,"R3.04",15,{"$f":"F10","v":""},null,"R3.06",18,{"$f":"F12","v":""},null,"R3.10",18,{"$f":"F16","v":""}]
[null,null,"R3.05","Programmation Système",{"$f":"M9","v":22},{"$f":"'S3 - Notes'!$D38","v":""},null,"R3.11",8,{"$f":"F17","v":""},null,"R3.09",10,{"$f":"F15","v":""},null,"R3.11",10,{"$f":"F17","v":""}]
[null,null,"R3.06","Architecture des Réseaux",{"$f":"I22+M10","v":23},{"$f":"'S3 - Notes'!$D45","v":""},null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R106<>\"Notes Manquantes\",'S3 - Notes'!$R106,\"\")","v":""},null,"R3.12",5,{"$f":"F18","v":""},null,"R3.12",7,{"$f":"F18","v":""}]
[null,null,"R3.07","SQL dans un Langage de Programmation",{"$f":"M20","v":25},{"$f":"'S3 - Notes'!$D52","v":""},null,"Total et moyenne",{"$f":"SUM(I7:I12)","v":100},{"$f":"SUMPRODUCT(J7:J12,I7:I12)/I13","v":0},null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R108<>\"Notes Manquantes\",'S3 - Notes'!$R108,\"\")","v":""},null,"R3.13",7,{"$f":"F19","v":""}]
[null,null,"R3.08","Probabilités",{"$f":"I23+M21","v":22},{"$f":"'S3 - Notes'!$D59","v":""},null,null,null,null,null,"Total et moyenne",{"$f":"SUM(M8:M13)","v":100},{"$f":"SUMPRODUCT(N8:N13,M8:M13)/M14","v":0},null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R110<>\"Notes Manquantes\",'S3 - Notes'!$R110,\"\")","v":""}]
[null,null,"R3.09","Cryptographie et Sécurité",{"$f":"I24+M11+M22","v":25},{"$f":"'S3 - Notes'!$D66","v":""},null,null,null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(Q8:Q14)","v":100},{"$f":"SUMPRODUCT(R8:R14,Q8:Q14)/Q15","v":0}]
[null,null,"R3.10","Management des Systèmes d'Information",{"$f":"M23+Q10+Q21","v":44},{"$f":"'S3 - Notes'!$D73","v":""}]
[null,null,"R3.11","Droit des Contrats et du Numérique",{"$f":"I11+M24+Q11","v":23},{"$f":"'S3 - Notes'!$D80","v":""},null,"UE3.2",null,null,null,"UE3.4"]
[null,null,"R3.12","Anglais",{"$f":"I25+M12+Q12+Q22","v":25},{"$f":"'S3 - Notes'!$D87","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"UE3.6"]
[null,null,"R3.13","Communication professionnellle",{"$f":"Q13+Q23","v":23},{"$f":"'S3 - Notes'!$D94","v":""},null,"R3.01",5,{"$f":"F7","v":""},null,"R3.01",10,{"$f":"F7","v":""},null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R3.14","Projet Personnel et Professionnel",{"$f":"Q24","v":15},{"$f":"'S3 - Notes'!$D101","v":""},null,"R3.02",13,{"$f":"F8","v":""},null,"R3.07",25,{"$f":"F13","v":""},null,"R3.04",5,{"$f":"F10","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E20)","v":360},{"$f":"SUMPRODUCT(F7:F20,E7:E20)/E21","v":0},null,"R3.03",5,{"$f":"F9","v":""},null,"R3.08",5,{"$f":"F14","v":""},null,"R3.10",16,{"$f":"F16","v":""}]
[null,null,null,null,null,null,null,"R3.06",5,{"$f":"F12","v":""},null,"R3.09",5,{"$f":"F15","v":""},null,"R3.12",8,{"$f":"F18","v":""}]
[null,null,"SAÉ",null,null,null,null,"R3.08",17,{"$f":"F14","v":""},null,"R3.10",10,{"$f":"F16","v":""},null,"R3.13",16,{"$f":"F19","v":""}]
[null,null,"Code","Nom","Coef.","Note",null,"R3.09",10,{"$f":"F15","v":""},null,"R3.11",5,{"$f":"F17","v":""},null,"R3.14",15,{"$f":"F20","v":""}]
[null,null,"S3.Réal.01","Développement d'une Application",{"$f":"I12+I26+M13+M25+Q14+Q25","v":240},{"$f":"IF('S3 - Notes'!D112<>\"Notes Manquantes\",'S3 - Notes'!D112,\"\")","v":""},null,"R3.12",5,{"$f":"F18","v":""},null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R109<>\"Notes Manquantes\",'S3 - Notes'!$R109,\"\")","v":""},null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R111<>\"Notes Manquantes\",'S3 - Notes'!$R111,\"\")","v":""}]
[null,null,"P3.01","Démarche Portfolio","non évalué",null,null,"S3.Réal.01",40,{"$f":"IF('S3 - Notes'!$R107<>\"Notes Manquantes\",'S3 - Notes'!$R107,\"\")","v":""},null,"Total et moyenne",{"$f":"SUM(M19:M25)","v":100},{"$f":"SUMPRODUCT(N19:N25,M19:M25)/M26","v":0},null,"Total et moyenne",{"$f":"SUM(Q20:Q25)","v":100},{"$f":"SUMPRODUCT(R20:R25,Q20:Q25)/Q26","v":0}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E25)","v":240},{"$f":"F25","v":""},null,"Total et moyenne",{"$f":"SUM(I19:I26)","v":100},{"$f":"SUMPRODUCT(J19:J26,I19:I26)/I27","v":0}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S3 - Notes","index":6,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[[111,3,111,18],[110,4,110,5],[110,6,110,7],[110,8,110,9],[110,10,110,11],[110,15,110,16],[110,17,110,18],[109,17,109,18],[108,4,108,5],[108,6,108,7],[108,8,108,9],[108,10,108,11],[108,15,108,16],[108,17,108,18],[109,4,109,5],[109,6,109,7],[109,8,109,9],[109,10,109,11],[109,15,109,16],[107,17,107,18],[106,4,106,5],[106,6,106,7],[106,8,106,9],[106,10,106,11],[106,15,106,16],[106,17,106,18],[107,4,107,5],[107,6,107,7],[107,8,107,9],[107,10,107,11],[107,15,107,16],[105,17,105,18],[104,4,104,5],[104,6,104,7],[104,8,104,9],[104,10,104,11],[104,15,104,16],[104,17,104,18],[105,4,105,5],[105,6,105,7],[105,8,105,9],[105,10,105,11],[105,15,105,16],[100,3,100,18],[102,2,102,18],[103,17,103,18],[103,4,103,5],[103,6,103,7],[103,8,103,9],[103,10,103,11],[103,15,103,16],[99,3,99,18],[72,3,72,18],[74,2,74,18],[78,3,78,18],[79,3,79,18],[81,2,81,18],[85,3,85,18],[86,3,86,18],[88,2,88,18],[92,3,92,18],[93,3,93,18],[95,2,95,18],[71,3,71,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[57,3,57,18],[58,3,58,18],[60,2,60,18],[64,3,64,18],[65,3,65,18],[67,2,67,18],[43,3,43,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[29,3,29,18],[30,3,30,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[15,3,15,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18]]}
[]
[]
[null,null,"Notes du semestre 3 - Vous pouvez récupérer le fichier CSV qui importera noms et coefficients de ce semestre en cliquant ici (attention, votre précédente saisie sera écrasée)"]
[]
[null,null,"R3.01 - Développement Web"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R3.02 - Développement Efficace"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R3.03 - Analyse"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R3.04 - Qualité de Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R3.05 - Programmation Système"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R3.06 - Architecture des Réseaux"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"R3.07 - SQL dans un Langage de Programmation"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"R3.08 - Probabilités"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"R3.09 - Cryptographie et Sécurité"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D63:S63,D64:S64)/SUM(D64:S64)+D65),20),\"\")","v":""}]
[]
[null,null,"R3.10 - Management des Systèmes d'Information"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D70:S70,D71:S71)/SUM(D71:S71)+D72),20),\"\")","v":""}]
[]
[null,null,"R3.11 - Droit des Contrats et du Numérique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D77:S77,D78:S78)/SUM(D78:S78)+D79),20),\"\")","v":""}]
[]
[null,null,"R3.12 - Anglais"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D84:S84,D85:S85)/SUM(D85:S85)+D86),20),\"\")","v":""}]
[]
[null,null,"R3.13 - Communication Professionnelle"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D91:S91,D92:S92)/SUM(D92:S92)+D93),20),\"\")","v":""}]
[]
[null,null,"R3.14 - Projet Personnel et Professionnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D98:S98,D99:S99)/SUM(D99:S99)+D100),20),\"\")","v":""}]
[]
[null,null,"S3.Réal.01 - Développement d'une Application"]
[null,null,"Noms","Note de Cadrage","Cahier des Charges",null,"Plan de Développement",null,"Sprint Review en anglais",null,"Code + Jeux d'Essai",null,"Guide d'Utilisation","Suivis de Projet","Diaporama","Revues (Sprints et Soutenance)",null,"Moyennes par Compétence"]
[null,null,"Notes"]
[null,null,"Coefficients - C1 : Réaliser",15,25,null,5,null,null,null,45,null,null,null,null,10,null,{"$f":"IF(AND(NOT(ISBLANK(D105)),NOT(ISBLANK(E105)),NOT(ISBLANK(G105)),NOT(ISBLANK(K105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D106:$P106)/SUM($D106:$P106)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Coefficients - C2 : Optimiser",15,25,null,5,null,null,null,40,null,null,null,null,15,null,{"$f":"IF(AND(NOT(ISBLANK(D105)),NOT(ISBLANK(E105)),NOT(ISBLANK(G105)),NOT(ISBLANK(K105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D107:$P107)/SUM($D107:$P107)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Coefficients - C3 : Administrer",5,15,null,5,null,null,null,60,null,null,null,null,15,null,{"$f":"IF(AND(NOT(ISBLANK(D105)),NOT(ISBLANK(E105)),NOT(ISBLANK(G105)),NOT(ISBLANK(K105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D108:$P108)/SUM($D108:$P108)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Coefficients - C4 : Gérer",null,null,null,null,null,null,null,80,null,null,null,null,20,null,{"$f":"IF(AND(NOT(ISBLANK(K105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D109:$P109)/SUM($D109:$P109)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Coefficients - C5 : Conduire",null,null,null,5,null,20,null,null,null,10,50,null,15,null,{"$f":"IF(AND(NOT(ISBLANK(G105)),NOT(ISBLANK(I105)),NOT(ISBLANK(M105)),NOT(ISBLANK(N105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D110:$P110)/SUM($D110:$P110)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Coefficients - C6 : Collaborer",null,null,null,5,null,20,null,null,null,20,null,30,25,null,{"$f":"IF(AND(NOT(ISBLANK(G105)),NOT(ISBLANK(I105)),NOT(ISBLANK(M105)),NOT(ISBLANK(O105)),NOT(ISBLANK(P105))),(SUMPRODUCT($D$105:$P$105,$D111:$P111)/SUM($D111:$P111)),\"Notes Manquantes\")","v":"Notes Manquantes"}]
[null,null,"Moyenne indicative de la SAÉ",{"$f":"IF(AND(R106<>\"Notes Manquantes\",R107<>\"Notes Manquantes\",R108<>\"Notes Manquantes\",R109<>\"Notes Manquantes\",R110<>\"Notes Manquantes\",R111<>\"Notes Manquantes\"),((D105*SUM(D106:D111)+E105*SUM(E106:E111)+G105*SUM(G106:G111)+I105*SUM(I106:I111)+K105*SUM(K106:K111)+M105*SUM(M106:M111)+N105*SUM(N106:N111)+O105*SUM(O106:O111)+P105*SUM(P106:P111))/(SUM(D106:P111))),\"Notes Manquantes\")","v":"Notes Manquantes"}]

{"sheet":"S4","index":7,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,15,17,17],[18,2,18,3],[21,2,21,5],[28,2,28,17],[26,2,26,3],[2,2,2,17],[4,2,4,5],[4,7,4,9],[5,11,5,13],[16,11,16,13],[15,7,15,9],[4,15,4,17]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 4"]
[]
[null,null,"RESSOURCES",null,null,null,null,"UE4.1",null,null,null,null,null,null,null,"UE4.5"]
[null,null,"Code","Nom","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"UE4.3",null,null,null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R4.01","Architecture Logicielle",{"$f":"I7+M8+Q19","v":32},{"$f":"'S4 - Notes'!D10","v":""},null,"R4.01",16,{"$f":"F7","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"R4.02",10,{"$f":"F8","v":""}]
[null,null,"R4.02","Qualité de Développement",{"$f":"I8+Q7","v":18},{"$f":"'S4 - Notes'!D17","v":""},null,"R4.02",8,{"$f":"F8","v":""},null,"R4.01",12,{"$f":"F7","v":""},null,"R4.Réal.09",22,{"$f":"F15","v":""}]
[null,null,"R4.03","Qualité et au-delà du Relationnel",{"$f":"M19","v":18},{"$f":"'S4 - Notes'!D24","v":""},null,"R4.Réal.10",8,{"$f":"F16","v":""},null,"R4.Réal.08",28,{"$f":"F14","v":""},null,"R4.Réal.10",4,{"$f":"F16","v":""}]
[null,null,"R4.04","Méthodes d’Optimisation",{"$f":"I18","v":12},{"$f":"'S4 - Notes'!D31","v":""},null,"R4.Réal.11",8,{"$f":"F17","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""},null,"R4.Réal.11",4,{"$f":"F17","v":""}]
[null,null,"R4.05","Anglais",{"$f":"I19+Q20","v":17},{"$f":"'S4 - Notes'!D38","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""},null,"S4.St",40,{"$f":"F25","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""}]
[null,null,"R4.06","Communication Interne",{"$f":"M20+Q21","v":19},{"$f":"'S4 - Notes'!D45","v":""},null,"S4.St",40,{"$f":"F25","v":""},null,"P4.01",5,{"$f":"F26","v":""},null,"S4.St",40,{"$f":"F25","v":""}]
[null,null,"R4.07","Projet Personnel et Professionnel",{"$f":"Q22","v":10},{"$f":"'S4 - Notes'!D52","v":""},null,"P4.01",5,{"$f":"F26","v":""},null,"Total et moyenne",{"$f":"SUM(M8:M12)","v":100},{"$f":"SUMPRODUCT(N8:N12,M8:M12)/M13","v":0},null,"P4.01",5,{"$f":"F26","v":""}]
[null,null,"R4.Réal.08","Virtualisation",{"$f":"M9","v":28},{"$f":"'S4 - Notes'!D59","v":""},null,"Total et moyenne",{"$f":"SUM(I7:I13)","v":100},{"$f":"SUMPRODUCT(J7:J13,I7:I13)/I14","v":0},null,null,null,null,null,"Total et moyenne",{"$f":"SUM(Q7:Q13)","v":100},{"$f":"SUMPRODUCT(R7:R13,Q7:Q13)/Q14","v":0}]
[null,null,"R4.Réal.09","Management Avancé des Systèmes d’Information",{"$f":"I20+Q8","v":26},{"$f":"'S4 - Notes'!D66","v":""}]
[null,null,"R4.Réal.10","Complément Web",{"$f":"I9+I21+M21+Q9","v":24},{"$f":"'S4 - Notes'!D73","v":""},null,"UE4.2"]
[null,null,"R4.Réal.11","Développement pour Applications Mobiles",{"$f":"I10+I22+M22+Q10","v":24},{"$f":"'S4 - Notes'!D80","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"UE4.4"]
[null,null,"R4.Réal.12","Automates et Langages",{"$f":"I23","v":12},{"$f":"'S4 - Notes'!D87","v":""},null,"R4.04",12,{"$f":"F10","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"UE4.6"]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E18)","v":240},{"$f":"SUMPRODUCT(F7:F18,E7:E18)/E19","v":0},null,"R4.05",4,{"$f":"F11","v":""},null,"R4.03",18,{"$f":"F9","v":""},null,"R4.01",4,{"$f":"F7","v":""}]
[null,null,null,null,null,null,null,"R4.Réal.09",4,{"$f":"F15","v":""},null,"R4.06",6,{"$f":"F12","v":""},null,"R4.05",13,{"$f":"F11","v":""}]
[null,null,null,null,null,null,null,"R4.Réal.10",4,{"$f":"F16","v":""},null,"R4.Réal.10",8,{"$f":"F16","v":""},null,"R4.06",13,{"$f":"F12","v":""}]
[null,null,"SAÉ",null,null,null,null,"R4.Réal.11",4,{"$f":"F17","v":""},null,"R4.Réal.11",8,{"$f":"F17","v":""},null,"R4.07",10,{"$f":"F13","v":""}]
[null,null,"Code","Nom","Coef.","Note",null,"R4.Réal.12",12,{"$f":"F18","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""}]
[null,null,"S4.Réal.01","Développement d'une Application Complexe",{"$f":"I11+I24+M10+M23+Q11+Q23","v":90},{"$f":"'S4 - Notes'!D94","v":""},null,"S4.Réal.01",15,{"$f":"F24","v":""},null,"S4.St",40,{"$f":"F25","v":""},null,"S4.St",40,{"$f":"F25","v":""}]
[null,null,"S4.St","Stage",{"$f":"I12+I25+M11+M24+Q12+Q24","v":240},{"$f":"'S4 - Notes'!D101","v":""},null,"S4.St",40,{"$f":"F25","v":""},null,"P4.01",5,{"$f":"F26","v":""},null,"P4.01",5,{"$f":"F26","v":""}]
[null,null,"P4.01","Démarche Portfolio",{"$f":"I13+I26+M12+M25+Q13+Q25","v":30},{"$f":"IF(NOT(ISBLANK('S4 - Notes'!K104)),'S4 - Notes'!K104,\"\")","v":""},null,"P4.01",5,{"$f":"F26","v":""},null,"Total et moyenne",{"$f":"SUM(M19:M25)","v":100},{"$f":"SUMPRODUCT(N19:N25,M19:M25)/M26","v":0},null,"Total et moyenne",{"$f":"SUM(Q19:Q25)","v":100},{"$f":"SUMPRODUCT(R19:R25,Q19:Q25)/Q26","v":0}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E24:E26)","v":360},{"$f":"SUMPRODUCT(E24:E26,F24:F26)/E27","v":0},null,"Total et moyenne",{"$f":"SUM(I18:I26)","v":100},{"$f":"SUMPRODUCT(J18:J26,I18:I26)/I27","v":0}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S4 - Notes","index":8,"n_rows":104,"n_cols":4,"rows_kept":104,"cut":false,"hidden":false,"merged":[[29,3,29,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18],[15,3,15,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[57,3,57,18],[30,3,30,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[43,3,43,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[85,3,85,18],[58,3,58,18],[60,2,60,18],[64,3,64,18],[65,3,65,18],[67,2,67,18],[71,3,71,18],[72,3,72,18],[74,2,74,18],[78,3,78,18],[79,3,79,18],[81,2,81,18],[102,2,102,18],[103,2,103,9],[103,10,103,18],[100,3,100,18],[86,3,86,18],[88,2,88,18],[92,3,92,18],[93,3,93,18],[95,2,95,18],[99,3,99,18]]}
[]
[]
[null,null,"Notes du semestre 4"]
[]
[null,null,"R4.01 - Architecture Logicielle"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R4.02 - Qualité de Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R4.03 - Qualité et au-delà du relationnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R4.04 - Méthodes d'Optimisation"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R4.05 - Anglais"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R4.06 - Communication Interne"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"R4.07 - Projet Personnel et Professionnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"R4.Réal.08 - Virtualisation"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"R4.Réal.09 - Management Avancé des Systèmes d'Information"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D63:S63,D64:S64)/SUM(D64:S64)+D65),20),\"\")","v":""}]
[]
[null,null,"R4.Réal.10 - Complément Web"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D70:S70,D71:S71)/SUM(D71:S71)+D72),20),\"\")","v":""}]
[]
[null,null,"R4.Réal.11 - Développement pour Applications Mobiles"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D77:S77,D78:S78)/SUM(D78:S78)+D79),20),\"\")","v":""}]
[]
[null,null,"R4.Réal.12 - Automates et Langages"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D84:S84,D85:S85)/SUM(D85:S85)+D86),20),\"\")","v":""}]
[]
[null,null,"S4.Réal.01 - Développement d'une Application Complexe"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D91:S91,D92:S92)/SUM(D92:S92)+D93),20),\"\")","v":""}]
[]
[null,null,"S4.St - Stage"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D98:S98,D99:S99)/SUM(D99:S99)+D100),20),\"\")","v":""}]
[]
[null,null,"P4.01 - Démarche Portfolio"]
[null,null,"Note"]

{"sheet":"S5","index":9,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,2,2,17],[4,2,4,5],[9,7,9,9],[9,11,9,13],[10,15,10,17],[20,2,20,3],[22,2,22,5],[25,4,25,5],[26,2,26,3],[28,2,28,17]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 5"]
[]
[null,null,"RESSOURCES"]
[null,null,"Code","Nom","Coef.","Note"]
[null,null,"R5.01","Initiation au Management d’une Équipe de Projet Informatique",{"$f":"Q13","v":9},{"$f":"'S5 - Notes'!D10","v":""}]
[null,null,"R5.02","Projet Personnel et Professionnel",{"$f":"Q14","v":6},{"$f":"'S5 - Notes'!D17","v":""}]
[null,null,"R5.03","Politique de Communication",{"$f":"Q15","v":13},{"$f":"'S5 - Notes'!D24","v":""}]
[null,null,"R5.Réal.04","Qualité Algorithmique",{"$f":"I12+M12","v":8},{"$f":"'S5 - Notes'!D31","v":""},null,"UE5.1",null,null,null,"UE5.2"]
[null,null,"R5.Réal.05","Programmation Avancée",{"$f":"I13+M13","v":16},{"$f":"'S5 - Notes'!D38","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"UE5.6"]
[null,null,"R5.Réal.06","Sensibilisation à la Programmation Multimédia",{"$f":"I14+M14+Q16","v":6},{"$f":"'S5 - Notes'!D45","v":""},null,"R5.Réal.04",2,{"$f":"F10","v":""},null,"R5.Réal.04",6,{"$f":"F10","v":""},null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R5.Réal.07","Automatisation de la Chaîne de Production",{"$f":"I15+Q17","v":8},{"$f":"'S5 - Notes'!D52","v":""},null,"R5.Réal.05",9,"",null,"R5.Réal.05",7,{"$f":"F11","v":""},null,"R5.01",9,{"$f":"F7","v":""}]
[null,null,"R5.Réal.08","Qualité de Développement",{"$f":"I16+M15","v":12},{"$f":"'S5 - Notes'!D59","v":""},null,"R5.Réal.06",2,"",null,"R5.Réal.06",2,{"$f":"F12","v":""},null,"R5.02",6,{"$f":"F8","v":""}]
[null,null,"R5.Réal.09","Virtualisation Avancée",{"$f":"I17+M16","v":9},{"$f":"'S5 - Notes'!D66","v":""},null,"R5.Réal.07",6,"",null,"R5.Réal.08",5,{"$f":"F14","v":""},null,"R5.03",13,{"$f":"F9","v":""}]
[null,null,"R5.Réal.10","Nouveaux Paradigmes de Base de Données",{"$f":"I18+M17","v":16},{"$f":"'S5 - Notes'!D73","v":""},null,"R5.Réal.08",7,"",null,"R5.Réal.09",2,{"$f":"F15","v":""},null,"R5.Réal.06",2,{"$f":"F12","v":""}]
[null,null,"R5.Réal.11","Méthodes d’Optimisation pour l’Aide à la Décision",{"$f":"M18","v":7},{"$f":"'S5 - Notes'!D80","v":""},null,"R5.Réal.09",7,"",null,"R5.Réal.10",4,{"$f":"F16","v":""},null,"R5.Réal.07",2,{"$f":"F13","v":""}]
[null,null,"R5.Réal.12","Modélisations Mathématiques",{"$f":"M19","v":13},{"$f":"'S5 - Notes'!D87","v":""},null,"R5.Réal.10",12,"",null,"R5.Réal.11",7,{"$f":"F17","v":""},null,"R5.Réal.13",5,{"$f":"F19","v":""}]
[null,null,"R5.Réal.13","Économie Durable et Numérique",{"$f":"I19+Q18","v":7},{"$f":"'S5 - Notes'!D94","v":""},null,"R5.Réal.13",2,{"$f":"F19","v":""},null,"R5.Réal.12",13,{"$f":"F18","v":""},null,"R5.Réal.14",13,{"$f":"F20","v":""}]
[null,null,"R5.Réal.14","Anglais",{"$f":"I20+M20+Q19","v":20},{"$f":"'S5 - Notes'!D101","v":""},null,"R5.Réal.14",3,{"$f":"F20","v":""},null,"R5.Réal.14",4,{"$f":"F20","v":""},null,"S5.Réal.01",50,{"$f":"F25","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E20)","v":150},{"$f":"SUMPRODUCT(F7:F20,E7:E20)/E21","v":0},null,"S5.Réal.01",50,{"$f":"F25","v":""},null,"S5.Réal.01",50,{"$f":"F25","v":""},null,"Total et moyenne",{"$f":"SUM(Q13:Q20)","v":100},{"$f":"SUMPRODUCT(R13:R20,Q13:Q20)/Q21","v":0}]
[null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(I12:I21)","v":100},{"$f":"SUMPRODUCT(J12:J21,I12:I21)/I22","v":0},null,"Total et moyenne",{"$f":"SUM(M12:M21)","v":100},{"$f":"SUMPRODUCT(N12:N21,M12:M21)/M22","v":0}]
[null,null,"SAÉ"]
[null,null,"Code","Nom","Coef.","Note"]
[null,null,"S5.Réal.01","Développement Avancé",{"$f":"I21+M21+Q20","v":150},{"$f":"'S5 - Notes'!D108","v":""}]
[null,null,"P5.01","Démarche Portfolio","non évalué"]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E25)","v":150},{"$f":"F25","v":""}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S5 - Notes","index":10,"n_rows":108,"n_cols":4,"rows_kept":108,"cut":false,"hidden":false,"merged":[[29,3,29,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18],[15,3,15,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[57,3,57,18],[30,3,30,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[43,3,43,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[85,3,85,18],[58,3,58,18],[60,2,60,18],[64,3,64,18],[65,3,65,18],[67,2,67,18],[71,3,71,18],[72,3,72,18],[74,2,74,18],[78,3,78,18],[79,3,79,18],[81,2,81,18],[100,3,100,18],[102,2,102,18],[106,3,106,18],[107,3,107,18],[86,3,86,18],[88,2,88,18],[92,3,92,18],[93,3,93,18],[95,2,95,18],[99,3,99,18]]}
[]
[]
[null,null,"Notes du semestre 5"]
[]
[null,null,"R5.01 - Initiation au Management d’une Équipe de Projet Informatique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R5.02 - Projet Personnel et Professionnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R5.03 - Politique de Communication"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.04 - Qualité Algorithmique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.05 - Programmation Avancée"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.06 - Sensibilisation à la Programmation Multimédia"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.07 - Automatisation de la Chaîne de Production"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.08 - Qualité de Développement"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.09 - Virtualisation Avancée"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D63:S63,D64:S64)/SUM(D64:S64)+D65),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.10 - Nouveaux Paradigmes de Base de Données"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D70:S70,D71:S71)/SUM(D71:S71)+D72),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.11 - Méthodes d’Optimisation pour l’Aide à la Décision"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D77:S77,D78:S78)/SUM(D78:S78)+D79),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.12 - Modélisations Mathématiques"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D84:S84,D85:S85)/SUM(D85:S85)+D86),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.13 - Économie Durable et Numérique"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D91:S91,D92:S92)/SUM(D92:S92)+D93),20),\"\")","v":""}]
[]
[null,null,"R5.Réal.14 - Anglais"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D98:S98,D99:S99)/SUM(D99:S99)+D100),20),\"\")","v":""}]
[]
[null,null,"S5.Réal.01 - Développement Avancé"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la SAÉ",{"$f":"IFERROR(MIN((SUMPRODUCT(D105:S105,D106:S106)/SUM(D106:S106)+D107),20),\"\")","v":""}]

{"sheet":"S6","index":11,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,17],[14,2,14,5],[8,7,8,9],[8,11,8,13],[2,2,2,17],[4,2,4,5],[12,2,12,3],[6,15,6,17],[19,2,19,3]]}
[]
[]
[null,null,"Tableau de répartition des ressources & SAÉ du semestre 6"]
[]
[null,null,"RESSOURCES"]
[null,null,"Code","Nom","Coef.","Note"]
[null,null,"R6.01","Initiation à l’Entrepreneuriat",{"$f":"Q9","v":12},{"$f":"'S6 - Notes'!D10","v":""},null,null,null,null,null,null,null,null,null,"UE6.6"]
[null,null,"R6.02","Droit du Numérique et de la Propriété Intellectuelle",{"$f":"Q10","v":12},{"$f":"'S6 - Notes'!D17","v":""},null,null,null,null,null,null,null,null,null,"Ressource ou SAÉ","Coef.","Note"]
[null,null,"R6.03","Communication : Organisation et Diffusion de l’Information",{"$f":"Q11","v":7},{"$f":"'S6 - Notes'!D24","v":""},null,"UE6.1",null,null,null,"UE6.2",null,null,null,"R6.01",12,{"$f":"F7","v":""}]
[null,null,"R6.04","Projet Personnel et Professionnel",{"$f":"Q12","v":7},{"$f":"'S6 - Notes'!D31","v":""},null,"Ressource ou SAÉ","Coef.","Note",null,"Ressource ou SAÉ","Coef.","Note",null,"R6.02",12,{"$f":"F8","v":""}]
[null,null,"R6.Réal.05","Développement Avancé",{"$f":"I11+M11+Q13","v":46},{"$f":"'S6 - Notes'!D38","v":""},null,"R6.Réal.05",22,{"$f":"F11","v":""},null,"R6.Réal.05",22,{"$f":"F11","v":""},null,"R6.03",7,{"$f":"F9","v":""}]
[null,null,"R6.Réal.06","Maintenance Applicative",{"$f":"I12+M12","v":36},{"$f":"'S6 - Notes'!D45","v":""},null,"R6.Réal.06",18,{"$f":"F12","v":""},null,"R6.Réal.06",18,{"$f":"F12","v":""},null,"R6.04",7,{"$f":"F10","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E7:E12)","v":120},{"$f":"SUMPRODUCT(F7:F12,E7:E12)/E13","v":0},null,"S6.Réal.01",10,{"$f":"F17","v":""},null,"S6.Réal.01",10,{"$f":"F17","v":""},null,"R6.Réal.05",2,{"$f":"F11","v":""}]
[null,null,null,null,null,null,null,"S6.Réal.Al",45,{"$f":"F18","v":""},null,"S6.Réal.Al",45,{"$f":"F18","v":""},null,"S6.Réal.01",10,{"$f":"F17","v":""}]
[null,null,"SAÉ",null,null,null,null,"P6.01",5,{"$f":"F19","v":""},null,"P6.01",5,{"$f":"F19","v":""},null,"S6.Réal.Al",45,{"$f":"F18","v":""}]
[null,null,"Code","Nom","Coef.","Note",null,"Total et moyenne",{"$f":"SUM(I11:I15)","v":100},{"$f":"SUMPRODUCT(J11:J15,I11:I15)/I16","v":0},null,"Total et moyenne",{"$f":"SUM(M11:M15)","v":100},{"$f":"SUMPRODUCT(N11:N15,M11:M15)/M16","v":0},null,"P6.01",5,{"$f":"F19","v":""}]
[null,null,"S6.Réal.01","Évolution d’une Application Existante",{"$f":"I13+M13+Q14","v":30},{"$f":"'S6 - Notes'!D52","v":""},null,null,null,null,null,null,null,null,null,"Total et moyenne",{"$f":"SUM(Q9:Q16)","v":100},{"$f":"SUMPRODUCT(R9:R16,Q9:Q16)/Q17","v":0}]
[null,null,"S6.Réal.Al","Alternance",{"$f":"I14+M14+Q15","v":135},{"$f":"'S6 - Notes'!D59","v":""}]
[null,null,"P6.01","Démarche Portfolio",{"$f":"I15+M15+Q16","v":15},{"$f":"IF(NOT(ISBLANK('S6 - Notes'!K62)),'S6 - Notes'!K62,\"\")","v":""}]
[null,null,"Total & moyenne indicative",null,{"$f":"SUM(E17:E19)","v":180},{"$f":"SUMPRODUCT(E17:E19,F17:F19)/E20","v":0}]
[]
[null,null,"Ce tableau est inspiré de ceux fournis par M. DE SAUZA"]

{"sheet":"S6 - Notes","index":12,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[15,3,15,18],[2,2,2,18],[4,2,4,18],[8,3,8,18],[9,3,9,18],[11,2,11,18],[43,3,43,18],[16,3,16,18],[18,2,18,18],[22,3,22,18],[23,3,23,18],[25,2,25,18],[29,3,29,18],[30,3,30,18],[32,2,32,18],[36,3,36,18],[37,3,37,18],[39,2,39,18],[60,2,60,18],[61,2,61,9],[61,10,61,18],[58,3,58,18],[44,3,44,18],[46,2,46,18],[50,3,50,18],[51,3,51,18],[53,2,53,18],[57,3,57,18]]}
[]
[]
[null,null,"Notes du semestre 6"]
[]
[null,null,"R6.01 - Initiation à l’Entrepreneuriat"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D7:S7,D8:S8)/SUM(D8:S8)+D9),20),\"\")","v":""}]
[]
[null,null,"R6.02 - Droit du Numérique et de la Propriété Intellectuelle"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D14:S14,D15:S15)/SUM(D15:S15)+D16),20),\"\")","v":""}]
[]
[null,null,"R6.03 - Communication : Organisation et Diffusion de l’Information"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D21:S21,D22:S22)/SUM(D22:S22)+D23),20),\"\")","v":""}]
[]
[null,null,"R6.04 - Projet Personnel et Professionnel"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D28:S28,D29:S29)/SUM(D29:S29)+D30),20),\"\")","v":""}]
[]
[null,null,"R6.Réal.05 - Développement Avancé"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D35:S35,D36:S36)/SUM(D36:S36)+D37),20),\"\")","v":""}]
[]
[null,null,"R6.Réal.06 - Maintenance Applicative"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D42:S42,D43:S43)/SUM(D43:S43)+D44),20),\"\")","v":""}]
[]
[null,null,"S6.Réal.01 - Évolution d’une Application Existante"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D49:S49,D50:S50)/SUM(D50:S50)+D51),20),\"\")","v":""}]
[]
[null,null,"S6.Réal.Al - Alternance"]
[null,null,"Noms"]
[null,null,"Notes"]
[null,null,"Coefficients"]
[null,null,"Bonus"]
[null,null,"Moyenne de la ressource",{"$f":"IFERROR(MIN((SUMPRODUCT(D56:S56,D57:S57)/SUM(D57:S57)+D58),20),\"\")","v":""}]
[]
[null,null,"P6.01 - Démarche Portfolio"]
[null,null,"Note"]