wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Big CSP EOC Review

Total questions: 194

Worksheet time: 2hrs 17mins

Name
Class
Date
1.
What is the purpose of DNS?
a)
It assigns a unique address to every device on the Internet.
b)
It returns the IP address given the name of a website.
c)
It forwards a message from one machine to another.
d)
It has more bits so you can make a longer, unique address.
2.
Why is IP v4 going to be replaced by IP v6?
a)
IP v6 is easier to use.
b)
IP v4 does not work on old hardware.
c)
IP v4 was not encrypted.
d)
We are running out of IP v4 addresses.
3.
Which of the following is an IP address?
a)
www.google.com
b)
192.168.2.25
c)
1024.2048.64.512.256
d)
A5:D4:23:56:FF:A4
4.

What is an Event?

a)

An action that causes something to happen

b)

An action that doesn’t do anything in the App

c)

An action that will allow you to look up and event

d)

Something that is happening in the calendar

5.
According to the domain name (DNS), which of the following is a subdomain of the domain example.com?
a)
about.example.com
b)
example.co.uk
c)
example.com.org
d)
example.org
6.
Which of the following activities poses the greatest personal cybersecurity risk?
a)
Making a purchase at an online store that uses public key encryption to transmit credit card information
b)
Paying a bill using a secure electronic payment system
c)
Reserving a hotel room by e-mailing a credit card number to a hotel.
d)
Withdrawing money from a bank account using an automated teller machine (ATM)
7.
Which of the following is LEAST likely to indicate a phishing attack?
a)
An e-mail from your bank asks you to call the number on your card to verify a transaction
b)
An e-mail from a merchant asks that you click on a link to reset your password
c)
An e-mail from a utility company asks you to enter your date of birth and social security number for verification purposes.
d)
An e-mail indicates that you have won a large sum of money and asks you to enter your bank account number so that the money can be transferred to you
8.
Which of the following is considered an unethical use of computer resources?
a)
Downloading freeware or shareware onto your home computer
b)
Purchasing a game from an app store and downloading it directly to a mobile device
c)
Purchasing a single-user copy of photo editing software and installing it on all computers in a computer lab
d)
Searching online for an electronic version of a school textbook
9.
Which of the following statements are true about using a high-level programming language instead of a lower-level language?
 I.  Programs written in a high-level language are generally easier for people to read than programs written in a low-level language.

II.   A high-level language provides programmers with more abstractions than a low-level language.
III.
Programs written in a high-level language are generally easier to debug than programs written in a low-level language.
a)
(A)  I only
b)
(A)  I and III only
c)
(A)  II and III only
d)
(A)  I, II, and III
10.
A user enters a Web address in a browser, and a request for a file is sent to a Web server. Which of the following best describes how the file is sent to the user?
a)
The file is broken into packets for transmission. The packets must be reassembled upon receipt.
b)
The file is broken into packets for transmission. The user’s browser must request each packet in order until all packets are received.
c)
The server attempts to connect directly to the user’s computer. If the connection is successful, the entire file is sent. If the connection is unsuccessful, an error message is sent to the user.
d)
The server repeatedly attempts to connect directly to the user’s computer until a connection is made. Once the connection is made, the entire file is sent.
11.
Two computers are built by different manufacturers. One is running a Web server and the other is running a Web browser. Which of the following best describes the ability of the two computers to communicate with each other across the Internet?
a)
The computers cannot communicate because different manufacturers use different communication protocols.
b)
The computers can communicate, but additional hardware is needed to convert data packets from one computer’s protocol to the other computer’s protocol.
c)
The computers can communicate directly only if the messages consist of text; other formats cannot be interpreted across computers.
d)
The computers can communicate directly because Internet communication uses standard protocols.
12.

Consider the following numbers. Binary 1100, Decimal 11, and Hexadecimal D. Which of the following lists the numbers in order from least to greatest?

a)

Binary 1100, Decimal 11, Hexadecimal D

b)

Decimal 11, Binary 1100, Hexadecimal D

c)

Decimal 11, Hexadecimal D, Binary 1100

d)

Hexadecimal D, Decimal 11, Binary 1100

