DETAILED SYLLABUS

DCA

 

 

 

 

 

 

 

 

 

 

 

 

 

 


 

No.

Title of the Subject

Duration/Hrs

  1.  

Computer organization and Operating system

45

  1.  

Personal computer software tools (MS Word,MS Excel and PowerPoint)

35

  1.  

Programming in C

40

  1.  

Designing and publishing using PageMaker, Photoshop and CorelDraw

35

  1.  

Open office

35

  1.  

Lab -I

35

  1.  

Seminar

25

  1.  

Web Technology using Photoshop and HTML

40

  1.  

Windows programming through Visual Basic

40

  1.  

System analysis and design

25

  1.  

Object Oriented Programming through C++

40

  1.  

Lab -II

35

  1.  

Project and viva

50

Total

480


DCA -1 

Computer organisation & operating systems

 

 

1.       TYPES OF COMPUTER

          Analog, Digital, and Hybrid type, Hardware, Software, System software, Application software, Stored Program Concept and Von Newman Architecture, Firm ware, Human ware, Stored Program Concept, Evolution of computers, Generation of computer.       

 

2.       Background AND NUMBER SYSTEM

          Information Representation and Codes, Data Types, Complements, Addition and Subtraction of Binary Numbers, Fixed Point and Floating Point Representation, Octal and Hexadecimal System , Conversion of Number Systems, Alpha Numeric Codes – ASCII & EBCDIC, Error Detection Codes, Building Blocks of Computers, Combinational Blocks (Gates, Multiplexes, Decoders, Encoders etc.), Sequential Building Blocks (Flip Flops, Registers, Counters, Random Access Memory, etc.)

 

3.       Register Transfer Language and Micro-Operations

          Register Transfer Language, Concept of Bus, Bus and Memory Transfer, Arithmetic Micro Operations, Logical and Shift Micro Operations

 

4.       Architecture of a Simple Processor

          A Simple Computer Organization, Computer Registers, Computer Instructions, Timing and Control, Instruction Cycle, Program Interrupts, Design of Basic Computer

 

5.       CPU Organization

          Addressing Modes, Instruction Formats, CPU Organization with Large Registers, Stacks and Handling of Interrupts and Subroutines, Instruction Pipelining : Storage, Hazards and methods to Remove Hazards

 

6.       PROGRAMMING LANGUAGES

          Machine language, Assembly language, High level language

 

7.       ORGANISATION OF A DIGITAL COMPUTER

          Input unit, Output unit, Central Processing unit, Memory

 

8.       DATA PROCESSING

          Data collection, Classifications, Sorting and Merging, Processing, Summarising

          Storing

 

9.       DATA ORGANISATION

          Organisation Data, Character, Field, Record, File, Database, Sequential Access, Random Access, Indexed Sequential Access

 

10.     PROGRAMMING PROCESS

          Problem Definition, Algorithm, Flowchart and coding, Testing and debugging, Implementation, Documentation, Structured Programming,  

11.     DATA COMMUNICATION

          Local Area Network, Wide Area Network, Satellite Communication, Internet

 

12.     OPERATING SYSTEM

          Introduction, Different Operating Systems, Loading and Quitting the Operating Systems

          Important DOS Commands

 

 

DCA -2

   personal computer software tools 

(ms word, EXCEL AND powerpoint)

 

WINDOWS

 

1.       WINDOWS INTRODUCTION

          Operating System

 

2.       Desk top icons

          My Computer, Recycle Bin, Internet Explorer, Network Neighborhood, My Documents

 

3.       Working with windows

          How to create a Folder, Copying and cutting files, Renaming

 

4.       START ICON

          Programs, Favorites, Documents, Settings, Find, Run, Shut down

 

5.       APPLICATION ICONS

 

MS WORD

 

1.          AN INTRODUCTION TO WORD

             The Word work space, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros

 

2.          HOW TO USE MOUSE AND MENU

             Working with dialog box

 

3.          PRIMARY COMMANDS IN FILE MENU

             The Open Commands, The File name commands, The New commands, The Save, Save As, and Save all  commands, The Close command, The Page setup, The Print commands, The Exit commands

 

4.          EDIT MENU COMMANDS

             The Cut, Copy, and Paste commands, The Undo and Repeat commands         

 

5.          FORMAT COMMANDS

             Font commands, Paragraph commands

 

6.          OTHER MENU

             The view menu, The Insert menu, The tool menu, The table menu, The Window menu

 

EXCEL

 

1.          BUILDING A SIMPLE WORKSHEET

             Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing Entries, Copying Entries, Moving Entries, Inserting and Deleting cells

 

