Voice Recognition With Software Applications: Excel Script

Voice Recognition With Software Applications

Script to Construct an Excel 2000 Worksheet
Using Dragon NaturallySpeaking 5.0

Excel Worksheet Application 1

For this first application you will use the script shown below to dictate and use voice commands to construct the following Excel 2000 worksheet. You will use the popular voice-recognition program, Dragon NaturallySpeaking 5.0. Print these instructions and review them carefully before beginning the dictation.

Creating a worksheet using Dragon NaturallySpeaking 5.0 requires your using different strategies than when you use Dragon NaturallySpeaking 5.0 to create a document that will be moved to a word processor. Use the following techniques to correct errors as you create your worksheet using dictation, keyboard commands, and menu commands.

1. If you are dictating text or numbers into a cell and you make a dictation error, say "Scratch that." If the program does not respond to "Scratch that," tell the program to "Backspace X," where X represents the number of spaces you wish to backspace. You need not provide the exact number; you may exaggerate and request the program to backspace more spaces than needed in order to remove all the dictation. You may also say, "Press escape key," to remove everything from the cell and return to the ready mode.

2. If you are dictating text into a cell and the program misunderstands you, say "Correct that." If the program does not respond to "Correct that," tell the program to "Backspace X," where X represents the number of spaces you wish to backspace. Again, you need not provide the exact number; you may exaggerate and request the program to backspace more spaces than needed in order to remove all the dictation. You may also say, "Press escape key," to remove everything from the cell and return to the ready mode.

3. If you are dictating numbers into a cell and either you or the program makes an error, say "Scratch that." Do not attempt to use the "Correct that" command. If the program does not respond to "Scratch that," use the "Press escape key" command.

4. If you dictate a keyboard command and the program enters the command as text in a cell, do not say "Scratch that" or "Correct that." You will lose any entered text, numbers, or formula that the cell occupies. Instead, you must say, "Press escape key" as many times as needed to restore the former contents of the cell.

5. If you consistently have difficulty navigating a menu dialog box because Excel does not respond to your voice commands, use your mouse to make the choice needed. The MouseGrid feature of Dragon NaturallySpeaking 5.0 will not be used in this exercise.

Access your Excel 2000 program. Dictate the following voice commands exactly as shown in the script. Do not dictate the word pause shown in angle brackets <pause>. Instead, pause briefly before dictating the next word or group of words.

