Module for entering/uploading offline grades

Module for entering/uploading offline grades

Zbigniew Fiedorowicz發表於
Number of replies: 52
I have created a module for entering/bulk uploading offline grades, e.g. in class exams, quizzes, etc.  You may download the module from my site:
https://webwork2.math.ohio-state.edu/download/
in either zip or tar.gz format.  There is also a readme file that you can look at for further details.

The module is in early development, so the usual caveats apply.  It should not be used on production sites.  I welcome your comments.
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Adam Johnston發表於
Sounds interesting.  I will be testing it out shortly as I was wondering about something similar to offer teachers this upcoming school year (late august I will go live and have to be stable).

When I test are you looking for features or just bugs it may have as you said it still early development?  Is there anything I should know/look for to help you out as you work on it?

Adam
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Adam Johnston發表於
Wow! Thats all I can say.
    This is almost exactly what I had imagined as my ideal solution. Gets rid of the 100 point maximum score, gets rid of those dropdown menus and add in the ability to upload scores. You are awesome.
    My only suggestion, and it may just be me or not be feasible, but could the comment boxes be made smaller and the spacing around names and such less, oreven putting the score stuff on the same line as the students name perhaps.
    I guess what I am going for and was going to look into trying to change myself anyway was to compress the info seen on the screen where the scores are entered. No idea how difficult it is but quite frankly its the only thing I would change about you module and even it is purely a productivity thing as I don't enter many or large comments where I need to see all of what I wrote there, I am generally more interested in getting to the students name as fast as possible to mark their score and start planning for class the next day.
    In short, you rock and I will keep testing but I will be including this for next year. Now I just have to see if I can edit ManualGrade (a recent gradebook mod by Bob Puffer and TheLinuxBox) so it lets me edit assignments made with this mod. Hopefully it won't be too bad, but between these two mods it made it so any teacher at my school should enjoy using moodle (versus the standard gradebook with 1.5 which I was not fond of...hate that "grade" button).

Hey! Quick sidenote!  You are at Ohio State (just paid attention to the link) and I teach in Columbus Public Schools.  Neat to see work being created nearby.  I'll have to give you a gift or something once I get my school's site done 微笑
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Zbigniew Fiedorowicz發表於
Thanks for the compliments.

I've just posted an update. Per your remarks, I've reduced the size of the comment boxes. I also fixed some bugs:
  • The homework module now handles due dates properly.
  • The calendar is now updated with exam and homework due dates
  • The module icons now are bit more appropriate

In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Adam Johnston發表於
Hey,
  I know you are looking at making soe radical changes, and I say that sounds cool.  One thing I want to put in because I feel this way and I keep seeing people who also feel this way (see recent post how to view all students instead of just 10) one of the biggest thing the gradebook we have lack was the ability to condense the student info on the page so more of them fit.  Hence I asked you to try that with your module which I appreciate you doing, but there must be a way to do even better. 
  Even now though the screen only fits a handful of students with the modified code.  I also have the manualgrade mod installed which solves much of the issue, but it can't interact with your module meaning I have to choose between having the ability to ENTER grades easily, or having the ability to UPLOAD grades.  These BOTH the the top 2 things teachers told me they wanted in order to switch to moodle when I make it available to other teachers at my school this fall. 
  Either way I do love moodle and I will make it work, but I just wanted to show that especially amongst the growing number of high schools that are looking for solutions like moodle some of the features desired may change.  I don't know how hard it is to change them as I am just trying to learn php so I can try and help moodle and some other scripting programs I have had the pleasure of using.
  I guess just consider this as you do your work towards bettering the way moodle handles grading and if you make any progress I will always be more than happy to test anything out, write any documentation you might need, etc.
Adam
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Zbigniew Fiedorowicz發表於
The display of the grade entry area per student is localized in the function exam_print_grade() in exam/lib.php
It should not be difficult to tinker with it.  I will see what I can do.

