Shell Programming and Scripting

Name	Exam1	Exam2	Exam3
Tom	23	12	30
Jack	30	35	38
Jane	31	25	19
Brian	38	38	40
Lisa	30	28	32
Nick	33	30	15
Karen	25	28	12

#BEGIN {printf "Name\tExam1\tExam2\tExam3\tTotal\tAverage\tGrade";}
{
sum=$2+$3+$4
grade = sum * 2.5
avg = grade / 3
		
        printf("%s%c%d%c%d%c", $0,OFS,sum,OFS,avg,OFS)
        if(avg>=90) {print "A"}
        else
                if((avg>=80)&&(avg<90)) {print "B"}
                else
                if((avg>=65)&&(avg<80)) {print "C"}
                        else
                if((avg>=50)&&(avg<65)) {print "D"}
                  else {print "F"}
}

#/bin/sh
echo "Name   Exam1   Exam2   Exam3  Total Average  Grade" > finalgrades.txt
awk -f 9.awk OFS='\t' grades.txt | sort -k6,6 -r > finalgrades.txt

#BEGIN {printf "Name\tExam1\tExam2\tExam3\tTotal\tAverage\tGrade";}
# skip the header line from the .txt file
FNR>1{
sum=$2+$3+$4
grade = sum * 2.5
avg = grade / 3

        printf("%s%c%d%c%d%c", $0,OFS,sum,OFS,avg,OFS)
        if(avg>=90) {print "A"}
        else
                if((avg>=80)&&(avg<90)) {print "B"}
                else
                if((avg>=65)&&(avg<80)) {print "C"}
                        else
                if((avg>=50)&&(avg<65)) {print "D"}
                  else {print "F"}
}