Home » Texas Instruments Manuals » Calculators » Texas Instruments TINSPIRE » Manual Viewer

Texas Instruments TINSPIRE Teacher Software Guidebook - Page 563

Working with cells, Understanding cell references in formulas

View all Texas Instruments TINSPIRE manuals

Add to My Manuals
Save this manual to your list of manuals

Page 563 highlights

Working with cells Working with color The Lists & Spreadsheet application displays black text and cells with a white background by default. You can change the color of cells and text to emphasize or distinguish data. The colors and the order in which color is assigned is based on the TI-Nspire™ color palette. See Changing the color of cells and Changing the color of text for more details. Color changes made in the software display in shades of gray when you work on documents on the TI-Nspire™ handheld. Color is preserved when you move documents back to the software. Changing the fill color of cells 1. Select the cells to fill with color. You can choose one or more cells in any adjacent cells, columns, or rows. 2. Access the context menu and choose Color > Fill Color. 3. Select the color to apply to the cells. The color of the selected cells changes. Note: If you combine color text and color cells, choose colors carefully to ensure visibility as you work with documents in the software and on the handheld. Changing the color of text 1. Select the cells that contain the text to change. You can choose one or more cells in any adjacent cells, columns, or rows. 2. Access the context menu and choose Color > Text Color. 3. Select the color to apply to the text. Empty cells in the selection area will show the color change when text is added. Understanding cell references in formulas Use a cell reference to use data from a cell or range of cells in a formula. The calculation results update automatically when values in cells change. Relative references include only the cell's column letter and row number (for example, E7). A relative reference describes where a cell is in relation to other cells of the spreadsheet. The Lists & Spreadsheet application keeps track of relative cell references and adjusts the reference automatically when surrounding cells shift (because of actions you perform, such as column deletions or cell insertions). Follow these guidelines to specify cell references: • Include a column letter and row number in a relative reference. Using Lists & Spreadsheet 551

