: I’m working on a business multi-part question and need an explanation and answer to help me learn

Learning Goal: I’m working on a python multi-part question and need an explanation and answer to help me learn.

Learning Goal: I’m working on a business multi-part question and need an explanation and answer to help me learn.

As I plan to provide the key that is needed for Program #3, I cannot accept programs past the last date indicated above.

Specifications for this program are in 2 files in the Canvas files folder titled “Programming assignment 2”

Upload two files: 1) your program with extension”.py” (I will not accept other types of files. 2) a WORD document showing the program execution output (if you get an error and cannot execute the program, please show me that execution with the error message for credit). Please, verify that your files upload correctly, I will not go out of my way to get readable files.

Program presentation. As a program correctly indented and well formed may get wrapping around when it is uploaded into Canvas, please verify that it is not the case for your program. If it is the case (more often for long statements), please correct your program accordingly.

The program execution output must also be well formatted for reability. Please label clearly the output of each question and separate them .

MIS 315 – Fall 2022. Programming Assignment #2.

Objectives: Functions, Lists, lists of lists
This program and the next program work together. I cannot accept assignments after
the deadline, as I will provide the key needed to work on programming assignment #3
Grading: 1. 10 2. 5 3. 10 (this is a B) 4. 5
1. QUESTION 1.Build a list of lists called studGrades, using the data in file
DATA_PROJ2.txt, shown in canvas files. For reference, I use the words “table”,
“row”, and “column” for the”2 dimensional” list studGrades.
Each row contains the data for one student, and it will be used to compute the final
letter grade of the student. Data of one row are the following
Column 0: unique student id (a number)
Col 1: “L” for the usual letter grading (A, B, …) , ”Cr” for Credit/noCr
Col 2: major – col 3: transfer student? -Col 4 -year
Col 5: gpa – col6 project 1 grade –Col 7 project 2 grade
Col 8: exam 1 grade – col 9: exam2 grade
To build the table studGrades in the Python program, copy and paste one row at a
time from the file DATA_PROJ2.txt into the table studGrades (again, “table” is not a
standard Python keyword, I use it to represent a list of lists or 2-dimensional list).
Insert commas and “[“ and “]” where needed to make studGrades a correct list of
lists (Murach top of page 179)
This table MUST be in main()
Print table studGrades, showing one row per line
2. QUESTION 2. Compute the average gpa. Compute how many students
have their gpa greater than the average gpa.
PRINT both results from main()

You must use a function for this question, besides main(). The table
studGrades must be a parameter of this function (not a global variable).Both
results must be returned to the calling program ( main()) using a “return” statement
and printed from main()
3.QUESTION 3. For each student, compute the final project grade based on
the combination of grades for project 1 (col 6) and grade for project 2 (col 7)
as follows (3 steps)
First step
newProj1grade = project1Weight*project1_grade
newProj2grade= project2Weight*project2_grade
Use : project1Weight = 2 project2Weight = 1.5 .Those are “global constants”
(Murach, page 114, 115, names of the constants should be in upper-case)
All rows have the same project1Weight. All rows have the same project2Weight
REMARK. I am not always respecting Python syntax and consistent in the
use of variable names in this text. The names I use are descriptive of the
data they hold, but you need to choose the variable names for your program
.Second step calculate:
projgrade = newProj1grade+ newProj2grade
Third, insert the value of projgrade at column 8 of studGrades for each row.
(note: insert, not append)
You must use a new function for this question
Print the following from main(): rows for student id 1111, 4555, 9500 with
columns 0, 6, 7, 8, 9, 10
4.QUESTION 4. For each student, compute the final exam grade based on
the combination of grades for exam1 (col 9) and grade for exam 2 (col 10) as
follows.
First, compute firstKmod as follows:
Kmod = 1.2 for juniors who are not transfer students (col 3), Is 1.4 for juniors who
are transfer from CC, is 1.5 for other juniors, is 2 for sophomores or seniors and
grading type “L” (col 1), 2.5 for sophomores with grading type Cr, 1 for all other
students
Then

