ND Syllabus 2018
ND Syllabus 2018
2018
NATIONAL DIPLOMA
IN
INFORMATION TECHNOLOGY
PREAMBLE
CONSULTATIONS YEAR
1. Ministry of Health and Child Care 2017
2. Zimbabwe Revenue Authority (ZIMRA) 2017
3. City Talk Mobile Technology 2017
4. Zimbabwe Republic Police (ZRP) 2017
5. Scientific and Industrial Research Centre (SIRDC) 2017
6. Bindura University of Science Education 2017
7. Barclays Bank (Zimbabwe) 2017
8. Ministry of Information Communication Technology 2017
9. Computer Society of Zimbabwe (CSZ) 2017
10. Checkpoint Health 2017
11. Ruwa Rehabilitation Centre 2017
12. Essential System Solutions 2017
13. Rogel Security 2017
14. PowertTel 2017
15. Prudent Communications 2017
16. ZARNet 2017
17. Zimbabwe National Army 2018
18. Airforce of Zimbabwe 2018
19. M-Web (Zimbabwe) 2018
20. MAPs Communication 2018
21. Grain Marketing Board (GMB) 2018
2
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
3
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
2.0 AIM
3.0 OBJECTIVES
By the end of the course, the student should be able to:
3.6 apply various mathematical tools in the analysis of systems in the business
environment
3.11 develop quality websites for business and industrial applications using
appropriate software
4
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 STRUCTURE
SUBJECT TITLE CODE DURATION IN
HOURS
ND1
1.Computer Architecture and Servicing 553/18/S01 200
2. Data Communication and Networks 553/18/S02 200
3. Software Engineering TBA 200
4. Programming in Visual Basic.Net 553/18/S04 220
5. IT Research and Project Management TBA 180
6. Mathematics and Statistics 553/18/S12 200
ND2
7. On the Job Education and Training 553/18/S11 One year
ND3
8. Computer Quantitative Methods 553/18/S06 200
9. Data Structures and Algorithms 553/18/S07 200
10.Software Project 553/18/S08 200
11.Database Concepts and Design 553/18/S09 200
12.Internet and Web Development 553/18/S10 200
13. Cybersecurity and Ethics TBA 180
14.*National Studies 401/13/S01 80
15.*Entrepreneurship Skills Development (ESD) 402/13/S01 80
TOTAL 2540
2540 hours plus On the Job Education and Training for all modes of study.
Full time: spread over at least two years institution based learning
Part time: spread over at least four years institution based learning
English Language and Mathematics passed at ‘O’ Level with grade C or better and any
other three ‘O’ Level subjects or relevant NFC subjects and full National Certificate in
Information Technology or equivalent.
5
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
6
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
7
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
Skills Competency
Testing 30%
Software Project See guidelines See guidelines 100%
553/18/S08
On the Job Education and See guidelines See guidelines 100%
Training
553/18/S11
9.0 GRADING
0% to 49% - Fail
50% to 59% - Pass
60% to 79% - Credit
80% and above - Distinction
10.1 A candidate should attend at least 85% of learning sessions to qualify for
examinations.
10.2 The final mark should be obtained through aggregation provided the candidate
scores at least 50% in each of continuous assessment and examinations.
11.0 RE-WRITES
11.2 Candidates should pass at least two thirds of the course to qualify for a
referral.
11.3 Any candidate who fails to pass at least two thirds of the course should repeat
the whole course, including the subjects they would have passed.
8
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
12.0 EXEMPTIONS
12.1 Exemptions are only granted in subjects already attained from a completed
accredited qualification provided an exemption certificate specifying subjects
of exemption is produced.
12.2 Exemption Certificate should be applied for at enrolment and produced before
registration for examinations.
14.0 RESOURCES
9
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
PC Servicing Toolkits
Work Desks and chairs
Internet connection
Writing surface for the instructor (e.g. securely-mounted whiteboard)
Antistatic mats, grounded wrist straps
Protective Clothing (to be provided by student)
Theory Classroom
Classroom furniture
Writing surface for the Instructor (e.g. securely-mounted whiteboard)
Smart board
Computer and projector
Internet connection
10
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
11
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
12
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
13
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
14
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
lxvi. Sheldon. B et al (2013) Professional Visual Basic 2012 and .NET 4.5
Programming, Wrox
lxvii. Singh, B. (2016). Research Methodology and Quantitative Methods of
Computer Application. Saarbrücken: LAP LAMBERT Academic Publishing.
lxviii. Sommerville, I. (2016). Software engineering. 10th ed. Harlow, Essex:
Addison Wesley.
lxix. Stalling, W. (2013). Data and Computer Communication. 10th Ed. New
Jersey: Pearson.
lxx. Stallings, W (2010) Computer Organisation and Architecture Prentice Hall
lxxi. Stephens, Rod (2015) Beginning Software Engineering, Wrox.
lxxii. Sumathi, S. and Esakkirajan S. (2010) Fundamentals of Relational Database
Management Systems Springer Verlang
lxxiii. Sur. A (2013), Visual Studio 2012 and .NET 4.5 Expert Development
Cookbook, Packt Publishing
lxxiv. Tanenbaum, AS. (2013). Computer Networks. 6th Ed. Boston: Pearson.
lxxv. Tsui, Frank , Orlando Karam and Barbara Bernal (2016) Essentials of
Software Engineering 4th Ed., Jones & Bartlett Learning , Sudbury, MA.
lxxvi. Tyler.J (2015), Building Great Software Engineering Teams, Apress
lxxvii. Wagner, R. (2011). Creating Web Pages All-in-One for Dummies 4th Ed.
Wiley Publications Inc., Indianapolis
lxxviii. Waters, D. (2011). Quantitative Methods for Business. 5th Ed. London:
Pearson.
lxxix. Weiss et al (2012), Cyber Security Policy Guidebook, Wiley
lxxx. Welling, L and Thomson, L. (2016). PHP and MySQL Web Development.
5th Ed. Addison-Wesley Professional, New York
lxxxi. White, C. (2015). Data Communications and Computer Networks: A
Business User’s Approach. 8th Ed. Boston: Cengage Learning.
lxxxii. Whitehead G (1999) Success in Business Calculations, 4th Ed. Petterson
Institute
lxxxiii. Zureich, D. and Graebe, W. (2015). Cybersecurity: The continuing evolution
of insurance and ethics. Defense Counsel Journal, 82(2), pp.192-198.
15
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip the student with knowledge, skills and attitudes to
install, troubleshoot and maintain computer hardware and software in compliance with
recommended health and safety practices.
2.0 OBJECTIVES
3.0 TOPICS
16
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
3.5 MICROPROCESSOR
3.6 MEMORY
3.8 MOTHERBOARDS
4.0 CONTENT
17
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
- Input ports
Keyboard
Mouse
Pointing device connectors/ports e.t.c.
- Output ports
Monitor(VGA, SVGA video port)
Speaker
Printer e.t.c.
- COM ports
- USB
- Hard Disk Drive controllers (IDE, EIDE, SCSI)
4.1.6 Specify common errors and troubleshooting for peripheral components
18
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.5 MICROPROCESSOR
4.5.1 Outline the process of installation and configuration of microprocessors
4.5.2 Explain microprocessor packaging
4.5.3 Outline processor architectures including microprocessor modes and
manufacturers
4.5.4 Explain processor virtualization
4.5.5 Specify common microprocessor errors and troubleshooting techniques
4.6 MEMORY
4.6.1 Outline the process of installation and configuration of memory
components
4.6.2 Explain the following
- Memory types (SRAM, DRAM, EDO RAM, SDRAM, ROM,
EPROM, and EEPROM)
- Memory Packaging (DIP, SIMM, So-DIMM, DIMM)
- Cache Memory, Video Memory, BIOS, Virtual Memory
- Memory Banks, Parity
4.6.3 Describe DMA management
4.6.4 Specify common memory problems and troubleshooting techniques
4.8 MOTHERBOARDS
4.8.1 Outline the following
- Motherboard form factors
- Motherboard components
4.8.2 Outline the process of installation and configuration of motherboards
4.8.3 Describe the following
- System Board Architectures (Integrated, Non-Integrated)
- Bus Architecture: address bus, data bus, control bus
19
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
20
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
Skills Competency
Testing 30%
5 MICROPROCESSOR 10
6 MEMORY 10
7 STORAGE SYSTEMS 10
8 MOTHERBOARDS 10
9 INTRODUCTION TO OPERATING 10
SYSTEMS
10 HARDWARE AND SOFTWARE 10
MAINTENANCE
11 CUSTOMER CARE 7
TOTAL 100
21
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes in data
communications and computer networking concepts & fundamentals.
2.0 OBJECTIVES
3.0 TOPICS
4.0 CONTENT
22
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
23
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
o Parity check
- Data link layer protocols (PPP, SLIP, MPLS, ATM, HDLC)
24
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
25
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
26
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes to
analyze, design, develop and implement software solutions.
2.0 OBJECTIVES
By the end of the course the student should be able to:
2.1 outline the fundamentals of software engineering
2.2 describe software processes
2.3 outline the steps and strategies of requirements engineering
2.4 explain the process of designing and modeling software solutions
2.5 illustrate systems architectural designs
2.6 apply various software testing techniques
2.7 outline strategies for software implementation
2.8 outline and discuss software evolution processes
3.0 TOPICS
3.1 FUNDAMENTALS OF SOFTWARE ENGINEERING
3.7 IMPLEMENTATION
27
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENTS
4.1 FUNDAMENTALS OF SOFTWARE ENGINEERING
4.1.1 Define software engineering
4.1.2 Explain why software engineering is important
4.1.3 Explain software engineering diversity
4.1.4 Outline issues affecting different types of software
4.1.5 Explain the need for software engineering ethics
4.1.6 Describe the qualities of good software
28
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
- Interaction models
- Structural models
- Behavioral models
4.4.8 Apply process specification tools
4.4.9 Explain model-driven engineering
4.4.10 Describe the process of file and database design
4.7 IMPLEMENTATION
4.7.1 Develop strategies for implementation
- Implementation planning
- User training
- Implementation management
4.7.2 Discuss changeover strategies
4.7.3 Explain the need for system documentation
4.7.4 Explain open source development
CASE STUDY
The student should be able to carry out a case study on the analysis and design of a system,
which can be implemented in Zimbabwe. In the case study, the student should be able to
demonstrate an understanding of Entrepreneurial Skills
29
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
8 SOFTWARE EVOLUTION 10
TOTAL 100
30
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
31
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes for
developing applications using the Visual Basic.NET programming language.
2.0 OBJECTIVES
By the end of the course the student should be able to:
3.0 TOPICS
3.1 INTRODUCTION
32
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
4.1 INTRODUCTION
33
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
34
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
CASE STUDY
The student should be able to develop and test a software solution to a given problem, which
can be implemented in Zimbabwe. In the case study, the student should be able to demonstrate
an understanding of Entrepreneurial Skills.
35
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
i. Boehm, Anne (2015) Murach’s Visual Basic , Mike Murach & Associates
ii. Bryan Newsom (2015) Visual Basic, wrox
iii. Halvorson. M (2012) Learn Microsoft Visual Basic 2012, Microsoft Press
iv. Jeffrey R. Shapiro (2010) Visual Basic(r).NET: The Complete Reference,
McGraw-Hill/Osborne
v. Novac .I et al (2010), Visual Studio 2010 and .NET 4 Six-in-One , Wrox
vi. Rod Stephens(2012), Visual Basic 2012 Programmer's Reference, Wiley &
Sons
vii. Sheldon. B et al (2013) Professional Visual Basic 2012 and .NET 4.5
Programming, Wrox
viii. Sur. A (2013), Visual Studio 2012 and .NET 4.5 Expert Development
Cookbook, Packt Publishing
36
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes to
conduct a research and manage projects in the field of information technology.
2.0 OBJECTIVES
3.0 TOPICS
37
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
38
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
- Drawing conclusions
4.4.2 Producing a research document
39
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4. RESEARCH PHASES 20
7. PROJECT SCHEDULING 10
TOTAL 100
40
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes
required in critical, logical and objective problem solving
2.0 OBJECTIVES
By the end of the course the student should be able to:
2.1 calculate areas, perimeters and volumes of different shapes.
2.2 use logarithms to solve problems.
2.3 solve equations using various methods
2.4 calculate cost prices, selling price, commission, compound interest and profit
and loss.
2.5 explain data collection methods and sampling methods
2.6 present and represent data using tables, graphs, charts and picture forms.
2.7 extract data to calculate mean, median and mode .
2.8 solve problems using set theory.
2.9 solve probability problems.
3.0 TOPICS
41
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
4.1 METRIC SYSTEM
4.1.1 Calculate areas and perimeters of rectangle, circles, cylinders and
irregular shapes.
4.1.2 Calculate volume of cylinders, cuboids and spheres.
4.1.3 Relate units of measurement.
4.2 LOGARITHMS
4.2.1 Outline the rules of logarithms and indices
4.2.2 Solve arithmetic problems using logarithms and indices.
4.3 ALGEBRA
4.3.1 Solve the following types of equations:-
- simple equations
- simple simultaneous equations
- quadratic equations
- quadratic simultaneous equations.
4.3.2 Solve Boolean expressions using Karnaugh maps and Boolean laws
42
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.9 PROBABILITY
4.9.1 Apply the rules of probability:-
- Addition rule
- Multiplication rule
4.9.2 Use tree diagrams in probability calculations.
43
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1. METRIC SYSTEM 15
2. LOGARITHMS 15
3. ALGEBRA 10
4. PERCENTAGES AND THEIR 15
APPLICATION
5. DATA COLLECTION 10
6. DATA PRESENTATION AND 15
REPRESENTATION
7. MEASURES OF CENTRAL 10
LOCATION
8. SET THEORY 15
9. PROBABILITY 15
TOTAL 120
44
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
2.0 The aim of the subject is to equip students with knowledge, skills and attitudes
required to apply mathematical (computational) techniques and concepts in solving
common I.T related problems
3.0 OBJECTIVES
3.0 TOPICS
3.1 FUNCTIONS
3.3 MATRICES
3.4 DIFFERENTIATION
3.5 INTEGRATION
45
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
3.11 SAMPLING
4.0 CONTENT
4.1 FUNCTIONS
4.1.1 Outline the different types of functions
4.1.2 Calculate the domain, range and inverse of a function
4.1.3 Determine the composite functions from given functions
4.3 MATRICES
4.3.1 Perform matrix algebra
4.3.2 Determine matrix determinants and their properties (up to 3 x 3)
4.3.3 Calculate the inverse of a matrix using the adjoint and elementary row
operations (up to 3 x 3)
4.4 DIFFERENTIATION
4.4.1 Interpret (essence) the Derivative
4.4.2 Differentiate Sums, Products and Quotients, Chain rule, Exponential
functions
4.4.3 Apply implicit differentiation
4.4.4 Apply differentiation to Business Systems (i.e. Maxima and minima,
point of inflexion)
4.5 INTEGRATION
4.5.1 Explain standard integrals
4.5.2 Integrate
46
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
47
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.11 SAMPLING
4.11.1 Outline advantages and disadvantages of the observation, personal
interview, postal questionnaire and published documents as methods of
data collection.
48
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
49
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
50
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes
required to design and implement efficient algorithms and appropriate data structures
in programs
2.0 OBJECTIVES
By the end of the course the student should be able to:
3.0 TOPICS
3.1 INTRODCUTION TO DATA STRUCTURES
3.2 RECURSION
3.3 ANALYSIS OF ALGORITHMS
3.4 SEARCHING AND SORTING ALGORITMS
3.5 POINTERS, LINKED LISTS AND ARRAY BASED LISTS
3.6 STACKS
3.7 QUEUES
3.8 TREES
3.9 GRAPHS
51
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
4.1 INTRODUCTION TO DATA STRUCTURES
4.1.1 Define the terms:
- Data structure
- Algorithm
- ADT
4.1.2 Outline Object Oriented Programming concepts
4.1.3 Explain arrays and structures
4.2 RECURSION
4.2.1 Explain the concept of recursion
4.2.2 Determine the output of a recursive function
4.2.3 Solve problems using recursion:
- Factorial
- Fibonacci sequence
- Tower of Hanoi
- Reversing an array by recursion
- Computing powers via linear recursion
- Converting a number from decimal to binary
(NB: Learners should implement the above concepts using C++)
52
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.6 STACKS
4.6.1 Explain the concept of a stack
4.6.2 Illustrate how to check for empty stack or full stack
4.6.3 Describe stack frames
4.6.4 Explain stack operations
- Push
- Pop
4.6.5 Describe the implementation of stacks
4.6.6 Application of stacks:
- Reverse a string
- Convert expressions from infix to postfix
- Evaluate arithmetic expressions
4.7 QUEUES
4.7.1 Explain the concept of a queue
4.7.2 Illustrate how to check for empty or full queue
4.7.3 Explain queue operations
- Enqueue
- Dequeue
4.7.5 Describe:
- Circular queues
- Priority queues
4.7.7 Describe the implementation of queues
4.7.8 Application of queues
- Check for palindromes
- Evaluate infix expressions
- Build a queue from two stacks
4.8 TREES
4.8.1 Explain the concept of the tree data structure
4.8.2 Outline properties of trees
53
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.8.3 Explain
- Binary tree representation
- Binary tree operations
- Binary tree traversals
Pre-order
In-order
Post-order
- Binary search trees and recursive binary search trees
4.8.4 Compare binary search trees (BST) and linear lists
4.8.5 Application of BST
- Evaluate expressions
- Sort using a BST
4.9 GRAPHS
4.9.1 Explain the concepts of graphs (directed, undirected, vertex, edge, path,
complete graph, weighted graph, adjacency matrix, adjacency list)
4.9.2 Illustrate graph representation
4.9.3 Describe graph traversal methods (BFS, DFS
4.9.4 Apply graph in the following:
- Minimum spanning trees
- Topological sort
- Shortest path algorithms
- Transitive closure
3. ANALYSIS OF ALGORITHMS 15
54
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
55
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 PREAMBLE
These guidelines have been prepared for use in the identification, development and
assessment of the Project component at National Diploma level.
They are meant to provide guidance to the student, Project Supervisor and Assessors
on the nature and essential components of the Project.
The guidelines are structured so as to indicate the expected main activities by the
student and specific areas to be looked at within each activity. The activities have
been further allocated individual measures of importance (weighting).
The Project Supervisor shall be required to approve the student’s proposed problem
before the project commencement. The mentor shall render warranted guidance to the
student according to agreed schedule. The time allocated for the Software Project,
which is to be conducted throughout the third part of the course, is 200 hours. Time
shall be reserved for the student to consult his/her supervisor throughout this period.
2.0 AIM
3.0 OBJECTIVES
56
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
The Project documents shall be required to be in the format specified below and write-
ups shall include necessary Headings, Definition of Terms and References
57
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
60% DOCUMENTATION
40 % VIVA (panel to consist of 2 industrialists, 3 lecturers)
TOTAL 100
EXAMINER’S COMMENTS:
___________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________
58
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes
required to design, set up and maintain a database system.
2.0 OBJECTIVES
3.0 TOPICS
3.6 NORMALISATION
59
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
4.1 DATABASE ENVIRONMENT
4.1.1 Define database
4.1.2 Explain the following database concepts:
- Data as a resource
- File Processing evolution (Traditional to Database approach)
- Database components and their relationships
Hardware
Software
Data
People
Procedures
60
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.6 NORMALIZATION
4.6.1 Explain
- Purpose and utilization
- Benefits and limitations of normalization
4.6.2 Describe the process of normalization up to BCNF
61
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
62
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
63
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes
required to design, develop, test and maintain web sites/applications.
2.0 OBJECTIVES
3.0 TOPICS
64
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.0 CONTENT
65
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
- Tags
- Attributes
- Tables
- Frames
- Forms
- Navigation (site links, page links, search feature)
4.4.3 Implement multimedia
- Sound
- Video
- Images
- Downloadable files
66
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
PRACTICAL PAPER
OBJECTIVES AREAS TO BE COVERED WEIGHTING %
4, 5 CREATE WEB PAGES USING HTML 30
5, 6 CREATE DYNAMIC WEB PAGES THAT 20
INCORPORATE JAVA SCRIPT FUNCTIONS AND
EVENTS
5, 7 CREATE DYNAMIC WEB PAGES THAT 30
INCORPORATE PHP FUNCTIONS FOR UPLOADING
FILES, FORMS, POSTING AND GETTING CONTENT
FROM SERVER
8 IMPLEMETNING SECURITY ON WEB PAGES 10
4, 5 CREATE GRAPHICS OBJECTS AND ANIMATION 10
TOTAL 100
THEORY PAPER
OBJECTIVES AREAS TO BE COVERED WEIGHTING %
1 INTRODUCTION TO INTERNET 15
67
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4 HTML TAGS 10
6, 7 WORKING WITH JAVASCIPT AND PHP 10
8 WEB SECURITY 10
TOTAL 100
68
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.0 AIM
The aim of the subject is to equip students with knowledge, skills and attitudes
required to apply professional ethics in mitigating cybersecurity concerns
2.0 OBJECTIVES
By the end of the course the student should be able to:
2.1 explain workable theories
2.2 describe cybersecurity threats and vulnerabilities
2.3 outline strategies for aligning it policies to government legislation
2.4 outline professional ethics in the it profession
2.5 describe the process of it auditing
3.0 TOPICS
3.1 INTRODUCTION TO ETHICS
3.5 IT AUDIT
4.0 CONTENT
4.1 INTRODUCTION TO ETHICS
4.1.1 Discuss ethical theories
4.1.2 Compare workable ethical theories
4.1.3 Examine the morality of breaking the law
69
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
70
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
4.5 IT AUDIT
4.5.1 Audit lifecycle
- Planning
- Testing
- Reporting
- Review
4.5.2 Identify the types of audits and their applications
4.5.3 Plan the Audit
- Audit Charter
- ICT Standards, Guidelines & Frameworks (COBIT 5, ITIL, ISO,
ITAF, HIPAA)
- Outline effects of Laws and Regulations on IS Audit Planning
4.5.4 Classify Audits
- Audit Programs
- Audit Methodology
4.5.5 Perform audit work within audit Guidelines
- Audit and Assurance Tools and Techniques
- Audit Objectives
- implement Fraud Detection
- Audit Risk and Materiality
- Risk Assessment Techniques
- Risk Assessment and Treatment
4.5.6 Communicate Audit Results
71
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
72
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
1.1 The student shall be attached to a relevant company after completing National
Diploma 1.
1.3 A student will only be admitted to ND3 when he/she has completed the
attachment.
2.1 The student is subject to the regulations of the institute and Company
regulations during the industrial attachments.
- write a log book on a daily basis and submit a report after finishing the
training in a given department (or training unit).
2.3 The choice of company for the industrial attachment will not be based on any
probable monetary benefits the students may stand to gain.
2.4 The student must always bear in mind that his/her conduct during the industrial
attachment period will reflect not only on him/her but also attachment
placement and the relationship between the institution and the company.
73
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
3.1 The student will be subject to the company’s regulations and is expected to
function like a full time employee of the company.
3.2 Wherever possible the company is required to assist the student by providing
welfare measure such as accommodation close to the company, access to
canteen facilities and company transport facilities etc.
3.3 If the company wishes to pay the student an extra allowance the arrangements
is only between the two parties, that is, the student and the company involved.
4. ATTACHMENT DUTIES
Signature
74
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
5.4 Subjects covered at National Certificate and NDI levels with gradings.
75
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
Signature
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
……………………
6.3 Company supervisor’s general comments on the student with regard to the
following aspects:
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
76
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
…………………………………………………………………………………
……………………
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
…………………………………………………………………………………
………...................................................................................................................
.................................................
6.5 College attachment coordinator’s overall marks and remarks (out of 100%).
…………………………………………………………………………………
…………………………………………………………………………………
………….
_________________________________ _______
Signature Date
I declare that the student has (has not) fulfilled the industrial attachment component of
the course according to his or her syllabus requirements.
Date stamp
77
NATIONAL DIPLOMA IN INFORMATION TECHNOLOGY – 553/18/CO/O
9. Section F (Notes)
9.2 The student (trainee) must write a detailed report at the end of the attachment
period and submit to the college course coordinator in mid October for
assessment before November examinations session.
9.3 The student must attend a VIVA before a panel where he/she will be required to
explain what he or she was doing during attachment period. The VIVA to conform to
stipulated dates for project VIVAs as declared by Head of Department.
78