CloseHelpPrint
Kies de Nederlandse taal
Course module: 202000452
202000452
Excel/VBA
Course info
Course module202000452
Credits (ECTS)3
Course typeCourse
Language of instructionEnglish
Contact personprof.dr.ir. E.W. Hans
E-maile.w.hans@utwente.nl
Lecturer(s)
Lecturer
dr. B. Alves Beirigo
Examiner
prof.dr.ir. E.W. Hans
Contactperson for the course
prof.dr.ir. E.W. Hans
Academic year2022
Starting block
1B
Application procedureYou apply via OSIRIS Student
Registration using OSIRISYes
Aims
  • Knowledge of and skills to use the basic and intermediate level features of the MS Excel spreadsheet software, covering topics like: tables, pivot tables, graphs, formula manipulation, worksheet layout and (conditional) formatting, proposition logic in formulas, use of basic Excel formulas for data retrieval and manipulation.
  • Basic programming skills using the VBA for Excel programming language, covering topics like: building and running macros, debugging, building subs and functions, local and global variable declaration, loops (for, while, repeat), proposition logic (if then else), Excel worksheet data manipulation (input and output)
Content

This course introduces the student into the MS Excel spreadsheet software. The learning objectives cover the features and skills that could be considered a basic requirement for any student in an engineering program like Industrial Engineering & Management. Additionally, this course is a basic introduction into programming, using the VBA for Excel programming language. The learning goals are sufficient to prepare students for more advanced programming (languages), as typically encountered in the MSc stage of engineering programs. This course is a pre-master course for the IE&M program. Upon request with the lecturer, the course may be performed in another period than the one indicated in this form.
Assumed previous knowledge
Admission only on individual basis by coordinator master program IEM.
Participating study
Bachelor Industrial Engineering and Management
Required materials
Course material
Manual on Canvas.
Recommended materials
-
Instructional modes
Lecture

Self study without assistance

Tutorial

Tests
Introduction to Excel

Remark
Testing on laptop

Introduction to programming with VBA

CloseHelpPrint
Kies de Nederlandse taal