Commonwealth Computer Navigator's Certificate/Milestone 3/Curriculum mapping/Module 5 mapping

From WikiEducator
Jump to: navigation, search

Module 5: mapping

Use the ECDL syllabus V4.0 document for the detailed explanation of the knowledge requirements for each knowledge area listed below. The mapping information below is taken directly from ECDL Syllabus Version 4.0.

Under each syllabus item please list and create links to the materials within the Open ICDL content or indicate if there is a 'gap'.

Module 5 Database, requires the candidate to understand some of the main concepts of databases and demonstrate the ability to use a database on a computer. The candidate shall be able to create and modify tables, queries, forms and reports, and prepare outputs ready for distribution. The candidate shall be able to relate tables and to retrieve and manipulate information from a database by using query and sort tools available in the package.

5.1 Using the Application

5.1.1 Database Concepts
  • Understand what a database is
    • Notes: a simple diagram (simple illustrations of tables, rows and columns) will really help to communicate this concept. Perhaps some real world examples of how databases can be used.
    • a gentle introduction into database design and the concept of normalization
    • refer to some simple (school theme) document examples and how to 'harvest' database entities and attributes from these documents into a database design
    • Exercise 1: using a pencil and paper draw some basic entities and their attributes (hint: student and teacher)
    • Example 1: fully attributed student and course entities - this should be a drawing, scanned and uploaded
  • Understand how a database is organized in terms of tables, records and fields
    • Notes: 'components' seems to be a vague or confusing term in this context
    • Add depth by introducing the difference between first and second normal form through table and attribute (field) design
    • Include data types to attributes
    • Exercise 2: using a pencil and paper add detail to the basic entities and attributes (introduce concept of students and courses)
    • using a pencil and paper create a table where columns are the attributes and each new row is an entry (make up some data)
    • Example 2: fully attributed and 2nd normal form student and course entities - this should be a drawing, scanned and uploaded
    • also include sample data tables
  • Understand what a key is; in particular, a primary key
    • Notes: might be helpful to explain significance of ID field; i.e. what it is used for traditionally
    • Include definition of candidate keys, secondary keys and uniqueness. These definitions provide good reference to what a primary key is and is not.
    • Introduce 3rd normal form with discussion of keys.
    • Exercise 3: using a pencil and paper extend the entities and their attributes into 3rd normal form
    • Example 3: fully attributed student and course entities into 3rd normal form - this should be a drawing, scanned and uploaded
  • Understand what an index is
    • Notes: would help to explain indexes in relation to the previous concepts like tables
    • An introduction to how indexes work - relate back to artifacts in school theme; like index cards
    • Explain how and why all primary keys are 'automatically' indexed, and how candidate and secondary keys often become indexed fields
    • Exercise 4: referring back to the work completed in exercise 3 identify commonly queried attributes (fields)
    • Example 4: provide list of indexed fields - this should be a drawing, scanned and uploaded
  • Section Exercise: using a pencil and paper write a paragraph (or more) describing a student and their tests, exams and assignments, include information about the relationship between these.
    • use your written description to identify the entities and their attributes, draw these using a pencil and paper
    • review your identified entities (and attributes) to identify keys
    • identify where indexes would be applied
  • Section Example: provide fully attributed, indexed and keyed entities - this should be a drawing, scanned and uploaded
5.1.2 First Steps with Databases

Notes: as we work through this section we will develop the database designed during the previous section.

5.1.3 Adjust Settings

5.2 Tables

5.2.1 Main Operations
5.2.2 Define Keys
5.2.3 Table Design/Layout
5.2.4 Table Relationships

5.3 Forms

5.4 Retrieving Information

5.4.1 Main Operations
5.4.2 Queries
5.4.3 Sort Records

5.5 Reports

5.6 Prepare Outputs

5.6.1 Prepare to Print
5.6.2 Print Options