principal
nivel superior
enviar artículo
buscar
administrar
acerca de ...
rdf
rss
main
|
Posted by Ricardo Beltran on Monday December 10, @08:39AM el 2007
from the Plenary Session 2 dept.
Finally the Plenary Session 2 is going live, The survey is finished and the Classification system is at the front door. The next steps follows:
1)Vic, Would you please sync the information at icme11.org into test.icme11.org... Please be careful since icme11.org is the latest version that should be spread to the others!
2)We need to promote this survey around the world (waiting for instructions about how are we going to accomplish this goal ).
3) We need to provide a download of the responses for David's team from Drupal to Comma Separated Value.
The Query?
The question is, who can give me a query that solves the following problem.
I have four data table with the following fields
Table1 (The table with almost all the questions
UID (FNK)
Q1
Q2
Q3
...
Q11
And also I have the following three tables for the multiple choice questions, for example Table2 is something like:
Table2
UID (FNK)
Q6
Then, Table1 has a one to many (no more than ten) relationship with table2,
Who can give me a query to obtain this
Table Result
UID
Q1
Q2
Q3
...
Q6_1
Q6_2
Q6_3
...
Q6_8
Q6_9
Q6_10
...
Q9
Q10
Q11
I will give a chocolate bar to the person that correctly solves this riddle.
<
reporte invernal
|
Arreglo en las fechas de los posts...
>
|
|
The Fine Print: The following comments
are owned by whoever posted them.
( Reply )
|
Re: Finished!
by Jergas on Tuesday December 11, @09:43PM
|
Hear Ye! Hear Ye! Hear Ye! Edgar Senior has announced the following:
Plenary 2 Survey
Please comment as a reply to this.
|
[
Reply to this ] |
Re: Finished!
by David Clarke on Wednesday December 12, @01:25AM
|
Hi Everyone,
I'm confused - I went to the ICME11 website yesterday and the link was there - the site works perfectly.
The link that Edgar provided takes me to a webpage that includes http://icme11.org/surveyinvitation - but the Plenary Session 2 Survey is also included in the right-hand menu. If I go to the existing live ICME11 homepage, then the same link is present in the right-hand menu, so I'm not sure where the new webpage (http://icme11.org/node/485) fits into the system.
I have no complaints or concerns at all about the existing form of the ICME11 homepage. Now it's my job to advertise the survey as widely as possible (see the attached flyer).
I don't know how to reply to the ps about the taxonomy content. Do you mean have I tried classifying responses? If so, I wasn't aware that there had been any.
Certainly the survey has now been advertised quite widely, through the ICME11 IPC, through my own international research network and through Jerry Becker's international mailserv (see below).
It's not clear to me what more I need to do - other than to test the data downloading facility once this is available.
As per my email to everyone - thanks again - I'm very pleased with the outcome.
David
Jerry Becker's mailout:
Sent at the request of Professor David Clarke.
--------------------------------------
See at the bottom how to respond to the Survey.
***************************
ICME 11 Mexico 2008
11th International Congress on Mathematics Education
Monterrey, Mexico, July 6 - 13, 2008
Help to shape the Research Agenda in Mathematics Education!
PLENARY 2 SURVEY
What do we need to know?
Does research in mathematics education address the concerns of teachers and policy makers?
One of the plenary activities for ICME 11 will be a panel presentation addressing the question of whether research in mathematics education is providing the information that teachers and policy makers most need. The panel members are mathematics education researchers from different countries, who will respond to teachers' and policy makers' questions submitted through this website.
WE NEED YOUR CONTRIBUTIONS!
Whether or not you plan to attend ICME 11 - and we hope you do - you can make an important contribution by letting us know how research can help you.
To do this, we invite you to submit an important question that you think should be answered by research in mathematics education and also to indicate whether research has helped you in the past and, if so, how.
WE NEED RESPONSES FROM ALL COUNTRIES, ALL SCHOOL TYPES AND ALL LEVELS OF THE SCHOOL SYSTEM INCLUDING TEACHERS, POLICY MAKERS AND CURRICULUM DEVELOPERS.
This is your chance to play a part in shaping the research agenda in mathematics education. To do this, please go to the ICME 11 website (http://icme11.org/) and select the Plenary Session 2 Survey link. It is important that you and your colleagues make your views known and contribute to shaping the direction of mathematics education research internationally.
A REPORT WILL BE MADE AVAILABLE THROUGH THE CONFERENCE WEBSITE OF BOTH THE SUBMISSIONS AND THE RESPONSES OF THE PLENARY PANEL.
- *******************************************
- Jerry P. Becker
Dept. of Curriculum & Instruction
Southern Illinois University
625 Wham Drive
Mail Code 4610
Carbondale, IL 62901-4610
Phone: (618) 453-4241 [O]
(618) 457-8903 [H]
Fax: (618) 453-4244
E-mail: jbecker@siu.edu
ICME 11 Plenary 2 Survey Invite.doc
50KB (51200 bytes)
|
[
Reply to this ]
|
|
Re: Finished!
by jergas on Thursday January 03, @03:06AM
|
Hola y Feliz Anyo!
No entiendo bien los detalles de las tablas involucradas. Al margen, dime, se resolvio esto?
Un abrazo para ti y para tu farmacia!
|
[
Reply to this ] |
Re: Finished!
by pks on Thursday January 03, @01:11PM
|
Aun no, no estaria mal que alguien chipocludo en los Queries echara una mano.
Gracias por los saludos
|
[
Reply to this ]
|
|
Puzzle solved!
by Gunnar on Thursday January 31, @09:59PM
|
Ok, I must say I'm proud of myself ;-) This piece of code took me just under an hour, and it provides the needed transformation from four tables to a single CSV file. It's all now a matter of integrating this into the site (so it is no longer a manually-run process). Of course, I'm attaching here my source - but not the resulting CSV, as it might contain non-public data. Of course, _please_ check my little program works correctly - that is, that the generated data is coherent with the input. I'm unfamiliar with the database layout, and I could have got something wrong. (Of course, how can you check the resulting data if you don't have it? Oh, that's simple: I'm just about to send it by mail to the interested parties: Victor, Ricardo, David, Edgar[0] and Marcela. Edgar[1] still told me his mail is out of order - Edgar, don't blame Telmex. It's for our own good, this time there's no real argument against it. Besides, the same thing is happening all around the world. And, yes, those are good measures!
|
[
Reply to this ] |
Re: Puzzle solved!
by jergas on Tuesday February 05, @01:56PM
|
How about a daily cron job?
If we wanted backups we could even have 2 cron jobs, one which saves de scv file with the date on the filename, and one (right after the first one) which copies that one to a fixed filename (with a fixed URL).
Then we could just have a fixed link in the plenary 2 website which only shows on the contextual menu of taxonomists.
|
[
Reply to this ]
|
Re: Puzzle solved!
by Gunnar on Tuesday February 05, @08:53PM
|
The script is quite trivial, and the output file is not large. My original proposal to Ricardo was to integrate the script as a CGI process, to generate the output on demand (that means, always-fresh). I understand our hosting would not have a problem with that - but it involves setting it up with Drupal, and I don't know how involved that is. On the other hand, we could just generate the files every hour (or every x hours), and -why not?- save all of the generated data sets - in case they are useful for something. That's as easy as just appending the timestamp to the filename! Of course, if the historic record is not needed, scrap my proposal - We would not even need a backup, as the whole data is in the database. And I understand DreamHost provides snapshot backups for it in case of disaster. (but I might understand wrong, of course!)
|
[
Reply to this ]
|
Re: Puzzle solved!
by jergas on Wednesday March 19, @05:19AM
|
Well, Ive seen the entry in the Taxonomists menu, and Ive even roadtested it. So, just out of curiosity: which solution was implemented?
|
[
Reply to this ]
|
Re: Puzzle solved!
by jergas on Friday March 21, @04:54AM
|
Hola Gunnarcindo,
Revisitando esta vieja conversacion, tengo una par de comentarios sobre el
articulo que mencionas arriba:
- lo que describe el articulo (filtrar los emilios) es mas agresivo que obligar a la gente a cambiar de puerto
- el articulo no lo menciona como algo bueno, de hecho, retoricamente pregunta si es deseable, y cuando haces una pregunta asi generalmente implica una critica indirecta
- una solucion moronica a un problema serio no me parece "good security policy", ya que al incrementar gradualmente la complejidad del problema que los atacantes enfrentan, solo los estamos ayudando a evolucionar mejor software
y bueno, este post no es un acto trollista, ni busca una piroguerra, solo es mi opinion expresada de manera poco delicada, pero ya que tu acostumbras expresarte de manera poco delicada, espero que aprecies mi candidez.
|
[
Reply to this ]
|
|
The Fine Print: The following
comments are owned by whoever posted them.
( Reply )
|
|