Information Technology MasterClass DBE

This MasterClass covers lessons for Information Technology Paper 1 (Programming and SQL) and Paper 2 (Theory) for the Grade 12 DBE examination

Created by Redhill School
Buy only
Information Technology MasterClass DBE
R300
Buy now
Includes:
  • 07:19:30 hours on-demand videos
  • 18 Lessons
  • Access until 31 December 2021
  • Access on mobile and PC devices

Buy it as a part of
Full DBE MasterClass Bundle
R350
Buy now
Includes:
  • All 8 DBE Subjects
  • Access until 31 December 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.Additionally, newer concepts to be tested at the end of this year, like formatting dates and numbers and extracting characters from randomly generated positions within the text etc.are discussed.
  • The lessons on Normalization will help you define the important terminology associated with Normalization. These lessons discuss the concept of Normalization, the reasons for Normalizing a database and the characteristics and requirements for each normal form, which should help you in portfolio assessments.

Curriculum for this subject
18 Lessons 07:19:30 hours
Grade 12 IT
18 Lessons 07:19:30 hours
  • Information Technology Sample Video
    00:01:31
  • Class Diagrams
    00:20:04
  • Class Diagrams with inheritance: Examples of field definitions
    00:18:00
  • Algorithms
    00:26:00
  • Trace Tables
    00:26:25
  • SQL Revision - Part 1
    00:31:28
  • SQL Revision - Part 2
    00:17:03
  • SQL Formatting Dates and String
    00:18: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
  • Data Representation
    00:18:52
  • Signed numbers and Addition
    00:24:36
  • Representing Real Numbers
    00:23:48
  • Hardware Terminology
    00:30:14
  • Boolean Logic
    00:42:09
Requirements
  • 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 Examination Guidelines document 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 Examination Guidelines, 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 hails from the beautiful KZN and has been teaching for the past thirty-one years. Since her move to Gauteng, she has taught at two top IEB schools for twenty-one of those 31 years -  starting her career within the IEB system at King David Linksfield, she moved on to Saheti School and later accepted a position  - as Head of Department: Information Technology - at Redhill School, in 2017. Vanitha was appointed as a Sub-Examiner for the IEB in; in addition, for the past three years she has acted as Senior Sub-Examiner for both the IT Practical and IT Theory papers. Vanitha recently completed her M.Sc. in Computing through UNISA.


Other related subjects
+ View more