2.          FORMATTING BASICS

             Changing Character Style, Changing Alignment, Changing Column Width

 

3.          WORKING WITH MULTIPLE WORKSHEET

             Copying entries between work books, Moving sheets between work books, Deleting sheets, Quitting Excel

 

4.          OPENING EXISTING WORKBOOKS

             Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges

 

5.          FORMATTING TEXT

             Displaying dollars and cents, Formatting decimal places, dates Format, Copying style and formats

 

6.          FORMULAS THAT MAKE DECISIONS

             Using the IF function, Using the nested IF function, Copying formulas               

 

7.          Checking Spelling, Printing Worksheets, Preview Worksheets, Setting up the pages,

 

8.          Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records

 

9.          Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format

            

10.        Creating Macros, Recording Macros, Running Macros

 

 

Power Point

1.       POWER POINT

          Main Features of Power Point

 

2.       Making the Presentation

          Creating Template with the Auto Content Wizard. Creating a Presentation with a Template.  Creating a presentation from Scratch

 

3        Different Views

          Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master

 

4        Animation, Art and Sound

          Controlling Transitions between slides.  Animating Different Parts of a slide.  Inserting a Motion Clip.  Including Sounds in slides.

 

5.       Including Graphs, Charts, Tables and Columns

          Organization Chart Slide, Creating a table Slide.  Creating two column Slide, Module  1: Showing  A Presentation, Rehearsing/ Timing a Presentation, Designation some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.

 

6.       Techniques for Making a Show Livelier

 

7.       Office Connections

          Presenting with the help of other Office Programs Importing the text from a World Document.

 

8.       Printing a Presentation

 

dca-3

 programming in c

 

1.       An overview of C language

          History – Structure of a C Program

 

2.       Data Types

          variables – Constants – Type Modifiers – Storage Class Specifiers Expressions – Operators – Assignment Statement

 

3.       Program Control I/O

          Unformatted and Formatted Console I/O Operations

 

4        Arrays

          Single, Two and Multi Dimensional

 

5.       Functions

          General form - Declaration and Prototypes – Function arguments – Scope rules – Recursion

 

6.       Pointers - & and * Operators

          Pointer expressions – Pointer assignments – Pointer Arithmetic – Pointer Comparison –   Pointers to Functions – Function returning Pointers

 

7.       Structures and Unions and User Defined variables

          Structures – Unions – Enumerated Data Types – Type of DEF

 

8.       File Handling

          File Pointer – File Assessing Functions – fopen, fclose, putc, Getc, feof, ferror, fprintf, fscanf, fgets, fputs, fseek function – ftell, #define , #include, #undef, #if, #else, @elif

 

DCA - 4

designing and publishing in computer

USING PageMaker ,Photoshop AND coreldraw

 

PageMaker

 

 

1.       Introduction

          Introduction to Desk Top Publishing, Introduction to Page Maker Advantages, Using the Mouse, Components of the Page Maker Window

 

2.       Creating a new Document

          Setting the Margins, Setting the Page Size, Changing the page Orientation, Setting Page Numbers, Changing the Page Size view, Creating New Document Windows: Displaying the Rulers, Changing the Rulers, Using Rulers, Using Guidelines, Positioning Guidelines., Adding Guidelines to Master Pages.  Aligning to Guidelines, Displaying Guidelines, Locking Guidelines.  Formatting Types: Changing Font Families, Changing Fond Sizes, Changing Typeface Style, Changing Character Specifications : Changing Type leading, Changing Character Widths, Changing Tracking, Changing Type Options.  Saving Your Document:  Saving a new Document, Saving an existing Document, Saving a Document as another document, Reverting to a Previously Saved Version.  Developing Paragraphs: Typing Text, Adding special Characters to Text, Aligning Text.  Formatting paragraphs:  Changing Indents, Changing the space around Paragraphs, Changing paragraph Alignment, controlling How Paragraphs Break Between Pages and Columns, Adding lines Above or Below Your Paragraphs.

 

3        Introduction to Creating Frames

          Converting Other Objects to Frames, Threading and Unthreading Text.  Threading additional Text, Threading Text to Different Page, Unthreading Text Blocks, Rethreading Text Blocks, Making Text 

         

          Blocks Disappear Without Deleting them, Selecting and Dragging Text, Editing Deleting Text, Cut, Copying, Pasting Text, Viewing the Contents of Clipboard, Using Undo and Revert.  Inserting and Removing Pages:  Inserting and Removing Pages, Adjusting Spacing of Characters, Words, Lines : Adjusting, Spacing and Leading, Setting and changing Tabs. 

