Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Overview This project will help you demonstrate your ability to create a program in Python. Below is a functional specification for the program you are

Overview
This project will help you demonstrate your ability to create a program in Python. Below is a
functional specification for the program you are going to design, code, and test. You will use the
following when coding this program:
variables
if else statements
loops - while and for loops
functions
open/create/read/write/closing files
read user input
convert data types (e.g., string to integer)
a data structure to store the data from the STUDENTDATA.TXT file
Functionality
Based on a menu selection, analyze student records from the STUDENTDATA.TXT file. The menu
items describe the type of processing you will have to do in your program.
Assume a grading scale of:
A: 90%-100%
B: 80%-89%
C: 70%-79%
D: 60%-69%
F: 60%
Use the student file that is called STUDENTDATA.TXT as input. It has the following fields, which
are comma delimited:
First Name - Up to 10 letters
Last Name - Up to 10 letters
Grade - NN.N (Grade percentage: e.g.,84.8. Round up when doing calculations.)
Degree - Either MSIT or MSCM
Your program will use a console/command line-based user interface, not a graphical user
interface.
Your program will display readable results to the display. You will write records to a file.
Your program will overwrite any output files.
Your program should exit gracefully.
Output files will be in the same format as the input file noted above.
Invalid records mean that all fields are not present, a grade in the file is above 100 or below 0,
or the degree program is listed as something other than MSCM or MSIT.
Validate all user input.
You will comment your program.
Menu options
Your program must have a menu. The menu functionality is below:
Display average grade for all students
Display average grade for each program
Display highest grade record
Display lowest grade record
Display students in MSIT
Display students in MSCM
Display all students in sorted order by student ID
Display invalid records
Create new file with invalid records called BADRECORDS.TXT. Display a message that
says BADRECORDS.TXT has been created
Exit programOverview
This project will help you demonstrate your ability to create a program in Python. Below is a functional specification for the program you are going to design, code, and test. You will use the following when coding this program:
variables
if else statements
loops while and for loops
functions
open/create/read/write/closing files
read user input
convert data types (e.g., string to integer)
a data structure to store the data from the STUDENTDATA.TXT file
Functionality
Based on a menu selection, analyze student records from the STUDENTDATA.TXT file. The menu items describe the type of processing you will have to do in your program.
Assume a grading scale of:
A: 90%100%
B: 80%89%
C: 70%79%
D: 60%69%
F: 60%
Use the student file that is called STUDENTDATA.TXT as input. It has the following fields, which are comma delimited:
Student ID NNNN (4 numbers)
First Name Up to 10 letters
Last Name Up to 10 letters
Grade NN.N (Grade percentage: e.g.,84.8. Round up when doing calculations.)
Degree Either MSIT or MSCM
Your program will use a console/command linebased user interface, not a graphical user interface.
Your program will display readable results to the display.
You will write records to a file.
Your program will overwrite any output files.
Your program should exit gracefully.
Output files will be in the same format as the input file noted above.
Invalid records mean that all fields are not present, a grade in the file is above 100 or below 0, or the degree program is listed as something other than MSCM or MSIT.
Validate all user input.
You will comment your program.
Menu options
Your program must have a menu. The menu functionality is below:
Display average grade for all students
Display average grade for each program
Display highest grade record
Display lowest grade record
Display students in MSIT
Display students in MSCM
Display all students in sorted order by student ID
Display invalid records
Create new file with invalid records called BADRECORDS.TXT. Display a message that
says BADRECORDS.TXT has been created
Exit program
image text in transcribed

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

Data Access Patterns Database Interactions In Object Oriented Applications

Authors: Clifton Nock

1st Edition

0321555627, 978-0321555625

More Books

Students also viewed these Databases questions