Comp 101

Question 1

How many numbers are in an IP address?

Answer 1

4 numbers separated by a dot (.)

Question 2

What can the individual numbers in an IP address range to?

Answer 2

0-255

Question 3

What does the IP in IP address stand for?

Answer 3

Internet Protocol

Question 4

How many bytes in an IPv4 address?

Answer 4

32 bytes

Question 5

How many bytes in an IPv6 address?

Answer 5

128 bytes

Question 6

How many bits in 8 bytes?

Answer 6

64 bits

Question 7

What is a computer that provides a service or has something to share over the internet?

Answer 7

server

Question 8

What is a computer that consumes a service over the internet

Answer 8

client

Question 9

What does WAN stand for?

Answer 9

Wide Area Network

Question 10

What does LAN stand for

Answer 10

Local Area Network

Question 11

What kind of network is the internet

Answer 11

WAN

Question 12

What Does DNS stand for and what does it do?

Answer 12

Domain Name Service. Translates numbers to names.

Question 13

What is batch processing?

Answer 13

When a computer only works on one task at a time

Question 14

When a computer is shared between multiple users what is it called?

Answer 14

Timesharing - using one computers processing power and sharing it with others

Question 15

Who funded the ARPAnet?

Answer 15

DARPA - Defense Advanced Research Project Agency

Question 16

What is the purpose of the ARPAnet?

Answer 16

To create a large network of computers to accelerate knowledge transfer and reduce the redundant re-researching of subjects by making everything available online.

Question 17

What does IMP stand for?

Answer 17

Interface Message Processor - Acted as a gateway and interface to the mainframe, It controlled network activities to allow the processing of program and data files

Question 18

What Does HTTP stand for and what does it do?

Answer 18

HyperText transfer protocol

Question 19

What is a host name?

Answer 19

A host name is a IP address converted into words so humans can memorize it easier. It is done by the DNS

Question 20

What does URL stand for and what does it do?

Answer 20

Uniform Resource Locator - Is a pathway for websites to be found

Question 21

What does HTTP stand for and what does it do?

Answer 21

Hyper Text Transfer Protocol - Method of sending files between computers through a network

Question 22

What does FTP stand for and what does it do?

Answer 22

File transfer protocol - transfers files securely between computers on a network by asking the user to login

Question 23

what does RAM stand for and what does it do?

Answer 23

Random access memory - Temporary memory used for running programs

Question 24

What does the HTML code rowspan do?

Answer 24

makes the cell vertically taller

Question 25

What does the HTML code colspan do?

Answer 25

makes the cell horizontally wider

Question 26

How do you make an un ordered list in HTML? How about an ordered list?

Answer 26

ordered list |

Question 27

How do you insert an image in html?

Answer 27

Question 28

What does putting a search term in "quotations" do?

Answer 28

It makes it so that any phrase in quotations will be searched as a phrase instead of individual words

Question 29

What is a computer network?

Answer 29

2 or more computers connected together for the purpose of sharing resources and communicating

Question 30

What does MAN stand for and what is its purpose?

Answer 30

Metropolitan Area Network - connects computer resources in a local geographical area

Question 31

What is a web server

Answer 31

When you click a link you enter a relationship with the web server

Question 32

give an example of server software

Answer 32

Apache

Question 33

give an example of client software

Answer 33

Web browser, FTP program

Question 34

What does TCP stand for and what does it do?

Answer 34

Transmition control protocol - defines how message are broken down and re assembled

Question 35

What does IP stand for and what does it do?

Answer 35

Internet Protocol - Defines Where the (which address) the packets are sent to

Question 36

What does a not gate do?

Answer 36

reverses input

Question 37

Is the NOT gate unary?

Answer 37

Yes, because it only accepts one input

Question 38

What does the AND gate do?

Answer 38

Takes 2 inputs and one output. The output will be true only if BOTH the inputs are true. ex 0/1 = 0, 1/1 = 1

Question 39

What does a OR gate do?

Answer 39

takes 2 inputs and provides one output. The output is true if ANY one of the inputs is true. ex. 0/1 = 1, 0/0 = 0, 1/1 = 1

Question 40

Name the following gates: |> >) D

Answer 40

``` |> = NOT >) = OR D = AND ```

Question 41

build a half adder

Answer 41

0-|=>)-----------| | |=D---------1 1-|=D---|---|>---| |______________0

Question 42

what is the IF function in Excel?

Answer 42

The IF function performs a logical test and and delivers an output if true and an output if not true

Question 43

what is the format for the IF function?

Answer 43

=IF(Logical_test,Value_If_True,Value_If_False)

Question 44

What does the Vlookup function in Excel do?

Answer 44

Vlookup searches for a value in a selected grid, if it finds the value it returns a selected value

Question 45

What is the format for the Vlookup Function?

Answer 45

=Vlookup(Lookup_Value,Table_Array,Return_Value,Range)

Question 46

In excel, how would you count all the values in a column greater than 5?

Answer 46

=CountIF(A1:A3,">5")

Question 47

In HTML what does the

tags indicate?

Answer 47

the start and end of a paragraph

Question 48

What does tags indicate?

Answer 48

Tags will make the text in between bold.

Question 49

What do tags indicate?

Answer 49

text in between tags is in Italics

Question 50

what does the

---

tag do?

Answer 50

The tag produces a line from left to right across the page

Question 51

what do

tags do?

Answer 51

tags produce an ordered list

Question 52

what do

tags do?

Answer 52

tags produce an un-ordered list

Question 53

what do

tags do?

Answer 53

tags are the items in a list.

Question 54

how do you put a link in a web page? use google.ca as an example

Answer 54

Google

Question 55

How do you put an image in a web page? use an image called pic.jpg and assume that it is accesible to the website. Change name for the picture that the web user will see.

Answer 55

Question 56

How would you change the body of a webpage's background colour?

Question 57

How would you change the font color on a webpage?

Question 58

what does the

tag do?

Answer 58

This tag creates a heading. the heading is bigger or smaller depending on the the number following the H. The smaller the number the bigger the heading.

Question 59

how would you make all

tags have red font?

Answer 59

h2 {color : red}

Question 60

In Alice what does the properties tab do?

Answer 60

The properties tab lets you change the physical features of an object, make it opaque

Question 61

converting numbers from binary to regular what should you make, hmm Christopher?

Answer 61

a power chart of 2 so i dont make mistakes

Question 62

When using VLOOKUP, for the column return section, how would you input to the get the value from the column one over? what about 3 over?

Answer 62

1 would return the cell in the column next to the desired cell and 3 would return the cell 3 columns over from the desired cell

Question 63

How does CountIf work?

Answer 63

has the format COUNTIF(range, criteria) | COUNTIF counts the number of cells that satisfy the criteria

Question 64

What is an XOR Gate? What is its truth table?

Answer 64

``` An XOR gate is only true if the only ONE of the inputs is true 0 0 = 0 1 0 = 1 0 1 = 1 1 1 = 0 ```