Question
At the school ABC, the information of students are stored in two files: - the file named studentInformaiton.xlsx that includes: student id, last name, first
At the school ABC, the information of students are stored in two files: - the file named studentInformaiton.xlsx that includes: student id, last name, first name, Security Number, birth day, phone number - the file named studentGrade.xlsx that include student id, and all the classes that students completed with the letter grade and the classes that students are currently taking
Then, display the following tasks to allow users to select SCHOOL ABC
1. Add One New Student from the keyboard (
2. Remove One Student
3. Find one Student by ID
4. Add a class for one student
5. Drop a class for one student
6. Print the list of student names in one class
7. Print out the transcript of one student
8. Show all studdents in the data structure
After finishing one task, the program will loop back to allow users do other tasks until users want to exit.
TASK 1: Add One New Student from the keyboard (INSERT) This task helps to insert one new student to the data structure. The information of one student are read from the keyboard.
TASK 2: Remove One Student (DELETE): This task helps to remove one student from data structure. Ask for an ID, for example, 12345, remove student and print out the message: Student with Id 12345 is removed OR Student with id 12345 is not In the system
TASK 3: Find a student by ID (FETCH) (for example id = 12345); the program will ask for an id that is entered from the keyboaRd, then display the information of student found as below where if the class with grade X print Not Complete instead of the letter grade; If cannot find the id then display the message ID cannot be found
TASK 4: Add a class for one student The program will ask for the id and the class name, then the program will fetch the student with the id, then add the new class to the class list where the grade of the new class is X
TASK 5: Drop a class for one student The program will ask for the and the class name to drop. The program will fetch thes student with id then remove the class from the list class. If the claas has the grade that is not X, then display the message The class is completed, cannot be dropped otherwise Drop class successfully
TASK 6: Print the list of students in one class (Search all student in one class): the program will ask for the class name. It should be in the format semester (2characters) year (4digits) 4 letter of class 4 digits of class. For example: FA2016-COSC2436, then use the entered class name as a keyto search in data structure. If it is found, print the id and first name and last name of the student in the following format. Continue to search until reaching the last node on the data structure. The final output of this task:
TASK 7: PrInt out the transcript of one student.
Ask for the id from the keyboard of the student that you want to print out the transcript. Search the student in the data structure by using id as a key. If the student is found, display the transcipt on the screen in the following format
SCHOOL ABC - TRANSCRIPT
TASK 8: Show alll (SHOW ALL)
Just call show all method to display all the student in the structure
TASK 0: //exit
Before terminate the program, do the following -Open the file studentInformation.csv to write -Open the file studentGrade.csv to write -Use the logic show all of the structure to read each not information then write to file in the following format:
WRITE TO FILE studentInformation.csv: Id, last name, first name, ss number, phone, address
For example: 12345,Smith,James,123456789,3/21/1996,2147256767,123 Walnut rd Dallas TX 74243
WRITE TO FILE studentGrade.csv: id, className1, grade1, className2, grade2, etc..
For example: 54321,SP2017-COSC1301, A,SP2017-ENGL1301,B,SP2018-MUSI1181,X,SP2018-MATH1414,X
Remember to close the file before terminating the program
studentGrade() (1) - Excel File Home Insert Dram Page Layout Formulas Data Review View Tell me what you want to do B1 1 1212121 SP2016-COSC1301 2 1232123 FA2016-ENGL1301 A FA2016-MATH1370 B SP2017-COSC1437 DSP2017-MATH2305 3 1234432 FA2016-HUMA1315 A FA2016-ENGL1301 A 4 1234435 FA2016-GOVT2305 FA2016-GOVT2305 SP2017-ENGL1302 FA2017-COSC2436 C FA2017-COSC2436 A FA2017-HUMA1302 A FA2017-GOVT2305 FA2017-MUSI2425 X FA2017-GOVT2305 X FA2017-PHYS2425 X FA2017-COSC1436 8 SP2017-GOVE2306 X FA2017-ENGL1302 C C ASP2017-cosci437 SP2017-MATH2305 SP2017-COSC!437 8 FA2016-PHYS2325 SP2017-MATH2305 studentGrade() (1) - Excel File Home Insert Dram Page Layout Formulas Data Review View Tell me what you want to do B1 1 1212121 SP2016-COSC1301 2 1232123 FA2016-ENGL1301 A FA2016-MATH1370 B SP2017-COSC1437 DSP2017-MATH2305 3 1234432 FA2016-HUMA1315 A FA2016-ENGL1301 A 4 1234435 FA2016-GOVT2305 FA2016-GOVT2305 SP2017-ENGL1302 FA2017-COSC2436 C FA2017-COSC2436 A FA2017-HUMA1302 A FA2017-GOVT2305 FA2017-MUSI2425 X FA2017-GOVT2305 X FA2017-PHYS2425 X FA2017-COSC1436 8 SP2017-GOVE2306 X FA2017-ENGL1302 C C ASP2017-cosci437 SP2017-MATH2305 SP2017-COSC!437 8 FA2016-PHYS2325 SP2017-MATH2305Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started