Texas Instruments TINSPIRECX manual Using Formulae, Conflict resolution

Page 42

First Steps with TI-Nspire™

Tutorial 6: Lists & Spreadsheet

Using Formulae

Suppose you wished to investigate the relationship between hand spans and shoe sizes. You might therefore wish to divide every hand-span measurement by the corresponding shoe size. These ratios would best be expressed in decimal rather than fractional format so change the Document Settings for Calculation Mode to Approximate (~721).

There are 3 ways (at least!) of calculating the ratios on the TI-Nspire. Try one of the following now.

Either:

in cell D1 type the expression =B1/A1. Select D1 and fill down the column by pressing b and

 

choosing the options 3: Data and 3: Fill Down.

Or:

in the grey formula area at the top of column D enter =mhand/mshoe.

Or:

in the grey formula area enter =b/a.

 

 

 

 

 

 

 

 

 

 

 

 

Conflict resolution

Press b and notice the various options available in the Lists & Spreadsheet application.

TI-Nspire has most of the editing features that you would expect from a spreadsheet including selecting, inserting, moving and deleting rows, columns and cells.

One way to enter a formula

Typical Spreadsheet Actions

You can also create absolute cell references in the usual way using $ chosen from the symbols key menu (º) and you can sort data in columns (b16). To sort multiple columns at once by one column press £ until the column is selected then hold down g and press ¡ or ¢ to select the columns you want before choosing Sort from the Actions menu.

Page 42

© 2012 Texas Instruments Education Technology

Page 41 Page 43
Image 42
Page 41 Page 43
Contents First Steps About this document Contents Appendix TI-Nspire CX Keypad Layout TI-Nspire Documents Nothing on the screen?Memory Battery Life Charging the handheldHome Screen First Steps with TI-Nspire Tutorial 1 TI-Nspire documents Documents, Problems and Pages ScratchpadNavigating Documents First Steps with TI-Nspire Tutorial 1 TI-Nspire documents Contextual Menus Check list of some key points in Tutorial Calculator Application Basic operationsHistory Lesson Approximate CalculationsTemplates Menu of maths templatesDocument settings dialog box Effect of changed settingsGetting Set Some Algebra Ways to define variablesUse of function notation Calculator Menu Statistical Distribution TablesLists of random integers Variables Linked to Documents List of defined variablesWhy use Notes? Making NotesVarious text formatting Instructions Recording results Splitting the Screen Format sub-menuWays to split the screen You must press /e and then b Interactive Notes An inserted comment Use of proof template and symbolsMore Options from the Notes Menu Use of Q+A templateAsking Questions Check list of some key points in Tutorial Graphing Functions GraphingGraphs & Geometry Two Views Graphing ViewOpen-hand cursor Grab and Drag PracticeChanging the Axes Grabbed tick mark on the axesZoom settings Grabbed-sheet icon Editing, Deleting or Hiding a FunctionChanging f2 in the function history Trace picks out significant points Tracing GraphsPoints and coordinates Points of intersectionAnalyse Graph Menu Coordinates and labelled pointsUsing Sliders Manually Moving GraphsAlternative icons Transformed graph and equation Sequence Plotting Check list of some key points in Tutorial Two Parallel Lines GeometryView for Plane Geometry Drawing the base of the triangleWhat’s grabbable? Construct the TriangleMany options in the Construction menu Measurement menu Making MeasurementsVariables and Text Storing the measurement as a variableReady to grab a and slide it Tidying Up and Using AttributesDynamic Changes Changing the attributes of the triangleArea is now locked Unlocked/Unpinned Points B and C. Try Moving point BCheck list of some key points in Tutorial Lists & Spreadsheet Entering Data as ListsUsing Formulae Conflict resolutionOne way to enter a formula Typical Spreadsheet Actions Capturing Data Function TablesHand-made function table Simple function table Options for function tables Graph and table side by sideFrequency Charts Charts with One Variable One and Two Variable StatisticsShoe Sizes and Hand Spans Comparing Boxplots Charts for Categorical DataPie Chart displaying categorical data Upper quartile displayedCharts with Two Variables Fitting a Line by Hand and EyeReady to add a 2nd variable Drawing the Regression Line Getting the StatsCalculated regression line Statistics Calculations menu Sets of statistics Dragging on the ChartsWorking with Frequency Data Effect of moving a point from here … … to hereTexas Instruments Education Technology Check list of some key points in Tutorial Multiple Representations Draw and Measure a CircleMeasured circle Two Scatterplots Setting up a scatter plot Data capture is under waySpreadsheet for Data Capture Collecting Just a Little DataLinear relationship Go to Town with Data CollectionFit a Straight Line Moving a straight line by hand Not a linear relationshipDifferent Approach to Scatterplots RegressionBasic quadratic ready for fitting… … and dragged into place
Top Page Image Contents