Understanding Data

For each service, maintain the data fields needed to identify the person/item and perform the task:

a) Declare exam results and print e-certificates
- Student name
- Roll number / registration number
- Class
- Subject-wise marks
- Total marks / percentage
- Result status
- Certificate number

b) Register participants in an exhibition and issue biometric ID cards
- Participant name
- Age
- Gender
- Address / contact details
- Exhibition category / stall or item name
- Photograph
- Biometric data such as fingerprint / iris scan
- ID card number

c) To search for an image by a search engine
- Image file name
- Image format/type
- Keywords / tags
- Title / description
- Size / resolution
- Source / web page link

d) To book an OPD appointment with a hospital in a specific department
- Patient name
- Age / gender
- Contact number
- OPD registration number
- Department name
- Doctor name
- Appointment date and time
- Patient ID / medical record number

To prepare the scholarship list, the school should follow these data processing steps:

1. Collect data for all 500 students:
- marks / percentage of the last two years
- family income
2. Store the data in a suitable digital form, such as a spreadsheet or database.
3. Process the data by applying the required conditions:
- student must have more than 75% in two consecutive years
- family income must be less than 5 lakh per annum
4. Filter / select only those students who satisfy both conditions.
5. Prepare the final list of beneficiaries and verify it before announcing.

Thus, the school can use the processed data to identify eligible scholarship students.

The bank should first collect data from the residents of city ABC, such as:

- number of bank accounts each family has
- average monthly account balance of each person
- family details / resident details

The data can be collected through forms, surveys, or existing bank records, and then stored in a digital file or database.

After that, the bank should process and analyse the data to check:

- how many families already have accounts in the bank
- how many accounts each family has on average
- the average monthly balance maintained by customers
- whether the bank is popular among residents based on the number of accounts and balances

From the processed data, the bank can judge its popularity in city ABC and understand customer usage and account balance patterns.

The types of data are:

a) Recording a video — Unstructured data

b) Marking attendance by teacher — Structured data

c) Writing tweets — Unstructured data

d) Filling an application form online — Structured data

Given temperatures: 34, 34, 27, 28, 27, 34, 34

- a) Find the average temperature → use Mean
- b) Find the temperature range → use Range
- c) Find the standard deviation temperature → use Standard Deviation