Index: openacs-4/packages/evaluation/catalog/evaluation.en_US.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/catalog/evaluation.en_US.ISO-8859-1.xml,v diff -u -r1.1 -r1.2 --- openacs-4/packages/evaluation/catalog/evaluation.en_US.ISO-8859-1.xml 10 Jun 2004 21:15:04 -0000 1.1 +++ openacs-4/packages/evaluation/catalog/evaluation.en_US.ISO-8859-1.xml 15 Jun 2004 23:20:28 -0000 1.2 @@ -11,7 +11,9 @@ Add/edit answer Add/edit solution again + Already answered Answer + Assignment Group Assignment Groups Assignment Type Assignment Types @@ -52,12 +54,16 @@ Edit Reason Edit Task Edit task + Email: + Evaluated Evaluation Index Evaluation Modified Evaluations Evaluations Evaluations Admin Evaluations List + Exams + Exams for students File File/url associated Generate file @@ -66,8 +72,10 @@ Grade Students Grade Distribution + Grade in Net value Grade over Grade over 100 + Grader Grades Grades Category Grades Report @@ -99,6 +107,7 @@ here How does this work? Id + Individual Insert Failed Is live? Last Modified @@ -108,7 +117,7 @@ able to see the grade? Add a member to a group Add Assignment to Communities - Add this assignment to other class(es) + Add this %grade_name% to other class(es) Admin Assignment Types Admin my Assignment Types Allow the students <br> to see the grade? @@ -119,11 +128,12 @@ Are you sure you want to remove the assignment type "%grade_plural_name%"? (If your answer is yes, all the evaluations, tasks, tasks solutions and answers associated with this assignment type will be deleted too) Are you sure you want to remove the group "%group_name%"? (If the group has an evaluation/answer associated, it will be deleted too) Are you sure you want to delete the task "%task_name%"? (If you delete the task, all the information associated with the task, such as answers, task solutions, etc, will be deleted too) + Assignment Attachment Assignment Plural Type Name Assignment Type Name Assignment Type's Comments Assignment Types Distribution - Assignment's Description + %grade_name%'s Description Associate to this group Audit info for task "%task_name%" Can the student submit the answer <br> after the due date? @@ -157,23 +167,34 @@ First, you will see the list of students without group (if there are students without group) and you can create a group by selecting the members of the group and then clicking on the "Create Group" botton. Generate the csv file from the system. This file has the proper structure so the system can parse it and obtain the information about the grades. This file is generated by clicking on the "Generate File" link. Grade %grade% does not seem to be a real number. + Grade over 100 points + %grade_plural_name% represents the %grade_weight%% of the 100% of the class Grade students using generated file: Grade students using generated file: Grade students with 0 + Grades Report for $student_name + Grades report of "%student_name%" Grades Sheet Explanation Group administration Groups administration Groups for task %task_name% If you administer more than one community and you want to upload an assigment in more than one community, you must set the same name for each of the assignment types in each community so the system can identify where to store the assignment. + If you click on the student name, you will see the grades report for that student. If you do not want to grade or edit the grade of a student/group, just leave intact the fields of that row, or you can delete the whole row. + if you do not want to see the portraits of the students if you want to download all the answers in one file + if you want to see the portraits of the students In order to generate this file there must be some parties assigned to this task. In this page you can administer the groups for the assignment. Input \"Will the student be able to see the grade\" must be 1 (one) for YES or 0 (zero) for NO, please don't leave it blank. + Is the task submitted online? Max Grade does not seem to be a real number. Please don't leave it in blank. No file/url associated with this task No file/url associated with this task solution + No group for student No, I want to cancel my request + No portrait for $party_name + No portrait for $student_name Notification for assignments Notification for evaluations Number of members for this task: @@ -184,10 +205,13 @@ Please enter the group name Please enter the new group name Please select the group + Projects for students Reuse groups from another assignment Save the csv file and KEEP THE CSV FORMAT. The CSV file can be edited with any text editor (and MS Excell) but you have to save it keeping the CSV format. If you do not keep the format, the system will not be able to parse the file. See grades sheets associated with this task Send the file using the "Send file" botton. The system will parse the file and you will be asked for a confirmation (if everything is ok with the file) for the grades. + <small>Total points in this category: ${total_grade}/${max_grade} <br /> + $grade_plural_name represents the ${grade_weight}% of the 100% of the class</small> Students who have not submitted answers and have not been evaluated (%not_evaluated_with_no_answer%) Students with answers that have not been evaluated (%not_evaluated_with_answer%) %submission_date_pretty% (late) @@ -201,6 +225,7 @@ } set page_title "<#_ Confirm Evaluation + The file extension of the file is \"$file_extension\" and it should be .CSV, we can't process it The file is too large. (The maximun file size is %pretty_maxnbytes% bytes)" return 0 } @@ -231,6 +256,7 @@ set max_grade [string trim [lindex $evaluation 1]] if { ![ad_var_type_check_number_p $max_grade] } { ad_return_error "<#_ Invalid Max Grade + The file is too large. (The maximun file size is %pretty_maxnbytes% bytes) The file should have a pre-defined format so the system can parse it and obtain the information. If you want to use this functionallity you must follow the following steps: The grade most be a valid number: %wrong_grade% The grade must be a REAL NUMBER. @@ -255,7 +281,9 @@ There is a comment larger than we can handle: %wrong_comments% There is an edit reason for a grade not realized: %wrong_comments% There is an edit reason larger than we can handle: %wrong_comments% + There is no audit info for this task because there are no students evaluated. There are no grades in the csv file or there are no modifications in the csv file. + There is no info for this student There is no information about this task. There must be an edit reason if you want to edit the grade on party_id %party_id%. There must be at least one grade to work with @@ -265,6 +293,8 @@ <p>This was the error: <pre>%errmsg%</pre></li> There was an error creating the groups These are the grades sheets used to evaluate students for this task + These are the students that have already answered but have not been evaluated yet. + These are the students that have not answered yet (if the task is online) and have not been evaluated yet. This funcionallity allows you to upload a CSV (Comma Separated Value) file with the grades of the students. This CSV file can be edited with MS Excell and many other text editors. This is the grades report of the students acording to the assignments/evaluations that you have made. This is the grades report of the students acording to one assignment type and the evaluations that you have made in this assignment type. @@ -279,15 +309,18 @@ To delete the group, click on the "Delete Group" botton. to submit their answers after due date? To unassociate a member of the group, click on the "Unassociate member" link. + TOTAL GRADE: %total_class_grade% Total points in this category: %total_grade% / $max_grade<br /> This grade category represents the ${grade_weight}% of the 100% of the class Total points in this category: %total_grade% / %max_grade%<br /> This grade category represents the %grade_weight%% of the 100% of the class + Total points in this category: %total_grade%/%max_grade% Unassociate student for this group Unrecognized value for notif type: $notif_type. Possible values are one_assignment_notif and one_evaluation_notif. Upload a file OR a url, and not both Upload a file OR a url, not both Upload a file OR a valid url, and not both + Upload a solution for this assignment so the students can see it and learn from it. $user_name has modified the grade of %party_name%. \n The edit reason given by %user_name% was: %edit_reason% \n The current grade is: %current_grade% \n\n Click on this link to see the evaluation details: %url_link% \n View/Edit Task Solution We got the following error while trying to remove the evaluation: <pre>%errmsg%</pre> @@ -303,9 +336,9 @@ Will the student be able to see the grade? (1 = Yes / 0 = No): Will the student be able to see the grade? Will the students be able - Will the task be submitted online? + Will the %grade_name% be submitted online? Will this task be submitted on line? - Will this task require a grade on the course? + Will this %grade_name% require a grade on the course? Yes, I really want to remove this evaluation Yes, I really want to remove this grade Yes, I really want to remove this group @@ -323,19 +356,23 @@ Maximun Grade: Members Modifying User + n/a Name: Name + Name: %student_name% Net value (NEW answer) New Assignment New Group + No No (No data) No group for task No. of Members No. of members No parties to grade No response + Not answered Not available Not evaluated Number of Integrants @@ -344,15 +381,19 @@ One Evaluation One Grade Type One Group + Online Submit y entonces + Projects Remove Grade Group Requires Grade? Reuse Groups + Solution Attachment Studen List Student List Student Name Students List + Student's Portrait Submission Date submit answer submit answer again @@ -362,6 +403,9 @@ Task Name Task Name Task Solution + Task Status + Tasks + Tasks for students Tasks List Total Total current grade: @@ -391,5 +435,6 @@ Weight Will the studen(s) be upi , pero no yupin + Yes Yes Index: openacs-4/packages/evaluation/catalog/evaluation.es_ES.ISO-8859-1.xml =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/catalog/evaluation.es_ES.ISO-8859-1.xml,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/catalog/evaluation.es_ES.ISO-8859-1.xml 15 Jun 2004 23:20:28 -0000 1.1 @@ -0,0 +1,484 @@ + + + + Individual = 1 + Agregar Asignaci�n + Agregar Tipo de Asignaci�n + Agregar tipo de asignaci�n + Agregar Miembro al grupo + Agregar Tarea + Agregar Soluci�n de la Tarea + Agregar/Editar respuesta + Agregar/Editar soluci�n + otra vez + Ya respondido + Respuesta + Grupo de Asignaci�n + Grupos de Asignaciones + Tipo de Asignaci�n + Tipos de Asignaciones + Tipos de Asignaciones + Asignaciones + Asignaciones + Asociar + Asociar a grupo... + Historial de Notas + Historial de notas + Historial de Notas + Historial de notas para tareas + Datos no validos + Cambiar Respuesta + Click + haga click en este link: + Comentarios: + Comentarios + Cometar/Editar raz�n: + Cometar/Editar raz�n: + Confirmar Evaluaci�n + Grupo + Crear Grupo + Eliminar Evaluaci�n + Eliminar evaluaci�n + Eliminar Grupo + Eliminar Tarea + Eliminar tarea + Descripci�n + Descripci�n + Fecha: + Fecha: + Fecha: + Fecha: + Editar evaluaci�n + Editar Evaluaciones + Raz�n de Modificaci�n: + Raz�n de Modificaci�n + Editar Tarea + Editar tarea + Correo Electr�nico + Evaluado + Indice de Evaluaciones + Evaluaci�n Modificada + Evaluaciones + Evaluaciones + Administraci�n de Evaluaciones + Lista de Evaluaciones + Ex�menes + Ex�menes para estudiantes + Nombre del archivo: + Archivo/url asociado + Generar Archivo + Regresar + Nota: + Nota + Estudiantes + Distribuci�n de Notas + Valor Neto de la Nota + Nota sobre + Nota sobre 100 + Calificado por + Notas + Categor�a de Notas + Reporte de Notas + Reportes de Notas + Nombre del Cuadro de Notas + Cuadro de Notas + Nombre del grupo + Nombre del Grupo + Administraci�n de Groupos. + aqu� + �C�mo funciona esto? + Id + Individual + No se pudo insertar + �Esta disponible? + Ultima Modificaci�n + tarde + (tarde) + Una nueva asignaci�n se ha subido, si usted desea ver mas detalles + + �podr�n ver sus notas? + Agregar miembro al grupo + Agregar Asignaci�n a Comunidades + + Agregar asignaci�n %grade_name% en varias clases o secciones + Administraci�n de Tipos de Asignaciones + Administrar mis Tipos de Asignaciones + �Permitir a los estudiantes <br> ver sus notas? + Grupos ya creados + Tambi�n, vera la lista de los grupos ya creados (si hubiera alg�n grupo creado). Haga click en el link de "Administraci�n del Grupo" para administrar el grupo. En estas paginas de administraci�n usted ser� capaz de desasociar miembros de un grupo dado, renombrar el grupo y/o eliminar el grupo. + Una asignaci�n ha sido modificada, si desea ver mas detalles + �Esta seguro de querer eliminar la evaluaci�n en "%party_name%"? + + �Esta seguro de querer eliminar la asignaci�n de tipo "%grade_plural_name%"? +(Si su respuesta es si, todas las evaluaciones, tareas, soluciones y respuestas asociadas a este tipo de asignaci�n ser�n eliminados tambi�n) + + �Esta seguro de querer eliminar el grupo "%group_name%"? (Si el grupo tiene una evaluaci�n/respuesta asociada, esta ser� eliminada tambi�n) + �Esta seguro de querer eliminar la tarea "%task_name%"? (Si usted elimina esta tarea, toda la informaci�n asociada a la tarea, como respuestas, soluciones, entre otros, ser�n eliminados tambi�n) + Adjunto de la Asignaci�n + Plural del Nombre del Tipo de Asignaci�n + + Nombre del Tipo de Asignaci�n + + Comentarios de los Tipos de Asignaci�n + + Distribuci�n de los Tipos de Asignaci�n + + + + + Descripci�n: + Asociar a este grupo + + Historial de notas de la tarea "%task_name%" + �Podr� entregarse tarde esta tarea? + Verificar el resto de las comunidades donde usted desea subir la asignaci�n tambi�n + Haga click aqu� para desadjuntar el archivo + + Haga click aqu� si desea ir a la pagina de administraci�n de grupos despu�s de subir la tarea + Haga click aqu� si desea agregar esta asignaci�n a varias clases o secciones + Haga click en la tarea que desea ser copiada por los grupos + + El numero de caracteres en la raz�n del comentario/edici�n en %party_id% es mayor a 4,000, nuestra longitud m�xima. Por favor haga la raz�n del comentario / edici�n mas corta. + + Confirmar su Evaluaci�n + Confirmar su(s) evaluacion(es) en "%task_name%" + + Actualmente este $content esta asociado a esta soluci�n, pero puede asociarlo a un url/archivo diferente solo con agregarlo aqu� + + Actualmente este $content esta asociado a esta tarea, pero puede asociarlo a un url/archivo diferente solo con agregarlo aqu� + Actualmente este $content esta asociado a esta soluci�n, pero puede adjuntar un url/archivo diferente solo con agregarlo aqu� + Actualmente este $content esta asociado a esta tarea, pero puede adjuntar un url/archivo diferente solo con agregarlo aqu� + Eliminar el Tipo de Asignaci�n + + Eliminar el tipo de asignaci�n + Distribuci�n de Notas +%grade_plural_name% + No cambie el campo "id" porque con este archivo se asocia la nota con el estudiante o grupo. + + La fecha de entrega debe de estar en el futuro + Editar Tipo de Asignaci�n + + Editar tipo de asignaci�n + Editar distribuci�n de notas de $grade_plural_name + + Ingrese las notas de los estudiantes/grupos y CONSERVE LA ESTRUCTURA del archivo. Si usted esta editando una nota, usted DEBE de dar una raz�n en el campo de "raz�n de Comentario/Edici�n". + Error al eliminar la evaluaci�n + + Error al eliminar la nota + Error al eliminar la tarea + Error al guardar el archivo + Evaluar Estudiantes (%total_evaluated%) + Primero debe de quitar el archio/url adjunto, luego subir otro o solo subir un nuevo archivo/url y dejar este en blanco + + Primero, usted encontrara una lista de estudiantes sin grupo (si hubieran estudiantes sin grupo) y puede crear un grupo seleccionando los miembros del grupo y haciendo click en el bot�n "Crear Grupo". + Genere el archivo csv del sistema. Este archivo tiene la estructura apropiada para que el sistema pueda reconocerlo y obtener la informaci�n acerca de las notas. Este archivo puede ser generado haciendo click en el link "Generar Archivo" + + + + La nota %grade% parece no ser un numero valido. + + + Nota sobre 100 puntos + %grade_plural_name% representa el %grade_weight%% del 100% de la clase + Ingresar notas usando el archivo generado: + + Ingresar notas usando el archivo generado: + Calificar con 0 (cero) + Reporte de Notas para $student_name + Reporte de notas para "%student_name%" + Hoja de Explicaci�n de Notas + + Administraci�n de grupo + Administraci�n de grupos + Grupos para la tarea %task_name% + Si usted administra mas de una comunidad y usted quiere subir una asignaci�n en mas de una comunidad, usted debe colocar el mismo nombre para cada uno de los tipos de asignaci�n en cada comunidad para que el sistema pueda identificar en donde guardar la asignaci�n. + Si usted hace click sobre el nombre del estudiante, usted vera el reporte de notas del estudiante. + Si usted no quiere evaluar o editar la nota de un estudiante o grupo, solo deje intacto los campos de esa fila, o puede eliminar la fila entera. + si usted no quiere ver las fotos de los estudiantes + si usted quiere bajar todas las respuestas en un solo archivo + si usted quiere ver las fotos de los estudiantes + Para generar este archivo deben de haber varios grupos\usuarios asignados a esta tarea. + En esta pagina usted puede administrar los grupos para la asignaci�n. + La entrada \"�Podr�n los estudiantes ver su nota?\" debe de ser 1 (uno) para SI o 0 (cero) para NO, por favor no lo deje en blanco. + + + �Van los estudiantes a enviar +las respuestas electr�nicamente? + La Nota M�xima parece no ser un numero valido. Por favor no la deje en blanco. + + No hay ning�n archivo/URL asociado a esta tarea + No hay ning�n archivo/URL asociado a la soluci�n de esta tarea + + No hay ning�n grupo para estudiante + No, quiero cancelar mi solicitud + + No hay foto para $party_name + No hay foto para $student_name + Notificaci�n para asignaciones + Notificaci�n para evaluaciones + Numero de miembros para esta tarea: + + N�mero de personas en el grupo: + sobre %grade_weight%% de %grade_plural_name% + El Id del usuario/grupo %party_id% no parece ser un numero entero. Por favor no modifique este campo. + + en la parte inferior de la p�gina +y haga click en OK. + Por favor ingrese el nombre del grupo + + Por favor ingrese el nuevo nombre del grupo + Por favor seleccione el grupo + + Proyectos para los estudiantes + No admitir grupos de otra asignaci�n + Guarde el archivo csv y MANTENGA EL FORMATO CSV. El archivo CSV puede ser editado con cualquier editor de texto (y MS Excell) pero tiene que mantener el formato CSV. Si usted no mantiene el formato, el sistema no ser� capaz de leer el archivo. + + Ver los cuadros de notas asociados a esta tarea + + Env�e el archivo utilizando el bot�n "Enviar archivo". El sistema leer� el archivo y preguntara por una confirmaci�n (si todo esta bien con el archivo) para las notas. + + + <small>Total de puntos en esta categoria: ${total_grade}/${max_grade} <br /> $grade_plural_name representan el ${grade_weight}% del 100% de la clase</small> + Estudiantes que NO han respondido: (%not_evaluated_with_no_answer%) + + Estudiantes No Evaluados: (%not_evaluated_with_answer%) + %submission_date_pretty% (tarde) + $submission_date_pretty <span style=\"color:red;\">(entregar tarde)</span> + La asignaci�n "%task_name%" ha sido subida en esta comunidad. + + La raz�n de comentarios/edici�n es una cadena de caracteres de no mas de 4,000 caracteres. + La raz�n de edici�n debe de ser menor a los 4,000 caracteres de largo + + La extensi�n del archivo \"$file_extension\" debe de ser .CSV, lo sentimos, no podemos procesarlo + El archivo es muy grande. (El tama�o m�ximo es de %pretty_maxnbytes% bytes) + El archivo debe de tener un formato predefinido para que el sistema pueda leerlo y obtener la informaci�n. Si usted desea utilizar esta herramienta debe de seguir los siguientes pasos: + La nota debe de ser un NUMERO VALIDO: %wrong_grade% + La nota debe de ser un NUMERO REAL. + La nota debe de ser un NUMERO VALIDO: %wrong_grade% + La nota debe de ser un numero valido + La suma de todos las asignaciones es %total_weight% y deber�a de ser 100 al final del curso (generalmente). + + + El sistema asume que las notas empiezan en la s�ptima fila del archivo. + No hay notas que editar + + No hay archivos asociados a esta tarea + + No hay notas para este grupo. + Todav�a no hay grupos para esta tarea. + No hay mas comunidades donde pueda agregar la tarea. + + No hay estudiantes asociados a este grupo. + + No hay estudiantes para evaluar que ya hayan respondido + + + No hay estudiantes para evaluar sin respuesta + + + No hay tareas asignados(as) + No hay tareas para este paquete. + + No hay tareas para este tipo de nota. + + + No hay tareas que evaluar para este paquete. + + Existe un comentario para una nota que no se ha tomado en cuenta: +%wrong_comments% + Existe un comentario mas grande del que podemos manejar: +%wrong_comments% + Existe un comentario mas grande del que podemos manejar: %wrong_comments% + Existe una raz�n de edici�n para una nota que no ha sido tomada en cuenta: +%wrong_comments% + Existe una raz�n de edici�n mas grande de la que podemos manejar: +%wrong_comments% + No hay historial de notas para esta tarea porque no hay estudiantes evaluados. + No hay notas en el archivo csv o no hay modificaciones en el archivo csv. + + No hay historial de notas para este estudiante. + No hay informaci�n para esta tarea. + + Debe de haber una raz�n de edici�n si desea editar la nota del usuario/grupo %party_id%. + + Debe de haber al menos una nota para poder trabajar + No deben de haber grupos en esta tarea para poder copiar los grupos de otra tarea. Usted puede regresar y borrar los grupos de esta tarea. + + Deben de haber algunos estudiantes seleccionados para poder crear el grupo. + + Hubo un problema al guardar el archivo. Por favor contacte al administrador. + <p>El error fue el siguiente: <pre>%errmsg%</pre></li> + Hubo un error al crear los grupos + + Estos son los cuadros de notas utilizados para evaluar los estudiantes de esta tarea. + + Estos son los estudiantes que ya respondieron pero que no han sido evaluados. + Estos son los estudiantes que no han respondido (si la tarea se puede entregar electr�nicamente) y no han sido evaluados. + Esta funcionalidad le permite subir un archivo CSV (Comm Separated Value) con las notas de los estudiantes. Este archivo CSV puede ser editado con MS Excell y con otros editores de texto. + + Este es el reporte de notas de los estudiantes de acuerdo a las asignaciones/evaluaciones que usted hizo. + Este es el reporte de notas de los estudiantes de acuerdo a un tipo de asignaci�n y a las evaluaciones que usted hizo en este tipo de asignaci�n. + + + Esta tarea no se puede entregar tarde + + Esta tarea no es grupos + + Este fue un error: + <blockquote> + <pre>%errmsg%</pre> + </blockquote> + Si desea agregar asignaciones en varias clases o secciones seleccione la opci�n que se encuentra + Para cambiar el nombre, edite el nombre en la entrada del texto y luego haga click en el bot�n "Renombrar Grupo". + + Para eliminar el grupo, haga click en el bot�n "Borrar Grupo" + �para entregar las respuestas despu�s de la fecha de entrega? + Para desasociar a un miembro del grupo, haga click en el link de "Desasociar miembro" + + NOTA TOTAL: %total_class_grade% + Total de puntos en esta categor�a: %total_grade% / $max_grade<br /> + Esta categor�a de nota representa el ${grade_weight}% del 100% de la clase + Total de puntos en esta categor�a: %total_grade% / $max_grade<br /> + Esta categor�a de nota representa el %grade_weight%% del 100% de la clase + Total de puntos en esta categor�a: %total_grade%/%max_grade% + Desasociar estudiante de este grupo + + Valor no reconocido para notif type: %$notif_type%. Los valores posibles son +one_assignment_notif and one_evaluation_notif. + + + Subir un archivo O un URL, pero no ambos + + Subir un archivo O un URL, pero no ambos + Subir un archivo O un URL, pero no ambos + Subir una soluci�n para esta asignaci�n para que los estudiantes puedan verla y aprender de ella. + user_name ha modificado el %party_name%. \n La raz�n de edici�n dada por %user_name% fue: %edit_reason% \n La nota actual es: %current_grade% \n\n Haga click en este link para ver los detalles de la evaluaci�n: %url_link% \n + + Ver/Editar Soluci�n de la Tarea + Hubo un error al tratar de eliminar la evaluaci�n: +<pre>%errmsg%</pre> + Hubo un error al tratar de eliminar la nota: +<pre>%errmsg%</pre> + Hubo un error al tratar de eliminar la tarea: +<pre>%errmsg%</pre> + La ponderaci�n debe de ser un numero real entre 0 y 100 + La ponderaci�n utilizada en $grade_plural_name es: ${category_weight}% (del 100% de $grade_plural_name) <br /> + $grade_plural_name representan el ${grade_weight}% del 100% de la clase + La ponderaci�n utilizada en $grade_plural_name es: ${category_weight}% (del 100% de $grade_plural_name) <br /> + $grade_plural_name representan el ${grade_weight}% del 100% de la clase + La ponderaci�n utilizada en $grade_plural_name es: ${category_weight}% (del 100% de $grade_plural_name) <br /> + $grade_plural_name representan el ${grade_weight}% del 100% de la clase + �Podr� el estudiante ver su nota? (1 = Si / 0 = No): + �Podr� el estudiante ver su nota? + Podr�n los estudiantes + �Ser� %grade_name% enviada electr�nicamente? + �Van los estudiantes a enviar +las respuestas electr�nicamente? + �Tendr� nota +esta tarea? + Si, realmente deseo eliminar esta evaluaci�n + + Si, realmente deseo eliminar esta nota + Si, realmente deseo eliminar este grupo + Si, realmente deseo eliminar esta tarea + Usted tambi�n puede agregar un estudiante a un grupo haciendo click en el link "Asociar a grupo...". Ah� se le preguntara el grupo al que desea agregar el usuario. + + Usted puede asociar un link a esta asignaci�n introduciendo el url aqu� (opcional) + Usted puede ordenar el reporte de notas por el nombre del estudiante, por el total de la nota, o por el tipo de asignaci�n, o ver los detalles del tipo de asignaci�n haciendo click en el icono a la izquierda del nombre del tipo de asignaci�n. + + + Usted puede ordenar el reporte de notas por el nombre del estudiante, por el total de la nota, o por el tipo de asignaci�n. + Usted puede ver los archivos csv asociados a esta tarea haciendo click en el bot�n "Ver cuadros de notas asociados a esta tarea". + + + Usted puede subir un archivo asociado a esta tarea utilizando el bot�n browse (opcional) + Utilice el bot�n "Browse..." para localizar su archivo explorando, luego haga click en "Abrir". (opcional) + Usted debe de dar una raz�n de edici�n (%old_grade% --> %grade_wo_reason% + + El total de su nota es de: + + Nota M�xima: + Nota M�xima: + Miembros + Por + n/a + Nombre: + T�tulo + Nombre: %student_name% + Valor neto + (NUEVA respuesta) + Nueva Asignaci�n + Nuevo Grupo + No + No + (No hay datos) + No hay grupo para la tarea + Numero de Miembros + Numero de Miembros + No hay ususarios/grupos para evaluar + Sin responder + Sin responder + No disponible + Sin evaluar + Numero de Integrantes + N�mero de personas en el grupo: + Una asignaci�n + Una evaluaci�n + Un Tipo de Nota + Un Grupo + Enviar Electr�nicamente + y entonces + Proyectos + Eliminar Nota + Grupo + Hacer "sin punteo" + Bloquear Grupos + Adjunto de la Soluci�n + Lista de Estudiantes + Lista de Estudiantes + Nombre del Estudiante + Lista de Estudiantes + Foto del Estudiante + Fecha de Entrega + entregar + re-entregar + Fecha de Entrega + Lista de Grupos + T�tulo: + T�tulo: + T�tulo: + Soluci�n + Estado de la Tarea + Tareas + Tareas para los estudiantes + Lista de Tareas + Total + Nota total actual: + Nota Total + Total de Miembros + Desasociar miembro + �Desasociar url? + �Remover el archivo adjunto? + Enviar Respuesta + Fecha de Env�o + Enviar Soluci�n + + Subido por + (URL) + o URL: + Ver respuesta + Ver comentarios + Ver evaluaci�n + Ver cuadro de notas + Ver mi respuesta + Ver NUEVA respuesta + Ver Tarea + Ver tarea + Ver/Editar Evaluaci�n + Ver/Editar Soluci�n + Fracci�n de nota: + Fracci�n de nota: + Podr�(n) el estudiante(s) + S� + S� + Index: openacs-4/packages/evaluation/lib/evaluations-chunk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/evaluations-chunk.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/lib/evaluations-chunk.tcl 10 Jun 2004 21:08:52 -0000 1.4 +++ openacs-4/packages/evaluation/lib/evaluations-chunk.tcl 15 Jun 2004 23:20:29 -0000 1.5 @@ -97,11 +97,12 @@ set grade "[_ evaluation.Not_evaluated_]" } + set task_weight "${over_weight}[format %.2f [lc_numeric $task_weight]]" set max_grade [expr $task_weight + $max_grade] } else { set grade "[_ evaluation.Not_available_]" + set task_weight "[_ evaluation.Not_available_]" } - set task_weight "${over_weight}[format %.2f [lc_numeric $task_weight]]" # working with answer stuff (if it has a file/url attached) if { [empty_string_p $answer_data] } { @@ -129,6 +130,6 @@ if { $admin_p } { set bottom_line "[_ evaluation.lt_Weight_used_in_grade__2]" } else { - set bottom_line "[_ evaluation.lt_Total_points_in_this__1]" + set bottom_line "[_ evaluation.lt_smallTotal_points_in_]" } Index: openacs-4/packages/evaluation/lib/student-grades-report-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/student-grades-report-chunk-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/lib/student-grades-report-chunk-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,103 @@ + + + + postgresql7.4 + + + + + select et.task_name, et.number_of_members, et.task_id, + to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, + et.online_p, + et.late_submit_p, + et.item_id, + et.requires_grade_p, et.description, et.grade_id, + cr.content_length, + et.data as task_data, + et.title as task_title, + et.task_id as revision_id, + ets.solution_id as solution_id + from cr_revisions cr, + evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) + where cr.revision_id = et.revision_id + and grade_id = :grade_id + and content_revision__is_live(et.task_id) = true + $assignments_orderby + + + + + + + + select et.task_name, et.number_of_members, et.task_id, + to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, +` et.online_p, + et.late_submit_p, + et.item_id, + et.due_date, + et.requires_grade_p, + et.description, + et.grade_id, + et.title as task_title, + et.data as task_data, + et.task_id as revision_id, + cr.content_length, + ea.answer_id as answer_id + from cr_revisions cr, + evaluation_tasksi et left outer join evaluation_answersi ea on (ea.task_id = et.task_id and content_revision__is_live(ea.answer_id) = true + and ea.party_id = evaluation__party_id(:user_id,et.task_id)) + where cr.revision_id = et.revision_id + and grade_id = :grade_id + and content_revision__is_live(et.task_id) = true + $assignments_orderby + + + + + + + + select evaluation__party_id(:student_id,:task_id) + + + + + + + + + select et.task_name, + ese.grade, + ese.description as comments, + (et.weight*eg.weight)/100 as task_weight, + (ese.grade*et.weight*eg.weight)/10000 as net_grade, + et.number_of_members, + to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, + et.task_id, + et.online_p, + ea.answer_id, + person__name(ese.creation_user) as grader_name + from evaluation_grades eg, + evaluation_tasks et2 left outer join evaluation_student_evalsi ese on (ese.task_id = et2.task_id and content_revision__is_live(ese.evaluation_id) = true + and ese.party_id = evaluation__party_id(:student_id,et2.task_id)), + evaluation_tasks et left outer join evaluation_answersi ea on (ea.task_id = et.task_id and content_revision__is_live(ea.answer_id) = true + and ea.party_id = evaluation__party_id(:student_id,et.task_id)) + where eg.grade_id = :grade_id + and eg.grade_id = et.grade_id + and et.task_id = et2.task_id + and content_revision__is_live(et.task_id) = true + and content_revision__is_live(eg.grade_id) = true + + + + + + + + select acs_group__name(:group_id) + + + + + Index: openacs-4/packages/evaluation/lib/student-grades-report-chunk.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/student-grades-report-chunk.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/lib/student-grades-report-chunk.adp 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,7 @@ + +
+ +

