iti 18 April 2025

πŸ–₯️ Working with OpenOffice for Word Processing and Spreadsheet Application

OpenOffice is a free and open-source office suite that includes tools similar to Microsoft Office. Two of its most widely used applications are:

  • OpenOffice Writer – for word processing
  • OpenOffice Calc – for spreadsheet tasks

πŸ“„ OpenOffice Writer – Word Processing

OpenOffice Writer is used to create, edit, and format documents like letters, reports, resumes, and project files.

Key Features:

  • Create new text documents
  • Format text: font style, size, color, alignment
  • Insert images, tables, symbols, and charts
  • Use headers, footers, page numbers
  • Spelling and grammar check
  • Use templates and mail merge

Basic Tasks:

  1. πŸ†• Creating a New Document: 
    Go to File β†’ New β†’ Text Document
  2. πŸ’Ύ Saving a Document: 
    File β†’ Save As and choose the file name and location
  3. πŸ–¨οΈ Printing: 
    File β†’ Print or press Ctrl + P

πŸ“Š OpenOffice Calc – Spreadsheet Application

OpenOffice Calc is used for data entry, calculations, creating graphs, and organizing data in rows and columns.

Key Features:

  • Enter data in rows and columns
  • Apply formulas and functions
  • Use charts and graphs
  • Sort and filter data
  • Use conditional formatting
  • Link multiple sheets

Basic Tasks:

  1. πŸ†• Creating a New Spreadsheet: 
    File β†’ New β†’ Spreadsheet
  2. βž• Entering Data: 
    Click on a cell and type the value (text, number, or formula)
  3. πŸ“ˆ Using Functions: 
    Examples: =SUM(A1:A5), =AVERAGE(B1:B10)
  4. 🎨 Formatting Cells: 
    Change font, borders, background color
  5. πŸ–¨οΈ Printing: 
    Set page layout, margins, and print area

πŸ“Œ Tips for ITI Students

  • Practice formatting documents in Writer using headings and lists.
  • Create basic financial tables and apply formulas in Calc.
  • Use OpenOffice to complete assignments and prepare project reports.
  • Save work regularly in multiple formats (e.g., .odt, .docx, .pdf).

βœ… Learning Outcome

By working with OpenOffice Writer and Calc, ITI students gain essential computer skills required for office administration, data handling, and documentation tasks. These skills are useful in both job and entrepreneurship roles.