ITSS 3300 Exam 1 Review

What is Enterprise Resource Planning (ERP)?

an application found in larger clients that integrates internal and external resources including tangible assets, financial resources, materials, and HR. Best for manufacturing organizations

What is managerial decision making?

are decisions about the allocation and utilization of resources.

To use AutoSum with a row of four values, where must your cursor be to have the sum appear in the row if you have not highlighted the cells?

on the first empty cell to the right of the last cell containing a value

True or False: In an Infrastructure-as-a-Service environment, the cloud tenant is responsible for routine hardware maintenance.

False - In an IaaS environment, the cloud provider is responsible for any hardware maintenance.

True or False: You need to purchase an Azure account before using any Azure resources.

False - You can use a Free Azure Account or a Microsoft Learn Sandbox to create resources.

A company can choose its competitive strategy. True False

True

Which of the following is NOT one of the five forces in Porter's Five Forces model? Threat of new entrants Bargaining power of suppliers Bargaining power of customers lowest cost provider

lowest cost provider

The inherent processes defined in an ERP solution are referred to by some ERP vendors as ________. process blueprints process trees stored procedures database transactions transaction logs

process blueprints

What is the first step in creating a chart with Excel Office 365?

Highlight the data you want to show in the chart.

How can you access Track Changes in Microsoft Excel Office 365?

Track Changes is located under the Customize Quick Access Toolbar.

You are working in the most recent version of Excel provided by your company. Why would you use the "Save as type" pulldown menu?

You are saving the file for someone with an older version of Excel.

What is desktop virtualization?

a server hosts many versions of desktop operating systems

What is Oracle (ERP Vendor)?

in house platform, acquired by people-soft and Siebel

Why are mobile systems increasingly important?

Because mobile users can access system from any place. Hardware: increasing demand for mobile systems means more for a demand of faster and better hardware and technology.

What are the Components of a Computer?

CPU/Processor Memory (RAM) Storage Input Devices Output Devices

What is a value chain?

A set of activities that a firm operating in a specific industry performs in order to deliver a valuable product for the market.

Which action will edit locked cells in a protected worksheet?

Enter the password to turn off the protection.

What does it mean that the right mouse button is "context-sensitive"?

The menu items available will differ depending on the context of what you are right-clicking .

What is an EAI?

The software which connects the various databases that a company has...there is no single, centralized database

What is an information system?

a formal, sociotechnical, organizational system designed to collect, process, store, and distribute information.

What is PC Virtualization?

a personal computer hosts several different operating systems ex: run Windows 10 and Ubuntu on a Mac-book running macOS

What is a data warehouse?

a place where databases are stored so that they are available when needed

What is a business process?

a standardized set of activities that accomplish a specific task, such as processing a customer's order

What is granularity?

refers to the level of detail in the model or the decision-making process

What is pull publishing?

requires the user to request BI results

What are application programs?

software that helps users preform tasks ex: MS Office

The value chain contains primary activities and ___________ secondary activities supporting activities customer activities supplier activities

supporting activities

What is the role of a business process?

- A network of activities, repositories, roles(actors), resources, and flows - Interact to accomplish a business function - has an input and output

Information System Benefits

- Automative Business Process - To Innovate

What is Objective Management Group (OMG)?

A software industry standards organization that created a standard set of terms and graphical notations for documenting business processes.

What is competitive strategy?

A strategy focused on how an organization will compete within its industry

What are Porter's Five Forces

Also known as Industry and Competitive Analysis. A framework considering the interplay between (1) the intensity of rivalry among existing competitors, (2) the threat of new entrants, (3) the threat of substitute goods or services, (4) the bargaining power of buyers, and (5) the bargaining power of suppliers.

How do organizations use business intelligence systems?

BI plays a key role in the strategic planning of organizations and is used for multiple purposes, including measuring performance progress toward business goals, performing quantitative analysis, reporting and data sharing, and identifying customer insights.

