1 / 20

2009-2010

2009-2010. AERIES Training for Accountability Administrators 1/15/2010. Agenda. Welcome Grouping of Participants/Log into Computers Query Screen Overview Tables Table Fields Tips for Querying Query Structure Query Partner Activity Canned Reports in AERIES Canned Queries.

lumina
Download Presentation

2009-2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2009-2010 AERIES Training for Accountability Administrators 1/15/2010

  2. Agenda • Welcome • Grouping of Participants/Log into Computers • Query Screen Overview • Tables • Table Fields • Tips for Querying • Query Structure • Query Partner Activity • Canned Reports in AERIES • Canned Queries

  3. Query Screen Overview

  4. Tables in AERIES • STU – Student Demographics • TST – Student Test Information • CRS – Course & Department • CSE – Special Education • GRD – Student Grades • SEC – Current Section (Connects STU and MST & CRS table) • MST – Master Schedule Information (Current Period & Semester) • TCH – Teacher Name

  5. Table Fields in AERIES Type in a table Table fields appear

  6. Table Fields in AERIES (Cont) • STU and CSE have a “hovering” feature which give detail of the field • Review the TST (filter) • Review the CRS • AERIES Tables & Fields Booklet • Tag the STU, TST, CRS, SEC, MST, CSE, GRD & TCH tables • Go through each table and supporting information

  7. Tips for Querying • Use the student’s permanent ID number field • LIST STU ID • Putting a “?” in front of the element will give you the long description of the field • LIST STU NM LF? • In order to call out an element, the table must be called out first • LIST STU NM ID LF? • Calling out one table, there is no need to use a “.” • LIST STU NM ID GR • Calling out multiple tables, you need to use the “table.field” format • LIST STU TST STU.NM STU.ID STU.GR TST.ID TST.PT

  8. Tips for Querying (Cont) • Most tables & elements can be combined depending on current or past information • In order to combine the STU and MST table, you must use SEC table as a “connector” • LIST STU SEC MST • For grades, cannot use the SEC & MST table. • LIST STU GRD • To Find Course ID Numbers & Department Codes, use the “Department Codes & Course Number” Excel Sheet in the Testing/Accountability.

  9. Query Structure LIST STU TST STU.NM STU.ID STU.GR TST.ID TST.PT TST.SS IF TST.ID = CAHSEE AND ( TST.PT = 1 OR TST.PT = 21 ) Call out the table field/s *Show up on your report * “IF” Call out the filter/s for each field/s Call out the table/s

  10. Query Partner Activity 1 • List of 12th graders who did not pass the math or English part of the CAHSEE in November. We need to know language fluency, ethnicity and special ed. status. • List tables needed. • List table fields needed. • What do we need to filter?

  11. Query Partner Activity 2A • List of students enrolled in Algebra 1 in semester 2. We need to know language fluency, ethnicity, special ed. status, teacher name, course number, course name and period. • List tables needed. • List table fields needed. • What do we need to filter?

  12. Query Partner Activity 2B • List of students enrolled in Algebra 1 and English 1 in semester 2. We need to know language fluency, ethnicity, special ed. status, teacher name, course number, course name and period. • List tables needed. • List table fields needed. • What do we need to filter?

  13. Query Partner Activity 3A • List of students enrolled in the social studies core area. We need to know grade, language fluency, ethnicity, teacher name, course number, course name, department code and period. • List tables needed. • List table fields needed. • What do we need to filter?

  14. Query Partner Activity 3B • List of students enrolled in all four core subject areas. We need to know grade, language fluency, ethnicity, teacher name, course number, course name, department code and period. • List tables needed. • List table fields needed. • What do we need to filter?

  15. Query Partner Activity 4A • List of students’ grades in semester 1 in the science core area. We need to know grade, language fluency, ethnicity, teacher name, course number, course name, department code, term and period. • List tables needed. • List table fields needed. • What do we need to filter?

  16. Query Partner Activity 4B • List of students’ grades in semester 1 in all four core subject areas. We need to know grade, language fluency, ethnicity, teacher name, course number, course name, department code, term and period. • List tables needed. • List table fields needed. • What do we need to filter?

  17. Canned CAHSEE Report In the “J-Testing and Assessment” Icon Under Reports “P. Print CAHSEE Status Reports

  18. Canned CAHSEE Report (Cont) Close the report, the STU.QT screen will come up Query to run: LIST STU NM ID GR IF STU.QT # " "

  19. Canned Multi Data Profile In the “J-Testing and Assessment” Icon Under View and Edit “N. Students Multi Data Profile” Icon In the Testing & Accountability Website, you can view the directions of AERIES Multi-Data Profile

  20. Canned Queries • Queries from this training, testing and booklet orders can be found in the Testing/Accountability Website.

More Related