• Home
  • Search
  • ChatGPT 's Performance Evaluation in Spreadsheets Modelling to Inform Assessments Redesign
  • https://doi.org/10.1111/jcal.70035Copy DOI Icon

ChatGPT 's Performance Evaluation in Spreadsheets Modelling to Inform Assessments Redesign

Show More
  • Abstract
  • Literature Map
  • References
  • Similar Papers
Abstract

ABSTRACT Background Increasingly, students are using ChatGPT to assist them in learning and even completing their assessments, raising concerns of academic integrity and loss of critical thinking skills. Many articles suggested educators redesign assessments that are more ‘Generative‐AI‐resistant’ and to focus on assessing students on higher order thinking skills. However, there is a lack of articles that attempt to quantify assessments at different cognitive levels to provide empirical study insights on ChatGPT's performance at different levels, which will affect how educators redesign their assessments. Objectives Educators need new information on how well ChatGPT performs to redesign future assessments to assess their students in this new paradigm. This paper attempts to fill the gap in empirical research by using spreadsheet modelling assessments, tested using four different prompt engineering settings, to provide new knowledge to support assessment redesign. Our proposed methodology can be applied to other course modules for educators to achieve their respective insights for future assessment designs and actions. Methods We evaluated the performance of ChatGPT 3.5 on solving spreadsheets modelling assessment questions with multiple linked test items categorised according to the revised Bloom's taxonomy. We tested and compared the accuracy performance using four different prompt engineering settings namely Zero‐Shot‐Baseline (ZSB), Zero‐Shot‐Chain‐of‐Thought (ZSCoT), One‐Shot (OS), and One‐Shot‐Chain‐of‐Thought (OSCoT), to establish how well ChatGPT 3.5 tackled technical questions of different cognitive learning levels for each prompt setting, and which prompt setting will be effective in enhancing ChatGPT's performance for questions at each level. Results We found that ChatGPT 3.5 was good up to Level 3 of the revised Bloom's taxonomy using ZSB, and its accuracy decreased as the cognitive level increased. From Level 4 onwards, it did not perform as well, committing many mistakes. ZSCoT would achieve modest improvements up to Level 5, making it a possible concern for instructors. OS would achieve very significant improvements for Levels 3 and 4, while OSCoT would be needed to achieve very significant improvement for Level 5. None of the prompts tested was able to improve the response quality for level 6. Conclusions We concluded that educators must be cognizant of ChatGPT's performance for different cognitive level questions, and the enhanced performance from using suitable prompts. To develop students' critical thinking abilities, we provided four recommendations for assessment redesign which aim to mitigate the negative impact on student learning and leverage it to enhance learning, considering ChatGPT's performance at different cognitive levels.

Similar Papers
  • Research Article
  • Citations10

Practicing Contextual Teaching and Learning Approach to Enhance Students’ Higher Order Thinking Skill on Writing Ability

  • Dec 20, 2022
  • Elsya : Journal of English Language Studies
  • Muhammad Wildan Hakim +1
  • PDF
  • Research Article
  • Citations1

Evaluation of the cognitive level of essay questions of an undergraduate medical program in Sri Lanka, using bloom’s taxonomy

  • Jun 30, 2018
  • Sri Lanka Journal of Medicine
  • Deepthika Himali Edussuriya +3
  • Research Article

The Effect of the Discovery Learning Model on Student Higher Order Thinking Skills on Buffer Solution Material

  • Jun 29, 2025
  • Orbital: Jurnal Pendidikan Kimia
  • Miterianifa +3
  • Research Article

Pemanfaatan Teknik SCAMPER dalam Meningkatkan HOTS (High Order of Thinking Skills) pada Mata Kuliah Pengembangan Materi Ajar Bahasa dan Sastra Indonesia Mahasiswa Universitas Muhammadiyah Bulukumba

  • Jan 20, 2021
  • Jurnal Ilmiah Telaah
  • Andi Alfina Listya Ningrum +1
  • Research Article
  • Citations63

Developing Higher Order Thinking Skills and Team Commitment via Group Problem Solving: A Bridge to the Real World

  • Dec 01, 2012
  • Procedia - Social and Behavioral Sciences
  • Phawani Vijayaratnam
  • Research Article
  • Citations4

The analysis of the implementation of multi techniques based learning media in improving the elementary school students’ higher order thinking skill in solving exponential problem

  • Jun 01, 2020
  • Journal of Physics: Conference Series
  • L Masruroh +2
  • Research Article

Effect of Concept Attainment Model (CAM) Based Teaching on Prospective Teachers’ Higher Order Thinking Skills

  • Feb 03, 2026
  • Journal for Social Science Archives
  • Asma Khalid +1
  • Research Article
  • Citations1

Relationship between Thinking Styles and Higher Order Thinking Skills

  • Feb 22, 2021
  • SHILAP Revista de lepidopterología
  • Asma Mumtaz +2
  • Conference Article
  • Citations3

The Realization of Higher Order Thinking Skills in English School Nationally Standardized Examination at State Senior High School 6 Semarang

  • Jan 01, 2020
  • Nanang Narwianta +2
  • Research Article
  • Citations10

An Evaluation of TEFL Postgraduates’ Testing Classroom Activities and Assignments Based on Bloom's Revised Taxonomy

  • Apr 05, 2016
  • Theory and Practice in Language Studies
  • Hassan Soleimani +1
  • Research Article
  • Citations3

E-learning and higher order thinking: Impact of STEM-based approach

  • Jul 14, 2023
  • Psychology Evaluation and Technology in Educational Research
  • Abdul Rahman +4
  • Research Article

UPAYA MENINGKATKAN HIGHER ORDER THINKING SKILLS (HOTS) PESERTA DIDIK MELALUI PENERAPAN MODEL PEMBELAJARAN PROBLEM BASED LEARNING PADA MATA PELAJARAN IPS

  • Aug 18, 2025
  • SOCIAL Jurnal Inovasi Pendidikan IPS
  • Dian Saputra +2
  • Research Article
  • Citations1

DESAIN PENYAJIAN MATERI PERSAMAAN GARIS LURUS DI SMP BERORIENTASI KETERAMPILAN BERPIKIR TINGKAT TINGGI

  • Dec 31, 2020
  • Media Pendidikan Matematika
  • Ibrahim Ibrahim
  • Research Article
  • Citations1

THE EFFECT OF DISCOVERY LEARNING MODEL TOWARD STUDENT HIGHER ORDER THINKING SKILLS IN DYNAMIC ELECTRICITY SUBJECT MATTER AT SMA RAKSANA MEDAN ACADEMIC YEAR 2014/2015

  • Feb 01, 2016
  • INPAFI (Inovasi Pembelajaran Fisika)
  • Kristin Natalia Tondang +1
  • Research Article
  • Citations1

PENINGKATAN HIGHER ORDER THINKING SKILLS (HOTS) MAHASISWA DENGAN MENGGUNAKAN MODEL SELF DIRECTED LEARNING (SDL) PADA MATA KULIAH PENGEMBANGAN PROFESI GURU

  • Feb 29, 2024
  • BIOPENDIX: Jurnal Biologi, Pendidikan dan Terapan
  • Marike Muskitta
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.