Objective of the Course
The goal of this course is to present overview of IT tools used in day to day use of computers and database operations. The Course has been designed to provide knowledge on various hardware and software components of computer, operating system, various packages used for different applications, data base concepts & operations and various issues related to IT and application of IT.
At the end of the course the students will be able to:-
- Acquire the foundation level knowledge required to understand computer and its operations.
- Understand the hardware and software components of the computer.
- Understand the basic concept of operating system and get knowledge about various
- different operating systems.
- Understand to use the packages of word processing, spread sheet and presentation in detail.
- Understand various data base concepts and operations.
- Understand the issues related to IT and IT applications.
Outline of Course
Topic Minimum number of hours
- Computer Appreciation 04
- Computer Organization 06
- Operating System 13
- Word Processing 06
- Spreadsheet Package 09
- Presentation Package 05
- Data Base Operations 13
- Information Technology and Society 04
Lectures = 60
Practical/Tutorials = 60
Total = 120
1. Computer Appreciation 04Hrs.
Characteristics of Computers, Input, Output, Storage units, CPU, Computer System, Binary number system, Binary to Decimal Conversion, Decimal to Binary Conversion, ASCII Code, Unicode.
2. Computer Organization 06 Hrs.
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. 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.
3. Operating System 13 Hrs.
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. 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.
4. Word Processing 06 Hrs.
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.
5. Spreadsheet Package 09 Hrs.
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.
6. 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 Handouts, 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 13 Hrs.
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.