29 Sep Most of the work is already done I just need help with making
Most of the work is already done I just need help with making the working storage section in the excel document and then finishing the hierarchy chart I've created. I'll also give my problem statement so you know what means what. Whoever reads this ty ty 🙂
HW #5
PROBLEM STATEMENT:
A computer program is required to compute individual and class scores of a project. Input will come from the keyboard and start with the cardinality of the report. Following this, the weights for each of the five components of the project. These components are:
· Problem Statement and I/O Design
· Walkthroughs
· Essential Model
· Implementation Model
· Code weight
Following this, detailed data for each student will be entered. This data consists of the student ID number followed by their percentage score for each of the five components.
For each student, the report must then display to the screen the student ID number, their weighted overall percentage score for the project, as well as the letter grade that corresponds to that percentage grade. The table below shows this relationship.
|
Cutoff Values |
Letter Grade |
|
0.0% |
F |
|
59.5% |
D |
|
69.5% |
C |
|
79.5% |
B |
|
89.5% |
A |
After the last student’s scores have been entered, a summary must display the class average. This average is calculated by taking the average of all the individual averages. In addition, the summary must display the student ID number of the student that had the highest project score, as well as what that score was. Also, it must display the student ID number of the student that had the lowest project score, as well as what that score was. In the event of multiple instances of the highest and lowest, only the first instance is to be reported.
INPUT/OUTPUT DESIGN:
Input:
nrStuds: number of students
psIOwt: problem statement and I/O design weight
wlkThruWt: walkthroughs weight
essenMdlWt: essential model weight
impMdlWt: implementation model weight
codeWt: code weight
studId: student number
psIOScr: problem statement and I/O design score
wlkThruScr: walkthroughs score
essenMdlScr: essential model score
impMdlScr: implementation model score
codeScr: code score
Output:
studId: student number
prcntGrd: weighted overall percentage score for the project
ltrGrd: letter grade
classAvg: class average
highScore: highest score
highStud: student number that achieved highest score
lowScore: lowest score
lowStud: student number that achieved lowest score
,
HLWT
| CIS 2110 Project 1 Walkthrough | ||||||||||||||||||||||||
| Exam Scores | ||||||||||||||||||||||||
| Inputs | Working Storeage | Outputs | ||||||||||||||||||||||
| nrStuds | psIOwt | wlkThruWt | essenMdlWt | impMdlWt | codeWt | studId | psIOScr | wlkThruScr | essenMdlScr | impMdlScr | codeScr | studId | prcntGrd | ltrGrd | classAvg | highScore | highStud | lowScore | lowStud | |||||
| 8 | 10% | 25% | 15% | 20% | 30% | |||||||||||||||||||
| 901 | 100% | 98% | 90% | 95% | 93% | 901 | 94.90% | A | ||||||||||||||||
| 902 | 98% | 90% | 100% | 92% | 92% | 902 | 93.30% | A | ||||||||||||||||
| 903 | 95% | 99% | 99% | 97% | 93% | 903 | 96.40% | A | ||||||||||||||||
| 904 | 100% | 86% | 84% | 93% | 80% | 904 | 86.70% | B | ||||||||||||||||
| 905 | 96% | 99% | 89% | 98% | 97% | 905 | 96.40% | A | ||||||||||||||||
| 906 | 80% | 76% | 70% | 94% | 100% | 906 | 86.30% | B | ||||||||||||||||
| 907 | 89% | 92% | 98% | 77% | 50% | 907 | 77.00% | C | ||||||||||||||||
| 908 | 92% | 95% | 97% | 80% | 45% | 908 | 77.00% | C | ||||||||||||||||
| 88.5% | 96.40% | 903 | 77.00% | 907 |
,
Exam Scores
Input, pslOwt wlkThruWt EssenMdlWt ImpMdlWt CodeWt
Outputs classAvg highScore highStud lowSco lowStud
Calc
Initialize
Process Scores
Output studId prcentGrd LtrGrd
Input studId pslOdcr wlkThruScr essenMdlScr impMdlScr codeScr
Accumulate
Update
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.