Course Details for the “Computer-cum-Internet Course”

Duration – 148 Hrs.

Number of Modules – 4 (Four)

Module – A I (Computer Fundamentals)

1. Hardware Overview

a. What is a Computer?
b.History of Computer
c.Advantages & Limitations of Computer
d. Description of a Computer
e. Types of Computer
f. Description of Input & Output Devices
g. Description of Internal & External Memory
h. Definition of Hardware & Software
i. Concept of Data, representation of data
j. Number System etc.

2. Operating System (Windows NT 4.0 and Windows Client

    a. What is an Operating System?
    b. Difference between CUI & GUI based Operating Systems
    c. Necessity of Operating Systems
    d. What is “Windows Operating System”?
    e. Various properties of Windows Operating System
    f. Files & Folders management using Windows Explorer
    g. Files & Folders management using Hard Disk, floppy & CD.
    h. Display properties, creating shortcuts, using screen savers, etc.

3. WordPad, Paint, Note Pad & Calculator
    a. Creating a new file, saving a file, Opening a file, editing and printing documents
    b. Cut, Copy & Paste of text and objects.
4. Microsoft Word
    a. Introduction of Microsoft Word
    b. Screen components of Microsoft Word
    c. Creating and Saving a new Document
    d. Different between Save and Save as… option
    e. Setting up of Pages, margins, orientations, paper size etc.
    f. Various layouts of Microsoft Word
    g. Print preview, multiple cut, copy & paste using clipboard.
    h. Using find, replace, go to, undo, & redo options
    i. Header & Footer of a page (Different in first page, in odd a even pages)
    j. Inserting Breaks, Date & Time, Page Numbers
    k. Auto Text, Auto Correct and Indexing 
    l. Word Art, Clip Arts, Pictures, Auto Shapes, Styles and Drawings in Microsoft Word
    m. Creating Tables (Drawing and Inserting), using Auto Format & Indexing
    n. Character Formatting & Paragraph Formatting using font, paragraph setting, bullets & numbering, borders & shedding, columns, drop cap, change case etc.
    o. Working with advanced tools of Microsoft Word p. Spelling & Grammar checking, Using Thesaurus, Mail Marge, and Macro, Password protection etc.
5. Microsoft Excel
    a. Introduction of Microsoft Excel
    b. Screen components of Microsoft Excel
    c. Saving a workbook using save, save as, save as web page, save as workspace etc.
    d. Utility of Fill Handle, entering data in a series
    e. Copying data, moving data, deleting – all, formats, contents
    f. Formatting, inserting, deleting rows, columns & cells
     g. Header & Footer, Comments, Hyperlink & Naming of Cells.
    h. Using formulas, entering formulas, referencing method, auto sum,
    i. Formatting – alignment, column width, row height, number formats, border, auto format & conditional formatting
    j. Inserting, deleting, renaming & moving of work sheet.
    k. Working with advanced tools of Microsoft Excel – Creating Chart, Scenario, Pivot Table,
6. Microsoft PowerPoint
    a. Introduction of Microsoft PowerPoint
    b. Screen components of Microsoft PowerPoint
    c. Some common terms – slides, presentations etc
    d. Inserting, deleting, duplicating, hiding, moving & inserting slides from other presentations.
    e. Creating presentations using Auto Content Wizard
    f. Creating presentations using Design Template
    g. Creating presentations using Blank Presentation
    h. Various views of PowerPoint
    i. Advanced effects – Slide Transitions, Custom Animation, Looping presentation
    j. Adding action buttons, inserting slide number and dates.
7. Internet, Using e-mail etc.
    a. Introduction and History of Internet
    b. Meaning on Network
    c. Types of Network (LAN, MAN & WAN)
    d. Necessity & Advantage of Internet
    e. Naming system of web addresses (DNS & IP Address)
    f. Some common term in the Internet – ISP, Server, Client, BSNL, NIC, WWW, GIAS, Web Server, Web Site, Web Page, Protocols, Search Engine, etc.
    g. Different protocols in the Internet (HTTP, FTP, TCP/IP, FTP, PPP, SMTP, POP etc.)
    h. Browsing web sites
    i. E-mail – How to create an e-mail account, Receiving Mails, Sending Mails, Adding attachment with the mails,

2. Module – A II (Office Productivity Tools)

1. Microsoft Access
    a. What is Data, Database, DBMS, RDBMS & Microsoft Access
    b. Introduction to the Microsoft Access
    c. Creating, Opening & Deleting a database in Microsoft Access
    d. Some common terms in Microsoft Access – Objects, Field name, Data type, Field properties, etc.
    e. Various data types in Microsoft Access
    f. Field properties of Field Names
    g. Creating Table in Design View and using Wizard, Importing a Table and Linking.
    h. Primary Key in a Table
    i. Editing Table – Editing Field Properties, Adding, Deleting & Hiding Fields
    j. Creating, Editing & Deleting Relationship between tables
    k. Entering, Modifying & Deleting data
    l. Queries – Select, Cross-Tab, Parameters, Action (Append, Delete, Make table & Update)
    m. Creating Form in Design view & using Wizard
    n. Creating Sub-Form in Design view & using Wizard
    o. Sorting & Filtering of data in the Table, Form & Report
    p. Creating Reports in Design view & using Wizard
    q. Adding Command Buttons & Introduction to Visual Basic Codes
    r. Creating & Applying Macros

2. Microsoft Outlook

    a. Introduction of Microsoft Outlook
    b. Screen components of Microsoft Outlook
    c. Sending & Receiving Mails, Reading Mails, Deleting Mails, Inbox, Drafts, Setting Message Options, etc
    d. Attaching a file with the mail
    e. Stationary – Creating, Selecting, Default Stationary
    f. Signature – Creating, Selecting Default Signature, Adding a Signature.
    g. Tasks – Setting Options, Adding, Assigning, Viewing the Task list, Changing Task Status, Deleting Tasks
    h. Calendar – Changing Calendar Options
    i. Appointments – Entering Appointments, Filling the Appointment Forms, Adding All-Day-Event, Recurring Appointments.

3. Module – A III (LAN Concept with Windows NT 4.0)

    a. Concept of NT
    b. Managing Files & Folders in the Network
    c. Concept of LAN and Networking with NT

4. Module – A IV (Concept of Internet & Multimedia)

    a. Introduction with Internet & Multimedia
    b. Useful services of “World Wide Web”
    c. Web Browsers, Home Pages & Web Sites.