Modern Nepal College, Putalisadak, Kathmandu

Word Processing Software

Microsoft Word
Microsoft word is very powerful, advance and useful word-processing software which is developed by
Microsoft Corporation, USA. It has all kind of word processing facilities like To create, edit, format, save
and print document, to check spellings and grammar, to search for synonyms and antonyms (thesaurus), to
work with newspaper columns, tables, to add footnotes and endnotes, page number, special symbols,
bookmarks, comments, to insert the picture, objects (e.g. video clips, audio clips, power point presentations,
equations, AutoCAD drawings etc.).

The file of Ms-Word is called document and the extension is doc.

In spite of above-mentioned matters, there are many other features available in WinWord, which help us to
furnish a document (e.g. report, letter, essay etc.) in such a way that we can produce the professional outlook.
Now a day, WinWord is considered as the best word-processing software.

Features of Word Processing Software

Formatting of documents
Most of the word processing features are used to format the document. The process of formatting a document
includes
 changing the appearance of text
 changing the layout of text on the page
 inserting pictures, symbols and other graphic elements

Therefore, formatting includes most of the tasks before printing a final document. The main objective of
formatting is to makes a document attractive. Formatting is of three categories: character format, paragraph
format and document format.

Speller (Spell Checker)

Speller is one of the most important features of a Word Processor. Every Word Processor contains a small
dictionary inside it. This dictionary can be used to check spelling errors. Using this facility is very easy. A
user can click a “Spelling and Grammar” button and check spelling within the document. The speller
catches spelling mistakes. It also provides options for replacing with correct word and ignoring word.

Grammar Checker
It is another important feature of a Word Processor. It works like speller but it inspects a document for
grammatical problems. A grammar checker compares each sentence to a set of standard grammatical rules
and informs you. If it finds a problem, it provides grammatically correct options.

Thesaurus
Thesaurus is a source of alternative words in any Word Processor. It provides antonyms and synonyms of
words. A user can select a word and use thesaurus tool to display words with the same meaning (synonym)
and opposite meaning (antonym).

Table
This feature allows user to create tables in just a few steps. Some of the features of a table are:
 User can mention number of rows and columns in a table
 new rows or columns can be inserted
 existing rows or columns can be deleted
 Rows or columns can be merged or splitted
 in-build model are available to change outlook of a table
Chapter 1/Software Applications/Page No.1 Subash Dangol
 Modern Nepal College, Putalisadak, Kathmandu

Mail Merge
A mail merge is the process of combining a form letter with the contents of a database. The database usually
contains name and address list of people. So, mail merge prepares an individual letter for all the persons in
the database. The mail merge feature makes it easy to send the same letter to a list of different people with
the correct name and address printed on each letter.

Graphics and Sound

With a Word Processor, use can easily add graphic images such as photos, drawings, or clipart to a
document. After graphic has been imported, user can move, size, crop, and add borders to it. Word Processor
provides a collection of graphic image files. User can select any one of them and put on a document.

User can embed sound file in a document in the same way that he or she embeds a graphic file. When user
embeds a sound file, it appears as an icon on the document. Clicking the icon plays the sound file.

Template
Templates are pre-designed documents that blank. The fonts, paragraph formats, heading, rules, graphics,
headers, or footers and margins are preset in a template. A Word Processor contains varieties of templates.
User can open a document template, type text into it and save it.

Spreadsheet Software

Microsoft Excel
Microsoft Company developed this program, so it is known as Microsoft Excel. It is a spreadsheet program
where we can insert data, process them, sort them, filter them and create chart from the data etc., in this
program we can perform various kinds of Mathematical, financial, statistical, engineering calculations. Using
this program we can create bill, voucher, salary sheet, income& expenses statement, mark sheet, purchase
book, sales book, balance sheet etc.

The file of Ms-Excel is called workbook and its extension is xls.

Worksheet: - The large working area of a workbook is called worksheet. There are 65,536 rows and 256
columns in a worksheet.

Cell: - The intersection between row and column is called Cell. Each cell contains 32000 Characters.

Features of Spreadsheet Software

Big and powerful worksheet

Worksheet provides a very large space to enter and edit data. A typical worksheet can accommodate ten or
more pages of data. Collection of worksheet is called workbook. A worksheet contains thousands of
individual cells. Every cell is capable of storing data and making calculation. Each cell is referred by a
unique address called cell address.

Formulas and Functions

The power of Spreadsheet lies in formula. A formula calculates numbers based on values or formulas in other
cell. User can create many kinds of formulas manually to do basic arithmetic operations, calculus, or
trigonometric operations, and so on. Spreadsheet also comes with many built-in functions. The functions
perform specialized calculations automatically, such as monthly payment of a loan, depreciation of an asset,
etc.

Chapter 1/Software Applications/Page No.2 Subash Dangol

 Modern Nepal College, Putalisadak, Kathmandu

