Chapter 3: Application Software
Cells may contain three types of data:
labels, values, and formulas.
Software suites offer two major advantages:
lower cost and ease of use.
Business software suites typically include, at a minimum, the following programs:
word processing, spreadsheet, presentation, and e-mail.
is a collection of clip art and photos.
CLIP ART/IMAGE GALLERY
is a small symbol displayed on the screen that moves as you interact with the mouse or other pointing device.
POINTER
Font size is gauged by a measurement system called
POINTS
allows professionals to modify a segment of a video, called a clip
VIDEO EDITING SOFTWARE
A single point is about ____ of an inch in height
1/72
helps companies record and report their financial transactions
ACCOUNTING SOFTWARE
PDF was developed by
ADOBE SYSTEMS
displays the Accessories list.
ALL PROGRAMS LIST
consists of programs designed to make users more productive and/or assist them with personal tasks.
APPLICATION SOFTWARE
lets users modify audio clips, produce studio- quality soundtracks, and add audio to video clips
AUDIO EDITING SOFTWARE
is available in a variety of forms: packaged, custom, Web application, open source, shareware, freeware, and public domain.
Application software
is an informal Web site consisting of time-stamped articles, or posts, in a diary or journal format, usually listed in reverse chronological order.
BLOG
• Time-stamped articles, or posts, in a diary or journal format, usually listed in reverse chronological order • Blogger needs blog software, or blogware, to create/ maintain blog - Some Web sites do not require installation of blog software
BLOGGING
examples of font styles
BOLD, ITALIC, UNDERLINE
is a collection of individual programs available together as a unit.
BUSINESS SOFTWARE SUITE
is a graphical element that you activate to cause a specific action to occur.
BUTTON
is the intersection of a column and a row.
CELL
founded the ADOBE SYSTEMS in 1982 and named it after a creek that ran behind Warnock's house in California.
CHARLES GESCHKE JOHN WARNOCK
depicts the data in graphical form
CHARTING
Real-time, online typed conversation • Requires chat client software - Integratedinsomeoperatingsystems,e-mailprograms,andWeb browsers - Available for download on the Web, usually at no cost - Included with some paid Internet access services - Built in to some Websites
CHAT ROOM
is a location on the Internet that permits users to chat with one another.
CHAT ROOM
is a collection of drawings, photos, and other images.
CLIP ART
also called a bar chart, displays bars of various lengths to show the relationship of data. The bars can be horizontal, vertical, or stacked on top of one another.
COLUMN CHART
is an instruction that causes a program to perform a specific action.
COMMAND
is a sophisticated type of application software that assists a professional user in creating engi- neering, architectural, and scientific designs.
COMPUTER-AIDED DESIGN (CAD)
is a type of education in which students learn by using and completing exercises with instructional software.
COMPUTER-BASED TRAINING (CBT)
typically consists of self-directed, self-paced instruction about a topic.
COMPUTER-BASED TRAINING (CBT)
the computer stores the data in an electronic format on a storage medium such as a hard disk.
COMPUTERIZED DATABASE
provides a means by which rich content, such as audio, video, photos, and documents, can be communicated digitally.
CONTENT SHARING
typically includes a spelling checker, which reviews the spelling of individual words, sections of a document, or the entire document.
CPELLING CHECKER
When you __________ a document, you enter text or numbers, insert images, and perform other tasks using an input device such as a keyboard, mouse, or digital pen.
CREATE
performs functions specific to a business or industry. Sometimes a company cannot find packaged software that meets its unique requirements. In this case, the company may use programmers to develop tailor-made custom software.
CUSTOM SOFTWARE
introduced wikiCalc in 2007 as a free software tool for Web pages that have data in lists and tables.
DAN BRICKLLIN
is a collection of data organized in a manner that allows access, retrieval, and use of that data.
DATABASE
is application software that allows users to create, access, and manage a database.
DATABASE SOFTWARE
is an on-screen work area that has a graphical user interface
DESKTOP
enables professional designers to create sophisticated documents that contain text, graph- ics, and many colors
DESKTOP PUBLISHING SOFTWARE
is a window that provides information, presents available options, or requests a response.
DIALOG BOXES
often contain option buttons, text boxes, check boxes, and command buttons.
DIALOG BOXES
which factor largely in many people's personal and business lives, include any transmission of information from one computer or mobile device to another
DIGITAL COMMUNICATIONS
includes the use of cell phones, smart phones, and VoIP (Voice over IP).
DIGITAL VOICE COMMUNICATIONS
is the delivery of education at one location while the learning takes place at other loca- tions.
DISTANCE LEARNING
provides a means for sharing, distributing, and searching through documents by converting them into a format that can be viewed by any user.
DOCUMENT MANAGEMENT SOFTWARE
short for electronic learning, is the delivery of education via some electronic method such as the Internet, networks, or optical discs.
E-LEARNING
Although ___________ is primarily a text-based form of digital communications, it also can be used to share photos, videos, and other types of files by attaching files to e-mail messages.
gradually has replaced typed and copied memos, letters, and faxes while increasing the reliability, cost effectiveness, and speed of the communications.
is the transmission of messages and files via a computer network.
means to make changes to its existing content.
EDIT
teaches a particular skill
EDUCATIONAL SOFTWARE
Messages and files sent via a network such as the Internet • Requires an e-mail program - Integrated in many software suites and operating systems - Available free at portals on the Web - Included with paid Internet access service - Can be purchased separately from retailers
includes interactive games, videos, and other programs designed to support a hobby or provide amusement and enjoyment.
ENTERTAINMENT SOFTWARE
Each column, called a _________, contains a specific category of data within a record.
FIELD
is a named collection of stored data, instructions, or information.
FILE
indicates the size of the characters in a particular font.
FONT SIZE
Adds emphasis to a font
FONT STYLE
Change a document's appearance
FORMAT
is copyrighted software provided at no cost to a user by an individual or a company that retains all rights to the software.
FREEWARE
• Method of uploading and downloading files with other computers on the Internet • May require an FTP program - Integrated in some operating systems - Available for download on the Web for a small fee
FTP
is a predefined formula that performs common calculations such as adding the values in a group of cells or generating a value such as the time or date.
FUNCTION
A typical enterprise consists of a wide variety of departments, centers, and divisions — collectively known as
FUNCTIONAL UNITS
This soft- ware includes computer-aided design, desktop publishing, paint/image editing, photo editing, video and audio editing, multimedia authoring, and Web page authoring.
GRAPHICS AND MULTIMEDIA SOFTWARE
Homeowners or potential homeowners can use _____________ to assist them with the design, remodeling, or improvement of a home, deck, or landscape
HOME DESIGN/LANDSCAPING SOFTWARE
These programs show changes to home designs and landscapes, allowing homeowners to preview proposed modifications.
HOME DESIGN/LANDSCAPING SOFTWARE
This soft- ware includes hundreds of predrawn plans that you can customize to meet your needs.
HOME DESIGN/LANDSCAPING SOFTWARE
Users often inter- act with Web applications directly at the Web site, referred to as the ___________
HOST
Common pointer shapes (3)
I-beam Block Arrow Pointing Hand
is a small image displayed on the screen that represents a program, a document, or some other object.
ICON
provides the capabilities of paint software and also includes the capability to enhance and modify existing pictures and images.
IMAGE EDITING SOFTWARE
is a real-time Internet communications service that notifies a user when one or more people are online and allows the user to exchange messages or files or join a private chat room with those people.
INSTANT MESSAGING
• Real-time exchange of messages, files, audio, and/or video with another online user • Requires instant messenger software - Integrated in some operating systems - Available for download on the Web, usually at no cost - Included with some paid Internet access services
INSTANT MESSAGING
assists in the preparation of legal documents and provides legal information to individuals, families, and small businesses
LEGAL SOFTWARE
shows a trend during a period of time, as indicated by a rising or falling line.
LINE CHART
you might record data on paper and store it in a filing cabinet.
MANUAL DATABASE
founded Softbank, which is one of Japan's largest telecommunications and media Corporations. He now is one of the richest men in the world with a net worth of $3.7 billion.
MASAYOSHI SON
contains a list of commands from which you make selections.
MENU
With this software, users control the placement of text and images and the duration of sounds, video, and animation
MULTIMEDIA AUTHORING SOFTWARE
allows users to combine text, graphics, audio, video, and anima- tion in an interactive application
MULTIMEDIA AUTHORING SOFTWARE
Popular software suites are
Microsoft Office, Apple iWork, Corel WordPerfect Office, and Google Docs.
• Online area where users have written discussions • Newsgroup may require a newsreader program - Integrated in some operating systems, e-mail programs, and Web browsers
NEWSGROUP/MESSAGE BOARD
is application software that enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page and then save the page as part of a notebook
NOTE TAKING SOFTWARE
is the electronic equivalent of a user manual.
ONLINE MANUAL
is a Web site that encourages members in its online community to share their interest, ideas, stories, photos, music, and videos with other registered users.
ONLINE SOCIAL NETWORK
is software provided for use, modification, and redistribution. This software has no restrictions from the copyright holder regarding modification of the software's internal instructions and its redistribution.
OPEN SOURCE SOFTWARE
usually can be downloaded from the Internet, often at no cost
OPEN SOURCE SOFTWARE
is mass-produced, copyrighted retail software that meets the needs of a wide variety of users, not just a single user or company. It is alo available in retail stores or on the Web.
PACKAGED SOFTWARE
Graphic artists, multimedia professionals, technical illustrators, and desktop publishers use _____________ AND _________ to create and modify graphical images such as those used in DTP documents and Web pages.
PAINT AND IMAGE EDITING SOFTWARE
allows users to draw pictures (Figure 3-18), shapes, and other graphical images with various on-screen tools such as a pen, brush, eyedropper, and paint bucket.
PAINT SOFTWARE
also called illustration software,
PAINT SOFTWARE
often use the concept of a desktop to make the computer easier to use.
PC COMPUTER SYSTEMS
A popular file format that document management software uses to save converted documents is
PDF - PORTABLE DOCUMENT FORMAT
helps home and small business users cre- ate newsletters, brochures, flyers, advertisements, post- cards, greeting cards, letterhead, business cards, banners, calendars, logos, and Web pages.
PERSONAL DTP SOFTWARE
Most of these programs also offer a variety of online services, such as online banking, which require access to the Internet.
PERSONAL FINANCE SOFTWARE
is a simplified accounting program that helps home users and small office/home office users balance their checkbooks, pay bills, track personal income and expenses, track investments, and evaluate financial plans.
PERSONAL FINANCE SOFTWARE
is application software that includes an appointment calendar, address book, notepad, and other features to help users organize personal information.
PERSONAL INFORMATION MANAGER SOFTWARE (PIM)
These products also include many templates to assist you in adding images to documents such as greeting cards, banners, calendars, signs, labels, business cards, and letterhead.
PERSONAL PAINT/IMAGE EDITING SOFTWARE
includes various simplified tools that allow you to draw pictures, shapes, and other images; and provides the capabil- ity of modifying existing graphics and photos.
PERSONAL PAINT/IMAGE EDITING SOFTWARE
provides an easy-to-use interface
PERSONAL PAINT/IMAGE EDITING SOFTWARE
a popular type of image editing software available both as packaged software and as Web applications, allows users to edit digital photos by removing red-eye, eras- ing blemishes, restoring aged photos, adding special effects, enhancing image quality, or creating electronic photo albums.
PERSONAL PHOTO EDITING SOFTWARE
is much simpler to use than its professional coun- terpart, for small-scale movie making projects
PERSONAL VIDEO AND AUDIO EDITING SOFTWARE
With _________, you can view, organize, sort, catalog, print, and share digital photos. Some photo editing software includes photo management functionality.
PHOTO MANAGEMENT SOFTWARE
is a wireless messaging service that allows users to send and receive photos and sound files, as well as short text messages, to and from a mobile device, or computer.
PICTURE MESSAGING
has the shape of a round pie cut into slices, shows the relationship of parts to a whole
PIE CHART
This software also provides a variety of layouts for each individual slide such as a title slide, a two-column slide, and a slide with clip art, a chart, a table, or a diagram. In addition, you can enhance any text, charts, and graphical images on a slide with 3-D, animation, and other special effects such as shading, shadows, and textures.
PRESENTATION SOFTWARE
is application software that allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group.
PRESENTATION SOFTWARE
typically provides a variety of predefined presentation formats that define complementary colors for backgrounds, text, and graphical accents on the slides.
PRESENTATION SOFTWARE
When you ______ a document, the computer places the contents of the document on paper or some other medium
is a type of image editing software that allows photographers, videographers, engineers, scientists, and other high-volume digital photo users to edit and customize digital photos.
PROFESSIONAL PHOTO EDITING SOFTWARE
allows a user to plan, schedule, track, and analyze the events, resources, and costs of a project.
PROJECT MANAGEMENT SOFTWARE
helps users manage project variables, allow- ing them to complete a project on time and within budget.
PROJECT MANAGEMENT SOFTWARE
has been donated for public use and has no copyright restrictions. Anyone can copy or distribute public-domain software to others at no cost.
PUBLIC-DOMAIN SOFTWARE
One of the more powerful features of spreadsheet software is its capability of _______________ the rest of the worksheet when data in a worksheet changes
RECALCULATING
Each row, called a ___________ contains data about a given person, product, object, or event.
RECORD
provides valuable and thorough information for all individuals.
REFERENCE SOFTWARE
• Keeps track of changes made to Web sites by checking RSS feeds • Requires RSS aggregator program - Integrated in some e-mail programs and Web browsers - Available for download on the Web, usually at no cost
RSS AGGREGATOR
When you _______ a document, the computer transfers the document from memory to a storage medium such as a USB flash drive or hard disk.
SAVE
is copyrighted software that is distributed at no cost for a trial period. To use a shareware program beyond that period, you send payment to the program developer.
SHAREWARE
The "oohs" and "aahs" you hear at a fireworks show may be in response to the music and pyrotechnics synchronized with
SPECIAL MULTIMEDIA SOFTWARE
compares the words in the document with an electronic dictionary that is part of the word processing software.
SPELLING CHECKER
is similar to a notebook that can contain more than 1,000 related individual worksheets
SPREADSHEET FILE
allows users to organize data in rows and columns and perform calculations on the data.
SPREADSHEET SOFTWARE
serves as the interface between the user, the application software, and the computer's hardware
SYSTEM SOFTWARE
is available both as packaged software and Web applications, can guide individuals, families, or small businesses through the process of filing federal taxes
TAX PREPARATION SOFTWARE
allow you to exchange short messages and small multimedia files with other online users.
TEXT MESSAGING
is a wireless messaging service that allows users to send and receive short notes on a smart phone or other mobile device.
TEXT MESSAGING
• Short text, picture, or video messages sent and received, mainly on mobile devices • Requires text, picture, video messenger software - Integrated in most mobile devices - Available for download on the Web, usually at no cost, for personal computers
TEXT, PICTRE, VIDEO MESSAGING
identifies the worksheet data and helps organize the worksheet
TEXT/LABEL
a horizontal space that contains the window's name.
TITLE BAR
usually displays a document's file name.
TITLE BAR
enables users to view maps, determine route directions, and locate points of interest
TRAVEL AND MAPPING SOFTWARE
Another difference between blogs and wikis is that blog entries typically are not included in search results from search engines, such as Google, while wiki entries are recognized by search engine queries.
TRUE
Some communications software is considered system software because it works with hard- ware and transmission media.
TRUE
While blogs can be modified only by the author, a wiki can be authored and edited by any user.
TRUE
is a type of system software that assists users with controlling or maintaining the operation of a computer, its devices, or its software.
UTILITY PROGRAMS
protect a computer against malicious software and unauthorized intru- sions, manage files and disks, compress files, play media files, and burn optical discs.
UTILITY PROGRAMS
typically offer features that provide an environment conducive to successful use of application software.
UTILITY PROGRAMS
• Meeting between geographically separated people who use a network such as the Internet to transmit video/audio • Requires video conferencing software, a microphone, speakers, and sometimes a video camera attached to your computer
VIDEO CONFERENCING
is a wireless messaging service that allows users to send and receive short video clips, usually up to 30 seconds, in addition to all picture messaging services.
VIDEO MESSAGING
• Allows users to speak to other users over the Internet • Requires Internet connection, Internet telephone service, microphone or telephone, and Internet telephone software or telephone adapter
VOIP (INTERNET TELEPHONY)
can be used as a replacement for the traditional telephone at work or in the home.
VoIP
is a technology that allows users to speak to other users via the Internet.
VoIP
Similar to CBT, _______ typically consists of self-directed, self-paced instruction about a topic.
WBT
often is combined with other materials for distance learning and e-learning.
WBT
refers to Web sites that provide users with a means to share personal information, allow users to modify Web site content, and/or have application software built into the site for visitors to use.
WEB 2.0
is a Web site that allows users to access and interact with software from any computer or device that is connected to the Internet.
WEB APP
is a Web site that allows users to access and interact with software from any computer or device that is connected to the Internet.
WEB APPLICATION
• Allows users to access and view Web pages on the Internet • Requires a Web browser program - Integrated in some operating systems - Available for download on the Web free or for a fee
WEB BROWSER
allows two or more people to engage in an online meeting and often allows the attendees to access programs and digital content, such as documents, audio, and video, during the meeting.
WEB CONFERENCE
helps users of all skill levels create Web pages that include graphical images, video, audio, animation, and special effects with interactive content.
WEB PAGE AUTHORING SOFTWARE
is a type of CBT (computer-based training) that uses Internet technology and consists of application software on the Web.
WEB-BASED TRAINING (WBT)
is a collaborative Web site that allows users to create, add to, modify, or delete the Web site content via their Web browser.
WIKI
is a rectangular area of the screen that displays data and information.
WINDOW
allows users to create and manipulate documents containing mostly text and sometimes graphics
WORD PROCESSING SOFTWARE
sometimes called a word processor
WORD PROCESSING SOFTWARE
A feature that allows users to type words in a paragraph continually without pressing the enter key at the end of each line
WORDWRAP
rows and columns collectively are called a
WORKSHEET
Three popular personal computer operating systems are
Windows, Mac OS, and Linux.
1. To make business activities more efficient 2. To assist with graphics and multimedia projects 3. To support home, personal, and educational tasks 4. To facilitate communications
application software's variety of uses
Popular reference software includes
encyclopedias, dictionaries, and health/medical guides.
Types of Web applications include
e-mail, word processing, and game programs.
Thousands of shareware, freeware, and public-domain programs are available on the Internet for users to download. Examples include: (3)
communications, graphics, and game programs.
