{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["DEZE WERKMAP GEBRUIKEN","CIJFERLIJST"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"DEZE WERKMAP GEBRUIKEN","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"INSTRUCTIES"]
[null,"Gebruik het werkblad CIJFERLIJST voor het berekenen van cijfers waarbij elke opdracht een opgegeven aantal punten waard is. "]
[null,"Instructies: Vergeet niet om back-ups van uw cijfers op te slaan."]
[null,"1. Voer de naam van uw school, de groepsinformatie, de namen van de leerlingen/studenten en de leerling/student-id's (optioneel) in.   "]
[null,"2. Pas de tabel Cijfers en gewogen gemiddelde aan aan het beoordelingssysteem dat u gewoonlijk gebruikt."]
[null,"3. Voer de namen van de opdrachten of toetsen in vanaf cel G7, samen met het percentage dat elk onderdeel waard is (bijvoorbeeld 'Eindtoets' en '50%'). "]
[null,"4. Voer de scores in voor elke leerling/student bij elke opdracht of toets. De kolommen 'Score', 'Eindbeoordeling' en 'Gemiddelde' worden automatisch berekend, maar u kunt deze desgewenst overschrijven. De manier waarop de cijfers worden berekend, het gemiddelde en eindcijfer worden pas voltooid nadat alle scores zijn ingevoerd."]
[null,"Gebruik de opdracht 'Afdrukbereik' in het menu Pagina-indeling als u het gebied dat wordt afgedrukt, wilt wijzigen."]
[null,"De Score, Eindbeoordeling en het Gewogen gemiddelde zijn niet geldig tot de toetsen en opdrachten 100% voltooid zijn. "]
[null,"In de cellen G7 tot W8 voert u iedere opdracht of toets en het bijbehorende percentage van de totale score in."]

{"sheet":"CIJFERLIJST","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"DE NAAM VAN UW SCHOOL"]
[]
[{"$nulls":6},"Score",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"Eindboordeling","Gezakt","Nog net voldoende","Voldoende","Ruim voldoende","Nog net goed","Goed","Zeer goed","Nog net bevredigend","Bevredigend","Zeer bevredigend","Uitstekend","Zeer uitstekend","Uitmuntend"]
[{"$nulls":6},"Gewogen gemiddelde",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Naam onderwijzer(es)"]
[null,"Groep/project",null,null,"Naam van opdracht of toets"]
[null,"Jaar/Semester/Kwartaal",null,null,"Percentage (moeten in totaal 100% zijn)"]
[{"$nulls":4},{"$f":"\"Totale percentage: \"&SUM(G8:W8)*100&\"%\"","v":"Totale percentage: 0%"}]
[null,"Naam leerling/student","Id-nummer leerling/student","Score","Eindboordeling","Gewogen gemiddelde","Kolom6","Kolom7","Kolom8","Kolom9","Kolom10","Kolom11","K12","Kolom13","Kolom14","Kolom15","Kolom16","Kolom17","Kolom18","Kolom19","Kolom20","Kolom21","Kolom22"]
[{"$nulls":3},{"$f":"(IF(SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Cijfers[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Cijfers[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Cijfers[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Cijfers[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Cijfers[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Cijfers[[#This Row],[Score]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[]
[null,"Groepsoverzicht",null,"Score","Eindboordeling","Gewogen gemiddelde","","","","","","","","","","",""]
[null," Gemiddelde",null,{"$f":"IFERROR(AVERAGE(Cijfers[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,GradeTable,2),\"\")","v":"Gezakt"},{"$f":"IFERROR(AVERAGE(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Hoogste score",null,{"$f":"IFERROR(MAX(Cijfers[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,GradeTable,2),\"\")","v":"Gezakt"},{"$f":"IFERROR(MAX(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Laagste score",null,{"$f":"IFERROR(MIN(Cijfers[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,GradeTable,2),\"\")","v":"Gezakt"},{"$f":"IFERROR(MIN(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":0},"","","","","","","","","","","","","","","","",""]