Getting Started | TechInAction | MyITLab | Syllabus | Lecture Outline | Assignments | Glossary | Home | Videos

Computer Literacy On-Line: Application Software

 

Word Processing

 

Mark Twain Goes for Broke

Mark Twain was the first author in history to submit a typewritten manuscript: The Adventures of Tom Sawyer. Twain later invested almost $200,000 (the equivalent of $1.5 million today) in the promising new Paige typesetting technology, convinced that it would transform publishing. Instead, Twain went bankrupt.

Linotypes dominated the industry until the 1960s, when electronic typesetting with mainframe computers took over. Now mainframe publishing systems are rapidly being displaced by personal computers.

 

THE WORD PROCESSING PROCESS

Working with any word processor involves several steps:

 

Entering Text

Because memory is not a permanent storage medium, it's important to regularly save your work&endash;that is, make a disk file containing your work in progress.

A flashing cursor (sometimes called an insertion bar) indicates your location in the document.

Because of a feature called word wrap, the word processor automatically transports any words that won't fit on the current line to the next line along with the cursor.

As you type, the topmost lines scroll out of view to make room on the screen for the new ones.

 

Editing Text

If you're working with a modern WYSIWYG (short for what you see is what you get, and pronounced "wizzy-wig") word processor, the arrangement of the words on the screen represents a close approximation of the arrangement of words on the printed page.

With a word processor you can easily

 

 

Cut-and-paste editing is possible in virtually all WYSIWYG word processors. You select text to be edited using the mouse or the keyboard. The selected text from the document is placed on the Clipboard&endash;a special portion of memory for temporarily holding information for later use.

To speed up the process of moving text within a document, many word processors include a drag-and-drop feature that allows you to simply drag (with the mouse) selected text to another part of the document.

The Replace command performs a search-and-replace operation, changing any or all of the target words to a different word.

The Undo command allows you to take back the last operation you performed.

 

Formatting Text

Text formatting commands allow you to control the format and style of the document.

 

Formatting Characters:

The format of the characters that you print is determined largely by your printer. Most modern printers can print text in a variety of point sizes, typefaces, and styles that aren't possible with typewriters.

Characters are traditionally measured by Point size, with one point equal to .72 inch.

In the language of typesetters, a font is a size and style of typeface. 

Serif fonts are embellished with serifs&endash;fine lines at the ends of the main strokes of each character.

Sans serif fonts, like those in the Helvetica family, have plainer, cleaner lines.

Proportionally spaced fonts allow more room for wide characters like w's than for narrow characters like i's.

 

Formatting Lines and Paragraphs:

Justification refers to the alignment of text on a line. Four justification choices are commonly available: left justification (with a smooth left margin and ragged right margin), right justification, full justification (both margins are smooth), and centered justification.

 

Formatting the Document:

Headers and footers are blocks that appear at the top and bottom of every page, displaying repetitive information like chapter titles, author names, and automatically calculated page numbers.

 

Rules of Thumb: Word Processing Is Not Typing

Here's a short list of new word processing habits to replace outmoded typing habits:

 

 

THE WORDSMITH'S TOOL BOX

A typical high-end word processor might include a built-in outliner, spelling checker, thesaurus, and indexer. But even word processors that don't include those features can be enhanced with stand-alone programs specifically designed to accomplish the same things.

Outliners and Idea Processors:

Idea processors take a variety of forms, but most are built around the concept of outlining. Most outliners are particularly effective at performing three functions:
  • Arranging information into levels, so that each heading can be fleshed out with more detailed subheads, which can then be broken into smaller pieces
  • Rearranging ideas and levels so that subideas are automatically moved with their parent ideas
  • Hiding and revealing levels of detail as needed, so that you can examine the forest, the trees, or an individual leaf of your project

Synonym Finders:

An on-line thesaurus puts synonyms at your fingertips.

Digital References:

Writers rely on a number of other reference books, including dictionaries, quotation books, encyclopedias, atlases, and almanacs. Most of these traditionally printed resources are now available in computer-readable form, too. The biggest advantage of the electronic form is speed; searching for subjects or words by computer is usually faster than thumbing through a book.

