[LON-CAPA-users] Creating links to csv (or xls) files
H. K. Ng
lon-capa-users@mail.lon-capa.org
Fri, 12 Oct 2007 07:20:43 -0400
--=====================_2396343==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
Thanks for the info - not quite what I am looking for. I forgot to
mention that the csv or xls files that I want to point to are not
static - created by the problem. So each student get his/her own
version. This may be possible using the window tag if it has an
attribute mimetype which generates the header "Content-type:
application/csv\n\n". So if the mimetype is not specified, then it
defaults to text/html.
-hk
At 03:43 PM 10/11/2007, you wrote:
>I have a number of labs that do this. For an example, look in
>/res/monroe/brewington/Chemistry/labs/02-NuclearChem/HalfLife.
>
>Spreadsheet.problem allows the student to download an Excel
>spreadsheet. (There are some extra instructions for us, since our
>school computers have restrictive security and prevent Excel sheets
>from being saved). Some of the other verbiage deals with the issue
>that my students also need to download a little add-in which
>supports the grading logic in the spreadsheet.
>
>The spreadsheet checks their responses for correctness (sort of a
>simpler LonCapa!). When they successfully complete the spreadsheet,
>a unique code is generated for the student (indicating completion).
>That answer code is entered as a problem response in LonCapa. This
>in turn pops up another problem part where they send their
>spreadsheet back to me using a dropbox.
>
>brew
>
>-----lon-capa-users-admin@mail.lon-capa.org wrote: -----
>
>To: lon-capa-users@mail.lon-capa.org
>From: "H. K. Ng" <hkng@fsu.edu>
>Sent by: lon-capa-users-admin@mail.lon-capa.org
>Date: 10/11/2007 10:01AM
>Subject: [LON-CAPA-users] Creating links to csv (or xls) files
>
>Hi,
>
>Has anyone generated a csv (or xls) file within a problem and then
>has a link pointing to it? What I like to do is to provide the
>students with some values in a csv file. The students click on the
>link which will then open the spreadsheet program. They then have to
>do some calculations using the spreadsheet and enter the results of
>their calculations on loncapa. This saves having to type in the
>values in a spreadsheet.
>
>Thanks,
>-hk
>
>_______________________________________________
>LON-CAPA-users mailing list
>LON-CAPA-users@mail.lon-capa.org
><http://mail.lon-capa.org/mailman/listinfo/lon-capa-users>http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>
>
>
>_______________________________________________ LON-CAPA-users
>mailing list LON-CAPA-users@mail.lon-capa.org
>http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
--=====================_2396343==.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<body>
Thanks for the info - not quite what I am looking for. I forgot to
mention that the csv or xls files that I want to point to are not static
- created by the problem. So each student get his/her own version. This
may be possible using the window tag if it has an attribute mimetype
which generates the header "Content-type: application/csv\n\n".
So if the mimetype is not specified, then it defaults to
text/html.<br><br>
-hk<br><br>
<br>
At 03:43 PM 10/11/2007, you wrote:<br>
<blockquote type=cite class=cite cite="">I have a number of labs that do
this. For an example, look in
/res/monroe/brewington/Chemistry/labs/02-NuclearChem/HalfLife.<br><br>
Spreadsheet.problem allows the student to download an Excel spreadsheet.
(There are some extra instructions for us, since our school computers
have restrictive security and prevent Excel sheets from being saved).
Some of the other verbiage 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 spreadsheet checks their responses for correctness (sort of a simpler
LonCapa!). When they successfully complete the spreadsheet, a unique code
is generated for the student (indicating completion). That answer code is
entered as a problem 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>
<font color="#990099">-----lon-capa-users-admin@mail.lon-capa.org wrote:
-----<br><br>
</font>
<dl>
<dd>To: lon-capa-users@mail.lon-capa.org<br>
<dd>From: "H. K. Ng" <hkng@fsu.edu><br>
<dd>Sent by: lon-capa-users-admin@mail.lon-capa.org<br>
<dd>Date: 10/11/2007 10:01AM<br>
<dd>Subject: [LON-CAPA-users] Creating links to csv (or xls)
files<br><br>
<dd>Hi,<br><br>
<dd>Has anyone generated a csv (or xls) file within a problem and then
<br>
<dd>has a link pointing to it? What I like to do is to provide the <br>
<dd>students with some values in a csv file. The students click on the
<br>
<dd>link which will then open the spreadsheet program. They then have to
<br>
<dd>do some calculations using the spreadsheet and enter the results of
<br>
<dd>their calculations on loncapa. This saves having to type in the <br>
<dd>values in a spreadsheet.<br><br>
<dd>Thanks,<br>
<dd>-hk<br><br>
<dd>_______________________________________________<br>
<dd>LON-CAPA-users mailing list<br>
<dd>LON-CAPA-users@mail.lon-capa.org<br>
<dd><a href="http://mail.lon-capa.org/mailman/listinfo/lon-capa-users">
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users</a><br><br>
</dl><br><br>
_______________________________________________ LON-CAPA-users mailing
list LON-CAPA-users@mail.lon-capa.org
<a href="http://mail.lon-capa.org/mailman/listinfo/lon-capa-users" eudora="autourl">
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users</a>
</blockquote></body>
</html>
--=====================_2396343==.ALT--