Casio ClassPad 330

To Next Page

To Previous Page

20060301

Example 4: Dragging data from eActivity to the Spreadsheet window

13-5-4

Using the Spreadsheet Application with the eActivity Application

Main Page

Unpacking3
Attaching and Removing the4
Using the Stylus5
Replacing Batteries and Setting up the Classpad5
User Registration8
Handling Precautions9
Table of Contents12
About this User's Guide26
Classpad Keypad and Icon Panel26
On-Screen Keys, Menus, and Other Controllers27
Page Contents28
Chapter 1 Getting Acquainted29
General Guide30
General Guide31
Using the Stylus33
Turning Power on and off34
Turning Power on34
Turning Power off34
Resume Function34
Limiting the Duration of the Sleep State35
Using the Icon Panel36
Built-In Applications37
Starting a Built-In Application38
Classpad Operation38
Application Menu Operations38
Swapping Two Icons40
Built-In Application Basic Operations41
Application Window41
Using a Dual Window Display41
Using the Menu Bar43
Using the O Menu44
Using Check Boxes46
Using Option Buttons47
Using the Toolbar48
Toolbar Buttons48
Interpreting Status Bar Information49
Pausing and Terminating an Operation49
Input51
Using the Soft Keyboard51
Input Basics53
Advanced Soft Keyboard Operations58
Variables and Folders70
Folder Types70
Variable Types71
Creating a Folder73
Creating and Using Variables74
Assigning Values and Other Data to a System Variable79
Locking a Variable or Folder79
Rules Governing Variable Access80
Using the Variable Manager81
Variable Manager Overview81
Starting up the Variable Manager81
Variable Manager Views82
Exiting the Variable Manager82
Variable Manager Folder Operations83
Variable Operations87
Configuring Application Format Settings94
Specifying a Variable95
Initializing All Application Format Settings96
Application Format Settings97
Graph Format Dialog Box99
Presentation Dialog Box107
Chapter 2 Using the Main Application109
Main Application Overview110
Starting up the Main Application110
Main Application Window110
Main Application Menus and Buttons112
Using Main Application Modes113
Accessing Classpad Application Windows from the Main Application114
Accessing the Main Application Window from Another Classpad Application115
Basic Calculations116
Arithmetic Calculations and Parentheses Calculations116
Using the E Key117
Omitting the Multiplication Sign117
Using the Answer Variable (Ans)117
Assigning a Value to a Variable119
Calculation Error119
Calculation Priority Sequence120
Calculation Modes121
Using the Calculation History124
Viewing Calculation History Contents124
Re-Calculating an Expression125
Deleting Part of the Calculation History Contents127
Clearing All Calculation History Contents127
Function Calculations128
List Calculations143
Inputting List Data143
Using a List in a Calculation145
Using a List to Assign Different Values to Multiple Variables146
Matrix and Vector Calculations147
Inputting Matrix Data147
Performing Matrix Calculations150
Using a Matrix to Assign Different Values to Multiple Variables152
Specifying a Number Base153
Number Base Precautions153
Binary, Octal, Decimal, and Hexadecimal Calculation Ranges153
Selecting a Number Base155
Arithmetic Operations156
Bitwise Operations157
Using the Baseconvert Function (Number System Transform)157
Using the Action Menu158
Abbreviations and Punctuation Used in this Section158
Example Screenshots159
Displaying the Action Menu160
Using the Transformation Submenu160
Using the Advanced Submenu165
Using the Calculation Submenu169
Using the Complex Submenu176
Using the List-Create Submenu178
Using the List-Calculation Submenu181
Using the Matrix-Create Submenu188
Using the Matrix-Calculation Submenu190
Using the Vector Submenu195
Using the Equation/Inequality Submenu199
Using the Assistant Submenu204
Using the Distribution Submenu205
Using the Command Submenu212
Using the Interactive Menu213
Interactive Menu and Action Menu213
Interactive Menu Example213
Using the "Apply" Command216
Using the Main Application in Combination with Other Applications217
Opening Another Application's Window217
Closing Another Application's Window218
Using the Graph Window $ and 3D Graph Window218
Using a Graph Editor Window (Graph & Table: ! , Conics: * , 3D Graph: @ , Numeric Solver: 1 )220
Using the Stat Editor Window221
Using the Geometry Window 3225
Using the Sequence Editor Window227
Using Verify228
Starting up Verify228
Verify Menus and Buttons229
Using Verify230
Using Probability232
Starting up Probability233
Probability Menus and Buttons233
Using Probability235
Running a Program in the Main Application238
Chapter 3 Using the Graph & Table Application240
Graph & Table Application Overview241
Starting up the Graph & Table Application241
Graph & Table Application Window241
Graph & Table Application Menus and Buttons242
Graph & Table Application Status Bar247
Graph & Table Application Basic Operations247
Using the Graph Window252
Configuring View Window Parameters for the Graph Window252
Using View Window Memory255
Viewing Graph Window Coordinates256
Scrolling the Graph Window257
Panning the Graph Window257
Zooming the Graph Window258
Using Quick Zoom260
Other Graph Window Operations261
Storing Functions263
Using Graph Editor Sheets263
Specifying the Function Type264
Storing a Function265
Using Built-In Functions267
Saving the Message Box Expression to the Graph Editor Window267
Editing Stored Functions268
Using Trace 3268
Deleting All Graph Editor Expressions269
Graphing a Stored Function269
Saving Graph Editor Data to Graph Memory276
Using Table & Graph277
Generating a Number Table277
Editing Number Table Values280
Deleting, Inserting, and Adding Number Table Lines281
Regenerating a Number Table282
Generating a Number Table and Using It to Draw a Graph283
Saving a Number Table to a List284
Generating a Summary Table285
Making the Graph Editor Window the Active Window291
Modifying a Graph292
Modifying a Single Graph by Changing the Value of a Coefficient (Direct Modify)292
Simultaneously Modifying Multiple Graphs by Changing Common Variables (Dynamic Modify)295
Using the Sketch Menu298
Sketch Menu Overview298
Using Sketch Menu Commands298
Using Trace303
Using Trace to Read Graph Coordinates303
Linking Trace to a Number Table305
Generating Number Table Values from a Graph306
Analyzing a Function Used to Draw a Graph308
G-Solve Menu Overview308
Using G-Solve Menu Commands309
Chapter 4 Using the Conics Application317
Conics Application Overview318
Starting up the Conics Application318
Conics Application Window318
Conics Application Menus and Buttons319
Conics Application Status Bar321
Inputting Equations322
Using a Conics Form to Input an Equation322
Inputting an Equation Manually324
Transforming a Manually Input Equation to a Conics Form324
Drawing a Conics Graph325
Drawing a Parabola325
Drawing a Circle328
Drawing an Ellipse329
Drawing a Hyperbola330
Drawing a General Conics332
Using Trace to Read Graph Coordinates333
Using Trace333
Using G-Solve to Analyze a Conics Graph334
Displaying the G-Solve Menu334
Using G-Solve Menu Commands335
Chapter 5 Using the 3D Graph Application339
Other 3D Graph Application Functions 5339
Graph Application Overview340
Starting up the 3D Graph Application340
Graph Application Window340
Graph Application Menus and Buttons341
Graph Application Status Bar343
Inputting an Expression344
Using 3D Graph Editor Sheets344
Storing a Function345
Drawing a 3D Graph346
Configuring 3D Graph View Window Parameters346
Graph Example348
Manipulating a Graph on the 3D Graph Window351
Enlarging and Reducing the Size of a Graph351
Switching the Eye Position351
Rotating the Graph Manually352
Rotating a Graph Automatically353
Initializing the Graph Window353
Other 3D Graph Application Functions354
Using Trace to Read Graph Coordinates354
Inserting Text into a 3D Graph Window354
Calculating a -Value for Particular355
T -Values355
Using Drag and Drop to down a 3D Graph356
Chapter 6 Using the Sequence Application357
Sequence Application Overview358
Starting up the Sequence Application358
Sequence Application Window358
Sequence Application Menus and Buttons359
Sequence Application Status Bar363
Inputting an Expression in the Sequence Application364
Inputting Data on the Sequence Editor Window364
Inputting Data on the Sequence RUN Window364
Recursive and Explicit Form of a Sequence365
Generating a Number Table365
Graphing a Recursion367
Determining the General Term of a Recursion Expression369
Calculating the Sum of a Sequence370
Using Linktrace371
Drawing a Cobweb Diagram372
Chapter 7 Using the Statistics Application373
Statistics Application Overview374
Starting up the Statistics Application375
Stat Editor Window Menus and Buttons376
Stat Editor Window Status Bar377
Using Stat Editor378
Basic List Operations378
Creating a List379
Inputting Data into a List381
Editing List Contents384
Sorting List Data385
Controlling the Number of Displayed List Columns386
Clearing All Stat Editor Data386
Before Trying to Draw a Statistical Graph387
Using the Setgraph Menu387
Configuring Statgraph Setups388
Graphing Single-Variable Statistical Data391
Normal Probability Plot (Npplot)391
Histogram Bar Graph (Histogram)392
Med-Box Plot (Medbox)392
Normal Distribution Curve (Ndist)393
Broken Line Graph (Broken)394
Graphing Paired-Variable Statistical Data395
Drawing a Scatter Plot and Xy Line Graph395
Drawing a Regression Graph396
Graphing Previously Calculated Regression Results398
Drawing a Linear Regression Graph399
Drawing a Med-Med Graph400
Drawing Quadratic, Cubic, and Quartic Regression Graphs401
Drawing a Logarithmic Regression Graph403
Y a B X403
A B X405
C ) + D )407
Overlaying a Function Graph on a Statistical Graph409
Using the Statistical Graph Window Toolbar410
Performing Statistical Calculations411
Viewing Single-Variable Statistical Calculation Results411
Viewing Paired-Variable Statistical Calculation Results412
Viewing Regression Calculation Results413
Residual Calculation413
Copying a Regression Formula to the Graph & Table Application414
Test, Confidence Interval, and Distribution Calculations415
Statistics Application Calculations415
Program Application Calculations415
Tests419
Test Command List420
Confidence Intervals437
Confidence Interval Command List438
Distributions447
Input Example449
Distribution Command List449
Statistical System Variables469
Chapter 8 Using the Geometry Application470
Geometry Application Overview471
Starting up the Geometry Application473
Geometry Application Menus and Buttons473
File Menu474
Drawing Figures477
Using the Draw Menu477
Inserting Text Strings into the Screen494
Attaching an Angle Measurement to a Figure495
Displaying the Measurements of a Figure498
Displaying the Result of a Calculation that Uses On-Screen Measurement Values501
Using the Special Shape Submenu503
Using the Construct Submenu506
Transformation Using a Matrix or Vector (General Transform)513
Editing Figures521
Selecting and Deselecting Figures521
Moving and Copying Figures 8521
Moving and Copying Figures523
Pinning an Annotation on the Geometry Window524
Specifying the Number Format of a Measurement525
Using the Measurement Box526
Controlling Geometry Window Appearance533
Configuring View Window Settings533
Selecting the Axis Setting534
Toggling Integer Grid Display on and off535
Zooming535
Using Pan to Shift the Display Image538
Working with Animations539
Using Animation Commands539
Using the Geometry Application with Other Applications547
Drag and Drop547
Copy and Paste551
Dynamically Linked Data551
Managing Geometry Application Files552
File Operations552
Folder Operations555
Chapter 9 Using the Numeric Solver Application557
Numeric Solver Application Overview558
Starting up the Numeric Solver Application558
Numeric Solver Application Window558
Numeric Solver Menus and Buttons558
Using Numeric Solver560
Chapter 10 Using the Eactivity Application563
Eactivity Application Overview564
Starting up the Eactivity Application564
Eactivity Application Window564
Eactivity Application Menus and Buttons565
Eactivity Application Status Bar567
Eactivity Key Operations567
Creating an Eactivity569
Basic Steps for Creating an Eactivity569
Managing Eactivity Files571
Inserting Data into an Eactivity572
Inserting a Text Row572
Inserting a Calculation Row574
Inserting an Application Data Strip576
Strip Help Text585
Moving Information between Eactivity and Applications586
Inserting a Geometry Link Row588
Working with Eactivity Files590
Opening an Existing Eactivity590
Browsing the Contents of an Eactivity591
Editing the Contents of an Eactivity591
Expanding an Application Data Strip591
Modifying the Data in an Application Data Strip592
Saving an Edited Eactivity592
Transferring Eactivity Files594
Transferring Eactivity Files between Two Classpad Units594
Transferring Eactivity Files between a Classpad Unit and a Computer595
Chapter 11 Using the Presentation Application596
Presentation Application Overview597
Starting up the Presentation Application598
Presentation Application Window598
Presentation Application Menus and Buttons599
Screen Capture Precautions600
Building a Presentation601
Adding a Blank Page to a Presentation602
Managing Presentation Files604
Playing a Presentation606
Using Auto Play606
Using Manual Play607
Using Repeat Play608
Editing Presentation609
About the Editing Tool Palette609
Entering the Editing Mode609
Editing Operations611
Using the Eraser615
Configuring Presentation Preferences616
Presentation File Transfer618
Chapter 12 Using the Program Application619
Program Application Overview620
Starting up the Program Application620
Program Loader Window620
Program Editor Window622
Creating a New Program627
General Programming Steps627
Creating and Saving a Program627
Running a Program631
Pausing Program Execution632
Terminating Program Execution632
Configuring Parameter Variables and Inputting Their Values633
Using Subroutines634
Debugging a Program636
Debugging after an Error Message Appears636
Debugging a Program Following Unexpected Results636
Modifying an Existing Program to Create a New One637
Searching for Data Inside a Program640
Managing Files641
Renaming a File641
Deleting a Program641
Changing the File Type642
User-Defined Functions643
Creating a New User-Defined Function643
Executing a User-Defined Function645
Editing a User-Defined Function646
Deleting a User-Defined Function646
Program Command Reference647
Using this Reference647
Program Application Commands648
Application Command List661
Including Classpad Functions in Programs693
Including Graphing Functions in a Program693
Using Conics Functions in a Program693
Including 3D Graphing Functions in a Program694
Including Table & Graph Functions in a Program694
Including Recursion Table and Recursion Graph Functions in a Program695
Including List Sort Functions in a Program695
Including Statistical Graphing and Calculation Functions in a Program696
Chapter 13 Using the Spreadsheet Application698
Spreadsheet Application Overview699
Starting up the Spreadsheet Application699
Spreadsheet Window699
Spreadsheet Application Menus and Buttons700
Basic Spreadsheet Window Operations703
About the Cell Cursor703
Controlling Cell Cursor Movement703
Navigating Around the Spreadsheet Window704
Cursor Keys704
Hiding or Displaying the Scrollbars706
Selecting Cells707
Using the Cell Viewer Window708
Editing Cell Contents709
Edit Mode Screen709
Entering the Edit Mode710
Basic Data Input Steps711
Inputting a Formula712
Inputting a Cell Reference714
Inputting a Constant716
Using the Fill Sequence Command717
Cut and Copy719
Paste719
Specifying Text or Calculation as the Data Type for a Particular Cell721
Using Drag and Drop to Copy Cell Data Within a Spreadsheet722
Using Drag and Drop to Obtain Spreadsheet Graph Data724
Recalculating Spreadsheet Expressions725
Importing and Exporting Variable Values729
Searching for Data in a Spreadsheet734
Sorting Spreadsheet Data737
Using the Spreadsheet Application with the Eactivity Application739
Drag and Drop739
Using the Action Menu743
Spreadsheet [Action] Menu Basics743
Action Menu Functions746
Formatting Cells and Data759
Standard (Fractional) and Decimal (Approximate) Modes759
Plain Text and Bold Text759
Text and Calculation Data Types759
Text Alignment760
Changing the Width of a Column761
Graphing764
Graph Menu764
Graph Window Menus and Toolbar774
Basic Graphing Steps776
Other Graph Window Operations778
Chapter 14 Using the Differential Equation Graph Application786
Differential Equation Graph Application Overview787
Differential Equation Graph Application Features787
Starting up the Differential Equation Graph Application788
Differential Equation Graph Application Window788
Differential Equation Editor Window Menus and Buttons790
Differential Equation Graph Window Menus and Buttons792
Differential Equation Graph Application Status Bar794
Graphing a First Order Differential Equation795
Inputting a First Order Differential Equation and Drawing a Slope Field795
Inputting Initial Conditions and Graphing the Solution Curves of a First Order Differential Equation797
Configuring Solution Curve Graph Settings798
Graphing a Second Order Differential Equation800
Drawing the Phase Plane of a Second Order Differential Equation800
Inputting Initial Conditions and Graphing the Solution Curve of a Second Order Differential Equation801
Graphing an Nth-Order Differential Equation803
Inputting an Nth-Order Differential Equation and Initial Conditions, and then Graphing the Solutions803
Drawing F (X) Type Function Graphs and Parametric Function Graphs805
Drawing an F ( X ) Type Function Graph805
Drawing a Parametric Function Graph806
Configuring Differential Equation Graph View Window Parameters807
Configuring Differential Equation Graph View Window Settings807
Differential Equation Graph View Window Parameters808
Differential Equation Graph Window Operations810
Graph Zooming and Scrolling810
Configuring and Modifying Initial Conditions810
Using Trace to Read Graph Coordinates814
Graphing an Expression or Value by Dropping It into the Differential Equation Graph Window815
Chapter 15 Using the Financial Application820
Financial Application Overview821
Starting up the Financial Application821
Financial Application Menus and Buttons822
Configuring Default Financial Application Settings824
Financial Application Pages825
Financial Calculation Screen Basics826
Variables827
Status Bar827
Simple Interest828
Simple Interest Fields828
Financial Application Default Setup for Examples828
Calculation Formulas829
Compound Interest830
Compound Interest Fields830
Financial Application Default Setup for Examples830
Calculation Formulas832
Cash Flow833
Cash Flow Fields833
Inputting Cash Flow Values833
Calculation Formulas836
Amortization837
Amortization Fields837
Financial Application Default Setup for Examples837
Calculation Formulas840
Interest Conversion841
Interest Conversion Fields841
Calculation Formulas842
Cost /Sell/Margin843
Cost /Sell/Margin Fields843
Calculation Formulas843
Day Count Fields844
Financial Application Default Setup for Examples844
Depreciation846
Depreciation Fields846
Calculation Formulas848
Bond Calculation850
Bond Calculation Fields850
Financial Application Default Setup for Examples850
Calculation Formulas853
Break-Even Point855
Break-Even Point Fields855
Financial Application Default Setup for Examples855
Calculation Formulas857
Margin of Safety858
Margin of Safety Fields858
Calculation Formulas858
Operating Leverage859
Operating Leverage Fields859
Calculation Formulas859
Financial Leverage860
Financial Leverage Fields860
Calculation Formulas860
Combined Leverage861
Combined Leverage Fields861
Calculation Formulas861
Quantity Conversion862
Quantity Conversion Fields862
Calculation Formulas863
Chapter 16 Configuring System Settings864
System Setting Overview865
Starting up the System Application865
System Application Window865
System Application Menus and Buttons866
Managing Memory Usage867
Memory Usage Sheets867
Deleting Memory Usage Data869
Using the Reset Dialog Box870
Initializing Your Classpad871
Adjusting Display Contrast872
Configuring Power Properties873
Power Saving Mode873
Auto Power off873
Configuring Power Properties874
Specifying the Display Language875
Specifying The Font Set876
Specifying The Alphabetic Keyboard Arrangement877
Optimizing "Flash Rom878
Specifying The Ending Screen Image879
Adjusting Touch Panel Alignment880
Viewing Version Information881
Registering A User Name On A Classpad882
Specifying The Complex Number Imaginary Unit883
Assigning Shift Mode Key Operations To Hard Keys884
Chapter 17 Performing Data Communication886
Data Communication Overview887
Connectable Devices and Transferable Data887
Using the Classpad Communication Application889
Connecting The Classpad To Another Device890
Connecting to Another Classpad Unit890
Connecting to an EA-200 Data Analyzer891
Connecting to a Computer (USB)892
Configuring Communication Parameters893
Wakeup894
Transferring Data To Another Classpad Unit896
Selecting Data for Transfer898
Sending a Screenshot of the Current Display Contents900
Communication Standby901
Interrupting an Ongoing Data Communication Operation901
Appendix902
Resetting and Initializing the Classpad903
Deleting an Application905
Power Supply906
Number of Digits and Precision911
Specifications912
Character Code Table914
System Variable Table918
Command And Function Index925
Graph Types and Executable Functions931
Error Message Table935

Casio ClassPad 330 - Page 742

Table of Contents

Other manuals for Casio ClassPad 330

Related product manuals