There should also be an option to toggle between the condensed view and the enlarged view and a configuration setting as to which is the default.
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Adam Johnston發表於
   Yeah, if there was an option to change, maybe involving getting rid of the comments sections entirely as well as the icons allowing for a highly condensed "spreadsheet-like" view for editting the grades.  Then you could just put a botton that would turn "comments on" and "comments off" maybe, allowing the person to choose. 
  If something like that could work, that'd be probably the best solution for everyone as there is a choice involved.
   Thanks for the great ideas and the great work thus far.  I also like the modularized approach to grades you suggested in the other threadm although I don't want to say much there as I can't code much yet.  I'll save that thread for people who know what they are doing 微笑
Adam
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Zbigniew Fiedorowicz發表於
Yeah, if there was an option to change, maybe involving getting rid of the comments sections entirely

Let me just point out that the comments sections has uses besides for putting in words of moral encouragement, e.g. "Great job!".  It can also be used to put in annotations like "grade changed from original 77".  Perhaps it is less important at the secondary school level, where you have smaller classes.  In the large lecture section environment of OSU freshman math classes, I sometimes get students disputing their grading, having their grades changed and then coming back at the end of the term complaining that I forgot to record their changed grade.
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

Adam Johnston發表於
I am sorry, I must have worded it badly because thats it not what I meant at all.
I was refering to something where when you clicked comments off they simply weren't displayed. That way when you initially enter grades or if you don't need to make many comments you can select "comments off" and then the grades can be entered in a much more condensed, much more spreadsheet like display (like manual grades but for only one assignment if you want more of a visual).
When you click "comments on" it switches to the current display you have where the comments appear and can be entered/editted.
I am not trying to get rid of comments all together, just asking for an option where I can just enter grades and not have the comments section spreading everything out, taking me a lot of extra time scrolling etc when trying to just enter scores.
Sorry for the confusion, I was just thinking about the edit on/off button they have already and how everything is still there, there are just some things essentially hidden until you hit edit on so I was thinking "hiding" the comments could be a really neat feature and timesaver.
Adam
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Zbigniew Fiedorowicz發表於
There is a new update of the exam and homework modules at
https://webwork2.math.ohio-state.edu/download/
There are a number of bug fixes, one for an undefined function error when in group mode, and several bugs involving backup and restore.  Also outline and complete activity reports for exams and homeworks are now implemented.
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Adam Johnston發表於
Just wanted to say thanks for all your work.  I know there is a lot of talk about how best to move forward but I just wanted you to know regardless I appreciate all the work you are doing to improve things regardless what eventually may be decided on for the future.  I love your modules 微笑

By the way, is there a way to have a block on the side when a module is open?  I was wondering if it was possible to set it to list all the assignments on the side while the grading part of the module is open so I could click on assignments and go right to the grading screen for that assignment to make it easy to navigate through the assignments when editing.  If not maybe it would be something you would use that'd be worth it?  Not anything necessary, just a thought a teacher testing it with me had and I thought sounded logical.

Adam
In reply to Adam Johnston

Re: Module for entering/uploading offline grades

W Page發表於

Hi Adam!

You can also put in a bug/feature request.  Post the Number here so others can vote for it. 微笑

http://moodle.org/bugs

WP1

In reply to W Page

Re: Module for entering/uploading offline grades

Adam Johnston發表於
     W Page I don't know what to put in the bug report as I don't like the assignment module that comes default.  This mod alters it to use text fields and condense the entry fields all on one page instead of each separate and needing to click grade then save changes a ton.
     If they change the assignment module to be more like this one then the system of essentially having all the assignments on a sideblock where a teacher can navigate to any specific assignment grade entry screen by just clicking on the assignment in the side block they want to edit would be useful.  As is they change screens so much entering grades with the core assignments module I think its a moot point for now there. 
     If you have any suggestions for how I could make it work or how I can make a bug report for this without being confusing or non applicable to the core code let me know.
Adam
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

James Robertson發表於

What is the status of this work now?  I just checked your download page and these files don't seem to have been updated since June 23 and the Readme still says, "Early development, do NOT use on production sites."  I am currently configuring our production site for Fall, and this looked interesting to me.  Has it been updated somewhere, or merged into or replaced by something else?

