Areas to be covered in Form 5 Junior Lyceum
|
|
|
Module 1 –
Basic Concepts
1.5. BC5
1.5.1. Systems development – process of research, analysis,
programming, testing
1.5.2. Information security – information security policies,
User IDs & passwords, access
rights, back ups, protection against intrusion, privacy issues
(protection of computer,
good password policies), power failures
1.5.3. Copyright – main security and legal issues re copying,
sharing, lending, transferring
files over network. Shareware, freeware, user licences.
1.5.4. Product ID numbers
1.5.5. Data protection act – implications of, uses of personal
data
1.5.6. Telephone network in computing – use of, PSDN, ISDN,
ADSL,, modem, digital,
analogue, baud (bps)
1.5.7. e-commerce – its advantages & disadvantages
Module 5 – Databases – Skills module
5.2. DB2
5.2.1. Creating a new database – file specifications (field
attributes): field name, field type,
field length, primary keyfield and its use – file name and database
name, setting up
index (without duplicates) and its use
5.2.2. Relation of memory requirement for characters, fields,
records, files (in relation to
file specifications)
5.2.3. Inserting data in table, updating the database, saving
5.2.4. Modifying table layout and field attributes
5.2.5. Creating a form – entry of data from form, formatting
text, changing background
colour, change arrangement of objects, saving, printing
5.2.6. Use of filters – finding records, adding and removing
filters
5.2.7. Querying – creating simple queries, creating compound
queries, adding and
removing fields, hiding/unhiding fields, saving, printing
5.2.8. Reporting – present data in a particular sequence, modify
a report, grouping data by
report totals and sub-totals, inserting headers and footers,
saving, printing
5.2.9. Printing, set paper size, report orientation
5.3. DB3
5.3.1. Create relationships between tables, edit & delete
(one to one, one to many)
5.3.2. Validation rules for numbers, date/time, currency
5.3.3. Forms with headers/footers, deleting forms
5.3.4. Queries based on two tables
5.3.5. Reports with grouped data, including calculated fields
for sum, max, min, average,
count
|
|
|