Computer Science
A school having 500 students wants to identify beneficiaries of the merit-cum means scholarship, achieving more than 75% for two consecutive years and having family income less than 5 lakh per annum. Briefly describe data processing steps to be taken by the school to prepare the beneficiaries list of school.
Relational Database
5 Likes
Answer
Data processing steps:
- Collect student information including name, address, academic qualifications, marks sheets for the last two consecutive years, family income certificate, phone number, email.
- Verify the accuracy and completeness of the collected data. Check if the student has achieved more than 75% in their academics for two consecutive years. Verify the family income of each student to ensure it is less than 5 lakh per annum.
- Identify students who meet the eligibility criteria of achieving more than 75% for two consecutive years and having a family income less than 5 lakh per annum and make a list.
Answered By
3 Likes
Related Questions
Identify data required to be maintained to perform the following services:
- Declare exam results and print e-certificates.
- Register participants in an exhibition and issue biometric ID cards.
- To search for an image by a search engine.
- To book an OPD appointment with a hospital in a specific department.
A bank 'xyz' wants to know about its popularity among the residents of a city 'ABC' on the basis of number of bank accounts each family has and the average monthly account balance of each person. Briefly describe the steps to be taken for collecting data and what results can be checked through processing of the collected data.
Identify type of data being collected/generated in the following scenarios:
- Recording a video
- Marking attendance by teacher
- Writing tweets
- Filling an application form online
Consider the temperature (in Celsius) of 7 days of a week as 34, 34, 27, 28, 27, 34, 34. Identify the appropriate statistical technique to be used to calculate the following:
- Find the average temperature.
- Find the temperature Range of that week.
- Find the standard deviation temperature.