CEIT is now accepting Registrations into the Certificate Course in Business Computing.

Semester Dates:Starts: Monday 6th March, 2023
Ends: Friday 7th July, 2023
Tutorial Times:5 pm – 7 pm every Thursday
Number of learning hours:320 hours over 13 weeks plus 4 weeks to complete major assignment and final examination
Course MaterialsTextbooks will be provided, learning materials available online via MOODLE
Eligibility QualificationThis course is suitable for anyone with intermediate level computer and programming skill. This course is suitable for IT Professionals
Exit Profile:Database administrator, VB.Net developer, IT Support
Facilitator:Miimetua Nimerota
Course Fee:$420.00 NZD

Detailed Overview and Learning Objectives

The objective of this course is to provide the student with skills, knowledge and competency in basic programming and advanced Microsoft Office. This qualification has a strong focus on information technology, software development life cycle, database technology, and communication skills. Students will develop understanding and skills in C programming, Object Oriented programming, Entity Relationship models, SQL data manipulation, and database technology. The end of the course students will gain confidence in using MS Access to design, create and manage simple databases, and using simple queries to search for data records.

Students who will complete this course will be able to work in ICT industries as a software developer, IT Support, VB.NET developer, Database Administrator and Support. This qualification can complement professionals working in various other industries such as finance, marketing, management, administration, law enforcement. Prospective students must have a sound knowledge of computer basics, and fundamentals of programming language.

This qualification has been designed in consultation with industry and domain expert keeping in mind the need for a more information and digitally literate workforce. In addition to these learning objectives, students will also have in-lab practice in basic computer security practices pertaining to antivirus/malware scanning of storage devices, phishing, identifying secure websites online, and more.

By the end of the course (320 learning hours) students will have developed an understanding, and competency in the following modules.

Sl. No.Module NameHours
1Fundamentals of Computers & OS Concepts        20
2Advanced MS Office 60
3C Programming 30
4Software Development Life Cycle20
5Object Oriented Programming with C++ and DS40
6Database Management using Ms Access30
7VB.Net as Front End 60
8Major Project 60
Total320

Detailed Course Outline

The CCBC Curriculum is competency and skill based which ensures students are able to demonstrate their skill in practice in order to effectively achieve the course learning objectives. Assessments are a combination of theory and practical, including classroom discussions, presentations, projects, and written examinations. 

This qualification is accredited through the Centre for Development in Advanced Computing (CDAC) under the National Skills Qualification Framework of the National Skills Development Agency, Government of India, and in partnership with India European Union Skills Development Project.

Fundamentals of Computer & OS Concepts (20 Hours)

  • Computer Fundamental:  Uses of Computer, Hardware, Accessories,
  • Types of computer
  • Hardware and Software
  • Operating System
  • Process Management
  • Threads
  • Process Scheduling
  • Memory Management
  • Virtual Memory
  • Input Output Management
  • File Management
  • Deadlocks
  • Inter–process Communication 
  • Classification of Computers 
  • Introduction to windows operating systems
  • The desktop, The window, application window, document window, Dialog Window
  • The Icons, Explore Your Computer, The Start Button and Taskbar.
  • My Computer, Windows Explorer, Starting and Closing Programs,
  • Installing Operating System
  • Performing a New Installation for Windows
  • Installing a Software other than OS
  • Setting up a printer
  • Uninstalling software

Advanced MS Office with Access (60 Hours)

  • MS Office 2010
  • Installing MS Office 2010
  • MS Word 2010
  • MS PowerPoint 2010
  • MS Excel 2010
  • MS Access 2010

C Programming (30 Hours)

  • Introduction to Programming Language
  • C Fundamentals
  • Operators and Expressions
  • Data Input and Output
  • Control statement
  • Functions
  • Arrays
  • Pointers
  • Structures and Unions 

Software Development Life Cycle (20 Hours)

  • Software: A Process
  • Various Phases in s/w Development
  • Software life cycle agile model
  • Introduction to Coding Standards
  • Testing Strategies and Tactics
  • Writing Test Cases
  • Configuration management
  • Software Quality Assurance 

OOP with C++ with DS (40 Hours)

  • OOP concepts
  • Programming constructs
  • Functions
  • Access Specifiers
  • Classes and Objects
  • Overloading
  • Inheritance
  • Polymorphism
  • Templates

Database Technologies (30 Hours)

  • Introduction to DBMS
  • Types and Components of DBMS
  • Advantages of DBMS
  • Database Design
  • Codd’s Rules
  • Normalization Techniques
  • Introduction to Oracle
  • SQL* Plus
  • DDL, DML and DCL
  • Tables, Indexes and Views
  • PL/SQL
  • Cursors
  • Stored Procedures
  • Triggers

VB.NET as Front–End (60 Hours)

  • Event driven programming
  • Form object
  • Data Types & Operators in VB
  • User Interface and control names
  • Procedures and functions
  • Modules and scopes
  • VB.Net Objects and Methods
  • Exception Handling
  • Classes
  • Inheritance, Polymorphism
  • Class Libraries
  • Interfaces & Abstract Classes
  • Delegates and Events
  • Intrinsic controls in VB .NET
  • Common controls in VB
  • User interface design (MDI & SDI Models)
  • Dates, Strings, Array, Collections
  • Structures
  • Working with Databases

Learning Resources and Student Support Services

Students will have full access to all CEIT and USP facilities throughout the semester. 

  • Course materials available online via MOODLE
  • CEIT library for textbooks and reference materials
  • Highly qualified and experienced trainers
  • Free academic counselling by appointment only
  • Computer lab is equipped with digital smartboard, computers and high-speed internet

Click here for a copy of the CCBC Qualification File