moodle where in database are final course grades kept

by Okey Pollich DDS 5 min read

Where are grades posted on Moodle?

View Your Grades Log into Moodle and open the course. On the course homepage, in the Navigation tray toggle (hamburger menu , top left) click Grades. The User report page opens to show all graded activities where your grades have been released, as well as feedback from your instructor (if any).

How do you show final grades on Moodle?

The Course grade settings page will open. Scroll down the page, under the heading for User report, change the Hide totals if they contain hidden items drop-down menu to Show totals including hidden items to display the total grade including the values from the hidden grades.

How do I save grades in Moodle?

Go to Course administration > Gradebook setup. Select "Course grade settings" in the administration block. From the Grade display type menu, select real (for actual grades), percentage or letter, or a combination of these. Click the "Save changes" button.Dec 9, 2021

What is Moodle grade history?

What is Grade history? Accessed from Course administration > Grade administration > Grade history, the Grade history report allows teachers to select specific students, grade items and/or graders and view the grading history for certain dates.May 2, 2019

How do I unhide grades in Moodle?

To unhide, click Edit agian and click it's Show icon. To hide it until a certain date, click the Edit Settings icon for the category or item and continue to the next step.Dec 18, 2020

Why can't I see my grades on Moodle?

click on Settings > Edit Settings under the Course administration heading. within the Appearance section, select "Yes" from the pull-down menu next to "Show gradebook to students" scroll all the way to the bottom of the page and click the "Save changes" button.Jan 21, 2021

How do I make grades visible to students in Moodle?

On the Course Management panel, under Course Settings, select Edit course settings. Under the Appearance heading, from the Show gradebook to students drop-down menu, select Yes or No. Scroll down to the bottom of the page and click Save and display.

How do I hide grades from students in Moodle?

In the row for the grade item or category you wish to hide, under the Actions column, click Edit, a drop-down menu will appear. From the drop-down menu, select Hide. The grade item's color will be dimmed to indicate the item is now hidden.

How do I hide my grades?

Hide GradesOpen Grades. Under Course Navigation, select the Grades.Open Assignment Menu. Hover over the assignment column header and select the Options icon.Open Hide Grades Tray. Select Hide grades.Hide Grades. Select Hide.View Gradebook. [1] Assignments with hidden grades display the Visibility icon.Oct 21, 2019

How do I delete a grade item in Moodle?

