Essentials of IT

Jun 2025 Examination

 

 

PLEASE NOTE:  This assignment is application based, you have to apply what you have learnt in this subject into real life scenario. You will find most of the information through internet search and the remaining from your common sense. None of the answers appear directly in the textbook chapters but are based on the content in the chapter

 

Q1. Use this dataset to answer the questions that follow:

h t t p s : / / d o c s . g o o g l e . c o m / s p r e a d s h e e t s / d / 1 L o –   G7nkTf0H7FWlxSEuWu5G9AodiicNh/edit?usp=drive_link&ouid=11645716942440

8822386&rtpof=true&sd=true

1. With the help of a graph, present the approximate cost for two people according to the type of restaurant. (3 marks)
2. Create a graph to present the number of people who book tables online. (3 marks)
3. Create a graph to present the count of online orders who book online orders. (3 marks)
4. What is the number of restaurants that have greater than 4.0? (1 mark)

(10 Marks)

 

 

Q2A. Evaluate the impact of implementing a centralized Database Management System (DBMS) at a    University to address data inconsistencies between the Academic Records System (ARS) and the Housing Records System (HRS)? (5 Marks)

 

Q2B.  Use the MS Excel tool to answer the questions given below for the following dataset:

h t t p s : / / d o c s . g o o g l e . c o m / s p r e a d s h e e t s / d / 1 X D B b U –  Pghu53m88nb7jEeJLPj5hHMjLu/edit?usp=sharing&ouid=116457169424408822386&rtpof=true&sd=true

Use conditional formatting to

1. Highlight candidate ID less than 3,00,000 (1 mark)
2. Highlight those cells where the area is south-east (1 mark)
3. Mark candidates with Gender ‘F’ (1 mark)
4. Use data bars to indicate mature candidates over 40 years using condition (1 mark)
5. Highlight the cells with the top 5 % result (1 mark)

(5 Marks)