[LON-CAPA-users] Creating links to csv (or xls) files

lon-capa-users@mail.lon-capa.org lon-capa-users@mail.lon-capa.org
Thu, 11 Oct 2007 15:43:53 -0400

<div>I have a number of labs that do this. For an example, look in /res/mon=
roblem allows the student to download an Excel spreadsheet. (There are some=
 extra instructions for us, since our school computers have restrictive sec=
urity and prevent Excel sheets from being saved). Some of the other verbiag=
e deals with the issue that my students also need to download a little add-=
in which supports the grading logic in the spreadsheet.<br><br>The spreadsh=
eet checks their responses for correctness (sort of a simpler LonCapa!). Wh=
en they successfully complete the spreadsheet, a unique code is generated f=
or the student (indicating completion). That answer code is entered as a pr=
oblem response in LonCapa. This in turn pops up another problem part where =
they send their spreadsheet back to me using a dropbox.<br><br>brew<br><br>=
</div><font color=3D"#990099">-----lon-capa-users-admin@mail.lon-capa.org w=
rote: -----<br><br></font><blockquote style=3D"border-left: 2px solid rgb(0=
, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-ri=
ght: 0px;">To: lon-capa-users@mail.lon-capa.org<br>From: "H. K. Ng" &lt;hkn=
g@fsu.edu&gt;<br>Sent by: lon-capa-users-admin@mail.lon-capa.org<br>Date: 1=
0/11/2007 10:01AM<br>Subject: [LON-CAPA-users] Creating links to csv (or xl=
s) files<br><br><font face=3D"monospace" size=3D"3">Hi,<br><br>Has anyone g=
enerated a csv (or xls) file within a problem and then <br>has a link point=
ing to it? What I like to do is to provide the <br>students with some value=
s in a csv file. The students click on the <br>link which will then open th=
e spreadsheet program. They then have to <br>do some calculations using the=
 spreadsheet and enter the results of <br>their calculations on loncapa. Th=
is saves having to type in the <br>values in a spreadsheet.<br><br>Thanks,<=
=5F=5F<br>LON-CAPA-users mailing list<br>LON-CAPA-users@mail.lon-capa.org<b=
r><a href=3D"http://mail.lon-capa.org/mailman/listinfo/lon-capa-users">http=