itech

• Application software


  Software used to perform specific tasks
• Commercial software


  Copyrighted software that is developed usually by a commercial company, for sale to others
• Shareware


  Copyrighted software distributed on the honor system; consumers should either pay for it or uninstall it after the trial period
• Freeware


  Copyrighted software programs that are given away by the author for others to use free of charge
• Public domain software


  Software that is not copyrighted and ownership rights have been donated to the public domain
• Open source software


  Programs with source code made available to the general public
• Mobile software


  Specifically designed for a specific type of mobile device
• Installed software


  Must be installed on the computer before it can be run
• Web-based software


  Run directly from the Internet, also called Software as a Service (SaaS) and cloudware
• Software suite


  Collection of software programs bundled together and sold as a single software package
• Office suites


  • Typically include word processing, spreadsheet, database, and presentation graphics software, as well as additional productivity tools
• Common software commands


  • Toolbars, menus, command buttons, keyboard shortcuts, ribbon, mini toolbar
• Ribbon


  Used in Microsoft Office 2007 and later, commands are organized into groups located on tabs, contextual
• Insertion point


  Indicates the current location in a document, where changes will be made
• Formatting a document


  Changing the appearance of the document, such as font, spacing, margins, etc.
• Word processing


  Using a computer and word processing software to create, edit, save, and print written documents
• Word processing software


  Application software used to create, edit, save, and print written documents
• Common word processing programs

  • Microsoft Word, Corel WordPerfect, Apple Pages
• Creating a word processing document

  • Word wrap, character formatting, paragraph formatting, page formatting, document formatting
• Word processing document elements

  • Tables, graphics, templates
• Spreadsheet software


  Used to create electronic spreadsheets
• Spreadsheet


  Document containing a group of numbers and other data organized into rows and columns
• Worksheet


  A single spreadsheet
• Workbook


  A collection of worksheets saved in a single file
• Common spreadsheet programs


  • Microsoft Excel, Corel Quattro Pro, Apple Numbers
• Entering data into a spreadsheet cell

  • Labels, constant values, formulas, functions
• Relative cell references


  Cell addresses are adjusted as the formula is copied
• Absolute cell references


  Cell addresses are not adjusted as the formula is copied
• Spreadsheet features


  • Charts, what-if analysis, goal seeking
• Database


  A collection of related data that is stored in a manner enabling information to be retrieved as needed
• Database management system (DBMS)


  Software that allows the creation and manipulation of an electronic database
• Common database programs


  • Microsoft Access, Oracle Database, IBM DB2
• Relational database organization


  • Fields (columns), records (rows), tables
• Query


  A question; a request for specific information from the database
• Report


  Created when a more formal output is desired from a database, displays data in a specified format
• Presentation graphic


  An image designed to visually enhance a presentation
• Slide


  A one-page presentation graphic that can be displayed in a group with others to form an electronic slide show
• Presentation graphics programs

  • Microsoft PowerPoint, Corel Presentations, Apple Keynote
• Creating a presentation

  • Templates and preformatted slide layouts, adding new slides, including text, images, charts, audio, video, formatting, adding multimedia and animation
• Finishing a presentation

  • Slide sorter view, automatic or manual slide show, speaker notes and tools