Computers Applications (Practical)

Paper Code: 
MFT-124
Credits: 
6
Contact Hours: 
90.00
Max. Marks: 
100.00
Objective: 
  • To expose students to basic microeconomic concepts.
  • To provide a method/ approach to help draw correct conclusions/ solve economic problems.
  • To understand, explain and quantify the mechanism by which the total amount of resources possessed by society is allocated among alternative uses.
     
Introduction to Computers 5 Hrs

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.

 

Windows 5 Hrs

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.

 

Microsoft Word 20 Hrs

  • 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.

 

Microsoft Excel 25 Hrs

  • 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).

 

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:                                                                                                            10 Hrs

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.

Essential Readings: 
  1. Abhay Upadhyay, 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
     
  • Printer-friendly version
  • PDF version