13.
Which of the following has the greatest potential for compromising a user’s personal privacy?
a)
A group of cookies stored by the user’s Web browser
b)
The Internet Protocol (IP) address of the user’s computer
c)
The user’s e-mail address
d)
The user’s public key used for encryption
14.
Both online newspapers and social media sites are used to distribute information on the Internet. Which of the following best describes an advantage that online newspapers have over social media sites?
a)
The ability to distribute information instantaneously
b)
The ability to provide credibility to the information distributed
c)
The ability to provide information that is widely accessible
d)
The ability to provide media-rich content for low cost
15.
Which of the following best describes a Distributed Denial of Service (DDoS) attack?
a)
An attempt by a country to deny its citizens access to the Internet
b)
An attempt to deny users access to a Web site’s resources by flooding the Web site with requests from multiple systems
c)
An attempt by one user to deny service to another user by posting material on a social network
d)
An attempt by a user of the Internet to get private information from a secure database.
16.
A program is expressed in a programming language. Which of the following is true of the program?
a)
The program can also be expressed as binary code, but will be more easily understood by humans when expressed in a higher-level programming language.
b)
The program can also be expressed as binary code, which will reduce the likelihood of errors.
c)
The program cannot be expressed as binary code, because binary code can only be used to represent data.
d)
Some parts of the program can be expressed as binary code, but operations must be expressed using a higher-level programming language.
17.
What is the 4-bit binary number for the decimal number Ten (10)?
a)
0010
b)
1010
c)
0110
d)
0101
18.
Considering the following numbers given in Binary (BIN), Decimal (DEC), and Hexadecimal (HEX) representations:BIN: 1110DEC: 13HEX: FWhich of the following lists the numbers in order from least to greatest?
a)
BIN: 1110, DEC: 13, HEX: F
b)
DEC: 13, BIN: 1110, HEX: F
c)
DEC: 13, HEX: F, BIN: 1110
d)
HEX: F DEC: 13, BIN: 1110
19.
Select the answer that lists the units of bytes in ascending order (from smallest to largest)
a)
Gigabyte, megabyte, terabyte
b)
Megabyte, terabyte, kilobyte
c)
Gigabyte, terabyte, megabyte
d)
Kilobyte, gigabyte, terabyte
20.
Approximately how much bigger (how many more bytes) is a megabyte than a kilobyte?
a)
1,000 times bigger
b)
100,000 times bigger
c)
1,000,000 times bigger
d)
1,000,000,000 times bigger
21.
Which of the following best explains what happens when a new device is connected to the Internet?
a)
A device driver is assigned to the device.
b)
An Internet Protocol (IP) address is assigned to the device.
c)
A packet number is assigned to the device.
d)
A Web site is assigned to the device.
22.

Which of the following would pose the greatest threat to a user’s personal privacy if it were to be leaked to the public?

a)

The IP address of the user’s computer

b)

The user’s browser cookies

c)

The user’s email address

d)

The user’s private key used for encryption

23.
 How many different digits are used in the Hexadecimal number system?
a)
2
b)
10
c)
8
d)
16
24.
Which of the following is the proper format for an HTML tag?
a)
>h1<Content Affected by Tag >/h1<
b)
<h1>Content Affected by Tag<h1>
c)
<h1 Content Affected by Tag />
d)
<h1>Content Affected by Tag</h1>
25.
What is the domain of this URL:www.example.com/home.html
a)
www
b)
home.html
c)
www.example.com
d)
HTML
26.

Consider the process of encoding and decoding a message using the following Caesar cipher encoding scheme in which the plaintext and ciphertext alphabets are offset by four positions, as shown above.


Which of the following encoded ciphertext strings decodes to an original plaintext message of “secret”?

a)

ersecr

b)

wigvix

c)

kwujwl

d)

oaynap

27.

According to Moore’s Law, increases in technological performance should approximately double every year? If this holds true, how much can performance be expected to increase over 5 years?

a)

10 times as much

b)

100 times as much

c)

32 times as much

d)

16 times as much

28.

What is the decimal equivalent of 11010011?

a)

211

b)

210

c)

209

d)

208

29.

What does HTTP stand for?

a)

Hypertalk Talking Protocol

b)

HyperText Transmission Protocol

c)

Hypertext Transferable Protocol

d)

HyperText Transfer Protocol

30.

What does len() do?

a)

It stops the list from continuing

b)

It adds up everything in the list

c)

It counts the amount of values in the list

d)

None of the above

31.

What is % in Python?

a)

Square Root

b)

Modulus

c)

Add

d)

Square Root

32.

What is the RGB value of red?

a)

(255,0,0)

b)

(255,0,255)

c)

(255,255,0)

d)

(0,0,255)

33.

How do you insert "yes.jpg" in HTML?

a)

<img scr = "yes.jpg">

b)

<img src = "yes.jpg">

c)

<img scr = "yes.jpg">

d)

<igm scr = "yes.jpg">

34.
What does HTTP stand for?
a)
Hyper Text Transfer Protocol
b)
Nothing, it's supposed to be HTML
c)
Head To This Page
d)
Hyper Tense Tall Penguins
35.

An Internet attack that causes a server to crash by making repeated requests to the same IP address:

a)

DDoS (Distributed Denial of Service)

b)

Cache Poisoning

c)

DNS (Domain Name System) Hijacking

d)

Phishing

36.

Internet Protocol

a)

Protocol that breaks data down into packets and addresses them with source and destination information

b)

A DNS attack in which numerous pings are made to the same IP, causing it to crash

c)

Protocol used by the World Wide Web. It describes how messages are formatted and interchanged, and how web servers respond to commands.

d)

Protocol that provides reliable, ordered, and error-checked delivery of a stream of packets on the internet

37.
Tranmission Control Protocol:
a)
Breaks messages into packets and addresses them
b)
A DNS attack in which numerous pings are made to the same IP, causing it to crash
c)
Protocol used by the World Wide Web. It describes how messages are formatted and interchanged, and how web servers respond to commands.
d)
Provides reliable, ordered, and error-checked delivery of a stream of packets on the internet
38.
Which bit-sending technology is used for Ethernet cables?
a)
Electric voltage
b)
Alternating frequencies
c)
Beam of light
d)
Magic
39.
Which bit-sending technology is used for fiber optic cables?
a)
Electric voltage
b)
Alternating frequencies
c)
Beam of light
d)
Magic
40.
According to the domain name system (DNS), which of the following is a subdomain of the domain code.org?
a)
educate.code.org
b)
code.com
c)
code.org/apcsp/lesson10
d)
code.co.uk
41.
The world is currently in a transition to using IPv6, a newer version of the IP protocol that uses 128-bit addresses instead of 32-bit addresses used by IPv4. What is the main problem that IPv6 was created to solve?
a)
IPv6 will allow problems with IPv4's address hierarchy to be resolved
b)
32-bit addresses could not ensure that every internet-connected device can receive a unique IP address
c)
32-bit addresses could not accommodate the increased size and amount of data traveling on the Internet as it has grown in popularity
d)
IPv4 proved unreliable in some cases where network redundancy could not be ensured
42.
Given the following network diagram, what is the minimum number of connections that must be broken or removed before computer E can no longer communicate with computer B?
a)
1
b)
2
c)
3
d)
4
43.
Which of the following protocols is primarily used to establish a secure connection between browsers and servers so that no data is lost?
a)
HTTP
b)
SMTP
c)
SSL/TLS
d)
TCP/IP
44.
Which of the following statements about IP addresses is NOT true?
a)
Each IP address has a network previx and may have various subnet and interface IDs
b)
Each of the octets in an address can be any number between 0 and 255
c)
There are no rules or guidelines for creating a new IP address
d)
IP addresses may have prefixes to identify which routers or subnets the address belongs to
45.
Andrew uses an application to track HOW LONG it takes a packet to travel from his computer to a Wikipedia server. Which of the following is he measuring?
a)
Bandwidth
b)
Latency
c)
Number of packets
d)
Router sp
46.
A ____ HTTP request is used when the user requests information, but does not enter anything into the page.
a)
Get
b)
Post
c)
Send
d)
Fetch
47.

A _____ HTTP request is used when the user enters information (ex. user name/password) into the webpage.

a)

Get

b)

Post

c)

Login

d)

Send

48.
Which of the following best describes the basic idea of fault tolerance?
a)
A system that never fails
b)
If part of the system fails, the operation continues without interruption
c)
A program that does not allow inputs out of a range given by a programmer
d)
A program that does not allow loss of precision
49.
Which of these is NOT part of the TCP header?
a)
Packet Number
b)
Sender IP Address
c)
Size of Packet
d)
Name of File
50.
This is used to resolve host names to IP addresses
a)
IP address
b)
subnet mask
c)
default gateway
d)
DNS server
51.
How many bits are in an IPV6 address?
a)
32
b)
64
c)
128
d)
256
52.

HTTP

a)

Protocol used to check if all packets of data have been received

b)

Protocol for relaying packets across an interconnected network (Internet)

c)

Protocol used by web browsers to communicate with the web server and fetch the webpages that you see

d)

A cryptographic protocol used to securely transmit data over an unsecured network

53.

How many bits are in an IPV4 address?

a)

32

b)

64

c)

128

d)

256

54.

What two numbers do we use in binary?

a)

-1 & 0

b)

2 & 1

c)

1 & 0

d)

4 & 0

55.

What number does 110 represent in binary?

a)

6

b)

3

c)

8

d)

12

56.

How would you represent the number 5 in binary?

a)

10

b)

100

c)

101

d)

110

57.

What base is binary in?

a)

2

b)

4

c)

1

d)

7

58.

The following program is run. Then the user NEVER clicks the “homeButton” button. What will be displayed in the console?

a)

1 2 3

b)

1 3

c)

1 3 2 2

d)

3 2 1

59.

The following program is run. Then the user clicks the “homeButton” button TWICE. What will be displayed in the console?

a)

1 2 3

b)

1 3

c)

1 3 2 2

d)

3 2 1

60.

I am enjoying this Quizizz...

a)

Very Very Much ! ! !

b)

Very Much ! !

c)

Much !

d)

Not at All

61.

What color is represented by (0, 150, 0)?

a)

Blue

b)

Green

c)

Yellow

d)

Red

62.

What is displayed to the console log?

a)

$10

b)

$ 10

c)

$10.00

d)

error

63.

What gets logged to the console?

a)

[1, 2, 3, 4, 5]

b)

1

c)

myList

d)

error

64.

What gets logged to the console?

a)

[1, 2, 3, 4, 5]

b)

1

c)

myList

d)

2

65.
a)

True

b)

False

66.

a)

True

b)

False

67.

A student is recording a song on her computer. When the recording is finished, she saves a copy on her computer. The student notices that the saved copy is of lower sound quality than the original recording. Which of the following could be a possible explanation for the difference in sound quality?

a)

The song was saved using fewer bits per second than the original song.

b)

The song was saved using more bits per second than the original song.

c)

The song was saved using a lossless compression technique.

d)

Some information is lost every time a file is saved from one location on a computer to another location.

68.

For which of the following lists can a binary search be used to search for an item in the list?

a)

I only

b)

III only

c)

I and III only

d)

I, II, and III

69.

Which of the following school policies is most likely to have a positive impact on the digital divide?

a)

A school allows students to bring a graphing calculator from home to complete in-class mathematics assignments.

b)

A school allows students to bring a tablet computer to class every day to participate in graded quizzes.

c)

A school provides a laptop or tablet computer to all students enrolled at the school.

d)

A school recommends that all students purchase a computer with as much processing speed as possible so that projects run faster.

70.

