1. Home
  2. Curriculum
  3. How to Bulk Assign Students to Groups using Import/Export

How to Bulk Assign Students to Groups using Import/Export

Note: All pages below are subject to having the relevant Roles and Permissions.

Administrators can use this process to Bulk Assign Students to Classes, Tutor Groups and Bands by creating and Exporting a Spreadsheet from Bromcom to send to Departmental Staff to populate or amend and then Import back into the system.

If this process is being used to Bulk Assign Students to classes in the next academic year, please see End of Year Secondary.

If you do not need to amend a spreadsheet before completing this process, see How to Bulk Assign Students to Groups.

From the left Menu go to Modules > Curriculum and from Routines select Bulk Group Assignment 

There are four options for adding Students to Groups which can be selected from the Bulk Update Type dropdown list. The options are, Class MembershipsTutor Group MembershipsClass Memberships via Block and Band Memberships. In this example, we are assigning Class Memberships.

NoteClass Memberships via Block requires Students to have been added to Groups already.

Create the Export Sheet

Select the Group Name of the Classes by clicking on the spy glass to the right of Group Name (this will be quicker than typing individual Groups). In this example 2 x Year 10 English classes have been selected.

Important Note: When searching for a Group in the next academic year, change the Active Date Filter in the Group Selector List to a date in the next Academic Year. This also applies when searching for students in the Student Selector List.

Select the classes you require and then click the Done button at the top right.

Next, find the Students using the associated Find button and again use the Filters to make the required selection of Students, select the students required and click Done to make the selection and return to the Bulk Assignment page. In this example the Year 10 Students have been selected to match the Year 10 English classes selected.

Click the Done button at the top right.

Click the Export button and then Export again a csv. file will be downloaded with an export name, with a similar format to StudentClassExport_1907201912345. Rename this if desired.

Populating the Spreadsheet

The Spreadsheet can then be forwarded to the required Departmental Staff for example Head of English to amend the 2 columns in this example populated with the capital letter T.

If populating students for the next academic year enter the capital letter T into each cell of the Groups required.

It is necessary to make sure that both Students and Groups have at least one T Membership. If no T exists for a Student or Group, these will not be Imported.

Important Note : In order to import the spreadsheet it is important to keep the format as exported from Bromcom.

Save the csv sheet once completed.

Importing the Spreadsheet

Once the Spreadsheet has been returned completed with amendments/additions ready to be imported, save the spreadsheet locally.

To Import the completed spreadsheet, there is no need to select Students or Groups first.

With the appropriate Membership selected from the dropdown list, click Import.

Complete the details, again paying attention to the Active On date.

If any of the selected Groups for example Teaching Classes have an individual End Date before the Active on date selected, then these Groups will not appear in the Import.

The Start Date is the date the Students will be assigned to the Groups selected, so in the example that the next academic years memberships are being updated the Start Date would be in the next academic year.

Click Import when you’re done.

Changes can be made to this page before saving, using the tools available, then click the Save or Save & Close button.

Updated on April 30, 2021

Was this article helpful?

Related Articles

Noticed a Missing Guide?
Can't find the guide you need?
Email Us

Leave a Comment