Certificate Course in Business Computing


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.

This course demands a command of wide-ranging specialized theoretical and practical skills, involving variable routine and non-routine contexts. 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.

Term Dates: Semester begins 30th September 2019.
Semester ends 28th February 2020.
Tutorial Times: 3pm – 5pm (TBC after registrations)
Number of 
learning hours:
320 hours over 4 months (4 hours a day, 5 days a week)
Course Materials Textbooks will be provided, learning materials available online
Eligibility Qualification Any Engineering /Science graduate with mathematics up to 10+2 level 
Candidate should have basic knowledge of computers, operating systems and networking fundamentals
Exit Profile: Software developer, IT Support, VB.NET developer, Database support and administration
Facilitator: Centre Head of CEIT
Course Fee: NZD $420.00

Detailed overview and learning objectives

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

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 (30 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 (16 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 (54 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

Management Development Program 

Introduction to communication, Barriers to communication, Kind of communication, Confidence building Non-verbal Communication, Fluency and vocabulary, Synonyms, Antonyms, Grammar, Noun Pronoun, Verb, Adjective, Preposition, Conjunction, Words of Idioms & phrases, Sentence Construction, Fill up the blanks, Pronunciation, Conversation practice, Polite Conversation, Greeting, Logical reasoning, General Aptitude, Writing: Covering letter, Resume, Email, Presentation Skill, group discussion, Interview skills, Mock interview