Report Card - PreSchool

School Info

1. School Name

Object Label: school name, school name page2
PowerQuery / DAT: ~([39]Name)
Screen: School
Description:
Displays the current school name from the School table. I t is used .on both Page 1 and Page 2.

2. School Address / Details

Object Label: school details, school details page2
New Object Label: School Address & Contact
PowerQuery / DAT:
- Address: ~([39]address)
- Phone: ~([39]schoolphone)
- Date: ^[long.date]
Screen: School
Description:
Static Spanish header text plus school address and phone. Current long date is printed at the right side on the same line as the phone.
Example text (Page 1 & 2):
TEXT
```
Enseñando para transformar vidas
www.powerschool.com.mx
~([39]address)
Tel: ~([39]schoolphone)<tabr 7.2> ^[long.date]
```

3. Term / Year Label

Object Label: term year
PowerQuery / DAT:^(yearname)
Screen: Years & Terms
Description:
the academic year name from ^(yearname).

4. School Code

Object Label: Preschool (part of text)
PowerQuery / DAT: ~([39]school_number),~([39]address)
Screen: School

Description:
Printed under the “Preschool” heading, as part of a centered block:

TEXT

<center>Preschool</center>
<center>~([39]address)</center>
<center>CLAVE ~([39]school_number)</center>

~([39]school_number) Power Query DAT shows the school number,

~([39]address) Power Query DAT shows the full school address

5. Mission & Vision Block (Page 1)

Object Label: Misión&Visión
PowerQuery / DAT:
- ~[39]Principal: display the school principal's name,
- ~(*powerquery;query=com.powerschool.dat.reports.students.teacherinfo;fields=fullname): teacher full name based on student and teacher home room match
- ~(last_name) ~(Student) ~(first_name) ~(middle_name): display student full name
- ~(home_room): display student home room
Screens:
- Student,staff – Teacher info
- Demographics – Student name, Home Room
- School:Principal Name

Description:
Static Spanish mission/vision text plus dynamic Coordinator (static name), Teacher (PowerQuery), Student full name and Group.

TEXT

<b>Misión:</b>
Enseñar a los alumnos la aplicación de los principios bíblicos en su vida y una disciplina cristiana basada en el amor, para desarrollar la armonía entre espíritu, pensamientos, sentimientos y acciones.

<b>Visión:</b>
Levantar hombres y mujeres con convicción, que hagan cumplir el plan de Dios en sus vidas y que sirvan a su generación.


<b>Coordinador:</b> ~[39]Principal<tabr 5><b>Maestro:</b> ~(*powerquery;query=com.powerschool.dat.reports.students.teacherinfo;fields=fullname)                      
<b>Alumna:</b> ~(last_name) ~(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=thirdname) ~(first_name) ~(middle_name)<tabr 5><b>Grupo:</b> ~(home_room)

Student Number & Full Name

Object Label: student number & name
PowerQuery / DAT:
- ~(student_number):Display Student Number
- ~(last_name) ~(Student) ~(first_name) ~(middle_name): display student full name
Screens: Student Demographics
Description:it displays Student number and student full name

CODE

~(student_number)<tabr 4.5>~(last_name)<tabr 5.7> ~








(*powerquery;query=com.powerschool.dat.reports.students.nameinfo;fields=thirdname)<tabr 7.5> ~(first_name) ~(middle_name)

7.Grades Table

Object Label: Grades 1
PowerQuery /DAT:
- ^(*powerquery;query=com.powerschool.dat.reports.students.reportcard.alpha;tableformat;fields=combinedcoursename,E1,E2,T1PR,E3,E4,T2PR,E5,E6,T3PR,PFinal;arg.storecode=E1|E2|E3|E4|E5|E6|T1|T2|T3|Y1;arg.course_group_cd=FOA26)
Screens: Historical Grades, Reporting Terms(Power Teacher Pro)
Description : The Power Query provides historical and current academic grade information based on the given arguments. Refer to the https://powerschoolgroup.atlassian.net/wiki/spaces/IPRD/pages/67817504848/Mexico+PowerQuery+DAT+26.2.0.0#Sample-Report-Card-DATs and construct it as a table.
Example:

CODE

<table><tr><th width="154"></th><th width="28"></th><th width="39"></th><th width="40"></th><th width="27"></th><th width="39"></th><th width="40"></th><th width="27"></th><th width="39"></th><th width="57"></th><th width="30"></th></tr>^(*powerquery;query=com.powerschool.dat.reports.students.reportcard.alpha;tableformat;fields=combinedcoursename,E1,E2,T1PR,E3,E4,T2PR,E5,E6,T3PR,PFinal;arg.storecode=E1|E2|E3|E4|E5|E6|T1|T2|T3|Y1;arg.course_group_cd=FOA26)</table>