Certificate Course in Business Computing

Overview

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

Project