Evaluation and Reflection, News and Events, Pedagogy, Technologies

Exploring the Digital Frontier: Revolutionizing Feedback Delivery with Excel and VBA Macros Part 2

Part 2: My experience and reflections

Part 1 of this blog can be found here: https://blogs.kcl.ac.uk/digitaleducation/exploring-the-digital-frontier-revolutionizing-feedback-delivery-with-excel-and-vba-macros-part-1/

Icons of the Microsoft 365 shown

I embarked on this journey to a few years ago when I led a large course with more than 700 students and a team of 15 markers. It was a challenging for an early career lecturer to manage the administrative tasks and collaborate with the whole team: standardization, moderation, and uploading/creating feedback documents. The demanding nature of the courses allows for no mistakes or human errors. Working through the clunky and often user-unfriendly interface of Moodle/Turnitin is another difficult obstacle: one would require the Internet to do the marking and as some other colleagues would agree that we often work better off the Internet. Traditional methods were often time-consuming and inconsistent, resulting in delayed feedback that left students wanting more. The technology-driven solution aimed to address these challenges head-on. When I joined KCL in September 2022, I faced the same problems and have been made aware of different initiatives at KBS to improve the feedback and assessment process at KBS. I gathered my own systems over the years and implemented the process during the Jan 2023 marking season. Over the Spring Term 2023, I refined the process with feedback from colleagues who shared the excitements and interest. In June 2023, I presented at the festival to share the practices and implementation strategies for an innovative automation system.

The process involved harnessing the power of Microsoft Excel and VBA Macros within Microsoft Word. These technologies allowed us to streamline and automate feedback delivery. Imagine, no more laborious hours spent typing feedback comments and no human errors involved in exporting and uploading the feedback documents to Keats/Turnitin! Instead, we could focus on providing students with valuable insights to help them excel.

Screenshot of Digital Skills Hub

**Challenges Faced:**

Of course, no transformative journey is without its challenges. Some educators were initially resistant to change, finding the prospect of learning VBA Macros daunting. Additionally, ensuring the new system was compatible with various devices and platforms presented a technical hurdle. As I mentioned in the guidance (see from my SharePoint), the set-up and troubleshooting at the beginning can be quite a challenge, particularly for colleagues using the MacOS system (it’s less so for Windows users). Compatibility issues were addressed through rigorous testing and continuous monitoring of system performance. Clear communication with your marking team is also needed to make sure everyone is on the same page with the new system.

But I promise it’s worth the effort and the subsequential usages will be a much smoother sail. And from a marker’s perspective, it is much less work than working through the traditional channels.

The journey from traditional feedback systems to an automated approach using Excel and VBA Macros has been nothing short of transformative. It’s a testament to the power of technology in education, where innovative solutions can overcome challenges and improve the overall learning experience.

As we continue this path of exploration and adaptation, the future of feedback delivery looks brighter than ever to improved student satisfaction and educational outcomes. I hope that a wider adoption of the process could help deliver a more insightful and time effective feedback to our students, thereby addressing the burning issues identified from the student surveys, as well as helping deliver impacts to the quality of feedback giving and student experience, as identified in King’s Vision 2029 and the TEF framework.

Screenshot of TEF award

It takes time and communications with colleagues to identify compatibility issues and resolve them. So far, the method has been used by six Economics courses at KBS, two from the University of Glasgow; and colleagues from Marketing and Adult Nursing, have expressed their interests in using it in their courses.
It is definitely not perfect, and I am very much looking forward to feedback, comments, and of course successful implementations of colleagues.

The blog discusses a transformative journey in education, initiated during The Festival of Technology 2022 at KCL. It explores the adoption of Excel and VBA Macros within Microsoft Word to revolutionize feedback delivery. The main reasons for this change were to enhance feedback quality and efficiency, addressing challenges like resistance to change and compatibility issues. Through workshops, ongoing support, and rigorous testing, the adoption of technology resulted in a more efficient, user-friendly, and collaborative feedback system, empowering educators and improving the overall learning experience.

I would like to thank KBS colleagues, Jack Fosten, Dragos Radu, and Chahna Gonsalves for their encouragement, important suggestions and feedback as well as allowing me to pilot the process in their modules. I also thank various colleagues across other faculties for providing feedback and suggestions as well as identifying compatibility issues (with solutions).

For additional resources, including the workshop slides and a detailed guide with relevant codes and FAQs, please refer to the SharePoint folder linked here.

