DCA / TALLY / ADCA / PGDCA / MS OFFICE
DCA Syllabus
COMPUTER FUNDAMENTALS, MS-DOS, BINARY, OCTAL, HEXADECIMAL NUMBER SYSTEM
OPERATING SYSTEMS. MICROSOFT WINDOWS , TYPES OF SOFTWARE
WORD PROCESSING , MS-WORD, SPREADSHEET PACKAGE , MS EXCEL, VARIOUS TYPES OF FUNCTIONS
MATHEMATICAL, LOGICAL, STRING ETC, PRESENTATION PACKAGE,
POWER POINT, MS OUTLOOK, DATA BASE OPERATIONS ,MS-ACCESS, ACCESS-SQL, FORM DESIGN
COMPUTER FUNDAMENTALS
* What is computer, characteristics of computers, generations, input Devices(keyboard, mouse, trackball, joystick, scanner, omr, bar-code reader,
micr Digitizer, card reader, voice recognition, web cam, video cameras), output Devices((monitors(lcd,tft,crt), monitors, printers - dot matrix, inkjet, laser,
Plotters, multimedia projector) , storage units, cpu(control unit, arithmetic unit, Memory unit(primary, secondary etc)), number system, coversion of decimal to Binary,
* Decimal to octal decimal to hexadecimal, octal to binary, binary to hexa, Negative no. Representation , relationship between hardware and software; System software, application software, compiler, names of some high level
Languages, free domain software , translators (compilers, interpreter, Assemblers), linkers, bcd, ascii, memory units, what is operating system and type of
Operating Systems-DOS
DOS File System, Root Directory Table, User File Area:
Command Prompt, Type a command, Changing Drive, Naming files and directories,
Location Path, Extension
General Dos Commands like DIR, Copy Con, Echo etc,
Special Dos Commands LikeCHKDSK command
DEFRAG , DISKCOMP , FDISK ,FORMAT , attribute
LABEL , VERIFY , The * wildcard ,The? Wildcard etc
OPERATING SYSTEMS. MICROSOFT WINDOWS
* Defining a graphical user interface (gui), installing windows, the windows Desktop, my computer, windows explorer,
Using windows applications, and using Dos (disk operating system) applications under windows.
Dealing with Windows -7
1. The Windows 7 Desktop
2. Desktop Backgrounds and Wallpapers
3. The Windows 7 Taskbar
4. The Date and Time in Windows 7
Toolbars in Windows 7
6. User Accounts in Windows 7
7. Parental Controls in Windows 7
8. Hard Drive Basics
9. File Extensions
10. Adding Information to an Image
11. Sorting Images in Windows 7
Managing Software and Hardware Resources
Adding and Removing Programs.
Installing a New Printer on the PC.
Changing the Default Printer.
Viewing a Print Job's Progress.
Handling the Recycle Bin.
Introducing the Major System Information.
Working with the Help and Support window.
Changing User Interface.
Shutting down a Non-Responding Application.
Canceling Sending Error Reports to Microsoft.
Advanced Topics in Managing Software and Hardware Resources
WORD PROCESSING
* Word processing concepts: saving, closing, opening an existing document, Selecting text, editing text, finding and replacing text, printing documents, Creating and printing merged documents, character and paragraph formatting,
Page design and layout. Editing and proofing tools: checking and correcting Spellings. Handling graphics. Creating tables and charts. Document templates and Wizards*.
SPREADSHEET PACKAGE
* Spreadsheet concepts. Creating, saving and editing a workbook, inserting, Deleting work sheets, entering data in a celli formula copying and moving data From selected cells, handling operators in formulae, functions:
mathematical, Logical, statistical, text, financial, date and time functions, using function Wizard.Formatting a worksheet: formatting cells - changing data alignment, changing
Date, number, character, or currency format, changing font, adding borders and Colors, printing worksheets, charts and graphs- creating, previewing, modifying Charts. Integrating word processor, spread sheets, web pages*.
PRESENTATION PACKAGE
* Creating, opening and saving presentations, creating the look of your Presentation, working in different views, working with slides, adding and Formatting text, formatting paragraphs,
* checking spelling and correcting typing Mistakes, making notes pages and handouts, drawing and working with objects,
* Adding clip art and other pictures, designing slide shows, running and Controlling a slide show, printing presentations*.
DATA BASE OPERATIONS
* Introduction to database, table, queries, forms, reports, macros, rdbms etc Data manipulation-concept: database, relational database, integrity. Operations : creating, dropping, manipulating table structure. Manipulation of data : query, data entry form, reports, macros
* What is computer, characteristics of computers, generations, input Devices(keyboard, mouse, trackball, joystick, scanner, omr, bar-code reader,
micr Digitizer, card reader, voice recognition, web cam, video cameras), output Devices((monitors(lcd,tft,crt), monitors, printers - dot matrix, inkjet, laser,
Plotters, multimedia projector) , storage units, cpu(control unit, arithmetic unit, Memory unit(primary, secondary etc)), number system, coversion of decimal to Binary,
* Decimal to octal decimal to hexadecimal, octal to binary, binary to hexa, Negative no. Representation , relationship between hardware and software; System software, application software, compiler, names of some high level
Languages, free domain software , translators (compilers, interpreter, Assemblers), linkers, bcd, ascii, memory units, what is operating system and type of
Operating Systems-DOS
DOS File System, Root Directory Table, User File Area:
Command Prompt, Type a command, Changing Drive, Naming files and directories,
Location Path, Extension
General Dos Commands like DIR, Copy Con, Echo etc,
Special Dos Commands LikeCHKDSK command
DEFRAG , DISKCOMP , FDISK ,FORMAT , attribute
LABEL , VERIFY , The * wildcard ,The? Wildcard etc
OPERATING SYSTEMS. MICROSOFT WINDOWS
* Defining a graphical user interface (gui), installing windows, the windows Desktop, my computer, windows explorer,
Using windows applications, and using Dos (disk operating system) applications under windows.
Dealing with Windows -7
1. The Windows 7 Desktop
2. Desktop Backgrounds and Wallpapers
3. The Windows 7 Taskbar
4. The Date and Time in Windows 7
Toolbars in Windows 7
6. User Accounts in Windows 7
7. Parental Controls in Windows 7
8. Hard Drive Basics
9. File Extensions
10. Adding Information to an Image
11. Sorting Images in Windows 7
Managing Software and Hardware Resources
Adding and Removing Programs.
Installing a New Printer on the PC.
Changing the Default Printer.
Viewing a Print Job's Progress.
Handling the Recycle Bin.
Introducing the Major System Information.
Working with the Help and Support window.
Changing User Interface.
Shutting down a Non-Responding Application.
Canceling Sending Error Reports to Microsoft.
Advanced Topics in Managing Software and Hardware Resources
WORD PROCESSING
* Word processing concepts: saving, closing, opening an existing document, Selecting text, editing text, finding and replacing text, printing documents, Creating and printing merged documents, character and paragraph formatting,
Page design and layout. Editing and proofing tools: checking and correcting Spellings. Handling graphics. Creating tables and charts. Document templates and Wizards*.
SPREADSHEET PACKAGE
* Spreadsheet concepts. Creating, saving and editing a workbook, inserting, Deleting work sheets, entering data in a celli formula copying and moving data From selected cells, handling operators in formulae, functions:
mathematical, Logical, statistical, text, financial, date and time functions, using function Wizard.Formatting a worksheet: formatting cells - changing data alignment, changing
Date, number, character, or currency format, changing font, adding borders and Colors, printing worksheets, charts and graphs- creating, previewing, modifying Charts. Integrating word processor, spread sheets, web pages*.
PRESENTATION PACKAGE
* Creating, opening and saving presentations, creating the look of your Presentation, working in different views, working with slides, adding and Formatting text, formatting paragraphs,
* checking spelling and correcting typing Mistakes, making notes pages and handouts, drawing and working with objects,
* Adding clip art and other pictures, designing slide shows, running and Controlling a slide show, printing presentations*.
DATA BASE OPERATIONS
* Introduction to database, table, queries, forms, reports, macros, rdbms etc Data manipulation-concept: database, relational database, integrity. Operations : creating, dropping, manipulating table structure. Manipulation of data : query, data entry form, reports, macros