In this article, you will learn how to create new classes and roster students into those classes using Quick Class Upload. Classes can be created one at a time and students can be added to classes one at a time. This method allows both to be done by updating a file and uploading the updates back into ADAM.
If you are rostering students in multiple grades for multiple schools, you will repeat this process for each grade/school combination.
| 1. | Log into ADAM (https://adamexam.com) | |
| 2. | Navigate to Rostering | Classes | |
| 3. | Click on the ellipses in the top right of the page, then select Quick Class Upload | |
| 4. | This opens the Quick Class Upload page containing instructions for completing the process | |
Quick Class Upload Steps
Step 1
Select the Grade, Course, Academic Session and School to produce an exportable file containing the students that match the criteria.
| S1-1 | Select the grade of the students you want to add into the classes. You can only choose one grade at a time. |
|
| S1-2 |
Select a course to assign to the classes. Choose a grade based course from this list:
|
|
| S1-3 |
Select an Academic Session to assign to the classes if it isn't populated. Type a space into this field to activate the value, instead of using the drop down arrow:
|
|
| S1-4 |
Select the school of the students you want to add into the classes. You can only choose one school at a time. |
|
| S1-5 |
Click the download template button to generate your CSV file |
|
Look in your system tray or in your downloads folder for a CSV file. It's formatted with School Name_Course Name_current date. It would look something like...quick_class_Ball Elementary_5th Grade 2023-2024_01_01_2023.csv.
Open the CSV file with a program like Excel, Sheets or Numbers. The only updates allowed on the file are in the column called 'class_code'. The value you add to the 'class_code' field becomes:
- the Title of the new class we are adding
- the Proctor Group in the Proctor Dashboard
- the class used for W3 Class Reports
NOTE: If the file you open is empty, it is because the students in that grade/school combination are already enrolled in classes. This process only works with students who are not already in a class.
Step 2
Modify the file you opened at the end of Step 1 by adding the new class name (even though it says class_code). Just don't use any special characters in the name.
| S2-1 | Open the download file from Step 1 (look in the system tray or download folder). Column A (user_sourced_id) is the student LSID. Columns B and C are the student Name. Ignore, but do not modify any column but the 'class_code' column. |
|
| S2-2 |
Populate the class_code column. There should be 1 row per student being enrolled in the class(s). The class_code must be a unique value for the school. It could be your existing class/section code or some combination of the school, teacher name and academic session(e.g., JHBean_Wilson_23). The class code is displayed as the Proctor Group name in the Administration and will be the Title of the class used in the EOU Class Reports. NOTE: If you are rostering students into an existing class, the class_code should be the Title of the existing class (not the Class Code). |
|
| S2-3 |
Saving the CSV File The file format is critical. Even though you will be editing this file in Excel (numbers or sheets), you will need to save this file as a particular file type called CSV (Comma- Separated Value). There is some difference between using a Mac or a Windows machine, but these steps are very similar.
|
|
| S2-3A |
A. Find and click on ‘File’ at the top of the Excel window (this is an example of a Mac screen).
|
|
| S2-3B |
B. Select 'Save As' from the available options. |
|
| S2-3C |
C. Choose where to save your file, name your file, and set the File Format to ‘Comma Separated Values (.csv). |
|
| S2-3D |
D. Click the Save button
|
|
Now that the file is updated by putting the students into classes and saved as a CSV, it's time to upload it back into ADAM. This will add the new classes and enroll the students into those new classes.
Step 3
This step takes the modified CSV file and uses it to create the new classes using the names provided in the class_code column of the file and enrolls the students into those new classes.
| S3-1 |
Either drag the file you saved in Step 2 into the drop box, or use the Browse button to search for the file you saved in Step 2. NOTE: If you get an error message about 'school with sourced ID 'xxxxxx' does not exist. You'll need to format the school column in the excel file.
|
|
| S3-2 |
Once the CSV is uploaded, ADAM modifies the CSV Validation criteria based on the success of the upload. If the criteria is highlighted green, then the CSV file passes the criteria test. Otherwise you will receive an error message identifying why the file failed the test. This is what the confirmation page might look like if you added a one class with four students from the file. Click the OK button to accept the added classes and students. |
|
| S3-3 |
This is what the class page might look like if you added a class called 'Mrs Harper' with four students. |
|
Repeat this process for each grade/school combination.
Comments
0 comments
Please sign in to leave a comment.