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