Index
A
Add Text
32, 111, 102, 134, 178
Affordance, definition
44
Alignment tab
44, 47, 111, 172
All Contacts Toolbar
167, 167, 167, 167
Annotation area
communications needs
167
creation
177–184
disadvantages
168
hyperlinks
180–182
uses
168
Assumption, definition
102
Audience, definition
102
AutoShapes tool
102, 125–126, 128–130, 140, 178, 193, 155
B
Background
special background application
155
texture specification
155
tiling prevention
155, 155
Basic page worksheet template
155
Basic Shapes
111, 125–126, 128–130, 178
Bolding, text
25
Border tab
29, 57, 59, 67, 56
Boxes and buttons worksheet
creation in template
56–63
iteration of prototype
155, 159
tab
25, 27
Brightness, Formatting toolbar
123
Business requirements document (BRD)
123
C
Canvas
creation for prototyping
gridline hiding
40–41
overview
39
preparation
39
row and column dimension setting
42–43
definition
97
storyboard prototyping
97
worksheet tab
22–23
Case studies, prototyping with Excel
5–6, 94, 122–123
Cell
color selection
45, 49
insertion and deletion
42–215
width setting
42
Cell Reference
145
Center Text
61, 69
Characteristics, definition
128
Circle
128
Clear Grid
196
Click-through interaction, creation
196
Collaboration, prototypes
187–188
Color key
definition
77
worksheet
77–78
Colors and Lines tab
175
Column
dimension setting in canvas
42–43
header hiding
199–200
width setting
27
Combo box
adding to prototype
27–29
creation in template
57–58, 64–65
Comment insertion
communications needs
167
disadvantages
168
formatting
175
Insert Comment Command
174
red triangle indicator
174
Reviewing toolbar
175, 177
uses
168
Competing prototypes, risks in prototype sharing
190
Compress Pictures, Formatting toolbar
112
Connectors, adding between boxes in wireframe prototype
112–114
Contacts, group box creation
160
Content, definition
76
Contrast, Formatting toolbar
76
Copy Colors From
76–77, 23
Crop, Formatting toolbar
23
Ctr-C, copy command
23, 23
Ctr-D, duplicate command
161, 163
Ctr-V, paste command
23, 66
Ctr-Y
increase table size
6
redo command
6
Ctr-Z, undo command
6, 74
Custom colors
74–76, 135
D
Design guidelines, definition
135
Design iteration
seeIteration, prototype
Digital interactive prototype
creation
135–139
drop-down menu creation
139–145
overview
12–13, 121
principles
122
requirements, gathering and verifying
123–124
samples
147
scenario example
122–123
screen flow diagram creation
124–135
thumbnail creation
125–133
uses
121
Drag-and-drop shortcuts
aligning elements on a page
30–219
overview
30–217
Drag-fill shortcuts
applying
30–221
patterns
30–222
Draw menu
30
Drawing toolbar
30, 102, 125, 133, 139–211, 139
Dreamweaver
139
Drop-down menu, creation
139–145
E
E-commerce site
see alsoDigital interactive prototype
interface built in Excel
20
Edit Text
126–127
Elbow Arrow Connector
112–113
Engineering, risks in prototype implementation
190
F
Fidelity
definition
192
level and risk mitigation in prototype sharing
192–193
Files of type menu
201–202
Fill Color
130
Fill Effects
178
Fill Transparency
178
Flip, Draw menu
44
Font tab
44, 48, 31
Format AutoShape dialog box
31–32, 102, 111, 129–130, 132, 140, 142, 178, 194, 24
Format Cells dialog box
24, 29, 44, 45, 57, 59–60, 65, 67, 98, 172–173, 175, 175
Format Comment
175
Formatting toolbar
62, 99, 123–225
Functional requirements document (FRD)
123
G
Google calendar, interface built in Excel
20
Graphics
see alsoImage library
Draw menu
51
examples
51–52
findings
53
Formatting toolbar
125–225
importing from another application
125
screen capture
97
selecting objects
54
template addition
54–56
widgets versus graphics
53–54
Greeking, definition
40
Gridlines, hiding in canvas
40–41, 143
Grouping, shapes
133–135, 23
H
Header, adding to prototype
23–24
HTML, saving Excel documents as
201–202, 180–213
Hyperlinking
annotation areas
180–182
digital interactive prototype
137–138, 143
Hyperlink dialog box
114
ScreenTip annotation
seeTooltip
site map wireframe prototype
114–115
I
Image library
tab
23, 31
worksheet
51–56
Images
seeGraphics
Insert Comment
seeComment insertion
Insert dialog box
114
Insert Hyperlink dialog box
114, 139, 143, 170–171, 181
Insert Picture from File icon
54–55, 125
Interaction flow diagram, example
8
Interaction methods, denoting in prototype sharing
196–198
Interactive prototype
seeDigital interactive prototype
Iteration, prototype
preparing for design iteration
151–152
wireframe prototype iterations
final wireframe
164
simple wireframe
153–154
updated wireframe with design team feedback
157, 159–163
wireframe with some details
154–157
L
Layers, Excel
44
Line Color
130, 194–195
Line style, Formatting toolbar
57, 61, 21
Link to
21
Longevity, definition
21
M
Management dashboard, prototype
21
Merge Cells
172–173
Misunderstanding, risks in prototype sharing
191
Mock up, definition
70
Modify button
70
More AutoShapes
125
Move or Copy function
54
MS Office
95
N
Narrative
definition
95
writing
95–96
Navigational links, addition to storyboard prototype
105–107
Nevin, experience with prototyping in Excel
13–229
No Line
13, 130, 194–195
Nonfunctional links, denoting in prototype sharing
198–199
O
Order, Draw menu
142, 190, 190
Outdated prototypes, risks in prototype sharing
190–191
Outline, border
29–30
P
Page attributes
backgrounds
26–207
default color
26
default font
26
entire worksheet selection
26
table cell orientation
26
text only cell content
26
Page navigation, adding to prototype
26
Paper prototype
overview
10, 12
sketch
19, 22
Patterns tab
24, 45–46, 60, 65, 98, 31, 31
Picture, Formatting toolbar
31
Placeholder creation
descriptive text
31, 33
drawing
30–31
promotional information area
31–33
Place in this Document
137, 180, 199
Presentation
improvement in prototypes
199–202
scroll bar use
188
storyboard prototype
104–107
Product manager, definition
7
Prototyper, definition
7
Prototypes
definition
7
Excel
advantages
7, 13–15, 35
templates and productivity
15–16
user types
15
types, see also specific types
digital interactive prototype
12–13
paper
10, 12
storyboard
8–9
wireframe
9–11
Prototyping, definition
30
R
Rapid prototyping
copying and pasting
30–223
definition
30
Rectangle
30, 102, 126, 129–130, 140, 178, 193
Regroup command
134, 22
Requirement, definition
175
Reviewing toolbar
175, 177
Rotate, Draw menu
42
Rotate Left, Formatting toolbar
42
Row
dimension setting in canvas
42–43
header hiding
199–200
height in tables
84–85, 100, 201
S
Save As dialog box
201–202
Scenario, definition
97
Screen capture, images
97
ScreenTip
seeTooltip
Scroll bar
188
Search, functionality adding to prototype
25–26
Select Object
133, 142
Send Backward
142, 144
Send to Back
143
Set Transparent Color, Formatting toolbar
133
Shapes
filling
patterns
133
text
133
grouping
133–135, 187
insertion
187–211
ordering
187
Sharing prototypes
collaboration
187–188
evaluation
188–189
presentation
188
risks
competing prototypes
190
engineering implementation
190
misunderstanding and misinterpretation
191
mitigation
denoting functional versus nonfunctional links
198–199
denoting interaction methods
196–198d
fidelity level setting
192–193
improving prototype appearance and presentation
199–202
summary worksheet
192
visual emphasis
193–196
outdated prototypes
190–191
overview
189
Sheet tabs setting
199
Shift cells right
21, 21
Size, Formatting toolbar
21
Snap, Draw menu
21
Sports Website, wireframe prototype
21
Spreadsheet programs, types for prototyping
34
Starter worksheet
86–87
Storyboard, definition
97
Storyboard prototype
canvas
97–98
example scenario
94
header creation
98–100
narrative writing
95–96
navigational link addition
105–107
overview
8–9, 91–94
presentation
104–107
screen capture of images
97
template adaptation
97–98
text box creation
102–104
types
91–93
wireframe image placement in worksheet
100–102
Summary worksheet, risk mitigation in prototype sharing
192
T
Table cell, formatting
79–210
Table template worksheet
79–86
Tabs
coloring
197–198
hiding
201
naming
196–197
selection with Shift key
63
Tabs worksheet, template creation
63, 65–70
Technical requirements document (TRD)
124
Templates
adapting
22–23
creation
boxes and buttons
56–63
color key and palette
77
color key worksheet
77–78
color management
70–75
image library and graphics addition
51–56
starter worksheet
86–87
table template worksheet
79–86
tabs worksheet
63, 65–70
tips and tricks worksheet
77–79
definition
22
downloading
22, 36
productivity enhancement
15–16, 51
wireframe prototype
117–119
Thumbnail
creation in Excel
125–132
definition
77
Tips and tricks worksheet
77–79
Toolbars, hiding
199–200
Tooltip
communications needs
167
disadvantages
168
ScreenTip annotation creation
169–172
uses
168
Translucent overlay, creation for visual emphasis
193–196
U
Underline
155
Ungroup command
134, 104
V
View
104
Visual emphasis, risk mitigation in prototype sharing
193–196
W
Web Page, saving Excel document as
201–202, 53–213
Widget
definition
53
versus graphics
53–54
Wireframe prototype
definition
115
detailed versus skeletal wireframes
115–117
iterations
final wireframe
164
simple wireframe
153–154
updated wireframe with design team feedback
157, 159–163
wireframe with some details
154–157
overview
9–11, 21, 109–110
site map
definition
110
function
110
hyperlinking
114–115
wireframe box creation
111–114
template worksheets
117–119
Workbook, definition
167
Worksheet, definition
167
Worksheet for communication
communications needs
167
disadvantages
169
uses
169
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
13.58.132.97