IaaS (Infrastructure as a Service)

Cloud-hosted provider of virtualized servers and networks.

What are servers?

Computers that exist only to provide things to others. ex: Linux

What is a CRM system?

Customer relationship management: strategy used to learn more about customers' needs and behaviors in order to develop stronger relationships with them Best for Sales and Service orgs

What is an operational decision?

Decisions employees make each day to make the organization function.

As you are entering sales data into a new worksheet, you inadvertently type 6/31/2019. Which action will Excel take with this?

Excel will display it as 6/31/2019 but left-justified and as only a set of numbers and dashes, and not an actual date.

What are the 5 components of framework?

Hardware, Software, Data, Procedures, and People

What is Business Intelligence?

Information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals and other knowledge workers.

What is an enterprise system?

Integrated enterprise-wide information systems that coordinate key internal processes of the firm.

What are the bit sizes?

Kilobyte Megabyte Gigabyte Terabyte Petabyte

What is a thin client?

Low-cost, centrally managed computer with no internal or external attached drives for storage

You would like to filter your large worksheet down to only sales from January. Which action must you take before using the Filter feature?

Make sure your date has no empty rows or columns.

Which of the following statements about enterprise information systems is TRUE? - They promote substantial workgroup data duplication. - They support 10 to 100 users. - They are very difficult to change. - The procedures are not formalized or documented. - They do not require users to have any formal training.

They are very difficult to change.

Your worksheet includes data for your company's IT department. How can you use Find & Select to quickly capitalize the many instances of IT appearing in the worksheet?

Use the "Match entire cell contents" option under Replace.

Which of the following statements is true? - With Operating Expenses (OpEx), you are responsible for purchasing and maintaining your computing resources. - With Operating Expenses (OpEx), you are only responsible for the computing resources that you use. - With Capital Expenses (CapEx), you are only responsible for the computing resources that you use.

With Operating Expenses (OpEx), you are only responsible for the computing resources that you use.

Which primary function does the Excel Ideas feature serve?

You can explore charting variations for your data sets.

As you are working with a Pivot Table, you decide to change some of your source data. How will the Pivot Table recognize the change?

You will either have to click Refresh on the Analyze ribbon or click Alt+F5.

You want to subtract your cost of 250 in cell D6, from your selling price of 400 in cell D5, and have the result in cell D7. How would you do this so you can extend the calculation across your other products?

by typing =d5-d6

What are Porter's 4 competitive strategies?

1. cost-leadership 2. differentiation 3. cost-focus 4. focused-differentiation

What is a dynamic process?

continuously changing and provides business solutions to ever-changing business operations

What is push publishing?

delivers business intelligence to users without any request from the users

You can _____ multiple sheets at the same time by _____ them first.

edit; grouping

If you have a worksheet containing data you do not want to be sorted, what must you do before sorting?

Delineate the data you do not want to be sorted.

How can you remove a split other than by clicking the Split button under View?

by double-clicking the split line

All of the following are primary value chain activities except inbound logistics outbound logistics sales and marketing customer service human resources

human resources

Which of the following is an example of a dynamic process? - Samsung accepts the return of a defective television from its dealer. - Starbucks places an order for coffee beans from its local supplier. - Amazon.com hires customer service representatives to help customers with their online orders. - IBM orders more CPUs for a cluster. - Nike uses Facebook and Twitter to generate buzz about its new line of running shoes.

- Nike uses Facebook and Twitter to generate buzz about its new line of running shoes.

Define Management Information Systems (MIS)

The use of information systems that help organizations achieve their strategies.

Business processes determine the scope and requirements of organizational information systems. True False

True

Information systems improve process quality by ________. controlling process flow increasing purchasing power changing the work culture duplicating data entirely replacing human activity

controlling process flow

Before you create a chart in Excel, how would you have the chart appear?

Remove any totals next to your data.

