Python and Analytics 1 & 2 ALA (CH 10)

Python was specifically designed to rely on which of the following?

Python libraries

Modules

Select the true statements about the business uses of Python.

Forty percent of recruiters are actively seeking Python programmers.

A Python library is a collection of related programming modules that include pre-compiled bundles of code.

Python is used in a variety of business disciplines including data analysis, finance, and accounting.

Similar to how mining recovers small amounts of precious metals from large amounts of ore or earth, ______ is the process of extracting information from large data sets.

data mining

A subset of data analysis that covers creating visual representations of data is referred to as data

visualization

Select the true statements about how Python is used in the banking industry.

Python is used by financial institutions to provide online banking and payment processing systems.

There is a Python script that allows for the creation of automatic recurring payment requests via Venmo.

Banks use Python to get financial models out of Microsoft Excel.

Select the true statements about the Python programming language.

Many people consider Python to be an ideal first programming language to learn.

Python is completely free to use.

Python syntax is considered by many to be relatively simple.

Which Python web frameworks identified in the text assist in the development of scalable and secure FinTech web applications?

Flask

Django

A multi-purpose programming language that relies extensively on libraries and modules, ______ is suitable for the automation of various tasks and processes.

Python

Data manipulation in Python using the wide variety of libraries that are available offer accountants the ability to automate which of the following tasks?

Perform calculations.

Generate reports.

Analyze financial data.

Known as numerical Python, ______ is well-suited for scientific computations and complex array operations and is widely used in data mining.

NumPY

Put the process for web scraping using Python in the correct order.

1. Identify the URL to scrape.

2. Identify the data that needs to be scraped.

3. Inspect the page.

4. Locate the data that needs to be extracted.

5. Write/use Python code to extract the data.

6. Run the code and extract the data.

7. Compile structured reports/visualizations of the data.

Which of the following Python libraries are commonly used for data processing and data visualization?

Seaborn

Matplotlib

Which of the following Python libraries are used in marketing analytics and SEO?

ExPan

TensorFlow

Python is used in quantitative and qualitative financial processes in which of the following areas?

Analytics

Cryptocurrency

Banking

Short for Financial Technology, FinTech refers to the use of technology and innovative solutions to automate and increase efficiency in which industries?

Insurance

Banking

Payment systems

Which of the following is Microsoft Excel frequently used for?

Data analytics

Data entry

Data visualization

Which of the following Python libraries are commonly used to automate accounting tasks?

NumPy

pandas

In Microsoft Excel, a predefined formula that is built into the software for ease of use and deployment is referred to as a

function

Web scraping is the automation of the extraction of large volumes of data from websites. Using Python, which of the following web scraping activities can be conducted?

Conduct research and development (R&D)

Conduct price comparisons.

Collect data from social media sites.

In Python, a collection of related programming modules that include precompiled bundles of code that can be used repetitively in different programs and applications are referred to as a Python ______. They often contain configuration data, templates, classes, values, and documentation.

library

Marketing analytics are used to measure marketing performance and effectiveness and to make decisions on different strategies to increase marketing efficiency and impact. The analysis of marketing performance data can be enhanced using Python. Python is used for the analysis of which marketing related tasks?

A/B Testing

Customer segmentation analysis

Predictive analytics

In Microsoft Excel, ______ is used to create custom macros and functions that are designed to accomplish organizational specific tasks.

VBA

Select the true statements about how Python is used in finance.

Python is used in quantitative and qualitative financial processes in many financial areas including analytics, banking, and cryptocurrency.

Banks use Python to get financial models out of Excel and into an environment that allows for more data analysis and visualization.

Analytics in finance provides high-level and granular-level views of an organization's financial data.

Which of the following are popular Python IDEs?

PyCharm

Visual Studio Code

Spyder

Microsoft Excel is a spreadsheet software application that consists of a grid interface of columns and ______ where data can be entered, structured, and manipulated.

rows

Python is ______ software based on community-based development that runs optimally on Windows and Linux operating systems.

open-source

In Microsoft Excel, a statement written by a user that is designed for a specific calculation is referred to as a

formula

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data

analytics

When compared to Python, which of the following are considered limitations of using Microsoft Excel for data analysis?

Handling large volumes of data

Limited scalability

Syntax errors

The steps in the data project life cycle, according to Harvard University's Data Science Ready project include which three of the following?

Sensing

Collection

Wrangling

Select the true statements about the scalability of Microsoft Excel.

When large volumes of data are introduced into Microsoft Excel, issues may occur.

The management of small and medium scale data sets can be accomplished relatively smoothly.

As the amount of spreadsheet tabs in a workbook increases, so does potential data management issues.

According to Tableau, data-driven decision making (DDDM) uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives?

Data

Metrics

Facts

Select the true statements about connectivity in Microsoft Excel.

Workbooks can be connected to external data sources including SQL servers.

Connections to cloud-based data is possible.

Microsoft Excel is a solid option for users importing and exporting basic reports.

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

Create your visuals.

Explore data sets for patterns.

Plan your visuals.

Data visualization is a strength of using Python for data analysis. Which of the following are types of data visualization that can be created using Python?

Charts

Interactive plots

Graphics

Computers process instructions

internally

The process of data analytics includes which of the following?

Prescriptive analytics

Predictive analytics

Descriptive analytics

Which of the following are true about IDLE?

IDLE is an IDE.

IDLE is free.

IDLE comes packaged with a Python download.

One way to visualize a data ecosystem is to apply it to the data project life cycle. The Data Science Ready project outlines the five steps of the data project life cycle. The final stage in this life cycle is

storage

When you go to www.python.org to download Python, you must

choose an operating system.

DDDM refers to data-driven

decision making

Which of the following statements are true about the IDLE editor?

To write an entire Python program, you must use the editor and not the shell.

The editor works like a simple word processor, but it also allows Python to compile and run source code.

A program created in the editor will run in the shell.

The graphical and structured representation of data is known as

data visualization

A computer is content to process programming instructions internally, but output is needed by

humans

Which of the following must be used by all programs?

Input

Output

Processing

In a program, a ______ tells the user what input is needed.

prompt

Which of the following are true about an Integrated Development Environment?

It translates a programmer's code into a format that is readable by a computer.

It contains a source code editor.

It includes tools to help a programmer write correct syntax.

Which of the following are true about variable names?

Variable names are case sensitive.

Variable names cannot include spaces.

Variable names may contain numbers but cannot begin with a number.

Python 3 has been in use since

2008

In order to process data, a computer program needs

variables with values and instructions

The IDLE shell

makes it easy to enter and test Python statements

Which of the following are popular methods data from a program can be output?

Sent to the Cloud

Sent to a file

Displayed on a screen

Which of the following are needed by every program?

A form of input

A way to display results

Instructions

The characters A through Z and a through z, the digits 0 through 9, and some special characters are called

string data

In Python, a prompt takes the form of a(n)

input request

Each ______ in the computer's memory is represented by its ASCII code.

character

Which of the following statements are true about variables?

The value of a variable is stored in the variable's location in computer memory.

The value of a variable can change as the program runs.

It is possible to join the value of one variable with the value of another variable to create a new variable.

In the following program, which line is the processing line?

1. num_1 = 5

2. num_2 = 3

3. sum = num_1 + num_2

4. print ("The sum is ", sum)

Line 3

What is the result of the following calculation?

8 + 3 * (9 - 5) / 2

14

In a Python print() statement, what types of data can be displayed?

Text, numbers, and variables

Select the true statements about pseudocode.

Pseudocode is used to outline the flow of a program.

Pseudocode allows a programmer to visualize the flow of a program without getting bogged down in syntax.

Pseudocode is not written in a specific programming language.

Select all of the following that are considered integers.

Negative whole numbers

Zero

Positive whole numbers

Which symbol in a flowchart represents a decision?

Diamond

The standard representation of characters in programming is called

ASCII code, which stands for American Standard Code for Information Interchange

The PDLC breaks down the development process into

manageable stages and tasks

The stages of the PDLC are

define, design, code, test, and revise

What is the primary purpose of including comments in code?

To provide explanations for different parts of the code

There are ______ basic arithmetic operations that can be performed on numeric data.

Six

What is another word for a structure in computer programming?

Construct

______ use(s) short phrases to describe the outline of a program.

Pseudocode

Which symbol in a flowchart represents input and output?

Parallelogram

Which of the following statements are true about a program that only includes sequential structures.

Sequential structures do not involve any repetition.

Sequential programming prohibits all forms of branching.

What are characteristics of selection structures in programming?

Computers use relational operators for making comparisons in selection structures.

If-statements are selection structures.

A complete understanding of relational and logical operators is crucial for creating effective selection structures.

Which of the following are ways to identify comments in Python?

Use the hashtag symbol (#).

Enclose the commented line or lines between two sets of three double quotes (" " ").

Enclose the commented line or lines between two sets of three apostrophes (' ' ').

Which of the following statements are true of relational operators?

Relational operators are used to compare two values, variables, or expressions.

The result of any comparison between relational operators is always either True or False.

There are six relational operators.

The three basic structures are

Selection

Sequence

Repetition

Which of the following statements about pseudocode are true?

Pseudocode is not written in a specific language.

Most programmers use both pseudocode and flowcharts when starting to design a program.

When a decision is made and a specific path of instructions is followed, this is called a

branch point

What is the purpose of ASCII code in character comparison, as explained in the text?

ASCII code helps computers determine the alphabetical order of characters.

ASCII code represents characters as numeric values.

Which of the following are alternate ways to refer to a selection structure?

If-statement

Conditional statement

Selection construct

Use your understanding of logical operators to help determine which of the following will result in False?

2 == 3 and 5 == 5

9 > 10 or 12 < 3

Computers use relational operators to compare two values, variables, or expressions. An expression consists of several values or variables and may combine values and variables. Based on this information, the result of the expression (5 + 3) >= 15 is

False

A single-alternative structure consists of an if clause with a condition. If the result of the condition is True, a block of statements is executed. If the condition is False, nothing is done and the program continues to the next statement after the selection structure.

Given the following code, what will be displayed if the user is 17 years old?

if(age >= 18):

print("You are eligible to vote.")

print("Goodbye")

Goodbye

Given the following code, which has a variable named light, what will be displayed if light has the value "yellow"?

if(light == "green"):

print("You are good to go!")

else:

print("Better stay put!")

print("Drive safely.")

Better stay put!

Drive safely.

Select the true statements about ASCII code.

ASCII code can compare long strings of text as well as single characters.

ASCII code is used for alphabetizing values in programming.

ASCII code is used to represent all the upper- and lowercase characters as well as digits 0 through 9.

Students in a programming class have ID numbers from 1 through 15. They are assigned to groups based on their ID numbers. What is wrong with the following code that tells students which group they will be in?

if(number > 0 and number < 5):

print("You're in the blue group.")

elif(number > 5 and number < 10):

print("You're in the green group.")

elif(number >= 10 and number <= 15):

print("You're in the red group.")

else:

print("You are not in this class")

A student with ID number 5 will not be in any group.

When discussing logical operators, if A is True and B is False, which of the following will result in True?

A or B

What are the characteristics and purposes of repetition structures (loops) in computer programming?

The value in the test condition can change during the loop's iterations.

Repetition structures involve a block of statements executed under certain conditions.

In a Python program, which of the following expressions would result in False?

16 == 17

9 <= 8

What causes an infinite loop?

The initial condition is met but never changes.

What are the key characteristics of a single-alternative structure?

The condition must be enclosed in parentheses.

Statements executed when the condition is True must be indented.

If the condition is True, a block of statements is executed.

What type of loop ends when a specific value is entered by the user or by something in the code?

Sentinel-controlled loop

What is wrong with the following code?

If(X > 75) :

print(You have enough money)

Else:

print(You need more money to buy this item.)

Statements inside the if and else clauses should be indented.

The keywords if and else must be lowercase.

Text to be displayed in print() statements is not enclosed in quotes.

What is the test condition in the following loop?

index = 1

while(index <= 5):

print("Your ID number is XYZ00", index)

index = index + 1

index <= 5

Which of the following situations would best be handled by an if-elif multiple-alternative structure?

Displaying four possible prizes based on a user's total purchase amount

Given the following for loop, what will be displayed after the code executes?

for number in range(0, 15, 5):

print(number, end = " ")

0 5 10

Which of the following are types of repetition structures?

while loops

for loops

counter-controlled loops

How can control structures be combined in programming?

Control structures can be combined using various and complex combinations.

What is wrong with the following code that calculates the cost of an item with tax?

1.tax = 0.06

2.cost = float(input("How much does your item cost? "))

3.while(cost != 0):

4. new_cost = cost + (cost * tax)

5. print("Total cost is $ ", new_cost)

6.print("Goodbye")

The value of cost never changes so this will be an infinite loop.

Which of the following are needed to create a function?

The function name

The keyword def

A set of parentheses with any necessary arguments