Casio Spreadsheet Application- User Manual
Casio Spreadsheet Application– User Manual, read for free online in PDF format. We hope this helps you resolve any issues you may have. If you have further questions, please contact us through the contact form.
Table of Contents:
- Page 2 – cursor anywhere in Row 2; and press; cursor anywhere in Column A and press COL (F2; Press; In Cell Range; Then; EXE EXE
- Page 3 – is mistakenly written instead of; Calculating Compound Interest:; Press EXIT FILE NEW; and name the new sheet; Press EXIT EDIT F6 FILL; In the formula row type
- Page 4 – Further Fibonacci Investigation:
- Page 5 – cursor in Cell A1. Press ALPHA EXP ALPHA R APLPHA T ALPHA N ALPHA R EXE; Calculating the TOTAL in Cell B4:
- Page 6 – EXE; One example of the Wage Calculator:; Create a new spreadsheet and name it suitably; pressing ALPHA EXP SHIFT ALPHA H R S EXE; enter the values as shown in Fig24.
- Page 7 – Enter the values as shown in Fig27; Simple Interest vs Compound Interest Investigation:
- Page 8 – Calculating the Simple Interest Future Value in Cell D1:; Place the cursor into cell D1; Calculating the Compount Interest Future Value in Cell D2:; Place the cursor into cell D2; Enter
- Page 9 – A quality activity for students could include the investigation; Inserting Rows and Columns:; enter the values shown in Fig36.; Inserting a row above Row 1:; Place the cursor somewhere in Row 1.; Opening Created Spreadsheets:; press EXIT; Deleting Spreadsheets:
- Page 10 – entering the numbers 1 to 5; as shown and; TOTAL entered into B1.; Start entering the formula by pressing; Now to use the GRAB function:; Press EXIT GRAB (F1) place the cursor on cell A1 EXE; Let's check this by calculating the MEAN the long way.
- Page 11 – Creating a Pythagorean Calculator:; One example of this spreadsheet:; Type in the labels as shown in Fig47:; Calculating the Hypotenuse in Cell C2:; Place the cursor in Cell C2; Calculating the Unknown Short Side in Cell C5:; Place the cursor in Cell C5.
- Page 12 – Cutting and Pasting:; EXIT that screen, Place the cursor in A1 and arrow up 1 space
- Page 13 – EXIT that screen, Place the cursor in A3 and arrow left 1 space; Sorting a column of scores:; Open a new spreadsheet.; Enter the values as they appear in Fig58.; Sort Column A into Ascending Order:; Clear the spreadsheet ie
- Page 14 – Drawing Graphs from a Spreadsheet:; Press SHIFT MENU; and; Press EXIT; to get to Fig65
- Page 15 – Investigating Correlation:; Use your arrow left-right to scroll through different values.
- Page 16 – Press EXE; To return to the trace facility:; Simply; Press SHIFT F1; Enter the values as they appear in Fig73; Leave the top setting on; Set the XCellRange, Frequency and Outliers
- Page 17 – Enter the titles SCR and FREQ; into the SUBs in Lists 1 and 2 by using; Enter the scores 0 – 10 into List 1; (This demonstration entered the data into STAT File 5) and; Cell at A1; remembering to cursor to the cell and then; Press EXIT and F6
- Page 18 – With the cursor over Stat Graph press F3 to select; Stat Graph3; Comparing the Histogram to the Box Plot:
- Page 19 – Transferring Data from a Column in SSHT to a List in STAT:
- Page 20 – Transferring Data from a List in STAT to a Column in SSHT:; Occasionally a need will arise to transfer data from STAT to SSHT.
- Page 21 – Insert your desired File number; (this demonstration is choosing File 5); Conditional Commands:
- Page 22 – Power – Root Tester:
Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008
1
Casio 9860 Self-guided Instructions - Spreadsheet Mode
Instructions
Screenshots
Getting Started … naming a new sheet:
Go to
Menu 4 (S-SHT)
and press
EXE
.
Note: You will either have a blank sheet or a sheet with some numbers.
Let's assume we want to make a new sheet. We will call this S1 for Sheet One.
Press File (F1)
then
NEW (F1)
In Spread Sheet Name:
Press S (X key) then ALPHA 1. Then EXE.
(Fig1)
NOTE: when typing Spread Sheet Name the ALPHA button does not need to be pressed to type a letter. ALPHA is already
'ON'.
NOTE: There is a 'Save As' function. If you forget to name your first spreadsheet, you can use 'Save As'. It is under File
(F1), then F3.
Before we enter values please do this:
Place your cursor in Cell A1. Press left arrow (FigA)
Note this hi-lights the Row1.
Now
return the cursor to A1 (right arrow) and press up arrow.
This hi-lights Column A.
Entering values:
Now make the spreadsheet in Fig2. Do this by scrolling to cell A1 and pressing
1 EXE then 2 EXE
etc. Enter the
numbers into all six cells.
Overwriting:
Now, in Column A move the cursor back to A1 and
press 3 EXE
etc. to over-write 1, 2, 3 with
3 6 9
(Fig 3)
Now, in Column B over-write 2, 4, 6 with
4 8 12
(Fig 4)
Deleting Values:
Let's delete just the 8 for now. Place the cursor over the 8 and
press CLR (F5)
(Fig 5)
Fig1
FigA
Fig2
Fig3
Fig4
Fig5
"Loading the manual" means you need to wait until the file loads and becomes available for online reading. Some manuals are very large, and the time they take to appear depends on your internet speed.
Summary
Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 2 Deleting a row: Let's delete Row 2. leave the cursor anywhere in Row 2 and press DEL (F3) then ROW (F1) (Fig 6) NOTE: When you delete a row, the rows below 'jump up' one place. Deleting a column: Let's ...
Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 3 Your spreadsheet should look like Fig10 A common mistake: Look at Column 3 in Fig11. This is the result of trying to make the last spreadsheet BUT making a common mistake in the formula line. Can you di...
Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 4 Generating the Fibonacci Sequence: Open a new spreadsheet and name it FIB1 ( Press EXIT if necessary, then FILE NEW FIB1 EXE) Enter 1 in A1 and 1 in A2 (Fig 17) Can you generate the Fibonacci Sequence? ...
