Formatting The Data File
university_layouts.csv
The university layout data file provides the entity structure for your institution. This file should be provided to us each semester in order to track changes in the structure over time. This file should include any program that was offered in your institution each term. Example: if a student is provided in the Terms.csv or Awarded_Degrees.csv file as enrolled or graduated under a program in a specific term, then that specific program code should be present in the University Layouts file under the same term.
Institutional structure will be as follows.
College -> College Division -> Department -> Major -> Program -> Concentration
Within this structure, only College, Major, and Program data are required.
The following columns are required for this data set. Each program code provided within the terms data file or the awarded degrees data file for the corresponding academic period, they should also be included in this file.
Examples can be found for each column in the image above or the sample file.
Please note that column names must be listed exactly as shown below.
| Column Name | What data should be provided | Notes |
|---|---|---|
| college_name | Name for each institutional college. | |
| college_code | Code for each institutional college. | |
| program_name | Name for each institutional program. | |
| program_code | Code for each institutional program. | |
| cip_code | The classification of instructional programs (CIP) code that is tied to this major. | |
| academic_period | The academic period that this program was available. If it is available for multiple periods, list them each as a different row in this file. | This should be provided in term yyyy format: "Winter yyyy", "Spring yyyy", "Summer yyyy", "Fall yyyy". Where "yyyy" is the 4 digit year format. |
The following columns are optional for this data set but we do ask that you provide them if possible. The columns can either be omitted completely or left with blank values:
Reminder: Each division/department/major/concentration provided in terms/awarded degree data files should be included here.
| Column Name | What data should be provided | Notes |
|---|---|---|
| college_division_name | If an institution has college divisions a name for each should be given. | If any data provided here, corresponding, college_division_code will be required |
| college_division_code | If an institution has college divisions a code for each should be given. | If any data provided here, corresponding, college_division_name will be required |
| department_name | If an institution has departments a name for each should be given. | If any data provided here, corresponding, department_code will be required |
| department_code | If an institution has departments a code for each should be given. | If any data provided here, corresponding, department_name will be required |
| major_name | Name for each institutional major. | If any data provided here, corresponding, major_code will be required |
| major_code | Code for each institutional major. | If any data provided here, corresponding, major_name will be required |
| concentration_name | If an institution has concentrations a name for each should be given. | If any data provided here, corresponding, concentration_code will be required |
| concentration_code | If an institution has concentrations a code for each should be given. | If any data provided here, corresponding, concentration_name will be required |
Historical Data
We request that each school provides at least 5 years of historical data for this data set. This will allow us to measure the impact that project success has on student progress.
File Types We Accept
ECMC currently accepts data files only in .csv (comma-separated values) format
New File Submissions
After the historical data files are loaded into the Data Warehouse, we request that each school submit the data related to the last two semesters. For example, if a school is submitting files on 06/1/2019, the school should submit all four files (university_layout.csv, students.csv, terms.csv, and awarded_degrees.csv) with Fall 2018 and Spring 2019 data. This will allow us to validate and verify the data in the Data Warehouse and ensure the correctness of the analytics run against each school's data.
Below is a list of the upcoming submission dates with the data required for each submission:
| Due Date | Terms Required |
|---|---|
| 6/1/2019 | Fall 2018 and Spring 2019 |
| 9/1/2019 | Spring 2019 and Summer 2019 |
| 1/15/2020 | Summer 2019 and Fall 2019 |
| 6/1/2020 | Fall 2019 and Spring 2020 |
| 9/1/2020 | Spring 2020 and Summer 2020 |
| 1/15/2021 | Summer 2020 and Fall 2020 |
| 6/1/2021 | Fall 2020 and Spring 2021 |
| 9/1/2021 | Spring 2021 and Summer 2021 |
| 1/15/2022 | Summer 2021 and Fall 2021 |
| 6/1/2022 | Fall 2021 and Spring 2022 |
| 9/1/2022 | Spring 2022 and Summer 2022 |
| 1/15/2023 | Summer 2022 and Fall 2022 |