4.1 Introduction to Office Package

An office package usually consists of a word processor, a spreadsheet program, a presentation tool, and a database management system. Each is built for a different job, but they share a similar look and feel, so a user who learns one component can pick up another quickly. Microsoft Office (Word, Excel, PowerPoint, Access) and Google Workspace (Docs, Sheets, Slides) are the two most common examples.

4.1.1 Word Processor

A word processor does more than let you type text. It formats paragraphs (fonts, alignment, spacing), checks spelling and grammar, inserts tables and images, and can build a table of contents on its own. Microsoft Word is the most common example.

• Formatting text and paragraphs: changing font style, size, color, alignment, and line spacing
• Spelling and grammar check: automatically highlights and suggests corrections for spelling and grammatical errors
• Managing lists and tables: creating bulleted/numbered lists and organizing data in rows and columns
• Mail merge: automatically generates multiple personalized documents (such as letters) from a single template and a data source
• Exporting documents: saving a finished document in a portable format such as PDF for sharing

4.1.2 Spreadsheet Package

Each intersection of a row and column is called a cell, and a cell can hold text, numbers, or a formula that calculates a result on its own. Microsoft Excel is the most common example.

• Cell references: identifying a cell by its column letter and row number (such as B4), used inside formulas to refer to data stored elsewhere in the sheet
• Functions and formulas: built-in calculations such as SUM, AVERAGE, and IF, used to process data automatically
• Charts: visual representations of data, such as bar charts and pie charts, created directly from spreadsheet values
• Sorting and filtering: arranging data in a particular order or displaying only rows that meet certain conditions
• Pivot tables: a tool used to summarize, group, and analyze large amounts of data quickly

4.1.3 Presentation Tool

A presentation is built slide by slide, and each slide can be designed on its own before being arranged in sequence. Microsoft PowerPoint is the most common example.

• Slide design and formatting: choosing layouts, themes, and backgrounds for a consistent visual style
• Animation and custom animation: applying motion effects to individual elements, such as text or images, within a slide
• Transition: the visual effect used when moving from one slide to the next
• Tables, charts, and graphics: inserting organized data or visuals to support the content of a slide
• Multimedia: embedding audio or video clips directly within a presentation

4.1.4 Database Management System

Instead of scattering information across loose files, a DBMS keeps related data organized so it can be searched, sorted, and updated efficiently, with multiple users able to access it without conflicts. Microsoft Access is a common example.

4.2 Introduction to Domain Specific Tools

An office package works across almost any profession. A domain-specific tool doesn’t; it’s built around the workflow of one particular sector, and it rarely works well outside that purpose.

• School Management System: manages student records, attendance, admissions, examinations, and fee collection for educational institutions
• Inventory Management System: tracks stock levels, purchases, and sales of goods, helping a business know what items are available and when to reorder
• Payroll System: manages employee salary calculation, deductions, and payment records within an organization
• Financial Accounting: handles the recording, tracking, and reporting of an organization’s financial transactions, such as income, expenses, and taxes
• Hotel Management System: manages room booking, guest check-in/check-out, billing, and housekeeping for hotels
• Weather Forecasting System: collects and processes meteorological data to predict and display future weather conditions

Sample Board Exam Questions

Based on the official NEB Computer Science Specification Grid 2077, Unit 4 (Application Package) is a relatively short unit, carrying 3 marks out of the theory paper, drawn from the Remembering and Understanding levels. Given its low working-hour weight, this unit is typically covered fully through Multiple Choice Questions. A sample question set in that pattern is given below.

Important Questions

1. What is an office package? List its main components.
2. Define word processor. Mention any three features of a word processor.
3. What is a spreadsheet package? Explain any three uses of a spreadsheet with examples.
4. What is a presentation tool? Explain the terms animation and transition.
5. Define DBMS. Why is a DBMS preferred over storing data in ordinary files?
6. What are domain-specific tools? List any four examples with their uses.
7. Differentiate between an office package and a domain-specific tool with suitable examples.
8. Explain the use of mail merge in a word processor.
9. What is a pivot table? Why is it useful while working with large data sets in a spreadsheet?