{"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.学校名、クラスの情報、学生の名前、学生の ID (省略可能) を入力します。"]
[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,"HW1","HW2","Q1"]
[{"$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,"学生の名前","学生 ID","平均","スコア","レター グレード","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,"学生番号 2",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},"","","","","","","","","","","","","","","","",""]