Casio Spreadsheet Application- Manuals

Casio Spreadsheet Application– User Manual in PDF format online.

Manuals:

User Manual

User Manual Casio Spreadsheet Application

Summary

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

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 ...

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

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...

Page 4 - Further Fibonacci Investigation:

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? ...

Page 5 - cursor in Cell A1. Press ALPHA EXP ALPHA R APLPHA T ALPHA N ALPHA R EXE; Calculating the TOTAL in Cell B4:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 5 Press EXE (Fig19D) We can see that the Golden Ratio does appear to be approached with successive divisions in this way. For closer inspection we could repeat this exercise using a computer spreadsheet. ...

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.

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 6 Then EXE The Retainer-plus-Commission Calculator is complete. Now use it to complete the investigation which was: Find three different combinations of Retainer Amount, Sales Made and Percentage Rate of ...

Page 7 - Enter the values as shown in Fig27; Simple Interest vs Compound Interest Investigation:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 7 Now we need to enter the formula for the Grand Total into cell D6. Place the cursor in cell D6. Press SHIFT = CEL (F5) Sum (F5) ALPHA D 2 (Fig 25) Now we need the colon. Press EXIT, F3 ALPHA D 5 ) (Fig ...

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

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 8 Building an SI/CI Spreadsheet: Here is one example of a SI/CI spreadsheet. Enter the headings as shown in Fig30 Calculating the Simple Interest Future Value in Cell D1: Place the cursor into cell D1 Ent...

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:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 9 A quality activity for students could include the investigation : "Using the results from your spreadsheet investigate which variable (P, I or T) has the greatest effect in creating the greatest dif...

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.

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 10 The GRAB function: You may be aware that when using excel there are two ways to enter cell names into a formula: 1) Writing the name eg C1, D3, etc, and 2) clicking on the required cell. With the Casio...

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.

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 11 Editing a Formula: (eg Calculating the Median starting with a Mean formula): Using the same spreadsheet let's change the first Mean to a Median. Change the label in cell B1 to MEDIAN. Place the cursor ...

Page 12 - Cutting and Pasting:; EXIT that screen, Place the cursor in A1 and arrow up 1 space

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 12 Testing the Spreadsheet: Test that your Pythagorean Calculator works using a 3-4-5 triangle as shown in Fig50. Calculate the Hypotenuse of a right angled triangle with short sides of length 2.1m and 4....

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

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 13 Press EDIT (F2) CUT (F1) scroll to Column C press PASTE (F1) arrow down 1 place (Fig56) Now we will COPY Row 3 and PASTE it into Row 6 EXIT that screen, Place the cursor in A3 and arrow left 1 space Pr...

Page 14 - Drawing Graphs from a Spreadsheet:; Press SHIFT MENU; and; Press EXIT; to get to Fig65

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 14 Sort Row 2 into Ascending order: Hi-light Row2 EDIT (F2) SRT-A (F3) (Fig62) Sort Row 2 into Descending order: Press SRT-D (F4) (Fig63) Drawing Graphs from a Spreadsheet: Arguably, when using the 9860, ...

Page 15 - Investigating Correlation:; Use your arrow left-right to scroll through different values.

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 15 Choose Scat (F1) Arrow down 1 place Change X Cell Range to A2:A5 (With Cell Range hi-lighted, arrow past the A2 press the DEL button type 2 EXE Similarly, change Y Cell range to B2:B5 Set Frequency to ...

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

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 16 Press EXE (Fig72) To return to the trace facility: Simply Press SHIFT F1 Drawing a Box and Whisker Plot from a Frequency Distribution Table: Open a new spreadsheet. Enter the values as they appear in F...

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

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 17 Frequency Histograms: What we are going to do here is – 1) Draw up a Frequency Distribution Table in STAT 2) Transfer the Table into SSHT 3) Draw a Histogram (and compare it to the Box Plot) (Then in t...

Page 18 - With the cursor over Stat Graph press F3 to select; Stat Graph3; Comparing the Histogram to the Box Plot:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 18 Press GRPH (F1) SET (F6) With the cursor over Stat Graph press F3 to select Stat Graph3 (Fig84) NOTE: There is a good reason for using Stat Graph 3. Stay tuned!! Scroll to Graph Type. Press F6 then HIS...

Page 19 - Transferring Data from a Column in SSHT to a List in STAT:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 19 Press EXIT SEL (F4) Turn Stat Graphs 1 and 3 On (Fig90) Press DRAW (F6) and complete the set up in Fig91 Press DRAW (F6) and TRACE This is poignant in regard to the location of the quartiles and the me...

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.

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 20 Set the Cell Range and List number as in Fig95 Press EXE (or F6) MENU STAT EXE Notice Column A has been placed in List 4 (Fig96) Transferring Data from a List in STAT to a Column in SSHT: Occasionally ...

Page 21 - Insert your desired File number; (this demonstration is choosing File 5); Conditional Commands:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 21 Now let's transfer an entire file. This demonstration is using File 5 on the software version of the 9860. You will need to choose a Stat File that you wish to transfer. To determine which STAT File yo...

Page 22 - Power – Root Tester:

Casio 9860 Graphic Calculator Self – Guided Instructions SPREADSHEET Mode © Richard Andrew 2008 22 Press EXE Experiment with various sets of values. This sheet could be a great assist to a beginners percentage worksheet asking 'easy' percentage questions (eg Find: 10% of 41; 4% of 50; 20% of 35; etc...

Casio Manuals

Casio 0205-H User Manual
Casio 0205-H Manual
Casio 1174 User Manual
Casio 1174 Manual
Casio 120CR User Manual
Casio 120CR Manual
Casio 120CR, 160CR User Manual
Casio 120ER User Manual
Casio 130CR User Manual
Casio 130CR Manual
Casio 140CR Manual
Casio 160CR User Manual
Casio 160CR Manual
Casio 1633 User Manual
Casio 1633 Manual
Casio Модуль 1789 User Manual
Casio 1868 User Manual
Casio 1868 Manual
Casio 1949 User Manual
Casio 1949 Manual