I2C Ch. 4 - Study Guide

Describe the activities that occur during project development.

1. CREATING the project 2. EDITING a project 3. FORMATTING a project 4. SAVING a project 5. DISTRIBUTING a project

Identify functions of database software.

A database is a collection of data organized in a manner that allows access, retrieval, and use of that data. Database software is an application that allows users to create access, and manage a database. Using database software, you can add, change, and delete data in a database; sort and retrieve data from the database; and create forms and reports using the data in the database. With most personal computer database programs, a database consists of a collection of tables, organized in rows and columns. Each row, called a record, contains data about a given item in the database, such as a person, product, object, or event. Each column, called a field, contains a specific category of data within a record.

Identify functions of software suite software.

A software suite is a collection of individual related applications available together as a unit. Productivity suites typically include, at a minimum, word processing, presentation, spreadsheet, and email applications. While several productivity suites are designed to be installed on a local computer, some are available as web apps and enable you to share projects stored on the cloud to collaborate with other users.

List categories of programs and apps. ____________ is another word for program.

CATEGORIES: > Productivity (Business and Personal) > Graphics and Media > Personal Interest > Communications > Security > File, Disk, and System Management "Software" is another word for program.

____________ software performs functions specific to a business or industry.

CUSTOM SOFTWARE performs functions specific to a business of industry.

Identify functions of calendar and contact management software.

Calendar and contact management software helps you organize your calendar, keep track of contacts, and share this information with other users, who can view it on their computers and mobile devices. This software provides a way for individuals and workgroups to organize, find, view, and share appointment and contact information easily. Calendar and contact management applications enable you to synchronize information across all of your computers and mobile devices so that you always have the latest version of any updated information.

Applications often include a(n) ____________ gallery, which is a collection of clip art and photos.

Clip art/image gallery.

List examples of desktop and mobile operating systems.

Examples of desktop operating systems: Examples of mobile operating systems:

Differentiate among font, font size, and font style.

FONT: a name assigned to a specific design of characters. Cambria and Calibri are examples of fonts. FONT SIZE: indicated the size of the characters in a particular font. Font size is gauged by a measurement system called points. A single point is about 1/72 of an inch in height. FONT STYLE: adds emphasis to a fond. Bold, italic, underline, and color are examples of font styles.

Identify functions of legal software.

Legal software assists in the preparation of legal documents and provides legal information to individuals, families, and small businesses. Legal software provides standard contracts and documents associated with buying, selling, and renting property; estate planning; marriage and divorce; and preparing a will or living trust. By answering a series of questions or completing a form, the legal software tailors the legal document to specific needs. Many lawyers offer assistance online when using legal software web apps.

Differentiate among mobile apps, native apps, cloud apps, and web apps.

MOBILE APPS: web app that runs on a mobile device. Mobile web apps often have a responsive web design, which means the app is optimized for display in a browser on a mobile device, regardless of screen size or orientation. EXAMPLES OF MOBILE APPS: websites for shopping, banking, and online social networks accessed in a browser. NATIVE APPS: app written for a specific platform and installed on a computer or mobile device. Native apps can take advantage of specific features of the devices on which they are installed, such as a smartphone's camera or contacts list. You may install native mobile or desktop apps by downloading them from an app store, sometimes called a marketplace, or other location on the Internet. EXAMPLES OF NATIVE APPS: productivity applications, single-player games, and browsers. CLOUD APPS: makes use of software and data that are not stored on your computer or mobile device. You can access the software and data using a computer or mobile device, or without a browser, as long as it is connected to a network, such as the Internet. EXAMPLES OF CLOUD APPS: apps for accessing online social networks, web-based email services, and online calendars. WEB APPS: a special type of cloud app that is accessed by visiting a website in a browser.

Identify functions of note taking software.

Note taking software is an application that enables users to enter typed text, handwritten comments, drawings, sketches, photos, and links anywhere on a page then save the page as part of a notebook. Users can also include audio recording as part of their notes. Some enable users to sync their notes to the cloud so that they can access the notes on any computer or mobile device. Many note taking applications also include a calendar feature. Users find note taking software convenient during meetings, class lectures and conferences, and in libraries and other settings where they would record written notes in a notebook.

Identify functions of retail apps.

Online marketplaces and payment services support buying and selling items and transferring funds from one party to another. Marketplace apps enable customers to research products, submit or examine product reviews, and make purchases. A retail store mobile

Define these terms: operating system, tools, and system software.

Operating system: a set of programs that coordinates all the activities among computer or mobile device hardware. Tools: programs that enable you to perform maintenance-type tasks usually related to managing devices, media, and programs used by computers and mobile devices. System software: the operating system and other tools are collectively known as system software because they consist of the programs that control or maintain the operation of the computer and its devices.

Identify tools word processing programs provide that can assist you when writing.

TOOLS WORD PROCESSING PROGRAMS PROVIDE: > A SPELLING CHECKER reviews the document for spelling errors. > A GRAMMAR CHECKER detects passive voice, run-on sentences, and grammatical errors. > A FORMAT CHECKER identifies extraneous spaces, capitalization errors, and more. > A BIBLIOGRAPHY TOOL can generate and format a bibliography from information provided about references cited in a paper.

Explain the purpose of a license agreement.

The license agreement provides specific conditions for use of the software, which a user typically must accept before using the software.

Describe when you should use a database and when to use a spreadsheet.

Use a DATABASE PROGRAM if you want to collect, reorganize and filter data, and/or create reports from the data. SPREADSHEET PROGRAMS are ideal for calculating results or crating charts from value in the worksheet.

Define the following terms: worksheet and function.

WORKSHEET: rows and columns used to organize data in a spreadsheet. FUNCTION: a predefined formula that performs a calculation, such as adding the values in a group of cells or generating a value, such as teh current time or date.

Identify functions of financial apps.

You can access bank accounts or investments using a financial app. Financial mobile apps track expenses as you spend money and notify you when a bill is due. To help secure information, financial mobile apps can disable access if your device is stolen or lost. Some banking mobile apps allow you to upload a photo of a check taken with the device's camera to process the deposit

Identify functions of accounting software.

Accounting software is an application that helps businesses of all sized record and report their financial transactions. With accounting software, business users perform accounting activities related to the general ledger, accounts receivable, accounts payable, purchasing, invoicing, and payroll functions. Accounting software also enables business users to write and print checks, track checking account activity, and update and reconcile balances on demand. Most accounting software supports online credit checks, bill payment, direct deposit, and payroll services. Some offer more complex features, such as job costing and estimating, time tracking, multiple company reporting, foreign currency reporting, and forecasting the amount of raw materials needed for products.

Name the types of software used by various functional units in an enterprise.

1. Human resources software 2. Accounting software 3. Engineering or product development software 4. Manufacturing software 5. Marketing software 6. Sales software 7. Distribution software 8. Customer service software 9. Information technology staff

List types of productivity applications.

> word processing ? presentation > spreadsheet > database > note taking > calendar and contact management > project management > accounting > personal finance > legal > tax preparation > document management > enterprise computing

Identify functions of enterprise computing software.

A large organization, commonly referred to as an enterprise, requires special computing solutions because of its size and geographic distribution. A typical enterprise consists of a wide variety of departments, centers, and divisions - collectively known as functional units. Nearly every enterprise has the following functional units: human resources, accounting and finance, engineering or product development, manufacturing, marketing, sales, distribution, customer service, and information technology. S oftware used in function units is not mutually exclusive; however, each functional unit in an enterprise uses specific software as outlined below. > HUMAN RESOURCES SOFTWARE manages employee information, such as pay rate, benefits, personal information, performance evaluations, training, and vacation time > ACCOUNTING SOFTWARE manages everyday transactions, such as sales and payments to suppliers. > FINANCE SOFTWARE helps managers budget, forecast, and analyze. > ENGINEERING or PRODUCT DEVELOPMENT SOFTWARE allows engineers to develop plans for new products to test their product designs. > MANUFACTURING SOFTWARE assists in the assembly process, as well as in scheduling and managing the inventory of parts and products. > MARKETING SOFTWARE allows marking personnel to create marketing campaigns, target demographics, and track their effectiveness. > SALES SOFTWARE enables the salesforce to manage contacts, schedule meetings, log customer interactions, manage product information, and take customer orders. > DISTRIBUTION SOFTWARE analyzes and tracks inventory and manages product shipping status. > CUSTOMER SERVICE SOFTWARE manages the day-to-day interactions with customers, such as phone calls, email messages, web interactions, and messaging sessions. > INFORMATION TECHNOLOGY STAFF use a variety of programs and apps to maintain and secure the hardware and software in an enterprise.

Identify functions of text editor software.

A text editor is used to type information when it does not need to be formatted with fonts, page numbers, or other styles. Many programmers and web develops use text editors to enter the programming or HTML code used for building applications or websites.

Identify functions of calendar and email apps.

Calendar apps keep track of your appointments and synchronize information entered on a mobile device with your online or desktop calendar software. Email apps integrate with your device's address book to facilitate sending messages to people whose names are stored in your device's contact list, and allow you to access and send photos stored in your device's photo gallery.

Identify functions of reference apps.

Dictionaries, encyclopedias, books, and directories are available online as reference apps. Many have associated mobile apps that format information for mobile devices or take advantage of their features. For example, rather than typing a search term in a dictionary web app to look up it's definition, a mobile app also might offer web input. Some reference mobile apps also can download information directly to your phone for offline access.

Identify functions of document conversion and readers software.

Document conversion software saves documents created in any application into a common format that has the same appearance as the original document. A popular image file format used to save converted documents is PDF (Portable Document Format), developed by Adobe Systems. Productivity applications, such as word processing and spreadsheet programs, often integrate the ability to save a project in PDF format. To interact with a PDF file, you need a PDF reader application, such as Adobe Reader, which can be downloaded free from Adobe's website. With a document reader, you can view, create, search , convert, annotate, edit, share, and print documents. You do not need the software that created the original document. Some readers allow you to complete forms and add your signature to documents.

List safety considerations when using personal finance apps.

EVALUATE THE APPS > If you want an app from a bank or other financial institution, visit that company's website for instructions about downloading and installing it's authentic apps. USE STRONG PASSWORDS TO ACCESS THE APPS > Many of the more secure personal finance apps have dual passwords that involve typing a string of characters and also validating a picture. GUARD YOUR SMARTPHONE > According to Consumer Reports, more than 5.2 million Americans lost or had their phones stolen in a recent year. > Many phones also have a kill switch that renders the phone inoperable or remotely wipes the phone's data after too many unsuccessful login attempts. VERIFY THE TRANSACTIONS > Always verify your transactions by scrutinizing monthly statements. > In addition, periodically check balances and alert your financial institution if any activity seems abnormal.

Identify functions of personal finance software.

Personal finance software is a simplified accounting application that helps home users and small/home office users balance their checkbooks pay bills, track personal income and expenses, verify account balances, transfer funds, tract investments, and evaluate financial plans. Personal finance software helps determine where, and for what purpose, you are spending money so that you can manage your finances. Most personal finance software includes financial planing features, such as analyzing home and personal loans, preparing income taxes and managing retirement savings. Other features include managing home inventory and setting up budgets. Most of these applications offer a variety of online services, such as online banking and online investing.

Identify functions of presentation software.

Presentation software is an application that allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group. Presentation software typically provides a variety of predefined presentation formats that suggest complimentary colors for backgrounds, text, and graphical accents on the slides. This software also provides a variety of layouts for each slide, such as a title slide,a two-column slide, a slide with clip art, a chart, a table, or a diagram, along with tools for arranging text in various configurations. Presentation software also incorporates features such as checking spelling, formatting, researching, and creating web pages from existing slide shows.

Identify ways you can manage a project using project management software.

Project management software helps users manage project variables, such as the tasks required to complete a project and the allotted time and resources for each, allowing them to complete a project on time and within budget. A marketing manager, for example, might use project management software to schedule the processes required in a product launch.

Identify functions of project management software.

Project management software is an application that allows a user to plan, schedule, track, and analyze the events, resources, and costs of a project. Project management software helps users manage project variables, such as the tasks required to complete a project and the allotted time and resources for each, allowing them to complete a project on time and within budget.

Identify functions of travel apps.