Section	Page
Important Information	2
License	2
Setting up the TI-Nspire™ Navigator™ Teacher Software	13
Unpacking the boxes	14
Charging the cradles	17
Checking the LEDs	17
Installing the handheld software	18
Setting up your TI-Nspire™ Navigator™ network the first time	20
Before you begin	20
Connecting the cables to the access point	21
Checking the access point LEDS	22
Starting the wizard	22
Removing adapters or cradles from an existing network	26
Connecting the handhelds to the wireless adapters	26
Connecting the handhelds to the cradles	28
Storing the wireless adapters and cradles	30
Checking the status of wireless adapters and cradles	30
Identifying selected cradles	31
Now that you know where the non-working cradles are, you can add the cradles to the network again.	32
Cradle LEDs	32
Creating and managing your teacher account	32
Creating your teacher account	33
Changing the password of your teacher account	34
Changing the user name of your teacher account	35
Logging in to the TI-Nspire™ Navigator™ system from the handheld	36
Logging in to the TI-Nspire™ Navigator™ network	36
TI-Nspire™ handheld login status icons	37
Getting started with the TI-Nspire™ Navigator™ Teacher Software	39
Navigating through the Welcome Screen icons	40
Opening the Welcome Screen manually	41
Exploring the TI-Nspire™ Navigator™ Teacher software	41
Understanding the status bar	42
Exploring workspaces	43
Changing language	43
Using help	44
Note: Aside from viewing your current software version, you must be connected to the Internet to perform any of these tasks. You do not need to be connected to the Internet to view your current version of software as shown in the About command.	45
Using the Content Workspace	47
Understanding the status bar	48
Exploring the Resources pane	49
Exploring the Content pane	50
Using the content pane tool bar	51
Using the Preview pane	51
Using shortcuts	53
Working with Links	53
Using the Links toolbar	53
Adding a link	54
Editing an existing link	55
Removing a link	55
Moving links up or down in the list	55
Using Web Content	56
Sorting the list of activities	57
Filtering the list of activities	57
Using keywords to search for an activity	57
Opening an activity	58
Saving an activity to your computer	58
Copying an activity	59
Sending an activity to a connected handheld	59
Working with connected handhelds	60
Viewing content on connected handhelds	61
Using Identify Selected to locate handhelds	63
Performing tasks on connected handhelds	63
Managing files on a connected handheld	63
Renaming handhelds	65
Working with lesson bundles	65
Creating a new lesson bundle	66
Adding files to a lesson bundle	66
Opening a lesson bundle	69
Managing files in a lesson bundle	70
Managing lesson bundles	71
Packaging lesson bundles	72
E-mailing a lesson bundle	73
Sending files to a class	73
Understanding the rules of content transfer	74
Types of content you can transfer	74
Methods you can use to transfer content	75
Using menus and toolbar icons	75
Using the Transfer Tool	85
Transfer Tool interface	85
Setup tab	85
Status tab	87
Opening the Transfer Tool	87
Adding files or folders to the Transfer List	88
Removing files or folders from the Transfer List	89
Editing the destination folder	90
Deleting all handheld files and folders	91
Starting a transfer	92
Stopping file transfers	93
Closing the Transfer Tool	93
Using the Documents Workspace	95
Using the Documents Toolbox	96
Exploring the Tool Palette	97
Exploring the Page Sorter Panel	99
Exploring the TI-SmartView™ Panel	99
Exploring the Utilities panel	101
Exploring the Content Explorer panel	102
Using the workspace	104
Understanding the status bar	105
Viewing and changing document settings	106
Changing General settings	106
Changing Graphs & Geometry settings	108
Sending files to a class	110
Sending files to a handheld	111
Working with Lesson Bundles	112
Creating a new lesson bundle	112
Adding files to a lesson bundle	112
Opening a lesson bundle	114
Managing files in lesson bundles	115
Packaging lesson bundles	115
E-mailing a lesson bundle	116
Managing lesson bundles	116
Sending lesson bundles to connected handhelds	117
Updating the handheld OS	117
Using menus and toolbar icons	118
Working with TI-Nspire™ documents	131
About documents	131
TI-Nspire™ documents	131
PublishView™ documents	131
Managing TI-Nspire™ documents	132
Creating a new TI-Nspire™ document	132
Saving TI-Nspire™ documents	133
Saving a document with a new name	133
Opening an existing document	134
Using Content Explorer to locate files	134
Opening Content Explorer	134
Understanding which files and folders you can transfer	136
Saving a document to a connected handheld	136
Opening handheld documents in the software	137
Saving handheld documents in the software	138
Copying supported files and folders	138
Working with multiple documents	139
Working with multiple documents in tiled view	139
Closing documents	140
Working with applications	140
Opening Document Tools	141
Opening context menus	142
Working with multiple applications in a page	143
Adding multiple applications to a page	143
Swapping applications	144
Selecting and moving pages with the Page Sorter	144
Selecting pages	145
Grouping applications	146
Deleting an application from a page	146
Deleting pages	146
Working with problems and pages	146
Adding a problem to a document	146
Adding a page to a problem	147
Copying, pasting, and deleting problems	147
Renaming a problem	147
Using Utilities in documents	148
Inserting items from the Utilities pane	151
Using wizards	151
Using colors in documents	152
Adding color from a list	152
Adding color from a palette	152
Using Screen Capture	153
Capturing a page	153
Saving captured pages	155
Printing documents	155
Using print preview	156
Viewing document properties and copyright information	156
Viewing copyright information	156
Protecting a document (making a document read-only)	157
Adding copyright information to a document	157
Capturing Screens	159
Accessing Screen Capture	159
Using Capture Class	160
Capturing student handheld screens	160
Using the Class Capture window menus and tool bar	162
Setting Teacher Preferences for Capture Class	164
Setting view options in Capture Class	165
Toggling between Tiled and Gallery views	165
Rearranging captured screens	166
Refreshing captured screens	167
Using zoom in and zoom out	168
Comparing selected screens	169
Using Make Presenter	169
Saving screens when using Capture Class	170
Saving screen images	170
Printing captured screens	171
Using Capture Page	172
Capturing a page	172
Using Capture Selected Handheld	173
Viewing captured screens	174
Using the Screen Capture window menu and tool bar	175
Zooming the view of captured screens	176
Saving captured pages and handheld screens	177
Saving selected screens	177
Saving multiple screens	178
Copying and pasting a screen	178
Copying a screen	179
Pasting a screen	179
Working with Images	181
TI-Nspire™ applications that can accept images	181
Example applications using images	182
Image types available	183
Inserting the image	183
Using the Insert command	184
Using Clipboard	185
Working with images	186
Selecting the image	186
Moving an image	187
Resizing image	187
Deleting the image	187
Technical considerations	188
Working with PublishView™ documents	189
Software requirements	189
Creating a new PublishView™ document	190
About PublishView™ documents	191
Exploring a PublishView™ document	192
Using the status bar in a PublishView™ document	194
Saving PublishView™ documents	195
Saving a new document	195
Saving a document with a new name	195
Exploring the Documents workspace	196
Exploring the Documents Toolbox	196
Using menus and the toolbar	198
Using context menus	199
Working with PublishView™ objects	200
Inserting an object	201
Opening object context menus	202
Resizing an object	202
Moving an object	203
Overlapping objects	204
Deleting an object	204
Choosing a working folder for PublishView™ objects	205
Working with TI-Nspire™ applications	206
Adding an application to a problem	206
Adding existing TI-Nspire™ documents	208
Working with problems	210
Adding a problem	210
Managing problem breaks	211
Hiding and showing problem breaks	211
Renaming a problem	211
Deleting a problem	211
Organizing PublishView™ sheets	212
Adding sheets to a problem	212
Opening the sheet context menu	212
Page numbering	212
Working with headers and footers	213
Showing and hiding borders	214
Adding and removing space	214
Deleting blank sheets from problems	217
Adding text to a PublishView™ document	217
Inserting text into a text box	217
Formatting and editing text	219
Launching edit mode	219
Opening the content context menu	219
Using hyperlinks in PublishView™ documents	219
Linking to a file	220
Linking to a web site	222
Editing a hyperlink	222
Converting existing text to a hyperlink	223
Removing a hyperlink	223
Working with images	224
Inserting an image	224
Moving images	225
Resizing images	226
Deleting images	226
Working with video files	226
Inserting a video	226
Using the video console	227
Using the video context menu	228
Adjusting Adobe® Flash® Player settings	228
Converting documents	228
Converting PublishView™ documents to TI-Nspire documents	229
Converting TI-Nspire™ documents to PublishView™ documents	230
Printing PublishView™ documents	231
Embedding documents in web pages	233
Using embedded web pages	233
Viewing embedded web pages	233
Using TI-Nspire™ HTML Inline Frames	234
Iframe tags and attributes	235
Using the Source (src) attribute	235
Defining the nspirefile parameter	235
Using other iframe attributes	236
Using dynamically-generated iframes	237
Using the TI-Nspire™ Document Player	238
Exporting to a web page	238
Exploring the web page	240
Customizing an embedded TI-Nspire™ Document Player	241
Using Export to generate source code	245
Export options	245
Viewing the source code	245
Exporting to the clipboard	250
Editing the code snippet	250
Storing and sharing your documents	251
Storing documents to be shared online	251
Modifying the parameter	252
Storing and sharing files offline	254
Launching a dedicated TI-Nspire™ Document Player window	254
Using the Class Workspace	257
Understanding the status bar	258
Adding classes	258
Adding a class	258
Importing students	259
Removing classes	261
Removing a class	261
Adding students to classes	261
Removing students from classes	263
Beginning and ending a class session	264
Beginning a class session	264
Pausing a class session	264
Ending a class session	264
Changing the student view	265
Changing the class view to Student List	265
Changing the class view to Seating Chart	265
Arranging the seating chart	266
Arranging students in the seating chart	266
Checking student login status	266
Sorting student information	267
Sorting student information	267
Changing the classes assigned to a student	267
Changing a student’s class	267
Changing student names and identifiers	269
Changing a student’s names or identifiers	269
Moving students to another class	270
Moving a student to another class	270
Copying students to another class	271
Copying a student to another class	271
Exploring the Class Record	272
Sending files to a class	273
Collecting files from students	275
Collecting files from the Class Record	275
Collecting files from the menu or icon	276
Managing Unprompted actions	277
Reviewing and opening Unprompted actions	278
Viewing items in an Unprompted action	278
Removing individual items from an Unprompted action	278
Removing an entire Unprompted action	279
Exporting Unprompted action items	279
Saving files to a Portfolio record	279
Deleting files from handhelds	280
Checking the status of file transfers	281
Canceling file transfers	282
Deleting items from the Class Record	282
Viewing file properties	283
Resetting student passwords	283
Resetting passwords for all students in a class	283
Resetting passwords for individual students	284
Using menus and toolbar icons	285
Using Live Presenter	293
Before starting Live Presenter	293
Starting Live Presenter	293
Starting Live Presenter from Class Screen Capture window	293
Exploring Live Presenter mode	294
Hiding and showing student names	296
Hiding and showing the presenter handheld	297
Hiding the handheld display	297
Showing the handheld	298
Viewing Keypress History	298
Hiding Keypress History	299
Showing Keypress History	299
Copying Keypress History	299
Clearing Keypress History	300
Showing the handheld screen only	300
Recording the live presentation	301
Starting the recording	301
Stopping and saving the recording	301
Playing and sharing the recording	302
Stopping Live Presenter	302
Using Question in the Teacher Software	303
Understanding the Question Tool Palette	303
Understanding the configuration tool	304
Adding configuration options	304
Using the Teacher Tool Palette	305
Adding images to questions	306
Image types available	306
Adding images using the Insert command	307
Adding images using the clipboard	307
Adding questions	307
Adding a custom multiple choice question	308
Adding an open response question	310
Adding an equation question	311
Adding an (x,y) numerical input question	313
Adding a drop points question	314
Adding a lists question	316
Using Question for Students	317
Accessing the Question Toolbar	317
Understanding the Question toolbar	317
Navigating in the Question application	318
Types of questions	318
Answering questions	319
Checking your Answer	319
Multiple Choice	320
Open Response	321
Equation	321
Coordinate Points, Drop Points, and and List	323
Polling students	327
Opening the Quick Poll tool	328
Sending a Quick Poll	330
Using the Quick Poll menu	330
Stopping polls	330
Saving polls	331
Viewing poll results	331
Responding to polls (student instruction)	333
Navigating the handheld in a Quick Poll question	333
Responding to Quick Poll questions	333
Clearing your answers	335
Submitting Quick Poll responses	335
Using the Review Workspace	337
Understanding the status bar	338
Using the Review toolbox	339
Exploring the Review tools	339
Exploring the Page sorter	340
Exploring the Student pane	341
Exploring the Data View pane	344
Understanding the Data View	344
Opening documents for review	347
Opening a document from the Class workspace	347
Opening a document from the Portfolio workspace	348
Viewing data	349
Viewing data from the Student pane	349
Viewing data from the Data View pane	349
Organizing responses	351
Configuring a plot list	351
Individualizing student responses	352
Organizing list data	353
Organizing bar chart data	353
Organizing by equivalency	355
Hiding and showing responses	355
Hiding responses from the Student pane	356
Hiding responses from the Data View pane	357
Showing responses	358
Marking responses as correct or incorrect	359
Adding teacher data	363
Adding teacher points	364
Adding teacher equations	365
Saving to the Portfolio workspace	366
Using menus and toolbar icons	367
Using the Portfolio Workspace	375
Understanding the status bar	376
Exploring the Assignments pane	376
Exploring the Workspace views	377
Assignments Summary View	377
Individual Assignment View	378
Saving an item to the Portfolio workspace	379
Importing an item to Portfolio	380
Editing scores	381
Changing a student’s score for an item	381
Changing the total possible points for a question	382
Changing the final percentage score	382
Exporting results	383
Sorting information in Portfolio	383
Opening a Portfolio item in another workspace	384
Opening an item in the Documents workspace	384
Opening an item in the Review workspace	384
Opening a Master Document	385
Adding a Master Document	385
Redistributing a Portfolio item	386
Collecting missing files from students	386
Sending missing files to students	387
Renaming a Portfolio item	387
Removing files from Portfolio	387
Using menus and toolbar icons	388
Using the Scratchpad	395
Opening and closing the Scratchpad	395
Calculating with the Scratchpad	396
Entering simple math expressions	396
Inserting items from the Catalog	397
Using an expression template	398
Inserting expressions using a wizard	399
Viewing the history	401
Copying a history item to the entry line	402
Clearing the history	402
Editing Scratchpad expressions	402
Inserting elements into the entry line	402
Selecting part of an expression	402
Graphing with the Scratchpad	403
Viewing the function table	404
Changing the appearance of the axes	404
Tracing a graphed function	405
Finding points of interest	406
Working with variables in the Scratchpad	407
Saving the Scratchpad contents	408
Clearing Scratchpad contents	408
Calculator	409
Getting started with the Calculator application	409
Calculator menu	410
Entering and evaluating math expressions	416
Entering simple math expressions	416
Controlling the form of a result	416
Inserting items from the Catalog	417
Using an expression template	419
Creating matrices	419
Inserting a row or column into a matrix	420
Inserting expressions using a wizard	420
Creating a piecewise function	422
Creating a system of equations	423
Deferring evaluation	423
Working with variables	423
CAS: Working with measurement units	424
CAS: Converting between measurement units	424
CAS: Creating a user-defined unit	425
Creating user-defined functions and programs	426
Defining a single-line function	426
Defining a multiple-line function using templates	426
Defining a multiple-line function manually	428
Defining a program	428
Recalling a function or program definition	430
Editing Calculator expressions	430

