REGISTRO DE NOTAS

GOBIERNO REGIONAL INKA ASIGNATURA

DIRECCION REGIONAL DE EDUCACION CUSCO

Educacion Fisica
Matematcas

Naturaleza y
comunidad
MINISTERIO DE EDUCACION

promedio
Naturales

Lenguaje
Ciencias
C.E.:________LA SALLE____________________
Dpto/Prov._____________________________
N° Apellidos y Nombres
1 LUQUE CUTIPA NELLY 17 10 7 15 9 11.6
2 ROJAS TORREZ DIANA 10 17 9 10 4 10
3 VALLE CUELLAR FLOR 9 17 10 16 7 11.8
4 MANRIQUE VILCA EDISON 8 15 3 14 17 11.4
5 CAPANA RODRIGUES GRACIELA 17 5 8 12 18 12
6 QUIAPE LINARES MARIA 11 9 14 10 16 12
7 ROJAS HERMOZA PERCY 17 8 15 14 8 12.4
8 QUISPE CALLAÑAUPA FLABIO 13 8 9 6 15 10.2
9 ESPERILLA FERNANDEZ VERONICA 13 19 14 18 14 15.6
10 RUBIO FIGUEREDO RENZO 3 7 15 14 15 10.8
11 LUQUE CUTIPA NELLY 13 11 10 14 7 11
12 ROJAS TORREZ DIANA 15 14 13 10 12 12.8
13 VALLE CUELLAR FLOR 13 16 9 14 8 12
14 MANRIQUE VILCA EDISON 10 6 9 5 3 6.6
15 CAPANA RODRIGUES GRACIELA 9 11 18 8 13 11.8
Promedio Global 11.46666667

LOGICO: FORMATO CONDICIONAL :

NOTAS >= 10.5 APROBADO NOTAS APROBADAS FUENTE : AZUL
NOTAS< 10.5 DESAPROBADO NOTAS DESAPROBADAS FUENTE ROJO
NOTAS<=7 REPROBADO
AÑO_________2018________
GRADO____5___________
SECCION _____A________

OBSERVACIONES
Aprobado
Desaprobado
Aprobado
Aprobado
Aprobado
Aprobado
Aprobado
Desaprobado
Aprobado
Aprobado
Aprobado
Aprobado
Aprobado
Reprobado
Aprobado
ELABORAR UN GRAFICO

Enero Febrero Marzo 6500

Manzana 5453 4600 6500
Uva 2510 3600 4800 4500

CANTIDAD DE FRUTA
Pera 2223 3222 5460
Palta 3500 2170 2654
2500

VENTA DE FRUTAS 500

7000
Manza na
6000 -1500
CANTIDAD DE FRUTAS

5000
4000
3000
2000
1000
0
Enero Febrero Marzo
MESES

Ma nzana Uva Pera Pa lta

 venta de frutas
6500

4500
CANTIDAD DE FRUTA

2500

500

Manza na Uva Pera Pal ta

-1500

TIPO DE FRUTA

Enero Febrero Ma rzo

 CATEGORIA SUELDO Nro MONTO
A 150 HIJOS
B 250 1 S/. 25.00
C 350 2 S/. 40.00
Más ò igual S/. 60.00
COSTO DE VIDA 10%
MOBILIDAD Y REFRIG. S/. 30.00 PARA TODOS

N° SUELDO
N° APELLIDOS Y NOMBRES CARGO CAT
HIJOS BASICO
1 LUQUE CUTIPA NELLY 2 OTROS B S/. 650.00
2 ROJAS TORREZ DIANA 1 OTROS A S/. 550.00
3 VALLE CUELLAR FLOR 0 FUNCIONARIO B S/. 950.00
4 MANRIQUE VILCA EDISON 3 OTROS C S/. 750.00
5 CAPANA RODRIGUES GRACIELA 2 FUNCIONARIO B S/. 650.00
6 QUIAPE LINARES MARIA 5 OTROS B S/. 550.00
7 ROJAS HERMOZA PERCY 1 FUNCIONARIO A S/. 850.00
8 QUISPE CALLAÑAUPA FLABIO 2 OTROS C S/. 750.00
9 ESPERILLA FERNANDEZ VERONICA 0 OTROS C S/. 750.00
10 RUBIO FIGUEREDO RENZO 3 FUNCIONARIO A S/. 850.00
 CARGO
FUNCIONARIO 80
OTROS 50

COSTO MOVILIDAD CARGA BONIFI. TOTAL

