Attendance and Enrollment

Student Information

Discipline

Food Service

Grading and
Teacher Portal

Academic History

Miscellaneous

Scheduling

School Information

Virtual High School

Star Student Home

Training

DCBE Home

Training and Presentations

EXCEL TEMPLATES:

• Student Tracking - 2010 Cohort (Excel Template)

• Vertical Lookup Template (Excel Template - For File Comparisons)

• At-Risk High School Students (Excel Template)

• Finding Duplicate Enrollments (Sample File)

• Student Referral (Sample Template)

• Truancy Comparison: SIS to Data Warehouse

• Monthly School Audit (Excel Template)

• Yearly School Audit (Excel Template)

• Scheduling and Rollover Checklist (Excel Template - For System DBA's)

• Emergency Data File (Sample Template)

EXAMPLES AND INSTRUCTIONS:

• Advanced Query Sample Parameters

• Able2Extract (pdf to Excel Conversion) Instructions

• Excel - Using Excel to Manage Data

• VLOOKUP Sample Formula

• IF(ISERROR) Sample Formula

• CONCATENATE Sample Forumla

• Alternate Row Shading Formula

• Birthdate Calculation Formula
  
  
   

• New Administrator Training Outline
   

• Link to SIS Express Demo

• Link to Spring 2010 Attendance Conference Presentation