User Manual

ManualsBrandsCasio ManualsCalculators, organizersClassPad 300 Spreadsheet Application

631

632

633

634

635

636

637

638

639

640

Table Of Contents

Getting Ready
- 1. Unpacking
- 2. Attaching and Removing the Front Cover
- 3. Using the Stylus
- 4. Replacing Batteries and Setting Up the ClassPad
- 5. User Registration
- Handling Precautions
Contents
About This User’s Guide
- ClassPad Keypad and Icon Panel
- On-screen Keys, Menus, and Other Controllers
- Page Contents
Chapter 1 Getting Acquainted
- 1-1 General Guide
- 1-2 Turning Power On and Off
- 1-3 Using the Icon Panel
- 1-4 Built-in Applications
- 1-5 Built-in Application Basic Operations
- 1-6 Input
- 1-7 Variables and Folders
- 1-8 Using the Variable Manager
Chapter 2 Using the Main Application
- 2-1 Main Application Overview
- 2-2 Basic Calculations
- 2-3 Using the Calculation History
- 2-4 Function Calculations
- 2-5 List Calculations
- 2-6 Matrix and Vector Calculations
- 2-7 Using the Action Menu
- 2-8 Using the Interactive Menu
- 2-9 Using the Main Application in Combination with Other Applications
- 2-10 Using Verify
Chapter 3 Using the Graph & Table Application
- 3-1 Graph & Table Application Overview
- 3-2 Using the Graph Window
- 3-3 Storing Functions
- 3-4 Using Table & Graph
- 3-5 Modifying a Graph
- 3-6 Using the Sketch Menu
- 3-7 Using Trace
- 3-8 Analyzing a Function Used to Draw a Graph
Chapter 4 Using the Conics Application
- 4-1 Conics Application Overview
- 4-2 Inputting Equations
- 4-3 Drawing a Conics Graph
- 4-4 Using Trace to Read Graph Coordinates
- 4-5 Using G-Solve to Analyze a Conics Graph
Chapter 5 Using the 3D Graph Application
- 5-1 3D Graph Application Overview
- 5-2 Inputting an Expression
- 5-3 Drawing a 3D Graph
- 5-4 Manipulating a Graph on the 3D Graph Window
- 5-5 Other 3D Graph Application Functions
Chapter 6 Using the Sequence Application
- 6-1 Sequence Application Overview
- 6-2 Inputting an Expression in the Sequence Application
- 6-3 Recursive and Explicit Form of a Sequence
- 6-4 Using LinkTrace
Chapter 7 Using the Statistics Application
- 7-1 Statistics Application Overview
- 7-2 Using List Editor
- 7-3 Before Trying to Draw a Statistical Graph
- 7-4 Graphing Single-Variable Statistical Data
- 7-5 Graphing Paired-Variable Statistical Data
- 7-6 Using the Statistical Graph Window Toolbar
- 7-7 Performing Statistical Calculations
- 7-8 Test, Confidence Interval, and Distribution Calculations
- 7-9 Tests
- 7-10 Confidence Intervals
- 7-11 Distribution
- 7-12 Statistical System Variables
Chapter 8 Using the Geometry Application
- 8-1 Geometry Application Overview
- 8-2 Drawing Figures
- 8-3 Editing Figures
- 8-4 Controlling Geometry Window Appearance
- 8-5 Working with Animations
- 8-6 Using the Geometry Application with Other Applications
- 8-7 Managing Geometry Application Files
Chapter 9 Using the Numeric Solver Application
- 9-1 Numeric Solver Application Overview
- 9-2 Using Numeric Solver
Chapter 10 Using the eActivity Application
- 10-1 eActivity Application Overview
- 10-2 Creating an eActivity
- 10-3 Inserting Data into an eActivity
- 10-4 Working with eActivity Files
- 10-5 Transferring eActivity Files
Chapter 11 Using the Presentation Application
- 11-1 Presentation Application Overview
- 11-2 Building a Presentation
- 11-3 Managing Presentation Files
- 11-4 Playing a Presentation
- 11-5 Editing Presentation Pages
- 11-6 Configuring Presentation Preferences
- 11-7 Presentation File Transfer Precautions
Chapter 12 Using the Program Application
- 12-1 Program Application Overview
- 12-2 Creating a New Program
- 12-3 Debugging a Program
- 12-4 Managing Files
- 12-5 User-defined Functions
- 12-6 Program Command Reference
- 12-7 Including ClassPad Functions in Programs
Chapter 13 Using the Spreadsheet Application
- 13-1 Spreadsheet Application Overview
- 13-2 Spreadsheet Application Menus and Buttons
- 13-3 Basic Spreadsheet Window Operations
- 13-4 Editing Cell Contents
- 13-5 Using the Spreadsheet Application with the eActivity Application
- 13-6 Using the Action Menu
- 13-7 Formatting Cells and Data
- 13-8 Graphing
Chapter 14 Using the Setup Menu
- 14-1 Setup Menu Overview
- 14-2 Using the Setup Menu
- 14-3 Setup Menu Settings
Chapter 15 Configuring System Settings
- 15-1 System Setting Overview
- 15-2 Managing Memory Usage
- 15-3 Using the Reset Dialog Box
- 15-4 Initializing Your ClassPad
- 15-5 Adjusting Display Contrast
- 15-6 Configuring Power Properties
- 15-7 Specifying the Display Language
- 15-8 Specifying the Font Set
- 15-9 Specifying the Alphabetic Keyboard Arrangement
- 15-10 Optimizing “Flash ROM”
- 15-11 Specifying the Ending Screen Image
- 15-12 Adjusting Touch Panel Alignment
- 15-13 Viewing Version Information
Chapter 16 Performing Data Communication
- 16-1 Data Communication Overview
- 16-2 Connecting the ClassPad to Another Device
- 16-3 Configuring Communication Parameters
- 16-4 Transferring Data to Another ClassPad Unit
Appendix
- 1 Resetting and Initializing the ClassPad
- 2 Deleting an Application
- 3 Power Supply
- 4 Number of Digits and Precision
- 5 Specifications
- 6 Character Code Table
- 7 System Variable Table
- 8 Command and Function Index
- 9 Graph Types and Executable Functions
- 10 Error Message Table

20050501

u variance

Function: Returns the sample variance of the values contained in the range of specified

cells.

Syntax: variance(start cell:end cell)

Example: To determine the sample variance of the values in the block whose upper left

corner is located at A7 and whose lower right corner is located at C12, and input

the result in cell A1:

13-6-9

Using the Action Menu

u Q1

Function: Returns the first quartile of the values contained in the range of specified cells.

Syntax: Q1(start cell:end cell[,start cell:end cell])

Example: To determine the first quartile of the values in the block whose upper left corner

is located at A7 and whose lower right corner is located at C12, and input the

result in cell A1: