COMPUTERS APPLICATIONS

Paper Code: 
FSD-124
Credits: 
6
Contact Hours: 
90.00
Max. Marks: 
100.00
Objective: 
  1. To expose students to basic microeconomic concepts.
  2. To provide a method/ approach to help draw correct conclusions/ solve economic problems.
  3. To understand, explain and quantify the mechanism by which the total amount of resources possessed by society is allocated among alternative uses.
5.00
Unit I: 
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). Generation of  computers.

5.00
Unit II: 
Windows

Introduction, 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.

                  

5.00
Unit III: 
Microsoft Word

Introduction to Word Processor: Features of Word processors, Getting started with MS-Word, Working with formatted text, Shortcut keys.
Formatting documents: Selecting text, Copying & moving data, Formatting characters, changing cases, Paragraph formatting, Indents, Drop Caps, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs, Forming tables.
Finding & replacing text, Go To (F5) command, Proofing text (Spell check, Auto correct), Reversing actions, Macros, Inserting pictures, Hyperlinks, Mail merging, Printing, Getting Help.

25.00
Unit IV: 
Microsoft Excel

Introduction to Spreadsheets, workbooks, creating, saving & editing a workbook, Renaming sheet, cell entries (numbers, labels, and formulas), spell check, find and replace; Adding and deleting rows and columns
Filling series, fill with drag, data sort, Formatting worksheet, Functions and its parts, Some useful Functions in excel (SUM, AVERAGE, COUNT, MAX, MIN, IF);
cell referencing (Relative, Absolute, Mixed), What-if analysis
Introduction to charts: types of charts, creation of chart from adjacent data/ nonadjacent data, printing a chart, printing worksheet, OLE (importing & exporting data).

35.00

Microsoft Power Point                                                                   20 hrs

Introduction to Presentation Software : Uses, Presentation tips, components of slide, templates and wizards, using template, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, using master slide. Adding slides, changing color scheme, changing background and shading, adding header and footer, adding clip arts and auto shapes.
Various presentation, Working in slide sorter view (deleting, duplicating, rearranging slides), adding transition and animations to slide show, inserting music or sound on a slide, Inserting action buttons or hyperlinks for a presentation, set and rehearse slide timings, viewing slide show, Printing slides.

Scanning of documents and pictures                                              5 hrs

Internet:                                                                                        10hrs

Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment), Sending & Receiving Secure E-mail, chatting, conferencing, E-mail mailing list, Newsgroup, IRC, ICQ, Video mail and Video Conferencing.

 

 

Examination Scheme

 

Continuous Assessment

Distribution of Marks (Practical Record)

Semester End Exam

Component

Marks

Component

Marks

Component

Marks

Practical Record

20

Microsoft Word

05

Submission

20

Excel Sheet

20

Test

05

Microsoft Excel

10

Power point

Presentation

15

Attendance

05

Microsoft Powerpoint

05

Word Document

10

Viva Voce

05

Total

30

Total

20

Total

70

 

Essential Readings: 
  1. AbhayUpadhyay, Elementary of Computers.
  2. Peter Norton, “Introduction to Computers”, TMH, 2001
  3. Mastering Word 2000 – Mansfield and Olsen
  4. Mastering Excel 2000 – Martin, Hansen, Klingher & Beth
  5. Courter, “Mastering Office 2000”, BPB Publications.
  6. Bill Bruck, “MS-Office 2000”, TMH.
References: 
  1. Robbins, “Mastering DOS”, BPB Publications
  2. Content Development Group, “Working with MS Office 2000”, TMH
  3. Mansfield & Olsen, “Mastering Word 2000”, BPB Publications
  4. Martin, Hansen, Klingher & Beth, “Mastering Excel 2000”, BPB Publications
  5. Murray, “Mastering Power Point 2000”, BPB Publications.
  6. Mahapatra & Sinha, “Essentials of Information Technology”, Dhanpat Rai Publishing

 

Academic Year: