Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Average Grades and Payroll Information for Students, Cheat Sheet of MS Microsoft Excel skills

Academia SerrantMS Microsoft Excel skills

The average grades and payroll information for several students, including their names, practice grades, exam grades, final grades, and corresponding messages. Additionally, it includes details on their salaries, deductions, bonuses, and total payments.

Typology: Cheat Sheet

2021/2022

Uploaded on 11/20/2022

ruben_flores2
ruben_flores2 🇺🇸

6 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
PROMEDIO DE NOTAS POR ESTUDIANTE
NOMBRE
NOTAS DE PRACTICAS
NOTAS EXAMENES
P1 P2 P3 P4 EX1
JUAN 12 13 16 13 13.5 14
PEDRO 14 14 17 14 14.8 15
MARIA 15 15 15 13 14.5 16
ROBERTO 17 16 16 12 15.3 17
ESTEFANY 15 14 14 15 14.5 14
CLAUDIA 18 18 18 18 18.0 15
MARGOT 20 19 19 19 19.3 15
PILAR 15 20 12 13 15.0 17
CARLOS 16 16 11 18 15.3 18
ANGEL 13 15 16 14 14.5 13
MIN 13.5
MAX 19.3
PROMEDIO
PRACTICAS
pf3
pf4
pf5

Partial preview of the text

Download Average Grades and Payroll Information for Students and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity!

PROMEDIO DE NOTAS POR ESTUDIANTE

NOMBRE

NOTAS DE PRACTICAS NOTAS EXA

P1 P2 P3 P4 EX

JUAN 12 13 16 13 13.5 14

PEDRO 14 14 17 14 14.8 15

MARIA 15 15 15 13 14.5 16

ROBERTO 17 16 16 12 15.3 17

ESTEFANY 15 14 14 15 14.5 14

CLAUDIA 18 18 18 18 18.0 15

MARGOT 20 19 19 19 19.3 15

PILAR 15 20 12 13 15.0 17

CARLOS 16 16 11 18 15.3 18

ANGEL 13 15 16 14 14.5 13

MIN 13.

MAX 19.

PROMEDIO

PRACTICAS

OR ESTUDIANTE SI EN LA NOTA FINAL TIENE MENOS QUE 10,5, QUE SA

NOTAS EXAMENES

NOTA FINAL

EX2 EX3 MENSAJE

14 17 15.0 14.3 APROBADO

15 15 15.0 14.9 APROBADO

13 13 14.0 14.3 APROBADO

15 15 15.7 15.5 APROBADO

16 15 15.0 14.8 APROBADO

13 15 14.3 16.2 APROBADO

16 16 15.7 17.5 APROBADO

16 16 16.3 15.7 APROBADO

17 13 16.0 15.6 APROBADO

11 15 13.0 13.8 APROBADO

MAX 13.

MIN 16.

MEDIANA 15.

PROMEDIO

EXAMENES

PLANTILLA DE PAGOS SETIEMBRE 2022

APELLIDOS NOMBRE

SUELDO PARCIAL SEGURO DESCUENTO TOTAL BONIFICACION

CACERES JUAN S/. 12.00 40 S/. 480.00 52.8 S/. 427.20 5%

SANCHEZ PEDRO S/. 15.00 36 S/. 540.00 59.4 S/. 480.60 3%

HINOJOSA MARIA S/. 16.00 20 S/. 320.00 35.2 S/. 284.80 2%

CARREON ROBERTO S/. 18.00 35 S/. 630.00 69.3 S/. 560.70 3%

DELGADO ESTEFANY S/. 19.00 46 S/. 874.00 96.14 S/. 777.86 6%

TORRES CLAUDIA S/. 20.00 29 S/. 580.00 63.8 S/. 516.20 3%

PEÑA MARGOT S/. 25.00 25 S/. 625.00 68.75 S/. 556.25 3%

MAMANI PILAR S/. 12.00 33 S/. 396.00 43.56 S/. 352.44 4%

TELLO CARLOS S/. 15.00 38 S/. 570.00 62.7 S/. 507.30 4%

ZEA ANGEL S/. 16.00 30 S/. 480.00 52.8 S/. 427.20 3%

SUELDO_PARCIAL = PRECIO_HORAS * NUM_HORAS

SEGURO = SUELDO PARCIAL * 0.

DESCUENTO TOTAL = SUELDO_PARCIAL - SEGURO

BONIFICACION_TOTAL = BONIFICACION (%) * SUELDO DESCUENTO TOTAL

PRECIO

HORAS

NUMERO

HORAS

BONIFICACION TOTAL SUELDO TOTAL APELLIDOS Y NOMBRE

21.36 S/. 448.56 CACERES JUAN

14.42 S/. 495.02 SANCHEZ PEDRO

5.70 S/. 290.50 HINOJOSA MARIA

16.82 S/. 577.52 CARREON ROBERTO

46.67 S/. 824.53 DELGADO ESTEFANY

15.49 S/. 531.69 TORRES CLAUDIA

16.69 S/. 572.94 PEÑA MARGOT

14.10 S/. 366.54 MAMANI PILAR

20.29 S/. 527.59 TELLO CARLOS

12.82 S/. 440.02 ZEA ANGEL