DECROLY'S TRANSENET DRAFT REPORT

www.decroly.com

By Alfredo de la Presa Cruz

Two Communities of Practice in which we could spread the results of our TRANSENET Project

The first one could be the following blog:

http://ticsenlaeducacionsantander.blogspot.com/ which is a blog for ICT in the education for the teachers of Santander and depends directly from the Regional Educative Authority

The second one The “internet in the classroom”congress that will take place in the frame of the program “internet in the classroom” (Ministery of Education, Center For Innovation, regions and red,es)

It is defined as a way to make more dynamic the community and also as a way of training for the community in the use of ICT in the educative processes. The congress has two modalities:

Virtual congress that will be constituted as a forum where the participants expose and share experiences and that will serve as teaching for peers for six months in 2008.

April 1^st to October 15^th. The webpage is www.congresointernetenelaula.es

Face to face congress in various cities that uses ICTs as an interaction mechanism between the towns making it possible a greater participation of the teachers, as lecturers or just as attendance, in 26^th, 27^th and 28^th in June 2008, being the towns: Barcelona, Granada, Madrid and Santander

The goals are the following:

To favour the use of the ICTs in the educative environment
To ease the teachers’ approach to the Communication and Informacion Society
To recognise the teachers as the main agents of educative innovation through ICTs
To point the support that technologies might give to the new curricula derived from the new Education Law
Helping to achieve the basic competences of the new curricula with the ICTs’incorporation.
To impulse the making of experiences of good educative practice
Showing the effectiveness of ICT’s in learning improvement
To get communities of practice interested in the use of the ICTs
To introduce the best initiatives for innovation through the use of ICTs
To promote a general reflection about the educative activity and the current needs in education

People that will form the Spanish Steering Group

Francisco Javier Múñiz Bárcena

Alfredo de la Presa Cruz

Two innovative practices in education:

As it can be seen here, this is an innovative approach to computing that was portrayed as such by the Ministery of Education and Science

The website can be accessed via this link: http://www.geocities.com/ConfesorAD/index.htm

The Spanish text says: “Name: Alfredo de la Presa Cruz, Vocational Training, second course of Management of Computing Systems. Following, I link my exercises, which were done although Hotpotatoes is primarily thought as a Language Teaching Tool, it can be used to make many different exercises for many matters. So I opted for making a Didactic unit of Database Management System with this software, using for each exercise one of the programs the Hotpotatoes Suite offers us.

As an example, I offer you a picture of one of this exercises when only two of the correct answers-out of five possible- are provided:

The text in the blue box says: “Your score is forty. Some of the answers are not right. The wrong answers have been maintained in their place just for you to change them.

Another example could be the following:

Which is a selection of te answer you believe to be right. The question is: The foreign key is:

A- A primary key in the table

B- A way to make a relationship between the contents of a table with those of other in which the foreign key is a primary ke

C- The chosen candidate key

D- The set of all the candidate keys

(The right one is B)

But if we press the button “Mostrar todas las preguntas”, which is Spanish for “Show all the questions”, the four questions will appear of which you have a sample in the following:

Which are questions for the two methods to relate table and the features of the primary key

This ends this brief example innovative practice, of course feel free to ask if you have questions about this one or if you feel that it would be interesting for me to make it a more extensive report

Second Experience of innovative practice

From my experience as a teacher, I found that during my first two years, I had a mountain of paper that war never more used, as the Students graduated and I had no further need for these papers, even if I had to keep the papers for five years because of our quality processes. So, then I made a course in PHP and Mysql and I saw a solution to the problem through ICTs as the easiest way not to end with a pile of paper. So I created a program to make examinations and assessment to my students.

I used EasyPHP which is a free software with the Apache Server and the Mysql server.

The final result was similar to the following one:

Test for middle level. This test is structured with two initial textboxes that are there to introduce the name and surname of the student and three questions to answer in which you can only select one radio button.

I will show you the code for the last test I took, which are ten questions and four textareas for definitions. I also designed a retrieval tool in order to ease the search, and then I will show the screen dumps of that code:

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">

<html>

<head>

<title>SEGUNDO EXAMEN DE LA PRIMERA EVALUACIÓN DE INSTALACIÓN Y MANTENIMIENTO DE SERVICIOS DE INTERNET DE EXPLOTACIÓN DE SISTEMAS INFORMÁTICOS</title>

</head>

<center><h1>EXAMEN DE 2º DE ESI</H1></center>

<BR>

Nombre:

Apellidos:<input type="text" name="apellidos" size="30" maxlength="256">

</center>

<tr>

Pregunta 1:

<br>

¿De qué formas se puede abrir un script o programa de PHP?

<br>

<input type="checkbox" name="Pregunta11">&gt?

<br>

<input type="checkbox" name="Pregunta12">&lt?PHP

<br>

<input type="checkbox" name="Pregunta13">&gt?PHP

<br>

<input type="checkbox" name="Pregunta14">&gt?PPP

<br>

</td>

</tr>

<tr>

Pregunta 2:<br>

Para evaluar que UNA condición se cumple utilizaremos:

<br>

<input type="radio" name="Pregunta2" value=0>DO WHILE

<br>

<input type="radio" name="Pregunta2" value=1>IF ELSE

<br>

<input type="radio" name="Pregunta2" value=0>ECHO

<br>

<input type="radio" name="Pregunta2" value=0>print

<br>

</td>

