Writing a shell script which takes input from a CSV file as an argument to calculate the minimum grade for the final in order to pass the subject:

Min final grade = (Passing grade * (Mid term weight + Final weight) - Mid term weight * Midterm) / Final weight

Output:

The output should produce the same CSV file as above plus a col for Min final grade for passing the course

\begin{tabular}{|r|r|r|r|} \hline Midterm & Midterm weight & Final weight & \multicolumn{2}{l|}{ Passing grade } \\ \hline 56 & 25 & 35 & 50 \\ \hline 34 & 30 & 30 & 50 \\ \hline 56 & 25 & 35 & 45 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline Midterm & Midterm weight & Final weight & Passing grade & Min final grade \\ \hline 56 & 25 & 35 & 50 & 46 \\ \hline 34 & 30 & 30 & 50 & 66 \\ \hline 56 & 25 & 35 & 45 & 37 \\ \hline \end{tabular}