Annotation of loncom/interface/statistics/lonstudentassessment.pm, revision 1.8
1.1 stredwic 1: # The LearningOnline Network with CAPA
2: # (Publication Handler
3: #
1.8 ! stredwic 4: # $Id: lonstudentassessment.pm,v 1.7 2002/08/05 20:53:38 stredwic Exp $
1.1 stredwic 5: #
6: # Copyright Michigan State University Board of Trustees
7: #
8: # This file is part of the LearningOnline Network with CAPA (LON-CAPA).
9: #
10: # LON-CAPA is free software; you can redistribute it and/or modify
11: # it under the terms of the GNU General Public License as published by
12: # the Free Software Foundation; either version 2 of the License, or
13: # (at your option) any later version.
14: #
15: # LON-CAPA is distributed in the hope that it will be useful,
16: # but WITHOUT ANY WARRANTY; without even the implied warranty of
17: # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18: # GNU General Public License for more details.
19: #
20: # You should have received a copy of the GNU General Public License
21: # along with LON-CAPA; if not, write to the Free Software
22: # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
23: #
24: # /home/httpd/html/adm/gpl.txt
25: #
26: # http://www.lon-capa.org/
27: #
28: # (Navigate problems for statistical reports
29: # YEAR=2001
30: # 5/5,7/9,7/25/1,8/11,9/13,9/26,10/5,10/9,10/22,10/26 Behrouz Minaei
31: # 11/1,11/4,11/16,12/14,12/16,12/18,12/20,12/31 Behrouz Minaei
32: # YEAR=2002
33: # 1/22,2/1,2/6,2/25,3/2,3/6,3/17,3/21,3/22,3/26,4/7,5/6 Behrouz Minaei
34: # 5/12,5/14,5/15,5/19,5/26,7/16 Behrouz Minaei
35: #
36: ###
37:
38: package Apache::lonstudentassessment;
39:
40: use strict;
41: use Apache::lonhtmlcommon;
42: use Apache::loncoursedata;
43: use GDBM_File;
44:
1.4 stredwic 45: #my $jr;
46:
1.1 stredwic 47: sub BuildStudentAssessmentPage {
1.2 stredwic 48: my ($cacheDB,$students,$courseID,$formName,$headings,$spacing,
49: $studentInformation,$r,$c)=@_;
1.4 stredwic 50: # $jr = $r;
1.1 stredwic 51: my %cache;
1.6 stredwic 52: unless(tie(%cache,'GDBM_File',$cacheDB,&GDBM_READER(),0640)) {
1.2 stredwic 53: $r->print('<html><body>Unable to tie database.</body></html>');
54: return;
1.1 stredwic 55: }
1.3 stredwic 56:
57: # Remove students who don't have the proper section.
58: my @sectionsSelected = split(':',$cache{'sectionsSelected'});
59: for(my $studentIndex=((scalar @$students)-1); $studentIndex>=0;
60: $studentIndex--) {
61: my $value = $cache{$students->[$studentIndex].':section'};
62: my $found = 0;
63: foreach (@sectionsSelected) {
64: if($_ eq 'none') {
65: if($value eq '' || !defined($value) || $value eq ' ') {
66: $found = 1;
67: last;
68: }
69: } else {
70: if($value eq $_) {
71: $found = 1;
72: last;
73: }
74: }
75: }
76: if($found == 0) {
77: splice(@$students, $studentIndex, 1);
78: }
79: }
1.4 stredwic 80: my ($infoHeadings, $infoKeys, $sequenceHeadings, $sequenceKeys,
81: $doNotShow) =
82: &ShouldShowColumns(\%cache, $headings, $studentInformation);
1.3 stredwic 83:
1.2 stredwic 84: my $selectedName = &FindSelectedStudent(\%cache,
85: $cache{'StudentAssessmentStudent'},
86: $students);
1.4 stredwic 87: $r->print(&CreateInterface(\%cache, $selectedName, $students, $formName,
88: $doNotShow));
1.7 stredwic 89: $r->rflush();
1.1 stredwic 90:
1.4 stredwic 91: my $Str = '';
1.1 stredwic 92: if($selectedName eq 'No Student Selected') {
1.4 stredwic 93: $Str .= '<h3><font color=blue>WARNING: ';
94: $Str .= 'Please select a student</font></h3>';
95: $r->print($Str);
1.2 stredwic 96: return;
1.1 stredwic 97: }
98:
1.2 stredwic 99: $r->print(&CreateTableHeadings(\%cache, $spacing, $infoKeys, $infoHeadings,
100: $sequenceKeys, $sequenceHeadings));
101: untie(%cache);
1.6 stredwic 102: if($c->aborted()) { return $Str; }
1.2 stredwic 103:
1.1 stredwic 104: my $selected=0;
1.2 stredwic 105: $r->print('<pre>'."\n");
1.1 stredwic 106: foreach (@$students) {
1.8 ! stredwic 107: if($c->aborted()) { return $Str; }
1.1 stredwic 108: next if ($_ ne $selectedName &&
109: $selectedName ne 'All Students');
110: $selected = 1;
1.2 stredwic 111:
1.8 ! stredwic 112: my @who = ($_);
! 113: next if(&Apache::loncoursedata::DownloadStudentCourseData(\@who, 'true',
! 114: $cacheDB, 'true',
! 115: 'false', $courseID,
! 116: $r, $c) ne 'OK');
1.6 stredwic 117: next if($c->aborted());
1.2 stredwic 118:
1.6 stredwic 119: if(tie(%cache,'GDBM_File',$cacheDB,&GDBM_READER(),0640)) {
1.8 ! stredwic 120: my @before=();
! 121: my @after=();
! 122: my @updateColumn=();
! 123: my $foundUpdate = 0;
! 124: foreach(@$infoKeys) {
! 125: if(/updateTime/) {
! 126: $foundUpdate=1;
! 127: push(@updateColumn, $_);
! 128: next;
! 129: }
! 130: if($foundUpdate) {
! 131: push(@after, $_);
! 132: } else {
! 133: push(@before, $_);
! 134: }
! 135: }
1.2 stredwic 136: my $displayString = 'DISPLAYDATA'.$spacing;
137: $r->print(&Apache::lonhtmlcommon::FormatStudentInformation(
138: \%cache, $_,
1.8 ! stredwic 139: \@before,
! 140: $displayString,
! 141: 'preformatted'));
! 142:
! 143: if($foundUpdate) {
! 144: $displayString = '';
! 145: $displayString .= '<a href="/adm/statistics?reportSelected=';
! 146: $displayString .= &Apache::lonnet::escape('Student Assessment');
! 147: $displayString .= '&download='.$_.'">';
! 148: $displayString .= 'DISPLAYDATA</a>'.$spacing;
! 149: $r->print(&Apache::lonhtmlcommon::FormatStudentInformation(
! 150: \%cache, $_,
! 151: \@updateColumn,
! 152: $displayString,
! 153: 'preformatted'));
! 154: }
! 155:
! 156: $displayString = 'DISPLAYDATA'.$spacing;
! 157: $r->print(&Apache::lonhtmlcommon::FormatStudentInformation(
! 158: \%cache, $_,
! 159: \@after,
1.2 stredwic 160: $displayString,
161: 'preformatted'));
162: $r->print(&StudentReport(\%cache, $_, $spacing, $sequenceKeys));
163: $r->print("\n");
1.7 stredwic 164: $r->rflush();
1.1 stredwic 165: untie(%cache);
166: }
167: }
1.2 stredwic 168: $r->print('</pre>'."\n");
1.1 stredwic 169: if($selected == 0) {
1.4 stredwic 170: $Str .= '<h3><font color=blue>WARNING: ';
171: $Str .= 'Please select a student</font></h3>';
172: $r->print($Str);
1.1 stredwic 173: }
174:
1.2 stredwic 175: return;
176: }
177:
178: #---- Student Assessment Web Page --------------------------------------------
179:
180: sub CreateInterface {
1.4 stredwic 181: my($cache,$selectedName,$students,$formName,$doNotShow)=@_;
182:
183: my $Str = '';
184: $Str .= &CreateLegend();
185: $Str .= '<table><tr><td>'."\n";
186: $Str .= '<input type="submit" name="PreviousStudent" ';
187: $Str .= 'value="Previous Student" />'."\n";
188: $Str .= '   '."\n";
189: $Str .= &Apache::lonhtmlcommon::StudentOptions($cache, $students,
1.2 stredwic 190: $selectedName,
191: 'StudentAssessment',
192: $formName);
1.4 stredwic 193: $Str .= "\n".'   '."\n";
194: $Str .= '<input type="submit" name="NextStudent" ';
195: $Str .= 'value="Next Student" />'."\n";
196: $Str .= '</td></tr></table>'."\n";
197: $Str .= '<table cellspacing="5"><tr>'."\n";
198: $Str .= '<td align="center"><b>Select Sections</b>'."\n";
199: $Str .= '</td>'."\n";
200: $Str .= '<td align="center"><b>Select column to view:</b></td>'."\n";
201: $Str .= '<td></td></tr>'."\n";
1.3 stredwic 202:
1.4 stredwic 203: $Str .= '<tr><td align="center">'."\n";
1.3 stredwic 204: my @sections = split(':',$cache->{'sectionList'});
205: my @selectedSections = split(':',$cache->{'sectionsSelected'});
1.4 stredwic 206: $Str .= &Apache::lonhtmlcommon::MultipleSectionSelect(\@sections,
1.3 stredwic 207: \@selectedSections,
208: 'Statistics');
1.4 stredwic 209: $Str .= '</td><td align="center">';
210: $Str .= &CreateColumnSelectionBox($doNotShow);
211: $Str .= '</td><td>'."\n";
212: $Str .= '<input type="submit" name="DefaultColumns" ';
213: $Str .= 'value="Default Column Display" />'."\n";
214: $Str .= '</td></tr></table>'."\n";
1.2 stredwic 215:
1.4 stredwic 216: return $Str;
1.1 stredwic 217: }
218:
1.2 stredwic 219: sub CreateTableHeadings {
220: my($cache,$spacing,$infoKeys,$infoHeadings,$sequenceKeys,
221: $sequenceHeadings)=@_;
222:
223: my $Str = '';
1.4 stredwic 224: $Str .= '<table border="0" cellpadding="0" cellspacing="0">'."\n";
225:
226: $Str .= '<tr>'."\n";
227: $Str .= &CreateColumnSelectors($infoHeadings, $sequenceHeadings,
228: $sequenceKeys);
229: $Str .= '<td></td></tr>'."\n";
1.2 stredwic 230:
1.4 stredwic 231: $Str .= '<tr>'."\n";
1.2 stredwic 232: my $displayString = '<td align="left"><pre><a href="/adm/statistics?';
233: $displayString .= 'sort=LINKDATA">DISPLAYDATA</a>FORMATTING';
234: $displayString .= $spacing.'</pre></td>'."\n";
235: $Str .= &Apache::lonhtmlcommon::CreateHeadings($cache,
236: $infoKeys,
237: $infoHeadings,
238: $displayString,
239: 'preformatted');
240:
1.8 ! stredwic 241: $displayString = '<td align="left"><pre>DISPLAYDATAFORMATTING'.$spacing;
1.2 stredwic 242: $displayString .= '</pre></td>'."\n";
243: $Str .= &Apache::lonhtmlcommon::CreateHeadings($cache,
244: $sequenceKeys,
245: $sequenceHeadings,
246: $displayString,
247: 'preformatted');
248:
249: $Str .= '<td><pre>Total Solved/Total Problems</pre></td>';
250: $Str .= '</tr></table>'."\n";
251:
252: return $Str;
253: }
254:
255: =pod
256:
257: =item &FormatStudentData()
258:
259: First, FormatStudentInformation is called and prefixes the course information.
260: This function produces a formatted string of the student's course information.
261: Each column of data represents all the problems for a given sequence. For
262: valid grade data, a link is created for that problem to a submission record
263: for that problem.
264:
265: =over 4
266:
267: Input: $name, $studentInformation, $ChartDB
268:
269: $name: The name and domain of the current student in name:domain format
270:
271: $studentInformation: A pointer to an array holding the names used to
272: remove data from the hash. They represent
273: the name of the data to be removed.
274:
275: $ChartDB: The name of the cached data database which will be tied to that
276: database.
277:
278: Output: $Str
279:
280: $Str: Formatted string that is an entire row of the chart. It is a
281: concatenation of student information and student course information.
282:
283: =back
284:
285: =cut
1.1 stredwic 286:
287: sub StudentReport {
1.2 stredwic 288: my ($cache,$name,$spacing,$showSequences)=@_;
289: my ($username,$domain)=split(':',$name);
1.1 stredwic 290:
291: my $Str = '';
1.8 ! stredwic 292: if(defined($cache->{$name.':error'})) {
! 293: return $Str;
! 294: }
1.1 stredwic 295: if($cache->{$name.':error'} =~ /course/) {
296: $Str .= '<b><font color="blue">No course data for student </font>';
297: $Str .= '<font color="red">'.$username.'.</font></b><br>';
298: return $Str;
299: }
300:
1.2 stredwic 301: foreach my $sequence (@$showSequences) {
302: my $characterCount=0;
1.1 stredwic 303: foreach my $problemID (split(':', $cache->{$sequence.':problems'})) {
304: my $problem = $cache->{$problemID.':problem'};
1.2 stredwic 305: # All grades (except for versionless parts) are displayed as links
306: # to their submission record. Loop through all the parts for the
307: # current problem in the correct order and prepare the output links
308: foreach(split(/\:/,$cache->{$sequence.':'.$problemID.
309: ':parts'})) {
1.8 ! stredwic 310: $characterCount++;
! 311: if(defined($cache->{$name.':'.$problemID.':NoVersion'}) ||
! 312: $cache->{$name.':'.$problemID.':'.$_.':code'} eq ' ') {
! 313: $Str .= ' ';
! 314: next;
1.2 stredwic 315: }
1.8 ! stredwic 316: $Str .= '<a href="/adm/grades?symb=';
! 317: $Str .= &Apache::lonnet::escape($problem);
! 318: $Str .= '&student='.$username.'&domain='.$domain;
! 319: $Str .= '&command=submission">';
! 320: my $code = $cache->{$name.':'.$problemID.':'.$_.':code'};
! 321: my $tries = $cache->{$name.':'.$problemID.':'.$_.':tries'};
! 322: if($code eq '*' && $tries < 10 && $tries ne '') {
! 323: $code = $tries;
1.2 stredwic 324: }
1.8 ! stredwic 325: $Str .= $code;
! 326: $Str.='</a>';
1.2 stredwic 327: }
328: }
329:
330: # Output the number of correct answers for the current sequence.
331: # This part takes up 6 character slots, but is formated right
332: # justified.
333: my $spacesNeeded=$cache->{$sequence.':columnWidth'}-$characterCount;
334: $spacesNeeded -= 3;
335: $Str .= (' 'x$spacesNeeded);
336:
1.8 ! stredwic 337: my $outputProblemsCorrect = sprintf("%3d", $cache->{$name.':'.$sequence.
! 338: ':problemsCorrect'});
1.2 stredwic 339: $Str .= '<font color="#007700">'.$outputProblemsCorrect.'</font>';
340: $Str .= $spacing;
1.1 stredwic 341: }
342:
1.2 stredwic 343: # Output the total correct problems over the total number of problems.
344: # I don't like this type of formatting, but it is a solution. Need
345: # a way to dynamically determine the space requirements.
1.8 ! stredwic 346: my $outputProblemsSolved = sprintf("%4d", $cache->{$name.':problemsSolved'});
! 347: my $outputTotalProblems = sprintf("%4d", $cache->{$name.':totalProblems'});
1.2 stredwic 348: $Str .= '<font color="#000088">'.$outputProblemsSolved.
349: ' / '.$outputTotalProblems.'</font>';
1.1 stredwic 350:
351: return $Str;
352: }
353:
1.2 stredwic 354: =pod
355:
356: =item &CreateLegend()
357:
358: This function returns a formatted string containing the legend for the
359: chart. The legend describes the symbols used to represent grades for
360: problems.
361:
362: =cut
363:
364: sub CreateLegend {
365: my $Str = "<p><pre>".
366: "1..9: correct by student in 1..9 tries\n".
367: " *: correct by student in more than 9 tries\n".
368: " +: correct by override\n".
369: " -: incorrect by override\n".
370: " .: incorrect attempted\n".
371: " #: ungraded attempted\n".
372: " : not attempted\n".
373: " x: excused".
374: "</pre><p>";
375: return $Str;
376: }
377:
378: =pod
379:
380: =item &CreateColumnSelectionBox()
381:
382: If there are columns not being displayed then this selection box is created
383: with a list of those columns. When selections are made and the page
384: refreshed, the columns will be removed from this box and the column is
385: put back in the chart. If there is no columns to select, no row is added
386: to the interface table.
387:
388: =over 4
389: Input: $CacheData, $headings
390:
391:
392: $CacheData: A pointer to a hash tied to the cached data
393:
394: $headings: An array of the names of the columns for the student information.
395: They are used for displaying which columns are missing.
396:
397: Output: $notThere
398:
399: $notThere: The string contains one row of a table. The first column has the
400: name of the selection box. The second contains the selection box
401: which has a size of four.
402:
403: =back
404:
405: =cut
406:
407: sub CreateColumnSelectionBox {
1.4 stredwic 408: my ($doNotShow)=@_;
1.2 stredwic 409:
1.4 stredwic 410: my $notThere = '';
411: $notThere .= '<select name="ReselectColumns" size="4" ';
412: $notThere .= 'multiple="true">'."\n";
413:
414: for(my $index=0; $index<$doNotShow->{'count'}; $index++) {
415: my $name = $doNotShow->{$index.':name'};
416: $notThere .= '<option value="';
417: $notThere .= $doNotShow->{$index.':id'}.'">';
1.2 stredwic 418: $notThere .= $name.'</option>'."\n";
419: }
420:
1.4 stredwic 421: $notThere .= '</select>';
1.2 stredwic 422:
1.4 stredwic 423: return $notThere;
1.2 stredwic 424: }
425:
426: =pod
427:
428: =item &CreateColumnSelectors()
429:
430: This function generates the checkboxes above the column headings. The
431: column will be removed if the checkbox is unchecked.
432:
433: =over 4
434:
435: Input: $CacheData, $headings
436:
437: $CacheData: A pointer to a hash tied to the cached data
438:
439: $headings: An array of the names of the columns for the student
440: information. They are used to know what are the student information columns
441:
442: Output: $present
443:
444: $present: The string contains the first row of a table. Each column contains
445: a checkbox which is left justified. Currently left justification is used
446: for consistency of location over the column in which it presides.
447:
448: =back
449:
450: =cut
451:
452: sub CreateColumnSelectors {
1.4 stredwic 453: my ($infoHeadings, $sequenceHeadings, $sequenceKeys)=@_;
1.2 stredwic 454:
1.4 stredwic 455: my $present = '';
456: for(my $index=0; $index<(scalar @$infoHeadings); $index++) {
1.2 stredwic 457: $present .= '<td align="left">';
458: $present .= '<input type="checkbox" checked="on" ';
1.4 stredwic 459: $present .= 'name="HeadingColumn'.$infoHeadings->[$index].'" />';
460: $present .= '</td>'."\n";
1.2 stredwic 461: }
462:
1.4 stredwic 463: for(my $index=0; $index<(scalar @$sequenceHeadings); $index++) {
1.2 stredwic 464: $present .= '<td align="left">';
465: $present .= '<input type="checkbox" checked="on" ';
1.4 stredwic 466: $present .= 'name="SequenceColumn'.$sequenceKeys->[$index].'" />';
467: $present .= '</td>'."\n";
1.2 stredwic 468: }
469:
1.4 stredwic 470: return $present;
1.2 stredwic 471: }
472:
1.1 stredwic 473: #---- END Student Assessment Web Page ----------------------------------------
1.2 stredwic 474:
475: #---- Student Assessment Worker Functions ------------------------------------
476:
477: sub FindSelectedStudent {
478: my($cache, $selectedName, $students)=@_;
1.3 stredwic 479:
480: if($selectedName eq 'All Students' ||
481: $selectedName eq 'No Student Selected') {
482: return $selectedName;
483: }
484:
485: for(my $index=0; $index<(scalar @$students); $index++) {
1.2 stredwic 486: my $fullname = $cache->{$students->[$index].':fullname'};
487: if($fullname eq $selectedName) {
488: if($cache->{'StudentAssessmentMove'} eq 'next') {
489: if($index == ((scalar @$students) - 1)) {
490: $selectedName = $students->[0];
1.3 stredwic 491: return $selectedName;
1.2 stredwic 492: } else {
493: $selectedName = $students->[$index+1];
1.3 stredwic 494: return $selectedName;
1.2 stredwic 495: }
496: } elsif($cache->{'StudentAssessmentMove'} eq 'previous') {
497: if($index == 0) {
498: $selectedName = $students->[-1];
1.3 stredwic 499: return $selectedName;
1.2 stredwic 500: } else {
501: $selectedName = $students->[$index-1];
1.3 stredwic 502: return $selectedName;
1.2 stredwic 503: }
504: } else {
505: $selectedName = $students->[$index];
1.3 stredwic 506: return $selectedName;
1.2 stredwic 507: }
508: last;
509: }
510: }
511:
1.3 stredwic 512: return 'No Student Selected';
1.2 stredwic 513: }
514:
515: =pod
516:
517: =item &ShouldShowColumn()
518:
519: Determine if a specified column should be shown on the chart.
520:
521: =over 4
522:
523: Input: $cache, $test
524:
525: $cache: A pointer to the hash tied to the cached data
526:
527: $test: The form name of the column (heading.$headingIndex) or
528: (sequence.$sequenceIndex)
529:
530: Output: 0 (false), 1 (true)
531:
532: =back
533:
534: =cut
535:
536: sub ShouldShowColumns {
537: my ($cache,$headings,$cacheKey)=@_;
538:
539: my @infoKeys=();
540: my @infoHeadings=();
541:
542: my @sequenceKeys=();
543: my @sequenceHeadings=();
544:
1.4 stredwic 545: my %doNotShow;
546:
1.2 stredwic 547: my $index;
1.4 stredwic 548: my $count = 0;
549: my $check = '';
1.2 stredwic 550: for($index=0; $index < scalar @$headings; $index++) {
1.4 stredwic 551: $check = 'HeadingColumn'.$headings->[$index];
552: if($cache->{'HeadingsFound'} =~ /$check/) {
553: push(@infoHeadings, $headings->[$index]);
554: push(@infoKeys, $cacheKey->[$index]);
555: } else {
556: $doNotShow{$count.':name'} = $headings->[$index];
557: $doNotShow{$count.':id'} = 'HeadingColumn'.$headings->[$index];
558: $count++;
559: }
1.2 stredwic 560: }
561:
562: foreach my $sequence (split(/\:/,$cache->{'orderedSequences'})) {
1.4 stredwic 563: $check = 'SequenceColumn'.$sequence;
564: if($cache->{'SequencesFound'} eq 'All Sequences' ||
565: $cache->{'SequencesFound'} =~ /$check/) {
566: push(@sequenceHeadings, $cache->{$sequence.':title'});
567: push(@sequenceKeys, $sequence);
568: } else {
569: $doNotShow{$count.':name'} = $cache->{$sequence.':title'};
570: $doNotShow{$count.':id'} = 'SequenceColumn'.$sequence;
571: $count++;
572: }
1.2 stredwic 573: }
574:
1.4 stredwic 575: $doNotShow{'count'} = $count;
1.2 stredwic 576:
577: return (\@infoHeadings, \@infoKeys, \@sequenceHeadings,
1.4 stredwic 578: \@sequenceKeys, \%doNotShow);
1.2 stredwic 579: }
580:
581: #---- END Student Assessment Worker Functions --------------------------------
582:
1.1 stredwic 583: 1;
584: __END__
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>