 |
Mary Star of the Sea High School
~([39]SchoolAddress)
San Pedro, CA 90731
Tel: ~([39]SchoolPhone) / Fax: ~([39]SchoolFax)
|
GRADE: |
~[tlist_sql; SELECT DISTINCT sg.grade_level
FROM storedgrades sg
INNER JOIN sections sec on sec.id=sg.sectionid
WHERE sg.studentid=~(curstudid) AND sg.schoolid=~(curschoolid) AND sg.storecode='P2' AND (sg.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) AND sec.expression='1(A)']
~(sg.grade_level)
| [/tlist_sql]
NAME: |
~(lastfirst) |
STUDENT ID: |
~(student_number) |
TERM: |
~[tlist_sql; SELECT DISTINCT t.name
FROM storedgrades sg
INNER JOIN sections sec on sec.id=sg.sectionid
INNER JOIN terms t on t.id=sg.termid
WHERE sg.studentid=~(curstudid) AND t.schoolid=~(curschoolid) AND sg.storecode='P2' AND (sg.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) AND sec.expression='1(A)']
~(t.name)         
| [/tlist_sql]
REPORT: |
2nd Progress Report (P2) |
DATE POSTED: |
~[tlist_sql; SELECT DISTINCT TO_CHAR(sg.datestored, 'MON FXDD, YYYY')
FROM storedgrades sg
INNER JOIN sections sec on sec.id=sg.sectionid
WHERE sg.studentid=~(curstudid) AND sg.schoolid=~(curschoolid) AND sg.storecode='P2' AND (sg.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) AND sec.expression='1(A)']
~(sg.datestored)
| [/tlist_sql]
PERIOD |
COURSE |
FACULTY |
ABS |
TAR |
COMMENTS |
P1 |
Q1 |
P2 |
S1 |
~[tlist_sql; select distinct
sec.expression, sg.course_name, sg.teacher_name, sg.absences, sg.tardies, to_char(sg.comment_value),
(select to_char(sg2.GRADE) from storedgrades sg2
where sg2.studentid = sg.studentid and sg2.course_number = sg.course_number
and (sg2.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) and sg2.storecode='P1') "P1",
(select to_char(sg3.GRADE) from storedgrades sg3
where sg3.studentid = sg.studentid and sg3.course_number = sg.course_number
and (sg3.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) and sg3.storecode='Q1') "Q1",
(select to_char(sg4.GRADE) from storedgrades sg4
where sg4.studentid = sg.studentid and sg4.course_number = sg.course_number
and (sg4.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) and sg4.storecode='P2') "P2"
from storedgrades sg, sections sec
where sg.SECTIONID = SEC.ID
and sg.storecode in ('P2')
and (sg.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3)
and sg.studentid = ~(curstudid)
and sg.grade is not null
order by sec.expression]
~(sec.Expression;t) |
~(sg.Course_Name;t) |
~(sg.teacher_name;t) |
~(sg.absences;t) |
~(sg.tardies;t) |
~(sg.comment_value;t) |
~(sg2.GRADE;t) |
~(sg3.GRADE;t) |
~(sg4.GRADE;t) |
|
[/tlist_sql]
Christian Service Hours: ~(servhours) (80 Christian Service Hours are required for graduation.)
Parent Volunteer Hours: ~(*period_info;9(A);current_grade;Y1) (Most families are required to complete 40 hours in a year.)
MESSAGE TO PARENTS
~[displaypref:p2m_string-s~(curschoolid)]
TEACHER COMMENTS |
|
01 Is doing excellent work |
09 Talks excessively; distracts others |
02 Is a pleasure to have in class |
10 Behavior/attitude needs improvement |
03 Shows improvement |
11 Unsatisfactory written classwork/homework |
04 Does not come prepared for class |
12 Poor test/quiz results |
05 Should attend after school tutoring with the teacher |
13 Student is in danger of failing |
06 Poor use of class time |
14 Inconsistent performance |
07 Missing assignments |
15 Working below ability |
08 Late assignments |
16 CONFERENCE-PLEASE CALL |