excel alumnos

3

Upload: victorgonzaru

Post on 14-Apr-2016

5 views

Category:

Documents


0 download

DESCRIPTION

infor

TRANSCRIPT

ALUMNOSFECHA INICIO PRACTICAS

FECHA FIN DE PRACTICAS

PRUEBA 1 PRUEBA 2 PRUEBA 3 PRUEBA 4 PRUEBA 5ANTONIO =DATE(2015,7,31) =DATE(2016,6,1) 6 4 2 5 1

MANUELA =DATE(2015,7,6) =DATE(2016,6,3) 10 7 9 9 10

JUAN =DATE(2015,8,6) =DATE(2016,6,6) 8 2 9 2 10

FEDERICO =DATE(2015,7,14) =DATE(2016,6,10) 1 8 9 8 6

ANA =DATE(2015,7,26) =DATE(2016,7,16) 1 1 9 1 4

MODULO DE CALIFICACIONES

NOTA MEDIA POR ALUMNO APROBADO/SUSPENSO DIAS EN PRACTICAS=AVERAGE(D6:H6) =IF(I6<5, "SUSPENSO","APROBADO") =(C6-B6)

=AVERAGE(D7:H7) =IF(I7<5, "SUSPENSO","APROBADO") =(C7-B7)

=AVERAGE(D8:H8) =IF(I8<5, "SUSPENSO","APROBADO") =(C8-B8)

=AVERAGE(D9:H9) =IF(I9<5, "SUSPENSO","APROBADO") =(C9-B9)=AVERAGE(D10:H10) =IF(I10<5, "SUSPENSO","APROBADO") =(C10-B10)