{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TÄMÄN TYÖKIRJAN KÄYTTÄMINEN","ARVOSANATYÖKIRJA"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"TÄMÄN TYÖKIRJAN KÄYTTÄMINEN","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"OHJEET"]
[null,"ARVOSANATYÖKIRJA-laskentataulukon avulla voit laskea kokonaisarvosanoja tehtävistä, joille on määritetty omat kokonaispistemäärät. "]
[null,"Ohjeet: Muista tallentaa arvosanoista varmuuskopiot."]
[null,"1. Täytä koulun nimi, ryhmän tiedot, oppilaiden nimet ja opiskelijanumerot (valinnainen).   "]
[null,"2. Säädä Arvosanat ja yleisarvosana -taulukko arviointijärjestelmän mukaiseksi."]
[null,"3. Kirjoita tehtävien, testien tai kokeiden nimet (esim. Koe 1) solusta H8 alkaen. Kirjoita myös kunkin tehtävän kokonaispistemäärä. "]
[null,"4. Kirjoita opiskelijoiden kustakin tehtävästä tai kokeesta saamat pistemäärät. Keskiarvo-, Pistemäärä-, Kirjainarvosana- ja Yleisarvosana-sarakkeet lasketaan automaattisesti, mutta voit myös ohittaa ne. Voit helposti antaa lisäpisteitä antamalla tehtävästä sille määritettyä kokonaispistemäärää enemmän pisteitä."]
[null,"Sivun asettelu -valikon Tulostusalue-komennolla voit määrittää tulostettavat osat."]
[null,"Arvosanojen pistemäärät perustuvat prosenttiosuuksiin riveillä 8 ja 9 määritettyjen kokonaispistemäärien mukaisesti. Voit määrittää kullekin tehtävälle tai testille kokonaispistemäärän ja kuhunkin arvosanaan oikeuttavan prosenttiosuuden. Voit tehdä muutoksia manuaalisesti kirjoittamalla Pisteet-solujen päälle."]
[null,"Kirjoita kukin tehtävä, testi tai koe ja kokonaispistemäärineen soluihin H8–X9."]

{"sheet":"ARVOSANATYÖKIRJA","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],[19,1,19,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,"OPPILAITOKSEN NIMI"]
[null,"Opettajan nimi"]
[{"$nulls":7},"Pisteet",{"$f":"I4*TotalPoints","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Ryhmä/projekti",{"$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,"Vuosi/lukukausi/opetusperiodi",{"$nulls":5},"Kirjainarvos.","I","A","A","B","B","C","C","M","M","E","E","L","L"]
[{"$nulls":7},"Yleisarvos.",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Tehtävän tai testin nimi",null,null,"KT1","KT2","P1"]
[{"$nulls":4},"Maksimipistemäärä",null,null,50,50,100]
[]
[{"$nulls":4},"Tehtävien ja kokeiden lukumäärä:",null,null,{"$f":"COUNTA(H8:X8)","v":3}]
[{"$nulls":4},"Maksimipistemäärät yhteensä:",null,null,{"$f":"SUM(H9:X9)","v":200}]
[]
[null,"Opiskelija","Opiskelijanro","Keskiarvo","Pisteet","Kirjainarvos.","Yleisarvos.","Sarake6","Sarake7","Sarake8","Sarake9","Sarake10","Sarake11","Sarake12","Sarake13","Sarake14","Sarake15","Sarake16","Sarake17","Sarake18","Sarake19","Sarake20","Sarake21","Sarake22"]
[null,"Opiskelijanumero 1",null,{"$f":"IFERROR(IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])/TotalPoints),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]))","v":182},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,3),\"\"),0)","v":"E"},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,4),\"\"),0)","v":3.67},45,45,92]
[null,"Opiskelijanumero 2",null,{"$f":"IFERROR(IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])/TotalPoints),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]))","v":200},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,3),\"\"),0)","v":"L"},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]))","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]))","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Arvosanat[[#This Row],[Sarake6]:[Sarake22]])=0,\"\",SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]))","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Arvosanat[[#This Row],[Keskiarvo]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Keskiarvo]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[]
[null,"Ryhmän yhteenveto",null,"Keskiarvo",null,"Kirjainarvos.","Yleisarvos.","","","","","","","","","","",""]
[null," Keskiarvo",null,{"$f":"IFERROR(AVERAGE(Arvosanat[[#All],[Keskiarvo]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoints,GradeTable,3),\"\")","v":"L"},{"$f":"IFERROR(AVERAGE(Arvosanat[[#All],[Yleisarvos.]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Suurin pistemäärä",null,{"$f":"IFERROR(MAX(Arvosanat[[#All],[Keskiarvo]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoints,GradeTable,3),\"\")","v":"L"},{"$f":"IFERROR(MAX(Arvosanat[[#All],[Yleisarvos.]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Pienin pistemäärä",null,{"$f":"IFERROR(MIN(Arvosanat[[#All],[Keskiarvo]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoints,GradeTable,3),\"\")","v":"E"},{"$f":"IFERROR(MIN(Arvosanat[[#All],[Yleisarvos.]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]