Purchasing flights, hotels, rental cars, or travel services is a common online task for personal and business travelers. Travel apps display available options and allow you tot filter results. Many allow you to share travel plans with your online social networks.

Describe how an operating system interacts with the computer.

STEP 1: An operating system user interface is displayed on the screen when a user turns on a computer. STEP 2: The user instructs the operating system to run an applications, such as a word processing application , which appears on the user's screen. The user then instructs the application to print a document. STEP 3: The application sends the print instruction to the computer's operating system (software), which is running on the computer. STEP 4: The operating system sends the print instruction to the printer (hardware), which prints the document.

Identify functions of scanning apps.

Scanning apps use a mobile device's camera to scan a QR code or a bar code. A QR code is a square shaped graphic that represents a web address or other information. A QR code reader app scans a QR code, and then displays its corresponding information. Some messaging apps provide codes representing contact information. By scanning the code displayed on the screen of a friend's mobile device, you can add your friend's contact information to your contacts or online social network. A bar code scanner reads a bar code and may provide product information, price, or reviews. Some supermarkets provide shopping apps for customers to scan bar codes of items they purchase. These apps create a customized shopping list, ordering items by their aisle location in the store, to provide a more efficient shopping experience.

List advantages of using a software suite.

Software suites offer three major advantages: ease of use, integration, and lower cost. 1. Software suites provide ease of use because the application sin the suite normally use a consistent interface and share features, such as clip art and spelling checker. 2. Applications in a software suite often are integrated, which makes it easy to share information among them. For example you can copy a chart on a worksheet created in a spreadsheet program and paste it into a slide created with presentation software. 3. When your purchase a software suite, the suite usually costs significantly less than purchasing each application individually, or as stand-alone applications.

Identify functions of spreadsheet software.

Spreadsheet software is an application that allows users to organize data in columns and rows and perform calculations on the data. These columns and rows collectively are called a worksheet. Most spreadsheet software has basic features to help users create, edit, and format worksheets. A spreadsheet file also is known as a workbook because it can contain thousand of related individual worksheets. Data is organized vertically in columns and horizontally in rows on each worksheet. One of more letters identify each column, and a number identifies each row. A cell is the intersection of a column and a row. For example,, the intersection of column B and row 4 is referred to as cell B4. A FUNCTION is a predefined formula that performs a calculation, such as adding the values in a group of cells or generating a value, such as the current time and date. Spreadsheet applications contain many built-in functions to perform financial, mathematical, logical, date and time, and other calculations. Many spreadsheet applications allow users to write their own customized functions to perform special purpose calculations. One of the more powerful features of spreadsheet software is its capability to recalculate the rest of the worksheet when data in a cell changes. Spreadsheet software's capability of recalculating data also makes it a valuable budgeting, forecasting, and decision-making tool. Another standard feature of spreadsheet software is charting , which depicts the data in graphical form, such as bar charts of pie charts.

Identify functions of tax preparation software.

Tax preparation software is an application that can guide individuals, families, or small business through the process of filing federal and state taxes. These programs forecast tax liability and offer money-saving tax tips, designed to lower your tax bill. After you answer a series of questions and complete basic forms, the software creates and analyzes your tax forms to search for missed potential errors and deduction opportunities. Once the forms are complete, you can print any necessary paperwork; then, they are ready for filing. Some tax preparation programs also allow you to file your tax forms electronically, a process called e-filing.

Identify functions of word processing software.

Word processing software is an application that allows users to create and manipulate documents containing text and sometimes graphics. People use word processing software to develop documents such as letters, memos, reports, mailing labels, and newsletters. Word processing software has many features to create professional and visually appealing documents. For example, you can change the font, size, and color of characters; apply special effects, such as three-dimensional shadows; use built-in styles to format documents; and organize text in newspaper-style columns. Word processing software allows users to incorporate graphics, such as digital photos and clip art, in documents. With word processing software, you can easily modify the appearance of an image after inserting it in the document. Word processing software typically includes tools to assist you with the writing process. For example, a spelling checker reviews the document for spelling errors. A grammar checker detects passive voice,, run-on sentences, and grammatical errors. A format checker identifies extraneous spaces, capitalization errors, and more.