RT Journal Article
T1 Automating Excel Tasks with Generative AI: Supporting Innovation in Mass Transfer Separations Education
A1 García Morales, Moisés
K1 Upper-Division Undergraduate
K1 Chemical Engineering
K1 Computer-Based Learning
K1 Mathematics/Symbolic Mathematics
K1 Separation Science
AB VBA (Visual Basic for Applications) macro creation assisted by AI (Artificial Intelligence) can enhance the teaching of Mass Transfer Separations. The code can be iteratively refined until the desired functionality is achieved. This is not only intended to improve computational efficiency and accuracy but also to boost student engagement. To showcase the full potential of VBA scripting within spreadsheets, a simulator with an appealing interface was designed using Excel, such that optimal and limiting operating conditions were identified in an equilibrium-staged distillation column. Moreover, to underscore the pedagogical value of the approach at this exploratory stage of evaluating its educational scope, a much simpler classroom exercise was used to illustrate the hands-on integration of GenAI (Generative AI) into the learning process.
PB American Chemical Society
SN 0021-9584
YR 2026
FD 2026
LK https://hdl.handle.net/10272/27914
UL https://hdl.handle.net/10272/27914
LA eng
NO García-Morales, M. (2026). Automating Excel Tasks with Generative AI: Supporting Innovation in Mass Transfer Separations Education. Journal of Chemical Education. https://doi.org/10.1021/acs.jchemed.5c01531. "This document is the Accepted Manuscript version of a Published Article that appeared in final form in Journal of Chemical Education, copyright © 2026 ACS Publications. All rights reserved. To access the final published article, see ACS Articles on Request."
NO El artículo presenta cómo el uso de macros en VBA asistidas por inteligencia artificial puede mejorar la enseñanza de las operaciones de transferencia de materia. Mediante la creación y refinamiento iterativo del código, se busca no solo aumentar la eficiencia y precisión de los cálculos, sino también incrementar la participación del alumnado. Para demostrar su potencial, se desarrolló en Excel un simulador con interfaz atractiva capaz de analizar condiciones óptimas y límites en una columna de destilación por etapas de equilibrio. Además, se empleó un ejercicio más sencillo en el aula para mostrar cómo la IA generativa puede integrarse de forma práctica en el proceso de aprendizaje."This document is the Accepted Manuscript version of a Published Article that appeared in final form in Journal of Chemical Education, copyright © 2026 ACS Publications. All rights reserved. To access the final published article, see ACS Articles on Request."
DS Repositorio Institucional de la Universidad de Huelva
RD 1 jun 2026