Computer applications I (Theory & Practical) Pdf notes

Description

Computer applications I (Theory & Practical) Pdf notes

CHAPTER 1: INTRODUCTION TO COMPUTER APPLICATIONS

Computer Application/Application software
Classification of Computer software
Stating the applications in a computers
Computer – Applications

CHAPTER 2: INTRODUCTION TO OPERATING SYSTEM ENVIRONMENT

Introduction to OS
Function of Operating system
Types of Operating System
Use of operating systems command
DOS Internal and External Commands

CHAPTER 3: WORD PROCESSING

Introduction to Word processing
Features of a word processor
Examples of word processor programs
Types of word processing applications
Features of Standard Word Processors
Opening Microsoft Word 2007 in the practical room
Screen Layout
Quick Access Toolbar
Using the Keyboard in MS Word
Basic actions with documents
Editing document
Formatting text
Formatting Paragraphs
Adding Tables
Graphics
Page Formatting
Footnotes
Bulleted and Numbered Lists
Proofing a Whole Word 2007 Document
Mail merge
Show or hide comments or tracked changes
Automating Common Word Tasks
Table of content, Figures and tables
Print an MS Word document

CHAPTER 4: SPREADSHEET

Introduction to Spreadsheets
The Main Spreadsheets
Basic MS Excel Skills
Excel Formula and Functions
Making Changes to the Contents of a Spreadsheet Cell
Saving Your Spreadsheet
Printing a Spreadsheet
Editing a Spreadsheet
Formatting a Spreadsheet
Sorting Filtering and Data Validation
Charts
What if analysis
Create a Scenario PivotTable Report
Summarizing, consolidating and outlining data
Automating simple task
Print a Worksheet

CHAPTER 5: DATABASE

Introduction to Databases
Traditional File Organization
What are Data Models? Type of Data Models
Introduction to Microsoft Access
Database Concepts
Introduction to Access 2007
Exploring Access 2007
Creating a New Database
Displaying Different Views
Converting and Compatibility Issues
Navigation Pane features and controls
Exploring an Access Database

CHAPTER 6: DESKTOP PUBLISHING

Introduction to Desk Top Publishing
Microsoft Publisher
Publisher Basics and Feature
Create a table
Working with Color Schemes
Change page size, paper size, or page orientation
Import a Word document
Insert a file
Add, change, or remove a border in Publisher
Determine your desktop printer’s nonprintable region
Prepare, publish, and maintain your Publisher Web site

CHAPTER 6: PRESENTATIONS

Introduction to Presentation
Microsoft PowerPoint
The Basics: Creating and Editing a Presentation
Create a New Presentation
Entering Text on a Slide
Adding Clip Art to a Slide
Editing Slide Text
Formatting Text Slides
Preparing to Deliver a Presentation
Adding Transitions to a Slide Show
How to Set Transition Effects
Animating Text
Printing Slides, Speaker Notes, and Handouts
Creating a Custom Design Template
Inserting Graphics
Adding Footers
Automate simple tasks – Create a macro in PowerPoint

CHAPTER 7: INTERNET AND EMAIL

Introduction to the Internet
Features and functions of the Internet
Internet Services
Browsing the Web
Setting or changing a Home Page
Downloading Web pages and programs from the Internet
Printing Web pages
Creating a Bookmark
Working Offline
Making Web pages available for offline viewing
Electronic Mail (E-Mail)

CHAPTER 8: EMERGING ISSUES AND TRENDS