For Boolean fields, use 0 for false and 1 for true. Either idnumber or coursename can be used to identify the course. Idnumber overrides coursename. If neither is specified, the groups will be added to the current course.
Full Answer
My moodle site will be implement in French. So you'll find some french word on it. Re: Useful SQL Queries? Hey guys, A very useful thread. I've just installed the ad-hoc database query block, and want to run a simple (i hope) query, where I get a total daily number of submitted assignments.
Note, it is always helpful to state your Moodle version when asking questions in these forums, especially if you are using an old, unsupported version of the software. Re: Useful SQL Queries? Thanks Davo. Sorry I missed stating my Moodle version the first time. I think I may have found what I'm looking for in that role_assignments table.
This SQL Statement is generating Moodle course log report just like the exported Excel Moodle Log: WHERE c.id =<YOUR_COURSE_ID> GROUP BY u.username, l.time order by l.time DESC;
I used it to make a list of all faculty email addresses who were "teacher" roles in moodle. You could change the "roleid = 3" to whatever other roleid you want. roleid = 3 is what our teacher roleid is.
Course ID number The ID number is an alphanumeric field. It has several potential uses. Generally, it is not displayed to students. However, it can be used to match this course against an external system's ID, as your course catalogue ID or can be used in the certificate module as a printed field.
The course teacher has control over the layout of the course homepage and can change it at any time. Progress can be tracked in a number of ways. Students can be enrolled manually by the teacher, automatically by the administrator, or they can be allowed to enrol themselves.
0:061:18How to Change Section Layout in Moodle - YouTubeYouTubeStart of suggested clipEnd of suggested clipSo you come over to edit settings on the administration panel. And when you go into the editMoreSo you come over to edit settings on the administration panel. And when you go into the edit settings you're gonna scroll down to course format. And in the course format you have area you have layout.
Re: Change date format Since 2003, you can to use the Moodle language editor (Site Administration > Language > Language Customization) to customize the string formats in the core langconfig. php.
To assign a teacher to a course, click on the course title from the main Moodle page. Find the admin block inside this course (default is the lower, left-hand side) and choose the "Assign roles" option. When the "Assign roles" page loads, choose the teacher link from the list.
You can also look for your course in the main section of the Moodle homepage, underneath the “Search courses” box, in the “My courses” section. After the active courses, you will see your inactive courses listed here in approximately reverse chronological order.
Course maps organize the structure of a course around its learning modules. Each module is broken down into its components: module outcomes, assessments, activities, instruction, and then linked or mapped to the corresponding course learning outcome to show alignment.
"Set a course" is a phrase used in driving an airplane or boat. It means to point the boat in a direction. The "course" is the direction. "Setting" it means marking it on the compass, then keeping the boat or plane travelling in that direction.
To design an effective course, you need to:Consider timing and logistics.Recognize who your students are.Identify the situational constraints.Articulate your learning objectives.Identify potential assessments.Identify appropriate instructional strategies.Plan your course content and schedule.
0:071:20How to change your time zone in Moodle - YouTubeYouTubeStart of suggested clipEnd of suggested clipSelect edit profile under the user accounts. And scroll down till you can see time zone the defaultMoreSelect edit profile under the user accounts. And scroll down till you can see time zone the default is Europe London. You can select it and change it to anywhere in the world.
Switch to Student View in Your Moodle Course - FacultyIn the upper right corner of the screen -- just above the circular "gear" icon -- click on the circular photo icon.On the resulting drop-down list, click on the Switch role to... option.Click on the Student button.
Change the Language of a Course in MoodleClick the gear menu, and then click Edit settings.Expand the Appearance section, and select the desired language within the Force language drop-down menu.Click the [Save and display] button.
New scales can be created by teachers with editing rights or by administrators or by any user with the manage scales role capability .
A teacher may select a scale by going to the Edit settings screen of an activity, for example an assignment ,scrolling to 'Grade' and then selecting 'Scale' from the Type dropdown:
If a scale has not yet been used, you will see an edit, move, and delete icon in the edit column.
Moodle uses the last entry to determine the number of points in the scale for computing percentages. For example, if your scale is 0,5,6,7,8,9,10 then Moodle will use a 0-6 or 1-7 point scale depending on your chosen aggregation method.