Unix with Perl scripting:

Generate a report containing the lowest, highest and average score for each assignment in the data file. The name of the assignment is located in column 3. Your report should be in a tabular format as shown in the sample below;

Name Low High Average Q06 77 95 86.80 L05 40 96 46.60 WS 5 5 5 Q07 58 100 78.80 L06 60 99 61 L07 77 86 64.80 H01 19 90 47.80 

data.csv below:

Student	Catehory	Assignment	Score	Possible
Chelsey	Homework	H01	90	100
Chelsey	Homework	H02	89	100
Chelsey	Lab	L01	91	100
Chelsey	Lab	L02	100	100
Chelsey	Quiz	Q01	100	100
Chelsey	Quiz	Q02	100	100
Chelsey	Final	FINAL	82	100
Sam	Homework	H06	97	100
Sam	Homework	H07	52	100
Sam	Lab	L06	0	100
Sam	Lab	L07	0	100
Sam	Quiz	Q06	95	100
Sam	Quiz	Q07	68	100
Sam	Final	FINAL	58	100
Andrew	Homework	H06	58	100
Andrew	Homework	H07	52	100
Andrew	Lab	L01	87	100
Andrew	Lab	L02	45	100
Andrew	Quiz	Q06	94	100
Andrew	Quiz	Q07	58	100
Andrew	Final	FINAL	99	100
Ava	Homework	H06	84	100
Ava	Homework	H07	55	100
Ava	Lab	L01	66	100
Ava	Lab	L02	77	100
Ava	Quiz	Q06	77	100
Ava	Quiz	Q07	88	100
Ava	Final	FINAL	99	100
Shane	Homework	H06	80	100
Shane	Homework	H07	90	100
Shane	Lab	L01	90	100
Shane	Lab	L02	0	100
Shane	Quiz	Q05	80	100
Shane	Quiz	Q06	80	100
Shane	Final	FINAL	90	100