Transcript Application software 3.1 Common Features of Application Software

3.1 Common Features of Application
Software

Application software


It helps us organize raw data into useful
information.
Some common types of application software:
spreadsheet
word processor
multimedia
presentation
software
Each type is
specially designed
and has distinct
features for
specific tasks.
personal information
manager and
communication program
database software
image
editing
program
web
authoring
software
3.1 Common Features of Application
Software

Common commands of application
software

In a computer system with a graphical
user interface (GUI), start an application
by either:


clicking its program icon
clicking its program name on a menu
3.1 Common Features of Application
Software

Common commands of application
software
File:
manipulate
the file
View:
specify
what and
how a file
is to be
displayed
Edit:
modify the
file content
Window:
move from
one open
file to
another
Help:
open
help
files
3.1 Common Features of Application
Software

Common commands of application
software
File:
manipulate
the file
View:
specify
what and
how a file
is to be
displayed
Edit:
modify the
file content
Window:
move from
one open
file to
another
Help:
open
help
files
3.2 Word Processors

Word Processors


It can be used to create, edit, format, save
and print text documents.
Creating documents involves developing
them by entering text, inserting graphics
and performing special tasks.
3.2 Word Processors

Word Processors


Editing is the process of making changes
to the content of a document.
Some common editing features of word
processors:
Copy
Paste
Cut
Draw a
table
Spelling and
grammar
checker
Find and
replace
3.2 Word Processors

Word Processors


Formatting is the process of polishing the
appearance of a document.
Some common formatting features of word
processors:
Properties of characters
Font setting
boldface
font
italic
font size
Alignment of paragraph
right-aligned
justified
left-aligned centre-aligned
underline
3.2 Word Processors

Word Processors

Saving is the process of copying a
document from the main memory to a
storage medium.
Saving

Printing is the process of sending a file to
a printer to generate output on a medium.
Printing
3.2 Word Processors

Word Processors

Saving is the process of copying a
document from the main memory to a
storage medium.
Saving

Printing is the process of sending a file to
a printer to generate output on a medium.
Printing
3.3 Spreadsheets

Basic features of spreadsheets


A spreadsheet is used to create tables
and organize data into rows and columns.
Storing units on a spreadsheet are called
cells.
3.3 Spreadsheets

Applications of spreadsheets


Spreadsheet software such as Microsoft
Excel provides many built-in functions and
tools for performing calculation and data
manipulation.
Some arithmetic operators in Microsoft
Excel:
Arithmetic
operator
Description
^
index
+–*/
arithmetic
operators
Example
Cell formula
Output
=2^4
16
=5+1–3*
4/6
4
3.3 Spreadsheets

Applications of spreadsheets


Spreadsheet software such as Microsoft
Excel provides many built-in functions and
tools for performing calculation and data
manipulation.
Some arithmetic operators in Microsoft
Excel:
Arithmetic
operator
Description
^
index
+–*/
arithmetic
operators
Example
Cell formula
Output
=2^4
16
=5+1–3*
4/6
4
3.4 Multimedia Presentation Software

Applications of Multimedia
Presentation Software


It is used to create presentations or slide
shows that contain text, graphics,
animations, sounds and videos.
Slide shows are effective tools for
exchanging ideas and presenting
information.
3.4 Multimedia Presentation Software

Common Features of Microsoft
PowerPoint
1. Create a new
slide show with
pre-defined layout.
3.4 Multimedia Presentation Software

Common Features of Microsoft
PowerPoint
2. Apply a design
template to the
slide show.
3.4 Multimedia Presentation Software

Common Features of Microsoft
PowerPoint
3. Customize the
order of animated
objects and the
details of the
animations.
3.4 Multimedia Presentation Software

Common Features of Microsoft
PowerPoint
4. Specify the
transition effects
when a slide is
replaced by a new one.
3.4 Multimedia Presentation Software

Common Features of Microsoft
PowerPoint
4. Specify the
transition effects
when a slide is
replaced by a new one.
3.5 Database Software

Applications of database software


Database software defines the structure
of a database and access the data within it.
It is used to store, organize and
manipulate a large amount of data records.
3.5 Database Software

Basic operations of Microsoft
Access
1. Create a new
database file and
define the record
structure.
3.5 Database Software

Basic operations of Microsoft
Access
2. Open a
database table
and add records
into it.
3.5 Database Software

Basic operations of Microsoft
Access
4. View records
in sorted order.
3. Manipulate
existing records.
3.5 Database Software

Common forms available in
database software

Users can create different types of forms
to input, retrieve and display data in a
database file.
Form type
Purpose
Data Entry Form
A template which accepts new records and
verifies the data entered.
Query Form
Allow users to define instructions, such as
SQL ones, for retrieving data.
Report Form
Allow selected data to be displayed on the
screen. It is also used for producing
hardcopies.
3.5 Database Software

Common forms available in
database software

Users can create different types of forms
to input, retrieve and display data in a
database file.
Form type
Purpose
Data Entry Form
A template which accepts new records and
verifies the data entered.
Query Form
Allow users to define instructions, such as
SQL ones, for retrieving data.
Report Form
Allow selected data to be displayed on the
screen. It is also used for producing
hardcopies.
3.6 Integrated Use of Application
Software


A project is usually required to
incorporate different types of
multimedia elements.
Different types of application software
are used to create the elements before
integrating them into the finished
project.
3.6 Integrated Use of Application
Software
3.6 Integrated Use of Application
Software
3.6 Integrated Use of Application
Software