In an educational landscape that increasingly demands personalised, efficient, and high-quality assessments, Niall McNulty has an innovative approach. This time, he’s introducing a workflow that brings together structured data, specifically spreadsheets, and the capabilities of ChatGPT’s Code Interpreter to transform how formative assessments are created and implemented in classrooms.
Formative assessments are an ongoing process used by teachers to understand and guide students’ learning. What makes McNulty’s approach so useful is his use of spreadsheets as a roadmap for creating these assessments. These aren’t your typical Excel files, but organised tabs that cover everything from aligning questions with educational standards to crafting question types and ensuring quality assurance. This allows for customisation down to the smallest details, be it short quizzes, homework assignments, or end-of-term tests.
Understanding the Requirements
It all starts with a well-structured spreadsheet. Each tab is designed to guide the question-creation process. From aligning with specific curriculum standards to deciding the difficulty levels based on Bloom’s taxonomy, this spreadsheet serves as the blueprint for the entire operation.
The real magic happens when this spreadsheet is uploaded to ChatGPT’s Code Interpreter. With a detailed prompt, the AI begins the task of generating questions that align with the specific guidelines outlined in the spreadsheet. It’s not just robotic output; it’s customised educational content with a human in the loop that caters to the unique needs of different classrooms.
And it doesn’t end with question generation. Each question is reviewed for accuracy, relevance, and educational soundness. While automated checks take care of grammar and content relevance, human experts ensure alignment with more nuanced educational goals like fostering critical thinking skills. It’s a hybrid model of quality control.
Once the questions have been generated and reviewed, they are formatted according to the selected output types, be it Word or Plain Text. McNulty incorporates rubrics and answer sheets, providing teachers with a complete package ready for classroom implementation.
Teachers are provided with a sophisticated yet user-friendly system that saves time without compromising on the quality of assessments. It’s an approach that lets teachers do what they do best, teach, inspire, and nurture young minds, while technology handles the intricacies of assessment design.