csc part 2

• Not long ago, trained specialists were required to perform many of the operations you can now do with a personal computer
• Competent end users


  Need to understand the capabilities of basic application software including word processors, spreadsheets, presentation programs, and database management systems
• Three categories of application software

  • General-purpose applications
  • Specialized applications
  • Mobile apps
• Retail software


  Mass-produced, copyrighted software that meets the needs of a wide variety of users, not just a single user or company
• Custom software


  Performs functions specific to a business or industry, usually costs more than retail software
• Web app


  An application stored on a web server that you access through a browser
• Mobile app


  An application you download from a mobile device's app store
• Mobile web app


  A web app that is optimized for display in a browser on a mobile device, regardless of screen size or orientation
• Shareware


  Copyrighted software that is distributed at no cost for a trial period, with payment entitling the user to the fully functional product
• Freeware


  Copyrighted software provided at no cost by an individual or a company that retains all rights to the software
• Open source


  Software provided for use, modification, and redistribution, often downloaded from a web server on the Internet at no cost
• Public domain


  Software that has been donated for public use and has no copyright restrictions
• Graphical User Interface (GUI)

  • Consists of icons, pointer, windows, menus, toolbars, buttons, and dialog boxes
• Microsoft Ribbon GUI


  • Includes ribbons, tabs, groups, contextual tabs, galleries, spell checkers, alignment, font and font sizes, tables, and reports
• General-purpose applications


  • Word processor programs
  • Spreadsheet programs
  • Presentation graphics programs
  • Database management systems (DBMS)
  • Browser
  • Communication software
• Word processor programs


  Create text-based documents such as memos, letters, faxes, newsletters, manuals, and brochures
• Flyer features in word processing

  • Spell checker
  • Center-alignment
  • Grammar checker
  • Fonts
  • Font sizes
  • Word wrap
  • Character effects
• Report features in word processing

  • AutoCorrect
  • Footnote
  • Header or footer
  • Captions and cross references
  • Tables
• Spreadsheet programs


  Organize, analyze, and graph numeric data
• Features of a sales forecast spreadsheet

  • Worksheets
  • Text entries
  • Functions
  • Cells
  • Formulas
• Analysis features in spreadsheets

  • Workbook and worksheets
  • What-if analysis
• Presentation graphics programs


  Combine a variety of visual objects to create visually interesting presentations
• Features of a presentation

  • Document theme
  • Animation
  • Templates
• Database management systems (DBMS)


  A collection of related data, the electronic equivalent of a file cabinet
• Features of creating a database

  • Primary key
  • Fields
  • Record
  • Table
  • Form
• Browser


  Special internet software connecting you to remote computers, opening and transferring files, displaying text and images, and providing an uncomplicated interface to the Internet and web documents
• Examples of browsers


  • Internet Explorer
  • Mozilla Firefox
  • Google Chrome
• Communication software uses


  • Blog
  • Browsing
  • Chat
  • Online discussion
  • Email
  • File transfer
  • Internet phone
  • Instant messaging
  • Mobile messaging
  • Videoconference
  • Web feeds
• Specialized applications


  • Graphics programs
  • Video game design software
  • Web authoring programs
  • Artificial intelligence
  • Virtual reality
  • Other specialized applications
• Desktop publishing programs


  Also known as page layout programs, mix text and graphics to create brochures, newsletters, newspapers and textbooks
• Desktop publishing programs


  • Adobe InDesign
  • Microsoft Publisher
  • QuarkXPress
• Image editors


  Also known as photo editors, edit or modify digital photographs consisting of thousands of pixels that form images known as bitmaps

  
• Image editors


  • Adobe Photoshop
  • Corel PaintShop Pro
  • GIMP (GNU Manipulation Program)
  • Windows Live Photo Gallery
• Illustration programs


  Drawing programs that create and edit vector images, which are geometric shapes or objects defined by mathematical equations
• Illustration programs


  • Adobe Illustrator
  • CorelDraw
  • Inkscape
• Video editors


  Edit videos to enhance quality and appearance, including using smartphones
• Video game design software


  Helps organize thoughts, guide the user through the game design process, and develop characters and environments
• Free/inexpensive video game design software

  • YoYo GameMaker
  • Stencyl
  • Unity
• Web authoring programs


  Used to create commercial websites, including web page editors or HTML editors with WYSIWYG (what you see is what you get) interfaces
• Web authoring programs


  • Adobe Dreamweaver
  • Microsoft Expression Web