Thanks,

Jim.

In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Thomas Eibel發表於
Hello Zbigniew Fiedorowicz!
I downloaded the module and copied it as you described it in the readme.txt
I tried to select an activity but I cannot find the exam-module. Also in the configuration-menu for "modules" it is not present.

When I am logged in as admin and select "Admin..." in the configuration-block moodle tells me: (see attachment)

I use moodle 1.5. Do you have any hint for me?
Best Regards, Thomas Eibel
In reply to Thomas Eibel

Re: Module for entering/uploading offline grades

Adolfo Franco發表於

Hi. I don't want to be too nosy but it seems that Fiedorowicz haven't showed up here lately... Check if you've effectively done the following:

1- exam and homework folders into mod directory;

2- exam.php and homework.php into lang/[language(s) in use] directory (en and the one(s) you want to use);

3- chmod permissions to all uploaded files to the maximum your server allows - for instance, my server allows chmod 755. If I try something higher I may get error messages.

If you did those, by acccessing /admin/modules.php it should trigger the modules and you can edit the language in /admin/lang.php where exam.php and homework.php must be listed to be edited...

Well... I hope that helps a little.

In reply to Adolfo Franco

Re: Module for entering/uploading offline grades

Thomas Eibel發表於
Thanks for helping!
I can find these modules (exam.php and homework.php) listed in the configuration=>language-menu. But I don't find them anywhere else: not in configuration=>modules, not in configuration=>blocks, not in the course-activities or in the grading-menu.
Where is max I find the examin ...?
What I'm curiuos about, that everytime I change from configuration=>modules moodle shows me the messages I posted last time thoughtful
Any idea ...
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Jonathan Konrad發表於
A great start. Thank you. When I loaded this module the exam loaded, but the homework is not showing as a module in the administration sections. Also when check for missing strings I get this output:

The following strings are not defined in /brhs_web/Documents/moodle/lang/en/exam.php

$string['nonnumericgrade2'] = "";
$string['higrade3'] = "";

The following strings are not defined in /brhs_web/Documents/moodle/lang/en/homework.php

$string['nonnumericgrade2'] = "";
$string['higrade3'] = "";

Just thought you might want to know.
In reply to Jonathan Konrad

Re: Module for entering/uploading offline grades

Jonathan Konrad發表於
Sorry to reply to my own post, but I finally triggered the homework module to install. I don't know why it did not when the exam module installed, but I just ran a backup of my moodle install from within moodle, and the homework module self installed correctly. Thanks for a great mod.
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Daniel Brouse發表於

Zbigniew Fiedorowicz, You provided me information and assistance in the Easy Manual Grade Entering Thread, but I decided to move the conversation here as it seems more pertinent to this thread and the columns arewider in this thread! Our conversation was at http://moodle.org/mod/forum/discuss.php?d=24881#151864 in case you want to reference it.

As far as I can tell, all of the problems that I had with the installation were due to errors I made, or in one case a file may have not copied correctly. I am going to keep the following information here on the off chance it may help someone else who has the same problems I did. ~written after everything else below.


I decided to try to install the module but I had some problems. My guess is that they are simple mistakes based on my ignorance, so please forgive me if I ask the equivalent of what a "left click" is.

When I went to the index of files and folders at https://webwork2.math.ohio-state.edu/download/ and tried to download the mod/ folder via a right click in Firefox 1.0.7, I selected "Save Link As..." and then could only save the folder as an .html file. I figured that this was not accomplishing what I needed so I tried Internet Explorer 6.0 and basically had the same problem. I decided to try to open the mod/ folder and download the files individually thinking that downloading folders was the problem. When I clicked on the exam/ folder to open it up I got the following error:

Warning: main(../../config.php): failed to open stream: No such file or directory in /var/www/html/download/mod/exam/index.php on line 6


Fatal error: main(): Failed opening required '../../config.php' (include_path='.:/usr/local/lib/php') in /var/www/html/download/mod/exam/index.php on line 6

