AP CSP DATA ANALYSIS 1

1

You were recently employed as a data analyst and have a need to calculate the total amount of money the store will receive if they sell all of the available Technical books. Which columns in the database can be ignored and still allow you to perform this calculation

1

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 counties across the United States. The program is intended to combine county data and then process the data. Which of the following is MOST likely to be a challenge in creating the program?

Different counties may report pollution data using different formats or units of measurement.

The program will need to use a loop to process the data.

The researchers will need to create variables to store the pollution data.

The program will need to display the results on a computer screen.

A computer program cannot combine data from different sources.

1

You are an analyst for an ISD and need to analyze same data from two different campuses. The data is already clean, before you combine the data what do you need to do?

1

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Which of the following information CANNOT be directly determined without additional data?

The specific dates when students were absent

The average attendance rate for all students

The number of students with perfect attendance

The total number of absences across all students

1

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Something is wrong with this dataset, I have one redundant data fields which would not cause error but consumes unnecessary memory space, can you spot it?
In a minimum of 3 full sentences, tell me your observations, why you think is redundant, and what would you advice?

1

A large data set contains information about all students majoring in computer science in colleges across the united states. The data set contains the following information about each student.
The students gender
The state in which the student attends college
The student grade point average (GPA) on a 4.0 scale
Which of the following could be answered by analyzing only the information in the data set?

Do students majoring in computer science tend to have higher GPA averages than students majoring in other subjects?

How many states have a higher percentage of female computer science majors than male computer science majors attending college in that state?

What percentage of students attending college in a certain state are majoring in computer science?

Which college has the highest number of students majoring in computer science?

1

On a video sharing platform, each video has the following metadata:
Upload date,
Duration,
Uploader's username,
View count,
Like count.
The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

Finding which time of year has the most video uploads

Determining the most popular video length

Identifying which types of scenes appear most frequently in videos

Finding creators with the highest average view counts

1

An image sharing website stores photos (data) and metadata including: photographer name, camera model, location tags, and upload time. Which task would necessitate analyzing the image data itself?

Finding photographers who post most frequently

Determining popular photography locations

Detecting what colors are most common in photos

Identifying which cameras are most used

1

A music streaming service stores songs (data) along with metadata including:
Artist name,
Release date,
Play count,
Genre tags, and
User playlist additions.
Which analysis would require examining the actual song data?

Finding the most popular genre by play count

Analyzing the audio characteristics like tempo and key

Determining which artists have the most songs

Identifying which months have the most new releases

AP CSP DATA ANALYSIS 1

You were recently employed as a data analyst and have a need to calculate the total amount of money the store will receive if they sell all of the available Technical books. Which columns in the database can be ignored and still allow you to perform this calculation

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 counties across the United States. The program is intended to combine county data and then process the data. Which of the following is MOST likely to be a challenge in creating the program?

You are an analyst for an ISD and need to analyze same data from two different campuses. The data is already clean, before you combine the data what do you need to do?

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Which of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:
Upload date,
Duration,
Uploader's username,
View count,
Like count.
The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

An image sharing website stores photos (data) and metadata including: photographer name, camera model, location tags, and upload time. Which task would necessitate analyzing the image data itself?

A music streaming service stores songs (data) along with metadata including:
Artist name,
Release date,
Play count,
Genre tags, and
User playlist additions.
Which analysis would require examining the actual song data?

You were recently employed as a data analyst and have a need to calculate the total amount of money the store will receive if they sell all of the available Technical books. Which columns in the database can be ignored and still allow you to perform this calculation

Which of the following Boolean expressions would identify books that need reordering (quantity less than 10) AND cost more than $40?

Data filtering question
A program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 counties across the United States. The program is intended to combine county data and then process the data. Which of the following is MOST likely to be a challenge in creating the program?

You are an analyst for an ISD and need to analyze same data from two different campuses. The data is already clean, before you combine the data what do you need to do?

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Which of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:
Upload date,
Duration,
Uploader's username,
View count,
Like count.
The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

An image sharing website stores photos (data) and metadata including: photographer name, camera model, location tags, and upload time. Which task would necessitate analyzing the image data itself?

A music streaming service stores songs (data) along with metadata including:
Artist name,
Release date,
Play count,
Genre tags, and
User playlist additions.
Which analysis would require examining the actual song data?

Which of the following Boolean expressions would identify books that need reordering (quantity less than 10) AND cost more than $40?

Data filtering question
A program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?

AP CSP DATA ANALYSIS 1

AP CSP DATA ANALYSIS 1

You were recently employed as a data analyst and have a need to calculate the total amount of money the store will receive if they sell all of the available Technical books. Which columns in the database can be ignored and still allow you to perform this calculation

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 counties across the United States. The program is intended to combine county data and then process the data. Which of the following is MOST likely to be a challenge in creating the program?

You are an analyst for an ISD and need to analyze same data from two different campuses. The data is already clean, before you combine the data what do you need to do?

A well known high school in college station has a dataset with the following information.Student_ID, Total_Days, Number_Days_Present, Number_Days_AbsentAttendance_RateWhich of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:Upload date, Duration, Uploader's username, View count, Like count. The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

An image sharing website stores photos (data) and metadata including: photographer name, camera model, location tags, and upload time. Which task would necessitate analyzing the image data itself?

A music streaming service stores songs (data) along with metadata including: Artist name, Release date, Play count, Genre tags, and User playlist additions. Which analysis would require examining the actual song data?

You were recently employed as a data analyst and have a need to calculate the total amount of money the store will receive if they sell all of the available Technical books. Which columns in the database can be ignored and still allow you to perform this calculation

Which of the following Boolean expressions would identify books that need reordering (quantity less than 10) AND cost more than $40?

Data filtering questionA program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3000 counties across the United States. The program is intended to combine county data and then process the data. Which of the following is MOST likely to be a challenge in creating the program?

You are an analyst for an ISD and need to analyze same data from two different campuses. The data is already clean, before you combine the data what do you need to do?

A well known high school in college station has a dataset with the following information.Student_ID, Total_Days, Number_Days_Present, Number_Days_AbsentAttendance_RateWhich of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:Upload date, Duration, Uploader's username, View count, Like count. The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

An image sharing website stores photos (data) and metadata including: photographer name, camera model, location tags, and upload time. Which task would necessitate analyzing the image data itself?

A music streaming service stores songs (data) along with metadata including: Artist name, Release date, Play count, Genre tags, and User playlist additions. Which analysis would require examining the actual song data?

Which of the following Boolean expressions would identify books that need reordering (quantity less than 10) AND cost more than $40?

Data filtering questionA program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Which of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:
Upload date,
Duration,
Uploader's username,
View count,
Like count.
The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

A music streaming service stores songs (data) along with metadata including:
Artist name,
Release date,
Play count,
Genre tags, and
User playlist additions.
Which analysis would require examining the actual song data?

Data filtering question
A program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?

A well known high school in college station has a dataset with the following information.
Student_ID,
Total_Days,
Number_Days_Present,
Number_Days_Absent
Attendance_Rate
Which of the following information CANNOT be directly determined without additional data?

On a video sharing platform, each video has the following metadata:
Upload date,
Duration,
Uploader's username,
View count,
Like count.
The video itself contains the actual footage. Which task would specifically require analyzing the video data rather than just the metadata?

A music streaming service stores songs (data) along with metadata including:
Artist name,
Release date,
Play count,
Genre tags, and
User playlist additions.
Which analysis would require examining the actual song data?

Data filtering question
A program needs to find all Sci-Fi books that are in stock (quantity > 0) and cost less than $30. What is the minimum number of comparisons needed for each book record?