REDEEMER'S UNIVERSITY PMB 230 Ede, Osun State, Nigeria FACULTY OF NATURAL SCIENCES DEPARTMENT OF COMPUTER SCIENCE Course Code/Course Title: CMP 215/Application Software Packages Course Unit: (2 Units) 2020/2021 SESSION, FIRST SEMESTER EXAMINATIONS Instructions: Attempt any Three (3) Questions Time Allowed: 2 Hours Question One a. Briefly describe any six (6) basic features of Web/Internet browser application (6 Marks) b. List eight (8) examples of Web/Internet Browser applications (4 Marks) c. (i) Describe Web Search Engine. (2 Marks) (ii) List eight (8) Examples of Web Search Engines. (4 Marks) d. Describe the four (4) components of a Search Engine. (4 marks) Question Two a. What is a Presentation Software? List four (4) popular examples of presentation Software application known to you. (3 Marks) b. (i) Describe "Slide Master view" and Outline four (4) common things that can be created in a PowerPoint application. (3 Marks) (ii) Describe four common uses of Slide Master. (4 Marks) c. (i) What do Editing features allow users to do in a Word Processors? (1 Marks) (ii) Briefly describe any five (5) Editing Features in Word Processors. (5 Marks) d. Define Word Processing and Word Processor? List any four examples of word processing software known to you. (4 Marks) Question Three a. What is a spreadsheet? Briefly describe what a cell is in an electronic spreadsheet. (2 Marks) b. Use Figure 1 to attempt the following questions. The figure shows the scores of a student in certain courses as inputted in Microsoft Excel. (i) Using the IF( ) function, write out the formulas that will automatically generate the Letter Grades; LG3 and LG5 (3 Marks) (ii) Using the IF( ) function, write out the formulas that will automatically generate the Grade Values; GV3 and GV5 (3 Marks) (iii) Generate the formulas for each of the credit points; CP3 and CP5. (2 Marks) (NOTE: The interpretations of the grades are according to the keys table to the right.) Page 1 of 3 KEYS TABLE Score Range Letter Grade Grade Value 70 --100 A 5 60 — 69 B 4 50 -- 59 C 3 45 -- 49 D 2 40 — 44 E 1 < 40 14 0 D E I Courses Score Letter Grade Grade Value Credit Unit Credit Point 2 GNS 101 55 LG1 GV1 3 CP1 3 GST 111 70 LG2 GV2 2 CP2 4 CMP 24S 54 LG3 GV3 3 CP3 CMP 221 80 LG4 GV4 CP4 6 CMP 22: 71 LG5 GV5 2 CP5 7 STA 223 45 LG6 GV5 3 CP6 Figure 1: Scores of a student in certain courses c. Briefly describe the following internet/web application related terms: (i) The Web; (ii) Web Browser; (iii) Web Surfing; and (iv) Web Server (4 Marks) d. (i) Outline four (4) important things to do in order to correctly enter a formula with a function, in Microsoft Excel. (4 Marks) (ii) Mention any two (2) types of functions available in Microsoft Excel. (2 Marks) Question Four a. Tabulate five (5) distinguishing differences that exist between System software and Application software, stating the basis for the differences. (10 Marks) b. What is a software? Briefly describe the two basic types of software. (3 Marks) c. (i) Briefly state the two types of Application Software. (2 Marks) (ii) What is Software Upgrading? Describe two types of software upgrades. (3 Marks) d. Describe the following as they relate to Microsoft Word Application: (i) Style (ii) Section Break (2 Marks) Question Five a. State what a database is and what a relational database application is. (2 Marks) b. Describe the four main objects in Microsoft Access Application. (8 Marks) c. (i) Identify the four entities that the Design view of a MS Access Table allows you to create and modify. (4 Marks) (ii) In Microsoft Excel, what is a Worksheet? Briefly describe the two (2) components of a Worksheet Formula. (3 Marks) d. Figure 2 shows the scores and grades of a student in some courses. Considering the cells references, generate the correct formula that will compute each of the TLU, TCP and GPA. (3 Marks) Page 2 of 3 2 3 7 , 8 10 I C1 0 I Score Letter Grade Grade Value Credit Unit Credit Point 77 A 5 3 15 50 C 3 2 6 64 B 4 3 12 44 E 1 • 2 2 69 B 4 1 4 33 F 0 2 0 Till TCP GPA Figure 2: Scores and grades of a student in some courses. Page 3 of 3 Page 1 Page 2 Page 3