Mary Star of the Sea High School

~([39]SchoolAddress)
San Pedro, CA 90731
Tel: ~([39]SchoolPhone) / Fax: ~([39]SchoolFax)



[/tlist_sql] [/tlist_sql] [/tlist_sql]
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) 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)          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; 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] [/tlist_sql]
PERIOD COURSE FACULTY ABS TAR COMMENTS P1 Q1 P2 S1
~(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)   

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