CATEGORIA ESSALUD.
VIDA REFR. FAMILIAR CARGO REMUNE.
S/. 250.00 S/. 65.00 S/. 30.00 S/. 40.00 S/. 50.00 S/. 1,085.00 S/. 21.70
S/. 150.00 S/. 55.00 S/. 30.00 S/. 25.00 S/. 50.00 S/. 860.00 S/. 17.20
S/. 250.00 S/. 95.00 S/. 30.00 S/. - S/. 80.00 S/. 1,405.00 S/. 28.10
S/. 350.00 S/. 75.00 S/. 30.00 S/. 60.00 S/. 50.00 S/. 1,315.00 S/. 26.30
S/. 250.00 S/. 65.00 S/. 30.00 S/. 40.00 S/. 80.00 S/. 1,115.00 S/. 22.30
S/. 250.00 S/. 55.00 S/. 30.00 S/. 60.00 S/. 50.00 S/. 995.00 S/. 19.90
S/. 150.00 S/. 85.00 S/. 30.00 S/. 25.00 S/. 80.00 S/. 1,220.00 S/. 24.40
S/. 350.00 S/. 75.00 S/. 30.00 S/. 40.00 S/. 50.00 S/. 1,295.00 S/. 25.90
S/. 350.00 S/. 75.00 S/. 30.00 S/. - S/. 50.00 S/. 1,255.00 S/. 25.10
S/. 150.00 S/. 85.00 S/. 30.00 S/. 60.00 S/. 80.00 S/. 1,255.00 S/. 25.10
 DESCUENTO
ESSALUD 2%
AFP 11%
SOLIDARIDAD 1%

DES. DESC. TOTAL NETO A

AFP SOLIDARI. DESC. PAGAR
S/. 119.35 S/. 10.85 S/. 151.90 S/. 933.10
S/. 94.60 S/. 8.60 S/. 120.40 S/. 739.60
S/. 154.55 S/. 14.05 S/. 196.70 S/. 1,208.30
S/. 144.65 S/. 13.15 S/. 184.10 S/. 1,130.90
S/. 122.65 S/. 11.15 S/. 156.10 S/. 958.90
S/. 109.45 S/. 9.95 S/. 139.30 S/. 855.70
S/. 134.20 S/. 12.20 S/. 170.80 S/. 1,049.20
S/. 142.45 S/. 12.95 S/. 181.30 S/. 1,113.70
S/. 138.05 S/. 12.55 S/. 175.70 S/. 1,079.30
S/. 138.05 S/. 12.55 S/. 175.70 S/. 1,079.30
 CUSTOMER FASHIONS
ALMACENES
ARTICULOS PRODUCCION LIMA SAN MIGUEL SURCO
50% 10% 40%
Polos 100,000.00 50,000.00 10,000.00 40,000.00
Camisas 150,000.00 75,000.00 15,000.00 60,000.00
Pantalones 350,000.00 175,000.00 35,000.00 140,000.00
Chompas 75,000.00 37,500.00 7,500.00 30,000.00
Sacos 50,000.00 25,000.00 5,000.00 20,000.00
 TIPO DE CAMBIO
LINEA DE BELLEZA 20% 28% 30% 31% 35%
JABONES ENERO FEBRERO MARZO ABRIL MAYO JUNIO

Camay 4,250.00 850.00 1,190.00 1,275.00 1,317.50 1,487.50

Nivea 3,125.00 625.00 875.00 937.50 968.75 1,093.75
Neko 2,145.00 429.00 600.60 643.50 664.95 750.75
Total 9,520.00 1,904.00 2,665.60 2,856.00 2,951.20 3,332.00
 2.75
TOTAL
SOLES DOLARES

10,370.00 3,770.91
7,625.00 2,772.73
5,233.80 1,903.20
23,228.80 8,446.84
a b c a&b a+b a-b a*b
4 1 20 41 5 3 4
8 3 30 83 11 5 24
6 4 15 64 10 2 24
2 5 18 25 7 -3 10
12 3 10 123 15 9 36
30 2 50 302 32 28 60
45 1 10 451 46 44 45
12 4 6 124 16 8 48
15 8 19 158 23 7 120
10 0 11 100 10 10 0
 5%
a/b a*5% (a+c)*b b*(c-a)
4 0.2 24 16
2.66666667 0.4 114 66
1.5 0.3 84 36
0.4 0.1 100 80
4 0.6 66 -6
15 1.5 160 40
45 2.25 55 -35
3 0.6 72 -24
1.875 0.75 272 32
#DIV/0! 0.5 0 0
ERROR