An online store uses 6-bit binary sequences to identify each unique item for sale. The store plans to increase the number of items it sells and is considering using 7-bit binary sequences. Which of the following best describes the result of using 7-bit sequences instead of 6-bit sequences?

a)

2 more items can be uniquely identified.

b)

10 more items can be uniquely identified.

c)

2 times as many items can be uniquely identified.

d)

10 times as many items can be uniquely identified.

71.

An algorithm has been developed to compute the sum of all the elements in a list of integers. Which of the following programming structures must be added to the existing algorithm so that the new algorithm computes the sum of only the even integers in the list?

a)

Iteration

b)

Searching

c)

Selection

d)

Sequencing

72.

Over winter break I plan to ...

4 lines
73.

Consider the following code segment to the left.

Which of the variables have the value 50 after executing the code segment?

a)

x only

b)

y only

c)

x and z only

d)

x, y, and z

74.

Consider the following code segment to the left.

What is the value of r as a result of executing the code segment?

a)

10

b)

20

c)

30

d)

40

75.

The variable age is to be used to represent a person’s age, in years. Which of the following is the most appropriate data type for age ?

a)

Boolean

b)

integer

c)

float

d)

string

e)

list

76.

A student is creating an algorithm to display the distance between the numbers num1 and num2 on a number line. The following table shows the distance for several different values.

Which of the following algorithms displays the correct distance for all possible values of num1 and num2 ?

a)

Step 1:

Add num1 and num2 and store the result in the variable sum.

 Step 2:    Take the absolute value of sum and display the result.

b)

Step 1:

Subtract num1 from num2 and store the result in the variable diff.

Step 2:

Take the absolute value of diff and display the result.

c)

Step 1:

Take the absolute value of num1 and store it in the variable absNum1.

Step 2:

Take the absolute value of num2 and store it in the variable absNum2.

Step 3:

Add absNum1 and absNum2 and display the result.

d)

Step 1:

Take the absolute value of num1 and store it in the variable absNum1.

Step 2:

Take the absolute value of num2 and store it in the variable absNum2.

Step 3:

Subtract absNum1 from absNum2 and display the result.

77.

Three words are stored in the variables word1, word2, and word3. The values of the variables are to be updated as shown in the following table.

Which of the following code segments can be used to update the values of the variables as shown in the table?

a)

temp ← word1

word3 ← word1

word1 ← temp

b)

temp ← word1

word1 ← word3

word3 ← temp

c)

temp ← word1

word1 ← word2

word2 ← word3

word3 ← temp

d)

temp ← word3

word3 ← word2

word2 ← word1

word1 ← temp

78.

Consider the following procedures for string manipulation.

The variable initials is to be assigned a string consisting of the first letter of the string firstName followed by the first letter of the string lastName. Which of the following assigns the correct string to initials ?

a)

initials ← concat(prefix(firstName, 1), prefix(lastName, 1))

b)

initials ← concat(prefix(firstName, 2), prefix(lastName, 2))

c)

initials ← prefix(concat(firstName, lastName), 1)

d)

initials ← prefix(concat(firstName, lastName), 2)

79.

To qualify for a particular scholarship, a student must have an overall grade point average of 3.0 or above and must have a science grade point average of over 3.2. Let overallGPA represent a student’s overall grade point average and let scienceGPA represent the student’s science grade point average. Which of the following expressions evaluates to true if the student is eligible for the scholarship and evaluates to false otherwise?

a)

(overallGPA > 3.0) AND (scienceGPA > 3.2)

b)

(overallGPA > 3.0) AND (scienceGPA ≥ 3.2)

c)

(overallGPA ≥ 3.0) AND (scienceGPA > 3.2)

d)

(overallGPA ≥ 3.0) AND (scienceGPA ≥ 3.2)

80.

A programmer is creating an algorithm that will be used to turn on the motor to open the gate in a parking garage. The specifications for the algorithm are as follows.

The gate should not open when the time is outside of business hours.

The motor should not turn on unless the gate sensor is activated.

The motor should not turn on if the gate is already open.

Which of the following algorithms can be used to open the gate under the appropriate conditions?

a)

Check if the time is outside of business hours. If it is, check if the gate sensor is activated. If it is, check if the gate is closed. If it is, turn on the motor.

b)

Check if the time is during business hours. If it is, check if the gate sensor is activated. If it is, check if the gate is open. If it is, turn on the motor.

c)

Check if the time is during business hours. If it is, check if the gate sensor is activated. If it is not, check if the gate is open. If it is not, turn on the motor.

d)

Check if the time is during business hours. If it is, check if the gate sensor is activated. If it is, check if the gate is open. If it is not, turn on the motor.

81.

Three teams (Team A, Team B, and Team C) are participating in a trivia contest. Let scoreA represent the number of correct questions for Team A, scoreB represent the number of correct questions for Team B, and scoreC represent the number of correct questions for Team C. Assuming no two teams get the same number of correct questions, which of the following code segments correctly displays the team with the highest number of correct questions?

a)

b)

c)

d)

82.

Consider the following code segment.

If the value of score1 is 350 and the value of score2 is 210, what will be the value of result after the code segment is executed?

a)

3

b)

4

c)

5

d)

7

83.
Which unit is the smallest?
a)
Megabyte
b)
Kilobyte
c)
Gigabyte
d)
Terabyte
84.

