A student’s overall course grade in a certain class is based on the student’s scores on individual assignments. The course grade is calculated by dropping the student’s lowest individual assignment score and averaging the remaining scores. For example, if a particular student has individual assignment scores of 85, 75, 90, and 95, the lowest score (75) is dropped. The calculated course grade is (85+90+95)/3. An administrator at the school has data about hundreds of students in a particular course. While the administrator does not know the values of each student’s individual assignment scores, the administrator does have the following information for each student.   The student name A unique student ID number The number of assignments for the course The average assignment score before the lowest score was dropped The course grade after the lowest score was dropped   Which of the following CANNOT be determined from this data alone?

The following code segment is used to determine whether a customer is eligible for a discount on a movie ticket. val1 (NOT(category = “new”)) OR (age 65) val2 (_________(category = “new”) AND (age 12) If category is “new” and age is 20, what are the values of val1 and val2 as a result of executing the code segment?

Consider the following code segment. Throughout the fourth block of code are nested blocks of code. Line 1: [begin block] a ← true [end block] Line 2: [begin block] b ← false [end block] Line 3: [begin block] c ← true [end block] [Begin Block] Line 4: REPEAT UNTIL [begin block] a and b [end block] [Begin Block] Line 5: [begin block] c ← NOT c [end block] Line 6: [begin block] b ← c [end block] [End Block] [End Block] Line 7: [begin block] DISPLAY [begin block] a [end block] [end block] Line 8: [begin block] DISPLAY [begin block] b [end block] [end block] Line 9: [begin block] DISPLAY [begin block] c [end block] [end block] What is displayed as a result of executing the code segment?

Directions: The question or incomplete statement below is followed by four suggested answers or completions. Select the one that is best in each case. A library of e-books contains metadata for each book. The metadata are intended to help a search feature find books that users are interested in. Which of the following is LEAST likely to be contained in the metadata of each e-book?

A retailer that sells footwear maintains a single database containing records with the following information about each item for sale in the retailer’s store.   Item identification number Footwear type (sneakers, boots, sandals, etc.) Selling price (in dollars) Size Color Quantity available   Using only the database, which of the following can be determined?

A 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 bookstore has a database containing information about each book for sale in the store. A sample portion of the database is shown below.   Book Database Table Author Title Selling Price Genre Quantity Available J. M. Barrie Peter and Wendy $6.99 Fantasy 3 L. Frank Baum The Wonderful Wizard of Oz $7.99 Fantasy 2 Arthur Conan Doyle The Hound of the Baskervilles $7.49 Mystery 4 Mary Shelley Frankenstein $7.99 Horror 4 Jules Verne Twenty Thousand Leagues Under the Sea $6.99 Science Fiction 3 H. G. Wells The War of the Worlds $4.99 Science Fiction 3   A store employee wants to calculate the total amount of money the store will receive if they sell all of the available science fiction books. Which columns in the database can be ignored and still allow the employee to perform this calculation? Select two answers.

Which of the following code segments can be used to interchange the values of the variables num1 and num2 ?

A sorted list of numbers contains 200 elements. Which of the following is closest to the maximum number of list elements that will need to be examined when performing a binary search for a particular value in the list?

Which is a common diagnostic criterion for identifying systemic lupus erythematosus (SLE)? (Select all that apply.)