[LON-CAPA-users] spreadsheet access folder name?

[Jon Hall]

guy,

i currently have 8 different flavors of assessment spreadsheets:
diagnostic, final exam, homework, lab, project, quiz, test, and  
ungraded.

and that works fine, setting each resource individually, except when  
i have a homework assignment with 15 problems, it is a little time  
consuming to go in and manually set each of those assessments.  so i  
was hoping that i could have the lon-capa do it automatically, based  
on folder title and due date.

sounds like it is a possibility with the latest versions of the  
spreadsheet and lonnet.  thanks a bunch for the heads up about the  
new features.

keep up the good work!
jh




On Jan 10, 2006, at 11:43 AM, Guy Albertelli II wrote:

> Hi Jon,
>
>> if i have a bunch of problems in located in folders named:
>>
>> Homework 14A
>> Lab: Centripetal Motion
>> Lab: Simple Pendulum
>> Homework 14B
>> Quiz 14.1
>>
>> how can i reference that information in the assessment-level
>> spreadsheet?
>>
>> i.e. how do i code
>>
>> if (folder name contains 'Homework')
>> {
>> calculation 1;
>> }
>> else
>> {
>> calculation 2;
>> }
>
> You can however set what assessment level spreadsheet is used on a per
> resource basis.
>
> So you could create 2 assement level sheets and use one for all the
> Homeworks and a different one for the labs, quizzes, etc.
>
> But for the next version one should be able to do
>
> &EXT('resource.title') to get the current resource's title
> &EXT('resource.map') to get the internal name of current resource
>                      folder (or sequence or page)
> and combine them:
> &EXT('resource.title',&EXT('resource.map'))
>
> To get the title of the current resources folder.
>
> (If you are want to try testing these changes out, you'll need to
> patch in:
> Spreadsheet.pm 1.61
> http://install.loncapa.org/cgi-bin/cvsweb.cgi/loncom/interface/ 
> spreadsheet/Spreadsheet.pm.diff?r1=1.60;r2=1.61
>
> and
>
> lonnet.pm 1.693
> http://install.loncapa.org/cgi-bin/cvsweb.cgi/loncom/lonnet/perl/ 
> lonnet.pm.diff?r1=1.692;r2=1.693
> )
>
> -- 
> guy@albertelli.com   0-7-1-8-27,137
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users