Back to Tutorials

Configuring Your Contextual Data

A guide for Non-SIMS schools

Share this page...

Step 2: Updating Data

There are numerous ways to now update those columns with the correct data. In this example we will show the easiest option based on technical ability. This option isn't neccessarily the quickest option. For the more technically able, further down on this page is a list of options against their heading if you wish to use a validation method to populate your sheet.

At this point you will need access to your school's contextual data. Depending on how you have this will obviously change the way you populate Frog. We assume you have a printed list of the following contextual data groups...


- English as an Additional Language

- Gifted and Talented

- Pupil Premium

- Free School Meals

- Service Children

- In Care

- Traveller Children


SYSTEM DEFAULTS: If a contextual data cell is left blank against any pupil the import and therefore Frog will base that information as, 'Not Known'


Reference images


Ref image 1 - Create a horizontal freeze pane


Ref inage 2 - Use find (Ctrl+F)


Data Validation


The newly created columns can only present certain values. Here's a list of those values against their relevant column heading.


Column Heading Data Values
SEN Not Known (empty), Yes, No
English as an Additional Language Not Known (empty), Yes, No
Gifted and Talented Not Known (empty), Yes, No
Pupil Premium Not Known  (empty), Yes, No
Free School Meals Not Known (empty), Yes, No
Service Children Not Known (empty), Yes, No
In Care Not Known (empty), Yes, No
Traveller Children Not Known  (empty), Yes, No


Tutorials in this series...

product hubs

FrogProgress-600_600.png  FrogLearn 600_600.png  FrogPlay 600_600.png

Product updates

A sneak peek at the new Frog App and updates to the Frog interface.
Save time with pre-populated site templates
FrogLearn now has over 30 mobile themes
How we can work with Multi-Academy Trusts
Progress Hub - All about our student progress tracker
All about our student progress tracker
All about our online assessment system
Helpful information that relates to GDPR functionality inside the Frog platform
Get access and use all our in-platform Site templates
Save time with pre-populated site templates