Delete Grade Items & CategoriesSelect Course Management (black gear icon. ... On the Course Management panel, under Grade, select Gradebook Setup.Choose a manual grade item to delete.Under the Actions column for that item, click Edit and from the drop-down select. ... On the Delete confirmation page, click Yes.

How does Moodle grading work?

The Moodle Gradebook automatically aggregates scores and feedback from Assignments, Activities, and/or Manual grades from your Moodle course. Students can view their own grades in individualized reports which protect student privacy.

How do you manually change grades in Moodle?

Changing Grades Manually in Moodle Select the Course for the specific Grader Report. In the Course administration section, select Grades. In the Grade administration, select Grader report. With the editing turned on, the Grader report will have the option to change the individual grades for the students.Aug 16, 2021

Where are grades hidden in gradebook?

Grades and categories can be hidden in the gradebook or the "categories and items" screen. When a category is hidden all the grade items within it are automatically hidden as well. When a category is un-hidden then all the grade items within it are un-hidden.

What is grade_grab_legacy_grades?

Function grade_grab_legacy_grades ($courseid) may be used to request transfer of grades from legacy or 3rd party activities which were not yet converted to new grade API. This function is not called automatically.

What is a category in math?

A set of Grade Items. A Category also has its own aggregated Grade which is calculated from its Grade Items. There is no limit to the level of nesting of Categories (a Category may belong to another Category). However, each Grade Item may belong to only one Category.

What is gradebook?

The concept of meeting certain criteria for completing a course. In the context of the gradebook, this means a set of grades that must be reached, or a number of outcomes/competencies to complete/master. Grade. A Grade is a single assessment. It may be a number or an item on a scale (possibly tied to an Outcome).

Can you lock a grade in a gradebook?

Both whole columns and individual grades can be locked in the gradebook, via the locked field. Teachers may want to do this to prevent further changes from the modules, or from other teachers. When a grade is locked, any changes that might affect that grade are ignored. When the graded is unlocked, activities are asked to resend the latest grades.

What is outcome in a course?

Outcomes are specific descriptions of what a person is expected to be able to do or understand at the completion of an activity or course . An activity might have more than one outcome, and each may have a grade against it (usually on a scale). Other terms for Outcomes are Competencies and Goals.

What directory should an export plugin be in?

The API for these is extremely simple. Each export plugin should occupy a directory under /grade/export/xyz and needs to provide only an index.php file as a the primary interface. This file just accepts a 'courseid' parameter.

Introduction

The Grades link is sometimes referred to Gradebook. The two central ideas of grading are:

How Grades Get Into the Gradebook

When activity modules produce grades, they use the gradebook public API to push (or send) their grades to the gradebook. These grades are then stored in database tables that are independent of the modules. The grades are still kept in the module database tables, and the gradebook will never access or modify these original grades.

Settings affecting grades

Being the smallest unit in the gradebook, the grade is affected by many settings at different levels. Here is a list of these levels, in hierarchical order:

Outcomes

Outcomes are specific descriptions of what a student is expected to be able to do or understand at the completion of an activity or course. An activity might have more than one outcome, and each may have a grade against it (usually on a scale ).

Gradebook reports

The gradebook includes a variety of reports. Select the Grades link in each course administration block. The default report is the grader report and other reports are available by using the "Choose an action.." pulldown menu under View to find:

Grades organisation

Teachers may organise grades into grade categories, import and/or export grades, and make grade calculations .

Assignment Database Tables

I'm trying very hard to understand the relationship between the assignment related tables in Moodle and after I spent like 2 days to try and figure out how it's been designed I decided to ask the community in the hope that someone will reply.

Re: Assignment Database Tables

Why do you have to do it via the database - why can't you do it via the assignment itself? (Using the offline grading worksheet feature - see Assignment settings

Database Schema

The files available here are in DBDesigner4 format. DBDesigner4 is a schema drawing program released under GPL.

Moodle 3.8

Web view of the Moodle 3.8 schema which is also grouped into common used components.

Moodle 3.7

Web view of the Moodle 3.7 schema which is also grouped into common used components.

Moodle 3.6

Web view of the Moodle 3.6 schema which is also grouped into common used components.

Moodle 3.5

Web view of the Moodle 3.5 schema which is also grouped into common used components. .

Moodle 3.4

Web view of the Moodle 3.4 schema which is also grouped into common used components.

Moodle 3.3

Web view of the Moodle 3.3 schema which is also grouped into common used components.

Executive Summary

  • This document primarily describes the current workings of the gradebook. For more detailed information about current gradebook development see Gradebook_improvements The gradebook mechanisms must be rebuilt to: 1. Improve performance and scalability- All grades from throughout the system will be pushed to a central system of tables. This means reports based o…
See more on docs.moodle.org

Glossary

  • Here are some terms used in the gradebook, both in the development and the user interface. Using these terms in discussions about the gradebook will help to reduce confusion.
See more on docs.moodle.org

Database Structures

  • grade_items
    This table keeps information about gradeable items (ie columns). If an activity (eg an assignment or quiz) has multiple grade_items associated with it (eg several outcomes and numerical grade), then there will be a corresponding multiple number of rows in this table. idnumber is a tag uniqu…
  • grade_categories
    This table keeps information about categories, used for grouping items. An associated grade_item will be maintained for each category to store the aggregate data.
See more on docs.moodle.org

Overview of Module Communication

  • Modules usually store raw grades internally and pass them into gradebook every time they change. Gradebook may also request activities to resend the grades. The gradebook is designed to be as separate as possible from the code of activities - modules do not read grade tables or use internal gradebook API. Originally it was planned to use new events API, but in the end it wa…
See more on docs.moodle.org

API For Communication with Modules/Blocks

  • Modules may use only functions from lib/gradelib.php which are marked as public. This API may be extended in later 1.9.x release. Activities should access/update only own grades.
See more on docs.moodle.org

Private Gradebook API

  • Private API is used by gradebook plugins and core Moodle code, it may change in 2.0. Most of the interesting classes and functions are in lib/gradelib.php, grade/lib.php and grade/report/lib.php. The following 3 functions are all in /lib/gradelib.php
See more on docs.moodle.org

Dealing with Multiple Grades

  • Modules usually produce only one grade item per activity. Optionally one or more outcomes may be attached to activities. Some activities may need to aggregate multiple ratings or attempts before sending them into the gradebook. Activities can not send variable number of items. If the gradebook receives multiple grade items from a module, then they are automatically grouped to…
See more on docs.moodle.org

Calculated Grade Items

  • Categories or manual items maybe calculated using spreadsheet-like formulas. Formulas may reference other items from the same course only using Id numbers in double square brackets.
See more on docs.moodle.org

Adjustment of Raw Grades

  • Grade_item contains optional rules for adjusting the raw grade before it is cached into a final grade. These rules are processed BEFORE the calculation discussed above. Scale is never changed. Multfactor and plusfactor may be used to alter raw grades coming from activities, but it is recommended to use formulas instead.
See more on docs.moodle.org

Displaying The Grades to Ordinary Participants

  • The module takes responsibility for displaying grades within the module (to a student, say). It is recommended to use the real final grades obtained using grade_get_grades() functionBecause guidebook might force hiding, override grade, etc. For full display of grades in a whole course say, the student uses the same link as teachers use to access the gradebook. However, due to their …
See more on docs.moodle.org