Unit 3 Comp Sci #5

Which of the following are true statements about how the Internet enables crowdsourcing?

I. The Internet can provide crowdsourcing participants access to useful tools, information, and professional knowledge.

II. The speed and reach of the Internet can lower geographic barriers, allowing individuals from different locations to contribute to projects.

III. Using the Internet to distribute solutions across many users allows all computational problems to be solved in reasonable time, even for very large input sizes.

• I and II only

• I and III only

• II and III only

• I, II, and III

A system is being developed to help pet owners locate lost pets. Which of the following best describes a system that uses crowdsourcing?

• A mobile application and collar that uses GPS technology to determine the pet’s location and transmits the location when the owner refreshes the application

• A mobile application and collar that uses wireless technology to determine whether the pet is within 100 feet of the owner's phone and transmits a message to the owner when the pet is nearby

• A mobile application that allows users to report the location of a pet that appears to be lost and upload a photo that is made available to other users of the application

• A mobile application that transmits a message to all users any time a lost pet is returned to its owner

A company uses the following data files.

A new rechargeable battery pack is available for products that use AA batteries. Which of the following best explains how the data files in the table can be used to send a targeted e-mail to only those customers who have purchased products that use AA batteries to let them know about the new accessory?

• Use the customer IDs in the purchases file to search the customers file to generate a list of e-mail addresses

• 
  Use the product IDs in the purchases file to search the products file to generate a list of product names that use AA batteries

• Use the customers file to generate a list of customer IDs, then use the list of customer IDs to search the products file to generate a list of product names that use AA batteries

• Use the products file to generate a list of product IDs that use AA batteries, then use the list of product IDs to search the purchases file to generate a list of customer IDs, then use the list of customer IDs to search the customers file to generate a list of e-mail addresses

A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below.

• In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30.

• In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings.

A student wants to count the number of restaurants in the spreadsheet whose price range is $30 or less and whose average customer rating is at least 4.0. For a given row in the spreadsheet, suppose prcRange contains the price range as a string and avgRating contains the average customer rating as a decimal number.

Which of the following expressions will evaluate to true if the restaurant should be counted and evaluates to false otherwise?

• (avgRating ≥ 4.0) AND ((prcRange = "lo") AND (prcRange = "med"))

• (avgRating ≥ 4.0) AND ((prcRange = "lo") OR (prcRange = "med"))

• (avgRating ≥ 4.0) OR ((prcRange = "lo") AND (prcRange = "med"))

• (avgRating ≥ 4.0) OR ((prcRange = "lo") OR (prcRange = "med"))

A large spreadsheet contains the following information about local restaurants. A sample portion of the spreadsheet is shown below.

• In column B, the price range represents the typical cost of a meal, where "lo" indicates under $10, "med" indicates $11 to $30, and "hi" indicates over $30.

• In column D, the average customer rating is set to -1.0 for restaurants that have no customer ratings.

A student is developing an algorithm to determine which of the restaurants that accept credit cards has the greatest average customer rating. Restaurants that have not yet received any customer ratings and restaurants that do not accept credit card are to be ignored.

Once the algorithm is complete, the desired restaurant will appear in the first row of the spreadsheet. If there are multiple entries that fit the desired criteria, it does not matter which of them appears in the first row.

The student has the following actions available but is not sure of the order in which they should be executed.

Assume that applying either of the filters will not change the relative order of the rows remaining in the spreadsheet.

Which of the following sequences of steps can be used to identify the desired restaurant?

1. Filter by number of ratings, then filter by payment type, then sort by rating

2. Filter by number of ratings, then sort by rating, then filter by payment type

3. Sort by rating, then filter by number of ratings, then filter by payment type

• I and II only

• I and III only

• II and III only

• I, II, and III

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 large spreadsheet contains information about the photographs in a museum’s collection. A sample portion of the spreadsheet is shown below.

• In column A, each unknown photographer is set to "(unknown)".

• In column C, each unknown year is set to -1.

A student is developing an algorithm to determine the name of the photographer who took the oldest photograph in the collection. Photographs whose photographer or year are unknown are to be ignored.

Once the algorithm is complete, the desired entry will appear in the first row of the spreadsheet. If there are multiple entries that meet the desired criteria, then any of them can appear in the first row.

The student has the following actions available.

• Filter by photographer, then filter by year, then sort by subject

• Filter by photographer, then filter by year, then sort by year

• Sort by subject, then sort by year, then filter by photographer

• Sort by year, then filter by year, then filter by photographer

A large spreadsheet contains information about the schedule for a college radio station. A sample portion of the spreadsheet is shown below.

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 large spreadsheet contains the following information about the books at a bookstore. A sample portion of the spreadsheet is shown below.

An employee wants to count the number of books that meet all of the following criteria.

• Is a mystery book

• Costs less than $10.00

• Has at least one copy in stock

For a given row in the spreadsheet, suppose genre contains the genre as a string, num contains the number of copies in stock as a number, and cost contains the cost as a number. Which of the following expressions will evaluate to true if the book should be counted and evaluates to false otherwise?

• (genre = "mystery") AND ((1 ≤ num) AND (cost < 10.00))

• (genre = "mystery") AND ((1 < num) AND (cost < 10.00))

• (genre = "mystery") OR ((1 ≤ num) OR (cost < 10.00))

• (genre = "mystery") OR ((1 < num) OR (cost < 10.00))

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.