This lesson will provide an overview to the data integration process when importing into DnA.
What You Need to Know
Before you get too deep into this document, there are a few things you should know:
- You're going to want to send a lot of data to your DnA installation.
- Basic reports will not work if you only stick to what is required in our data specs.
- For a lot of the built in reporting power in DnA, you'll want to make sure that you're providing data in the right places.
- Don't bite off more than you can chew right away. Start with your Core Data Set (more on this below) and then prioritize and phase in additional data sets.
The Cliff's Notes Version
There are a lot of files that you can import into DnA. Here is a recommendation:
- Start with the core data set.
- Make sure that data is automated and importing nightly.
- Review your import logs (Admin > Data > Core Data Import Logs)
- In your studemo.txt file, make sure to provide the following columns:
- Race 1, 2, 3(Columns 8, 9, 10)
- Is Hispanic (Column 11)
- English Proficiency/Language Fluency Code (Column 14)
- Primary Disability Code (Column 16)
- Parent/Guardian Highest Education Level (Column 22)
- Special Ed Exit Date( Column 28)
- While its not required, also send a programs.txt file. This is an important data set. Make sure to include program data for the following:
- Student Lunch Programs
- Gifted Programs
- Once you've addressed items 1-5 above, begin looking at additional datasets that you may want to begin reporting on. Generally a good next place to start is contacts or transcripts.
That's the short version!
As you probably know by now, the data process is one of the most integral elements to a successful DnA implementation. While getting started is generally a straightforward process, getting to where you want to be with all of your data may take some time. Its recommended that you think about the various data elements that you are interested in using in DnA and prioritizing the data loads.
DnA's Data Team has great experience with the DnA data set and DnA tools. One thing to keep in mind is that the DnA team does not have expertise in all other Student Information Systems (SIS). There are essentially three ways for you to get your data out of your SIS.
- Write and automate your own queries from your SIS based on the DnA data specs.
- Start with the DnA courtesy scripts for your SIS (if we have one) and make any necessary adjustments in order to get your data extracted and automating out of your SIS.
- Consult with local districts, your SIS vendor, or a third party data company to assist you with your extracts and automation (DnA can provide a reference).
We have worked with just about every SIS out there and have in many cases obtained courtesy scripts that we can distribute to help get you started with your data implementation. The courtesy scripts are usually extracts that other DnA clients have written and they were kind enough to share with us. These scripts may not work for you or they may require some tweaking on your end.
All of the DnA data specs can be found online at https://www.illuminateed.com/downloads. It is imperative to realize that whether or not a field is required is due to a purely technical requirement. Without the required fields your data imports will not work.You are definitely going to want to add non-required fields in order to have a fully functional installation. Many of the key DnA features will not work well without additional data.
On the downloads page you'll see three different data specs:
DnA Core Data Spec
- This is your starting point. Before moving beyond the core data spec and into additional data sets youll want to make sure that your core data is flowing into DnA on a regular basis - ideally nightly - and youll want to be sure that you have accounted for some pretty important data elements.
- The core data set accounts for your students, teachers, admin users, courses, enrollments, and schedules.
DnA ISI Data Spec
- This is potentially your next stop. The ISI data spec is a requirement for ISI implementations, but the datasets in the ISI data spec are also available for importing into DnA or ISE installations.
- The ISI data set accounts for some very valuable data that can be imported into all instances, such as: programs, contacts, transcripts, attendance, and behavior.
- The programs data set, while not truly required for all installations is one of the most important data sets that you will want to get automated quickly in order to accurately track Gifted and Socio-economically Disadvantaged students.
DnA Health Data Spec
- The Health Data Spec is generally only used in the initial data migration for ISI installations.
- The Health Data Spec is relatively straightforward, but has been separated out on its own since there are so many health related files that can be imported.
So, That's All?
Please understand that the data process is an iterative process. You'll work with the DnA implementation and data team to iron out any issues with your data imports. You'll review data and possibly identify some minor issues that need to be resolved. As you begin the process of automating the data and, more importantly, using the data you'll start to get a feel for where you want to go next.
One important tip is to make sure that someone on your team is reviewing your data prior to major data events. If you are planning on rolling out online testing, make sure that you've looked at all of your courses and users in DnA. If you are planning on diving into some data for in depth analysis, take a look at some reports ahead of time and see if your subgroup reports are working. Talk through timelines and data implications with your implementation manager.
The most important thing in a data rollout is preparation. Identify your key dates for data usage, and work back from there. Give yourself some time to identify any data issues and work with the DnA team to address them prior to key dates.
Working with the data team through the ticketing process is pretty painless. But if it isn't working for you or if things are just taking too long, do not hesitate to pick up the phone and call your Customer Success Manager or our Support Team to make sure that you're on the right track as soon as possible!
Confirming and scheduling your data meeting is imperative to the success and starting line of your implementation with DnA. Don't wait or delay to reply, confirm and be present for the first step towards illuminating your organization!
Connect with your Customer Success Manager as soon as possible to starting building a partnership in your growth, guidance, and illuminating adventures ahead.