Objective : To prepare a student with skills with will complement his main stream working (like Marketing executive, Personal Assistant, Office Coordinator, Purchase Assistant / Officer) or Self Employment as Data Entry Operator, Cyber Cafe Operator etc.
Duration : 144 Hours
Eligibility : Standard 10th Pass under 10+2 System with English as one of the subject.
Content
:
Introduction to Computers, DOS, Windows 2000, MS Office-2000
( Word , Excel , Power Point & MS Access ), Introduction to Internet
and Email Services.
|
Sr.
No. |
Name
of Topics |
Duration |
|
1 |
Computer Architecture and Fundamentals |
10 Hrs. |
|
2 |
Operating Systems & MS-DOS |
10 Hrs. |
|
3 |
MS Windows 2000 O.S. |
14 Hrs. |
|
4 |
Microsoft Office-2000 |
02 Hrs. |
|
5 |
Microsoft Word-2000 |
26 Hrs. |
|
6 |
Microsoft Excel-2000 |
28 Hrs. |
|
7 |
Microsoft Access-2000 |
28 Hrs. |
|
8 |
Microsoft Power-Point-2000 |
12 Hrs. |
|
9 |
Internet Essentials Email & Outlook Express |
14 Hrs. |
|
Total |
|
144
Hrs. |
Introduction
to Computers
§ Computers in Our World
§ Introduction
§ Necessity is the Mother of Invention
§ Capabilities of a computer
§ Classification of Computer
§ Application of Computers
§ Generation of computers
§ Addition Reading
§ Brief History of Computers
§ Computers and Hardware
§ Computer System
§ Input/Output Devices
§ Central Processing Unit abbreviated(CPU)
§ Brief Introduction to Memory
§ In Computers Everything is Binary
§ Input Data : Sources & Concepts
§ Keyboard
§ Graphical Input Devices
§ Those using Special Sensitivity
§ Those which senses Magnetic Ink
§ Industrial Robots
§ Output Devices and storage devices
¨ Why output is needed
¨ Monitor
¨ Printers
¨ Impact
¨ Non-impact Printers
¨ Plotters
¨ Storage Device
¨ Primary Devices
¨ Secondary Devices
¨ Magnetic Disks
¨ Those mounted in the computer
¨ Those which can be removed and used on various machines
§ Computer Software & Data Communication
¨ Computer Software
¨ Application Software & System Software
¨ Computer and Data Communication
¨ Advantages of Data Communication
¨ concept of network
¨ Classification according to the area covered by network
§ Operating System
¨ Introduction to Operating System
¨ Booting Procedure
¨ Types of Files
¨ DOS PROMPT
¨ Introduction to Dos Commands
§ Understanding DOS-I
¨ Internal DOS Commands
¨ Wild Card Character in Dos
¨ Directory Related Commands
¨ File Related Commands
§ Understanding DOS II
¨ External DOS Commands AND Utilities
§ Filters & Redirection
¨ Redirection
¨ Input Redirection of a command
¨ Filter Commands
¨ Connecting Pipe
¨ Combining Redirection and Filters
§ Batch files
¨ Techniques of batch Files
¨ Create your first batch file
¨ Suppressing of On-screen display of commands
¨ Decision making with Batch files
v Importance of an Operating System
v A Guarantee to an Instant Start on MS-DOS
v Getting Started on DOS with Booting the System
v MSDOS.SYS
v Command COM
v Telling DOS the Data and Time
v Concepts Review
v Getting and Interpreting a Directory
v Making use of Pause Key to freeze scrolling
v Getting a Printed Copy of a Directory
v Using Wild Card Character
v What is a Wild Card Character ?
v Concepts Review
v Making use of Hierarchical Directories
v What are Hierarchical Directories ?
v Hierarchical Directory System
v Making use of MKDIR or MD command
v Making use of CHDIR or CD command
v Making use of the RMDIR or RD command
v Concepts Review
v Copying commands
v Copy command
v Copy Source file Destination file
v Disk copy source Destination
v Concepts Review
v Displaying the file contents
v Syntax
v Type Filename
v Print Filename(s)
v DEL Filename(s)
v Erase Filename(s)
v Formatting Disks
v FORMAT <DRIVE:>/<SWITCHES>
v Renaming Files
v Rename Original Filename New filename
v Clearing the Screen
v Displaying the Version Number
v VER
v Find
v Sort Filename
Ø Introduction to Operating System
Ø What is an Operating system ?
Ø Why is it required ?
Ø What are the types of an Operating System ?
Ø What are the functions of an Operating System ?
Ø Terms often used for Windows 2000
Ø Introduction to Windows 2000
Ø Specialties of Windows 2000
Ø Terms often used in Windows 2000
TASKBAR
- WHAT IS GOING ON ?
Ø What is the Taskbar ?
Ø What are its functions ?
Ø Launching of applications with help of Launching Pad
Ø Explanation of title bar and buttons
Ø Switching between applications
Ø Changing the size and position of the Taskbar
Ø Properties of the Taskbar
DESKTOP
- HOW DO I LOOK ?
v Introduction to the Desktop
v Main Icons on the Desktop
v Properties of the Desktop
Ø what does an Applet mean ?
Ø Different Applets under Windows 2000
Ø Clipboard Viewer
Ø Character Map
Ø Calculator
Ø Clock
Ø Games
Ø Media Player
Ø Paint
Ø Sound Recorder
Ø WordPad & Notepad
RECYCLE
BIN - FLUSHING IS REQUIRED
Ø Introduction to Recycle Bin
Ø Working with Recycle Bin
Ø Properties of Recycle Bin
MY
BRIEFCASE - TAKE ME HOME
Ø What is Briefcase in Windows 2000 ?
Ø Linking files from the main computer to the laptop
Ø Copying back the updated files
WINDOWS
EXPLORER-NOTHING IS HIDDEN FROM ME
Ø Two modes in which Windows Explorer works
Ø My Computer
Ø Windows Explorer
Ø File Management Tools under Windows Explorer
NETWORK
NEIGHBORHOOD-LOVE THY NEIGHBORS
Ø Introduction
Ø Network Neighborhood in Open window
Ø Network Neighborhood in Explore window
Ø Sharing
Ø Sharing of files and folders
Ø Sharing of hard disk
Ø Sharing of Printers
Ø Connecting a device temporarily
CONTROL
PANEL-MY TOOL KIT
Ø Introduction to Control Panel
Ø Tools under Control Panel
Ø Accessibility Options
Ø Add new Hardware
Ø Add Remove Programs
Ø Date/Time
Ø Display
Ø Fonts
Ø Keyboard
Ø Mouse
Ø Multimedia
Ø 32bit ODIALOG BOXC
Ø Passwords
Ø Printers
Ø Regional Settings
Ø Sounds
SHORTCUTS-SHORT
BUT STRONG CUTS
Ø What are shortcuts ?
Ø Creating a shortcut on the Desktop
Ø Creating a shortcut in the Start menu
Ø Short-cut for Send To
Ø Properties of short-cut
IN-BOX
LET'S TALK WITH THE WHOLE WORLD
v At a glance :
Ø Introduction to In Box
Ø Sending & Receiving e-mail
Ø Sending & Receiving Fax
MULTIMEDIA-SINGING
ALL THE WAY
Ø What is a multimedia ?
Ø Playing of a CD with CD Player
Ø Playing of a CD with Media Player
Ø
Working with a Sound Recorder
v What is Windows
v What is suite of Software
v Selecting in Office Programs
v Using Tools and Menus
v Working in Documents
v Cutting, Copying, and pasting
v Saving a Document
v Getting Help
v Advantages of Word Processing under Windows
v
Various Word Processors available under Windows
Introduction
to MS Word-2000
v Opening a New Document
v Opening an Existing Document
v Recently opened files
v Opening from the Documents menu
v Exporting and Importing Files
v Setting Up Your Pages
v Choosing page Size and Orientation
v Changing page Size
v Changing Orientation
v Setting Margins
v Centering Page
v Controlling Page Breaks
v Typing in the Document
v Inserting Today's Date
v Moving Around in the Document
v Creating Sections
v Inserting a Section break
v Formatting a Section
v Viewing Sections
v Using Columns
v Numbering Pages
v On Your Own
v Saving a File
v Quitting Word
Formatting
Text
v Formatting Characters
v Choosing Fonts
v Enhancing Text Appearance
v Inserting Special Characters
v Changing Character Spacing
v Formatting Paragraphs
v Aligning Paragraphs
v Indenting Paragraph
v Setting Tabs
v Changing Line Spacing
v Adding Borders and Shading
v Creating a Bulleted List
v Creating a Numbered List
v On Your Own
v Selecting Styles
v Selecting Text
v Deleting Text
v Correcting Mistakes
v Using Undo
v Using Rado
v Using Auto Correct
v Moving Text
v Using Menu Commands to Move Text
v Using Drag-and-Drop Editing
v Copying text
v Checking Your Document
v Finding and Replacing Text
v Finding Text
v Replacing Text
v Checking Your Spelling
v Checking Your Grammar
v Looking Up Words in the Thesaurus
v Inserting a Picture from the Clip Art Gallery
v Inserting a Picture
v Adding a Border
Creating
Headers and Footers
v Adding Footnotes and Endnotes
Working
with Tables and Graphics
v Use a Wizard to help create and format a table.
v Enter and edit data in a table.
v Add borders and shading to a table.
v Convert a table to text.
v Add clip art to a document
v Using Wizard to Create and Format a Table
v Starting the Table Wizard
v Using Table Auto Format
v Entering Data into a Table
v Moving Around in the Table
v Entering Text
v Working with Columns and Rows
v Inserting and Selecting Columns and Rows
v Deleting Columns and Rows
v Inserting Columns and Rows
v Changing Cell Height
v Adding Borders and Shading
v Applying Shading
v Converting Text into a Table
Mail
Merge
v What is a Mail Merge ?
v Setting up the mail merge
v Creating a main document
v Building the data source
v Placing the merge fields
Templates,
Wizards and Printing Techniques
v Understanding Templates
v Using Templates
v Using Wizards
Printing
Techniques
Viewing
the Document before Printing
v Viewing the Document before Printing
v Changing to Print Preview
v Using Print Preview
v
Printing Your Document
MS
EXCEL-2000
INTRODUCTION
TO EXCEL
v Introduction to spreadsheets
v Introduction to excel
v File management in excel
v Create a new workbook
Moving around in the worksheet
v Entering data
v Check spelling or automatically correct spelling errors
v Selecting cells
v Autofill feature of excel
v Quick data entry
v Autosum facility of excel
v Autoformat in excel
v
Quick movement
FORMATTING
v Changing column width
v Modifying row height
v Changing font, size and style
v Changing allignment of text
v Wrapping of text
v Vertical alignment of cells
v Special formatting
v Conditionl formatting
ADDING
FORMULATE AND FUNCTIONS
v About formulae
v Adding a formula in cell
v Copying of formula
v About functions
v Adding a function
v Copying of functions
v Discussion of some useful functions
LARGE
DATABASES
v Create list
v Editing records with data form
v Data validation
v Performing what if analysis
v Annotating worksheet
v Re-orienting worksheet
v Pivot tables
v Special facilities of wizard
ADDITIONAL
FACILITIES TO FORMAT DATA
v Inserting rows and columns
v Giving quarterly subtotals
v Hide and unhide
v Grouping and outline
v Sorting
v Filtering of data
v Adding subtotals
CHARTS AND
MAPS
v Chart
v Move, resize and delete the chart
v Change the chart type
v Add new data to a chart
v Updating chart items
v Formating patterns, texture and colors of bars
v Creating a picture graph
v Background
v Trendlines in charts
v Maps
v Update the map
v Format the map items
WORK WITH
MULTIPLE WORKSHEETS
v Switching between worksheets
v Move or copy data from one worksheet to another
v Insert a new worksheet
v Reference to cells of other worksheet
v Giving workbook name in the address
v Renaming a worksheet
v Moving a worksheet
v Copying the worksheet
v Deleting a worksheet
PRINTING IN
EXCEL
v Giving header and footer
v Putting company name in the header
v Giving the footer
v Setting up the page
v Insert a page break
v Previewing the worksheet
v Printing of the worksheet
IMPORTING AND
EXPORTING OF DATA
v Introduction to import and export of data
v Importing and exporting data between excel and other
v Office applications
v View or save files from other programs as excel
v Workbooks
v Ways to retrieve data from an external database
v
Exchange data between excel and microsoft access
MS Power Point-2000
v Introduction
v Applications of Power Point
v File Management in Power Point
v Starting of Power Point
v Create the First Slide
v Creating a New Slide
v View the Presentation
v Saving a Presentation
v Close the Presentation
v Create a New Presentation
v Close Power Point
v Changing Views
Add Text and
other Objects to Slides
v Enter Text
v Edit Text
v Format Text
v Create Objects
v Format the Objects
v Grouping of objects
v Add Clip Art
v Create a Table
v Add a Chart
v Add Organization Chart
Templates and
Master Slides
v Changing the Color Schemes
v Background settings of Slides
v Concept of Master Slides
v Adding Header and Footer
v Applying a Readymade Design
v
Recorder of Slides
Giving
Animation effects
v Introduction to Animation Effects
v Giving Build Effects
v Customize Build Effects
v Giving Transition Effects
v Adding Transitions to a Slide
Links and
Action buttons
v Import a Word Document
v Create Macros
v Create Action buttons
v
Create Hyperlinks
Tuning up of
Presentation
v Introduction
v Create a Presentation with Auto Content wizard
v Performing a Rehearsal
v Creating Custom Slide Show
v Printing of Presentation
v Pack and Go wizard
MS
Access-2000
INTRODUCTION
§ Starting access 97
§ Opening an existing database
§ Opening the sample north window database
§ What is a database?
§ Managing database objects
UNDERSTANDING
DATABASES
§ Why store data ?
§ You use tables to store data
§ Terminology time
§ Why use multiple tables ?
CREATING
DATABASES
§ Introcuction
§ Database is not a table
§ Creating a blank database
§ Using the file new database dialong box
CREATING
TABLES
§ Using the table wizard
§ Object naming rules
§ Planning a table from scratch
§ Creating a table without using a wizard
§ Defining a tables fields
§ Choosing appropriate data types
§ Defining field properties
§ Setting a primary key
§ Defining indexes
§ Saving a table structure
§ Switching between design and datasheet views
§ Changing properties
§ About lookup fields
ADDING,
EDITING AND VIEWING DATA
§ Datasheet view and form view
§ Changing the datasheet appearances
§ Navigating forms and datasheets
§ Changing data in a table
§ Delting data
§ Copying and moving data
§ Special techniques for memo fields
§ Duplicate key message
§ Null value in index
§ Validation rule
§ Changing the table design from datasheet view
§ Creating a table from a blank datasheet
SORTING
§ Introduction
§ Quick and easy sorting
§ Sorts within sorts
§ Filtering out unwanted records
§ Using advanced filter/sort
§ Creating complex filters
§ Specifying selection criteria
§ Specifying 'and/or' criteria
§ Sample filters
§ Saving a filter as a query
QUERY
§ Introduction
§ What queries let you do
§ Types of queries
§ Creating a query
§ Viewing the dynaset
§ Running an action query
§ Refining your query
§ Changing field properties
§ Creating crosstab queries
§ Creating action queries
§ Update queries
§ Make table queries
CREATING FORMS
§ Creating forms with form wizards
§ Making hierarchical forms work properly
§ Charts
§ Pivot tables
§ Using wizards
§ Saving a form
§ Opening and using a form
§ Getting around in hierarchical forms
§ Changing the style
CREATING
REPORTS
§ Introduction
§ Kinds of reports
§ Groups, totals and summary reports
§ When the report wizard needs your help
§ Charts
§ Using wizards to create a report
§ Creating mailing lables
§ Formatting postal codes and phone numbers
§ Saving a report
§ Opening a report
§ Removing a filter and sort order
§
Changing the style for a report
Internet
& E-mail Services
¨ Introduction to Internet
§ Information Super Highway
§ Types of Network
§ Basic Uses of the Internet
§ Internet Administration
§ Client/Server Overview
§ Protocol used in different Generation
§ World Wide Web
§ From Dirt Road to Information Highway
¨ Domain Name System
§ Domain & Address
§ Domain Name System (DNS)
§ WAYS TO ACCESS INTERNET
¨ World Wide Web
§ Requirement of Internet
§ Working of Internet
§ Connection to Internet Using the Dial-Up Network Wizard
§ Connecting to Internet
§ More about World Wide Web
§ Introducing Web Browsers
§ Different Protocols in URLs
§ Test Drive with the Browser
§ Connecting with URL
§ Setting Up Internet Explorer to Send and Receive Mail
§ Customizing Internet Explorer
§ Getting a New Start in Life
§ Telling Internet Explorer Which Programs to Use When
§ Introducing the Profile Assistant
§ Defining Security Zones
§ Protecting children from Seeing Inappropriate content
§ changing content Advisor Settings
¨ Introduction to Front Page Express
§ Welcome to Front Page Express
§ Setting Up the Basic
§ Entering the page's Title
§ Adding Some Color to Web Page
§ Formatting Text
§ Adding Graphics to your Web Page
§ Saving Your Web Page
§ Browsing Your Web Page
§ Exiting Front Page Express
§ Getting Ready to go Live
§ Saving Your Page to a Web Server
§ Uploading File to an FTP Server
¨ Spice Up Your Web Page with Front Page Express
§ Link of Different Pages
§ Linking to Other Web Sites
§ Using a Background Graphic to Give Your Page
§ Personality.
§ Adding Sound to Your Web Pages
§ Adding a Sound File to the Background of Your Page
§ Setting the Front Page Express Table
§ Creating Moving Web Pages
¨ Electronic Mail Using Outlook Express
§ Composing an Email Message
§ Working with Address Book
§ Automatically Add contents to Your Address Book
§ Reading Email using Outlook Express
§ Reading a Message
§ Checking for New Messages
§ Reading File Attachment
§ Taking Acting on a Message
§ Web Based Email
§ Advantage of Using Web Based Email
§ GLOSSARY
Creating Complete Project Work