Many CD-ROM references take advantage of the massive disk capacity by including sounds, animation, video, and other forms of information that aren't possible in books. Multimedia references are discussed in more detail in Chapter 7. 

Spelling Checkers

Most spelling checkers offer several choices for each suspect word:
  • Replace the word with the suggested alternative.
  • Replace the word with another alternative typed by the user.
  • Leave the word alone (used when the word is spelled correctly, but it's not in the dictionary because it's an obscure word, a specialized term, or a proper name).
  • Leave the word alone and add it to the dictionary so that it won't be flagged next time (used when the word is spelled correctly, it's not in the dictionary, and it's a regular part of the user's written vocabulary).

The most common spelling checkers are batch spelling checkers; they check all of the words in your document in a batch when you issue the appropriate command.

Some people prefer interactive spelling checkers that check every word as it's typed, beeping or flashing each time a word is typed incorrectly.

When you're using a spelling checker, it's important to keep two potential problems in mind:

  • Dictionary limitations and errors
  • Errors of context

Grammar and Style Checkers:

Many errors that would slip by a spelling checker would be detected by a grammar and style checker. In addition to checking spelling, grammar and style checking software analyzes each word in context, checking for errors of context, common grammatical errors, and stylistic foibles. In addition to pointing out possible errors and suggesting improvements, it can analyze prose complexity using measurements.

Form Letter Generators:

Most word processors today have mail merge capabilities for producing personalized form letters. When used with a database containing a list of names and addresses, a word processor can quickly generate individually addressed letters and mailing labels. The uses and abuses of this kind of technology are discussed in Chapter 8.

 

THE DESKTOP PUBLISHING STORY

Just as word processing changed the writer's craft in the 1970s, the world of publishing was radically transformed in the 1980s with the introduction of desktop publishing.

 

What Is Desktop Publishing?

The process of producing a book, magazine, or other publication includes several steps:

Businesses rely on desktop publishing technology to produce in-house newsletters, brochures, advertising materials, training manuals, periodicals, and books.

With modern desktop publishing (DTP) technology, the bulk of the publishing process can be accomplished with tools that are small, affordable, and easy to use. A desktop publishing system generally includes a computer with a graphical user interface, desktop publishing software, and a laser printer or other high-resolution printer.

Desktop publishers generally use standard word processors and graphics programs to produce most source documents. Scanners are used to transform photos and hand-drawn images into computer-readable documents. Page-layout software is used to combine the various source documents into a coherent, visually appealing publication.

You start the page-layout process by designing master pages that control the general layout and include common elements for all left- and right-facing pages.

Many desktop publishers who need typeset-quality output prefer to rely on outside service bureaus to print their final camera-ready pages&endash;ready to be photographed and printed.

Desktop publishing tools provide graphic designers with control over virtually every element of the design, right down to the spacing between each pair of letters (kerning) and the spacing between lines of text (leading).

For users without background in the elements of layout and design, most desktop publishing packages include templates&endash;professionally designed "empty" documents that can easily be adapted to specific user needs.

 

Rules of Thumb: Beyond DESKTOP TACKY!

While there's no substitute for a good education in the principles of design, it's easy to avoid tacky-looking documents if you follow a few simple guidelines:

 

Why Desktop Publishing?

The reasons desktop publishing has enjoyed such wide acceptance by businesses are:

Desktop publishing technology offers new hope for every individual's right to publish. The number of small presses and alternative, low-circulation periodicals is steadily increasing as publishing costs go down. If, as A. J. Liebling suggested, freedom of the press belongs to the person who owns one, that precious freedom is now accessible to more people than ever before.

 

TOMORROW'S WORD TOOLS

The End of Desktop Publishing Software?:

As word processors grow in sophistication, they absorb more and more of the features formerly available only in page-layout software. Of course, desktop publishing software is growing in sophistication, too, incorporating features essential to discriminating professionals.

Groupware for Writing and Editing:

