<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
	<id>http://wiki.mipt.ru/index.php?action=history&amp;feed=atom&amp;title=Development%3ACompetencies</id>
	<title>Development:Competencies - История изменений</title>
	<link rel="self" type="application/atom+xml" href="http://wiki.mipt.ru/index.php?action=history&amp;feed=atom&amp;title=Development%3ACompetencies"/>
	<link rel="alternate" type="text/html" href="http://wiki.mipt.ru/index.php?title=Development:Competencies&amp;action=history"/>
	<updated>2026-05-06T23:35:58Z</updated>
	<subtitle>История изменений этой страницы в вики</subtitle>
	<generator>MediaWiki 1.42.1</generator>
	<entry>
		<id>http://wiki.mipt.ru/index.php?title=Development:Competencies&amp;diff=10942&amp;oldid=prev</id>
		<title>Олег Давидович: 1 версия импортирована</title>
		<link rel="alternate" type="text/html" href="http://wiki.mipt.ru/index.php?title=Development:Competencies&amp;diff=10942&amp;oldid=prev"/>
		<updated>2024-10-21T08:51:06Z</updated>

		<summary type="html">&lt;p&gt;1 версия импортирована&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;ru&quot;&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Предыдущая версия&lt;/td&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Версия от 08:51, 21 октября 2024&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-notice&quot; lang=&quot;ru&quot;&gt;&lt;div class=&quot;mw-diff-empty&quot;&gt;(нет различий)&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</summary>
		<author><name>Олег Давидович</name></author>
	</entry>
	<entry>
		<id>http://wiki.mipt.ru/index.php?title=Development:Competencies&amp;diff=10941&amp;oldid=prev</id>
		<title>1&gt;Janvh: /* &quot;Add / edit competency depth&quot; admin page */</title>
		<link rel="alternate" type="text/html" href="http://wiki.mipt.ru/index.php?title=Development:Competencies&amp;diff=10941&amp;oldid=prev"/>
		<updated>2010-11-25T19:22:14Z</updated>

		<summary type="html">&lt;p&gt;&lt;span dir=&quot;auto&quot;&gt;&lt;span class=&quot;autocomment&quot;&gt;&amp;quot;Add / edit competency depth&amp;quot; admin page&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;{{Moodle 2.0}}&amp;lt;p class=&amp;quot;note&amp;quot;&amp;gt;&amp;#039;&amp;#039;&amp;#039;Note&amp;#039;&amp;#039;&amp;#039;: This page outlines ideas for the Competencies feature planned for Moodle 2.0. It&amp;#039;s a &amp;#039;&amp;#039;specification under construction&amp;#039;&amp;#039;! If you have any comments or suggestions, please add them to the [[Development talk:Progress tracking|page comments]].&amp;#039;&amp;#039;&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;PROJECT STATE: Proposal&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;MAIN TRACKER ISSUE&amp;#039;&amp;#039;&amp;#039;: &lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;DISCUSSION&amp;#039;&amp;#039;&amp;#039;: Not yet announced on Moodle.org&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;COMMENTS&amp;#039;&amp;#039;&amp;#039;: [[Development_talk:Competencies]]&lt;br /&gt;
