Index: openacs-4/packages/evaluation/evaluation.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/evaluation.info,v
diff -u -r1.18.2.1 -r1.18.2.2
--- openacs-4/packages/evaluation/evaluation.info 17 Nov 2004 23:58:06 -0000 1.18.2.1
+++ openacs-4/packages/evaluation/evaluation.info 8 Jun 2005 22:07:45 -0000 1.18.2.2
@@ -7,21 +7,22 @@
ff
-
+ Jose Pablo Escobedo Del CidThis package allows the users (professors and students) to use the system to submit and grade the tasks.
- 2004-10-26
+ 2005-04-11This package allows the professors and TAs to assign tasks to the students and to grade them, and to the students to upload their answers and see their grades.0
-
+
-
+
+
@@ -30,6 +31,7 @@
+
-
+1 = Individual
+ Activities
+ Activities for students
+
+ ActivityAdd Assignment Add Assignment Type Add assignment type
@@ -14,10 +18,14 @@
Add/edit solution again Already answered
- Answer
+ ANSWER
+ SUBMISSIONAnswer
+ AnswerOK
- Answer Date
+ How will the task be answered?
+ Answer Date <br> (24 hr format)
+ ANSWERSAssignment Group Assignment Groups Assignment Type
@@ -78,9 +86,12 @@
<input type=submit value="<# Grade Students
Bad input Change Answer
+ NOT EVALUATED STUDENTS
+ 'Not Evaluated Students'Clickclick on this link:
- Comments:
+ Comment
+ COMMENTSComments CommentsComments/Edit reason:
@@ -89,52 +100,73 @@
Confirm Evaluation Group Create Group
+ CREATION DATE
+ DeleteDelete Evaluation Delete evaluation Delete Group Delete Task Delete task Description
+ DESCRIPTIONDescription
- Due Date:
+ Discussion
+ Discussions
+ Download
+ DUE DATE
+ Due Date:Due Date
- Due date
+ Due Date Due Date
+ Leave blank for no due date.Due date: %task_name%Edit Grades
+ Edit
+ Edit All EvaluationsEdit evaluation
- Edit Evaluations
+ Edit All Evaluations Edit %grade_name% Edit Reason:Edit Reason Edit Task Edit task Email:
+ Equal valueEvaluated
- Evaluation Date
+ Evaluation Date <br>(24 hr format)Evaluation Index Evaluation Modified
+ Evaluation ParameterClass Material EvaluationsEvaluations Evaluations Admin
+ GradebookEvaluations List ExamExams Exams for students File File/url associated
+ Final Project
+ Final Project
+ Associate with Forums
+ Associate with forums?
+ You can associate this task to a forumGenerate fileBack Go Back
- Grade:
+ GRADEGrade
- Students
+ Submit GradesGradeGrade Distribution
- Grade in Net value
- Grade over
- Grade over 100
+ Net Value
+ %max_grade% max.
+ GRADE OVER
+ GRADE %<br>
+(OF 100%)
+ The %grade_plural_name% weight is 0% of total grade and will not impact the total grade.GraderGrader Grades
@@ -173,7 +205,43 @@
you want to see the group members, click on the name of the group Individual Insert Failed
+ Instructions
+ <br><br>
+
+<ul>
+<li><text class="blue"><b>Option 1.</b> If you want each %grade_name% to count the same toward the total
+for %grade_plural_name% just click on <b>"Set to Default"</b>.</text>
+<br>
+<li><text class="blue"><b>Option 2.</b> You can tell the system what percentage each %grade_name%
+should be towards the total for %grade_plural_name%. To do this put numbers in
+the first column, the total will need to add up to 100%. Then click on
+<b>"Submit"</b>.</text>
+<br>
+</ul>
+
+ <h1 class="blue">How to set up grading:</h1>
+<br>
+<text class="blue">
+<b>Step 1:</b> Set the percentage you want each assignment type to count towards
+the total grade. Currently you have <b>%grade_plural_name% as %grade_weight%%</b> of the
+total grade.<a href="%link_1%">Change that here</a>.
+</text>
+<br>
+<br>
+<text class="blue">
+<b>Step 2:</b> Add specific tasks to the assignment type. Currently you have
+%counter% %grade_plural_name% as shown in the table above.<a href=%link_2%>Click here to add another</a>.
+</text>
+<br><br>
+
+<text class="blue">
+<b>Step 3:</b> Determine how much each task contributes to the total grade. This
+is referred to as the weight. You have three choices.
+%options%</text>Is live?
+ Journal
+ Journals
+ Journals for students Last Modified late (late)
@@ -182,7 +250,7 @@
Add a member to a group Add Assignment to Communities Add this %grade_name% to other class(es)
- Admin Assignment Types
+ Modify an Assignment TypeAdmin my Assignment TypesAllow the students <br> to see the grade? Already created groups
@@ -195,9 +263,9 @@
Assignment Attachment Assignment Edited (%grade_name% %community_name%) Assignment Groups for %task_name%
- Assignment Plural Type Name
+ Assignment Type Name (Plural)Assignment Type Name
- Assignment Type's Comments
+ Comments Assignment Types Distribution %grade_name%'s Description Associate to this group
@@ -213,16 +281,16 @@
Comment/edit reason on party_id %party_id% is larger than 4,000 characters long, which is our max lenght. Please make this comment/edit reason shorter. Confirm Your Evaluation Confirm your evaluation(s) on "%task_name%"
- Currently $content is associated to this task solution, but you can associate a different url/file just by adding it here
- Currently $content is associated to this task, but you can associate a different url/file just by adding it here
- Currently $title is attached to this task solution, but you can attach a different file/url just by adding it here
+ Currently %content% is associated to this task solution, but you can associate a different url/file just by adding it here
+ Currently %content% is associated to this task, but you can associate a different url/file just by adding it here
+ Currently %title% is attached to this task solution, but you can attach a different file/url just by adding it here Currently $title is attached to this task, but you can attach a different file/url just by adding it here Delete Assignment Type Delete assignment type Distribution for grade "%grade_plural_name%"Do NOT change the "party id" field because with this file we associate the grade with the student or group.Due date must be in the future
- Due Date of \"%task_name%\"
+ Due Date of %task_name% <br> (24 hr format)Edit Assignment Type Edit assignment type Edit grades distribution of $grade_plural_name
@@ -232,31 +300,34 @@
Error deleting the grade Error deleting the task Error while storing file
- Evaluated Students (%total_evaluated%)
+ GRADED (%total_evaluated%)Evaluation Modified %community_name%
+ Final Projects for studentsFirst unattach the file/url, then submit another one or just upload a new file/url and leave this in blank 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 (%)
+ %grade_plural_name% represent %grade_weight%% of the course grade
+
+%grade_plural_name% represents the %grade_weight%% of the 100% of the grade of the class.Grade students using generated file:Grade students using generated file:Grade students with 0Grades Report for $student_name
- Grades report of "%student_name%"
+ Grade report for "%student_name%"Grades Sheet Explanation Grades sheet for assighment "%task_name%"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.
+ Click on a student's name to see their detailed grade report.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 studentsIf you enter the net value, it must be less than %grade_weight%, which is the net value of %grade_plural_name% over the 100 points of the class. <br /> After uploading the %grade_name%, the system will do the convertion and the net value will be represented as a percentage.
- if you want to download all the answers in one file
+ to download all submissions in one file.if you want to see the portraits of the studentsIn 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.
@@ -283,13 +354,13 @@
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
+ See grade sheets associated with this taskSend 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 List for \"%task_name%\"
- 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%)
+ Student Scores for "%task_name%"
+ NOT YET SUBMITTED (%not_evaluated_with_no_answer%)
+ NOT YET GRADED (%not_evaluated_with_answer%)%submission_date_pretty% (late) %submission_date_pretty% <span style=\"color:red;\">(late answer)</span> %task_name% administration
@@ -346,14 +417,14 @@
The sum of the weight of all the assignment types is %total_weight% and it should be 100 by the end of the term(supposedly). The system assumes that the grades start at the 7th line of the file.The weight must be grather than 0, and you can not enter Net Value AND Weight.
- There are no grades to edit
+ There are no grades to edit.There are no files associated with this task There are no grades for this group. There are no groups for this task yet. There are no more communities where you can add the task.There are no studens associated with this group.
- There are no students to eval that already answered
- There are no students to eval with no answer
+ There are no students to evaluate.
+ There are no students to evaluate.There are no tasks associated with this assignment typeThere are no tasks for this package.There are no tasks for this grade type.
@@ -381,7 +452,7 @@
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.
+ The following is a summary of student grades for this course. This is the grades report of the students acording to one assignment type and the evaluations that you have made in this assignment type.This task can not be submitted after the due date This task is not in groups
@@ -400,7 +471,7 @@
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%
+ 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
@@ -417,14 +488,15 @@
Weight must be a real number and between 0 and 100 Weight of %grade_plural_name% over 100% of the classWeight of this %grade_name% over %grade_plural_name%
- Weight over 100% <br /> of the Course
+ WEIGHT <br>(out of 100% )
+ WEIGHT OVER %grade_weight%% <br /> OF %grade_plural_name_up% Weight over %grade_weight%% <br /> of %grade_plural_name% Weight over %grade_weight%% of %grade_plural_name%"}
{html {size 5}}
{help_text "<#_ You can enter the weight over %grade_weight%% of %grade_plural_name% or you can enter the net value of it in the field below. Weight over %grade_weight%% of %grade_plural_name%
- Weight used in $grade_plural_name: ${category_weight}% (of 100% of $grade_plural_name) <br />
- $grade_plural_name represents ${grade_weight}% of the 100% of the class
+ <small>Weight used in %low_name%: %category_weight%% (over 100% of %low_name%) <br />
+ %low_name% represents %grade_weight%% of the 100% of the class</small> Weight used in %grade_plural_name%: ${category_weight}% (of 100% of $grade_plural_name) <br />
$grade_plural_name represents ${grade_weight}% of the 100% of the class Weight used in %grade_plural_name%: %category_weight%% (of 100% of %grade_plural_name%) <br />
@@ -442,7 +514,8 @@
You can also add a student to an existing group by clicking on the "Associate to group..." link. Here you will be asked to select the group to wich you want to add the user.You can associate a link to this task by entering the absolute url here (also optional) You can enter the weight over %grade_weight%% of %grade_plural_name% or you can enter the net value of it in the field below.
- You can order the grade report by the name of the student, by the total grade, or by any of the assignment types, or see the assignment type details by clicking on the view icon at the left of the assignment type name.
+ To sort by student name, total grade, or any of the assignment types, click on the column headers.<br>
+To see the assignment type details, click on the view icon at the left of the assignment type name.You can order the grade report by the name of the student, by the total grade, or by any of the assignments of this assignment type.You can see the csv files associated with the task by clicking on the "See grades sheets associated with this task" botton.You can upload a file associated to this task by using the browse button (optional)
@@ -451,56 +524,82 @@
Your total grade in this class is:Max Grade: Maximun Grade:
+ File Upload SizeMembers Modifying User n/a Name:
+ NAMEName Name: %student_name%Net GradeNet Value Net value
+ Net value over(NEW answer) New Assignment New Group NoNo
+ NONo assignments (No data) No group for task
+ You can't enter more than one relative weightNo. of Members No. of members No parties to grade No response
- Not answered
+ Not submitted Not available
+ The sum of the Weight over %grade_plural_name% should be 100.
+ The sum of the Weight over Total must be %grade_weight%.Not evaluated
+ No submissionthat if you unassociate ALL the members or the group, THE GROUP WILL BE DELETED. Number of IntegrantsNumber of Members One Assignment One Evaluation One Grade Type One Group
+ SUBMITTED ONLINE?Online Submit
+ Over %grade_plural_name%
+ Over total
+ PERFECT SCORE
+ Perfect Score:
+ This is the score used to evaluate the students.y entonces
+ POINTS
+ Grade in %base_grade%ProjectProjects
+ RELATIVE WEIGHT
+ Relative WeightsRemove GradeGroup
+ REQUIRES GRADE?Requires Grade? Reuse Groups
+ DISPLAY TO STUDENTS?Send file Solution Attachment
+ for spreadsheet grading.Studen List Student List Student Name Students List Student's Portrait
+ "Not Yet Graded" file
+ "Not Yet Submitted" file
+ SUBMISSIONSubmission Date submit answer submit answer again
+ SUBMITTEDSubmitted by
+ Submit onlineSumission Date TaskTask Groups
@@ -514,27 +613,39 @@
Tasks List 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. are no groups for this assignment yet.
+ %grade_plural_name_up% TOTAL:Total Total current grade:
+ <div align=right>Total:</div>Total Grade
+ Total Grade over %base_grade%
+ <div align=left><text class="blue">(out of a possible 100% of the course)</text></div>Total of Members
+ Percentage of Total Grade
+Unassociate member Unassociate url? Unattach file? Upload Answer Upload Date
+ Upload graded spreadsheet toUpload Solution Uploaded by (URL) URL pues, esto esta interesante
- View answer
+ View
+ View submission
+ View my AnswersView comments View EvaluationView evaluation View grades sheet View my answer
- View NEW answer
+ View submission
+ VIEW STUDENT PORTRAITS?
+ VIEW STUDENT PORTRAITS:
+ View PostView Task View task View/Edit Evaluation
@@ -546,5 +657,6 @@
upi , pero no yupinYesYes
- answer has been submited successfully. Click <a href="%return_url;noquote%"> here </a> to continue.
+ YES
+ Your answer has been submitted successfully. Click <a href="%return_url%"> here </a> to continue.
Index: openacs-4/packages/evaluation/lib/evaluations-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/evaluations-chunk-postgresql.xql,v
diff -u -r1.6.2.1 -r1.6.2.2
--- openacs-4/packages/evaluation/lib/evaluations-chunk-postgresql.xql 17 Nov 2004 23:58:15 -0000 1.6.2.1
+++ openacs-4/packages/evaluation/lib/evaluations-chunk-postgresql.xql 8 Jun 2005 22:07:45 -0000 1.6.2.2
@@ -8,15 +8,26 @@
select et.task_name,
round(et.weight,2) as task_weight,
- et.task_id
+ et.task_id, (select perfect_score from evaluation_tasks where task_id=et.task_id) as perfect_score, online_p
from evaluation_tasksi et, cr_items cri
where grade_item_id = :grade_item_id
and cri.live_revision = et.task_id
$evaluations_orderby
+
+
+ select ets.solution_id
+ from evaluation_tasks_sols ets, cr_items cri
+ where ets.task_item_id = (select task_item_id from evaluation_tasks where task_id=:task_id)
+ and cri.live_revision = ets.solution_id
+
+
+
+
+
@@ -25,16 +36,19 @@
et.weight as t_weight,
eg.weight as g_weight,
round((et.weight*eg.weight)/100,2) as task_weight,
- et.number_of_members,
- et.task_id
+ et.number_of_members,
+ et.online_p,
+ et.due_date,
+ et.late_submit_p,
+ et.task_id, (select perfect_score from evaluation_tasks where task_id=et.task_id) as perfect_score
from evaluation_grades eg,
evaluation_tasksi et,
cr_items cri
where eg.grade_id = :grade_id
and eg.grade_item_id = et.grade_item_id
and cri.live_revision = et.task_id
$evaluations_orderby
-
+
@@ -83,7 +97,6 @@
from evaluation_tasks et3
where et3.task_id = :task_id
)
-
-- evaluation__party_id(:user_id,:task_id)
@@ -94,7 +107,7 @@
select ea.data as answer_data,
ea.title as answer_title,
- ea.answer_id
+ ea.answer_id,to_char(ea.creation_date,'MM/DD/YYYY HH24:MI') as creation_date
from evaluation_answersi ea, cr_items cri
where ea.task_item_id = :task_item_id
and cri.live_revision = ea.answer_id
@@ -119,5 +132,41 @@
+
+
+ select 1 from dual where :due_date > now()
+
+
+
+
+
+
+ select ea.answer_id
+ from evaluation_answers ea, cr_items cri
+ where ea.task_item_id = :task_item_id
+ and cri.live_revision = ea.answer_id
+ and ea.party_id =
+ ( select
+ CASE
+ WHEN et3.number_of_members = 1 THEN :user_id
+ ELSE
+ (select etg2.group_id from evaluation_task_groups etg2,
+ evaluation_tasks et2,
+ acs_rels map
+ where map.object_id_one = etg2.group_id
+ and map.object_id_two = :user_id
+ and etg2.task_item_id = et2.task_item_id
+ and et2.task_id = :task_id)
+ END as nom
+ from evaluation_tasks et3
+ where et3.task_id = :task_id
+ )
+
+ --evaluation__party_id(:user_id,:task_id)
+
+
+
+
+
Index: openacs-4/packages/evaluation/lib/evaluations-chunk.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/evaluations-chunk.adp,v
diff -u -r1.3.2.1 -r1.3.2.2
--- openacs-4/packages/evaluation/lib/evaluations-chunk.adp 17 Nov 2004 23:58:15 -0000 1.3.2.1
+++ openacs-4/packages/evaluation/lib/evaluations-chunk.adp 8 Jun 2005 22:07:45 -0000 1.3.2.2
@@ -1,4 +1,24 @@
-
+
+
+