The goal of this course is
to present overview of IT tools used in day today use of computers and data
base operations. The Course has been designed toward provide knowledge on
various hardware and software components of computer, operating system, various
packages used for different applications, data base concepts & operations
and different issues related to IT and application of IT.
Module - I Computer Organization
Central Processing Unit - Processor Speed,
Cache, Memory, RAM, ROM Booting, Memory- Secondary Storage Devices: Floppy and
Hard Disks, Optical Disks CD-ROM,DVD, Mass Storage Devices: USB thumb drive.
Anaging 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; Names of common multimedia file formats Computer Software- Relationship
between Hardware and Software; System Software, Application Software
Module - II Operating System
Microsoft Windows- An overview of different
versions of Windows, Basic Windows elements, File management through Windows.
Using essential accessories: System tools – Disk cleanup, 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.
Module - III Word Processing (MS Word)
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.
Module - IV Spreadsheet Package (MS Excel)
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.
Module - V Presentation Package (MS Power point)
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.
Module - VI Internet
Connectivity, Browser, Outlook Express,
e-mail, E-Ticketing, E-Banking, E-Commarce, E-mail etc
