Application Package

Most people who use a computer never write a line of code. They write letters, add up columns of figures, make slides and look things up in a database — and they do it with ready-made application packages. This short unit surveys the four members of the standard office package and then looks at the domain-specific software written for one particular line of work: a school, a shop, a payroll office, a hotel or a weather service.

4.1 Introduction to office packages

The best known office suites, as of 2025, are Microsoft 365 / MS Office (Word, Excel, PowerPoint, Access, Outlook), the free and open-source LibreOffice (Writer, Calc, Impress, Base), the web-based Google Workspace (Docs, Sheets, Slides), WPS Office, and Apple's iWork (Pages, Numbers, Keynote).

(a) Word processor

Examples: MS Word, LibreOffice Writer, Google Docs, WPS Writer, Apple Pages.

Main features

• Typing with automatic word wrap, insert and overtype modes.
• Editing: cut, copy, paste, undo/redo, and find and replace.
• Formatting of characters (font, size, bold, italic, underline, colour), paragraphs (alignment, indent, line spacing, bullets and numbering) and pages (margins, orientation, size, columns).
• Styles and templates so that every heading in a long report looks the same.
• Tables, pictures, shapes, charts, equations and symbols.
• Header and footer with automatic page numbers.
• Spelling and grammar check, thesaurus, word count.
• Mail merge — one letter combined with a list of names to produce many personalised letters.
• Track changes and comments for reviewing, and export to PDF.

(b) Spreadsheet package

Examples: MS Excel, LibreOffice Calc, Google Sheets, WPS Spreadsheets, Apple Numbers.

A file is a workbook; each page of it is a worksheet. Columns are named with letters (A, B, C …), rows with numbers (1, 2, 3 …), and the box where a column and a row meet is a cell whose address is the column letter followed by the row number, such as C5. A rectangular block of cells is a range, written B2:E6.

Main features

• Formulas always begin with = and may use the operators + - * / ^ and the comparison operators.
• Built-in functions such as SUM, AVERAGE, MAX, MIN, COUNT, COUNTIF, IF, ROUND, RANK, TODAY, VLOOKUP.
• Automatic recalculation: change one number and every dependent cell updates at once — this is the whole point of a spreadsheet.
• Cell references: relative (B2, which changes when the formula is copied), absolute ($B$2, which never changes) and mixed (B$2, $B2).
• Charts — column, bar, line, pie, scatter — drawn from a range of cells and updated automatically.
• Sorting, filtering, conditional formatting, data validation, pivot tables, "what-if" analysis and Goal Seek.

(c) Presentation tool

Examples: MS PowerPoint, LibreOffice Impress, Google Slides, Prezi, Canva.

Main features: slide layouts and placeholders; design themes, templates and the slide master that fixes the look of every slide; transitions between slides and animations within a slide; speaker notes and handouts; views — Normal, Slide Sorter, Reading and Slide Show (F5); rehearse timings; insert tables, charts, SmartArt, audio, video and hyperlinks; and export to PDF or video.

(d) Database management system (DBMS)

Examples: MS Access, LibreOffice Base, MySQL, PostgreSQL, Oracle, Microsoft SQL Server, SQLite, MongoDB.

In a relational DBMS data is held in tables:

• A field (column or attribute) is one item of information, for example Roll No or Address.
• A record (row or tuple) is the complete set of fields about one entity, for example everything about one student.
• A primary key is a field whose value is different in every record and is never empty; it identifies a record uniquely.
• A foreign key is a field in one table that holds the primary key of another table, and is what links the two tables together.

The four objects of a desktop DBMS such as MS Access are tables (store the data), queries (ask questions of it), forms (a friendly screen for data entry) and reports (formatted printed output). Common field data types are Text/Short Text, Number, Date/Time, Currency, Yes/No, AutoNumber and Memo/Long Text.

	Word processor	Spreadsheet	Presentation	DBMS
Works with	text documents	numbers in a grid	slides	tables of records
Basic unit	character, paragraph, page	cell, worksheet	slide	field, record
Key strength	formatting and printing text	automatic calculation and charts	visual support for a talk	storing and querying large data
Typical file	.docx, .odt	.xlsx, .ods	.pptx, .odp	.accdb, .sql
Example	MS Word, Writer	MS Excel, Calc	PowerPoint, Impress	MS Access, MySQL

4.2 Introduction to domain-specific tools

A general package can be bent to almost any purpose, but a domain-specific system is built around the workflow of one industry. Compare the two:

	General purpose package	Domain-specific tool
