19 Topic A: Application programs

Word Processors and Spreadsheets

Application program – a computer program that provides users with tools to accomplish a specific task.

Examples of application programs include those for word processing, spreadsheets, presentations, and database management, as well as Internet browsers, email programs, media players, accounting software, and programs that help with pronunciation, translation, desktop publishing, enterprise.

Microsoft Office – A group of productivity software applications developed by Microsoft Corporation. Microsoft Office 2016 includes such programs as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

Word processors

Word processor – a program that allows users to create, save, edit, format, print, and retrieve documents.

Word processing programs can be used to create all types of text-based documents, such as:

  • Assignments
  • Notes
  • Memos
  • Letters
  • Resumes
  • Articles
  • Reports
  • Newsletters
  • Short stories
  • Books (with tables, diagrams, photos, links, etc.)

Examples of word processing programs include Microsoft Word, Google Docs, Apple Pages, and LibreOffice Writer.

Spreadsheets

Spreadsheet (electronic worksheet) – a program that organizes data into rows and columns, also known as tabular form. This data can then be arranged, sorted, calculated (using formulas and functions), analyzed, or illustrated using graphical representations.

Among many other things, a spreadsheet program can be used to:

  • Create budgets
  • Calculate grades
  • Balance bank accounts
  • Calculate loan payments
  • Calculate tax
  • Prepare payrolls
  • Analyze business performance numbers and results
  • Produce charts
  • Calculate revenues

Examples of spreadsheet programs include Microsoft Excel, Google Sheets, Apple Numbers, and LibreOffice Calc.

Screenshoot of spreadsheet software.

Presentation and Database Programs

Presentation programs

An example slide from a presentation.

Presentation program – a program that is designed to present information in the form of a slideshow, using multimedia formats such as pictures, sounds, videos, and text. Such a program is commonly used in education, training, business meetings, etc., to create powerful presentations.

Presentation programs are commonly used to:

  • Create slideshow presentations
  • Create lectures and tutorials
  • Make photo slideshows
  • Design websites with hyperlinks and interactivity
  • Make photo albums
  • Create animated videos (with voice and animation)

Examples of presentation programs include Microsoft PowerPoint, Google Slides, Apple Keynote, Prezi, CustomShow, SlideDog, and Powtoon.

Database programs

Database program (database management system) – A program that is designed for creating, editing, updating, maintaining databases, and managing organized information stored in them.

Databases are useful for keeping track of customers, users, employees, students, inventory, product purchases, ISBN numbers, etc. Database programs are used in the following fields:

  • Banking
  • Airline/railway reservation
  • Library management
  • Education
  • Human resource management
  • Healthcare
  • Weather
  • E-commerce
  • Government
  • Sports
  • Military

Examples of database programs include Microsoft Access, Oracle Database, Knack, TablePlus, and TeamDesk.

Launch and Terminate a Program

Launch an application program

Method 1

  1. Menu when click Windows Start button.Click the Start icon. Microsoft Windows logo.
  2. Click the name of the program that you wish to start (e.g., Word 2016).

Method 2

  1. Search box in the Windows Start menu.Type the program name in the Search box.
  2. Click the name of the program that you want to launch.

Method 3

  1. Double-click a program shortcut icon on the desktop, if there is one.

Method 4

  1. Windows taskbar.Click a program shortcut on the taskbar at the bottom edge of the screen.

Close (exit) a program (close an active open window)

Method 1

  1. Click the Close icon (x) in the upper-right corner of the window.

Method 2 (Apple)

  1. Apple File menu.Click File in the upper-left corner.
  2. Click Close.

Force close a frozen program

Method 1

  1. Click Alt + F4.

Method 2

  1. Click Ctrl + Alt + Delete to open Task Manager.
  2. Select the unresponsive program and click End Task.
definition

License

Icon for the Creative Commons Attribution 4.0 International License

Key Concepts of Computer Studies Copyright © 2020 by Meizhong Wang is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book