</tr>

<tr>

Pregunta 3:<br>

El bucle For me permite realizar una serie de instrucciones mientras se cumpla una condición dada. ¿Cuál es su sintaxis correcta?

<br>

<input type="radio" name="Pregunta3" value=0>for ($i=0,$i<=0,$i++){}

<br>

<input type="radio" name="Pregunta3" value=0>for ($i=0;$i<=0;$i++);{}

<br>

<input type="radio" name="Pregunta3" value=0>for (;$i=0;$i<=0;$i++){}

<br>

<input type="radio" name="Pregunta3" value=1>for ($i=0;$i<=0;$i++){}

<br>

<BR>

</td>

</tr>

<tr>

Pregunta 4:<br>

Si escribimos $consulta="INSERT INTO CONSULR VALUES ('$CADENA'. '$COMENTARIO','$ETIQUETA')", los posibles resultados son:<br>

<input type="checkbox" name="Pregunta41">Almacenará en la variable $consulta la cadena de caracteres que hay entre las comillas dobles

<br>

<input type="checkbox" name="Pregunta42">Error porque la consulta está mal construida

<br>

<input type="checkbox" name="Pregunta43">Almacenará en la variable $consulta la cadena de caracteres que hay entre las comillas simples

<br>

<input type="checkbox" name="Pregunta44">No dará ningún resultado aunque almacenará en la cadena $consulta la consulta SQL

<br>

</td>

</tr>

<tr>

Pregunta 5:<br>

¿Es necesario introducir un formulario antes del programa PHP para que funcione?

<br>

<input type="radio" name="Pregunta5" value=0>Es estrictamente necesario<br>

<input type="radio" name="Pregunta5" value=0>Nunca es necesario

<br>

<input type="radio" name="Pregunta5" value=0>Depende del número de líneas del programa

<br>

<input type="radio" name="Pregunta5" value=1>No es estrictamente necesario pero incluír los datos desde un formulario mejora la interactividad

<br>

</td>

<tr>

</tr>

</table>

</center>

Introduzca en la caja siguiente la diferencia entre el uso de las sentencias WHILE y DO-WHILE

<br>

</TEXTAREA>

</CENTER>

Introduzca en la caja siguiente un pequeño programa en PHP que me diga si un número es mayor que otro introducido por teclado

<br>

</TEXTAREA>

</CENTER>

Introduzca en la caja siguiente con sus palabras una descripción lo más detallada posible de cómo introducir valores en una base de datos desde PHP

<br>

</TEXTAREA>

</CENTER>

Introduzca en la caja siguiente un programa que me cuente los cien primeros números naturales y me diga cuáles de ellos son primos.

<br>

</TEXTAREA>

</CENTER>

</form>

<?php

if (isset($nombre)){

$puntuacion=$Pregunta2+$Pregunta3+$Pregunta5;

if (($Pregunta41==true)AND ($Pregunta44==true)){$puntuacion++;}

if ($Pregunta12==true){$puntuacion++;}

$c=mysql_connect("localhost","root","");

if (!$c){

die("Conexión Fallida");

}

$s=mysql_select_db("examen2esi2008",$c);

$consulta="INSERT INTO examen2esi2008(nombre,apellidos,puntuacion, definicion1, definicion2,definicion3, definicion4) VALUES ('$nombre','$apellidos','$puntuacion','$definicion1','$definicion2','$definicion3','$definicion4')";

$resultado=mysql_query($consulta);

if ($resultado){

print("Su test ha quedado registrado<br>");

}

else{

Print("Error en el registro");

}

mysql_close($c);

}

</body>

</html>

The code for the retrieval is the following one:

<table>

<tr>

<td>

</td>

<td>

Búsqueda por Nombre:

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

Búsqueda por Apellidos:

</td>

<td>

</td>

</tr>

</table>

<br>

</form>

<?php

if (isset($tipobusqueda)){

$c=mysql_connect("localhost","root","");

if(!$c){

die("Conexion fallida");

}

$s=mysql_select_db("examen2esi2008",$c);

switch($tipobusqueda){

case 1:

$consulta="SELECT * FROM examen2esi2008 where nombre='$Nombre'";

break;

case 2:

$consulta="SELECT * FROM examen2esi2008 where apellidos='$Apellidos'";

break;

}

$resultado=mysql_query($consulta);

$r=mysql_fetch_array($resultado);

echo "<table border= 1><tr><td>Nombre</td><td>Apellidos</td><td>Puntuación</td><td>Definición 1</td><td>Definición 2</td><td>Definición 3</td><td>Definición 4</td></tr><tr><td>$r[0]</td><td>$r[1]</td><td>$r[2]</td><td>$r[3]</td><td>$r[4]</td><td>$r[5]</td><td>$r[6]</td></tr></table>";

}

And the screen dumps for these two programs are the following:

In this test there are only five questions, and then the definitions:

So this is the program to introduce the answers

The retrieval tool has this aspect:

Result of the implementation of a test seeing the database with the retrieval tool designed for it.

This ends this brief example innovative practice, of course feel free to ask if you have questions about this one or if you feel that it would be interesting for me to make it a more extensive report.

DECROLY - Entidad Organizadora de Formación al amparo de la Fundación Tripartita para la Formación en el Empleo

Paseo del General Dávila, 202. 39006 Santander. - Tfno.: + 34 942 37 02 34 - www.decroly.com - formacion@decroly.com