#evaluation.lt_Total_points_in_this__2#
+ #evaluation.lt_grade_plural_name_rep#

+
+ Index: openacs-4/packages/evaluation/lib/student-grades-report-chunk.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/student-grades-report-chunk.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/lib/student-grades-report-chunk.tcl 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,128 @@ +ad_page_contract { + + task chunk to be displayed in the index page + +} + +db_1row grade_names { *SQL* } +set package_id [ad_conn package_id] +set base_url [ad_conn package_url] + +set mode display +set return_url "[ad_conn url]?[export_vars { grade_id }]" + +db_1row grade_info { *SQL* } + +set elements [list task_name \ + [list label "[_ evaluation.Task_Name_]" \ + orderby_asc {task_name asc} \ + orderby_desc {task_name desc}] \ + task_status \ + [list label "[_ evaluation.Task_Status_]" \ + ] \ + due_date_pretty \ + [list label "[_ evaluation.Due_date_]" \ + orderby_asc {due_date_ansi asc} \ + orderby_desc {due_date_ansi desc}] \ + grade \ + [list label "[_ evaluation.lt_Grade_over_100_points]" \ + orderby_asc {grade asc} \ + orderby_desc {grade desc}] \ + net_grade \ + [list label "[_ evaluation.Grade_in_Net_value_]" \ + orderby_asc {net_grade asc} \ + orderby_desc {net_grade desc}] \ + online_p \ + [list label "[_ evaluation.Online_Submit_]" \ + orderby_asc {online_p asc} \ + orderby_desc {online_p desc}] \ + assignment_group \ + [list label "[_ evaluation.Assignment_Group_]" \ + orderby_asc {assignment_group asc} \ + orderby_desc {assignment_group desc}] \ + grader_name \ + [list label "[_ evaluation.Grader_]" \ + orderby_asc {grader_name asc} \ + orderby_desc {grader_name desc}] \ + comments \ + [list label "[_ evaluation.Comments_]" \ + orderby_asc {comments asc} \ + orderby_desc {comments desc}] \ + ] + +template::list::create \ + -name student_grades \ + -multirow student_grades \ + -pass_properties { return_url base_url } \ + -filters { grade_id {} student_id {} } \ + -elements $elements \ + -orderby_name orderby \ + -orderby { default_value task_name } + +set orderby [template::list::orderby_clause -orderby -name student_grades] + +if {[string equal $orderby ""]} { + set assignments_orderby " order by task_name asc" +} + +set max_weight 0.00 +set max_grade 0.00 +set total_grade 0.00 + +db_multirow -extend { task_status due_date_pretty assignment_group } student_grades get_student_grades { *SQL* } { + + set due_date_pretty [lc_time_fmt $due_date_ansi "%q"] + + if { $online_p } { + set online_p "[_ evaluation.Yes_]" + } else { + set online_p "[_ evaluation.No_]" + } + + if { [empty_string_p $comments] } { + set comments "[_ evaluation.na_]" + } + + set over_weight "" + set task_status "" + + # working with answer stuff (if it has a file/url attached) + if { [empty_string_p $answer_id] } { + append task_status " [_ evaluation.Not_answered_] " + } else { + append task_status " [_ evaluation.Already_answered_] " + } + + if { ![empty_string_p $grade] } { + set grade [format %.2f [lc_numeric $grade]] + set over_weight "[format %.2f [lc_numeric $net_grade]]/" + set total_grade [expr $total_grade + $net_grade] + set net_grade [format %.2f [lc_numeric $net_grade]] + set task_status "[_ evaluation.Evaluated_]" + } else { + set neg_grade "[_ evaluation.na_]" + set grade "[_ evaluation.na_]" + set grader "[_ evaluation.na_]" + append task_status " [_ evaluation.Not_evaluated_] " + } + + set max_grade [expr $task_weight + $max_grade] + + set task_weight "${over_weight}[format %.2f [lc_numeric $task_weight]]" + + set group_id [db_string get_group_id { *SQL* }] + if { $number_of_members > 1 } { + if { [string eq $group_id 0] } { + set task_status "[_ evaluation.lt_No_group_for_student_]" + set assignment_group " [_ evaluation.na_] " + } else { + set assignment_group [db_string group_name { *SQL* }] + } + } else { + set assignment_group "[_ evaluation.Individual_]" + } + +} + +set max_grade [format %.2f [lc_numeric $max_grade]] +set grade_weight [format %.2f [lc_numeric $grade_weight]] \ No newline at end of file Index: openacs-4/packages/evaluation/lib/student-grades-report-chunk.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/student-grades-report-chunk.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/lib/student-grades-report-chunk.xql 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,24 @@ + + + + + + + + select eg.weight as grade_weight, + eg.grade_plural_name + from evaluation_grades eg + where eg.grade_id = :grade_id + + + + + + + + select grade_name, grade_plural_name from evaluation_grades where grade_id = :grade_id + + + + + Index: openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/tasks-chunk-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql 10 Jun 2004 21:08:52 -0000 1.4 +++ openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.5 @@ -66,7 +66,7 @@ - select grade_name, grade_plural_name, grade_name from evaluation_grades where grade_id = :grade_id + select grade_plural_name, grade_name from evaluation_grades where grade_id = :grade_id Index: openacs-4/packages/evaluation/tcl/evaluation-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs-postgresql.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/evaluation/tcl/evaluation-procs-postgresql.xql 10 Jun 2004 21:08:53 -0000 1.6 +++ openacs-4/packages/evaluation/tcl/evaluation-procs-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.7 @@ -570,8 +570,8 @@ :creation_user, :package_id, :creation_ip, - 'Exams', - 'Exams for students', + :exams_name, + :exams_desc, 'text/plain', null, null, @@ -597,7 +597,7 @@ :creation_user, :creation_ip, :exams_revision_name, - 'Exams for students', + :exams_desc, now(), --publish date null, --nls_language 'text/plain' --mime_type @@ -625,8 +625,8 @@ :creation_user, :package_id, :creation_ip, - 'Projects', - 'Projects for students', + :projects_name, + :projects_desc, 'text/plain', null, null, @@ -652,7 +652,7 @@ :creation_user, :creation_ip, :projects_revision_name, - 'Projects for students', + :projects_desc, now(), --publish date null, --nls_language 'text/plain' --mime_type @@ -681,8 +681,8 @@ :creation_user, :package_id, :creation_ip, - 'Tasks', - 'Tasks for students', + :tasks_name, + :tasks_desc, 'text/plain', null, null, @@ -708,7 +708,7 @@ :creation_user, :creation_ip, :tasks_revision_name, - 'Tasks for students', + :tasks_desc, now(), --publish date null, --nls_language 'text/plain' --mime_type Index: openacs-4/packages/evaluation/tcl/evaluation-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs.tcl,v diff -u -r1.7 -r1.8 --- openacs-4/packages/evaluation/tcl/evaluation-procs.tcl 10 Jun 2004 21:08:53 -0000 1.7 +++ openacs-4/packages/evaluation/tcl/evaluation-procs.tcl 15 Jun 2004 23:20:29 -0000 1.8 @@ -42,6 +42,31 @@ } } +ad_proc -public evaluation::get_user_portrait { + -user_id:required + {tag_attributes ""} +} { + returns the portrait for the given user or a default portrait if not found. +} { + + if { [db_0or1row user_portrait { *SQL* }] } { + set output "" + return $output +} + ad_proc -public evaluation::notification::do_notification { -task_id:required -package_id:required @@ -668,6 +693,12 @@ Helper for the apm_proc } { db_transaction { + set exams_name "[_ evaluation.Exams_]" + set exams_desc "[_ evaluation.Exams_for_students_]" + set tasks_name "[_ evaluation.Tasks_]" + set tasks_desc "[_ evaluation.Tasks_for_students_]" + set projects_name "[_ evaluation.Projects_]" + set projects_desc "[_ evaluation.lt_Projects_for_students]" db_exec_plsql create_evaluation_folders { *SQL* } set creation_user [ad_verify_and_get_user_id] Index: openacs-4/packages/evaluation/tcl/evaluation-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/tcl/evaluation-procs.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/tcl/evaluation-procs.xql 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,17 @@ + + + + + + + + select c.item_id + from acs_rels a, cr_items c + where a.object_id_two = c.item_id + and a.object_id_one = :user_id + and a.rel_type = 'user_portrait_rel' + + + + + Index: openacs-4/packages/evaluation/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/index-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/index-postgresql.xql 7 Jun 2004 16:05:07 -0000 1.2 +++ openacs-4/packages/evaluation/www/index-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.3 @@ -17,4 +17,13 @@ + + + + select evaluation__class_total_grade(:user_id,:package_id) + + + + + Index: openacs-4/packages/evaluation/www/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/index.tcl,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation/www/index.tcl 10 Jun 2004 21:08:53 -0000 1.5 +++ openacs-4/packages/evaluation/www/index.tcl 15 Jun 2004 23:20:29 -0000 1.6 @@ -20,13 +20,11 @@ set admin_p [permission::permission_p -party_id $user_id -object_id $package_id -privilege admin] -set package_id [ad_conn package_id] - db_multirow grades get_grades { *SQL* } { } -set total_class_grade [format %.2f [lc_numeric [db_string get_total_grade "select evaluation__class_total_grade(:user_id,:package_id)"]]] +set total_class_grade [format %.2f [lc_numeric [db_string get_total_grade { *SQL* }]]] set notification_chunk [notification::display::request_widget \ -type one_assignment_notif \ Index: openacs-4/packages/evaluation/www/task-view-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/task-view-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/evaluation/www/task-view-postgresql.xql 7 Jun 2004 16:05:07 -0000 1.3 +++ openacs-4/packages/evaluation/www/task-view-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.4 @@ -12,16 +12,28 @@ et.description, et.title as task_title, et.data as task_data, + et.revision_id as task_revision_id, ets.title as solution_title, ets.data as solution_data, eg.grade_plural_name, eg.weight as grade_weight, - ets.revision_id - from evaluation_grades eg, evaluation_tasksi et - left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) + ets.revision_id as solution_revision_id + from evaluation_grades eg, + evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) where et.task_id = :task_id and et.grade_id = eg.grade_id + + + + select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, + et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p + from evaluation_tasksi et + where task_id = :task_id + + + + Index: openacs-4/packages/evaluation/www/task-view.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/task-view.adp,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/task-view.adp 10 Jun 2004 21:08:53 -0000 1.4 +++ openacs-4/packages/evaluation/www/task-view.adp 15 Jun 2004 23:20:29 -0000 1.5 @@ -2,51 +2,8 @@ @page_title;noquote@ @context;noquote@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +

- -
#evaluation.Task_Name_1# - @task_name@
#evaluation.Description# - @description;noquote@
#evaluation.Due_Date_1# - @due_date@
#evaluation.Fileurl_associated# - @task_url@
#evaluation.Number_of_Integrants# - @number_of_members@
#evaluation.Weight# - @weight@%
#evaluation.Grades_Category# - @grade_plural_name@ - @grade_weight@%
#evaluation.lt_Will_this_task_be_sub# - @online_p@
#evaluation.lt_Will_the_students_be_#
#evaluation.lt_to_submit_their_answe#
- @late_submit_p@
#evaluation.Task_Solution# - @solution_url;noquote@
-

#evaluation.Go_Back#

Index: openacs-4/packages/evaluation/www/task-view.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/task-view.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/task-view.tcl 10 Jun 2004 21:08:53 -0000 1.4 +++ openacs-4/packages/evaluation/www/task-view.tcl 15 Jun 2004 23:20:29 -0000 1.5 @@ -8,8 +8,7 @@ @cvs-id $Id$ } { grade_id:integer,notnull - task_id:integer,notnull,optional - item_id:integer,notnull,optional + task_id:integer,notnull {return_url ""} } @@ -22,39 +21,108 @@ db_1row get_task_info { *SQL* } -set weight [format %.2f [lc_numeric $weight]] +ad_form -name task -has_submit 1 -has_edit 1 -export { return_url item_id storage_type grade_id attached_p } -mode display -form { -if { [string eq $online_p "1"] || [string eq $online_p "t"] } { - set online_p "[_ evaluation.Yes_]" -} else { - set online_p "[_ evaluation.No_]" -} + task_id:key -if { [string eq $late_submit_p "1"] || [string eq $late_submit_p "t"]} { - set late_submit_p "[_ evaluation.Yes_]" -} else { - set late_submit_p "[_ evaluation.No_]" + {task_name:text + {label "[_ evaluation.Task_Name_]"} + {html {size 30}} + } + } +db_1row get_task_info { *SQL* } -#set description [template::util::richtext::get_property contents $description] -# working with task stuff (if it has a file/url attached) -if { [empty_string_p $task_data] } { - set task_url "[_ evaluation.lt_No_fileurl_associated]" -} elseif { [regexp "http://" $task_data] } { - set task_url "$task_data" -} else { +if { ![empty_string_p $task_data] } { + + if { [regexp "http://" $task_data] } { + set task_url "$task_data" + } else { # we assume it's a file - set task_url "$task_title" + set task_url "$task_title" + } + + ad_form -extend -name task -form { + {task_file:text,optional + {label "[_ evaluation.lt_Assignment_Attachment]"} + {html "size 30"} + {after_html "$task_url"} + } + } } -# working with task soluiton stuff (if it has a file/url attached) -if { [empty_string_p $solution_data] } { - set solution_url "[_ evaluation.lt_No_fileurl_associated_1]" -} elseif { [regexp "http://" $solution_data] } { - set solution_url "$solution_data" -} else { +if { ![empty_string_p $solution_data] } { + + if { [regexp "http://" $solution_data] } { + set solution_url "$solution_data" + } else { # we assume it's a file - set solution_url "$solution_title" + set solution_url "$solution_title" + } + + ad_form -extend -name task -form { + {solution_file:text,optional + {label "[_ evaluation.Solution_Attachment_]"} + {html "size 30"} + {after_html "$solution_url"} + } + } } +ad_form -extend -name task -form { + + {description:richtext,optional + {label "[_ evaluation.lt_Assignments_Descripti]"} + {html {rows 4 cols 40 wrap soft}} + } + + {due_date:date,to_sql(linear_date),from_sql(sql_date) + {label "[_ evaluation.Due_Date_]"} + {format "MONTH DD YYYY"} + {today} + {help} + {value {[evaluation::now_plus_days -ndays 15]}} + } + + {number_of_members:naturalnum + {label "[_ evaluation.Number_of_Members_]"} + {value "1"} + {html {size 5 onChange TaskInGroups()}} + {help_text "[_ evaluation.1__Individual_]"} + } + + {weight:float + {label "[_ evaluation.Weight_]"} + {html {size 5}} + {help_text "[_ evaluation.lt_over_grade_weight_of_]"} + } + + {online_p:text(radio) + {label "[_ evaluation.lt_Will_the_task_be_subm]"} + {options {{"[_ evaluation.Yes_]" t} {"[_ evaluation.No_]" f}}} + {value t} + } + + {late_submit_p:text(radio) + {label "[_ evaluation.lt_Can_the_student_submi]"} + {options {{"[_ evaluation.Yes_]" t} {"[_ evaluation.No_]" f}}} + {value t} + } + + {requires_grade_p:text(radio) + {label "[_ evaluation.lt_Will_this_task_requir]"} + {options {{"[_ evaluation.Yes_]" t} {"[_ evaluation.No_]" f}}} + {value t} + } +} -edit_request { + + db_1row task_info { *SQL* } + + set due_date [template::util::date::from_ansi $due_date_ansi] + set weight [format %.2f [lc_numeric $weight]] + +} + ad_return_template + + Index: openacs-4/packages/evaluation/www/task-view.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/task-view.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/task-view.xql 7 Jun 2004 16:05:07 -0000 1.2 +++ openacs-4/packages/evaluation/www/task-view.xql 15 Jun 2004 23:20:29 -0000 1.3 @@ -5,7 +5,7 @@ - select grade_plural_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id + select grade_name, grade_plural_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id Index: openacs-4/packages/evaluation/www/admin/evaluations/audit-info.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/audit-info.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/evaluations/audit-info.adp 10 Jun 2004 21:08:53 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/evaluations/audit-info.adp 15 Jun 2004 23:20:29 -0000 1.3 @@ -13,8 +13,9 @@ -There is no audit info for this task because there are no students evaluated. +#evaluation.lt_There_is_no_audit_inf# + Index: openacs-4/packages/evaluation/www/admin/evaluations/evaluation-delete.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/evaluation-delete.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/evaluations/evaluation-delete.adp 10 Jun 2004 21:08:53 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/evaluations/evaluation-delete.adp 15 Jun 2004 23:20:29 -0000 1.3 @@ -13,4 +13,3 @@

-[_ evaluation.lt_No_I_want_to_cancel_m] Index: openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.tcl 10 Jun 2004 21:08:53 -0000 1.4 +++ openacs-4/packages/evaluation/www/admin/evaluations/grades-sheet-parse.tcl 15 Jun 2004 23:20:29 -0000 1.5 @@ -16,142 +16,178 @@ csv_type_p { set file_extension [file extension $upload_file] if { [string compare [string tolower $file_extension] ".csv"] } { - ad_complain "[_ evaluation.lt_The_file_extension_of]" + ad_complain "[_ evaluation.lt_The_file_extension_of_1]" + } + } +} + +set page_title "[_ evaluation.Confirm_Evaluation_]" + set context [list [list "[export_vars -base student-list { task_id }]" "[_ evaluation.Studen_List_]"] "[_ evaluation.Confirm_Evaluation_]"] # Getting some info from the db about the task if ![db_0or1row get_task_info { *SQL* }] { - # This should never happen. - ad_return_complaint 1 "
  • [_ evaluation.lt_There_is_no_informati]
  • " - return - } + # This should never happen. + ad_return_complaint 1 "
  • [_ evaluation.lt_There_is_no_informati]
  • " + return +} set evaluations_gs:rowcount 0 # Double-click protection if { ![db_string file_exists { *SQL* }] } { - + set max_n_bytes [parameter::get -parameter MaxNumberOfBytes] set tmp_filename [ns_queryget upload_file.tmpfile] if { ![empty_string_p $max_n_bytes] && ([file size "$tmp_filename"] > $max_n_bytes) } { set pretty_maxnbytes [lc_numeric $max_n_bytes] - ad_return_complaint 1 "[_ evaluation.lt_The_file_is_too_large]" "[_ evaluation.lt_Max_Grade_does_not_se]" - return - } - continue - } elseif { $line_number == 4 } { - set see_comments_p [string trim [string tolower [lindex $evaluation 1]]] - # removing the first and last " that comes from the csv format - regsub ^\" $see_comments_p "" see_comments_p - regsub \"\$ $see_comments_p "" see_comments_p - if { ![string eq $see_comments_p 1] && ![string eq $see_comments_p 0] } { - ad_return_error "[_ evaluation.Bad_input_]" "[_ evaluation.lt_Input_Will_the_studen]" - return - } elseif { [string eq $see_comments_p 1] } { - set comments_p "t" - } else { - set comments_p "f" - } - continue - } elseif { $line_number <= 6 } { - continue - } - - set party_id [string trim [lindex $evaluation 0]] - set party_name [db_string get_party_name { *SQL* }] - set grade [string trim [lindex $evaluation 2]] - set comments [string trim [lindex $evaluation 3]] - - # removing the first and last " that comes from the csv format - regsub ^\" $comments "" comments - regsub \"\$ $comments "" comments - - if { [empty_string_p $party_id] && [empty_string_p $grade] && [empty_string_p $comments] } { - # "blank" line, skip it - continue - } - - if { ![empty_string_p $grade] } { - # start validations - if { ![ad_var_type_check_integer_p $party_id] } { - incr errors - append errors_text "
  • [_ evaluation.lt_Party_id_party_id_doe]
  • " - } - - if { ![ad_var_type_check_number_p $grade] } { - incr errors - append errors_text "
  • [_ evaluation.lt_Grade_grade_does_not_]
  • " - } - - if { [string length $comments] > 4000 } { - incr errors - append errors_text "
  • [_ evaluation.lt_Commentedit_reason_on]
  • " - } + ad_return_complaint 1 "[_ evaluation.lt_The_file_is_too_large_1]" + return 0 + } - # editing without reason - if { ![string eq [format %.2f [db_string check_evaluated { *SQL* } -default $grade]] [format %.2f $grade]] && [empty_string_p $comments] } { - incr errors - append errors_text "
  • [_ evaluation.lt_There_must_be_an_edit]
  • " - } - - if { $errors } { - ad_return_complaint $errors $errors_text - ad_script_abort - return - } - - if { ![empty_string_p $comments] } { - if { [db_string verify_grade_change { *SQL* } -default 0] } { - # there is no change, skip it - continue - } - } else { - if { [db_string verify_grade_change_wcomments { *SQL* } -default 0] } { - # there is no change, skip it - continue - } - } - - # validation checked, prepare data structures for next page - incr counter + set errors 0 + set errors_text "" + set counter 0 - set grades_gs($party_id) $grade - set comments_gs($party_id) $comments - set show_student_gs($party_id) $comments_p + set line_number 0 + + set file_handler [open $tmp_filename {RDWR}] + + while { ![eof $file_handler] } { + incr line_number + set one_line [gets $file_handler] + + # jump first two lines + if { $line_number <= 2 } { + continue + } + + # replace enters (<-|) with semicolons (;) + regsub -all {(,[\r\n])} $one_line "" clean_line + regsub -all {[\r\n]} $clean_line "" clean_line + + set evaluation [split $clean_line ","] + + if { $line_number == 3 } { + set max_grade [string trim [lindex $evaluation 1]] + if { ![ad_var_type_check_number_p $max_grade] } { + ad_return_error "Invalid Max Grade" "Max Grade does not seem to be a real number. Please don't leave it blank." + return + } + continue + } elseif { $line_number == 4 } { + set see_comments_p [string trim [string tolower [lindex $evaluation 1]]] + # removing the first and last " that comes from the csv format + regsub ^\" $see_comments_p "" see_comments_p + regsub \"\$ $see_comments_p "" see_comments_p + if { ![string eq $see_comments_p 1] && ![string eq $see_comments_p 0] } { + ad_return_error "[_ evaluation.Bad_input_]" "[_ evaluation.lt_Input_Will_the_studen]" + return + } elseif { [string eq $see_comments_p 1] } { + set comments_p "t" + } else { + set comments_p "f" + } + continue + } elseif { $line_number <= 6 } { + continue + } + + set party_id [string trim [lindex $evaluation 0]] + set party_name [db_string get_party_name { *SQL* }] + set grade [string trim [lindex $evaluation 2]] + set comments [string trim [lindex $evaluation 3]] + + # removing the first and last " that comes from the csv format + regsub ^\" $comments "" comments + regsub \"\$ $comments "" comments + + if { [empty_string_p $party_id] && [empty_string_p $grade] && [empty_string_p $comments] } { + # "blank" line, skip it + continue + } + + if { ![empty_string_p $grade] } { + # start validations + if { ![ad_var_type_check_integer_p $party_id] } { + incr errors + append errors_text "
  • [_ evaluation.lt_Party_id_party_id_doe]
  • " + } + + if { ![ad_var_type_check_number_p $grade] } { + incr errors + append errors_text "
  • [_ evaluation.lt_Grade_grade_does_not_]
  • " + } + + if { [string length $comments] > 4000 } { + incr errors + append errors_text "
  • [_ evaluation.lt_Commentedit_reason_on]
  • " + } - set evaluations_gs:${counter}(rownum) $counter - set evaluations_gs:${counter}(party_name) $party_name - set evaluations_gs:${counter}(grade) $grade - set evaluations_gs:${counter}(comment) $comments - if { [string eq $comments_p "t"] } { - set evaluations_gs:${counter}(show_student) "[_ evaluation.Yes_]" - } else { - set evaluations_gs:${counter}(show_student) "[_ evaluation.No_]" - } + # editing without reason + if { ![string eq [format %.2f [db_string check_evaluated { *SQL* } -default $grade]] [format %.2f $grade]] && [empty_string_p $comments] } { + incr errors + append errors_text "
  • [_ evaluation.lt_There_must_be_an_edit]
  • " + } + + if { $errors } { + ad_return_complaint $errors $errors_text + ad_script_abort + return + } + + if { ![empty_string_p $comments] } { + if { [db_string verify_grade_change { *SQL* } -default 0] } { + # there is no change, skip it + continue + } + } else { + if { [db_string verify_grade_change_wcomments { *SQL* } -default 0] } { + # there is no change, skip it + continue + } + } + + # validation checked, prepare data structures for next page + incr counter - set evaluation_id [db_string editing_p { *SQL* } -default 0] - if { $evaluation_id } { - set item_ids($party_id) [db_string get_item_id { *SQL* }] - set new_p_gs($party_id) 0 - } else { - set item_ids($party_id) [db_nextval acs_object_id_seq] - set new_p_gs($party_id) 1 - } + set grades_gs($party_id) $grade + set comments_gs($party_id) $comments + set show_student_gs($party_id) $comments_p - } + set evaluations_gs:${counter}(rownum) $counter + set evaluations_gs:${counter}(party_name) $party_name + set evaluations_gs:${counter}(grade) $grade + set evaluations_gs:${counter}(comment) $comments + if { [string eq $comments_p "t"] } { + set evaluations_gs:${counter}(show_student) "[_ evaluation.Yes_]" + } else { + set evaluations_gs:${counter}(show_student) "[_ evaluation.No_]" + } + + set evaluation_id [db_string editing_p { *SQL* } -default 0] + if { $evaluation_id } { + set item_ids($party_id) [db_string get_item_id { *SQL* }] + set new_p_gs($party_id) 0 + } else { + set item_ids($party_id) [db_nextval acs_object_id_seq] + set new_p_gs($party_id) 1 + } + } - set evaluations_gs:rowcount $counter - set export_vars [export_vars -form { task_id max_grade grades_gs comments_gs show_student_gs item_ids new_p_gs grades_sheet_item_id tmp_filename upload_file }] + } + set evaluations_gs:rowcount $counter + set export_vars [export_vars -form { task_id max_grade grades_gs comments_gs show_student_gs item_ids new_p_gs grades_sheet_item_id tmp_filename upload_file }] - # writing the file in the file system so we can work with it later - flush $file_handler - close $file_handler + # writing the file in the file system so we can work with it later + flush $file_handler + close $file_handler if [catch {exec mv $tmp_filename "${tmp_filename}_grades_sheet"} errmsg] { - ad_return_error "[_ evaluation.lt_Error_while_storing_f]" "[_ evaluation.lt_There_was_a_problem_s]" - ad_script_abort + ad_return_error "[_ evaluation.lt_Error_while_storing_f]" "[_ evaluation.lt_There_was_a_problem_s]" + ad_script_abort } } Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list.adp,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/admin/evaluations/student-list.adp 10 Jun 2004 21:08:53 -0000 1.4 +++ openacs-4/packages/evaluation/www/admin/evaluations/student-list.adp 15 Jun 2004 23:20:29 -0000 1.5 @@ -12,13 +12,13 @@ @due_date_pretty@ - Is the task submitted online? + #evaluation.lt_Is_the_task_submitted# -

    Yes

    +

    #evaluation.Yes#

    -

    No

    +

    #evaluation.No#

    @@ -30,13 +30,21 @@

    #evaluation.lt_Evaluated_Students_to#

    -

    Theese are the evaluated students. Note that if you evaluated them over a grad different from 100, the system automatically did the conversion so the grade will be shown over 100 points.

    +

    <_ Theese are the evaluated students. Note that if you evaluated them over a grad different from 100, the system automatically did the conversion so the grade will be shown over 100 points. >


    #evaluation.lt_Students_with_answers#

    +

    #evaluation.lt_These_are_the_student#

    #evaluation.Click# #evaluation.here# #evaluation.lt_if_you_want_to_downlo#

    + + +

    #evaluation.Click# #evaluation.here# #evaluation.lt_if_you_do_not_want_to#

    +
    +

    #evaluation.Click# #evaluation.here# #evaluation.lt_if_you_want_to_see_th#

    +
    +
    @@ -69,6 +77,14 @@

    #evaluation.lt_Students_who_have_not#

    +

    #evaluation.lt_These_are_the_student_1#

    + + +

    #evaluation.Click# #evaluation.here# #evaluation.lt_if_you_do_not_want_to#

    +
    +

    #evaluation.Click# #evaluation.here# #evaluation.lt_if_you_want_to_see_th#

    +
    +
    @@ -105,3 +121,4 @@

    #evaluation.lt_There_are_no_students_1#

    + Index: openacs-4/packages/evaluation/www/admin/evaluations/student-list.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/evaluations/student-list.tcl,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation/www/admin/evaluations/student-list.tcl 10 Jun 2004 21:08:53 -0000 1.5 +++ openacs-4/packages/evaluation/www/admin/evaluations/student-list.tcl 15 Jun 2004 23:20:29 -0000 1.6 @@ -1,15 +1,16 @@ # /packages/evaluaiton/www/admin/evaluaitons/student-list.tcl ad_page_contract { - Displays the evaluations of students that have already been evaluated, - lists the ones that have not been evaluated yet (in order to evaluate them) + Displays the evaluations of students that have already been evaluated, + lists the ones that have not been evaluated yet (in order to evaluate them) and deals with tasks in groups and individual. @author jopez@galileo.edu @creation-date Mar 2004 @cvs-id $Id$ } { task_id:integer,notnull + {show_portrait_p ""} {return_url "student-list?[export_vars -url { task_id }]"} {orderby_wa:optional} {orderby_na:optional} @@ -21,13 +22,19 @@ set page_title "[_ evaluation.Student_List_]" set context { "[_ evaluation.Student_List_]" } +if { [string eq $show_portrait_p "t"] } { + set this_url "student-list?[export_vars -entire_form -url { { show_portrait_p f } }]" +} else { + set this_url "student-list?[export_vars -entire_form -url { { show_portrait_p t } }]" +} + db_1row get_task_info { *SQL* } set due_date_pretty [lc_time_fmt $due_date_ansi "%q"] if { $number_of_members > 1 } { - set groups_admin "[_ evaluation.lt_Groups_administration]" + set groups_admin "[_ evaluation.lt_Groups_administration]" } else { - set groups_admin "" + set groups_admin "" } set done_students [list] @@ -148,28 +155,36 @@ set elements [list party_name \ [list label "[_ evaluation.Name_]" \ orderby_asc {party_name asc} \ - orderby_desc {party_name desc}] \ - submission_date_pretty \ - [list label "[_ evaluation.Submission_Date_]" \ - orderby_asc {submission_date_ansi asc} \ - orderby_desc {submission_date_ansi desc}] \ - answer \ - [list label "[_ evaluation.Answer_]" \ - link_url_col answer_url \ - link_html { title "[_ evaluation.View_answer_]" }] \ - grade \ - [list label "[_ evaluation.Maximun_Grade_] " \ - display_template { } ] \ - comments \ - [list label "[_ evaluation.Comments_]" \ - display_template { } \ - ] \ - show_answer \ - [list label "[_ evaluation.lt_Allow_the_students_br]" \ - display_template { [_ evaluation.Yes_] [_ evaluation.No_] } \ - ] \ - ] + orderby_desc {party_name desc}] + ] +if { [string eq $show_portrait_p "t"] && [string eq $number_of_members "1"] } { + lappend elements portrait \ + [list label "[_ evaluation.Students_Portrait_]" \ + display_template { @not_evaluated_wa.portrait;noquote@ } + ] +} + +lappend elements submission_date_pretty \ + [list label "[_ evaluation.Submission_Date_]" \ + orderby_asc {submission_date_ansi asc} \ + orderby_desc {submission_date_ansi desc}] +lappend elements answer \ + [list label "[_ evaluation.Answer_]" \ + link_url_col answer_url \ + link_html { title "[_ evaluation.View_answer_]" }] +lappend elements grade \ + [list label "[_ evaluation.Maximun_Grade_] " \ + display_template { } ] +lappend elements comments \ + [list label "[_ evaluation.Comments_]" \ + display_template { } \ + ] +lappend elements show_answer \ + [list label "[_ evaluation.lt_Allow_the_students_br]" \ + display_template {
    [_ evaluation.Yes_] [_ evaluation.No_]
    } \ + ] + template::list::create \ -name not_evaluated_wa \ -multirow not_evaluated_wa \ @@ -186,8 +201,12 @@ set orderby_wa " order by party_name asc" } -db_multirow -extend { answer answer_url submission_date_pretty } not_evaluated_wa get_not_evaluated_wa_students { *SQL* } { +db_multirow -extend { answer answer_url submission_date_pretty portrait } not_evaluated_wa get_not_evaluated_wa_students { *SQL* } { + if { $number_of_members == 1 } { + set portrait "[evaluation::get_user_portrait -user_id $party_id { {alt "[_ evaluation.lt_No_portrait_for_party]"} }]" + } + lappend done_students $party_id if { [string eq $online_p "t"] } { set submission_date_pretty "[lc_time_fmt $submission_date_ansi "%Q"] [lc_time_fmt $submission_date_ansi "%X"]" @@ -214,19 +233,27 @@ [list label "[_ evaluation.Name_]" \ orderby_asc {party_name asc} \ orderby_desc {party_name desc}] \ - grade \ - [list label "[_ evaluation.Grade_over_] " \ - display_template { } ] \ - comments \ - [list label "[_ evaluation.Comments_]" \ - display_template { } \ - ] \ - show_answer \ - [list label "[_ evaluation.lt_Allow_the_students_br]" \ - display_template { [_ evaluation.Yes_] [_ evaluation.No_] } \ - ] \ ] +if { [string eq $show_portrait_p "t"] && [string eq $number_of_members "1"] } { + lappend elements portrait \ + [list label "[_ evaluation.Students_Portrait_]" \ + display_template { @not_evaluated_na.portrait;noquote@ } + ] +} + +lappend elements grade \ + [list label "[_ evaluation.Grade_over_] " \ + display_template { } ] +lappend elements comments \ + [list label "[_ evaluation.Comments_]" \ + display_template { } \ + ] +lappend elements show_answer \ + [list label "[_ evaluation.lt_Allow_the_students_br]" \ + display_template {
    [_ evaluation.Yes_] [_ evaluation.No_]
    } \ + ] + template::list::create \ -name not_evaluated_na \ -multirow not_evaluated_na \ @@ -271,12 +298,16 @@ } -db_multirow not_evaluated_na get_not_evaluated_na_students { *SQL* } { +db_multirow -extend { portrait } not_evaluated_na get_not_evaluated_na_students { *SQL* } { + if { $number_of_members == 1 } { + set portrait "[evaluation::get_user_portrait -user_id $party_id { {alt "[_ evaluation.lt_No_portrait_for_party]"} }]" + } + } set grades_sheet_item_id [db_nextval acs_object_id_seq] - + Index: openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql 10 Jun 2004 21:08:54 -0000 1.5 +++ openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.6 @@ -49,7 +49,8 @@ - select cu.first_names||', '||cu.last_name as student_name + select cu.first_names||', '||cu.last_name as student_name, + cu.user_id $sql_query from cc_users cu $orderby @@ -60,7 +61,8 @@ - select cu.first_names||', '||cu.last_name as student_name + select cu.first_names||', '||cu.last_name as student_name, + cu.user_id $sql_query from cc_users cu, registered_users ru, Index: openacs-4/packages/evaluation/www/admin/grades/grades-reports.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-reports.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/grades/grades-reports.adp 10 Jun 2004 21:08:54 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/grades/grades-reports.adp 15 Jun 2004 23:20:29 -0000 1.3 @@ -3,6 +3,7 @@ @context;noquote@

    #evaluation.lt_This_is_the_grades_re#
    #evaluation.lt_You_can_order_the_gra#
    +If you click on the student name, you will see the grades report for that student.

    Index: openacs-4/packages/evaluation/www/admin/grades/grades-reports.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-reports.tcl,v diff -u -r1.5 -r1.6 --- openacs-4/packages/evaluation/www/admin/grades/grades-reports.tcl 10 Jun 2004 21:08:54 -0000 1.5 +++ openacs-4/packages/evaluation/www/admin/grades/grades-reports.tcl 15 Jun 2004 23:20:29 -0000 1.6 @@ -77,6 +77,6 @@ -db_multirow grades_report $query_name { *SQL* } { - +db_multirow -extend { student_url } grades_report $query_name { *SQL* } { + set student_url [export_vars -base "student-grades-report" -url { {student_id $user_id} }] } Index: openacs-4/packages/evaluation/www/admin/grades/grades-type-reports-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-type-reports-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/admin/grades/grades-type-reports-postgresql.xql 10 Jun 2004 21:08:54 -0000 1.4 +++ openacs-4/packages/evaluation/www/admin/grades/grades-type-reports-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.5 @@ -18,7 +18,8 @@ - select cu.first_names||', '||cu.last_name as student_name + select cu.first_names||', '||cu.last_name as student_name, + cu.user_id $sql_query from cc_users cu $orderby @@ -29,7 +30,8 @@ - select cu.first_names||', '||cu.last_name as student_name + select cu.first_names||', '||cu.last_name as student_name, + cu.user_id $sql_query from cc_users cu, registered_users ru, Index: openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.adp 10 Jun 2004 21:08:54 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.adp 15 Jun 2004 23:20:29 -0000 1.3 @@ -3,8 +3,10 @@ @context;noquote@

    #evaluation.lt_This_is_the_grades_re_1#
    #evaluation.lt_You_can_order_the_gra_1#
    +#evaluation.lt_If_you_click_on_the_s#

    + Index: openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.tcl 10 Jun 2004 21:08:54 -0000 1.4 +++ openacs-4/packages/evaluation/www/admin/grades/grades-type-reports.tcl 15 Jun 2004 23:20:29 -0000 1.5 @@ -37,6 +37,7 @@ set elements [list student_name \ [list label "[_ evaluation.Name_]" \ + link_url_col student_url \ orderby_asc {student_name asc} \ orderby_desc {student_name desc} \ ]\ @@ -74,6 +75,6 @@ set task_order " order by student_name asc" } -db_multirow grade_tasks $query_name { *SQL* } { - +db_multirow -extend { student_url } grade_tasks $query_name { *SQL* } { + set student_url [export_vars -base "student-grades-report" -url { {student_id $user_id} }] } Index: openacs-4/packages/evaluation/www/admin/grades/student-grades-report-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/student-grades-report-postgresql.xql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/www/admin/grades/student-grades-report-postgresql.xql 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,40 @@ + + + + postgresql7.4 + + + + + select eg.grade_plural_name, + eg.grade_id + from evaluation_gradesx eg, acs_objects ao + where content_revision__is_live(eg.grade_id) = true + and eg.item_id = ao.object_id + and ao.context_id = :package_id + order by grade_plural_name desc + + + + + + + + + select person__name(:student_id) as student_name, + p.email + from parties p + where p.party_id = :student_id + + + + + + + + select evaluation__class_total_grade(:student_id,:package_id) + + + + + Index: openacs-4/packages/evaluation/www/admin/grades/student-grades-report.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/student-grades-report.adp,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/www/admin/grades/student-grades-report.adp 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,29 @@ + +@page_title;noquote@ +@context;noquote@ + +

    #evaluation.lt_Grades_report_of_stud#


    + + + + + + +
    @portrait;noquote@ #evaluation.Name_student_name#
    #evaluation.Email# @email@
    +
    +
      + +
    • #evaluation.lt_There_is_no_info_for_#
    • +
      + +
    • @grades.grade_plural_name@
      + +
    • +
      +

      #evaluation.lt_TOTAL_GRADE_total_cla#

      +
      +
    + + + + Index: openacs-4/packages/evaluation/www/admin/grades/student-grades-report.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/student-grades-report.tcl,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/evaluation/www/admin/grades/student-grades-report.tcl 15 Jun 2004 23:20:29 -0000 1.1 @@ -0,0 +1,31 @@ +# /package/evaluation/www/admin/grades/student-grades-reportindex.tcl + +ad_page_contract { + + Grades report for one student + + @author jopez@galileo.edu + @creation-date Jun 2004 + @cvs-id $Id: student-grades-report.tcl,v 1.1 2004/06/15 23:20:29 josee Exp $ + +} { + student_id:integer,notnull + {orderby:optional ""} +} + +db_1row student_info { *SQL* } + +set portrait [evaluation::get_user_portrait -user_id $student_id { {alt "[_ evaluation.lt_No_portrait_for_stude]"} }] + +set page_title "[_ evaluation.lt_Grades_Report_for_stu]" +set context {} +set package_id [ad_conn package_id] +set user_id [ad_conn user_id] + +db_multirow grades get_grades { *SQL* } { + +} + +set total_class_grade [format %.2f [lc_numeric [db_string get_total_grade { *SQL* }]]] + +ad_return_template Index: openacs-4/packages/evaluation/www/admin/groups/group-new.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/groups/group-new.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/groups/group-new.adp 10 Jun 2004 21:08:54 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/groups/group-new.adp 15 Jun 2004 23:20:29 -0000 1.3 @@ -8,10 +8,29 @@ - + + + + + +
    +
    + + + +
    #evaluation.lt_Please_enter_the_grou#
    + + + + + + +
    @students.rownum@.@students.student_name@
    +
    + Index: openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.adp,v diff -u -r1.2 -r1.3 --- openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.adp 10 Jun 2004 21:08:54 -0000 1.2 +++ openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.adp 15 Jun 2004 23:20:30 -0000 1.3 @@ -2,5 +2,6 @@ @page_title;noquote@ @context;noquote@ -Upload a solution for this assignment so the students can see it and learn from it. +#evaluation.lt_Upload_a_solution_for#

    + Index: openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.tcl 10 Jun 2004 21:08:54 -0000 1.4 +++ openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit.tcl 15 Jun 2004 23:20:30 -0000 1.5 @@ -14,7 +14,7 @@ upload_file.tmpfile:tmpfile,optional {solution_mode "edit"} grade_id:integer,notnull - {return_url "/"} + return_url } set package_id [ad_conn package_id] @@ -28,7 +28,7 @@ set context [list [list [export_vars -base ../grades/grades { }] "[_ evaluation.Grades_]"] $page_title] set attached_p "f" -ad_form -html { enctype multipart/form-data } -name solution -cancel_url $return_url -export { grade_id item_id storage_type task_id attached_p } -mode $solution_mode -form { +ad_form -html { enctype multipart/form-data } -name solution -cancel_url $return_url -export { return_url grade_id item_id storage_type task_id attached_p } -mode $solution_mode -form { solution_id:key Index: openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql 10 Jun 2004 21:08:54 -0000 1.3 +++ openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql 15 Jun 2004 23:20:30 -0000 1.4 @@ -6,7 +6,7 @@ - select grade_plural_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id + select grade_plural_name, grade_name, weight as grade_weight from evaluation_grades where grade_id = :grade_id Index: openacs-4/packages/evaluation/www/resources/photo_na.gif =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/resources/photo_na.gif,v diff -u Binary files differ