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

Bryanston High makes a start with iPads

During the schools's  open day, 28/2, parents and learners were introduced to the shool's recently acquired iPad computers. These computers will be used by both teachers and learners for enrichment purposes.

Gr10 Homework

Friday, 8 March 2013: P.60 Act 1. Ex 1,3,4,6,7,8
Monday,  11 March 2013: Act 3, Ex  2,3,5

Gr 11 Cycle postponed.

Please note that the scheduled Gr 11 cyle test for tomorrow will take place on Wednesday, 27 February, 2013 as discussed in class today.  The test will take place in the periods 3 and 4 of Day 5 of the school timetable.

Gr 12 IT ClassTest, Wednesday 13 Febuary 2013

This test will be on SQL (pp 94 - 115) in your book Computers Part of your Life, Part 3.
Practice each one of the examples. Create a summary page to learn for the test. Every query must be preceded by a summary that describes it. The different types of queries should be placed under suitable group headings.

For example:
Queries involving dates.
i) Calculating the days between to dates.
ii)Calculating a persons age in years.
iii) List names of people who's birthday is in January.

Remember also  that your Cycle is scheduled for Thursday, 21 Febuary

Gr10 IT practical homework for Friday 8 Feb 2013

Practical work students should have finished for Friday 8/2 is as follows:

1. Study the explanation on variables from p43 - p45. This can be asked in a future test.
2. Do corrections to activities 2 (p47) - 4(p48). This work was due on Tuesday 5/2.
3. I the activity using Fan Spin program was not done (activity 2 p47) make sure it is done.
4.  Do activity 5 questions 1 - 8 on page 49. Algorithms for questions 2 -6 and 8 are necessary.
5. Do activity 6 questions 1 and 2 on page 50.

For Monday 11/2 complete exercise 7 questions 1 -3 starting on p51.

Also remember the Cycle Exam on Tuesday 26 February 2013. Things to study for test include Module 1.1, Module 1.2, Module 1.3 for practical work and Module 2.1. The test will be a written test.