Download Syllabus DCA

UNIT I Brief History of Development of Computers ,Computer System Concept, Computer System Characteristics, Capabilities and Limitations, Types of Computers-.,Personal Computer (PCs) - IBM PCs, Types of PCs- Desktop, Laptop, Notebook, Palmtop, etc. Basic Components of a Computer System - Control Unit, ALU, Input/Output semiconductor Memory. Storage fundamentals - Primary Vs Secondary memory.
UNIT II Input Devices: Keyboard, Mouse, Joystick, Scanners, Digital Camera, Scanners-MICR, OCR, OMR, Light pen, Touch Screen. Output Devices Monitors - Characteristics and types of monitor, Size, Resolution, and Refresh Rate Printers - Daisy wheel, Dot Matrix, Inkjet, Laser. Plotter, Sound Card and Speakers. Various Storage Devices - Magnetic Disks, Hard Disk Drives, Floppy, Disks, Optical Disks, Computer Software ,Need, Types of Software's - System software, Application software System Software - Operating System, compiler ,Assemblers, Interpreter .
UNIT III Operating Systems Functions , Types- Batch, Single, Multiprogramming, Multiprocessing Programming languages- Machine, Assembly, High Level, 4GL, Application Software - Word-processing, Spreadsheet, Presentation Graphics, Data Base Management Software, Number System, Number System of computers- Binary, Octal, Hexadecimal.
UNIT IV Direction of Transmissions Flow-Simplex, Half Duplex Full Duplex, Types of Network - LAN, WAN, MAN etc. Topologies of LAN - Ring, Bus, Star, Mesh and Tree topologies. Computer Virus: Virus working principals, Types of viruses, Virus detection and Prevention Viruses on network.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I MS Windows: Introduction to MS Windows; Features of Windows; Various versions of Windows & its use; Working with Windows; My Computer & Recycle bin ; Desktop, Icons and Windows Explorer; Screen description & working styles of Windows; Dialog Boxes & Toolbars; Working with Files & Folders; simple operations like copy, delete, moving of files and folders from one drive to another, Accessories Ms Paint, notepad
UNIT II Office Packages: Office activates and their software requirements, Word-processing, Spreadsheet, Presentation graphics, MS Word Basics: Introduction to MS Office, Introduction to MS Word, Features & area of use. Working with MS Word, Menus & Commands, Toolbars & Buttons, Shortcut Menus, Wizards & Templates, Creating a New Document, Different Page Views and layouts, Paragraph and Page Formatting, Text Editing using various features ; Bullets, Numbering, Auto formatting, Printing & various print options. Advanced Features of MS-Word: Spell Check, Thesaurus, Find & Replace; Headers & Footers, Inserting - Page Numbers, Pictures, Files, Auto texts, Symbols etc., Working with Columns, Tabs & Indents, Creation & Working with Tables including conversion to and from text, Margins & Space management in Document, Graphics, Mail Merge, Envelops & Mailing Labels.
UNIT III MS Excel: Introduction and area of use, Working with MS Excel, concepts of Workbook & Worksheets, Using Wizards, Various Data Types, Using different features with Data, Cell and Texts, Inserting, Removing & Resizing of Columns & Rows, Working with Data & Ranges, Different Views of Worksheets, Column Freezing, Labels, Hiding, Splitting etc., Using different features with Data and Text; Use of Formulas, Calculations & Functions, Cell Formatting including Borders & Shading, Working with Different Chart Types; Printing of Workbook & Worksheets with various options.
UNIT IV MS PowerPoint: Introduction & area of use, working with MS PowerPoint, Creating a New Presentation, Working with Presentation, Using Wizards; Slides & its different views, Inserting, Deleting and Copying of Slides; Working with Notes, Handouts, Columns & Lists, Adding Graphics, Sounds and Movies to a Slide; Working with PowerPoint Objects, Designing & Presentation of a Slide Show, Printing Presentations, Notes, Handouts with print options.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

