Student data spreadsheet overview #
Before a student can register for ACP dual credit, an Indiana University admissions record must exist identifying that student as a prospective ACP student. ACP collects this information from the high school before the beginning of the term via a customized spreadsheet uploaded to the school’s shared folder. Because of the sensitive nature of some of this data, the ACP Student Data Spreadsheet should not be shared as an email attachment.
A template of the Student Data Spreadsheet should be available for download from the home page of the school’s shared folder.
| Column(s) | Data Element(s) | Details |
|---|---|---|
| A-C | Legal First, Middle, & Last Name | The student's legal first, middle, and last name.
|
| D | Suffix | Only complete this column for students with suffixes as part of their legal name, e.g., Jr., II, (not Ms./Mr.). |
| E | Sex | Currently, M or F are the only available options. |
| F | Birth Date | Double check for accuracy. Reporting this information incorrectly can result in multiple records or will block student from creating IT account. |
| G | Citizenship | Enter single number or letter as indicated. One option must be selected: 1 - Born US citizen (most common) 2 - Naturalized (became US citizen) 3 - Alien Permanent (permission to stay in US permanently) 4 - Alien Temporary (permission to stay in US for set amount of time) N - Not indicated – This option slows the process of generating IU student account. Only use if truly unsure of other options. |
| H-M | Ethnicity | More than one column may be selected. Enter Yes, Y, or X beneath the appropriate column(s). |
| N | Student's personal or high school email. Do not use parent email address. Note: If address turns RED, double check entry for formatting error, e.g., extra space, missing dot or @ symbol. |
|
| O-T | Mailing Address | Including apt. numbers, city, state, and zip code. Note: Column T is the student's County of residence, not Country—this value should never be "USA". |
| U | Grade Level | Report the student's grade level as it will be at the time the student takes the ACP course, i.e., if data is being reported at the end of the academic year for the following year, a student who is in 10th grade at the time of the reported data should be reported as 11th grade on the spreadsheet. |
| V | Meets Min. GPA (2.70) | Enter Yes if GPA is 2.70 or above on a 4.00 scale. Enter No if GPA is below 2.70 on a 4.00 scale. |
| W | Free/Reduced Lunch | Enter Yes if student has applied and been approved for Free/Reduced Lunch Assistance (regardless of whether approval is for Free or Reduced status). Enter No if student has not applied or been approved for this benefit.* |
| X | Contact Number | Student (ideally) or parent telephone number. Note: Do not use high school telephone number. |
| Y | Full School Name | Enter high school's complete name |
| Z | IU High School ACP Course(s)--For ICC/WRCA ONLY--Yes or No? | Enter Yes if student should be enrolled in courses through IU High School (for ICC/WRCA students only). If student is not an ICC or WRCA student, enter no and leave the rest of the columns (AA-AE) blank. |
| AA | IU High School ACP Course #1 | Enter first course the student should be enrolled in if applicable. Leave blank otherwise. |
| AB | IU High School ACP Course #2 | Enter second course the student should be enrolled in if applicable. Leave blank otherwise. |
| AC | IU High School ACP Course #3 | Enter third course the student should be enrolled in if applicable. Leave blank otherwise. |
| AD | IU High School ACP Course #4 | Enter fourth course the student should be enrolled in if applicable. Leave blank otherwise. |
| AE | IU High School ACP Course Notes | Any notes for IU High School courses (section or instructor preference). If no notes, leave blank. |
* Students who are indicated as eligible for Free/Reduced Lunch Assistance on the ACP Student Data Spreadsheet will have their ACP tuition covered by ACP. This does not include charges for textbooks or eTexts. If a student is reported as ineligible in error, or, becomes eligible after the student data has been reported, contact ACP to report the update to the student’s status. ACP can retroactively apply the tuition coverage. Schools who are eligible for Community Eligibility Provision (CEP) should report all students as eligible for Free/Reduced Lunch Assistance.
Spreadsheet instructions #
- Report data for every student taking an ACP eligible course regardless of student’s eligibility or intent to take course for dual credit.
- All requested information on this spreadsheet is required by Indiana University for record creation and admission of a prospective ACP student.
- IUHS ICC/WRCA instructions:
If a student is taking ICC/WRCA courses online through IUHS specify the course(s) in columns AA-AE. Only for current term and year-long courses (see list below)—do not submit data for Spring Semester students until instructed to do so in October/November:
Course 1: (W131)
Course 2 : (C101 and C121) etc.
Possible Course notes: IUHS Instructor Smith for W131.
Do this for each student enrolling in IUHS ICC/WRCA courses. For students not enrolling in IUHS ICC/WRCA courses, just answer “No” in column Z. There is no need to fill out columns AA-AE. - Once complete, save spreadsheet and rename including the high school’s name and date in the file name, e.g., communityhighschool-4.1.22.xls.
- Upload completed spreadsheet to shared folder.
- Access shared folder via provided link (from saved ACP email message).
- Click Upload from the top of screen on home page of folder.
- Locate file and select for upload. You should see file appear in folder.
- Any new/overlooked students should be submitted as a new spreadsheet file. Do not make additions or changes to the spreadsheet once it has been uploaded.
- There is no limit to the number of spreadsheets that can be submitted each term, nor to the number of students on each sheet.
- If a submitted student changes schedule and is no longer taking an ACP course, this is not a problem. Students self-register. ACP does not enroll students based on the names provided in these files.
- Contact acp@iu.edu if you need to report changes to any of the information initially provided on an uploaded spreadsheet.
- Students only need to be submitted once per academic year regardless of the number of ACP courses they may be taking that year.
- Students need to be submitted each year they are taking an ACP eligible course, i.e., students who took ACP courses the previous year need to be submitted again the following year if they have additional ACP courses scheduled for the upcoming fall or spring term.
- Student data must be reported by stated deadline. ACP can assist with admitting new and overlooked students beyond the deadline, but these should be exceptions and not the school’s entire student list.
Indiana University High School courses for Spring 2025 #
|
ACP Online Courses: Spring 2025 |
2 Dec - Last day to submit student data |
||||
|
Course # |
Title |
Length |
Mode |
Live attendance |
Notes |
|
ARTH-H 100 |
Introduction to Art History and Visual Culture |
semester |
asynch |
|
|
|
ENG-W 131 |
Reading, Writing, & Inquiry I |
semester |
synch |
2 times weekly |
|
|
GER-G 250 |
Intermediate German II |
semester |
asynch |
|
|
|
HIST-H 105 |
American History I |
semester |
asynch |
|
|
|
HIST-H 106 |
American History II |
semester |
asynch |
|
|
|
MATH-M 126 |
Trigonometry |
year |
semi-synch |
proctored exams at home school |
M 125 preequisite |
|
POLS-Y 103 |
Introduction to American Politics |
semester |
asynch |
|
|
|
COLL- P 155 |
Public Speaking |
semester |
semi-synch |
final presentation |
|