Transcript Software - Ivailo Chakarov

Using Computer Applications
Introduction to the module
1
Today's objectives

At the end of this lecture you should be able to
describe:
 structure of the module
 learning materials you will need
 what you are to learn
 how you will be assessed
This will be explained using the module descriptor
 List the main types of computer packages
 Identify tasks that these packages can be used for
Created by Janet Nichols
Modified by Ivailo Chakarov
2
Using Computer Applications
Ivailo Chakarov
3
Module Descriptor



Purpose of module - to develop an in-depth
knowledge of generic commercial software
applications.
To be able to use:
 Word Processing Software
 Spreadsheets
 Databases
 Presentation software
Learning materials required –
Computer
Microsoft Office
Created by Janet Nichols
Modified by Ivailo Chakarov
4
Purpose/Assessment of Module



To give students an overall grounding in the use of
common PC applications in solving business problems
The course will consist of lectures and practical
sessions over 12 weeks
Assessment will be through 2 assignments
 Assessment 1 – production of a spreadsheet and
report
 Assessment 2 – creation of a database and
associated documentation and the delivery of a
presentation.
Created by Janet Nichols
Modified by Ivailo Chakarov
5
Computer Applications covered

Word processing / DTP (Word)
 Databases (Access)
 Spreadsheets (Excel)
 Presentation software (PowerPoint)
Created by Janet Nichols
Modified by Ivailo Chakarov
6
Word Processing (Word)




Used to create written documents such as letters,
reports, forms etc.
Contain useful tools to help produce professional
documents such as:
 Spell checker
 Thesaurus, Grammar checks
Used to create, edit, format, store and print
Helpful for proof reading
Created by Janet Nichols
Modified by Ivailo Chakarov
7
Word Processing (Word)

Desktop
Publishing
Used to produce quality publications with



well-designed pages
elaborate charts & graphics
text, headlines, typeface variety
Created by Janet Nichols
Modified by Ivailo Chakarov
8
Databases (Access)
An organised collection of related data
Allows: 1. integrated files
2. reduced redundancy
3. shared data
4. centralised security
5. easy filing & retrieval
Useful for storing large amounts of data in an organised
manner. Common database systems are:
personnel systems, order/invoicing systems,
warehouse systems, accounting systems etc.
Created by Janet Nichols
Modified by Ivailo Chakarov
9
Spreadsheets (Excel)

Traditional business tool
 Allows :
 basic calculations using formulae consisting of
 Operands (sum, +, -,*,/)
 Functions – sum, SDEV, IF,
 automatic recalculation
 charts
Created by Janet Nichols
Modified by Ivailo Chakarov
10
Spreadsheets (Excel)

useful for:
Accounting and cash flow
 budget management
 cost benefit analysis

Created by Janet Nichols
Modified by Ivailo Chakarov
11
Presentation software (PowerPoint)
Used to produce multimedia presentations
consisting of:
Text
 Video
 Sound
 graphics (static and non-static)
Useful for producing presentations to be given
to an audience such as Sales, Marketing,
educational lectures etc.

Created by Janet Nichols
Modified by Ivailo Chakarov
12
Integrated Packages
(Microsoft Office)

An all in one set of programs

Usually comprising: Word processor
 Spreadsheet
 Database
 Presentation software

Created by Janet Nichols
Modified by Ivailo Chakarov
13
Objectives revisited

you should now be able to describe:
 structure of the module
 learning materials you will need
 what you are to learn
 how you will be assessed
as explained using the module descriptor
 List Computer Packages to be used
 List main uses of the computer packages
Created by Janet Nichols
Modified by Ivailo Chakarov
14