Study Guide

Objective

The student can use spreadsheet programs in a variety of ways.
Students can use the built-in programming capabilities of a spreadsheet program..

Content

Rehersal of Excel
Visual Basic for Applications
- Developer Toolbar and the Visual Basic editor
- Objects, Collections, Properties, Methods
- The programming language VBA
- Procedures and functions
- Exceptions
- Events and event-oriented programming
- User Forms
- Diagrams
- Office Automation
- Import and export of data

Qualifications

Applied Data Tools.

Assessment criteria, satisfactory (1)

The student knows the possibility of macro programming as well as procedural programming.
The student can read and write spreadsheets with code and can make simple calculations on the computer.
The student can write program code that includes selections and iterations.

Assessment criteria, good (3)

The student can write program code that includes coding functions and function calls.
The student can modify, verify, search and sort data in a spreadsheet with code.
The student can write code to import and export text data.

Assessment criteria, excellent (5)

he student can build customized user interfaces for the calculation.
The student can solve calculation problems with macro programming.

Materials

Material on Moodle.