* &amp;#039;&amp;#039;&amp;#039;AUTHOR&amp;#039;&amp;#039;&amp;#039;: [[User:Jonathan Newman|Jonathan Newman]] with help from [[Matt Clarkson|Matt Clarkson]] and others&lt;br /&gt;
&lt;br /&gt;
=Overview=&lt;br /&gt;
To support the range of different types of competency frameworks used by organisations, competencies in Moodle 2.0 needs to expand on the 1.9 outcomes architecture.&lt;br /&gt;
&lt;br /&gt;
==Goals==&lt;br /&gt;
# Measured amount of abstraction&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to organise competencies in a hierarchy&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to create unlimited hierarchical levels&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to map related competencies on a given depth level&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to define custom info fields on a given depth level&lt;br /&gt;
# Easy navigation&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to view the competency structure&lt;br /&gt;
#** Expanding/collapsing competencies&lt;br /&gt;
#** Sorting/searching/filtering by competency meta data&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to easily add new competencies and meta-data&lt;br /&gt;
# Linking competencies and evidence items&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to easily attach allowed evidence (course, activity, etc) to a competency (from a &amp;#039;&amp;#039;site-level competency view&amp;#039;&amp;#039;):&lt;br /&gt;
#* Allow &amp;quot;course creators&amp;quot; to attach competencies to evidence &amp;#039;&amp;#039;within a course&amp;#039;&amp;#039;:&lt;br /&gt;
# Portability&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to import competencies (using import plugins) into a Moodle install&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to export competencies (using export plugins) from a Moodle install&lt;br /&gt;
# Specifying expected proficiency levels&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to assign an expected proficiency level (i.e., competency scale value) to a competency and a competency evidence item&lt;br /&gt;
# Aggregating measured proficiency&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to specify aggregation methods for each competency&lt;br /&gt;
#* Reporting&lt;br /&gt;
#** Allow &amp;quot;admins&amp;quot; to view competency results for all students&lt;br /&gt;
#** Allow &amp;quot;teachers&amp;quot; to view student measured proficiencies related to evidence in his/her courses.&lt;br /&gt;
#** Allow &amp;quot;students&amp;quot; to view their own competency results (via either their personal profile or My Moodle).&lt;br /&gt;
# Specifying weights&lt;br /&gt;
#* Allow &amp;quot;admins&amp;quot; to assign weight to a competency or a competency evidence item&lt;br /&gt;
# Scalability&lt;br /&gt;
#* Store and retrieve data efficiently to allow the scalability to very large numbers of courses, users, competencies, evidence, etc&lt;br /&gt;
# Extensibility&lt;br /&gt;
#* Use a plugin architecture for evidence types&lt;br /&gt;
&lt;br /&gt;
==General requirements==&lt;br /&gt;
# We&amp;#039;ll need to access and use the existing site-wide Outcomes [https://docs.moodle.org/en/Development:Grades#grade_outcomes Outcomes tables]&lt;br /&gt;
# We&amp;#039;ll need to use the tables that indicate completion status for courses (these are not yet in place) [https://docs.moodle.org/en/Development:Course_completion Course Completion]&lt;br /&gt;
# We need to get aggregate information about the course outcomes and aggregate grades for each user from the gradebook API&lt;br /&gt;
&lt;br /&gt;
==Definitions==&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Scale&amp;#039;&amp;#039;&amp;#039;: A way to measure a competency using scale values.&lt;br /&gt;
&lt;br /&gt;
Example scales:&lt;br /&gt;
 &amp;quot;Average-based scale&amp;quot;&lt;br /&gt;
 &amp;quot;Competency-based scale&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Scale values&amp;#039;&amp;#039;&amp;#039;: Descriptor or numeric values that comprise a scale. A scale value can have a id number (code) and description.&lt;br /&gt;
&lt;br /&gt;
Example scales values (with descriptors and numerical values) for the scale examples above:&lt;br /&gt;
 &amp;quot;Below average [1], Average [2], Above average [3]&lt;br /&gt;
 &amp;quot;Not yet competent [0], Competent [100]&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency&amp;#039;&amp;#039;&amp;#039;: A measurable knowledge, skill, ability, attitude or other learning-related characteristic which a student may have. Competencies can be organised into a hierarchy. &lt;br /&gt;