Users	everybody	one line of business
Cost	low, mass produced	higher; may be custom built
Features	broad but shallow	exactly what that field needs
Training	general computer skill	job-specific training
Example	MS Excel used to keep stock	a full inventory management system

Almost every such system has the same three-part shape: input of transactions, processing against stored master data, and output of reports.

(a) School management system

Handles admission and student records, class routines, daily attendance, examination marks and result processing, fee collection and dues, the library, the hostel and transport, payroll for the staff, and SMS or app notices to parents. In Nepal, community schools report their data through the government's IEMIS (Integrated Educational Management Information System) platform.

(b) Inventory management system

Records every item in a store with a code, name, unit, rate and reorder level; posts each purchase and each sale; keeps the stock balance up to date; warns when an item falls below its reorder level; values the stock; and prints purchase orders and stock reports. Barcode or QR scanning at the counter is the usual input method.

(c) Payroll system

Keeps a master file of employees with grade, basic salary and allowances; accepts monthly attendance, overtime, leave and loan data; computes gross pay, then deductions (income tax, provident fund, CIT, insurance, advances) and finally net pay; prints pay slips and the bank transfer file; and produces statutory tax returns.

(d) Financial accounting system

Maintains the chart of accounts; records journal vouchers of every receipt, payment, purchase and sale; posts them to the ledger automatically; and prints the trial balance, trading and profit-and-loss account, balance sheet, VAT returns, and party-wise receivables and payables. Widely used examples are Tally, Busy, Sage, QuickBooks and Odoo.

(e) Hotel management system

Handles room inventory and tariffs, online and telephone reservations, check-in and check-out, housekeeping status, restaurant and laundry billing posted to the room, the final guest folio, and occupancy and revenue reports. It usually connects to online travel agents and to a payment gateway.

(f) Weather forecasting system

Collects readings of temperature, pressure, humidity, rainfall, wind speed and direction from ground stations, balloons, radar and satellites; feeds them into numerical weather prediction models, which solve the equations of the atmosphere on a three-dimensional grid; and issues forecasts, flood and landslide warnings and aviation bulletins. Because the models are enormous, this work is done on supercomputers. In Nepal the Department of Hydrology and Meteorology publishes the national forecast and monsoon and flood warnings.

System	Typical inputs	Typical outputs
School management	admission forms, attendance, marks, fees	mark ledger, grade sheet, fee receipt, attendance report
Inventory	purchase and sales vouchers, item master	stock balance, reorder alert, valuation report
Payroll	attendance, overtime, leave, loans	pay slip, bank file, tax statement
Financial accounting	vouchers of all transactions	ledger, trial balance, profit and loss, balance sheet
Hotel management	reservations, check-in, restaurant bills	guest folio, occupancy report, revenue report
Weather forecasting	station, radar and satellite readings	forecast maps, warnings, aviation bulletins

Chapter summary

• An application package is ready-made software sold to many users; an office package bundles a word processor, spreadsheet, presentation tool and DBMS that share a common interface.
• A word processor creates and formats text: editing, styles, tables, header and footer, spell check, mail merge. Examples: MS Word, LibreOffice Writer.
• A spreadsheet holds data in cells addressed by column letter and row number, calculates with formulas beginning with = and functions such as SUM, AVERAGE, MAX, IF, and draws charts. References may be relative (B2), absolute ($B$2) or mixed.
• Presentation software builds a deck of slides with layouts, themes, transitions and animations, shown with F5.
• A DBMS stores data in tables of records made of fields, identified by a primary key and linked by a foreign key; its objects are tables, queries, forms and reports.
• Domain-specific tools are built for one field: school management, inventory, payroll, financial accounting, hotel management and weather forecasting. Describe each by its inputs, processing and outputs.

Practice questions

Group A — Multiple choice (1 mark each)

1. Which of the following is not part of a standard office package? [1]aword processorbspreadsheetccompilerdDBMS
2. In a spreadsheet, the intersection of a row and a column is called a [1]arangebcellcfielddworksheet
3. Every spreadsheet formula must begin with [1]a+b#c=d@
4. =SUM(B2:B10) adds [1]aB2 and B10 onlyball cells from B2 to B10ccolumn B entirelydrows 2 to 10 entirely
5. A field that uniquely identifies each record in a table is the [1]aforeign keybindexcprimary keydattribute
6. A row of a database table is also called a [1]afieldbrecordcquerydform
7. Mail merge is a feature of [1]aa spreadsheetba word processorca DBMSdpresentation software
8. Which of these is a domain-specific software? [1]aMS ExcelbLibreOffice Impressca hotel management systemdGoogle Chrome
9. The view used to reorder the slides of a presentation is [1]aNormal viewbSlide Sorter viewcReading viewdNotes page

