Microsoft Teams Grades app calculator (for new teams)

readme.md

Microsoft Teams grades (app) calculator

Only works in broswer Run this in broswer console (ctrl + shift + i), make sure to go into your team -> Grades on the side bar

Paste below:

// Select all assignment rows
const assignmentRows = document.querySelectorAll('tr[data-type="assignmentRow"]');

// Initialize variables for total marks and obtained marks
let totalMarks = 0;
let obtainedMarks = 0;

// Loop through the assignment rows
assignmentRows.forEach(assignmentRow => {
    // Extract the marks from the last column (column-15__y-uzA)
    const marksElement = assignmentRow.querySelector('.column-15__y-uzA span');
    if (marksElement) {
        const [obtained, total] = marksElement.textContent.trim().split('/').map(Number);
        if (!isNaN(obtained) && !isNaN(total)) {
            totalMarks += total;
            obtainedMarks += obtained;
        }
    }
});

// Calculate the percentage if totalMarks is not zero
const percentage = totalMarks !== 0 ? (obtainedMarks / totalMarks) * 100 : 0;

// Define grade based on percentage
let grade = '';

if (percentage >= 90) {
    grade = 'A+';
} else if (percentage >= 85) {
    grade = 'A';
} else if (percentage >= 80) {
    grade = 'A-';
} else if (percentage >= 76) {
    grade = 'B+';
} else if (percentage >= 72) {
    grade = 'B';
} else if (percentage >= 68) {
    grade = 'B-';
} else if (percentage >= 64) {
    grade = 'C+';
} else if (percentage >= 60) {
    grade = 'C';
} else if (percentage >= 55) {
    grade = 'C-';
} else {
    grade = 'F'; // Below 55 is considered fail
}

// Define color based on grade
let color = '';
switch (grade) {
    case 'A+':
    case 'A':
    case 'A-':
        color = 'green';
        break;
    case 'B+':
    case 'B':
    case 'B-':
        color = 'yellow';
        break;
    case 'C+':
    case 'C':
    case 'C-':
        color = 'orange';
        break;
    default:
        color = 'red';
}

// Log the result with colored output
console.log(`Total Marks: ${totalMarks}\nObtained Marks: ${obtainedMarks}`);
console.log(`%cPercentage: %c${percentage.toFixed(2)}%`, `color: white`, `color: ${color}`);
console.log(`%cGrade: %c${grade}`, 'color: white', `color: ${color}`);

If it logs nothing (eg a 0), you need to select any of the elements (Ctrl + Shift + C) and click on a grade (eg a 20/20) Keep in mind, if you have many assignments, you may need to scroll down to load them into the DOM

ok