The table shows Student, Grade, and Email on a club sign-up sheet. Which row would be counted as a separate member even though that student already appears in the table?

The table shows Name, Shift, and Email for library volunteers. Which row is a duplicated record?

The table shows Student, Period, and Email from an art survey. Which row duplicates an earlier record?

The table shows Student, Grade, and Phone for event attendees. Which row is a duplicate of an earlier attendee record?

The table lists Route, Stop, and Boardings from a bus-door counter. Which cell contains a value the counter could not have recorded?

The table lists Day, Steps, and Battery percent from fitness bands. Which cell holds a value the band could not have recorded?

The table lists Plot, Moisture percent, and Time from soil sensors. Which cell holds a value the sensor could not have recorded?

The table lists Day, Meal, and Trays from a cafeteria tray scanner. Which cell contains a value the scanner could not have recorded?

A researcher downloads hourly traffic counts from a state transportation department's public archive and analyzes them for a new project. How was the data obtained?

A club adviser sends every team member an online form asking which meeting day they prefer. What collection method is being used?

A weather station automatically records humidity every hour and sends the readings to a file. What is the source of this data?

A student uses county census tables published online to compare neighborhood populations. What is one limitation of using this secondary data?

An orders spreadsheet mixes dates such as 03/04/2025 and 4 March 2025, causing a chart to group some orders incorrectly. What cleaning action is needed?

An import accidentally places the same online order in a sales file twice. What should cleaning do?

A temperature data set has an empty reading for one hour because a sensor briefly lost power. Which cleaning action best preserves what is known?

A student-ID field contains S102, s102, and spaces before S102 for the same identifier. What cleaning action is appropriate?

A school garden project will collect thousands of readings with fields for sensor ID, date, time, and soil moisture. Several programs must search the records. Where should the readings be stored?

A class has 30 one-time observations in three columns and wants to sort them and make a chart. What is an appropriate place to store this small data set?

Authorized counselors need to search a growing student-support data set, while different staff members should see only records permitted for their role. What storage choice best fits?

A wildlife project has thousands of camera images and needs to search records by date, location, and species. How should the searchable record information be stored?

A school event system must connect each attendee to multiple sessions, while each session has many attendees. Which storage arrangement best supports those related records?

A sign-up form lets students type their grade into an empty box, producing 9, Nine, 9th, and Yr 9. What change would have prevented the inconsistent entries?

A form collecting battery percentages accepts entries such as 135 and -4. What point-of-entry change would prevent those invalid values?

A contact form has many blank email fields because users can submit it without entering an email address. What change would prevent this missing-data problem?

A registration form accepts both 03/04/2025 and 4 March 2025 in its date field. What input change would best prevent mixed date formats?