{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TÄMÄN TYÖKIRJAN KÄYTTÄMINEN","ARVOSANATYÖKIRJA"],"not_rendered":{"defined_names":5},"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ä oppilaitoksen nimi, ryhmän tiedot, oppilaiden nimet ja opiskelijanumerot (valinnainen).   "]
[null,"2. Säädä Arvosanat ja yleisarvosana -taulukko arviointijärjestelmän mukaiseksi."]
[null,"3. Täytä solusta G7 alkaen tehtävien tai testien nimet ja jokaisen prosenttiarvo (esimerkiksi \"Lopullinen\" ja \"50 %\"). "]
[null,"4. Kirjoita opiskelijoiden jokaisesta tehtävästä tai kokeesta saamat pistemäärät. Pistemäärä-, Kirjainarvosana- ja Yleisarvosana-sarakkeet lasketaan automaattisesti, mutta voit myös ohittaa ne. Arvosanojen laskentatavan takia keskiarvo ja lopullinen arvosana ovat epätäydellisiä, kunnes kaikki pisteet on saatu."]
[null,"Sivun asettelu -valikon Tulostusalue-komennolla voit määrittää tulostettavan alueen."]
[null,"Pistemäärä-, Kirjainarvosana- ja Yleisarvosana eivät ole päteviä, ennen kuin testien ja tehtävien valmistumisprosentti on 100 %. "]
[null,"Kirjoita jokainen tehtävä tai testi ja sen prosenttiosuus kokonaisarvosanasta soluihin G7–W8."]

{"sheet":"ARVOSANATYÖKIRJA","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,"OPPILAITOKSEN NIMI"]
[]
[{"$nulls":6},"Pisteet",{"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},"Kirjainarvos.","P","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"Yleisarvos.",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Opettajan nimi"]
[null,"Kurssi/projekti",null,null,"Tehtävän tai testin nimi"]
[null,"Vuosi/lukukausi/opetusperiodi",null,null,"Prosenttiluku (summan pitäisi olla 100 %)"]
[{"$nulls":4},{"$f":"\"Prosenttiosuus yhteensä: \"&SUM(G8:W8)*100&\"%\"","v":"Prosenttiosuus yhteensä: 0%"}]
[null,"Oppilaan nimi","Oppilaan tunnusnumero","Pisteet","Kirjainarvos.","Yleisarvos.","Sarake6","Sarake7","Sarake8","Sarake9","Sarake10","Sarake11","Sarake12","Sarake13","Sarake14","Sarake15","Sarake16","Sarake17","Sarake18","Sarake19","Sarake20","Sarake21","Sarake22"]
[{"$nulls":3},{"$f":"(IF(SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),ROUND(SUMPRODUCT($G$8:$W$8,Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),2),\"\"))","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,2),\"\")","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),ROUND(SUMPRODUCT($G$8:$W$8,Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),2),\"\"))","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,2),\"\")","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),ROUND(SUMPRODUCT($G$8:$W$8,Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),2),\"\"))","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,2),\"\")","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),ROUND(SUMPRODUCT($G$8:$W$8,Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),2),\"\"))","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,2),\"\")","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),ROUND(SUMPRODUCT($G$8:$W$8,Arvosanat[[#This Row],[Sarake6]:[Sarake22]]),2),\"\"))","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,2),\"\")","v":""},{"$f":"IF(Arvosanat[[#This Row],[Pisteet]]<>\"\",HLOOKUP(Arvosanat[[#This Row],[Pisteet]],GradeTable,3),\"\")","v":""}]
[]
[null,"Kurssin yhteenveto",null,"Pisteet","Kirjainarvos.","Yleisarvos.","","","","","","","","","","",""]
[null," Keskiarvo",null,{"$f":"IFERROR(AVERAGE(Arvosanat[[#All],[Pisteet]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,GradeTable,2),\"\")","v":"P"},{"$f":"IFERROR(AVERAGE(Arvosanat[[#All],[Yleisarvos.]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Suurin pistemäärä",null,{"$f":"IFERROR(MAX(Arvosanat[[#All],[Pisteet]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,GradeTable,2),\"\")","v":"P"},{"$f":"IFERROR(MAX(Arvosanat[[#All],[Yleisarvos.]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Pienin pistemäärä",null,{"$f":"IFERROR(MIN(Arvosanat[[#All],[Pisteet]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,GradeTable,2),\"\")","v":"P"},{"$f":"IFERROR(MIN(Arvosanat[[#All],[Yleisarvos.]]),0)","v":0},"","","","","","","","","","","","","","","","",""]