https://docs.moodle.org/24/en/api.php?action=feedcontributions&feedformat=atom&user=JoeythibaultMoodleDocs - User contributions [en]2026-05-20T22:32:14ZUser contributionsMediaWiki 1.43.5https://docs.moodle.org/24/en/index.php?title=ad-hoc_contributed_reports&diff=104145ad-hoc contributed reports2013-04-24T19:57:04Z<p>Joeythibault: </p>
<hr />
<div>{{Sitewide reports}}<br />
==User and Role Report==<br />
===Detailed ACTIONs for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===<br />
<code sql><br />
SELECT r.name,l.action, count( l.userid ) as counter<br />
FROM `prefix_log` as l<br />
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid<br />
JOIN prefix_role AS r ON ra.roleid = r.id<br />
WHERE ra.roleid IN (3,4,5)<br />
GROUP BY roleid,l.action<br />
ORDER BY counter desc<br />
</code><br />
<br />
===Student (user) COUNT in each Course===<br />
Including (optional) filter by: year (if included in course fullname).<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',course.id,'">',course.fullname,'</a>') AS Course<br />
,concat('<a target="_new" href="%%WWWROOT%%/user/index.php?contextid=',context.id,'">Show users</a>') AS Users<br />
, COUNT(course.id) AS Students<br />
FROM prefix_role_assignments AS asg<br />
JOIN prefix_context AS context ON asg.contextid = context.id AND context.contextlevel = 50<br />
JOIN prefix_user AS user ON user.id = asg.userid<br />
JOIN prefix_course AS course ON context.instanceid = course.id<br />
WHERE asg.roleid = 5 <br />
# AND course.fullname LIKE '%2013%'<br />
GROUP BY course.id<br />
ORDER BY COUNT(course.id) DESC<br />
</code><br />
<br />
===LIST of all site USERS by COURSE enrollment (Moodle 1.9.x)===<br />
<br />
Reports a site global list of all users enroled in each course<br />
<code sql><br />
SELECT<br />
user.firstname AS Firstname,<br />
user.lastname AS Lastname,<br />
user.email AS Email,<br />
user.city AS City,<br />
course.fullname AS Course<br />
,(SELECT name FROM prefix_role WHERE id=asg.roleid)<br />
FROM<br />
prefix_user AS user,<br />
prefix_course AS course,<br />
prefix_role_assignments AS asg<br />
INNER JOIN prefix_context AS context ON asg.contextid=context.id <br />
WHERE<br />
context.contextlevel = 50<br />
AND<br />
user.id=asg.userid<br />
AND<br />
context.instanceid=course.id<br />
</code><br />
<br />
===LIST of all site USERS by COURSE enrollment (Moodle 2.x)===<br />
<br />
<code sql><br />
SELECT<br />
user2.firstname AS Firstname,<br />
user2.lastname AS Lastname,<br />
user2.email AS Email,<br />
user2.city AS City,<br />
course.fullname AS Course<br />
,(SELECT shortname FROM prefix_role WHERE id=en.roleid) as Role<br />
,(SELECT name FROM prefix_role WHERE id=en.roleid) as RoleName<br />
<br />
FROM prefix_course as course <br />
JOIN prefix_enrol AS en ON en.courseid = course.id<br />
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id<br />
JOIN prefix_user AS user2 ON ue.userid = user2.id<br />
</code><br />
<br />
===Enrolled users,which did not login into the Course, even once (Moodle 2)===<br />
Designed forMoodle 2 table structure and uses special plugin filter : %%FILTER_SEARCHTEXT:table.field%%<br />
<br />
<code sql><br />
SELECT<br />
user2.id as ID,<br />
ul.timeaccess,<br />
user2.firstname AS Firstname,<br />
user2.lastname AS Lastname,<br />
user2.email AS Email,<br />
user2.city AS City,<br />
user2.idnumber AS IDNumber,<br />
user2.phone1 AS Phone,<br />
user2.institution AS Institution,<br />
<br />
IF (user2.lastaccess = 0,'never',<br />
DATE_FORMAT(FROM_UNIXTIME(user2.lastaccess),'%Y-%m-%d')) AS dLastAccess<br />
<br />
,(SELECT DATE_FORMAT(FROM_UNIXTIME(timeaccess),'%Y-%m-%d') FROM prefix_user_lastaccess WHERE userid=user2.id and courseid=c.id) as CourseLastAccess<br />
<br />
,(SELECT r.name<br />
FROM prefix_user_enrolments AS uenrol<br />
JOIN prefix_enrol AS e ON e.id = uenrol.enrolid<br />
JOIN prefix_role AS r ON e.id = r.id<br />
WHERE uenrol.userid=user2.id and e.courseid = c.id) AS RoleName<br />
<br />
FROM prefix_user_enrolments as ue<br />
JOIN prefix_enrol as e on e.id = ue.enrolid<br />
JOIN prefix_course as c ON c.id = e.courseid<br />
JOIN prefix_user as user2 ON user2 .id = ue.userid<br />
LEFT JOIN prefix_user_lastaccess as ul on ul.userid = user2.id<br />
WHERE c.id=16 AND ul.timeaccess IS NULL<br />
%%FILTER_SEARCHTEXT:user2.firstname%%<br />
</code><br />
<br />
===Permissions Overides on Categories===<br />
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712834 Séverin Terrier] )<br />
<code sql><br />
SELECT rc.id, ct.instanceid, ccat.name, rc.roleid, rc.capability, rc.permission, <br />
DATE_FORMAT( FROM_UNIXTIME( rc.timemodified ) , '%Y-%m-%d' ) AS timemodified, rc.modifierid, ct.instanceid, ct.path, ct.depth<br />
FROM `prefix_role_capabilities` AS rc<br />
INNER JOIN `prefix_context` AS ct ON rc.contextid = ct.id<br />
INNER JOIN `prefix_course_categories` AS ccat ON ccat.id = ct.instanceid<br />
AND `contextlevel` =40<br />
</code><br />
<br />
===Lists "Totally Opened Courses" (visible, opened to guests, with no password)===<br />
(By: [http://moodle.org/mod/forum/discuss.php?d=153059#p712837 Séverin Terrier] )<br />
<code sql><br />
SELECT id , category , fullname , shortname , enrollable<br />
FROM `prefix_course`<br />
WHERE `guest` =1<br />
AND `password` = ""<br />
AND `visible` =1<br />
</code><br />
<br />
===Lists "loggedin users" from the last 120 days===<br />
<code sql><br />
SELECT id,username,FROM_UNIXTIME(`lastlogin`) as days <br />
FROM `prefix_user` <br />
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120<br />
</code><br />
<br />
''and user count for that same population:''<br />
<code sql><br />
SELECT COUNT(id) as Users FROM `prefix_user` <br />
WHERE DATEDIFF( NOW(),FROM_UNIXTIME(`lastlogin`) ) < 120<br />
</code><br />
<br />
===Lists the users who have only logged into the site once===<br />
<code sql><br />
SELECT id, username, firstname, lastname, idnumber<br />
FROM prefix_user<br />
WHERE prefix_user.deleted = 0<br />
AND prefix_user.lastlogin = 0 <br />
AND prefix_user.lastaccess > 0<br />
</code><br />
<br />
===Students in all courses of some institute===<br />
What is the status (deleted or not) of all Students (roleid = 5) in all courses of some Institute<br />
<code sql><br />
SELECT c.id, c.fullname, u.firstname, u.lastname, u.deleted<br />
FROM prefix_course AS c<br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid<br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid =5<br />
AND ctx.instanceid = c.id<br />
AND u.institution = 'please enter school name here'<br />
</code><br />
<br />
===Full User info (for deleted users)===<br />
Including extra custom profile fields (from mdl_user_info_data)<br />
<code sql><br />
SELECT * <br />
FROM prefix_user as u <br />
JOIN prefix_user_info_data as uid ON uid.userid = u.id <br />
JOIN prefix_user_info_field as uif ON (uid.fieldid = uif.id AND uif.shortname = 'class')<br />
WHERE `deleted` = "1" and `institution`="your school name" and `department` = "your department" and `data` = "class level and number"<br />
</code><br />
<br />
===User's courses===<br />
change "u.id = 2" with a new user id<br />
<code sql><br />
SELECT u.firstname, u.lastname, c.id, c.fullname<br />
FROM prefix_course AS c<br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid<br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE u.id = 2<br />
</code><br />
<br />
===Special Roles===<br />
<code sql><br />
SELECT ra.roleid,r.name<br />
,concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',ra.userid,'">',u.firstname ,' ',u.lastname,'</a>') AS Username<br />
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_role AS r ON r.id = ra.roleid<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
JOIN prefix_context AS ctx ON (ctx.id = ra.contextid AND ctx.contextlevel = 50)<br />
JOIN prefix_course AS c ON ctx.instanceid = c.id<br />
WHERE ra.roleid > 6<br />
</code><br />
<br />
===Courses without Teachers===<br />
Actually, shows the number of Teachers in a course.<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id) AS Teachers<br />
FROM prefix_course AS c<br />
ORDER BY Teachers ASC<br />
</code><br />
<br />
===List of users who have been enrolled for more than 4 weeks===<br />
For Moodle 2.2 , by Isuru Madushanka Weerarathna <br />
<code sql><br />
SELECT uenr.userid As User, IF(enr.courseid=enr.courseid ,'Y','N') As Enrolled, <br />
IF(DATEDIFF(NOW(), FROM_UNIXTIME(uenr.timecreated))>=28,'Y','N') As EnrolledMoreThan4Weeks<br />
FROM mdl_enrol As enr, mdl_user_enrolments AS uenr<br />
WHERE enr.id = uenr.enrolid AND enr.status = uenr.statu<br />
</code><br />
<br />
==Log Acivity Reports==<br />
===Detailed "VIEW" ACTION for each ROLE (TEACHER,NONE-EDITING TEACHER and STUDENT)===<br />
<code sql><br />
SELECT l.action, count( l.userid ) as counter , r.name<br />
FROM `prefix_log` as l<br />
JOIN `prefix_role_assignments` AS ra on l.userid = ra.userid<br />
JOIN `prefix_role` AS r ON ra.roleid = r.id<br />
WHERE (ra.roleid IN (3,4,5)) AND (l.action LIKE '%view%' )<br />
GROUP BY roleid,l.action<br />
order by r.name,counter desc<br />
</code><br />
<br />
===Total Activity of Roles:"Teacher" and "None-Editing Teacher" by Dates and by Hours===<br />
The output columns of this report table can be used as base for a Pivot-Table<br />
which will show the amount of '''activity''' per '''hour''' per '''days''' in 3D graph view.<br />
<br />
<code sql><br />
SELECT DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%Y/%m/%d' ) AS grptimed ,<br />
DATE_FORMAT( FROM_UNIXTIME( l.time ) , '%k' ) AS grptimeh , count( l.userid ) AS counter <br />
FROM `prefix_log` AS l<br />
JOIN prefix_user AS u ON u.id = l.userid<br />
JOIN prefix_role_assignments AS ra ON l.userid = ra.userid<br />
JOIN prefix_role AS r ON r.id = ra.roleid<br />
WHERE ra.roleid IN (3,4)<br />
GROUP BY grptimed,grptimeh<br />
ORDER BY grptimed,grptimeh<br />
</code><br />
<br />
===How many LOGINs per user and user's Activity===<br />
+ link username to a user activity graph report<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/user.php?id=1&user=',u.id,'&mode=alllogs">',u.firstname ,' ',u.lastname,'</a>') as Username<br />
,count(*) as logins<br />
,(SELECT count(*) FROM prefix_log WHERE userid = l.userid GROUP BY userid) as Activity <br />
FROM prefix_log as l JOIN prefix_user as u ON l.userid = u.id <br />
WHERE `action` LIKE '%login%' group by userid<br />
ORDER BY Activity DESC<br />
</code><br />
<br />
===Total activity per course, per unique user on the last 24h===<br />
<code sql><br />
Select<br />
Count(Distinct userid) As countUsers<br />
, Count(course) As countVisits<br />
, concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
<br />
From prefix_log as l<br />
JOIN prefix_course as c on c.id = l.course<br />
Where course > 0 and FROM_UNIXTIME(time) >= DATE_SUB(NOW(), INTERVAL 1 DAY) and c.fullname LIKE '%תשעג%'<br />
Group By course<br />
ORDER BY countVisits DESC<br />
</code><br />
<br />
==Course Reports==<br />
===Most Active courses===<br />
<code sql><br />
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename<br />
FROM prefix_log l INNER JOIN prefix_course c ON l.course = c.id<br />
GROUP BY courseId<br />
ORDER BY hits DESC<br />
</code><br />
<br />
===Active courses, advanced===<br />
Including: Teacher's name, link to the course, All types of log activities, special YEAR generated field, Activities and Resource count, enrolled Student count<br />
<code sql><br />
SELECT COUNT(l.id) hits, concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course <br />
<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher<br />
<br />
,CASE <br />
WHEN c.fullname LIKE '%תשע' THEN 'תשע'<br />
WHEN c.fullname LIKE '%תשעא' THEN 'תשעא'<br />
WHEN c.fullname LIKE '%תשעב' THEN 'תשעב'<br />
END AS Year<br />
<br />
,(SELECT count(*) FROM prefix_course_modules cm WHERE cm.course = l.course) Modules<br />
<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students<br />
<br />
FROM prefix_log l <br />
INNER JOIN prefix_course c ON l.course = c.id<br />
GROUP BY c.id<br />
HAVING Modules > 2<br />
ORDER BY Year DESC, hits DESC<br />
</code><br />
<br />
===RESOURCE count for each COURSE===<br />
<code sql><br />
SELECT COUNT(l.id) count, l.course, c.fullname coursename<br />
FROM prefix_resource l INNER JOIN prefix_course c on l.course = c.id<br />
GROUP BY course<br />
ORDER BY count DESC<br />
</code><br />
<br />
===Detailed Resource COUNT by Teacher in each course===<br />
<br />
Including (optional) filter by: year, semester and course id.<br />
<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS CourseID<br />
, c.id<br />
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_user AS u ON ra.userid = u.id<br />
JOIN prefix_context AS ctx ON ctx.id = ra.contextid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher<br />
<br />
, (CASE <br />
WHEN c.fullname LIKE '%תשעב%' THEN '2012' <br />
WHEN c.fullname LIKE '%תשעא%' THEN '2011'<br />
END ) as Year<br />
, (CASE <br />
WHEN c.fullname LIKE '%סמסטר א%' THEN 'Semester A' <br />
WHEN c.fullname LIKE '%סמסטר ב%' THEN 'Semester B'<br />
WHEN c.fullname LIKE '%סמסטר ק%' THEN 'Semester C'<br />
END ) as Semester<br />
,COUNT(c.id) AS Total<br />
,(SELECT count(*) FROM prefix_course_modules AS cm WHERE cm.course = c.id AND cm.module= 20) AS TABs<br />
,(SELECT count(*) FROM prefix_course_modules AS cm WHERE cm.course = c.id AND cm.module= 33) AS BOOKs<br />
<br />
FROM `prefix_resource` as r <br />
JOIN `prefix_course` AS c on c.id = r.course<br />
#WHERE type= 'file' and reference NOT LIKE 'http://%' <br />
<br />
#WHERE 1=1<br />
#%%FILTER_YEARS:c.fullname%%<br />
#AND c.fullname LIKE '%2013%'<br />
<br />
GROUP BY course<br />
ORDER BY COUNT(c.id) DESC<br />
</code><br />
<br />
===Courses that are defined as using GROUPs===<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/group/index.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
,(SELECT count(*) FROM prefix_course_modules cm WHERE cm.course = c.id) Modules<br />
,(SELECT count(*) FROM prefix_groups g WHERE g.courseid = c.id) Groups<br />
FROM `prefix_course` AS c<br />
WHERE groupmode > 0<br />
</code><br />
<br />
===List all Courses in and below a certain category===<br />
Use this SQL code to retrieve all courses that exist in or under a set category.<br />
<br />
$s should be the id of the category you want to know about...<br />
<code sql><br />
SELECT prefix_course. * , prefix_course_categories. *<br />
FROM prefix_course, prefix_course_categories<br />
WHERE prefix_course.category = prefix_course_categories.id<br />
AND (<br />
prefix_course_categories.path LIKE '/$s/%'<br />
OR prefix_course_categories.path LIKE '/$s'<br />
)<br />
</code><br />
===List all Categories in one level below a certain category===<br />
Use this PHP code to retrieve a list of all categories below a certain category.<br />
<br />
$s should be the id of the top level category you are interested in.<br />
<code php><br />
<?php<br />
<br />
require_once('./config.php');<br />
<br />
$parent_id = $s;<br />
<br />
$categories= array();<br />
<br />
$categories = get_categories($parent_id);<br />
<br />
echo '<ol>';<br />
foreach ($categories as $category)<br />
{<br />
echo '<li><a href="'.$CFG->wwwroot.'/course/category.php?id='.$category->id.'">'.$category->name.'</a></li>';<br />
}<br />
echo '</ol>';<br />
<br />
?><br />
</code><br />
<br />
===Blog activity per Course (not including VIEW)===<br />
Filter activity logging to some specific Course Categories!<br />
+ link course name to actual course (for quick reference)<br />
(you can change %blog% to %wiki% to filter down all wiki activity or any other module you wish)<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID<br />
,m.name ,count(cm.id) as counter <br />
,(SELECT Count( ra.userid ) AS Users<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5<br />
AND ctx.instanceid = c.id<br />
) AS Students<br />
, ( SELECT count(id) FROM prefix_log WHERE `module` LIKE '%blog%' AND course = c.id AND action NOT LIKE '%view%' ) as BlogActivity<br />
FROM `prefix_course_modules` as cm JOIN prefix_modules as m ON cm.module=m.id JOIN prefix_course as c ON cm.course = c.id <br />
WHERE m.name LIKE '%blog%' AND c.category IN ( 8,13,15)<br />
GROUP BY cm.course,cm.module order by counter desc<br />
</code><br />
<br />
===All Courses which uploaded a Syllabus file===<br />
+ under specific Category<br />
+ show first Teacher in that course<br />
+ link Course's fullname to actual course<br />
<code sql><br />
SELECT<br />
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course<br />
,c.shortname,r.name<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) as Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user as u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) as Teacher<br />
FROM prefix_resource as r <br />
JOIN prefix_course as c ON r.course = c.id<br />
WHERE ( r.name LIKE '%סילבוס%' OR r.name LIKE '%סילאבוס%' OR r.name LIKE '%syllabus%' OR r.name LIKE '%תכנית הקורס%' ) <br />
AND c.category IN (10,18,26,13,28)<br />
</code><br />
<br />
===Site-wide completed SCORM activities by Course name===<br />
This report will list all completed attempts for all SCORM activities. It is ordered first by Course name, then student's last name, then student's first name, then attempt number. Please note: the FROM_UNIXTIME command is for MySQL.<br />
<code sql><br />
SELECT u.firstname First,u.lastname Last,c.fullname Course, st.attempt Attempt,st.value Status,FROM_UNIXTIME(st.timemodified,"%m-%d-%Y") Date <br />
FROM prefix_scorm_scoes_track AS st <br />
JOIN prefix_user AS u ON st.userid=u.id<br />
JOIN prefix_scorm AS sc ON sc.id=st.scormid<br />
JOIN prefix_course AS c ON c.id=sc.course<br />
WHERE st.value='completed' <br />
ORDER BY c.fullname, u.lastname,u.firstname, st.attempt<br />
</code><br />
<br />
==Grade Reports==<br />
===Site-Wide Grade Report with All Items===<br />
Shows grades for all course items along with course totals for each student.<br />
<code sql><br />
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name', <br />
c.fullname AS 'Course', <br />
cc.name AS 'Category',<br />
<br />
CASE <br />
WHEN gi.itemtype = 'course' <br />
THEN c.fullname + ' Course Total'<br />
ELSE gi.itemname<br />
END AS 'Item Name',<br />
<br />
ROUND(gg.finalgrade,2) AS Grade,<br />
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time<br />
<br />
FROM prefix_course AS c<br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid<br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
JOIN prefix_grade_grades AS gg ON gg.userid = u.id<br />
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid<br />
JOIN prefix_course_categories as cc ON cc.id = c.category<br />
<br />
WHERE gi.courseid = c.id <br />
ORDER BY lastname<br />
</code><br />
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:<br />
<code><br />
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time<br />
</code><br />
<br />
===Site-Wide Grade Report with Just Course Totals===<br />
A second site-wide grade report for all students that just shows course totals.<br />
<code sql><br />
SELECT u.firstname AS 'First' , u.lastname AS 'Last', u.firstname + ' ' + u.lastname AS 'Display Name', <br />
cc.name AS 'Category',<br />
CASE <br />
WHEN gi.itemtype = 'course' <br />
THEN c.fullname + ' Course Total'<br />
ELSE gi.itemname<br />
END AS 'Item Name',<br />
<br />
ROUND(gg.finalgrade,2) AS Grade,<br />
DATEADD(ss,gi.timemodified,'1970-01-01') AS Time<br />
<br />
FROM prefix_course AS c<br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid<br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
JOIN prefix_grade_grades AS gg ON gg.userid = u.id<br />
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid<br />
JOIN prefix_course_categories as cc ON cc.id = c.category<br />
<br />
WHERE gi.courseid = c.id AND gi.itemtype = 'course'<br />
<br />
ORDER BY lastname<br />
</code><br />
For MySQL users, you'll need to use the MySQL DATE_ADD function instead of DATEADD:<br />
<code><br />
DATE_ADD('1970-01-01', INTERVAL gi.timemodified SECONDS) AS Time<br />
</code><br />
<br />
===Learner report by Learner with grades===<br />
Which Learners in which course and what are the grades<br />
<code sql><br />
SELECT u.firstname AS 'Name' , u.lastname AS 'Surname', c.fullname AS 'Course', cc.name AS 'Category', <br />
CASE WHEN gi.itemtype = 'Course' <br />
THEN c.fullname + ' Course Total' <br />
ELSE gi.itemname <br />
END AS 'Item Name', ROUND(gg.finalgrade,2) AS Score,ROUND(gg.rawgrademax,2) AS Max, ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) as Percentage,<br />
<br />
if (ROUND(gg.finalgrade / gg.rawgrademax * 100 ,2) > 79,'Yes' , 'No') as Pass<br />
<br />
FROM prefix_course AS c <br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid <br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id <br />
JOIN prefix_user AS u ON u.id = ra.userid <br />
JOIN prefix_grade_grades AS gg ON gg.userid = u.id <br />
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid <br />
JOIN prefix_course_categories AS cc ON cc.id = c.category <br />
WHERE gi.courseid = c.id and gi.itemname != 'Attendance'<br />
ORDER BY `Name` ASC<br />
</code><br />
<br />
<br />
==Activity Module Reports==<br />
<br />
===How many SCORM activities are used in each Course===<br />
<code sql><br />
SELECT cm.course,c.fullname ,m.name <br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/scorm/index.php?id=',c.id,'">',count(cm.id),'</a>') AS Counter<br />
<br />
FROM `prefix_course_modules` as cm <br />
JOIN prefix_modules as m ON cm.module=m.id <br />
JOIN prefix_course as c ON cm.course = c.id <br />
WHERE m.name LIKE '%scorm%' <br />
GROUP BY cm.course,cm.module <br />
ORDER BY count(cm.id) desc<br />
</code><br />
<br />
===Detailed ACTIONs for each MODULE===<br />
<code sql><br />
SELECT module,action,count(id) as counter<br />
FROM prefix_log<br />
GROUP BY module,action<br />
ORDER BY module,counter desc<br />
</code><br />
<br />
===Most popular ACTIVITY===<br />
<code sql><br />
SELECT COUNT(l.id) hits, module<br />
FROM prefix_log l<br />
WHERE module != 'login' AND module != 'course' AND module != 'role'<br />
GROUP BY module<br />
ORDER BY hits DESC<br />
</code><br />
<br />
===System wide use of ACTIVITIES and RESOURCES===<br />
<code sql><br />
SELECT count( cm.id ) AS counter, m.name<br />
FROM `prefix_course_modules` AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
GROUP BY cm.module<br />
ORDER BY counter DESC<br />
</code><br />
<br />
===LOG file ACTIONS per MODULE per COURSE (IDs)===<br />
<code sql><br />
select course,module,action,count(action) as summa from prefix_log<br />
where action <> 'new'<br />
group by course,action,module<br />
order by course,module,action<br />
</code><br />
<br />
===System Wide usage count of various course Activities===<br />
(Tested and works fine in Moodle 2.x)<br />
Like: Forum, Wiki, Blog, Assignment, Database,<br />
#Within specific category<br />
#Teacher name in course<br />
<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course<br />
<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher <br />
<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%forum%') AS Forums<br />
<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%data%') AS Databses<br />
<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%assignment%') AS Assignments<br />
<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students<br />
<br />
FROM prefix_course AS c<br />
WHERE c.category IN ( 18)<br />
ORDER BY Wikis DESC,Blogs DESC, Forums DESC<br />
</code><br />
<br />
===Course wiki usage/activity over the last 6 semesters===<br />
<code sql><br />
SELECT "Courses with Wikis"<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','2010','%') and c.fullname LIKE '%Semester A%') AS '2010 <br/> Semester A'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','2010','%') and c.fullname LIKE '%Semester B%') AS '2010 <br/> Semester B'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעא','%') and c.fullname LIKE '%סמסטר א%') AS 'תשעא <br/> סמסטר א'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעא','%') and c.fullname LIKE '%סמסטר ב%') AS 'תשעא <br/> סמסטר ב'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעב','%') and c.fullname LIKE '%סמסטר א%') AS 'תשעב <br/> סמסטר א'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעב','%') and c.fullname LIKE '%סמסטר ב%') AS 'תשעב <br/> סמסטר ב'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעג','%') and c.fullname LIKE '%סמסטר א%') AS 'תשעג <br/> סמסטר א'<br />
<br />
,(SELECT count( m.name ) AS count FROM <br />
prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_course AS c ON c.id = cm.course<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%'<br />
and c.fullname LIKE CONCAT('%','תשעג','%') and c.fullname LIKE '%סמסטר ב%') AS 'תשעג <br/> סמסטר ב'<br />
</code><br />
<br />
===Detailed WIKI activity (per wiki per course)===<br />
Including Number of Students in course (for reference)<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',cm.course,'">',c.fullname,'</a>') as CourseID <br />
,(SELECT Count( ra.userid ) AS Users<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id ) AS Students<br />
,m.name<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%updat%' ) as 'UPDAT E'<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%annotate%' ) as ANNOTATE<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%comment%' ) as COMMENT<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%add%' ) as 'A DD'<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action LIKE '%edit%' ) as EDIT<br />
, ( SELECT count(id) FROM prefix_log WHERE cmid = cm.id AND action NOT LIKE '%view%' ) as 'All (NO View)'<br />
FROM `prefix_course_modules` as cm <br />
JOIN prefix_modules as m ON cm.module=m.id <br />
JOIN prefix_course as c ON cm.course = c.id <br />
WHERE m.name LIKE '%wiki%'<br />
GROUP BY cm.course,cm.module<br />
ORDER BY 'All (NO View)' DESC<br />
</code><br />
<br />
===Wiki usage, system wide===<br />
(you can filter the output by selecting some specific course categories : "WHERE c.category IN ( 8,13,15)")<br />
<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course<br />
<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%wiki%') AS Wikis<br />
<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%') AS 'WikiActivity<br/>ALL'<br />
<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%add%' ) AS 'WikiActivity<br/>ADD'<br />
<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%edit%' ) AS 'WikiActivity<br/>EDIT'<br />
<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%annotate%' ) AS 'WikiActivity<br/>ANNOTATE'<br />
<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.course = c.id AND l.module LIKE '%wiki%' and l.action LIKE '%comments%' ) AS 'WikiActivity<br/>Comments'<br />
<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students<br />
<br />
,(SELECT count(*) FROM prefix_ouwiki_pages as ouwp<br />
JOIN prefix_ouwiki as ouw ON ouw.id = ouwp.subwikiid<br />
WHERE ouw.course = c.id GROUP BY ouw.course ) as OUWikiPages<br />
<br />
,(SELECT count( DISTINCT nwp.pagename ) FROM prefix_wiki_pages AS nwp<br />
JOIN prefix_wiki AS nw ON nw.id = nwp.dfwiki WHERE nw.course = c.id ) As NWikiPages<br />
<br />
FROM prefix_course AS c<br />
WHERE c.category IN ( 8,13,15)<br />
HAVING Wikis > 0<br />
ORDER BY 'WikiActivity<br/>ALL' DESC<br />
</code><br />
<br />
===Aggregated Teacher activity by "WEB2" Modules===<br />
(Tested and works fine in Moodle 2.x)<br />
The NV column shows activity without VIEW log activity<br />
<code sql><br />
SELECT ra.userid, u.firstname,u.lastname<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%') AS Wiki<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%wiki%' AND l.action NOT LIKE '%view%') AS Wiki_NV<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%') AS Forum<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%forum%' AND l.action NOT LIKE '%view%') AS Forum_NV<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%') AS Blog<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%blog%' AND l.action NOT LIKE '%view%') AS Blog_NV<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%') AS Assignment<br />
,(SELECT count(*) FROM prefix_log as l WHERE l.userid = u.id AND l.module LIKE '%assignment%' AND l.action NOT LIKE '%view%') AS Assignment_NV<br />
FROM prefix_role_assignments AS ra <br />
JOIN prefix_user AS u ON u.id = ra.userid <br />
WHERE ra.roleid = 3 <br />
GROUP BY ra.userid<br />
</code><br />
<br />
===List all the certificates issued, sort by variables in the custom profile fields===<br />
Note: The SQL queries look intimidating at first, but isn't really that difficult to learn. I've seen in the forums that users wanted to do 'site-wide' groups in 1.9x. This is sort of the idea. It pulls all the certificates issued to all users sorted by the custom profile fields, which in my case is the Units or Depts (i.e. my site wide groups). Why certificates? I've explored with both grades and quizzes, the course admins are not really interested in the actual grades but whether the learner received a certificate (i.e. passed the course with x, y, z activities). It also saves me from creating groups and assigning them into the right groups. Even assigning in bulk is not efficient, since I have upward of 25 groups per course and constantly new learners enrolling in courses. The limitation is something to do with the server? as it only pull 5000 rows of data. If anyone figured out how to change this, please let me know. In the meantime, the work around is to pull only a few units/depts at a time to limit the number of rows. This is fine at the moment, since each course admin are only responsible for certain units/depts.<br />
<br />
<code sql><br />
SELECT<br />
DATE_FORMAT( FROM_UNIXTIME(prefix_certificate_issues.timecreated), '%Y/%m/%d' ) AS Date,<br />
prefix_certificate_issues.classname AS Topic,<br />
prefix_certificate.name AS Certificate,<br />
prefix_certificate_issues.studentname as Name,<br />
prefix_user_info_data.data AS Units<br />
<br />
FROM<br />
prefix_certificate_issues<br />
<br />
INNER JOIN prefix_user_info_data<br />
on prefix_certificate_issues.userid = prefix_user_info_data.userid<br />
<br />
INNER JOIN prefix_certificate<br />
on prefix_certificate_issues.certificateid = prefix_certificate.id<br />
<br />
WHERE prefix_user_info_data.data='Unit 1'<br />
OR prefix_user_info_data.data='Unit 2'<br />
OR prefix_user_info_data.data='Unit 3'<br />
<br />
ORDER BY Units, Name, Topic ASC<br />
</code><br />
<br />
===Counter Blog usage in Courses,system wide===<br />
What teachers in what courses, uses blogs and how many + student count in that course.<br />
<code sql><br />
<br />
SELECT ( @counter := @counter+1) as counter, <br />
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') as Course<br />
<br />
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_user AS u ON ra.userid = u.id<br />
JOIN prefix_context AS ctx ON ctx.id = ra.contextid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher<br />
<br />
,(SELECT count( m.name ) AS count FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
WHERE cm.course = c.id AND m.name LIKE '%blog%') AS Blogs<br />
<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students<br />
<br />
FROM prefix_course AS c, (SELECT @counter := 0) as s_init<br />
WHERE c.category IN ( 8,13,15)<br />
HAVING Blogs > 0<br />
ORDER BY Blogs DESC<br />
</code><br />
<br />
=== Elluminate (Blackboard Collaborate) - system wide usage===<br />
<code sql><br />
SELECT e.name As Session ,er.recordingsize<br />
,c.fullname As Course<br />
,u.firstname,u.lastname <br />
,DATE_FORMAT(FROM_UNIXTIME(e.timestart),'%d-%m-%Y') AS dTimeStart<br />
,concat('<a target="_new" href="%%WWWROOT%%/moodle/mod/elluminate/loadrecording.php?id=',er.id,'">Show</a>') AS RecordedSession<br />
<br />
FROM prefix_elluminate_recordings AS er<br />
JOIN prefix_elluminate AS e ON e.meetingid = er.meetingid<br />
JOIN prefix_course as c ON c.id = e.course<br />
JOIN prefix_user AS u ON u.id = e.creator <br />
ORDER BY er.recordingsize DESC<br />
</code><br />
<br />
==Assignment Module Reports==<br />
===All Ungraded Assignments===<br />
Returns all the submitted assignments that still need grading<br />
<code sql><br />
select <br />
u.firstname AS "First",<br />
u.lastname AS "Last",<br />
c.fullname AS "Course",<br />
a.name AS "Assignment"<br />
<br />
from prefix_assignment_submissions as asb<br />
join prefix_assignment as a ON a.id = asb.assignment<br />
join prefix_user as u ON u.id = asb.userid<br />
join prefix_course as c ON c.id = a.course<br />
join prefix_course_modules as cm ON c.id = cm.course<br />
<br />
where asb.grade < 0 and cm.instance = a.id<br />
and cm.module = 1<br />
<br />
order by c.fullname, a.name, u.lastname<br />
</code><br />
<br />
===All Ungraded Assignments w/ Link===<br />
Returns all the submitted assignments that still need grading, along with a link that goes directly to the submission to grade it. The links work if you view the report within Moodle.<br />
<code sql><br />
select <br />
u.firstname AS "First",<br />
u.lastname AS "Last",<br />
c.fullname AS "Course",<br />
a.name AS "Assignment",<br />
<br />
'<a href="http://education.varonis.com/mod/assignment/submissions.php' + char(63) +<br />
+ 'id=' + cast(cm.id as varchar) + '&userid=' + cast(u.id as varchar) <br />
+ '&mode=single&filter=0&offset=2">' + a.name + '</a>'<br />
AS "Assignmentlink"<br />
<br />
<br />
from prefix_assignment_submissions as asb<br />
join prefix_assignment as a ON a.id = asb.assignment<br />
join prefix_user as u ON u.id = asb.userid<br />
join prefix_course as c ON c.id = a.course<br />
join prefix_course_modules as cm ON c.id = cm.course<br />
<br />
where asb.grade < 0 and cm.instance = a.id and cm.module = 1<br />
<br />
order by c.fullname, a.name, u.lastname<br />
</code><br />
<br />
===Assignments (and Quizzes) waiting to be graded===<br />
This report requires a YEAR filter to be added (Available when using the latest block/configurable_reports)<br />
<br />
Which you can always remove, to make this query work on earlier versions.<br />
<br />
The report includes: <br />
*number of quizzes<br />
*unFinished Quiz attempts<br />
*Finished Quiz attempts<br />
*number of students<br />
*number of Assignments<br />
*number of submitted answers by students <br />
*number of unchecked assignments (waiting for the Teacher) in a Course.<br />
<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher <br />
<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/assignment/index.php?id=',c.id,'">מטלות</a>') AS Assignments<br />
<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/quiz/index.php?id=',c.id,'">בחנים</a>') AS 'Quizzes'<br />
<br />
,(SELECT COUNT(*) <br />
FROM prefix_course_modules cm <br />
JOIN prefix_modules as m ON m.id = cm.module <br />
WHERE m.name LIKE 'quiz' AND cm.course = c.id <br />
GROUP BY cm.course <br />
) AS 'nQuizzes'<br />
<br />
,(SELECT COUNT(*)<br />
FROM prefix_quiz_attempts AS qa<br />
JOIN prefix_quiz AS q ON q.id = qa.quiz<br />
WHERE q.course = c.id<br />
AND qa.timefinish = 0<br />
GROUP BY q.course) AS 'unFinished Quiz attempts'<br />
<br />
,(SELECT COUNT(*)<br />
FROM prefix_quiz_attempts AS qa<br />
JOIN prefix_quiz AS q ON q.id = qa.quiz<br />
WHERE q.course = c.id<br />
AND qa.timefinish > 0<br />
GROUP BY q.course) AS 'finished quiz attempts'<br />
<br />
,(SELECT Count( ra.userid ) AS Users<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5<br />
AND ctx.instanceid = c.id<br />
) AS nStudents<br />
<br />
<br />
,(<br />
SELECT count(a.id)<br />
FROM prefix_assignment AS a <br />
JOIN prefix_course_modules AS cm ON a.course = cm.course <br />
WHERE cm.instance = a.id AND cm.module = 1 AND a.course = c.id<br />
) nAssignments<br />
<br />
,(<br />
SELECT count(*)<br />
FROM prefix_assignment AS a <br />
WHERE a.course = c.id AND FROM_UNIXTIME(a.timedue) > NOW()<br />
GROUP BY a.course<br />
) 'Open <br/>Assignments'<br />
<br />
, CONCAT(ROUND( (100 / iAssignments ) * iOpenAssignments ) ,'%') 'unFinished <br/>Assignments <br/>(percent)'<br />
<br />
,(<br />
SELECT count(asb.id)<br />
FROM prefix_assignment_submissions AS asb<br />
JOIN prefix_assignment AS a ON a.id = asb.assignment<br />
JOIN prefix_course_modules AS cm ON a.course = cm.course <br />
WHERE asb.grade < 0 AND cm.instance = a.id AND cm.module = 1 AND a.course = c.id<br />
) 'unChecked <br/>Submissions' <br />
<br />
,(<br />
SELECT count(asb.id)<br />
FROM prefix_assignment_submissions AS asb<br />
JOIN prefix_assignment AS a ON a.id = asb.assignment<br />
JOIN prefix_course_modules AS cm ON a.course = cm.course <br />
WHERE cm.instance = a.id AND cm.module = 1 AND a.course = c.id<br />
) 'Submitted <br/>Assignments'<br />
<br />
FROM prefix_course AS c<br />
LEFT JOIN (<br />
SELECT course, count(*) AS iAssignments<br />
FROM prefix_assignment AS a <br />
GROUP BY a.course <br />
) AS tblAssignmentsCount ON tblAssignmentsCount.course = c.id<br />
<br />
LEFT JOIN (<br />
SELECT course, count(*) AS iOpenAssignments<br />
FROM prefix_assignment AS a <br />
WHERE FROM_UNIXTIME(a.timedue) > NOW()<br />
GROUP BY a.course <br />
) AS tblOpenAssignmentsCount ON tblOpenAssignmentsCount.course = c.id<br />
<br />
WHERE 1=1 <br />
#AND c.fullname LIKE '%תשעג%'<br />
%%FILTER_YEARS:c.fullname%%<br />
## You can enable the SEMESTER filter as well, <br />
## by uncommenting the following line:<br />
## %%FILTER_SEMESTERS:c.fullname%%<br />
ORDER BY 'Open <br/>Assignments' DESC<br />
</code><br />
<br />
===Who is using "Single File Upload" assignment===<br />
<code sql><br />
SELECT <br />
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher <br />
<br />
,ass.name as "Assignment Name"<br />
<br />
FROM <br />
prefix_assignment as ass<br />
<br />
JOIN <br />
prefix_course as c ON c.id = ass.course<br />
<br />
WHERE `assignmenttype` LIKE 'uploadsingle'<br />
</code><br />
<br />
==Resource Module Reports==<br />
===List "Recently uploaded files"===<br />
see what users are uploading<br />
<code sql><br />
SELECT FROM_UNIXTIME(time,'%Y %M %D %h:%i:%s') as time ,ip,userid,url,info <br />
FROM `prefix_log` <br />
WHERE `action` LIKE 'upload' <br />
ORDER BY `prefix_log`.`time` DESC<br />
</code><br />
<br />
===List Courses that loaded a specific file: "X"===<br />
Did the Teacher (probably) uploaded course's Syllabus ?<br />
<code sql><br />
SELECT c.id, c.fullname FROM `prefix_log` as l <br />
JOIN prefix_course as c ON c.id = l.course <br />
WHERE `action` LIKE '%upload%' AND ( info LIKE '%Syllabus%' OR info LIKE '%Sylabus%' ) GROUP BY c.id<br />
</code><br />
<br />
===All resources that link to some specific external website===<br />
+ link to course<br />
+ who's the teacher<br />
+ link to external resource<br />
<code sql><br />
SELECT<br />
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
,c.shortname,r.name<br />
,(SELECT CONCAT(u.firstname,' ', u.lastname) AS Teacher<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id LIMIT 1) AS Teacher<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/resource/view.php?id=',r.id,'">',r.name,'</a>') AS Resource<br />
FROM prefix_resource AS r <br />
JOIN prefix_course AS c ON r.course = c.id<br />
WHERE r.reference LIKE 'http://info.oranim.ac.il/home%' <br />
</code><br />
<br />
==="Compose Web Page" RESOURCE count===<br />
<code sql><br />
SELECT course,prefix_course.fullname, COUNT(*) AS Total<br />
FROM `prefix_resource`<br />
JOIN `prefix_course` ON prefix_course.id = prefix_resource.course<br />
WHERE type='html'<br />
GROUP BY course<br />
</code><br />
<br />
===Resource count in courses===<br />
+ (First)Teacher name<br />
+ Where course is inside some specific Categories<br />
<code sql><br />
SELECT <br />
COUNT(*) AS count<br />
,r.course <br />
,c.shortname shortname<br />
,c.fullname coursename<br />
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_user as u ON ra.userid = u.id<br />
JOIN prefix_context AS ctx ON ctx.id = ra.contextid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = r.course AND ctx.contextlevel = 50 LIMIT 1) AS Teacher<br />
FROM prefix_resource r <br />
JOIN prefix_course c ON r.course = c.id<br />
WHERE c.category IN (10,13,28,18,26)<br />
GROUP BY r.course<br />
ORDER BY COUNT(*) DESC<br />
</code><br />
<br />
==Forum Module Reports==<br />
===print all User's post in course Forums===<br />
@@COURSEID@@ is a variable the is replace by the current CourseID you are running the sql report from. if you are using the latest block/configurable_reports ! (You can always change it to a fixed course or remove it to display all courses.)<br />
<code sql><br />
SELECT <br />
concat('<a target="_new" href="%%WWWROOT%%/mod/forum/user.php?course=',c.id,'&id=',u.id,'&mode=posts">',CONCAT(u.firstname,' ', u.lastname),'</a>') As Fullname<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/forum/view.php?f=',fd.forum,'">',f.name,'</a>') AS Forum<br />
,count(*) as Posts<br />
,(SELECT count(*) FROM prefix_forum_discussions AS ifd JOIN prefix_forum as iforum ON iforum.id = ifd.forum WHERE ifd.userid = fp.userid AND iforum.id = f.id) AS cAllDiscussion<br />
<br />
FROM prefix_forum_posts AS fp <br />
JOIN prefix_user as u ON u.id = fp.userid <br />
JOIN prefix_forum_discussions AS fd ON fp.discussion = fd.id <br />
JOIN prefix_forum AS f ON f.id = fd.forum <br />
JOIN prefix_course as c ON c.id = fd.course <br />
WHERE fd.course = '@@COURSEID@@' <br />
GROUP BY f.id,u.id<br />
ORDER BY u.id<br />
</code><br />
===FORUM use Count per COURSE -- not including NEWS Forum!===<br />
<code sql><br />
SELECT prefix_course.fullname, prefix_forum.course, count(*) as total FROM prefix_forum<br />
INNER JOIN prefix_course<br />
ON prefix_course.id = prefix_forum.course<br />
WHERE NOT(prefix_forum.type = 'news')<br />
GROUP BY prefix_forum.course<br />
ORDER BY total desc<br />
</code><br />
<br />
===FORUM use Count per COURSE by type -- not including NEWS Forum!===<br />
<code sql><br />
SELECT prefix_course.fullname, prefix_forum.course, prefix_forum.type, count(*) as total FROM prefix_forum<br />
INNER JOIN prefix_course<br />
ON prefix_course.id = prefix_forum.course<br />
WHERE NOT(prefix_forum.type = 'news')<br />
GROUP BY prefix_forum.course,prefix_forum.type<br />
ORDER BY total desc<br />
</code><br />
<br />
===Forum activity - system wide===<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.id,'</a>') AS CourseID<br />
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_user AS u ON ra.userid = u.id<br />
JOIN prefix_context AS ctx ON ctx.id = ra.contextid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher<br />
,c.fullname as Course<br />
,f.type<br />
,(SELECT Count( ra.userid ) AS Users FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid = 5 AND ctx.instanceid = c.id) AS Students<br />
, fd.forum, f.name,count(*) AS cPostAndDisc<br />
,(SELECT count(*) FROM prefix_forum_discussions AS ifd WHERE ifd.forum = f.id) AS cDiscussion<br />
FROM prefix_forum_posts AS fp<br />
JOIN prefix_forum_discussions AS fd ON fd.id = fp.discussion<br />
JOIN prefix_forum AS f ON f.id = fd.forum<br />
JOIN prefix_course AS c ON c.id = f.course<br />
WHERE f.type != 'news' AND c.fullname LIKE '%2013%'<br />
## WHERE 1=1 <br />
## %%FILTER_YEARS:c.fullname%%<br />
## You can enable the SEMESTER filter as well, <br />
## by uncommenting the following line:<br />
## %%FILTER_SEMESTERS:c.fullname%%<br />
<br />
GROUP BY fd.forum<br />
ORDER BY count( * ) DESC<br />
</code><br />
<br />
===Activity In Forums===<br />
Trying to figure out how much real activity we have in Forums by aggregating:<br />
Users in Course, Number of Posts, Number of Discussions, Unique student post, Unique student discussions, Number of Teachers , Number of Students, ratio between unique Student posts and the number of students in the Course...<br />
<code sql><br />
SELECT c.fullname,f.name,f.type <br />
,(SELECT count(id) FROM prefix_forum_discussions as fd WHERE f.id = fd.forum) as Discussions<br />
,(SELECT count(distinct fd.userid) FROM prefix_forum_discussions as fd WHERE fd.forum = f.id) as UniqueUsersDiscussions<br />
,(SELECT count(fp.id) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as Posts<br />
,(SELECT count(distinct fp.userid) FROM prefix_forum_discussions fd JOIN prefix_forum_posts as fp ON fd.id = fp.discussion WHERE f.id = fd.forum) as UniqueUsersPosts<br />
,(SELECT Count( ra.userid ) AS Students<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid =5<br />
AND ctx.instanceid = c.id<br />
) AS StudentsCount<br />
,(SELECT Count( ra.userid ) AS Teachers<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid =3<br />
AND ctx.instanceid = c.id<br />
) AS 'Teacher<br/>Count'<br />
,(SELECT Count( ra.userid ) AS Users<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_context AS ctx ON ra.contextid = ctx.id<br />
WHERE ra.roleid IN (3,5)<br />
AND ctx.instanceid = c.id<br />
) AS UserCount<br />
, (SELECT (UniqueUsersDiscussions / StudentsCount )) as StudentDissUsage<br />
, (SELECT (UniqueUsersPosts /StudentsCount)) as StudentPostUsage<br />
FROM prefix_forum as f <br />
JOIN prefix_course as c ON f.course = c.id<br />
WHERE `type` != 'news'<br />
ORDER BY StudentPostUsage DESC<br />
</code><br />
<br />
===All Forum type:NEWS===<br />
<code sql><br />
SELECT f.id, f.name<br />
FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_forum AS f ON cm.instance = f.id<br />
WHERE m.name = 'forum'<br />
AND f.type = 'news'<br />
</code><br />
<br />
===All new forum NEWS items (discussions) from all my Courses===<br />
change "userid = 26" and "id = 26" to a new user id<br />
<code sql><br />
SELECT c.shortname,f.name,fd.name,FROM_UNIXTIME(fd.timemodified ,"%d %M %Y ") as Date<br />
FROM prefix_forum_discussions as fd <br />
JOIN prefix_forum as f ON f.id = fd.forum <br />
JOIN prefix_course as c ON c.id = f.course <br />
JOIN prefix_user_lastaccess as ul ON (c.id = ul.courseid AND ul.userid = 26)<br />
WHERE fd.timemodified > ul.timeaccess <br />
AND fd.forum IN (SELECT f.id<br />
FROM prefix_course_modules AS cm<br />
JOIN prefix_modules AS m ON cm.module = m.id<br />
JOIN prefix_forum AS f ON cm.instance = f.id<br />
WHERE m.name = 'forum'<br />
AND f.type = 'news')<br />
AND c.id IN (SELECT c.id<br />
FROM prefix_course AS c<br />
JOIN prefix_context AS ctx ON c.id = ctx.instanceid<br />
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id<br />
JOIN prefix_user AS u ON u.id = ra.userid<br />
WHERE u.id = 26) ORDER BY `fd`.`timemodified` DESC<br />
</code><br />
<br />
<br />
===News Forum - Discussions COUNT===<br />
Which is actually... How much instructions students get from their teachers<br />
<code sql><br />
SELECT c.shortname ,<br />
concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
,( SELECT DISTINCT CONCAT(u.firstname,' ',u.lastname)<br />
FROM prefix_role_assignments AS ra<br />
JOIN prefix_user AS u ON ra.userid = u.id<br />
JOIN prefix_context AS ctx ON ctx.id = ra.contextid<br />
WHERE ra.roleid = 3 AND ctx.instanceid = c.id AND ctx.contextlevel = 50 LIMIT 1) AS Teacher<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/forum/view.php?f=',fd.forum,'">',count(fd.id),'</a>') AS DiscussionsSum<br />
FROM prefix_forum_discussions AS fd<br />
INNER JOIN prefix_forum AS f ON f.id = fd.forum<br />
INNER JOIN prefix_course AS c ON c.id = f.course<br />
WHERE f.type = 'news' AND c.category IN (10,13,28,18,26)<br />
GROUP BY fd.forum<br />
ORDER BY count(fd.id) DESC<br />
</code><br />
<br />
==Quiz Module Reports==<br />
===Generate a list of instructors and their email addresses for those courses that has "essay questions" in their quizzes===<br />
<code sql><br />
SELECT qu.id AS quiz_id, qu.course AS course_id, qu.questions,<br />
co.fullname AS course_fullname, co.shortname AS course_shortname,<br />
qu.name AS quiz_name, FROM_UNIXTIME(qu.timeopen) AS quiz_timeopen, FROM_UNIXTIME(qu.timeclose) AS quiz_timeclose,<br />
u.firstname, u.lastname, u.email,<br />
FROM mdl_quiz qu, mdl_course co, mdl_role re, mdl_context ct, mdl_role_assignments ra, mdl_user u<br />
WHERE FROM_UNIXTIME(timeopen) > '2008-05-14' AND<br />
qu.course = co.id AND<br />
co.id = ct.instanceid AND<br />
ra.roleid = re.id AND<br />
re.name = 'Teacher' AND<br />
ra.contextid = ct.id AND<br />
ra.userid = u.id<br />
<br />
SELECT Count('x') As NumOfStudents<br />
FROM mdl_role_assignments a<br />
JOIN mdl_user u ON userid = u.id<br />
WHERE roleid = 5 AND contextid = (SELECT id FROM mdl_context WHERE instanceid = 668 AND contextlevel = 50)<br />
</code><br />
<br />
===Number of Quizes per Course===<br />
<code sql><br />
SELECT count(*)<br />
,concat('<a target="_new" href="%%WWWROOT%%/course/view.php?id=',c.id,'">',c.fullname,'</a>') AS Course<br />
,concat('<a target="_new" href="%%WWWROOT%%/mod/quiz/index.php?id=',c.id,'">Link</a>') AS Quizes<br />
<br />
FROM prefix_course_modules cm<br />
JOIN prefix_course c ON c.id = cm.course<br />
JOIN prefix_modules as m ON m.id = cm.module<br />
WHERE m.name LIKE 'quiz'<br />
GROUP BY c.id<br />
</code><br />
<br />
===List all MultiAnswer (Cloze) Questions===<br />
<code sql><br />
SELECT concat('<a target="_new" href="%%WWWROOT%%/mod/quiz/attempt.php?q=', quiz.id, '">', quiz.name, '</a>') AS Quiz<br />
,question.id question_id, question.questiontext <br />
FROM prefix_question question<br />
JOIN prefix_quiz_question_instances qqi ON question.id = qqi.question<br />
JOIN prefix_quiz quiz ON qqi.quiz = quiz.id<br />
WHERE `qtype` LIKE 'multianswer'<br />
</code><br />
<br />
===List courses with MANUAL grades===<br />
Which is basically and indication to teachers using Moodle to hold offline grades inside Moodle's Grade-Book,<br />
So grades could be uploaded into an administrative SIS.<br />
<code sql><br />
SELECT COUNT( * )<br />
,concat('<a target="_new" href="%%WWWROOT%%/grade/edit/tree/index.php?showadvanced=1&id=',c.id,'">',c.fullname,'</a>') AS Course<br />
FROM prefix_grade_items AS gi<br />
JOIN prefix_course as c ON c.id = gi.courseid<br />
WHERE `itemtype` = 'manual'<br />
GROUP BY courseid<br />
</code><br />
===List the users that did not took the Quiz===<br />
Do not forget to change "c.id = 14" and q.name LIKE '%quiz name goes here%'<br />
<code sql><br />
SELECT<br />
user2.id AS ID,<br />
ul.timeaccess,<br />
user2.firstname AS Firstname,<br />
user2.lastname AS Lastname,<br />
user2.email AS Email,<br />
user2.username AS IDNumber,<br />
user2.institution AS Institution,<br />
<br />
IF (user2.lastaccess = 0,'never',<br />
DATE_FORMAT(FROM_UNIXTIME(user2.lastaccess),'%Y-%m-%d')) AS dLastAccess<br />
<br />
,(SELECT DATE_FORMAT(FROM_UNIXTIME(timeaccess),'%Y-%m-%d') FROM prefix_user_lastaccess WHERE userid=user2.id AND courseid=c.id) AS CourseLastAccess<br />
<br />
,(SELECT r.name<br />
FROM prefix_user_enrolments AS uenrol<br />
JOIN prefix_enrol AS e ON e.id = uenrol.enrolid<br />
JOIN prefix_role AS r ON e.id = r.id<br />
WHERE uenrol.userid=user2.id AND e.courseid = c.id) AS RoleName<br />
<br />
FROM prefix_user_enrolments AS ue<br />
JOIN prefix_enrol AS e ON e.id = ue.enrolid<br />
JOIN prefix_course AS c ON c.id = e.courseid<br />
JOIN prefix_user AS user2 ON user2 .id = ue.userid<br />
LEFT JOIN prefix_user_lastaccess AS ul ON ul.userid = user2.id<br />
WHERE c.id=14 and ue.userid NOT IN (SELECT qa.userid FROM prefix_quiz_attempts AS qa<br />
JOIN prefix_quiz AS q ON qa.quiz = q.id<br />
JOIN prefix_course AS c ON q.course = c.id<br />
WHERE c.id = 14 AND q.name LIKE '%quiz name goes here%')<br />
</code><br />
<br />
==SCORM Activity Reports==<br />
<br />
===Lists All completed SCORM activites by Course name===<br />
This report will list all completed attempts for all SCORM activities. It is ordered first by Course name, then student's last name, then student's first name, then attempt number. Please note: the FROM_UNIXTIME command is for MySQL.<br />
<code sql><br />
SELECT u.firstname First,u.lastname Last,c.fullname Course, st.attempt Attempt,st.value Status,FROM_UNIXTIME(st.timemodified,"%m-%d-%Y") Date <br />
FROM prefix_scorm_scoes_track AS st <br />
JOIN prefix_user AS u ON st.userid=u.id<br />
JOIN prefix_scorm AS sc ON sc.id=st.scormid<br />
JOIN prefix_course AS c ON c.id=sc.course<br />
WHERE st.value='completed' <br />
ORDER BY c.fullname, u.lastname,u.firstname, st.attempt<br />
</code><br />
<br />
[[Category:Contributed code]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Quiz_statistics_report&diff=103306Quiz statistics report2013-02-21T22:23:02Z<p>Joeythibault: video in link no longer available</p>
<hr />
<div>{{Quiz reports}}<br />
''Navigation > Course > Quiz name > Results > Statistics''<br />
<br />
This report gives a statistical (psychometric) analysis of the quiz, and the questions within it. The top section of this report gives a summary of the whole quiz. The next section gives an analysis showing all questions in a table format. There are links in this section to edit individual questions or drill down into a detailed analysis of a particular question. The last section of this report is a bar graph of the percent of correct answers (Facility index) and the Discriminative efficiency index.<br />
<br />
The full report (overview, and detailed analysis of all questions) can be downloaded in a variety of formats, as can the quiz structure analysis table.<br />
<br />
===Overall quiz statistics===<br />
Here are the details concerning information in this robust report.<br />
<br />
====Quiz information====<br />
<br />
This section gives some basic information about the test as a whole. You will see:<br />
* Quiz name<br />
* Course name<br />
* Open and close dates (if applicable)<br />
* Total number of first/graded attempts<br />
* Average grade for first/all attempts<br />
* Median grade<br />
* Standard deviation of grades <br />
* [http://en.wikipedia.org/wiki/Skewness Skewness] and [http://en.wikipedia.org/wiki/Kurtosis Kurtosis] of the grade distribution<br />
* Coefficient of internal consistency (sometimes called [http://en.wikipedia.org/wiki/Cronbach%27s_alpha Cronbach Alpha]) - This is a measure of whether all the items in the quiz are testing basically the same thing. Thus it measures the consistency of the text, which is a lower bound for the validity. Higher numbers here are better.<br />
* Error ratio - the variation in the grades comes from two sources. First some students are better than others at what is being tested, and second there is some random variation. We hope that the quiz grades will largely be determined by the student's ability, and that random variation will be minimised. The error ratio estimates how much of the variation is random, and so lower is better.<br />
* Standard error - this is derived from the error ratio, and is a measure of how much random variation there is in each test grade. So, if the Standard error is 10%, and a student scored 60%, then their real ability probably lies somewhere between 50% and 70%.<br />
[[File:Quiz_results_statistics_information.png|thumb|center|Example of quiz information section]]<br />
<br />
====Quiz structure analysis====<br />
<br />
This section lists all the questions in the quiz with various statistics in a table format.<br />
<br />
* '''Q#''' - shows the question number (position), question type icon, and preview and edit icons<br />
* '''Question name''' - the name is also a link to the detailed analysis of this question (See Quiz Question Statistics below).<br />
* '''Attempts''' - how many students attempted this question.<br />
* '''Facility Index''' - the percentage of students that answered the question correctly.<br />
* '''[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]''' - how much variation there was in the scores for this question.<br />
* '''Random guess score''' - the score the student would get by guessing randomly<br />
* '''Intended/Effective weight''' - Intended weight is simply what you set up when editing the quiz. If question 1 is worth 3 marks out of a total of 10 for the quiz, the the intended weight is 30%. The effective weight is an attempt to estimate, from the results, how much of the actual variation was due to this question. So, ideally the effective weights should be close to the intended weights.<br />
* '''Discrimination index''' - this is the correlation between the score for this question and the score for the whole quiz. That is, for a good question, you hope that the students who score highly on this question are the same students who score highly on the whole quiz. Higher numbers are better.<br />
* '''Discriminative efficiency''' - another measure that is similar to Discrimination index.<br />
<br />
:Where random questions are used, there is one row in the table for the random question, followed by further rows, one for each real question that was selected in place of this random question.<br />
:When quiz questions are randomized for each quiz, the quiz module determines a default position.<br />
:[[:dev:Quiz_statistics_calculations|Quiz statistics calculations]] gives further details on all these quantities.<br />
[[File:Quiz_results_statistics_structure_analysis.png|thumb|center|Example of statistics structural analysis section]]<br />
====Quiz statistics chart====<br />
[[File:Quiz_results_statistics_chart.png|thumb|center|Chart example]]<br />
<br />
===Quiz question statistics===<br />
Navigation > quiz's name > Results > Statistics (click on any question title)<br />
It is possible to see the statistics for one question on a single page. This view will also tell you what percentage of quiz takers selected each answer (Analysis of responses) and give you basic information about the question.<br />
<br />
*Question information- The basic information about the question, the name of the quiz, the question, the question type, the position in the quiz and the question itself. There are preview and edit icons in this page.<br />
*Question statistics - This repeats the information from the table row from the Quiz structure analysis that relates to this question.<br />
*Report options - You can choose whether to run the report on all attempts, or just the first attempt by each student. Some of the calculations used in the report are based on assumptions that may not apply to quizzes that allow more than one attempt.<br />
<br />
'':Tip:'' Computing the statistics takes some time, the report will store the computed values and re-use them for up to 15 minutes. Therefore, there is a display of how recently the statistics were calculated, with a button to recalculate them immediatel<br />
<br />
<gallery><br />
File:Quiz_results_statistics_individual_question_preferences.png|Individual question page preferences<br />
File:Quiz_results_statistics_individual_question_information.png|Individual question's information<br />
File:Quiz_results_statistics_individual_question_statistics.png|Individual question's statistic information<br />
</gallery><br />
<br />
====Analysis of individual question responses====<br />
<br />
This gives a frequency analysis of the different responses that were given to each part of the question. The details of the analysis depends on the question type, and not all question types support this. For example, essay question responses cannot be analyzed.<br />
<br />
[[File:Quiz_results_statistics_individual_question_analysis_responses.png|thumb|center|Individual question's responses statistic information]]<br />
<br />
[[de:Test-Statistik]]<br />
[[es:Quiz_statistics_report]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Amazon_EC2_Cloud_Services_Installation&diff=96887Amazon EC2 Cloud Services Installation2012-04-11T11:44:10Z<p>Joeythibault: </p>
<hr />
<div>This is essentially a linux box in the cloud but at the time of writing I did not like to add it to the Linux category, it seems more general than that somehow. If this install lacks detail or doesn't work then see comments attached to this page. I start this off with some assumptions and then go though a full install using the cli. <br />
The assumptions are that you have an Amazon 32 bit EC2 Linux server setup and you have ssh & http access to it.<br />
<br />
= Install all the requirements =<br />
From the cli as root or sudo<br />
<br />
yum install httpd<br />
yum install mysql-server <br />
yum install git<br />
yum install php<br />
yum install php-gd <br />
yum install php-pear<br />
yum install php-mbstring<br />
yum install php-mcrypt <br />
yum install php-mbstring <br />
yum install memcached <br />
yum install php-mcrypt <br />
yum install php-zts <br />
yum install php-xmlrpc <br />
yum install php-soap <br />
yum install php-intl <br />
yum install php-zip <br />
yum install php-zts<br />
yum install php-xml<br />
<br />
= To ensure that mysql and httpd come up on boot. =<br />
<br />
<br />
chkconfig mysqld on <br />
chkconfig httpd on<br />
<br />
= To ensure that utf8 is used by mysql = <br />
<br />
edit /etc/my.cnf to read as follows (I have found that the precise lines required seem to vary as time goes on)<br />
Back up my.cnf first with <br />
cp /etc/my.cnf /etc/mycnf.original<br />
<br />
Then edit to read<br />
<br />
[mysqld]<br />
default-character-set=utf8<br />
default-collation=utf8_unicode_ci<br />
character-set-server=utf8<br />
collation-server=utf8_unicode_ci<br />
datadir=/var/lib/mysql<br />
socket=/var/lib/mysql/mysql.sock<br />
user=mysql<br />
# Disabling symbolic-links is recommended to prevent assorted security risks<br />
symbolic-links=0<br />
[mysqld_safe]<br />
log-error=/var/log/mysqld.log<br />
pid-file=/var/run/mysqld/mysqld.pid<br />
[client]<br />
default-character-set=utf8<br />
<br />
Check that mysql restarts with <br />
service mysqld restart<br />
<br />
NB edit. Later with FC16 I found that I needed to make my.cnf read<br />
<br />
[mysqld]<br />
# Settings user and group are ignored when systemd is used.<br />
# If you need to run mysqld under different user or group, <br />
# customize your systemd unit file for mysqld according to the<br />
# instructions in http://fedoraproject.org/wiki/Systemd<br />
character-set-server=utf8<br />
collation-server=utf8_unicode_ci<br />
datadir=/var/lib/mysql<br />
socket=/var/lib/mysql/mysql.sock<br />
# Disabling symbolic-links is recommended to prevent assorted security risks<br />
symbolic-links=0<br />
<br />
[mysqld_safe]<br />
log-error=/var/log/mysqld.log<br />
pid-file=/var/run/mysqld/mysqld.pid<br />
<br />
= In order to make sure php is included when httpd comes up =<br />
<br />
make sure you have a file called /etc/httpd/conf.d/php.conf whose contents are like the following<br />
<br />
<IfModule prefork.c><br />
LoadModule php5_module modules/libphp5.so<br />
</IfModule> <IfModule worker.c><br />
LoadModule php5_module modules/libphp5-zts.so<br />
</IfModule><br />
AddHandler php5-script .php AddType text/html .php<br />
DirectoryIndex index.php<br />
<br />
<br />
At the time of writing 26-01-2012) (php-common should provide zip.so but it doesn't so I have put a copy here (http://moodle.org/mod/forum/discuss.php?d=194589))<br />
Attached to a forum post. Perhaps a wiki buff could fix that better.<br />
<br />
Once you have got zip.so, put it in /usr/lib/php/modules<br />
<br />
Also you need to add<br />
<br />
extension=zip.so<br />
<br />
to your php.ini (in /etc)<br />
<br />
= Create the database, database user and access rights =<br />
run<br />
<br />
mysql_secure_installation<br />
<br />
Answer all the questions conservatively. (e.g. You will not need test databases or for root to have any other mysql access than local.) This will create a root mysql pw for you. Mysql users are nothing whatsoever to do with you unix users.<br />
<br />
run<br />
mysql -u root -p<br />
<password you set above><br />
<br />
In mysql you need to <br />
<br />
1. make a database. The name can be anything you like. I used moodledb<br />
<br />
2. make a database user. The name can be anything you like. I used moodledbuser.<br />
<br />
3. give that user rights to access the database from the localhost. <br />
<br />
4. No db access is required by anyone from any other host than the localhost<br />
<br />
<br />
<br />
** Now you are in mysql and all the commands are mysql commands and could equally be run on a windows instance of mysql. Do not forget the ";" after each command.<br />
<br />
create database moodledb;<br />
grant all privileges on moodledb.* to moodledbuser@localhost identified by '<put a pw here>';<br />
quit<br />
<br />
TEST the above by doing<br />
<br />
mysql -u moodledbuser -p<br />
<password><br />
<br />
If you get connected OK then you can go on and quit.<br />
<br />
= Create moodledata folder =<br />
mkdir /var/www/moodledata<br />
<br />
The default root folder for apache is /var/www/html and so moodledata is not accessible from the web.<br />
Next, give the apache user all the access rights to moodledata. This is better than chmod 777 which some users seem to do.<br />
<br />
chown apache:apache /var/www/moodledata<br />
<br />
= Fetch moodle =<br />
<br />
cd /var/www/html<br />
git clone git://git.moodle.org/moodle.git<br />
<br />
This should put all of moodle in a directory called moodle in the correct folder /var/www/html. It takes a while but you get %age feedback.<br />
<br />
There are more sophisticated git commands, see git docs in moodle docs for more info.<br />
Also, you may give the apache user ownership of the site, this way, when you install, the script will be able to create the config.php file.<br />
If you leave the owner as root, you will have to paste the suggested config.php into /var/www/html/moodle<br />
<br />
To give apache ownership do<br />
<br />
chown -R apache:apache /var/www/html/moodle<br />
<br />
= Do the install =<br />
<br />
Visit http://<your amazon host>/moodle<br />
<br />
Well, it worked for me!<br />
<br />
= Other Resources = <br />
<br />
For another method of using Amazon EC2 for Moodle hosting you can utilize the free image created by Bitnami.org: http://bitnami.org/stack/moodle which makes creating a Moodle server on Amazon a snap (no command line necessary)</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Free_Moodle&diff=87811Free Moodle2011-08-15T16:44:30Z<p>Joeythibault: </p>
<hr />
<div>{{Improve}}{{Try Moodle}}<br />
<br />
<table width="100%" border="1"><br />
<br />
<tr><br />
<td><strong>Org</strong></td><br />
<td><strong>URL</strong></td><br />
<td><strong>Ads?</strong></td><br />
<td><strong>3rd party plug-ins</strong></td><br />
<td><strong>Mobile-Enabled</strong></td><br />
<td><strong>Support</strong></td><br />
<td><strong>Business </strong><strong>Plan</strong></td><br />
<td><strong>Limits</strong></td><br />
<td><strong>Comm-</strong><br />
<strong>unity</strong></td><br />
<td><strong>Basic Plan</strong></td><br />
</tr><br />
<tr><br />
<td>MoodleReader</td><br />
<td>http://moodlereader.org</td><br />
<td>no</td><br />
<td>Graded reader module</td><br />
<td>no</td><br />
<td>email/forums</td><br />
<td>University/Gov't funded</td><br />
<td>Legit edu orgs only</td><br />
<td>25+</td><br />
<td>1 course, full access to the module &amp; 900+ book resources</td><br />
</tr><br />
<tr><br />
<td>MDL2.com</td><br />
<td>http://mdl2.com</td><br />
<td>yes</td><br />
<td>no</td><br />
<td>no</td><br />
<td>FAQs</td><br />
<td>ad supported</td><br />
<td>250 MB upload</td><br />
<td></td><br />
<td>full Moodle 2.0 site with Admin access</td><br />
</tr><br />
<tr><br />
<td>Ninehub</td><br />
<td>http://ninehub.com</td><br />
<td>yes</td><br />
<td>no</td><br />
<td>no</td><br />
<td>NA</td><br />
<td>Web development company</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>Full admin rights; unrestricted &amp; unlimited disk space</td><br />
</tr><br />
<tr><br />
<td>iTeach.org</td><br />
<td>http://iteach.org</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>For teachers, by teachers</td><br />
<td>100MB</td><br />
<td>NA</td><br />
<td>Must be a current teacher in a US private/public school (verified by phone</td><br />
</tr><br />
<tr><br />
<td>FreeWebClass</td><br />
<td>http://www.FreeWebClass.com</td><br />
<td>yes</td><br />
<td>no</td><br />
<td>no</td><br />
<td>NA</td><br />
<td>Freemium</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>35 user limit (for free version); 1 GB bandwidth; 10 GB storage</td><br />
</tr><br />
<tr><br />
<td>MoodleShare</td><br />
<td>http://courses.moodleshare.com</td><br />
<td>no</td><br />
<td>no</td><br />
<td>no</td><br />
<td>NA</td><br />
<td>NA</td><br />
<td>1 course</td><br />
<td>NA</td><br />
<td>editing teacher rights</td><br />
</tr><br />
<tr><br />
<td>Sqooltools</td><br />
<td>http://sqooltools.com</td><br />
<td>yes</td><br />
<td>yes^</td><br />
<td>no</td><br />
<td>self serve is free, $10 per ticket for help desk</td><br />
<td>Freemium model</td><br />
<td>yes</td><br />
<td>NA</td><br />
<td>k-12 only, 1 course, 30 students, 250MB</td><br />
</tr><br />
<tr><br />
<td>Gnomio</td><br />
<td>http://gnomio.com</td><br />
<td>yes</td><br />
<td>yes</td><br />
<td>mle</td><br />
<td>NA</td><br />
<td>Donations</td><br />
<td>no</td><br />
<td>1000+ sites</td><br />
<td>Full admin rights; honor code (no large files)</td><br />
</tr><br />
<tr><br />
<td>KeytoSchool²</td><br />
<td>http://keytoschool.com</td><br />
<td>no</td><br />
<td>yes</td><br />
<td>coming<br />
soon</td><br />
<td>forums</td><br />
<td>Non-profit/Freemium</td><br />
<td>NA</td><br />
<td>help site/FAQs</td><br />
<td>Full admin rights; 500 users &amp; 1/2 GB storage</td><br />
</tr><br />
<tr><br />
<td>TuitionClass</td><br />
<td>http://tuitionclass.net</td><br />
<td>no</td><br />
<td>no</td><br />
<td>no</td><br />
<td>NA</td><br />
<td>Supported by service/hosting company</td><br />
<td>128 MB upload limit</td><br />
<td>NA</td><br />
<td>Editing teacher/course creation rights</td><br />
</tr><br />
<tr><br />
<td>e-Socrates²</td><br />
<td>http://e-socrates.org</td><br />
<td>yes</td><br />
<td>no</td><br />
<td>no</td><br />
<td>forums (English and Italian)</td><br />
<td>IT company, focused on open source software</td><br />
<td>courses must be open</td><br />
<td>1000+ courses</td><br />
<td>1 course</td><br />
</tr><br />
<tr><br />
<td>Learning<br />
Objectivity²</td><br />
<td>http://learningobjectivity.com</td><br />
<td>no</td><br />
<td>NA</td><br />
<td>no</td><br />
<td>self serve, email</td><br />
<td>Consultancy</td><br />
<td>NA</td><br />
<td>67 courses</td><br />
<td>1 course</td><br />
</tr><br />
<tr><br />
<td>000webhost¹</td><br />
<td>http://www.000webhost.com/</td><br />
<td>no</td><br />
<td>no</td><br />
<td>no</td><br />
<td>no</td><br />
<td>Freemium</td><br />
<td>1.5 GB storage; 100 GB bandwidth</td><br />
<td>NA</td><br />
<td>full admin rights</td><br />
</tr><br />
<br />
</table><br />
^audio recording only, other 3rd party modules with paid contract.<br />
<br />
¹note that this enables site set up via cPanel<br />
<br />
²these hosting companies are currently not accepting new registrants. In the case of K2S it's been said that they are waiting for the release of Moodle 2.0.<br />
<br />
Originally created and published at http://www.Moodlenews.com/hosting</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Moodle_research&diff=82073Moodle research2011-03-18T19:49:42Z<p>Joeythibault: /* Print (papers, reports, collections, theses...) */</p>
<hr />
<div>A growing, community-contributed collection of research into LMS (Learning Management Systems) and particularly Moodle.<br />
<br />
=Moodle-specific research=<br />
Academic, governmental, organisational research (mostly) involving Moodle (design, use, implementation...). Check [[Moodle research FAQ|here]] for details. <br />
==Print (papers, reports, collections, theses...)==<br />
*Rakoczi, Gergely. (2010) [http://www.fm-kp.si/zalozba/ISBN/978-961-266-066-6/prispevki/rakoczi.pdf "Cast your Eyes on Moodle: An Eye Tracking Study investigating learning with Moodle"]<br />
<br />
==Presentations and videos==<br />
==Other material (eg projects)==<br />
<br />
=LMS research - general=<br />
Broader academic, governmental, organisational research on LMS/VLE useful to Moodle to learn from. Check [[Moodle research FAQ|here]] for details. <br />
==Print (papers, reports, collections, theses...)==<br />
*Carmean, C. & Haefner,J. (2002). [http://net.educause.edu/ir/library/pdf/ERM0261.pdf Mind over matter: Transforming course management systems into effective learning environments]. EDUCAUSE Review, Vol. 37, No. 6, pp. 27–33.<br />
*Chang, Chinhong Lim (2008) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Faculty Perceptions and Utilization of a Learning Management System in Higher Education] (dissertation)<br />
*Keesee, G. & Shepard, M.(2011) [http://www.westga.edu/~distance/ojdla/spring141/keesee_shepard141.html Perceived Attributes Predict Course Management System Adopter Status]. Online Journal of Distance Learning Administration, Vol 14/1.<br />
*Lane, L. (2009) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Insidious pedagogy: How course management systems impact teaching]. First Monday, Vol. 14, Number 10 - 5 Oct 2009<br />
*[http://en.wikipedia.org/wiki/Ofsted OFSTED] (2009) [http://www.ofsted.gov.uk/Ofsted-home/Publications-and-research/Browse-all-by/Documents-by-type/Thematic-reports/Virtual-learning-environments-an-evaluation-of-their-development-in-a-sample-of-educational-settings Virtual learning environments: an evaluation of their development in a sample of educational settings].<br />
<br />
==Presentations and videos==<br />
==Other material==<br />
=Questions? Try here=<br />
See the growing list at [[Moodle research FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Moodle_research&diff=82072Moodle research2011-03-18T19:48:34Z<p>Joeythibault: /* Print (papers, reports, collections, theses...) */</p>
<hr />
<div>A growing, community-contributed collection of research into LMS (Learning Management Systems) and particularly Moodle.<br />
<br />
=Moodle-specific research=<br />
Academic, governmental, organisational research (mostly) involving Moodle (design, use, implementation...). Check [[Moodle research FAQ|here]] for details. <br />
==Print (papers, reports, collections, theses...)==<br />
*Rakoczi, Gergely. "Cast your Eyes on Moodle: An Eye Tracking Study investigating learning with Moodle" [http://www.fm-kp.si/zalozba/ISBN/978-961-266-066-6/prispevki/rakoczi.pdf]<br />
<br />
==Presentations and videos==<br />
==Other material (eg projects)==<br />
<br />
=LMS research - general=<br />
Broader academic, governmental, organisational research on LMS/VLE useful to Moodle to learn from. Check [[Moodle research FAQ|here]] for details. <br />
==Print (papers, reports, collections, theses...)==<br />
*Carmean, C. & Haefner,J. (2002). [http://net.educause.edu/ir/library/pdf/ERM0261.pdf Mind over matter: Transforming course management systems into effective learning environments]. EDUCAUSE Review, Vol. 37, No. 6, pp. 27–33.<br />
*Chang, Chinhong Lim (2008) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Faculty Perceptions and Utilization of a Learning Management System in Higher Education] (dissertation)<br />
*Keesee, G. & Shepard, M.(2011) [http://www.westga.edu/~distance/ojdla/spring141/keesee_shepard141.html Perceived Attributes Predict Course Management System Adopter Status]. Online Journal of Distance Learning Administration, Vol 14/1.<br />
*Lane, L. (2009) [http://firstmonday.org/htbin/cgiwrap/bin/ojs/index.php/fm/article/view/2530/2303 Insidious pedagogy: How course management systems impact teaching]. First Monday, Vol. 14, Number 10 - 5 Oct 2009<br />
*[http://en.wikipedia.org/wiki/Ofsted OFSTED] (2009) [http://www.ofsted.gov.uk/Ofsted-home/Publications-and-research/Browse-all-by/Documents-by-type/Thematic-reports/Virtual-learning-environments-an-evaluation-of-their-development-in-a-sample-of-educational-settings Virtual learning environments: an evaluation of their development in a sample of educational settings].<br />
<br />
==Presentations and videos==<br />
==Other material==<br />
=Questions? Try here=<br />
See the growing list at [[Moodle research FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Project_Course_Format&diff=81217Project Course Format2011-02-10T12:28:17Z<p>Joeythibault: </p>
<hr />
<div>* Project Course Format 1.9 release 2 - 2008.07.03<br />
* Project Course Format 1.9 release 3 - 2008.12.31 <br />
* Project Course Format 1.9 release 4 - 2009.02.19<br />
* Project Course Format 1.9 release 5 - 2009.11.30 (new: section delete feature added)<br />
<br />
==Purpose==<br />
This is an optional course format for handling projects and other learning units with a variety of activities. A course format changes the layout and operations of the main center column of a Moodle course. Inside a course, you can select the format of a course by clicking on Admin >> Course Settings. Typically, Topics format or Weekly format is used. This format is like Topics format, except that each section of a course can be "packaged" separately. It has a separate directory and it can be backed up separately with all resources and activities together. The import function allows a teacher to share and move the section (project) anywhere on the site. Fast resource creation and bulk media file upload are also possible. This format is ideal for creating an in-house repository of learning packages and promoting teacher-to-teacher sharing of materials. Note: for simply adding the "Quick Resource Creator" function, check the Modules and Plugins Database of moodle.org: http://moodle.org/mod/data/view.php?d=13&rid=2880 (Thanks to Mike Wilson).<br />
<br />
==Features==<br />
* section directory<br />
* section backup<br />
* section import across site with auto-regeneration of media file links<br />
* section delete<br />
* quick resource creator<br />
* bulk file uploader<br />
<br />
==Status==<br />
This course format has been used since April 2008 in a full 1.9 production environment. Moving sections of courses has been increasingly more reliable, especially with quizzes which have a complicated set of categories and permissions. Since 2009, we have added the Sharing Cart: https://docs.moodle.org/en/Sharing_Cart, which is a separate block for moving individual course items. We believe both the Project Course Format and Sharing Cart supports all standard modules plus some third party modules (Feedback, Project, Splitscreen). Let us know which modules work or do not work in your environment.<br />
<br />
==Download & Installation==<br />
To install: admin status needed, and use standard procedure for installing 3rd party plugins as follows.<br />
# Download from CVS: http://download.moodle.org/download.php/plugins/course/format/project.zip<br />
# Unzip this package<br />
# Place the "project" folder into the course/format/ folder of your Moodle 1.9 program files<br />
# Login as Admin and run "Notifications"<br />
# Go into a course where you have teacher or admin status. Click on "Course settings".<br />
# Change the course format to "project". <br />
# Turn "editing on" and you will see new icons appear.<br />
<br />
==Changelog==<br />
Changes contributed by Tomonori Maruyama 2009.11.30<br />
* section delete function added<br />
Changes contributed by Akio Ohnishi and Tomonori Maruyama 2009.02.19<br />
# new icons for resource upload and file upload<br />
Changes contributed by Akio Ohnishi 2008.07.02<br />
* AJAX fixed when enabled on the site.<br />
Changes contributed by Matt Gibson 2008.07.03<br />
# Upload links are now labelled 'Upload file(s) and display them here' and 'Upload file(s) without displaying them yet' - still not ideal, but just a personal preference.<br />
# All links/icons have tooltips to elaborate on the imperfect titles<br />
# The divs containing those links will no longer overlap each other on smaller screens, whilst using long titles<br />
# Help files for backup/restore and directory name were the wrong way around<br />
# The directory naming help button was missing<br />
Changes contributed by Matt Gibson 2008.07.08<br />
# Bug in quotation marks inside format.php file (inconsistant " and ' marks)<br />
<br />
==Bugs & Known Issues==<br />
Please report bugs to Don Hinkelman (hinkel at sgu.ac.jp). Known issues include:<br />
<br />
# Importing a project for a second time in the same location may overwrite the old project without warning--previous user data will be lost. We recommend backing up the section first and renaming the section folder.<br />
# Converting from a topic-format course to a project format course will create new section directories and copy all associated media to those folders. Links in the activities/resources will be regenerated to those new media files and should not require manual correction of links. However, if you experience problems, please report to us. Before doing a Topic-to-Project format conversation, double check to make sure you have a course backup in case you do not like the results of the conversion.<br />
# After you import a new section into your course, you may be prompted to change the name of the directory. It is best to have a unique directory name for each section (across a course), however, this is not always enforced strictly.<br />
# When moving a resource or activity within a course, from one project to another (using the up/down arrow icon, or the AJAX icon), the associated media files or resource file does not move into the new section directory<br />
# This approach to backup/import may duplicate media files many times within a site. This is not a problem for a site with its own server and sufficient hard disk capacity. However, for limited capacity sites (such as on a shared hosting server), this course format could cause you to reach your limit sooner than expected. Use carefully.<br />
# Fatal Errors: These may occur do to problems outside of the Project Course Format. Here is some advice on what to do: [[Sharing Cart/Project Format Errors]]<br />
<br />
==Acknowledgements==<br />
Design team: Don Hinkelman and Andy Johnson (hinkel at sgu.ac.jp)<br />
Programming: Akio Ohnishi and Tomonori Maruyama, Version2 Web Development<br />
Funding: Sapporo Gakuin University, Japan<br />
<br />
==Help Files==<br />
1. English Help file "format/project/resourceupload.html":<br />
'''Quick Resource Upload'''<br />
This is a quick way to upload a resource file into a section of a course. It will automatically name the resource with the same name as the original file. It can also be used to bulk upload an unlimited number of resources. This can save numerous steps and encourage teachers to take the time to publish their documents, handouts, and lesson files. However, be careful when selecting what to upload, because bulk upload is so easy, but there is no bulk delete or undo function. Each new resource must be deleted one-by-one. Any resource created by this method can be edited in the normal way.<br />
<br />
2. English Help file "format/project/cousefileupload.html"<br />
'''Quick Course File Upload'''<br />
This is a quick way to upload a batch of media files (audio, video, image, etc.) for any activity in your section/project. For example, if you want to create a quiz with many images and sound files, use this to locate, select, and upload those files. Click on the link, "Quick Course File Upload", and then select the files anywhere on your hard disk. Click "Select" and these files will be instantly uploaded into the Course Files area of your course administration. When you do a backup or import into another course, these files will be included. After moving, a new path to these files will be built in each activity that has links to these files.<br />
<br />
3. English Help file "format/project/sectionbackuprestore.html"<br />
'''Section Backup and Import'''<br />
The first icon in this pair of icons (on the left) is for section backup. It will backup all the activities, resources and associated course files into one package. It does not backup any user data or user files. This is useful if you want to send or exchange a zip file to another site or another teacher on a different site. The second icon (on the right) is more important. It is an import icon. First, you have to know the location of a good section/project you want to import into your course. After you have got the location in another course, you normally will go to an empty section in your destination course and click on this. When you click on this, you will have to select the original course, and then you will select one of the sections of that course.<br />
<br />
4. Help file "format/project/directoryname.html"<br />
'''Section Directory Name'''<br />
In the Project Course Format, each section has its own folder. The folder is kept in Admin >> FIles of each course (not the Site Files). This folder holds the media files and resources that belong to the section (project/topic/theme). Initially, each section folder is named "section01"," section02"," section03" and so on. However, for moving and importing across the site, it is important that each folder have a unique name. You will be prompted to make a unique name.<br />
<br />
<br />
[[Category:Contributed code]]<br />
[[Category:Course format]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Dropbox_repository&diff=80850Dropbox repository2011-01-27T00:00:39Z<p>Joeythibault: </p>
<hr />
<div>{{stub}}{{Moodle 2.0}}<br />
<br />
A Dropbox repository can be enabled by an administrator in ''Site administration > Modules > Repositories > Manage repositories''.<br />
<br />
==Configuration==<br />
Once enabled by the administrator a Dropbox API Key and Secret will need to be added to the Dropbox settings in order for it to work. This will be ''the'' Dropbox available to all users throughout the site (and each will need the correct Dropbox login credentials to access it from their courses). To gather the Dropbox API Key and Secret click the "Dropbox Developers" link on the Dropbox repository settings page. On the next page you'll be prompted to login with your Dropbox username and password and to create a Dropbox app. <br />
<br />
Once the App has been created at Dropbox.com you'll have the API Secret and Key available at the bottom of the App page. Entering those on the Dropbox settings page (and clicking Save) back in Moodle will finish the configuration. Dropbox is now available to the entire site. <br />
<br />
To access it editing teachers need only "Add..." a new file while editing or creating a resource to see Dropbox as a new option. <br />
<br />
==Configuration for Multiple Users==<br />
Logging in with a different account from which the Dropbox App was created results in this error "Only the app owner can receive access token while this app is in development mode". To configure the Dropbox repository for multiple users you must...<br />
<br />
==See also==<br />
<br />
* [http://www.youtube.com/watch?v=V221JLCywWs Import files from Dropbox into Moodle 2.0 video]<br />
* MDL-19168<br />
<br />
[[Category:Repositories]]<br />
[[de:Dropbox]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Development_talk:Mobile_app&diff=73907Development talk:Mobile app2010-07-13T13:58:56Z<p>Joeythibault: New page: I'd love to see the ability for students to take quizzes be included in a 1.0 mobile app. Comparative LMS (BB) have not yet achieved this with their own Mobile apps and it would be a boon...</p>
<hr />
<div>I'd love to see the ability for students to take quizzes be included in a 1.0 mobile app. Comparative LMS (BB) have not yet achieved this with their own Mobile apps and it would be a boon for mobile learning (or learning utilizing tablet devices).</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=73445Mobile Moodle FAQ2010-06-29T20:23:23Z<p>Joeythibault: /* Web apps: */</p>
<hr />
<div>{{Work in progress}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
=== Native Apps: ===<br />
* [http://www.moodletouch.com MoodleTouch] created by Ali OzGur (available April 2010)<br />
* [http://mpage.hk/ mPage] created by Mass Media, HK (available May 24, 2010)<br />
<br />
=== Web apps: ===<br />
* [http://iphone.moodle.com.au iPhone4Moodle] (available 2010)<br />
* Moodle for Mobiles: [http://www.mobilemoodle.org/momo18/ MoMo]<br />
* [http://code.google.com/p/moodbile/ Moodbile]<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system.<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
<br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
* Using Moodle [http://moodle.org/mod/forum/view.php?id=7798 Moodle for mobile forum]<br />
<br />
Using Moodle forum discussions:<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=73444Mobile Moodle FAQ2010-06-29T20:10:09Z<p>Joeythibault: /* Web apps: */</p>
<hr />
<div>{{Work in progress}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
=== Native Apps: ===<br />
* [http://www.moodletouch.com MoodleTouch] created by Ali OzGur (available April 2010)<br />
* [http://mpage.hk/ mPage] created by Mass Media, HK (available May 24, 2010)<br />
<br />
=== Web apps: ===<br />
* [http://mle.sourceforge.com Mobile LE] <br />
* [http://iphone.moodle.com.au iPhone4Moodle] (available 2010)<br />
* Moodle for Mobiles: [http://www.mobilemoodle.org/momo18/ MoMo]<br />
* [http://code.google.com/p/moodbile/ Moodbile]<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system.<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
<br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
* Using Moodle [http://moodle.org/mod/forum/view.php?id=7798 Moodle for mobile forum]<br />
<br />
Using Moodle forum discussions:<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=73443Mobile Moodle FAQ2010-06-29T20:09:52Z<p>Joeythibault: /* MLE */</p>
<hr />
<div>{{Work in progress}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
=== Native Apps: ===<br />
* [http://www.moodletouch.com MoodleTouch] created by Ali OzGur (available April 2010)<br />
* [http://mpage.hk/ mPage] created by Mass Media, HK (available May 24, 2010)<br />
<br />
=== Web apps: ===<br />
* [http://mle.sourceforge.com Mobile LE] <br />
* [http://iphone.moodle.com.au iPhone4Moodle] (available 2010)<br />
* Moodle for Mobiles: [http://www.mobilemoodle.org/momo18/ MoMo]<br />
* [http://code.google.com/p/moodbile/ Moodbile]<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
<br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
* Using Moodle [http://moodle.org/mod/forum/view.php?id=7798 Moodle for mobile forum]<br />
<br />
Using Moodle forum discussions:<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=73442Mobile Moodle FAQ2010-06-29T20:09:05Z<p>Joeythibault: /* Web apps: */</p>
<hr />
<div>{{Work in progress}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
=== Native Apps: ===<br />
* [http://www.moodletouch.com MoodleTouch] created by Ali OzGur (available April 2010)<br />
* [http://mpage.hk/ mPage] created by Mass Media, HK (available May 24, 2010)<br />
<br />
=== Web apps: ===<br />
* [http://mle.sourceforge.com Mobile LE] <br />
* [http://iphone.moodle.com.au iPhone4Moodle] (available 2010)<br />
* Moodle for Mobiles: [http://www.mobilemoodle.org/momo18/ MoMo]<br />
* [http://code.google.com/p/moodbile/ Moodbile]<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
* Using Moodle [http://moodle.org/mod/forum/view.php?id=7798 Moodle for mobile forum]<br />
<br />
Using Moodle forum discussions:<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=73441Mobile Moodle FAQ2010-06-29T20:08:28Z<p>Joeythibault: /* Web apps: */</p>
<hr />
<div>{{Work in progress}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
=== Native Apps: ===<br />
* [http://www.moodletouch.com MoodleTouch] created by Ali OzGur (available April 2010)<br />
* [http://mpage.hk/ mPage] created by Mass Media, HK (available May 24, 2010)<br />
<br />
=== Web apps: ===<br />
* [http://mle.sourceforge.com Mobile LE] <br />
* [http://iphone.moodle.com.au iPhone4Moodle] (available 2010)<br />
* Moodle for Mobiles: [http://www.mobilemoodle.org/momo18/ MoMo]<br />
* Moodbile [http://code.google.com/p/moodbile/]<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
* Using Moodle [http://moodle.org/mod/forum/view.php?id=7798 Moodle for mobile forum]<br />
<br />
Using Moodle forum discussions:<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=70315Mobile Moodle FAQ2010-03-29T23:28:51Z<p>Joeythibault: </p>
<hr />
<div>{{stub}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br/><br />
<br />
Native Apps:<br/><br />
+(Available April 2010) MoodleTouch: [http://www.moodletouch.com] created by Ali OzGur <br />
<br />
Web apps:<br/><br />
* Mobile LE: [http://mle.sourceforge.com] <br/><br />
* (Available 2010) iPhone4Moodle: [http://iphone.moodle.com.au] <br/><br />
* Moodle for Mobiles: <br />
* MoMo: [http://www.mobilemoodle.org/momo18/] <br/><br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
Moodle Docs<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
<br />
Moodle Forums<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
* [http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=70314Mobile Moodle FAQ2010-03-29T23:07:37Z<p>Joeythibault: /* How can I use Moodle on mobile devices? */</p>
<hr />
<div>{{stub}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by [http://www.Moodletouch.com] in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br/><br />
<br />
Native Apps:<br/><br />
+(Available April 2010) MoodleTouch: [http://www.moodletouch.com] created by Ali OzGur <br />
<br />
Web apps:<br/><br />
+ Mobile LE: [http://mle.sourceforge.com] <br/><br />
+ (Available 2010) iPhone4Moodle: [http://iphone.moodle.com.au] <br/><br />
+ Moodle for Mobiles: <br />
+ MoMo: [http://www.mobilemoodle.org/momo18/] <br/><br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
Moodle Docs<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
<br />
Moodle Forums<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
*[http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=70313Mobile Moodle FAQ2010-03-29T22:47:11Z<p>Joeythibault: /* How can I use Moodle on mobile devices? */</p>
<hr />
<div>{{stub}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by www.Moodletouch.com in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br/><br />
<br />
Native Apps:<br/><br />
+(Available April 2010) MoodleTouch: [http://www.moodletouch.com] created by Ali OzGur <br />
<br />
Web apps:<br/><br />
+ Mobile LE: [http://mle.sourceforge.com] <br/><br />
+ (Available 2010) iPhone4Moodle: [http://iphone.moodle.com.au] <br/><br />
+ MoMo: <br/><br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
Moodle Docs<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
<br />
Moodle Forums<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
*[http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=70312Mobile Moodle FAQ2010-03-29T22:46:28Z<p>Joeythibault: /* How can I use Moodle on mobile devices? */</p>
<hr />
<div>{{stub}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
<br />
There are two ways to use Moodle on a mobile device, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by www.Moodletouch.com in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
Native Apps:<br />
+(Available April 2010) MoodleTouch: [http://www.moodletouch.com] created by Ali OzGur <br />
<br />
Web apps:<br/><br />
+ Mobile LE: [http://mle.sourceforge.com] <br />
+ (Available 2010) iPhone4Moodle: [http://iphone.moodle.com.au] <br />
+ MoMo:<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
Moodle Docs<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
<br />
Moodle Forums<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
*[http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibaulthttps://docs.moodle.org/24/en/index.php?title=Mobile_Moodle_FAQ&diff=70311Mobile Moodle FAQ2010-03-29T22:45:54Z<p>Joeythibault: /* How can I use Moodle on mobile devices? */</p>
<hr />
<div>{{stub}}<br />
<br />
== How can I use Moodle on mobile devices? ==<br />
Moodle will soon be available on various on limited phones through both native and web applications. There are several projects that in the past that have made in-roads to making Moodle more mobile, but web-enabled handhelds, such as Android based phones or the iPhone and iPod Touch have provided much easier platforms for which to develop mobile Moodle technologies. <br />
<br />
There are two ways to use Moodle on a mobile devise, you can pay for or download a native app for your cellular device (currently the only native Moodle app is planned for release by www.Moodletouch.com in April 2010), or you can configure your Moodle site to be Mobile accessible by using one of the available plug-ins. <br />
<br />
Native Apps:<br />
+(Available April 2010) MoodleTouch: [http://www.moodletouch.com] created by Ali OzGur <br />
<br />
Web apps:<br />
+ Mobile LE: [http://mle.sourceforge.com] <br />
+ (Available 2010) iPhone4Moodle: [http://iphone.moodle.com.au] <br />
+ MoMo:<br />
<br />
== Which platforms are supported? ==<br />
<br />
=== iPhone ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104599 Moodle Mobile for iPhone]<br />
* [[Moodle_for_Mobiles#Creating_Mobile_Learning_Tutorials_for_iPhone.2FiPod_Touch|Creating Mobile Learning Tutorials for iPhone/iPod Touch]]<br />
<br />
=== MLE ===<br />
* [http://mle.sourceforge.net MLE-Moodle] - MLE-Moodle is a plugin for Moodle, which adds mLearning functionality to this open-source eLearning system. <br />
<br />
=== Android ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=134778 Moodle on Android]<br />
<br />
=== Twitter ===<br />
* [http://moodle.org/mod/forum/discuss.php?d=104949 Twitter plug-in for Moodle]<br />
<br />
== See also: ==<br />
<br />
Moodle Docs<br />
* [[Moodle for Mobiles]] is designed to work with mobile phones in Japan.<br />
<br />
Moodle Forums<br />
* [http://moodle.org/mod/forum/discuss.php?d=31895 Moodle for Mobiles Quiz code released] <br />
* [http://moodle.org/mod/forum/discuss.php?d=31895&parent=185847 Re: Customised Scripts -Moodle for Mobiles projects use of] <br />
* [http://moodle.org/mod/forum/discuss.php?d=143973 Moodle for mobile browsers]<br />
* [http://moodle.org/mod/forum/discuss.php?d=33033 Moodle for Mobiles Project]<br />
* [http://moodle.org/mod/forum/discuss.php?d=141815 Comparisons and Advocacy > Mobile Moodle]<br />
<br />
Miscellaneous<br />
*[http://yuiblog.com/blog/2008/02/06/iphone-cacheability/ YUI blog post on how to optimise for the iPhone's cache]<br />
* [http://www.mobilestudy.org/moodle/mobilequiz/ Moodle Mobile Quiz]<br />
* [http://www.mobilemoodle.org/ Mobile Moodle (MOMO)]<br />
* [http://moodle.org/mod/forum/discuss.php?d=123331 Emulators for mobile platforms]<br />
<br />
<br />
[[Category:FAQ]]</div>Joeythibault