Part
I: Operating
System and MS – OFFICE
1. Command User Interface
1.1 Introduction
1.2 The Need of Operating System
1.3 Function of Operating System
1.4 User Interface
1.4.1 What are CUI and GUI?
1.5 Introducing MS – DOS
1.6 Disk Drives
1.7 Loading of Dos Into Main Memory (Booting)
1.8 Files and file naming conventions
1.9 Types of Dos Commands
1.10 Directory Structure of MS –DOS
1.11 Concept of Path
1.12 Wild Cards
1.13 Some Dos Internal Commands
1.13.1 File Commands
1.13.2 Directory Commands
1.13.3 Miscellaneous Commands
1.13.4 External Commands; Summary; Question bank (objective & subjective)
keywords; Assignment
2. Graphics User Interface
2.1 Introduction
2.2 Introduction to windows operating system
2.2.1 The desktop
2.2.2 The window.
2.2.2 A The application window
2.2.2 B The document window
2.2.2 C The Dialog Window
2.2.3 The Icons
2.3 Explore Your Computer
2.3.1 The Start Button and Taskbar.
2.3.2 My Computer
2.3.3 Windows Explorer
2.4 Starting and Closing Programs
2.5 Managing File and Folders
2.5.1 Creating Folders
2.5.2 Finding Files and Folders
2.5.3 Opening Files and Folders
2.5.4 Renaming Files and Folders
2.5.5 To Move or Copy a File or Folder
2.5.6 To copy a File to Floppy Disk
2.5.7 To Delete a File or Folder
2.6 Creating Shortcuts
2.7 Using Clipboard
2.8 Shutting Down the Computer; Summary; Question Bank (Objective
and Subjective)Keywords; Assignment
3. Installing Software
3.1 Introduction
3.2 Installing Operating System
3.3 Performing a New Installation for Windows 98
3.4 Installing a Software other than OS
3.5 Setting up a printer ; Summary ; Question Bank (Objective
and Subjective) ; Keywords; Assignment
4. The Internet
4.1 Introduction
4.2 Computers and Communications- Some Concepts
4.3 Networking
4.3.1 Need for Networking
4.4 Components of Network
4.5 Modem
4.6 Types of Network
4.6.1 Local Area Network (LAN)
4.6.2 Metropolitan Area Network (MAN)
4.6.3 Wide Area Network (WAN)
4.7 Introduction of Internet
4.7.1 World Wide Web (www)
4.7.2 Uses of Internet
4.7.3 Network Addressing
4.8 Information Retrieval
4.9 Electronic Mail
4.9.1 E-Mail Address
4.9.2 Advantages of E-Mail
4.9.3 E-Mail Primer
4.9.4 Emoticons
4.9.5 Acronyms
4.9.6 E-Mail Protocols
4.10 Search Engines
4.10.1 Finding Information Using Search Engine
4.10.2 How Search Engine Works
4.10.3 Some Searching tips
4.10.4 Finding People on the Net
4.11 FTPing
4.11.1 FTP Session Using a Web Browser; Summary; Question Bank
(Objective and Subjective); Keywords; Assignment
5. MS WORD
5.1 Introduction
5.2 What is word Processor?
5.3 Getting Started With Word Processor
5.4 Word Processing Terminology
5.5 Editing Document
5.6 Finding and Replace
5.7 Tab Stops
5.8 Formatting the Document
5.9 Printing and Getting Help
5.10 Spell Check
5.11 Inserting Graphics in the Word
5.12 Some Advanced Tool of Word
5.13 Mail Merge; Summary; Question Bank (Objective and Subjective);
Keywords;Assignment
6. MS EXCEL
6.1 Introduction
6.2 MS Excel Basics
6.3 Editing Cell Contents
6.4 Command For Worksheet / Workbook
6.5 Some Useful Functions
6.6 Formatting Data
6.7 Charts in MS Excel
6.8 Printing Worksheets / Charts; Summary; Question Bank (Objective
and subjective);Keyword; Assignment
7. MS POWERPOINT
7.1 Introduction to Presentation
Graphics
7.2 Steps to a PowerPoint Presentation
7.3 Presentation Tips
7.4 Physical Aspects of a Presentation
7.5 Creating New Presentation
7.6 PowerPoint Views
7.7 Adding New Slides
7.8 Editing and Formatting a Slides
7.9 Adding Illustrations to Slides
7.10 Creating Slides Shows; Summary; Question Bank (Objective
and subjective);Keyword;
Assignment
8. MS-ACCESS I
8.1 Introduction
8.2 Database Functioning
8.2.1 How Database Works
8.2.2 Advantages of Database
8.3 Designing a Database
8.4 Starting MS-Access
8.4.1 MS-Access Window
8.5 Creating MS-Access Database
8.5.1 Creating Database Using Wizards
8.5.2 Creating Database Using Scratch
8.6 Let us Discuss Field Properties
8.7 Creating Tables
8.7.1 Creating Tables using the Table Wizards
8.7.2 To Create Table in Datasheet View
8.7.3 To Create Table in Design View
8.7.4 Saving a Table
8.7.5 Adding a Field To Table in Design View
8.7.6 Entering Caption and Default Value for a Field
8.7.7 Setting Field Properties: Size, Format etc
8.8 Viewing a Table
8.8.1 Setting or Changing Primary Key
8.9 Entering Data in a Table
8.10 Editing Data in a Table
8.11 Opening an existing Database
8.12 Navigating in Table
8.13 Table and Field Specifications
8.14 Record Validation Rules
8.15 Sorting and Indexing
8.16 Some Useful Shortcuts Keys; Summary; Question Bank(Objective
and subjective);Keyword; Assignment
9. MS-ACCESS II
9.1 Introduction
9.2 Queries
9.2.1 Types of Queries
9.2.2 Relationships
9.2.2A Types of Relationships
9.2.2B Foreign Key and Referential Integrity
9.2.2C Defining Relationships
9.2.3 Creating Queries
9.2.3A A creating Select Query through Wizard
9.2.3B A creating Select Query Manually in Design View
9.2.3C Creating Parameter Query
9.2.4 Sorting Records in Queries
9.2.4A Consideration when sorting records in table, query, form,
or
report
9.2.4B Sort Records by using the Design Grid of a query
9.2.5 Deleting Multiple Records Using Queries
9.2.5A Delete records from one table or tables in a one-to-one
relationships
9.2.5B Delete records by using query that includes both in a
one- to-one
relationships
9.3 Reports
9.3.1 Creating report With Report Wizards
9.3.2 Printing the Records
9.3.3 Formatting A Report
9.4 Creating a Report in Design View
9.4.1 Setting Group Ranges
9.5 Mailing Labels
9.6 Object Linking and Embedding
9.7 Working With Multiple Databases; Summary; Question Bank
(Objective and subjective);
Keyword; Assignment
10. More On MS-Word and MS-Excel
10.1 Introduction
10.2 Table Of Contents
10.2.1 Create a Table of Contents by using Built-in Heading
Styles
10.3 Importing Files, Sounds and Images in Ms-Word and Ms-Excel
10.3.1 Create an Embedded object from an existing Microsoft
Excel
Worksheet or Chart
10.3.2 Create an Embedded object from One Or More PowerPoint
Slides
or an Entire Presentation
10.3.3 Insert a Movie into a Word Document
10.3.4 Insert an Existing Sound File into a Word Document
10.3.5 Insert Data from Ms-Word to Ms-Excel
10.4 Working with Multiple Spreadsheets/Workbooks
10.4.1 Referring to Cell in another Worksheet of same Workbook
10.4.1A Refer to the same Cell or Range on Multiple Sheets by
using 3-D Reference
10.4.2 Referring to Cell in another Workbook
10.4.2A Create a Formula to Calculate Data on another Worksheet
or Workbooks
10.5 What-If Analysis
10.5.1 Data Tables
10.5.2 Components Involved in Data Tables
10.5.3 Creating a One-Variable Data Table
10.5.4 Creating a Two-Variable Data Table; Summary; Question
Bank
(Objective and subjective); Keyword; Assignment
11. Computing and Ethics
11.1 Introduction
11.2 Computer Ethics
11.2.1 Software Ethics
11.3 Major Ethical Issues
11.3.1 Individual’s Right to Privacy
11.3.2 Intellectual Property Rights
11.3.3 Accuracy of Information
11.4 Hacking And Piracy
11.4.1 Software Piracy
11.5 Getting Protected
11.5.1 Protective Measures
11.5.2 Preventive Maintenance
11.6 Computer Crime
11.6.1 Reasons for Computer Crimes
11.7 The Ten Commandments of Computers Ethics Summary; Question
Bank (Objective and subjective); Keyword; Assignment
Part-II :Introduction
To JAVA
1. Concept of Objects
1.1 Introduction
1.2 What is an Object
1.2.1 Objects encapsulate state and behavior
1.3 Implementing Objects
2. Introducing Classes
2.1 Introduction
2.2 What is a class
2.2.1 Object’s Description
2.2.2 Methods
2.2.3 Need for Class
2.2.4 Classes as Abstraction for sets of Objects
2.2.5 Class as Objects Factory
3. Introducing Java On
Bluej Environment
3.1 Introduction
3.1 About Java
3.2.1 History of Java
3.2.2 Byte Code
3.2.3 Java Virtual Machine (JVM)
3.2.4 Characteristics of Java
3.3 Sample Java Program
3.3.1 Types of Java Program
3.4 BlueJ-A quick Introduction
3.5 Starting BlueJ
3.6 Writing Programs on BlueJ Environment
3.6.1 Creating a BlueJ Projects
3.6.2 Adding a New Class to your Projects
3.6.3 Editing a Class Code
3.6.4 Compiling the Source Code
3.6.5 Saving Your Code
3.6.6 Creating Objects
3.6.7 Executing an Object’s Methods
3.6.8 Saving output from the Console Window
3.6.9 Printing Your Source Code
3.6.10 Closing a Project
3.6.11 Opening an Existing BlueJ Projects;
3.6.12 Opening a Non BlueJ Java File
3.6.13 Executive a Java Application’s main Methods
3.7 Creating (Executable) jar Files
3.8 Creating Documentation
4. Classes as Basis of all Computation
4.1 Introduction
4.2 Java Character Set
4.3 Tokens
4.3.1 Keywords
4.3.2 Identifiers
4.3.3 Literals
4.3.4 Separators
4.5 Variables
4.5.1 Declaration of a Variable
4.5.2 Initialization of Variable
4.6 Reference Types Revisited
4.7 Constants
4.8 Operator in Java
4.8.1 Arithmetic operator
4.8.2 Increment/Decrement Operators
4.8.3 Relational Operators
4.8.4 Logical Operators
4.8.5 Shift Operators
4.8.6 Bitwise Operators
4.8.7 Assignment Operators
4.8.8 Others Operators
4.8.9 Operators Precedence
4.9 Expressions
4.9.1 Arithmetic Expressions
4.10 Java Statements
4.11 Significance of Classes
4.12 Objects as Instances of Class
5. Function
5.1 Introduction
5.2 Why Function?
5.3 Function Definition
5.3.1 Function Prototype and Signature
5.4 Accessing a Function
5.4.1 Actual and Formal Parameters
5.4.2 Arguments to Function
5.5 Pass By Value (Call By Value)
5.6 Call by Reference
5.7 Returning from a Function
5.7.1 The return statement
5.7.2 Returning Values
5.8 Constructors
5.8.1 Need for Constructor
5.8.2 Declaration and definition
6. Flow of Control
6.1 Introduction
6.2 Programming Constructor
6.3 Selection
6.3.1 The if Statement of Java statements
6.3.2 The switch Statement
6.4 Iteration Through Loops
6.4.1 Elements that control a Loop (Parts of Loop)
6.5 The For Loop – Fixed Number of Iterations
6.6 The while Loop
6.7 The Do-while Loop
6.8 Jump Statements
6.8.1 The break Statement
6.8.2 The continue Statement
+91-22-236762182