Download PYTHON AND ANALYTICS 1 & 2 ALA EXAM FULLY SOLVED 2026 #14 and more Exams Computer Science in PDF only on Docsity!
PYTHON AND ANALYTICS 1 & 2 ALA EXAM FULLY SOLVED 2026
Python was specifically designed to rely on which of the following? - correct answer Python libraries Modules Select the true statements about the business uses of Python. - correct answer 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. - correct answer data mining A subset of data analysis that covers creating visual representations of data is referred to as data - correct answer visualization Select the true statements about how Python is used in the banking industry. - correct answer 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. - correct answer 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? - correct answer Flask Django
A multi-purpose programming language that relies extensively on libraries and modules, ______ is suitable for the automation of various tasks and processes. - correct answer 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? - correct answer 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. - correct answer numpy Put the process for web scraping using Python in the correct order. - correct answer 1. Identify the URL to scrape.
- Identify the data that needs to be scraped.
- Inspect the page.
- Locate the data that needs to be extracted.
- Write/use Python code to extract the data.
- Run the code and extract the data.
- Compile structured reports/visualizations of the data. Which of the following Python libraries are commonly used for data processing and data visualization? - correct answer Seaborn Matplotlib Which of the following Python libraries are used in marketing analytics and SEO? - correct answer expan Tensorflow Python is used in quantitative and qualitative financial processes in which of the following areas? - correct answer 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? - correct answer Insurance
Select the true statements about how Python is used in finance. - correct answer 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? - correct answer 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. - correct answer rows Python is ______ software based on community-based development that runs optimally on Windows and Linux operating systems. - correct answer open-source In Microsoft Excel, a statement written by a user that is designed for a specific calculation is referred to as a - correct answer 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 - correct answer analytics When compared to Python, which of the following are considered limitations of using Microsoft Excel for data analysis? - correct answer 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? - correct answer Sensing Collection Wrangling
Select the true statements about the scalability of Microsoft Excel. - correct answer 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? - correct answer Data Metrics Facts Select the true statements about connectivity in Microsoft Excel. - correct answer 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? - correct answer 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? - correct answer Charts Interactive plots Graphics Computers process instructions - correct answer internally The process of data analytics includes which of the following? - correct answer Prescriptive analytics Predictive analytics
It includes tools to help a programmer write correct syntax. Which of the following are true about variable names? - correct answer 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 - correct answer 2008 In order to process data, a computer program needs - correct answer variables with values and instructions The IDLE shell - correct answer makes it easy to enter and test Python statements Which of the following are popular methods data from a program can be output? - correct answer Sent to the Cloud Sent to a file Displayed on a screen Which of the following are needed by every program? - correct answer 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 - correct answer string data In Python, a prompt takes the form of a(n) - correct answer input request Each ______ in the computer's memory is represented by its ASCII code. - correct answer character Which of the following statements are true about variables? - correct answer 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?
- Num_1 = 5
- Num_2 = 3
- Sum = num_1 + num_
- Print ("The sum is ", sum) - correct answer Line 3 What is the result of the following calculation? 8 + 3 * (9 - 5) / 2 - correct answer 14 In a Python print() statement, what types of data can be displayed? - correct answer Text, numbers, and variables Select the true statements about pseudocode. - correct answer 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. - correct answer Negative whole numbers Zero Positive whole numbers Which symbol in a flowchart represents a decision? - correct answer Diamond The standard representation of characters in programming is called - correct answer ASCII code, which stands for American Standard Code for Information Interchange The PDLC breaks down the development process into - correct answer manageable stages and tasks The stages of the PDLC are - correct answer define, design, code, test, and revise What is the primary purpose of including comments in code? - correct answer To provide explanations for different parts of the code There are ______ basic arithmetic operations that can be performed on numeric data. - correct answer Six
Which of the following statements about pseudocode are true? - correct answer 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 - correct answer branch point What is the purpose of ASCII code in character comparison, as explained in the text? - correct answer 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? - correct answer If-statement Conditional statement Selection construct Use your understanding of logical operators to help determine which of the following will result in False? - correct answer 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 - correct answer 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") - correct answer 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.") - correct answer Better stay put! Drive safely. Select the true statements about ASCII code. - correct answer 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") - correct answer 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? - correct answer A or B What are the characteristics and purposes of repetition structures (loops) in computer programming? - correct answer 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? - correct answer 16 == 17 9 <= 8 What causes an infinite loop? - correct answer The initial condition is met but never changes.
How can control structures be combined in programming? - correct answer 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. 2.cost = float(input("How much does your item cost? ")) 3.while(cost != 0):
- New_cost = cost + (cost * tax)
- Print("Total cost is $ ", new_cost) 6.print("Goodbye") - correct answer The value of cost never changes so this will be an infinite loop. Which of the following are needed to create a function? - correct answer The function name The keyword def A set of parentheses with any necessary arguments What is the test condition in the following loop? Name = "Janey" While(name != "finished"): Print("Your name is ", name) Name = input("Enter a name or enter 'finished': " ) Print("Nice meeting ya'll.") - correct answer name != "finished" Which of the following are built-in Python functions? - correct answer abs() Print() Input() In a(n) ______ loop, the body of the loop is executed a fixed number of times. - correct answer counter-controlled What is the difference between a built-in function and a function created by a programmer? - correct answer The code for a built-in function is included with the Python software and is hidden from programmers using that software. Built-in functions perform specific tasks. Programmers can create their own functions to do other tasks, as needed.
In a for loop, which parts of the loop are defined in a single statement? - correct answer The increment or decrement of the test condition The initial condition The test condition In Python, a list is - correct answer a group of related items To specify that a random number should be an integer, Python programmers use the ______ function. - correct answer randint() Which of the following statements are true about functions? - correct answer Functions allow programmers to break up code into manageable tasks. Each function normally performs a single task. When a specific task is needed, the function that does that task is called. How does Python locate a CSV file for processing? - correct answer The programmer specifies the path to the CSV file in the code. The program may ask the user to provide the path to the CSV file. What is the role of built-in functions in Python, as described in the text? - correct answer Built-in functions include functions like abs(), sort(), and len(). Built-in functions instruct the program to perform specific tasks. What is the purpose of the line return sum in the add_values() function shown here? Def add_values(X, Y) Sum = X + Y Return sum - correct answer The line return sum allows the result of the function to be sent back to the code that called it. What is each item in a list called? - correct answer An element What is the significance of nesting control structures? - correct answer Nesting control structures allows for more complex program behavior. Complex combinations of control structures are possible through nesting. How can Python be used to work with data that is stored in a spreadsheet or a database? - correct answer Python stores the data in lists to work on it.
A comment is text inserted into a program. A ______ structure has no branch points. - correct answer sequential Select the true statements about flowcharts. - correct answer Flowcharts are used to represent the flow of execution of a program. A flowchart is a diagram. Flowcharts show the programmer what will happen at various branch points. The ______ is a methodology used by programmers to develop a program. - correct answer Program Development Cycle What are the three fundamental constructs that form the basis of virtually all computer programs? - correct answer Sequence, selection, and repetition What are the characteristics and hierarchy of logical operators in computer programs? - correct answer The "and" operator results in True if both simple conditions are True. The "not" operator reverses the result of a simple condition. In a computer program where the characters are exactly as shown, which word would be listed first and why? Word1 = "kangaroo" word2 = "Teddy" - correct answer Teddy would be first because uppercase letters have smaller ASCII codes than lowercase. What would be the display after the following code is executed? Number = 1 While(number < 4): Print(number * 2) Number = number + 1 - correct answer 2 4 6 Given the following code, what would display if the user's test score is 84? If(score > 90): Print("A") Elif(score > 80): Print("B") Elif(score > 70):
Print("C") Elif(score > 60): Print("D") Else: Print("F") Print("Goodbye") - correct answer B Goodbye Using combinations of control structures and ______ operators, complex programs can be created. - correct answer logical Given the following loop, what will be the display after the loop executes? Index = 1 While(index <= 3): Print("Happy day!") Index = index + 1 - correct answer Happy day! Happy day! Happy day! Given the following list, how would a programmer identify the dragon in the code? Beasts = ["ogre", "troll", "dragon", "harpie", "elf"] - correct answer beasts[2] What is the purpose of the abs() function in Python, as mentioned in the text? - correct answer The abs() function returns the absolute value of a number. What is the name of the Python module that must be imported for Python to work on data in a CSV file? - correct answer csv
