Test 4 Study Guide

Put the steps of the information processing cycle in the correct order, with the first step at the top.

1. Input 2. Process 3. Output 4. Store

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are) ___.

2 dashes: "- -"

is the brains of the computer where most calculations take place.

A processor or central processing unit (CPU)

Select 3 sources of information that a CRM system uses to collect data about current customers.

Analytics Social Media Customer Surveys

Which three of the following regarding a computer application are true?

Applications can be located on smartphones, tablets, laptops, and even on servers accessible on the Internet. A computer application is a computer program. Most applications can be downloaded for free or for a fee.

The design of a CRM system that collects data on customer interaction should include which of the following elements?

Automation Treating customers as individuals Monitoring customer interactions

Used to display slices of information. Designed to plot numerical values in the form of bars. Often used to demonstrate the distribution of data points or to display values across different subgroups of data.

Bar Charts

Because its radio waves can pass through walls or desktops, ___-capable devices have become very popular.

Bluetooth

1.Ask - Determine what questions you need to ask and establish a clear definition of the problem 2.Prepare - Data should be collected, stored, and secured in preparation for data processing 3.Process - Data cleansing and checking should occur to ensure high-quality data is ready for analysis 4.Analysis - Data is analyzed to find patterns, trends, and relationships within the data set 5.Share - Data is shared with the appropriate audience. This can include visualization and presentations to key stakeholders 6.Act - Once data and results have been shared, decisions must be made These are the Six Steps of ________________

Data-Driven Decisions

SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a ______

Database

There are several best practices that can be applied to ensure effective development and interpretation of data visualizations. Select 3 of these best practices.

Define the purpose Inclusion of data Use color

CRM analytics can provide insight into how customers and members of the organization interact with the CRM system. This can be used to encourage interaction and use.

Demonstrate the Value of CRM

What devise has 500 GB - 3 TB for space

Desktop

Common SQL terms include which 3 of the following?

FROM SELECT WHERE

Most tablets have solid-state drive (SSD) capacities measured in terabytes (TBs). True or False

False

The only major difference between MacBooks and the Dell laptops is their prices. True false question.

False

Built-in formulas included in a spreadsheet program

Function

Which of the following terms refers to the physical parts of a computer system?

Hardware

Characteristics of spreadsheets include which 3 of the following?

Information is organized into cells Data is structured in rows and columns Program is typically limited to one user at a time

Used to compare values over long and short periods. Can efficiently display changes over time in a single category of data or groups of data categories.

Line Charts (line plots or line graphs)

Which of the following are popular CRM options that are used to assist with sales prospecting?

LinkedIn Sales Navigator Zoominfo Clearbit Prospector

the process of dividing a market of both potential and existing customers into groups (i.e., segments) based on a variety of characteristics including both demographic and psychographic types of data.

Market segmentation

The devices shown in the image (iPod, Chromecast, Roku, etc.) are referred to as Personal ___ Players

Media

Characteristics of Mainframes

Not designed to calculate huge formulas, but able to manage thousands of transactions simultaneously. More powerful than a server, less powerful than a supercomputer. Often operated by businesses such as large banks or credit card companies.

Which three of the following are common spreadsheet application programs?

Numbers for Mac Microsoft Excel Google Docs (Sheets)

Analytical Thinking Includes characteristics and capabilities that allow for:

Observation. Research. interpretation of a problem.

Select the true statements about Customer Lifetime Value (CLV).

One of the key metrics used to determine the profitability of an organization's customers. Organizations use CLV to determine how much they should spend to acquire new customers versus how much they should spend to retain existing customers.

Which two of the following are true about system software?

One of the most important types of system software is the operating system. System software refers to programs that offer the structure and hardware control necessary to run the computer and its peripheral devices.

allows for customized marketing based on individual customer behavior

Personalization

Design elements that can lead to misleading data visualization include exaggerated or improper scaling.This can most often occur when presenting data in the form of a ___

Pictogram

Used to represent part-to-whole relationships in a data set.

Pie Charts

The 3-step data visualization process is comprised of which of the following?

Planning for visuals Explore data sets for patterns Create your visuals

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft ____ BI.

