{"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(\"第 \" &_xlfn.RANK.EQ(VLOOKUP(B8,StudentData[],5,FALSE),StudentData[獲得總分]) & \" 名 (共 \" &COUNTA(StudentData[學生姓名]) & \" 位學生)\",\"\")","v":"第 2 名 (共 3 位學生)"},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,"在下表輸入各成績等級的百分比範圍，以自訂成績標準範本。"]
[]
[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 必須以遞增順序輸入。"]