WorksheetsQUIZ APCSP BIG IDEA 2
Total questions: 13
Worksheet time: 15mins
A digital photo is taken with a smartphone. In addition to the image data itself, the file also contains information such as the date and time the photo was taken, the GPS coordinates of the location, and the model of the smartphone used. This additional information is best described as:
Metadata
A heuristic
An algorithm
Lossy data
A musician records a high-fidelity song in a studio and saves it as a .WAV file. To upload the song to a streaming service, they convert the file to a .MP3 format. The .MP3 file is significantly smaller, but some of the audio frequencies that are hard for humans to hear are permanently removed. This conversion is an example of:
Lossless compression
Lossy compression
Metadata analysis
Data encryption
A data scientist is analyzing a large dataset collected from a city's traffic sensors. The dataset includes the number of cars that pass a sensor each hour, the average speed of those cars, and the time of day. The scientist wants to find the relationship between the time of day and the average traffic speed. Which of the following data visualizations would be most appropriate for this purpose?
A pie chart
A scatter plot
A histogram
A bar chart showing only the total cars per day
A researcher analyzing data from a fitness app finds a strong positive correlation between the number of steps a user takes per day and the user's self-reported happiness level. Based only on this information, which of the following is a valid conclusion?
Taking more steps causes a user to be happier.
Users who are happier are caused to take more steps.
There is an association between step count and happiness, but a causal relationship cannot be concluded.
There is no relationship between the number of steps taken and happiness.
A scientist has a large dataset of whale sightings, which includes whale_species, date_seen, and location_coordinates. The scientist wants to create a new, smaller dataset that only contains sightings of "Humpback" whales. Which data processing operation is most appropriate for this task?
Sorting
Compressing
Visualizing
Filtering
Which of the following pieces of information, when collected and stored by a company, would be considered Personally Identifiable Information (PII)?
I. A user's full name
II. A user's country of residence
III. A user's email address
I and III only
I only
II only
I, II, and III
A school principal analyzes student data and finds a strong positive correlation between the number of AP classes a student takes and their final-year GPA. Which TWO conclusions are valid based only on this correlation? (Select 2 answers)
An association or pattern exists between the number of AP classes taken and the final-year GPA.
Students with high GPAs are caused to take more AP classes.
A causal relationship cannot be determined from this correlation alone.
All students who take fewer AP classes will have a lower GPA.
Which TWO of the following statements are true regarding data compression? (Select 2 answers)
Lossy compression is ideal for backing up important text documents or source code.
A .MP3 audio file is a common example of lossy compression.
Lossless compression reduces file size by permanently deleting data that is unnoticeable.
A .ZIP file is a common example of lossless compression.
A user takes a photo with a digital camera and uploads it to a website. Which TWO of the following would be considered metadata for the image file? (Select 2 answers)
The total number of pixels in the image.
The GPS coordinates identifying where the photo was taken.
The camera model used to take the photo.
A text comment another user posts on the website about the photo.
A new social media app requires users to sign up. Which TWO of the following pieces of data, if collected by the app, would be considered Personally Identifiable Information (PII)?(Select 2 answers)
The user's full name.
The user's screen resolution (e.g., 1920x1080).
The user's social security number.
The time of day the user is most active.
A developer is working with a database table of employee records, which includes the fields Employee_ID, Department, Hire_Date, and Salary. The developer needs to generate a report that lists the Employee_ID of the three longest-serving (hired earliest) employees in the "Engineering" department.
Which of the following describes the correct sequence of operations to generate this report?
Sort by Hire_Date (ascending), then filter for Department == "Engineering", then select the top 3.
Filter for Department == "Engineering", then sort by Hire_Date (ascending), then select the top 3.
Sort by Salary (descending), then filter for Department == "Engineering", then select the top 3.
Filter for Department == "Engineering", then sort by Employee_ID (ascending), then select the top 3.
A research firm releases a large dataset about citizens that has been "anonymized." All Personally Identifiable Information (PII), such as names and social security numbers, has been removed. However, the dataset still contains each individual's 5-digit ZIP code, full date of birth, and gender.
Why might this "anonymized" dataset still present a significant privacy concern?
The dataset is stored as a .CSV file, which is an unencrypted format.
The combination of these three "non-PII" data points can be cross-referenced with other public datasets (e.g., voter registration lists) to re-identify specific individuals.
The dataset's metadata still includes the name of the researcher who compiled it.
The dataset is too large to be processed efficiently, leading to data loss.
A computer science class is analyzing a large .CSV (Comma Separated Values) file containing data about popular songs on a streaming service. Each row represents a single song. The table includes the following columns:
Song_Title, Artist_Name, Release_Year, Genre, Duration_ms (length in milliseconds), Popularity_Score (0-100)
Which of the following processes uses only metadata from this dataset?
Calculating the average Duration_ms of all songs released in Release_Year 2023.
Finding the 10 songs with the highest Popularity_Score.
Creating a list of all unique Genre entries to understand what categories exist.
Analyzing the .CSV file's properties to find its "Date Created" and "File Size" on the computer's hard drive.
