Casio Spreadsheet Application, User Manual

Page 1: ...RJA510188 4 E For ClassPad 300 Spreadsheet Application User s Guide Version 2 0 http classpad net ...

Page 2: ...20040801 Using the Spreadsheet Application The Spreadsheet application provides you with powerful take along anywhere spreadsheet capabilities on your ClassPad ...

Page 3: ...Using the Fill Sequence Command 4 8 Cut and Copy 4 10 Paste 4 11 Specifying Text or Calculation as the Data Type for a Particular Cell 4 13 Using Drag and Drop to Copy Cell Data within a Spreadsheet 4 14 Using Drag and Drop to Obtain Spreadsheet Graph Data 4 16 5 Using the Spreadsheet Application with the eActivity Application 5 1 Drag and Drop 5 1 6 Using the Action Menu 6 1 Spreadsheet Action Me...

Page 4: ...ing procedure to start up the Spreadsheet application u ClassPad Operation 1 On the application menu tap R This starts the Spreadsheet application and displays its window Spreadsheet Window The Spreadsheet window shows a screen of cells and their contents Row numbers 1 to 999 Column letters A to BL Edit buttons Edit box Cell cursor Status area Each cell can contain a value expression text or a for...

Page 5: ...play a dialog box for specifying column width Column Width Display a dialog box for specifying the number format of the selected cell s Number Format Display or hide the Cell Viewer window Cell Viewer Display a dialog box for specifying a cell to jump to Goto Cell Display a dialog box for specifying a range of cells to select Select Range Display a dialog box for specifying cell contents and a ran...

Page 6: ...n decimal floating point and exact display 1 Toggle the selected cell s between bold and normal M B Toggle the data type of the selected cell s between text and calculation u Specify left justified text and right justified values for selected cell s default Specify left justified for selected cell s p Specify centered for selected cell s x Specify right justified for selected cell s Display or hid...

Page 7: ...urrent selection is indicated in the status bar and the value or formula located in the selected cell is shown in the edit box You can select multiple cells for group formatting deletion or insertion See Selecting Cells on page 3 5 for more information about selecting cells Controlling Cell Cursor Movement Use the following procedure to specify whether the cell cursor should stay at the current ce...

Page 8: ...e setting is the way you want tap OK Navigating Around the Spreadsheet Window The simplest way to select a cell is to tap it with the stylus You can also drag the stylus across a range of cells to select all of them If you drag to the edge of the screen it will scroll automatically until you remove the stylus from the screen The following are other ways you can navigate around the Spreadsheet wind...

Page 9: ...e cell s column and row u ClassPad Operation 1 On the Edit menu select Goto Cell 3 3 Basic Spreadsheet Window Operations 2 On the dialog box that appears type in a letter to specify the column of the cell to which you want to jump and a value for its row number 3 After the column and row are the way you want tap OK to jump to the cell ...

Page 10: ...Hide the scrollbars Off 3 After the setting is the way you want tap OK Hiding or Displaying the Scrollbars Use the following procedure to turn display of Spreadsheet scrollbars on and off By turning off the scrollbars you make it possible to view more information in the spreadsheet u ClassPad Operation 1 On the Edit menu tap Options 3 4 Basic Spreadsheet Window Operations ...

Page 11: ...range of cells all the cells in a row or column or all of the cells in the spreadsheet 3 5 Basic Spreadsheet Window Operations Tap a row heading to select the row Tap a column heading to select the column Tap a cell to select it Tap here to select the entire spreadsheet To select a range of cells drag the stylus across them ...

Page 12: ...select a value or formula and then drag it to another cell u To view or hide the Cell Viewer window On the Spreadsheet toolbar tap A Or on the Spreadsheet Edit menu select Cell Viewer The above operation toggles display of the Cell Viewer window on and off You can control the size and location of the Cell Viewer window using the r and S icons on the icon panel below the touch screen For details ab...

Page 13: ...dit Mode Screen The Spreadsheet application automatically enters the edit mode whenever you tap a cell to select it and input something from the keypad Entering the edit mode see page 4 2 displays the editing cursor in the edit box and the data input toolbar Tap to apply your input or edits Tap to cancel input or editing without making any changes Data input toolbar Tap to scroll the character but...

Page 14: ...standard edit mode Tapping the edit box selects highlights all of the text in the edit box Tapping the edit box again deselects unhighlights the text and displays the editing cursor a solid blinking cursor Be sure to use this standard editing mode when you want to correct or change the existing contents of a cell The following explains the operation of the cursor key after entering the standard ed...

