{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["DEZE WERKMAP GEBRUIKEN","CIJFERLIJST"],"not_rendered":{"defined_names":7},"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, toetsen of testen in (bijvoorbeeld 'toets 1') vanaf cel H8, samen met het aantal punten dat elke opdracht waard is. "]
[null,"4. Voer de scores in voor elke leerling/student bij elke opdracht of toets. De kolommen 'Gemiddelde', 'Score', 'Eindbeoordeling' en 'Gewogen gemiddelde' worden automatisch berekend, maar u kunt deze desgewenst overschrijven. Als u extra punten wilt toekennen, hoeft u alleen maar meer punten aan een opdracht te geven dan het totaal aantal te verdienen punten voor die opdracht."]
[null,"Gebruik de opdracht 'Afdrukbereik' in het menu Pagina-indeling als u wilt wijzigen wat er wordt afgedrukt."]
[null,"Scores voor beoordelingen zijn gebaseerd op een schaal met standaardpercentages op basis van het totaal aantal toegewezen punten in de rijen 8 en 9. Pas voor iedere opdracht of test het gewenste aantal punten aan en pas vervolgens het percentage voor de bijbehorende beoordeling aan. Overschrijf de scorecellen voor handmatige wijzigingen."]
[null,"In cellen H8 tot X9 voert u elke opdracht, toets of test en het aantal punten dat deze waard zijn in."]

{"sheet":"CIJFERLIJST","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[1,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"DE NAAM VAN UW SCHOOL"]
[null,"Naam onderwijzer(es)"]
[{"$nulls":7},"Score",{"$f":"I4*TotalPoints","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Groep/project",{"$nulls":5},"%",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"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%"}]
[null,"Jaar/Semester/Kwartaal",{"$nulls":5},"Eindbeoordeling","Gezakt","Nog net voldoende","Voldoende","Ruim voldoende","Nog net goed","Goed","Zeer goed","Nog net bevredigend","Bevredigend","Zeer bevredigend","Uitstekend","Zeer uitstekend","Uitmuntend"]
[{"$nulls":7},"Gewogen gemiddelde",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Naam van opdracht of toets",null,null,"HW1","HW2","K1"]
[{"$nulls":4},"Totaal aantal te verdienen punten:",null,null,50,50,100]
[]
[{"$nulls":4},"Totaal aantal opdrachten en toetsen:",null,null,{"$f":"COUNTA(H8:AH8)","v":3}]
[{"$nulls":4},"Totaal mogelijke punten:",null,null,{"$f":"SUM(H9:AH9)","v":200}]
[]
[null,"Naam leerling/student","Id-nummer leerling/student","Gemiddelde","Score","Eindbeoordeling","Gewogen gemiddelde","Kolom6","Kolom7","Kolom8","Kolom9","Kolom10","Kolom11","K12","Kolom13","Kolom14","Kolom15","Kolom16","Kolom17","Kolom18","Kolom19","Kolom20","Kolom21","Kolom22"]
[null,"Studentnummer 1",null,{"$f":"IFERROR(IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]])/TotalPoints),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]))","v":182},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,3),\"\"),0)","v":"Uitstekend"},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,4),\"\"),0)","v":3.67},45,45,92]
[null,"Dossiernummer Leerling/student",null,{"$f":"IFERROR(IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]])/TotalPoints),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]))","v":200},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,3),\"\"),0)","v":"Uitmuntend"},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Cijfers[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Cijfers[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Cijfers[[#This Row],[Gemiddelde]]<>\"\",HLOOKUP(Cijfers[[#This Row],[Gemiddelde]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[]
[null,"Groepsoverzicht",null,"Gemiddelde",null,"Eindbeoordeling","Gewogen gemiddelde","","","","","","","","","","",""]
[null," Gemiddelde",null,{"$f":"IFERROR(AVERAGE(Cijfers[[#All],[Gemiddelde]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoints,GradeTable,3),\"\")","v":"Zeer uitstekend"},{"$f":"IFERROR(AVERAGE(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Hoogste score",null,{"$f":"IFERROR(MAX(Cijfers[[#All],[Gemiddelde]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoints,GradeTable,3),\"\")","v":"Uitmuntend"},{"$f":"IFERROR(MAX(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Laagste score",null,{"$f":"IFERROR(MIN(Cijfers[[#All],[Gemiddelde]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoints,GradeTable,3),\"\")","v":"Uitstekend"},{"$f":"IFERROR(MIN(Cijfers[[#All],[Gewogen gemiddelde]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]