10/12/2017
Week 4: Understanding Application
Software
1
10/12/2017
Understanding Application
Software
Learning Objectives:
• Identify the various types of application
software
• Understand the basics of business
productivity applications
• Explore graphics and photo editing
programs
• Understand system requirements and the
uninstall process
Word Processing
• Designed for text-based documents
• Contains advanced spelling and grammar
correction
• Microsoft Word is the most popular program in
this category
2
10/12/2017
Word Processing
Desktop Publishing
• Page layout software
• Combines text with graphics
• Content is frame-based for greater flexibility in
the layout
• Professional versions include QuarkXPress and
Adobe InDesign
3
10/12/2017
Desktop Publishing
Spreadsheet Applications
• Analyzes and presents numeric data
– Budgets
– Mortgages
– Sales data
– Inventory levels
• Creates charts out of numeric data
• Stores data in cells
4
10/12/2017
Spreadsheet Applications
Spreadsheet Applications
• Functions perform
math calculations,
such as SUM shown
here
5
10/12/2017
Database Software
• Database: A structured collection of data, such
as an inventory or address book
– Contains one or more tables
– Each table contains records and fields
• Database Management System (DBMS) is the
software that manages a database
• Data mining: Extracting information from a
database
• Relational database: A database in which there
are multiple tables with relationships to one
another
Personal Information Management
• Provides time-management and contact-
management tools
– Calendars/scheduling
– Names and addresses of people and businesses
– To-do lists
– Notes
• May also include email
• Microsoft Outlook is the most popular
6
10/12/2017
Software Suite
• A collection of related applications sold as a
group
• Microsoft Office: Excel, Word, PowerPoint,
Outlook, Access
• Creative Suite: Photoshop, Dreamweaver,
Illustrator, InDesign, Director
Accounting and Personal Finance
• Accounting software: simplifies the process of
managing a business’s finances
– Quickbooks is one popular example for small
businesses
– Larger businesses may have their own custom
software
• Personal finance software: manages home and
personal finances
– Quicken is one popular example
– Mint is a free online tool
– Your bank may have online banking services
7
10/12/2017
Vector Image Drawing Programs
• Vector art: art created with math formulas in a
drawing program
– Adobe Illustrator
– Drawing tools in Office applications
– Clip art line drawings
• Raster art: art created with a grid of colored dots
– Scanned photos and digital camera images
– Paint
– Adobe Photoshop
Vector Graphic Tools in PowerPoint
8
10/12/2017
Bitmap (Raster) Graphics
• Grid of colored pixels
• Originate with scanners and digital cameras
• Can also be created from scratch in Paint
programs
• Each graphic has a native resolution
• Resolution is measured in pixels, as in 1024 x
768
• Color depth: number of bits used to describe the
color of each pixel, such as 24-bit or 32-bit
Photoshop Elements
9
10/12/2017
Images Are Made of Pixels
Drawbacks of Bitmap Images
• Large file size
– Example: 24-bits per pixel x 1024 x 768 =
2,359,296 bytes
– File compression can reduce the size
• Lossless
• Lossy
• Loses quality when resized
– Resizing causes images to be pixilated
– Image quality loss is especially noticeable when
resizing above original size
10
10/12/2017
Pixelation
Presentation Graphics Software
• Creates groups of graphic slides to accompany
presentations
• Slides can be enhanced with graphics, sounds,
videos, and animation effects
• Presentations can be delivered in-person, on
disc, on the Internet, or made into videos
11
10/12/2017
PowerPoint
Computer-Aided Design (CAD)
• Vector graphic drawing tool for 3D modeling
• Creating a CAD drawing is a multi-step process
– Objects are created as a wireframe
– Wireframe is assigned properties such as mass
– Wireframe is assigned with a texture that
resembles a certain type of surface, such as skin,
hair, bones, or fabric
– Rendering applies the properties and textures to
the wireframe
– Rendering can require a lot of computing power
and time
12
10/12/2017
AutoCAD
Music and Video Players
• Multi-purpose players can play music, DVD
movies, videos, podcasts, and audio books
• Movie player applications may require a codec
13
10/12/2017
Audio and Video Editing
• Audio editing programs create and make
changes to music and narration tracks
• Video editing programs combine music, still
images, and video clips to create movies
Enrichment and Education
• Legal software
• Reference software
• Educational software
14
10/12/2017
Communication Software
• Email client
• Web browser
• Instant messaging
• Videoconferencing
• Groupware
Web Authoring Software
• HTML Editors (plain text)
• Web authoring software
– Dreamweaver
– Expression Web
• Web multimedia creation tools
– Fireworks
– Illustrator
• Online site creation tools
• Blog sites (WordPress, TypePad)
15
10/12/2017
Managing Your Applications
• End User License Agreement (EULA)
• System Requirements
– Minimum and Recommended
– Hardware requirements (CPU, RAM, disk space)
– Operating system version
Installing Applications
• What Installing Does
– Expands and copies files to your hard drive
– Creates a shortcut on the Start menu
– Modifies the Windows Registry
• How to Install an Application
– Download a Setup file and run it to install
– Insert CD or DVD disc and follow the prompts
16
10/12/2017
Removing Applications
1. Click Start and
click Control
Panel.
2. Under Programs,
click Uninstall or
Change a
Program.
3. Click the program
to uninstall.
4. Click the Uninstall
button.
5. Follow the
prompts.
Updating Applications
• Updating fixes bugs and security flaws
• Updates may be automatically installed for some
applications
17
10/12/2017
Key Terms
accounting software formula resolution
application software graphics software slide
cell groupware spreadsheet
codec hierarchical database suite
color depth instant messaging system requirements
compression legal software tax software
computer-aided design node vector-based illustration
data mining personal finance video chat
database software videoconferencing
database management pixel web authoring software
system pixilated what-you-see-is-what-
desktop publishing presentation graphics you-get (WYSIWYG)
software software wireframe
educational software raster graphic word processor
email application reference software
End User License relational database
Agreement (EULA) render
Summary
• 1 . For each of the following, name two types of work you
could accomplish: word processor,
• spreadsheet, desktop publishing software, database.
• 2 . What are the advantages of a software suite?
• 3 . How is data stored in a relational database?
• 4 . If a raster graphic had a resolution of 800 × 600, how
would you determine the number of
• pixels in it?
• 5 . Explain the process of rendering in a CAD application.
• 6 . Explain the difference between instant messaging and
video conferencing.
18
10/12/2017
Second hour: Understanding
Microsoft Office 2010
Learning Objectives:
• Identify the basic parts of an Office application’s
interface
• Use common features that all Office applications
share
• Save, open, and create data files
• Print your work and email it to others
• Adjust the options of an Office application
The Office Ribbon
• Ribbon
19
10/12/2017
Hiding the Ribbon
Backstage View
20
10/12/2017
Quick Access Toolbar
Shortcut Menus
• Right-click for a shortcut
menu
• Mini toolbar also
appears when right-
clicking on text
21
10/12/2017
ScreenTips
Status Bar
22
10/12/2017
Window Controls
Getting Help
• Press the
F1 key
• Click the
Help
button
• Click the
File tab
and click
Help
23
10/12/2017
Changing Views
Moving Around
• Scroll bars
– Scroll box
– Scroll arrows
• Keyboard movement
– Arrow keys
– Page up, Page Down
– End, Home
– Ctrl+End, Ctrl+Home
24
10/12/2017
Selecting Content
• Selecting Text in Word or PowerPoint
– Drag across it
– Click at the start point, hold down Shift, and click
at the end point.
– Click at the start point, hold down Shift, and press
arrow keys to extend the selection
Selecting Content
• Selecting Cells in Excel
– Drag across the cells
– Select the first cell, hold down Shift, and click the
last cell.
– Select the first cell, hold down Shift, and press
arrow keys to extend the selection
– Click a cell, hold down Ctrl, and drag across
additional cells to select them
25
10/12/2017
Using the Clipboard
Office Clipboard
• Holds up to 24
objects at a time
• Click an item to
paste it
26
10/12/2017
Undo and Redo
Text Formatting
27
10/12/2017
Themes
• Apply from Design tab
• Contains definitions of
fonts, colors, and effects
• In PowerPoint, may
contain addition elements
(background images,
variants)
Theme Colors and Palettes
28
10/12/2017
Moving and Resizing Objects
• Drag selection handle to resize
• Drag border to move
Saving Files
• Choose File, Save
or press Ctrl+S
• When saving
subsequent times,
use Save As to
reopen dialog box
29
10/12/2017
Default File Formats for Office
Applications
Opening Recently Used Files
30
10/12/2017
New Files with Templates
• File, New
• Select one
of the
templates,
or search
for a
template
Printing Files
31
10/12/2017
Sending a File as an Email Attachment
Setting Application Options
32
10/12/2017
Application Options
Key Terms
AutoCorrect keyboard shortcut selection handle
AutoRecover object shortcut menu
Backstage view Office Clipboard standard colors
cell cursor Quick Access Toolbar status bar
color palette (QAT) tab
default file location Ribbon template
dialog box launcher ScreenTip theme
embed fonts scroll theme colors
group scroll bar Zoom controls
insertion point scroll box
33
10/12/2017
Summary
• 1 . Explain how to save and open files in Office
applications.
• 2 . Describe the main features that the user interfaces
of all Office applications have in common.
• 3 . Describe how colors are arranged on a palette and
how they relate to the active theme.
• 4 . Name three things you can customize in an
application via its Options dialog box.
• 5 . Explain how to change the default save location.
• 6 . Describe how to move the insertion point.
• 7 . Contrast the Windows Clipboard to the Office
Clipboard.
In Summary
Next week lecture shall cover Word Processing with MS Word
and Creating Spreadsheets with MS Excel.
68
34
