Grade calculations - История изменений

Breslav.ep: перевод

2025-10-17T13:53:18Z

перевод

← Предыдущая версия		Версия от 13:53, 17 октября 2025
Строка 1:		Строка 1:
	{{Managing grades}}		{{Managing grades}}
	~~A grade calculation is a formula used to determine grades~~, ~~based on other grade items~~. ~~Note that this is not the same as~~ [[~~Calculated_question_type~~\|~~Calculated question types~~]].		Расчет оценок — это формула, используемая для определения оценок на основе других элементов оценки. Обратите внимание, что это не то же самое, что [[Тип вопроса «вычисляемый»\|вычисляемый тип вопросов]].

	~~Grade calculations follow the pattern of formulas~~/~~functions in popular spreadsheet programs~~. ~~They start with an equal~~ (=) ~~sign~~, ~~and use common mathematical operators and functions to produce a single numerical output~~. ~~This output is then used as the computed value for the grade item you are editing~~.		Расчеты оценок выполняются по образцу формул/функций в популярных программах для работы с электронными таблицами. Они начинаются со знака равенства (=) и используют общие математические операторы и функции для получения единого числового результата. Этот результат затем используется в качестве вычисленного значения для элемента оценки, который вы редактируете.

			При расчете оценок в журнале оценок можно использовать условные операторы (IF), а также логические операторы (AND,OR) (MDL-64414).

	~~Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).~~
	==Настройка расчета оценки==		==Настройка расчета оценки==
	[[~~File~~:~~Edit Calculated Grade~~.~~png~~\|~~alt~~=\|~~thumb~~\|~~Edit calculation setting~~]]		[[Файл:Расчет оценок панель управления.jpg\|альт=Расчет оценок панель управления\|мини\|Панель управления расчетом оценок в отчете по оценкам.]]
	[[Image:newcalculationgrade.png\|thumb\|Example calculation]]		[[Image:newcalculationgrade.png\|thumb\|Example calculation]]


	Чтобы настроить расчет оценок:		Чтобы настроить расчет оценок:

	# Войдите в систему как преподаватель или другой пользователь, у которого есть разрешение на редактирование оценок		# Войдите в систему как преподаватель или другой пользователь, у которого есть разрешение на редактирование оценок.
	# Нажмите на ~~оценки~~ в ~~блоке администрирования курса~~		# Нажмите на пункт «Оценки» в горизонтальном меню или в боковом меню в разделе «Управление курсом».
	# Выберите ~~"Просмотр" > "Отчет об оценке"~~		# Выберите в выпадающем меню «Отчет по оценкам».
	# ~~Нажмите "Включить редактирование"~~; над оценками должна появиться панель ~~"Элементы управления"~~		# Включите режим редактирования; над оценками должна появиться панель «Управляющие элементы».
	# Нажмите на значок "Калькулятор" над элементом оценки или категорией, которую вы хотите отредактировать. Примечание: если вы этого не видите, значит, он должен быть включен в разделе "Администрирование сайта> Оценки> Настройки отчета> Отчет об оценке> Показывать расчеты"		# Нажмите на значок "Калькулятор" над элементом оценки или категорией, которую вы хотите отредактировать. Примечание: если вы этого не видите, значит, он должен быть включен в разделе "Администрирование сайта> Оценки> Настройки отчета> Отчет об оценке> Показывать расчеты"
	# Начинайте со знака равенства (=)		# Начинайте со знака равенства (=)
