Python and Analytics 1 & 2 ALA

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

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.

What is the result of the following calculation? 8 + 3 * (9 - 5) / 2

14

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

16 == 17 9 <= 8

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

Python 3 has been in use since

2008

Which of the following are needed by every program?

A form of input A way to display results Instructions

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

A or B

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.

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

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.

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.

The standard representation of characters in programming is called

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

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

Analytics Cryptocurrency Banking

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.

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

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.

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.

What is another word for a structure in computer programming?

Construct

How can control structures be combined in programming?

Control structures can be combined using various and complex combinations.

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

Create your visuals. Explore data sets for patterns. Plan your visuals.

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

Which of the following is Microsoft Excel frequently used for?

Data analytics Data entry Data visualization

Which symbol in a flowchart represents a decision?

Diamond

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

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

ExPan TensorFlow

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

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

Flask Django

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.

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

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

Which of the following are true about IDLE?

IDLE is an IDE. IDLE is free. IDLE comes packaged with a Python download.

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

If-statement Conditional statement Selection construct

Which of the following must be used by all programs?

Input Output Processing

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 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.

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

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.

Select all of the following that are considered integers.

Negative whole numbers Zero Positive whole numbers

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

NumPY

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

NumPy pandas

Which symbol in a flowchart represents input and output?

Parallelogram

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.

The process of data analytics includes which of the following?

Prescriptive analytics Predictive analytics Descriptive analytics

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

Pseudocode

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.

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.

Which of the following are popular Python IDEs?

PyCharm Visual Studio Code Spyder

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

Python

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 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.

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

Python libraries Modules

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.

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

Seaborn Matplotlib

The three basic structures are

Selection Sequence Repetition

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

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

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

Sentinel-controlled loop

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.

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

Six

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.

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

Text, numbers, and variables

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.

Which of the following are needed to create a function?

The function name The keyword def A set of parentheses with any necessary arguments

What causes an infinite loop?

The initial condition is met but never changes.

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.

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.

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.

What is the primary purpose of including comments in code?

To provide explanations for different parts of the code

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.

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 (' ' ').

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

VBA

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.

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.

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 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 a decision is made and a specific path of instructions is followed, this is called a

branch point

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

character

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

choose an operating system.

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

The graphical and structured representation of data is known as

data visualization

DDDM refers to data-driven

decision making

The stages of the PDLC are

define, design, code, test, and revise

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

formula

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

function

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

humans

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

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

input request

Computers process instructions

internally

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

The IDLE shell

makes it easy to enter and test Python statements

The PDLC breaks down the development process into

manageable stages and tasks

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

open-source

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

prompt

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

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

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

string data

In order to process data, a computer program needs

variables with values and instructions

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

visualization

Which of the following are types of repetition structures?

while loops for loops counter-controlled loops