SAQA

All qualifications and part qualifications registered on the National Qualifications Framework are public property. Thus the only payment that can be made for them is for service and reproduction. It is illegal to sell this material for profit. If the material is reproduced or quoted, the South African Qualifications Authority (SAQA) should be acknowledged as the source.

SOUTH AFRICAN QUALIFICATIONS AUTHORITY

REGISTERED QUALIFICATION THAT HAS PASSED THE END DATE:

Diploma: Computer Programming and Information Systems

SAQA QUAL ID	QUALIFICATION TITLE
36010	Diploma: Computer Programming and Information Systems
ORIGINATOR
Durbanville College (Pty) Ltd
PRIMARY OR DELEGATED QUALITY ASSURANCE FUNCTIONARY			NQF SUB-FRAMEWORK
CHE - Council on Higher Education			HEQSF - Higher Education Qualifications Sub-framework
QUALIFICATION TYPE	FIELD		SUBFIELD
National Diploma	Field 10 - Physical, Mathematical, Computer and Life Sciences		Information Technology and Computer Sciences
ABET BAND	MINIMUM CREDITS	PRE-2009 NQF LEVEL	NQF LEVEL	QUAL CLASS
Undefined	125	Level 5	NQF Level 06	Regular-Provider-ELOAC
REGISTRATION STATUS		SAQA DECISION NUMBER	REGISTRATION START DATE	REGISTRATION END DATE
Passed the End Date - Status was "Reregistered"		EXCO 0415/23	2021-07-01	2023-04-18
LAST DATE FOR ENROLMENT		LAST DATE FOR ACHIEVEMENT
2024-04-18		2028-04-18

In all of the tables in this document, both the pre-2009 NQF Level and the NQF Level is shown. In the text (purpose statements, qualification rules, etc), any references to NQF Levels are to the pre-2009 levels unless specifically stated otherwise.

This qualification does not replace any other qualification and is not replaced by any other qualification.

PURPOSE AND RATIONALE OF THE QUALIFICATION

The purpose of the qualification is to train and equip the learner with the necessary knowledge and skills which will enable him/her to get employment in the information technology industry, of which programmer, support services, and marketing are but three careers.

Rationale for the qualification

The information technology is a very competitive, but growing and changing, industry. To up with these changing trends, relevant training in this field will definitely contribute to the regional and national goals of relieving an apparent shortage of personnel.

The wide-spread use of computers has resulted in a continuous need for a wide range of highly skilled data-processing and information technology personnel. As the field is one which is subject to rapid technological change, employees are required who are well trained, and who keep up to date with the latest development in their fields. This course aims to enable learners to become effective users and implementers of information.

In our region are other institutions who offer training in the information technology field, but more towards the computer hardware and use of existing programmes. In comparison to computer programming programmes offer by other institutions, our programme structure is unique, because we do not only offer IT related modules, but also Communication & Life Skills, Networking, Internet, Hardware and Powerpoint which forms a more complete qualification.Being a provider in IT training for the past 10 years, we are very fortunate to have staff members with not only teaching experience, but also with vast practical expertise. This ensures close relations with the business sector to ensure relevant training.

LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING

Learners must be able to demonstrate that they have the knowledge and skills, gained through studying the Certificate in Computer Programming & Information Systems to continue to this level of training.

Recognition of prior learning (RPL)

Recognition of prior learning forms an integral part of the structure of the programmes at the College. Learners are RPL`ed for studies successfully completed at universities, technikons and state colleges as well as private colleges accredited by SAQA, CHE or a SETA.

Learners who can demonstrate good computer, administrative, communication, numerical and programming experience, may be registered for some diploma levels and some certificate level modules.

RECOGNISE PREVIOUS LEARNING?

QUALIFICATION RULES

N/A

EXIT LEVEL OUTCOMES

On achieving this qualification, the learner will be able to:Productively functions an information technology office being capable to perform all computer and business functions as set out in the core units.

ANNEXURE 1

Computer Programming

Java

What is Java
Object-oriented programming
The ABC`s of Java
Console vs Windows based application
Working with objects
Lists, logic and loops
Creating classes and methods
Writing Java applets
Working with Swing
Building a Swing interface
Arranging components on a user interface
Responding to user input
Colour, fonts and graphics
Threads and animation
Java Sound
Packages, interfaces, class features
Error handling and security
Handling data through Java streams
bject serialisation and reflection
ommunicating across the Internet
orking with Java Beans
Java database connectivity and data structures

