Computers Are Your Future
Twelfth Edition
Chapter 5: Application Software:
Tools for Productivity
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 1
Objectives
• Understand how system software
supports application software.
• List the most popular types of general-
purpose applications.
• Discuss the advantages of Web-hosted
technology and file compatibility.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 2
Objectives
• Discuss the advantages and
disadvantages of standalone programs,
integrated programs, and software
suites.
• Explain the concept of software
versions and software upgrades.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 3
Objectives
• Understand how commercial software,
shareware, freeware, and public domain
software differ.
• Understand basic concepts of using
application software.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 4
Application Software:
Tools for Productivity
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 5
General-Purpose
Applications
• Application software
o Any program that gives the user the ability to
complete work on the computer
• General-purpose applications
o Enable users to complete common tasks
• Examples: word-processing, spreadsheet
programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 6
General-Purpose
Applications
• General-purpose application
software
o Productivity programs
o Media and graphic software
o Internet-based software
o Home and education programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 7
Application Software:
Tools for Productivity
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 8
Productivity
Programs
• Productivity programs
o Make it easier to do work
o Examples
• Word-processing software
• Spreadsheet or database software
• Presentation software
• Project management software
• Personal information management software
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 9
Productivity
Programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 10
Productivity
Programs
• Microsoft Office 2010
o Office Button changed to File tab on Ribbon
o Allows customization of the Ribbon
o Live preview for the paste clipboard
o Option to capture and insert screen shots
o Enhanced multimedia editing
• Video cutting
• Removing backgrounds
• Recording a slide show as a video
o Office Web applications
• Free online companions to Word, Excel, PowerPoint, OneNote
• Real-time buddy list identifies who is currently editing a document
o Stronger security settings for working on collaborative projects
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 11
Productivity
Programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 12
Productivity
Programs
• Shared Office Interface
o Features interfaces similar to Microsoft’s Windows operating systems
• Application window
• Application workspace
• Document
• Title bar
• Window control buttons: minimize, restore down/maximize, close
• Window border
• Status bar
• Scroll bars and scroll arrows
• Ribbon
• Tab and contextual tab
• Group
• Quick Access Toolbar
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 13
Productivity
Programs
• Microsoft Word 2010
o Automatic text wrapping
o Find and Replace utility
o Ability to cut, copy and paste text, images, and screen captures
• Within document
• Between documents and programs
o Editing and formatting tools insert headers, footers, page breaks,
page numbers, and dates
o Embed pictures, graphics, charts, tables, footnotes, endnotes, & more
o Add tables, columns, tabs, bulleted or numbered lists
o Theme feature provides precreated color schemes and font selections
o Live Preview option
o Portrait or landscape orientation print options
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 14
Productivity
Programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 15
Productivity
Programs
• Microsoft Excel 2010
o Leading spreadsheet program for business and personal use
o Stores and manipulates numbers
o Modeling/what-if analysis—prediction of things that might happen
o Each file is a workbook holding worksheets with columns, rows & cells
o Spreadsheet entries and features
• Labels
• Formulas
• Mathematical formulas
• Functions
• Argument set
• Charts
• Sparklines
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 16
Productivity
Programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 17
Productivity
Programs
• Microsoft Access 2010
o Database management system
• Designed to
o Store related data in tables
o Create relationships
o Generate forms, queries, & reports
o Features of Access
• Table
• Data set
• Form
• Filter
• Query
• Report
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 18
Productivity
Programs
• Microsoft PowerPoint 2010
o Popular program used to create and deliver presentations
o PowerPoint screen features
• Slide/Outline pane
• Notes pane
• View buttons
• Slide pane
o Includes
• Professionally designed templates
• Slide transitions
• Placeholder and image animation options
• Animation painter
• Ability to insert video
• Convert presentation into a WMV video file
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 19
Productivity
Programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 20
Productivity
Programs
• Microsoft Project
2010
o Useful for the management of one or
more projects that can vary in
complexity
o Features include
• Visually enhanced timeline
emphasizes due dates and
deadlines
• Team-planning capability
• Portfolio manager monitors
allocation of scarce resources and
current project costs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 21
Productivity
Programs
• Microsoft Outlook 2010
o Personal information management system
o Features include
• E-mail
• Conversation grouping
• Ignoring conversations
• Think before you send feature
• Calendar with alarms
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 22
Media and Graphic
Software
• Media
o Refers to the technology used in presenting
information including:
• Pictures
• Sound
• Video
• Multimedia programs
o Enable users to incorporate more than one type of
technology
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 23
Media and Graphic
Software
• Multimedia and graphics software
programs include:
o Professional desktop publishing
o Multimedia authoring
o Paint, drawing, and animation
o Image editing
o 3D rendering, such as CAD
o Audio
o Video editing
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 24
Media and Graphic
Software
• Compression and decompression
o Codecs—algorithms that reduce file size and allow faster
Internet transfer speeds
Codecs use two different approaches to compression:
• Lossless compression—The original file is compressed
so that it can be completely restored without flaws,
when it is decompressed
• Lossy compression—The original file is processed so
that some information is permanently removes from the
file.
• Audio Video Interleave (AVI)—Microsoft-created
specification for packaging audio and video data into a
file
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 25
Media and Graphic
Software
• Desktop publishing programs
o Used to create newsletters, product catalogs,
advertising brochures, and other documents
requiring unusual design and layout normal word
processors do not provide.
• Adobe InDesign Corel Draw
FlippingBook – software for creating online
publications, magazines, photo albums
and flip books with the real page turning
effect.
• Adobe PageMaker, etc
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 26
Media and Graphic
Software
• Paint programs
o Create bitmapped
images (raster
graphics)—made up of
tiny dots known as pixels
o Paint program standard
file formats
• GIF
• JPEG
• PNG
• BMP
• TIFF
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 27
Media and Graphic
Software
• Graphics Interchange Format (GIF)
o Lossless compression of simple images
o Often used for Web pages
• Joint Photographic Experts Group (JPEG)
o Lossy compression of complex images
o Also used for Web pages
• Portable Network Graphics (PNG)
o Patent-free alternative to a GIF
o Lossless compression, suitable for Web use only
• Windows Bitmap (BMP)
o Compression optional
o Files tend to be large
• Tag Image File Format (TIFF)
o Includes descriptive information with the image
o Used in publishing
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 28
Media and Graphic
Software
• Drawing
programs
o Create vector
graphics that can be
edited and resized
without distortion
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 29
BITMAP VS VECTOR
GRAPHIC
• Bitmap-based images, do not rely on mathematical
formulas to define their various elements.
o File names for bitmap-based images usually consist of extensions such
as *.PSD, *.JPG,*GIF, *.TIF, or *.BMP.
• Vector-based images generally contain well-
defined elements such as curves and shapes of
various colors.
o File names for vector-based images usually consist of extensions such
as *.EPS, *.AI,*CDR, or *.DWG.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 30
Media and Graphic
Software
• 3D rendering programs
o Provide graphic objects with three dimensional effects
• 3ds Max Design
• Ray tracing
o Manipulates variations in color intensity that would
be produced by light falling on an object from
multiple directions
• Computer Aided Design (CAD)
o 3D rendering programs used by engineers and scientists
• Image editors
o Advanced types of paint programs
o Can change complicated bitmapped objects, including photographs
o Can edit, but not create, bitmapped images
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 31
Media and Graphic
Software
CAD
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 32
Media and Graphic
Software
• Animation
programs
o Give the ability
to create
animation from
images and run
the animation
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 33
Media and Graphic
Software
• Audio
software
o Used to capture
and process
sound used in
multimedia
presentations
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 34
Media and Graphic
Software
• Standard sound file formats
o MP3
o Windows Media Audio (WMA)---developed by
MICROSOFT
o WAV-- is a Microsoft and IBM audio file
format standard for storing an audio bitstream
on PCs.
o Ogg Vorbis
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 35
Media and Graphic
Software
o Musical Instrument Digital Interface (MIDI)-- is
an electronic musical
instrument industryspecification that enables a
wide variety of digital musical
instruments, computers and other related
devices to connect and communicate with one
another.[1]
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 36
Media and Graphic
Software
• Video editors
o Enable the user to:
• Modify digitized
videos
• Save in at least one
of these formats:
o Moving
Picture
Experts Group
(MPEG)
o QuickTime
o Video for
Windows
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 37
Media and Graphic
Software
• Multimedia authoring systems
o Used to create multimedia presentations
o Require a large amount of disk space and
memory to run properly
Adobe Director
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 38
Media and Graphic
Software
• Web page authoring programs
o Professional development tools that have greater
scope to create Web pages
• Dreamweaver
• Flash
• Fireworks
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 39
Media and Graphic
Software
• Internet programs
o Help users communicate, learn, and interact
through the Internet
o Examples include:
• E-mail
• Instant messaging software
• Web browsers
• Video conferencing programs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 40
Applications that Work through
and Run from the Internet
• Web-hosted technology
o Share files and collaborate
• Windows Office Live
• Google Docs
o Help avoid file incompatibility
• Undesirable Internet software
o Spyware—monitors your activity
o Pop-up—small window that appears in the current
browser window
o Adware—targets products to your interests
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 41
Home and Educational
Programs
• Home and educational programs
o Personal finance and tax preparation software
o Home design and landscaping software
o Computerized reference software
• Multimedia dictionaries
• Encyclopedias
• How-to guides
o Computer games
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 42
Home and Educational
Programs
• Computer games
o Total sales up to $68.4 billion by 2012
o Started in 1970s
o Multiplayer online gaming—players interact with characters
controlled by other players
• MUDs (multiuser dungeons or dimensions)
• gMUDs (Graphical MUDs)
• MMORPGs (massively multiplayer online role-playing
games)
• Gaming trends
o Gamers spend an average 18 hrs per week playing games.
o Two of every five gamers are female.
o Members of 65% of U.S. households play video games
o Age of average gamer is 32.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 43
Tailor-Made
Applications
• Tailor-made applications
o Software designed for specific businesses or users
o Often cost more than general-purpose applications
because of their development costs
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 44
Tailor-Made
Applications
• Custom versus packages
software
o Custom software
• Developed for a user’s specific needs
• Necessary when an application is not available
o Packaged software
• Developed for the mass market
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 45
Standalone Programs, Integrated
Programs, and Software Suites
• Standalone program
o Fully self-contained program: a program that does not
require operating system's services to run
o Advantages
• Purchased and installed separately
• Function by themselves
o Disadvantages
• Take a lot of storage space
• Do not share resources
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 46
Standalone Programs, Integrated
Programs, and Software Suites
• Integrated
programs
o Single program that
combines the most
commonly used functions of
many productivity software
programs
• Example: Microsoft Works
o Modules (functions) share
the same interface
o Lacks features
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 47
Standalone Programs, Integrated
Programs, and Software Suites
• Software suite (office suite)
o Bundle of standalone programs
• Word processing
• Spreadsheet
• Presentation graphics
• Database
• Personal information
o Share common code, drivers, and graphic libraries
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 48
System Requirements and
Software Versions
• System requirements
o Outline the minimal level of resources that a
program requires
• Releases of programs are cited
by a year or version number.
o In a version number, a decimal number indicates a
maintenance release.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 49
System Requirements and
Software Versions
• Time-limited trial versions
o Offered for commercial programs by software
companies
• Beta versions
o Sometimes available to users
• Software is in the final testing stages and may
contain bugs.
• Access is free.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 50
System Requirements and
Software Versions
• Software upgrading
o How software is kept current.
• Small fixes to software are called patches.
• Large or major fixes to software are called
service packs or service releases.
• Software can be distributed
through the Internet and/or
purchased in stores.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 51
System Requirements and
Software Versions
• Documentation
o In print or downloaded from the Internet.
• Brief tutorials
• Read Me files
• Help files
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 52
Software Licenses
and Registration
• Software license
o Permits the user to install the program on one
computer
• Site license
o Right to install copies of programs on a precise
number of computers
• Validate software
o Providing a special code or product key before using it
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 53
Software Licenses
and Registration
• Commercial software
o Software that must be purchased
• May have a trial period
• Examples
o Microsoft Office
o Adobe Acrobat
o Apple iLife
• Shareware
o You may try before purchasing
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 54
Software Licenses
and Registration
• Freeware
o Free to users as long as users do not sell it to others
• Public domain software
o Copyright-free software
o Users can modify or sell
• Copy-protected software
o Internal process prohibits making unauthorized copies
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 55
Installing and Managing
Application Software
• Installing
o Moving the software to the hard disk and properly
configuring the software
• Uninstalling
o Takes the program off the hard disk
• Launching
o Moves it from the hard disk to memory
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 56
Installing and Managing
Application Software
• Options
o Can be chosen to identify program is run
• Defaults
o Software settings used by the program unless
overridden by the user
• AutoSave or AutoRecover
o Automatically saves the users work at specified
intervals
• Exiting
o Quitting or closing down an application
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 57
Summary
• Understand how system software
supports application software.
• List the most popular types of general-
purpose applications.
• Discuss the advantages of Web-hosted
technology and file compatibility.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 58
Summary
• Discuss the advantages and
disadvantages of standalone programs,
integrated programs, and software
suites.
• Explain the concept of software
versions and software upgrades.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 59
Summary
• Understand how commercial software,
shareware, freeware, and public domain
software differ.
• Understand basic concepts of using
application software.
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 60
All rights reserved. No part of this publication may be reproduced, stored in a
retrieval system, or transmitted, in any form or by any means, electronic,
mechanical, photocopying, recording, or otherwise, without the prior written
permission of the publisher. Printed in the United States of America.
Copyright © 2012 Pearson Education, Inc.
Publishing as Prentice Hall
Copyright © 2012 Pearson Education, Inc. Publishing as Prentice Hall 61