I then just went back to the original directory and downloaded the zipped file (exam.zip). I should have figure this out to begin with. I uploaded the zipped file but then I couldn't get the filemanager in CPanel to unzip it. (Or so I thought, after the fact it now appears that I may have unzipped it, but in the wrong location!) I then decided to unzip the files on my PC. I then created the folders indicated in the zip files folder structure and uploaded the correct files into the folders. I got some errors when I logged into my moodle site. These errors were my first hint that I had successfully unzipped the folder structure on the server, but in the mod/ directory rather than the moodle/ directory the way the zip file structure required.

I cleaned up the incorrect folders ...mod/mod/ and mod/lang/, that were created by the erroneous unzip, and then the errors went away when logging in to my moodle site.

______ below here is the current problem. I think the ones above were solved ____

I then realized that I did not know what new interface to expect now that the module appeared to be loaded, and no error messages were showing. When opening up the grades feature in my moodle class, everything looked the same, so I decided to create a new activity in my class. When the activity dropdown showed modulename as the last option, I was pretty sure I had found at least one of the changes made with my attempt to install the module.

So when selecting modulename as a new activity, a new form comes up that says

Adding a new modulename as a title and then, lower, it labels the description field as description and uses the label maximumgrade and examdate as labels for the appropriate fields.

So, in the end, did I do something wrong? Is there anything I should change? Are the double bracketed labels normal or do they indicate a problem with the installation.

I apologize for the length of this narrative, it wasn't going to be so long but I kept trying things as I was writing and then had to add the description of the attempt to this note -- one of the dangers of tabbed browsing with Firefox!

Thanks to any and all who provide some helpful comments. To the rest of you, I hope that this technological comedy of errors made you smile. big grin


P.s. Oops, I did just get an error stating Module "lang" is not readable - check permissions, so I must need to go back and double check what I have done in the lang/ folder.

P.p.s I removed the lang/ subfolder from the mod/ folder and the error went away. When double checking the new activities dropdown it still listed modulename as an option. I doublechecked the exam.php file in the lang/en/ folder and found that it was zero (0) kilobytes. Doublechecking the file on my PC showed that it was 2k so I deleted the empty file and then reuploaded the exam.php into the lang/en/ subfile. The bracketed labels listed above went away! Yeah!

In reply to Daniel Brouse

Re: Module for entering/uploading offline grades

Daniel Brouse發表於
I just finished grading exams all weekend and feel compelled to jot this note.

Bravo. This module is great. Thank you Zbigniew
In reply to Zbigniew Fiedorowicz

How to have a

Adolfo Franco發表於

First of all. Thanks, you've saved my life! LOL That is the solution that I desperately needed.

Now, my doubt, altough it doesn't have to do with your modules diretly (but I am sure you can help me out) is the following:

My grade book will be plain simple: only two grades named "AF" and "AS", so I created two exams and also categorized them into the gradebook. I could put the grades and so... So far so good. Also, I set up the weights 50/50 and 0 to uncategorized grades. The problem is that the total is still first grade plus second. Is it possible to make moodle divide the total by the number of activities?

Thanks in advance.

PS: I'm a language teacher, meaning I am awful at maths. LOL

In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Stephen Reiach發表於
For those who are bulk uploading using a text file note that the first line of the text file should contain the name of the exam/homework. Then the following lines contain the cvs data (username, grade, comment).
The first part was missing from the README file.
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

James Rudd發表於
Great module, where just started using Moodle and this should make it much more useful to some teachers.

I found a small bug in mod\exam\index.php on line 77. When viewing the list of all homework or exams for a course, it incorrectly showed the date.

Line says:
$examdate = userdate($modulename->$strlexamdate);
but as its in a for loop should be
$examdate = userdate($exam->$strlexamdate);


In reply to James Rudd

Re: Module for entering/uploading offline grades

Timothy Takemoto發表於
Thanks Zbigniew Fiedorowicz and James and everyone

I append a ja_utf8 language pack for this tremendously useful modulecool. This should be standard. (But perhaps there is no need for both exam and homework? >> Offline Activity Module?)

