CSCI003 FINAL EXAM SPRING 2015
NAMES IN FULL ______
This Exam has two parts: Part A is Multiple Choice, Part B is short answers (No more than 2 paragraphs, no more than 5 sentences in each paragraph). Open a WORD document and answer all the questions in it. Save the WORD file and email it to me at This Exam must be completed by the time shown on the board.
DO NOT FORGET TO PUT THE FOLLOWING IN YOUR EMAIL
Subject Header: CSCI1003, LastName,FirstName, FINAL EXAM FALL 2015
PART A: INSTRUCTIONS Q1-Q20 (40 points)
Bold the correct answer in Red.
Q1 The Internet is
(a)A computer
(b)A local area network
(c)A switch
(d)A Network of computer networks
Q2. One Exabyte is
(a)One million bytes
(b)One Billion bytes
(c)One thousand bytes
(d)One Quintillion bytes
Q3. TCP/IP stands for
(a)Trailer Control/Interim Protocol
(b)Transmission Control Program/Internet Protocol
(c)Test Control Program/Intermediate Packet
(d) None of the above
Q4 Which of the following is not a TCP/IP Protocol
(a)FTP
(b)TELNET
(c)HTTP
(d)CCCP
Q5. A Router is a
(a)Packet routing and addressing device
(b) A vehicle for changing directions
(c)A terminal
(d)None of the above
Q6. URL stands for
(a)United Realtors Limited
(b)Universal Resource Locator
(c)Unlimited Relay Latency
(d)Ultra Resistant Laser
Q7. A web Server is
(a)A client program
(b)A machine which hosts networked application on the web
(c)An internet explorer browser
(d)A Netscape browser
Q8. The HTML tag for underline is
(a)<b> .. </b>
(b)<ul …..</ul>
(c)<u> ……</u>
(d)None of the above
Q9. A Frame tag has the following structure
(a)<iframe ……<done>
(b)<iframe …….</iframe>
(c)<iframe …….>
(d)None of the above
10. A Table row tag is described by
(a)< ts> …..</ts>
(b)< tr>………</tr>
© <trow ……>
(d)<ti> ……..</ti>
Q11 Application Software is installed in the
(a)CPU memory of a computer
(b)Secondary memory of a computer
(c)Read Only memory of a computer
(d)Direct memory Access of a computer.
Q12. Which of the following is true
(a)Power point is a database application.
(b)Power point is a spreadsheet application
(c)Power point is a presentation software
(d)Power point is an Apple Application.
Q13. Which of the following is not a function of the operating system
(a)File Management
(b)Process Scheduling
(c)Concurrency control
(d) Packet switching
Q14. Firmware is
(a)The outermost layer of an Operating System
(b)The innermost layer of an operating system
(c)The layer between the hardware and the graphical user interface operating system
(d)A place where a dog lives.
Q15. Console commands are
(a)Single click instructions
(b)Command line instructions
(c)Double click instructions
(d)Right mouse button click instructions
Q16. And EXCEL Application can be used with MAILMERGE in WORD to generate automated letters for several names.
(a)True
(b)False
(c)Absolutely
(d)Not sure
Q17. The CPU consists of the following:
(a)Network card, Ethernet cable and router
(b)Logic Unit, Control Unit and Memory Unit
(c)Transmission Cable and wires
(d)All of the above.
Q18. Application Software is the same thing as the Operating System
(a)False
(b)True
(c)Not sure
(d)All of the above
Q19. LAN stands for
(a)Large Areal Node
(b)Local Area Network
(c)Logistic Analysis Numbers
(d)Logic Analysis Node
Q20. WAN stands for
(a)Weekly Annotated Nodes
(b)Wireless Access Nodes
(c)Wide Area Network
(d)Worst Application Network
PART B: INSTRUCTIONS SHORT ANSWER QUESTIONS (60 points)
Answer all questions in the space provided. (Be brief)
Q1b Briefly describe the following: web server, web client, and domain.
Q2b Briefly describe a worm
Q3b. What is a Trojan Horse?
Q4b. What is the purpose of a firewall?
Q5b. Name two Antivirus software products.
Q6b. In this question use the EXCEL .
In column E, you have the average result for each students for an exam. In column F, write a function which returns if students Pass or Fail if the average mark is greater or equal than 10.
Table 1Student / Course 1 / Course 2 / Course 3 / Average / Result
Luc / 8 / 15 / 9 / 10.67 / Fill your formula here
Estelle / 4 / 15 / 16 / 11.67
Laurent / 11 / 6 / 8 / 8.33
Paul / 17 / 16 / 3 / 12
Léa / 17 / 18 / 10 / 15
Murielle / 6 / 5 / 13 / 8
Thierry / 18 / 19 / 15 / 17.33
Q7b In this question use EXCEL
Change your function to display
- Fail (when the average is below 10)
- Pass (when the average is between 10 and 12)
- Good (when the average is between 12 and 14)
- Very Good (when the average is between 14 and 16)
- Excellent (when the average is beyond 16)
Student / Course 1 / Course 2 / Course 3 / Average / Result / Result expected
Luc / 8 / 15 / 9 / 10.67 / Fill your formula here / Pass
Estelle / 4 / 15 / 16 / 11.67 / Pass
Laurent / 11 / 6 / 8 / 8.33 / Fail
Paul / 17 / 16 / 3 / 12 / Good
Léa / 17 / 18 / 10 / 15 / Very Good
Murielle / 6 / 5 / 13 / 8 / Fail
Thierry / 18 / 19 / 15 / 17.33 / Excellent
Q8b. Use EXCEL to plot a bar
DAY / Mon / Tues / Wed / Thurs / Fri / Sat / SunRainfall in Inches / 13 / 2 / 14 / 5 / 17 / 8 / 16
Graph of rainfall in Albany in the last week by day as shown
Q9b. Plot a Pie chat for Q8 showing the rainfall by percentage.
Q10b. supposing the data for this week was included as follows: Which week had more rainfall? Hint: Calculate the average.
DAY / Mon / Tues / Wed / Thurs / Fri / Sat / SunRainfall in Inches (Last Week) / 13 / 2 / 14 / 5 / 17 / 8 / 16
Rainfall (This Week) / 10 / 3 / 13 / 4 / 18 / 15 / 12