OpenOffice.org 3.1 Calc
Course Specifications
Course number: 084295
Course length: 1.0 day(s)
Course Description
Course Objective: You will use the features and tools present in OpenOffice.org 3.1
Calc to manage data. You will also apply advanced analysis techniques to more
complex data sets. In addition, you will apply visual elements and advanced
formulas to a spreadsheet.
Target Student: This course is designed for general office workers as well as data
analysts.
Prerequisites: Students should be familiar with using personal computers
and should have used a mouse and keyboard.
Hardware Requirements
This course requires one desktop computer for each student
with the following minimum hardware requirements.
- Intel® Pentium® IV, 1 GHz CPU or higher
- Minimum 512 MB of RAM or higher
- 1024 x 768 resolution monitor
- 40 GB hard disk or larger
- Printer
- Display system to project the instructor’s computer
screen
Software Requirements
Each computer requires the following software:
- Microsoft® Windows® XP Professional
- OpenOffice.org 3.1 Calc
- Adobe® Reader® 8 or above
Course Objectives
Upon successful completion of this course, students will be able to:
- explore the various elements of the OpenOffice Calc interface.
- create a spreadsheet by entering data and saving the spreadsheet.
- perform calculations using the basic and advanced formulas
and functions available in OpenOffice Calc.
- modify and locate data in a spreadsheet using various
methods and tools available in OpenOffice Calc.
- format a spreadsheet to improve its visual appeal and make
it easier for users to locate required information.
- audit data in a spreadsheet by using tools to trace cells
and rectify incorrect formula.
- analyze data using the Scenarios, Goal Seek, Solver, and
DataPilot tables.
- present data using charts so that numerical data can be
depicted graphically for easy comprehension.
- finalize a spreadsheet by protecting files, freezing cells,
and exporting to different formats.
Course Content
- Lesson 1: Exploring
the OpenOffice Calc Interface
- Topic 1A: Explore the Interface
- Topic 1B: Customize the Interface
- Topic 1C: Obtain Help
- Lesson 2: Creating a Spreadsheet
- Topic 2A: Enter Data in a Spreadsheet
- Topic 2B: Save a Spreadsheet
- Lesson 3: Performing Calculations
- Topic 3A: Calculate Using Basic Formulas and Functions
- Topic 3B: Calculate Using Advanced Functions
- Lesson 4: Modifying a Spreadsheet
- Topic 4A: Manipulate Data
- Topic 4B: Sort and Filter Data
- Topic 4C: Search for Data in a Spreadsheet
- Topic 4D: Spell Check a Spreadsheet
- Lesson 5: Formatting a Spreadsheet
- Topic 5A: Format Cells
- Topic 5B: Apply Conditional Formatting
- Lesson 6: Auditing Data in a Spreadsheet
- Topic 6A: Trace Cells
- Topic 6B: Troubleshoot Errors in Formulas
- Topic 6C: Add Data Validation Criteria
- Lesson 7: Analyzing Data
- Topic 7A: Create Scenarios
- Topic 7B: Analyze Data Using Goal Seek
- Topic 7C: Analyze Data Using Solver
- Topic 7D: Analyze Data Using DataPilot
- Lesson 8: Presenting Data Using Charts
- Topic 8A: Create a Chart
- Topic 8B: Modify a Chart
- Lesson 9: Finalizing a Spreadsheet
- Topic 9A: Prepare a Spreadsheet for Distribution
- Topic 9B: Export a Spreadsheet