Tim

In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Abbie Blanco發表於

Dear Zbigniew Fiedorowicz,

I had a difficult time in installing the exam module. I think there is an error in the file mod/exam/db/mysql.php, the exam table is installed but it cannot be accessed by users who installed their tables with CFG->prefix. When you create a table, pls. concat the $CFG->prefix, just like this (located inside the function exam_upgrade) :

CREATE TABLE `{$CFG->prefix}$modulename` (
          `id` int(10) unsigned NOT NULL auto_increment,
          `course` int(10) unsigned NOT NULL default '0',
          `name` varchar(255) NOT NULL default '',
          `description` text NOT NULL,
          `format` tinyint(2) unsigned NOT NULL default '0',
          `{$modulename}date` int(10) unsigned NOT NULL default '0',
          `grade` int(10) NOT NULL default '0',
          `timemodified` int(10) unsigned NOT NULL default '0',
          PRIMARY KEY  (`id`)
        ) COMMENT='Defines exam'

In reply to Abbie Blanco

Re: Module for entering/uploading offline grades

stefan de backer發表於

Is there anyone who can tell me where I can download the latest working update of the grade book module?

Thanks!

In reply to stefan de backer

Re: Module for entering/uploading offline grades

Josep M. Fontana發表於
In reply to Josep M. Fontana

Re: Module for entering/uploading offline grades

Andy Hawkins發表於

We do not have a 1.5 testing server -

Is the current humboldt gradebook plus different to the advanced gradebook in moodle 1.5.3+?

Does it have upload marks/comments as per exam/offline upload module?

Downloading comments (in the excel or text files) would also be useful - maybe a tickbox on the gradebook page with those buttons. Is that a feature of humboldt gradebook plus?

TIA

Andy

In reply to Andy Hawkins

Re: Module for entering/uploading offline grades

Michael Penney發表於
Hi Andy, for the most part all we did in gradebookplus is add the ability to edit assignment and quiz grades in the gradebook. It is similar (and based on) the work done by linuxbox and Rob Barreca, however there is some code in those versions that is not Moodle API compliant, wheras gradebookplus the code was re-written (by Jeff Graham, the main developer of the 1.5 gradebook) to be Moodle api compliant.

There was some interest expressed at the Savannah Moot in moving forward with this work by Martin and Bryan Williams, but we haven't heard anything more. Rob's version includes some nice features our's doesn't yet (direct links to assignment comments, etc.).
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

jonathan Joy發表於

Hi, I used the module and it worked fine, thanks

But it did return the following warnings

Warning: fopen(C:\moodledata/filter/admin_1140452431) [function.fopen]: failed to open stream: No such file or directory in C:\moodle\mod\exam\examgrades.php on line 196

Warning: fwrite(): supplied argument is not a valid stream resource in C:\moodle\mod\exam\examgrades.php on line 197

Warning: fclose(): supplied argument is not a valid stream resource in C:\moodle\mod\exam\examgrades.php on line 198

Exam/quiz feedback updated for 1 people
In reply to jonathan Joy

Re: Module for entering/uploading offline grades

Sarah Quantick發表於

I am also trying to use this module and get this error when I try to upload grades. How can I resolve this issue

Warning

: fopen(d:\moodledata/filter/administrator_1145796984): failed to open stream: No such file or directory in c:\program files\easyphp1-7\www\moodle\mod\exam\examgrades.php on line 196

Warning: fwrite(): supplied argument is not a valid stream resource in c:\program files\easyphp1-7\www\moodle\mod\exam\examgrades.php on line 197

Warning: fclose(): supplied argument is not a valid stream resource in c:\program files\easyphp1-7\www\moodle\mod\exam\examgrades.php on line 198

wrongfirstline

In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Diane Salamone發表於

Hi, the ability to upload and record offline grading sounds like a module that I really could use.  Could someone give me the link to download the latest version and some more instruction on what I do with the file once I download it to the moodle server.

Any help would be appreciated!

Thanks, Diane

In reply to Diane Salamone

Re: Module for entering/uploading offline grades

