Unit 4: Application Package Class 11 Computer Notes | Based On New Syllabus

Chapter 4 - Application Package

#Word Processor

Word processor is application software that helps for writing, editing, formatting a document. Moreover, it also helps for designing and presenting the document in an attractive format. We can insert pictures, tables, shapes, graphs, objects, etc. It also provides features like labels, mailings, grammar, spell checking, macros, equations, and mail merge. Most common word processor packages are: MS Word, Word Perfect, WordStar, Lotus Notes, etc.

Features of word processing

1. It is used for creating, saving and closing, printing a document.
2. It is used for drawing pictures, charts, graphs, text boxes and frames.
3. It is used for formatting text, paragraphs, tables, and pages.
4. It is used for inserting symbols, objects, word art, clip art, graphics, etc.
5. It is used for automating the work by using macros.
6. It is used for sending multiple mails by using mail merge tools.
7. It is used for checking spelling and thesaurus.

Application of word processing

1. Text editing and publishing document.
2. Formatting and editing document.
3. Mathematical calculation and macros handling.
4. Web publishing, mail merging, and image insertion.
5. Checking spelling and grammar of documents.
6. Coloring and numbering document pages.

#Spreadsheet

Spreadsheet is a computer application that helps for handling, manipulating, and analyzing data. Moreover, it helps for data presentation using charts and it also helps for decision making for the managers. It is used for preparing mark sheets, salary sheets, bills, etc. It is an electronic document having multiple rows and multiple columns where we can put data for further manipulation and analysis. Some common examples of spreadsheet software are: MS Excel, IBM Lotus 123, KSpread, Apple Numbers, Tabulus, etc.

Some features of Spreadsheet

1. It allows for keeping records in the worksheet and workbook.
2. It allows for sorting, filtering, and conditional formatting of given data.
3. It provides various mathematical, statistical, and logical formulas for data manipulations.
4. It provides various charts for presenting data.
5. It offers the features for data validation and data entry rules.
6. It helps for analyzing data using pivot table and chart.

Application of Spreadsheet

1. It helps for preparing annual budgets and reports.
2. It helps for maintaining databases and also helps for presenting data using charts.
3. It helps for preparing mark sheets, salary sheets, bills, ledgers, inventory, etc.
4. It helps for statistical analysis, functional analysis, scientific calculation, engineering data analysis, and research works.

Basic components of Spreadsheet

A workbook is a file created by MS Excel. A workbook contains multiple worksheets, its default name is book1, book2, book3, and so on.

Worksheet

A worksheet is an electronic sheet that contains a number of rows and columns. A row is defined by the integer number 1, 2, 3, … up to 10,48,576 and column defined by the Roman alphabets A, B, C, … up to XFD (16,384).

Cell and Cell Address

Cell is the intersection of row and column where we put data inside it. A cell is the unit element of the worksheet and it has a unique address defined by the respective column name followed by the row number called cell address.

Cell Reference (Cell Address)

A cell reference is also known as a cell address. A cell reference allows the user to access data in the cells. MS Excel supports three types of cell references:

1. Relative cell reference - If the reference of a cell automatically changes when we copy data from one cell to another then it is called relative cell reference.
2. Absolute cell reference - If the reference of a cell remains the same when we copy data from cell to another then it is called absolute cell reference.
3. Mixed cell reference - Mixed cell reference is used for both the reference relative and the absolute.

#Presentation

A presentation is a collection of data and information that is to be delivered to a specific audience. A PowerPoint presentation is a collection of electronic slides that can have text, pictures, graphics, tables, sound, and video. This collection can run automatically or can be controlled by a presenter.

Each page in a PowerPoint presentation is called a slide. Pictures and graphics are a big part of any PowerPoint presentation. Different forms of transition and movements can be added to the slide. Some common examples of presentation programs are: MS PowerPoint, Simple Slides, IBM Lotus, Power Dot, etc.

Features of Presentation Software

1. Different forms of information such as text, graphics, audio, video, and animation can be presented.
2. It provides custom animation, slide transition, and custom setup show.
3. Different forms of charts, tables, and objects can be embedded in the slides of the presentation.
4. It provides features like slide layout, theme, design template, ready-made template, etc.

Application of Presentation Software

1. It is a very useful tool for the presentation of information among specific audiences.
2. It is very popular in business meetings, both face to face and teleconferenced.
3. It is often used in business to present training material.