SQL

Introducing SQL server
SQL and database fundamentals
Planning, installing and upgrading SQL server
SQL server tools
Managing database
Scheduling tasks and alerts
Maintaining SQL server
Introducing SQL security
Managing users
Assigning user permissions
Backing up data basis
Restoring SQL data
Importing, exporting and distributing data
Setting up and configuring data replication
System optimisation and tuning fundamentals
Trouble shooting SQL server

Information Systems

The History of Computers

Introduction to Information Systems
Information System in Organisations
Hardware
Software
Organising Data and Information
Telecommunication
Transaction Processing Systems
Management Information Systems
Decision Support Systems
AI & Expert Systems
Security, Privacy and Ethical Issues in Information Systems
Information Resource Management

Systems Analysis

Systems development fundamentals
The modern systems analyst
Information systems building blocks
The systems development life cycle
Systems planning and systems analysis
Systems planning
Systems analysis
Data modeling
Systems design
Systems design
Data analysis
Process analysis and design
File and database design
Input and output design
User interface design
Systems implementation and support

MS Access

Introduction to Databases
The Database Foundation
Planning your Database
Starting Access
Creating, Opening, Saving, Editing and Closing Databases and Tables in Access
Entering Data into a Table, Formatting a Table and Creating Relationships between

Tables

Creating and Editing Forms
Searching for, Sorting and Filtering Data
Creating and Editing Queries
Creating, Modifying and Printing Reports

Computer Skillls

Word processing
Hardware, software and disk handling
Formatting and defragmentation of disks
Scanning drives
Document, folder and file management (create, save, retrieve, etc)
Toolbars
Keyboard management (insert, delete, move, search, etc)
Tables and graphics
Menus
Spell check
Fonts, numbering, headers and footers
Merge
Address labels and table of contents

Spreadsheets
Introduction to spreadsheeting
Introduction to Microsoft Excel 97
Starting Microsoft Excel 97
Moving the cell pointer
Organising your workbooks
Entering and editing data in your worksheet
Editing the worksheet
Cutting, copying and pasting data
Formatting cells
Creating simple formulas
Managing worksheets
Printing your worksheets
Creating charts
Working with databases

Business Management

The Business World and Business Management
The Business Organisation
The Business Organisation and the Business Environment
Introduction to General Management
Planning and Organising in Management
Leadership and Control in Management
The Marketing Process
Marketing Instruments
The Integrated Marketing Strategy
Public Relations
The Financial Function and Financial Management
Asset Management
Financing Decisions
The Operations Management Function
Activities, Techniques and Methods of Operations Management
The Purchasing Function and Activities
The Human Resources Function

Human Resource Management

Overview of HRM
Historical Development of HRM and Status Quo in the RSA
The Human Being as an Employee
Human Resource Planning
Recruitment
Selection
Placement and Induction
Performance Appraisal
Compensation
Fringe Benefits
Affirmative Action
Health and Safety
Motivation
Leadership
Quality of Work Life and Social Responsibility

Communication

Selling skills
Handling customer complaints
Making a public presentation
Handling interpersonal conflict
Business writing skills
Writing a memorandum and facsimile
Selling yourself - curriculum vitae and interview skills

Hard Ware & Network Administration

Hard ware

Introduction to Microcomputers
Safety
Microcomputer components
Miscellaneous hardware
Troubleshooting and preventative maintenance
Hardware installation and configuration
Diagnostics and repair
Printers
Printer diagnostics and troubleshooting
Local area network overview (LAN)
OSI model
Network connectivity
Wide area network infrastructure (WAN)
The Internet
Connecting to the Internet
Internet services
Customer services
The customer service organisation
DIReCtional troubleshooting
Communication skills
Customer interaction skills case scenarios
Disk Operating System (DOS)
System optimization under DOS
Windows
Introduction to Windows 95 and 98 and Ntv 4.0
Installing Windows
Windows basics
Windows 95 and 98 hardware management
Windows 95 and 98 software management
Basic management
Installing Windows NT workstation 4.0
Navigating the user interface
Windows NT hardware management
Windows NT software management
Windows NT user and security management

Network Administration

