Syllabus for Diploma in Computer Applications - Bharathiar University, Dr.N.G.P. Community College - 2011

Course Name: Diploma in Computer Applications

Duration of course: 6 months / 1 Semester

With effect from: 2010 – 2011

FUNDAMENTAL OF COMPUTERS AND COMMUNICATION SKILLS

UNIT – I

Brief history of development of computers, Computer system concepts, Computer system characteristics, Capabilities and limitations, Types of computers Generations of computers, Personal Computer (PCs) – evolution of PCs.

UNIT – II

Input/Output & Storage Units-:Keyboard, Mouse, Trackball, Joystick, Digitizing tablet, Scanners, Digital Camera, MICR, OCR, OMR, Bar-code Reader, Voice Recognition, Light pen, Touch Screen, Monitors - characteristics and types of monitor -Digital, Analog, Size, Resolution, Refresh Rate, Interlaced / Non Interlaced, Dot Pitch,Video Standard - VGA, SVGA, XGA etc, Printers& types – Daisy wheel, Dot Matrix, Inkjet, Laser, Line Printer, Plotter, Sound Card  and Speakers.

UNIT – III

Software and its Need, Types of Software - System software, Application software, System Software - Operating System, Utility Program, Programming languages, Assemblers, Compilers and Interpreter, Introduction to operating system for PCs. Software and its types - Word-processing, Spreadsheet, Presentation Graphics, Data Base Management Software, characteristics, Uses and examples and area of applications of each of them, Virus working principles, Types of viruses, virus detection and prevention, viruses on network.

UNIT – IV

Listening Skills: Types of Listening - Tips for Effective Listening - Academic Listening- (lecturing ) - Listening to Talks and Presentations -Listening to Announcements- (railway/ bus stations/ airport /stadium announcement etc.) - Listening to Radio and Television

Telephone Skills: Basics of Telephone communication - How to handle calls- telephone manners - Leaving a message -  Making requests - Greeting and Leave Taking over phone(etiquette) - Asking for and giving information - Giving Instructions - Listening for Tone/Mood and Attitude at the other end Handling the situations especially trouble shooting - Teleconference handling -Handling Tele interviews for Call Centers

UNIT-V
Case Study :

• Reading Comprehension
• Grammar and Usage.-Nouns ,Pronouns Adjectives,Adverbs,Gerunds
• Sentence completion , Paragraph Writing.
• Letter Writing – Formal and Non formal , Applications

TEXT & REFERENCE BOOKS:

1. Anurag Seetha, “Introduction to Computers and Information Technology”, Ram Prasad & Sons, Bhopal.
2. S.K.Basandra, “Computers Today “, Galgotia Publications. Alexis Leon & Mathews Leon, “ Fundamentals of Informationtechnology “, Vikas Publishing House, New Delhi

OPERATING SYSTEMS

Unit-I  

Introduction and process concepts: Definition of DOS – Early History – History of DOS and UNIX OS – Definition of Process State Transition – Interrupt Processing – Interrupt Classes – Context Switching.

UNIT –II

Storage Management Real Storage: Real Storage Management Strategies – Contigious Vs Non-Contigious Storage Allocation -  Single User Contigious Storage Allocation – Fixed Partition Multiprogramming – Variable Partition Multiprogramming, multiprogramming with storage swapping.

Virtual Storage : Virtual Management Strategies – Page Replacement Strategies – Working set – Demand Paging – Page size.

UNIT - III

DOS basics- Physical structure of disk, drive name, FAT, file & directory structure and naming rules, booting process, DOS system files.

DOS commands :

Internal - DIR, MD, CD, RD, COPY, DEL, REN,VOL, DATE, TIME, CLS, PATH, TYPE etc.

External - CHKDSK, XCOPY, PRINT, DISKCOPY, DISKCOMP,DOSKEY, TREE, MOVE, LABEL, APPEND, FORMAT, SORT,FDISK, BACKUP, EDIT, MODE, ATTRIB, HELP, SYS

UNIT- IV

WINDOWS XP Introduction to Windows XP and its features . Hardware requirements of Windows. Windows concepts, Windows  Structure, Desktop, Taskbar, Start Menu, My Pictures ,My Music ,working with recycle bin-restoring a deleted file, emptying the recycle bin. Managing files ,folders and disk-navigating between folders ,manipulating files and folders,creating new folder ,searching files and folders .My computer-exploring hard disk

,coping and moving files and folder from one drive to another, formatting floppy drive.

UNIT - V

LINUX History & Features of Linux Linux Structure File system of Linux Hardware requirements of Linux .Various flavours of Linux Program & Process Process creation and process identifiers Functions of profile and login files in Linux, Linux kernel

TEXT & REFERENCE BOOKS:

1. Operating systems 2 ^nd edition by H.M.Deitel
2. DOS Quick reference by Rajeev Mathur, Galgotia Publications Peter Norton Complete Guide to Linux by Peter Norton,Techmedia Publications
3. Level Module M 1.1 Information technology by Khanna Book Publications, NewDelhi
4. Windows XP Complete Reference. BPB Publications