Modern computer networks make it possible for many people to work together on the same set of computer documents using groupware&endash;software designed to be used by work groups rather than individuals.

Electronic Dictation

Speech-recognition software systems are now available at an affordable price (under $100 up to $1000 depending on features). Because of large memory requirements they require a pentium processor PC with 64 megabytes of memory. Thousands of speech recognition systems are sold every day. They are useful to persons who are blind or who cannot use their hands. Doctors, lawyers, and others who dictate their notes may find that they no longer need to pay a transcriptionist. Word processors that can reliably recognize human speech are almost certainly in your future. See Chapter 12 for more details.

 

Intelligent Word Processors

Some possible kinds of electronic writing consultants that might appear in a few years are:

 

SpreadSheets

 

Dan Bricklin and Mitch Kapor Count on Computers

In 1978 Harvard graduate student Dan Bricklin and MIT student Bob Frankston developed VisiCalc, the first computer spreadsheet program. Many analysts believe VisiCalc was responsible for the early success of the Apple II, and the desktop computer in general, in the business world.

After IBM introduced the IBM PC in 1981, one of the many VisiCalc-inspired spreadsheet programs competing for the software dollars of businesses was developed by Mitch Kapor. In 1983 Kapor's startup company, Lotus, released a powerful, easy-to-use integrated spreadsheet/graphics package called 1-2-3 that quickly established itself as the standard spreadsheet on IBM-compatible computers.

 

THE SPREADSHEET: SOFTWARE FOR SIMULATION AND SPECULATION

More than any other type of personal computer software, the spreadsheet has changed the way people do business. Spreadsheet software allows the user to take control of numbers, manipulating them in ways that would be difficult or impossible otherwise.

A spreadsheet program can make short work of tasks that involve repetitive calculations: budgeting, investment management, business projections, grade books, scientific simulations, checkbooks, and so on.

A spreadsheet can also reveal hidden relationships between numbers, taking much of the guesswork out of financial planning and speculation.

 

The Malleable Matrix

Almost all spreadsheet programs are based on a simple concept: the malleable matrix. A spreadsheet document, called a worksheet, typically appears on the screen as a grid of numbered rows and alphabetically lettered columns.

The box representing the intersection of a row and a column is called a cell. Every cell in this grid has a unique address made up of a row number and column letter.

Each cell can contain a numeric value, an alphabetic label, or a formula representing a relationship between numbers in other cells.

 

Values (numbers) are the raw material used by the spreadsheet software to perform calculations.

To make it easier for people to understand the numbers, most worksheets include labels at the top of columns and at the edge of rows.

To calculate the total points (or the average wind speed or the final approval rating) the worksheet must include a formula&endash;a step-by-step procedure for calculating the desired number.

 

Typing appears in the current or active cell&endash;the cell containing the cursor&endash;and in the long window above the worksheet, called the console or formula bar. You move from cell to cell by clicking with the mouse or by navigating with the keyboard.

A range of cells is a rectangular block of cells.

You can change the format of some cells to make the worksheet more readable. Spreadsheet software can automatically recalculate all formulas to reflect revised input data.

Popular spreadsheet programs have most or all of these features:

 

What If ? Questions

A spreadsheet program is a versatile tool, but it's especially valuable for answering "What if?" questions.

Some spreadsheet programs include equation solvers that turn "What if ?" questions around. Instead of forcing you to manipulate data values until formulas give you the numbers you're looking for, an equation solver allows you to define an equation, enter your target value, and watch while the computer determines the necessary data values.

 

Rules of Thumb: Avoiding Spreadsheet Pitfalls

When creating a worksheet, you can minimize errors by following a few basic guidelines:

 

Tomorrow's Spreadsheet?

Recent versions of 1-2-3 include user he]p functions that incorporate the kinds of multimedia technology described in Chapter 7. Excel and other spreadsheets are beginning to incorporate artificial intelligence technology (see Chapter 12) to guide users through complex procedures.

To help users check complex worksheets for consistency of entries and formula logic, future spreadsheets are likely to include validators&endash;the equivalent of spelling and grammar checkers for spreadsheets.

