notice:

Admission Open in all Courses.

0-LEVEL COURSE

                                  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

2

 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

3
Operating System – MS DOS
 Importance of an Operating System
 A Guarantee to an Instant Start on MS-DOS
 Getting Started on DOS with Booting the System
 MSDOS.SYS
 Command COM
 Telling DOS the Data and Time
 Concepts Review
 Getting and Interpreting a Directory
 Making use of Pause Key to freeze scrolling
 Getting a Printed Copy of a Directory
 Using Wild Card Character
 What is a Wild Card Character ?
 Concepts Review
 Making use of Hierarchical Directories
 What are Hierarchical Directories ?
 Hierarchical Directory System
 Making use of MKDIR or MD command
 Making use of CHDIR or CD command
 Making use of the RMDIR or RD command
 Concepts Review
 Copying commands
 Copy command
 Copy Source file Destination file
 Disk copy source Destination
 Concepts Review
 Displaying the file contents
 Syntax
 Type Filename
 Print Filename(s)
 DEL Filename(s)
 Erase Filename(s)
 Formatting Disks
 FORMAT <DRIVE:>/<SWITCHES>
 Renaming Files
 Rename Original Filename New filename
 Clearing the Screen
 Displaying the Version Number
 VER
 Find
 Sort Filename

INTRODUCTION TO WINDOWS 2000
 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

4
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 ?
 Introduction to the Desktop
 Main Icons on the Desktop
 Properties of the Desktop

AN APPLET TEMPORARILY KEEPS APPLICATIONS AWAY
 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
5
 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 THEWHOLEWORLD
 At a glance :
 Introduction to In Box
 Sending & Receiving e-mail
 Sending & Receiving Fax

MULTIMEDIA-SINGING ALL THEWAY
 What is a multimedia ?
 Playing of a CD with CD Player
 Playing of a CD with Media Player
 Working with a Sound Recorder

INTRODUCTION TO MS OFFICE-2000
 What is Windows
 What is suite of Software
 Selecting in Office Programs
 Using Tools and Menus
 Working in Documents
 Cutting, Copying, and pasting
 Saving a Document
 Getting Help
 Advantages of Word Processing under Windows
 Various Word Processors available under Windows
Introduction to MSWord-2000
 Opening a New Document
 Opening an Existing Document
 Recently opened files
 Opening from the Documents menu
 Exporting and Importing Files
 Setting Up Your Pages
 Choosing page Size and Orientation
 Changing page Size
 Changing Orientation
 Setting Margins
 Centering Page
 Controlling Page Breaks

6
 Typing in the Document
 Inserting Today’s Date
 Moving Around in the Document
 Creating Sections
 Inserting a Section break
 Formatting a Section
 Viewing Sections
 Using Columns
 Numbering Pages
 On Your Own
 Saving a File
 Quitting Word
Formatting Text
 Formatting Characters
 Choosing Fonts
 Enhancing Text Appearance
 Inserting Special Characters
 Changing Character Spacing
 Formatting Paragraphs
 Aligning Paragraphs
 Indenting Paragraph
 Setting Tabs
 Changing Line Spacing
 Adding Borders and Shading
 Creating a Bulleted List
 Creating a Numbered List
 On Your Own
 Selecting Styles
 Selecting Text
 Deleting Text
 Correcting Mistakes
 Using Undo
 Using Redo
 Using Auto Correct
 Moving Text
 Using Menu Commands to Move Text
 Using Drag-and-Drop Editing
 Copying text
 Checking Your Document
 Finding and Replacing Text
 Finding Text
 Replacing Text
 Checking Your Spelling
 Checking Your Grammar
 Looking Up Words in the Thesaurus
 Inserting a Picture from the Clip Art Gallery
 Inserting a Picture
 Adding a Border
Creating Headers and Footers
 Adding Footnotes and Endnotes
Working with Tables and Graphics
 Use a Wizard to help create and format a table.
 Enter and edit data in a table.

7
 Add borders and shading to a table.
 Convert a table to text.
 Add clip art to a document
 Using Wizard to Create and Format a Table
 Starting the Table Wizard
 Using Table Auto Format
 Entering Data into a Table
 Moving Around in the Table
 Entering Text
 Working with Columns and Rows
 Inserting and Selecting Columns and Rows
 Deleting Columns and Rows
 Inserting Columns and Rows
 Changing Cell Height
 Adding Borders and Shading
 Applying Shading
 Converting Text into a Table

