excel alumnos
DESCRIPTION
inforTRANSCRIPT
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)