CVS log for loncom/interface/spreadsheet/studentcalc.pm
Up to [LON-CAPA] / loncom / interface / spreadsheet
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Current tag: MAIN
Revision 1.47: download - view: text, markup, annotated - select for diffs
Sun Dec 31 15:27:03 2017 UTC (6 years, 7 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_12_X,
HEAD
Diff to previous 1.46: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.46: +3 -3
lines
- Bug 6754 LON-CAPA as LTI Consumer
- Spreadsheet includes external tools set to be "gradable".
Revision 1.46: download - view: text, markup, annotated - select for diffs
Wed Feb 12 16:55:36 2014 UTC (10 years, 6 months ago) by bisitz
Branches: MAIN
CVS tags: version_2_11_X,
version_2_11_5_msu,
version_2_11_5,
version_2_11_4_uiuc,
version_2_11_4_msu,
version_2_11_4,
version_2_11_3_uiuc,
version_2_11_3_msu,
version_2_11_3,
version_2_11_2_uiuc,
version_2_11_2_msu,
version_2_11_2_educog,
version_2_11_2,
version_2_11_1,
version_2_11_0_RC3,
version_2_11_0
Diff to previous 1.45: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.45: +2 -2
lines
Internationalization: Added missing &mt() call
Revision 1.45: download - view: text, markup, annotated - select for diffs
Mon Jun 14 01:30:54 2010 UTC (14 years, 2 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_9_X,
version_2_9_1,
version_2_11_0_RC2,
version_2_11_0_RC1,
version_2_10_X,
version_2_10_1,
version_2_10_0_RC2,
version_2_10_0_RC1,
version_2_10_0,
loncapaMITrelate_1,
language_hyphenation_merge,
language_hyphenation,
BZ4492-merge,
BZ4492-feature_horizontal_radioresponse
Diff to previous 1.44: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.44: +10 -6
lines
- Top level sequence was being included twice.
Revision 1.44: download - view: text, markup, annotated - select for diffs
Tue Jun 9 14:15:42 2009 UTC (15 years, 2 months ago) by bisitz
Branches: MAIN
CVS tags: version_2_9_99_0,
version_2_9_0,
version_2_8_99_1,
version_2_8_99_0,
bz6209-base,
bz6209,
bz5969,
bz2851,
PRINT_INCOMPLETE_base,
PRINT_INCOMPLETE,
GCI_3,
GCI_2,
BZ5971-printing-apage
Diff to previous 1.43: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.43: +4 -4
lines
- Localization: Added &mt call
- Replaced hardcoded font color by appropriate warning style
Revision 1.43: download - view: text, markup, annotated - select for diffs
Fri Jul 6 19:50:00 2007 UTC (17 years, 1 month ago) by albertel
Branches: MAIN
CVS tags: version_2_8_X,
version_2_8_2,
version_2_8_1,
version_2_8_0,
version_2_7_X,
version_2_7_99_1,
version_2_7_99_0,
version_2_7_1,
version_2_7_0,
version_2_6_X,
version_2_6_99_1,
version_2_6_99_0,
version_2_6_3,
version_2_6_2,
version_2_6_1,
version_2_6_0,
version_2_5_X,
version_2_5_99_1,
version_2_5_99_0,
version_2_5_2,
version_2_5_1,
version_2_5_0,
version_2_4_99_0,
GCI_1,
BZ5434-fox
Diff to previous 1.42: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.42: +3 -4
lines
- BUG#5306, turn off navmaps folder eliding for SPRS
Revision 1.42: download - view: text, markup, annotated - select for diffs
Thu Dec 21 02:54:19 2006 UTC (17 years, 8 months ago) by albertel
Branches: MAIN
CVS tags: version_2_4_X,
version_2_4_2,
version_2_4_1,
version_2_4_0,
version_2_3_X,
version_2_3_99_0,
version_2_3_2,
version_2_3_1,
version_2_3_0,
version_2_2_99_1
Diff to previous 1.41: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.41: +2 -2
lines
- notice and announce when errors occur trying to calculate spreadsheets
Revision 1.41: download - view: text, markup, annotated - select for diffs
Mon Oct 2 17:04:33 2006 UTC (17 years, 10 months ago) by raeburn
Branches: MAIN
CVS tags: version_2_2_X,
version_2_2_99_0,
version_2_2_2
Diff to previous 1.40: preferred, unified
Changes since revision 1.40: +3 -1
lines
Bug 4296. Values entered in cells in student sheet were not being stored in tmp file.
Revision 1.39: download - view: text, markup, annotated - select for diffs
Mon May 1 06:17:16 2006 UTC (18 years, 3 months ago) by raeburn
Branches: MAIN
Diff to previous 1.38: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.38: +2 -2
lines
Determination of parameters for spreadsheet now correctly cascades for cases where a user has multiple active groups. Also groups are passed in argument list for Spreadsheet object as array reference. Lastly lonnet::get_users_groups function modified to only return user's active groups, except in case when user status has expired (and default end access date for students has also passed), in which case user's groups which were still active less than 24 hours before default end date are also included in user's groups. [For consistency with students groups returned by loncoursedata::get_students_groups()].
Revision 1.38: download - view: text, markup, annotated - select for diffs
Thu Apr 6 20:24:13 2006 UTC (18 years, 4 months ago) by raeburn
Branches: MAIN
Diff to previous 1.37: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.37: +3 -2
lines
Making group-based parameters apply in spreadsheet, using same cascading precedence scheme as used for parmset.
Revision 1.37: download - view: text, markup, annotated - select for diffs
Thu Apr 6 16:43:49 2006 UTC (18 years, 4 months ago) by albertel
Branches: MAIN
Diff to previous 1.36: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.36: +3 -2
lines
- #self->{'section'} never got set
Revision 1.36: download - view: text, markup, annotated - select for diffs
Sun Mar 26 22:48:34 2006 UTC (18 years, 5 months ago) by bowersj2
Branches: MAIN
Diff to previous 1.35: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.35: +45 -9
lines
Fix bug 3622, ability to change assessment spreadsheet for entire
sequence at once.
Revision 1.35: download - view: text, markup, annotated - select for diffs
Fri Aug 26 20:46:46 2005 UTC (18 years, 11 months ago) by albertel
Branches: MAIN
CVS tags: version_2_1_X,
version_2_1_3,
version_2_1_2,
version_2_1_1,
version_2_1_0,
version_2_0_X,
version_2_0_99_1,
version_2_0_2,
version_2_0_1
Diff to previous 1.34: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.34: +3 -1
lines
- fixes bug #4296 spreadsheet can't be edited
Revision 1.34: download - view: text, markup, annotated - select for diffs
Fri Aug 5 20:06:22 2005 UTC (19 years ago) by albertel
Branches: MAIN
CVS tags: version_2_0_0,
version_1_99_3
Diff to previous 1.33: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.33: +2 -2
lines
- BUG# 4248, SUMSEQ wsn't fetching titles correctly
Revision 1.33: download - view: text, markup, annotated - select for diffs
Tue May 17 17:48:19 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
CVS tags: version_1_99_2,
version_1_99_1_tmcc,
version_1_99_1,
version_1_99_0
Diff to previous 1.32: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.32: +2 -1
lines
- need to undef $navmap so that the hashes are untied
Revision 1.32: download - view: text, markup, annotated - select for diffs
Sun May 15 03:06:59 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.31: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.31: +1 -6
lines
- remving superflouous connection abort checks
Revision 1.31: download - view: text, markup, annotated - select for diffs
Fri May 13 20:30:14 2005 UTC (19 years, 3 months ago) by albertel
Branches: MAIN
Diff to previous 1.30: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.30: +8 -1
lines
- shave another 0.5 seconds per student
Revision 1.30: download - view: text, markup, annotated - select for diffs
Thu Apr 7 06:56:23 2005 UTC (19 years, 4 months ago) by albertel
Branches: MAIN
CVS tags: version_1_99_0_tmcc
Diff to previous 1.29: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.29: +15 -15
lines
- ENV -> env
Revision 1.29: download - view: text, markup, annotated - select for diffs
Thu Mar 10 17:33:57 2005 UTC (19 years, 5 months ago) by matthew
Branches: MAIN
Diff to previous 1.28: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.28: +3 -3
lines
Updated to use loncommon::create_workbook. Spreadsheets were slightly
modified to use formats.
Revision 1.28: download - view: text, markup, annotated - select for diffs
Thu Mar 3 17:52:36 2005 UTC (19 years, 5 months ago) by matthew
Branches: MAIN
Diff to previous 1.27: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.27: +52 -44
lines
Changed to use navmaps.
Revision 1.27: download - view: text, markup, annotated - select for diffs
Wed Dec 8 00:56:00 2004 UTC (19 years, 8 months ago) by albertel
Branches: MAIN
CVS tags: version_1_3_X,
version_1_3_3,
version_1_3_2,
version_1_3_1,
version_1_3_0,
version_1_2_99_1
Diff to previous 1.26: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.26: +4 -13
lines
- BUG #2207, the SUBM,PGRD,PPRM links on the SPRS now go to the correct place.
Revision 1.26: download - view: text, markup, annotated - select for diffs
Tue Nov 2 20:48:02 2004 UTC (19 years, 9 months ago) by albertel
Branches: MAIN
CVS tags: version_1_2_99_0
Diff to previous 1.25: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.25: +3 -7
lines
consolidate some of the multitude of functions out there that try to format and display the student's 'fullname'
Revision 1.25: download - view: text, markup, annotated - select for diffs
Mon Dec 8 19:58:39 2003 UTC (20 years, 8 months ago) by matthew
Branches: MAIN
CVS tags: version_1_2_X,
version_1_2_1,
version_1_2_0,
version_1_1_X,
version_1_1_99_5,
version_1_1_99_4,
version_1_1_99_3,
version_1_1_99_2,
version_1_1_99_1,
version_1_1_99_0,
version_1_1_3,
version_1_1_2,
version_1_1_1,
version_1_1_0,
version_1_0_99_3,
version_1_0_99_2,
version_1_0_99_1
Diff to previous 1.24: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.24: +3 -3
lines
Fix parameters passed in to excel_rows and csv_rows. Should go in 1.1
Revision 1.24: download - view: text, markup, annotated - select for diffs
Mon Nov 17 19:55:41 2003 UTC (20 years, 9 months ago) by matthew
Branches: MAIN
CVS tags: version_1_0_99
Diff to previous 1.23: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.23: +35 -11
lines
Fix bug in error reporting where errors in computation of the spreadsheet
were not reported and bad cache values were stored away.
Added in Spreadsheet: &set_badcalc, &badcalc, &set_calcerror, &calcerror,
and &html_report_error. These are used to keep track of computation errors
and to report them to the user. The &save_export_data routines were all
modified to not store data when an error has occured.
Revision 1.23: download - view: text, markup, annotated - select for diffs
Tue Oct 14 18:36:54 2003 UTC (20 years, 10 months ago) by www
Branches: MAIN
Diff to previous 1.22: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.22: +22 -14
lines
Internationalize/localize
Revision 1.22: download - view: text, markup, annotated - select for diffs
Thu Sep 18 20:12:40 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.21: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.21: +84 -15
lines
Added &SUMSEQ(), a new function available in the student level spreadsheet
to sum over sequences.
Revision 1.21: download - view: text, markup, annotated - select for diffs
Tue Sep 16 15:39:36 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.20: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.20: +2 -6
lines
Cleanup of parent_link subroutine - there is no need to include the
students name and domain when requesting the course level spreadsheet.
Revision 1.20: download - view: text, markup, annotated - select for diffs
Fri Sep 12 19:00:54 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.19: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.19: +3 -1
lines
Cache student performance data (only make 1 call to get_current_state)
Cache export rows and write them only when asked to or when the computations
are done.
Revision 1.19: download - view: text, markup, annotated - select for diffs
Mon Sep 8 18:25:26 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.18: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.18: +2 -2
lines
Trivial html cleanup.
Revision 1.18: download - view: text, markup, annotated - select for diffs
Fri Sep 5 01:57:54 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.17: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.17: +13 -3
lines
Clear package variables on both normal completion and on interruption.
Revision 1.17: download - view: text, markup, annotated - select for diffs
Fri Sep 5 01:06:45 2003 UTC (20 years, 11 months ago) by matthew
Branches: MAIN
Diff to previous 1.16: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.16: +9 -6
lines
Minor modifications brought about due to making warnings fatal.
Revision 1.16: download - view: text, markup, annotated - select for diffs
Fri Aug 1 13:33:41 2003 UTC (21 years ago) by matthew
Branches: MAIN
CVS tags: version_1_0_3,
version_1_0_1,
version_1_0_0,
version_0_99_5,
version_0_99_4
Branch point for: version_1_0_2
Diff to previous 1.15: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.15: +5 -3
lines
Extra paranoia about decision to compute spreadsheet. Removed some
excess logging. Please put in 1.0.
Revision 1.15: download - view: text, markup, annotated - select for diffs
Wed Jul 16 20:30:36 2003 UTC (21 years, 1 month ago) by matthew
Branches: MAIN
Diff to previous 1.14: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.14: +3 -1
lines
Added paranoia about when to recalculate the student level sheet.
Revision 1.14: download - view: text, markup, annotated - select for diffs
Wed Jul 16 15:57:32 2003 UTC (21 years, 1 month ago) by matthew
Branches: MAIN
Diff to previous 1.13: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.13: +21 -2
lines
Bug 1584: pgrd button for each resource in the student level sheet.
Revision 1.13: download - view: text, markup, annotated - select for diffs
Mon Jun 23 20:47:00 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_3
Diff to previous 1.12: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.12: +2 -2
lines
Paler yellow.
Revision 1.12: download - view: text, markup, annotated - select for diffs
Mon Jun 23 19:58:18 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.11: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.11: +10 -6
lines
Bug 1729 - color hints on export/import rows. The color of the export
row of the assessment sheet is the same as the import row of the
student sheet. The export row of the student sheet is the same color
as the import rows of the course level sheet.
Revision 1.11: download - view: text, markup, annotated - select for diffs
Thu Jun 12 21:17:11 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_2
Diff to previous 1.10: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.10: +2 -1
lines
Handle course data caching properly.
Revision 1.10: download - view: text, markup, annotated - select for diffs
Thu May 29 18:39:58 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_1,
conference_2003
Diff to previous 1.9: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.9: +2 -2
lines
Trivial change to header row of excel spreadsheet export to make it match
the values used by chart.
Revision 1.9: download - view: text, markup, annotated - select for diffs
Thu May 29 18:31:27 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.8: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.8: +16 -13
lines
Fixes bugs 1513 and 1516. Every time a new row is added to a spreadsheet
the spreadsheet will be saved.
&set_row_numbers now actually keeps track of the maximum row found, which
can be useful if you need to add a new row...
Also fixed bug in caching of spreadsheets - was storing the 'join'd version
of the formulas when I expected a hash reference.
Revision 1.8: download - view: text, markup, annotated - select for diffs
Thu May 29 13:39:38 2003 UTC (21 years, 2 months ago) by matthew
Branches: MAIN
Diff to previous 1.7: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.7: +13 -1
lines
Added $spreadsheet->initialize() subroutine to take care of specific
initialization needed for each sheet. assesscalc now has a list of
mandatory parameters (Bug 1514) but is running in to problems with
bug 1513.
Revision 1.7: download - view: text, markup, annotated - select for diffs
Fri May 23 21:03:29 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
CVS tags: version_0_99_0
Diff to previous 1.6: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.6: +24 -4
lines
CSV output implemented.
Revision 1.6: download - view: text, markup, annotated - select for diffs
Fri May 23 19:36:04 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.5: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.5: +49 -18
lines
Added output selector and implemented excel output.
Moved $spreadsheet->display() to Spreadsheet.pm instead of having it reside
three times in the descendents of the spreadsheet object.
Moved $spreadsheet->outsheet_excel() to Spreadsheet.pm for the same reason.
Created Spreadsheet::output_selector, which allows the user to select the
output mode they desire.
Created $spreadsheet->excel_output_row which takes care of writing a row
to an excel worksheet.
classcalc.pm, studentcalc.pm, and assesscalc.pm each had the same work done
on them:
Created &excel_rows(), which writes the body of the spreadsheets to
an excel file.
Rewrote &get_title to return an array of title lines.
Created &get_html_title to return an HTML version of the results of
&get_title.
classcalc.pm and Spreadsheet.pm each have the following change:
Created &html_header to return appropriate HTML for the spreadsheet.
Revision 1.5: download - view: text, markup, annotated - select for diffs
Fri May 23 14:52:51 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.4: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.4: +2 -1
lines
No longer save the results of computation of temporary spreadsheets.
Added Spreadsheet->temporary() to handle the getting and setting of the flag
which indicates a spreadsheet is temporary. studentcalc.pm and assesscalc.pm
check this flag before saving their export rows.
Revision 1.4: download - view: text, markup, annotated - select for diffs
Thu May 22 21:16:35 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.3: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.3: +43 -17
lines
Added 'blackout' support. A blackout occurs when an assessment has a part
flagged with 'problemstatus' equal to 'no'. This prevents the display of
the students performance on the part until the answerdate has passed.
Spreadsheet.pm contains &blackout, which returns the blackout status of
the current spreadsheet.
assesscalc.pm contains code which
a) causes the computation of the spreadsheet to determine the
blackout status
b) forces the recomputation of the spreadsheet if the user is a student.
Obviously (b) is less than ideal and a new approach should be found.
studentcalc.pm's outsheet_html subroutine now supresses the display of the
export (aka 'summary') row, as well as the rows of any assessments which
are under blackout.
Revision 1.3: download - view: text, markup, annotated - select for diffs
Mon May 19 15:48:18 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.2: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.2: +21 -5
lines
Modified $spreadsheet->title() subroutines to look prettier, link to the
students 'aboutme' page, and call &Apache::loncoursedata::GetUserName.
Revision 1.2: download - view: text, markup, annotated - select for diffs
Mon May 19 14:34:54 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to previous 1.1: preferred, unified to selected 1.40: preferred, unified
Changes since revision 1.1: +29 -14
lines
Cosmetic HTML changes.
If the user does not have 'mgr' privileges the student spreadsheet will display
a link to the resource for each assessment instead of a link to the assessment
spreadsheet.
Revision 1.1: download - view: text, markup, annotated - select for diffs
Fri May 16 20:55:11 2003 UTC (21 years, 3 months ago) by matthew
Branches: MAIN
Diff to selected 1.40: preferred, unified
Nearly complete reworking of spreadsheet.
lonspreadsheet.pm holds a few utility functions and the handler, which
creates a spreadsheet and tells it to display itself.
Spreadsheet.pm is the base definition of the spreadsheet object.
classcalc.pm, studentcalc.pm, and assesscalc.pm are implementations of the
spreadsheets.
There are missing pieces - excel and csv output, limiting by section
permissions, the ability to add extra 'header' rows to the student and
course level sheets, and students are still allowed to view the assessment
level sheets (will disable this soon).
Computing and editing of the spreadsheet have been tested and have been
given a preliminary seal of approval.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>