## invoke as script test.csv
sed -e 's/Strongly agree/1/g' -e 's/Agree/0.8/g' -e 's/Neutral/0.6/g' -e 's/Disagree/0.4/g' -e 's/Strongly disagree/0.2/g' $1 |
awk -F, '
{
	for(ii=1; ii <= 11; ++ii) {
		var[ii] += $ii;
	}
} END {
	for(ii=1; ii <= 6; ++ii) {
		instructor += var[ii];
	}
	instructor /= (6*NR);
	for(ii=7; ii <= 11; ++ii) {
		course += var[ii];
	}
	course /= (5*NR);
	print "Course = " course;
	print "Instructor = " instructor;
}'