COMPUTER APPLICATION

(a) Word Processing (i) Definition and Examples of Word Processing and Word Processor Word Processing: The act of creating, editing, formatting, saving, and printing text documents using computer software. Word Processor: A software application used for word processing tasks. Examples: MS Word: A popular word processor with advanced formatting tools. WordStar: An early word processor known for text editing. WordPerfect: A feature-rich word processor, especially popular in legal industries. (ii) Features of Word Processing Programs Text editing: Insert, delete, and modify text. Formatting: Change fonts, sizes, colors, alignment, and styles. Spell check and grammar tools: Detect and correct errors. Tables and graphics: Add visuals and organize data in tables. Printing: Produce hard copies of documents. (iii) Application Areas of Word Processing Programs Office: Drafting letters, memos, and reports. Publishing: Designing newsletters, brochures, and books. Journalism: Writing and editing articles. Education: Preparing lesson plans, research papers, and assignments. (iv) Features of MS Word User-friendly interface with a ribbon toolbar. Rich formatting tools. Insert multimedia (images, tables, hyperlinks). Mail merge for personalized letters. Auto-save and cloud integration. (v) Steps to Activate and Exit MS Word Activate: Click on the MS Word icon or search it in the Start menu. Exit: Click "File" → "Exit" or use the close button (X) in the top-right corner. (vi) Basic Operations in MS Word Create: File → New → Blank Document. Edit: Use tools like undo, redo, cut, copy, and paste. Save: File → Save or Ctrl + S. Retrieve: File → Open → Select the saved document. Print: File → Print → Select printer and settings. Close: File → Close or Ctrl + W. (vii) Further Operations in MS Word Move/Copy/Cut: Cut: Ctrl + X, Copy: Ctrl + C, Paste: Ctrl + V. Font Styles and Sizes: Use the Home tab to modify fonts. Formatting and Justifying: Align text (left, center, right, justified). Search and Explore: Ctrl + F to find text; Research tool for exploring topics. Spell Checking: Tools → Spelling and Grammar. File Merging: Combine multiple files into one. (b) Spreadsheet (i) Definition and Examples of Spreadsheet Program Spreadsheet: Software for organizing, analyzing, and storing data in tabular form. Examples: VisiCalc: The first spreadsheet program. MS Excel: A widely used spreadsheet with advanced tools. SuperCalc: A powerful spreadsheet program. (ii) Features of Spreadsheet Programs Rows and columns organization. Formulas for automatic calculations. Charts and graphs for data visualization. Sorting and filtering data. (iii) Application Areas of Spreadsheet Programs Accounting: Budgeting and financial analysis. Statistical Calculations: Analyzing data trends. Student Results: Maintaining grades and performance records. (iv) Features of MS Excel Environment Status Bar: Displays information like sum, count, and averages. Menu Bar: Access to commands. Formula Bar: Enter and edit formulas. (v) Definitions of Basic Terms in MS Excel Worksheet: A single sheet in a workbook. Workbook: A file containing multiple worksheets. Cells: Intersection of rows and columns. Cell Ranges: A selection of multiple cells. (vi) Data Types in Excel Numbers: Numeric values. Labels: Text entries. Formulas: Mathematical expressions (e.g., =A1+B1). (vii) Basic Operations in Excel Data Entry: Input numbers, text, or formulas. Saving: File → Save or Ctrl + S. Retrieve/Copy/Move: File → Open/ Ctrl + C/ Ctrl + X. (viii) Arithmetic Calculations and Built-In Functions Formulas: =A1+B1 (sum of two cells). Functions: SUM(), AVERAGE(). Charts: Pie Chart: Visualizing proportions. Histogram: Frequency distributions. (c) Database (i) Definition and Examples of Database Packages Database: A collection of organized data for efficient access and management. Examples: DBase IV FoxBASE MS Access Oracle (ii) Basic Terms in Database File: A collection of records. Record: A single unit of data (row). Field: A column representing a specific type of data. Key: A unique identifier for records. (iii) Types of Database Organization Hierarchical: Data in a tree structure. Network: Interconnected records. Relational: Tables with relationships. (iv) Basic Operations on Databases Search: Find specific records. Modify: Update data fields. Sort: Arrange data in a sequence. (d) Graphics (i) Definition and Examples of Graphics Packages Graphics: Software for creating, editing, and designing visual content. Examples: Paint CorelDraw Photoshop (ii) Features and Design Using CorelDraw Business Card, Logos, and National Flags can be created with tools for shapes, colors, and text. (e) Presentation Package (i) Definition of Presentation Package Software used to create slideshows for conveying ideas visually. Examples: MS PowerPoint (ii) PowerPoint Operations Create: Start a new presentation. Insert: Add text, images, and charts. Animate: Add transitions to slides. Run Slideshow: Present slides on screen.