&lt;br /&gt;
Example hierarchy of competencies:&lt;br /&gt;
 top-level competency: &amp;quot;Literacy&amp;quot;&lt;br /&gt;
     -&amp;gt; child competency: &amp;quot;Reading Comprehension&amp;quot;&lt;br /&gt;
         -&amp;gt; child competency: &amp;quot;Responding to Text&amp;quot;&lt;br /&gt;
             -&amp;gt; child competency: &amp;quot;Initial Understanding of Literary Text&amp;quot;&lt;br /&gt;
                 -&amp;gt; child competency: &amp;quot;Demonstrate initial understanding of elements of literary texts (including text read aloud, reading independently&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency evidence type&amp;#039;&amp;#039;&amp;#039;: A form of evidence that can be accepted as evidence that a competency has been achieved. Examples:&lt;br /&gt;
 Activity grade&lt;br /&gt;
 Activity completion&lt;br /&gt;
 Activity outcome&lt;br /&gt;
 Course completion&lt;br /&gt;
 Course grade&lt;br /&gt;
 File (diploma)&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency evidence&amp;#039;&amp;#039;&amp;#039;: A competency can be measured by one or more competency evidence types. Evidence can be stated to include the evidence type, evidence date, and measured value. Examples:&lt;br /&gt;
 &amp;quot;Quiz - 4:00pm May 28, 2009 - Grade 90% out of 100%&amp;quot;&lt;br /&gt;
 &amp;quot;Certificate - Public Speaking Institute - 4:00pm May 28, 2009 - Passed.&amp;quot;&lt;br /&gt;
 &amp;quot;File - College Diploma - 4:00pm May 28, 2009 - Bachelor of Science Computer Science&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Expected proficiency level&amp;#039;&amp;#039;&amp;#039;: The expected (or required) rating (based on a scale descriptor or numerical value) for a competency. Examples:&lt;br /&gt;
 &amp;quot;Average&amp;quot;&lt;br /&gt;
 &amp;quot;5&amp;quot;&lt;br /&gt;
 &amp;quot;50%&amp;quot;&lt;br /&gt;
 &amp;quot;Passed&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Measured proficiency level&amp;#039;&amp;#039;&amp;#039;: A user&amp;#039;s observed, scored, reported proficiency level for a competency.&lt;br /&gt;
 &amp;quot;Above average&amp;quot;&lt;br /&gt;
 &amp;quot;8&amp;quot;&lt;br /&gt;
 &amp;quot;80%&amp;quot;&lt;br /&gt;
 &amp;quot;Passed&amp;quot;&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency weighting&amp;#039;&amp;#039;&amp;#039;: Child competencies can be assigned weights which can be used for aggregating either sums or averages of child competencies. Examples:&lt;br /&gt;
&lt;br /&gt;
Example with percentage weights&lt;br /&gt;
 -&amp;gt; top-level competency: &amp;quot;Communication&amp;quot;&lt;br /&gt;
     -&amp;gt; child competency: &amp;quot;Written Communication&amp;quot; : weight: 60%&lt;br /&gt;
     -&amp;gt; child competency: &amp;quot;Oral Communication&amp;quot; : weight: 40%&lt;br /&gt;
&lt;br /&gt;
==Example frameworks==&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Example 1:&amp;#039;&amp;#039;&amp;#039; Competency hierarchy with activity outcomes as evidence&lt;br /&gt;
&lt;br /&gt;
The example data below is based roughly on the [http://education.vermont.gov/ Department of Education for the State of Vermont]&amp;#039;s [http://education.vermont.gov/new/html/pgm_curriculum/literacy/gle.html Grade 1 Expectations for Literacy] for Reading.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Depth level&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Depth name&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Competency&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;full name&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Competency&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;evidence&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Competency&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;aggregation method&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Competency&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;weight&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Competency&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;proficiency expected&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|0&lt;br /&gt;
|&amp;quot;Curriculum&amp;quot;&lt;br /&gt;
|&amp;quot;Literacy&amp;quot;&lt;br /&gt;
|none&lt;br /&gt;
|all&lt;br /&gt;
|20%&lt;br /&gt;
|80%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|1&lt;br /&gt;
|&amp;quot;Type&amp;quot;&lt;br /&gt;
|&amp;quot;Reading&amp;quot;&lt;br /&gt;
|none&lt;br /&gt;
|all&lt;br /&gt;
|20%&lt;br /&gt;
|100%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|2&lt;br /&gt;
|&amp;quot;Standard&amp;quot;&lt;br /&gt;
|&amp;quot;Standard 1.1 Reading Strategies&amp;quot;&lt;br /&gt;
|none&lt;br /&gt;
|all&lt;br /&gt;
|20%&lt;br /&gt;
|80%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|3&lt;br /&gt;
|&amp;quot;Strategy&amp;quot;&lt;br /&gt;
|&amp;quot;Early Reading Skills and Strategies: Phonological Awareness&amp;quot;&lt;br /&gt;
|none&lt;br /&gt;
|all&lt;br /&gt;
|100%&lt;br /&gt;
|80%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|4&lt;br /&gt;
|&amp;quot;Code&amp;quot;&lt;br /&gt;
|&amp;quot;RK: 1 - Applies phonological knowledge and skills by...&amp;quot;&lt;br /&gt;
|activity outcome &amp;quot;Recognizing pairs of rhyming words and producing rhymes&amp;quot;&lt;br /&gt;
&lt;br /&gt;
activity outcome &amp;quot;Blending and segmenting syllables and onset-rimes&amp;quot;&lt;br /&gt;
&lt;br /&gt;
activity outcome &amp;quot;Isolating phonemes in single-syllable words (e.g., &amp;quot;tell me the first sound in &amp;#039;mop&amp;#039; &amp;quot;; &amp;quot;tell me the last sound in &amp;#039;mop,&amp;#039;&amp;quot; &amp;quot;tell me the middle sound in &amp;#039;mop&amp;#039;&amp;quot;)&amp;quot;&lt;br /&gt;
|all&lt;br /&gt;
|50%&lt;br /&gt;
|80%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|3&lt;br /&gt;
|&amp;quot;Strategy&amp;quot;&lt;br /&gt;
|&amp;quot;Early Reading Skills and Strategies - Concepts of Print&amp;quot;&lt;br /&gt;
|none&lt;br /&gt;
|all&lt;br /&gt;
|50%&lt;br /&gt;
|80%&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|4&lt;br /&gt;
|&amp;quot;Code&amp;quot;&lt;br /&gt;
|&amp;quot;RK: 2 - Demonstrates understanding of concepts of print during shared or individual reading by...&amp;quot;&lt;br /&gt;
|activity outcome: &amp;quot;Distinguishing between printed letters and words&amp;quot;&lt;br /&gt;
&lt;br /&gt;
activity outcome: &amp;quot;Following text with finger-pointing (e.g., charts, simple books), demonstrating left-to-right and top-to-bottom directionality&amp;quot;&lt;br /&gt;
&lt;br /&gt;
activity outcome: &amp;quot;Identifying the first and last parts of a word (beginning/end of the word)&amp;quot;&lt;br /&gt;
&lt;br /&gt;
activity outcome: &amp;quot;Identifying key parts of a book: front and back, print, illustrations&amp;quot;&lt;br /&gt;
&lt;br /&gt;
|all&lt;br /&gt;
|50%&lt;br /&gt;
|80%&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
See [https://docs.moodle.org/en/Development:Competencies_example here] for how the data above fits into the proposed schema.&lt;br /&gt;
&lt;br /&gt;
=Settings=&lt;br /&gt;
==Site settings==&lt;br /&gt;
[https://docs.moodle.org/en/Development:Conditional_activities#Completion_tracking_2 Activity Completion] provides an &amp;quot;Enable outcomes&amp;quot; setting (found in the Site Administration block&amp;#039;s Advanced features / optional subsystems settings page). We need to keep outcomes, however we will need to add competencies.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Proposed changes:&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
* Create a new setting named &amp;quot;Enable competencies&amp;quot; (the setting will allow competencies to be defined)&lt;br /&gt;
&lt;br /&gt;
=User interface=&lt;br /&gt;
&lt;br /&gt;
==Site Administration block==&lt;br /&gt;
When competencies are enabled, a &amp;quot;Competencies&amp;quot; menu item should appear in the Site Administration block. An &amp;quot;Add / edit competencies&amp;quot; option should appear when &amp;quot;Competencies&amp;quot; is clicked. The &amp;quot;Add / edit competencies&amp;quot; will point to the &amp;quot;Add / edit competencies&amp;quot; admin page.&lt;br /&gt;
&lt;br /&gt;
==&amp;quot;Add/edit competencies&amp;quot; admin page==&lt;br /&gt;
[[Image:Competencies_add_edit_default.png|thumb|400px|Mockup of the Add/edit competencies admin page (default)]]&lt;br /&gt;
&lt;br /&gt;
[[Image:Competencies_add_edit.png|thumb|400px|Mockup of the Add/edit competencies admin page (with competencies from Example 1 framework)]]&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;admin&amp;quot; can use this page to add and edit competencies and competency depth levels, using buttons and features available in a table.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Buttons&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
* An &amp;quot;Add a new competency&amp;quot; button will link to the &amp;quot;Add a competency&amp;quot; admin page.&lt;br /&gt;
* An &amp;quot;Add a new depth level&amp;quot; button will link to the &amp;quot;Add a depth level&amp;quot; admin page.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Table rows&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
* A &amp;quot;plus&amp;quot; / &amp;quot;minus&amp;quot; icon will appear on the right of each row in the table, allowing all child competencies to be shown or hidden.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Table columns&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
* A default, top-level competency depth named &amp;quot;Competency&amp;quot; will appear in a table as a column on the left. The default competency depth name can be changed (e.g., &amp;quot;Competency Area&amp;quot;, &amp;quot;Standard&amp;quot;, &amp;quot;Development Area&amp;quot;, etc).&lt;br /&gt;
* When a new competency depth is added, it will appear as column to the right of the next highest competency depth level.&lt;br /&gt;
* Appearing to the right of the competency depth level columns will be the following &amp;quot;standard&amp;quot; interface columns: &amp;quot;Evidence items&amp;quot;, &amp;quot;Edit&amp;quot;, and &amp;quot;Move competency to&amp;quot;.&lt;br /&gt;
&lt;br /&gt;
Below are more specifics on the table columns and content:&lt;br /&gt;
* &amp;#039;&amp;#039;[Competency depth level 0 name]&amp;#039;&amp;#039;, &amp;#039;&amp;#039;[Competency depth level 1 name]&amp;#039;&amp;#039;, &amp;#039;&amp;#039;[Competency depth level 2 name]&amp;#039;&amp;#039;, ... &amp;#039;&amp;#039;[Competency depth level n name]&amp;#039;&amp;#039;&lt;br /&gt;
** Columns of depth levels will be ordered from highest/top-level (on the left) to the lowest (on the right).&lt;br /&gt;
** An edit icon will appear beside each competency depth name, and will link to the &amp;quot;Edit competency depth&amp;quot; page (which will allow an &amp;quot;admin&amp;quot; to change the name of the competency depth name).&lt;br /&gt;
** The competency name will be displayed, and will link to a page containing meta data and possibly summary proficiency achievement stats about the competency.&lt;br /&gt;
* &amp;#039;&amp;#039;Evidence item&amp;#039;&amp;#039;&lt;br /&gt;
** By default the number of evidence items will be &amp;quot;0&amp;quot;. The number shown will link to the &amp;quot;Add / edit evidence items&amp;quot; admin page for the given competency.&lt;br /&gt;
* &amp;#039;&amp;#039;Edit&amp;#039;&amp;#039;&lt;br /&gt;
** Three icons appear providing the following functionality:&lt;br /&gt;
*** &amp;quot;edit&amp;quot; icon points to the &amp;quot;Edit competency&amp;quot; page for the competency&lt;br /&gt;
*** &amp;quot;delete&amp;quot; icon points to a confirmation page for deleting the competency&lt;br /&gt;
*** &amp;quot;up&amp;quot; / &amp;quot;down&amp;quot; icons will appear beside child competencies when a parent has two or more child competencies. A competency can only be moved up or down with respect to a parent competency.Only the down arrow will appear for the highest child competency, and only the up arrow will appear for the lowest child competency.&lt;br /&gt;
* &amp;#039;&amp;#039;Move competency to&amp;#039;&amp;#039;&lt;br /&gt;
** A drop down menu appears containing all parent competencies at the next highest depth. &lt;br /&gt;
** Competencies can only be moved from one parent to another parent in the same depth level.&lt;br /&gt;
&lt;br /&gt;
==&amp;quot;Add / edit a competency&amp;quot; admin page==&lt;br /&gt;
[[Image:Competencies_add.png|thumb|400px|Mockup of the Add competencies admin page]]&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;admin&amp;quot; will use this page to add or edit a new competency, with the following settings:&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;General settings&amp;#039;&amp;#039;&lt;br /&gt;
* Parent competency&lt;br /&gt;
* Competency full name&lt;br /&gt;
* Competency short name&lt;br /&gt;
* Competency ID number&lt;br /&gt;
* Description&lt;br /&gt;
* Aggregation method&lt;br /&gt;
* Scale&lt;br /&gt;
* Proficiency expected&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;Custom depth level settings&amp;#039;&amp;#039;&lt;br /&gt;
* Form elements based on custom fields for selected depth level (based on the parent competency)&lt;br /&gt;
* Changing the selected parent competency should update the custom fields shown, if the depth level of the parent changes&lt;br /&gt;
&lt;br /&gt;
==&amp;quot;Add / edit competency depth&amp;quot; admin page==&lt;br /&gt;
[[Image:Competencies_depth_add.png|thumb|400px|Mockup of the Add competency depth admin page]]&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;admin&amp;quot; will use this page to add / edit a new competency depth, with the following settings:&lt;br /&gt;
* Depth full name&lt;br /&gt;
* Depth short name&lt;br /&gt;
* Description&lt;br /&gt;
&lt;br /&gt;
Also, the depth level will be displayed&lt;br /&gt;
&lt;br /&gt;
==&amp;quot;Add / edit competency evidence&amp;quot; admin page==&lt;br /&gt;
[[Image:Competencies_evidence_add_edit.png|thumb|400px|Mockup of the Add / edit competency evidence admin page with Example 1 competencies]]&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;admin&amp;quot; will be use this page to view / add / edit evidence for a competency. The top of the page should display the existing general data for the competency, the number of &amp;quot;students&amp;quot; who have achieved the competency, and a table showing data and functionality for each evidence item:&lt;br /&gt;
* The name of the competency evidence (which links to the evidence item in context, e.g., the course if course completion is specified, etc)&lt;br /&gt;
* The type of evidence &lt;br /&gt;
* The activity (if the evidence is an activity outcome or activity grade)&lt;br /&gt;
* The weight of the evidence&lt;br /&gt;
* Options to edit or remove the evidence&lt;br /&gt;
* The number of &amp;quot;students&amp;quot; who have achieved the evidence&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;Add new competency evidence&amp;quot; button should link to the &amp;quot;Add new competency evidence&amp;quot; admin page.&lt;br /&gt;
&lt;br /&gt;
==&amp;quot;Competencies summary&amp;quot; user profile page==&lt;br /&gt;
&lt;br /&gt;
[[Image:Competencies_user_profile_activity.png|thumb|400px|Mockup of user profile page with Example 1 competencies]]&lt;br /&gt;
&lt;br /&gt;
An &amp;quot;student&amp;quot; or a user with permission to view a student&amp;#039;s competencies will be able to view the proficiency status for each competency as a table with the following columns:&lt;br /&gt;
* Competency depth(s)&lt;br /&gt;
* Evidence items&lt;br /&gt;
* Proficiency&lt;br /&gt;
* Scale&lt;br /&gt;
&lt;br /&gt;
Each competency name should link to a pop-up containing the competency details (full name, description, aggregation method, scale, and meta data) and list of evidence items.&lt;br /&gt;
&lt;br /&gt;
Each number of competency items should link to a pop-up containing a list of evidence items.&lt;br /&gt;
&lt;br /&gt;
=Data structures=&lt;br /&gt;
&lt;br /&gt;
[[Image:Competency_data_model.png|thumb|400px|Competencies data model]]&lt;br /&gt;
&lt;br /&gt;
===scale===&lt;br /&gt;
Scales (introduced in Moodle 1.9) give a scale value a single attribute: text (i.e., the name of the scale value like &amp;quot;below standard,&amp;quot; &amp;quot;meets standard,&amp;quot; &amp;quot;above standard&amp;quot;). Scale values can be particularly useful if given attributes including: numerical equivalent, idnumber (code id), and a description. The new attributes will require a new table.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;Proposed changes:&amp;#039;&amp;#039; Create a new table &amp;#039;scale_values&amp;#039; that includes a foreign key to the &amp;#039;scale&amp;#039; table, and migrate the &amp;#039;scale&amp;#039; field values from the &amp;#039;scale&amp;#039; table (as serialised text) to the &amp;#039;scale_values&amp;#039; table (as separate records). A sort order field will be used to track ranking (starting with the lowest with a sortorder of 0). &lt;br /&gt;
&lt;br /&gt;
Below is the proposed &amp;#039;scale&amp;#039; table, and further below is the proposed &amp;#039;scale_value&amp;#039; table.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;courseid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Id of the course, which the scale belongs to&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;userid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Id of the user who last modified the scale&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;name&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Name of the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Description of the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timemodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Timestamp of when the scale was modified&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===scale_values===&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;scaleid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Id of the scale that the scale value describes&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;name&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Name of the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;idnumber&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(100)&lt;br /&gt;
|&lt;br /&gt;
|Optional id, code number or local identifier for the scale value (used for reporting).&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Description of the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;numeric&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|number(8)&lt;br /&gt;
|&lt;br /&gt;
|Numerical value for the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;sortorder&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The order for the scale value&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timemodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Timestamp of when the scale value was modified&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency===&lt;br /&gt;
&lt;br /&gt;
A competency can be part of a hierarchy and can have evidence attached to it.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;shortname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(100)&lt;br /&gt;
|&lt;br /&gt;
|The shortname for the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;fullname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|The full name for the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|The description of the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;idnumber&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id, code number or local identifier for the competency used for reporting&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;parentid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of the parent competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;sortorder&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The order number of this competency (useful for ordering competencies for viewing/navigation/reporting)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;depthid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of the depth level the competency belongs to&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;path&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|The path to the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;aggregationmethod&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|A constant representation one of the competency aggregation methods (any, all, unit, fraction, sum of weighted, average of weighted)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;scaleid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The scale used to measure the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;proficiencyexpected&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The expected proficiency for the competency, foreign key to the scale_value table&amp;#039;s id&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timecreated&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when the competency was created&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timemodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when the competency was modified&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;usermodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The userid of the person who last modified the competency&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_relations===&lt;br /&gt;
&lt;br /&gt;
For tracking relations between competencies.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Info about how competencies are related&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;competencyid1&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of a competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;competencyid2&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of a related competency&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_depth===&lt;br /&gt;
&lt;br /&gt;
Data for a competency depth level.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;shortname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Shortname for the depth level&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;fullname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Full name for the depth level&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Description for the depth level&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;level&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(2)&lt;br /&gt;
|&lt;br /&gt;
|The actual depth level, starting at 0&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_depth_info_field===&lt;br /&gt;
&lt;br /&gt;
Data for a competency depth level field.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;shortname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Shortname for the field&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;fullname&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Full name for the field&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;depthid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of the competency depth for the field. Foreign key to the competency_depth table&amp;#039;s id&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;datatype&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|The type of field data&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Description of the field&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;categoryid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id for the field category. Foreign key to the competency_depth_info_category table&amp;#039;s id field&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;sortorder&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The sort order for the field within its category&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;hidden&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(1)&lt;br /&gt;
|&lt;br /&gt;
|The field should be hidden&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;required&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(1)&lt;br /&gt;
|&lt;br /&gt;
|The field required&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;defaultdata&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Default text for the selected parameter&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;param1&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Parameter text&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;param2&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Parameter text&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;param3&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Parameter text&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;param4&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Parameter text&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;param5&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|Parameter text&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_depth_info_category===&lt;br /&gt;
&lt;br /&gt;
A competency&amp;#039;s depth level can have categories for its fields.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;name&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(255)&lt;br /&gt;
|&lt;br /&gt;
|Shortname for the depth level category&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;sortorder&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The order number for this category&lt;br /&gt;
&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_depth_info_data===&lt;br /&gt;
&lt;br /&gt;
Data for a depth level field.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;fieldid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id for the field&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;competencyid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id for the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;data&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|text&lt;br /&gt;
|&lt;br /&gt;
|The actual data for the competency field&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_evidence_items===&lt;br /&gt;
&lt;br /&gt;
A competency can be achieved by one or more forms of evidence.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|Auto incrementing &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;competencyid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id for the competency that this evidence describes&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;itemtype&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(30)&lt;br /&gt;
|&lt;br /&gt;
|The type of evidence &amp;#039;course/outcome&amp;#039;, &amp;#039;mod/outcome&amp;#039;, &amp;#039;course/completion&amp;#039;, &amp;#039;mod/completion&amp;#039;, &amp;#039;course/grade&amp;#039;, &amp;#039;mod/grade&amp;#039;, &amp;#039;file&amp;#039;&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;itemmodule&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|varchar(30)&lt;br /&gt;
|&lt;br /&gt;
|The type of evidence &amp;#039;quiz&amp;#039;, &amp;#039;scorm&amp;#039;, etc&lt;br /&gt;
|-&lt;br /&gt;
&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;iteminstance&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id for the evidence instance (ie, grade_outcome id, course id, course_modules id, grade_item id, files id)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;weight&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|num(10)&lt;br /&gt;
|&lt;br /&gt;
|The weight applied to this evidence item (for aggregation)&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timecreated&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when this competency evidence was allowed&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timemodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when this competency evidence was last changed&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;usermodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The user who last modified this evidence&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
===competency_evidence===&lt;br /&gt;
&lt;br /&gt;
Track historical and current competency information for each user.&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Field&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Type&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Default&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Info&amp;#039;&amp;#039;&amp;#039; &lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;id&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|auto-incrementing&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;userid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of the user&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;competencyid&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The id of the competency&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;proficiencymeasured&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The measured/evaluated proficiency level for the user&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timecreated&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when this competency evidence was started&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;timemodified&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|int(10)&lt;br /&gt;
|&lt;br /&gt;
|The time when this competency evidence was last changed&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
=Plugin architecture=&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency evidence type plugins&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
Each type of evidence will need its own methods for interacting with the competency architecture and will need to interact via a base competency evidence API. Below are the item types.&lt;br /&gt;
&lt;br /&gt;
* Course completion&lt;br /&gt;
* Course grade&lt;br /&gt;
* Course outcome&lt;br /&gt;
* Activity completion&lt;br /&gt;
* Activity grade&lt;br /&gt;
* Activity outcome&lt;br /&gt;
* File&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Report plugins&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
Similar to the gradebook, we need to allow development of report plugins for competencies.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Import/Export plugins&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
We need to be able to import and export data related to competencies.&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency framework import/export&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
A competency framework should be able to be exported using an appropriate format in either xml and csv file format. There are some standards on exchanging competencies including:&lt;br /&gt;
* IEEE P1484.20.1 Standard on Reusable Competency Definitions and the IEEE Draft Standard on Simple Reusable Competency Map&lt;br /&gt;
* ISO/IEC PDTR 24763 Conceptual Reference Model for Competencies and Related Objects&lt;br /&gt;
&lt;br /&gt;
&amp;#039;&amp;#039;&amp;#039;Competency evidence import/export&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
There are a variety of standards for exchanging competencies evidence including:&lt;br /&gt;
* IMS Reusable Definition of Competency or Educational Objectives Spec (RDCEO)&lt;br /&gt;
* IMS Learner Information Package Spec (LIP)&lt;br /&gt;
* HR-XML Competencies (Measurable Characteristics) Recommendation, 2007 April 15&lt;br /&gt;
&lt;br /&gt;
IMS RDCEO and LIP recommend formats as shown in the examples below (more [http://www.imsglobal.org/competencies/index.html IMS RDCEO here] and [http://www.imsglobal.org/profiles/index.html IMS LIP home]). Special thanks to Sarveswaran Kengatharaiyer (GSOC 2008 student for the Moodle Progress Tracker project) who developed these examples.&lt;br /&gt;
&lt;br /&gt;
 rdceo.identifier = rdceo434323&lt;br /&gt;
 rdceo.title = Identify verbs in simple sentences&lt;br /&gt;
 rdceo.description = “Identify verbs in simple sentences”&lt;br /&gt;
 rdceo.definition.statement.&lt;br /&gt;
    statementid = 123&lt;br /&gt;
    statementname = Always&lt;br /&gt;
    statementtext = Scale&lt;br /&gt;
    statementtoken = scl55435&lt;br /&gt;
 rdceo.definition.statement.&lt;br /&gt;
    statementid = 124&lt;br /&gt;
    statementname = Never&lt;br /&gt;
    statementtext = Scale&lt;br /&gt;
    statementtoken = scl55436&lt;br /&gt;
 rdceo.definition.statement.&lt;br /&gt;
    statementid = 125&lt;br /&gt;
    statementname = Sometimes&lt;br /&gt;
    statementtext = Scale&lt;br /&gt;
    statementtoken = scl55437&lt;br /&gt;
 &lt;br /&gt;
 lip.contenttype.referencial.sourceid.id = jenney_profile&lt;br /&gt;
 lip.identification.cotenttype.referential.indexid = id123&lt;br /&gt;
 lip.identification.name.partname.typename=Jenny &lt;br /&gt;
 lip.competency&lt;br /&gt;
    cotenttype.referential.indexid = j123&lt;br /&gt;
    exrefrecord = rdceo434323&lt;br /&gt;
    description = Always&lt;br /&gt;
&lt;br /&gt;
HR-XML recommends a format like shown below in an example which uses recursive competencies (more [http://ns.hr-xml.org/2_5/HR-XML-2_5/CPO/Competencies.html#_Toc127531664 here]).&lt;br /&gt;
 &amp;lt;Competency name=&amp;quot;Communication Skills&amp;quot;&amp;gt;&lt;br /&gt;
       &amp;lt;Competency name=&amp;quot;Written Communication Skills&amp;quot;&amp;gt;&lt;br /&gt;
             &amp;lt;CompetencyEvidence name=&amp;quot;WRITTENTEST1-A&amp;quot; dateOfIncident=&amp;quot;1995-01-01&amp;quot; lastUsed=&amp;quot;2000-01-01&amp;quot;&amp;gt;&lt;br /&gt;
                    &amp;lt;NumericValue minValue=&amp;quot;3&amp;quot; maxValue=&amp;quot;5&amp;quot; description=&amp;quot;SEP-equivalent Skill-Level Range&amp;quot;&amp;gt;5&amp;lt;/NumericValue&amp;gt;&lt;br /&gt;
             &amp;lt;/CompetencyEvidence&amp;gt;&lt;br /&gt;
             &amp;lt;CompetencyWeight&amp;gt;&lt;br /&gt;
                    &amp;lt;NumericValue minValue=&amp;quot;0&amp;quot; maxValue=&amp;quot;100&amp;quot;&amp;gt;35&amp;lt;/NumericValue&amp;gt;&lt;br /&gt;
             &amp;lt;/CompetencyWeight&amp;gt;&lt;br /&gt;
       &amp;lt;/Competency&amp;gt;&lt;br /&gt;
       &amp;lt;Competency name=&amp;quot;Oral Communication Skills&amp;quot;&amp;gt;&lt;br /&gt;
             &amp;lt;CompetencyEvidence name=&amp;quot;ManagerObservation&amp;quot; dateOfIncident=&amp;quot;1996-01-01&amp;quot; lastUsed=&amp;quot;2000-01-01&amp;quot;&amp;gt;&lt;br /&gt;
                    &amp;lt;NumericValue minValue=&amp;quot;1&amp;quot; maxValue=&amp;quot;5&amp;quot; description=&amp;quot;Company XYZ Skill Range&amp;quot;&amp;gt;5&amp;lt;/NumericValue&amp;gt;&lt;br /&gt;
             &amp;lt;/CompetencyEvidence&amp;gt;&lt;br /&gt;
             &amp;lt;CompetencyWeight&amp;gt;&lt;br /&gt;
                    &amp;lt;NumericValue minValue=&amp;quot;0&amp;quot; maxValue=&amp;quot;100&amp;quot;&amp;gt;65&amp;lt;/NumericValue&amp;gt;&lt;br /&gt;
             &amp;lt;/CompetencyWeight&amp;gt;&lt;br /&gt;
       &amp;lt;/Competency&amp;gt;&lt;br /&gt;
 &amp;lt;/Competency&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=Logging=&lt;br /&gt;
All competency related changes should be logged in history tables.&lt;br /&gt;
&lt;br /&gt;
=Role capabilities and permissions=&lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;0&amp;quot; cellpadding=&amp;quot;2&amp;quot; cellspacing=&amp;quot;0&amp;quot;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Description&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
|&amp;#039;&amp;#039;&amp;#039;Capability&amp;#039;&amp;#039;&amp;#039;&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|View competency competencies&lt;br /&gt;
|moodle/competency:viewcompetencies&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|View hidden competencies&lt;br /&gt;
|moodle/competency:viewhiddencompetencies&lt;br /&gt;
&lt;br /&gt;
|-&lt;br /&gt;
|Manage competencies&lt;br /&gt;
|moodle/competency:managecompetencies&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
=Ideas for the future=&lt;br /&gt;
# Allow competencies to be attached to an individual user (either by user profile field or by drag and drop).&lt;br /&gt;
# Allow competencies to be tagged (in a folksonomy) using Moodle&amp;#039;s tag/lib.&lt;br /&gt;
&lt;br /&gt;
[[Category:Project]]&lt;/div&gt;</summary>
		<author><name>1&gt;Janvh</name></author>
	</entry>
</feed>