{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["評価表","生徒のデータ","評価基準"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":"評価表","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"クラス名"]
[null,"担任名",null,null,null,"課題の日付","2011-01-18","2011-01-25","2011-02-01"]
[null,null,null,null,"最大合計点",{"$f":"SUM(TotalAssignmentPoints[#Data])","v":90},20,20,50]
[null,"生徒名","成績","評価","%","合計点","授業のレポート作成 1","授業のレポート作成 2","論述課題草稿"]
[null,"生徒 1",{"$f":"StudentData[[#This Row],[合計点]]","v":90},{"$f":"IFERROR(VLOOKUP(StudentData[[#This Row],[%]],GradeTable[],2,TRUE),\"\")","v":"A+"},{"$f":"IFERROR(StudentData[[#This Row],[合計点]]/TotalPoints,\"\")","v":1},{"$f":"IFERROR(SUM(StudentData[[#This Row],[授業のレポート作成 1]]:OFFSET(F5,,COUNTA(TotalAssignmentPoints[]))),\"\")","v":90},20,20,50]
[null,"生徒 2",{"$f":"StudentData[[#This Row],[合計点]]","v":60},{"$f":"IFERROR(VLOOKUP(StudentData[[#This Row],[%]],GradeTable[],2,TRUE),\"\")","v":"D"},{"$f":"IFERROR(StudentData[[#This Row],[合計点]]/TotalPoints,\"\")","v":0.66666666666666663},{"$f":"IFERROR(SUM(StudentData[[#This Row],[授業のレポート作成 1]]:OFFSET(F6,,COUNTA(TotalAssignmentPoints[]))),\"\")","v":60},10,10,40]
[null,"生徒 3",{"$f":"StudentData[[#This Row],[合計点]]","v":75},{"$f":"IFERROR(VLOOKUP(StudentData[[#This Row],[%]],GradeTable[],2,TRUE),\"\")","v":"B"},{"$f":"IFERROR(StudentData[[#This Row],[合計点]]/TotalPoints,\"\")","v":0.83333333333333337},{"$f":"IFERROR(SUM(StudentData[[#This Row],[授業のレポート作成 1]]:OFFSET(F7,,COUNTA(TotalAssignmentPoints[]))),\"\")","v":75},20,15,40]
[null,"平均評価/スコア",null,{"$f":"IFERROR(VLOOKUP(StudentData[[#Totals],[%]],GradeTable[],2,TRUE),\"\")","v":"B"},{"$f":"SUBTOTAL(101,StudentData[%])","v":0.83333333333333337},{"$f":"SUBTOTAL(101,StudentData[合計点])","v":75},{"$f":"SUBTOTAL(101,StudentData[授業のレポート作成 1])","v":16.666666666666668},{"$f":"SUBTOTAL(101,StudentData[授業のレポート作成 2])","v":15},{"$f":"SUBTOTAL(101,StudentData[論述課題草稿])","v":43.333333333333336}]

{"sheet":"生徒のデータ","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,1,7,3],[11,1,11,2],[35,1,44,7],[0,0,0,4]]}
["学校名"]
[null,{"$f":"TeacherName","v":"担任名"}]
[null,{"$f":"ClassName","v":"クラス名"}]
[null,"これまでの成績"]
[null,"2011-09-22"]
[]
[null,"生徒名:"]
[null,"生徒 3"]
[]
[]
[null,"生徒の順位",null,"評価","達成率","生徒の点数","合計点","GPA"]
[null,{"$f":"IFERROR(COUNTA(StudentData[生徒名]) & \" 人中 \" &_xlfn.RANK.EQ(VLOOKUP(B8,StudentData[],5,FALSE),StudentData[合計点]) & \" 番 \",\"\")","v":"3 人中 2 番 "},null,{"$f":"IFERROR(VLOOKUP(StudentName,StudentData[],3,FALSE),\"\")","v":"B"},{"$f":"IFERROR(VLOOKUP(StudentName,StudentData[],4,FALSE),\"\")","v":0.83333333333333337},{"$f":"IFERROR(VLOOKUP(StudentName,StudentData[],5,FALSE),\"\")","v":75},{"$f":"TotalPoints","v":90},{"$f":"IFERROR(VLOOKUP(E12,GradeTable[],3,TRUE),\"\")","v":3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"教師のコメント"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"保護者の署名 (必要な場合)"]
[]
[]
[null,"X",null,null,null,"日付: "]

{"sheet":"評価基準","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,3],[2,1,2,4]]}
[null,"評価の計算"]
[]
[null,"下の表で各評価の達成率の範囲を入力し、テンプレートを評価基準に合わせて\nカスタマイズします。"]
[]
[null,"評価および GPA 表\n(評価表で生徒の評価を計算するための表です)"]
[null,"スコア (達成率)","評価","GPA"]
[null,0,"F",0]
[null,0.6,"D-",0.67]
[null,0.63,"D",1]
[null,0.67,"D+",1.33]
[null,0.7,"C-",1.67]
[null,0.73,"C",2]
[null,0.77,"C+",2.33]
[null,0.8,"B-",2.67]
[null,0.83,"B",3]
[null,0.87,"B+",3.33]
[null,0.9,"A-",3.67]
[null,0.93,"A",4]
[null,0.97,"A+",4]
[null,"スコア (達成率) と GPA は昇順で入力してください。"]