Eventually spreadsheets may disappear along with other applications as component-based software makes document-centric computing possible.

 

SPREADSHEET GRAPHICS: FROM DIGITS TO DRAWINGS

Most spreadsheet programs include charting commands that can turn worksheet numbers into charts and graphs automatically. In addition, many stand-alone charting programs create charts from any collection of numbers, whether stored in a worksheet or not.

 

Creating Charts from Numbers

A pie chart is the best choice for showing the relative proportions of the parts to a whole.

Line charts are most often used to show trends or relationships over time or to show relative distribution of one variable through another.

Bar charts and column charts are similar to line charts, but they're more appropriate when data falls into a few categories. Bars can be stacked in a stack chart that shows how proportions of a whole change over time; the effect is similar to a series of pie charts.

Scatter charts are used to discover, rather than display, a relationship between two variables.

 

Rules of Thumb: Making Smart Charts

Some guidelines for creating charts that are easy to read and understand:
  • Choose the right chart for the job.
  • Keep it simple, familiar, and understandable.
  • Strive to reveal the truth, not hide it.

 

 

STATISTICAL SOFTWARE: BEYOND SPREADSHEETS

Spreadsheet software is remarkably versatile, but no program is perfect for every task. Other types of number-manipulation software are available for situations in which spreadsheets don't quite fit the job.

 

Money Managers

Instead of relying on general-purpose spreadsheets for accounting, most businesses (and many households) use professionally designed accounting and financial management software.

Tax preparation software works like a prefabricated worksheet.

 

Automatic Mathematics

Many professionals and students whose mathematical needs go beyond the capabilities of spreadsheets depend on symbolic mathematics processing software to grapple with complex equations and calculations.

 

Statistics and Data Analysis

Statistical analysis software can suggest answers to questions like these by testing the strength of data relationships. Statistical software can also produce graphs showing how two or more variables relate to each other.

 

Scientific Visualization

Scientific visualization software uses shape, location in space, color, brightness, and motion to help us understand relationships that are invisible to us. Scientific visualization takes many forms, all of which involve graphical representation of numerical data.

 

 

CALCULATED RISKS: COMPUTER MODELING AND SIMULATION

Whether part of a simple worksheet or a complex set of equations, numbers often symbolize real-world phenomena. Computer modeling&endash;the use of computers to create abstract models of objects, organisms, organizations, and processes&endash;can be done with spreadsheets, mathematical applications, or standard programming languages.

A computer model isn't static; it can be put to work in a computer simulation to see how the model operates under certain conditions. A well-designed model should behave like the system it imitates.

A feedback loop occurs when the system responds to input data.

 

Computer Simulations: The Rewards

Here are a few of the many reasons for the growing popularity of computer simulations:

 

Computer Simulations: The Risks

 

 

 

KEY TERMS

accounting and financial management software, active cell, address, automatic link, automatic recalculation

bar chart, cell, column, console, current cell, equation solver, feedback loop, formula, formula bar, function

GIGO, label, line chart, macro, mathematics processing software, modeling, pie chart

range, replication.,row, scatter chart, scientific visualization software, simulation

spreadsheet software, stack chart, statistical analysis software

tax preparation software, template, value, "What if ?" questions, worksheet

 

automatic footnoting, automatic hyphenation, camera-ready, clipboard. copying text, cursor, cut and paste

deleting text, desktop publishing (DTP), drag-and-drop, Find command, font, footer

grammar and style checker, groupware, header, idea processor, inserting text, insertion bar

justification, mail merge, master pages, moving text, navigating, outlining

page-layout software, point size, proportionally spaced font, sans serif font

saving a document, scrolling, search and replace, selecting text, serif font, service bureau

source document, spelling checker (batch or interactive), style sheet, template

text editing, text formatting, thesaurus, typeface, Undo command, word wrap, WYSIWYG

 

 

 

 

 Computer Literacy On-Line

Getting Started | TechInAction | MyITLab | Syllabus | Lecture Outline | Assignments | Glossary | Home | Videos