Give me user requirements and System requirements specification based on the scenario given below. After the supplementary examinations, the system will process the list of students. If the supplementary examination mark is at least 50%, then the student has passed the subject. If it is below 50% then the student has failed the subject. Finally, the student’s CGPA is calculated and if the student’s CGPA is at least 2.00 then the student’s status changes to “Pass” else it will change to “Fail”.

Give me user requirements and System requirements specification based on the scenario given below. After the supplementary examinations, the system will process the list of students. If the supplementary examination mark is at least 50%, then the student has passed the subject. If it is below 50% then the student has failed the subject. Finally, the student’s CGPA is calculated and if the student’s CGPA is at least 2.00 then the student’s status changes to “Pass” else it will change to “Fail”.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

(select all that apply) In MS Access, to ensure that a grade must be either A, B, C, D or F, whichvalidation rule should be used?A) ="A" or ="B" or ="C" or ="D" or ="F"B) between A and FC) like "A", "B", "C", "D", "F"D) not in ("A" or "B" or "C" or "D" or "F")E) in ("A", "B", "C", "D", "F")
Exercise A: In this exercise, you are asking the user to set a alpha numeric password for any website. Put some conditions. Password must be 8 characters long. There must be at-least one uppercase letter There must be at least one number. Then show the user, you have set the correct password or not. Exercise B: This exercise is the extension of the above Exercise. In this exercise we are not checking all the criteria of having a good password. Here ask the user to enter his/her password twice. If both matches, thanks the customer otherwise loop your code until user enters both passwords same.
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules:- A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill directly, or…
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. Show all connectivities, relationship…
At a standstill, certain procedures should be discontinued to avoid the following:
Help this task please
ID At_fault_claims 1001 0 1001 1 1002 0 1002 1 1002 1 1003 0 1004 1 1005 1 1005 0 Aggregate the the dataframe above at the ID to create the following claim count variables: : Number of At Fault claims Number of Not At Fault claims it should be written with python We should now have two additional columns 'at fault count' and 'not at fault count' in our aggregate dataframe
Q2. After the successful conduct of Mid Term Examinations, the HOD of the Department of Examinations has called his team members to create the online mark sheet of the students. Also he told his team members to assign grade on the basis of percentage. Input Constraint 91<=marks<=100, Grade O 81<=marks<=90, Grade A 71<=marks<=80, Grade B 61<=marks<=70, Grade C 51<=marks<=60, Grade D 41<=marks<=50, Grade E Otherwise Fail Its the question to be solved in Dev C++.
The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE. Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.
In this function, you will try to update the given user's bank account with the given amount. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to update with, and can either be positive or negative. To update the user's account with the amount, the following requirements must be met: - The user exists in log_in and his/her status is True, meaning, the user is logged in. If the user doesn't exist in the bank, create the user. - The given amount can not result in a negative balance in the bank account. Return True if the user's account was updated. For example, if Brandon has 115.50 in his account: - Calling update(bank, log_in, "Brandon", 50) will return False, unless "Brandon" is first logged in. Then it will return True. Brandon will then have 165.50 in his account. - Calling…
''' In this function, you will try to update the given user's bank account with the given amount. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to update with, and can either be positive or negative. To update the user's account with the amount, the following requirements must be met: - The user exists in log_in and his/her status is True, meaning, the user is logged in. If the user doesn't exist in the bank, create the user. - The given amount can not result in a negative balance in the bank account. Return True if the user's account was updated. For example, if Brandon has 115.50 in his account: - Calling update(bank, log_in, "Brandon", 50) will return False, unless "Brandon" is first logged in. Then it will return True. Brandon will then have 165.50 in his account. - Calling…
Implement the DBS Share Price Index System in Python as per Figure 2 below which allows users toadd, delete, update and lookup Share Prices. The System should store the Company Name and SharePrice. Your program should not allow users to add the same company more than once. On adding,deleting, updating or looking up a Share Price, your program should let the user know if theoperation was successful or not. On looking up a Share Price return the Company Name and SharePrice of the company; if the company is not found give the user the option to add the details theyare looking up. The user can perform multiple actions; they can add a new entry and subsequentlydelete an entry without having to stop and start the program until they decide to quit