Quick Export

How To

To use the Quick Export function:

1. On the start page, search for and select a group of students > list of students appears in the Current Student Selection section.

2. Click the [Select Function] arrow > Group Functions pop-up menu appears.

3. Under Student Reports, choose Quick Student Export > you'll be taken to a page with a box on it. From there, enter in the fields you would like to export, one per line. 

4. Change/add field names using the Fields link. 

5. Check Surround Fields

6. Click Submit 

• Information can only be exported if it has a field in PS.

• After you do the export, the field names will stay for future reports unless removed.

• When exporting fields that indicate a Yes, No, or checkbox option: 

1. 1 = Yes

2. 0 = No

Below are commonly used Field Names and Data Access Tags (DATs) to include in your quick export:

Student Information

• SchoolID

• [39]name

• Student_Number

• LastFirst

• Last_Name

• Middle_Name

• First_Name

• Grade_Level

• Gender

• U_StudentsUserFields.advisor

• Street

• City

• State

• Zip

• U_StudentsUserFields.student_email

• U_StudentsUserFields.student_cell

• U_StudentsUserFields.c_504 (504 Status)

  • • If the student has a 504 plan, this will export a 1.

• S_IL_STU_X.LEP (Multilingual Status)

  • • If the student is ML, this will export a 1.

•  S_IL_STU_X.IEP (IEP Status)

  • • If the student has an IEP, this will export a 1.

• FedEthnicity

• Ethnicity 

• Web_ID

**For additional field names on student information, please see the document attached to this page.

Parent/Guardian Information

• Father

• U_StudentsUserFields.father_cell

• StudentCoreFields.fatherdayphone

• Mother

• U_StudentsUserFields.mother_cell

• StudentCoreFields.motherdayphone

• Home_Phone

• U_StudentsUserFields.GUARDIANEMAIL1

• U_StudentsUserFields.GUARDIANEMAIL2

GPA

The GPA DAT (data access tag) returns a student’s GPA based on the specified parameters. GPAs are calculated on the fly and not stored in a database table. These exports require a significant amount of processing power and best to use them during off-peak hours (evenings or weekends).

Format: ^(*gpa method=”value” type=”value” term=”value” year=”value” grade=”value” credittype=”value” scale=”value”)

To pull GPAs, enter the following code:

• ^(*gpa method="METHOD")

Example: ^(*gpa method="Unweighted")

**The following are our GPA methods:

Current Weighted: GPA based on current grades, weighted

Current_Unweighted: GPA based on current grades, unweighted

Weighted: Cumulative GPA based on stored grades, weighted

Unweighted: Cumulative GPA based on stored grades, unweighted

Projected: GPA based on cumulative GPA and current grades, weighted

Projected-unweighted: GPA based on cumulative GPA and current grades, unweighted

Additional GPA DAT formats are listed in the chart below:

Class Rank

The Honor Roll DAT (data access tag) returns results from the ClassRank table. 

Format: ^(*classrank method="[GPA Calculation Method name]" result="[value]" percentiledigits="[decimal places]")

To pull Class Ranks, enter the following code:

• ^(*class_rank_out_of*gpa method="METHOD")

Examples: ^(*classrank result="rankoutof")

 ^(*classrank method="Simple" result="rank")

 ^(*gpa method="Enrichment")

Additional Class Rank DAT formats are listed in the chart below: