TOPICS COVERED
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 InDesign View
8.7.4 Saving a Table
8.7.5 Adding a Field To Table InDesign 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 InDesign 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 InDesign 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
PART-I(Operating System and MS – OFFICE)
| Course Duration |
Fees (Indian RS.) |
Fees (US $) |
| 45 sessions of 1 hr. each |
5,700 |
165 |
Computer Applications for Class X
1 . CONCEPT OF OBJECT
1.1 Introduction
1.2 What is an Object?
1.3 Object encapsulate state and behavior
1.4 Implementing Objects
2. INTRODUCTION CLASSES
1.1 Introduction
1.2 What is a Class?
Object’s Description ; Method ; Need for Class; Classes as Abstraction for Set of Objects; Class as Object Factory
3 INTRODUCTION JAVA On BlueJ Environment
1.1 Introduction
1.2 About Java
History Java; Byte Code; Java Virtual Machine (JVM) Sample Java Programs
1.3 Type of Java Programs
1.4 BlueJ-A Quick Introduction
1.5 Starting BlueJ
1.6 Writing Programs on BlueJ Environment
Creating a BlueJ Project ; Adding a New Class to Your Project ; Editing a Class Code ; Compiling the Source Code ; Saving Your Code ; Creating Objects ; Executing an Object’s Method ; Saving Output from the Console Window ; Printing Your Source Code ; Closing a Project ; Opening an Existing BlueJ Project ; Opening a Non BlueJ Java File.
1.7 Creating (Executable) Jar Files
1.8 Creating Documentation
4 CLASSES AS BASIS OF ALL COMPUTATION
1.1 Introduction
1.2 Java Character Set
1.3 Tokens
Keywords ; Identifiers ; Literals ; Separators ; Operators
1.4 Concept of Data Types
Primitive Data Types ; Reference Types
1.5 Variables
Declaration of a Variable ; Initialization of Variables
1.6 Reference Types Revisited
1.7 Constants
1.8 Operators in Java
Arithmatic Operators ; Increment /Decrement Operator ; Relational Operators; Logical Operators ;Shift Operators ; Bitwise Operators ;Assignment Operators ;Other Operators ; Operators Precedence
1.9 Expressions
2.0 Arithmatic Expressions
2.1 Java Statements
2.2 Significance of Classes
2.3 Objects as instances of class
5 FUNCTIONS
1.1 Introduction
1.2 Why functions?
1.3 Function definition
1.4 Function prototype and signature
1.5 Accessing a function
Actual and formal parameters; arguments to functions
1.6 Pass by value(call by value)
1.7 Call by reference
1.7 Returning from a function
The return statement; returning values
1.8 Pure and impure functions
1.9 Function overloading
Need for function overloading; Declaration and Definition
2.0 Calling Overloaded Functions
6 CONSTRUCTORS
1.1 Introduction
1.2 Constructor
1.3 Need for Constructors ; Declaration and Definition
1.4 Types of Constructors
Non-parameterized ; Parameterrized
1.5 The this Keyword
7 CLASS AS USER DEFINED TYPE
1.1 Introduction
1.2 Class as Composite Type
1.3 Class A User-Defined Datatype
1.4 Creating And Using Objects
Using Objects ; Controlling Access to Members of a Class – Access Specifiers Using Classes
8 USING LIBRARY CLASSES
1.1 Introduction
1.2 Simple Input / Output
1.3 Exception handling
Concept of Exception handling; Exception handling in Java
1.4 Wrapper Classes
1.5 Working with Strings
Creating Srtings ; Creating StringBuffers ; Accessor Methods
1.5 Packages in Java
Importing Package and their Classes ; Using Dates and Times (Date and Calendar Objects) ; Package in Java ; User Defined Packages
9 DECISION MAKING STATEMENTS
1.1 Introduction
1.2 Programming Constructs
1.3 Selection statements
The if Statement of Java ; The switch Statement
10 INTERATION THROUGH LOOPS
1.1 Introduction
1.2 Elements that Control a loop (Parts of a Loop)
1.3 The for Loop – Fixed Number of Iterations
1.4 The for Loop Variations
1.5 The while Loop
1.6 Variations in a while Loop
1.7 The do-while Loop
1.8 Nested Loops
1.9 Comparison of Loops
2.0 Jump Statements
The break Statement ; The continue Statement ; Labels and Branching Statements
11 ENCAPSULATION
1.1 Introduction
1.2 Visibility Modifiers
1.3 Scope and Visibility Rules
12 ARRAYS
1.1 Introduction
1.2 Need for Arrays
1.3 Types of Arrays
Single Dimensional Arrays ; Some facts about Arrays ; Two – Dimensional Arrays
1.4 Searching in 1-D Arrays
1.5 Sorting
1.6 Arrays vs. Objects
1.7 Advantages and Disadvantages of Files
13 OPERATIONS ON FILES
1.1 Introduction
1.2 Files
1.3 Java Streams
1.4 Operations on Files
Buffering ; Output to Text Files ; Input from Text Files
1.5 String Tokenizer
Processing a Number Sequence with StringTokenizer StringTokenizing and File Handling
1.6 Stream Tokenizer.
