Computer Fundaments and IT

Paper Code: 
ABFS 101
Credits: 
2
Contact Hours: 
30.00
Max. Marks: 
100.00
Objective: 

The objective of this course is to familiarize students with Fundamentals of Computer and IT applications. It enables the student to get practical exposure towards MS - Office tools.

6.00
Unit I: 
Introdction to Computers

Introduction to Computers: Introduction to Computers (definition, characteristics & uses), Evolution of computers, System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary). Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter). Introduction to Data Processing: Elements of Data Processing, Data Processing Activities

6.00
Unit II: 
Introduction to Windows

Features (Desktop & its components, the window, the application window (various bars), the document window, the dialog window, the icons). Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus
Adding and removing Printers. File and Directory Management: Creating and renaming of files and directories.

6.00
Unit III: 
Word Processing

Introduction to word processing, Features of Word processors, Working with formatted documents, Shortcut keys. Finding & replacing text, GoTo (5) command. Formatting documents, Selecting text, Formatting characters, Changing cases, Paragraph formatting, Indents, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs.
Advanced Word processing Tools: Creating and formatting tables. Proofing text (Spell check, Auto correct), Inserting pictures, Mail merging, Printing, Getting Help

6.00
Unit IV: 
MS Excel

Features, file creations, storing, modification, formation, sorting of data, inserting row, column, worksheet, splitting and merging of cells, etc.

6.00
Unit V: 
MS PowerPoint and Cloud based Office Tools

MS PowerPoint: Features, file creations, storing, modification, indentation, insertion of new slide, pictures, tables, etc.
Cloud based Office Tools: Introduction to cloud services: Google drive, Google docs, Google sheets, Google slides. Sharing and creating files, uploading and downloading files and folders. Creating and designing forms using Google forms. Introduction to office365 and its applications.

Essential Readings: 

1. Fundamentals of Computers, V. Rajaraman, PHI Publication
2. Computer Fundamentals, P. K. Sinha, BPB Publication
3. Introduction to Computers with MS - Office 2007, Leon, TMH Publication
4. Peter Norton, “Introduction to Computers”, TMH, 2001
5. Bott and Leonhard, “Using Office 2000”, Prentice Hall of India
6. L. Young, “Internet Complete Reference”, TMH
7. Mahapatra & Sinha, “Essentials of Information Technology”, Dhanpat Rai Publishing
8. R.K.Taxali, “PC Software For Windows” , Tata McGraw Hill

Academic Year: