CSCI2201
The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip?
$10.50
Select three critical factors to consider when determining the right data to select
-How will the data be collected? -What types of data do you need to solve a specific problem -How much data should be collected
Analytical skills necessary for a data analyst include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. According to Google, there are five essential aspects of analytical skills including which three of the following?
-curiosity -understanding context -data strategy
Uses of data analytics include which three of the following?
-improved decision making -improved patient experiences and internal procedures in health care
The main tools used by data analysts include which three of the following?
-spreadsheets -databases and query languages -data visualization tools
Which of these extensions, if you open it, will probably install software onto your computer? Be careful!
.eve
Which of the following file extensions is commonly used for drawings?
.gif
A smartphone emits approximately ________ watts of microwaves.
0-1
How many people can own a domain name?
1
when you buy a new laptop how much ram should it come with
15-20 GB
Full HD Resolution
1920 x 1080
A web page has____ main parts
2
If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
27
What is the minimum amount of RAM you should have on your laptop?
4 GB
A typical laptop has a storage capacity of___
500GB-1TB
Most new cell phones today come with approximately ________ of RAM.
500MB-2GB
LTE and ________ are best for streaming or uploading photos or videos.
5G
Bus width is the amount of data that can be transmitted at a given time. A 64-bit bus can transmit ________ bits of data.
64
Every time you go to the gas station you're amazed by how much prices have increased. At this time last year the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?
= ((4.25 - 3.20) / 3.20) * 100
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.
= (25 + 50 + 75) / 3
Some computers use ___ to represent characters in a binary format
ASCII
Which of these operating systems is based on Linux and used on smartphones?
Android
Versions of the ________ used to be assigned sweets/candy names, such as Oreo and Pie.
Android OS
The two main components of a processor are the control and the ________.
Arithmetic Logic Unit(ALU)
AJAX stands for ________ JavaScript and XML.
Asynchronous
Σ What does the above symbol (upper-case Sigma) represent in spreadsheets?
AutoSUM
The programming language of the third generation learned by most students when most computers used MS DOS was ________. It continues as a secure programming language to use 3rd party code and offers a standard for coding that readily integrates with other programming languages.
BASIC
Data analysts are likely to have achieved what education level when beginning their career?
Bachelor's degree
A protocol commonly used to transfer large files from one server to another on the Internet is the ________.
File Transfer Protocol
All application that navigates all of the files and folders on your Mac is the ___
Finder
Select the Samsung smartphone.
Galaxy S21
Although not a programming language technically, ________ relates to the protocols that enable content to be displayed on the Internet.
HTML
What are the two main parts of a webpage?
Head Body
Computer hardware and software used by an organization to improve its performance is called its ________.
IT System
In spreadsheets, all functions and calculations begin with
In spreadsheets, all functions and calculations begin with
Which chip manufacturing company is the largest in the world
Intel
Which of these browsers was developed by Microsoft?
Internet Explorer
Which of these programs, by parsing XML documents, makes information more readable for programmers?
JSON
An object-oriented programming language used by Android phones and tablets to write apps is ________.
Java
The programming language ________ makes it much quicker to create websites and web pages.
JavaScript
The processor directly houses the ___ cahche
L1
Changing the appearance of your can make it easier to keep your folder information organized. To change your folder's appearance, first click on the folder, and then go to the Command bar and click _______
Organize
____ runs the processor faster than reccommended by the manufacturer. This can increase performance and speed, but will also void the manufacturer warranty
Overclocking
What is the acronym for Hypertext Preprocessor?
PHP
The part of a URL include:
Protocol Domain name Host (Optional query string)
System BIOS(Basic Input/Output System) is stored in
ROM
The term used for designing websites to be viewed on all types of devices is known as _____.
RWD (Responsive Web Design)
A signal transmitted every few seconds by a wireless router so that users' computers can find the Wi-Fi hot spot is called a(n) ________.
SSID
Which of the following refers to the distribution of computer applications over the Internet and is commonly referred to as web apps?
SaaS
Because they are both Apple products, the browser that works smoothest with Macintosh OS X is ________.
Safari
To look for a file or folder in Windows 10, just type the file name in the ________ box.
Search
________ programming is a programming design that breaks a issue into a sequence of functions.
Top-down
URL stands for ________ Resource Locator.
Uniform
The acronym URL stands for?
Uniform Resource Locator
In Apple iWork's Numbers the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the ________ menu.
View
To change the size of your folder's icon, just right-click on a blank area of the Contents pane and click ________.
View
The original wireless network privacy and protection standard for Wi-Fi was known as ________.
WEP
The wireless network privacy standard that was introduced in 2003 but was quickly replaced (due to numerous vulnerabilities) was known as ________.
WPA
CD store data using
a reflective coating that has pits and lands
DVDs store data using
a reflective coating that has pits and lands
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ________ reference.
absolute
Testing and documenting the software are the final steps in the PDLC process. When testing is carried out by the software's potential customers, it is called a(n) ________ test.
beta
A question that is answered as either yes or no, or true or false, is called ________.
binary
A wireless short-range transmission protocol is called___
bluetooth
Your computer is the client when you type a URL into your browser. A request is sent to a server by your _____.
browser
Software applications that allow users to access and surf the World Wide Web are called ________.
browsers
The two main factors that affect the speed of the processor are clock speed and ____
bus width
Data analysts must blend facts and data with knowledge about the
business or organization
A ___ is the smallest unit of data that a computer can process
but
In ASCII 8 bits are combined to create a
byte
What element of a database field specifies the data in a field such as text, numeric, or date/time?
data type
Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ________.
database
There are almost always errors after the code has been written. The PDLC's fourth step involves finding and correcting these errors in a process. This process is called ________.
debugging
A website usually has a lot of folders, also known as ______.
directories
A security system separating two networks or even computers on the same network is called a ________.
firewall
Defining the problem is the ________ step in the Program Development Life Cycle.
first
Which is an example of a correct URL?
https://www.amazon.com
Apple's mobile device with the largest display is the ________.
iPad Pro
For ________ it may be less expensive to add an existing cell phone data plan and to use the phone as a hot spot than to add wired Internet service.
individual users
Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ________.
integrity
The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's
interest
A program that can be used to turn a single line of C# into a machine language without the complete program being compiled is called a C# ________.
interpreter
Because of the large infrastructure cost of building antennae and mobile switching stations, as well as leasing the rights to use radio frequencies, only ________ companies can compete nationally as cell phone providers.
large
The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view.
logical
An initial value process, a process and a test condition which can potentially return to the initial value is called a ________.
loop
Most desktop computers use _____ to store data
magnetic hard drives
one of the largest data requirements of the future will most likely be__
mapping patients genomes
A storage device that uses lasers to read CDs, DVDs, o Blu-ray discs is referred to as an
optical drive
Many manufactures have made ___ optional equipment when purchasing a new laptop computer
optical drives
Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered _____ data.
ordinal
The BitTorrent protocol is often called ________ file sharing.
peer-to-peer
Each loan payment is referred to as a(n)
period.
When data is anonymized, the PII is eliminated or encrypted. PII includes names, Social Security numbers, addresses, and more and stands for ______ identifiable information.
personally
Software that can be added to a browser to increase its functionality are called ________.
plug-ins
If you just need a phone for emergencies, you might consider a ________ phone.
prepaid
Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's
present value (PV).
An easy way to rename a folder in Windows is to ________-click on the folder and then click Rename.
right-click
The most common method of renaming files and folders is to simply ________ on the item and select Rename.
right-click
The device that connects two networks is a ________.
router
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
The two major concerns regarding cloud storage are reliability and ________.
security
A _____ is a large computer that stores files, including web pages, that can be accessed over the Internet.
server
A web hosting company will store all the files and folders for a website on a _____.
server
Pseudocode is written in natural language but often includes programming ________ to assist in writing the program itself.
shorthand
The small computer within your phone that enhances the sound quality of your call is called a digital ________ processor.
signal
A processor that consists of one control unit and one ALU is called a
sing-core processor
A Cascading Style Sheet (or a CSS) uses _____ to define many properties of elements including visual properties such as color, size, and font as well as where and how elements are positioned on a page.
styles
The cell tower's base transmission station is connected to a mobile ________ station.
switching
Connecting your phone to your laptop to transfer photos, videos, or music files is referred to as ________.
synching
A collection of related records in a database is referred to as a ________.
table
A common SQL term used in queries is FROM. FROM allows the user to choose the _____ of the database in which the query is located.
table
A thousand gigabytes(GB) equals one___
terabye
A thousand gigabytes equals one ___
terabyte
If you purchase a new graphics computer game or a new photo/video editing software for your desktop computer, you may want to purchase a new ________ card.
video
Some apps that use a surprising amount of data are those that include embedded ________.
videos
The term "search engine optimization" (SEO) refers to the process of making a website _____ in a user's search results.
visible
An IP address is a string of numbers that tells a computer where to look for a _____.
website
A search engine has a database of _____, and when a user types in a search word, the search engine searches its database for a match.
websites
Which of the following could have a traditional(magnetic) hard drive
Dell desktop computer
Broadband is measured in ________.
Mbps
Microsoft offers free cloud storage for everyone who has a Microsoft e-mail account. This storage is called Microsoft _______
OneDrive
An alternative term for a programming language is programming ________.
code
Web programmers write the _____ that creates the pages that viewers will see.
code
Trying to answer questions such as "what happened?" or "what is occurring?" or "what was the ROI?" is the role of
descriptive analytics
Which transmission media has the largest bandwidth?
fiber optic
THe SSD cost is ___ than a hard drive
higher
One thousand kilobytes equals one
megabyte
To search a database for information, create a ________.
query
Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.
spreadsheets
Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called
spreadsheets.
Adding a microSD card (when possible) increases your phone's ________ capacity.
storage
SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.
structured
Because of the popularity and bandwidth demands of video streaming, ________ data plans became very expensive. Tough competition for customers forced cell phone service providers to increase available bandwidth, so now these data plans are fairly common.
unlimited
A domain is the name of a _____.
website
If you are planning to write PC games software, you might need to know C or ________.
C++
The PDLC's coding phase uses which of the following languages?
C++
To remove a file from one folder and place it in another, click on the item and press ________, then move your cursor to the new location and press CTRL + V.
CTRL + X
What are the four most commonly used web browsers?
Chrome Safari Firefox Edge
SAGE was developed during the ________ War.
Cold
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ________ subsystem.
Data Administration
Acronym for End-User Licensing Agreement
EULA
The second step in the PDLC is to create the plan or algorithm. This plan is usually written as a flowchart and is written in ________.
English
If you see the extension .xlsx, you know that you are looking at a(n) ________ file.
Excel
A quick way to rename files or folders in Windows is to select the item and then press the ________ key.
F2
You created a flyer and saved it in your Documents folder. To find this file you could open Cortana (in Windows 10) and type the flyer's name in the search window, or you could click on the ________ icon (all Windows versions, on your toolbar) and access the Documents folder from there.
File Explorer
The protocol used for transmitting large files from one server to another over the Internet is known as the ________ Protocol (FTP).
File Transfer
To speed up the programming process while producing dynamic web pages, select the program that utilizes tiny programs called scripts.
JavaScript
______ is a computer programming language that enables the client-side (browser) to interact with users, change document content, communicate asynchronously, and more.
Javascript
The method used in the development and maintenance of an IT scheme is called the SDLC. SDLC stands for System Development ________ Cycle.
Life
Digital music devices are connect to computers using ___ ports
MIDI
Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ________ System.
Management
MIDI stands for
Musical Instrument Digital Interface
The actual pixel number in a monitor is called the ___ resolution
Native
JSON stands for JavaScript ________ Notation.
Object
You're tired of losing documents so you've decided to save your research paper to your desktop where you know you'll be able to locate it quickly. To save it to the desktop, you first click the File tab to open the file menu. Next you select ________.
Save As
Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?
Share
Because it comes with a full computer operating system, some consider the ________ a laptop computer rather than a tablet computer.
Surface Pro 8
Apple developed ________, a programming language for Mac OS and iOS writing software because Objective-C was hard to write.
Swift
The World Wide Web was created through a collaboration led by ________.
Tim Berners-Lee
In addition to activating ________ protection, it's a good idea to disable your router's SSID transmission once all your devices are connected.
WPA2
Many cellular ISPs offer modem/router combination devices that can create a ________ wherever there is adequate cell service.
Wi-Fi hot spot
Although not a programming language technically, ________ pertains to the protocols that enable content to be displayed on the Internet.
XML
A bus is a channel over which information flows. A bus has two parts: the ______ and the ____
address bus; data bus
Written in the English language and as a flowchart, a programmer uses a(n) ________ to describe the problem to be solved by the program.
algorithm
In order to change sound waves into digital signals, smartphones contain a(n) ________-digital converter.
analog
The second step of the SDLC phase is to collect information on current hardware and software, analyze this information, and prepare system requirements. This is called the phase of the ________ scheme.
analysis
When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ________ generation subsystem
application
One character of information comprises of one ___ of storage
byte
Which might be a choice for Internet service in your area?
cable internet
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)
cell
To select a folder, simply put your cursor on it and ________.
click
If you wish to e-mail a file to a friend, but find that it's too big for your e-mail server, you can always ________ the file.
compress
The term "Server" has two meanings. One is a physical server that stores files and web pages, the other meaning refers to _____ that manages and processes server requests and delivers data to other computers.
computer software
The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally
creating your visuals
The fourth step in the life cycle of system growth is to get the required equipment and ensure that it operates properly. This is called the system ___________ step.
development
An integral part of a database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ________.
dictionary
The devices inside your phone that convert analog waves (such as sound waves) into digital signals that your phone can process are called ________.
digital-analog converters
A database that stores data in different physical locations and that users access though client/server networks is called a ________ database.
distributed
An easy way to create a new folder in Windows is to ________ on any area in the Contents pane, and then click New and Folder.
double-click
If you have two folders open on your desktop and you want to move a file from one folder to the other, simply ________ the file.
drag
Routers that can send Intern
dual-band
Solid state drives(SSD) store data using ___
electronic circuits
HTML documents are broken down into sections called _____.
elements
In a database a ________ is a group of related characters in a database table that represents a characteristic of someone or something.
field
The ________ step in software development is: What should this program do?
first
In order to keep your files organized, it's a good idea to create ________ and place your files in them.
folders
When you need to link two tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in the other table.
foreign key
Data transformation is the process of converting the _____ of data.
format
To control how information is entered into a database, programmers and database administrators create ________ to help ensure data integrity.
forms
The total amount of money (principal + interest) that lender receives from a borrower at the end of the loan is referred to as the loan's
future value (FV).
The largest category of apps, both in terms of active downloads and in terms of revenue generated is ________.
game apps
Typical tablet computer or smartphone SSD capabilities are measured in
gigabytes
When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem.
manipulation
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a(n) ________ database.
multidimensional
Website video, audio, and slide shows are examples of what type of files?
multimedia
The information in the memory)the RAM, the caches, the registers) is ___ when a computer is shut down
not saved
A(n) ________-oriented assessment operates well when inputs can readily be put into distinct categories or classes.
object
The amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.
principal
Converting a task into commands that a computer can use to perform the task is called ________.
programming
Converting a task into commands that a computer can use to perform the task is one definition of computer ________.
programming
Which type of touchscreen uses a single metallic-coated panel and uses electricity to calculate touch points
projective capacitive
Written in natural language, but often including shorthand programming to help write the program itself, ________ is the word that defines an intermediate step in generating a flowchart algorithm.
pseudocode
SQL, usually pronounced "sequel," is quite useful when working with large data sets. The Q in SQL stands for
query
Before a browser displays your web page, it first ____ and _____ all the HTML, CSS, and other codes.
reads and interprets
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ________.
record
Collections of related fields in a database are referred to as
records
In order to be considered open data, databases must provide access rights so that they can be
redistributed
The type of database that uses common fields to create links between tables is called a(n) ________ database.
relational
A link between tables in a relational database that defines how the data is related is called a ________.
relationship
To display or distribute information from a database, programmers or database administrators create ________.
report
To Insert a Column to the left of Column D in an OpenOffic Calc file, select Column D and then ________ and select Insert.
right-click
If you're in an area where your home network has no cell coverage, you may need to use the cellular network of a different provider. This is called ________.
roaming
Ironically, the expenses for calling and ________ are among the smallest charges found on a cell phone bill.
texting
When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______ data.
third-party
What is the purpose of saving an Excel file as a .cvs (comma-separated format) file?
to share data with other spreadsheet users regardless of which spreadsheet program is being used
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)
two dashes "--"
You might consider constructing a wireframe when designing a website. A wireframe is a _____ representation of the user interface for a web page.
two-dimensional