Unit 1: Introduction to Programming : The Basic Model of Computation, Algorithms, Characteristics of Algorithm Language, Flow-charts- Symbols of Flow Chart , Flow chart rules, Advantage of using flowcharts, Limitation of Flowcharts, Examples of Flow Chart with decisions etc., Programming Languages Machine Language, Assembly Language, Low level and High-level Language, Source and Object Language, Brief Description of High Level Languages (BASIC, FORTRAN, COBOL, C Language, Assembly Language) Compiler, Linker, Loader, Testing and Debugging Syntax Errors, Linking Errors, Runtime Errors, Logical Errors, Difference between Testing and Debugging, Documentation User Documentation, Technical Documentation, Aim of Documentation,
Unit 2: Algorithms for Problem Solving : Sample Algorithms -Exchanging values of two variables, summation of a set of numbers, Decimal Base to Binary Base conversion, Reversing digits of an integer, GCD (Greatest Common Division) of two numbers, Test whether a number is prime, Organize numbers in ascending order, Find square root of a number, factorial computation, Fibonacci sequence, Reverse order of elements of an array, Find largest number in an array, Print elements of upper triangular matrix, multiplication of two matrices
Unit 3: Pseucode: Benefits of Pseudocode, example of Pseudocode ,Tools of structured Analysis: Physical and Logical DFD with examples, Context Diagram, First Level DFD, Data Dictionary, Importance of Data Dictionary, Elements of Data Dictionary.
Unit 4: Decision Tree: Examples of Decision Tree, Decision Tables , Examples of Decision Tables, Structured English, Overview of variables, Operators, Conditional Statements and Loops .

Unit 1: Introduction to database: -What is a Database, Why use a Relational Database, Data Normalization (Determining tables, Determining Fields, Determining Relationships) Integrity Rules / (Primary/Foreign Key, One-to- Many, Many-to-Many, One-to-One) Introduction to MS Access.
Unit 2: Tables in Database: Create a Table in MS Access- Data Types, Field Properties, Fields: names, types, properties- default values, format, caption, validation rules Data Entry, Add record delete record and edit text, Sort, find/replace, filter/ select, rearrange columns, freeze columns. Edit a Tables-
Unit 3: Working with Query: Setting up Relationships- set a rule for Referential Integrity, change the join type, delete a relationship, save relationship Queries & Filter - difference between queries and filter, filter using multiple fields AND, OR, advance filter Queries, create Query with one table, find record with select query, find duplicate & unmatched record with query, run query, save.
Unit 4: Working with Forms: Introduction to Forms Types of Basic Forms: Columnar, Tabular, Datasheet, add headers and footers, add fields to form,add text to form use label option button, check box, combo box, list box Forms Wizard, Create Template. Working with Reports, Introduction to Reports, Types of Basic Reports: Single Colu Tabular Report Groups/Total, single table report, multi table report preview repos print report, Creating Reports and Labels, Wizard.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT I Internet: Evolution, Concepts, Internet Vs Intranet, Growth of Internet, ISP, ISP in India, Types of connectivity - Dial-up, Leased line, DSL, Broadband, VSAT etc., Methods of sharing of Internet connection, Use of Proxy server.
UNIT II WORLD WIDE WEB (WWW) - History, Working, Web Browsers, Its functions, URLs, web sites, Domain names, Portals. Concept of Search Engines, Search engines types, searching the Web, Web Servers, TCP/IP and others main protocols used on the Web. E-Mail: Concepts, Basics of Sending & Receiving, E-mail Protocols, Mailing List, Free E- mail services.
UNIT III Concepts of Hypertext, HTML introduction, features, uses & versions Using various HTML tags, Elements of HTML syntax, Head & Body Sections, , Inserting texts, Text alignment, Using images in pages, Hyperlinks text and images, bookmarks, Backgrounds and Color controls, creating and using Tables in HTML, and presentation, Use of font size & Attributes, List types and its tags.
UNIT IV Introduction to WYSIWYG Design tools for HTML, Overview of MS FrontPage, Macromedia Dream weaver, and other popular HTML editors, designing web sites using MS FrontPage .
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