Page 15: ...Selecting Cells on page 3 5 for more information about selecting cells 2 Input the data you want You can input data using the keypad the Action menu and the input toolbar See the following sections for more information 3 After you are finished finalize the input using one of the procedures below If you are using this edit mode Do this to finalize your input Standard Edit Tap the s button next to t...

Page 16: ... formula in cell B5 calculates the average of the values in cells B1 through B3 4 4 Editing Cell Contents Important Tapping another cell while the first character in the edit box is an equal sign inserts a reference to the tapped cell into the edit box Dragging across a range of cells will input a reference to the selected range See Inputting a Cell Reference on page 4 6 for more information When ...

Page 17: ...p cell B1 and then press 8 On the soft keyboard tap the 9 tab tap and then tap 9 Tap cell A1 press x 1 and then press 10 Press E 11 Press k to hide the soft keyboard 12 Select highlight cells A1 and B1 13 On the Edit menu tap Copy 14 Select cells A2 and B2 15 On the Edit menu tap Paste Learn more about cell referencing on the next page 4 5 Editing Cell Contents ...

Page 18: ...emember that relative cell references always change dynamically in this way whenever you move them using cut and paste or drag and drop Important When you cut or copy a relative cell reference from the edit box it is copied to the clipboard as text and pasted as is without changing If A1 is in cell C2 and you copy A1 from the edit box and paste it into cell D12 for example D12 will also be A1 k Ab...

Page 19: ...y to input all of the cell references you want For example you could input A1 A2 You can also input a range of cells into the edit box by dragging across a group of cells 6 After your input is the way you want tap the s button next to the edit box or press the E key to save it u To input a cell reference 1 Select the cell where you want to insert the cell reference 2 Tap inside the edit box 3 If y...

Page 20: ... Result A string expression Text sin Invalid expression context Text When text is too long to fit in a cell it spills over into the next cell to the right if the neighboring cell is empty If the cell to the right is not empty the text is cut off and is displayed to indicate that non displayed text is contained in the cell Using the Fill Sequence Command The Fill Sequence command lets you set up an...

Page 21: ...ose value will change with each step Low Specify the smallest value to be assigned to the variable High Specify the greatest value to be assigned to the variable Step Specify the value that should be added to the variable value with each step Start Specify the starting cell from which the results of the expression should be inserted The following shows how the Fill Sequence dialog box should appea...

Page 22: ...l cut copy Multiple cell cut copy Selected edit box text cut copy Cell Viewer values and formulas copy only Cutting or copying data places it onto the clipboard You can use the Paste command to paste the clipboard contents at the current cell cursor or editing cursor location 4 10 Editing Cell Contents 3 After everything is the way you want tap OK This performs all the required calculations accord...

Page 23: ... box If you do this Executing the Paste command will do this Select a single cell with the cell cursor Paste the clipboard data into the selected cell Select multiple cells with the cell cursor Paste the clipboard data into each of the selected cells Locate the editing cursor inside the edit Paste the clipboard data at the editing cursor box location k When the clipboard contains data from multipl...

Page 24: ...asted into the edit box 4 12 Editing Cell Contents Select the cell where you want to insert the text A6 in this example and then tap inside the edit box Tap Edit and then Paste To view the matrix as text tap the cell A6 and then A To view the matrix as 2D tap u to change data types ...

Page 25: ...he cell Causes this to be specified displayed Text u 2 2 4 toolbar button for text 2 2 2 2 Calculation 2 2 4 toolbar button for math 2 2 4 Important Unless noted otherwise all of the input examples in this User s Guide assume that input is being performed into a cell for which text is specified as the data type Because of this calculations that evaluate will be preceded with an equal sign u ClassP...

Page 26: ...ce on page 4 6 for more information u To drag and drop between cells within a spreadsheet 1 Use the stylus to select the cell or range of cells you want to copy so it is highlighted Lift the stylus from the screen after you select the cell s See Selecting Cells on page 3 5 for information about selecting cells 2 Hold the stylus against the selected cell s Selection boundary Check to make sure that...

Page 27: ... Cells When dragging multiple cells only the cell where the stylus is located has a selection boundary around it Selection boundary dropped here A8 When you release the stylus from the screen the top left cell of the group originally A1 in the above example will be located where you drop the selection boundary ...