4.       Introduction to Auto Flow, page maker Plug-Ins, Drop Cap, Change Case, Bullets and Numbering.

 

5.       Adding Design Elements- Introduction

          Adding Graphics to your Document, Adding Lines, Changing Lines Specifications, Adding Shapes, changing Shape specifications, Changing Line and fill, Specifications together (Fill and Stroke), Changing Round Corners, Creating Drop-Shadow, Boxes, Text wrap, Changing page maker Options: Adjusting Margins, Setting and Adjusting Columns, Setting Unequal Width Columns, Creating headers and Footers, Creating Graphics in page maker, Rotating Text, Skewing and Mirroring objects with Control Palette.  Importing Graphics into page maker : Placing, Sizing, aligning Graphics, Cropping Graphics.

 

6.       Setting Up Templates

          Setting Up Master page Templates, Creating Custom Page Sizes, Creating Custom Boarders, Creating a News Paper Template, Creating New master Pages, Saving an existing Page As a Master Page.  Setting UP Custom Styles: Defining Styles, Creating, Editing, Removing Styles and Copying Styles.

 

7.       Introduction to Using layers , n- Layers Palette, Moving and creating objects. Introduction to Printing- Selecting a Printer, Printing your Document, printing Document Dialog Box Options. 

 

8.       Adding Color

          Introduction – Using Page Makers Default Color Palette, Opening Color Palette, Adding color to Text, Working with Color Graphics, Defining Custom Colors, Creating Text Screens.

 

9.       Developing Long Documents

          Introduction – Using Story Editor: Opening Story Editor, How the Story Editor names, Tories, Switching Between Story Editor and Layout Editors, Closing Story Editor and Placing the Story Editor, Differences between Story Editor and layout Editors.

 

10.     Spellings:

          Starting the speller, Correcting Misspelled Words, Correcting Duplicate Words, Adding Words to the different Dictionaries, Correcting Duplicate Words, using find Feature, Using the change Feature, Creating an Index, using page Maker Help.

 

 

 

ADOBE PHOTOSHOP

 

1.          Introduction

                 Getting Stock Image, Tools, Getting Images into Photoshop, Creating New Images, Selecting Colors and Display Mode, Selecting Tools, Path, Mask, Editing, Layers, Filters

 

2.          Saving and Developing Images

             Application using Images

 

3.          Retouching a Photography

             Remove a Stain from a Photo, Remove Blemishes, Rubbing out an unwanted person, Repairing the Cracked Photography, Cloning a Pattern, Cropping an Image, Making Things Appear Small

 

4.          Working with Old Photographs

             Warped Photograph, Wrinkled Photograph, Faded Photographs

 

5.          working with Fixed Media

 

 

       COREL DRAW

 

1.          Basics of CorelDraw

             Introduction-Getting Started-Creating A New File - Title Bar-Menu Bar-Work Area-Printable Page-Property Bar-Page Counter Bar-Colour Palette-Toolbox-Status Bar-Drawing Figures-Lines-Ellipse-Circles-Rectangle-Square-Polygon-Saving-Closing-Opening-Views-Normal View-Preview-Wire Frame View-Draft View-Zoom-View Manager-Creating a View.

2.          Drawing

             Introduction - Toolbox-Selecting an Object-Resizing an Object-Moving an Object-Changing the Shape-Combining Two Objects-Skewing-Welding the Objects-Blending-Curve Lines-Straight Lines-Continuing a Line-View Mode-Changing-Media Tool-Rotating An Object-Grouping-Fill Tool Fly Out-Filling-Spray Mode.

3.          Text

                        Introduction-Text Tool-Entering Artistic Text-Entering Paragraph Text-Converting Text-Formatting Text-Changing the Font Size-Arranging Objects-Ordering The Objects-Changing the Font-Bullets-Decorating the Text-Webdings-Text Editor-Opening-Changing the Alignment-Type Style-Spell Checking-Grammer-SearchingSynonyms-Find-Replace-Editing-Kerning-Formatting Characters.

 

4.          Image

             Bitmap Images-Vector Image-Resizing-Rotating-Skewing-Moving-Cropping-Importing Images-Adding Special Effects-Converting to Bitmap-Exporting Images.

5.          Page Layout

             Changing the Page Size-Changing the Layout-Applying Styles-Applying Bitmaps to the Background - Changing the Background-Adding a Page Frame-Moving Between Pages.

DCA -5

OPEN OFFICE

 

1.         Overview of OpenOffice.org Calc

1.   Describe the features of OpenOffice Calc

2.   The OpenOffice Calc Screen

2.         Entering Information in a Worksheet

1.   Entering numeric values

