Page 1 of 7 Chapter 3 Application Software Application Software What is application software? • Programs that perform specific tasks for users • Also called a software application or an application • Several reasons to use application software • To assist with graphics and multimedia projects • To serve as a productivity/business tool • To facilitate communications • To support household activities, for personal/business, or for education What are the categories of application software? • Productivity/Business • Graphic Design/Multimedia • Home/Personal (Education) • Communications What is system software? • Programs that control the operations of the computer • User Interface • Serves as the interface between the user, the application software, and the computer's hardware –Icon –Pointer What is an antivirus program? • A utility that prevents, detects, and removes viruses from a computer’s memory or storage devices • Some viruses destroy or corrupt data What is a menu? • A menu contains commands you can select • Start button • Start menu • Command • All Programs submenu • Accessories submenu • Imaging program commandPage 2 of 7 What is an application window? • A rectangular area of the screen that displays a program, data, and/or information • Paint window • Shortcut menu • Title bar • Toolbar What is a dialog box? • A special window that provides information, presents available options, or requests a response • Option buttons • Command buttons • Print dialog box Productivity Software What is productivity software? • Software that assists people in becoming more effective and efficient • Presentation Graphics – Microsoft PowerPoint • Personal Information Manager – Microsoft Outlook • Software Suite – Microsoft Office • Project Management – Microsoft Project • Accounting – Intuit QuickBooks What is word processing software? • Allows users to create and manipulate documents that contain text and graphics • Word window • Printed document What is clip art? • A collection of drawings, diagrams, and photographs that you can insert into documents What are some word processing features? • Word wrap • Specify margins • Scrolling What is a major advantage of using a word processor? • You can easily insert, delete, or rearrange words, sentences, paragraphs or entire sections • Clipboard • Find and replace • Spelling and grammar checkerPage 3 of 7 What are other popular word processing features? What are the stages of developing a document? • Creating • Editing • Formatting • Saving • Printing What is a font? • A name assigned to a specific design of characters • Font size specifies the size of the characters in a particular font in points • A single point is about 1/72 of an inch in height • Font style adds emphasis to a font such as bold, italic, and underline What is a file? • A named collection of data, instructions, or information • Each file has a file name • File name on title bar What is voice recognition? • The computer’s capability of distinguishing spoken words What is spreadsheet software? • Allows you to organize data • Performs calculations • Called a worksheet or spreadsheet How is a spreadsheet organized? • Columns identified by letters • Rows identified by numbers • A cell is the intersection of a column and row What can a cell contain? • Label • Number • Formula What is a function? • A predefined formula that performs common calculations What is recalculation? • The capability of recalculating the rest of the worksheet when data in a worksheet changesPage 4 of 7 • What-if analysis What is charting? • Allows you to display spreadsheet data in graphical form • Line chart • Pie chart • Column chart What is a database? • A collection of data organized in a manner that allows access, retrieval, and use of that data What is database software? • Allows you to create, access, and manage a database • Also called a database management system (DBMS) • Add, change, delete data • Sort and Retrieve data • Create forms and reports using the data What are the parts of a database? • A table contains records • Item table • Supplier table • A record is a row in a table that contains information about a given person, product, or event • A field is a column in a table that contains a specific piece of information within a record How is a database organized? • Records and fields in a table are described by the table structure What does the table structure contain for each field? • Field Name • Field Size • Data Type How do you extract information from a database? • Sort records in a particular order • Query database What is presentation graphics software? • Used to create documents that communicate ideas and messages What is slide sorter view? • View of small versions of all the slides What is a personal information manager (PIM)?Page 5 of 7 • An application that includes an appointment calendar, address book, and other features • Organize personal information on both desktop and handheld computers • Synchronization What is a software suite? • A collection of individual applications sold as a single package • Two major advantages: • Lower Cost • Ease of use • VS. Integrated software package What is project management software? • Allows you to plan, schedule, track, and analyze the events, resources, and costs of a project What is accounting software? • Helps companies record and report their financial transactions Graphics and Multimedia Software What are some popular graphics and multimedia software products? • CAD • Desktop Publishing (Pro) • Paint/Image Editing (Pro) • Video and Audio Editing • Multimedia Authoring • Web Page Authoring What is computer-aided design (CAD)? • Software that allows you to create engineering, architectural, and scientific designs What is desktop publishing software? • Enables you to design and produce sophisticated documents that contain text, graphics, and brilliant colors What is paint/image editing software? • Used to create and modify graphical images • Sometimes called illustration software What is video and audio editing software? • Video editing software allows you to modify a segment of a