Description

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)

Ans 1.

Introduction

The restaurant industry has rapidly evolved with the influence of digital platforms and changing consumer preferences. In urban areas, customers now expect more than just good food—they look for convenience, quick access to information, and personalized services. Online food delivery, table booking options, and user ratings play a vital role in shaping customer choices. Analyzing such factors helps restaurant businesses understand what influences customer behavior and how to stay competitive. This study, using real-world data from Zomato, explores trends related to online ordering, table bookings, customer ratings, and the average cost for dining across different types of restaurants. The goal is to draw useful

Its Half solved only

Buy Complete assignment from us

Price – 190/  assignment

NMIMS University Complete SolvedAssignments  session JUNE 2025

buy cheap assignment help online from us easily

we are here to help you with the best and cheap help

Contact No – 8791514139 (WhatsApp)

Message ASSIGNMENT SUPPORT on WhatsApp. https://wa.me/918791514139

OR

Mail us-  [email protected]

Our website – www.assignmentsupport.in

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)

Ans 2A.

Introduction

In many universities, different administrative departments operate in isolation, often leading to inconsistencies in student data. A common issue arises when the Academic Records System (ARS) and the Housing Records System (HRS) store overlapping yet disconnected information. Such inconsistencies can cause confusion, inefficiencies, and administrative delays. Implementing a centralized Database Management System (DBMS) provides an integrated solution by offering a single source of truth for all student-related data, improving

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)

Ans 2B.

Introduction

Data analysis using Microsoft Excel allows users to efficiently organize, interpret, and highlight important trends within large datasets. Conditional formatting is one of the most powerful tools in Excel, enabling users to visually differentiate values based on specific criteria. In this case, Excel was used to format a dataset of candidate information that includes ID numbers, regions, gender, age, and test results. The goal was to apply conditional rules to