Module 3: Application Software: Programs That Let You Work and Play

This preview shows page 1 - 4 out of 13 pages.

FUNDAMENTALS OF INFORAMTIONS AND TECHNOLOGY Module 3: Application Software: Programs That Let You Work and PlaySoftwareThe term software refers to a set of instructions that tells the computer what to do. These instruction sets, also called programs, provide the means for us to interact with and use the computer.Your computer uses two basic types of software:System softwareApplication softwareSystem Software vs. Application SoftwareSystem SoftwareCoordinates instructions between software and hardwareIncludes:Operating systemUtility programsApplication SoftwarePrograms used to complete tasksIncludes:Productivity softwareSpecialty softwareEntertainment softwareEducational and reference softwarePersonal softwareApplication SoftwareHere you see the various types of application software available. In this module, we look at all of these types in detail, starting with productivity software.
Productivity SoftwarePrograms that enable you to perform various tasks generally required in home, school and businessThis category includes:Word-processing programsSpreadsheet programsPresentation programsDatabase programsPersonal Information Manager (PIM) programsWord-Processing SoftwareUsed to create and edit documentsFeatures include:Quick and easy editingFormatting optionsGraphicsTemplatesWizardsExamples:Corel WordPerfectMicrosoft WordOpenOffice WriterSpreadsheet SoftwareUsed to perform calculations and numerical analysesFeatures include:Worksheets with cells
Values, formulas and functionsAutomatic recalculationThe basic element in a spreadsheet program is the worksheet, columns and rows of which form boxes called cells. There are several types of data you can enter into a cell:Labelsare descriptive text that identifies the components of the worksheet.Valuesare numeric data entered either directly or as a result of a calculation.Formulasare equations that you build yourself.Functionsare formulas that are preprogrammed into the spreadsheet software.The primary benefit of spreadsheet software is its ability to recalculate all functions and formulas in the spreadsheet automatically when assumptions are changed.Examples:Microsoft ExcelOpenOffice CalcPresentation SoftwareUsed to create slide shows.Features include:Templates and layoutsAnimationsTransitionsCan use animation effects to control how and when text and other objects enter and exit each slide. Similarly, slide transitions add different effects as you move from one slide to the next during the presentation.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture