LIS506A – Introduction to Information Technology, Final Exam, Spring 2011
Full Name (Print): ___Samantha Simoes________________________
Instructions
You have 140 minutes to complete this exam. Time will begin after we have read through it together.
You may use your own personal copy of the text book along with any notes or other files that
you have brought with you and anything that you find on the Internet.
You may use any program on the computer in front of you, and you may use a calculator if you
brought one.
You may NOT communicate with any other person (except the professor) during this exam,
either in person or using an electronic means.
Please write your answers in the space provided directly after each question.
Do not discuss this exam with anyone until specific permission is given by the professor or the
answers are posted on the class Web page. Questions on this exam may be used in other sections,
and discussing them in any forum where the discussion might be overheard by a person who has
not yet taken the exam would constitute academic dishonesty.
As strategies for completing the exam, keep the following in mind:
If you find a question to be ambiguous, you may ask about it privately by coming to the front of
the room. If the confusion is not resolved to your satisfaction, please explain your confusion
along with your answer so that we can consider it during grading.
Read the questions carefully and focus your answers on what’s being asked.
Be careful not to get carried away and run over the time limit by spending too much time on one
question. Plan ahead, and don’t devote more time to a question than it is worth.
Score Summary (for use by graders. Do NOT write anything below)
Question Possible points Actual points
1 60
2 10
3 15
4 15
TOTAL 100
1. (60 points, 3 points each) Multiple choice questions. For each question, please circle one
best answer. Circling more than one answer for a question receives 0 point. Circling a
wrong answer for a question receives 0 point.
1) All of the following are components of van Neumann architecture EXCEPT __A__.
A. Cache
B. memory
C. ALU
D. control unit
2) Which of the following statement is true about microphones and webcams? ___A_
A. Microphones are input devices, but webcams are output devices.
B. Microphones are output devices, but webcams are input devices.
C. Both are input devices.
D. Both are output devices.
3) Which of the following is true about storage hierarchy? __A__
A. It describes the relationship between the speed and the storage capacity among
the processor, the memory, and the hard disk in a computer.
B. It describes how some files are stored in parent folders while others are stored in
child folders.
C. It states the fastest devices are also usually the largest devices.
D. It explains server hard disks are much larger than client hard disks..
4) All of the following are system software EXCEPT __C__.
A. Symantec Endpoint Protection
B. Microsoft Windows 7
C. Disk defragmenter
D. Microsoft BPOS
5) The Internet standard that specifies how to locate a web page is __D__.
A. FTP
B. HTML
C. DNS
D. HTTP
6) In an IP address, the number in each group is between ____A_.
A. 0 and 255
B. 256 and 512
C. 513 and 1024
D. approximately 16 million
7) All of the following are communications devices EXCEPT __D__.
A. Router
B. NIC adapter
C. broadband modem
D. USB flash drive
8) What decimal value does the second “1” from the right side in binary number “10010001”
contribute to the conversion of the binary number into a decimal number? __D_
A. 2
B. 8
C. 16
D. 32
9) Which of the following statement is true? ___A_
A. JPEG uses lossless compression
B. Clip arts are usually saved in GIF format
C. TIFF format is rarely used for archiving images in digital libraries
D. PNG format is supported by all Web browsers
10) Which of the following is true about Javascript? __C
A. It is a special case of Java programming language.
B. It is a compiled programming language.
C. It is usually embedded in HTML Web pages.
D. It runs on the server side.
11) What will be the value of y after the follow part of JavaScript is executed? __D_
var x, y;
x = 2;
y = 3;
x = x - y;
y = x * x * y;
A. 0
B. 3
C. 9
D. 12
12) Which of the following uses database-generated Web pages? __D__
A. Purchasing books from Amazon.com
B. Booking flights through orbitz.com
C. Finding books using ublib.buffalo.edu
D. All of the above
13) Google Suggest uses ___A_.
A. AJAX
B. Mashup
C. RSS
D. Google Maps
14) To create metadata using Dublin Core Element Set for a copy of Week 11’s lecture
slides file that you downloaded from UBLearns to your computer, what should be the
value of creator element? __A__
A. Your name
B. Jianqiang Wang
C. DLIS
D. Microsoft
15) Which of the following is true about Web search engines? ___A_
A. They use web crawlers to find and download Web pages
B. One powerful computer is usually enough for handling all the queries
C. Normally only 5 to 10 factors are considered for ranking Web pages
D. The Web page index is refreshed about once per two years
16) Which of the following statement is NOT true? ___C_
A. XML is not intended to replace HTML
B. People can define their own XML tags when creating XML documents
C. No elements in an XML document should share the same tag
D. XML is a markup language
17) Examples of digital libraries include __A
A. UB library’s Online Public Access Catalog (OPAC)
B. Digital collections managed by UBDigit
C. GSE Website
D. all of the above
18) When you pay your credit card online using asymmetric data encryption method,
which key is used to encrypt your payment? D
A. Your credit card company’s secret
B. Your credit card company’s public key
C. Your secret key
D. Your public key
19) All of the following are example methods of safeguarding against unauthorized
access to and use of computer systems EXCEPT __C__.
A. UBIT’s acceptance use policies
B. UBITname/password login
C. Anonymity
D. UB ID card swiping at the door of 14 Baldy lab
20) Which of the following is NOT true about the “rapid prototyping” model? __D__
A. It usually starts with an incomplete list of system functions.
B. It is iterative in nature.
C. It can be used in combination with other system design models.
D. A prototype must be built using the same tool that is also used to build the
actual system.
2. (10 points) Taking searching the textbook used in this course on Amazon.com as an
example,
1) (5 points) give an example of a mental model used in the process.
Hands and sight to text and image (visual)
2) (5 points) give an example of a software model used in the process.
Keyboard, mouse to display to task
3. (15 points) “Bag of words” approach is commonly used in representing queries and
documents in information retrieval.
1) (10 points) Create a “bag of words” representation table for the following three
documents (note: ignore letter cases, the plural/singular forms of nouns, and the
tenses of verbs):
D1: Professor Soergel teaches information organization in LIS.
D2: Assistant Professor Valerie Nesset’s research focuses on information
seeking behaviors and knowledge organization.
D3: Dr. Brenda Battleson is a new faculty member in the Department of
Library and Information Studies.
2) soergel 3) professor 4) valerie 5) teaches
6) battleson 7) informatio 8) on knowledge
n
9) research 10) nesset 11) in organization
12) is 13) behavior 14) seeking 15) in
16) focuses 17) library 18) organizatio 19) informatio
n n
20) new 21) studies 22) department 23) and
24) informatio 25) lis 26) faculty 27) the
n
28) assistant 29) member 30) professor
31) (5 points) Based on the document representation you created above, list the
document(s) that will be retrieved for each of the following two Boolean queries:
Q1: “professor AND LIS”
Q2: “(knowledge OR information) AND organization”
Term or and not and/not
Professor 1 0 0 0
knowledge 0 1 0 0
information 1 0 1 0
organization 0 0 1 0
Lis 0 1 0 1
(15 points) Design a LIS Advisement database that can be used to answer at least the
following queries:
A. Find out the name and the contact information of John Smith’s advisor.
B. List all students (names and email addresses) that Dr. Peterson currently advises.
C. Find out when Dr. Meloche was assigned to Peter Brown as his advisor.
In your answer,
1) (10 points) list the tables and the fields in each table that you think should be
included in your design, and specify the primary key of each table. You do not
need to create any actual records;
2) (5 points) describe briefly which table(s) will be used to answer each of the above
three queries. You do not need to construct the actual queries.
Your design will be graded based on not only whether it can correctly answer the above
queries (and similar queries), but also whether it reduces data redundancy to a reasonably
low level.
Student Table
Student ID Advisor Student Year admitted
1 Dr. Meloche Peter Brown May 2011
2 Dr. Peterson Kelly Reeves January 2010
3 Dr. Peterson Courtney Buriston May 2010
4 Dr. Peterson Sam Simoes September 2010
5 Dr. Meloche John Smith May 2011
Advisor Email Student id
Dr.Peterson kreeves@buffalo.edu 2
Dr.Peterson Cb232@buffalo.edu 3
Dr. Peterson ssimoes@buffalo.edu 4