EYFS Profile Assessment Spreadsheet

Save Resource

To save a resource you must first Join or Log In.

EYFS Profile Assessment Spreadsheet - EYFS, Early Years, assessment, ELG, EYFSP, Early Years Profile, Reception, Good Level of Development, Emerging, Expected, Exceeding
Description
Ratings & Reviews
Categories
Suggest a Change
Resource Updates
Log in Join
  • Help! I need to add more children than you give me space for. How do I add them to the spreadsheet?

    , Oct 10th
    • Hello :) Just to let you know we are going to make some different versions of this resource so you can add more children. It should be available shortly :)

      , Oct 14th
  • tracking children

    , Sep 28th
  • Have just downloaded this spreadhseet and entered names etc into the spreadsheet - and have just realised there is no 'data' tab to click on to transfer the ? Can you help? thanks

    , Sep 19th
  • Hi there everyone,
    Thank you all so much for your comments on this resource. This resource has now been fixed and works without any issues.

    You will need to ensure that when you open the spreadsheet, you click 'enable editing' and 'enable content' in the yellow bar towards the top of the spreadsheet.

    When you have put your data into the 'register' and 'data' tabs, you will need to click on the blue 'Generate Stats' button in order to transfer the data across to the other tabs of the spreadsheet. When you have clicked this, the tabs which contain the data you required will turn green whereas any irrelevant tabs will remain red.

    If you do find that you are still having difficulty using the resource please take a look at our lovely help video which you can download from underneath the pink download button.

    Have a lovely day everyone! :)

    , Sep 19th
  • Names aren't transferring to data boxes still - please help!

    , Sep 14th
    • Good afternoon sarastreet,
      Thank you very much for commenting! It's great to hear from you :) I'm sorry to hear you are having trouble with this resource. Have you tried the Help Video under the pink 'download' button? Let me know if you are still struggling :)

      , Sep 14th
    • We are having the same problem. We can fill in the register but the names do not appear on the data sheet. We have watched the video and they seem to appear automatically - not sure what we are doing wrong!

      , Sep 15th
    • Hi greatwoodfs,
      Thank you so much for letting us know about this one. I've checked this resource again and seem to be having the same problem. I've asked our resource team about this for you and someone will be in touch as soon as this has been looked into. I'm very sorry for any inconvenience this may be causing you and I hope you have a lovely day! :)

      , Sep 15th
    • Hey there Sara. I have now been informed that this resource has now been fixed. I've checked it myself and it is working just fine. When you open the spreadsheet, please ensure that you 'Enable editing' and 'Enable content' which will appear as a yellow bar towards the top of the page. If you could then have a go at filling in the register for me and then go onto the data tab that would be great. When you go to the data tab, the names should now automatically be transferred across.Our lovely help video might also be useful to help you fill in the rest of the spreadsheet. You can donwload it from underneath the pink download button. Please let me know if you have any further problems with this resource and have a lovely day! :)

      , Sep 19th
  • Lovely resource. I am having issues with transferring the register onto the data sheet. Please could you advise me how to do this? Also, how do you record emerging, expected. exceeding - is it just a colour exercise?

    Thank you

    , Sep 14th
    • Hi elmb77,
      Thank you very much for commenting! It's great to hear from you. There is a version with a help video available below the main download button, which should be useful for you. The data tab is in the process of being corrected and I will ask our lovely Design Team to send the new version of the resource out to you. Have a great day! :)

      , Sep 15th
  • Hi, is there a version of this available for key stage 1? Thanks

    , Sep 12th
    • Hi sarastreet,

      Thanks for your comment, it's great to hear from you!

      We have many wonderful resources on the Twinkl site so I was wondering if you could provide a few more details about the resources you're looking for?

      I hope you have a lovely day! : )

      , Sep 12th
    • Hi,
      I am looking for a tracker with the tabs for different groups, exactly the same as this but with the key stage 1 curriculum. Also I've tried to use this for EYFS but when I enter the children's names they are not showing up on the data tab but they are on the other tabs such as girls, boys etc. Is there anyway of fixing this so I don't have to type the names in again? Thank you :)

      , Sep 13th
    • Hi sarastreet,
      Thank you for your fantastic resource suggestion! Due to the large numbers of requests we receive every day, we are unable to make all of the resources requested. If we can make your resource we will be in touch to let you know, though we cannot guarantee when it will be completed. If there is anything else I can help with, please let me know! Have a great day :)

      , Sep 13th
    • Hi sarastreet,
      We will also make sure that the data tab is working correctly for you :) Our lovely Design Team will be in touch soon! Have a good evening.

      , Sep 13th
  • Hi, is there a version available that has the same amount of information about each child but is for the development matters descriptors leading up to the Early Learning Goal where you can just put from a drop down if the child is 30-50L, 30-50S or 30-50H etc for that strand? And so you can input data 4 times a year?

    Thanks

    , Sep 10th
  • Hi,

    There aren't any tabs at the bottom of the spread sheet when I open up the main version or the simple Excel version. I have watched the help video but the document doesn't look the same as that one when I open it up, even after enabling editing and enabling content. Is it something to do with the version I have on my laptop? I have Excel 2010?

    Any help appreciated as the spread sheet looks great!

    Thanks

    , Sep 10th
    • Hi cburgess,
      Thanks for commenting and I'm sorry you're having trouble downloading this resource.

      I've taken a look at this and it appears to open and display properly for me here. I will e-mail you over a copy and see if that rectifies the problem.

      Have a lovely day! :)

      , Sep 10th
  • This is a great resource! I am struggling to add my data (to practice) and I cannot

    , Sep 7th
    • Hi bellelouise,
      Thank you very much for commenting! It's great to hear from you. We have a version of this resource with a handy help video available below the main download button. I hope this is useful for you. Let us know if you need any further help. Have a great day! :)

      , Sep 7th
  • This is a fantastic resource to use at the end of the year! It's great that all the figures are done automatically, it will save me a lot of time! Thanks so much.

    , Sep 4th
  • When I

    , Sep 2nd
    • Hi HolH93,
      Is there something that we can help you with on this resource?

      , Sep 2nd
  • This resource has been completely updated to include new, more in depth functionality. Please see the description for further details. We hope you find it useful!

    , Aug 31st
  • This is great and thank you for making the requested changes. I've put all my data in. The % for emerging in each of the 3 strands of Speaking and listening have come out incorrectly. Can someone help me with this please? Thanks.

    , Aug 2nd
    • Hi banana82,
      Thank you so much for letting us know about this one. I'll get this looked at right away!

      , Aug 2nd
  • Hi there,
    I love this resource but I am having trouble with the formulas, it seems that after the 42nd child, the numbers are no longer turning the boxes to the correct colour or working with the formulas - does anyone know why? probably something I've done wrong!

    Thank you

    , Jul 22nd
    • Hi becki131,
      Thank you very much for commenting! It's great to hear from you :) I'm sorry to hear you are having trouble with the formulas.Would it be possible to send us a couple of screenshots so that I can pass this over to our technical team? Have a lovely day :)

      , Jul 22nd
    • Hi Lucy,
      Thanks so much for getting back to me. I closed and reopened/ started again a few times and still having the same problem :( Of course- is there an email address I can send them to?
      Becki :)

      , Jul 22nd
    • Hi becki131,
      Thank you so much for letting us know about this one. I'll send this over for our Design Team to look at right away! If they need any further information, they will be in touch with you :)

      , Jul 23rd
    • Great, thank you :) it's perfect up until the 42nd child then it comes up with 1= 1% instead of turning it red!

      , Jul 23rd
    • Hi becki131,
      Thank you very much for getting back to us. I will pass this on to the Design Team and they will get back to you very soon :)

      , Jul 23rd
    • Hi there, do you know if anyone got to the bottom of the problem? Has anyone else had the same problem? I'd really like to be able to use it soon! X

      , Jul 25th
    • Hi there, thanks for getting in touch. I will get this chased up for you now, to find out what the problem appears to be. I will be in touch with you when I know more. Thanks for your patience on this matter. :)

      , Jul 25th
    • I've received it! Thank you to you all at Twinkl for your help and really quick responses! Made my life much easier, thank you so much :)

      , Jul 25th
    • Hi becki131,
      Thank you for your feedback! I'm really glad we could help :)

      , Jul 25th
  • I can't enter any scores! I'm pretty sure it's my fault, but I'm at a loss!

    , Jul 4th
    • Hi HelenRatcliff,
      Thanks for getting in touch!

      When you open this resource and go to the 'ELG" tab at the bottom of the spreadsheet, you should then be able to click in the relevant boxes and then enter your data. If you are not able to do this, please ensure that you have enabled editing for this resource(there may be a yellow bar at the top of the screen and a box which says 'enable editing). If you could take a look at this for me and let me know if you are still having issues, that would be great.
      Have a lovely evening! :)

      , Jul 4th
  • Brilliant! Just what I have been looking for and perfect for pupil progress and data analysis. The only thing missing for me is analysis against gender eg. number of girls/boys achieved expected or above in each area. I know it's just a case of putting the right formula in the right boxes but am not sure how to work out the formula. Is there anyone who could help me with this please?

    , Jul 4th
    • Hi banana82,

      Thank you for your resource suggestion on the Twinkl website.

      If we're able to make this for you we'll be in touch shortly to let you know.

      I hope you have a lovely day! : )

      , Jul 4th
    • Hi there banana82,
      We've made this resource for you and have sent it in an email, I hope you find it useful! It will also be available for download on the website within 48 hours, and you can find it either as a main resource, or under 'Alternative versions' above.

      , Jul 6th
  • Amazing! Great resource!!

    , Jun 3rd
  • Saving time

    , Jun 1st
  • Looks great... but not supported in the android excel apps (to do with 'form control's) :(

    , May 20th
    • Hi Jessl89,
      Thank you for commenting! I will ask our lovely Web Team if anything can be done about this for you! I hope you have a lovely day :)

      , May 21st
  • I am using this for evidence to give to my senior management team - absolutely brill! Thank you so much!

    , May 18th
    • Hi katietorocisk,
      Thank you very much for commenting! It's great to hear from you :)

      , May 18th
  • I entered all of my children's data, but it kept saying runtime error?

    , May 13th
    • Hi SarahMartin,
      Thank you for commenting! Can you tell me a little more about the problem you are having? Have you downloaded and saved the resource before editing it? It sounds like an issue with your computer settings, but any further details would be helpful! :)

      , May 14th
EYFS Profile Assessment Spreadsheet

EYFS Profile Assessment Spreadsheet - An extremely useful Excel spreadsheet that enables you to record ELG assessment scores for each child in your class or setting. It automatically calculates a number of useful functions such as percentages of the class achieving emerging, expected or exceeding for each goal and also whether the Good Level of Development has been achieved. It also calculates statistics for gender, FSM, SEND, LAC, pupil premium, birth season, EAL and Vulnerable Groups. Full instructions on how to use the spreadsheet are contained on the first tab of the resource. There is also a help video which guides you through how to use it - this can be found as an alternative version beneath the download button.
This resource is available in Help Video, Simple Excel and Standard.
  • Homepage » Early Years » Foundation Assessment » EYFS Tracking Sheets
  • Homepage » Early Years » Foundation Assessment » Early Learning Goals
  • We love to hear your ideas! If you’d like to see another version of this resource, you’ve had a great idea for how we could improve it or you’ve spotted a mistake then let us know by filling in your details below.

    Please try to be as specific as you can :)

    • Twinkl updated the Main Version on Oct 31st
    • Twinkl added Simple Excel Version on Aug 31st
    • Twinkl added Help Video Version on Aug 31st

    Log In