How do I prepare further education teaching data and post data for import?

Modified on Tue, 10 Dec at 3:10 PM

Within Cintra iQ, you can create a Further Education Workforce Data (FEWD) staff record to be submitted to the Further Education body. Use the attached FEWD_Cintra.xlsx and FEWD_Import_POST_Cintra.xlsx files as templates to collect your data before you import it into Cintra iQ.

Important:

From the year 1 August 2021 to 31 July 2022, it is a mandatory requirement for FE establishments to submit further education workforce data. For further details visit the UK government web site at https://www.gov.uk/government/publications/further-education-workforce-data-collection

FEWD_Cintra template

Tips for filling in data

You can enter data in any of the Person Id, DFES Number or NI Number columns in order for the import process to identify which employee in the Cintra iQ database the record refers to,
You can track the progress of the spreadsheet completion by entering the First Name and Last Name of each employee.

Note:

The First Name and Last Name columns are not used in the import to identify employee records.
Dates should be entered in the format DD-MMM-YYYY, e.g. 25-May-1967
You should complete columns I to Y by selecting one of the options in the drop-down lists which become available when you click in a column.

FEWD_Import_POST_Cintra template

Tips for filling in data

Column A should be completed by entering a valid Post Reference (i.e. a post reference which exists in the Cintra iQ database.)
Columns B to C should be completed by selecting one of the options in the drop down lists which become available when the user navigates to a column.

Saving Data

When you use the templates for collating data in Excel, you should save the data as a spreadsheet in order to retain the drop-down functionality. Once you have entered the data in the relevant worksheets, you must save the file in a .csv format before importing it into Cintra iQ.

For more information about importing FEWD standard teaching data and post data, see How Do I Import Further Education Workforce Data into Cintra iQ?

Attachments (2)

xlsx

FEWD_Import_....xlsx
26.9 KB

xlsx

FEWD_Cintra_(2).xlsx
461 KB