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.
Presentation and Database Programs
Presentation programs
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