Answers to Group A

1. (c) — a compiler is system software.

2. (b) — a cell.

3. (c) — the equals sign.

4. (b) — the colon means "through", so the whole range is added.

5. (c) — the primary key.

6. (b) — a record (tuple).

7. (b) — a word processor.

8. (c) — it serves one line of business only.

9. (b) — Slide Sorter view.

Group B — Short answer (5 marks each)

1. What is an application package? Name the four components of an office package and write two features of each. [5]
2. Define cell, range, worksheet and workbook. Write the formulas to find the total, the average, the largest and the smallest of the marks stored in cells C3 to C20. [5]
3. Differentiate between a relative, an absolute and a mixed cell reference with one example of each, and explain why absolute references are needed. [5]
4. Define database, DBMS, field, record and primary key. Name two DBMS packages. [5]
5. What is domain-specific software? Differentiate it from a general purpose package under any four headings. [5]
6. Explain any two of the following with their inputs and outputs: inventory management system, payroll system, hotel management system. [5]

Answers to Group B

2. A cell is the box where one column meets one row, addressed as C3. A range is a rectangular block of cells, written C3:C20. A worksheet is one page of the grid; a workbook is the whole file containing several worksheets. Total =SUM(C3:C20); average =AVERAGE(C3:C20); largest =MAX(C3:C20); smallest =MIN(C3:C20).

3. Relative (B2) changes when the formula is copied — copying =B2*2 from C2 to C3 gives =B3*2. Absolute ($B$2) never changes, because the dollar signs lock both the column and the row. Mixed (B$2 or $B2) locks only one of the two. Absolute references are needed when a formula must always refer to one fixed cell, such as a rate of tax or a full-marks value, while being copied down a column.

4. A database is an organised collection of related data; a DBMS is the software that creates and manages it; a field is one column or attribute; a record is one complete row about one entity; a primary key is a field whose value is unique and never empty, so it identifies a record. Examples of a DBMS: MS Access and MySQL (also Oracle, PostgreSQL).

Group C — Long answer (8 marks each)

1. (a) What is a spreadsheet package? Explain any four of its features. [4](b) A worksheet stores the names of 20 students in column A and their marks in five subjects in columns B to F, in rows 2 to 21. Write the formulas for the total, the average, the percentage out of 500, the result (Pass if the average is 40 or above) and the highest total in the class, and explain how the formulas are copied to the remaining rows. [4]
2. (a) What is a DBMS? Explain the terms table, field, record, primary key and foreign key with a suitable example. [5](b) Explain the four objects of MS Access and state the purpose of each. [3]
3. (a) What is domain-specific software? [2](b) Explain the school management system, the payroll system and the weather forecasting system, mentioning the inputs, the processing and the outputs of each. [6]

Answers to Group C

1. (b) With the first student in row 2: total G2 =SUM(B2:F2); average H2 =AVERAGE(B2:F2); percentage I2 =G2/500*100; result J2 =IF(H2>=40,"Pass","Fail"); highest total K2 =MAX($G$2:$G$21). Select G2:K2, then drag the small square fill handle at the bottom-right corner down to row 21 (or copy and paste). The relative references B2:F2 become B3:F3, B4:F4 and so on, while the absolute reference $G$2:$G$21 stays pointing at the whole column of totals.

2. (b) Tables store the data in rows and columns and are the only object that actually holds data. Queries ask questions of one or more tables — select, filter, sort, calculate — and can also update or delete records. Forms provide a friendly on-screen layout for entering and editing one record at a time. Reports produce formatted, printable output such as a mark ledger or a fee statement, with grouping and totals.

3. (b) School management: inputs — admission forms, daily attendance, exam marks, fee receipts; processing — validation, totalling, grading, dues calculation; outputs — grade sheets, mark ledgers, attendance and fee reports, SMS to parents. Payroll: inputs — employee master data, attendance, overtime, leave, loans; processing — gross pay, then tax, provident fund and other deductions, then net pay; outputs — pay slips, bank transfer file, tax returns. Weather forecasting: inputs — temperature, pressure, humidity, rainfall and wind readings from ground stations, radar and satellites; processing — numerical weather prediction models run on supercomputers; outputs — forecast maps, rainfall and flood warnings, aviation bulletins.