Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Removed

Live Searchadditionalnone

Live Search
sizelarge
additionalpage excerpt
placeholderSearch our Help Centre

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColortitle#F4F5F7

Useful Information

Cohorts can be created by importing data from the school pupil management system (for example SIMS, Progresso, CMIS, Scholarpack, Bromcom, Arbor, PupilAsset, Integris G2).
An example might be for subject sets, e.g. for Geography Set8A.
To import cohorts into SCO, you will need to generate a report from your pupil management system and import the pupil data into SCO.

Import a Cohort

1. Create a Cohort

  1. Click on

...

  1. the Configuration

...

  1.  tab

...

  1. Select Account configuration

...

  1. Select Cohorts

  2. Click on Cohorts and groups

...

  1. Click Add

  2. Enter the cohort Name Subject

...

  1. Click Done

...

2. Create a Cohort Report

a. Check which Pupil ID you are using in SCO

  1. Click on

...

  1. the Configuration

...

  1.  tab

  2. Click

...

  1. on System options

  2. Click on

...

  1. the General

...

  1.  tab

  2. Note

...

  1. the Pupil ID field used for

...

  1. imports 
    (usually either Pupil ID, UPN or Admission Number)

  2. Note

...

  1. the Staff ID field used for

...

  1. imports 
    (usually Staff ID)

  2. Click

...

  1. on Done


...

b. Locate a Sample Pupil ID 

  1. Click on

...

  1. the Accounts

...

  1.  tab

  2. Note

...

  1. the Last name, First name

...

  1.  and Pupil ID

...

  1.  for the first pupil


...

c. Create a Cohort Report 

  1. See the Sample Data Sets below to create a report

  2. Ensure the ID field matches the fields noted above

  3. Add the relevant fields required for cohorts using the field headings Subject and Cohort

  4. This will produce a report showing each pupil and their current cohort

  5. Save the Excel file as a CSV (comma delimited)


IMPORTANT: Before importing pupil data, carefully review the data to ensure that you have the expected pupil data.


...

3. Import the New Pupil Data

This only needs to be carried out once and can be done from any client PC.

  1. Click on

...

  1. the Configuration

...

  1.  tab

...

  1. Select Import from external system

...

  1. Select Cohort import

  2. Select the CSV file you saved earlier and

...

  1. click Open

  2. A message will appear confirming that the Cohort column has been set - click Yes to continue

  3. Review the next screen carefully reviewing any errors or discrepancies

  4. Enter a name for the Cohort group e.g. Subject

  5. Click Confirm

  6. Once complete,

...

  1. click Close, Close

...

4. Review the Cohort Data

  1. Click on

...

  1. the Configuration

...

  1.  tab

...

  1. Select Account configuration

...

  1. Select Pupils

  2. Select

...

  1. the Cohorts

...

  1.  tab

  2. Click

...

  1. the +

...

  1.  sign to the left of a cohort to view the pupils in the cohort

...

SAMPLE DATA SETS

Data set 1 - Sample of Secondary School Subject Set import (multiple lines per pupil)

...

Data set 2 - Sample of single cohort import (1 line per pupil)Image Removed

...


See also

Using Cohorts

...