As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

Effective observation and diagnosis of student learning can be greatly assisted by 21st century technologies. This article lists five practical tools to help educators measure student progress: (1) Clickers; (2) Online quizzes; (3) Web-based surveys; (4) Digital logs; and (5) Spreadsheets.

Spreadsheets can be a powerful tool when it comes to teaching physics. From data analysis and graphing to animated simulations, Excel[R] is a very versatile program for the educator and learner alike. This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS,…

Discusses multiple choice questions and presents a statistical approach to post-test correction for guessing that can be used in spreadsheets to automate the correction and generate a grade. Topics include the relationship between the learning objectives and multiple-choice assessments; and guessing correction by negative marking. (LRW)

Describes a teacher support system which is a computer-based workstation that provides support for teachers and administrators by integrating teacher utility programs, instructional management software, administrative packages, and office automation tools. Hardware is described and software components are explained, including database managers,…