Official site of the Introduction to Programming in Visual Basic For Applications part of the 01KWTHX - Introduction to Computer Science course, for automotive engineering students.
News
- Past Exams and solutions [.zip]
- Updated Lesson 5 slides, please check them out!
- Welcome to the 2009-2010 edition of the Introduction to Computer Science course! This site will host all the information about the Introduction to Programming in Visual Basic For Applications part of the course. Please read the course introduction for getting started.
Course Syllabus
The 01KWTHX - Introduction to Computer Science course is deployed in 2 different parts:
- the Main course (Prof. Marco Mezzalama)
- the Introduction to Programming in VBA (Ing. Dario Bonino)
This web site hosts lessons, exercises, relevant links and exam samples for the Introduction to Programming in VBA part. Materials referred to the Main part of the course can be found on the institutional web site.
Teachers
- Main part: prof. Marco Mezzalama (This email address is being protected from spambots. You need JavaScript enabled to view it.)
- Introduction to Programming in VBA part: Ing. Dario Bonino (This email address is being protected from spambots. You need JavaScript enabled to view it.)
Course Schedule
Day | Time | Room |
Friday (Team1) | 15:00 - 17:00 | "Sala Rossa" - Lingotto |
Friday (Team2) | 17:00 - 19:00 | "Sala Rossa" - Lingotto |
Introduction to programming in VBA
Slides
- Lesson 1: Foundations [slides][handouts (3x)]
- Lesson 2: First Example [slides][handouts (3x)]
- Lesson 3: Variables and operators [slides][handouts (3x)]
- Lesson 4: Conditional constructs [slides][handouts (3x)]
- Lesson 5: Strings and Loops [slides][handouts (3x)]
- Lesson 6: Arrays and matrices [slides][handouts (3x)]
- Lesson 7: Files [slides][handsout (3x)]
Exercises
- Lesson 1: Hello World [.xls][.txt]
- Lesson 2: First Example [.xls]
- Lesson 3: Operators Example [.xls], Mixed Types Example [.xls]
- Lesson 4: Exercise Solutions [.xls]
- Lesson 5: In-class Exercise Solutions [.xls]
- Lesson 5: Exercise Solutions [.xls]
- Lesson 6: Exercise Solutions [.xls]
- Lesson 7: Exercise Solutions [.xls]
The following table reports the course lessons schedule and the involved topics. It discloses the entire course organization and allows students for a better planning of their learning efforts. The reported schedule may change depending on teaching needs.
Legend: the Type column may include the following values: L=Lesson, EA=In Classroom Exercises, EL=Lab; theTopic column reports the topic of each lesson.
Date | Time | Type | Topic | Teacher |
---|---|---|---|---|
25/09/2009 | 15:00-17:00 | EA |
Introduction to VBA programming: Foundations (Team 1) |
Dario Bonino |
25/09/2009 | 17:00-19:00 | EA |
Introduction to VBA programming: Foundations (Team 2) |
Dario Bonino |
02/10/2009 | 15:00-17:00 | EA | Variables and operators, exercises (Team 1) | Dario Bonino |
02/10/2009 | 17:00-19:00 | EA | Variables and operators, exercises (Team 2) | Dario Bonino |
09/10/2009 | 15:00-17:00 | EA | Variables and operators, exercises (Team 1) | Dario Bonino |
09/10/2009 | 17:00-19:00 | EA | Variables and operators, exercises (Team 2) | Dario Bonino |
16/10/2009 | 15:00-17:00 | EA | Conditional constructs, exercises | Dario Bonino |
16/10/2009 | 17:00-19:00 | EA | Conditional constructs, exercises | Dario Bonino |
23/10/2009 | 15:00-17:00 | EA | Strings, For-Next loop, exercises | Dario Bonino |
23/10/2009 | 17:00-19:00 | EA | Strings, For-Next loop, exercises | Dario Bonino |
30/10/2009 | 15:00-17:00 | EA | For-Next loop, exercises | Dario Bonino |
30/10/2009 | 17:00-19:00 | EA | For-Next loop, exercises | Dario Bonino |
06/11/2009 | 15:00-17:00 | EA | Do-While loop, exercises | Dario Bonino |
06/11/2009 | 17:00-19:00 | EA | Do-While loop, exercises |
Dario Bonino |
13/11/2009 | 15:00-17:00 | EA | Arrays and Matrices, exercises | Dario Bonino |
13/11/2009 | 17:00-19:00 | EA | Arrays and Matrices, exercises | Dario Bonino |
27/11/2009 | 15:00-17:00 | EA | Arrays and Matrices, exercises | Dario Bonino |
27/11/2009 | 17:00-19:00 | EA | Arrays and Matrices, exercises | Dario Bonino |
4/12/2009 | 15:00-17:00 | EA | Files, exercises | Dario Bonino |
4/12/2009 | 17:00-19:00 | EA | Files, exercises | Dario Bonino |
11/12/2009 | 15:00-17:00 | EA | Files, exercises | Dario Bonino |
11/12/2009 | 17:00-19:00 | EA | Files, exercises | Dario Bonino |
18/12/2009 | 15:00-17:00 | EA | Exam examples | Dario Bonino |
18/12/2009 | 17:00-19:00 | EA | Exam examples | Dario Bonino |