Power

uses prior information to assist in the determination of the success or failure of future endeavors

Predictive modeling

CRM analytics often give insights that foster innovation. This information can be used by decision-makers to identify strong areas and potential growth areas.

Product Development

__________ a potential customer occurs when an organization determines whether or not an individual or business makes sense to pursue as a potential customer.

Qualifying

SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in Structured ____ Language stands for ___.

Query

Characteristics of databases include which 3 of the following?

Records Fields Characters

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as __ ___AI.

Scalable

Are designed to diagram pairs of numerical data with one variable placed on each axis. If there is a correlation between the variables, the data points will fall on a line or curve.

Scatterplots (scatter diagram or X‑Y graph.)

Which three of the following devices are also computers?

Smartphone Gaming console Laptop Desktop

The __ tool is used to capture a screen shot, or snip, of any image on the screen of a laptop or desktop computer,

Snipping

CRM analytics can provide information about where data erosion occurs and how processes can be improved to minimize it.

Standardized Data Collection Processes

Many of these are owned by research universities and government agencies such as the NSA. NASA uses them to determine gravitational fluctuations that might indicate additional planets in the solar system

Supercomputer

Programs that offer the structure and hardware control necessary to run the computer and its peripheral devices are called __ software.

Systems

Analytics software that offers business intelligence and data visualization across many areas as well as for organizational processes.

Tableau

CRM systems can be designed to capture data about why users are buying a product or service and how they are using it.

User Experience

CRM analytics can be used to test the ______ of products or services. This ______ check results from the analysis of consumption trends and usage behaviors.

Viability

The graphical and structured representation of data is known as data _____

Visualization

A stationary (non-mobile) computer that combines the power of a desktop with a neat, clean, look is a(n):

all-in-one

If you want a non-mobile computer without the relatively large footprint of a desktop, consider purchasing a(n) ___ computer.

all-in-one

Smartphones owe much of their popularity and computing flexibility to ___ .

apps (applications)

Users can identify patterns in data as well as create data visualization tools with ________

charts and graphs

A well-developed CRM strategy can assist organizations to identify the needs, wants, preferences, and expectations of ______

current customers

A SQL statement is used to ask a question or communicate a request of the ______ management system.

database

A personal computer with a separate system unit (chassis or tower) and a relatively large footprint is called a ___ .

desktop

Memory, such as RAM or cache, is __ and has no moving parts.

electronic (solid state)

Analysts use _______ and other tools to depict the workflow, the sequence of operations, and the decision points.

flow-charts

Most new laptops come with 128-1,000 _____ of storage.

gigabytes

The physical parts of a computer, such as the monitor, keyboard, mouse, and system unit are called computer ___ .

hardware

Memory, such as a computer's RAM ___

holds data and programs being used by the processor.

Which operating system is found on Apple smartphones and tablets?

iOS

CRM software assists organizations in identifying marketing qualified ________ (MQLs).

leads

While not designed to solve complex technical formulas, a computer that is more powerful than a server computer, and used by organizations to process large numbers of transactions simultaneously is called a

mainframe

When a computer is shut down, the information in the memory (the RAM, the caches, the registers) is ___.

not saved

Because they tend to use relatively large amounts of battery life and because their inclusion tends to make a laptop somewhat larger (thicker), many new laptops do not come with _______ drives such as blu-ray or DVD players.

optical

Media players allow you to listen to audio files such as music, podcasts, listen to audio books, and watch videos. Media players are often referred to as _____ Media Players due to their transportability and customization.

personal

Most new smartphones come with between 2 and 6 GB of __ .

random access memory (RAM)

Data from the hard drive reaches the CPU ___ than data from the RAM.

slower

Because of their compact size and extreme efficiency, smartphones, tablets, and some laptops use ______ - state storage (hard drives)

solid

A hardware component that keeps data and information when the device is not powered is called a ____ device.

storage

The most powerful computers, _______ , can evaluate complex data very quickly. Many of these computers in the United States are owned by the government or major research institutions and can cost $1 million dollars or more.

supercomputers

Desktop computers usually come with at least 8-16 GB of __. One nice thing about a desktop is that most allow this to be easily expanded to up to 32 to 64 GB.