Which unit is the largest?

a)

Megabyte

b)

Terabyte

c)

Gigabyte

d)

Kilobyte

85.

An artist makes an RGB raster image in which each pixel color is encoded with 12-bits --- 4 bits each for red, green and blue.Which of the following correctly shows the hexadecimal value for Red as a 12-bit representation.

a)

F00

b)

00F

c)

FF00

d)

FF0000

86.

Approximately how much bigger (how many more bytes) is a megabyte than a kilobyte?

a)

1,000 times bigger

b)

100,000 times bigger

c)

1,000,000 times bigger

d)

1,000,000,000 times bigger

87.

Approximately 1,000 ________ are equal to 1 terabyte (1 TB).

a)

jengabytes

b)

gigglebytes

c)

gigabytes

d)

megabytes

88.

Which of the following is a reason to use lossy compression?

a)

You want the compressed file to be larger than the original.

b)

You want the highest quality audio file possible, with no modifications.

c)

You want the highest quality image file possible, with no modifications.

d)

You want to save space and are not concerned if the file is the highest quality possible.

89.

a problem solving approach (algorithm) to find a satisfactory solution where finding an optimal or exact solution is impractical or impossible

a)

Lossless Compression

b)

Heuristic

c)

Lossy Compression

d)

encryption

90.

Which of the following is irreversible?

a)

lossy compression

b)

lossless compression

c)

abstraction

d)

RLI

91.

Which of the file types is an audiofile type?

a)

jpg

b)

mp3

c)

png

d)

csv

92.

An original file is 100 MB, it is compressed to 80 MB (including dictionary). What is its compression rate?

a)

90%

b)

80%

c)

20%

d)

100%

93.

Which of the following hexadecimal representations would represent dark green?

a)

#191399

b)

#00FF10

c)

#001313

d)

#001300

94.

How would you lighten the color #bcc8e1?

a)

+50 to each color component

b)

+50 to the red component

c)

-50 to each color component

d)

-50 to the red component

95.

How many bits are needed to represent 8 colors?

a)

8 bits

b)

24 bits

c)

1 hex digit

d)

3 bits

96.

How many bits are needed to represent a 3 x 3 black and white image (exclude metadata)

a)

3 bits

b)

6 bits

c)

9 bits

d)

9 x 24 bits

97.

The color widget uses 3 bytes of metadata. The first two bytes indicate the width and height of the image. The next byte indicates the number of bits that will be used to represent color. How many bits is used to represent color given the metadata (in binary) 00001000 00001000 0001001

a)

3 bits

b)

6 bits

c)

9 bits

d)

12 bits

98.

Which of the following statements is FALSE?

a)

The computer stores colors in hexadecimal

b)

Every color has 3 components. A red, green and a blue component.

c)

A bright color would be represented by a large number.

d)

A computer uses 3 bytes to store a single colored pixel.

99.

Lil’ Nibble, a local Soundcloud rapper, has recorded a new mixtape called “Half-a-byte,” produced by “Mibikibi and the Teraflops.” The mixtape has several audio files that have been compressed into a .ZIP file so they can be transferred easily and a separate .ZIP file containing album artwork and liner notes. If the mixtape .ZIP file takes up 800 MB and the artwork .ZIP file is 300 MB, what size flash drive do you need in order to transfer the files?

a)

512 MB

b)

1.0 GB

c)

4 KB

d)

2.0 GB

100.

Consider the following three binary numbers:

01010

010000

1110

Which of the following lists the numbers in order from least to greatest?

a)

010000

1110

01010


b)

01010

1110

010000


c)

01010

010000

1110


d)

1110

01010

010000


101.

The image is from Google Trends that plots Cats and Dogs.

Choose the most accurate description of what this data is actually showing based on what you know about how Google Trends works.

a)

People like dogs more than cats

b)

People search for "dogs" more frequently than "cats"

c)

There was a sharp increase in the dog population sometime between 2014 and 2015

d)

The popularity of dogs as pets is slightly increasing over time, while the popularity of cats is relatively flat

102.

What is metadata?

a)

Data that is about the data.

b)

Data that is everywhere.

c)

Data that can change.

d)

Data that needs filtered.

103.

Recognizing patterns and similarities in data visualizations relates to which of the following about the data?

a)

Causation

b)

Correlation

c)

Metadata

d)

Filtering

104.

Which of the following is NOT a benefit of metadata?

a)

It can be changed without impacting the primary data

b)

Used for sorting and filtering information

c)

Increases effective use of data by providing extra information

d)

Increases search speeds of the database

105.

Which of the following is NOT a reason for data to be cleaned?

a)

Data is incomplete

b)

Data is invalid

c)

Multiple tables are combined into one

d)

Data is a string

106.

What is the goal of the data analysis process?

a)

To search through databases quicker

b)

To gain insight into new information

c)

To make sure datasets are clean

d)

To collect the correct information

107.

The mayor of a city is interested in learning what goals are most important for residents of the city. Members of her staff visit one of the many neighborhoods in the city and ask 20 residents to fill out a survey. The mayor is concerned that the survey may be biased and not accurately reflect the overall interests in her town. Which of the following strategies is MOST likely to address concerns about the data being biased or inaccurate

a)

Finding the same people surveyed previously to ask more detailed questions.

b)

Visiting the same neighborhood to collect more survey responses

