AIS Chapter Quizzes

Data differ from information in which way?
a. Data are output, and information is input.
b. Information is output, and data are input.
c. Data are meaningful bits of information.
d. There is no difference.

Information is output, and data are input

Which of the following is NOT a characteristic that make information useful?
a. It is accurate
b. It is timely
c. It is expensive
d. it is relevant

It is expensive

Which of the following is a primary activity in the value chain?
a. purchasing
b. accounting
c. post-sales service
d. human resource management

post-sales service

Which transaction cycle includes interactions between an organization between an organization and its customers?
a. revenue cycle
b. expenditure
c. human resources/payroll
d. general ledger and reporting system

expenditure

Which of the following is NOT a means by which information improves decision making?
a. increases information overload
b. reduces uncertainty
c. provides feedback about the effectiveness of prior decisions
d. identifies situations requiring management action

increase information overload

In the value chain concept, upgrading IT is considered what kind of activity?
a. primary activity
b. support activity
c. service activity
d. structured activity

support activity - tech stuff are support

In which cycle does a company ship goods to customers?
a. production cycle
b. financing cycle
c. revenue cycle
d. expenditure cycle

revenue cycle - involved interactions between org and its customers

Which of the following is a function of an AIS
a. reducing the need to identify a strategy and strategic position
b. transforming data into useful information
c. allocating organizational resources
d. automating all decision making

transforming data into useful information

A firm, its suppliers, and its customers collectively form which of the following?
a. supply chain
b. value chain
c. ERP system
d. AIS

supply chain

A performance report about all approved vendors during the previous 12 months is information MOST needed in which business process?
a. paying vendors
b. acquiring inventory
c. selling merchandise
d. paying employees

acquiring inventory

Which of the following is NOT a step in the data processing cycle?
a. data collection
b. data input
c. data storage
d. data processing

data collection - data collection is part of data input

All of the information (name, GPA, major) about a particular student is stored in the same
a. file
b. record
c. attribute
d. field

record - includes all info about a particular entity

Which of the following would contain the total value of all inventory owned by an organization?
a. source document
b. general ledger
c. cash budget

general ledger

Which of the following is most likely to be a general ledger control account?
a. accounts receivable
b. petty cash
c. prepaid rent
d. retained earnings

accounts receivable

Which of the following documents is most likely to be used in the expenditure cycle?
a. sales orders
b. credit memo
c. receiving report
d. job time ticket

receiving report

Which of the following is LEAST likely to be a specialized journal?
a. sales journal
b. cash receipts journal
c. prepaid insurance journal
d. cash disbursements journal

prepaid insurance journal - specialized journals record large numbers of repetitive transaction

How does the chart of accounts list general ledger accounts?
a. alphabetical
b. chronological
c. size order
d. the order in which they appear in financial statements

order in which they appear in financial statements

Which of the following is NOT an advantage of an ERP system?
a. better access control
b. standardization of procedures and reports
c. improved monitoring capabilities
d. simplicity and reduced costs

simplicity and reduced costs - ERPs are complex and costly

Records of company data sent to an external party and then returned to the system as input are called
a. turnaround documents
b. source data automation documents
c. source documents
d. external input documents

turnaround documents

Recording and processing information about a transaction at the time it takes place is referred to as which of the following?
a. batch processing
b. real-time processing
c. captured transaction processing
d. chart of accounts processing

real-time processing

A data flow diagram (DFD) is a representation of which of the following?
a. logical operation performed by a computer program
b. flow of data in an organization
c. decision rules in a computer program
d. computer hardware configuration

flow of data in an organization

Documentation methods such as DFDs, BPDs, and flowcharts save both time and money, adding value to an organization
a. True
b. False

True

Which of the following statements is FALSE?
a. flowcharts make use of many symbols
b. document flowchart emphasizes the flow of documents or records containing data
c. DFDs help convey the timing of events
d. both a and b are false

DFDs help convey timing of events - DFDs show data movements, help not necessarily the timing of the movement

A DFD consists of the following four basic elements: data sources and destinations, data flows, transformation processing, and data stores. Each is represented on a DFD by a different symbol
a. True
b. False

True

All of the following are guidelines that should be followed in naming DFD data elements EXCEPT:
a. process names should include action verbs such as update, edit, prepare, and record
b. make sure the names describe all the data or the entire process
c. name only the most important DFD elements
d. choose active and descriptive names

name only the most important DFD elements

The documentation skills that accountants require vary with their job function. However, they should at least be able to do which of the following?
a. read documentation to determine how the system works
b. critique and correct documentation that others prepare
c. prepare documentation for a newly developed information system
d. teach other how to prepare documentation

read documentation to determine how the system works

Which of the following statements is FALSE?
a. a flowchart is an analytical techniques used to describe some aspect of an information system in a clear, concise, and logical manner
b. flowcharts use a standard set of symbols to describe pictorially the flow of documents and date through a system
c. flowcharts are easy to prepare and revise when the designer utilizes a flowcharting software package
d. a system flowchart is a narrative representation of an information system

