Appendices Appendix A ICT Literacy A5 Working with a Database
Previous TOC Next

UNIT A5 – WORKING WITH A DATABASE

Objective

Students should be able to use a prepared database in a competent manner.

Sub-objectives

Students should be able to:

  1. understand some of the relevant phases of problem solving;
  2. identify a problem which can be solved by a database;
  3. use a prepared database to store information;
  4. drawn and interpret information from an existing database in a structured and rational manner.

Context

In a large variety of businesses and in every day life, data are stored in databases managed by computers which are increasingly being linked together, for example for airline reservations and hotel reservations. More and more information about people is stored in databases – students should be aware of the need for the protection of personal data.

Content

Students analyse different applications in every day life where databases are used. Whenever possible, examples should be used which make the need for data protection obvious, such as: student records, information about tourist flows and needs.
Using a suitable example, the teacher prepares the appropriate structure of a database. Students then collect the necessary data, for example by interviews for which they must design an appropriate questionnaire. The data are entered into the database. Different lists will be produced and discussed.
During the process of using a database, students will come to understand some aspects of problem solving such as design, data entry and modification, and how to question the database.

Resources

Minimum necessary resources:
One computer per group of students;
Simple filled databases;
Some countries provide simple educational databases or special user interfaces for student s at a reasonable price.

Optional extra resources:
One computer per student; tutorial software;
Liquid crystal display panel and overhead projector.

Links

All other A-Units

Methodology

Student-centred, hands-on activities