c)

Visiting multiple new neighborhoods to collect more survey responses

d)

Having her staff collect the data using an app rather than paper surveys

108.

In which of the following situations would parallel systems MOST likely be used to help analyze data?

a)

Data analysis involving two or more columns of data

b)

Data analysis involving both string and numeric data

c)

Data analysis involving large datasets

d)

Data analysis that could result in two or more different types of visualizations

109.

Which of the following conclusions is BEST supported by the histogram chart?

a)

More than half of all states are larger than 100,000 square miles

b)

More than half of all states are smaller than 50,000 square miles

c)

Some states are larger than 200,000 square miles

d)

The most common size of states is between 50,000 and 100,000 square miles

110.

A restaurant is interested in learning about the food preferences of people living nearby to the restaurant and intends to use survey data to help decide which new items to add to the menu. Which of the following is LEAST likely to be part of the process used to analyze the data?

a)

Cleaning a data visualization to remove unwanted patterns

b)

Iteratively creating visualizations to ask and answer new questions

c)

Cleaning data to remove inconsistencies

d)

Filtering the data to look at the responses from only certain groups

111.

A town decides to publicize data it has collected about electricity usage around the city. The data is freely available for all to use and analyze in the hopes that it is possible to identify more efficient energy usage strategies.

Which of the following does this situation best demonstrate?

a)

Citizen science

b)

Crowdfunding

c)

Open data

d)

Machine Learning

112.

A series of algorithms that endeavors to recognize underlying relationships in a set of data through a process that mimics the way the human brain operates.

a)

Data Training

b)

Neural Networks

c)

Algorithmic Modeling

d)

Citizen Science

113.

Which of the following works best when you want to visualize one column with few values?

a)

Histograms

b)

Scatter Plot

c)

Bar Charts

d)

Crosstab

114.

Which of the following works best when you want to visualize multiple columns with many values?

a)

Histograms

b)

Scatter Plot

c)

Bar Charts

d)

Crosstab

115.

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)

A computer program cannot combine data from different files.

b)

Different counties may organize data in different ways.

c)

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

d)

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

116.

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?

a)

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

b)

The car’s average speed on a particular day

c)

The distance the car traveled on a particular day

d)

The number of bicycles the car passed on a particular day

117.

Which of the following applications is most likely to benefit from the use of crowdsourcing?

a)

An application that allows users to convert measurement units (e.g., inches to centimeters, ounces to liters)

b)

An application that allows users to purchase tickets for a local museum

c)

An application that allows users to compress the pictures on their devices to optimize storage space

d)

An application that allows users to view descriptions and photographs of local landmarks

118.

A mobile application is used to display local traffic conditions. Which of the following features of the application best exemplifies the use of crowdsourcing?

a)

Users can save an address to be used at a later time.

b)

Users can turn on alerts to be notified about traffic accidents.

c)

Users can submit updates on local traffic conditions in real time.

d)

Users can use the application to avoid heavily congested areas.

119.

Research where some of the data collection is done by members of the public using own computing devices which leads to solving scientific problems

a)

Open Data

b)

Crowd Sourcing

c)

Citizen Science

d)

Big Data

120.

Data that is publicly available and shared by governments, organizations, and others.

a)

Crowd Sourcing

b)

Citizen Science

c)

Open Data

d)

Big Data

121.

Cloud computing or parallel systems are sometimes used to help process this type of data.

a)

Open Data

b)

Big Data

c)

Crowd Sourcing

d)

Citizen Science

122.

Reorder the following

a)

Ask Questions

b)

Collect Choose Data

c)

Clean Filter Data

d)

Visualize Data

e)

Generate New information

1)
2)
3)
4)
5)
123.

A new or improved idea, device, product, etc, or the development thereof.

a)

Innovation

b)

Technology

c)

Improvement

d)

Protocol

124.

A way of representing information using only two options.

a)

BInary

b)

Doubled

c)

Algorithm

d)

Hexadecimal

125.

A contraction of "Binary Digit"; the single unit of information in a computer, typically represented as a 0 or 1

a)

Bit

b)

Character

c)

BInar

d)

BiDig

126.

Transmission capacity measure by bit rate

a)

Brandwidth

b)

Latency

c)

Bit Length

d)

Transmission Rate

127.

The number of bits that are conveyed or processed per unit of time. e.g. 8 bits/sec.

a)

Bit Rate

b)

Bit Speed

c)

Latency

d)

BPS

128.

Time it takes for a bit to travel from its sender to its receiver.

a)

Latency

b)

Bit Rate

c)

Bit Speed

d)

BPS

129.

A set of rules governing the exchange or transmission of data between devices.

a)

Protocol

b)

Guideline

c)

Packet

d)

Command

130.

American Standard Code for Information Interchange; the universally recognized raw text

a)

ASCII

b)

USACII

c)

QWERTY

d)

IETF

131.

Instructions for a computer.

a)

Code

b)

Comand

c)

Protocol

d)

Direction

132.

Internet Engineering Task Force - develops and promotes voluntary Internet standards

a)

IETF

b)

IT

c)

MIT

d)

Net Neutrality

133.

A group of computers and servers that are connected to each other.

a)

Internet

b)

Google

c)

Packets

d)

Online Network

134.

The principle that all Internet traffic should be treated equally by Internet Service Providers.

