San Antonio Independent School District Data Warehouse

1
San Antonio Independent School
District Data Warehouse
Maps/Streets
Membership
Demographics
Assessments
My Child
2
San Antonio Independent School
District Data Warehouse

• What is the iDataPortal?
• Reporting tool, developed internally at SAISD by
  Marcos Zorola
• Web-based application that allows users to get
  reports on demand 24/7
• Data is downloaded daily from Region 20
  (Education Service Agency) and stored in a
  database server at SAISD
• Downloaded data is stored in composite database
  tables for efficient data access
• Custom reports are developed to display the data
  in an easy to understand and user
• friendly format
• The SAISD Data Warehouse currently supports and
  maintains the iDataPortal
• It has been in use since 2003
• Users include Board Members, District and Campus
  employees, and Parents
• Parent access to their childrens school
  information is provided via the iDataPortal My
• Child application

Maps/Streets
Membership
Demographics
Assessments
My Child
3
San Antonio Independent School
District Data Warehouse

• Whats available on iDataPortal?
• Maps / Streets (Public has access)
• Find out which schools serve a specified
  address, find all the streets and block numbers
  that are within a school boundary, get one way
  and round trip mileage by specifying a starting
  and destination point, and get a map of the
  surrounding area for a specified campus.
• Membership (Restricted to authorized personnel)
• Get membership and attendance, enrollment and
  withdrawals, mobility rates, projections,
  instructor teaching schedules, warning notices
  and court filings, and data quality reports.
• Demographics (Restricted to authorized
  personnel)
• Get student demographic summaries by local
  accountability subgroups filtering by program,
  ethnicity, age and more. Locate any student
  within SAISD by identification number or name and
  view specific information about the student.
• Assessments (Restricted to authorized personnel)
• View courses and/or classes, interim assessment
  results, item analysis, RPTE data, RPTE
  distribution and yearly progress reports, SDAA
  data, SDAA projected accountability information,
  TAKS data, TAKS projected accountability
  information, and TPRI data.
• My Child (Restricted to authorized personnel and
  parents)
• Authorize iDataPortal My Child registration
  applications and get campus registration
  instructions.

Maps/Streets
Membership
Demographics
Assessments
My Child
4
San Antonio Independent School
District Data Warehouse

• How to Gain Access
• Campus Access (Campus Employees Only)
• Have your principal send an email to
  dwsupport_at_saisd.net requesting access to
  iDataPortal.
• District Access (Non-Campus Employees Only)
• Have your department head send an email to
  dwsupport_at_said.net requesting access to
  iDataPortal
• Classroom Access
• Automatic for teachers.

Maps/Streets
Membership
Demographics
Assessments
My Child
5
San Antonio Independent School
District Data Warehouse

• User Access Levels (Authorization)
• Access Levels
• Access level determines what features a user is
  allowed to see and use. Each user is assigned an
  access level when their account is created.
  There are four different access levels
• District Access to student data for all SAISD
  campuses
• Campus Access to student data for a campus
• Classroom Access to student data for a specific
  instructor
• Guest Access to non-student related features
  (e.g. Campus Maps)
• A user may have access to more than one campus

Maps/Streets
Membership
Demographics
Assessments
My Child
6
San Antonio Independent School
District Data Warehouse
To login, click the Log In/Out tab at the top of
the page.
7
San Antonio Independent School
District Data Warehouse
Employee, portal, calendar and focus group
information is displayed after logging in. User
also have the ability of changing their password.
As a security feature, passwords must be
changed every 90 days.
Make sure you have it filtered to your campus and
click apply.
Change your password by clicking this icon.
Logout by clicking this icon.
8
San Antonio Independent School
District Data Warehouse
To find out which school a student will attend
given the students address, click on the Address
lookup button.
9
San Antonio Independent School
District Data Warehouse
To get membership and attendance data, click on
the Membership and Attendance Query (MAQ) button.
10
San Antonio Independent School
District Data Warehouse
To get student demographics, click on the Student
Demographics button.
11
San Antonio Independent School
District Data Warehouse
Select the Student List report and click on the
gears button. Optionally, you can also select any
additional selection criteria in the Advanced
options section.
12
San Antonio Independent School
District Data Warehouse

• The Data Panel is used to select the reporting
  fields you want in your student list report. By
  default, the students name and id fields are
  pre-selected. To select additional fields
• Select the data category you want.
• Select the field from the field list.
  
• The field you selected will appear in
  the Reporting fields list.
• Once you have the fields you want in your report,
  click the gears button.

1
1
2
3
2
3
Use the Clear button to remove all of the fields
from the reporting fields list, to move a field
up or down the list use the Up and Down buttons,
to remove a single field use the Delete button,
and use the Literal button to add a word or
phrase to each row of the report
Use the scroll bar to move up and down the data
category list
13
San Antonio Independent School
District Data Warehouse

• Once the gears button is clicked, your student
  data report is displayed at the bottom of the
  page. If the report displays the student id
  field, the students id is hyperlinked and can be
  clicked to get additional student information.

14
San Antonio Independent School
District Data Warehouse

• Optionally, the data can be downloaded instead
  of displayed. Once you have selected your
  reporting fields, check the Download data check
  box, select a file format (use the CSV format for
  Excel) and click the Download button. A dialog
  window will appear prompting you to open or save
  the file.

An example of a downloaded file in CSV format
opened with MS Excel
15
San Antonio Independent School
District Data Warehouse

• To save a frequently selected student data
  report format, select all of your reporting
  fields, click the Save Format button, enter a
  short description of the format and click the OK
  button. To access the saved format, click the
  Select standard / saved formats here drop down
  list and select your saved format.

Your saved format will be displayed in the drop
down list
16
San Antonio Independent School
District Data Warehouse

• Click on the Demographics tab at the top.
• To get information about a specific student,
  click on the Student Locator button

17
San Antonio Independent School
District Data Warehouse

• Enter the students id or name and click the
  Search button. A table with the list of students
  that matched your search is displayed. To get
  additional student information, click on the
  students id number under the SID column.

An example of the student locator screen
18
San Antonio Independent School
District Data Warehouse

• The student information sheet displays
  demographic, attendance, class assignments,
  interim assessments, TAKS, SDAA, TPRI, grades,
  schedule, enrollment, program, and parent
  information. To view certain sections of the
  student information sheet, check the
  corresponding check box in the blue left hand
  side bar and click the Apply button. To have the
  system save your setting, click the Make Default
  button.

19
San Antonio Independent School
District Data Warehouse
This concludes the iDataPortal presentation.
Questions?
Maps/Streets
Membership
Demographics
Assessments
My Child