File:
[LON-CAPA] /
loncom /
interface /
statistics /
lonproblemanalysis.pm
Revision
1.96:
download - view:
text,
annotated -
select for diffs
Wed Oct 27 17:47:13 2004 UTC (20 years, 2 months ago) by
matthew
Branches:
MAIN
CVS tags:
HEAD
Modifications to option response analysis.
Tries & time based analysis:
use 'statements' instead of 'foils' on plots.
list number of students attempting, number of submissions plotted,
number of correct submissions, and number of incorrect submissions.
time based analysis:
Fixed a bug where the concept and foil graphs appeared to have a different
number of data points to plot by consolidating the answer post-processing
code into &OR_time_process_data, which needed to happen anyways.
# The LearningOnline Network with CAPA
#
# $Id: lonproblemanalysis.pm,v 1.96 2004/10/27 17:47:13 matthew Exp $
#
# Copyright Michigan State University Board of Trustees
#
# This file is part of the LearningOnline Network with CAPA (LON-CAPA).
#
# LON-CAPA is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# LON-CAPA is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with LON-CAPA; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
#
# /home/httpd/html/adm/gpl.txt
#
# http://www.lon-capa.org/
#
package Apache::lonproblemanalysis;
use strict;
use Apache::lonnet();
use Apache::loncommon();
use Apache::lonhtmlcommon();
use Apache::loncoursedata();
use Apache::lonstatistics;
use Apache::lonlocal;
use Apache::lonstathelpers();
use Apache::lonstudentsubmissions();
use HTML::Entities();
use Time::Local();
use Spreadsheet::WriteExcel();
my $plotcolors = ['#33ff00',
'#0033cc', '#990000', '#aaaa66', '#663399', '#ff9933',
'#66ccff', '#ff9999', '#cccc33', '#660000', '#33cc66',
];
my @SubmitButtons = ({ name => 'PrevProblemAnalysis',
text => 'Previous Problem' },
{ name => 'ProblemAnalysis',
text => 'Analyze Problem Again' },
{ name => 'NextProblemAnalysis',
text => 'Next Problem' },
{ name => 'break'},
{ name => 'SelectAnother',
text => 'Choose a different Problem' },
{ name => 'ExcelOutput',
text => 'Produce Excel Output' });
sub BuildProblemAnalysisPage {
my ($r,$c)=@_;
#
my %Saveable_Parameters = ('Status' => 'scalar',
'Section' => 'array',
'NumPlots' => 'scalar',
'AnalyzeOver' => 'scalar',
);
&Apache::loncommon::store_course_settings('problem_analysis',
\%Saveable_Parameters);
&Apache::loncommon::restore_course_settings('problem_analysis',
\%Saveable_Parameters);
#
&Apache::lonstatistics::PrepareClasslist();
#
$r->print(&CreateInterface());
#
my @Students = @Apache::lonstatistics::Students;
#
if (@Students < 1 && exists($ENV{'form.firstrun'})) {
$r->print('<h2>There are no students in the sections selected</h2>');
}
#
my @CacheButtonHTML =
&Apache::lonstathelpers::manage_caches($r,'Statistics','stats_status');
$r->rflush();
#
# Support for numerical and radio response isn't complete enough to
# include in 1.2 release.
# my $problem_types = '(option|radiobutton|numerical)';
my $problem_types = '.';#(option)';
if (exists($ENV{'form.problemchoice'}) &&
! exists($ENV{'form.SelectAnother'})) {
foreach my $button (@SubmitButtons) {
if ($button->{'name'} eq 'break') {
$r->print("<br />\n");
} else {
$r->print('<input type="submit" name="'.$button->{'name'}.'" '.
'value="'.&mt($button->{'text'}).'" />');
$r->print(' 'x5);
}
}
foreach my $html (@CacheButtonHTML) {
$r->print($html.(' 'x5));
}
#
$r->print('<hr />');
$r->rflush();
#
# Determine which problem we are to analyze
my $current_problem = &Apache::lonstathelpers::get_target_from_id
($ENV{'form.problemchoice'});
#
my ($prev,$curr,$next) =
&Apache::lonstathelpers::get_prev_curr_next($current_problem,
$problem_types,
'response',
);
if (exists($ENV{'form.PrevProblemAnalysis'}) && defined($prev)) {
$current_problem = $prev;
} elsif (exists($ENV{'form.NextProblemAnalysis'}) && defined($next)) {
$current_problem = $next;
} else {
$current_problem = $curr;
}
#
# Store the current problem choice and send it out in the form
$ENV{'form.problemchoice'} =
&Apache::lonstathelpers::make_target_id($current_problem);
$r->print('<input type="hidden" name="problemchoice" value="'.
$ENV{'form.problemchoice'}.'" />');
#
if (! defined($current_problem->{'resource'})) {
$r->print('resource is undefined');
} else {
my $resource = $current_problem->{'resource'};
$r->print('<h1>'.$resource->{'title'}.'</h1>');
$r->print('<h3>'.$resource->{'src'}.'</h3>');
if ($ENV{'form.show_prob'} eq 'true') {
$r->print(&Apache::lonstathelpers::render_resource($resource));
}
$r->rflush();
my %Data = &Apache::lonstathelpers::get_problem_data
($resource->{'src'});
my $problem_data = $Data{$current_problem->{'part'}.
'.'.
$current_problem->{'respid'}};
if ($current_problem->{'resptype'} eq 'option') {
&OptionResponseAnalysis($r,$current_problem,
$problem_data,
\@Students);
} elsif ($current_problem->{'resptype'} eq 'radiobutton') {
&RadioResponseAnalysis($r,$current_problem,
$problem_data,
\@Students);
} elsif ($current_problem->{'resptype'} eq 'numerical') {
##
## analyze all responses of a problem at once
my $res = $current_problem->{'resource'};
foreach my $partid (@{$res->{'parts'}}) {
$current_problem->{'part'} = $partid;
foreach my $respid (@{$res->{'partdata'}->{$partid}->{'ResponseIds'}}) {
$current_problem->{'respid'}=$respid;
&NumericalResponseAnalysis($r,$current_problem,
$problem_data,\@Students);
}
}
} else {
$r->print('<h2>This analysis is not supported</h2>');
}
}
$r->print('<hr />');
} else {
$r->print('<input type="submit" name="ProblemAnalysis" value="'.
&mt('Analyze Problem').'" />');
$r->print(' 'x5);
$r->print('<h3>'.&mt('Please select a problem to analyze').'</h3>');
$r->print(&Apache::lonstathelpers::ProblemSelector
($problem_types));
}
}
#########################################################
#########################################################
##
## Numerical Response Routines
##
#########################################################
#########################################################
sub NumericalResponseAnalysis {
my ($r,$problem,$problem_data,$Students) = @_;
my $c = $r->connection();
my ($resource,$partid,$respid) = ($problem->{'resource'},
$problem->{'part'},
$problem->{'respid'});
#
if (scalar(@{$resource->{'parts'}})>1) {
if (@{$resource->{'partdata'}->{$partid}->{'ResponseIds'}}>1) {
$r->print('<h3>'.
&mt('Part [_1], response [_2].',$partid,$respid).
'</h3>');
} else {
$r->print('<h3>'.
&mt('Part [_1]',$partid,$respid).
'</h3>');
}
} elsif (@{$resource->{'partdata'}->{$partid}->{'ResponseIds'}}>1) {
$r->print('<h3>'.&mt('Response [_1]',$respid).'</h3>');
}
#
my $analysis_html;
my $PerformanceData = &Apache::loncoursedata::get_response_data
(\@Apache::lonstatistics::SelectedSections,
$Apache::lonstatistics::enrollment_status,
$resource->{'symb'},$respid);
if (! defined($PerformanceData) ||
ref($PerformanceData) ne 'ARRAY' ) {
$analysis_html = '<h2>'.
&mt('There is no submission data for this resource').
'</h2>';
$r->print($analysis_html);
return;
}
#
# This next call causes all the waiting around that people complain about
&Apache::lonstathelpers::GetStudentAnswers($r,$problem,$Students,
'Statistics',
'stats_status');
return if ($c->aborted());
#
# Collate the data
my %Data;
foreach my $student (@$Students) {
my $answer = $student->{'answer'};
$Data{$answer}++;
}
my @Labels = sort {$a <=> $b } keys(%Data);
my @PlotData = @Data{@Labels};
#
my $width = 500;
my $height = 100;
my $plot = &one_dimensional_plot($r,500,100,scalar(@$Students),
\@Labels,\@PlotData);
$r->print($plot);
return;
}
sub one_dimensional_plot {
my ($r,$width,$height,$N,$Labels,$Data)=@_;
#
# Compute data -> image scaling factors
my $min = $Labels->[0];
my $max = $Labels->[-1];
if ($max == $min) {
$max =$min+1;
}
my $h_scale = ($width-10)/($max-$min);
#
my $max_y = 0;
foreach (@$Data) {
$max_y = $_ if ($max_y < $_);
}
my $ticscale = 5;
if ($max_y * $ticscale > $height/2) {
$ticscale = int($height/2/$max_y);
$ticscale = 1 if ($ticscale < 1);
}
#
# Create the plot
my $plot =
qq{<drawimage width="$width" height="$height" bgcolor="transparent" >};
for (my $idx=0;$idx<scalar(@$Labels);$idx++) {
my $xloc = 5+$h_scale*($Labels->[$idx] - $min);
my $top = $height/2-$Data->[$idx]*$ticscale;
my $bottom = $height/2+$Data->[$idx]*$ticscale;
$plot .=
&line($xloc,$top,$xloc,$bottom,'888888',1);
}
#
# Put the scale on last to ensure it is on top of the data.
if ($min < 0 && $max > 0) {
my $circle_x = 5+$h_scale*abs($min); # '0' in data coordinates
my $r = 4;
$plot .= &line(5,$height/2,$circle_x-$r,$height/2,'000000',1);
$plot .= &circle($circle_x,$height/2,$r+1,'000000');
$plot .= &line($circle_x+$r,$height/2,$width-5,$height/2,'000000',1);
} else {
$plot .= &line(5,$height/2,$width-5,$height/2,'000000',1);
}
$plot .= '</drawimage>';
my $plotresult = &Apache::lonxml::xmlparse($r,'web',$plot);
my $title = 'Distribution of correct answers';
my $result = '<table>'.
'<tr><td colspan="3" align="center">'.
'<font size="+2">'.$title.' (N='.$N.')'.
'</font>'.
'</td></tr>'.
'<tr>'.
'<td valign="center">'.$min.'</td>'.
'<td>'.$plotresult.'</td>'.
'<td valign="center">'.$max.'</td>'.
'</tr>'.
'<tr><td colspan="3" align="center">'.
'Maximum Number of Coinciding Values: '.$max_y.
'</td></tr>'.
'</table>';
return $result;
}
##
## Helper subroutines for <drawimage>.
## These should probably go somewhere more suitable soon.
sub line {
my ($x1,$y1,$x2,$y2,$color,$thickness) = @_;
return qq{<line x1="$x1" y1="$y1" x2="$x2" y2="$y2" color="$color" thickness="$thickness" />$/};
}
sub text {
my ($x,$y,$color,$text,$font,$direction) = @_;
if (! defined($font) || $font !~ /^(tiny|small|medium|large|giant)$/) {
$font = 'medium';
}
if (! defined($direction) || $direction ne 'vertical') {
$direction = '';
}
return qq{<text x="$x" y="$y" color="$color" font="$font" direction="$direction" >$text</text>};
}
sub rectangle {
my ($x1,$y1,$x2,$y2,$color,$thickness,$filled) = @_;
return qq{<rectangle x1="$x1" y1="$y1" x2="$x2" y2="$y2" color="$color" thickness="$thickness" filled="$filled" />};
}
sub arc {
my ($x,$y,$width,$height,$start,$end,$color,$thickness,$filled)=@_;
return qq{<arc x="$x" y="$y" width="$width" height="$height" start="$start" end="$end" color="$color" thickness="$thickness" filled="$filled" />};
}
sub circle {
my ($x,$y,$radius,$color,$thickness,$filled)=@_;
return &arc($x,$y,$radius,$radius,0,360,$color,$thickness,$filled);
}
sub build_student_data_worksheet {
my ($workbook,$format) = @_;
my $rows_output = 3;
my $cols_output = 0;
my $worksheet = $workbook->addworksheet('Student Data');
$worksheet->write($rows_output++,0,'Student Data',$format->{'h3'});
my @Headers = ('full name','username','domain','section',
"student\nnumber",'identifier');
$worksheet->write_row($rows_output++,0,\@Headers,$format->{'header'});
my @Students = @Apache::lonstatistics::Students;
my $studentrows = &Apache::loncoursedata::get_student_data(\@Students);
my %ids;
foreach my $row (@$studentrows) {
my ($mysqlid,$student) = @$row;
$ids{$student}=$mysqlid;
}
foreach my $student (@Students) {
my $name_domain = $student->{'username'}.':'.$student->{'domain'};
$worksheet->write_row($rows_output++,0,
[$student->{'fullname'},
$student->{'username'},$student->{'domain'},
$student->{'section'},$student->{'id'},
$ids{$name_domain}]);
}
return $worksheet;
}
#########################################################
#########################################################
##
## Radio Response Routines
##
#########################################################
#########################################################
sub RadioResponseAnalysis {
my ($r,$problem,$problem_analysis,$students) = @_;
if ($ENV{'form.AnalyzeOver'} eq 'tries') {
&RR_tries_analysis($r,$problem,$problem_analysis,$students);
} elsif ($ENV{'form.AnalyzeOver'} eq 'time') {
&RR_static_time_analysis($r,$problem,$problem_analysis,$students);
} else {
$r->print('Bad request');
}
return;
}
sub RR_computed_tries_analysis {
my ($r,$problem,$problem_analysis) = @_;
my ($resource,$partid,$respid) = ($problem->{'resource'},
$problem->{'part'},
$problem->{'respid'});
$r->print('The tries answer you seek must be computed');
# Gather student data
# for each try
# loop through data, classifying it by
# correct foil -> selected foil
# if there is concept data
# make a concept correct plot
# for each correct foil
# make a plot of the data
}
sub RR_computed_time_analysis {
my ($r,$problem,$problem_analysis) = @_;
my ($resource,$partid,$respid) = ($problem->{'resource'},
$problem->{'part'},
$problem->{'respid'});
$r->print('The time answer you seek must be computed');
# Gather student data
# for time division
# limit to between start time & end time
# loop through data, classifying it by
# correct foil -> selected foil
# if there is concept data
# make a concept correct plot
# for each correct foil
# make a plot of the data
}
sub RR_tries_analysis {
my ($r,$problem,$problem_analysis,$students) = @_;
my ($resource,$partid,$respid) = ($problem->{'resource'},
$problem->{'part'},
$problem->{'respid'});
#
my $analysis_html;
my $foildata = $problem_analysis->{'_Foils'};
my ($table,$foils,$concepts) = &build_foil_index($problem_analysis);
$analysis_html .= $table;
# Gather student data
my $response_data = &Apache::loncoursedata::get_response_data
(\@Apache::lonstatistics::SelectedSections,
$Apache::lonstatistics::enrollment_status,
$resource->{'symb'},$respid);
my $correct; # either a hash reference or a scalar
if ($problem_analysis->{'answercomputed'} || scalar(@$concepts) > 1) {
# This takes a while for large classes...
&Apache::lonstathelpers::GetStudentAnswers($r,$problem,$students,
'Statistics',
'stats_status');
foreach my $student (@$students) {
my ($idx,@remainder) = split('&',$student->{'answer'});
my ($answer) = ($remainder[$idx]=~/^(.*)=([^=]*)$/);
$correct->{$student->{'username'}.':'.$student->{'domain'}}=
&Apache::lonnet::unescape($answer);
}
} else {
foreach my $foil (keys(%$foildata)) {
if ($foildata->{$foil}->{'value'} eq 'true') {
$correct = $foildata->{$foil}->{'name'};
last;
}
}
}
if (! defined($response_data) ||
ref($response_data) ne 'ARRAY' ) {
$analysis_html = '<h2>'.
&mt('There is no submission data for this resource').
'</h2>';
$r->print($analysis_html);
return;
}
#
$analysis_html.='<table>';
for (my $try = 1;$try<=$ENV{'form.NumPlots'};$try++) {
# classify data ->correct foil -> selected foil
my $attempt_restriction_function =
my $foil_choice_data =
&RR_classify_response_data($response_data,$correct,
sub {($_[0]->{'tries'} == $try?1:0)});
my $answers;
if (ref($correct)) {
my %tmp;
foreach my $foil (values(%$correct)) {
$tmp{$foil}++;
}
$answers = [keys(%tmp)];
} else {
$answers = [$correct];
}
# Concept Plot
my $concept_plot = '';
if (scalar(@$concepts) > 1) {
$concept_plot = &RR_concept_plot($concepts,$foil_choice_data,
'% choosing');
}
# % Choosing plot
my $choice_plot = &RR_create_percent_selected_plot
($foils,$foil_choice_data,'Attempt '.$try);
# for each correct foil, how did they mark it? (stacked bar graph)
my ($stacked_plot,$count_by_foil) =
&RR_create_stacked_selection_plot($foils,$foil_choice_data,'');
#
if ($concept_plot ne '' ||
$choice_plot ne '' ||
$stacked_plot ne '') {
$analysis_html.=
'<tr>'.
'<td>'.$concept_plot.'</td>'.
'<td>'.$choice_plot.'</td>';
if ($stacked_plot ne '') {
$analysis_html .=
'<td>'.$stacked_plot.'</td>'.
'<td>'.&build_foil_key($foils,$count_by_foil).'</td>';
} else {
$analysis_html .= ('<td></td>'x2);
}
$analysis_html.='</tr>'.$/;
}
}
$analysis_html.='</table>';
$r->print($analysis_html);
}
sub RR_concept_plot {
my ($concepts,$foil_data,$title) = @_;
#
my %correct_by_concept;
my %incorrect_by_concept;
my %true;
foreach my $concept (@$concepts) {
foreach my $foil (@{$concept->{'foils'}}) {
next if (! exists($foil_data->{$foil}));
foreach my $choice (keys(%{$foil_data->{$foil}})) {
if ($choice eq $foil) {
$correct_by_concept{$concept->{'name'}} +=
$foil_data->{$foil}->{$choice};
} else {
$incorrect_by_concept{$concept->{'name'}} +=
$foil_data->{$foil}->{$choice};
}
}
}
}
#
# need arrays for incorrect and correct because we want to use different
# colors for them
my @correct;
#
my $total =0;
for (my $i=0;$i<scalar(@$concepts);$i++) {
my $concept = $concepts->[$i];
$correct[$i] = $correct_by_concept{$concept->{'name'}};
$total += $correct_by_concept{$concept->{'name'}}+
$incorrect_by_concept{$concept->{'name'}};
}
if ($total == 0) { return ''; };
for (my $i=0;$i<=$#correct;$i++) {
$correct[$i] = sprintf('%0f',$correct[$i]/$total*100);
}
my $xlabel = 'concept';
$title.= ' (N='.$total.')';
my $plot= &Apache::loncommon::DrawBarGraph($title,
$xlabel,
'Percent Choosing',
100,
['#33ff00','#ff3300'],
undef,
\@correct);
return $plot;
}
sub RR_create_percent_selected_plot {
my ($foils,$foil_data,$title) = @_;
#
my %foil_selections;
my %true;
foreach my $foil (@$foils) {
# foil_data has format $foil_data->{true_foil}->{selected foil}
next if (! exists($foil_data->{$foil}));
$true{$foil}++;
while (my ($f,$count)= each(%{$foil_data->{$foil}})) {
$foil_selections{$f}+=$count;
}
}
#
# need arrays for incorrect and correct because we want to use different
# colors for them
my @correct;
my @incorrect;
#
my $total =0;
for (my $i=0;$i<scalar(@$foils);$i++) {
my $foil = $foils->[$i];
if ($true{$foil}) {
$correct[$i] = $foil_selections{$foil};
$incorrect[$i] = 0;
} else {
$correct[$i] = 0;
$incorrect[$i] = $foil_selections{$foil};
}
$total+=$foil_selections{$foil};
}
if ($total == 0) { return ''; };
for (my $i=0;$i<=$#correct;$i++) {
$correct[$i] = sprintf('%0f',$correct[$i]/$total*100);
}
for (my $i=0;$i<=$#incorrect;$i++) {
$incorrect[$i] = sprintf('%0f',$incorrect[$i]/$total*100);
}
my $xlabel = 'foil chosen';
$title.= ' (N='.$total.')';
my $plot= &Apache::loncommon::DrawBarGraph($title,
$xlabel,
'Percent Choosing',
100,
['#33ff00','#ff3300'],
undef,
\@correct,
\@incorrect);
return $plot;
}
sub RR_create_stacked_selection_plot {
my ($foils,$foil_data,$title)=@_;
#
my @correct_choice; # the green row
my @dataset; # array of array refs - multicolor rows.
my %filled;
my @labels;
my $count=-1;
my %column;
for (my $i=0;$i<scalar(@$foils);$i++) {
next if (! exists($foil_data->{$foils->[$i]}));
my $correct_foil = $foils->[$i];
push(@labels,$i+1);
$column{$correct_foil}= ++$count;
for (my $j=0;$j<scalar(@$foils);$j++) {
my $value = 0;
if ($i != $j ) {
$value += $foil_data->{$correct_foil}->{$foils->[$j]};
}
$dataset[$j]->[$column{$correct_foil}]=$value;
}
}
#
return '' if (! scalar(keys(%column)));
#
my $grand_total = 0;
my %count_per_foil;
while (my ($foil,$bar) = each (%column)) {
my $bar_total = 0;
for (my $j=0;$j<scalar(@dataset);$j++) {
$bar_total += $dataset[$j]->[$bar];
}
next if ($bar_total == 0);
for (my $j=0;$j<scalar(@dataset);$j++) {
$dataset[$j]->[$bar] =
sprintf('%2f',$dataset[$j]->[$bar]/$bar_total * 100);
}
$count_per_foil{$foil}=' (N='.$bar_total.')';
$grand_total += $bar_total;
}
if ($grand_total == 0) {
return ('',undef);
}
my @empty_row = ();
foreach (@{$dataset[0]}) {
push(@empty_row,0);
}
#
$title .= ' (N='.$grand_total.')';
my $graph = &Apache::loncommon::DrawBarGraph
($title,'Correct Foil','foils chosen Incorrectly',
100,$plotcolors,\@labels,\@empty_row,@dataset);
return ($graph,\%count_per_foil);
}
# if $correct is a hash ref, it is assumed to be indexed by student names.
# the values are assumed to be hash refs with a key of 'answer'.
sub RR_classify_response_data {
my ($full_row_data,$correct,$function) = @_;
my %submission_data;
foreach my $row (@$full_row_data) {
my %subm = &hashify_attempt($row);
if (ref($correct) eq 'HASH') {
$subm{'correct'} = $correct->{$subm{'student'}};
} else {
$subm{'correct'} = $correct;
}
$subm{'submission'} =~ s/=\d+\s*$//;
if (&$function(\%subm)) {
$submission_data{$subm{'correct'}}->{$subm{'submission'}}++;
}
}
return \%submission_data;
}
sub RR_static_time_analysis {
my ($r,$problem,$problem_analysis) = @_;
my ($resource,$partid,$respid) = ($problem->{'resource'},
$problem->{'part'},
$problem->{'respid'});
$r->print('<h3>The time answer you seek is static</h3>');
my $analysis_html;
# Gather student data
my $response_data = &Apache::loncoursedata::get_response_data
(\@Apache::lonstatistics::SelectedSections,
$Apache::lonstatistics::enrollment_status,
$resource->{'symb'},$respid);
if (! defined($response_data) ||
ref($response_data) ne 'ARRAY' ) {
$analysis_html = '<h2>'.
&mt('There is no submission data for this resource').
'</h2>';
$r->print($analysis_html);
return;
}
# for time division
# limit to between start time & end time
# loop through data, classifying it by
# correct foil -> selected foil
# if there is concept data
# make a concept correct plot
# for each correct foil
# make a plot of the data
}
=pod
} elsif ($ENV{'form.AnalyzeOver'} eq 'tries') {
$analysis_html .= &RR_tries_Analysis($r,$problem->{'resource'},
$PerformanceData,$problem_data);
} elsif ($ENV{'form.AnalyzeOver'} eq 'time') {
$analysis_html .= &RR_time_Analysis($r,$problem->{'resource'},
$PerformanceData,$problem_data);
} else {
$analysis_html .= '<h2>'.
&mt('The analysis you have selected is not supported at this time').
'</h2>';
}
$r->print($analysis_html);
}
sub RR_Excel_output {
my ($r,$PerformanceData,$problem_data) = @_;
return '<h1>No!</h1>';
}
sub RR_tries_Analysis {
my ($r,$resource,$PerformanceData,$problem_data) = @_;
my $analysis_html;
my $mintries = 1;
my $maxtries = $ENV{'form.NumPlots'};
my ($table,$Foils,$Concepts) = &build_foil_index($problem_data);
if ((! defined($Concepts)) || (@$Concepts < 2)) {
$table = '<h3>'.
&mt('Not enough data for concept analysis. '.
'Performing Foil Analysis').
'</h3>'.$table;
}
$analysis_html .= $table;
my @TryData = &RR_tries_data_analysis($r,$PerformanceData);
$analysis_html .= &RR_tries_Foil_Analysis($mintries,$maxtries,$Foils,
\@TryData,$problem_data);
return $analysis_html;
}
sub RR_tries_data_analysis {
my ($r,$Attempt_data) = @_;
my @TryData;
foreach my $attempt (@$Attempt_data) {
my %Attempt = &hashify_attempt($attempt);
my ($answer,undef) = split('=',$Attempt{'submission'});
$TryData[$Attempt{'tries'}]->{$answer}++;
}
return @TryData;
}
sub RR_time_Analysis {
my ($r,$PerformanceData,$problem_data) = @_;
my $html;
return $html;
}
sub RR_tries_Foil_Analysis {
my ($min,$max,$Foils,$TryData,$problem_data) = @_;
my $html;
#
# Compute the data neccessary to make the plots
for (my $try=$min;$try<=$max;$try++) {
my @PlotData_Correct;
my @PlotData_Incorrect;
next if ($try > scalar(@{$TryData}));
next if (! defined($TryData->[$try]));
my %DataSet = %{$TryData->[$try]};
my $total = 0;
foreach my $foilid (@$Foils) {
$total += $DataSet{$foilid};
}
foreach my $foilid (@$Foils) {
if ($total == 0) {
push (@PlotData_Correct,0);
push (@PlotData_Incorrect,0);
} else {
if ($problem_data->{'_Foils'}->{$foilid}->{'value'} eq 'true') {
push (@PlotData_Correct,
int(100*$DataSet{$foilid}/$total));
push (@PlotData_Incorrect,0);
} else {
push (@PlotData_Correct,0);
push (@PlotData_Incorrect,
int(100*$DataSet{$foilid}/$total));
}
}
}
my $title='Attempt '.$try.' (N='.$total.')';
my $xlabel = 'Foil Chosen';
$html.= &Apache::loncommon::DrawBarGraph($title,
$xlabel,
'Percent Choosing',
100,
['#33ff00','#ff3300'],
undef,
\@PlotData_Correct,
\@PlotData_Incorrect);
}
return $html;
}
sub RR_tries_Concept_Analysis {
my ($min,$max,$Concepts,$ResponseData,$problem_data) = @_;
my $html;
return $html;
}
sub RR_time_Foil_Analysis {
my ($min,$max,$Foils,$ResponseData,$problem_data) = @_;
my $html;
return $html;
}
sub RR_time_Concept_Analysis {
my ($min,$max,$Concepts,$ResponseData,$problem_data) = @_;
my $html;
return $html;
}
sub get_Radio_problem_data {
my ($url) = @_;
my $Answ=&Apache::lonnet::ssi($url,('grade_target' => 'analyze'));
(my $garbage,$Answ)=split('_HASH_REF__',$Answ,2);
my %Answer = &Apache::lonnet::str2hash($Answ);
my %Partdata;
foreach my $part (@{$Answer{'parts'}}) {
while (my($key,$value) = each(%Answer)) {
# if (ref($value) eq 'ARRAY') {
# &Apache::lonnet::logthis('is ref part:'.$part.' '.$key.'='.join(',',@$value));
# } else {
# &Apache::lonnet::logthis('notref part:'.$part.' '.$key.'='.$value);
# }
next if ($key !~ /^$part/);
$key =~ s/^$part\.//;
if ($key eq 'foils') {
$Partdata{$part}->{'_Foils'}=$value;
} elsif ($key eq 'options') {
$Partdata{$part}->{'_Options'}=$value;
} elsif ($key eq 'shown') {
$Partdata{$part}->{'_Shown'}=$value;
} elsif ($key =~ /^foil.value.(.*)$/) {
$Partdata{$part}->{$1}->{'value'}=$value;
} elsif ($key =~ /^foil.text.(.*)$/) {
$Partdata{$part}->{$1}->{'text'}=$value;
}
}
}
return %Partdata;
}
=cut
#########################################################
#########################################################
##
## Option Response Routines
##
#########################################################
#########################################################
sub OptionResponseAnalysis {
my ($r,$problem,$problem_data,$Students) = @_;
my ($resource,$respid) = ($problem->{'resource'},
$problem->{'respid'});
# Note: part data is not needed.
my $PerformanceData = &Apache::loncoursedata::get_response_data
(\@Apache::lonstatistics::SelectedSections,
$Apache::lonstatistics::enrollment_status,
$resource->{'symb'},$respid);
if (! defined($PerformanceData) ||
ref($PerformanceData) ne 'ARRAY' ) {
$r->print('<h2>'.
&mt('There is no student data for this problem.').
'</h2>');
} else {
$r->rflush();
if (exists($ENV{'form.ExcelOutput'})) {
my $result = &OR_excel_sheet($r,$resource,
$PerformanceData,
$problem_data);
$r->print($result);
$r->rflush();
} else {
if ($ENV{'form.AnalyzeOver'} eq 'tries') {
my $analysis_html = &OR_tries_analysis($r,
$PerformanceData,
$problem_data);
$r->print($analysis_html);
$r->rflush();
} elsif ($ENV{'form.AnalyzeOver'} eq 'time') {
my $analysis_html = &OR_time_analysis($PerformanceData,
$problem_data);
$r->print($analysis_html);
$r->rflush();
} else {
$r->print('<h2>'.
&mt('The analysis you have selected is '.
'not supported at this time').
'</h2>');
}
}
}
}
#########################################################
#
# Option Response: tries Analysis
#
#########################################################
sub OR_tries_analysis {
my ($r,$PerformanceData,$ORdata) = @_;
my $mintries = 1;
my $maxtries = $ENV{'form.NumPlots'};
my ($table,$Foils,$Concepts) = &build_foil_index($ORdata);
my %response_data = &OR_analyze_by_tries($r,$PerformanceData,
$mintries,$maxtries);
my $analysis = '';
#
# Compute the data necessary to make the plots
my @foil_plot;
my @concept_data;
for (my $j=0;$j<=scalar(@$Concepts);$j++) {
my $concept = $Concepts->[$j];
foreach my $foilid (@{$concept->{'foils'}}) {
for (my $try=$mintries;$try<=$maxtries;$try++) {
# concept analysis data
$concept_data[$j]->[$try]->{'_correct'} +=
$response_data{$foilid}->[$try]->{'_correct'};
$concept_data[$j]->[$try]->{'_total'} +=
$response_data{$foilid}->[$try]->{'_total'};
#
# foil analysis data
if ($response_data{$foilid}->[$try]->{'_total'} == 0) {
push(@{$foil_plot[$try]->{'_correct'}},0);
} else {
push(@{$foil_plot[$try]->{'_correct'}},
100*$response_data{$foilid}->[$try]->{'_correct'}/
$response_data{$foilid}->[$try]->{'_total'});
}
foreach my $option (@{$ORdata->{'_Options'}}) {
push(@{$foil_plot[$try]->{'_total'}},
$response_data{$foilid}->[$try]->{'_total'});
if ($response_data{$foilid}->[$try]->{'_total'} == 0) {
push (@{$foil_plot[$try]->{$option}},0);
} else {
if ($response_data{$foilid}->[$try]->{'_total'} ==
$response_data{$foilid}->[$try]->{'_correct'}) {
push(@{$foil_plot[$try]->{$option}},0);
} else {
push (@{$foil_plot[$try]->{$option}},
100 *
$response_data{$foilid}->[$try]->{$option} /
($response_data{$foilid}->[$try]->{'_total'}
-
$response_data{$foilid}->[$try]->{'_correct'}
));
}
}
} # End of foreach my $option
}
} # End of foreach my $foilid
} # End of concept loops
#
# Build a table for the plots
my $analysis_html = "<br /><table>\n";
my $optionkey = &build_option_index($ORdata);
my $num_concepts = 1;
if (defined($Concepts)) { $num_concepts = scalar(@$Concepts); }
#
for (my $try=$mintries;$try<=$maxtries;$try++) {
if (! defined($response_data{'_total'}->[$try]) ||
$response_data{'_total'}->[$try] == 0) {
if ($try > 1) {
$analysis_html.= '<tr><td align="center" colspan="4"><b>'.
&mt('None of the selected students attempted the problem more than [_1] times.',$try-1).
'</b></td></tr>';
} else {
$analysis_html.= '<tr><td colspan="4" align="center"><b>'.
&mt('None of the selected students have attempted the problem').'</b></td></tr>';
}
last;
}
my $concept_graph='';
if ($num_concepts > 1) {
#
# Create concept plot
my @concept_plot_data;
for (my $j=0;$j<=$#concept_data;$j++) {
my $total = $concept_data[$j]->[$try]->{'_total'};
if ($total == 0) {
$concept_plot_data[$j] = 0;
} else {
$concept_plot_data[$j] = 100 *
sprintf('%0.3f',
$concept_data[$j]->[$try]->{'_correct'} /
$total);
}
}
#
$concept_graph = &Apache::loncommon::DrawBarGraph
('Correct Concepts','Concept Number','Percent Correct',
100,$plotcolors,undef,\@concept_plot_data);
}
#
# Create Foil Plots
my $data_count = $response_data{'_total'}->[$try];
my $correct = $response_data{'_correct'}->[$try];
my @Datasets;
foreach my $option ('_correct',@{$ORdata->{'_Options'}}) {
next if (! exists($foil_plot[$try]->{$option}));
push(@Datasets,$foil_plot[$try]->{$option});
}
#
# Put a blank in the data set between concepts
for (my $set =0;$set<=$#Datasets;$set++) {
my @Data = @{$Datasets[$set]};
my $idx = 0;
foreach my $concept (@{$Concepts}) {
foreach my $foilid (@{$concept->{'foils'}}) {
$Datasets[$set]->[$idx++]=shift(@Data);
}
if ($concept->{'name'} ne $Concepts->[-1]->{'name'}) {
$Datasets[$set]->[$idx++] = 0;
}
}
}
#
# Set up the labels needed for the bar graph
my @Labels;
my $idx = 1;
foreach my $concept (@{$Concepts}) {
foreach my $foilid (@{$concept->{'foils'}}) {
push(@Labels,$idx++);
}
push(@Labels,'');
}
#
my $correct_graph = &Apache::loncommon::DrawBarGraph
('Correct Statements','Statement','% Answered Correct',
100,$plotcolors,\@Labels,$Datasets[0]);
#
#
next if (! defined($Datasets[0]));
for (my $i=0; $i< scalar(@{$Datasets[0]});$i++) {
$Datasets[0]->[$i]=0;
}
my $count = $response_data{'_total'}->[$try] -
$response_data{'_correct'}->[$try];
my $incorrect_graph = &Apache::loncommon::DrawBarGraph
('Incorrect Statements','Statement','% Chosen Incorrectly',
100,$plotcolors,\@Labels,@Datasets);
$analysis_html.=
'<tr><td colspan="4" align="center">'.
'<font size="+1">'.
&mt('Attempt [_1], [_2] submissions, [_3] correct, [_4] incorrect',
$try,$data_count,$correct,$data_count-$correct).
'</font>'.'</td></tr>'.$/.
'<tr>'.
'<td>'.$concept_graph.'</td>'.
'<td>'.$correct_graph.'</td>'.
'<td>'.$incorrect_graph.'</td>'.
'<td>'.$optionkey.'<td>'.
'</tr>'.$/;
}
$analysis_html .= "</table>\n";
$table .= $analysis_html;
return $table;
}
sub OR_analyze_by_tries {
my ($r,$PerformanceData,$mintries,$maxtries) = @_;
my %Trydata;
$mintries = 1 if (! defined($mintries) || $mintries < 1);
$maxtries = $mintries if (! defined($maxtries) || $maxtries < $mintries);
my @students;
foreach my $row (@$PerformanceData) {
next if (! defined($row));
my $tries = &get_tries_from_row($row);
my %Row = &Process_OR_Row($row);
next if (! %Row);
my $student_id = $row->[&Apache::loncoursedata::RD_student_id()];
$students[$tries]->{$student_id}++;
while (my ($foilid,$href) = each(%Row)) {
if (! ref($href)) {
$Trydata{$foilid}->[$tries] += $href;
next;
}
while (my ($option,$value) = each(%$href)) {
$Trydata{$foilid}->[$tries]->{$option}+=$value;
}
}
}
for (my $try=$mintries;$try<=$maxtries;$try++) {
$Trydata{'_studentcount'}->[$try] = scalar(keys(%{$students[$try]}));
}
return %Trydata;
}
#########################################################
#
# Option Response: Time Analysis
#
#########################################################
sub OR_time_analysis {
my ($performance_data,$ORdata) = @_;
my ($table,$Foils,$Concepts) = &build_foil_index($ORdata);
my $foilkey = &build_option_index($ORdata);
my $num_concepts = 1;
if (defined($Concepts)) { $num_concepts = scalar(@$Concepts); }
#
if ($num_concepts < 2) {
$table = '<h3>'.
&mt('Not enough data for concept analysis. '.
'Performing Foil Analysis').
'</h3>'.$table;
}
#
my $num_plots = $ENV{'form.NumPlots'};
my $num_data = scalar(@$performance_data)-1;
#
my $current_index;
$table .= "<table>\n";
for (my $i=0;$i<$num_plots;$i++) {
##
my $starttime = &Apache::lonhtmlcommon::get_date_from_form
('startdate_'.$i);
my $endtime = &Apache::lonhtmlcommon::get_date_from_form
('enddate_'.$i);
if (! defined($starttime) || ! defined($endtime)) {
my $sec_in_day = 86400;
my $last_sub_time = &get_time_from_row($performance_data->[-1]);
my ($sday,$smon,$syear) =
(localtime($last_sub_time - $sec_in_day*$i))[3..5];
$starttime = &Time::Local::timelocal(0,0,0,$sday,$smon,$syear);
$endtime = $starttime + $sec_in_day;
if ($i == ($num_plots -1 )) {
$starttime = &get_time_from_row($performance_data->[0]);
}
}
$table .= '<tr><td colspan="4" align="center"><font size="+1">'.
&mt('Data from [_1] to [_2]',
&Apache::lonlocal::locallocaltime($starttime),
&Apache::lonlocal::locallocaltime($endtime)).
'</font></td></tr>'.$/;
my $startdateform = &Apache::lonhtmlcommon::date_setter
('Statistics','startdate_'.$i,$starttime);
my $enddateform = &Apache::lonhtmlcommon::date_setter
('Statistics','enddate_'.$i,$endtime);
#
my $begin_index;
my $end_index;
my $j;
while (++$j < scalar(@$performance_data)) {
last if (&get_time_from_row($performance_data->[$j])
> $starttime);
}
$begin_index = $j;
while ($j < scalar(@$performance_data)) {
if (&get_time_from_row($performance_data->[$j]) > $endtime) {
last;
} else {
$j++;
}
}
$end_index = $j;
##
my ($processed_time_data,$correct,$data_count,$student_count) =
&OR_time_process_data($performance_data,$begin_index,$end_index);
##
$table .= '<tr><td colspan="4" align="center"><font size="+1">'.
&mt('[_1] submissions from [_2] students submitting, [_3] correct, [_4] incorrect',
$data_count,$student_count,$correct,$data_count-$correct).
'</font></td></tr>'.$/;
my $concept_correct_plot = '';
if ($num_concepts > 1) {
$concept_correct_plot =
&OR_Concept_Time_Analysis($processed_time_data,
$correct,$data_count,$student_count,
$ORdata,$Concepts);
}
my ($foil_correct_plot,$foil_incorrect_plot) =
&OR_Foil_Time_Analysis($processed_time_data,
$correct,$data_count,$student_count,
$ORdata,$Foils,$Concepts);
$table .= '<tr>'.
'<td>'.$concept_correct_plot.'</td>'.
'<td>'.$foil_correct_plot.'</td>'.
'<td>'.$foil_incorrect_plot.'</td>'.
'<td align="left" valign="top">'.$foilkey.'</td></tr>'.$/;
$table .= '<tr><td colspan="4" align="center">'.
&mt('Start time: [_1]',$startdateform).'<br />'.
&mt('End time: [_1]',$enddateform).'</td></tr>'.$/;
$table.= '<tr><td colspan="4"> </td></tr>'.$/;
}
$table .= '</table>';
#
return $table;
}
sub OR_Foil_Time_Analysis {
my ($processed_time_data,$correct,$data_count,$student_count,
$ORdata,$Foils,$Concepts) = @_;
if ($data_count <= 0) {
return ('<h2>'.&mt('There is no data to plot').'</h2>','');
}
my $analysis_html;
my @plotdata;
my @labels;
foreach my $concept (@{$Concepts}) {
foreach my $foil (@{$concept->{'foils'}}) {
push(@labels,scalar(@labels)+1);
my $total = $processed_time_data->{$foil}->{'_total'};
if ($total == 0) {
push(@{$plotdata[0]},0);
} else {
push(@{$plotdata[0]},
100 * $processed_time_data->{$foil}->{'_correct'} / $total);
}
my $total_incorrect = $total - $processed_time_data->{$foil}->{'_correct'};
for (my $i=0;$i<scalar(@{$ORdata->{'_Options'}});$i++) {
my $option = $ORdata->{'_Options'}->[$i];
if ($total_incorrect == 0) {
push(@{$plotdata[$i+1]},0);
} else {
push(@{$plotdata[$i+1]},
100 * $processed_time_data->{$foil}->{$option} / $total_incorrect);
}
}
}
# Put in a blank one
push(@labels,'');
push(@{$plotdata[0]},0);
for (my $i=0;$i<scalar(@{$ORdata->{'_Options'}});$i++) {
push(@{$plotdata[$i+1]},0);
}
}
#
# Create the plot
my $correct_plot = &Apache::loncommon::DrawBarGraph('Correct Statements',
'Statement Number',
'Percent Correct',
100,
$plotcolors,
undef,
$plotdata[0]);
for (my $j=0; $j< scalar(@{$plotdata[0]});$j++) {
$plotdata[0]->[$j]=0;
}
my $incorrect_plot =
&Apache::loncommon::DrawBarGraph('Incorrect Statements',
'Statement Number',
'Incorrect Option Choice',
100,
$plotcolors,
undef,
@plotdata);
return ($correct_plot,$incorrect_plot);
}
sub OR_Concept_Time_Analysis {
my ($processed_time_data,$correct,$data_count,$student_count,
$ORdata,$Concepts) = @_;
return '' if ($data_count == 0);
#
# Put the data in plottable form
my @plotdata;
foreach my $concept (@$Concepts) {
my ($total,$correct);
foreach my $foil (@{$concept->{'foils'}}) {
$total += $processed_time_data->{$foil}->{'_total'};
$correct += $processed_time_data->{$foil}->{'_correct'};
}
if ($total == 0) {
push(@plotdata,0);
} else {
push(@plotdata,100 * $correct / $total);
}
}
#
# Create the plot
return &Apache::loncommon::DrawBarGraph('Correct Concepts',
'Concept Number',
'Percent Correct',
100,
$plotcolors,
undef,
\@plotdata);
}
sub OR_time_process_data {
my ($performance_data,$begin_index,$end_index)=@_;
my %processed_time_data;
my %distinct_students;
my ($correct,$data_count);
if (($begin_index == $end_index) &&
($end_index != scalar(@$performance_data)-1)) {
return undef;
}
# Be sure we include the last one if we are asked for it.
# That we have to correct here (and not when $end_index is
# given a value) should probably be considered a bug.
if ($end_index == scalar(@$performance_data)-1) {
$end_index++;
}
&Apache::lonnet::logthis(' '.$begin_index.':'.$end_index);
my $count;
for (my $i=$begin_index;$i<$end_index;$i++) {
my $attempt = $performance_data->[$i];
$count++;
next if (! defined($attempt));
my %attempt = &Process_OR_Row($attempt);
$data_count++;
$correct += $attempt{'_correct'};
$distinct_students{$attempt->[&Apache::loncoursedata::RD_student_id()]}++;
while (my ($foilid,$href) = each(%attempt)) {
if (! ref($href)) {
$processed_time_data{$foilid} += $href;
next;
}
while (my ($option,$value) = each(%$href)) {
$processed_time_data{$foilid}->{$option}+=$value;
}
}
}
&Apache::lonnet::logthis('count = '.$count);
return (\%processed_time_data,$correct,$data_count,
scalar(keys(%distinct_students)));
}
#########################################################
#########################################################
##
## Excel output
##
#########################################################
#########################################################
sub OR_excel_sheet {
my ($r,$resource,$performance_data,$ORdata) = @_;
my $response = '';
my (undef,$Foils,$Concepts) = &build_foil_index($ORdata);
#
# Create excel worksheet
my $filename = '/prtspool/'.
$ENV{'user.name'}.'_'.$ENV{'user.domain'}.'_'.
time.'_'.rand(1000000000).'.xls';
my $workbook = Spreadsheet::WriteExcel->new('/home/httpd'.$filename);
if (! defined($workbook)) {
$r->log_error("Error creating excel spreadsheet $filename: $!");
$r->print('<p>'.&mt("Unable to create new Excel file. ".
"This error has been logged. ".
"Please alert your LON-CAPA administrator").
'</p>');
return undef;
}
#
$workbook->set_tempdir('/home/httpd/perl/tmp');
my $format = &Apache::loncommon::define_excel_formats($workbook);
#
# Create and populate main worksheets
my $problem_data_sheet = $workbook->addworksheet('Problem Data');
my $student_data_sheet = &build_student_data_worksheet($workbook,$format);
my $response_data_sheet = $workbook->addworksheet('Response Data');
foreach my $sheet ($problem_data_sheet,$student_data_sheet,
$response_data_sheet) {
$sheet->write(0,0,$resource->{'title'},$format->{'h2'});
$sheet->write(1,0,$resource->{'src'},$format->{'h3'});
}
#
my $result;
$result = &OR_build_problem_data_worksheet($problem_data_sheet,$format,
$Concepts,$ORdata);
if ($result ne 'okay') {
# Do something useful
}
$result = &OR_build_response_data_worksheet($response_data_sheet,$format,
$performance_data,$Foils,
$ORdata);
if ($result ne 'okay') {
# Do something useful
}
$response_data_sheet->activate();
#
# Close the excel file
$workbook->close();
#
# Write a link to allow them to download it
$result .= '<h2>'.&mt('Excel Raw Data Output').'</h2>'.
'<p><a href="'.$filename.'">'.
&mt('Your Excel spreadsheet.').
'</a></p>'."\n";
return $result;
}
sub OR_build_problem_data_worksheet {
my ($worksheet,$format,$Concepts,$ORdata) = @_;
my $rows_output = 3;
my $cols_output = 0;
$worksheet->write($rows_output++,0,'Problem Structure',$format->{'h3'});
##
##
my @Headers;
if (@$Concepts > 1) {
@Headers = ("Concept\nNumber",'Concept',"Foil\nNumber",
'Foil Name','Foil Text','Correct value');
} else {
@Headers = ('Foil Number','FoilName','Foil Text','Correct value');
}
$worksheet->write_row($rows_output++,0,\@Headers,$format->{'header'});
my %Foildata = %{$ORdata->{'_Foils'}};
my $conceptindex = 1;
my $foilindex = 1;
foreach my $concept (@$Concepts) {
my @FoilsInConcept = @{$concept->{'foils'}};
my $firstfoil = shift(@FoilsInConcept);
if (@$Concepts > 1) {
$worksheet->write_row($rows_output++,0,
[$conceptindex,
$concept->{'name'},
$foilindex++,
$Foildata{$firstfoil}->{'name'},
$Foildata{$firstfoil}->{'text'},
$Foildata{$firstfoil}->{'value'},]);
} else {
$worksheet->write_row($rows_output++,0,
[ $foilindex++,
$Foildata{$firstfoil}->{'name'},
$Foildata{$firstfoil}->{'text'},
$Foildata{$firstfoil}->{'value'},]);
}
foreach my $foilid (@FoilsInConcept) {
if (@$Concepts > 1) {
$worksheet->write_row($rows_output++,0,
['',
'',
$foilindex,
$Foildata{$foilid}->{'name'},
$Foildata{$foilid}->{'text'},
$Foildata{$foilid}->{'value'},]);
} else {
$worksheet->write_row($rows_output++,0,
[$foilindex,
$Foildata{$foilid}->{'name'},
$Foildata{$foilid}->{'text'},
$Foildata{$foilid}->{'value'},]);
}
} continue {
$foilindex++;
}
} continue {
$conceptindex++;
}
$rows_output++;
$rows_output++;
##
## Option data output
$worksheet->write($rows_output++,0,'Options',$format->{'header'});
foreach my $string (@{$ORdata->{'_Options'}}) {
$worksheet->write($rows_output++,0,$string);
}
return 'okay';
}
sub OR_build_response_data_worksheet {
my ($worksheet,$format,$performance_data,$Foils,$ORdata)=@_;
my $rows_output = 3;
my $cols_output = 0;
$worksheet->write($rows_output++,0,'Response Data',$format->{'h3'});
$worksheet->set_column(1,1,20);
$worksheet->set_column(2,2,13);
my @Headers = ('identifier','time','award detail','attempt');
foreach my $foil (@$Foils) {
push (@Headers,$foil.' submission');
push (@Headers,$foil.' grading');
}
$worksheet->write_row($rows_output++,0,\@Headers,$format->{'header'});
#
foreach my $row (@$performance_data) {
next if (! defined($row));
my ($student,$award,$grading,$submission,$time,$tries) = @$row;
my @Foilgrades = split('&',$grading);
my @Foilsubs = split('&',$submission);
my %response_data;
for (my $j=0;$j<=$#Foilgrades;$j++) {
my ($foilid,$correct) = split('=',$Foilgrades[$j]);
my (undef,$submission) = split('=',$Foilsubs[$j]);
$submission = &Apache::lonnet::unescape($submission);
$response_data{$foilid.' submission'}=$submission;
$response_data{$foilid.' award'}=$correct;
}
$worksheet->write($rows_output,$cols_output++,$student);
$worksheet->write($rows_output,$cols_output++,
&Apache::lonstathelpers::calc_serial($time),$format->{'date'});
$worksheet->write($rows_output,$cols_output++,$award);
$worksheet->write($rows_output,$cols_output++,$tries);
foreach my $foilid (@$Foils) {
$worksheet->write($rows_output,$cols_output++,
$response_data{$foilid.' submission'});
$worksheet->write($rows_output,$cols_output++,
$response_data{$foilid.' award'});
}
$rows_output++;
$cols_output = 0;
}
return;
}
sub build_foil_index {
my ($ORdata) = @_;
return if (! exists($ORdata->{'_Foils'}));
my %Foildata = %{$ORdata->{'_Foils'}};
my @Foils = sort(keys(%Foildata));
my %Concepts;
foreach my $foilid (@Foils) {
push(@{$Concepts{$Foildata{$foilid}->{'_Concept'}}},
$foilid);
}
undef(@Foils);
# Having gathered the concept information in a hash, we now translate it
# into an array because we need to be consistent about order.
# Also put the foils in order, too.
my $sortfunction = sub {
my %Numbers = (one => 1,
two => 2,
three => 3,
four => 4,
five => 5,
six => 6,
seven => 7,
eight => 8,
nine => 9,
ten => 10,);
my $a1 = lc($a);
my $b1 = lc($b);
if (exists($Numbers{$a1})) {
$a1 = $Numbers{$a1};
}
if (exists($Numbers{$b1})) {
$b1 = $Numbers{$b1};
}
if (($a1 =~/^\d+$/) && ($b1 =~/^\d+$/)) {
return $a1 <=> $b1;
} else {
return $a1 cmp $b1;
}
};
my @Concepts;
foreach my $concept (sort $sortfunction (keys(%Concepts))) {
if (! defined($Concepts{$concept})) {
$Concepts{$concept}=[];
# next;
}
push(@Concepts,{ name => $concept,
foils => [@{$Concepts{$concept}}]});
push(@Foils,(@{$Concepts{$concept}}));
}
#
# Build up the table of row labels.
my $table = '<table border="1" >'."\n";
if (@Concepts > 1) {
$table .= '<tr>'.
'<th>'.&mt('Concept Number').'</th>'.
'<th>'.&mt('Concept').'</th>'.
'<th>'.&mt('Foil Number').'</th>'.
'<th>'.&mt('Foil Name').'</th>'.
'<th>'.&mt('Foil Text').'</th>'.
'<th>'.&mt('Correct Value').'</th>'.
"</tr>\n";
} else {
$table .= '<tr>'.
'<th>'.&mt('Foil Number').'</th>'.
'<th>'.&mt('Foil Name').'</th>'.
'<th>'.&mt('Foil Text').'</th>'.
'<th>'.&mt('Correct Value').'</th>'.
"</tr>\n";
}
my $conceptindex = 1;
my $foilindex = 1;
foreach my $concept (@Concepts) {
my @FoilsInConcept = @{$concept->{'foils'}};
my $firstfoil = shift(@FoilsInConcept);
if (@Concepts > 1) {
$table .= '<tr>'.
'<td>'.$conceptindex.'</td>'.
'<td>'.&HTML::Entities::encode($concept->{'name'},'<>&"').'</td>'.
'<td>'.$foilindex++.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$firstfoil}->{'name'},'<>&"').'</td>'.
'<td>'.$Foildata{$firstfoil}->{'text'}.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$firstfoil}->{'value'},'<>&"').'</td>'.
"</tr>\n";
} else {
$table .= '<tr>'.
'<td>'.$foilindex++.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$firstfoil}->{'name'},'<>&"').'</td>'.
'<td>'.$Foildata{$firstfoil}->{'text'}.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$firstfoil}->{'value'},'<>&"').'</td>'.
"</tr>\n";
}
foreach my $foilid (@FoilsInConcept) {
if (@Concepts > 1) {
$table .= '<tr>'.
'<td></td>'.
'<td></td>'.
'<td>'.$foilindex.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$foilid}->{'name'},'<>&"').'</td>'.
'<td>'.$Foildata{$foilid}->{'text'}.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$foilid}->{'value'},'<>&"').'</td>'.
"</tr>\n";
} else {
$table .= '<tr>'.
'<td>'.$foilindex.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$foilid}->{'name'},'<>&"').'</td>'.
'<td>'.$Foildata{$foilid}->{'text'}.'</td>'.
'<td>'.&HTML::Entities::encode($Foildata{$foilid}->{'value'},'<>&"').'</td>'.
"</tr>\n";
}
} continue {
$foilindex++;
}
} continue {
$conceptindex++;
}
$table .= "</table>\n";
#
# Build option index with color stuff
return ($table,\@Foils,\@Concepts);
}
sub build_option_index {
my ($ORdata)= @_;
my $table = "<table>\n";
my $optionindex = 0;
my @Rows;
foreach my $option (&mt('correct option chosen'),@{$ORdata->{'_Options'}}) {
my $color = $plotcolors->[$optionindex++];
push (@Rows,
'<tr>'.
'<td bgcolor="'.$color.'">'.
'<font color="'.$color.'">'.('*'x3).'</font>'.'</td>'.
'<td>'.&HTML::Entities::encode($option,'<>&"').'</td>'.
"</tr>\n");
}
shift(@Rows); # Throw away 'correct option chosen' color
$table .= join('',reverse(@Rows));
$table .= "</table>\n";
}
sub build_foil_key {
my ($foils,$extra_data)= @_;
if (! defined($extra_data)) { $extra_data = {}; }
my $table = "<table>\n";
my $foil_index = 0;
my @rows;
foreach my $foil (&mt('correct foil chosen'),@{$foils}) {
my $color = $plotcolors->[$foil_index++];
push (@rows,
'<tr>'.
'<td bgcolor="'.$color.'" class="key">'.
'<font color="'.$color.'">'.('*'x4).'</font></td>'.
'<td>'.&HTML::Entities::encode($foil,'<>&"').
(' 'x2).$extra_data->{$foil}.'</td>'.
"</tr>\n");
}
shift(@rows); # Throw away 'correct foil chosen' color
$table .= join('',reverse(@rows));
$table .= "</table>\n";
}
#########################################################
#########################################################
##
## Generic Interface Routines
##
#########################################################
#########################################################
sub CreateInterface {
##
## Environment variable initialization
if (! exists$ENV{'form.AnalyzeOver'}) {
$ENV{'form.AnalyzeOver'} = 'tries';
}
##
## Build the menu
my $Str = '';
$Str .= &Apache::lonhtmlcommon::breadcrumbs
(undef,'Detailed Problem Analysis');
$Str .= '<table cellspacing="5">'."\n";
$Str .= '<tr>';
$Str .= '<td align="center"><b>'.&mt('Sections').'</b></td>';
$Str .= '<td align="center"><b>'.&mt('Enrollment Status').'</b></td>';
# $Str .= '<td align="center"><b>'.&mt('Sequences and Folders').'</b></td>';
$Str .= '<td align="center"> </td>';
$Str .= '</tr>'."\n";
##
##
$Str .= '<tr><td align="center">'."\n";
$Str .= &Apache::lonstatistics::SectionSelect('Section','multiple',5);
$Str .= '</td>';
#
$Str .= '<td align="center">';
$Str .= &Apache::lonhtmlcommon::StatusOptions(undef,undef,5);
$Str .= '</td>';
#
# $Str .= '<td align="center">';
my $only_seq_with_assessments = sub {
my $s=shift;
if ($s->{'num_assess'} < 1) {
return 0;
} else {
return 1;
}
};
&Apache::lonstatistics::MapSelect('Maps','multiple,all',5,
$only_seq_with_assessments);
##
##
$Str .= '<td>';
##
my $showprob_checkbox =
'<input type="checkbox" name="show_prob" value="true" ';
if ($ENV{'form.show_prob'} eq 'true') {
$showprob_checkbox .= 'checked ';
}
$showprob_checkbox.= ' />';
$Str.= '<nobr><label>'.
&mt('Show problem [_1]',$showprob_checkbox).
'</label></nobr><br />';
##
my $analyze_selector = '<select name="AnalyzeOver" >';
$analyze_selector .= '<option value="tries" ';
if (! exists($ENV{'form.AnalyzeOver'}) ||
$ENV{'form.AnalyzeOver'} eq 'tries'){
# Default to tries
$analyze_selector .= ' selected ';
}
$analyze_selector .= '>'.&mt('Tries').'</option>';
$analyze_selector .= '<option value="time" ';
$analyze_selector .= ' selected ' if ($ENV{'form.AnalyzeOver'} eq 'time');
$analyze_selector .= '>'.&mt('Time').'</option>';
$analyze_selector .= '</select>';
$Str .= '<nobr><label>'.
&mt('Analyze Over [_1] [_2]',
$analyze_selector,
&Apache::loncommon::help_open_topic('Analysis_Analyze_Over')).
'</label></nobr><br />'.$/;
##
my $numplots_selector = '<select name="NumPlots">';
if (! exists($ENV{'form.NumPlots'})
|| $ENV{'form.NumPlots'} < 1
|| $ENV{'form.NumPlots'} > 20) {
$ENV{'form.NumPlots'} = 5;
}
foreach my $i (1,2,3,4,5,6,7,8,10,15,20) {
$numplots_selector .= '<option value="'.$i.'" ';
if ($ENV{'form.NumPlots'} == $i) { $numplots_selector.=' selected '; }
$numplots_selector .= '>'.$i.'</option>';
}
$numplots_selector .= '</select></nobr><br />';
$Str .= '<nobr><label>'.&mt('Number of Plots [_1]',$numplots_selector).
'</label></nobr>';
##
$Str .= '<nobr><label>'.&mt('Status: [_1]',
'<input type="text" '.
'name="stats_status" size="60" value="" />'
).
'</label></nobr>';
$Str .= '</td>';
##
##
$Str .= '</tr>'."\n";
$Str .= '</table>'."\n";
return $Str;
}
#########################################################
#########################################################
##
## Misc Option Response functions
##
#########################################################
#########################################################
sub get_time_from_row {
my ($row) = @_;
if (ref($row)) {
return $row->[&Apache::loncoursedata::RD_timestamp()];
}
return undef;
}
sub get_tries_from_row {
my ($row) = @_;
if (ref($row)) {
return $row->[&Apache::loncoursedata::RD_tries()];
}
return undef;
}
sub hashify_attempt {
my ($row) = @_;
my %attempt;
$attempt{'student'} = $row->[&Apache::loncoursedata::RD_sname()];
$attempt{'tries'} = $row->[&Apache::loncoursedata::RD_tries()];
$attempt{'submission'} = &Apache::lonnet::unescape($row->[&Apache::loncoursedata::RD_submission()]);
$attempt{'award'} = $row->[&Apache::loncoursedata::RD_awarddetail()];
$attempt{'timestamp'} = $row->[&Apache::loncoursedata::RD_timestamp()];
return %attempt;
}
sub Process_OR_Row {
my ($row) = @_;
my %RowData;
# my $student_id = $row->[&Apache::loncoursedata::RD_student_id()];
my $award = $row->[&Apache::loncoursedata::RD_awarddetail()];
my $grading = $row->[&Apache::loncoursedata::RD_response_eval()];
my $submission = $row->[&Apache::loncoursedata::RD_submission()];
my $time = $row->[&Apache::loncoursedata::RD_timestamp()];
# my $tries = $row->[&Apache::loncoursedata::RD_tries()];
return undef if ($award eq 'MISSING_ANSWER');
if ($award =~ /(APPROX_ANS|EXACT_ANS)/) {
$RowData{'_correct'} = 1;
}
$RowData{'_total'} = 1;
my @Foilgrades = split('&',$grading);
my @Foilsubs = split('&',$submission);
for (my $j=0;$j<=$#Foilgrades;$j++) {
my ($foilid,$correct) = split('=',$Foilgrades[$j]);
$foilid = &Apache::lonnet::unescape($foilid);
my (undef,$submission) = split('=',$Foilsubs[$j]);
if ($correct) {
$RowData{$foilid}->{'_correct'}++;
} else {
$submission = &Apache::lonnet::unescape($submission);
$RowData{$foilid}->{$submission}++;
}
$RowData{$foilid}->{'_total'}++;
}
return %RowData;
}
1;
__END__
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/back.gif){kind=icon}
Return to lonproblemanalysis.pm CVS log ![[TXT]](/icons/text.gif){kind=icon}
![[DIR]](/icons/dir.gif){kind=icon}
Up to [LON-CAPA] / loncom / interface / statistics