{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["如何使用此活頁簿","成績簿"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"如何使用此活頁簿","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"指示"]
[null,"使用成績簿工作表來計算分數，其中每項作業以分數計分。 "]
[null,"指示： 請務必將成績備份。"]
[null,"1. 填入學校名稱、課程資訊、學生姓名和學生學號 (選填)。   "]
[null,"2. 將 [成績與 GPA] 表格調整為您一般使用的計分系統。"]
[null,"3. 從儲存格 H8 開始填入作業、小考或考試名稱 (如小考 1)，以及每項作業應得的分數。 "]
[null,"4. 在每項作業或考試中，填入每位學生得到的分數。「平均分數」、「分數」、「等級分數」和「GPA」會自動計算，但您可以依需要覆寫這些值。若要獎勵額外的學分，只需在作業中給出的分數多於為該作業列出的總分數。"]
[null,"如果想變更列印內容，可使用 [版面配置] 功能表上的 [列印範圍] 命令。"]
[null,"會根據列 8 和 9 指定的總分數所計算出的標準百分比分數來決定等級分數。調整每項作業或考試的分數，然後再調整適當等級對應的百分比。覆寫 [分數] 儲存格，以手動方式進行變更。"]
[null,"在儲存格 H8 到 X9 中輸入每項作業、小考或考試，以及各項應得的分數。"]

{"sheet":"成績簿","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,"您的學校名稱"]
[null,"教師姓名"]
[{"$nulls":7},"分數",{"$f":"I4*總分","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"課程/專案",{"$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,"學年/學期/學季",{"$nulls":5},"等級分數","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":7},"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"作業或考試名稱",null,null,"作業1","作業2","小考1"]
[{"$nulls":4},"可得總積分",null,null,50,50,100]
[]
[{"$nulls":4},"作業和考試總數：",null,null,{"$f":"COUNTA(H8:AH8)","v":3}]
[{"$nulls":4},"可得總分：",null,null,{"$f":"SUM(H9:AH9)","v":200}]
[]
[null,"學生姓名","學生學號","平均分數","分數","等級分數","GPA","欄6","欄7","欄8","欄9","欄10","欄11","欄12","欄13","欄14","欄15","欄16","欄17","欄18","欄19","欄20","欄21","欄22"]
[null,"學生編號 1",null,{"$f":"IFERROR(IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]])/總分),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]]))","v":182},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,3),\"\"),0)","v":"A-"},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,4),\"\"),0)","v":3.67},45,45,92]
[null,"學生編號...",null,{"$f":"IFERROR(IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]])/總分),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]]))","v":200},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]])/總分),\"\")","v":""},{"$f":"IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]]))","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]])/總分),\"\")","v":""},{"$f":"IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]]))","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]])/總分),\"\")","v":""},{"$f":"IF(COUNT(成績[[#This Row],[欄6]:[欄22]])=0,\"\",SUM(成績[[#This Row],[欄6]:[欄22]]))","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(成績[[#This Row],[平均分數]]<>\"\",HLOOKUP(成績[[#This Row],[平均分數]]*總分,成績表,4),\"\"),0)","v":""}]
[]
[null,"課程摘要",null,"平均分數",null,"等級分數","GPA","","","","","","","","","","",""]
[null," 平均分數",null,{"$f":"IFERROR(AVERAGE(成績[[#All],[平均分數]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*總分,成績表,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(成績[[#All],[GPA]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," 最高分數",null,{"$f":"IFERROR(MAX(成績[[#All],[平均分數]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*總分,成績表,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(成績[[#All],[GPA]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," 最低分數",null,{"$f":"IFERROR(MIN(成績[[#All],[平均分數]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*總分,成績表,3),\"\")","v":"A-"},{"$f":"IFERROR(MIN(成績[[#All],[GPA]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]