Daniel Brouse發表於
Diane,

I am in the process of migrating my Moodle classes to a new server and so I found that I needed to reinstall this module to maintain compatibility with my existing classes that use this feature. It is unfortunate that this module is an addon and not part of the standard Moodle installation. I have saved HOURS of time using this module. If you look at prior posts you will see that I ran into problems the first time I installed the module. But now that I just reinstalled it I think I can walk you through the process. I am going to step through this with the beginner in mind as they are likely to read this also so please pardon me if I state the obvious.

1. Go to https://webwork2.math.ohio-state.edu/download/ and dowload either the Exam.zip or Exam.tar.gz whichever is better suited for your needs based on your Moodle servers ability to extract either archive type. I think that this URL has always been the primary location for this module's download.
2. Using your prefered
file management or ftp managment application/tool upload the archived exam file to your Moodle server's main Moodle folder. I have a commercially hosted site and so I use cPanels File Manager. This folder should have mod and lang as subfolders.
3. Extract/decompress the exam file. This will place files into the mod and lang subfolders and should complete the installation. To be honest though, I wasn't able to get the installation to work right away -- I went to the Moodle Site Admin Configuration Variables screen and then without making any changes saved it. Once I clicked save to the site variable settings a series of notices popped up (which I did not capture, nor do I remember - angry) indicating to me that that mod was now installed. I went to confirm that it was installed (see below) and now it was in fact installed. I do not know if the resaving of the Variables is necessary -- I just went there to double-check that en (english) was selected as the language after I couldn't get the mod to work right away.

Now to confirm that the mod was installed:
A. Go to a class in your Moodle installation and in edit mode (click the Turn Editing On button)
B. In any block click the Add Activity dropdown. You should see an option titled Exam/quiz and another one titled Homework.

Once you create an Exam/quiz, you will have the opportunity to enter (or upload - which I rarely do) the batch of grades for that assignment/exam/quiz/etc. You can access this ability to enter the grades either by clicking on the Exam/quiz entry on the main view of the class or via the gradebook tool.
Most of my classes have 20-70 students so being able to enter the grades in bulk and then submit them with one click is a HUGE timesaver.

Here is a cut and paste of what the grade entry screen looks like. I changed the names of actual students to the generic list seen below.

Order:First nameSurnameGradeLast modified up.gif
spacer.gif
Student 1________
________________________________
Student 2
Student 3
Student 4
Student 5
Student 6
Show only students listed in the file: $CFG->dataroot/2/subsections/instructor
Check bounds for inputted grades
condensedview


The first blank column is for the grade and the second blank column is for any comments you want to enter for the student to see when they are viewing the detail of their grade.

In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Adolfo Franco發表於

Hi. When I first installed your modules (exam and homework) it worked fine on Moodle 1.5. Then I updated to Moddle 1.6 and they kept working fine.

Now I'm testing Moodle 1.7. I updated a testing site and, unfortunately, the modules don't work now.

I know you have no responsibility, I just wondered if you're updating your modules or if you could , perhaps, give us some hints on how to make them work in Moodle 1.7.

Thanks in advance.

In reply to Adolfo Franco

Re: Module for entering/uploading offline grades

Daniel Brouse發表於
Well, it is good to know that it works with 1.6! Thanks.
In reply to Daniel Brouse

Re: Module for entering/uploading offline grades

Chass Wingrove發表於
Hi there

I am having major problems installing the Exam/Quiz module on 1.6 (and indeed previous versions of Moodle).

After copying the necesary files to their locations, i click on Admin to let the installation begin and i recieve the following errors;

exam


(mysql): CREATE TABLE `mdl_exam` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `examdate` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `course` (`course`)) COMMENT='Defines exams'  
1050: Table 'mdl_exam' already exists
         
      
   


Error


(mysql): CREATE TABLE `mdl_exam_grade` ( `id` int(10) unsigned NOT NULL auto_increment, `exam` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `teacher` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `assignment` (`exam`), KEY `userid` (`userid`), KEY `mailed` (`mailed`), KEY `timemarked` (`timemodified`)) COMMENT='Info about submitted exams'  
1050: Table 'mdl_exam_grade' already exists
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'view', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'add', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'update', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'view grades', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'upload', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


