EMIS Alliance Using Excel to Troubleshoot SIS Data

Basic, Intermediate, and Advanced Excel techniques can be used to analyze EMIS data from Student Information Systems (SISs), from the Data Collector, and on ODE EMIS reports

This session will demonstrate Exel functions and practical applications that can be helpful in all phases of the EMIS data review process.



•Staff and Course Collection Best Practices
•Prepare the CI and CK files for sharing with others in your district 
•Recording a MACRO with VLOOKUPS
•Create a PivotTable
•Review prepared Staff Demographic (CI) and Staff Employment (CK) files
•Access Excel recorded sessions

This session will be hybrid (offered online and in person).





Meeting Number:  2304 484 1569

Password:  EAEXCEL  (case sensitive)

Join by phone:  415-655-0002


Wednesday, November 3, 2021 - 9:00am to 11:00am
NEOnet Room B & WebEx
EMIS Services
Event Type: