Comp Sci unit 3 #2

Comp Sci unit 3 #2

11th Grade

10 Qs

quiz-placeholder

Similar activities

Arrays and Lists

Arrays and Lists

6th - 12th Grade

10 Qs

1.2.2 - Secondary Storage

1.2.2 - Secondary Storage

KG - University

13 Qs

CONDITIONAL FORMATTING

CONDITIONAL FORMATTING

9th - 12th Grade

15 Qs

Database concepts part 1 & 2

Database concepts part 1 & 2

9th - 11th Grade

15 Qs

data validation MS Access

data validation MS Access

11th Grade

15 Qs

ERDs and DFDs

ERDs and DFDs

9th - 12th Grade

15 Qs

Variable

Variable

11th Grade

10 Qs

AQA GCSE Databases and SQL

AQA GCSE Databases and SQL

9th - 12th Grade

14 Qs

Comp Sci unit 3 #2

Comp Sci unit 3 #2

Assessment

Quiz

Computers

11th Grade

Easy

Created by

Nick Nessralla

Used 12+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Participants in a survey were asked how many hours per day they spend reading, how many hours per day they spend using a smartphone, and whether or not they would be interested in a smartphone application that lets users share book reviews.

The data from the survey are represented in the graph below. Each  represents a survey participant who said he or she was interested in the  application, and each  represents a participant who said he or she was not interested.


Which of the following hypotheses is most consistent with the data in the graph?

Participants who read more were generally more likely to say they are interested in the application.

Participants who read more were generally less likely to say they are interested in the application.

Participants who use a smartphone more were generally more likely to say they read more.

Participants who use a smartphone more were generally less likely to say they read more.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Grades in a computer science course are based on total points earned on a midterm exam and a final exam. The teacher provides a way for students to improve their course grades if they receive high scores on the final exam: if a student’s final exam score is greater than the student’s midterm exam score, the final exam score replaces the midterm exam score in the calculation of total points.

The table below shows two students’ scores on the midterm and final exams and the calculated total points each student earns.

  • Khalil does better on the midterm exam than on the final exam, so his original midterm and final exam scores are added to compute his total points.

  • Josefina does better on the final exam than on the midterm exam, so her final exam score replaces her midterm exam score in the total points calculation.

The teacher has data representing the scores of thousands of students. For each student, the data contain the student name, the midterm exam score, the final exam score, and the result of the total points calculation. Which of the following could be determined from the data?

I. The average total points earned per student
II. The average increase in total points per student as a result of the score replacement policy
III. The proportion of students who improved their total points as a result of the score replacement policy

III only

I and II only

I and III only

I, II, and III

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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 student’s gender

  • -The state in which the student attends college

  • -The student’s grade point average on a 4.0 scale

Which of the following questions could be answered by analyzing only information in the data set?

Do students majoring in computer science tend to have higher grade point 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 percent 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?

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Historically, it has been observed that computer processing speeds tend to double every two years. Which of the following best describes how technology companies can use this observation for planning purposes?

Technology companies can accurately predict the dates when new computing innovations will be available to use.

Technology companies can plan to double the costs of new products each time advances in processing speed occur.

Technology companies can set research and development goals based on anticipated processing speeds.

Technology companies can spend less effort developing new processors because processing speed will always improve at the observed rate.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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?

Which items listed in the database are not currently in the store

Which colors are more popular among men than women

Which type of footwear is most popular among adults

The total number of shoes sold in a particular month

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Each student at a school has a unique student ID number. A teacher has the following spreadsheets available.

  • -Spreadsheet I contains information on all students at the school. For each entry in this spreadsheet, the student name, the student ID, and the student’s grade point average are included.

  • -Spreadsheet II contains information on only students who play at least one sport. For each entry in this spreadsheet, the student ID and the names of the sports the student plays are included.

  • -Spreadsheet III contains information on only students whose grade point average is greater than 3.5. For each entry in this spreadsheet, the student name and the student ID are included.

  • -Spreadsheet IV contains information on only students who play more than one sport. For each entry in this spreadsheet, the student name and the student ID are included.

The teacher wants to determine whether students who play a sport are more or less likely to have higher grade point averages than students who do not play any sports. Which of the following pairs of spreadsheets can be combined and analyzed to determine the desired information?

Spreadsheets I and II

Spreadsheets I and IV

Spreadsheets II and III

Spreadsheets III and IV

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?