2.   Entering text values

3.   Entering dates and times

4.   Entering notes

5.   Entering formulas

6.   Saving the workbook

 3.        Editing the Worksheet

1.   Selecting cells and ranges

2.   Clearing and deleting cells

3.   Undoing commands

4.   Using Cut, Copy and Paste

5.   Adding rows and columns to the worksheet

6.     Entering a series of labels, numbers and dates

4.         Formatting a Worksheet

1.   Formatting cells

2.   Applying an Autoformat to a table

3.   Changing column widths and row heights

4.   Inserting page breaks

5.         Organising Information with Workbooks

1.   Linking Information between worksheets

2.   Using more than one Workbook

 6.        Customising OpenOffice Calc to work the way you do

1.   Using the Zoom command

2.   Setting AutoCorrect options

3.   Setting Printing Options

4.   Controlling Page Orientation

5.   Adjusting the Margins

6.   Adding gridlines and other options

7.         Creating worksheet charts

1.   Planning a Chart

2.   Creating a Chart

3.   Formatting a Chart

 

DCA -6

LAB - I

 

DCA -7

SEMINAR

 

dca -8

WEB TECHNOLOGY USING PHOTOSHOP AND HTML

 

 

1.         INTRODUCTION TO PHOTOSHOP

2.         INTRODUCTION TO GRAPHICS TOOLS IN PHOTOSHOP

3.         INTRODUCTION TO COLORS,PATHS,WORKING WITH TEXT

4.         DESIGN WEB PAGES,BUTTONS,LOGOS

5.         ANIMATION USING  PHOTOSHOP

 

 

DCA-9

windows programming through visual basic

 

1.         Windows Programming Visual Basic Environment

Windows Programming Concepts, Windows GUI, Application Programming Interface, Features of Windows OS, Kernal, User and GUI Services, Other APIS, Memory Models, Message Architecture of Windows, Call Backs, Window Procedures, Message Queries, Graphic Device Context, Resources in Windows, registry Dynamic Kinking Concept, Platform Difference , Windows NT, Windows 95, Other Platforms, Windows and VB Features, Steps involved in Developing a simple VB Application, Visual Basic Environment IDE Features, General – Menus and Windows, Single Document Interface Environment (SDI), Toolbox and Controls, Form Window, Project Explorer, Form Designer, Object Browser Short cut (pop up) Menus, VB Editor, Creating Simple Application

 

2.         Forms, Tool Box, Standard Controls, Menu Designing and Dialog Boxes

From, The Anatomy of a Form, Controls, Properties, Events and Methods, MDI Forms, Creating MDI Forms, Using Form Wizard, Tool Box, Controls, Properties, Events and Method, Custom Controls, Properties, Events and Methods, Command Button, Text Boxes, Frame Controls, List Boxes, Combo boxes, Image controls, Timer, Scroll bars, Drive List, Directory List Box, Data Control, Menu Properties, Check Event Menu Methods, Creating Menu with Menu Editor, Menu Design, Sample Menu Design Window, MDI Forms, MDI Parent & Child Forms, Window Menu, Title Converting & Arranging Child Windows, Dialog Boxes, Custom Dialog Boxes, Designing Custom Dialog Boxes, Common Dialog Boxes, File Open, File Save, Color Changing Print, Font Choice – Method.

 

3.         Visual Basic Programming

Modules and Design, Variables, Constants, Statements, Control Structures, Decision making Statements, if … else statements, Select … Case, Goto, Looping Statements, Do … while, Do … until, For … next, While … wend, Exit Statements, Functions, Built-in Functions, Working with Sun and Function Procedures, Public, Private & Static Scopes Friend Functions, Arrays, Files, Sequential Files, Random Files, Binary Files, Processing File in VB, Database Features, Data Controls, Advanced Database Controls, Tables and Queries

 

4.         OOPs in VB, IDE and Crystal Reports

OOPs Concepts, Properties and Methods of and Object, Inheritance, Encapsulation Polymorphism Character, Object and VB, OLE, OLE Control, Creating an Object in VB, General property Procedures, Creating a New Class Module, Using Object Browsers IDE Features, Extension of IDE with Add-Ins, Loading Add-Ins into IDE, Using Add-Ins Application Wizard, Add-Ins Tool Bar, Creating Add-Ins, Application Level Utility Module Level Utility, Procedure Level Utility, Crystal Reports, Using Crystal Reports Understanding and Using Print Form Methods, Printing Reports

 

5.         Using ActiveX