exam tables could NOT be set up successfully!

Does anyone have any ideas of advice they could offer please. I have tried re-installing the module many times now, but am having no success at all. Does anyone have a download they have used successfully for 1.6? Is there something that is not set correctly in the database?

Many Thanks in Advance



In reply to Chass Wingrove

Re: Module for entering/uploading offline grades

Jean-Michel Védrine發表於
You have several problems
1) some tables are already in your database (leftover from a previous unsucessfull installation) so use phpMyAdmin to delete the mdl_exam and mdl_exam_grade tables from your database. Be carefull not to delete any other table !

2) You need to correct some lines in the mod/exam/db/mysql.php and mod/exam/db/mysql.sql files changing all occurences (5 lines to change in each file) of:

INSERT INTO mdl_log_display VALUES

to :

INSERT INTO mdl_log_display (module, action, mtable, field) VALUES
Please note that I have exam only installed on a Moodle 1.5.4+ production site and not on my Moodle 1.6 test site so I don't know if this module will work with Moodle 1.6 I am just trying to solve your installation problems !
In reply to Jean-Michel Védrine

Re: Module for entering/uploading offline grades

Chass Wingrove發表於
Thanks for the help, i am now experiencing these errors;

exam


(mysql): CREATE TABLE `mdl_exam` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `examdate` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `course` (`course`)) COMMENT='Defines exams'  
Success


(mysql): CREATE TABLE `mdl_exam_grade` ( `id` int(10) unsigned NOT NULL auto_increment, `exam` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `teacher` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `assignment` (`exam`), KEY `userid` (`userid`), KEY `mailed` (`mailed`), KEY `timemarked` (`timemodified`)) COMMENT='Info about submitted exams'  
Success


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'view', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'add', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'update', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'view grades', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


(mysql): INSERT INTO mdl_log_display VALUES ('exam', 'upload', 'exam', 'name')  
1136: Column count doesn't match value count at row 1
         
      
   


Error


exam tables could NOT be set up successfully!

Please could you copy and paste both your mysql.php and mysql.sql files so we can see exactly the format to enter the code.

Many thanks in advanced 微笑
In reply to Chass Wingrove

Re: Module for entering/uploading offline grades

Jean-Michel Védrine發表於
Please, can you test the included exam.zip ? Note that I only included the files where I made some changes, not the complete module.
To test it, just overwrite old files by the new ones.
I suggest not to use this on a production server because testing has been minimal (I just entered some grades and comments, for instance the upload grade function was not tested) but it appear to work with Moodle 1.6 and 1.6+ (not tested with Moodle 1.7).
Can somebody tell me if this mod is still needed or if using gradebook plus v2 you can now enter and upload grades ?


In reply to Jean-Michel Védrine

Re: Module for entering/uploading offline grades

Rolf Christoffersen發表於

Thank very much!  We were seeing the same errors with the exam module after upgrading to 1.6.1 and  your edits of the module resolved the problem for us.  The ability to upload exam scores is a critical feature for anyone who uses Moodle to teach a hybrid class.  I wish this feature was incorporated into the standard gradebook.

In reply to Jean-Michel Védrine

Re: Module for entering/uploading offline grades

James Rudd發表於
I've modified Jean-Michel's code to work with 1.7. Same notes regarding lack of testing apply.

Mainly needed to change references to user_student in the SQL inside the exam_get_all_grades function.

If anyone who understands the new role system better would like to improve it please try. This was my first attempt at modifying a Moodle module and I'm still trying to understand how to code in Roles.
In reply to Zbigniew Fiedorowicz

Re: Module for entering/uploading offline grades

Steven McKay發表於
I am having difficulty getting this module working with 1.6.1.  The module installs fine, and I can create the quiz or homework fine, but when I go to add grades, I get a page that says
"Course module is incorrect"
I hit ok and it takes me back to the main page.  I haven't seen anyone mention this, but if you know what is going on, I would appreciate any help you can give.
Thanks,
S.M.
In reply to Steven McKay

