McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Click-Alongs
Interactive Companion
Web Summary
Multiple Choice Quiz
Fill in the Blanks
True or False
Knowledge in Action
Essay Quiz
Click-along
Crossword Puzzle
IT Challenge
IT Word Scramble
Feedback
Help Center


Using Information Technology Intro: A Practical Introduction to Computers and Communications, 5/e
Stacey Sawyer
Brian K. Williams

SOFTWARE: The Power behind the Power

Web Summary

  1. System Software. Three basic components of system software are operating systems, device drivers, and utility programs. An operating system is the principal component of system software. Device drivers allow input/output devices to communicate with the rest of the computer system. Utility programs provide functions (such as data recovery) not supplied by other system software.

    The operating system (OS) consists of the master system of programs that manage the basic operations of the computer. Features of the OS are booting, CPU management, file management, task management, and formatting. (1) In booting, the OS is loaded into the computer's main memory. (2) The supervisor or kernel manages the CPU. The OS also manages memory. (3) In file management, the OS records the storage location of files. (4) Task management includes multitasking, executing more than one program concurrently. (5) Formatting, or initializing, consists of preparing a disk to store data or programs.

    Device drivers are specialized software programs that allow input and output devices to communicate with the rest of the computer system. Utility programs perform tasks related to the control and allocation of computer resources. They enhance existing functions or provide services not supplied by other system software programs. Tasks performed by utilities include the following: backing up data, recovery of lost data, and identification of hardware problems.

    The user interface is the display screen that enables user interaction with the computer via keyboard or via the mouse, which has an onscreen pointer. Today's screens have a graphical user interface (GUI), in which a desktop, or main interface screen, allows you to select from icons (little pictorial symbols) or menus (lists of activities). Most icons have a rollover feature that pops up an explanation when a mouse rolls over it. Menus may be pull-down (from the screen top), fly-out (explode out to the right), pull-up (from screen bottom), and pop-up (anywhere on screen). A title bar contains the name of the window. A menu bar contains the names of pull-down menus. A toolbar displays icons and menus representing frequently used options or commands. The data and programs appear in a frame called a window, which can be resized or repositioned on screen. Most toolbars contain a Help command to provide answers to questions; for some specific tasks, context-sensitive help is available.

    There are three categories of platforms, or particular combinations of processors and OSs -- for desktops/laptops, for networks, and for handhelds.

    Principal desktop/laptop OSs are DOS, Macintosh OS, and the Microsoft Windows series. DOS was Microsoft's original OS. The Macintosh operating system runs only on Apple Macintoshes. Microsoft Windows 95, 98 and most recently Me is the most popular OS for desktops and portables.

    Principal network server OSs are NetWare from Novell; Windows NT and its successor Windows 2000 from Microsoft; the recently-released Microsoft XP which combines elements of Windows Me and Windows 2000, and has a new GUI;

    Unix, available in several versions, including Sun's Solaris; and Linux, a free version of Unix and a kind of open-source software modifiable by anyone.

    Principal OSs for handhelds are Palm OS, which runs the Palm and the Visor, and Windows CE (a slimmed-down version of Windows), which became Pocket PC, a simpler version.

  2. Application Software. There are five ways of obtaining application software. (1) You can use commercial software, which is copyrighted and is available for a fee under software license, meaning it may not be duplicated without permission. (2) You can freely duplicate public-domain software, which is not copyrighted. (3) You can use copyrighted shareware, which is distributed free but requires a fee for continued use. (4) You can use freeware, which is copyrighted but distributed free. (5) You can lease rentalware, the concept behind ASPs. To learn software you can use step-by-step tutorials (lessons) or documentation (reference guides).

    The purpose of application software is to manipulate raw data into files of information. A file is a named collection of data or a program existing in secondary storage. Three types are document files (created by word processing), worksheet files (created by spreadsheets), and database files (created by database management programs). Files can be imported or acquired from other programs and exported or sent to other programs.

    Productivity software, which is designed to make users more productive, may exist in stand-alone form, such as word processing or spreadsheet programs. Or several programs may be combined in an office suite. Some productivity software exists as groupware, which several users may share online.

  3. Word Processing. Perhaps the most useful productivity program is word processing software (Microsoft Word, Corel WordPerfect), which allows you to create, edit, format, print, and store text material, using mouse and keyboard. A computer keyboard contains special-purpose keys to enter, delete, and edit data and execute commands and functions keys (F1, F2, etc.) for executing commands specific to the software. Several keystrokes may be combined in one or two keystroke commands -- a macro.

    Three features that help you create documents are the cursor, the movable symbol on the display screen; scrolling, the ability to move up, down, or sideways through the text; and word wrap, which continues text on the next line automatically when you reach the end of a line. An outline feature enables you to show the hierarchy of headings within a document. Features for editing documents are insert and delete, undelete, find and replace, cut/copy and paste, spelling checker, grammar checker, and thesaurus (for presenting alternate words).

    Formatting, or determining the appearance of a document, is made easier by templates, preformatted documents, and wizards, which answer your questions and format a document. Aspects of formatting are fonts, or typefaces and type sizes; spacing and columns; margins and justification (spacing of words in a line); page numbers and page headers/footers (repeated text at top/bottom); and other formatting such as use of clip art (ready-made pictures). The manufacturer usually specifies automatically standardized format settings, or default settings. Most programs give several options for printing out documents. Documents may be saved, or preserved, in secondary storage, such as hard disk.

  4. Spreadsheets. The electronicspreadsheet, now simply called the spreadsheet (Microsoft Excel, Corel Quattro Pro, Lotus 1-2-3), allows you to create tables and financial schedules by entering data and formulas into rows and columns arranged as a grid. A spreadsheet file contains worksheets, or single tables, with several related worksheets collected into a workbook.

    Spreadsheet grids are organized with column headings across the top, row headings down the left side, and various labels or descriptive text. Columns and rows intersect in a cell, and its position is called a cell address; several adjacent cells constitute a range. A number entered in the cell is called a value, and its location is indicated by a cell pointer or spreadsheet cursor.Formulas, or instructions for calculations, are used to manipulate data; built-in formulas are called functions. Values can be changed and then recomputed; such recalculationis an important reason for the popularity of the spreadsheet, since it allows you to do what-if analysis -- to see how changing numbers can change outcomes. For specialized needs, worksheet templates, custom-designed forms, are available. A nice feature of spreadsheets is the ability to create analytical graphics, graphical forms -- such as bar charts, line graphs, and pie charts -- that make numeric data easier to analyze.

  5. Database Software. A database is a collection of interrelated files, and database software (Microsoft Access, Corel Paradox, Lotus Approach) is a program that controls the structure of a database and access to the data. The most widely used form is the relational database, in which data is organized into related tables. Each table contains records (rows) and fields (columns). The records within the various tables in a database are linked by a key field, a common identifier that is unique, such as a Social Security number.

    You can find what you want with a query, locating and displaying records. Records can also be sorted, as alphabetically, numerically, or geographically. Search results can then be saved, or they can be put into different formats, printed out, copied and placed in other documents, or transmitted (as via e-mail) to someone else. A specialized type of database software is a personal information manager (PIM), which helps you manage addresses, appointments, and to-do lists.

  6. Specialty Software. Among the many thousands of specialized productivity programs available, the following are important. Presentation graphics software (Microsoft PowerPoint, Corel Presentations, Lotus Freelance Graphics) uses graphics, animation, sound, and data to make visual presentations, commonly called slide shows. Design templates and content templates are available to help users get started. Material may be viewed from several perspectives (Outline, Slide, Notes Page, Slide Sorter, and Slide Show views). Presentations may be dressed up with clip art, textures, audio clips, and the like.

    Financial software includes personal-finance managers, entry-level accounting programs, and business financial-management packages. Personal-finance managers (Quicken, Microsoft Money) help users track income and expenses, write checks, do online banking, and plan financial goals. Tax programs help with tax preparation and filing. Some financial programs automate bookkeeping and payroll tasks. Others help in business start-ups or in making investments.

    Desktop-publishing (DTP) software (QuarkXPress, PageMaker, Microsoft Publisher) enables users to mix text and graphics to produce high-quality output for commercial printing. Users can choose various type and layout styles and can use files (text, graphics) from other programs. Drawing programs allow users to design and illustrate objects and products; painting programs allow them to simulate painting on screen.

    Project management software helps users plan and schedule the people, costs, and resources required to complete a project on time.

    Computer-aided design (CAD) programs are used to design products, structures, engineering drawings, and maps. CAD/CAM software -- for computer-aided design/computer-aided manufacturing -- allows products designed with CAD to be input automatically into an automated manufacturing system that makes the products.

  7. Online Software & Application Software Providers. Application service providers _ASPs_ are firms that lease software over the Internet. ASPs fit the strategy of users of network computers -- thin clients, or inexpensive, stripped-down computers that connect to networks and run applications tied to servers. ASPs were anticipated by enterprise resource planning (ERP) software, which consists of large client/server software applications that help companies organize and operate their businesses. With ASPs, however, clients can rent instead of buy software to run off of servers.




McGraw-Hill/Irwin