The Course Lists with Guardian Email Addresses Query will give you the Email Addresses for Guardians of students in a specified Course.
When Executing the query, you can select the School Year, Course Title (School ID# only,no section), School, and the Guardian settings for Lives with Student and Receives Mail (default value is Yes for both).
The resulting report will include all sections for the Course ID with a count of students for each section. The student will be listed multiple times if they have more than one Guardian with an email address on record in iPass.
Example: (names substituted for security purposes)
|
Course ID |
Name |
Course Sec |
ID |
GL |
Last Name |
First Name |
Last Name |
First Name |
Email Address |
|
E1011 |
English 1 |
01 |
98475 |
09 |
Student Last 1 |
Student First 1 |
Father Last 1 |
Father First 1 |
father@gmail.com |
|
E1011 |
English 1 |
01 |
98475 |
09 |
Student Last 1 |
Student First 1 |
Mother Last 1 |
Mother First 1 |
mother@gmail.com |
|
E1011 |
English 1 |
01 |
98468 |
09 |
Student Last 2 |
Student First 2 |
Mother Last 2 |
Mother First 2 |
mother@yahoo.com |
|
E1011 |
English 1 |
01 |
98838 |
09 |
Student Last 3 |
Student First 3 |
Mother Last 3 |
Mother First 3 |
mother@yahoo.com |
|
E1011 |
English 1 |
01 |
70835 |
09 |
Student Last 4 |
Student First 4 |
Mother Last 4 |
Mother First 4 |
mother@charter.net |
|
E1011 |
English 1 |
01 |
13135 |
09 |
Student Last 5 |
Student First 5 |
Father Last 5 |
Father First 5 |
father@gmail.com |
|
E1011 |
English 1 |
01 |
15093 |
09 |
Student Last 6 |
Student First 6 |
Father Last 6 |
Father First 6 |
|
|
E1011 |
English 1 |
01 |
15093 |
09 |
Student Last 6 |
Student First 6 |
Mother Last 6 |
Mother First 6 |
mother@qmail.qcc.edu |
|
E1011 |
English 1 |
01 |
13513 |
09 |
Student Last 7 |
Student First 7 |
Mother Last 7 |
Mother First 7 |
|
|
E1011 |
English 1 |
01 |
70809 |
09 |
Student Last 8 |
Student First 8 |
Mother Last 8 |
Mother First 8 |
mother@msn.com |
|
|
|
|
|
|
|
|
|
Count |
10 |
|
E1011 |
English 1 |
02 |
15103 |
09 |
Student Last 1 |
Student First 1 |
Mother Last 1 |
Mother First 1 |
mother@yahoo.com |
** Directions on how to download a query from iPass Help and import into your iPass account can be found in iPass Help > My Queries > Help > How do I import a query file into my iPass database?