Re: Module for entering/uploading offline grades

Daniel Brouse發表於
Steven,

I am having the same problem. I am guessing that the reason why I am having the problem is because I installed the exam/quiz extension while my Moodle site was 1.5.x and then I upgraded to 1.6.1 without doing anything special to ensure that the exam/quiz extension would work. I am going to see if I can fix it for my installation of Moodle. I'll let you know how it turns out and, if I am sucessful, how I was able to correct the problem. In reality, lack of success is not an option -- I have 3 active classes that MUST have offline grade entering functionality.

Daniel
In reply to Daniel Brouse

Re: Module for entering/uploading offline grades

Steven McKay發表於
That may have been the problem.  I don't remember how I upgraded, but I think that I did a clean install of the moodle directory, and then added them in later.  However, after pulling out my hair and giving up, I noticed yesterday that its working again.  I did not do anything to get it working.  Maybe a system reboot (or restarting Mysql, or ...) did the trick.  I am still frustrated, because I don't know why it stopped working, and I don't know if it will happen again.  But it works just in time for me to upload 84 exam scores, so that is good 微笑. If you find out anything, I would be interested to know what is going on.

Thanks,
Steven
In reply to Steven McKay

Re: Module for entering/uploading offline grades

Daniel Brouse發表於
Steven,

Wow, the "silicone gremlins" are at it again --> mucking with computer software and making it unpredictable. My Exam/Quiz module has not started working on it's own.... yet! So, here is what I found:

0) Don't have high expectations, I completely avoided  any attempt to find the cause of the problem! big grin
1) According to his profile, here on Moodle.org, Zbigniew Fiedorowicz, the modlue developer, has not been in the Using Moodle class for 58 days. With the frequent upgrades to the Moodle code, and the plan for Moodle 1.8 to have a significant update/change in the grade-book I am guessing that the Exam/Quiz module may not be actively being developed/maintained. That means that it may be ready to retire the Exam/Quiz module for me.
2) I installed the XAAMP-Moodle package (1.6.2+) on my external hard drive and tinkered with installing the Exam/Quiz module -- No luck. This may say more about my ability to read directions and install the module than whether the Exam/Quiz module is compatible with 1.6.1-2. mixed  Either way it inclines me to look for something else. I must say that the Exam/Quiz module has been wonderful the past year and it has saved me a ton of time if I can't successfully load it onto a freshly installed Moodle installation, maybe I shouldn't be using it anymore.
I also installed the Gradebook Plus V2 but didn't tinker with it much. I was surprised that some of the labels displayed funny with brackets on either side of some of the labels. I may put this on my "production" installation in the future but I don't have any immediate plans to use it.
3) I "discovered" that the standard assignment module can not only be set to "offline assigment," allowing manual grade entry, but it can also be put in "Quick Grading" mode and allow all grades for a particular assignment/quiz/etc. to be added at once. This is what I have needed all along and was the primary reason I used the Exam/Quiz module. I don't know when this was added (I don't remember it from 1.4.x ) but now that I know it is available, I am happy to use it to enter my offline grades. I haven't needed the grade upload funtionality of the Exam/Quiz mod and so I won't miss it. My annoyance at the Assignments icon that will now be in front of the labels for my "quizzes" and "exams" is minor enough that it won't cause me to avoid that solution nor will it cause me to delve into the code to "fix" the problem.

I hope your Exam/Quiz module remains stable. Is it possible that there was a change in your server's PHP, mySQL, or Apache settings?

Daniel

In reply to Daniel Brouse

Re: Module for entering/uploading offline grades

Mark Little發表於
Hi,

Has anybody got this working in 1.64?

I have installed Exam and Homework module successfully without any database errors but when you try to use the module you get errors.

For example -

Fatal error: Call to undefined function get_context_instance() in d:\website\www\mod\exam\view.php on line 2

The error happens after you fill in the first page and press submit.

Any ideas?

Thanks