{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["使い方","20問","3回分","得点表"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":5,"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":"row_number_cap","date_system":"1900"}

{"sheet":"使い方","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"＜正の数・負の数の計算アプリの使い方＞"]
[null,null,"このアプリは、中学１年の数学で学習する正の数・負の数の和や差の計算練習をするアプリです。"]
[null,null,"このファイルは生徒全員に配布し、20問シート上部に組、番号、氏名を入力してください。"]
[null,null,"このファイルは、Excelのファイルとして動くものです。初めて起動するときは、次のことをしてください。"]
[null,null,"このアプリ上で右クリック→プロパティ→許可するのボックスにチェックを入れる→OKでプログラムが動きます。"]
[null,null,"使い方は、20問シートを選択し、スタート→次のボタン→解答→〇×→次のボタンの要領で進んでください。"]
[null,null,"このアプリの特徴は練習結果や得点をpdfファイルでデスクトップに出力して提出できるところです。"]
[null,null,"20問目に〇×で採点ができたときに、3回分のシートに解答採点シートがコピーされます。3回分シートに直近3回の"]
[null,null,"解答結果シートがコピーされます。3回を超えると古いデータから上書きされていきます。"]
[null,null,"保存できるのは、3回分シートと得点シートの2種類です。提出するときは、どちらのデータかを確認してください。"]
[null,"＜各ボタンについて＞"]
[null,null,"ボタン名",null,"ボタンをクリックしたときの動き"]
[null,null,"全画面に（解除）",null,"このボタンでエクセルのメニューを非表示にしてから始めてください。"]
[null,null,"スタート",null,"２０問の計算練習を始めるときにクリックします。"]
[null,"20問","10まで（20まで）",null,"10までの数と20までの数の出題の切り替えができます。"]
[null,"シート","次の問題",null,"このボタンで、問題が出題されます。２０問出題されたら、得点が表示されます。"]
[null,null,"○×",null,"採点ボタンです。20問目の採点時にデータを3回分シートにコピーします。"]
[null,null,"テンキー",null,"このボタンをクリックすると、テンキーが表示されてテンキーでの入力ができます。"]
[null,null,"リセット",null,"このボタンですべてのデータを消去し、最初から始めます。"]
[]
[null,null,"3回分の保存",null,"このボタンで3回分のシートデータをデスクトップにpdfで保存します。"]
[null,"３回分",null,null,"ファイル名には、クラス名、出席番号、氏名、記録した月、日、時間がつきます。"]
[null,"シート","印刷",null,"表示シートを印刷します。"]
[null,null,"3回分消去",null,"このボタンで3回分のシートデータを消去します。"]
[]
[null,"得点表","得点データ保存",null,"このボタンで記録シートのデータをデスクトップにpdfで保存します。"]
[null,"シート","印刷",null,"得点シートを印刷します。"]
[null,null,"リセット",null,"採点結果が記録シートに１０回分記録されます。リセットボタンで記録が消去されます。"]
[]
[null,null,"※間違った問題は、訂正はできますが、再度の採点はできません。（×はそのままになります）"]
[]
[null,null,null,null,null,null,null,null,"Copyright","E.B",2023,"11.20"]

{"sheet":"20問","index":1,"n_rows":57,"n_cols":218,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,0,3,1],[7,0,7,1]],"read":"row_number_cap"}
[null,null,"正の数・負の数の計算",null,null,null,null,{"$f":"C33&\"まで\"","v":"20まで"},1,"組",1,"番","　阿波　一郎",null,null,{"$f":"A10","v":1},{"$f":"A10","v":1},{"$f":"TEXT(A9,\"00\") &\"%\"","v":"%"}]
[null,null,"(1)",null,null,null,null,null,null,null,"（11）"]
[null,null,"(2)",null,null,null,null,null,null,null,"（12）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,9]
[null,null,"(3)",null,null,null,null,null,null,null,"（13）"]
[null,null,"(4)",null,null,null,null,null,null,null,"（14）",null,null,null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",H35)","v":""}]
[{"$f":"$B$45","v":0},"問正解","(5)",null,null,null,null,null,null,null,"（15）",null,null,null,null,null,null,null,{"$f":"IF(H36=\"\",\"\",H36)","v":""}]
[{"$f":"$B$47","v":0},"問中","(6)",null,null,null,null,null,null,null,"（16）",null,null,null,null,null,null,null,{"$f":"IF(H37=\"\",\"\",H37)","v":""}]
["正答率",null,"(7)",null,null,null,null,null,null,null,"（17）"]
[{"$f":"IF($A$7=0,\"\",($A$6/$A$7)*100)","v":""},"％","(8)",null,null,null,null,null,null,null,"（18）"]
[{"$f":"$A$54","v":1},"回目","(9)",null,null,null,null,null,null,null,"（19）"]
[null,null,"(10)",null,null,null,null,null,null,null,"（20）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"マイナス"]
[null,5]
[-7,null,0]
[null,null,20]
[]
[0,0]
[]
[]
[]
[]
[1]
[]
[{"$f":"IF(AND(A43>0,A43>E43),\"\",IF(A43<0,\"(\"&A43&\")\",\"(+\"&A43&\")\"))","v":"(+)"},6,{"$f":"IF(AND(A43>0,A43>E43),\"\",\"+\")","v":"+"},null,{"$f":"IF(AND(A43>0,A43>E43),\"\",IF(C43=\"-\",\"(-\"&E43&\")\",\"(+\"&E43&\")\"))","v":"(+)"},{"$f":"IF(AND(A43>0,A43>E43),\"\",\"＝\")","v":"＝"},{"$f":"IF(AND(A43>0,A43>E43),\"\",A32)","v":-7},{"$f":"IF(AND(A43>0,A43>E43),\"\",IF(AND(A43<0,E44<0),\"－\",IF(OR(AND(AND(A43>0,E44<0),A43>ABS(E44)),AND(AND(A43<0,E44>0),ABS(A43)<E44)),\"＋\",\"－\")))","v":"－"},{"$f":"IF(AND(A43>0,A43>E43),\"\",IF(AND(A43<0,E44<0),\"（\"&ABS(A43)&\"+\"&ABS(E44)&\"）＝\",IF(AND(ABS(A43)>ABS(E44)),\"（\"&ABS(A43)&\"－\"&ABS(E44)&\"）＝\",\"（\"&ABS(E44)&\"－\"&ABS(A43)&\"）＝\")))","v":"（0－0）＝"}]
[null,null,null,null,null,null,null,{"$f":"IF(ABS(A43)>ABS(E43),ABS(A43),ABS(E43))","v":0}]
[null,null,null,null,{"$f":"IF(C43=\"-\",E43*(-1),E43)","v":0}]
["正答数→",0]
[null,0]
["出題数→",0]
[]
[]
[]
["q","r"]
[1]
[]
[1]
[]
[]
[1]

{"sheet":"3回分","index":2,"n_rows":57,"n_cols":34,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"計算練習結果",null,null,null,null,null,null,null,{"$f":"R2","v":"11-28-17h20m"},null,null,null,{"$f":"NOW()","v":"2023-11-28T17:20:22.950"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-3,-3,null,null,{"$f":"MONTH(R1)&\"-\"&DAY(R1)&\"-\"&HOUR(R1)&\"h\"&MINUTE(R1)&\"m\"","v":"11-28-17h20m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-18-15h13m"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",-15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",-13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-2,-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"×",5]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,-1,-1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]

{"sheet":"得点表","index":3,"n_rows":54,"n_cols":34,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,9,0,11],[10,1,10,11],[9,1,9,11]],"read":"row_number_cap"}
[null,"得点表",{"$f":"'20問'!I1","v":1},"組",{"$f":"'20問'!K1","v":1},"番","氏名",{"$f":"'20問'!M1","v":"　阿波　一郎"},null,{"$f":"N2","v":"11-28-17h20m"},null,null,null,{"$f":"NOW()","v":"2023-11-28T17:20:22.950"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MONTH(N1)&\"-\"&DAY(N1)&\"-\"&HOUR(N1)&\"h\"&MINUTE(N1)&\"m\"","v":"11-28-17h20m"}]
[null,null,"１回目","２回目","３回目","４回目","５回目","６回目","７回目","８回目","９回目","１０回目",null,"11-18-15h18m"]
[null,"正解数",{"$f":"IF(C25=\"\",\"\",C25)","v":""},"","","","","","","","",""]
[null,"問中",{"$f":"IF(C26=\"\",\"\",C26)","v":""},"","","","","","","","",{"$f":"IF(L26=\"\",\"\",L26)","v":""}]
[null,"正答率(％)",{"$f":"IF(C27=\"\",\"\",C27)","v":""},"","","","","","","","",""]
[]
[]
[]
[null,"間違いやすい計算などについてかきましょう。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,9,13,16,1,2,1,null,14,1,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,20,20,20,20,20,20,20,null,20,20,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,45,65,80,5,10,5,null,70,5,null,null,null,null,45]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]