IT Skills-1

Unit 1

Conceptual Framework Hardware: (a) Input devices - keyboard, printing devices, voice speech devices, scanner, MICR, OMR, Bar code reader, digital camera etc. (b) Output devices - Visual Display UNIT, printers, plotters (c) Storage Devices - Magnetic storage devices, Optical storage devices, Flash Memory.

Software: Types of software with examples; Introduction to languages, compiler, interpreter and Assembler, Operating System Functions, Types and Classification, Elements of GUI based operating system. Network and Internet: Types of computer networks (LAN, WAN and MAN), Netiquettes, Basic services over Internet like WWW, FTP, Telnet, Gopher, URL, Domain names, Web Browsers, Multimedia and its applications: Concepts of Text, Graphics, Animation, Audio, Images, Video.

Multimedia Application in Education, Entertainment, Marketing. Names of common multimedia file formats,

Unit 2

Windows and Users Interface (Lab Work)- 7 hours Windows operating System: Introduction and characteristics, Elements of GUI. Using Mouse, My Computer Icon, The Recycle Bin, Status Bar, Start and Menu & Menu-selection, Running an Application, Windows Explorer: Viewing of File, Folders and Directories Creating and Renaming of files and folders Opening and closing of different Windows, Windows Setting: Control Panels, Wall paper and Screen Savers Setting the date and Sound. Concept of menu, Using Help, Using right Button of the Mouse, Creating Short cuts, Basics of Window Setup, Notepad, Window Accessories

Unit 3

Word Processor Software (Lab Work) - 8 hours Word processing concepts: Opening, Saving, Closing the file, 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. Using Graphics, Tables, Charts, Document Templates and Wizards.

Unit 4

Spreadsheet Software (Lab Work) - 10 hours Spreadsheet Package Spreadsheet: Concept and Working Interface, 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 in Spreadsheet: Mathematical, Logical, statistical, text, financial, Date and Time functions, Using Function Wizard. Formatting a Worksheet and Cell: changing data alignment, changing date, number, character or currency format, changing font, adding borders and colors. Printing worksheets, Charts and Graphs - Creating, Previewing, and Modifying Charts. Integrating word processor, spread sheets, web pages.