a)

Net Neutrality

b)

Network Redundancy

c)

Internet Equality

d)

Online Protocol

135.

A number assigned to any item that is connected to the Internet.

a)

IP Adress

b)

Network Coefficient

c)

Online Password

d)

Router Code

136.

Small chunks of information that have been carefully formed from larger chunks of information.

a)

Packets

b)

Clusters

c)

Superunits

d)

Subunits

137.

Having multiple backups to ensure reliability during cases of high usage

a)

Network Redundancy

b)

Net Neutrality

c)

Internet Support

d)

Online Backup

138.

A type of computer that forwards data across a network

a)

Router

b)

WiFi Station

c)

Interlocutor

d)

Reciever

139.

Provides reliable, ordered, and error-checked delivery of a stream of packets on the internet.

a)

TCP

b)

DNS

c)

IP

d)

URL

140.

The service that translates URLs to IP addresses.

a)

DNS

b)

TCP

c)

HTTP

d)

TCP/IP

141.

The protocol used for transmitting web pages over the Internet

a)

HTTP

b)

DNS

c)

URL

d)

IP Adress

142.

A number assigned to any item that is connected to the Internet.

a)

IP Adress

b)

URL

c)

Link

d)

HTTP

143.
What does Protocol mean?
a)
Security
b)
Rules
c)
Orders
d)
Services
144.
Which of these is NOT part of the TCP header?
a)
Packet Number
b)
Sender IP Address
c)
Size of Packet
d)
Name of File
145.
This is used to resolve host names to IP addresses
a)
IP address
b)
subnet mask
c)
default gateway
d)
DNS server
146.
How many bits are in an IPV6 address?
a)
32
b)
64
c)
128
d)
256
147.
The HTTP protocol: 
a)
The GET request results in all of the page data being displayed. 
b)
Data sent by the server is sent in one file, broken up into various packets.
c)
Data sent by the server is sent in several files broken up into packets.  
d)
Data sent by the server arrives at the client in the order it is sent. 
148.

An Internet attack that causes a server to crash by making repeated requests to the same IP address:

a)

DDoS (Distributed Denial of Service)

b)

Cache Poisoning

c)

DNS (Domain Name System) Hijacking

d)

Phishing

149.

Internet Protocol

a)

Protocol that breaks data down into packets and addresses them with source and destination information

b)

A DNS attack in which numerous pings are made to the same IP, causing it to crash

c)

Protocol used by the World Wide Web. It describes how messages are formatted and interchanged, and how web servers respond to commands.

d)

Protocol that provides reliable, ordered, and error-checked delivery of a stream of packets on the internet

150.
Tranmission Control Protocol:
a)
Breaks messages into packets and addresses them
b)
A DNS attack in which numerous pings are made to the same IP, causing it to crash
c)
Protocol used by the World Wide Web. It describes how messages are formatted and interchanged, and how web servers respond to commands.
d)
Provides reliable, ordered, and error-checked delivery of a stream of packets on the internet
151.
The world is currently in a transition to using IPv6, a newer version of the IP protocol that uses 128-bit addresses instead of 32-bit addresses used by IPv4. What is the main problem that IPv6 was created to solve?
a)
IPv6 will allow problems with IPv4's address hierarchy to be resolved
b)
32-bit addresses could not ensure that every internet-connected device can receive a unique IP address
c)
32-bit addresses could not accommodate the increased size and amount of data traveling on the Internet as it has grown in popularity
d)
IPv4 proved unreliable in some cases where network redundancy could not be ensured
152.
Given the following network diagram, what is the minimum number of connections that must be broken or removed before computer E can no longer communicate with computer B?
a)
1
b)
2
c)
3
d)
4
153.
Andrew uses an application to track HOW LONG it takes a packet to travel from his computer to a Wikipedia server. Which of the following is he measuring?
a)
Bandwidth
b)
Latency
c)
Number of packets
d)
Router sp
154.
A ____ HTTP request is used when the user requests information, but does not enter anything into the page.
a)
Get
b)
Post
c)
Send
d)
Fetch
155.

A _____ HTTP request is used when the user enters information (ex. user name/password) into the webpage.

a)

Get

b)

Post

c)

Login

d)

Send

156.
Which of the following best describes the basic idea of fault tolerance?
a)
A system that never fails
b)
If part of the system fails, the operation continues without interruption
c)
A program that does not allow inputs out of a range given by a programmer
d)
A program that does not allow loss of precision
157.
This is used to resolve host names to IP addresses
a)
IP address
b)
subnet mask
c)
default gateway
d)
DNS server
158.

A number assigned to any item that is connected to the Internet.

a)

IP Adress

b)

Network Coefficient

c)

Online Password

d)

Router Code

159.

Small chunks of information that have been carefully formed from larger chunks of information.

a)

Packets

b)

Clusters

c)

Superunits

d)

Subunits

160.

Having multiple backups to ensure reliability during cases of high usage

a)

Network Redundancy

b)

Net Neutrality

c)

Internet Support

d)

Online Backup

161.

A type of computer that forwards data across a network

a)

Router

b)

WiFi Station

c)

Interlocutor

d)

Reciever

162.

The service that translates URLs to IP addresses.

a)

DNS

b)

TCP

c)

HTTP

d)

TCP/IP

163.

Bandwidth

a)