a system flowchart is a narrative representation of an information system

Which of the following flowcharts illustrates the flow of data among areas of responsibility in an organization?
a. program flowchart
b. computer configuration chart
c. system flowchart
d. document flowchart

document flowchart

All of the following are recommended guidelines for making flowcharts more readable, clear, concise, consistent, and understandable EXCEPT:
a. divide a document flowchart into columns with labels
b. flowchart all data flows, especially exception procedures and error routines
c. design the flowchart so that flow proceeds from top to bottom and from left to right
d. show the final disposition of all documents to prevent loose ends that leave the reader dangling

flowchart all data flows, especially exception procedures and error routines

How are data sources and destinations represented in a data flow diagram?
a. as a square
b. as a curved arrow
c. as a circle
d. as two parallel lines
e. none of the above

as a square

What is each row in a relational database table called?
a. tuple
b. relation
c. attribute
d. anomaly

tuple

The relational data model portrays data as being stored in
a. objects
b. hierarchies
c. tables
d. files

tables

How a user conceptually organizes and understands data is referred to as the
a. logical view
b. physical view
c. data model view
d. data organization view

logical view

Which of the following attributes would most likely be a primary key?
a. supplier name
b. supplier number
c. supplier zip code
d. supplier account balance

supplier number - unique number

Which of the following is an individual user’s view of the database?
a. internal-level schema
b. conceptual-level schema
c. external-level schema
d. logical-view scheme

external-level schema

Which of the following would managers most likely use to retrieve information about sales during the month of October?
a. DQL
b. DML
c. DSL
d. DDL

DQL - data query language; used to retrieve info from a database

The constraint that all foreign keys must have either null values or the value of a primary key in another table is referred to as which of the following?
a. referential integrity rule
b. entity integrity rules
c. foreign key value rule
d. null value rule

referential integrity rule

The constraint that all primary keys must have non-null data values is referred to as which of the following?
a. referential integrity rule
b. entity integrity rules
c. normalization rule
d. relational data model rule

entity integrity rule

Unstructured data internal or external to the organization is usually gather and stored in which of the following?
a. data dictionary
b. data lake
c. data mart
d. data warehouse

data lake

Which one of the following items would be the best primary key for a table containing information about customers
a. customer ID
b. customer full name
c. customer phone number
d. customer email address

customer ID

Which one of the following characters would be the best delimiter
a. ,
b. @
c. |
d. all of the above

| - pipe characters are rarely used in writing so it makes for a good delimiter

An online sales company designed a program to evaluate customer purchases. After each purchase, the program analyzes which product the customer is most likely to buy next and emails the customer a coupon for a discount on this new product. What type of analytics is this an example of?
a. descriptive
b. diagnostic
c. predictive
d. prescriptive

prescriptive

When sharing the results of an analysis, which of the following is NOT a key principle to follow?
a. simplify the presentation of data
b. present the visualization in a timely manner
c. ethically present the data
d. emphasize what is important

present in a timely manner

Which of the steps of an analytics mindset is the most difficult to automate?
a. ask the right questions
b. extract, transform, and load relevant data
c. apply appropriate data analytics techniques
d. interpret and share the results with stakeholders

ask the right questions - involves using creativity, understanding context, difficult to automate

All of the following characteristics of data are important in distinguishing big data from regular data EXCEPT:
a. velocity
b. variety
c. visualization
d. volume

visualization

You are given an extract of one field from a database. The field has the value “11815 N. Diamond Dr.” Which type of data is contained in this field?
a. structured data
b. unstructured data
c. semi-structured data
d. none of the above

structured data

Programming a computer program to automatically perform a task previously performed by a human is an example of which of the following?
a. warehouse data
b. ETL process
c. establishing SMART objectives
d. robotic process automation (RPA)

RPA

Good question for data adhere to all of the following principles EXCEPT:
a. accurate
b. timely
c. measurable
d. specific

accurate - related to high-quality data, but not necessarily good questions

In which step of the data transformation process would you analyze whether the data has the properties of high-quality data?
a. data structuring
b. data standardization
c. data cleaning
d. data validation

data validation

As part of the data standardization process, often items contained in different fields for the same record need to be combined into a single field. This process is called:
a. aggregating data
b. data aggregating
c. data concatenation
d. data parsing

data concatenation

Which of the following reasons why describes why transforming data is necessary?
a. data aggregated at different levels needs to be joined
b. data within a field has various formats
c. multiple data values are contained in the same field and need to be separated
d. all of the above

all of the above

A company wants to determine how to decrease employee turnover. In order to do this, they test whether paying off an employee’s student debt will cause fewer employees to leave. The analytics test of whether paying off an employee’s student debt causes lower turnover is an example of which type of analytics?
a. descriptive
b. diagnostic
c. predictive
d. prescriptive

prescriptive