{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["集計","レポート","使用方法"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["○○学"]
[null,"問題数",6]
[null,"入力したIDの数",{"$f":"COUNTA(C7:C106)","v":74},null,null,"No dataの数",{"$f":"COUNTIF(E7:E106,\"No data\")","v":0}]
[null,"レポートのデータ数",{"$f":"COUNTA(レポート!A7:A106)","v":74},null,null,"回答数1/2未満の学生数",{"$f":"COUNTA(D7:D106)","v":1}]
[]
["学籍番号","氏名","ID","回答数1/2未満","得点"]
["BXXA001","機械01","1B4DE1",null,3]
["BXXA002","機械02","1B4D60",null,6]
["BXXA003","機械03","1B4D5C",null,4]
["BXXA004","機械04","1B4C91",null,1]
["BXXA005","機械05","1B4CC7",null,1]
["BXXA006","機械06","1B4DB0","×",1,"6問中2問しか解答していない"]
["BXXA007","機械07","1B4DD2",null,2]
["BXXA008","機械08","1B4D52",null,4]
["BXXA009","機械09","1B4D61",null,3]
["BXXA010","機械10","1B4DCB",null,3]
["BXXA011","機械11","1B4C94",null,2]
["BXXA012","機械12","1B4D70",null,2]
["BXXA013","機械13","1B4D53",null,6]
["BXXA014","機械14","1B4D4F",null,1]
["BXXA015","機械15","1B4CE8",null,2]
["BXXA016","機械16","1B4D03",null,2]
["BXXA017","機械17","1B4DAD",null,4]
["BXXA018","機械18","1B4D00",null,4]
["BXXA019","機械19","1B4C8E",null,6]
["BXXA020","機械20","1B4CDF",null,2]
["BXXA021","機械21","1B4D1E",null,4]
["BXXA022","機械22","1B4DD5",null,4]
["BXXA023","機械23","1B4D3A",null,3]
["BXXA024","機械24","1B4DDB",null,4]
["BXXA025","機械25","1B4DCE",null,4]
["BXXA026","機械26","1B4DCD",null,1]
["BXXA027","機械27","1B4CB2",null,2]
["BXXA028","機械28","1B4D10",null,3]
["BXXA029","機械29","1B4CEB",null,2]
["BXXA030","機械30","1B4CA3",null,4]
["BXXA031","機械31","1B4CD9",null,1]
["BXXA032","機械32","1B4C88",null,3]
["BXXA033","機械33","1B4D66",null,6]
["BXXA034","機械34","1B4D51",null,6]
["BXXA035","機械35","1B4C97",null,6]
["BXXA036","機械36","1B4D20",null,5]
["BXXA037","機械37"]
["BXXA038","機械38","1B4DD8",null,2]
["BXXA039","機械39","1B4C7C",null,4]
["BXXA040","機械40","1B4DCC",null,0]
["BXXA041","機械41","1B4CEE",null,4]
["BXXA042","機械42","1B4D3E",null,3]
["BXXA043","機械43","1B4DD6",null,3]
["BXXA044","機械44","1B4D3B",null,6]
["BXXA045","機械45","1B4CCD",null,0]
["BXXA046","機械46","1B4D62",null,3]
["BXXA047","機械47","1B4D5D",null,4]
["BXXA048","機械48","1B4CB8",null,4]
["BXXA049","機械49","1B4D4A",null,2]
["BXXA050","機械50","1B4CF7",null,0]
["BXXA051","機械51","1B4DD4",null,1]
["BXXA052","機械52","1B4DAC",null,5]
["BXXA053","機械53","1B4CA7",null,6]
["BXXA054","機械54","1B4DD7",null,2]
["BXXA055","機械55","1B4D9C",null,6]
["BXXA056","機械56","1B4CBB",null,6]
["BXXA057","機械57","1B4D50",null,2]
["BXXA058","機械58","1B4CE7",null,4]
["BXXA059","機械59","1B4CE4",null,5]
["BXXA060","機械60","1B4CA0",null,5]
["BXXA061","機械61","1B4D4E",null,2]
["BXXA062","機械62"]
["BXXA063","機械63"]
["BXXA064","機械64","1B4D4D",null,2]
["BXXA065","機械65","1B4CFA",null,1]
["BXXA066","機械66","1B4DDA",null,3]
["BXXA067","機械67","1B4CE5",null,4]
["BXXA068","機械68"]
["BXXA069","機械69"]
["BXXA070","機械70","1B4CAF",null,3]
["BXXA071","機械71","1B4DC9",null,4]
["BXXA072","機械72","1B4D02",null,2]
["BXXA073","機械73","1B4DC8",null,3]
["BXXA074","機械74","1B4D13",null,4]
["BXXA075","機械75","1B4CFC",null,3]
["BXXA076","機械76","1B4D1D",null,2]
["BXXA077","機械77","1B4CDB",null,4]
["BXXA078","機械78","1B4D0C",null,2]
["BXXA079","機械79","1B4CEA",null,3]

{"sheet":"レポート","index":1,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,8],[2,0,2,8],[3,0,3,8]]}
["参加者の採点結果を作成する"]
[]
["セッション名: New Session 2010-05-25 16-05"]
["作成済み: 2010/05/27 14:28"]
[null,null,null,null,"前問の再集計",null,null,null,"前問の再集計"]
["デバイス ID","名","姓","1) 以下の内, Si (14族)にAl (13族)をド－プした半導体の電気伝導率s の式として適切なのはどれか?","2) 以下の内, Si (14族)にAl (13族)をド－プした半導体の電気伝導率s の式として適切なのはどれか?","3) 外因性半導体の電気伝導率の温度変化が, ある温度で極大値を持つのはなぜか?","4) pn接合に逆バイアスの電圧を加えた場合, 電流が流れないのはなぜか?","5) 光伝導タイプの可視光センサー用材料として, SiやGeが使用されないのはなぜか?","6) 光伝導タイプの可視光センサー用材料として, SiやGeが使用されないのはなぜか?","合計得点","正解1点、不正解0点 (TurningPointで問題ごとに設定できます)"]
["1B4D3A",null,null,"4 i","2 c","4 c","2 c","2 i","2 i","3","数字の後ろに\"c\"が付いているのは正解",null,null,null,null,null,null,"○"]
["1B4DE1",null,null,"4 i","2 c","4 c","2 c","2 i","2 i","3","数字の後ろに\"i\"が付いているのは不正解",null,null,null,null,null,null,"○"]
["1B4DD8",null,null,"4 i","2 c","1 i","2 c","3 i","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4CC7",null,null,"4 i","4 i","2 i","2 c","3 i","2 i","1",null,null,null,null,null,null,null,"○"]
["1B4C97",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4D51",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4DAC",null,null,"2 c","2 c","3 i","2 c","1 c","1 c","5",null,null,null,null,null,null,null,"○"]
["1B4D5C",null,null,"4 i","2 c","4 c","2 c","1 c","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4D9C",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4DD6",null,null,"2 c","2 c","4 c","1 i","3 i","3 i","3",null,null,null,null,null,null,null,"○"]
["1B4CDB",null,null,"2 c","2 c","4 c","2 c","2 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4CE5",null,null,"2 c","2 c","4 c","2 c","3 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4CEE",null,null,"2 c","2 c","3 i","2 c","3 i","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4CCD",null,null,"4 i","4 i","1 i","1 i","3 i","3 i","0",null,null,null,null,null,null,null,"○"]
["1B4CA0",null,null,"2 c","2 c","4 c","1 i","1 c","1 c","5",null,null,null,null,null,null,null,"○"]
["1B4CE7",null,null,"2 c","2 c","4 c","2 c","3 i","3 i","4",null,null,null,null,null,null,null,"○"]
["1B4D1D",null,null,"4 i","2 c","3 i","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4CDF",null,null,"4 i","4 i","1 i","2 c","1 c","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4DB0",null,null,"4 i","2 c","-","-","-","-","1",null,null,null,null,null,null,null,"○"]
["1B4CA7",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4DDB",null,null,"2 c","2 c","4 c","1 i","3 i","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4DCD",null,null,"4 i","4 i","2 i","2 c","3 i","3 i","1",null,null,null,null,null,null,null,"○"]
["1B4DD4",null,null,"4 i","4 i","2 i","2 c","3 i","3 i","1",null,null,null,null,null,null,null,"○"]
["1B4DC8",null,null,"4 i","2 c","4 c","2 c","2 i","2 i","3",null,null,null,null,null,null,null,"○"]
["1B4CF7",null,null,"4 i","4 i","1 i","1 i","3 i","3 i","0",null,null,null,null,null,null,null,"○"]
["1B4D5D",null,null,"2 c","2 c","4 c","2 c","2 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4C91",null,null,"4 i","4 i","2 i","2 c","3 i","3 i","1",null,null,null,null,null,null,null,"○"]
["1B4CE4",null,null,"2 c","2 c","4 c","1 i","1 c","1 c","5",null,null,null,null,null,null,null,"○"]
["1B4CAF",null,null,"2 c","2 c","4 c","3 i","3 i","2 i","3",null,null,null,null,null,null,null,"○"]
["1B4D53",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4CE8",null,null,"4 i","2 c","3 i","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4D3E",null,null,"2 c","2 c","2 i","2 c","3 i","3 i","3",null,null,null,null,null,null,null,"○"]
["1B4C94",null,null,"4 i","4 i","4 c","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4D62",null,null,"2 c","2 c","4 c","1 i","3 i","3 i","3",null,null,null,null,null,null,null,"○"]
["1B4D3B",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4D66",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4CA3",null,null,"2 c","2 c","4 c","2 c","2 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4D13",null,null,"3 i","2 c","4 c","2 c","2 i","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4D60",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4DD7",null,null,"4 i","4 i","4 c","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4C88",null,null,"3 i","2 c","2 i","2 c","3 i","1 c","3",null,null,null,null,null,null,null,"○"]
["1B4D4E",null,null,"4 i","4 i","-","2 c","1 c","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4DCC",null,null,"4 i","4 i","2 i","5 i","3 i","2 i","0",null,null,null,null,null,null,null,"○"]
["1B4D50",null,null,"3 i","2 c","3 i","2 c","4 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4D61",null,null,"4 i","4 i","2 i","2 c","1 c","1 c","3",null,null,null,null,null,null,null,"○"]
["1B4D4F",null,null,"4 i","4 i","2 i","2 c","3 i","2 i","1",null,null,null,null,null,null,null,"○"]
["1B4CD9",null,null,"4 i","4 i","2 i","2 c","3 i","2 i","1",null,null,null,null,null,null,null,"○"]
["1B4D1E",null,null,"2 c","2 c","3 i","2 c","2 i","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4DAD",null,null,"2 c","2 c","4 c","2 c","2 i","3 i","4",null,null,null,null,null,null,null,"○"]
["1B4D02",null,null,"1 i","2 c","4 c","3 i","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4DC9",null,null,"4 i","4 i","4 c","2 c","1 c","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4D4A",null,null,"4 i","2 c","3 i","2 c","2 i","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4CEB",null,null,"4 i","4 i","4 c","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4C7C",null,null,"2 c","2 c","2 i","2 c","2 i","1 c","4",null,null,null,null,null,null,null,"○"]
["1B4D20",null,null,"2 c","2 c","3 i","2 c","1 c","1 c","5",null,null,null,null,null,null,null,"○"]
["1B4DCE",null,null,"2 c","2 c","4 c","2 c","3 i","3 i","4",null,null,null,null,null,null,null,"○"]
["1B4CB2",null,null,"3 i","2 c","2 i","2 c","3 i","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4C8E",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4CBB",null,null,"2 c","2 c","4 c","2 c","1 c","1 c","6",null,null,null,null,null,null,null,"○"]
["1B4CFA",null,null,"4 i","4 i","1 i","2 c","-","2 i","1",null,null,null,null,null,null,null,"○"]
["1B4DD5",null,null,"2 c","2 c","4 c","2 c","3 i","3 i","4",null,null,null,null,null,null,null,"○"]
["1B4D10",null,null,"2 c","2 c","1 i","2 c","3 i","3 i","3",null,null,null,null,null,null,null,"○"]
["1B4CEA",null,null,"1 i","2 c","2 i","2 c","1 c","2 i","3",null,null,null,null,null,null,null,"○"]
["1B4CFC",null,null,"4 i","4 i","4 c","2 c","2 i","1 c","3",null,null,null,null,null,null,null,"○"]
["1B4D52",null,null,"2 c","2 c","4 c","2 c","2 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4DDA",null,null,"3 i","-","4 c","2 c","3 i","1 c","3",null,null,null,null,null,null,null,"○"]
["1B4DCB",null,null,"4 i","4 i","2 i","2 c","1 c","1 c","3",null,null,null,null,null,null,null,"○"]
["1B4D4D",null,null,"4 i","4 i","3 i","2 c","1 c","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4D03",null,null,"4 i","2 c","1 i","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]
["1B4D00",null,null,"2 c","2 c","4 c","2 c","2 i","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4CB8",null,null,"2 c","2 c","1 i","2 c","1 c","2 i","4",null,null,null,null,null,null,null,"○"]
["1B4DD2",null,null,"4 i","2 c","-","2 c","2 i","3 i","2",null,null,null,null,null,null,null,"○"]
["1B4D0C",null,null,"-","2 c","3 i","2 c","2 i","-","2",null,null,null,null,null,null,null,"○"]
["1B4D70",null,null,"-","4 i","4 c","2 c","2 i","2 i","2",null,null,null,null,null,null,null,"○"]

{"sheet":"使用方法","index":2,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["ID入力"]
[null,"「集計」シートに学籍番号、氏名、リモコンのIDを入力して下さい。"]
[]
["問題数の入力"]
[null,"「集計」シートの「C2」セルに、問題数を入力して下さい。"]
[null,"再集計を行った問題がある場合は、問題数を増やして下さい。"]
[null,null,"Ex. 3問あり、その内1問で再集計を行った場合は、問題数を「4」にして下さい。"]
[]
["レポートの作成"]
[null,"「参加者の結果レポート」→「参加者の採点結果(得点の値)」で作成して下さい。"]
[]
["レポートの貼り付け"]
[null,"「レポート」シートに作成されたレポートを貼り付けてください。"]
[]
["マクロ「集計」を実行する"]
[null,"「集計」シートの「E列」に得点が入力されます。"]
[null,"データが見つからない場合は、「No data」が入力されます。"]
[null,"「レポート」シートの「R列」には、処理したデータに「○」が入力されます。"]
[null,null,"同じIDが複数あった場合は、○が複数入力されます。"]
[null,"回答数が1/2未満の学生が居た場合は、「D列」に「×」が入力されます。"]