| View previous topic :: View next topic |
| Author |
Message |
randenius
Newbie
Joined: 03 May 2012
Posts: 2
|
 Posted: Thu May 03, 2012 11:03 pm Post subject: Conducting a test within organisation |
 |
|
Here is a little background of the problem. I'm tasked to conduct a test within my organisation. About 400 candidates are suppose to sit for the test that is 60 minutes long and has 50 MCQs. Most of the candidates are running Windows XP with only intranet access, hence I'm thinking about using Open Office to carry out this task. However, I'm a newbie in this.
What I have in mind right now is to prepare the test paper, probably in OO Calc. I will send this out to the candidates, get them to fill in the answers and send it back. The problem lies here. Is there a way to do a macro or program to automatically gather the scores from every file into 1 single spreadsheet and tie them to their respective name? |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri May 04, 2012 6:27 am Post subject: Re: Conducting a test within organisation |
|
|
| randenius wrote: | Here is a little background of the problem. I'm tasked to conduct a test within my organisation. About 400 candidates are suppose to sit for the test that is 60 minutes long and has 50 MCQs. Most of the candidates are running Windows XP with only intranet access, hence I'm thinking about using Open Office to carry out this task. However, I'm a newbie in this.
What I have in mind right now is to prepare the test paper, probably in OO Calc. I will send this out to the candidates, get them to fill in the answers and send it back. The problem lies here. Is there a way to do a macro or program to automatically gather the scores from every file into 1 single spreadsheet and tie them to their respective name? |
I wonder if there is not a better solution using some opensource testing software? A quick google will give you some leads.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
randenius
Newbie
Joined: 03 May 2012
Posts: 2
|
| Posted: Sat May 05, 2012 6:28 am Post subject: |
|
|
| Hi, jrkrideau. I forgot to mention that I'm not allowed to install any third party software into our computers. Hence I am resorting to installed software such as open office/microsoft office. |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sun May 06, 2012 6:04 am Post subject: |
|
|
| randenius wrote: | | Hi, jrkrideau. I forgot to mention that I'm not allowed to install any third party software into our computers. Hence I am resorting to installed software such as open office/microsoft office. |
Ouch! Nothing like being handicapped before starting.
My guess is that it would be possible to do it with Calc but I certainly don't have the programming skills to do it.
Again, I lack the programming skills to do it, but you might want to consider using BASE?
I'd suggest posting the question to the Base forum and seeing if any of the data base gurus there have a suggestion. It just strikes me as more of a data.base operation than a Calc one.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