Formatting numbers
Spreadsheet programs offer numerous formats specifically for numbers. Numbers can appear as rupees, or
dollars and cents, percentages, dates, times and fractions. They can be shown with or without commas and
decimal points.

Charts
A popular feature of Spreadsheet software is its ability to generate charts based on numeric data. Chart
makes data easier to understand and analyze. Creating a chart is very simple in Spreadsheet software. Every
Spreadsheet software offer varieties of charts, such as column chart, line chart, pie chart, etc.

Analysis tools
Modern spreadsheet software provides various tools to analyse data. User can create a report summarizing
the different cases. One can also use these tools to find the value that meets specified conditions.

Database management
A worksheet can offer large volume of records. These records form a database. A Spreadsheet program
provides various tools, which can be used to sort, update, search, and manage database.

Presentation Software

Microsoft Power Point

Power Point is presentation software where we can make a slide, design, format, animation, sound, set effect
in particular slide, etc. This is mostly used in display project overview, display program by Ms-PowerPoint.
It is developed by Microsoft Corporation USA.

The file of Ms-PowerPoint is called slide and its extension is ppt.

Slide show (presentation)

This option is use to present the slides in full screen mode with different slide transition and animation effect.
After crating and formatting the slides

Features of Presentation Software

Varieties of output
User can get the presentation from different output media. He or she can:
 show presentation on the computer’s monitor
 print the slides on transparent sheets, and show them through Over-head projector
 use Video projector to show full-fledge multimedia presentation

Outlining
Outlining tool enables user to organize slide’s contents. It actually arranges the contents and views them in
order.

Animation
User can use animation tools to apply special effects on text or images. Animation makes text pop up or
crawl onto the screen. Use can also create animated transitions, a special effect that causes slides to bend
together when user switch from one slide to another.

Annotations

Chapter 1/Software Applications/Page No.3 Subash Dangol

 Modern Nepal College, Putalisadak, Kathmandu
This tool allows user to prepare a set of notes (called annotations) to accompany the slides. These notes are
visible only to user, or user can print them with or without actual slide.

Sound and video

Slide presentations can be full-fledged multimedia events. User can embed sound or video object into a slide.
Then play the object by double-clicking its icon during a presentation.

Other embedded objects

User can embed different types of objects, such as links to Web pages or other applications, in a presentation.
When a user clicks such link in a slide, the Web page opens or other application runs.

Web Page conversion

Like Word Processors and other software, Presentation Program let user save document in HTML format.
With this, a presentation file can be used as a web page, or it can be available on-line.

Database Software

Microsoft Access
Microsoft Access is a powerful multi-user RDBMS (Relational Database Management system) developed by
Microsoft Corporation and can be used to store and manipulate large amounts of information and perform
repetitive tasks. Access stores an entire database application within a single file with a .mdb extension, which
can contain data objects, like tables, indexes and queries, as well as application objects like forms, reports,
macros, and visual basic code.

Although the term “database” typically refers to a collection of related data tables, an Access database
includes more than just data. In addition to tables, an Access database file contains several different types of
database objects:
 Saved queries for organizing data,
 Forms for interacting with the data on screen,
 Reports for printing results,

Features of Database Software

Microsoft Access 2000 offers a variety of features for different database needs and can be used to different
types of applications such as:
 Personal Applications
 Small Business Applications
 Departmental Applications
 Corporation-wide Applications
 As a front end for enterprise wide client/server Applications
 Intranet / Internet Applications

Database
A database is a collection of data organized in a manner, which allows retrieval and use of that data, by
anyone needing it. A database is organized and designed to allow a large number of users to draw
information from it for many different purposes in many different formats.

DBMS (Database Management System)

A database-management system (DBMS) consists of a collection of interrelated data and a set of programs to
access those data. The collection of data, usually referred to as the database, contains information about one
particular enterprise.

Chapter 1/Software Applications/Page No.4 Subash Dangol

 Modern Nepal College, Putalisadak, Kathmandu
The Primary goal of a DBMS is to provide an environment that is both convenient and efficient to use in
retrieving and storing database information.

Database systems are designed to manage large bodies of information. The management of data involves
both the definition of structures fro the storage of information and the provision of mechanisms for the
manipulation of information. In addition, the database system must provide for the safety of the information
stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several
users, the system must avoid possible anomalous results. The importance of information in most
organizations - which determines the value of the database - has led to the development of a large body of
concepts and techniques for the efficient management of data.

Some popular DBMS are FoxPro, Clipper, SYBASE, MS-ACCESS, ORACLE, MS SQL Server, MY SQL,
etc.

Computer Graphics
Computer graphics is a field related to the generation of graphics using computers. It includes the creation,
storage, and manipulation of images of objects. These objects come from diverse fields such as physical,
mathematical, engineering, architectural, abstract structures and natural phenomenon. Computer graphics
today is largely interactive; that is, the user controls the contents, structure, and appearance of images of the
objects by using input devices, such as a keyboard, mouse, or touch-sensitive panel on the screen.

Chapter 1/Software Applications/Page No.5 Subash Dangol