Counterglow Forums  

Go Back   Counterglow Forums > General Discussions > Technoglow

Reply
 
Thread Tools Display Modes
Old 15-01-2008, 21:46:03   #1
Beta1
[works only in german, sorry]
 
Beta1's Avatar
 
Join Date: Nov 2001
Location: here
Excel genius/web guru needed

I've made a self marking worksheet for my A-level chemists in excel - basically it gives them some compounds and they type in the name and if its right it tells them and if not it gives hints.

It works great and the kids love it as they can get instatn feedback.

So far so good.

Its sitting on my web space and the some of the kids download it and practise naming compounds as told to.

Some don't

What I want to do is figure out a way of either finding out who has downloaded it - or even better getting a way of the excel sheet feeding back the data of what they got right by email or similar.

ANyone got any clue how to do this other than making them email the worksheet back?
__________________
I've got ham, but I'm not a hamster...
Beta1 is offline   Reply With Quote
Old 15-01-2008, 22:49:40   #2
Beta1
[works only in german, sorry]
 
Beta1's Avatar
 
Join Date: Nov 2001
Location: here
only thing I can think of that doesnt require major work is having a copy of worksheet for each kid on the school server and then another that simply reads the scores off them....

I can see this getting very complex...
__________________
I've got ham, but I'm not a hamster...
Beta1 is offline   Reply With Quote
Old 16-01-2008, 00:17:29   #3
Greg W
This title intentionally left blank
 
Greg W's Avatar
 
Join Date: Nov 2001
Location: Down Under
Or make the spreadsheet require a userid and password to download, and then keep track of who downloads it.

I'm guessing (I'm not that big an expert) that you could put something into the script that checks the answers... Ooh, hang on...

What about instead of having them download the spreadsheet, you embed it into a webpage (and no, don't ask me how to do that ) that they have to log into to see. That I imagine would make it much simpler to keep track of answers and the like.
__________________
NIM
Greg W is offline   Reply With Quote
Old 16-01-2008, 07:41:39   #4
chagarra
Grumpy Geriatric
 
Join Date: Nov 2001
Location: Melbourne Australia
www.htmlgoodies.com has a primer on

this in their ASP primers.. Worth a look
chagarra is offline   Reply With Quote
Old 16-01-2008, 09:37:53   #5
Funko
Pubs Minister
 
Funko's Avatar
 
Join Date: Mar 2005
Location: Banned
I think that getting them to e-mail it back and checking it manually will be FAR less work than doing any of the web ideas that you are thinking about.
Funko is offline   Reply With Quote
Old 16-01-2008, 09:49:07   #6
C.G.B. Spender
Burggespenst Lülü
 
C.G.B. Spender's Avatar
 
Join Date: Nov 2001
Trust http://www.lazyview.com !
C.G.B. Spender is offline   Reply With Quote
Old 16-01-2008, 20:41:26   #7
LoD
The Human Banning Rod.
 
LoD's Avatar
 
Join Date: Nov 2001
Location: No longer Freudtown
The only surefire way is to have it server-side, e.g. as a PHP script.
__________________
Austrian english would be completely different. It sounds like a nasal record player on sedatives.
--Dyl
LoD is offline   Reply With Quote
Old 21-01-2008, 16:55:33   #8
mr_B
me happy
 
mr_B's Avatar
 
Join Date: Jun 2007
Location: aintgonnatellyou
Quote:
Excel genius/web guru needed
ask drekkus



__________________
GregW GAYLORD!!!!!
mr_B is offline   Reply With Quote
Old 22-01-2008, 13:17:49   #9
Nav
Never gonna be as ugly as Lurker
 
Nav's Avatar
 
Join Date: Nov 2001
Location: Everywhere...
possibly you can embed some script (vb?) that could do something magic (such as ask for a name when finished). Which could then send that to a basic mailer script on a server somewhere.
Nav is offline   Reply With Quote
Reply
Forum Jump

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 23:05:23.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© Counterglow 2001-2012. All rights reserved.