 |
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='P1' 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='P1' AND (sg.termid BETWEEN ~(curtermid)-3 AND ~(curtermid)+3) AND sec.expression='1(A)']
~(t.name)         
| [/tlist_sql]
REPORT: |
1st Progress Report (P1) |
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='P1' 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') AS "P1"
FROM storedgrades sg, sections sec
WHERE sg.sectionid = sec.id
AND sg.storecode IN ('P1')
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) |
|
|
|
[/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:p1m_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 |