If you accidentally delete a sheet that you wanted to keep, which action should you take?

Retrieve the sheet from a saved version of the file.

You are entering Sales data for each month in 2018. How can you quickly enter all 12 months in columns?

Type in January, point to the lower right-hand corner of the cell, hold down the left mouse button, and drag across the next eleven rows.

What is Big data?

a broad term for datasets so large or complex that traditional data processing applications are inadequate.

What is a content management system?

helps companies manage the creation, storage, editing, and publication of their website content

What are collaboration systems?

is an information system that supports collaboration.

What is the Architecture of an Information System?

1. Clients 2. Private or Public Networks (The Internet) 3. Server Computers

What are some negatives of cloud computing?

-Locked in a contract with a vendor -Giving up control -

Primary Value Chain Activities

inbound logistics, operations, outbound logistics, marketing and sales, service

To reduce the substantial work that needs to be done to customize an ERP application to a particular customer, ERP vendors provide ________. DIY modules industry-specific solutions process statistics service descriptions inherent processes

industry-specific solutions

The primary purpose of an ERP system is ________. customer acquisition duplication customization robotic process automation integration

integration

What are publish results?

the process of delivering business intelligence to the knowledge workers who need it

Why is IT Systems important?

Because this class will show you how technology is fundamentally changing businesses. You'll learn why executives are constantly trying to find ways to use new technology to create a sustainable competitive advantage.

What is BPMN and why is it important?

Business Process Management Notation. A global standard of documenting a process - Actors (roles) - Process steps (activities) - Swimlanes - Systems

Which of the following options is not a type of cloud computing? Distributed cloud Hybrid cloud Private cloud Public cloud

Distributed cloud

Which of the following choices is not a benefit of using cloud services? Scalability Geographic isolation Disaster Recovery High Availability

Geographic isolation You can choose to create resources in a single region; however, one of the primary advantages to cloud computing is geographic distribution.

Which of the following choices is not a cloud computing category? Platform-as-a-Service (PaaS) Networking-as-a-Service (NaaS) NaaS is not a cloud computing category. Infrastructure-as-a-Service (IaaS) Software-as-a-Service (SaaS)

Networking-as-a-Service (NaaS)

What are the major functional areas of a firm?

Purchasing, operating, warehouse, sales & marketing, research & development, finance & accounting, human resources, and Information Technology

What are the benefits of Information Systems?

Real time data, better communication, reduce risk of errors, greater productivity, and secure

What is SAP?

Systems, Applications and Products; The largest ERP Vendor

What is COBIT (Control Objectives for Information and related Technology)?

The Information Systems Audit and Control Association has created a set of standard practices

You created a bar chart with the bars for the products and the colors for the salesperson. If you click Switch Row Column, what will happen?

The bars will change to salespeople, and the colors will change to products.

How can you quickly add a border around a set of cells covering 3 rows and 12 columns?

Use Draw Border under Border on the ribbon under Home.

How would you most efficiently test a layout adjustment before printing on paper?

Use Print Preview as a trial and error.

What is the Internet of Things (IoT)?

a world where interconnected, Internet-enabled devices or "things" can collect and share data without human intervention

What are value chain activities?

activities or tasks the firm completes in order to produce products and then sell, distribute, and service those products in ways that create value for customers

What is Hadoop

an open source program supported by the Apache Foundation that manages thousands of computers and that implements MapReduce

What is a functional information system?

workgroup information systems that support a particular business function (ex. accounting department)

All of the following are examples of a competitive strategy EXCEPT - lowest costs across an industry - better product service within an industry segment - highest costs across an industry - lowest cost within an industry segment

- highest costs across an industry

Gigabyte=

1024 MB

Petabyte=

1024 TB

Kilobyte=

1024 bytes

What is a business process model?

A graphic description of a process, showing the sequence of process tasks, which is developed for a specific

What is RFM Analysis?

A technique readily implemented with basic reporting operations to analyze and rank customers according to their purchasing patterns.

