Chapter 02 – Competing with Information Technology
2-9
ANSWERS TO ANALYSIS EXERCISES
1. End-User Computing: Skill Assessment
Note that students tend to overestimate their computing skills when self-reporting.
a. Word processing: About how many words per minute can you type? Do you use styles to manage
document formatting? Have you ever set up your own mail merge template and data source? Have
you created your own macros to handle repetitive tasks? Have you ever added branching or looping
logic in your macro programs?
Most students feel they are competent at word processing if they can type, save, and print their papers.
b. Spreadsheets: Do you know the order of operations your spreadsheet program uses (what does
“_5*2^2– 10” equal)? Do you know how to automatically sort data in a spreadsheet? Do you know
how to create graphs and charts from spreadsheet data? Can you build pivot tables from spreadsheet
data? Do you know the difference between a relative and a fixed cell reference? Do you know how to
use functions in your spreadsheet equations? Do you know how to use the IF function? Have you
created your own macros to handle repetitive tasks? Have you ever added branching or looping logic
in your macro programs?
Students should be able to calculate the answer to the equation provided without programming it into a
c. Presentations: Have you ever used presentation software to create presentation outlines? Have you
added your own multimedia content to a presentation? Do you know how to add charts and graphs
from spreadsheet software into your presentations so that they automatically update when the
spreadsheet data change?
Students should be able to prepare presentation outlines that include graphics imported from or linked
d. Database: Have you ever imported data into a database from a text file? Have you ever written
queries to sort or filter data stored in a database table? Have you built reports to format your data
for output? Have you built forms to aid in manual data entry? Have you built functions or programs
to manipulate data stored in database tables?
Most students will have very little database experience. Yet, managers can take great advantage of a