1-2-3 Millennium Edition 9.5: Charting and Database Functions

Course specifications

Course number: LME-L2_076-214

Software version number: 9.5

Course length: 1 day

Course description

Overview: 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 98: Introduction and 1-2-3 Millennium Edition 9.5: Worksheets, or equivalent knowledge.

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

Benefits: Students will learn how to display worksheet data by creating charts; they will also manipulate worksheet ranges by using database operations.

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

What's next: 1-2-3 Millennium Edition 9.5: Charting and Database Functions is the second course in this series. 1-2-3 Millennium Edition 9.5: Advanced, the next course in this series, teaches students how to work with advanced features of 1-2-3, such as macros, linking files, and advanced formula construction.

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 selecting a range and creating a chart.

* Enhance chart displays by modifying parts of the chart.

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

* Enhance worksheet and chart data by using drawn objects.

* Manage data on a worksheet by sorting the rows.

* Find records in a database table by using a query table.

* Manage data in a database table by using a query table.

Course content

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 a 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

·         Wildcards

·         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

Appendix B: Integration with Approach