Class 11 Computer Science Unit 4: Application Package CDC Code: Com. 4271 5 Credit Hours | Board Weight: ~4 Marks

Unit 4: Application Package - Word, Excel & PowerPoint

Core features of word processing (Mail Merge, Macro, formatting), spreadsheet packages (formulas, built-in functions, charts, pivot tables), and presentation tools.

1. Word Processing Concepts

A Word Processor is an application software package used for the creation, editing, formatting, and printing of text-based documents (e.g. Microsoft Word, Google Docs, LibreOffice Writer).

Advanced Features:

  • Mail Merge: A powerful feature that allows users to produce personalized letters, envelopes, or mailing labels for hundreds of recipients by merging a main document template with a structured data source (e.g. Excel spreadsheet or Access database).
  • Macro: A recorded series of commands and keystrokes that can be replayed automatically with a single shortcut key to automate repetitive formatting tasks.
  • Header and Footer: Repeating text/page numbers appearing at the top (header) and bottom (footer) margins of every page.
  • Table of Contents (TOC): Automated index generated based on heading styles (Heading 1, Heading 2).
2. Spreadsheet Package (MS Excel)

A Spreadsheet is an interactive grid of horizontal rows and vertical columns used for organizing, analyzing, calculating, and graphically representing numerical data.

  • Cell & Cell Address: The intersection of a row and column. Identified by column letter and row number (e.g. B4).
  • Formula vs Function:
    • Formula: A user-defined mathematical expression starting with an equal sign (e.g. =A1 + B1 * 2).
    • Function: A pre-defined, built-in formula that takes arguments and returns a calculated result (e.g. =SUM(A1:A10), =AVERAGE(B1:B20), =IF(C2>=40, "Pass", "Fail")).
  • Cell Referencing Modes:
    • Relative Reference: Automatically changes when copied to another cell (e.g. A1).
    • Absolute Reference: Remains fixed when copied; indicated by dollar signs (e.g. $A$1).
    • Mixed Reference: One part fixed and one part relative (e.g. $A1 or A$1).
3. Presentation Package (PowerPoint)

Software designed to display information in the form of a slide show (e.g. Microsoft PowerPoint, Google Slides).

  • Slide Transition: The visual and sound effect that occurs when advancing from one slide to the next during a presentation.
  • Animation: Dynamic movement and effects applied to individual text elements, images, or shapes on a single slide.
  • Slide Master: The master template that governs the universal styling, font, color palette, logo placement, and background for all slides in the deck.