Action		Voice (or Mouse) Commands	Result
1		Open a new Excel workbook.
2	Say	Press control-key alpha	Selects the entire worksheet
3	Say	Click format <pause> click cells <pause> click number
4	Use mouse	Click on Accounting
5	Say	Press Alt-Delta <pause> zero <pause> press Alt-Sierra <pause> move up 1 <pause> press enter key <pause> click OK <pause> press down arrow <pause> press up arrow	Formats numbers with zero decimal places Formats numbers above 999 with commas Unselects worksheet
6	Say	Press control-key bravo <pause> click format <pause> click cells <pause> click font <pause> click size <pause> 12 <pause> click OK	Formats font in Arial 12 Bold
7	Say	cap-star <pause> hyphen <pause> cap-bean <pause> cap-coffee <pause> cap-house <pause> press right arrow	Enters name of company in first cell
8	Say	Move right 4 <pause> press shift-home key	Selects the first six cells in Row 1
9	Say	Click format <pause> click cells <pause> click alignment <pause> click merge cells <pause> press Alt-hotel <pause> click center <pause> press enter key <pause> click OK <pause> press down arrow	Centers first line of title across the six selected cells
10	Say	Press control-key bravo <pause> click format <pause> click cells <pause> click font <pause> click size <pause> 11 <pause> click OK	Formats font in Arial 11 Bold
11	Say	cap-north <pause> space <pause> cap-valley <pause> cap-sales <pause> press right arrow	Enters content of worksheet in Cell A2
12	Say	Move right 4 <pause> press shift-home key	Selects the first six cells in Row 2
13	Say	Click format <pause> click cells <pause> click alignment <pause> click merge cells <pause> press Alt-hotel <pause> click center <pause> press enter key <pause> click OK <pause> press down arrow	Centers the second line of the title across the six selected cells
14	Say	Press control-key bravo	Bolds font
15	Say	apostrophe <pause> January <pause> 2000 <pause> press right arrow	Enters the time period covered in Cell A3
16	Say	Move right 4 <pause> press shift-home key	Selects the first six cells in Row 3
17	Say	Click format <pause> click cells <pause> click alignment <pause> click merge cells <pause> press Alt-hotel <pause> click center <pause> press enter key <pause> click OK <pause> move down 2	Centers the third line of the title across the six selected cells
18	Say	Cap-store <pause> press right arrow	Enters column heading
19	Say	Cap-beverages <pause> press right arrow	Enters column heading
20	Say	Cap-bakery <pause> space <pause> and <pause> cap-candy <pause> press right arrow	Enters column heading
21	Say	Cap-coffees <pause> press right arrow	Enters column heading
22	Say	Cap-accessories <pause> press right arrow	Enters column heading
23	Say	Cap-totals <pause> press right arrow <pause> move left 1	Enters column heading and moves cursor to beginning of row
24	Say	press shift-home key	Selects the first six cells in Row 5
25	Say	Click format <pause> click column <pause> click width <pause> 12 <pause> click OK	Widens the columns
26	Say	Press control-key bravo	Bolds column headings
27	Say	Click format <pause> click cells <pause> click alignment <pause> click wrap text <pause> press Alt-victor <pause> click center <pause> press enter key <pause> press Alt-hotel <pause> click center <pause> press enter key <pause> click OK <pause> press down arrow	Centers and wraps column headings
28	Say	Cap-west <pause> space <pause> cap-hills <pause> press right arrow	Enters West Hills
29	Say	Twelve thousand three hundred eighty-nine <pause> press right arrow	Enters 12,389
30	Say	Four thousand two hundred twelve <pause> press right arrow	Enters 4,212
31	Say	Six thousand nine hundred twenty-one <pause> press right arrow	Enters 6,921
32	Say	Two thousand four hundred eighty-three <pause> press down arrow <pause> move left 4	Enters 2,483
33	Say	Cap-springfield <pause> press right arrow	Enters Springfield
34	Say	Nineteen thousand seven hundred eighty-five <pause> press right arrow	Enters 19,785
35	Say	Ten thousand six hundred eighty-three <pause> press right arrow	Enters 10,683
36	Say	Thirteen thousand four hundred eighty-seven <pause> press right arrow	Enters 13,487
37	Say	Four thousand five hundred thirty-three <pause> press down arrow <pause> move left 4	Enters 4,533
38	Say	Cap-hillsdale <pause> press right arrow	Enters Hillsdale
39	Say	Fifteen thousand seven hundred nine <pause> press right arrow	Enters 15,709
40	Say	Six thousand three hundred twenty-eight <pause> press right arrow	Enters 6,328
41	Say	Seven thousand eight hundred ninety-three <pause> press right arrow	Enters 7,893
42	Say	Three thousand four hundred thirty-nine <pause> press down arrow <pause> move left 4	Enters 3,439
43	Say	Cap-mission <pause> space <pause> cap-hills <pause> press right arrow	Enters Mission Hills
44	Say	Eleven thousand five hundred <pause> press right arrow	Enters 11,500
45	Say	Five thousand one hundred forty <pause> press right arrow	Enters 5,140
46	Say	Five thousand two hundred ninety-seven <pause> press right arrow	Enters 5,297
47	Say	One thousand two hundred forty-three <pause> press down arrow <pause> move left 4	Enters 1,243
48	Say	Cap-totals <pause> press right arrow	Enters Totals
49	Say	Equal sign <pause> sum <pause> no space open parenthesis <pause> press bravo <pause> numeral 6 <pause> dot dot <pause> press bravo <pause> numeral 9 <pause> close parenthesis <pause> press right arrow <pause> press left arrow	=sum(b6..b9) Calculates sum for Column B
50	Say	Click format <pause> click cells <pause> click number
51	Use mouse	Click on Currency
52	Say	Press Alt-Delta <pause> zero <pause> press Alt-Sierra <pause> move down 1 <pause> press enter key <pause> click OK	Formats cell for currency with 0 decimals
53	Say	Press control-charlie	Issues the copy command in Cell B10
54	Say	Move right 1 <pause> press shift-right arrow <pause> press shift-right arrow <pause> press shift-right arrow	Selects the remaining cells in the totals row
55	Say	Paste that <pause> press right arrow <pause> move right 2 <pause> move up 4	Copies formula in B10 to selected cells and moves pointer to Cell F6
56	Say	Equal sign <pause> sum <pause> no space open parenthesis <pause> press bravo <pause> numeral 6 <pause> dot dot <pause> press echo <pause> numeral 6 <pause> close parenthesis <pause> press down arrow <pause> press up arrow	=sum(b6..e6) Calculates sum of Row 6
57	Say	Press control-charlie	Issues the copy command in Cell F6
58	Say	Move down 1 <pause> press shift-down arrow <pause> press shift-down arrow	Selects the remaining cells in the totals column
59	Say	Paste that <pause> press down arrow	Copies formula in F6 to selected cells
60	Use mouse	Double-click on sheet tab.	Selects sheet tab
61	Say	January <pause> 2000 <pause> cap-sales	Names sheet tab
62	Use mouse	Click into any cell in the worksheet
63	Say	Click file <pause> click save as <pause> cap-star <pause> hyphen <pause> cap-bean <pause> cap-coffee <pause> cap-house <pause> click save	Save the workbook
64	Say	Click file <pause> click page setup <pause> click margins <pause> click horizontally <pause> click print <pause> click OK	Center the worksheet horizontally on the page and print it
65	Say	Click file <pause> click save <pause> click file <pause> click exit	Save the print setting and exit Excel

Word Substitutes for Letters to Aid in Dictation and Spelling
For	Say	For	Say
A	Alpha	N	November
B	Bravo	O	Oscar
C	Charlie	P	Papa
D	Delta	Q	Québec
E	Echo	R	Romeo
F	Foxtrot	S	Sierra
G	Golf	T	Tango
H	Hotel	U	Uniform
I	India	V	Victor
J	Juliet	W	Whiskey
K	Kilo	X	X-ray
L	Lima	Y	Yankee
M	Mike	Z	Zulu