Page 28: ...ta The following examples show how you can drag graph data from a Spreadsheet application Graph window to obtain the graph s function or the values of the graph s data u To use drag and drop to obtain the function of a graph Example To obtain the function of the regression graph shown below 1 Input data and draw a regression curve See Other Graph Window Operations on page 8 13 for more information...

Page 29: ...ontents 1 Input data and draw a bar graph See Other Graph Window Operations on page 8 13 for more information on graphing 2 Tap the Graph window to make it active 3 Tap the top of any bar within the Graph window and then drag to the cell you want in the Spreadsheet window This will cause the bar graph s data to appear beginning at the cell you tapped ...

Page 30: ...mation between the two application windows Example 1 To drag the contents of a single cell from the Spreadsheet window to the eActivity window u ClassPad Operation 1 Tap m to display the application menu and then tap A to start the eActivity application 2 From the eActivity application menu tap Insert and then Spreadsheet This inserts a Spreadsheet data strip and displays the Spreadsheet window in...

Page 31: ... drag a calculation expression from the Spreadsheet edit box to the eActivity window u ClassPad Operation 1 Tap m to display the application menu and then tap A to start the eActivity application 2 From the eActivity application menu tap Insert and then Spreadsheet This inserts a Spreadsheet data strip and displays the Spreadsheet window in the lower half of the screen 3 Select a Spreadsheet cell ...

Page 32: ...in the eActivity window as a text string 5 3 Using the Spreadsheet Application with the eActivity Application 6 You can now experiment with the data in the eActivity window The basic operations for the following example are the same for the other examples described above Example 3 Dragging multiple Spreadsheet cells to the eActivity window ...

Page 33: ...20040801 Example 4 Dragging data from eActivity to the Spreadsheet window 5 4 Using the Spreadsheet Application with the eActivity Application ...

Page 34: ...m the Action menu are similar to those on the List Calculation sub menu of the standard Action menu Spreadsheet Action Menu Basics The following example demonstrates the basic procedure for using functions within the Action menu Example To calculate the sum of the following data and then to add 100 to it ...

Page 35: ...example we would tap cell A1 2 On the Action menu tap sum This inputs an equal sign and the sum function into the edit box 6 2 Using the Action Menu 3 Use the stylus to drag across the range of data cells from A7 to C12 to select them A7 C12 appears to the right of the open parenthesis of the sum function ...

Page 36: ...esult in cell A1 You could skip this step and input the closing parentheses by pressing the key on the keypad if you want 6 3 Using the Action Menu 5 Tap the edit box to activate it again and then tap to the right of the last parenthesis 6 Press the key and then input 100 7 Tap the s button to the right of the edit box This calculates the result and displays it in cell A1 ...

Page 37: ...xample To determine the lowest value 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 u u u u u max Function Returns the greatest value contained in the range of specified cells Syntax max start cell end cell start cell end cell value Example To determine the greatest value in the block whose upper left corner is l...

Page 38: ...ted at A7 and whose lower right corner is located at C12 and input the result in cell A1 6 5 Using the Action Menu u u u u u median Function Returns the median of the values contained in the range of specified cells Syntax median start cell end cell start cell end cell Example To determine the median of the values in the block whose upper left corner is located at A7 and whose lower right corner i...

Page 39: ...s located at A7 and whose lower right corner is located at C12 and input the result in cell A1 6 6 Using the Action Menu u u u u u sum Function Returns the sum of the values contained in the range of specified cells Syntax sum start cell end cell start cell end cell Example To determine the sum of the values in the block whose upper left corner is located at A7 and whose lower right corner is loca...

Page 40: ...le To determine the product of the values in cells A7 and A8 and input the result in cell A1 6 7 Using the Action Menu u u u u u cuml Function Returns the cumulative sums of the values contained in the range of specified cells Syntax cuml start cell end cell Example To determine the cumulative sums of the values in cells B1 through B3 and input the result in cell A1 ...

Page 41: ...ls B1 through B3 and input the result in cell A1 6 8 Using the Action Menu u u u u u stdDev Function Returns the sample standard deviation of the values contained in the range of specified cells Syntax stdDev start cell end cell Example To determine the sample standard deviation of the values in the block whose upper left corner is located at A7 and whose lower right corner is located at C12 and i...

Page 42: ...ated at A7 and whose lower right corner is located at C12 and input the result in cell A1 6 9 Using the Action Menu u u u u 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...