Unit 1: Introduction to CSS Introduction to CSS, Types of CSS, Selector in CSS(ID,Tag,Class, Sub Selector), Attribute Selector, Group Selector, CSS Properties: Back Ground properties, Block Properties, Box properties, List properties, Border Properties, Positioning Properties, CSS Lists CSS Tables, CSS Menu Design CSS Image Gallery.
Unit 2: CSS Framework Web Site Development using W3.CSS Framework, W3.CSS Intro, W3.CSS Colors, W3.CSS Containers, W3.CSS Panels, W3.CSSBorders, W3.CSSFonts, W3.CSS Text, W3.CSS Tables, W3.CSS List, W3.CSSImages, W3.CSS Grid
Unit 3: JavaScript Javascript Overview, Javascript and the WWW, Javascript Javascript vs. Java, Script element,. Functions introduction, Calling functions, Javascript Comments, declaring variables, Types of variables, Casting variables, Alert box , Prompt & confirm. Expressions: Arithmetic operators, Assignment operators, Logical operators, Expressions and precedence, Statements: If statement, For statement, While statement, Break/Continue statements etc.
Unit 4: Creating arrays/event handlers, JavaScript Object model, Object and Events in JavaScript OnClick, On MouseOver, On Focus, OnChange, OnLoad etc. Getting data with forms. Introduction to Angular JS Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.


Unit 1: Introduction to Programming Algorithms, flowcharts, Programming Languages, compilation, testing & debugging and documentation, Flow Chart, Basic algorithms/flowcharts for sequential processing, decision based processing and iterative processing. Some examples like: Exchanging values of two variables, summation of a set of numbers, Test whether a number is prime, factorial etc.
Unit 2:- Introduction to Python Python Introduction, Using Comments, Literals, Constants, Python‟s Built-in Data types, Strings ,Accepting input from Console, printing statements, Simple „Python‟ programs. Operators, Expressions and Python Statements, Assignment statement, expressions, Arithmetic, Relational, Logical, Bitwise operators and their precedence, Conditional statements: if, if-else, if-elif-else; While Statement, For loop, break statement, Continue Statement, Pass statement, else, assert. Lists, tuples and dictionary
Unit 3: Functions Uses of functions, Function parameters, the Return statement, Default argument values, VarArgs parameters. Library function-input(), eval(),print(), String Functions: count(), find(), rfind(), capitalize(), title(), lower(), upper(), swapcase(), islower(), isupper(), istitle(), replace(), strip(), lstrip(), rstrip(), aplit(), partition(), join(), isspace(), isalpha(), isdigit(), isalnum(), startswith(), endswith(), encode(), decode(), String: Slicing, Membership, Pattern Matching, Numeric Functions: eval(), max(), min(), pow(), round(), int(), random(), ceil(), floor(), sqrt(), Date & Time Functions, Recursion.
Unit 4: File Processing Concept of Files, File opening in various modes and closing of a file, Reading from a file, Writing onto a file, File functions-open(), close(), read(), readline(), readlines() ,write(), writelines(),tell(),seek(), Command Line arguments. NumPy Basics
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.

UNIT-I The basic Financial Accounts, types of accounts, Rules of Entries of transaction, Journal. Cash Book Types, Format of Cash book, Balancing of Cash Book, Subsidiary books Purchase, Sales, and Purchase return and sales return. Ledger, posting of entries.
UNIT II Trial Balance, Rectification of errors, adjustment entries. Depreciation and Inflation.
UNIT III Principles of Cost Accounting, Valuation of Stocks, Allocation of Overheads, Methods of material issues. Payroll department, Preparation of Pay roll, Preparation of wage record, Methods of payments of wages, overview of computerized method for payroll preparation.
UNIT IV Inventory account and store record, inventory or stock control and cost accounting, Department demand and supply method of stock control. Classification and condition of material Report on material handling. Introduction to accounting software, their features and some basic operations.
Note: In each theory paper, nine questions are to be set. Two questions are to be set from each Unit and candidate is required to attempt one question from each unit. Question number one will be compulsory, which will consist of MCQ, True/False, Match the Columns and Fill in the Blanks out of the entire syllabus. In all, five questions are to be attempted.