HDCA

Course syllabus

Course name: HDCA Honours Diploma in Computer Application

Duration: 1 year

Chapter 1: Fundamental of Computer

Introduction of Computer
Computer Generations
Types of Computers
Classification of Computers
Hardware
Computer Memories System
Input / Output Devices
Software
Data Representation
Number System
Computer Virus & Vaccines / Anti-Virus,
Network
summaryï¿½
Exercise

Chapter 2:ï¿½ MS-DOS

Introduction of MS-DOS
File Naming
Internal Commands
External Commands
summary
Exercise

Chapter 3: MS-Windows –XP

Introduction
Windows Accessories
WordPad
Notepad
MS-Paint
Calculator
Character Map
Control Panel
Multitasking
Searching Files/Folders,
My Computer,
Windows Explorer
Folder
Recycle Bin
Briefcase
My Network Places
Clipboard
Disk Defragment
Personal Folders
Shortcut Keys
summary
Exercise

Chapter 4: MS-Windows -7

Introduction
New Features
Gadgets
summary
Hardware Requirements

ï¿½Chapter 5: Internet

Introduction
History of the Internet
Search Engine
E-mail Handling
Send SMS on Mobile
Summary
Exercise

Chapter 6: Multimedia

Introduction of Multimedia
VGA
Sound Card
Use of Removable Disk
CD/ DVD
Burning
summary
Exercise

Chapter 7: HTML

Intro of HTML
Different Tags
Creating Lists
Formatting of Text
Creating Hypertext Links
Table
Excel
summary
exercises

Chapter 8: MS- Office 2010

Introduction to MS-Office 2010
Installation of MS-Office
First View of Microsoft Office 2010
New File
Extensions
summary
exercises

Chapter 9: MS Word

Intro of MS-Word
Menus
Advanced Formatting
Editing Document
Table in Document

Mail Merge
Saving Document
Printing Document
Shortcuts Keys
summary
Exercise.

Chapter 10: MS Excel

Introduction to MS-Excel
Menus
Operator & Functions
Cell Formatting
Working with formulas and cell referencing
Auto sum
Formatting to worksheet
Graphic Objects
Chart
Database
Sorting
Filtering
Scenario Manager
List Box
Goal Seek
Validation
Macro

Printing Worksheet
Shortcut Keys
summary
Exercise.

Chapter 11: MS Power point

Introduction to MS- PowerPoint
Menus
Formatting
Drawing
Editing slides
Changing templates
Slide Layouts
Inserting Clipart
Sound and Movies into Slides
Add, Rearrange and Delete Slides,
Printing in Microsoft Power Point
Understanding Animation and Action Buttons
summary
Exercise.

Chapter 12: ï¿½MS-Access

Introduction to MS-Access
Menus
Create a Database Using Template
Create Table, Form, Query, Report, Pages and Macro
Table Sorting and Filtering

Database Security
summary
Exercise.

Chapter 13: ï¿½MS-Publisher

Introduction to MS- Publisher
Menus
Create a Certificate
Greetings Card through Template.
DCP
summary
exercises

Chapter 14: Concept of Programming

Pseudo-metrics
Methodology
Languages
Flow Chart
Introduction, Symbols
Data Flow Extensions
summary
Exercise

Chapter 15: ï¿½C

Introduction to Structural Programming & C
Features of C
Data Types
Variables, Constants Operators, Expressions Control Structures
Functions
Arrays

Strings
Structures & Unions
Pointers
summary
exercise

Chapter 16: C++

Introduction
Data Types
Operators
Control Structure
Functions
Arrays
Operator Overloading,
Inheritance
Virtual Function
Polymorphism
Pointers
summary
Exercise

Chapter 17: Visual Basic 6.0

Introduction of Visual Basic
Visual Basic Environment
Introduction to VB Control
Data Types
Variable
Constants
Calculation
Decision & Controls
Menus
Sub Procedures and Sub functions
Multiple Forms
List
Loops
Printing
Array
Data file
summary
Exercise

Chapter 18: ï¿½Oracle 9i

Introduction to SQL
SQL & DBMS
SQL Basic
Simple Queries
Multi table Queries
Database Updates
Data Integrity
Transaction Processing
Creating a Database
Views
Security

Summary
Exercise

ï¿½Chapter 19: Techniques of Software Development

Requirements
Design
Implementation
Verification
Maintenance

Chapter 20: Assignment & Project

S.No	Exam	% of mark to Certify	Timing (in minutes)
1	HDCA-ASSESMENT - HDCA-001	50	60