Lotus 1-2-3 97: Charting and Database Functions

Students will learn the basics of creating charts from their worksheet data and enhancing those charts. They will also be introduced to database concepts and learn how to work with a range of worksheet data as a database.

Prerequisites

Windows 95: Introduction, 1-2-3 97 Worksheets, or equivalent knowledge.

Target Student

Students enrolling in this course should understand the basics of working in a 1-2-3 for Windows worksheet.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Display data graphically by creating a chart.

Enhance chart displays and manage the data displayed on the chart by using the InfoBox.

Display data as parts of a whole by creating and enhancing pie charts.

Update charts by adding data series, assigning styles, and customizing the chart axes.

Sort data by using the sort features of 1-2-3.

Work with a range of data as a database table to find records by using a query table.

Extract and manage data in a database table by using a query table.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

What's next

1-2-3 97: Charting and database functions is the second course in this series. 1-2-3 97: Advanced, the next course in this series, teaches student how to work with advanced features of 1-2-3 such as macros, linking files, and advanced formula construction.

Course duration

1 Day(s) Course outline

Lesson 1: Introduction to charts

Creating a basic chart
Working with multiple charts

Lesson 2: Formatting and enhancing charts

Enhancing and formatting titles and legends
Modifying axis information
Using drawn objects to enhance charts and worksheets

Lesson 3: Using pie charts

Creating a pie chart
Enhancing a pie chart

Lesson 4: Advanced charting topics

Adding and deleting data series
Additional enhancements
Creating charts from 3-D ranges

Lesson 5: Sorting data

One-column sorts
Range names
Multiple-level sorts

Lesson 6: Introduction to data management

Database terminology and guidelines
Defining the database table and the find criteria
Text comparison criteria
Numeric comparison criteria

Lesson 7: Using query tables

Working with query tables
Using multiple criteria
Managing records in a database table
Using database functions

Appendix A: Using maps to chart data

Creating a map to chart data

Appendix B: Integration with Approach

Using Approach features in 1-2-3

Hardware/Software Requirements

You will need 8 megabytes (MB) of Random Access Memory (RAM) if you are using 1-2-3. See your reference manual for hardware considerations that apply to your specific hardware setup.

In addition, you will need printers if you want to print the worksheets and charts> created in the course.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.