{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["How to use this log book","Front page","2016-17","Background to CPD in the GSS","Running Tally of CPD","Drop down list","Blank"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How to use this log book","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[25,1,25,3],[17,1,17,3],[19,1,19,3],[3,1,3,3],[5,1,5,3],[10,1,10,3]]}
[]
[null,null,"How to use this CPD log book"]
[null,"Background"]
[null,"This spreadsheet is designed to keep a record of the learning and development you have done to maintain and develop your skills and competencies. It should be simple and intuitive to use, but this instruction page gives you some hints and tips"]
[null,"Getting started"]
[null,"This template is designed to record your CPD (continuing professional development) for every year, starting from 2016-17. If you have been a member of the GSS in previous years, you should already have a record of your CPD for those years. You are not expected to copy across old material, but you may wish to keep a record of your running totals for CPD:"]
[null,null,"1. Click on the 'Running tally of CPD' page. For each year up to 2015-16, type in the number of hours of statistical and broader training you have completed. The totals and the running average are calculated automatically."]
[null,null,"2. Click on the 'Front page' and type in your name in the box provided."]
[null,null,"3. In cells c8 to e8, enter details of your current post, current grade and the date that this took effect."]
[null,"Filling in the CPD page"]
[null,"To record your CPD, there is a separate page for each year. Click on the '2016-17' tab. The broad idea is to record one row of information for each training and development action you have taken. The template is designed to record all your CPD; not just statistical aspects, but broader development too."]
[null,null,"1. Decide whether your development action relates to your statistical skills, or to the broader 'civil service competency framework' (CSCF) skills. Select from the drop down in column B."]
[null,null,"2. Describe the learning activity in column C (free text)."]
[null,null,"3. In column D, choose a competency area from the drop down box. This drop down box changes depending on whether you selected 'stats' or 'CSCF' in column B. Choose the competency or theme that fits most closely."]
[null,null,"4. Columns E to I refer to the five pillars of the GSS Strategy. Click on all that apply; whether or not your development action is statistics oriented (for example, you might find that 'Learning the basics of agile project planning' will help you to be more 'efficient', so tick that box. You can tick more than one box in this section, if relevant."]
[null,null,"5. In column J, record the type of development activity from the drop down box."]
[null,null,"6. Enter the date of the development activity, and the number of hours to record."]
[null,"Note that the running total of CPD on this page, and also on the 'running tally' page all update automatically."]
[null,"Year end and maintenance"]
[null,"This template has some simple 'macro' tools to enable you to record future years' learning and to ensure you have an up to date record of sign-off processes from your line manager. These are accessed from the 'front page' tab."]
[null,null,"1. On the 'Front page' tab, enter the name of the manager responsible for signing off your statistical development in the relevant box. If the person who signs off your broader skills is a different person, enter their name in the relevant box."]
[null,null,"2. When your manager has confirmed sign off of your CPD for the current year, simply click on the radio button next to their name, and enter the date."]
[null,null,"3. Click on the button 'click to add new year'. This will add a new sheet for the next financial year, and will add the name of that year (eg \"2017-18\") in the manager sign off box."]
[null,null,"4. If you move jobs, or change grade, during the year: Type in the new details in the table on the front page. If you run out of rows in this table, click on the button 'add row to career history table'."]
[null,null,"5. To print your log book, simply click on the button 'click to print your log book'. Top tip: if you have CutePDF installed on your computer, print using this option. Rather than producing a paper printout, this will convert your CPD into a pdf file."]

