Elementary Class List Builder

Welcome to the WSD Class List Builder

This tool is designed to help elementary school administrators, teachers, instructional coaches, and administrative assistants assemble class lists for the upcoming school year. This tool requires a specifically formatted Google Sheet in order to perform the task correctly. You can download a template for the Class List Builder to create your own classes. Important Note: Any edits you make to the Google Sheet that change the column titles or functionality will require edits to the prompt.

Use this file to test the functionality of the Class List Builder: Test CSV 

Get the spreadsheet template for this class list builder to make your own class lists.

__________________________________________________________________________________________________________________________________________________

How To Use the Class List Builder

1. Get the template and complete the information. Do not reformat or retitle the columns. Use the word Request or Requests along with the teacher's name in the Notes column to ensure that gets flagged. Immersion schools may also add text such as "Request Spanish Teacher 1" to accommodate immersion students. Students who should be separated can be flagged in the Notes column by stating which students cannot be with the current student.

2. In Google Sheets, navigate to File > Download and select Comma Separated Value as the format. 

3. Click Upload New Roster (CSV) in the Class List Builder below. Select the number of classes. Click Generate Lists.

4. Review the information. You can drag and drop individual students into other classes as desired. 

5. Download the class lists and import them back into Google Sheets. Collaborate with the stakeholders who help determine the final placements.

6. Print the finalized lists and deliver to your teachers. That's it!

Usage Notes

This tool creates one draft; however, it will be important for you to have a thorough and complete spreadsheet, make all the intended edits in the tool, and download the class list. The class list you see on the screen will not be saved for later revision. Make revisions and edits in the spreadsheet.

____________________________________________________________________________________________________________________________________________________

If you're stuck, scroll to the bottom to view the included tutorial.

Prompt

Code in html, css, and javascript a self-contained, complete, and embeddable class list builder for elementary school administrators to create class lists for next year. Use the attached csv file with the associated parameters to build a class list. Create a drop down selection for the user to select the number of classes between 2 and 6. Make the classes of equal or approximately equal size. Each class should have gender balance with an approximately equal number of boys and girls. Also balance the number of excellent reading, math, and behavior students. These are rated with a 4. Balance the number of struggling students who got 1 and 2 ratings in reading, math and behavior. Equalize the number of students who have checks by ESL, SPED Math, SPED Reading, Speech, 504 and Attendance checks. Place high focus on the Notes column and ensure the students who cannot be together are not together where possible. Add a key at the top to reflect any flags (Advanced Academics, ESL, etc.) and the number of students who have that classification. Allow the user to drag and drop students from one list to another on the generated class lists to override the original generation. Make the lists look like that attached image. Update the numbers in the grid columns at the top to reflect the change in the students' flags. Use a navy blue, white, black, and gray theme for a professional look. Add a download class lists button to download a CSV with a page for each class for further review and editing.

Iteration

The totals are great, but add the lists of the kids' names sorted by class in the number of columns selected as classes. Also, there are only 81 students, not 87. Double check the code.

Iteration 2

Change the red and green arrows in the final lists to flags to show what they mean. For example, green up arrow to green Math 4 flag.

Prompt Revision

For this iteration, keep all parameters the same, but adjust the format of the Attendance column to accept a 4-1 input with 4 = No Issues, 3 = Minor Issues, 2 = Moderate Issues, and 1 = Significant Issues. Add the flag to the final list using the same color coding as the other badges. Double check the code to ensure uniform functionality.

In the class list flags next to the student names, differentiate SPED Math and SPED Reading by showing a separate flag for each. Add the Speech flag and a Medical flag by the students' names if they have a check in that column. Balance the classes by including the Medical column as a sorting parameter. Students who cannot be together as noted in the Notes column currently have a red border around their names in the class lists. Add a blue border to any students who have teacher requests. In the class list, if the user hovers over the student's name block, provide a floating box summary with all of that student's flags and notes.

Iteration 3

The sorting is still including the "countif" function row and the Total # of Students rows. Double check the code to ensure that the countif row and the row below it along with any others below that should not be included. Only include rows with student names above the countif row.

Reference Image

Test CSV Preview

Video Tutorial