I am a Lecturer in Economics at the Department of Economics, King’s Business School, King’s College London. I am also an academic supervisor at the Institute of Finance and Technology, University College of London, and a chief examiner for the University of London International Programme (Econometrics). Before joining King’s, I lectured and conducted research at the London School of Economics as an LSE Fellow in Economics, and at the University of Warwick as a postdoctoral fellow (in Economics). I completed my PhD in Economics at the University of Nottingham in 2018.

I have lectured courses in econometrics and macroeconomics at King’s, LSE, and Warwick, and led seminars (tutorials) in various courses at Nottingham. From March 2023, I am the GTA Lead at King’s Business School.

Evaluation and Reflection, News and Events, Pedagogy, Technologies

Exploring the Digital Frontier: Revolutionizing Feedback Delivery with Excel and VBA Macros Part 1

Part 1: The practical guide

In today’s rapidly evolving digital age, the need for efficient and effective systems in education is more pronounced than ever. Traditional platforms like Moodle and Turnitin have served us well, but as educators, we must acknowledge their limitations in providing timely, user-friendly, and collaborative feedback on assignments, exams, and dissertations.

This tutorial aims to be your guiding light towards a better, more streamlined approach to feedback delivery. Drawing upon my workshop presented during The Festival of Technology 2022 at KCL, where I shared practical insights and implementation strategies for this automation system, we’ll delve into the fascinating world of Excel and VBA Macros within Microsoft Word. This comprehensive resource builds upon the principles discussed in that workshop.

By embarking on this journey, you’ll equip yourself with the skills and knowledge to revolutionize your approach to feedback giving. Here’s what you stand to gain:

1. **Efficiency:** Say goodbye to the laborious and time-consuming task of manually providing feedback using KEATs (Moodle/Turnitin). With Excel and VBA Macros, you’ll learn how to automate the process, saving valuable time that can be redirected towards more meaningful feedback and interactions with your students.


Screenshot illustrating what the purpose of the document
Picture 1: Our Aims and Objectives

2. **User-friendliness:** Discover how to create a user-friendly feedback documents for both yourself, the marking team, and your students. Your feedback system will become intuitive and accessible, ensuring that learners can easily understand and act upon your comments with a nicely formatted feedback document.

A screenshot showing the step by step summary for collecting marking and feedback
Picture 2: A summary of steps

3. **Collaboration:** Break free from the constraints of limited collaboration within traditional systems. The method will allow a marking team to efficiently collaborate and moderate, making feedback delivery a seamless and cooperative effort.

Screenshot of marking folder contents
Picture 3: What the marking folder looks like? It is sharable with the marking team

4. **Comprehensive Feedback:** Dive into the world of detailed and constructive feedback. You’ll gain the expertise to provide tailored insights that empower students to excel in their academic pursuits.

Screenshot of excel file showing comments
Picture 4: What a short comment looks like? Totally customizable.

This tutorial isn’t just about learning a new tool; it’s about transforming your approach to education. By mastering Excel and VBA Macros for feedback delivery, you’ll become a more effective educator, making a lasting impact on your students. The system will:
– Enhance your teaching methods, creating a more engaging and supportive learning environment.
– Free up your time that was spent on administrative tasks or dealing with Turnitin/Keats for more meaningful activities such as preparing feedback comments and communication with your team and students.
– For repeated courses/assessments, you can prepare a bank of modal comments for lateral uses, as well as a record of common mistakes and suggestions for improvements to communicate with students.

Screenshot of excel sheet
Picture 5: What the end product of a long feedback document looks like? Totally customizable.

Education is a dynamic field, and keeping pace with technological advancements is essential. The automation possibilities offered by Excel and VBA Macros are not just practical but also intriguing. Discovering how to harness these tools to optimize your feedback process can be genuinely exciting.

Screenshot displaying cautions with using excel
Picture 6: A few cautions?

For additional resources, including the workshop slides and a detailed guide with relevant codes and FAQs, please refer to the SharePoint folder linked here. This tutorial serves as a bridge between the insights shared during the workshop and the practical implementation of an automated feedback system. It’s an opportunity to further explore and master these valuable techniques, all while enhancing the overall learning experience for students. Join us as we embark on this transformative journey together.

Part 2 of this blog can be found here: https://blogs.kcl.ac.uk/digitaleducation/exploring-the-digital-frontier-revolutionizing-feedback-delivery-with-excel-and-vba-macros-part-2/