{"sheet":"Front page","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[23,7,23,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[17,2,17,4],[18,2,18,4],[16,7,16,8],[17,7,17,8],[1,1,1,7],[3,2,3,4],[15,7,15,10],[16,2,16,4]]}
[]
[null,"Statistician Group Member's CPD Log Book"]
[]
[null,"Name:"]
[]
[null,"Career History (Record changes of role, or changes of grade)"]
[null,null,"New Branch/ Division or Department:","New Grade:","Date from:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Assessment of Outcome"]
[null,null,"Statistical CPD",null,null,null,null,"Broader CPD"]
[null,"Year","Manager's/Mentor's name:",null,null,"Sign off","Date:","Manager's/Mentor's name:",null,"Sign off","Date:"]
[null,"2016/17"]

{"sheet":"2016-17","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,8],[6,9,7,9],[3,1,4,1],[6,10,7,10],[6,11,7,11],[3,4,3,8],[4,4,4,8],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,6,8]]}
[]
[null,"Appraisal year:",null,null,null,null,null,null,null,"2016-17"]
[]
[null,"Running Total:","Statistical","Broader","Total"]
[null,null,{"$f":"SUMIF('2016-17'!B:B,\"Stats\",'2016-17'!L:L)","v":2},{"$f":"SUMIF('2016-17'!B:B,\"CSCF\",'2016-17'!L:L)","v":0},{"$f":"C5+D5","v":2}]
[]
[null,"Type of skill\nselect from drop down menu ","Learning Activity\nFree Text","Statistical skill or broader competency\nselect from drop down menu ","GSS Pillars - click all relevant boxes",null,null,null,null,"Type of activity\nselect from drop down menu ","Date","Hours Completed            "]
[null,null,null,null,"Helpful","Innovative","Capable","Efficient","Professional"]
[null,"CSCF","Free text","Delivering Results: Achieving Commercial Outcomes",null,null,null,null,null,"Other training course"]
[null,"Stats",null,"Data analysis",null,null,null,null,null,"Involvement in collaborative or corporate GSS initiatives",null,2]

{"sheet":"Background to CPD in the GSS","index":3,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Background to Continuing Professional Development (CPD)"]
[]
[null,"It is compulsory for statisticians and data scientists in the Government Statistician Group to continue their professional development and to record the development activities in this log book. Maintaining effective CPD is part of your role as a professional statistician or data scientist."]
[]
[null,"In this log, you can record your learning activities against the relevant competencies; both the purely statistical competencies in the GSG competency framework but also broader competencies as set out in the civil service competency framework."]
[null,"The purpose of a CPD log"]
[]
[null,"The CPD process, and this log, have  the following aims:"]
[]
[null,"- to help you continuously to develop your professional skills;"]
[null,"- to help to set standards for managing and monitoring professional development across the GSG;"]
[null,"- to underpin the Statistician Competency Framework and support the Civil Service Competency Framework;"]
[null,"- to set out expectations for the number of hours a statistician or Data Scientist should devote to professional learning each year;"]
[null,"- to provide a process for recording and endorsing professional development throughout one’s career; and,"]
[null,"- to ensure a common approach to CPD is adopted across the GSG."]
[]
[null,"What counts as CPD"]
[]
[null,"CPD activities should be focussed on learning something new and relevant. It is sometimes helpful to refresh old knowledge, but the focus is on providing new insights,  competencies or learning. It is always the outcome of the learning rather than the method that matters. Any activity can count as CPD so long as something new and relevant has been learnt. "]
[]
[null,"Some examples of relevant CPD activity may include: "]
[null,"- formal qualifications, "]
[null,"- short training courses, "]
[null,"- conferences or seminars, "]
[null,"- reading, "]
[null,"- secondments, "]
[null,"- involvement in collaborative GSS initiatives,"]
[null,"- the acquisition of new statistical/data science skills, "]
[null,"- articles written to publications, or "]
[null,"- specific work experience or project aimed at developing a new skill"]
[null,"- teaching and coaching. "]
[]
[null,"How much CPD to do"]
[]
[null,"The GSG guideline for CPD is 60-100 hours per year, of which 30-50 hours should be statistical. "]
[]
[null,"The 30 hours of statistical learning is a compulsory minimum requirement, but there is no upper limit. The guideline is pro-rata for part-time workers."]
[]
[null,"It is recognised that the number of hours may fluctuate from year to year, but averaged over a five year period the minimum levels of statistical CPD must be achieved."]
[]
[null,"Key development needs should be identified at the start of the year but unplanned activity will also be a major feature of the CPD Log Book."]
[]
[null,"The role of CPD in Recruitment, Promotion and Badging"]
[]
[null,"Line managers of those in the GSG are expected to recognise CPD as a professional requirement and provide assistance to ensure that it is accomplished."]
[]
[null,"Ideally all members of the Statistician Group will have a statistician (any grade) involved in the planning and assessment of their learning – this will either be a member of their line management chain or a representative of the Head of Profession, e.g. statistical mentor."]
[]
[null,"GSS members on interview boards will ask for your 'CPD Log Book' and check that you have met the guideline. The information will show boards how you are developing professionally."]
[null,"developmental and not simply a repetition of existing skills and knowledge."]

{"sheet":"Running Tally of CPD","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,1,4,5]]}
[]
[]
[null,"This sheet updates automatically"]
[]
[null,"At a glance running tally of CPD"]
[null,"Year","Statistical","Broader","Total","5 year average STATS"]
[null,"2010-11",0,0,{"$f":"C7+D7","v":0}]
[null,"2011-12",0,0,0]
[null,"2012-13",0,0,0]
[null,"2013-14",0,0,0]
[null,"2014-15",0,0,0,{"$f":"AVERAGE(C7:C11)","v":0}]
[null,"2015-16",0,0,{"$f":"C12+D12","v":0},0]
[null,"2016-17",{"$f":"IFERROR(INDIRECT(\"'\"&B13&\"'!\"&\"c5\"),0)","v":2},{"$f":"IFERROR(INDIRECT(\"'\"&B13&\"'!\"&\"d5\"),0)","v":0},{"$f":"C13+D13","v":2},0.4]
[null,"2017-18",0,0,0,0.4]
[null,"2018-19",0,0,0,0.4]
[null,"2019-20",0,0,0,{"$f":"AVERAGE(C12:C16)","v":0.4}]
[null,"2020-21",0,0,0,{"$f":"AVERAGE(C13:C17)","v":0.4}]
[null,"2021-22",0,0,0,0]
[null,"2022-23",0,0,0,0]
[null,"2023-24",0,0,0,0]
[null,"2024-25",0,0,0,0]

{"sheet":"Drop down list","index":5,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Statistician Competency",null,"Type of skill",null,"Type of activity"]
["Acquiring data/understanding customer needs",null,"Stats",null,"Statistical training course"]
["Data analysis",null,"CSCF",null,"Other training course"]
["Presenting and disseminating data effectively",null,null,null,"Giving a presentation"]
["Working with credibility",null,null,null,"Attending a presentation, conference etc."]
[null,null,null,null,"Qualification"]
[null,null,null,null,"Mentoring / teaching / coaching (mentor or mentee)"]
[null,null,null,null,"On-the-job learning or development"]
[null,null,null,null,"Purposeful networking with other statisticians"]
["Levels",null,null,null,"Purposeful networking"]
["Level 1",null,null,null,"Teaching/coaching others"]
["Level 2",null,null,null,"Work shadowing"]
["Level 3",null,"CSCF Skills",null,"Involvement in collaborative or corporate GSS initiatives"]
["Level 4",null,"Setting Direction: Seeing the Big Picture",null,"Reading/ self-teaching"]
[null,null,"Setting Direction: Changing and Improving",null,"Other"]
["CSCF Levels",null,"Setting Direction: Making Effective Decisions"]
["Level 1",null,"Delivering Results: Achieving Commercial Outcomes"]
["Level 2",null,"Delivering Results: Delivering Value for Money"]
["Level 3",null,"Delivering Results: Managing a Quality Service"]
["Level 4",null,"Delivering Results: Delivering at Pace"]
["Level 5",null,"Engaging People: Leading and Communicating"]
["Level 6",null,"Engaging People: Collaborating and Partnering"]
[null,null,"Engaging People: Building Capability for All"]
[]
[]
[null,null,"Next year:"]
[{"$f":"MAX(A28:A34)+1","v":2017},{"$f":"VALUE(RIGHT(A27,2))+1","v":18},{"$f":"A27&\"-\"&B27","v":"2017-18"}]
[{"$f":"IF('Front page'!B18=\"\", 0,VALUE(LEFT('Front page'!B18,4)))","v":2016},null,"2019-20"]
[{"$f":"IF('Front page'!B19=\"\", 0,VALUE(LEFT('Front page'!B19,4)))","v":0}]
[{"$f":"IF('Front page'!B20=\"\", 0,VALUE(LEFT('Front page'!B20,4)))","v":0}]
[{"$f":"IF('Front page'!B21=\"\", 0,VALUE(LEFT('Front page'!B21,4)))","v":0}]
[{"$f":"IF('Front page'!B22=\"\", 0,VALUE(LEFT('Front page'!B22,4)))","v":0}]
[{"$f":"IF('Front page'!B23=\"\", 0,VALUE(LEFT('Front page'!B23,4)))","v":0}]
[{"$f":"IF('Front page'!B24=\"\", 0,VALUE(LEFT('Front page'!B24,4)))","v":0}]

{"sheet":"Blank","index":6,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[[6,9,7,9],[6,10,7,10],[6,11,7,11],[1,1,1,8],[3,4,3,8],[4,4,4,8],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,6,8],[3,1,4,1]]}
[]
[null,"Appraisal year:"]
[]
[null,"Running Total:","Statistical","Broader","Total"]
[null,null,{"$f":"SUMIF(B:B,\"Stats\",L:L)","v":0},{"$f":"SUMIF(B:B,\"CSCF\",L:L)","v":0},{"$f":"C5+D5","v":0}]
[]
[null,"Type of skill\nselect from drop down menu ","Learning Activity\nFree Text","Statistical skill or broader competency\nselect from drop down menu ","GSS Pillars - click all relevant boxes",null,null,null,null,"Type of activity\nselect from drop down menu ","Date","Hours Completed            "]
[null,null,null,null,"Helpful","Innovative","Capable","Efficient","Professional"]