Time it takes for a bit to travel from its sender to its receiver.

b)

Transmission capacity measure by bit rate

c)

American Standard Code for Information Interchange; the universally recognized raw text format that any computer can understand

d)

The number of bits that are conveyed or processed per unit of time. e.g. 8 bits/sec.

164.

What will the following algorithm display?
\leftarrow   13
\leftarrow   17
\leftarrow   a + 1
\leftarrow   a/7
DISPLAY(c)
DISPLAY(a)
DISPLAY(b)

a)

2, 14, 17

b)

13, 17, 5

c)

2, 12, 2

d)

14, 17, 2

165.

What will the following algorithm display?

a ← 13

a ← 17

a ← a+1

DISPLAY(a)

a)

13

b)

17

c)

18

d)

19

166.

What will the following algorithm display?

a ← 11

a ← a + 35

a ← a + 6

a ← a MOD 2

a ← a x b

DISPLAY (a)

a)

0

b)

42

c)

84

d)

126

167.

Extra Credit: Before deciding on a Hedgehog, Sega originally planned to make Sonic a...

a)

rabbit

b)

goose

c)

cat

d)

dinosaur

168.

What will the following display?

a ← "Milk"

a ← "Cookies Soda"

a ← "Chips"

b ← a + "put them in a bag so they stay crisp"

a)

Milk

b)

Milk Cookies Soda

c)

Put them in a bag so they crisp

d)

Milk Cookies Soda Chips put them in a bag so they stay crisp

169.

What is the value displayed after the program is run?
\leftarrow  8
\leftarrow  3
\leftarrow  2
\leftarrow  b * c
\leftarrow  c+4
display "a"
display (c)

a)

a  8

b)

a  6

c)

8  6

d)

16  4

170.

 What is the value displayed after the program is run?
\leftarrow  8
\leftarrow  3
\leftarrow  2
\leftarrow  b*c
\leftarrow   c+4
DISPLAY("a")
DISPLAY("c")

a)

a  8

b)

a  c

c)

8  6

d)

16  4

171.

What will the following algorithm display?
\leftarrow  26 MOD 2

a)

26

b)

13

c)

0

d)

1

172.

What will the following algorithm display?
\leftarrow  5 MOD 2
DISPLAY (a)

a)

26

b)

13

c)

0

d)

1

173.

What will the following algorithm display?
a \leftarrow  8 MOD 26
display(a)

a)

26

b)

13

c)

8

d)

1

174.

Extra Credit: Before deciding on the name "Sonic", the original name of the character was

a)

Speedy

b)

Mach

c)

Mr. Needlemouse

d)

Gus

175.

What will the following algorithm display?

a ← 13 MOD 26

display(a)

a)

26

b)

13

c)

8

d)

0

176.

What will the following algorithm display?

a ←26 MOD 13

display(a)

a)

26

b)

13

c)

8

d)

0

177.

What will the following algorithm display?

a ←26 MOD 3

b ←7 MOD a

display (b)

a)

26

b)

13

c)

0

d)

1

178.

What will the following algorithm display?

a ←2 MOD 3

b ←7 MOD a

display (b)

a)

26

b)

13

c)

0

d)

1

179.

What will the following segment display?

a ← 13

b ← 5

temp ← a

a ← b

b ← temp

display (a)

display (b)

a)

13 5

b)

5 13

c)

a b

d)

13 13

180.

What is the percentage that this algorithm displays true?

Display(RANDOM(1, 10) = 6)

a)

9

b)

10

c)

60

d)

100

181.

What is the percentage that this algorithm displays true?

DISPLAY(random(5,9) = 6)

a)

10

b)

20

c)

60

d)

100

182.

Extra Credit: Sonic's footwear was inspired by...

a)

Michael Jordan

b)

Michael Jackson

c)

Mickey Mouse

d)

Wreck-it-Ralph

183.

What is the percentage that this algorithm displays true?

DISPLAY (RANDOM(5,9) = 4)

a)

0

b)

20

c)

60

d)

100

184.

What is the percentage that this algorithm displays true?
DISPLAY(RANDOM(5,9) \le   9)

a)

0

b)

20

c)

60

d)

100

185.

What is the percentage that this algorithm displays true?

DISPLAY(RANDOM(5,9)>9)

a)

0

b)

20

c)

60

d)

100

186.

What is the percentage that this algorithm displays true?

DISPLAY(RANDOM(1, 10) ≤6

a)

9

b)

10

c)

60

d)

100

187.

Assume that the two variables age and day have been initialized with the values shown.

var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.

(age > 10) && (age < 20)

a)

true

b)

false

188.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


!(age > 10)

a)

true

b)

false

189.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


(day == "Tuesday") || (age < 12)

a)

true

b)

false

190.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


!((age == 16) || (day == "Monday"))

a)

true

b)

false

191.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


!((age == 16) && !(day == "Monday"))

a)

true

b)

false

192.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


((age == 16) && (day == "Monday")) && (day == "Tuesday")

a)

true

b)

false

193.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


((age == 16) && (day == "Monday")) || (day == "Tuesday")

a)

true

b)

false

194.

Assume that the two variables age and day have been initialized as shown below.


var age = 16;

var day = "Monday";


Determine if the following statement evaluates to true or false.


((age > 10) && ((age + 5) > 20))

a)

true

b)

false