Key words
Applied IT
Objectives
Learning to work with a spreadsheet program and to create and use a database with a database program.
The emphasis lies on using the programs in applications related to business economics.
The student has to be able to work with both packages efficiently.
Therefore, the student needs to learn and practice regularly and thoroughly so he can carry out a number of tasks within a limited time.
The student has to have a command of the most important possibilities of both programs. By using the documentation of the programs, he can extend his knowledge.
Topics
SPREADSHEET PROGRAM- basic operations
- mathematical calculations
- more advanced operations such as logical and search functions
- create and edit graphs
- manage lists.
ACCESS- basic terms of database programs
- create tables
- enter, import and export data into tables
- create queries: selection and action queries
- creating and adapting forms and reports
Prerequisites
Knowledge of Windows and basic understanding of Office-packages.
Final Objectives
Materials used
Course book Applied IT 2nd year Environmental Administration.
Zip diskette
Study costs
Cost price copies : estimated number of pages : 400 pp.
Zip diskette
Study guidance
Coaching during the exercises.
Teaching Methods
Interactive discussion, individual and supervised exercises.
Assessment
First exam session: computer and written examination.
Second exam session: computer and written examination.
Examination Board Flemish Community: (ditto regular student).
Lecturer(s)
|
|