Page 43: ...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 6 10 Using the Action Menu u u u u u percent Function Returns the percentage of each value in the range of specified cells the sum of which is 100 Syntax percent start cell end cell Example To determine the percentage of the values in cells B1 through B4 and input th...

Page 44: ...cells Syntax polyEval start cell end cell start cell end cell variable Example To create a second degree polynomial with coefficients that correspond to the values in cells B1 through B3 and input the result in cell A1 6 11 Using the Action Menu x is the default variable when you do not specify one above To specify y as the variable for example enter polyEval B1 B3 y ...

Page 45: ...valuate the polynomial at 2 for example the result will be the second value in our list Syntax sequence start cell end cell start cell end cell variable Example To determine a polynomial for the sequence values in cells B1 through B4 and a variable of y and input the result in cell A1 6 12 Using the Action Menu x is the default variable when you do not specify one above ...

Page 46: ...e the sum of the first two values in your list When two columns of values or two lists are specified the resulting polynomial returns a sum based on a sequence Syntax sumSeq start cell end cell start cell end cell variable Example To determine a polynomial that generates the sum of the first n terms for the sequence expressed by the values in cells B1 through B4 with a variable of y and input the ...

Page 47: ... row cell Example To determine the row number of cell A7 and input the result in cell A1 u u u u u col Function Returns the column number of a specified cell Syntax col cell Example To determine the column number of cell C9 and input the result in cell A1 6 14 Using the Action Menu ...

Page 48: ...eturns a count of the number of cells in the specified range Syntax count start cell end cell Example To count the number of cells 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 ...

Page 49: ...ard mode and the decimal mode Plain Text and Bold Text Use the following procedure to toggle the text of a specific cell row or column or the entire spreadsheet between plain and bold u ClassPad Operation 1 Select the cell s whose text setting you want to specify See Selecting Cells on page 3 5 for information about selecting cells 2 On the toolbar tap the M B button to toggle between bold and pla...

Page 50: ...appears tap the text alignment option you want to use For this type of alignment Tap this option Left and right justified Left p Center x Right Number Format Use the following procedure to specify the number format Normal 1 Normal 2 Fix 0 9 Sci 0 9 of a specific cell row or column or the entire spreadsheet u ClassPad Operation 1 Select the cell s whose number format setting you want to specify See...

Page 51: ...mand u To change the width of a column using the stylus Use the stylus to drag the edge of a column header left or right until it is the desired width u To change the width of a column using the Column Width command 1 Tap any cell in the column whose width you want to change You could also drag the stylus to select multiple columns if you want 2 On the Edit menu tap Column Width 7 3 Formatting Cel...

Page 52: ...Fit Selection command Example To use AutoFit Selection to adjust the column width to display the value 1234567890 1 Tap a cell and input the value Since the value is too long to fit in the cell it is converted automatically to exponential format Notice however that the entire value appears in the edit box 2 Select the cell you want to auto fit You can also select a range of cells in the same colum...

Page 53: ...usted automatically so the entire value can be displayed Note that AutoFit Selection also will reduce the width of a column if applicable The following shows what happens when AutoFit Selection is executed while a cell that contains a single digit is selected 7 5 Formatting Cells and Data ...

Page 54: ... select the type of graph you want to draw You can also use the Graph menu to specify whether to graph data by column or row The following explains each of the Graph menu commands and shows examples of what happens to the Graph window when you execute a command Note The following examples show the appearance of graph screens after tapping r on the icon panel so the Graph window fills the entire sc...

Page 55: ...20040801 u Graph Line Clustered D u Graph Line Stacked F 8 2 Graphing ...

Page 56: ...20040801 u Graph Line 100 Stacked G u Graph Column Clustered H 8 3 Graphing ...

Page 57: ...20040801 u Graph Column Stacked J u Graph Column 100 Stacked K 8 4 Graphing ...

Page 58: ...20040801 u Graph Bar Clustered L u Graph Bar Stacked 8 5 Graphing ...

Page 59: ...row or column of the selected data is used Tapping any of the sections of a pie graph causes three values to appear at the bottom of the screen the cell location a data value for the section and a percent value that indicates the portion of the total data that the data value represents 8 6 Graphing ...

Page 60: ... columns of data like Columns A B C and D for example there will be three different plot point types A B A C and A D Scatter graphs initially have plotted points only You can add lines by selecting Lines on the View menu u Graph Row Series Selecting this option treats each row as a set of data The value in each column is plotted as a vertical axis value The following shows a graph of the same data...

