HDCA (Programming) Honours Diploma in Computer 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 Presentation –  OLE – Enhancing Presentations  –  Adding Audio & Video – Special Effects.

INTERNET

Introduction to Internet,  www , http &  E-mail  –  Creating E-mail ID  – Receiving  & Sending E-mail  –  Chatting  – Locating Information  –  Downloading.

II .Client / Server Technology

VISUAL BASIC

Controls – User Controls – Properties and Events – Control statements and Loops – Procedures and Functions – Error Handling – Creating Instances of Objects – Menu Editors – MDI Applications – Sequential, Random and Binary File Handling – Data Manager – ODBC – OLEDB- Data Controls and SQL – Active x – RDO – ADO – Data Report- DHTML.

MySQL

Client / Server Concepts – Relational Model – Data Definition Using SQL – Modify Tables – Using ALTER TABLE Queries, Add a Column, Add an Index, Add a Primary Key – INSERT and DELETE Queries – UPDATE Queries – Using Select Queries – SELECT, WHERE, LIMIT, ORDER BY, GROUP BY, JOIN -Constraints  and Indexes – Views – Expressions – Grouping -Using Functions – Math Functions, Compare String values, Work with Dates – JOIN and Subqueries – Advanced MySQL Query Processing – Database Management, Stored Procedures, Triggers, etc.

PROJECT*

With our guidance students will undertake one Client- Server Project.

III. 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 List –  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.

PYTHON – 

Introduction to Python – History – Features – working with Python – Basic Syntax – Variable and Data Types – operator and Expression – Conditional Statements – If – If – else – Nested if-else – Looping – For – while – Nested loops – Control Statements – Break – Continue – Pass – String Manipulation – Accessing String – Basic Operation – String slices – Function and Methods – Lists – Introduction – Accessing list – Operation – Working with lists – Functions and Methods – Tuples – Introduction – Accessing tuples – Operations – Working – Functions and Methods – Dictionaries – Introduction – Accessing values in dictionaries – Working with dictionaries – Properties – Functions – Defining a function – Calling a function – Types of functions – Functions Arguments – Anonymous functions – Global and local variables – Modules – Importing module – Math module – Random module – Package – Composition – Input-Output – Printing on screen – Reading data from keyboard – Opening and closing file – Reading and Writing files – Functions – Exception Handling – Exception – Except clause – OOPs concept – Class and object – Attributes – Inheritance – Overloading – Overriding – Data hiding – Polymorphism – Data Structure.

ADVANCED PYTHON PROGRAMMING

MySQL Database Access

GUI Programming (Tkinter)

Image Processing in Python with Pillow