DIPLOMA IN COMPUTER OPERATOR AND PROGRAMMING ASSISTANT ( M-DCOPA014 )

Syllabus Coverage:

1. Fundamentals of IT Tools and Network Basics

Fundamental of Computer:-

Theoretical Work:- Introduction to Computer, Definition of Computer, Computer Characteristics, Classification of Computer, Input/Output Unit- CPU,  History & Generations of Computers, Bit & Bytes, Introduction to Computer Hardware-Input & Output Devices, Memory & its types, Introduction to Computer Software & its Classification. Characteristics of Computers, Input, Output, Storage units, CPU, Computer System, Binary number system, Binary to Decimal Conversion, Decimal to Binary Conversion, ASCII Code, Unicode, Computer Organization , Central Processing Unit - Processor Speed, Cache, Memory, RAM, ROM, Booting, and Memory- Secondary Storage Devices: Floppy and Hard Disks, Optical Disks CD-ROM, DVD, Mass Storage Devices: USB thumb drive. Managing disk Partitions, File System Input Devices - Keyboard, Mouse, joystick, Scanner, web cam, Output Devices- Monitors, Printers – Dot matrix, inkjet, laser, Multimedia- What is Multimedia, Text, Graphics, Animation, Audio, Images, Video; Multimedia Application in Education, Entertainment, Marketing. Names of common multimedia file formats, Computer Software- Relationship between Hardware and Software; System Software, Application Software, Compiler, names of some high level languages, free domain software.

Operating System:- Microsoft Windows- An overview of different versions of Windows, Basic Windows elements, File management through Windows. Using essential accessories: System tools – Disk clean-up, Disk defragmenter, Entertainment, Games, Calculator, Imaging – Fax, Notepad, Paint, WordPad. Command Prompt- Directory navigation, path setting, creating and using batch files. Drives, files, directories, directory structure. Application Management: Installing, uninstalling, Running applications. Linux- An overview of Linux, Basic Linux elements: System Features, Software Features, File Structure, File handling in Linux: H/W, S/W requirements, Preliminary steps before installation, specifics on Hard drive repartitioning and booting a Linux system.

Practical Work: English typing-Tutor (During theory of Fundamental)

 Word Processing (Microsoft Office: Word, Excel, and PowerPoint)

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 Profiling Tools: Checking and correcting spellings. Handling Graphics, Creating Tables and Charts, Document Templates and Wizards.

MS WORD

Theoretical Cum Work:- Introduction to MS Word, MS Word Screen, Title bar, Menu bar, Standard tool bar, Formatting tool bar, The Ruler, Status bar.

Practical Work:- To Create, Open, Save Documents etc: New Document, Page Setup of Document, Type words in Documents, Save/Save as Document, Open Document, Print Preview of Document, and Print.

To Edit Document: Undo typing, Redo typing, Cut, Copy, Paste, Office Clipboard, Select All, Find, Replace, Go to.

To View Document: Normal View, Web layout View, Print Layout View, Outline View, Task pane. Toolbar Options, Ruler View, Document Map, Header & Footer, Full Screen View, Zoom.

To Insert Date, Time Symbol, Picture etc. in Document: Page Number, Date & Time, Symbol, Picture- Clipart/FromFile/OrganizationChart/WordArt/AutoShapes/Chart, Comment, Hyperlink, Reference-Footnote/Caption, Diagram, Textbox, File, object.

To Format font, paragraph etc. in documents: Font, Paragraph, Bullet & Numbering Border, Shading, Drop Cap, Change Case, Background, Theme, Style & Formatting.

To Create Table: Draw table, Insert table, Delete table, Select Table, Table Auto format, Convert text to table. Convert table to text.

MS EXCEL

Theoretical Cum Practical Work:- Introduction to MS Excel, MS Excel Screen, Standard tool bar, Formatting tool bar, Creating work book, Entering Data, Creating Formulas, Formatting a Worksheet, Inserting Table, picture ,Charts, Sorting, Printing. Function-Statistical Function/Logical Function, Filtering Data. General Template- Loan Calculator, Invoice etc. Spreadsheet Concepts, Creating, Saving and Editing a Workbook, Inserting, Deleting Work Sheets, entering data in a cell / formula Copying and Moving 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.

MS POWERPOINT

Theoretical cum Practical Work:- Introduction to MS PowerPoint, Main Elements of presentation- Slides/Handout/Speakers Note/Outlines, Creating a presentation, To format Slides, To Insert- Table/Chart & other Drawing objects. To print Slides6. Presentation Package 05 Hrs. 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 Hand-outs, Drawing and Working with Objects, Adding Clip Art and other pictures, Designing Slide Shows, Running and Controlling a Slide Show, Printing Presentations. 7. Data Base Operations, 14 Data Manipulation-Concept: Database, Relational Database, Integrity. Operations: Creating, dropping, manipulating table structure. Manipulation of Data: Query, Data Entry Form, Reports. 8. Information Technology and Society 04 Hrs. Indian IT Act, Intellectual Property Rights – issues. Application of information Technology in Railways, Airlines, Banking, Insurance, Inventory Control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.

Eligibility: 12^th