- Information
- AI Chat
202311 CS112 112F Nov 2023
Computer Science (ComSci1)
Rhodes University
Recommended for you
Preview text
RHODES UNIVERSITY
DEPARTMENT OF COMPUTER SCIENCE
EXAMINATION: NOVEMBER 2023
COMPUTER SCIENCE 112 / 112F
Internal Examiners: Prof N Dlodlo MARKS: 180 Dr Z Shibeshi DURATION: 3 hours Dr SD Chindipha Dr C Thomson Mr T Ncube
GENERAL INSTRUCTIONS TO CANDIDATES- This paper consists of 33 pages and 80 questions. Please ensure that you have a complete paper.
- Please complete Section A on the Multiple Choice Sheet, attached to the back of this paper, and may be detached.
- Please complete Sections B and C on the exam paper, except questions 78-80, which should be written in the Word document provided.
- Ensure you complete your student number on this front cover and on the MCQ sheet.
- There is no task number for this examination.
- Calculators may be used during this examination.
- The Oxford Concise English dictionary may be used during this examination.
STUDENT NUMBER: ________________________
SEAT NUMBER: ____________________________
EXAMINERS USE ONLY MCQ (1-64) Written: Big Data (71-74) Written: Intro (65-67) Prac: SS (7 5 ) Written: IST (68-69) Prac: BPS (7 6 - 77 ) Written: DB (70) Prac: DB (78-80) TOTAL
PLEASE DO NOT TURN OVER THIS PAGE UNTIL TOLD TO DO SO.
SECTION A: MULTIPLE CHOICE [85 MARKS]
Answer all the questions in this section on the multiple-choice answer sheet provided.
Introduction to the Operational Environment (18 Marks)
In this section, each question carries one (1) mark, except for question 3, which carries three ( 3 ) marks.
Random Access Memory (RAM) is ____________. a. non-volatile memory b. volatile memory c. disposable memory d. reusable memory e. None of the above.
Which of the following components is not housed on the motherboard? a. expansion slots b. sound card c. hard disk d. video card e. None of the above.
Convert 479 in decimal code into binary. (3 marks) a. 0001 1010 1111 b. 0001 1101 0001 c. 0001 1101 1111 d. 1001 1011 1110 e. 0001 1011 0001
In the XNOR gate, if the inputs are 1 and 1, what will the output be? a. 0 b. 1 c. 11 d. 10 e. None of the above.
The instruction time of the machine cycle in the CPU comprises the following functions: a. fetch and execute b. fetch and store c. fetch and decode d. decode and execute e. decode and fetch
The difference between freeware and shareware is that ____________. Select the most appropriate option. a. while shareware is software for no cost for an unlimited time, freeware is software for a trial period after which the user pays b. while freeware is fully-functional, shareware is not fully-functional c. while shareware is fully-functional, freeware is not fully-functional d. while freeware is software for no cost for an unlimited time, shareware is software for a trial period after which the user pays e. All of the above.
The copy-left licencing ensures that derived work has the following freedom(s), except the freedom to ____________. a. use and study the work b. copy and share the work c. modify the work d. patent the work e. distribute the modified work
The cloud is ____________. Select the most appropriate option. a. a group of computers suspended in the atmosphere b. a service provided by Apple Computers c. a network of intertwined CPUs d. a network of remote servers or databases that can be located anywhere in the world e. None of the above.
Phishing does not include tricking the user into ____________. a. divulging sensitive data b. downloading malware c. fishing from a database d. updating their profile to an illegitimate website e. None of the above
Trojan horses are malicious software that ____________. Select the most appropriate option. a. replicates itself and corrupts the computer system b. is disguised as legitimate software c. enables users to obtain information covertly d. monitors and records each keystroke e. None of the above.
Spreadsheets (18 marks)
In this section, each question carries two (2) marks, unless stated to carry one (1) mark. 17. In Excel, VIP2:VIP22 represents ____________. (1 mark) a. cell references b. a cell range c. owners of a file d. The question does not make sense. 18. What will be displayed if we enter the following formula in a certain cell and both A2 and A5 are empty cells? =NOT(A2<>A5) a. An error message b. TRUE c. FALSE d. The formula will be displayed. 19. The opposite of >= is ____________. (1 mark) a. > b. < c. <= d. <> 20. Which of the formulae below is valid? a. =1A+2B b. =F1+F2+F3/ c. =X22Z d. =3H- 3 e. All are valid formulae. 21. What would be a possible scenario where we use the following formula? =IF(E5="Yes"; D5 + D514%; D5). a. To display the item's value plus its 14% if the item is taxable, otherwise the item’s value. b. To display the item’s value if the item is taxable. c. To display the item's value plus its 14% if the item is taxable, otherwise 0. d. To display the value plus its 14% if the item is not taxable, otherwise 0.
What is the primary purpose of using plots like the following? Select the most appropriate option. a. To display the relationship between two sets of numeric data. b. To display a trendline for a single data series. c. To compare the distribution of categorical data. d. To create a line chart with multiple data series.
What do you do if you want to copy the result of a formula but not the underlying formula to another cell? (1 mark) a. Use Cut and Paste Special b. Use Cut and Paste c. Use Copy and Paste Special d. Use the fill handle and drag
In the diagram below, what will happen if we click on the “OK” button in the dialog box? a. Excel will enter 75 in B6. b. It depends on the file type. c. Excel will change the formula in B8. d. None of the above is correct.
Business Problem Solving (10 Marks)
In this section, each question carries one (1) mark. 28. A spreadsheet model is ____________. Select the most appropriate option.
a. used to eliminate spreadsheet errors
b. a template that can be used to enter and manipulate data values
c. a template that is used to calculate profit/loss
d. a template used for invoicing
Which of these represents a logical error in spreadsheets? a. Incorrectly labelling data b. Capturing inappropriate financial formulae c. Entering an incorrect value d. Incorrectly copying and pasting data
The IRR and XIRR functions are used to calculate the internal rate of return. What is the difference between the two functions? a. IRR is used when the cash flows are periodic, and the XIRR is used when the cash flows are not periodic. b. IRR is used when the cash flows are not periodic, and the XIRR is used when the cash flows are periodic. c. IRR is used when the cash flow amounts are the same, and the XIRR is used when the cash flow amounts are different. d. IRR is used when the cash flow amounts are not the same, and the XIRR is used when the cash flow amounts are the same.
The ____________ function is used to find the interest portion of a monthly payment. a. PPMT b. PMT c. NPMT d. IPMT
Which of the following is the 4th stage in the best-practice modelling approach to the development of a spreadsheet model? a. Use b. Specify c. Build d. Test
Which of the following is not a correct rule for designing spreadsheet models? a. Use multiple worksheets. b. Referencing the column below. c. Use one formula per row or column. d. Use consistent columns on multiple worksheets.
IS Theory (16 Marks)
In this section, each question carries one (1) mark, unless stated to carry two (2) marks. 38. Which of the following best describes the purpose of Information Systems? a. To manage data and information b. To store and retrieve information c. To collect, process and store information d. To collect, process, store and disseminate information e. To analyse information and produce reports 39. An information system is made up of which of the following primary components? a. Hard systems thinking and soft systems thinking b. Inputs, processes, and outputs c. Hardware, software, data, people, and networks d. Hardware, software, data, people, and procedures e. Inputs, processes, outputs, and feedback 40. Indicate whether the following statement is True or False. The term Information Systems is often confused with Information Technology. Information Systems focuses on the technology involved in systems, and is primarily concerned with installing, maintaining, and improving systems, networks and databases. a. True b. False 41. In Information Systems, what is represented by raw and unordered facts? a. Information b. Data c. Knowledge d. Action e. Wisdom 42. When is information deemed useful to an individual or organisation? a. When it is relevant b. When it is timely c. When it is accurate d. When it is accessible e. All of the above
Which of the following perspectives have largely influenced the hard systems approach? a. Systems engineering, systems analysis, and functions research b. Systems engineering, systems analysis, and operations research c. Systems engineering, systems analysis, and reductionism d. Systems thinking, systems engineering, and holism e. Systems engineering, systems analysis, and systems management
Which of the following statements are true of an information system? (2 marks) i. A system is an entity that is comprised of two or more parts or elements. ii. In a system, all of the parts or elements need not be interrelated or connected (directly or indirectly). iii. A system can be abstract or concrete. iv. In special circumstances, a system can be composed of only one part or element. v. A system can be open or closed. a. i, ii and iii b. i, iii, iv and v c. i, iii and v d. i, ii, iii and v e. None of the above.
Suppose the following scenario takes place: A person sees that it is getting dark outside and decides to press the light switch to turn on the light in their bedroom (process A). When the light switch is pressed, the light bulb goes from “off” to “on” (process B). (2 marks) a. Process A is a response. Process B is a reaction. b. Process A is a reaction. Process B is a response. c. Both Process A and B are reactions. d. Both Process A and B are responses. e. Process A is a response. Process B is undefined.
What is the name of the diagram below? a. The System Appropriation Process b. The Data-Information-Wisdom Process c. The Information Appropriation Process d. The Information Transformation Process e. The Data-Information-Knowledge-Wisdom (DIKW) Process
Databases (5 Marks)
In this section, each question carries one (1) mark. 51. For some relations, changing the data can have undesirable consequences called ____________. a. lack of integrity constraints b. abnormal forms c. broken transitive dependencies d. modification anomalies 52. The following SQL statement is which type of JOIN? SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID a. Equi-join b. Natural join c. Outer join d. Cartesian join
Point out the wrong statement. a. Data is facts for analysis b. BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data c. Customer relationship management (CRM) entails all aspects of interaction that a company has with its customer d. All of the above
Which of the following involves analyzing complex relationships among thousands or even millions of data items stored in data marts, data warehouses, and other multidimensional databases to discover patterns, trends, and exception conditions? a. OLTP b. OLAP c. OISE d. DSS
Information has three dimensions. These are ____________. a. time, consent, and form b. time, content, and form c. cost, content, and form d. time, content, and value
Key Performance Indicators (KPIs) can be measured using business intelligence tools. KPIs can ____________. a. guarantee your business will grow by 125% b. ensure your business will reduce costs by 55% c. drive improvements and help businesses focus their people and resources on what counts d. All of the above.
What are the challenges to developing BI with semi-structured or unstructured data? a. Unstructured data is stored in a huge variety of formats. b. There is a lack of standardized terminology. c. Problem of format and terminology is just with unstructured data and not semi structured data. d. Both a and b are correct.
Hadoop is a framework that works with a variety of related tools. Common cohorts include ____________. a. MapReduce, Hive and HBase b. MapReduce, MySQL and Google Apps c. MapReduce, Hummer and Iguana d. MapReduce, Heron and Trumpet
You want to plot the break-up of traffic sources to your website. There will be three categories: Direct Traffic, Search Engines and Referring Sites. Which type of chart would be the best choice? a. Line chart b. Histogram c. Pie chart d. Distribution chart
What statement below best describes why we do data analytics in business? a. Analytics improves our understanding of how the business works. b. We must show a return on the investment we make in data and analytical resources c. We need specific insights to make business decisions. d. We have to calculate and report financial results to owners / shareholders.
b. What are the most common causes of overheating? Name two of these. [ 2 ] ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ 67. There are benefits of using a computer network for a business. As a business owner, name and explain two (2) of these benefits. (4 marks)
INFORMATION SYSTEMS THEORY (14 Marks) 68. Name, define and give one (1) example each of two (2) types of information systems that can be used in an organisation. (3x2 = 6 marks) ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ ______________________________________________________________________ 69. Refer to the WiseEd System Diagram on the following page, and provide the names of the components labels A to H. (8 marks) Label Component Name A B C D E F G H
202311 CS112 112F Nov 2023
Course: Computer Science (ComSci1)
University: Rhodes University
- Discover more from:
