HOW TO COMPUTE GRADES IN MS EXCEL (DepEd) - A Tutorial

A short video tutorial on how to compute grades using MS Excel using different formulas (for total scores, percentages, raw grade, transmuted grade and rank).

Submitted by: TRISHA MAE D. CHU
Educ1B | PCK2

[mattheweppley]

This worked PERFECTLY for me!! Thank you very much. This was amazing. :-)

[allaboutschool]

NICE TUTORIAL MAM TRISHA MAE....GODbless You!

[altheaartieda]

Thank you so much ma'am.This was a great help for me.God bless you❤️

[giemar]

Thank you Ma'am. Nalilito ako sa LOOKUP

[marvinmanayaga]

Thnk you for this wonderful toturial...God bless

[trishamaechu]

Hi, to all those who are having a problem with regards to the formula for transmuted grade, try to change semi-colon ; into comma, 😊 Thank you!

[johndenn-jeoc]

TenkU po na kahit bata pa lang po ako alam kona mag compute ng grade dream ko kasi is teacher tenkU very very much

[tere]

Thank you so much 💗. I've learned a lot.

[itsjiamaecullen]

thank u so much po❤️ just finished my assignment in comp1 ❤️❤️

[robertoadalla]

Hello, ma'am! Is the Transmutation values indicated on Sheet 2 constant? Where can we get it?

[Crimilion]

Where the transmuted sheet 2 came from?

[renrenvillarante]

Where do you get the numbers in sheet 2 ?

[rebeccabravo]

Where did you get the formulas from? A book?

[josephsalazar]

how about the 40%-40%-20% how do we get that?

[zahra]

can you explne to me why are you using colon for performance task?

[lorenzodatulayta]

paano nyo po ginawa ang layout ? wala po bang tutorial nyan?

[jemarcobriz]

Hello po, ask ko lng po kung pano po kau nsg gagrade sa mga recitation ng students?😅

[beverlynoates]

sir meron po ba kayong excel file for college thanku po

[honeybee]

How to create sheet 2 po? kusa po ba sya mag aappear?

[jhodinevalenzuela]

May iba pa po bang ginawa to get the transmutted grade. Nageerror kasi ehehe. Thank you. Btw, this is so nice ♥️♥️♥️