JALT2025 - Tokyo

Rubric Grading Made Easy with Excel Drop-Down Menus

Nov 2, 2025, 1:45 PM

1h

National Olympics Memorial Youth Center / 国立オリンピック記念青少年総合センター

Practice-oriented Workshop (60-minutes) Materials and Assessment Room 509

Speakers

Mellisa Ogasawara (Aomori University of Health and Welfare)Mr Chris Horne (Aomori University of Health and Welfare)Mr Travis Emery (Aomori University of Health and Welfare)

Description

This workshop demonstrates how to create Excel-based rubrics using drop-down menus for efficient and consistent assessment. Participants will learn to set up drop-downs for selecting scores and pre-written feedback comments, streamlining grading while improving feedback clarity. This method reduces workload and enhances standardisation. The session includes hands-on practice, so attendees should bring a device with Excel installed.

Summary

This workshop demonstrates how to create Excel-based rubrics using drop-down menus for efficient and consistent assessment. Participants will learn to set up drop-downs for selecting scores and pre-written feedback comments, streamlining grading while improving feedback clarity. This method reduces workload and enhances standardisation. The session includes hands-on practice, so attendees should bring a device with Excel installed.

Presentation materials

1 Instruction Manual.pdf

2 Use Lastest Excel Version - Example Rubric for Editing.xlsx

3 Use Lastest Desktop Excel Version - End Result Example.xlsx