WGU D075-OA Study Guide
- CAD software can test the product design.
- Designs are easily transferred to automated manufacturing tools.
- Product changes can be easily made. ANS: Which advantages do computer-aided design and
computer-aided manufacturing (CAD and CAM) provide the manufacturing process?
Choose 3 answers.
- It is a process to capture information about the business's customers.
- It provides communication tools and channels.
- It facilitates marketing strategies to increase business. ANS: Which three benefits does a customer
relationship management system (CRM) provide to a business?
Choose 3 answers.
Chief information officer (CIO) ANS: Who does the CTO report to?
[Average_range] ANS: The cells to average. This is optional, and if omitted, the cells in the range
argument are averaged together.
[range_lookup] ANS: A Boolean to indicate an exact match or approximate match. Default=TRUE-
approximate match.
[Sum_range] ANS: The cells to add together. This is optional, and if omitted, the cells in the range
argument are added together.
[value_if_false] ANS: Used to specify the result of the IF function if the Boolean expression is FALSE.
,[value_if_true] ANS: Used to specify the result of the IF function if the Boolean expression result is
TRUE.
The Internet of Things (IoT) ANS: Which technology necessitated the development and implementation
of Internet Protocol version 6 (IPv6)?
1) A technology that captures all the information listed above and puts it into a structure where reports
can be run, analyses can be done, and information can be gleaned to support the business.
2) A strategy whereby a company uses the CRM to increase business by having the customers know the
CRM is there and use it to their advantage. For example, how many clicks does it take to buy something
from Amazon once you are a customer? CRM reduces the clicks, thereby reducing the time and
increasing the convenience to purchase from them.
3) A process that a company uses to its advantage to manage relationships with customers. ANS: What
is a CRM to a business?
=C3>70 ANS: Maria recently received a large set of data containing new employees' exam scores. She
was asked to prepare the data for analysis. The first task is to identify whether each of the new
employees received a score over 70. She is going to use Boolean logic to return "TRUE" if the new
employee's score is over 70 and "FALSE" otherwise.
What should she type in cell D3 below?
=SUM(F3:F17) ANS: What is the correct Excel function expression to calculate the total of all of the
scores (column F) in cell C2?
What are the steps in the decision making process? ANS: 1) Identify the decision that needs to be made.
,2) Gather the relevant information. In a DSS, ensure that the system is using the correct information and
run the DSS process to see what the outcomes are.
3) Identify the alternatives. Run the DSS using different parameters that match the qualifications for
making the decision.
4) Weigh all the components and assign probabilities of success, using the DSS output as the baseline.
The DSS can assign probabilities based on input data and the selection of criteria.
5) Choose the best alternative that meets the requirements of the decision.
6) Implement the decision.
7) Review and monitor the results of the decision.
What is the process for launching a mobile app? ANS: 1) Sketch out the app idea to understand the
flow.
2) Do market research to determine whether the app is unique and has a market.
3) Create a mockup of the app to nail down the flow, decisions, and displays.
4) Create the graphic design of the app. Look at areas of human interaction, color, flow, and ease of use.
5) Build the app landing page or a home page, which is a dedicated page of the mobile app to describe
the functions of the app.
, 6) Code the app with the programming language of choice.
7) Launch the app in the app store, for both iPhone and Android.
8) Market the app to reach the targeted demographic, and use the marketing principles defined in an
earlier section.
9) Improve your app with user feedback. Responding to users in a timely fashion is key to the success of
the app because in an online environment, everyone "hears" the complaints and the praises.6.03 GB of
15 GB used
Terms · Privacy · Program Policies
Last account activity: 2 days ago
Details
Name 2 Reasons to store data in orderly fashion ANS: 1. Knowing what information is in the database.
2. Using the data
Name 2 types of Information Technology careers ANS: 1. Technical
2. Managerial
Name 3 elements DSS uses for accurate decision-making ANS: 1. business intelligence
2. data analytics
3. data management capabilities
Name 3 Main levels of security to protect database information: ANS: 1. Data level security
2. System level security
3. User level security
- CAD software can test the product design.
- Designs are easily transferred to automated manufacturing tools.
- Product changes can be easily made. ANS: Which advantages do computer-aided design and
computer-aided manufacturing (CAD and CAM) provide the manufacturing process?
Choose 3 answers.
- It is a process to capture information about the business's customers.
- It provides communication tools and channels.
- It facilitates marketing strategies to increase business. ANS: Which three benefits does a customer
relationship management system (CRM) provide to a business?
Choose 3 answers.
Chief information officer (CIO) ANS: Who does the CTO report to?
[Average_range] ANS: The cells to average. This is optional, and if omitted, the cells in the range
argument are averaged together.
[range_lookup] ANS: A Boolean to indicate an exact match or approximate match. Default=TRUE-
approximate match.
[Sum_range] ANS: The cells to add together. This is optional, and if omitted, the cells in the range
argument are added together.
[value_if_false] ANS: Used to specify the result of the IF function if the Boolean expression is FALSE.
,[value_if_true] ANS: Used to specify the result of the IF function if the Boolean expression result is
TRUE.
The Internet of Things (IoT) ANS: Which technology necessitated the development and implementation
of Internet Protocol version 6 (IPv6)?
1) A technology that captures all the information listed above and puts it into a structure where reports
can be run, analyses can be done, and information can be gleaned to support the business.
2) A strategy whereby a company uses the CRM to increase business by having the customers know the
CRM is there and use it to their advantage. For example, how many clicks does it take to buy something
from Amazon once you are a customer? CRM reduces the clicks, thereby reducing the time and
increasing the convenience to purchase from them.
3) A process that a company uses to its advantage to manage relationships with customers. ANS: What
is a CRM to a business?
=C3>70 ANS: Maria recently received a large set of data containing new employees' exam scores. She
was asked to prepare the data for analysis. The first task is to identify whether each of the new
employees received a score over 70. She is going to use Boolean logic to return "TRUE" if the new
employee's score is over 70 and "FALSE" otherwise.
What should she type in cell D3 below?
=SUM(F3:F17) ANS: What is the correct Excel function expression to calculate the total of all of the
scores (column F) in cell C2?
What are the steps in the decision making process? ANS: 1) Identify the decision that needs to be made.
,2) Gather the relevant information. In a DSS, ensure that the system is using the correct information and
run the DSS process to see what the outcomes are.
3) Identify the alternatives. Run the DSS using different parameters that match the qualifications for
making the decision.
4) Weigh all the components and assign probabilities of success, using the DSS output as the baseline.
The DSS can assign probabilities based on input data and the selection of criteria.
5) Choose the best alternative that meets the requirements of the decision.
6) Implement the decision.
7) Review and monitor the results of the decision.
What is the process for launching a mobile app? ANS: 1) Sketch out the app idea to understand the
flow.
2) Do market research to determine whether the app is unique and has a market.
3) Create a mockup of the app to nail down the flow, decisions, and displays.
4) Create the graphic design of the app. Look at areas of human interaction, color, flow, and ease of use.
5) Build the app landing page or a home page, which is a dedicated page of the mobile app to describe
the functions of the app.
, 6) Code the app with the programming language of choice.
7) Launch the app in the app store, for both iPhone and Android.
8) Market the app to reach the targeted demographic, and use the marketing principles defined in an
earlier section.
9) Improve your app with user feedback. Responding to users in a timely fashion is key to the success of
the app because in an online environment, everyone "hears" the complaints and the praises.6.03 GB of
15 GB used
Terms · Privacy · Program Policies
Last account activity: 2 days ago
Details
Name 2 Reasons to store data in orderly fashion ANS: 1. Knowing what information is in the database.
2. Using the data
Name 2 types of Information Technology careers ANS: 1. Technical
2. Managerial
Name 3 elements DSS uses for accurate decision-making ANS: 1. business intelligence
2. data analytics
3. data management capabilities
Name 3 Main levels of security to protect database information: ANS: 1. Data level security
2. System level security
3. User level security