Строка 90:		Строка 90:
	Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs\|language pack]].		Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs\|language pack]].

	The [[~~Decimal separator\|~~decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).		The [[decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

	Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).		Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).

Breslav.ep: /* Assigning ID numbers */

2025-10-17T13:35:32Z

Assigning ID numbers

← Предыдущая версия		Версия от 13:35, 17 октября 2025
Строка 23:		Строка 23:
	# Click the "Save Changes" button		# Click the "Save Changes" button

	==~~Assigning ID numbers~~==		== Присвоение идентификационных номеров ==
	~~You can include the values of other grade items by using their ID number as references in your formulas~~. ~~The ID number must be surrounded by double square brackets~~, ~~for example if you have a grade item with~~ Quiz.3 ~~as ID number~~, ~~you can refer this item using~~ <nowiki>[[Quiz.3]]</nowiki> ~~in your calculation~~.		Вы можете включить значения других элементов оценки, используя их идентификационные номера в качестве ссылок в своих формулах. Идентификационный номер должен быть заключен в двойные квадратные скобки, например, если у вас есть элемент оценки с номером Quiz.3 в качестве идентификационного номера, вы можете указать этот элемент, используя <nowiki>[[Quiz.3]]</nowiki> в своих расчетах.

	~~Below the calculation field there is a list of your course grade categories and grade items~~. ~~Next to each item or category's total there is the ID number you can use in your calculation~~ (~~already surrounded with the required double square brackets~~).		Под полем расчета находится список категорий оценок за ваш курс и элементов оценки. Рядом с итогом по каждому элементу или категории указан идентификационный номер, который вы можете использовать при расчете (он уже заключен в обязательные двойные квадратные скобки).

	~~However~~, ~~since ID numbers are optional~~, ~~some items may not yet have one~~. ~~Each item without ID number have a form field that you can use to enter its ID number directly~~. ~~As soon as you have assigned the ID numbers you need~~, ~~you must click the~~ "~~Add ID numbers~~" ~~button~~; ~~the page will reload and show you the same list including the ID numbers you have just assigned~~. ~~Now you can use them in your grade calculation~~.		Однако, поскольку идентификационные номера необязательны, у некоторых товаров их может еще не быть. У каждого товара без идентификационного номера есть поле формы, которое вы можете использовать для непосредственного ввода его идентификационного номера. Как только вы присвоите необходимые идентификационные номера, вы должны нажать кнопку "Добавить идентификационные номера"; страница перезагрузится и покажет вам тот же список, включающий только что присвоенные идентификационные номера. Теперь вы можете использовать их при расчете оценок.

			"Примечание": Moodle не допускает расчетов без использования идентификационных номеров.

	~~'''Note''': Moodle does not allow calculations involving no ID numbers.~~
	==Calculation functions==		==Calculation functions==
	Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.		Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.

Breslav.ep: /* Setting a grade calculation */

2025-10-17T13:34:56Z

Setting a grade calculation

← Предыдущая версия		Версия от 13:34, 17 октября 2025
Строка 5:		Строка 5:

	Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).		Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).
	==~~Setting a grade calculation~~==		==Настройка расчета оценки==
	[[File:Edit Calculated Grade.png\|alt=\|thumb\|Edit calculation setting]]		[[File:Edit Calculated Grade.png\|alt=\|thumb\|Edit calculation setting]]
	[[Image:newcalculationgrade.png\|thumb\|Example calculation]]		[[Image:newcalculationgrade.png\|thumb\|Example calculation]]


	~~To set a grade calculation~~:		Чтобы настроить расчет оценок:

	# ~~Login as teacher or other user with permission to edit grades~~		# Войдите в систему как преподаватель или другой пользователь, у которого есть разрешение на редактирование оценок
	# ~~Click on Grades in the course administration block~~		# Нажмите на оценки в блоке администрирования курса
	# ~~Click 'View~~ > ~~Grader Report'~~		# Выберите "Просмотр" > "Отчет об оценке"
	# ~~Click 'Turn Editing On'~~; ~~a 'Controls' bar should appear above the grades~~		# Нажмите "Включить редактирование"; над оценками должна появиться панель "Элементы управления"
	# ~~Click the 'Calculator' icon above the grade item or category you wish to edit~~. ~~Note~~: ~~if you don't see this~~, ~~then it must be enabled in ''Site administration~~>~~Grades~~>~~Report settings~~>~~Grader report~~>~~Show calculations''~~		# Нажмите на значок "Калькулятор" над элементом оценки или категорией, которую вы хотите отредактировать. Примечание: если вы этого не видите, значит, он должен быть включен в разделе "Администрирование сайта> Оценки> Настройки отчета> Отчет об оценке> Показывать расчеты"
	# ~~Start with an equal sign~~ (=)		# Начинайте со знака равенства (=)
	# ~~Type an expression using numbers~~, ~~arithmetic operators~~, ~~mathematical functions and ID numbers~~; ~~for example~~ =average()		# Введите выражение, используя числа, арифметические операторы, математические функции и идентификационные номера; например, =average()
	# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>		# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>
	# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)		# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)

