Grade 10 It Theory Exam Wednesday 19 November 2013 , 11h00 - 13h00

The sections to study for this exam are:

Section 2: System Technologies
Section 3: Communication and Internet Technologies.
Section 4: Data and Information Management.
Section 5: Social Implications.

Gr 11 Theory Exam: Friday 15 November 2013

Duration is from 07h45 - 10h00 in room 106 (2 hours).
Topics to study:

• Hardware
• Software
• Networks
• ICT and society
• Computer management
• E-Communication
• Internet services technologies

Database Design and Normalisation

First Normal Form (1NF)

1. Remove all repeating columns (Fields)

e.g. Subject1, Subject2, Subject3

2. Remove data with multiple values

e.g. Name and Surname in same field (Robyn Smith)

3. Ensure that each table has a unique primary key field.

Try to avoid using a composite primary key – that is two fields that jointly function as primary key.

 Study the following table:

Table: School_Sports :

 

 

 

Problems: (1) There are two John Smiths. They are actually two different learners – 
                        and we can’t tell them apart!
                  (2) There are repeating columns (fields) namely Sport1,Sport2 etc.

Solution:  (1)Create a new table just for the learners names and surnames add a key

                     field called ID that allows us to distinguish between people with the same
                    name and surname.
               (2)Create a second table for all the sporting activities done by these people
                    and link the two tables using the values in the ID field of the Names table.
                   Also add a key field (ID2) to the Activities table so that each record has a
                  unique  value.

 

 

Second Normal Form (2NF)

1. Make sure the database meets the requirements of (1NF)

2. Make sure there are no partial dependencies every field must depend
    on a whole primary field (not a composite one).
3. Also check for repeating values that do not have to be repeated (if the
    tables were designed correctly - redundancy).

 Problems: (1) Although the above split has resulted every field depending a whole primary key field, there is the  problem of repeating values in a field with the potential for errors.

The above arrangement therefore does not meet the criteria of the second normal form.

Solution: Split the tables in the way shown:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Third Normal Form (3NF)

1. Make sure the database meets the requirements of (2NF)
2. Make sure that no value depends on field that is NOT part of primary  key.

 

Gr10 June Exam Scope of Work

Practical Exam  (Tuesday 11 June, 2013):

Study all work, activities and exercises of the following chapters:
Module 1.1 Thinking for Computers.
Module 1.2 Introduction to graphical programming.
Module 1.3 Input, Processing, Output
Module 1.4 Decision Making.
Web page design using HTML

Theory Exam (Friday 21 June, 2013):

All chapters of the following:
Section 2 System  Technologies.
Section 3 Communication and Internet.

Gr12 IT - Useful links for exam preparation

Gr12 students will find the following links to be very useful:

http://teachitza.com/index.php?option=com_frontpage&Itemid=1

http://teachitza.com/blog/blog/

The following link is for past exam papers:

http://www.education.gov.za/Examinations/PastExamPapers/tabid/351/Default.aspx

Gr11 IT June Exams - work to study

gr11 Practical: June 2013 - Mon 3rd  June
========================================
Study the following study opportunities notes:
_Chapter1:Gr11IT Delphi Chapter1
_Chapter2:Gr11IT Delphi Chapter2
_Chapter3:Gr11IT Delphi Ch3 CustomSubroutines
_Chapter4:_Gr11IT Delphi Chapter4 complete


Gr11 Theory June 2013 Wed 12th June
=======================================
Gr11IT2013 1_1Hardware
Gr11IT2013 1_2 Software
Gr11IT2013 2_1 Networks
Gr11IT2013 3_1 ICT and society
Chapter1:Gr11IT Delphi Chapter1
Chapter2:Gr11IT Delphi Chapter2
Additional info Bus design

Gr10 Homework Tuesday,12/3/2013

Do the following:  pp67 - 68, Act Ex. 1 - 3.
Also produce the Scrath program for question 2