IT 111 Introduction to Information and Communication Technology Past Paper PDF (The University of Dodoma)

THE UNIVERSITY OF DODOMA COLLEGE OF EDUCATION DEPARTMENT OF EDUCATIONAL PSYCHOLOGY AND CURRICULUM STUDIES IT 111: Introduction to Information and communication technology End of Semester I University Examination for Undergraduate...

THE UNIVERSITY OF DODOMA COLLEGE OF EDUCATION DEPARTMENT OF EDUCATIONAL PSYCHOLOGY AND CURRICULUM STUDIES IT 111: Introduction to Information and communication technology End of Semester I University Examination for Undergraduate Students February, 2020 Duration: 08:00 – 10:00 Instructions 1. This is a 2-Hours examination consisting of two (2) sections, namely A and B. 2. The examination weights a total of 60 marks. 3. Answer all questions in both sections in the answer booklet provided. 4. Write your registration number in the space provided on every page of the answer booklet. 5. Do not write anything on the question paper and insert it in your booklet upon submission. Page 1 of 9  SECTION A Multiple choice, matching items and short answers Multiple Choice questions 1. Choose the most correct answer(s) and write its letter(s) against the question number [7.5 Marks @ 0.5] i. What is Computer Hardware? A) Electronic device that input data, processes these data and gives the output. B) Physical parts, which you can see and touch C) Is machine that control set of instruction takes data process and output D) All of above are true ii. What is the difference between firmware and application software? A) Firmware are programmed on hardware while application software is Operating System. B) Firmware is the part of hardware while application software is part of OS. C) Firmware are programmed on Hardware while application software are user software D) Firmware and software are both application software. iii. What is the application of Network interface card (NIC)? A) Assigns the Internet protocol address to a device. B) Assigns a unique Media Access Control C) Connect network devices one another D) Transmit signal from one computer to shared resources iv. Every computer network must include: A) At most two computers B) At least two computing devices C) At most one computer D) Only computers v. Password, Fingerprint and User IDs are: A) Authentication mechanisms B) Backup mechanisms C) Anti spyware protection tools D) types of Virus Page 2 of 9 vi. Example of type of printer A) Dot Matrix B) Daisy Wheel C) Microprocessor D) Hertz vii. What is the main improvement in the third generation computer? A) They used electronic valves for CPU B) They used transistor for CPU C) They used ICs known as Chips for CPU D) They used Microprocessor (VLSI) for CPU viii. What are the basic elements of an electronic communication system as organized in the correct order? A) Transmitter, Source, Media, Receiver and Destination B) Source, Transmitter, Receiver, Destination, and Media C) Source, Transmitter, Media, Receiver, and Destination D) Media, Source, Transmitter, Receiver, and Destination ix. Examples of wireless media are: A) Coaxial cables, and Infrared B) UTP and Infrared C) Wi-Fi and Whatsapp D) Bluetooth and Microwave Systems x. Which of the following is not an internet protocol A) SMTP B) FTP C) HTML D) HTTP xi. How data is represented inside the computer? A) Logical System B) Byte System C) Binary System D) Hexadecimal System xii. Which of the following is not an output device? A) Monitor B) Touchscreen C) Printer Page 3 of 9  D) Plotter xiii. Which of the following is a way to prevent the theft of data from a computer? A) Use of an up to date anti-virus program B) Set up a username and password C) Backup data on a regular basis D) Remove the monitor when not in use xiv. Madam Lucy wants to process students’ results in terms total marks, average and rank. Which application software can assist her to do that? A) MS-Word B) MS- Publisher C) MS- Excel D) MS-Access xv. The mail merge tool in MS-Word is found in a tab known as A) Mail Wizard B) Mail letters C) Mailings D) Insert 2. Match items from list A with the most correct items in list B. Write the corresponding letter from list B against the number from list A [7.5 Marks @ 0.5] List A List B i. BIOS A) Uninterruptible Power Supply (UPS) ii. Electronic Valves B) Star topology iii. Analog Computer C) [email protected] iv. Mainframe D) Mesh topology v. Basic features of E) ensuring that the originators of Computer messages cannot deny that they in vi. Sign of Computer fact sent the messages Virus F) creating backups vii. Attack Page 4 of 9 viii. Acknowledg G) guarding against improper ment information modification or ix. Non repudiation destruction x. Network topology H) creating fingerprints of documents which offers I) insert a malicious router in the path highest reliability between client and server xi. A device that J) feedback to the sender of the email if supplies power it was sent or not when commercial K) lies dormant until a specific piece of utility power program is activated system fails L) modify existing programs in the xii. Logic Bomb operating system xiii. Email M) an assault on system security address format that derives from an intelligent threat xiv. Integrity N) Macintosh (Example of) xv. Vulnerability O) Drivers (Examples of) P) necessary instructions for how a device communicates with the other computer hardware Q) the central components in the first generation computers R) computer which uses continuous signal such as physical phenomena S) performs calculations with quantities represented as digits T) fastest and powerful computer in process data U) kambale.udom.ac.tz V) Weakness in a system’s security W) may become tired X) communicate with hardware directly Y) test computer system and make sure no errors exist Z) a sudden reduction of disk space Page 5 of 9  3. Complete the following statement by filling the correct answer in the gaps provided [15 @ 1 Mark]. i. Two major kinds of software are and application software. ii. are programs that coordinate computer resources, provide an interface between users and the computer, and run applications. iii. is the portion of the application that allows you to control and to interact with the program. iv. Some tabs, called , only appear when they are needed and anticipate the next operations to be performed by the user. v. create text-based documents and are one of the most flexible and widely used software tools. vi. means to point at an object you want to select, and then press and release the left mouse button twice in rapid succession. vii. is a location in the computer’s memory that is used to store information temporarily. viii. The appears when you paste text, it asks you if you want to keep source formatting, match destination formatting, or keep text only. ix. The feature allows you to combine a mailing list with a document to send the same thing to a number of people. x. are effects for moving from slide to slide and controls the way the whole slide appears on the screen. xi. _________________ is a built in device in a computer which stores different files such as book, videos and music. xii. _________________ is a pre-designed MS-Excel worksheet with formulae and functions. It can be used by an ICT less literate teacher to process students’ results. Page 6 of 9 xiii. _________________ is a function in MS-Excel used to make selection in which for someone to be selected all the put criteria must be reached. xiv. Two requirements needed for mail merge are __________________ and _____________________________ xv. An output device which displays the content from a computer to a large screen is known as___________________________ 4. You have been provided with complete set of menu tabs such as File, Home, Insert, Design, References, Mailings, Review, View, Transitions, Animation and Slide Show in MS Word and MS PowerPoint Window. Fill in the table provided with Menu Tabs (s) responsible for creation of various documents tasks [10 marks @ 1 Mark]. Document Task Menu Tab (s) Example: View a document in a web layout View i. 1. See all items you have copied to the Clipboard ii. 2. Use a ready-made shape such as circles, squares and arrows iii. 3. Make your text pop by highlighting it in a bright colour iv. 4. Choose the list of people you will like to send your document to v. 5. Type a very small letters just above the line of text vi. 6. Split your text in to two or more columns vii. 7. Add a note at the bottom of the page providing more information viii. 8. Add or remove borders from your selection ix. 9. Convert your document and upgrade it to newest file format x. 10. Hide the current slide so that it won’t appear when you are presenting Page 7 of 9 5. Carefully read the following statements and write down the concept reflected by each of the statements [10 Marks @ 0.5] i. Texts which describe data in MS-Excel worksheet------- ii. Numeric entries in MS-Excel worksheet---------__ iii. Use this device to change hard copies of your academic certificates into soft copies-------- iv. One of the characteristics of a computer which holds that a computer is 100% precise--------- v. An example of online storage space owned by Google------ vi. A function used in MS-Excel to determine the number of students under each grade category---------- vii. An operating system owned by Microsoft Corporation Company--------------- viii. A device used by first year students to convert the soft copy of admission letters into hard copies during registration-------------- ix. Are presented in MS-Excel by letters and number such as D2 and E4------------ x. A command used to check the specifications of a computer--------- xi. Are individual components such as HOME and INSERT in MS-Excel worksheet-------- xii. Vertical bars in MS-Excel worksheet-------- xiii. Horizontal bars in MS-Excel worksheet--------- xiv. A component in the system unit which receives power and supplies to other components of the system unit----------- xv. A cable connecting a computer to a network source--------- xvi. One of the characteristics of a computer which holds that a computer can work for a long time without taking rest------ xvii. A quick reminding memory in a computer-------------- xviii. A pressure sensitive part in a laptop which works like a mouse in a computer-------------- xix. A display screen to a computer---------- xx. A cable connecting your smartphone and a computer and transfer data among them----------------- Page 8 of 9  SECTION B Alternative to practical 6. The following table is an extract of MS-Excel worksheet. Clearly study it and answer the questions which follows [10 Marks @ 2]. i. Explain how will you insert automatic serial number (SN) starting at a point ‘A’?------- ii. At ‘B’ write down the formula for finding total of students’ marks------- iii. At ‘C’ write down the formula for finding average of students’ marks------ iv. At ‘D’ write down the formula for ranking the students in descending order using their average scores------- v. At ‘E’ write down the formula for grading students’ average scores using the grading scheme currently used by O’Level secondary schools in Tanzania-------- Page 9 of 9