Олег Давидович: 1 версия импортирована

2024-10-18T06:54:54Z

1 версия импортирована

← Предыдущая версия	Версия от 06:54, 18 октября 2024
(нет различий)

Олег Давидович: 1 версия импортирована

2024-10-14T18:17:58Z

1 версия импортирована

← Предыдущая версия		Версия от 18:17, 14 октября 2024
Строка 1:		Строка 1:
	#~~REDIRECT~~ [[~~Grade~~ calculations]]		{{Managing grades}}
			A grade calculation is a formula used to determine grades, based on other grade items. Note that this is not the same as [[Calculated_question_type\|Calculated question types]].

			Grade calculations follow the pattern of formulas/functions in popular spreadsheet programs. They start with an equal (=) sign, and use common mathematical operators and functions to produce a single numerical output. This output is then used as the computed value for the grade item you are editing.

			Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).
			==Setting a grade calculation==
			[[File:Edit Calculated Grade.png\|alt=\|thumb\|Edit calculation setting]]
			[[Image:newcalculationgrade.png\|thumb\|Example calculation]]


			To set a grade calculation:

			# Login as teacher or other user with permission to edit grades
			# Click on Grades in the course administration block
			# Click 'View > Grader Report'
			# Click 'Turn Editing On'; a 'Controls' bar should appear above the grades
			# Click the 'Calculator' icon above the grade item or category you wish to edit. Note: if you don't see this, then it must be enabled in ''Site administration>Grades>Report settings>Grader report>Show calculations''
			# Start with an equal sign (=)
			# Type an expression using numbers, arithmetic operators, mathematical functions and ID numbers; for example =average()
			# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>
			# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)
			# Click the "Save Changes" button

			==Assigning ID numbers==
			You can include the values of other grade items by using their ID number as references in your formulas. The ID number must be surrounded by double square brackets, for example if you have a grade item with Quiz.3 as ID number, you can refer this item using <nowiki>[[Quiz.3]]</nowiki> in your calculation.

			Below the calculation field there is a list of your course grade categories and grade items. Next to each item or category's total there is the ID number you can use in your calculation (already surrounded with the required double square brackets).

			However, since ID numbers are optional, some items may not yet have one. Each item without ID number have a form field that you can use to enter its ID number directly. As soon as you have assigned the ID numbers you need, you must click the "Add ID numbers" button; the page will reload and show you the same list including the ID numbers you have just assigned. Now you can use them in your grade calculation.

			'''Note''': Moodle does not allow calculations involving no ID numbers.
			==Calculation functions==
			Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.
			All common arithmetic operators are supported
			* addition, using the plus (+) sign
			* subtraction, using the minus (-) sign
			* multiplication, using the asterisk (*) character
			* division, using the slash (/) character
			* exponentiation, using the caret (^) character
			with their usual evaluation precedence rules: exponentiations are evaluated first, then multiplications and divisions are performed, finally additions and subtraction are carried out; so, the expression =1+2-34/5^6 gives almost 3 (2,999232). Different precedences can be forced using round parentheses, as in the expression =((((1+2)-3)4)/5)^6 which yields 0.

			Functions can also appear in expressions, using a separator between their arguments listed within round brackets.
			<div class="alert alert-danger">Important:
			<ul><li>For the English language pack this separator is a comma (,).</li>
			<li>For other [[Language\|languages]] the separator could be a different character, for example a semicolon (;).</li></ul></div>
			* average<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the average of the values in a list of arguments
			* ceil(number): Maps a real number to the smallest following integer
			* floor(number): Maps a real number to the largest previous integer
			* if<nowiki>([[item1]], [[item2]], [[item3]]):</nowiki> Evaluates the first argument (condition) and returns the second argument if the condition is not zero (true condition) and returns the third argument if the condition is zero (false condition).
			* max<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the maximum value in a list of arguments
			* min<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the minimum value in a list of arguments
			* mod(dividend, divisor): Calculates the remainder of a division
			* pi(): Returns the value of the number Pi (3.14159265...)
			* power(base, exponent): Raises a number to the exponent power (this is the same as base^exponent)
			* round(number, count): Rounds number to count decimal digits
			* sum<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the sum of all arguments (this is the same as <nowiki>[[item1]]+[[item2]]+...</nowiki>
			Many other mathematical functions are also supported:
			* sin()
			* sinh()
			* arcsin()
			* asin()
			* arcsinh()
			* asinh()
			* cos()
			* cosh()
			* arccos()
			* acos()
			* arccosh()
			* acosh()
			* tan()
			* tanh()
			* arctan()
			* atan()
			* arctanh()
			* atanh()
			* sqrt()
			* abs()
			* ln()
			* log()
			* exp()
			==Example calculations==
			* <nowiki>=max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]])</nowiki> - Returns the maximum value of the grades referred by Quiz.1, Quiz.4 and Assignment.1
			* <nowiki>=average(max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]), min([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]))</nowiki> - Returns the average of the maximum and the minimum values among Quiz.1, Quiz.4 and Assignment.1 (functions can be nested)
			* <nowiki>=sum([[item1]]0.3, [[item2]]0.6, [[item3]]*2)</nowiki> - Returns a weighted grade sum where item1 is weighted 30%, item2 is weighted at 60% and item3 is weighted at 200%
			* <nowiki>=if([[midtermexam]]>=5, [[midtermexam]]+[[lab]], 0)</nowiki> - Returns the sum of midtermexam and lab items if the midtermexam grade is 5 of more, and 0 otherwise. This is a very handy way of dealing with conditional evaluation in a course.
			* <nowiki>=if(AND([[item1]]>=5, [[item2]]>=5), ([[item1]]+[[item2]])/2, 0)</nowiki> - Returns the average of item1 and item2 if both have 5 of more, and 0 otherwise. This is a very handy way of dealing with sine qua non activities.
			==Calculations when user language is not English==
			Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs\|language pack]].

			The [[Decimal separator\|decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

			Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).
			==See also==
			*[http://www.youtube.com/watch?v=WKUGyzAXcyA Video on how to set up calculations in the gradebook (basic)]
			*[http://www.youtube.com/watch?v=VBEj8mmu8lM Video on how to set up calculations in the gradebook (advanced)]
			[[ca:grade/edit/tree/calculation]]
			[[es:Cálculos de calificación]]
			[[fr:Calcul de note]]
			[[ru:Формулы и вычисления оценок]]
			[[ja:評定計算]]
			[[de:Bewertungen berechnen]]

1>Tim@horizoneducationnetwork.org: Case sensitive redirect

2023-03-02T16:47:06Z

Case sensitive redirect

← Предыдущая версия		Версия от 16:47, 2 марта 2023
Строка 1:		Строка 1:
	~~{{Managing grades}}~~		#REDIRECT [[Grade calculations]]
	~~A grade calculation is a formula used to determine grades, based on other grade items. Note that this is not the same as [[Calculated_question_type\|Calculated question types]].~~

	Grade calculations follow the pattern of formulas/functions in popular spreadsheet programs. They start with an equal (=) sign, and use common mathematical operators and functions to produce a single numerical output. This output is then used as the computed value for the grade item you are editing.

	~~Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).~~
	~~==Setting a grade calculation==~~
	[[~~File:Edit Calculated~~ Grade~~.png\|alt=\|thumb\|Edit calculation setting]]~~
	~~[[Image:newcalculationgrade.png\|thumb\|Example calculation]]~~


	~~To set a grade calculation:~~

	~~# Login as teacher or other user with permission to edit grades~~
	~~# Click on Grades in the course administration block~~
	~~# Click 'View > Grader Report'~~
	~~# Click 'Turn Editing On'; a 'Controls' bar should appear above the grades~~
	# Click the 'Calculator' icon above the grade item or category you wish to edit. Note: if you don't see this, then it must be enabled in ''Site administration>Grades>Report settings>Grader report>Show calculations''
	~~# Start with an equal sign (=)~~
	~~# Type an expression using numbers, arithmetic operators, mathematical functions and ID numbers; for example =average()~~
	~~# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>~~
	~~# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)~~
	~~# Click the "Save Changes" button~~

	~~==Assigning ID numbers==~~
	You can include the values of other grade items by using their ID number as references in your formulas. The ID number must be surrounded by double square brackets, for example if you have a grade item with Quiz.3 as ID number, you can refer this item using <nowiki>[[Quiz.3]]</nowiki> in your calculation.

	Below the calculation field there is a list of your course grade categories and grade items. Next to each item or category's total there is the ID number you can use in your calculation (already surrounded with the required double square brackets).

	However, since ID numbers are optional, some items may not yet have one. Each item without ID number have a form field that you can use to enter its ID number directly. As soon as you have assigned the ID numbers you need, you must click the "Add ID numbers" button; the page will reload and show you the same list including the ID numbers you have just assigned. Now you can use them in your grade calculation.

	~~'''Note''': Moodle does not allow calculations involving no ID numbers.~~
	~~==Calculation functions==~~
	~~Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.~~
	~~All common arithmetic operators are supported~~
	* addition, using the plus (+) sign
	* subtraction, using the minus (-) sign
	* multiplication, using the asterisk (*) character
	* division, using the slash (/) character
	* exponentiation, using the caret (^) character
	with their usual evaluation precedence rules: exponentiations are evaluated first, then multiplications and divisions are performed, finally additions and subtraction are carried out; so, the expression =1+2-34/5^6 gives almost 3 (2,999232). Different precedences can be forced using round parentheses, as in the expression =((((1+2)-3)4)/5)^6 which yields 0.

	~~Functions can also appear in expressions, using a separator between their arguments listed within round brackets.~~
	~~<div class="alert alert-danger">Important:~~
	~~<ul><li>For the English language pack this separator is a comma (,).</li>~~
	~~<li>For other [[Language\|languages]] the separator could be a different character, for example a semicolon (;).</li></ul></div>~~
	* average<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the average of the values in a list of arguments
	* ceil(number): Maps a real number to the smallest following integer
	* floor(number): Maps a real number to the largest previous integer
	* if<nowiki>([[item1]], [[item2]], [[item3]]):</nowiki> Evaluates the first argument (condition) and returns the second argument if the condition is not zero (true condition) and returns the third argument if the condition is zero (false condition).
	* max<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the maximum value in a list of arguments
	* min<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the minimum value in a list of arguments
	* mod(dividend, divisor): Calculates the remainder of a division
	* pi(): Returns the value of the number Pi (3.14159265...)
	* power(base, exponent): Raises a number to the exponent power (this is the same as base^exponent)
	* round(number, count): Rounds number to count decimal digits
	* sum<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the sum of all arguments (this is the same as <nowiki>[[item1]]+[[item2]]+...</nowiki>
	~~Many other mathematical functions are also supported:~~
	* sin()
	* sinh()
	* arcsin()
	* asin()
	* arcsinh()
	* asinh()
	* cos()
	* cosh()
	* arccos()
	* acos()
	* arccosh()
	* acosh()
	* tan()
	* tanh()
	* arctan()
	* atan()
	* arctanh()
	* atanh()
	* sqrt()
	* abs()
	* ln()
	* log()
	* exp()
	~~==Example~~ calculations==
	* <nowiki>=max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]])</nowiki> - Returns the maximum value of the grades referred by Quiz.1, Quiz.4 and Assignment.1
	* <nowiki>=average(max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]), min([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]))</nowiki> - Returns the average of the maximum and the minimum values among Quiz.1, Quiz.4 and Assignment.1 (functions can be nested)
	* <nowiki>=sum([[item1]]0.3, [[item2]]0.6, [[item3]]*2)</nowiki> - Returns a weighted grade sum where item1 is weighted 30%, item2 is weighted at 60% and item3 is weighted at 200%
	* <nowiki>=if([[midtermexam]]>=5, [[midtermexam]]+[[lab]], 0)</nowiki> - Returns the sum of midtermexam and lab items if the midtermexam grade is 5 of more, and 0 otherwise. This is a very handy way of dealing with conditional evaluation in a course.
	* <nowiki>=if(AND([[item1]]>=5, [[item2]]>=5), ([[item1]]+[[item2]])/2, 0)</nowiki> - Returns the average of item1 and item2 if both have 5 of more, and 0 otherwise. This is a very handy way of dealing with sine qua non activities.
	~~==Calculations when user language is not English==~~
	~~Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs\|language pack]].~~

	The [[Decimal separator\|decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

	~~Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).~~
	~~==See also==~~
	*[http://www.youtube.com/watch?v=WKUGyzAXcyA Video on how to set up calculations in the gradebook (basic)]
	*[http://www.youtube.com/watch?v=VBEj8mmu8lM Video on how to set up calculations in the gradebook (advanced)]
	~~[[ca:grade/edit/tree/calculation]]~~
	~~[[es:Cálculos de calificación]]~~
	~~[[fr:Calcul de note]]~~
	~~[[ru:Формулы и вычисления оценок]]~~
	~~[[ja:評定計算]]~~
	~~[[de:Bewertungen berechnen~~]]

1>Jonwitts: /* Setting a grade calculation */

2021-12-03T11:58:27Z

Setting a grade calculation

Новая страница

{{Managing grades}}
A grade calculation is a formula used to determine grades, based on other grade items. Note that this is not the same as [[Calculated_question_type|Calculated question types]].

Grade calculations follow the pattern of formulas/functions in popular spreadsheet programs. They start with an equal (=) sign, and use common mathematical operators and functions to produce a single numerical output. This output is then used as the computed value for the grade item you are editing.

Conditional (IF) operators can be used in grade calculations of the grade book, and logical operators (AND,OR) can be also used (MDL-64414).
==Setting a grade calculation==
[[File:Edit Calculated Grade.png|alt=|thumb|Edit calculation setting]]
[[Image:newcalculationgrade.png|thumb|Example calculation]]

To set a grade calculation:

# Login as teacher or other user with permission to edit grades
# Click on Grades in the course administration block
# Click 'View > Grader Report'
# Click 'Turn Editing On'; a 'Controls' bar should appear above the grades
# Click the 'Calculator' icon above the grade item or category you wish to edit. Note: if you don't see this, then it must be enabled in ''Site administration>Grades>Report settings>Grader report>Show calculations''
# Start with an equal sign (=)
# Type an expression using numbers, arithmetic operators, mathematical functions and ID numbers; for example =average()
# Plug in your ID numbers (see below) enclosed in double square brackets, for example =<nowiki>[[item1]]</nowiki>+<nowiki>[[item2]]</nowiki>
# Separate each function argument with a comma, as in =average(<nowiki>[[item1]]</nowiki>, <nowiki>[[item2]]</nowiki>)+<nowiki>[[item3]]</nowiki>)
# Click the "Save Changes" button

==Assigning ID numbers==
You can include the values of other grade items by using their ID number as references in your formulas. The ID number must be surrounded by double square brackets, for example if you have a grade item with Quiz.3 as ID number, you can refer this item using <nowiki>[[Quiz.3]]</nowiki> in your calculation.

Below the calculation field there is a list of your course grade categories and grade items. Next to each item or category's total there is the ID number you can use in your calculation (already surrounded with the required double square brackets).

However, since ID numbers are optional, some items may not yet have one. Each item without ID number have a form field that you can use to enter its ID number directly. As soon as you have assigned the ID numbers you need, you must click the "Add ID numbers" button; the page will reload and show you the same list including the ID numbers you have just assigned. Now you can use them in your grade calculation.

'''Note''': Moodle does not allow calculations involving no ID numbers.
==Calculation functions==
Every grade calculation must start with an equal sign (=) followed by an expression using operators and functions supported by the system.
All common arithmetic operators are supported
* addition, using the plus (+) sign
* subtraction, using the minus (-) sign
* multiplication, using the asterisk (*) character
* division, using the slash (/) character
* exponentiation, using the caret (^) character
with their usual evaluation precedence rules: exponentiations are evaluated first, then multiplications and divisions are performed, finally additions and subtraction are carried out; so, the expression =1+2-3*4/5^6 gives almost 3 (2,999232). Different precedences can be forced using round parentheses, as in the expression =((((1+2)-3)*4)/5)^6 which yields 0.

Functions can also appear in expressions, using a separator between their arguments listed within round brackets.
<div class="alert alert-danger">Important:
<ul><li>For the English language pack this separator is a comma (,).</li>
<li>For other [[Language|languages]] the separator could be a different character, for example a semicolon (;).</li></ul></div>
* average<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the average of the values in a list of arguments
* ceil(number): Maps a real number to the smallest following integer
* floor(number): Maps a real number to the largest previous integer
* if<nowiki>([[item1]], [[item2]], [[item3]]):</nowiki> Evaluates the first argument (condition) and returns the second argument if the condition is not zero (true condition) and returns the third argument if the condition is zero (false condition).
* max<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the maximum value in a list of arguments
* min<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the minimum value in a list of arguments
* mod(dividend, divisor): Calculates the remainder of a division
* pi(): Returns the value of the number Pi (3.14159265...)
* power(base, exponent): Raises a number to the exponent power (this is the same as base^exponent)
* round(number, count): Rounds number to count decimal digits
* sum<nowiki>([[item1]], [[item2]]...)</nowiki>: Returns the sum of all arguments (this is the same as <nowiki>[[item1]]+[[item2]]+...</nowiki>
Many other mathematical functions are also supported:
* sin()
* sinh()
* arcsin()
* asin()
* arcsinh()
* asinh()
* cos()
* cosh()
* arccos()
* acos()
* arccosh()
* acosh()
* tan()
* tanh()
* arctan()
* atan()
* arctanh()
* atanh()
* sqrt()
* abs()
* ln()
* log()
* exp()
==Example calculations==
* <nowiki>=max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]])</nowiki> - Returns the maximum value of the grades referred by Quiz.1, Quiz.4 and Assignment.1
* <nowiki>=average(max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]), min([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]))</nowiki> - Returns the average of the maximum and the minimum values among Quiz.1, Quiz.4 and Assignment.1 (functions can be nested)
* <nowiki>=sum([[item1]]*0.3, [[item2]]*0.6, [[item3]]*2)</nowiki> - Returns a weighted grade sum where item1 is weighted 30%, item2 is weighted at 60% and item3 is weighted at 200%
* <nowiki>=if([[midtermexam]]>=5, [[midtermexam]]+[[lab]], 0)</nowiki> - Returns the sum of midtermexam and lab items if the midtermexam grade is 5 of more, and 0 otherwise. This is a very handy way of dealing with conditional evaluation in a course.
* <nowiki>=if(AND([[item1]]>=5, [[item2]]>=5), ([[item1]]+[[item2]])/2, 0)</nowiki> - Returns the average of item1 and item2 if both have 5 of more, and 0 otherwise. This is a very handy way of dealing with sine qua non activities.
==Calculations when user language is not English==
Calculations and formulas use decimal and list separators as defined in the [https://docs.moodle.org/dev/Translation_langconfig langconfig.php] file of each [[Language packs|language pack]].

The [[Decimal separator|decimal separator]] (the symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

Analogously, the list separator (the symbol used to separate the items within a list, such as the arguments of a function) is a comma (,) in English. In other languages it may be a semicolon (;).
==See also==
*[http://www.youtube.com/watch?v=WKUGyzAXcyA Video on how to set up calculations in the gradebook (basic)]
*[http://www.youtube.com/watch?v=VBEj8mmu8lM Video on how to set up calculations in the gradebook (advanced)]
[[ca:grade/edit/tree/calculation]]
[[es:Cálculos de calificación]]
[[fr:Calcul de note]]
[[ru:Формулы и вычисления оценок]]
[[ja:評定計算]]
[[de:Bewertungen berechnen]]