PC PACKAGES

UNIT–I

Office Packages-Office activities and their software requirement, word Processing, spreadsheet, presentation graphics, database, introduction and comparison of various office suites like MS office, Lotus Office, Star Office, Open Office etc.

UNIT - II

MS Word Basics: Introduction to MS Office; Introduction to MSWord; Features & area of use. Working with MS Word.; Menus &Commands; Toolbars & Buttons; Shortcut Menus, Wizards &Templates; Creating a New Document; Different Page Views and layouts; Applying various Text Enhancements; Working with – Styles, Text Attributes; Paragraph and Page Formatting; Text Editing using various features ; Bullets, Numbering, Auto formatting, Printing & various print options.

UNIT – III

MS Excel: Introduction and area of use; Working with MS Excel.; concepts of Workbook & Worksheets; Using Wizards; Various Data Types; Using different features with Data, Cell and Texts; Inserting, Removing & Resizing of Columns & Rows; Working with Data & Ranges; Different Views of Worksheets; Column Freezing, Labels, Hiding, Splitting etc.; Using different features with Data and Text; Use of Formulas, Calculations & Functions.

UNIT – IV

MS PowerPoint: Introduction & area of use; Working with MS PowerPoint; Creating a New Presentation; Working with Presentation; Using Wizards; Slides & its different views; Inserting, Deleting and Copying of Slides; Working with Notes, Handouts, Columns & Lists; Adding Graphics, Sounds and Movies to a Slide; Working with PowerPoint Objects; Designing & Presentation of a Slide Show; Printing Presentations, Notes, Handouts with print options.

UNIT-V
Ms Access – Introduction to Access, working with databases, queries, tables, forms, reports,
Macros and charts.
Internet – Basics of internet, basics of e mail, browsing.

Text & Reference Books:

1. Windows XP Complete Reference. BPB Publications
2. MS Office XP complete BPB publication
3. MS Office - Microsoft Network (2000)
4. Internet –Complete reference – Hardley Hahn (1999)

C PROGRAMMING

UNIT - 1

C Language – Character set Tokens of C - tokens-constant- keywords and identifiers - variables- data types- declaration and assignment of variables ,defining symbolic constants.- Operators and Expressions: Types of Operators- Arithmetic, Relational and Logical Operators Assignment, increment and decrement of operators - conditional bitwise and special operators -arithmetic expression and its evaluation - hierarchy of arithmetic operations -evaluations, precedence and associatively - mathematical functions.

UNIT - 2

Control Branching and Decision-Making in C - If statement Switch statement - GOTO statement - The ? : Operators.-  Decision - Making and Looping nesting in a loop, statements in C ,WHILE DO and FOR statements with variations.

UNIT - 3

Arrays in C Single Two - dimensional and Multi-dimensional arrays. Handling of Character Set: Declaration & Initialization of string variables - reading from and writing to screen -Arithmetic operations - String handling functions.

UNIT - 4

Structures and Unions: Definitions initialization and assigning values to members arrays of structures and arrays within structures structure with in structure- unions - size of structures. Pointers: Declaration and initialization of pointers - pointer expression - pointer and arrays -pointer and character strings pointers and functions

UNIT - 5

File Maintenance in “C” : Defining, Opening and closing a file - Input/Output operations on a file- random access to file - command line arguments. User Defined Functions: Form of “C” functions- calling a function - nesting of functions - recursion - functions with arrays.

Books:
1. Programming in “C” E Balgurusamy Tata Cm Graw-Hill
2. The “C” Programming Language :Briain W. Kenigham & Dennis Ritchie
3. The Spirit of “C”- Henrry Mulish, Herbert L. Cooper.
4. Mastering “C” - Crain Bolon.

Practical :  MS OFFICE & C PROGRAMMING

1.   Familiarizing with DOS commands, Windows operating systems.

Ms- Word

2.   Text manipulation, changing the font size, font type, and font style, making the text bold,

            underlining the text, aligning the text (Centre, justify, left, right), cut, copy, paste.

3.    Paragraph indenting & spacing, bullets & numbering, spelling & grammar check,   

      inserting a picture from clip art, auto shapes, and word art.

4.    Mail merge concept and printing formats.

Ms- Excel

5.    Entering the data, changing the fonts, changing row heights & column width, formatting  

            the data,sorting the data.

6.    Formula processing- creating simple formula, using function (ABS, SQRT, LEN, SUM  

,ROUND, AVG, COUNT, CONCATENATE, FIND).

Ms –PowerPoint

     7. Creating simple presentations, saving, opening and existing presentation, creating a
          presentation using Auto content wizard & template.

     8. Using various auto- layouts, charts, table, bullets & clip art.

C Programming

9. Write a C program to find largest and smallest of given n numbers

10. Write a C program to find a Factorial of given number

11. Write a C program to find prime number or not

12. Write a C program to prepare student mark list