Using ActiveX, ActiveX Platform, ActiveX Requirements, Role of ActiveX in Software Development, Creating & Using ActiveX Documents, ActiveX Controls, ActiveX DLL, ActiveX Excel, Windows API, API Functions, Windows API Library Files, Declaring a Windows API Function, Statements, Data Types, Introducing DLL, DLL Calling Converts, API Viewer Using API Application.Multiple mode, Paintbrush to OS, Linear gradient tool

 

 

6.          Preparing Image for the WEB

             Creating WEB Pages with Images

 

 

dca -10

system analysis and design

 

1.          Introduction

             Introduction, System Definition and Concepts, Real – Life Business Subsystems, System Models; Types of Models, System Environments and Boundaries, Real – Time and Distributed Systems, Basic Principles of successful Systems.

 

2.          System Analyst

             Introduction, Role and Need of Systems Analyst, Qualifications and Responsibilities, Systems Documentation as an Agent of Change.

 

3.          System Development Cycle

             Introduction, Introduction to Systems Development Life Cycle (SDLC), Various Phases, Systems Analyst as an Agent of Change.

 

4.          System Planning

             Introduction, Data and Fact Gathering Techniques, Feasibility Study and its importance, Types of Feasibility Reports, System selection Plan and Proposal, Prototyping, Cost Benefit Analysis.

   

5.          System Design and Modeling

             Introduction, Process Modeling, Logical and Physical Design, Design Representations, Systems Flowcharts and structured Charts, Data Flow Diagrams, Common Diagramming Conventions and Guidelines Using DFD and ERD for Data Modeling and System Analysis.

 

6.          Input and Output

             Introduction, Classification of Forms, Input/Output Forms, User Interface Design, Graphical Interfaces.

 

7.          Modular and Structure Design

             Introduction, Module Specifications, Module Coupling and Cohesion, Top-down and Bottom-up interfaces.

 

8.          System Implementation and Maintenance

             Introduction, Planning Considerations, Conversion Methods, Procedures and Controls, System Acceptance Criteria, System Evaluation and Performance, Testing and Validation, System quality Control and Issues.

 

 

 

9.          System Audit and Security

             Introduction, Computer System as an Expensive Resource, Procedures and Norms for Utilization of Computer Equipment, Audit of Computer System Usage, Audit Trails, Types of Threats to Computer System and Control Measures.

 

 

dca -11

 object oriented programming through c++

 

1.       OBJECT ORIENTED PROGRAMMING CONCEPTS

          Introduction, Need of OOP Concepts, Data hiding, Encapsulation, Polymorphism

 

2.       BASIC CHARACTERISTICS OF OOP

          Objects, Classes, Inheritance, Reusability, Polymorphism, Operator Overloading

 

3.       C++ PROGRAMMING-BASICS

          Structure of a Program, Preparations of a program, Functions, Extractions and Insertion Operators, Data types, Variables, Manipulators, Operators, Header files and library files, Error types

 

4.       DECISION MAKING

          Introduction, Using IF statement, Nesting of IF………..ELSE statement, Switch statement, Conditional statement, GO…….TO       Statements, Examples

 

5        MAKING LOOPS

          Introduction, While Statement, Do Statement, For Statement, Control Statements, Examples

 

5.       FUNCTIONS

          User defined functions, Defining, Functions- Prototypes, Passing arguments, Return statement, Recursion, Online functions, Examples

 

7.       ARRAYS

          Introduction, One dimensional arrays, Two dimensional arrays, Arrays of strings, Passing arrays to functions, Examples

 

8.       STRUCTURES

          Introduction, Definition, Accessing Members, Comparison of Structure Variables, Arrays of structures, Size of structures, Union, Enumerated data type, Examples

 

9.       OBJECTS & CLASSES

          Introduction, Objects and classes, Public and private, Member functions, Constructors

          Destructors, Member functions outside the class, Operator programming, Examples

 

 

10.     INHERITANCE

          Introduction, Derived class and Base class, Accessing Base class members, Protected access specifier, Multiple inheritance, Examples,

 

11.     POINTERS

          Under standing pointers, Accessing increments and scale factor, Pointer increments and scale factor, Pointers and Arrays, Pointers and Functions, Pointers and Structures

          Memory management with new & delete, Concepts of linked lists, Advantage of lists

          Types of linked lists

 

12.     VIRTUAL FUNCTIONS & POLYMORPHISM

          Introduction, Virtual functions, Late binding, Friend functions, Friend classes, Example

 

13.     FILES AND STREAMS

          Introduction, Steam class, Opening and closing of files, Allowed modes, Reading and Writing files, File pointers, Command line arguments

 

 

DCA -12

LAB - II

 

DCA -13

PROJECT AND VIVA