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.

 

OUTLINE:

•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).

 

Join:

https://neonet.webex.com/neonet/j.php?MTID=m444ee90c67897bf56c4e7f170a0b7e36

 

Meeting Number:  2304 484 1569

Password:  EAEXCEL  (case sensitive)

Join by phone:  415-655-0002

 

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