1 / 14

Using Computer Applications

Learn about generic commercial software applications, including Word Processing, Spreadsheets, Databases, and Presentation software. Understand the purpose of the module, required learning materials, and assessment details.

minya
Télécharger la présentation

Using Computer Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Computer Applications Introduction to the module

  2. 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 NicholsModified by Ivailo Chakarov

  3. Using Computer Applications Ivailo Chakarov

  4. 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 NicholsModified by Ivailo Chakarov

  5. 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 NicholsModified by Ivailo Chakarov

  6. Computer Applications covered • Word processing / DTP (Word) • Databases (Access) • Spreadsheets (Excel) • Presentation software (PowerPoint) Created by Janet NicholsModified by Ivailo Chakarov

  7. 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 NicholsModified by Ivailo Chakarov

  8. Desktop Publishing Word Processing (Word) • Used to produce quality publications with • well-designed pages • elaborate charts & graphics • text, headlines, typeface variety Created by Janet NicholsModified by Ivailo Chakarov

  9. Databases (Access) An organised collection of related data Allows: - • integrated files • reduced redundancy • shared data • centralised security • 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 NicholsModified by Ivailo Chakarov

  10. Spreadsheets (Excel) • Traditional business tool • Allows : • basic calculations using formulae consisting of • Operands (sum, +, -,*,/) • Functions – sum, SDEV, IF, • automatic recalculation • charts Created by Janet NicholsModified by Ivailo Chakarov

  11. Spreadsheets (Excel) • useful for: • Accounting and cash flow • budget management • cost benefit analysis Created by Janet NicholsModified by Ivailo Chakarov

  12. 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 NicholsModified by Ivailo Chakarov

  13. Integrated Packages (Microsoft Office) • An all in one set of programs • Usually comprising: - • Word processor • Spreadsheet • Database • Presentation software Created by Janet NicholsModified by Ivailo Chakarov

  14. 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 NicholsModified by Ivailo Chakarov

More Related