What is the role of an Information System in a structured process?

- execute a process - capture, store, and process data - monitor and control the process

What is a thick client?

Also called a (Fat client) is a regular desktop computer or laptop that is sometimes used as a client by a visualization server.

What is AWS?

Amazon Web Services is a subsidiary of Amazon providing on-demand cloud computing platforms and APIs to individuals, companies, and governments, on a metered pay-as-you-go basis.

What is a static report?

BI documents that are fixed at the time of creation and do not change

What is a dynamic report?

BI documents that are updated at the time they are requested

________ are flexible, informal, and adaptive processes that normally involve strategic and less structured managerial decisions and activities. Dynamic processes Operational processes Inherent processes Malleable processes Structured processes

Dynamic processes

Firms with different competitive strategies will have identical business processes. True False

False

There is a button on the ribbon, and you are interested in learning more about its functionality. How can you access "Tell me more"?

Hover over the button, then click "Tell me more" at the bottom of the information displayed.

What is server virtualization?

a server computer hosts one or more other server computers. makes cloud computing feasable

What is a Business Process Modeling Notation (BPMN)?

a standard set of terms and graphical notations for documenting business processes. Swim-lanes with roles, processes, systems, and information

What are information silos?

an insular management system in which one information system or subsystem is incapable of reciprocal operation with others that are, or should be, related.

What are the Operating System Software?

controls the application software and manages how the hardware devices work together. ex: Windows, macOS, Unix, and Linux

Which of the following is an example of a structured process? social networking new product offerings collaboration customer returns ill-defined situations

customer returns

What are strategic decisions?

decisions that support broad-scope, organizational issues

All of the following increase the threat of new entrants except low startup costs high industry profitability high startup costs specialized knowledge or skill is not required

high startup costs

Terabyte=

1024 GB

Megabyte=

1024 KB

What is Cloud Computing?

A system in which all computer programs and data is stored on a central server owned by a company (e.g. Google) and accessed virtually

1. Which of the following statements is NOT true about cloud computing? - IaaS, PaaS, and SaaS are examples of cloud computing service models. - Cloud computing resources are usually limited to specific geographic regions. - Most cloud computing resources can be distributed to global datacenters. - Cloud computing typically decreases your operating expenses. - Three cloud computing deployment models are public cloud, private cloud, and hybrid cloud.

- Cloud computing resources are usually limited to specific geographic regions.

________ is a suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform. - Customer relationship management - Centralized process planning - Enterprise application integration - Enterprise resource planning - Business process reengineering

- Enterprise resource planning

Which ERP vendor acquired PeopleSoft and Siebel? Sage Oracle Infor Microsoft Dynamics SAP

Oracle

You would like to add some frequently used buttons to the Quick Access Toolbar. How can you do this?

Right-click the button on the ribbon and select Add.

You have numerical data across 12 rows and 4 columns. When you highlight this range of cells, and then press Average under AutoSum in the Formula ribbon, which outcome occurs?

The averages will display in the column at the end of each row and below the bottom row of each column.

One of the number cells in your worksheet shows as ###. What does this mean?

The content in the cell is wider than the cell width.

What does the Porter's Five Forces analytical model attempt to predict? The intensity of competitive rivalary between products The intensity of competitive rivalry between people The intensity of competitive rivalry in a firm The intensity of competitive rivalary in an industry

The intensity of competitive rivalary in an industry

What are structured decisions?

process is one for which there is an understood and accepted method for making the decision.

What are unstructured decisions?

process is one for which there is no agreed-on decision-making method.

____________ make it difficult for a customer to change from one product/service to a different product/service. fixed costs switching costs marginal costs optimal costs

switching costs

You are working in your company's "2018 Sales" Workbook with each column widened and a color graph. When you add a worksheet "2018 Profit," how will the new worksheet appear?

with the same formatting as "2018 Sales" before you made any changes