Font size
WorksheetsCSP Unit 13 Practice Test
Total questions: 15
Worksheet time: 15mins
A digital photo file contains data representing the level of red, green, and blue for each pixel in the photo. the file also contains metadata that describes the date and geographic location where the photo was taken. For which of the following goals would analyzing the metadata be more appropriate than analyzing the data?
Determining the likelihood that the photo is a picture of the sky
Determining the likelihood that the photo was taken at a particular public event
Determining the number of people that appear in the photo
Determining the usability of the photo for projection onto a particular color background
An infographic displays the relative frequencies of the top 100 most common GIF's used in text messaging for each of the past 12 months. Which of the following conclusions cannot be drawn from such representation of GIF usage?
You can determine the growth or decline in popularity of a single GIF.
You can determine what percentage of text messages contain a particular GIF.
You can determine the average education level of GIF users based on GIF use.
You can determine how long the most popular GIF has held the #1 spot.
Consider the following relational database that contains the following census data.
Which of the following would be the result if a user were to search this database for any “City” with a population between 100,000 and 1,000,000?
Albany, Dallas, New York, San Antonio, Utica
Anaheim, Austin, Charlotte, Tempe
Dallas, New York, San Antonio
Austin, Dallas, San Antonio
The table below shows the time a computer system takes to complete a specified task on the customer data of different-sized companies.
Based on the information in the table, which of the following tasks is likely to take the longest amount of time when scaled up for a very large company of approximately 100,000 customers?
Backing up data
Deleting entries from data
Sorting data
Searching through data
Biologists often attach tracking collars to wild animals. For each animal, the following geolocation data is collected at frequent intervals.
- time
- date
- location of the animal
Which of the following questions about a particular animal could NOT be answered using only the data collected from the tracking collars?
Approximately how many miles did the animal travel in one week?
Do the movement patterns of the animal vary according to the weather?
In what geographic locations does the animal typically travel?
Does the animal travel in groups with other tracked animals?
Which of the following tasks best shows an example of using searching and sorting techniques of big data in order to find a useful pattern.
Tallying how many pencils and pens you use throughout a school year so you know how many to buy for the start of the next school year to insure you will have enough
Creating a seating chart for a classroom based on an alphabetized list of student Names
Keeping track of all employees’ email use to see how many personal or work-related emails are sent during work time to check for productivity
Recording the amount of time it takes a student to travel from one class to another class in order to find the average
Which of the following is NOT a benefit of making digital information and scientific databases openly available across the internet?
Data scientists can discover previously unnoticed trends and patterns hidden with large data sets.
Scientific researchers can more easily share data on research projects.
Innovations in medicine can be developed from the increased knowledge gained from large data sets.
Inaccurate and misleading data can be more easily disseminated to scientist researchers.
Which of the following can be used to extract structured information from unstructured data?
Organize data into information
Identify patterns in data
Create frameworks for information
All of the above
A hospital that has its own pharmacy keeps track of the following information.
At the end of the week, all of the data is summarized into a database that is accessible by financial analysts of the hospital that can be sorted by any column in ascending or descending order.
Below is a portion of this database.
Which of the following cannot be determined from the information in the database?
a. How many unique prescriptions were filled for a patient in a certain room?
b. How many patients were in the hospital on a given day?
Which of the following cannot be determined from the information in the database?
How many unique prescriptions were filled for a patient in a certain room?
How many patients were in the hospital on a given day?
What was the average cost of the medication, Lipitor, paid by patients?
What day did the pharmacy filled the most prescriptions?
Temporal scan thermometers are popular tools in order to take a baby’s temperature. It uses sensors that when slowly moved across the forehead provides a temperature reading in either degrees Celsius or Fahrenheit. Which of the following has to deal with this type of thermometer’s usefulness and not usability?
The thermometer outputs the temperature with a digital display that uses a backlight.
The thermometer (when used properly) is accurate to within 0.2 degrees.
The thermometer is reasonably priced, so most families can afford it.
The thermometer is ergonomically designed to be comfortable to use.
A local high school recently won the girls volleyball championships and have been rewarded by the school with $5,000 to purchase merchandise for the team. The coach is trying to surprise the players with the merchandise at the banquet, so instead of asking them what sizes they want, he is trying to figure that out based on the information from the volleyball program. The following information is stored in the program for each player.
What would be the best way for the coach to use this information in order to order sizes that work for the majority of the team?
Filter the data by grade and order larges for the juniors and seniors, mediums for the sophomores and smalls for the freshmen.
Sort the data by jersey number, ordering smaller sizes for the lower numbers and larger sizes for higher numbers.
Filter the data by age and height, where the older and taller girls will get larger sizes and the younger and shorter girls will get smaller sizes.
Sort the data by height and weight and order smaller sizes for the girls that are shorter and weigh less and order larger sizes for the girls that are taller and weigh more.
For situations that may be too dangerous, costly or otherwise too difficult to test in the real world, what do computer scientists create in order to draw help discover new knowledge and create new hypothesis related to what situation they are studying?
Classifications
Infographics
Simulations
Regressions
A marine biologist wants to analyze the effects of scuba divers and snorkelers on coral reefs. In order to model this, he plans on writing a program to measure death and decay of the reef over time. Which of the following factors might the marine biologist NOT need to include in his program?
Names of the city that contain the reef
Water temperature
Amount of scuba divers and snorkelers
Type of coral
In Fantasy Football, participants compete against one another by choosing certain players from different NFL teams that they think will do the best on any particular week. Top Fantasy Football players spend hours every day looking at statistics of the players and the teams. Spreadsheets and software tools are used to choose the best players. This process would be considered __________.
Data persistence
Data divide
Data collection
Data mining
Which of the following are examples of how people give up some of their privacy in order to gain something in return (utility)?
Students make sure to use the “Incognito” tab in a web browser so that none of the browsing history is saved and all cache is cleared at the end of the browsing session.
People only use cash to pay for products since they do not have any credit cards.
Customers sign up for “rewards” programs for different grocery stores so that they can get discounts on different items throughout the store.
People enable GPS on their phone so that Apps can locate nearby stores, restaurants and hotels.
