Overview
Quattro Pro 10 will introduce students to creating charts to graphically represent their data and the database features of Quattro Pro including sorting, locating, extracting, manipulating, and calculating data, and presenting it in meaningful reports.
Prerequisites
To ensure students' success with this course, we recommend that they first take the following Content courses or have equivalent knowledge:
- Windows 2000: Introduction or equivalent knowledge.
- Quattro Pro 10: Spreadsheets.
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:
- Use the QuickChart button to display data graphically.
- Use the Chart Expert, Chart Gallery, and Chart Advisor to create a chart and change its overall appearance.
- Enhance a chart's display by changing chart object properties, adding data details, and drawing objects on the chart.
- Create and enhance pie charts and combination charts.
- Create a map chart, and create and run an automated slide show presentation.
- Sort data in a notebook based on one or more columns.
- Work with spreadsheet data as a database to locate records, and groups of records, that meet specific criteria.
- Work with spreadsheet data as a database to extract and manipulate records, and groups of records, that meet specific criteria.
- Use database functions to perform calculations and summarize data by creating a Cross Tabs report.
Delivery Method
Quattro Pro 10 is a hands-on instruction book.
Course duration
1 Day(s)
Course outline
Lesson 1: Introduction to Charts
- Topic 1A: The QuickChart Button
- Topic 1B: Exploring Chart Types
- Topic 1C: Previewing a Chart and Using the Objects Sheet
Lesson 2: Using the Chart Expert
- Topic 2A: Using the Chart Expert\
- Topic 2B: The Chart Gallery and Chart Advisor
Lesson 3: Enhancing Charts
- Topic 3A: Working with Chart Properties and Elements
- Topic 3B: Working with Chart Details
- Topic 3C: Using Drawing Tools
Lesson 4: Extracting Records
- Topic 4A: One-key Sorts
- Topic 4B: Multiple-key Sorts
Lesson 5: Extracting Records
- Topic 5A: Database Terminology and Guidelines
- Topic 5B: Extracting Records
- Topic 5C: Working with the Output Cells
- Topic 5D: Creating OR and AND Conditions
Lesson 6: Introduction to Selected Database Topics
- Topic 6A: Using Database Functions
- Topic 6B: Summarizing Data in a Cross Tabs Report
Hardware/Software Requirements
You will need:
- Personal computer with Pentium 166 MHz processor or equivalent.
- 64 MB of RAM is the recommended minimum for Windows 2000 Professional; in addition, you should have 8 MB of RAM for each application running simultaneously. (Note: Memory requirements may differ for other operating systems.)
- 600 MB of free hard-disk space.
- Either a local CD-ROM drive or access to a networked CD-ROM drive.
- A two-button mouse, an IntelliMouse, or compatible pointing device.
- VGA or higher-resolution monitor; Super VGA recommended.
- An installed printer driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
- 28.8 kbps modem or faster.
- An Internet connection with access to the World Wide Web may be necessary to complete some tasks in the book. (Note: Internet access may require payment of a separate fee to a service provider; local charges may also apply.)
- A Custom Setup of WordPerfect Office 2002 Professional, see the Class Requirements section for details.
- A Web browser, such as Microsoft Internet Explorer.
- Windows 2000 Professional. This course was written using the Windows 2000 Professional operating system with Service Pack 2 installed. Using this course with other operating systems or configurations may affect how the activities work. (Note: The manufacturer states that WordPerfect 10 will work with Microsoft Windows 95b (OSR2), Microsoft Windows 98, Microsoft Windows 2000, Microsoft Windows NT 4.0 with SP6 or later, or Microsoft Windows ME. For best results on Windows XP, you should download and install the latest Service Packs from the Corel Web site.)
|
