Application Software
gary xiao
9781305656314_PPT_ch06_DM_RM_DM.pptxChapter 6 Application Software: Desktop and Mobile Apps
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Learning Objectives (1)
Describe what application software is, the different types of ownership rights, and the difference between installed and cloud software.
Detail some concepts and commands that many software programs have in common.
Discuss word processing and explain what kinds of documents are created using this type of program.
Explain the purpose of spreadsheet software and the kinds of documents created using this type of program.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
2
Learning Objectives (2)
Identify some of the vocabulary used with database software and discuss the benefits of using this type of program.
Describe what presentation graphics and electronic slide shows are and when they might be used.
List some types of graphics and multimedia software that consumers use frequently.
Name several other types of application software programs and discuss what functions they perform.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
3
Overview
This chapter covers:
General characteristics of application software
The most widely used types of application software:
Word processing
Spreadsheet
Database
Presentation graphics
Graphics and multimedia
Overview of other types of application software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
4
The Basics of Application Software
Software ownership rights of application software (apps)
Specify the allowable use of the program
A software license gives you the right to use a software program
Specifies the conditions under which the software can be used
Also called an end user license agreement (EULA)
Often terms of use instead for mobile apps
Open source software are programs with source code made available to the general public
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
5
Inside the Industry
Open Source Software
Linux was the first widely used open source software
There are many other open source apps (GIMP, LibreOffice, etc.)
Cheaper than other software
Increased stability and security
Ability to modify application’s source code
The free GIMP program.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
6
6
Examples of Software Types
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
7
Commercial Software
Commercial software is developed and sold for profit
Typically comes with a single-user license
Sometimes can be installed on one desktop and one personal computer (see license to know)
Site licenses or network licenses are available for some software
Some software is available in a demo or trial version to test out the program before buying
Licenses may be per running instance or use license tokens to better fit some business uses
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
8
Shareware, Freeware, and Public Domain Software
Shareware consists of copyrighted software distributed on the honor system
Consumers should either pay for it or uninstall it after the trial period
Freeware consists of copyrighted software programs that are given away by the author for others to use free of charge
Many apps available at the app stores used with mobile devices are freeware
Public domain software is not copyrighted
Ownership rights have been donated to the public domain
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
9
Desktop vs. Mobile Software
Personal computers use desktop software
Smartphones and other mobile devices typically require mobile apps
Designed for a specific type of device
Wide range of software available via app stores (Google Play, Apple App Store, etc.)
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
10
Technology and You
Mobile Ticketing
Using your smartphone or tablet as your admission ticket
Typically use a mobile app; show the ticket barcode when the ticket is needed
Examples:
Tickets for movies, sporting events, concerts, etc.
Boarding passes
Custom tickets
A mobile boarding pass.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
11
Installed vs. Cloud Software: Installed Software
Installed software must be installed on the computer before it can be run
Can be purchased in physical form (DVD, etc.) and then installed
Can be downloaded from the Internet and then installed
Can be free or fee-based software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
12
Cloud Software
Cloud software is delivered on-demand via the Web
Also called Software as a Service (SaaS), Web-based software, and cloudware
Includes free software and fee-based software
Advantages of cloud software
Files can be accessed from any computer or device with an Internet connection
Ease of implementation
Improved collaboration and interface capabilities
Always working with the most current version of software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
13
Cloud Software (cont’d)
Potential disadvantages of cloud software
Online applications tend to run more slowly
Cannot use during a server outage or without Internet access
Some programs like Google Docs allow some offline access
Some cloud software may have file size limits
Cost may eventually exceed the cost of purchasing a similar installed version of the software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
14
Examples of Cloud Software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
15
Trend
Dealing with Crapware
Many manufacturers preinstall third-party software on new PCs
Can also be bundled with a software program you download
Download software from the manufacturer’s site whenever possible
Read each installation screen carefully
Security software can detect PUPs (potentially unwanted programs)
Pay close attention to the options listed on installation screens to avoid installing crapware.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
16
Software Suites
A software suite is a collection of software programs bundled together and sold as a single software package
Office suites are used by most businesses/individuals to produce documents and typically include:
Word processing software
Spreadsheet software
Database software
Presentation graphics-software
Microsoft Office 2016 and Office 365
Provide a common interface among programs in the suite
Typically less expensive than buying the programs individually
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
17
Microsoft Office
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
18
Common Software Commands
Commands are similar from program to program
Usually commands are issued via menus, keyboard shortcuts, or command buttons located on a toolbar or Ribbon
Keyboard shortcut key combinations are faster ways of issuing commands
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
19
The Microsoft Office Ribbon
The Ribbon arrived with Microsoft Office 2007
Commands are organized into groups located on tabs
Contextual tabs appear on the Ribbon as needed and contain special commands
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
20
Editing a Document
Editing a document refers to change the content of the document, such as inserting or deleting words
Insertion point indicates the current location in a document, which is where the changes will be made
Typing text inserts the text at the insertion point location
Insertion point can be moved with the arrow keys or by selecting the new location with a pen, mouse, or finger
Delete and Backspace keys delete text
Text and objects can typically be selected and moved, copied, deleted, or formatted
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
21
Formatting a Document
Formatting changes the appearance of the document
Font face, font size, font style, and/or font color
Line spacing or margins
Page numbers
Shading or borders to a paragraph, image or other item
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
22
Getting Help
Help is often built into the program and may use:
Table of contents
Browsing
Search
Online help (via manufacturer’s Web site and independent sites)
Offline help (periodicals, books, tutorial videos, classes)
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
23
Quick Quiz (1)
1. Software programs that are distributed on the honor system and can be legally and ethically shared with others to try out the software are referred to as _________.
a. shareware programs
b. commercial software
c. public domain software
2. True or False: Software purchased via the Internet is always provided as a download rather than as a package.
3. A group of related software programs sold together as one unit is called a(n) __________.
Answers:
1) a; 2) False; 3) software suite
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
24
Word Processing Concepts
Word processing uses a computer and word processing software to create, edit, save, and print written documents
Letters, contracts, manuscripts, etc.
Common word processing software programs
Microsoft Word
Corel WordPerfect
Google Docs
Apple Pages
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
25
How It Works
Gesture Input with Microsoft Office
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
26
Creating a Word Processing Document
Word wrap automatically returns the insertion point to the next line when the end of the screen line is reached
Character formatting (font face, size, style, or color)
Paragraph formatting (line spacing, indentation, alignment, and styles)
Page formatting (margins, paper size, orientation, headers, footers, etc.)
Document formatting (footnotes, end notes, table of contents, index, background, theme)
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
27
Microsoft Word 2016
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
28
Examples of Ribbon Tabs
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
29
Tables, Graphics, and Templates
Tables
Allow content to be organized in a table consisting of rows and columns
Table Tools tab
Graphics or drawing features
Allow images to be inserted into a document (clip art, photographs, drawn images, scanned image, etc.) and then modified
Picture Tools tab
Templates
Help users create new documents quickly
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
30
Word Processing and the Web
Most word processing programs today include Web-related features allowing you to:
Send a document as an e-mail message
Include Web page hyperlinks in documents
Create or modify Web pages
Create and publish blogs
Collaborate with others online
Stream documents from and store documents in the cloud
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
31
Spreadsheet Concepts
A spreadsheet contains a group of numbers and other data organized into rows and columns
Spreadsheet software is used to create computerized spreadsheets
Most widely used spreadsheet programs:
Microsoft Excel
Corel Quattro Pro
Google Sheets
Apple Numbers
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
32
Creating a Spreadsheet
A worksheet is a single spreadsheet divided into rows and columns
A workbook is a collection of worksheets saved in a single file
A cell is the intersection of a row and a column
Each cell is identified by a cell address, such as A1
Cell pointer is used to select a cell
Cell pointer can be used to select more than one cell (range or block)
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
33
Microsoft Excel 2016
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
34
Entering Data into a Spreadsheet Cell
Data is entered into the appropriate spreadsheet cell
Labels are text-based entries that identify data on the worksheet
Constant values are numerical entries
Formulas perform mathematical operations on the content of other cells
Usually reference the cell address, not the current data in a cell
Use mathematical operators; begin with an = sign
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
35
Spreadsheet Functions
A function is a named, pre-programmed formula
Hundreds of functions that can be used in spreadsheets
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
36
Absolute vs. Relative Cell Referencing in Formulas
Relative cell references
Cell addresses are adjusted as the formula is copied to reflect the new location of the formula
Absolute cell references
Formulas are copied exactly as they are written
Appropriate when you want to use a specific cell address in all copies of the formula
Use $ to make cell references absolute: $B$6
A single formula can contain both relative and absolute cell references as needed
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
37
Examples of Relative and Absolute Cell Referencing
38
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Charts and What-If Analysis
Most spreadsheet programs include some type of charting or graphing capability
Can create charts from the data in the spreadsheet (do not have to reenter it)
Charts change accordingly if the data in the spreadsheet changes
When cell contents are changed, formulas are automatically recalculated
What-if-analysis
Tool frequently used to help make business decisions
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
39
Spreadsheets and the Web
Most spreadsheet programs have built-in Web capabilities enabling the user to:
Save the current worksheet as a Web page
Insert hyperlinks inserted into worksheet cells
Select and copy ranges of cells to a Web publishing or word processing program to insert spreadsheet data into a Web page as a table
Send a workbook as an e-mail message
Collaborate online
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
40
Quick Quiz (2)
1. Changing the font face or size of text in a document is an example of which word processing feature?
a. page orientation
b. paragraph formatting
c. character formatting
2. True or False: A spreadsheet document created in spreadsheet program is often called a worksheet.
3. The intersection of a row and column into which spreadsheet data may be typed is called a(n) ________.
Answers:
1) c; 2) True; 3) cell
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
41
Database Concepts
A database is a collection of related data that is stored in a manner enabling information to be retrieved as needed
Database management system (DBMS) or database software allows the creation and manipulation of an electronic database
Most widely used relational database programs
Microsoft Access
Corel Paradox
Oracle Database
IBM’s DB2
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
42
Database Organization
Data in a database is organized into fields (columns), records (rows), and tables
A field (column) is a single type of data to be stored in a database
A record (row) is a collection of related fields
A table is a collection of related records
Database file is a collection of related tables
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
43
Paper-Based vs. Computerized Databases
44
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Creating a Database
Create the database file first
Contains objects, such as tables, forms, and queries
Create one or more tables
Can use either the table’s Datasheet view or Design view
The table structure is created:
Field name (unique identifying name)
Data type (text, number, date, object)
Field size (maximum number of characters)
Default value (initial content of the field)
Data is entered into the table
A form can be create to use for data entry if desired
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
45
Microsoft Access 2016
46
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Example of Creating a Database Table
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
47
Modifying Table Data
Data can be displayed using either Form view or the table’s Datasheet view
Open a form to view data via the form
Data can be added, edited, or deleted in either view
Record buttons are used to move through the records
48
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Queries and Reports
A query is a question, or a request for specific information from the database
Contains criteria to specify the records and fields to be included in the query results
Named and saved so it can be run again at a later time
Displays the current data meeting the criteria each time it is opened
A report is created when a more formal output is desired
Associated with either a table or a query
Displays the current data in the report format each time it is opened
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
49
Example of Creating and Using a Database Query
50
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Databases and the Web
Many Web sites use one or more databases to:
Keep track of inventory
Allow searching for people, documents, products, or other information
Place real-time orders
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
51
Presentation Graphics Concepts
A presentation graphic is an image designed to visually enhance a presentation
Can be used in electronic slide shows
Can be inserted into reports and other written documents
52
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Presentation Graphics Terms
An electronic slide is a one-page presentation graphic that can contain images, text, video, and more
An electronic slide show is a group of electronic slides that are displayed one after the other on a computer monitor or other display device
Presentation graphics software is used to create presentation graphics
Microsoft PowerPoint
Corel Presentations
Google Slides
Apple Keynote
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
53
Creating a Presentation
New slides can be added to a new or existing presentation as needed
Preformatted slide layouts that contain placeholders for text, images, and other items can be used
Slides can contain a variety of elements
Text
Images
Charts
Audio clips
Video clips
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
54
Microsoft PowerPoint 2016
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
55
Finishing a Presentation
Objects can be animated
Transitions between slides can be added
Slide Sorter view can be used to rearrange the slide order
Show can be set up to run automatically or manually
Can print slides to create overhead transparencies or an audience handout
Speaker tools include:
Speaker notes and pens
Presenter view
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
56
Example of Running a Slide Show
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
57
Presentation Graphics and the Web
Presentation graphics programs can be used to generate Web pages or Web page content
Slides can include hyperlinks
Users can usually control Web-based presentations accessed via a Web browser
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
58
Graphics and Multimedia Concepts
Graphics are digital representations of images, such as digital photographs, clip art, scanned drawings, and original images created using a software program
Multimedia technically refers to any application that contains more than one type of media
Often used to refer to audio or video content
There is a large variety of graphics software to create or modify graphics, edit digital audio or video, play multimedia files, and burn CDs and DVDs
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
59
Types of Graphics Software
Painting programs typically create bitmap images
Don’t usually support layers
Microsoft Paint
Drawing programs (illustration programs) typically create vector graphics using mathematical formulas
Adobe Illustrator CC, Corel Painter
Image editing or photo editing programs are designed for touching up or modifying images
Adobe Photoshop, Picasa, Apple Photos
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
60
Examples of Graphics Software Programs
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
61
Audio Capture and Editing Software
Audio editing software is used to create and edit audio files
Sound recorder software captures sound from a microphone
Ripping software captures sound from a CD
Audio can be edited, spliced, and otherwise modified
Professional and consumer software
Adobe Audition CC
Apple GarageBand
Audacity
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
62
Video Editing and DVD Authoring Software
Video editing software modifies existing videos
Prepares video clips for presentations, Web sites, YouTube, etc.
Video is first imported into the computer
DVD authoring software organizes content to be transferred to DVD
DVD burning software records data on recordable or rewritable DVDs
Professional and consumer software
Adobe Premiere Elements, Corel VideoStudio, Apple iMovie, etc.
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
63
Example of Video Editing Software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
64
Media Players
Media players are programs designed to play audio and video files
Music CDs, downloaded music, streaming audio, etc.
Video stored on device or streamed from the Internet
Typically allow you to arrange your stored music and videos into playlists
Transfer them to a CD or smartphone
Some players include the ability to purchase and download music via an associated music store
Important to adhere to copyright laws when using digital music
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
65
Example of a Media Player Program
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
66
Graphics, Multimedia, and the Web
Often used by individuals and businesses to create content to be included on a Web sites or shared via the Web
Company logos
Web site banners
Games
Tutorials
Videos
Demonstrations
Web multimedia content can be created using animation (Adobe Flash) and multimedia authoring (Adobe Director) software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
67
Other Types of Application Software
Desktop and personal publishing software
Web publishing software and Web site builders
Educational and entertainment software
Reference software
Much is available via the Web today
68
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Other Types of Application Software (cont’d)
Note taking software and Web notebooks
CAD and other types of design software
Accounting and personal finance software
Project management, collaboration, and remote access software
69
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
Remote Access Software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
70
Quick Quiz (3)
1. A single category of data to be included in a database (viewed as a column in a table) is called a __________.
a. record
b. field
c. table
2. True or False: Each slide in a slide presentation can contain only one type of element, such as text, an image, or a video clip.
3. DVD ________ refers to recording data (such as a collection of songs or a finished video) on a recordable or rewritable DVD.
Answers:
1) b; 2) False; 3) burning
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
71
Summary
The Basics of Application Software
Word Processing Concepts
Spreadsheet Concepts
Database Concepts
Presentation Graphics Content
Graphics and Multimedia Concepts
Other Types of Application Software
© 2017 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a password-protected website for classroom use.
72
