Key words
Database Management, IWETO-code: P175 Informatics
Objectives
Knowledge:
This course wants to make students familiar with databases. By means of a database program (part of an office-package) the student has to be able to produce and use a database professionally.
The student has to know all the most important possibilities of a database program and has to be able to expand his knowledge through documentation (help-function).
The student must be able to perform a given amount of assignments independently and efficiently within a limited length of time.
The student must be able to think in a problem-solving way and must be able to work accurately. This course is used as a link to the other office-packages Word and Excel.
Skills:
The student has to be able to handle the package professionally and efficiently and he also has to be capable of working in a problem-solving way. To accomplish this, the student has to practise the offered content (theory and exercises) independently, thoroughly and regularly. By doing this, the student will be able to execute a given number of assignments within a limited length of time.
Competencies:
The student must have a thorough command of the most important possibilities of a database program he must also be able to expand his knowledge through production documentation
Topics
- Basic terminology concerning database programs
- Produce tables, find relations· Introduce data (importing and exporting)
- Designing queries: queries of selection and queries of action
- Working with documents (including lists of choice) and reports (including group reports)
Prerequisites
Being able to use the current possibilities of system of control as efficiently as possible and having a keyboard skill (part of final objectives when having finished the course 'Communication Skills')
Final Objectives
Knowledge
General:
Job-related (general):
Job-related (specific):- Knowledge of calculation sheets, database programs, word processing, e-mail, internet and knowledge of the possibilities of the programs in relation to the field of profession
- Knowledge of data processing and adjusting of data
- Production and management of databases
Skills
General:- Thinking and reasoning power
- Working independently
Job-related (general):- Ability to use the knowledge efficiently (for instance ICT)
- Ability to work efficiently with the PC
- Ability to think in an analytical and problem-solving way
- Arrange and keep a goal-oriented administration, keep a goal-oriented classification system
- Apply packages of informatics (most recent ones concerning the profession)
Job-related (specific):- Ability to use the appropriate solutions for prospecting and management of data of customers
- Ability to assimilate, store and use relevant information
- Ability to settle in job-related and/or company-specific computer-software
- Ability to search for information through queries
- Ability to import data in a data bank through documents
- Ability to make up reports with data that is stored in a data bank
Attitudes
General:
Job-related (general):
Job-related (specific):- Eagerness to work with numerical data
Materials used
::Click here for additional information::
- Syllabus with practical exercises, available at the service for courses
- Files of lessons available through the internal network, can be copied on cd-rom in the classrooms
- Pc with Office-software, students can also use the classroom when there is no lesson
Study costs
Syllabus: at the unit price determined under Hogeschool rules
Estimated pages: about 250
Study guidance
- Steering and coaching of students during the contact hours
- Guidance possible through the electronic learning environment
Teaching Methods
Method of question-and-answer and seminars
Guided and individual exercises on the computer- Through the method of question-and-answer, guided and individual exercises on the computer, one learns to know the software.
- The lecturer will coach you and steer where it is necessary in relation to various exercises and assignments you have first prepared at home.
Assessment
- First exam session: 100% exam with working out on the computer
- Second exam session: 100% exam with working out on the computer - ability to perform the given assignments correctly within the given time
Students only enrolled for taking the exams: - First exam session: 100% with working out on the computer - ability to perform the given assignments correctly within the given time
- Second exam session: 100% with working out on the computer - ability to perform the given assignments correctly within the given time
Lecturer(s)
|
|