newExam1grade = Exam1Weight*Exam1_grade
newExam2 grade= Exam2Weight*Kmod*Exam2_grade
All students have the same Exam1Weight = 3 (global constant)
All students have the same exam2Weight=5 (global constant
For each student, compute
examgrade = new Exam1grade+ new Exam2grade; append
Print the following from main(): rows for student id 1111, 4555, 9500 with
columns 0, 9, 10, 11
You must use a new function for this question.

WHAT YOU CAN EXPECT:

A high quality explanation and answer with in your time limit

Quick responsive communication

Original explanations and answers with any outside resources cited

(hidden)STUDENT”Grading” MAJOR Transfer YEAR GPA PROJ1 PROJ2 EXAM1 EXAM2

ID TYPE
1111, “L” , “ART” ,”CC” ,”Junior” ,3.5 , 7.8, 4.0, 2, 6
1256, “L” , “MIS” ,”No” ,”Soph” , 1.2 , 7.3, 9.5, 5, 10
1479, “Cr”, “ITA” ,”No” ,”Soph” , 4.0 , 8, 7.5, 8, 9
1888, “L” , “ITA” ,”UCI”,”Senior”, 2.1 , 9.5, 8, 9, 7
2221, “L” , “MIS” ,”No” ,”Junior” ,1.2 , 7.3, 10, 4, 7.5
2345, “L” , “ART” ,”No” ,”Senior” ,3.8 , 5.0, 4, 6, 4
3333, “Cr”, “ART” ,”CC” ,”OpenU” , 2.7 , 7.5, 0, 1, 6
3969, “Cr”, “ITA” ,”No” ,”Senior” ,2.1 , 9.5, 6, 7, 8
4000, “Cr”, “MIS” ,”No” ,”Senior” ,2.7 , 8, 10, 3, 4
4555, “Cr”, “MIS” ,”No” ,”Soph” ,1.4 , 8, 6, 2, 5
5100, “Cr”, “ITA” ,”CC” ,”Junior” ,2.1 , 9, 6.5, 4, 6
5600, “Cr”, “ART” ,”No” ,”OpenU” ,4.0, 8.5, 3, 10, 9
5700, “Cr”, “MIS” ,”No” ,”Senior” ,3.8 , 8, 3, 7, 2
5800, “L” , “ART” ,”CC” ,”Junior” ,2.7 , 10, 3, 6, 9
6000, “L” , “BUS” ,”No” ,”Senior” ,1.2 , 7.5, 6, 8, 5
6111, “L” , “MIS” ,”No” ,”Junior” ,1.4 , 7.3, 9.5, 8, 0
6666, “L” , “ITA” ,”CC” ,”Senior” ,1.4 , 8.5, 6.5, 9, 8
7000, “L” , “SPA” ,”No” ,”Soph” ,3.8 , 7.3, 9.5, 6, 8
7111, “L” , “ITA” ,”No” ,”Senior” ,2.1 , 7.5, 5.5, 4, 8
7800, “L” , “MIS” ,”No” ,”Junior” ,4.0 , 7.5, 9.5, 4, 7
7999, “L” , “ITA” ,”No” ,”Senior” ,2.7 , 7.5, 3, 7, 7
8000, “L” , “ART” ,”CC” ,”Soph” ,3.9 , 7.8, 5.5, 6, 6
8666, “Cr”, “MIS” ,”No” ,”Grad” ,3.9 , 7.8, 7.8, 6, 9
8700, “L” , “MIS” ,”No” ,”Senior” ,3.8 , 7.8, 7, 5, 2
8888, “L” , “MIS” ,”No” ,”Junior” ,2.1 , 8, 0, 7, 8
9000, “L” , “ART” ,”UCB”,”Senior” ,3.9 , 7, 6, 8, 7
9333, “L” , “MIS” ,”No” ,”Senior” ,0.5 , 0, 0, 9, 6
9500, “Cr”, “BUS” ,”No” ,”Junior” ,2, 5, 4, 8, 7
This table has 10 columns, numbered 0 to 9 (new columns will be added when
the program runs).
Columns are student id, grading type (letter or Cr/NoCr), major, year,
gpa,
project 1 grade, project 2 grade, exam 1 grade, exam 2 grade