Page 61: ...red column graph while Column Series is selected and the data that produced it Graph Window Menus and Toolbar The following describes the special menus and toolbar that appears whenever the Spreadsheet application Graph window is on the display k O Menu See Using the O Menu on page 1 5 4 of your ClassPad 300 User s Guide k Edit Menu See Edit Menu on page 2 1 of this User s Guide 8 8 Graphing ...

Page 62: ...y image so it fits the R Zoom to Fit display Toggle display of axes and coordinate values on q Toggle Axes and off Toggle line graph and scatter graph plot markers Markers on and off Toggle line graph and scatter connecting lines Lines on and off k Type Menu The Type menu is identical to the Graph menu described on page 8 1 k Series Menu All of the Series menu commands can also be executed by tapp...

Page 63: ...urve j Trend Polynomial Quintic Display an exponential AeBx regression curve k Trend Exponential Display a logarithmic Aln x B regression curve l Trend Logarithmic Display a power AxB regression curve Trend Power Convert the data of the selected column to a z Line line graph Convert the data of the selected line to a column Column graph Important Exponential and logarithmic regression curves ignor...

Page 64: ...e Graph menu to specify whether you want to graph the data by row or by column To do this Select this Graph menu option Graph the data by row Row Series Graph the data by column Column Series See Graph Menu on page 8 1 for more information 3 Select the cells that contain the data you want to graph See Selecting Cells on page 3 5 for information about selecting data 8 11 Graphing ...

Page 65: ... on the toolbar This draws the selected graph See Graph Menu on page 8 1 for examples of the different types of graphs that are available You can change to another type of graph at any time by selecting the graph type you want on the Type menu Or you can tap the applicable icon on the toolbar 8 12 Graphing ...

Page 66: ...ph or a scatter graph is on the Graph window tap the View menu 2 Tap the Markers or Lines item to toggle it between show checkbox selected and hide checkbox cleared Lines and markers both turned on Lines turned on markers hidden 8 13 Graphing Markers turned on lines hidden Line and scatter graphs can have markers only lines only or both markers and lines You cannot turn off both markers and lines ...

Page 67: ...wish to change to a column graph 3 On the Series menu tap Column 8 14 Graphing You could also tap the down arrow button next to the third tool button from the left and then tap You can change more than one line to a column graph if you want You can change a column graph back to a line graph by selecting one of its columns and tapping Line on the Series menu ...

Page 68: ...to change to a line graph 3 On the Series menu tap Line You could also tap the down arrow button next to the third tool button from the left and then tap z You can change more than one column to a line graph if you want You can change a line graph back to a column graph by selecting one of its data points and tapping Column on the Series menu 8 15 Graphing ...

Page 69: ...he stylus tap any point of the data for which you want to draw the regression curve 3 Use the Series menu to select the type of regression curve you want You could also tap the down arrow button next to the third tool button from the left and tap an icon to select the regression curve type See Series Menu on page 8 9 for information about regression curve types Here we will select quartic regressi...

Page 70: ...ession curve to a cell or the edit box in the Spreadsheet window 8 17 Graphing To delete all displayed regression curves select Clear All on the Edit menu Note that regression curves are also deleted automatically if you change to another graph style This causes the applicable regression curve to appear in the Graph window ...

Page 71: ...tap Paste This pastes two columns of values The numbers in the left column are pie graph section numbers The values in the right column are the percentages that the data in each section of the pie graph represents u To change View Window settings 1 While a graph is on the Graph window tap O Settings and then View Window This displays the current View Window settings 2 Change the View Window settin...

Page 72: ...alues on axes and values off u To change the appearance of a graph by dragging a point While a graph is on the Graph window use the stylus to drag any one of its data points to change the configuration of the graph You can change curves make bars or columns longer or shorter or change the size of pie graph sections Changing a graph automatically changes the graph s data on the Spreadsheet window 8...

Page 73: ...he regression curve also changes automatically in accordance with the drag changes When you edit data in the spreadsheet and press E your graph will update automatically Important You can drag a point only if it corresponds to a fixed value on the spreadsheet You cannot drag a point if it corresponds to a formula ...

Page 74: ...CASIO COMPUTER CO LTD 6 2 Hon machi 1 chome Shibuya ku Tokyo 151 8543 Japan SA0410 B ...