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