system memory (RAM)

Most databases are composed of multiple ______ , which are groups of assigned records and fields organized in rows and columns.

tables

A highly mobile, touch-screen enabled device that is larger than a smartphone and popular with those who use a computer while walking around is a _____ computer.

tablet

is the group of existing and potential customers that an organization believes they can sell their products or services to.

target market

Analytic Analysis

the process of analyzing data to discover patterns, correlations, and trends

If you buy a new computer game that emphasizes graphics, or new photo/video editing software for your desktop computer, you may want to purchase a new ___.

video/graphics card

There are three main tools data analysts and other members of an organization use to analyze data. They are spreadsheets, databases and query languages, and data ______ tools.

visualization

What are the types of Computer Hardware

•system unit (called the tower or the chassis) •printer •monitor •keyboard •mouse router

Personal computer CPU clock speeds range between ____.

1-4 gigahertz

One way to remove an app from your Mac is to go to the Launchpad.The Launchpad icon looks like ___

9 colored dots in a 3x3 format

Which three of the following computers would not have a traditional (magnetic) hard drive?

An Android-based smartphone iPhone XR A 2-in-1 computer

Fetch

An instruction is obtained from memory

Which computer component found on the motherboard (magnified in the image) is often called the brains of the computer?

CPU

Is the selection and representation of data in a visualization that supports a desired conclusion or result.

Cherry-picking data

One way to delete unused files from your Windows hard drive is to use the Disk ___ app.

Cleanup

Number of instructions a computer can process in a second.

Clock Speed

where customers are grouped into homogenous segments so behavior can be more easily analyz

Customer segmentation

includes the identification of which customers create the highest revenue

Customer value and profitability

Which of the following explain the importance of CRM to businesses? More than one answer can be selected.

Customers can be acquired using a number of approaches including social media, search, affiliate, referral, and email marketing. CRM software systems track prospective customers (and current customers) through the various stages of the funnel Organizations often track customer acquisition using a lead generation funnel

Duties for __________ include: •Working on data analytics teams to extract data from large data sets. •Creating reports that outline key findings. •Monitoring K P I's to identify success or failure. •Analyzing data to identify trends.

Data Analyst

The information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data.

Data Ecosystems

What is based on the unique circumstances of each organization, a specialized ecosystem is created for every business entity.

Data Ecosystems

Improved customer service Improved patient experiences and internal procedures in healthcare Improved decision making These are the uses of

Data analytics

The process of investigating raw data of various types to: Uncover trends and correlations. To answer specifically crafted questions

Data analytics

___________ software assists managers by examining large quantities of data and parsing it into usable information.

Data analytics

Some of the responsibilities of a data analyst include which 3 of the following?

Data visualization Data structuring Data reporting

The use of facts, metrics, and data to guide strategic business decisions that align with organizational goals, objectives, and initiatives.

Data-Driven Decision Making (DDDM)

Trying to answer questions such as, "what happened?" or, "what is occurring?" or "what was the ROI?", is the role of ___.

Descriptive Analytics

Uncovers historical trends in data sets

Descriptive Analytics

Designed for power users. Has a relatively large footprint. Not mobile, but allows for relatively easy upgrade and expansion.

Desktop computer

Click 3 characteristics of desktop computers.

Desktops use a full OS. Desktops allow for relatively easy upgrade and expansion. Desktops are often used in offices since they do not need to be mobile.

Memory used to increase a hard drive's efficiency

Disk cache

A computer that is integrated (a part of) to a larger device or system. Accepts input, processes data into information, provides output, and can store data.

Embedded Computer

Sold in categories such as CAT5e (enhanced) or CAT6, or CAT7 cable is commonly used for connecting devices in a network. These are commonly called _______ cables.

Ethernet

The processor completes the instruction. This is called:

Execute

Used for data storage.

File Server

The small amount of memory, located within the CPU itself, is referred to as ___ cache.

L1

Memory located directly on the processor itself

L1 cache

Memory located next to the processor

L3 cache

A legal contract between the software manufacturer and the user of an application is called an End-User __ Agreement (EULA).

