1 of 15

Data Boot Camp Advanced

​

​

2 of 15

Topics for this session

  • EIS – Student Problem Enrollment Search
  • Using the Membership List research query and Pivot Table to check ADM
  • ADM Audit Report
  • Who is missing from my counts? Comparing state ids (SIS vs. EIS)
  • TISA data reports review

3 of 15

EIS Student Problem Enrollment Search

  • EIS: Student top tab 🡪 Student Problem Enrollment Search side link

​

​

​

​

  • Great place to view block errors and drill down on EIS data at the same time

4 of 15

����

Standard Reports

Research Queries

5 of 15

Research Queries 🡪Student Membership List

6 of 15

ADM Pivot Table

  • Run Membership List for a school and attendance period
  • Extract list as a CSV file
  • Open list in Excel
  • Create a Pivot Table with ADM as rows and a count of ADM

7 of 15

ADM Pivot Table (Data 🡪 Summarize with Pivot Table)

Drag ADM to the Rows

Check ADM to place in

Values – set to Count

Double click any

Total to see detail

Pivot Table Wizard

Pivot Table Output

8 of 15

ADM Audit (Research Queries 🡪 ADM Audit)

9 of 15

ADM Audit Tips

  • ADM Audit only includes records with issues that could impact ADM
  • Grade Level of 0 – check these records
  • Other Data�Value of 1 = data column has issue you should investigate�Value of 0 = data column has no issue
  • To be on the report, the student record has a 1 in at least one column
  • Export report as a .csv file and use Excel filters to isolate data items that need attention�

​

10 of 15

�Comparing State Ids (SIS vs. EIS)��1. Obtain list of state ids from both SIS and EIS and paste them in Excel side by side��2. In Excel, choose Conditional Formatting 🡪 Highlight Cell Rules 🡪 Duplicate Values���� 🡪 🡪 �

11 of 15

Duplicate Cell Values Output

Records to

check because they are missing from EIS

12 of 15

TISA Reporting

TISA GUIDE Pg. 44

Contact: tnedu.funding@tn.gov

​

​

13 of 15

TISA Data Files

  • A folder for each monthly estimate can found in TN Share that contains one pdf and one Excel file.
  • The pdf file contains a letter to the Director of Schools with TISA totals and explanation of any relevant business rules to call to a district’s attention.
  • The Excel file contains multiple tabs featuring district totals, school level data, and student level data used to calculate the various funding categories of TISA.
  • TISA estimates are provided from February – May with the final data pull and reports provided in June. Data is not ‘locked’ until the final pull in June.

​

14 of 15

TISA Data Files (cont’d)

  • Files for charter schools are also provided for districts that have them.
  • Special files are being provided for ELL counts to help reconcile SIS/EIS and TN Pulse Data.
  • There must be a finalized ILP (ELL) or ILP-D (Characteristics of Dyslexia) in TN Pulse to be counted for funding in their TISA related categories. This year, an exception is ELL students who withdrew prior to having an ILP created in TN Pulse.

15 of 15

Contacts:

​

​