Application Software Basics Quiz

Application Software Basics

• Software Ownership Rights define acceptable program usage.
• Software Licenses grant usage rights and outline conditions.
• Open Source Software makes source code publicly accessible.

Open Source Software

• Increasingly popular, with many applications available beyond Linux.
• Generally cheaper, more stable, and secure.

Software Types

• Commercial Software: Copyrighted, sold for profit with a single-user license.
• Shareware: Copyrighted; a "try before you buy" model, requires payment or removal after the trial.
• Freeware: Copyrighted, but free to use.
• Public Domain Software: Not copyrighted; freely available to everyone.

Desktop vs. Mobile Software

• Desktop Software is designed for personal computers.
• Mobile Apps are tailored for mobile devices, and accessible through app stores (e.g., Google Play, Apple App Store).

Mobile Ticketing

• Download tickets directly to a mobile device for entry. - Used for movies, concerts, sporting events, boarding passes, and custom events.

Installed vs. Cloud Software

• Installed Software requires installation on a computer and can be in physical form or downloaded.
• Cloud Software (SaaS) is accessed on-demand via the web.

Advantages of Cloud Software

• Accessible from any internet-connected device.
• Easier setup and enhanced collaboration.
• Always updated to the latest version.

Disadvantages of Cloud Software

• May run slower online.
• File size limits.
• Long-term costs may exceed installed versions.

Airline Apps

• Airlines like American Airlines provide tablets for staff and iPads to pilots.
• Replaces paper manuals and maps.
• Enables enhanced passenger services, including flight connections, weather updates, and in-flight purchases.

Software Suites

• Bundled collection of programs sold as one package.
• Commonly includes word processing, spreadsheets, databases, and presentation tools.
• Office suites provide a unified interface.
• Latest versions include Office 2013 (installed) and Office 365 (subscription).

Common Software Commands

• Ribbon (Microsoft Office 2007+): Commands grouped into tabs; contextual tabs appear as needed.
• Shortcuts: Toolbars, menus, and keyboard shortcuts are available.

Editing Documents

• Insert, delete, or modify text at the insertion point.
• Actions include selecting, moving, copying, deleting, or formatting text and objects.

Formatting Documents

• Adjust font, size, color, spacing, margins, page numbers, and borders.

Getting Help

• Built-in assistance includes a Table of Contents, browsing, and searching options.
• Help is available online (websites) and offline (tutorials, videos, classes).

Word Processing Concepts

• Word Processing involves creating, editing, saving, and printing documents.
• Examples include letters, contracts, and manuscripts.

Common Word Processing Software Programs

• Microsoft Word
• Corel WordPerfect
• Apple Pages

Creating a Word Processing Document

• Word Wrap: Moves insertion point to the next line when the end of the screen line is reached.
• Character Formatting: Adjusts font face, size, style, or color.
• Paragraph Formatting: Customizes line spacing, indentation, alignment, styles.
• Page Formatting: Alters margins, paper size, orientation, headers, footers, etc.
• Formatting: Adds footnotes, endnotes, table of contents, index, background, and themes.

Tables, Graphics, and Templates

• Tables: Organize content into rows and columns.
• Graphics/Drawings: Insert and modify images like clip art, photos, or drawings.
• Templates: Pre-designed layouts that expedite document creation.

Word Processing and the Web

• Many word processing programs allow sending documents via email.
• Adding hyperlinks to web pages.
• Creating or modifying Web pages.
• Blogging and collaborating online.

Spreadsheet Concepts

• Spreadsheets organize data in rows and columns.
• Used for formulas, data analysis, charts, and graphs.
• Common software includes Microsoft Excel, Corel Quattro Pro, and Apple Numbers.

Creating a Spreadsheet

• Worksheet: A single spreadsheet.
• Workbook: Multiple worksheets in one file.
• Cell: Intersection of a row and column identified by a cell address (e.g., A1).

Entering Data

• Labels: Text identifiers.
• Constant Values: Numerical entries.
• Formulas: Perform calculations using cell references (e.g., =A1 + B1).

Functions

• Pre-programmed formulas (e.g., SUM, AVERAGE).

Absolute vs. Relative Referencing

• Relative: Cell references adjust when copied.
• Absolute: Cell references remain fixed (e.g., $B$6).

Charts & What-If Analysis

• Create charts from data.
• What-if Analysis facilitates simulations.

Spreadsheets and the Web

• Save as web pages, insert hyperlinks, copy to web pages, send via email, and collaborate online.

Database Concepts

• Databases store related data that is retrievable as needed.
• Managed by Database Management Systems (DBMS) like Microsoft Access, Oracle, or IBM DB2.

Data Organization

• Fields: Columns that store single data types.
• Records: Rows of related fields.
• Tables: Collections of related records.
• Database File: Collection of related tables.

Creating a Database

• First, create a database file with tables, forms, and queries.
• Tables have a specified structure (field name, data type, size, default values).
• Tables are viewable in Datasheet or Design mode.

Queries & Reports

• Queries: Requests for specific data, saved for repeated use.
• Reports: Formal output based on tables or queries.

Databases and the Web

• Databases are used by websites to track inventory, enable searches, and process real-time orders

Presentation Graphics Concepts

• Presentation Graphics are visual aids that enhance presentations.
• Can be used in electronic slide shows and printed reports.
• Examples include charts, graphs, images or clips.

Key Terms

• Slide: A single page of a presentation.
• Electronic Slide Show: A sequence of slides displayed one after another.
• Presentation Graphics Software: Programs used to create presentation graphics (e.g., Microsoft PowerPoint, Corel Presentations, Apple Keynote).

Creating a Presentation

• Preformatted layouts enhance efficiency.
• New slides can be added to existing or new presentations.
• Slides can include elements like text, images, charts, audio clips, and video clips.

Finishing a Presentation

• Slide Sorter View: Displays thumbnails of slides to help rearrange their order.
• Presentations can be set to run automatically or manually.
• Speaker Tools include speaker notes, pens, presenter views, and recorded narration.
• Printouts can be created for overhead transparencies or handouts.

Presentation Graphics and the Web

• Presentation software creates web pages or content.
• Slides may contain hyperlinks.
• Web-based presentations are controlled through a browser.

Graphics and Multimedia Concepts

• Graphics: Digital images include photos, clip art, scanned drawings and images created with software.
• Multimedia: Applications that use more than one media type, often audio or video.

Software Types

• Graphics Software: Programs for creating or editing images (e.g., Microsoft Paint, Adobe Illustrator, Adobe Photoshop).
• Audio Editing Software: Programs for creating and editing audio files (e.g., Audacity, GarageBand).
• Video Editing Software: Programs for modifying videos (e.g., Apple iMovie, Roxio Creator).
• Media Players: Programs for playing audio and video files (e.g., Windows Media Player, QuickTime).

Web Use:

• Graphics and multimedia tools are widely used to create websites and online content (e.g., logos, banners, games, videos).

Other Application Software Types

• Desktop & Personal Publishing (e.g., brochures, posters)
• Educational, Entertainment, & Reference Software (e.g., e-books, games)
• Note-Taking & Web Notebooks (e.g., OneNote)
• CAD & Design Software (e.g., AutoCAD)
• Accounting & Finance Software (e.g., QuickBooks)
• Project Management & Collaboration Software (e.g., Zoom, Microsoft Project)

Test your knowledge on various aspects of application software, including software ownership rights, types of software like commercial and open source, and the differences between desktop and mobile applications. This quiz will help you understand software licenses and mobile ticketing practices.