EITC BI OOC Spreadsheets software fundamentals (OpenOffice) [v1r1] Exam

1. Introduction to Spreadsheets

• Overview of spreadsheet applications
• Introduction to OpenOffice Calc
• Key features and functions of OpenOffice Calc
• Understanding the spreadsheet interface (menus, toolbars, and navigation)
• Understanding cell structure, rows, columns, and sheets
• Basic terminology: cells, ranges, formulas, functions, and data types

2. Getting Started with OpenOffice Calc

• Opening and creating new spreadsheets
• Navigating through a spreadsheet (scrolling, zooming)
• Using the status bar and other on-screen information
• Working with different spreadsheet file formats (ODS, XLSX, CSV)
• Saving, closing, and opening spreadsheets
• Understanding workbook and worksheet concepts

3. Working with Cells and Data

• Selecting, inserting, and deleting rows, columns, and cells
• Copying, moving, and pasting data
• Formatting cells (number formatting, text formatting, alignment, and style)
• Understanding different data types (text, numbers, dates, and times)
• Data validation and input restrictions
• Using auto-fill and auto-correct features

4. Using Formulas and Functions

• Introduction to formulas and how to create them
• Basic arithmetic operations in formulas (addition, subtraction, multiplication, division)
• Understanding relative, absolute, and mixed cell references
• Using built-in functions (SUM, AVERAGE, MIN, MAX, COUNT, etc.)
• Using advanced functions (IF, VLOOKUP, HLOOKUP, INDEX, MATCH, etc.)
• Error handling in formulas (e.g., #DIV/0, #N/A)

5. Data Organization and Management

• Sorting data (ascending, descending, custom sort)
• Filtering data using AutoFilter
• Using advanced filtering and criteria ranges
• Grouping and outlining data
• Conditional formatting (highlighting data based on conditions)
• Protecting data and setting cell permissions

6. Working with Charts and Graphs

• Introduction to charts and their types (bar, line, pie, scatter, etc.)
• Creating and editing charts in OpenOffice Calc
• Customizing chart elements (titles, labels, axes, colors)
• Using chart styles and templates
• Understanding chart data ranges and series
• Adding trendlines and data labels to charts

7. Data Analysis and Advanced Functions

• Using statistical functions (STDEV, VARIANCE, MEDIAN, etc.)
• Working with financial functions (PMT, NPV, IRR, etc.)
• Date and time functions (TODAY, NOW, DATE, WEEKDAY, etc.)
• Text functions (CONCATENATE, LEFT, RIGHT, MID, TRIM, etc.)
• Lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH)
• Array formulas and their uses

8. Working with Multiple Sheets and Workbooks

• Managing multiple sheets within a workbook
• Referencing data from different sheets (internal and external references)
• Linking data between workbooks
• Grouping sheets for simultaneous editing
• Renaming, moving, and copying sheets
• Hiding and protecting sheets

9. Printing and Exporting Data

• Setting up print areas and print ranges
• Adjusting page layout (margins, page orientation, paper size)
• Previewing and printing spreadsheets
• Exporting spreadsheets to other formats (PDF, HTML, CSV)
• Exporting charts and images for reports or presentations
• Using headers and footers in printed documents

10. Automation and Macros

• Introduction to macros in OpenOffice Calc
• Recording simple macros
• Assigning macros to buttons and events
• Editing and managing macros
• Using OpenOffice Basic for writing custom macros
• Understanding macro security settings

11. Collaboration and Sharing

• Sharing spreadsheets with others
• Using comments and notes to collaborate within the spreadsheet
• Tracking changes and revisions in shared workbooks
• Merging changes from multiple users
• Using OpenOffice Calc with cloud storage services
• Protecting sensitive data during collaboration (passwords, encryption)

12. Advanced Data Handling and Analysis Tools

• Using pivot tables for data summarization and analysis
• Data consolidation from multiple sheets
• Using goal seek and solver for advanced analysis
• Creating and managing data ranges for complex calculations
• Introduction to database functions (DSUM, DCOUNT, etc.)
• Using the analysis toolpak (add-ins) for advanced statistical analysis

13. Troubleshooting and Error Handling

• Understanding common errors and their meanings
• Using the formula auditing tools (trace precedents, trace dependents, error checking)
• Managing circular references in formulas
• Using the "Find and Replace" feature effectively
• Resolving formula and data inconsistencies
• Tips for debugging complex spreadsheets

14. Final Review and Exam Preparation

• Reviewing key concepts from each section
• Hands-on practice with sample exercises and problems
• Time management strategies for taking the exam
• Common pitfalls to avoid during the exam
• Exam strategies for multiple-choice and practical problem-solving questions