Mail Merge
 What is a Mail Merge ?
 Setting up the mail merge
 Creating a main document
 Building the data source
 Placing the merge fields
Templates, Wizards and Printing Techniques
 Understanding Templates
 Using Templates
 Using Wizards
Printing Techniques
Viewing the Document before Printing
 Viewing the Document before Printing
 Changing to Print Preview
 Using Print Preview
 Printing Your Document

MS EXCEL-2000

INTRODUCTION TO EXCEL
 Introduction to spreadsheets
 Introduction to excel
 File management in excel
 Create a new workbook
 Moving around in the worksheet
 Entering data
 Check spelling or automatically correct spelling errors
 Selecting cells
 Auto fill feature of excel
 Quick data entry
 Auto sum facility of excel
 Auto format in excel
 Quick movement

8
FORMATTING
 Changing column width
 Modifying row height
 Changing font, size and style
 Changing alignment of text
 Wrapping of text
 Vertical alignment of cells
 Special formatting
 Conditional formatting

ADDING FORMULATE AND FUNCTIONS
 About formulae
 Adding a formula in cell
 Copying of formula
 About functions
 Adding a function
 Copying of functions
 Discussion of some useful functions

LARGE DATABASES
 Create list
 Editing records with data form
 Data validation
 Performing what if analysis
 Annotating worksheet
 Re-orienting worksheet
 Pivot tables
 Special facilities of wizard

ADDITIONAL FACILITIES TO FORMAT DATA
 Inserting rows and columns
 Giving quarterly subtotals
 Hide and unhide
 Grouping and outline
 Sorting
 Filtering of data
 Adding subtotals

CHARTS AND MAPS
 Chart
 Move, resize and delete the chart
 Change the chart type
 Add new data to a chart
 Updating chart items
 Formatting patterns, texture and colors of bars
 Creating a picture graph
 Background
 Trend lines in charts
 Maps
 Update the map
 Format the map items

WORK WITH MULTIPLE WORKSHEETS
 Switching between worksheets
 Move or copy data from one worksheet to another
9
 Insert a new worksheet
 Reference to cells of other worksheet
 Giving workbook name in the address
 Renaming a worksheet
 Moving a worksheet
 Copying the worksheet
 Deleting a worksheet

PRINTING IN EXCEL
 Giving header and footer
 Putting company name in the header
 Giving the footer
 Setting up the page
 Insert a page break
 Previewing the worksheet
 Printing of the worksheet

IMPORTING AND EXPORTING OF DATA
 Introduction to import and export of data
 Importing and exporting data between excel and other
 Office applications
 View or save files from other programs as excel
 Workbooks
 Ways to retrieve data from an external database
 Exchange data between excel and Microsoft access
MS Power Point-2000
 Introduction
 Applications of Power Point
 File Management in Power Point
 Starting of Power Point
 Create the First Slide
 Creating a New Slide
 View the Presentation
 Saving a Presentation
 Close the Presentation
 Create a New Presentation
 Close Power Point
 Changing Views
Add Text and other Objects to Slides
 Enter Text
 Edit Text
 Format Text
 Create Objects
 Format the Objects
 Grouping of objects
 Add Clip Art
 Create a Table
 Add a Chart
 Add Organization Chart
Templates and Master Slides
 Changing the Color Schemes
 Background settings of Slides
10
 Concept of Master Slides
 Adding Header and Footer
 Applying a Readymade Design
 Recorder of Slides
Giving Animation effects
 Introduction to Animation Effects
 Giving Build Effects
 Customize Build Effects
 Giving Transition Effects
 Adding Transitions to a Slide
Links and Action buttons
 Import a Word Document
 Create Macros
 Create Action buttons
 Create Hyperlinks
Tuning up of Presentation
 Introduction
 Create a Presentation with Auto Content wizard
 Performing a Rehearsal
 Creating Custom Slide Show
 Printing of Presentation
 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
 Introduction
 Database is not a table
 Creating a blank database
 Using the file new database dialogue 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
11
 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
 Deleting 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

latest news:

Free Education for poor peoples who had BPL Card.
Head office is going to shift at new address Gobind Puri New Delhi.
HEAD OFFICE :508/A Gobind Puri New Delhi
Contact : +91-8433107033, +91-8285278233
REASONAL OFFICE : Naveen Nagar Babarpur Auraiya, Uttar Pradesh Pin. 206121
Contact : 91-9548860192, +91-9058346020