Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can anyone build a student data base file using python and the information on the photo below The main objective of this assignment is to

can anyone build a student data base file using python and the information on the photo below image text in transcribed
image text in transcribed
The main objective of this assignment is to design and implement A Student Assessment database software application for managing student's workload, using the python concepts cannt so far like python collections, functions and files NB: Please do not use SQL or pandas to build the code for this program but just use normal python codes and the file below which you will save as a csv file and use in the codes Save the student assessment database below as a CSV file and use it to build the code Assessment ID Submission Dates Module Name Staff Module Code Weighting Component CS10001 12/04 2021 Software Development 00123 CSIL-SOD 30 CWKI CS1002 05/05/2021 Software Development 00123 CS1--SOD 70 CWK2 CS10004 31/03/2021 Web Technologies CSI-S-WET 50 CWKI CSIOOOS 05/05/2021 Web Technologies 2006 CS-S-WET 30 CWK2 CS10006 05/06 2021 Embedded Computing 00345 CS1-7-EMC 60 CWKI CS10007 15/06/2021 Embedded Computing 00045 CSI-FMC40 EX The database above includes all of the data fields. Also given above are validation requirements that you will need when in later steps you come to add new incidents or modify existing ones. - Assessment Number -que Student Assessment Duta od D. Fethiconework, when you come to add or modify an incident, you can enter this mier manually or generate it automatically, but it must be usque In database temes it is the primary key of the second system Submission Date - this is the date, wheat is due. In the case of an exam, it is the date of the exam Staff ID - This nasix degrumbet, for example, 2971 Module Code -tox ende, for cumple CS1-6-EFG The ser should enter a code that is 7digits long and unique Module Name - You can use existing module names Weighting This is the percentage of the overall stule prate for the secunet Esamples include Category of enessment. This can be CWK.CWKI.CWX2, CWX3, EX the CSV file will be able to be imported into Excel, Notepad and other programs for viewing. 1. Thereafter, your program should provide wing a menu driven intact a List assessments Enter a new assessment Remeve an existing met 1. Update the details of an existing assement Search and display the details for a particular level Count the number of assessments Edit the program to access to the following use-cases 1) List all assessment: The user can display on-screen the complete contents of the database. 2) Add a new assessment record: The user can add a new assessment with a unique assessment ID (auto-generated or manual. Once the data is received from the console, it should be stored using appropriate data structures or variables. Once the data has been entered, should be concatenated or joined together with each field separated by a comma and no comma after the last field. This concatenated record must then be written or appended to the existing file Usually, the module seader enters several assessment records at the same sitting 3) Remove an existing assessment: If an assessment is no longer running, or if an assessment was entered by mistake, the assessment needs to be removed 4) Change/modify the details of an existing assessment:Times when changes may have to be made include: Assessment details have changed. A new modele leader has been appointed The weighting of an assessment has been allered 5) Search and display the details for a particular teaching level: A course director may wish to examine all assessments for a particular academic teaching level. Level 4 is usually first year, MSC s usually level 7.Foundation is levels. Tabs may be used to format the output 6) Count the total number of assessments in the database: The user may wish to know how many assessments are running on all courses and at all levels 1) exit the program NB: Include a flowchart and pseudocode alongside the codes The question is about building a student database file where one can listedit delete update, count and exit the program explined everytying in the question biel i posted the information to use to create the student database file is the excel spreadsheet which you have to save it as a csv file and se in the codes if you want The main objective of this assignment is to design and implement A Student Assessment database software application for managing student's workload, using the python concepts cannt so far like python collections, functions and files NB: Please do not use SQL or pandas to build the code for this program but just use normal python codes and the file below which you will save as a csv file and use in the codes Save the student assessment database below as a CSV file and use it to build the code Assessment ID Submission Dates Module Name Staff Module Code Weighting Component CS10001 12/04 2021 Software Development 00123 CSIL-SOD 30 CWKI CS1002 05/05/2021 Software Development 00123 CS1--SOD 70 CWK2 CS10004 31/03/2021 Web Technologies CSI-S-WET 50 CWKI CSIOOOS 05/05/2021 Web Technologies 2006 CS-S-WET 30 CWK2 CS10006 05/06 2021 Embedded Computing 00345 CS1-7-EMC 60 CWKI CS10007 15/06/2021 Embedded Computing 00045 CSI-FMC40 EX The database above includes all of the data fields. Also given above are validation requirements that you will need when in later steps you come to add new incidents or modify existing ones. - Assessment Number -que Student Assessment Duta od D. Fethiconework, when you come to add or modify an incident, you can enter this mier manually or generate it automatically, but it must be usque In database temes it is the primary key of the second system Submission Date - this is the date, wheat is due. In the case of an exam, it is the date of the exam Staff ID - This nasix degrumbet, for example, 2971 Module Code -tox ende, for cumple CS1-6-EFG The ser should enter a code that is 7digits long and unique Module Name - You can use existing module names Weighting This is the percentage of the overall stule prate for the secunet Esamples include Category of enessment. This can be CWK.CWKI.CWX2, CWX3, EX the CSV file will be able to be imported into Excel, Notepad and other programs for viewing. 1. Thereafter, your program should provide wing a menu driven intact a List assessments Enter a new assessment Remeve an existing met 1. Update the details of an existing assement Search and display the details for a particular level Count the number of assessments Edit the program to access to the following use-cases 1) List all assessment: The user can display on-screen the complete contents of the database. 2) Add a new assessment record: The user can add a new assessment with a unique assessment ID (auto-generated or manual. Once the data is received from the console, it should be stored using appropriate data structures or variables. Once the data has been entered, should be concatenated or joined together with each field separated by a comma and no comma after the last field. This concatenated record must then be written or appended to the existing file Usually, the module seader enters several assessment records at the same sitting 3) Remove an existing assessment: If an assessment is no longer running, or if an assessment was entered by mistake, the assessment needs to be removed 4) Change/modify the details of an existing assessment:Times when changes may have to be made include: Assessment details have changed. A new modele leader has been appointed The weighting of an assessment has been allered 5) Search and display the details for a particular teaching level: A course director may wish to examine all assessments for a particular academic teaching level. Level 4 is usually first year, MSC s usually level 7.Foundation is levels. Tabs may be used to format the output 6) Count the total number of assessments in the database: The user may wish to know how many assessments are running on all courses and at all levels 1) exit the program NB: Include a flowchart and pseudocode alongside the codes The question is about building a student database file where one can listedit delete update, count and exit the program explined everytying in the question biel i posted the information to use to create the student database file is the excel spreadsheet which you have to save it as a csv file and se in the codes if you want The main objective of this assignment is to design and implement A Student Assessment database software application for managing student's workload, using the python concepts cannt so far like python collections, functions and files NB: Please do not use SQL or pandas to build the code for this program but just use normal python codes and the file below which you will save as a csv file and use in the codes Save the student assessment database below as a CSV file and use it to build the code Assessment ID Submission Dates Module Name Staff Module Code Weighting Component CS10001 12/04 2021 Software Development 00123 CSIL-SOD 30 CWKI CS1002 05/05/2021 Software Development 00123 CS1--SOD 70 CWK2 CS10004 31/03/2021 Web Technologies CSI-S-WET 50 CWKI CSIOOOS 05/05/2021 Web Technologies 2006 CS-S-WET 30 CWK2 CS10006 05/06 2021 Embedded Computing 00345 CS1-7-EMC 60 CWKI CS10007 15/06/2021 Embedded Computing 00045 CSI-FMC40 EX The database above includes all of the data fields. Also given above are validation requirements that you will need when in later steps you come to add new incidents or modify existing ones. - Assessment Number -que Student Assessment Duta od D. Fethiconework, when you come to add or modify an incident, you can enter this mier manually or generate it automatically, but it must be usque In database temes it is the primary key of the second system Submission Date - this is the date, wheat is due. In the case of an exam, it is the date of the exam Staff ID - This nasix degrumbet, for example, 2971 Module Code -tox ende, for cumple CS1-6-EFG The ser should enter a code that is 7digits long and unique Module Name - You can use existing module names Weighting This is the percentage of the overall stule prate for the secunet Esamples include Category of enessment. This can be CWK.CWKI.CWX2, CWX3, EX the CSV file will be able to be imported into Excel, Notepad and other programs for viewing. 1. Thereafter, your program should provide wing a menu driven intact a List assessments Enter a new assessment Remeve an existing met 1. Update the details of an existing assement Search and display the details for a particular level Count the number of assessments Edit the program to access to the following use-cases 1) List all assessment: The user can display on-screen the complete contents of the database. 2) Add a new assessment record: The user can add a new assessment with a unique assessment ID (auto-generated or manual. Once the data is received from the console, it should be stored using appropriate data structures or variables. Once the data has been entered, should be concatenated or joined together with each field separated by a comma and no comma after the last field. This concatenated record must then be written or appended to the existing file Usually, the module seader enters several assessment records at the same sitting 3) Remove an existing assessment: If an assessment is no longer running, or if an assessment was entered by mistake, the assessment needs to be removed 4) Change/modify the details of an existing assessment:Times when changes may have to be made include: Assessment details have changed. A new modele leader has been appointed The weighting of an assessment has been allered 5) Search and display the details for a particular teaching level: A course director may wish to examine all assessments for a particular academic teaching level. Level 4 is usually first year, MSC s usually level 7.Foundation is levels. Tabs may be used to format the output 6) Count the total number of assessments in the database: The user may wish to know how many assessments are running on all courses and at all levels 1) exit the program NB: Include a flowchart and pseudocode alongside the codes The question is about building a student database file where one can listedit delete update, count and exit the program explined everytying in the question biel i posted the information to use to create the student database file is the excel spreadsheet which you have to save it as a csv file and se in the codes if you want The main objective of this assignment is to design and implement A Student Assessment database software application for managing student's workload, using the python concepts cannt so far like python collections, functions and files NB: Please do not use SQL or pandas to build the code for this program but just use normal python codes and the file below which you will save as a csv file and use in the codes Save the student assessment database below as a CSV file and use it to build the code Assessment ID Submission Dates Module Name Staff Module Code Weighting Component CS10001 12/04 2021 Software Development 00123 CSIL-SOD 30 CWKI CS1002 05/05/2021 Software Development 00123 CS1--SOD 70 CWK2 CS10004 31/03/2021 Web Technologies CSI-S-WET 50 CWKI CSIOOOS 05/05/2021 Web Technologies 2006 CS-S-WET 30 CWK2 CS10006 05/06 2021 Embedded Computing 00345 CS1-7-EMC 60 CWKI CS10007 15/06/2021 Embedded Computing 00045 CSI-FMC40 EX The database above includes all of the data fields. Also given above are validation requirements that you will need when in later steps you come to add new incidents or modify existing ones. - Assessment Number -que Student Assessment Duta od D. Fethiconework, when you come to add or modify an incident, you can enter this mier manually or generate it automatically, but it must be usque In database temes it is the primary key of the second system Submission Date - this is the date, wheat is due. In the case of an exam, it is the date of the exam Staff ID - This nasix degrumbet, for example, 2971 Module Code -tox ende, for cumple CS1-6-EFG The ser should enter a code that is 7digits long and unique Module Name - You can use existing module names Weighting This is the percentage of the overall stule prate for the secunet Esamples include Category of enessment. This can be CWK.CWKI.CWX2, CWX3, EX the CSV file will be able to be imported into Excel, Notepad and other programs for viewing. 1. Thereafter, your program should provide wing a menu driven intact a List assessments Enter a new assessment Remeve an existing met 1. Update the details of an existing assement Search and display the details for a particular level Count the number of assessments Edit the program to access to the following use-cases 1) List all assessment: The user can display on-screen the complete contents of the database. 2) Add a new assessment record: The user can add a new assessment with a unique assessment ID (auto-generated or manual. Once the data is received from the console, it should be stored using appropriate data structures or variables. Once the data has been entered, should be concatenated or joined together with each field separated by a comma and no comma after the last field. This concatenated record must then be written or appended to the existing file Usually, the module seader enters several assessment records at the same sitting 3) Remove an existing assessment: If an assessment is no longer running, or if an assessment was entered by mistake, the assessment needs to be removed 4) Change/modify the details of an existing assessment:Times when changes may have to be made include: Assessment details have changed. A new modele leader has been appointed The weighting of an assessment has been allered 5) Search and display the details for a particular teaching level: A course director may wish to examine all assessments for a particular academic teaching level. Level 4 is usually first year, MSC s usually level 7.Foundation is levels. Tabs may be used to format the output 6) Count the total number of assessments in the database: The user may wish to know how many assessments are running on all courses and at all levels 1) exit the program NB: Include a flowchart and pseudocode alongside the codes The question is about building a student database file where one can listedit delete update, count and exit the program explined everytying in the question biel i posted the information to use to create the student database file is the excel spreadsheet which you have to save it as a csv file and se in the codes if you want

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 19th International Conference Dexa 2008 Turin Italy September 2008 Proceedings Lncs 5181

Authors: Sourav S. Bhowmick ,Josef Kung ,Roland Wagner

2008th Edition

3540856536, 978-3540856535

More Books

Students also viewed these Databases questions