J. Technology and Education, Vol.15, No.1, pp.27-30, 2008

教育論文

授業への復習時間，小テスト，順位付けとその効果(1)

〜教員支援マクロの開発と化学Iへの適用

　

城石　英伸^*1，大野　秀樹²，松本　章代³

東京工業高等専門学校，¹物質工学科，²物理学科，³情報工学科

^*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 Shiroishi¹, Hideki Ohno², Akiyo Matsumoto³

Departments of ¹Chemical Science and Engineering, ²Physics, and ³Computer 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