Uso combinado de VBA y Solver de Excel para la realización de ejercicios de optimización en ficheros Excel fácilmente evaluables
[EN] The present study is focused on the exploitation of the potential of VBA and Solver tools of Excel during the execution of a computer practice lesson within the subject of “Analysis and simulation of processes” corresponding to the bachelor’s degree of Chemical Engineering. VBA was used to desi...
| Autores: | , , , , |
|---|---|
| Tipo de recurso: | capítulo de libro |
| Fecha de publicación: | 2019 |
| País: | España |
| Institución: | Universitat Politècnica de València (UPV) |
| Repositorio: | RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia |
| Idioma: | español |
| OAI Identifier: | oai:riunet.upv.es:10251/128450 |
| Acceso en línea: | https://riunet.upv.es/handle/10251/128450 |
| Access Level: | acceso abierto |
| Palabra clave: | Educación superior Enseñanza superior Tecnologías y educación Innovación educativa Resolución de problemas Optimización Excel Solver VBA Evaluación Problem-solving Optimization Evaluation |
| Sumario: | [EN] The present study is focused on the exploitation of the potential of VBA and Solver tools of Excel during the execution of a computer practice lesson within the subject of “Analysis and simulation of processes” corresponding to the bachelor’s degree of Chemical Engineering. VBA was used to design an Excel spreadsheet that integrates the following items: the assignment of different series of experimental data to the students, the guided and structured execution of three exercises, and the automated evaluation of the practice questions by the professor. The integrated and structured design of the lesson has advantages for both the students and the professors, since it simplifies the execution and evaluation of the report, while it also allows an effective use of time for the development of the students’ competencies. The use of VBA and the working environment of Excel provides more flexibility and freedom to the professor for designing practice lectures or tests than other available platforms, in which the professor needs to adapt the structure of the exercise to pre-established forms. The development of the practice lecture in a compact Excel file facilitated the obtention of good qualifications by the students |
|---|