# The LearningOnline Network with CAPA
#
# $Id: lonproblemanalysis.pm,v 1.103 2004/11/10 16:56:39 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('
There are no students in the sections selected
');
}
#
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(" \n");
} else {
$r->print('{'text'}).'" />');
$r->print(' 'x5);
}
}
foreach my $html (@CacheButtonHTML) {
$r->print($html.(' 'x5));
}
#
$r->print('');
$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('');
#
if (! defined($current_problem->{'resource'})) {
$r->print('resource is undefined');
} else {
my $resource = $current_problem->{'resource'};
$r->print('
';
$r->print($analysis_html);
}
#
return;
}
sub numerical_plot_percent {
my ($r,$responses) = @_;
#
my $total = $responses->{'_count'};
return '' if ($total == 0);
my $minbin = 0.5;
while (my ($interval,$submissions) = each(%$responses)) {
next if ($interval =~ /^_/);
my ($ans,$ans_low,$ans_high) = split(" ",$interval);
my $low_percent = abs(($ans-$ans_low)/$ans);
my $high_percent = abs(($ans_high-$ans)/$ans);
if ($minbin > $high_percent) { $minbin = $high_percent; }
if ($minbin > $low_percent) { $minbin = $low_percent; }
}
#
my @bins;
if ($minbin < 1) {
@bins = (0.1, ".5",1,1.5,2,2.5,3,4,5,10,20,50,100);
} elsif ($minbin < 2) {
@bins = (0.5,1,1.5,2,2.5,3,4,5,10,20,50,100);
} elsif ($minbin < 5) {
@bins = (1,2,3,4,5,10,25,50,75,100,200);
} elsif ($minbin < 10) {
@bins = (2,4,6,8,10,12,15,20,25,30,50,75,100,200);
} else {
@bins = (5,10,15,20,25,30,50,75,100,200);
}
my @labels = (1..scalar(@bins));
#
my @correct;
my @incorrect;
while (my ($interval,$submissions) = each(%$responses)) {
next if ($interval =~ /^_/);
my ($ans,$ans_low,$ans_high) = split(" ",$interval);
while (my ($submission,$count) = each(%$submissions)) {
my $scaled_value = abs(($submission-$ans)/$ans);
my $bin=0;
for ($bin=0;$bin<$#bins;$bin++) { # not <= for a reason
last if ($bins[$bin]>$scaled_value);
}
if (($submission <= $ans_high) && ($submission >= $ans_low)) {
$correct[$bin]+=$count;
} else {
$incorrect[$bin]+=$count;
}
}
}
#
for (my $i=0;$i<=$#bins;$i++) {
if (! defined( $correct[$i])) { $correct[$i]=0;}
if (! defined($incorrect[$i])) { $incorrect[$i]=0;}
$correct[$i]*=100/$total;
$incorrect[$i]*=100/$total;
}
my $title = &mt('Distribution by Percent');
my $graph = &Apache::loncommon::DrawBarGraph
($title,'Percent difference from correct','Number of answers',
100,['#33FF00','#FF3300'],\@labels,\@correct,\@incorrect,
{xskip=>1});
#
my $table = $graph.'
'.&mt('Bar').'
'.
'
'.&mt('Range').'
';
for (my $i=0;$i<=$#bins;$i++) {
my $lownum;
if ($i == 0) {
$lownum = 0;
} else {
$lownum = $bins[$i-1];
}
my $highnum = $bins[$i];
$table .=
'
'.
'
'.$labels[$i].'
'.
'
'.$lownum.'
'.
'
-
'.
'
'.$highnum.'
'.'
'.$/;
}
$table.= '
'.$/;
return $table;
}
sub numerical_plot_differences {
my ($r,$responses) = @_;
#
my $total = $responses->{'_count'};
return '' if ($total == 0);
my $minbin = undef;
my $maxbin = undef;
while (my ($interval,$submissions) = each(%$responses)) {
next if ($interval =~ /^_/);
my ($ans,$ans_low,$ans_high) = split(" ",$interval);
my $low_diff = abs($ans-$ans_low);
my $high_diff = abs($ans_high-$ans);
if (! defined($maxbin)) { $maxbin = $low_diff;}
if (! defined($minbin)) { $minbin = $low_diff;}
#
if ($minbin > $high_diff) { $minbin = $high_diff; }
if ($minbin > $low_diff ) { $minbin = $low_diff; }
#
if ($maxbin < $high_diff) { $maxbin = $high_diff; }
if ($maxbin < $low_diff ) { $maxbin = $low_diff; }
}
#
my @bins;
my @labels;
# Hmmmm, should switch to absolute difference
for (my $i=1;$i<=20;$i++) {
push(@bins,$i*$minbin/2);
push(@labels,$i);
}
#
my @correct;
my @incorrect;
while (my ($interval,$submissions) = each(%$responses)) {
next if ($interval =~ /^_/);
my ($ans,$ans_low,$ans_high) = split(" ",$interval);
while (my ($submission,$count) = each(%$submissions)) {
my $value = abs($submission-$ans);
my $bin=0;
for ($bin=0;$bin<$#bins;$bin++) { # not <= for a reason
last if ($bins[$bin]>$value);
}
if (($submission <= $ans_high) && ($submission >= $ans_low)) {
$correct[$bin]+=$count;
} else {
$incorrect[$bin]+=$count;
}
}
}
#
for (my $i=0;$i<=$#bins;$i++) {
if (! defined( $correct[$i])) { $correct[$i]=0;}
if (! defined($incorrect[$i])) { $incorrect[$i]=0;}
$correct[$i]*=100/$total;
$incorrect[$i]*=100/$total;
}
my $title = &mt('Distribution by Magnitude');
my $graph = &Apache::loncommon::DrawBarGraph
($title,'magnitude difference from correct','Number of answers',
100,['#33FF00','#FF3300'],\@labels,\@correct,\@incorrect,{xskip=>1});
#
my $table = $graph.'
'.&mt('Bar').'
'.
'
'.&mt('Range').'
';
for (my $i=0;$i<=$#bins;$i++) {
my $lownum;
if ($i == 0) {
$lownum = 0;
} else {
$lownum = $bins[$i-1];
}
my $highnum = $bins[$i];
$table .=
'
'.
'
'.$labels[$i].'
'.
'
'.$lownum.'
'.
'
-
'.
'
'.$highnum.'
'.'
'.$/;
}
$table.= '
'.$/;
return $table;
}
sub numerical_response_determine_intervals {
my ($r,$resource,$partid,$respid,$students)=@_;
my $c = $r->connection();
#
# FIX ME: Need progress dialog updates
#
# Read in the cache (if it exists) before we start timing things.
&Apache::lonstathelpers::ensure_proper_cache($resource->{'symb'});
#
my $correct;
# %intervals differs from %answers because it may be possible for two
# students to have the same correct answer but different intervals.
my %intervals;
my %answers;
foreach my $student (@$students) {
last if ($c->aborted());
my $sname = $student->{'username'};
my $sdom = $student->{'domain'};
# analyze problem
my $analysis =
&Apache::lonstathelpers::analyze_problem_as_student($resource,
$sname,
$sdom);
# make the key
my $key = $partid.'.'.$respid;
my $interval = join(' ',($analysis->{$key.'.answer'}->[0],
$analysis->{$key.'.ans_low'}->[0],
$analysis->{$key.'.ans_high'}->[0]));
$correct->{$sname.':'.$sdom} = $interval;
$intervals{$interval}++;
$answers{$analysis->{$key.'.answer'}->[0]}++;
}
&Apache::lonstathelpers::write_analysis_cache();
return ($correct,\%intervals,\%answers);
}
sub numerical_one_dimensional_plot {
my ($r,$width,$height,$n,$data)=@_;
#
# Compute data -> image scaling factors
my $max_y = 0;
my $min_x = undef;
my $max_x = undef;
while (my ($answer,$count) = each(%$data)) {
$max_y = $count if ($max_y < $count);
if (! defined($min_x) || $answer < $min_x) {
$min_x = $answer;
}
if (! defined($max_x) || $answer > $max_x) {
$max_x = $answer;
}
}
#
my $h_scale = ($width-10)/($max_x-$min_x);
#
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{};
while (my ($answer,$count) = each(%$data)) {
my $xloc = 5+$h_scale*($answer - $min_x);
my $top = $height/2-$count*$ticscale;
my $bottom = $height/2+$count*$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_x < 0 && $max_x > 0) {
my $circle_x = 5+$h_scale*abs($min_x); # '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 .= '';
my $plotresult = &Apache::lonxml::xmlparse($r,'web',$plot);
my $result = '
'.
'
'.
''.&mt('Distribution of correct answers').''.
' '.&mt('[_1] students, [_2] distinct correct answers',
$n,scalar(keys(%$data))).
' '.&mt('Maximum number of coinciding values: [_1]',$max_y).
'
'.
'
'.
'
'.$min_x.'
'.
'
'.$plotresult.'
'.
'
'.$max_x.'
'.
'
'.
'
';
return $result;
}
##
## Helper subroutines for .
## These should probably go somewhere more suitable soon.
sub line {
my ($x1,$y1,$x2,$y2,$color,$thickness) = @_;
return qq{};
}
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};
}
sub rectangle {
my ($x1,$y1,$x2,$y2,$color,$thickness,$filled) = @_;
return qq{};
}
sub arc {
my ($x,$y,$width,$height,$start,$end,$color,$thickness,$filled)=@_;
return qq{};
}
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 radio_response_analysis {
my ($r,$problem,$problem_analysis,$students) = @_;
#
if ($ENV{'form.AnalyzeOver'} !~ /^(tries|time)$/) {
$r->print('Bad request');
}
#
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);
#
my %true_foils;
my $num_true = 0;
if (! $problem_analysis->{'answercomputed'}) {
foreach my $foil (@$foils) {
if ($foildata->{$foil}->{'value'} eq 'true') {
$true_foils{$foil}++;
}
}
$num_true = scalar(keys(%true_foils));
}
#
$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'};
}
}
}
#
if (! defined($response_data) || ref($response_data) ne 'ARRAY' ) {
$analysis_html = '
'.
&mt('There is no submission data for this resource').
'
'.$/;
}
} # end of loop for plots
$analysis_html.='
';
$r->print($analysis_html);
}
sub ensure_start_end_times {
my ($start,$end,$first,$last,$plot_num) = @_;
if (! defined($start) || ! defined($end)) {
my $sec_in_day = 86400;
my ($sday,$smon,$syear) =
(localtime($last - $sec_in_day*($plot_num-1)))[3..5];
$start = &Time::Local::timelocal(0,0,0,$sday,$smon,$syear);
$end = $start + $sec_in_day;
if ($plot_num == $ENV{'form.NumPlots'}) {
$start = $first;
}
}
return ($start,$end);
}
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[$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';
my $plot= &Apache::loncommon::DrawBarGraph($title,
$xlabel,
'Percent Choosing',
100,
['#33ff00','#ff3300'],
undef,
\@correct);
return $plot;
}
sub RR_create_percent_selected_plot {
my ($concepts,$foils,$foil_data,$title) = @_;
#
if ($foil_data->{'_count'} == 0) { return ''; };
my %correct_selections;
my %incorrect_selections;
foreach my $foil (@$foils) {
# foil_data has format $foil_data->{true_foil}->{selected foil}=count
next if (! exists($foil_data->{$foil}));
while (my ($f,$count)= each(%{$foil_data->{$foil}})) {
if ($f eq $foil) {
$correct_selections{$foil} += $count;
} else {
$incorrect_selections{$f} += $count;
}
}
}
#
# need arrays for incorrect and correct because we want to use different
# colors for them
my @correct;
my @incorrect;
#
my $total = $foil_data->{'_count'};
for (my $i=0;$i[$i];
$correct[$i] = $correct_selections{$foil};
$incorrect[$i] = $incorrect_selections{$foil};
}
for (my $i=0;$i<=$#correct;$i++) {
$correct[$i] = sprintf('%2f',$correct[$i]/$total*100);
}
for (my $i=0;$i<=$#incorrect;$i++) {
$incorrect[$i] = sprintf('%2f',$incorrect[$i]/$total*100);
}
#
# Put a blank in the data sets between concepts, if there are concepts
my @labels;
if (defined($concepts) && scalar(@$concepts) > 1) {
my @new_correct;
my @new_incorrect;
my $foil_count = 0;
foreach my $concept (@$concepts) {
foreach (@{$concept->{'foils'}}) {
push(@new_correct, $correct[$foil_count]);
push(@new_incorrect,$incorrect[$foil_count]);
push(@labels,++$foil_count);
}
push(@new_correct,'');
push(@new_incorrect,'');
push(@labels,'');
}
@correct = @new_correct;
@incorrect = @new_incorrect;
} else {
@labels = (1 .. scalar(@correct));
}
#
my $xlabel = 'foil chosen';
my $plot= &Apache::loncommon::DrawBarGraph($title,
$xlabel,
'Percent Choosing',
100,
['#33ff00','#ff3300'],
\@labels,
\@correct,
\@incorrect);
return $plot;
}
sub RR_create_stacked_selection_plot {
my ($foils,$foil_data,$title,$true_foils)=@_;
#
my @dataset; # array of array refs - multicolor rows $datasets[row]->[col]
my @labels;
my $count;
my %column; # maps foil name to column in @datasets
for (my $i=0;$i[$i];
if (defined($true_foils) && scalar(keys(%$true_foils)) > 0 ) {
next if (! $true_foils->{$foil} );
push(@labels,$i+1);
} else {
next if (! exists($foil_data->{$foil}));
push(@labels,$i+1);
}
next if (! exists($foil_data->{$foils->[$i]}));
$column{$foil}= $count++;
for (my $j=0;$j{$foil}->{$foils->[$j]};
}
$dataset[$j]->[$column{$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[$bar];
}
next if ($bar_total == 0);
for (my $j=0;$j[$bar] =
sprintf('%2f',$dataset[$j]->[$bar]/$bar_total * 100);
}
$count_per_foil{$foil}=' ( '.$bar_total.' )';
$grand_total += $bar_total;
}
if ($grand_total == 0) {
return ('',undef);
}
my @empty_row = ();
foreach (@{$dataset[0]}) {
push(@empty_row,0);
}
#
my $graph = &Apache::loncommon::DrawBarGraph
($title,'Correct Foil','foils chosen Incorrectly',
100,$plotcolors,\@labels,\@empty_row,@dataset);
return ($graph,\%count_per_foil);
}
#########################################################
#########################################################
##
## Misc routines
##
#########################################################
#########################################################
# 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 classify_response_data {
my ($full_row_data,$correct,$function) = @_;
my %submission_data;
my %students;
my $max=0;
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)) {
$students{$subm{'student'}}++;
$submission_data{'_count'}++;
if (&submission_is_correct($subm{'award'})) {
$submission_data{'_correct'}++;
}
if($max<++$submission_data{$subm{'correct'}}->{$subm{'submission'}}) {
$max=$submission_data{$subm{'correct'}}->{$subm{'submission'}};
}
}
}
$submission_data{'_max'} = $max;
$submission_data{'_students'}=scalar(keys(%students));
return \%submission_data;
}
#########################################################
#########################################################
##
## 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('
'.
&mt('There is no student data for this problem.').
'
');
} 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('
'.
&mt('The analysis you have selected is '.
'not supported at this time').
'
');
}
}
}
}
#########################################################
#
# 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 = "
\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.= '
'.
&mt('None of the selected students attempted the problem more than [_1] times.',$try-1).
'
';
} else {
$analysis_html.= '
'.
&mt('None of the selected students have attempted the problem').'
';
}
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.=
'
';
#
return $table;
}
sub OR_Foil_Time_Analysis {
my ($processed_time_data,$correct,$data_count,$student_count,
$ORdata,$Foils,$Concepts) = @_;
if ($data_count <= 0) {
return ('
'.&mt('There is no data to plot').'
','');
}
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{'_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{'_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++;
}
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;
}
}
}
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('
'.&mt("Unable to create new Excel file. ".
"This error has been logged. ".
"Please alert your LON-CAPA administrator").
'
');
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 .= '