CloseHelpPrint
Kies de Nederlandse taal
Course module: 202000392
202000392
VBA Programming
Course info
Course module202000392
Credits (ECTS)2
Course typeStudy Unit
Language of instructionEnglish
Contact personprof.dr.ir. E.W. Hans
E-maile.w.hans@utwente.nl
Lecturer(s)
Examiner
dr. B. Alves Beirigo
Lecturer
dr. B. Alves Beirigo
Contactperson for the course
prof.dr.ir. E.W. Hans
Examiner
prof.dr.ir. E.W. Hans
Academic year2022
Starting block
1A
Application procedureYou apply via OSIRIS Student
Registration using OSIRISYes
Aims
Data Processing in Excel
1. The student gets familiar with Excel by using several types of graphs, tables and functions.
2. The student can navigate, analyze, clean, sort and represent (graphically or numerically) data.
3. The student can make pivot tables based on data and apply it in graphs.

Elementary programming skills with VBA
1. The student knows the basic logic constructs of programming.
2. The student knows the basic functionality of VBA in Excel.
3. The student is able to use common debugging tools to find errors in code
4. The student can implement simple routines, with input and/or output parameters..
5. The student knows the basic syntax of VBA, and can execute VBA code via buttons or forms.
6. The student can implement simple routines to read or write data from/to Excel.
Content

Module
Module 1
Participating study
Bachelor Industrial Engineering and Management
Required materials
Syllabus
Excel manual (PDF and data files on Canvas)
Syllabus
VBA manual (PDF and data files on Canvas)
Laptop
Use of own laptop with MS Office
Software
MS Office (Mac or Windows)
Recommended materials
-
Instructional modes
Self study without assistance
Presence dutyYes

Tests
Introduction to Excel

Remark
Testing on laptop

Introduction to programming with VBA

Remark
Testing on laptop

CloseHelpPrint
Kies de Nederlandse taal