Chapter 3B

1
Chapter 3B

• Popular Applications

2
Document Production Software

• Assists you with composing, editing, designing,
  printing, and electronically publishing documents
• Word processing
• Word, Word Perfect, Open Office, Amni Pro
• Desktop publishing
• Publisher, Print Shop, Resume builders
• Web authoring
• Front Page, Dreamweaver

3
Different Features

• Spell Checker
• Word (red lines)
• Spelling dictionary
• Change languages
• Thesaurus
• Grammar Checker
• Word (green lines)
• Readability formula
• Search and Replace
• Graphical Elements
• Clip Art
• Save as Web Pages

• All sorts of formatting
• Font
• Point Size
• Paragraph style
• Alignments
• Line spacing
• Style
• Page Layout
• Header/Footer
• Tables/Tabs
• Mail Merge
• Templates

4
Spreadsheet Software

• Assists in handling calculations
• Budgeting, grade book, balancing a checkbook,
  calculating loan payments
• What-if analyses
• Worksheets
• Cells
• Values
• Labels

5
Formulas

• Formulas begin with an equal sign and must
  indicate at least one arithmetic operator
• Addition M2A1
• Subtraction R7-B4
• Multiplication A13, A2C7
• / Division B5/A3
• Exponentiation 52 (5225)
• Values can be replaced by cell addresses that
  contain values themselves
• (80 89 30 40 60) / 5
• Or
• (C3 D3 E3 F3 G3) / 5

6
Functions

• Functions are shortcuts for too long or complex
  formulas (begins with equal sign).
• This Sum function adds the group of cells
  contained in the Parentheses(arguments or
  parameters)

7
Number Crunching Software

• Provides a structured environment dedicated to a
  particular number crunching task
• Statistical software
• Mathematical modeling software
• Money management software
• Personal finance software
• Quicken
• Tax preparation software
• Turbo Tax

8
Database

• Helps you organize information
• Student records, medical records
• Structured file
• Records
• Fields

9
Database Software

• A query language such as SQL (Structured Query
  Language) provides a set of commands for locating
  and manipulating data
• Natural language query
• Query by example

10
Graphics Software

• Designed to help you create, manipulate, and
  print graphics
• Paint software
• Photo editing software
• Drawing software
• 3-D graphics software
• CAD software
• Presentation software

11
Music Software

• Allows you to make your own digital voice and
  music recordings
• Audio editing software
• CD ripper software
• Audio encoding software
• Ear training software
• Notation software
• Computer-aided music software
• MIDI sequencing software

12
Other Software

• Video Editing Software
• Educational Software
• Reference Software
• Groliers Encyclopedia
• Entertainment Software
• Role-playing, action, adventure, puzzle,
  simulation, sports, strategy games

• Business Software
• Accounting software
• Horizontal Market Software
• Used by many businesses
• Vertical Market Software
• Usually for a single market