Licensing

An operating system that is an open source and not owned by a sole company is __.

Linux

Which 3 of the following are the strengths of the Linux OS?

Linux OS has solid security features and is less susceptible to viruses. Linux is an open-source software that can be modified by users. Linux is an operating system that is free to download and use.

Jose uses Windows 10 on his laptop to run the programs he needs to complete his college assignments. Windows OS is owned and maintained by _____ .

Microsoft

Which three of the following are common software licenses?

Network Single-User Site

Used to control access to resources such as printers and applications on a network.

Network Server

These are examples of ___________________ •Tracking fuel prices by airlines to determine possible increases and decreases. •Monitoring flu strains and activity to determine possible outbreak areas. •Analysis of cyberthreats and activity to identify possible threats and breaches.

Prescriptive Analytics

Used to help determine best courses of action. Considered to be the most advanced form of data analytics. Seek to predict what, when, and why a given scenario might occur.

Prescriptive Analytics

Applications that enable a user to create visual aids that can be projected on a screen or displayed on a digital display are called __ software.

Presentation

is the method of searching and finding potential customers for a product or service.

Prospecting

________ is actually storage since it retains data and information when the power has been turned off.

ROM (Read-Only Memory)

Solid ________ Drives (SSDs) are all-electronic storage devices that are used in a variety of products including smartphones, cameras, and tablet computers. SSDs have no moving parts, which makes them faster and more durable than hard drives.

State

If you plan to become an accountant or major in finance, it is probably best to purchase a computer that uses ___ operating system.

The Windows

This type of connector is the most common for connecting peripherals (printers, monitors, storage devices, etc.) to a computer.

USB

perform a specific maintenance-type task on a computer and are included with both Windows and macOS including •disk cleanup •file search system backup and restore

Utility Programs

Which two of the following are usually considered the strengths of the macOS platform?

Very stable and reliable, few viruses Strong graphics quality and graphical user interface (GUI).

Used to control access to resources on the Web.

Web Server

The standard for wireless Ethernet networks is known as _____.

Wi-Fi

Which of the following is a strength of the Windows OS?

Wide availability of software options.

Small application programs that are often utility programs and perform less complex operational functions and are commonly used to execute tasks in the Control Panel of Microsoft Windows are called ___.

applets

The system management tool in the Windows operating system is referred to as the ___ .

control panel or Windows Settings

Identify the cable and connector in the image, commonly used in networking. This is a ___ cable.

ethernet

A protocol commonly used to transfer large files from one server to another on the Internet is the ___.

file transfer protocol (FTP)

A multicore processor has the ability to execute two or more sets of instructions at the same time. This is called _____.

hyperthreading

One method of finding and downloading programs for a Windows computer is to download the program from the _____

internet

The computer platform known for its graphics capability and stylish design is the ___ .

macOS

In an all-in-one computer, such as the one pictured in the image, the motherboard is housed behind the

monitor

Two or more complete processors residing on the same chip and capable of executing two or more sets of instructions at a time is called a ____-core processor.

multi

IP, FTP, HTTP, and HTTPS are all acronyms that describe different

network protocols

Apps designed to make individuals or businesses more efficient are categorized as:

productivity

Software comes in various categories. One category is system software, which provides the instructions that hardware needs to operate (iOS, Android, Windows, etc.). Another category is game software (League of Legends, Hearthstone, Angry Birds, etc.). Another category of software includes applications such as Office 365, iWork, QuickBooks, Googledocs, etc. This software is referred to as ___ software.

productivity

When referring to apps or applications, the term "installing" refers to the process of _____.

putting software on a digital device

A computer system in a network that is shared by multiple users is called a ___

server

A processor composed of one control unit and one arithmetic logic unit (ALU) is called a:

single-core processor

A software license that restricts the use of a program to one user at a time is known as a ___ .

single-user license

The location of the computer's ___ unit, which houses a computer's motherboard, depends on the type of computer. For example, in this laptop, it is located under the keyboard.

system

Similar to the Windows control panel, the system management tool in the macOS is called ___.

system preferences

To download an app onto your Android-based smartphone or tablet, you first click on ___ .

the Play Store icon