Key words
IT. Knowledge of database management, IWETO code P175 information technology
Objectives
- Students are to get acquainted with databases. They should be able to make and use a database using database software (part of an Office suite);
- Students should know the main functions of database software and be able to increase their skill using the help function.
- Students have to be able to execute a given number of assignments within a given time, efficiently and individually.
- Students should be able to think practically and work meticulously.
- This course is used as a link to Office software Word and Excel.
Topics
- Basic terminology on database software;
- Creating tables, relations;
- Entering data, links to Word and Excel;
- Designing queries: selection queries (incl. Parameter queries and join queries) and action queries;
- Working with forms and reports;
- Exercises.
Prerequisites
Acquaintance with Windows and basics of Office software.
Final Objectives
Knowledge:
General:- File management;
- Word processing.
General and job-related:
Skills:
General and job-related:- Working efficiently on a PC;
- Analytic and problem solving mindset;
- Logical thinking;
- Using software (the most recent in the field).
Job-related:- Being able to easily make a database, entering data, designing queries, designing forms and reports;
- Using professional software (the most recent in the field).
Attitudes:
General:- An eye for quality;
- Meticulousness;
- Orderly and tidy work.
General and job-related:- Working towards results;
- Working according to plan.
Job-related:- Awareness of quality;
- Sense of structure.
Materials used
Syllabus by the lecturers, available through course service;
Exercises on the network; Dokeos;
Pc with software, floppy disk/zip disk, cdrw;
Students without their own PC may use the machines in the PC workroom between classes.
Study costs
Syllabus at the going rate in Hogeschool Gent (approx. 250 pages).
Study guidance
Possible coaching through Dokeos (electronic learning environment).
Teaching Methods
Students get to know the software through interactive classes, guided and individual exercises on the computer.
The lecturer will coach students on various exercises they have prepared themselves.
Assessment
- First exam session: 100% written exam executed on a PC
- Second exam session: 100% written exam executed on a PC
Students registered for the examinations only: - First exam session: 100% written exam executed on a PC
- Second exam session: 100% written exam executed on a PC
Note: students have to finish their assignments efficiently within the given time limits.
Lecturer(s)
|
|