Introduction to LAN`s
LAN`s and Legacy networks
LAN`s and WAN`s
LAN`s, CAN`s, MAN`s and WAN`s
OSI model
Introduction to network connectivity
Topologies
Transmission media characteristics
Data link protocols
Ethernet and 802.3
Token ring and 802,5
Fiber distributed data interface
Building a cabling infrastructure
Wireless technologies and Access methods
Network adapter cards
Introduction to WAN infrastructure
Public carriers
Public carrier services
Bandwidth
Switched digital services
Putting it all together
Transmission control protocol/Internet protocol and multi-protocol support

Internet, Webpage and Powerpoint

Internet

Introduction to the Internet
History of the Internet
The World Wide Web (WWW)
Who controls the Internet
Open standards
Intranets and extranets
TCP/IP
Connecting to the web
Internet service providers
Configuring an Internet dial-up connection
Browsers
Navigating the world wide web
Troubleshooting Internet connectivity issues
Internet services
The importance of protocols
Electronic mail
Automated mail services
FTP
Telnet
Newsgroups

Webpage

Introduction
Up and running with font page 98
Creating web pages
Formatting web pages
Web graphics in the front page editor
Designing with tables
Defining hyperlinks
Adding dynamic content to your pages
Using plug-ins and applies
Automatic sites with front page components
Designing input forms
Collecting form input
Integrating frontpage with Microsoft Office
Creating web graphics with Image Composer
Apply image effects
Managing Image files
Using the personal web server
Using Microsoft Internet Information Server
Using Frontpage with Intranets
Orchestrating your web in the frontpage explorer
Creating webs from templates and wizards
Creating pages with templates

Powerpoint

Introduction to PowerPoint
Beginning a presentation
Drawing tools
Clip art and WordArt
Organisation charts and Microsoft Graph
Templates and the Slide Master
Slide shows, output, and presentation options
Saving presentations for Internet viewing and delivery
References

ASSOCIATED ASSESSMENT CRITERIA

In particular assessors should check that the learner demonstrates that he/she met all the exit-level outcomes.

Integrated Assessment

Theory:

Tests, projects, presentations and internal examinations. All tests have a practical and theoretical component, except for Information Systems, which is theoretically evaluated.

Practicals:

Hands-on exercises are completed throughout the programmes, with a final cumulative practical assessment encompassing the whole programme.

Resource center utilisation:

Learners must include a bibliography with all projects indicating resources consulted, whether reference material of the College or another source.

Experiential learning:

The practical computer based exercises noted above are evaluated by College staff. Experiential learning is an integral part of the programme. Learners are assisted by the College to find suitable workstations. A well structured Log-book, which gets signed by the learner, employer and college lecturer, is in use to ensure control over the actual work experience gained by the learner.

Projects:

Projects are assessed in terms of their suitability for, and use in, the working environment.

INTERNATIONAL COMPARABILITY

The programme compares favourably with similar international programmes based on comparison of brochures. Learners who have worked overseas, especially in Britain, report that they are very well qualified for comparable job opportunities.

The computer programming qualification is highly comparable in that the programming languages (Java, SQL, Network administration & the Internet) are international languages incorporated in the programme.

ARTICULATION OPTIONS

On completion of this qualification, besides careers in the formal programming industry, can be appointed in sales, marketing, accounting, data capturing and business fields.

MODERATION OPTIONS

The College subscribes to a variety of evaluation / moderation processes:

We use lecturers from universities and technikons to moderate the examination papers and scripts.

Own staff are being used as internal moderators and will be qualified as assessors in the near future.

We make use of registered assessors and people from the business sector to participate in the evaluation of practical projects.

CRITERIA FOR THE REGISTRATION OF ASSESSORS

N/A

REREGISTRATION HISTORY

As per the SAQA Board decision/s at that time, this qualification was Reregistered in 2006; 2009; 2012; 2015.

NOTES

Language of the Qualification

LEARNING PROGRAMMES RECORDED AGAINST THIS QUALIFICATION:

NONE

PROVIDERS CURRENTLY ACCREDITED TO OFFER THIS QUALIFICATION:

This information shows the current accreditations (i.e. those not past their accreditation end dates), and is the most complete record available to SAQA as of today. Some Primary or Delegated Quality Assurance Functionaries have a lag in their recording systems for provider accreditation, in turn leading to a lag in notifying SAQA of all the providers that they have accredited to offer qualifications and unit standards, as well as any extensions to accreditation end dates. The relevant Primary or Delegated Quality Assurance Functionary should be notified if a record appears to be missing from here.

1.	Durbanville College (Pty) Ltd