Information Technology MasterClass

This MasterClass covers lessons for Information Technology Paper 1 (Programming and SQL) and Paper 2 (Theory) for the Grade 12 IEB examinations.

Created by Redhill School
R900
Buy now
Includes:
  • 04:23:48 hours on-demand videos
  • 11 Lessons
  • Access until 1 February 2021
  • Access on mobile and PC devices
What will I learn?
  • To create and learn how to interpret a class diagram.
  • To learn more about Trace tables.
  • To learn about cabling types and be made aware of the pros and cons of each type of cable.
  • To be able to both define and choose the most appropriate topology/medium applicable to a given scenario.
  • To be able to describe transmission technologies and different networking devices. Students will also be able to describe the device and its functions, as well as when and where it is used.
  • To be able to define the important terminology associated with Normalization, as well as discussing the concept of Normalization, the reasons for Normalizing a database and the characteristics and requirements for each normal form.
  • To be introduced to the crucial concepts of what an algorithm is as well as detailed explanations of:
    a) How to assign values to variables;
    b) The operators used for calculations;
    c) How to indicate an entire array as opposed to a single item of an array;
    d) How to represent each of the programming structures;
    e) How to represent and call methods.
  • To be made aware of the terms that are most often tested and a broad overview of the evolution of the Web. Students will be shown how to apply the terminology to a given scenario and give appropriate examples of the aspects covered. Additional important aspects, amongst others, are: Downloading vs Streaming, Lossy vs Lossless Compression and Client-side vs Server-side Scripting.
  • To revise advanced concepts in SQL. Aspects such as the sequence of instructions, TOP clause, Insert, Update, Delete, Insert using existing data, Joins: INNER, LEFT and RIGHT, Date functions, String (text) functions, Data aggregate functions, Group by, Having, The use of IN, Nested queries and generating random numbers.

Curriculum for this subject
11 Lessons 04:23:48 hours
Grade 12 IT
12 Lessons 04:23:48 hours
  • Information Technology Sample Video
    00:01:31
  • Class Diagrams
    00:20:04
  • Algorithms
    00:26:00
  • Trace Tables
    00:26:25
  • SQL Revision - Part 1
    00:31:28
  • SQL Revision - Part 2
    00:17:03
  • Normalization - Part 1
    00:12:49
  • Normalization - Part 2
    00:21:31
  • Internet and Communication Technologies
    00:17:48
  • Networking - Part 1
    00:26:18
  • Networking - Part 2
    00:22:50
  • Additional Explanations
    00:40:01
Requirements
  • Redhill IT Information Booklet
  • IT Textbook


Description

The Information Technology MasterClass Series of videos was produced to highlight, clarify and refine the most important concepts as described in the Subject Assessment Guidelines (SAGs) for Information Technology.

 

An effort was made to address the more difficult concepts and the focus was on revising and clarifying most frequently examined concepts, rather than on reteaching. Most of the theoretical concepts outlined are from the grade 11 SAGs, given that we have not had much time this year to revisit those concepts which form the bulk of the theory examination. Helpful hints and what students need to watch out for when answering examination questions are interspersed within the content.

 

After each video, students should take some time to consolidate their understanding of the concepts discussed, by attempting to answer questions from past examination papers specifically on that particular topic.


Teacher Biography


Vanitha Rajamany is from the beautiful KZN and has been teaching for the past 30 years. Since her move to Gauteng, she has taught at two top IEB schools for 21 of those 30 years - starting her career with the IEB at King David-Linksfield before arriving at Redhill. Vanitha has been a Sub Examiner at the IEB since 2000 and has for the past 2 years served as Senior Sub Examiner for both the IT Practical and the IT Theory examinations. Vanitha recently completed her M.Sc. in Computing through UNISA. She currently serves as Head of Department IT at Redhill School.


Other related subjects
+ View more
03:29:27 hours
Updated Fri, 07-Aug-2020
R900
02:41:53 hours
Updated Fri, 07-Aug-2020
R750
01:45:16 hours
Updated Fri, 28-Aug-2020
R800
04:45:53 hours
Updated Fri, 28-Aug-2020
R1100
06:28:59 hours
Updated Fri, 28-Aug-2020
R1350
06:56:47 hours
Updated Fri, 28-Aug-2020
R1350
01:49:11 hours
Updated Sat, 29-Aug-2020
R750
10:04:48 hours
Updated Fri, 28-Aug-2020
R1500