J. Technology and Education, Vol.15, No.1, pp.27-30, 2008
教育論文
授業への復習時間,小テスト,順位付けとその効果(1)
〜教員支援マクロの開発と化学Iへの適用
 
城石 英伸*1,大野 秀樹2,松本 章代3
東京工業高等専門学校,1物質工学科,2物理学科,3情報工学科
*h-shiroishi@tokyo-ct.ac.jp
 
Effects of Short Self-review Time, Short Test, and Printing a Score Ranking in the Test (1)? Development of Macro Programs for Teachers and Application to Chemistry I
Hidenobu Shiroishi1, Hideki Ohno2, Akiyo Matsumoto3
Departments of 1Chemical Science and Engineering, 2Physics, and 3Computer Science
Tokyo National College of Technology (Kunugida 1220-2, Tokyo 193-0997, Japan)
 
(Received April 8, 2008; Accepted June 6, 2008)
 
  We gave a short test in every class of Chemistry I after 5 ? 10 minutes of a self-review time, and printed the score ranking and a deviation score in the header of their tests before we returned their tests the next week. We developed two programs written by the Excel VBA for doing it easily: 1) A program for changing a test with its answer to that with no answer. 2) A program for printing a ranking and a deviation score in the header of every test. Students answered the printing of a ranking and a deviation score in the affirmative. The scores of the students with these tests are higher than those without them.
Keywords: a short self-review time, a short test, printing their ranking, VBA macro, Chemistry I