HONOURS DIPLOMA IN COMPUTER APPLICATION

Honours Diploma in Computer Application (HDCA)
(12 Months)

Objective

            Upon completion of this course, the participant acquires the advantage in choosing his / her career as an application Programmer, Computerized Accountant, Web programmer, Web master & Web content developer.

Target Audience

             School Final students / Graduates Students pursuing  

 a career in programming.

Prerequisites

          No prior Computer knowledge is required.

     COURSE COVERAGE     

I.END-USER APPLICATION

WINDOWS

_______________________________________________________

Computer Fundamentals - Introduction to OS/GUI - Wordpad - Notepad - Paintbrush - Windows Explorer - Control Panel.

MS OFFICE

_______________________________________________________

       

Word  Creating Text and Documents - Indexes and Tables - Embedding Picture - Table Manipulation - Mail Merge - Macro.       

 Excel  Formatting Cells - Charts - Pivot table - Data Table - Forms - Scenarios - Goal seek - Macros and Models.

 PowerPoint  Creating Presentations - OLE - Enhancing Presentation - Adding Audio & Video - Special Effects.

II.CLIENT / SERVER TECHNOLOGY

SQL SERVER

__________________________________________

SQL Enterprice Manager - Client Configuration Utility - T-SQL and ANSI SQL - Views and Index - Data Modeling - Data integrity - Triggers - Stored Procedures.

VISUAL BASIC 6.0

__________________________________________

Controls - User controls - Properties and Events - Control Statement and Loops - Procedures and Functions - Error handling - Creating Instances of Objects - Menu Editors - MDI Applications - Sequencial - Random and Binary File Handling - Data Manager - ODBC - RDO - ADO - Data Report -DHTML.

PROJECT*

___________________________________________

With our guidance students will undertake one Client - Server project using SQL Server as Back-end and Visual Basic as Front-end.

III.WEB PROGRAMMING

INTERNET

___________________________________________

Creating E-mail ID - Receiving & sending E-mail -  Chatting - Locating Information - Downloading.

HTML

___________________________________________

Tags - Links - Anchor - Adding Pictures - Lists - Tables - Frames - Forms - Menu Controls

FRONT PAGE

___________________________________________

Tables - Frames - Forms - DHTML effects.

VB SCRIPT

___________________________________________

Functions - Procedures - Objects - Event Handling - Forms and Frames. 

ASP

___________________________________________

Forms - Cookies - ActiveX Server Components - Database Supports - Reading and Writing to Files - Security. 

XML

___________________________________________

Elements - Attributes - creating & Designing Tags - Document Type Definition

PROJECT

___________________________________________

Development of Website.

III.Elective I

FINANCIAL ACCOUNTING

Tally.ERP 9

___________________________________________

Principles of Accounting - Voucher Types - Classification of Ledgers - Concept of Inventory Groups - Creation of Godowns - Stock Items - Concept of Sales and Purchase Order Processing - Making Voucher Entries for all transactions - Bank Reconciliation - VAT Computation - TDS - Service Tax - Concurrent Multilingual. 

Report

___________________________________________

Trial Balance - Balance Sheet - P&L Account - Outstanding statements - Reminders - VAT Reports - TDS - Service Tax Report.

MIS Reports

___________________________________________

Cash Flow - Funds Flow - Groups Comparison - P&L A/c. Multi stock Valuation - Movement Analysis - Multiple Financial Years, Backup and Restoration.

Database(MS-Access)

___________________________________________

Creating & Maintaining Database - Sort and Index - Programming Concepts - Concepts of Relational Database - Functions - Creating Form, Report, Queries.

PROJECT

___________________________________________

Students will be allowed to execute a project in financial accounting using real-life data from industries or business enterprise.

III.Elective II

PROGRAMMING TOOLS

"C" LANGUAGE

___________________________________________

Data Types - Operators - Expressions - Conditional Compilation - Looping & Branching - Arrays - Functions - Storage Classes - Structures and Unions - Pointers - Dynamic Memory Allocation - File Handling - Linked Lists - Double Linked List - Circular Linked List - Bit Manipulation - Introduction to Data Structure. 

OOPS Using c++

___________________________________________

Introduction to OOPS - Input & Output Streams - Classes & Objects - Member Functions - Function Overloading - Friend Functions & Classes - Operator Overloading - Constructor & Destructor - Inheritance - Polymorphism - File handling using Stream Classes - Instance - Templates.

PROJECT

___________________________________________

Development of System / Graphical Utility.