Match case Limit results 1 per page

Using Lists & Spreadsheet

551

Working

with cells

Working with color

The Lists & Spreadsheet application displays black text and cells with a

white background by default. You can change the color of cells and text

to emphasize or distinguish data. The colors and the order in which color

is assigned is based on the TI-Nspire™ color palette. See

Changing the

color of cells

and

Changing the color of text

for more details.

Color changes made in the software display in shades of gray when you

work on documents on the TI-Nspire™ handheld. Color is preserved

when you move documents back to the software.

Changing the fill color of cells

Select the cells to fill with color. You can choose one or more cells in

any adjacent cells, columns, or rows.

Access the context menu and choose

Color > Fill Color

Select the color to apply to the cells. The color of the selected cells

changes.

Note:

If you combine color text and color cells, choose colors carefully to

ensure visibility as you work with documents in the software and on the

handheld.

Changing the color of text

Select the cells that contain the text to change. You can choose one or

more cells in any adjacent cells, columns, or rows.

Access the context menu and choose

Color > Text Color

Select the color to apply to the text. Empty cells in the selection area

will show the color change when text is added.

Understanding cell references in formulas

Use a cell reference to use data from a cell or range of cells in a formula.

The calculation results update automatically when values in cells change.

Relative references include only the cell’s column letter and row number

(for example, E7). A relative reference describes where a cell is in relation

to other cells of the spreadsheet. The Lists & Spreadsheet application

keeps track of relative cell references and adjusts the reference

automatically when surrounding cells shift (because of actions you

perform, such as column deletions or cell insertions).

Follow these guidelines to specify cell references:

•

Include a column letter and row number in a relative reference.