Using Programs with Data

The owner of a clothing store records the following information for each transaction made at the store during a 7-day period.

- The date of the transaction

- The method of payment used in the transaction

- The number of items purchased in the transaction

The total amount of the transaction, in dollars

Customers can pay for purchases using cash, check, a debit card, or a credit card.

Using only the data collected during the 7-day period, which of the following statements is true?

• The average amount spent per day during the 7-day period can be determined by sorting the data by the total transaction amount, then adding the 7 greatest amounts, and then dividing the sum by 7.

• The method of payment that was used in the greatest number of transactions during the 7-day period can be determined by sorting the data by the method of payment, then adding the number of items purchased for each type of payment method, and then finding the maximum sum.

• The most expensive item purchased on a given date can be determined by searching the data for all items purchased on the given date and then sorting the matching items by item price.

• The total number of items purchased on a given date can be determined by searching the data for all transactions that occurred on the given date and then adding the number of items purchased for each matching transaction.

A student wants to count the number of shows that meet both of the following criteria.

Is a talk show Is on Saturday or Sunday

For a given row in the spreadsheet, suppose genre contains the genre as a string and day contains the day as a string. Which of the following expressions will evaluate to true if the show should be counted and evaluates to false otherwise?

• (genre = "talk") AND ((day = "Saturday") AND (day = "Sunday"))

• (genre = "talk") AND ((day = "Saturday") OR (day = "Sunday"))

• (genre = "talk") OR ((day = "Saturday") AND (day = "Sunday"))

• (genre = "talk") OR ((day = "Saturday") OR (day = "Sunday"))

A wildlife preserve is developing an interactive exhibit for its guests. The exhibit is intended to allow guests to select the name of an animal on a touch screen and display various facts about the selected animal.

For example, if a guest selects the animal name “wolf,” the exhibit is intended to display the following information.

- Classification: mammal

- Skin type: fur

- Thermoregulation: warm-blooded

- Lifestyle: pack

- Average life span: 10–12 years

- Top speed: 75 kilometers/hour

The preserve has two databases of information available to use for the exhibit. The first database contains information for each animal’s name, classification, skin type, and thermoregulation. The second database contains information for each animal’s name, lifestyle, average life span, and top speed.

Which of the following explains how the two databases can be used to develop the interactive exhibit?

• Only the first database is needed. It can be searched by animal name to find all the information to be displayed.

• Only the second database is needed. It can be searched by animal name to find all the information to be displayed.

• Both databases are needed. Each database can be searched by animal name to find all information to be displayed.

• The two databases are not sufficient to display all the necessary information because the intended display information does not include the animal name.

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

• A computer program cannot combine data from different files.

• Different counties may organize data in different ways.

• The number of counties is too large for the program to process.

• The total number of rows of data is too large for the program to process.

A student is creating a Web site that is intended to display information about a city based on a city name that a user enters in a text field. Which of the following are likely to be challenges associated with processing city names that users might provide as input?

Select two answers.

• Users might attempt to use the Web site to search for multiple cities.

• Users might enter abbreviations for the names of cities.

• Users might misspell the name of the city.

• Users might be slow at typing a city name in the text field.

A database of information about shows at a concert venue contains the following information.

- Name of artist performing at the show

- Date of show

- Total dollar amount of all tickets sold

Which of the following additional pieces of information would be most useful in determining the artist with the greatest attendance during a particular month?

• Average ticket price

• Length of the show in minutes

• Start time of the show

• Total dollar amount of food and drinks sold during the show

A camera mounted on the dashboard of a car captures an image of the view from the driver’s seat every second. Each image is stored as data. Along with each image, the camera also captures and stores the car’s speed, the date and time, and the car’s GPS location as metadata. Which of the following can best be determined using only the data and none of the metadata?

• The average number of hours per day that the car is in use

• The car’s average speed on a particular day

• The distance the car traveled on a particular day

• The number of bicycles the car passed on a particular day