{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["COVER","QUANTITATIVE AUDIT CHECKLIST","General_information","KEY AREA_1","KEY AREA_2","KEY AREA_3","KEY AREA_4","KEY AREA_5","SUMMARY OF MAIN INDICATORS","MENUAK"],"not_rendered":{"charts":12,"images":8,"macros":1,"external_links":0,"defined_names":0,"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":"COVER","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"QUANTITATIVE AUDIT CHECKLIST","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,9],[41,0,41,13],[42,0,42,13],[44,0,46,13],[4,1,4,5],[2,0,2,13]]}
["THE QUANTITATIVE AUDIT CHECKLIST STRUCTURE AND CONCEPTUAL FRAMEWORK"]
[]
["The Quantitative Audit Checklist, is an the Excel tool you will use to collect all the quantitative data for the participatory audit procedure. The document is divided in 8 different TABS. This is the main structure of the document (click to directly be re-directed to the part of the document): "]
[]
[null,"GENERAL INFORMATION ABOUT THE INSTITUTION"]
[]
[null,null,"KEY AREA 1 "]
[null,null,"The governance bodies, key actors and decision-makers "]
[null,null,"1.1. Governing and decision-making bodies"]
[null,null,"1.2. Gender equality structures in the institution"]
[]
[]
[null,null,"KEY AREA 2"]
[null,null,"Recuitment,career progression and retention"]
[null,null,"2.1. Student data"]
[null,null,"2.2. Selection and recruitment"]
[null,null,"2.3. Career progression "]
[null,null,"2.4. Gender pay gap "]
[]
[null,null,"KEY AREA 3 "]
[null,null,"Work and personal life integration"]
[null,null,"3.1. Data on Caring-responsabilities of the RPO's academic staff"]
[null,null,"3.2. Work and personal life integration policies in the institution"]
[null,null,"3.3. Measures to keep the link with people on parental leave and to promote joint responsibility in care"]
[]
[]
[null,null,"KEY AREA 4"]
[null,null,"Researchers and Research: gender equality among researchers and gender perspective/sex in research "]
[null,null,"4.1. Academic and research staff data"]
[null,null,"4.2. Gender perspective in research project management"]
[null,null,"4.3. The integration of the gender dimension in Research"]
[]
[]
[null,null,"KEY AREA 5 "]
[null,null,"Integration of gender/sex  dimension  in teaching curricula"]
[null,null,"5.1. Gender-mainstreaming in teaching curricula"]
[]
[]
[]
[null,null,"GRAPHS"]
[]
["Inside each of this areas, you will find a set of charts which are numbered in reference to the area and topic they will help us analyze. (This is the way charts have been referenced: KEY_AREA_NUMBER.TOPIC_NUMBER.NUMBER_OF_CHART)"]
["Each chart also has a set of notes referenced with the number of the chart that it corresponds to. This notes, will help you understand the information that is required in each of the charts, and the way each of them should be filled-in.  Please, read the notes before filling-in any information. "]
[]
["Which data should my RPO gather? We propose to gather data from the previous Academic Year XXXX_YY, and data at 31st december XXXX (of the previous year) in cases regarding academic staff, as those numbers could vary along the year. In any case, it should be specified if the RPO has gathered data from another year for any reasons. Along the document we have specified the relevant years data should be collected from, XXXX being 2015 in the case of Plotina RPOs and AY XXXX_YY being 2015-16. "]
[]
[]
[]
["This is a flexible document, that will have to be adapted to the reality of each of the RPOs, regarding structure and specific terminology. "]

{"sheet":"General_information","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[6,4,6,7],[19,1,19,2],[21,1,21,2],[23,1,23,3],[9,6,9,13],[10,6,10,13],[11,6,11,13],[12,6,12,13],[13,6,13,13],[14,6,14,13],[24,1,24,2],[14,1,14,2],[11,1,11,2],[12,1,12,2],[6,0,6,1],[10,1,10,2],[15,1,15,2],[17,1,17,2],[13,1,13,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[8,1,8,3],[9,1,9,2],[42,1,48,3],[25,1,25,2],[26,1,26,2],[27,1,28,1],[29,1,30,1],[31,1,40,1],[41,1,41,3]]}
["PLOTINA- Quantitative Audit Checklist"]
[]
["General information about the institution"]
["Name of the organization (RPO)"]
["Name of the person who has gathered the information"]
["E-mail address or contact information"]
["Data collection date",null,null,null,"RETURN TO THE MAIN PAGE"]
[]
[null,"General information about the RPO",null,null,null,null,"NOTES: "]
[null,"Ownership ",null,"Specify %",null,null,"1. For state owned organizations, public funds would be 100%."]
[null,"Public funds 1",null,null,null,null,"2.  The total needs to be 100%."]
[null,"Private male owners",null,null,null,null,"3. Number of men elected as representatives."]
[null,"Private female owners",null,null,null,null,"4. Number of women elected as representatives."]
[null,"Male members of the cooperative and/or workers",null,null,null,null,"5. Name of the Trade Unions that got representation. "]
[null,"Female members of the cooperative and/or workers"]
[null,"Another organization 1"]
[null,"Name organization 1"]
[null,"Another organization 2"]
[null,"Name organization 2"]
[null,"Another organization 3"]
[null,"Name organization 3"]
[null,"TOTAL 2 ",null,{"$f":"SUM(D11:D21)","v":0}]
[]
[null,"MANAGEMENT "]
[null,null,null,"Put an X or the N"]
[null,"Is there a Human Resources department?"]
[null,"Do workers have trade union representation?"]
[null,"If the previous answer is \"yes\"…","Number of men represantative 3 (elected)"]
[null,null,"Number of women represantative 4 (elected)"]
[null,"GENDER EQUALITY PLAN (GEP)","Do you have a Gender Equality Plan?"]
[null,null,"If you already have a GEP, specify the valid period of it"]
[null,"Other  Plans or Regulations into effect (put an \"X\" when it applies)","Strategic Plan"]
[null,null,"Work-life Balance Plan"]
[null,null,"Social Responsibility Plan"]
[null,null,"Health and Safety Plan"]
[null,null,"Risk Assessment Plan"]
[null,null,"Diversity Management Plan"]
[null,null,"Regulation on the prevention and response to sexual harassment in the workplace "]
[null,null,"Language management Plan"]
[null,null,"Environmental Plan"]
[null,null,"Other (please specify)"]
[null,"Relevant national policy on gender equality: Please indicate below reference for the national policies (i.e. number and year of the law and/ore regulation)  as well as the main provisions in terms of gender"]

{"sheet":"KEY AREA_1","index":3,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[24,10,25,12],[24,6,24,9],[24,1,25,3],[24,4,24,5],[36,1,36,10],[37,1,37,10],[35,1,35,10],[40,1,41,2],[26,1,26,2],[38,1,38,10],[27,1,27,3],[28,10,28,12],[26,10,27,12],[29,10,32,12],[34,1,34,10],[11,8,14,12],[19,1,19,2],[15,8,15,12],[16,8,19,12],[0,0,0,4],[9,1,9,2],[9,3,9,4],[9,5,9,6],[10,8,10,12],[2,6,2,8],[2,2,3,5],[1,2,1,5]]}
["PLOTINA- Quantitative Audit Checklist"]
[null,null,"KEY AREA 1"]
[null,null,"Governance bodies, key actors and decision-makers ",null,null,null,"RETURN TO THE MAIN PAGE"]
[]
[]
["1.1.- Governing and decision-making bodies"]
[]
[null,"Chart 1.1.1.- Composition of the Governing bodies/Decision-taking bodies"]
[]
[null,"Please list  the governing bodies and their  tasks",null,"Composition today 6",null,"Composition today 6",null,null,"NOTES 1.1.1: "]
[null," Name of the  Body 7","Tasks (roles and responsibilities)","Women 9","Men 9","% Women","% Men",null,"6. \"Today\" refers to the date on which this data is compiled. If you are coleecting data from 2017, then it would be the composition on 31/12/2017."]
[null,null,null,null,null,{"$f":"D12*100/($D$20+$E$20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,"7. In this chart we specifically need information about the governing bodies of the whole university (Rector, Academic Senate, Board of director, and so on) and/or  the governing bodies of teaching and research structures (Deans of Department, School Chairs, Presidents of Research Center, etc.)."]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"8. Number of women and number of men in each body."]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"9.  The percentage shows the horizontal segregation among governing bodies. The presence of women or men from the total who participate in governing bodies and decision-taking bodies to participate in each of them. \n(Reference: http://eige.europa.eu/rdc/thesaurus/terms/1247)"]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL in governing bodies",null,{"$f":"SUM(D11:D19)","v":0},{"$f":"SUM(E11:E19)","v":0},{"$f":"D20*100/(D20+E20)","v":{"$error":"#DIV/0!"}},{"$f":"E20*100/(D20+E20)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["1.2.- Gender equality structures in the institution"]
[null," Chart 1.2.1. Gender equality structures in the institution",null,null,"If yes, how many? 11",null,"Participants 12",null,null,null,"How often does this group meet? 13 "]
[null,null,null,null,"Women","Men","Departments","Women","Men","Total"]
[null,"Is there a person or a group of people of reference for gender equality matters? 10",null,null,null,null,null,null,null,{"$f":"SUM(H27:I27)","v":0}]
[null,"TOTAL 14",null,null,{"$f":"SUM(E27:E27)","v":0},{"$f":"SUM(F27:F27)","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,"If other, please specify: "]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,"TOTAL 14",{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(I27:I32)","v":0},{"$f":"SUM(J27:J32)","v":0}]
[null,"NOTES 1.2.1: "]
[null,"10. Choose from menu."]
[null,"11. If previous question was answered yes, specify how many women and men participate in that structure/group."]
[null,"12. Name the departments/faculties/schools that are represented in the group and how many women and men participate from each of them. If the group does not have participant from departments but it is elected for the whole university, please indicate Not Applicable."]
[null,"13. Is there a calendar of meetings for this group? Specify the frequency of meetings during 1 year. For example it might meet every two months, or twice a year, etc.. Choose from the menu, and if your response is \"other\" you can give details in the following line. "]
[null,"14. The two totals should match. If not, please check if there has been a mistake. "]
[]
[null,"Go to KEY AREA 1 GRAPHS"]

{"sheet":"KEY AREA_2","index":4,"n_rows":219,"n_cols":14,"rows_kept":219,"cut":false,"hidden":false,"merged":[[157,16,157,21],[156,16,156,21],[145,11,146,12],[141,13,142,13],[143,11,144,12],[143,13,144,13],[145,13,146,13],[139,8,140,9],[143,10,144,10],[145,10,146,10],[159,16,159,21],[185,4,185,5],[97,1,97,2],[100,1,100,2],[199,1,199,10],[184,2,186,2],[184,3,186,3],[185,8,185,9],[185,6,185,7],[185,10,185,11],[147,10,148,10],[120,1,122,1],[147,8,148,9],[105,3,105,6],[103,1,103,2],[105,1,105,2],[110,17,110,20],[111,17,111,20],[111,1,111,8],[112,1,112,8],[113,1,113,8],[158,16,158,21],[121,10,121,13],[141,1,149,1],[109,17,109,20],[65,5,65,8],[103,3,103,6],[85,1,87,3],[67,2,69,3],[70,2,72,3],[67,1,69,1],[70,1,72,1],[79,1,81,1],[82,1,84,1],[73,2,75,3],[76,2,78,3],[79,2,81,3],[101,1,101,2],[99,1,99,2],[108,1,108,8],[109,1,109,8],[73,1,75,1],[76,1,78,1],[90,1,90,8],[91,1,91,8],[82,2,84,3],[102,1,102,2],[98,1,98,2],[62,15,62,20],[37,1,37,5],[37,6,37,9],[8,1,8,5],[8,6,8,9],[25,2,27,3],[22,2,24,3],[10,1,12,1],[10,2,12,3],[22,1,24,1],[42,2,44,4],[48,2,50,4],[45,2,47,4],[51,1,53,1],[25,1,27,1],[28,2,30,4],[54,1,56,1],[39,1,41,1],[32,1,32,9],[33,1,33,9],[42,1,44,1],[48,1,50,1],[39,2,41,4],[54,2,56,4],[0,0,0,4],[1,0,1,1],[19,2,21,3],[16,2,18,3],[13,2,15,3],[9,2,9,3],[13,1,15,1],[16,1,18,1],[19,1,21,1],[7,1,7,9],[3,4,3,6],[1,2,1,3],[2,2,3,3],[123,0,126,0],[206,0,209,0],[149,8,150,9],[149,10,150,10],[139,13,140,13],[139,11,140,12],[139,10,140,10],[141,10,142,10],[152,8,152,13],[153,8,153,13],[154,8,154,13],[155,8,155,13],[156,8,156,13],[157,8,157,13],[205,2,205,3],[200,1,200,10],[184,4,184,11],[141,8,142,9],[141,11,142,12],[150,1,158,1],[139,1,139,6],[177,1,177,2],[182,11,183,11],[168,1,176,1],[159,8,159,13],[160,8,160,13],[161,8,161,13],[34,1,34,9],[61,1,61,9],[62,1,62,9],[36,1,36,9],[38,1,38,9],[45,1,47,1],[57,2,59,4],[65,1,65,4],[66,2,66,4],[64,1,64,8],[159,1,167,1],[120,10,120,13],[110,1,110,8],[96,1,96,6],[51,2,53,4],[116,2,116,8],[92,1,92,8],[218,1,219,2],[120,2,121,5],[120,6,121,9],[182,1,183,10],[184,1,186,1],[104,1,104,2],[104,3,104,6],[128,1,129,1],[133,1,133,9],[134,1,134,9],[135,1,135,9],[136,1,136,9],[137,1,137,9],[214,1,215,9],[143,8,144,9],[145,8,146,9],[158,8,158,13]]}
["PLOTINA- Quantitative Audit Checklist"]
[null,null,"KEY AREA 2"]
[null,null,"Recuitment, retention and career progression"]
[null,null,null,null,"RETURN TO THE MAIN PAGE"]
[]
["2.1.- Student data (REFERENCE FOR THIS DATA SHOULD BE THE LAST AY)"]
[]
[null," Chart 2.1.1.- Number of undergraduate students in AY 2017/18 15 "]
[null,"Programme",null,null,null,null,"Number of students enrolled inthe last AY 16"]
[null,"School/ Faculty ","Name of degree/program",null,"Degree duration 17",null,"Women","Men","% women","% men"]
[null,null," name program 1… ",null,null,"Full-time",null,null,{"$f":"((G11*100)/(G11+H11))","v":{"$error":"#DIV/0!"}},{"$f":"((H11*100)/(H11+G11))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E11:E12)","v":0},"Total",{"$f":"SUM(G11:G12)","v":0},{"$f":"SUM(H11:H12)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," name program 2… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E14:E15)","v":0},"Total",{"$f":"SUM(G14:G15)","v":0},{"$f":"SUM(H14:H15)","v":0},{"$f":"((G16*100)/(G16+H16))","v":{"$error":"#DIV/0!"}},{"$f":"((H16*100)/(H16+G16))","v":{"$error":"#DIV/0!"}}]
[null,null," name program 3… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E17:E18)","v":0},"Total",{"$f":"SUM(G17:G18)","v":0},{"$f":"SUM(H17:H18)","v":0},{"$f":"((G19*100)/(G19+H19))","v":{"$error":"#DIV/0!"}},{"$f":"((H19*100)/(H19+G19))","v":{"$error":"#DIV/0!"}}]
[null,null," name program4… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E20:E21)","v":0},"Total",{"$f":"SUM(G20:G21)","v":0},{"$f":"SUM(H20:H21)","v":0},{"$f":"((G22*100)/(G22+H22))","v":{"$error":"#DIV/0!"}},{"$f":"((H22*100)/(H22+G22))","v":{"$error":"#DIV/0!"}}]
[null,null," name program 5… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E23:E24)","v":0},"Total",{"$f":"SUM(G23:G24)","v":0},{"$f":"SUM(H23:H24)","v":0},{"$f":"((G25*100)/(G25+H25))","v":{"$error":"#DIV/0!"}},{"$f":"((H25*100)/(H25+G25))","v":{"$error":"#DIV/0!"}}]
[null,null,"… more rows can be added if needed",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"SUM(E26:E27)","v":0},"Total",{"$f":"SUM(G26:G27)","v":0},{"$f":"SUM(H26:H27)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"TOTAL",null,null,"Full-time",{"$f":"SUM(G26,G23,G20,G17,G14,G11)","v":0},{"$f":"SUM(H26,H23,H20,H17,H14,H11)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",{"$f":"SUM(G27,G24,G21,G18,G15,G12)","v":0},{"$f":"SUM(H27,H24,H21,H18,H15,H12)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G29:G30)","v":0},{"$f":"SUM(H29:H30)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"NOTES 2.1.1: "]
[null,"15. The baseline for this grid will be the enrolment data from the last Academic Year (as an example we have foreseen AY 2017/18) dissagregated by sex. We will use information regarding  amount of students enrolled at the first year of each degree-programme. We will specify number of students per programme and option (full-time / part-time). For a more exhaustive analysis it could also be interesting to look at the number applications from 1st year students dissagregated by sex, and data about amount of students who will graduate in the present AY  (ex. AY 2017/18), to compare the level of achievement among women and men in different degrees. "]
[null,"16. Number of students enrolled in the 1st year in the last Academic Year ( for example AY 2017/18)"]
[null,"17. For example in the case of Italy: it would be 3 years if it is a \"Degree\" or 5 years if it is a \"single cycle Degree/ciclo unico\". Rest of RPOS: just specify the duration in term of number of years of each of the degree programmes you have included. "]
[]
[null,"Chart 2.1.2.- Number of men and women on master degrees  in AY 2015/16 18"]
[null,"Programme",null,null,null,null,"Number of students enrolled in AY 2015/16 19"]
[null,"School/ Faculty ","Name of master",null,null,null,"Women","Men","% women","% men"]
[null,null," name program 1… ",null,null,"Full-time",null,null,{"$f":"((G40*100)/(G40+H40))","v":{"$error":"#DIV/0!"}},{"$f":"((H40*100)/(H40+G40))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G40:G41)","v":0},{"$f":"SUM(H40:H41)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," name program 2… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," name program 3… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G46:G47)","v":0},{"$f":"SUM(H46:H47)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," name program4… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G49:G50)","v":0},{"$f":"SUM(H49:H50)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," name program 5… ",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G52:G53)","v":0},{"$f":"SUM(H52:H53)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"… more rows can be added if needed",null,null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G55:G56)","v":0},{"$f":"SUM(H55:H56)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"TOTAL",null,null,"Full-time",{"$f":"SUM(G55,G52,G49,G46,G43,G40)","v":0},{"$f":"SUM(H55,H52,H49,H46,H43,H40)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Part-time",{"$f":"SUM(G56,G53,G50,G47,G44,G41)","v":0},{"$f":"SUM(H56,H53,H50,H47,H44,H41)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Total",{"$f":"SUM(G58:G59)","v":0},{"$f":"SUM(H58:H59)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"NOTES 2.1.2: "]
[null,"18. The information gattered in this grid will represent the reality about postgraduate students in taught  master degrees.  The baseline for this grid will be the enrolment data from the last AY ( for example AY 2017/18) dissagregated by sex. We will specify number of students per programme and option (full-time / part-time). For a more exhaustive analysis it could also be interesting to look at the number applications dissagregated by sex, and data about amount of students who will graduate in the present AY  (ex. AY 2017/18), to compare the level of achievement among women and men in different master degrees. "]
[null,"19. Number of students enrolled in the 1st year of master in the last AY ( ex. AY 2017/18)"]
[]
[null,"Chart 2.1.3.- Numbers of men and women on postgraduate research degrees (PhD)  in AY 2015/16"]
[null,"Programme",null,null,null,"Number of students enrolled  in AY 2015/16 20"]
[null,"Department 21","PhD programmes",null,null,"Women","Men","% women","% men"]
[null,null,"name program 1… ",null,"Full-time",null,null,{"$f":"((F68*100)/(F68+G68))","v":{"$error":"#DIV/0!"}},{"$f":"((G68*100)/(G68+F68))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F68:F69)","v":0},{"$f":"SUM(G68:G69)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"name program 2… ",null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F71:F72)","v":0},{"$f":"SUM(G71:G72)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"name program 3… ",null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F74:F75)","v":0},{"$f":"SUM(G74:G75)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"name program 4… ",null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F77:F78)","v":0},{"$f":"SUM(G77:G78)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"name program5 … ",null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F80:F81)","v":0},{"$f":"SUM(G80:G81)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"more rows to be added if needed",null,"Full-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F83:F84)","v":0},{"$f":"SUM(G83:G84)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL",null,null,"Full-time",{"$f":"SUM(F83,F80,F77,F74,F71,F68)","v":0},{"$f":"SUM(G83,G80,G77,G74,G71,G68)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Part-time",{"$f":"SUM(F84,F81,F78,F75,F72,F69)","v":0},{"$f":"SUM(G84,G81,G78,G75,G72,G69)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,"Total",{"$f":"SUM(F86:F87)","v":0},{"$f":"SUM(G86:G87)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"NOTES 2.1.3: "]
[null,"20. Number of students enrolled in the 1st year of PhD in the last AY ( ex. AY 2017/18). or a more exhaustive analysis it could also be interesting to look at the number of year students from different disciplines spend in doing their PhD dissagregated by sex, to compare the level of achievement among women and men in different academic disciplines. "]
[null,"21. Specify the department to which the PhD programme is attached."]
[]
[]
["2.2.- Selection and recruitment"]
[]
[null,"Chart 2.2.1.- Candidatures presented during the year"]
[null,null,null,"Women","Men"," % Women","% Men"]
[null,"Number of CVs received 22",null,null,null,{"$f":"D99*100/(D99+E99)","v":{"$error":"#DIV/0!"}},{"$f":"E99*100/(D99+E99)","v":{"$error":"#DIV/0!"}}]
[null,"Number of  CVs received through advertisement 23",null,null,null,{"$f":"D100*100/(D100+E100)","v":{"$error":"#DIV/0!"}},{"$f":"E100*100/(D100+E100)","v":{"$error":"#DIV/0!"}}]
[null,"Finalists 24",null,null,null,{"$f":"D101*100/(D101+E101)","v":{"$error":"#DIV/0!"}},{"$f":"E101*100/(D101+E101)","v":{"$error":"#DIV/0!"}}]
[null,"Hired 25",null,null,null,{"$f":"D102*100/(D102+E102)","v":{"$error":"#DIV/0!"}},{"$f":"E102*100/(D102+E102)","v":{"$error":"#DIV/0!"}}]
[null,"How many people have been hired by direct appointment?  26",null,null,null,{"$f":"D103*100/(D103+E103)","v":{"$error":"#DIV/0!"}},{"$f":"E103*100/(D103+E103)","v":{"$error":"#DIV/0!"}}]
[null,"Are there any support programmes (counselling, training, advice…) for women who want to start a career after graduating? (choose from the menu)"]
[null,"If you answered \"yes\" to the previous question, how many support programmes have been set up (counselling, training, advice…) for women who want to start a career after graduating? 27"]
[null,"If so, please specify name of programme and amount of hours (duration)"]
[]
[null,"NOTES 2.2.1: "]
[null,"22. Number of CVs (of all grades: Grade A, grade B and Grade C) received during the year (for example if 2017, from 1st January until 31st December 2017) if available. If not available, just explain that the data is not available, the fact that is not available is already relevant for the audit. For example, in the case of UNIBO this data is not available. "]
[null,"23. Number of CVs received for advertised vacancies during the year (for example 2017). The total CVs received by women and men in response to an advertised vacancy.  "]
[null,"24. From the CVs received during the year how many were finalists in a selection process at the RPO? Is that data registered? Please, specify and if not available, just explain that the data is not available, the fact that is not available is already relevant for the audit. Please specify if this data do not apply to your country rules: for example, in the case of UNIBO, in the process of selection does not provide for finalists and winners, but only winners. "]
[null,"25. Number of successful applications. Amount of people hired during the year disaggregated by sex. "]
[null,"26. Amount of people hired by direct appointment in the RPO during the year, with no need of a selection process, give the data dissagregated by sex. This is the case when a vacancy advertisement is written thinking on who can be the successful candidate, or when the person is directly contacted with no need of advertising the vacancy. For example, in some cases they migh directly call known students they previously had contact with.  Please specify if this case is applicable to your own country: for instance, in the case of UNIBO, all vacancies are publically advertised by law. "]
[null,"27. Amount of support programmes specifically directed to women who want to start an academic career after graduation, specify name and amount of hours in the next line. "]
[]
[]
["2.3.- Career progression"]
[]
[null,"Chart 2.3.1.- Career progression in the RPO 28"]
[]
[null,"Number of Men/Women by level","At the moment they started working in the RPO (i.e. 2005)  29",null,null,null,"After 5 years (i.e. in 2010) 30",null,null,null,"Today"]
[null,null,null,null,null,null,null,null,null,null,"After 10 years (i.e. in 2015) 31"]
[null,null,"Women","Men","% Women","% Men","Women","Men","% Women","% Men","Women","Men","% Women","% Men"]
[null,"Grade A- Full Professor",null,null,{"$f":"C124*100/(C124+D124)","v":{"$error":"#DIV/0!"}},{"$f":"D124*100/(C124+D124)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"G124*100/(G124+H124)","v":{"$error":"#DIV/0!"}},{"$f":"H124*100/(G124+H124)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"K124*100/(K124+L124)","v":{"$error":"#DIV/0!"}},{"$f":"L124*100/(K124+L124)","v":{"$error":"#DIV/0!"}}]
[null,"Grade B- Associate Professor",null,null,{"$f":"C125*100/(C125+D125)","v":{"$error":"#DIV/0!"}},{"$f":"D125*100/(C125+D125)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"G125*100/(G125+H125)","v":{"$error":"#DIV/0!"}},{"$f":"H125*100/(G125+H125)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"K125*100/(K125+L125)","v":{"$error":"#DIV/0!"}},{"$f":"L125*100/(K125+L125)","v":{"$error":"#DIV/0!"}}]
[null,"Grade C- Assistant Professor",null,null,{"$f":"C126*100/(C126+D126)","v":{"$error":"#DIV/0!"}},{"$f":"D126*100/(C126+D126)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"G126*100/(G126+H126)","v":{"$error":"#DIV/0!"}},{"$f":"H126*100/(G126+H126)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"K126*100/(K126+L126)","v":{"$error":"#DIV/0!"}},{"$f":"L126*100/(K126+L126)","v":{"$error":"#DIV/0!"}}]
[null,"Grade D- Research Fellow",null,null,{"$f":"C127*100/(C127+D127)","v":{"$error":"#DIV/0!"}},{"$f":"D127*100/(C127+D127)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"G127*100/(G127+H127)","v":{"$error":"#DIV/0!"}},{"$f":"H127*100/(G127+H127)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"K127*100/(K127+L127)","v":{"$error":"#DIV/0!"}},{"$f":"L127*100/(K127+L127)","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL",{"$f":"SUM(C124:C127)","v":0},{"$f":"SUM(D124:D127)","v":0},{"$f":"C128*100/(C128+D128)","v":{"$error":"#DIV/0!"}},{"$f":"D128*100/(C128+D128)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G124:G127)","v":0},{"$f":"SUM(H124:H127)","v":0},{"$f":"G128*100/(G128+H128)","v":{"$error":"#DIV/0!"}},{"$f":"H128*100/(G128+H128)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K124:K127)","v":0},{"$f":"SUM(L124:L127)","v":0},{"$f":"K128*100/(K128+L128)","v":{"$error":"#DIV/0!"}},{"$f":"L128*100/(K128+L128)","v":{"$error":"#DIV/0!"}}]
[null,"Number of people who left 32","Women","Men","% Women","% Men"]
[null,null,{"$f":"C128-K128","v":0},{"$f":"D128-L128","v":0},{"$f":"C130*100/(C130+D130)","v":{"$error":"#DIV/0!"}},{"$f":"D130*100/(C130+D130)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"NOTES 2.3.1: "]
[null,"28. Chart 2.3.1. will gather information about Career progression in the RPO, it will use data from ten or moren years before (for example 2005) as a baseline and will monitor the progress among 10 year (for example from 2005) until 2015.  Suggestion for big universities: select one department for each area if digital data for each department are not available.  For example, She Figures 2015 Areas are: \nEducation\nHumanities and arts\nSocial sciences, business and law\nScience, mathematics and computing\nEngineering, manufacturing and construction\nAgriculture and veterinary\nHealth and welfare Services"]
[null,"29. Amount of people who started working in the RPO. For example in 2005 by grade and dissgregated by sex. For a more exhaustive analysis we could also gather the average age by grade and sex."]
[null,"30. Where were those people, that started working in for example 2005, five years later (for example in 2010)? Gather data from 2010, about the amount of people from those who started working in 2005 in each level by gender. "]
[null,"31. And where were them 10 years later? Gather data from for example 2015, about the amount of people from those who started working in 2005 in each level by gender. "]
[null,"32. Calculate the amount of women and men who left the institution during those 10 years. The reasons might vary, in some cases it might have been the workers decision, in others contracts might have ended or they might have moved to a different university. "]
[]
[null,"Chart 2.3.2.-Number of staff by age and gender 33",null,null,null,null,null,null,"Average age of women in high level 35",null,{"$f":"(((20*D142)+(25*D143)+(30*D144)+(35*D145)+(40*D146)+(45*D147)+(50*D148)+(55*D149)+(60*D150))/(SUM(D142:D150)))","v":{"$error":"#DIV/0!"}},"Average age of men in high level 36",null,{"$f":"(((20*E142)+(25*E143)+(30*E144)+(35*E145)+(40*E146)+(45*E147)+(50*E148)+(55*E149)+(60*E150))/(SUM(E142:E150)))","v":{"$error":"#DIV/0!"}}]
[null,"Position 34","Age-range","Women","Men","% women","%men"]
[null,"Grade A ","20-24",null,null,{"$f":"D142*100/($D$178+$E$178)","v":{"$error":"#DIV/0!"}},{"$f":"E142*100/($D$178+$E$178)","v":{"$error":"#DIV/0!"}},null,"Average age of women in medium level 37",null,{"$f":"(((20*D151)+(25*D152)+(30*D153)+(35*D154)+(40*D155)+(45*D156)+(50*D157)+(55*D158)+(60*D159))/(SUM(D151:D159)))","v":{"$error":"#DIV/0!"}},"Average age of men in medium level 38",null,{"$f":"(((20*E151)+(25*E152)+(30*E153)+(35*E154)+(40*E155)+(45*E156)+(50*E157)+(55*E158)+(60*E159))/(SUM(E151:E159)))","v":{"$error":"#DIV/0!"}}]
[null,null,"25-29",null,null,{"$f":"D143*100/($D$178+$E$178)","v":{"$error":"#DIV/0!"}},{"$f":"E143*100/($D$178+$E$178)","v":{"$error":"#DIV/0!"}}]
[null,null,"30-34",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Average age of women in low level 39",null,{"$f":"(((20*D160)+(25*D161)+(30*D162)+(35*D163)+(40*D164)+(45*D165)+(50*D166)+(55*D167)+(60*D168))/(SUM(D160:D168)))","v":{"$error":"#DIV/0!"}},"Average age of men in low level 40",null,{"$f":"(((20*E160)+(25*E161)+(30*E162)+(35*E163)+(40*E164)+(45*E165)+(50*E166)+(55*E167)+(60*E168))/(SUM(E160:E168)))","v":{"$error":"#DIV/0!"}}]
[null,null,"35-39",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"40-44",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Average age of women in Admin/technical categories 41",null,{"$f":"(((20*D169)+(25*D170)+(30*D171)+(35*D172)+(40*D173)+(45*D174)+(50*D175)+(55*D176)+(60*D177))/(SUM(D169:D177)))","v":{"$error":"#DIV/0!"}},"Average age of men in Admin/technical categories 42",null,{"$f":"(((20*E169)+(25*E170)+(30*E171)+(35*E172)+(40*E173)+(45*E174)+(50*E175)+(55*E176)+(60*E177))/(SUM(E169:E177)))","v":{"$error":"#DIV/0!"}}]
[null,null,"45-49",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"50-54",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"55-59",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"60 plus",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Grade B ","20-24",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"25-29",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"NOTES 2.3.2: "]
[null,null,"30-34",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"33. Chart 2.3.2 will gather information about RPO staff in the same year we are gathering data from in all the document (for example 2015 or 2017), that means information on 31/12/20XX, as there might be variations during the year."]
[null,null,"35-39",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"34. Three levels have been differentiated for positions: high, medium and low. For example in the case of UNIBO it suits perfectly with their three categories. If this is not the case in your RPO, you can add different categories in each of the levels. Adapt as needed. "]
[null,null,"40-44",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"35. This figure indicates the average age of women in high level positions. It is also interesting to look at the age-range with the most and the less amounts of women in these positions. "]
[null,null,"45-49",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"36. This figure indicates the average age of men in high level positions. It is also interesting to look at the age-range with the most and the less amounts of men in these positions."]
[null,null,"50-54",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"37. This figure indicates the average age of women in medium level positions. It is also interesting to look at the age-range with the most and the less amounts of women in these positions."]
[null,null,"55-59",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"38. This figure indicates the average age of men in medium level positions. It is also interesting to look at the age-range with the most and the less amounts of men in these positions."]
[null,null,"60 plus",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"39. This figure indicates the average age of women in low level positions. It is also interesting to look at the age-range with the most and the less amounts of women in these positions."]
[null,"Grade C","20-24",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"40. This figure indicates the average age of men in low level positions. It is also interesting to look at the age-range with the most and the less amounts of men in these positions."]
[null,null,"25-29",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"41. This figure indicates the average age of women in Admin/technical positions. It is also interesting to look at the differences in the percentage of men and women in these positions."]
[null,null,"30-34",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"42. This figure indicates the average age of men in Admin/technical positions. It is also interesting to look at the differences in the percentage of men and women in these positions."]
[null,null,"35-39",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"40-44",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"45-49",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"50-54",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"55-59",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"60 plus",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Technical staff and Grade D  ","20-24",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"25-29",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"30-34",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"35-39",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"40-44",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"45-49",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"50-54",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"55-59",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"60 plus",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL",null,{"$f":"SUM(D142:D177)","v":0},{"$f":"SUM(E142:E177)","v":0},{"$f":"D178*100/(D178+E178)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[null,"Chart 2.3.3.- Inclusive selection and career progression "]
[]
[null,"Has human resources staff and/or Selection Committee members received specific training on how to conduct inclusive selection and career progression processes? 43 "]
[]
[null,"Title of the training","Aimed at 44 ","Duration (amount of hours","Assistance"]
[null,null,null,null,2018,null,2017,null,2016,null,2015]
[null,null,null,null,"Women","Men","Women","Men","Women","Men","Women","Men"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[null,null,"…"]
[]
[null,"NOTES 2.3.3: "]
[null,"43. Answer question by choosing from the menu. Just to clarify, when we speak about inclusive selection, we mean inclusive in the broad sense of dealing with diversity.\nIf your answer is yes, answer questions in the next line: name of the training and if it was intended for Human resources staff and/or Selection commitee, duration (amount of hours), assistance (number of people who attended the training)"]
[null,"44. Please specify if the course was for Humarn Resources Staff or Selection Committee members in each of the cases."]
[]
[]
["2.4.- Gender pay gap"]
[]
[null,"Chart 2.4.1- Pay Gap","(milliards €)"]
["Linked to Chart 2.3.1 ","Average salary of the last year 45","Women","Men","GAP"]
[null,{"$f":"'KEY AREA_2'!B124","v":"Grade A- Full Professor"},null,null,{"$f":"D208-C208","v":0}]
[null,{"$f":"'KEY AREA_2'!B125","v":"Grade B- Associate Professor"},null,null,0]
[null,{"$f":"'KEY AREA_2'!B126","v":"Grade C- Assistant Professor"},null,null,0]
[null,{"$f":"B127","v":"Grade D- Research Fellow"},null,null,0]
[null,"…",null,null,0]
[null,"TOTAL"]
[null,"NOTES 2.4: "]
[null,"45. Calculate the average salary of the last period (in our example data from 2015), depending on sex and level/position; including all payments (extras, etc.).. \nNote that this indicator has been defined as ‘unadjusted’ as it has not been adjusted according to individual characteristics that may explain part of the earnings difference. Such individual characteristics relate, amongst other things, to traditions in the education and career choices of men and women; to a gender imbalance in the sharing of family responsibilities; to the fact that men and women still tend to work in different sectors; to part-time work, which is often highly feminised, etc. However, an important part of the discrepancies can only be explained by the fact that there is pay discrimination (i.e. the ‘adjusted wage gap’)."]
[]
[]
[]
[null,"Go to KEY AREA 2 GRAPHS"]

{"sheet":"KEY AREA_3","index":5,"n_rows":110,"n_cols":18,"rows_kept":110,"cut":false,"hidden":false,"merged":[[110,6,110,12],[106,1,106,2],[101,1,101,2],[7,1,7,6],[8,1,8,2],[9,1,9,2],[22,1,22,10],[92,1,92,2],[93,1,93,2],[103,1,103,2],[94,1,94,2],[95,1,95,2],[91,1,91,3],[99,4,99,7],[102,1,102,2],[16,1,16,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[96,1,96,2],[106,15,106,17],[99,1,100,3],[108,5,109,9],[98,1,98,8],[86,1,86,15],[28,1,28,17],[0,0,0,4],[1,0,1,1],[10,1,10,2],[11,1,14,1],[15,1,15,2],[26,1,26,9],[18,1,18,10],[21,1,21,10],[29,1,30,1],[29,2,29,5],[29,6,29,9],[29,10,29,13],[29,14,29,17],[1,2,1,4],[81,1,81,15],[82,1,82,15],[83,1,83,15],[84,1,84,15],[85,1,85,15],[2,2,3,5],[77,1,77,15],[78,1,78,15],[79,1,79,15],[80,1,80,15],[3,6,3,9],[19,1,19,10],[20,1,20,10],[70,1,70,15],[71,1,71,15],[31,1,31,17],[44,1,44,17],[57,1,57,17],[67,1,67,15],[68,1,68,15],[69,1,69,15],[72,1,72,15],[73,1,73,15],[74,1,74,15],[75,1,75,15],[76,1,76,15]]}
["PLOTINA- Quantitative Audit Checklist"]
[null,null,"KEY AREA 3"]
[null,null,"Work and personal life integration"]
[null,null,null,null,null,null,"RETURN TO THE MAIN PAGE"]
[]
["3.1.- Data on caring responsibilities of the RPO's academic staff"]
[]
[null,"Chart 3.1.1- Caring-responsibilities of academic staff 46"]
[null,null,null,"Women","Men","% women","%men"]
[null,"One parent families 47",null,null,null,{"$f":"((D10*100)/(D10+E10))","v":{"$error":"#DIV/0!"}},{"$f":"((E10*100)/(E10+D10))","v":{"$error":"#DIV/0!"}}]
[null,"Rest of families with children 48",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Age of children","under 3 years",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3-8 years",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"9-16 years",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null," plus 16 years",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Children with special needs 49",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other caring responsibilities 50",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"NOTES 3.1.1: "]
[null,"46. If caring responsibilities data is not collected, this information will not be available in the institution. Perceptions on this issue will be collected from the qualitative interviews and focus groups. This data-collection could be an action of the GEP if there is a will to improve on this issue within the RPO. For example, in the case of UNIBO this is N/A, this data is not systematized. "]
[null,"47. One parent families, families with at least one child in which the caring responsibility in the household relies in a single person (mother or father of the child or children)"]
[null,"48. Rest of families who have children, meaning families with two parents (a mother and a father, two mothers, two fathers…); families of one or more people with no children are not counted. If the two parents in a family worked in the same RPO, then both would be counted in their relevant column, as we understand that both parents in all families do have caring responsibilities for their children."]
[null,"49. If there are children with any kind of special needs, that need further care from their parents because of some illness,  or other reasons, then specify amount of men and women who have this kind of caring responsibilities. "]
[null,"50. Number of people in institution with family-members needing to be looked after that live or not with the worker, elder over 65s or handicapped people under that age."]
[]
["3.2.- Work and personal life integration policies in the institution"]
[]
[null,"Chart 3.2.1. Link between the use of work-life balance measures, gender  and position 51"]
[]
[null,"How many used the measure? "]
[null,null,{"$f":"'KEY AREA_2'!B124","v":"Grade A- Full Professor"},null,null,null,{"$f":"'KEY AREA_2'!B125","v":"Grade B- Associate Professor"},null,null,null,{"$f":"'KEY AREA_2'!B126","v":"Grade C- Assistant Professor"},null,null,null,"TOTAL"]
[null,null,"Women","Men","% Women","% Men","Women","Men","% Women","% Men","Women","Men","% Women","% Men","Women","Men","%Women","% Men"]
[null,"Parenting supports and permits 52"]
[null,"Maternity leave 53",null,null,{"$f":"((C33*100)/(C33+D33))","v":{"$error":"#DIV/0!"}},{"$f":"((D33*100)/(D33+C33))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((G33*100)/(G33+H33))","v":{"$error":"#DIV/0!"}},{"$f":"((H33*100)/(H33+G33))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((K33*100)/(K33+L33))","v":{"$error":"#DIV/0!"}},{"$f":"((L33*100)/(L33+K33))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C33,G33,K33)","v":0},{"$f":"SUM(D33,H33,L33)","v":0},{"$f":"((O33*100)/(O33+P33))","v":{"$error":"#DIV/0!"}},{"$f":"((P33*100)/(P33+O33))","v":{"$error":"#DIV/0!"}}]
[null,"Paternity leave 54",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Parental leave 55",null,null,{"$f":"((C35*100)/(C35+D35))","v":{"$error":"#DIV/0!"}},{"$f":"((D35*100)/(D35+C35))","v":{"$error":"#DIV/0!"}}]
[null,"Breastfeeding permit 56",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null," Parenting friendly working hours 57",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Time off-work 58",null,null,{"$f":"((C38*100)/(C38+D38))","v":{"$error":"#DIV/0!"}},{"$f":"((D38*100)/(D38+C38))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((G38*100)/(G38+H38))","v":{"$error":"#DIV/0!"}},{"$f":"((H38*100)/(H38+G38))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((K38*100)/(K38+L38))","v":{"$error":"#DIV/0!"}},{"$f":"((L38*100)/(L38+K38))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C38,G38,K38)","v":0},{"$f":"SUM(D38,H38,L38)","v":0},{"$f":"((O38*100)/(O38+P38))","v":{"$error":"#DIV/0!"}},{"$f":"((P38*100)/(P38+O38))","v":{"$error":"#DIV/0!"}}]
[null,"Extended leave for the care of children 59",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"…",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"…",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"…",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Work-life balance services 60 "]
[null,"Lactation rooms",null,null,{"$f":"((C46*100)/(C46+D46))","v":{"$error":"#DIV/0!"}},{"$f":"((D46*100)/(D46+C46))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((G46*100)/(G46+H46))","v":{"$error":"#DIV/0!"}},{"$f":"((H46*100)/(H46+G46))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((K46*100)/(K46+L46))","v":{"$error":"#DIV/0!"}},{"$f":"((L46*100)/(L46+K46))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C46,G46,K46)","v":0},{"$f":"SUM(D46,H46,L46)","v":0},{"$f":"((O46*100)/(O46+P46))","v":{"$error":"#DIV/0!"}},{"$f":"((P46*100)/(P46+O46))","v":{"$error":"#DIV/0!"}}]
[null,"Nursery",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Canteen/Kitchen 61",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Collective transport 62",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Subsiding childcare for conference purposes ",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Eldercare 63",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Summer camps 64",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Teaching relief support for new parents 65",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Services for dual career couples 66",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"…",null,null,{"$f":"((C55*100)/(C55+D55))","v":{"$error":"#DIV/0!"}},{"$f":"((D55*100)/(D55+C55))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((G55*100)/(G55+H55))","v":{"$error":"#DIV/0!"}},{"$f":"((H55*100)/(H55+G55))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((K55*100)/(K55+L55))","v":{"$error":"#DIV/0!"}},{"$f":"((L55*100)/(L55+K55))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C55,G55,K55)","v":0},{"$f":"SUM(D55,H55,L55)","v":0},{"$f":"((O55*100)/(O55+P55))","v":{"$error":"#DIV/0!"}},{"$f":"((P55*100)/(P55+O55))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Work-life balance measures"]
[null,"Flexitime 67",null,null,{"$f":"((C59*100)/(C59+D59))","v":{"$error":"#DIV/0!"}},{"$f":"((D59*100)/(D59+C59))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((G59*100)/(G59+H59))","v":{"$error":"#DIV/0!"}},{"$f":"((H59*100)/(H59+G59))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"((K59*100)/(K59+L59))","v":{"$error":"#DIV/0!"}},{"$f":"((L59*100)/(L59+K59))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C59,G59,K59)","v":0},0,{"$f":"((O59*100)/(O59+P59))","v":{"$error":"#DIV/0!"}},{"$f":"((P59*100)/(P59+O59))","v":{"$error":"#DIV/0!"}}]
[null,"Staggered hours 68",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Paid extended leave for personal reasons ",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Unpaid extended leave for personal reasons ",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Working from home",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Mobility 69",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Job sharing 70",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"NOTES 3.2.1: "]
[null,"51. Chart 3.2.1 will gather data about the dissagregated use of parenting, work-life balance and flexibitiy measures and services that the RPO might offer to workers. Reference date for the collection of data would be for example 31/12/2017 and we will collect data from all the year. This chart will gather data about the use RPO workers (by sex and category) do off this measures, for a more exhaustive analysis, we could be interesting to know how many people (women and men) are elegibile to use each of the measures, and how many of them actually use it. If the data is not systematized in the institution, please try to incorporate it in the qualitative data gathering. All the measures and services will have to be adapted to the reality of each RPO. For example, in the case of UNIBO this is N/A, this data is not systematized. "]
[null,"52. First block to be analysed are parenting supports and measures, a set of seven measures has been proposed  and blank space has been left for each RPO to add any other relevant measures. For example in the case of UNIBO only paternity and maternity leave are applicable.  "]
[null,"53. Maternity leave: leave from work for mothers in the period immediately preceding and following birth. In the case of Spain this counts from the 6th week after the birth of the baby. Use national legislation as reference. "]
[null,"54. Paternity leave: leave from work for fathers similar to maternity leave, intransferible and that can either use paralellary to maternity leave or one after the other. For example in Spain from July 2018 this is of 5 weeks. Use national legislation as reference.\n"]
[null,"55. Parental leave: leave after maternity/paternity leave which can be taken by either parent. Use national legislation as reference. "]
[null,"56. Specific permit where workers are entitled to leave the workplace for an hour during their working-day for breastfeeding (natural or artificial) purposes. According to Spanish law, it might vary in other countries, this can be used during the first 9 months after the baby is born. Male and female workers are entitled to use this measure, but in a couple only one of the parents can use it. Use national law as a reference."]
[null,"57. Reducing the working hours to make parenting easier/possible.  Parents with children under 8 years of age are entitled for part-time work by law in Spain.  Use national law as a reference."]
[null,"58. Taking time-off work for caring purposes. For example, when a parent asks for days-off work during summer because she or he has to take care for a child. In some workplaces there is an amount of days per year (it can be two weeks) that each worker can take for caring purposes. "]
[null,"59. Extended leave for the care of family-members: all workers should be considered with the right to  take it, as we all have caring responsibilities (even if not children). This also happens, when the parental leave that has been extended for longer months."]
[null,"60. The second block is composed by a set of 9 work-life balance measures that the RPO/workplace might offer to its workers. Blank space has been left for any other measures the RPO might have. If the service is not offered by the RPO just leave blank, and if nobody uses it write 0. "]
[null,"61. Do workers have an space where they can have lunch? It might be a place where food is served, or something like a common dining-room or kitchen with microwaves where they can heat and eat the food they take from home. A separate space, that involves they have an option to have lunch out from their working desk in a separated space. "]
[null,"62. This is a measure that is only relevant for workplaces that are not very centrically located and might not have good transport links. There can be different options, either a network of people doing the same trips and organized in order to facilitate the sharing of private transport (car) or a bus service that goes from the centre of the nearest city to the workplace and is adapted to the working hours of workers , so it also promotes a culture of shorter but productive-hours rather than longer (not always productive) working hours. "]
[null,"63. This would be a similar service to a nursery, but dedicated for elder people. There have been some good practices of intergenerational experiences, in which elder people are the ones caring for the kindergarten children. "]
[null,"64. For example in the case of universities with a Summer University programme, this would be an option to organize an open summer camp in parallel for the children of the parents who want to attend the Summer Courses. "]
[null,"65. It refers to the possibility to ask for a reduction in the number of teaching hours for new parents during the first year of birth of their child."]
[null,"66. For example, employment and career advice for partners when both people in the couple have an academic career."]
[null,"67. The employee chooses when to start and end work (within agreed limits) but works certain ‘core hours’, for example 10am to 4pm every day and has flexibility to organize the rest of working hours during the day. For example if a worker has to work 7 hours per day and has to work 10am to 3pm every day (5hours) could decide to start work at 7 am on Mondays and Wednesdays and only work the core hours the rest of the days; OR he/she could decide to work an hour longer every day, etc.. "]
[null,"68. The employee has different start, finish and break times from other workers. Reference: https://www.gov.uk/flexible-working/types-of-flexible-working"]
[null,"69. Giving the option of moving to a working-place that is closer to the hometown, when the institution has more than one centres."]
[null,"70. Two people do one job and split the hours, both working part-time. This measure is usually used when a person in a responsibility post decides to reduce his or her working hours for caring purposes, some of her/his responsibilities pass to another collegue to make her or his new timetable suitable. "]
[]
["3.3.- Measures to keep the link with people on parental leave and to promote joint responsibility in care"]
[]
[null,"Chart 3.3.1.- Specific measures to keep the link between people on parenting leaves and the organization"]
[]
[null,"Sending the minutes, memorandums, circulates…"]
[null,"Maintaining the conditions and competences of the position "]
[null,"Training opportunities"]
[null,"Asking them about the decisions that might affect them"]
[null,"Training/reception to return to work"]
[]
[null,"Chart 3.3.2.- Specific measures to promote joint responsibility in care"]
[null,"Have this kind of activities been organized in the RPO? (Choose from menu)",null,null,"Number of participants in those activities/initiatives"]
[null,null,null,null,"Women","Men","% Women ","% Men"]
[null,"Training activities, workshops, talks…",null,null,null,null,{"$f":"((E102*100)/(E102+F102))","v":{"$error":"#DIV/0!"}},{"$f":"((F102*100)/(F102+E102))","v":{"$error":"#DIV/0!"}}]
[null,"Brochures, posters, intranet, newsletters… ",null,null,null,null,{"$f":"((E103*100)/(E103+F103))","v":{"$error":"#DIV/0!"}},{"$f":"((F103*100)/(F103+E103))","v":{"$error":"#DIV/0!"}}]
[null,"(you can add further…)",null,null,null,null,{"$f":"((E104*100)/(E104+F104))","v":{"$error":"#DIV/0!"}},{"$f":"((F104*100)/(F104+E104))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Chart 3.3.3.- Measures to maintain the implication-level of the individuals who work part-time in the RPO"]
[]
[null,"Meetings within core hours",null,null,null,"NOTES 3.3., 3.3.2 and 3.3.3.: "]
[null,"Maintaining the conditions and competences of the position",null,null,null,"* If the RPO has this data systematized, fill-in with that information. If not, these are integrated in the questionnaire (ANNEX 1) gather from the answers, and put numbers based on number of responses rather than ticks. "]
[null,"Training at core working hours"]

{"sheet":"KEY AREA_4","index":6,"n_rows":114,"n_cols":14,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,3,5],[72,20,72,21],[73,20,73,21],[74,20,74,21],[31,8,32,8],[27,1,32,3],[21,1,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[19,5,20,5],[19,6,20,6],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[8,1,8,4],[21,6,22,6],[27,4,28,4],[15,4,16,4],[15,5,16,5],[15,6,16,6],[13,4,14,4],[13,5,14,5],[7,5,7,8],[9,7,10,7],[9,8,10,8],[13,6,14,6],[13,7,14,7],[13,8,14,8],[27,5,28,5],[7,1,7,4],[9,1,14,3],[15,1,20,3],[27,6,28,6],[27,7,28,7],[27,8,28,8],[15,7,16,7],[15,8,16,8],[19,4,20,4],[49,10,49,11],[21,7,22,7],[70,20,70,21],[71,20,71,21],[19,7,20,7],[19,8,20,8],[21,8,22,8],[33,8,34,8],[49,12,49,13],[54,8,54,9],[55,8,55,9],[49,4,49,7],[48,1,48,6],[33,7,34,7],[50,1,50,3],[49,1,49,3],[37,7,38,7],[33,6,34,6],[33,1,38,3],[33,4,34,4],[33,5,34,5],[37,6,38,6],[31,4,32,4],[31,5,32,5],[53,6,54,6],[21,5,22,5],[65,1,65,2],[37,8,38,8],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[50,8,50,9],[49,8,49,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[56,3,57,3],[55,1,55,2],[37,4,38,4],[31,6,32,6],[31,7,32,7],[21,4,22,4],[49,0,57,0],[51,1,51,2],[53,4,54,4],[52,1,52,2],[53,3,54,3],[9,4,10,4],[9,5,10,5],[41,1,41,12],[42,1,42,12],[43,1,43,12],[44,1,44,12],[45,1,45,12],[46,1,46,12],[29,8,30,8],[9,6,10,6],[56,4,57,4],[56,5,57,5],[56,6,57,6],[56,8,56,9],[57,8,57,9],[56,1,57,2],[53,1,54,2],[53,5,54,5],[56,7,57,7],[1,6,1,8],[63,1,64,2],[66,1,66,2],[69,1,69,2],[53,7,54,7],[91,1,91,2],[98,1,98,2],[99,1,99,2],[94,1,94,2],[90,1,90,2],[85,1,85,2],[87,1,87,2],[88,1,88,2],[75,1,75,2],[89,1,89,2],[37,5,38,5],[70,1,70,2],[63,3,63,6],[68,1,68,2],[84,1,84,2],[77,1,77,6],[78,1,78,6],[79,1,79,6],[80,1,80,6],[72,8,72,13],[73,8,74,13],[75,8,75,13],[76,1,76,6],[67,1,67,2],[72,1,72,2],[73,1,73,2],[74,1,74,2],[100,1,100,2],[97,1,97,2],[96,1,96,2],[86,1,86,2],[64,20,64,21],[65,20,65,21],[66,20,66,21],[67,20,67,21],[71,1,71,2],[68,20,68,21],[69,20,69,21],[65,8,65,13],[66,8,67,13],[68,8,69,13],[70,8,71,13],[233,1,233,5],[227,1,227,3],[228,1,228,3],[229,1,229,3],[230,1,230,3],[201,23,205,23],[220,1,220,3],[218,1,218,3],[225,1,225,3],[222,1,222,3],[215,4,216,4],[206,20,206,21],[215,5,216,5],[201,20,205,21],[232,1,232,3],[231,1,231,3],[226,1,226,3],[219,1,219,3],[224,1,224,3],[215,1,216,3],[221,1,221,3],[223,1,223,3],[217,1,217,3],[211,31,211,33],[212,31,218,33],[199,22,200,22],[201,22,205,22],[193,20,194,21],[196,20,196,21],[199,20,200,21],[211,28,211,30],[212,28,218,30],[193,23,194,23],[199,23,200,23],[211,24,211,27],[205,24,205,25],[195,20,195,21],[193,22,194,22],[194,14,194,16],[84,9,84,10],[103,1,103,9],[104,1,104,9],[105,1,105,9],[106,1,106,9],[107,1,107,9],[108,1,108,9],[109,1,109,9],[110,1,110,9],[93,1,93,2],[92,1,92,2],[95,1,95,2],[111,1,111,9],[112,1,112,9],[113,1,113,9],[85,9,85,10],[86,9,86,10],[87,9,87,10],[88,9,88,10],[89,9,89,10],[90,9,90,10],[91,9,91,10],[92,9,92,10],[93,9,93,10],[94,9,94,10],[95,9,95,10],[96,9,96,10],[97,9,97,10],[98,9,98,10],[99,9,99,10],[100,9,100,10]]}
["PLOTINA- Quantitative Audit Checklist"]
[null,null,"KEY AREA 4",null,null,null,"RETURN TO THE MAIN PAGE"]
[null,null,"Researchers and Research: gender equality among researchers and  gender perspective/sex in research"]
[]
[]
["4.1. Academic and research staff data 70"]
[]
[null,"Grade",null,null,null,"Number of employees 71"]
[null,"Please list the GRADES72: ",null,null,null,"Women","Men"," % Women","% Men"]
[null,"Grade A - Full Professor",null,null,"Research only 73",null,null,{"$f":"F10:F11*100/(F10:F11+G10:G11)","v":{"$error":"#DIV/0!"}},{"$f":"G10:G11*100/(G10:G11+F10:F11)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Teaching only 74",null,null,{"$f":"F12:F13*100/(F12:F13+G12:G13)","v":{"$error":"#DIV/0!"}},{"$f":"G12:G13*100/(G12:G13+F12:F13)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Research and teaching 75",null,null,{"$f":"F14:F15*100/(F14:F15+G14:G15)","v":{"$error":"#DIV/0!"}},{"$f":"G14:G15*100/(G14:G15+F14:F15)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Grade B - Associate Professor",null,"….","Research only",null,null,{"$f":"F16:F17*100/(F16:F17+G16:G17)","v":{"$error":"#DIV/0!"}},{"$f":"G16:G17*100/(G16:G17+F16:F17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Teaching only",null,null,{"$f":"F18:F19*100/(F18:F19+G18:G19)","v":{"$error":"#DIV/0!"}},{"$f":"G18:G19*100/(G18:G19+F18:F19)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Research and teaching",null,null,{"$f":"F20:F21*100/(F20:F21+G20:G21)","v":{"$error":"#DIV/0!"}},{"$f":"G20:G21*100/(G20:G21+F20:F21)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Grade C - Assistant Professor",null,null,"Research only",null,null,{"$f":"F22:F23*100/(F22:F23+G22:G23)","v":{"$error":"#DIV/0!"}},{"$f":"G22:G23*100/(G22:G23+F22:F23)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Teaching only",null,null,{"$f":"F24:F25*100/(F24:F25+G24:G25)","v":{"$error":"#DIV/0!"}},{"$f":"G24:G25*100/(G24:G25+F24:F25)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Research and teaching",null,null,{"$f":"F26:F27*100/(F26:F27+G26:G27)","v":{"$error":"#DIV/0!"}},{"$f":"G26:G27*100/(G26:G27+F26:F27)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Grade D- Research Fellow",null,null,"Research only",null,null,{"$f":"F28:F29*100/(F28:F29+G28:G29)","v":{"$error":"#DIV/0!"}},{"$f":"G28:G29*100/(G28:G29+F28:F29)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Teaching only",null,null,{"$f":"F30:F31*100/(F30:F31+G30:G31)","v":{"$error":"#DIV/0!"}},{"$f":"G30:G31*100/(G30:G31+F30:F31)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Research and teaching",null,null,{"$f":"F32:F33*100/(F32:F33+G32:G33)","v":{"$error":"#DIV/0!"}},{"$f":"G32:G33*100/(G32:G33+F32:F33)","v":{"$error":"#DIV/0!"}}]
[]
[null,"TOTAL",null,null,"Research only",{"$f":"SUM(F10,F16,F22,F28)","v":0},{"$f":"SUM(G10,G16,G22,G28)","v":0},{"$f":"F34:F35*100/(F34:F35+G34:G35)","v":{"$error":"#DIV/0!"}},{"$f":"G34:G35*100/(G34:G35+F34:F35)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Teaching only",{"$f":"SUM(F12,F18,F24,F30)","v":0},{"$f":"SUM(G12,G18,G24,G30)","v":0},{"$f":"F36:F37*100/(F36:F37+G36:G37)","v":{"$error":"#DIV/0!"}},{"$f":"G36:G37*100/(G36:G37+F36:F37)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Research and teaching",{"$f":"SUM(F14,F20,F26,F32)","v":0},{"$f":"SUM(G14,G20,G26,G32)","v":0},{"$f":"F38:F39*100/(F38:F39+G38:G39)","v":{"$error":"#DIV/0!"}},{"$f":"G38:G39*100/(G38:G39+F38:F39)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F34:F39)","v":0},{"$f":"SUM(G34:G39)","v":0},{"$f":"F40*100/(F40+G40)","v":{"$error":"#DIV/0!"}},{"$f":"G40*100/(G40+H40)","v":{"$error":"#DIV/0!"}}]
[null,"NOTES 4.1.1: "]
[null,"70. For chart 1.2.1 concerning research staff, consider the number of people working for example at 31/12/2015 or the year you took as reference for collecting your data. This will help in future options of monitoring and comparing data. "]
[null,"71. Specify number of research staff by grade, contract-function and gender. With this data we will analyse the vertical segregation in the institution. If you also want to look at the horizontal segregation that might exist among disciplines, you could gather this information by departments or faculties. For a more exhaustive analysis, that includes the intersectional perspective you can compare these data with the data collected in Key Area 2 based on age; also data regarding the type of contract could be collected (as you will see in the UNIBO example that follows these explanations)"]
[null,"72. Specify the relevant grades, work-titles in your RPO, according to your own countries' rules. You have to start form the highest academic position to the lowest academic position (In the case of UNIBO this are: full- professor - Grade A, associate professor - Grade B, assistant professor - Grade C, and research fellows - Grade D). The grade identifies different levels at the academic career. According to She Figures 2015 (pp. 196/203) there are 4 grade in academic career, starting from Grade A that is the highest. The correspondance among grades defined by She Figure and different European contries' regulation are displayed at She Figures 2015 (pp. 139/145). According to SHE FIGURES this would be the relevant grades for each of the Plotina RPOs: MU (Spain) Grade A, full professor and emeritus professor- Grade B, Tenured professor and Visiting professor- Grade C, Lecturers Senior teachers and REsearchers- Grade D, Teachers, Assitants and others; ISEG (Portugal) Grade A, Reitor, Vice Reitor and Professor Catedrático- Grade B, Professor Associado and Professor Coordenator- Grade C, Profesor Auxiliar and Professor Adjunto, Grade D, Assitente, Assistente Politecnico, Leitor and Assistente estagiario; NIC (Slovenia) Grade A, full professor- Grade B, Associate Professor- Grade C, Assistant professor, Senior lecturer, Lecturer and lector- Grade D, Young researcher; Warwick (UK) Grade A, Professor- Grade B, Senior lecturer and Senior researcher- Grade C, Lecturer and Grade D, Researcher; OZU (Turkey) Grade A, Professor- Grade B, Associate professor and assistant professor- Grade C, Instructor and Grade D, Research assitant. "]
[null,"73. If there are Research only contracts in the RPO, provide data disaggregated by sex."]
[null,"74. If there are Teaching only contracts in the RPO, provide data disaggregated by sex."]
[null,"75. Provide data regarding research and teaching staff disaggregated by sex. If none of the previous categories exist in the RPO (this is the case of UNIBO) adequate the chart to simplify it (see below notes as example)."]
[]
[null,"AS AN EXAMPLE, THIS IS UNIBOS CHART 3 ADAPTED TO THEIR REALITY: "]
[null,"Grade",null,null,"Number of staff",null,null,null,"Type of contract",null,"Number of staff",null,"%"]
[null,"Please list the GRADES above: ",null,null,"Women","Men"," % Women","% Men","Specify number of staff by grade, contract-function and gender",null,"Women","Men","Women","Men"]
[null,"Grade A- Full professor",null,"Research and teaching",null,null,{"$f":"E52*100/(E52+F52)","v":{"$error":"#DIV/0!"}},{"$f":"F52*100/(F52+E52)","v":{"$error":"#DIV/0!"}},"Permanent",null,null,null,{"$f":"K52*100/(K52+L52)","v":{"$error":"#DIV/0!"}},{"$f":"L52*100/(K52+L52)","v":{"$error":"#DIV/0!"}}]
[null,"Grade B- Associate professor",null,"Research and teaching",null,null,{"$f":"E53*100/(E53+F53)","v":{"$error":"#DIV/0!"}},{"$f":"F53*100/(F53+E53)","v":{"$error":"#DIV/0!"}},"Permanent",null,null,null,{"$f":"K53*100/(K53+L53)","v":{"$error":"#DIV/0!"}},{"$f":"L53*100/(K53+L53)","v":{"$error":"#DIV/0!"}}]
[null,"Grade C -Assistant Prof",null,"Research and teaching",null,null,{"$f":"E54:E55*100/(E54:E55+F54:F55)","v":{"$error":"#DIV/0!"}},{"$f":"F54:F55*100/(F54:F55+E54:E55)","v":{"$error":"#DIV/0!"}},"Open-ended",null,null,null,{"$f":"K54*100/(K54+L54)","v":{"$error":"#DIV/0!"}},{"$f":"L54*100/(K54+L54)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Permanent",null,null,null,{"$f":"K55*100/(K55+L55)","v":{"$error":"#DIV/0!"}},{"$f":"L55*100/(K55+L55)","v":{"$error":"#DIV/0!"}}]
[null,"Grade D -Research Fellow ",null,"Research only",null,null,{"$f":"E56*100/(E56+F56)","v":{"$error":"#DIV/0!"}},{"$f":"F56*100/(F56+E56)","v":{"$error":"#DIV/0!"}},"Open-ended",null,null,null,{"$f":"K56*100/(K56+L56)","v":{"$error":"#DIV/0!"}},{"$f":"L56*100/(K56+L56)","v":{"$error":"#DIV/0!"}}]
[null,"TOTAL",null,"Research and teaching",{"$f":"SUM(E52:E55)","v":0},{"$f":"SUM(F52:F55)","v":0},{"$f":"E57:E58*100/(E57:E58+F57:F58)","v":{"$error":"#DIV/0!"}},{"$f":"F57:F58*100/(F57:F58+E57:E58)","v":{"$error":"#DIV/0!"}},"Open-ended",null,{"$f":"SUM(K54)","v":0},{"$f":"SUM(L54)","v":0},{"$f":"SUM(M56+M54)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N56+N54)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Permanent",null,{"$f":"SUM(K52,K53,K55)","v":0},{"$f":"SUM(L52,L53,L55)","v":0},{"$f":"SUM(M52,M53,M55)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N52,N53,N55)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"TOTAL",{"$f":"SUM(E57:E58)","v":0},{"$f":"SUM(F57:F58)","v":0},{"$f":"E59*100/(E59+F59)","v":{"$error":"#DIV/0!"}},{"$f":"F59*100/(F59+G59)","v":{"$error":"#DIV/0!"}}]
[]
[]
["4.2. Gender perspective in research project management"]
[null,"Chart 4.2.1.- Gender perspective in research project management"]
[null,null,null,"2015 76"]
[null,null,null,"Women","Men","% Women","% Men",null,"NOTES 4.2.1: "]
[null,"a. Number of researchers who have reached the highest research titles in the RPO 77",null,null,null,{"$f":"((D66*100)/(D66+E66))","v":{"$error":"#DIV/0!"}},{"$f":"((E66*100)/(E66+D66))","v":{"$error":"#DIV/0!"}},null,"76. Collect data from the same year you have taken as a reference in the rest of the document, (for example if you took  2015 as reference, you should provide data from 31/12/2015)."]
[null,"b. Average composition of research teams who got public founding 78",null,null,null,{"$f":"((D67*100)/(D67+E67))","v":{"$error":"#DIV/0!"}},{"$f":"((E67*100)/(E67+D67))","v":{"$error":"#DIV/0!"}},null,"77. Number of researchers (women and men) who achieved the highest level in for example 2015 , not all the researchers at this level, but the ones who got it in that specific year. In the case of UNIBO, for example, this would be the ones who became GRADE A- full-professor within the internal promotion or hiring made in 2015."]
[null,"c. Average composition of peer review teams 79 ",null,null,null,{"$f":"((D68*100)/(D68+E68))","v":{"$error":"#DIV/0!"}},{"$f":"((E68*100)/(E68+D68))","v":{"$error":"#DIV/0!"}}]
[null,"d. Number of researchers that are mentors to Young Researchers (PhD students) in your institution 80",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"78. Average number of women and average number of men participants in the research teams that received any kind of public funding for their research. All the people involved in the research team will be counted here, also the Scientific Coordinator. For a more exhaustive analysis we could  analyse the four major sources of public funding (not-european funding, European funding, National funding and/or Regional funding), in order to see if there are any differences in the composition of the teams."]
[null,"d. Number of researchers who have received individual funding for their research, other than from competitive public funding programmes 81",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"e. Average amount of funding received 82",null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"79. If peer review teams exist within the RPO, then specify the composition at for example, 31/12/2015. In the case of UNIBO there is a Commitee that operates for different scientific areas (i.e. Commissione VRA) to annually evaluate publications from UNIBO academics. They would write the composition of that committee. You can adapt the data gathering to your own institution."]
[null,"f. Funded Research Project Coordinators by gender 83 ",null,null,null,{"$f":"((D72*100)/(D72+E72))","v":{"$error":"#DIV/0!"}},{"$f":"((E72*100)/(E72+D72))","v":{"$error":"#DIV/0!"}}]
[null,"g. Average amount of researchers who presented their research results in academic settings at national and international levels 84 ",null,null,null,{"$f":"((D73*100)/(D73+E73))","v":{"$error":"#DIV/0!"}},{"$f":"((E73*100)/(E73+D73))","v":{"$error":"#DIV/0!"}},null,"80. Only fill-in if applicable. Some RPOs have a menthor figure that help and inspire the young researchers in their research process. "]
[null,"h. Amount of academics who have published solo-articles in scientific publications 85",null,null,null,{"$f":"((D74*100)/(D74+E74))","v":{"$error":"#DIV/0!"}},{"$f":"((E74*100)/(E74+D74))","v":{"$error":"#DIV/0!"}},null,"81. Only fill-in if applicable. If there are cases where a researcher receives \"funding\" for their research in the form of a private donation, or from a private company, then specify how many men and women receive that kind of \"funding\"."]
[null,"i. Amount of academics who have published co-authored articles in scientific publications 86",null,null,null,{"$f":"((D75*100)/(D75+E75))","v":{"$error":"#DIV/0!"}},{"$f":"((E75*100)/(E75+D75))","v":{"$error":"#DIV/0!"}}]
[null,"j.  Number of publications authored by at least one author from the RPO, which have in their Title and/or Key Words a word connected to gender 87",null,null,null,0,0,null,"82. Calculate average with this data as reference: the total grant received and the gender of the coordinator of competitive research programme. Calculate the average grant received by women and the average received by men. The reference to calculate this data will be the funding received through competitive public funding (indicator b)."]
[null,"83. Coordinators of the research teams that have received public funding, for a more exhaustive analysis you can differentiate this data by type of funding as in indicator b.  For example in the case of UNIBO, Tullia is the coordinator of the PLOTINA research team; that would count as 1 female. In the case of NIC, they will gather information about research project leaders instead of coordinators. "]
[null,"84. This data considers presentationf of paperf and/or speeches in national and/or international Conferences, Workshop,  Seminars, etc. Please, provide this data if there is a record kept. For example, in the case of UNIBO this is N/A."]
[null,"85. This can be collected from the database of academic articles used in the RPO. For example, in the case of UNIBO, this will be collected from VRA: number of research products inserted in VRA that have just one author and she/he is from UNIBO. Authors will be only academics from the institution, for example in the case of UNIBO these are full professors, associate professors, assistant professors."]
[null,"86. Same as previous, but articles with more than one author in which one or more authors are from the RPO. For example, in the case of UNIBO number of research product inserted in VRA that have UNIBO authors. - for instance, if there are two authors from Unibo, you have to count it 2, etc.… "]
[null,"87. Such as gender, equal opportunities, intersectionality, men/man, women/woman, etc."]
["4.3.- The integration of the gender dimension in Research"]
[null,"Chart 4.3.1.- The integration of Gender in Research 88"]
[]
[null,"Gender-mainstreaming in research 89",null,1,2,3,4,5,6,"Name of research project (s)"]
[null,"Is data disaggregated by sex? 90"]
[null,"Is data reported gender-sensitively? 91"]
[null,"Are there male and female specimen in the used research sample?"]
[null,"Are there balanced numbers of both sexes/genders used in the samples? 92"]
[null,"Is it checked if men and women are differently linked to the research problem that is going to be analyzed?"]
[null,"Are men and women considered when formulating the research questions?"]
[null,"Is gender-sensitive language used in the research project? 93"]
[null,"Are men and women participating in the project writing?"]
[null,"Are men and women participating in the project execution?"]
[null,"Are working conditions within the project shaped to equally accommodate men and women? 94"]
[null,"Are there gender-sensitive studies included in the literature review? 95"]
[null,"Are stereotypical gender roles projected in this research? 96"]
[null,"Are gender stereotypes actively challenged in the research? 97"]
[null,"Is there an effort made to increase diversity in research project teams? 98"]
[null,"Is the project result going to benefit lives of both men and women?"]
[null,"Does the research topic relate to gender inequalities in the society?"]
[]
[null,"NOTES 4.3.1.: "]
[null,"88. Data for Chart 4.3.1. will be gathered from a questionnaire ( Annex 1) that will be submitted to the Delegates of Departments  with research projects that got public funding in 2015 (Chart 4.2.1- Gender perspective in research management). Only the Delegates of departments where they had certain (one or more) research projects funded in 2015 will have to fill-in the questionare,  and the questions will be answered in reference to the projects that got funding to be developed. \nSuggestion for big institution: choose a sample of 1 Department in each scientific area according to the areas suggested by She figures 2015."]
[null,"89. Gather data from questionares. There will be one chart per Department, and it will be completed with an scale where  1 means no/never and 5 means yes/ always; 6 means \"Does not answer/ Does not know\""]
[null,"90. For example when data about amount of people is gathered, to be dissagregated by sex means, collecting the information sepparetly by having two rows one wiht the amount of women and another with the amount of men. "]
[null,"91. This means that data is dissagregated and it gives the option to understand both the reality of men and women"]
[null,"92. Balanced meaning a proportion of 40% /60%"]
[null,"93. Gender-sensitive language mening, the use of language that is inclusive and does not use sexist or discriminatory terms"]
[null,"94. In other words, are the specific needs of male and female researchers accomplished?"]
[null,"95. Did the studies used in hte literature review consider gender? "]
[null,"96. What image of women and what image of men does the project show? Are traditional gender roles reinforced? "]
[null,"97. What image of women and what image of men does the project show? Are there new ways and gender options/ identities visibilized or promoted?"]
[null,"98. In other words, is diversity also important for the specific composition of research project teams? How much importance is given within the RPO to have diverse (gender, ethnic., experience…) research teams? "]

{"sheet":"KEY AREA_5","index":7,"n_rows":49,"n_cols":27,"rows_kept":49,"cut":false,"hidden":false,"merged":[[38,1,38,26],[39,1,39,26],[40,1,40,26],[34,17,34,18],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,26],[34,15,34,16],[34,11,34,12],[34,13,34,14],[35,1,36,10],[34,3,34,4],[34,5,34,6],[34,1,34,2],[34,7,34,8],[0,0,0,4],[9,15,9,20],[15,1,15,2],[9,21,9,26],[9,3,9,8],[9,9,9,14],[3,2,5,7],[1,6,1,16],[9,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[26,1,26,2],[27,1,27,2],[33,15,33,16],[33,9,33,10],[33,11,33,12],[33,13,33,14],[28,1,28,2],[29,1,29,2],[33,1,33,2],[30,1,30,2],[33,17,33,18],[33,19,33,20],[33,21,33,22],[33,23,33,24],[33,25,33,26],[34,9,34,10],[33,3,33,4],[33,5,33,6],[33,7,33,8],[16,1,16,2],[17,1,17,2],[18,1,18,2],[32,1,32,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[31,1,31,2],[24,1,24,2],[25,1,25,2],[46,1,46,26],[47,1,47,26],[48,1,48,26],[41,1,41,26],[42,1,42,26],[43,1,43,26],[44,1,44,26],[45,1,45,26]]}
["PLOTINA- Quantitative Audit Checklist"]
[null,null,null,null,null,null,"RETURN TO THE MAIN PAGE"]
[null,null,"KEY AREA 5 "]
[null,null,"Integration of gender/sex dimension  in teaching curricula 99"]
[]
[]
[]
["5.1. Gender mainstreaming in teaching curricula"]
[]
[null,"Chart 5.1. Gender-mainstreaming in teaching-curricula 100",null,"Department 1 101",null,null,null,null,null,"Department 2",null,null,null,null,null,"Department 3",null,null,null,null,null,"Department 4"]
[null,null,null,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6,1,2,3,4,5,6]
[null,"Are a balanced number of female and male academics invited for visiting lectures at the department? 102 "]
[null,"Has any visiting lecturer been invited for her/his well-known gender-sensitivity?"]
[null,"In general, are female and male student numbers balanced in your department? 103"]
[null,"Is the number of students of all subjects taught in your Department gender balanced?"]
[null,"Are students stimulated to work in gender-mixed groups?"]
[null,"Are students taught to be gender-sensitive?"]
[null,"Do the course readers/bibliographies in your department include gender-sensitive publications? 104"]
[null,"Are gender stereotypes actively challenged in the class?"]
[null,"Is gender-sensitive methodology taught in the methodology linked subjects in your department? "]
[null,"Are gender-sensitive language and visual materials used while teaching and writing course materials? "]
[null,"Does the Handbook used contain the gender dimension of the course topic?"]
[null,"Is women´s invisibility in science addressed in the courses by highlighting women's achievements in science?"]
[null,"Are there any subjects or additional trainning (not mandatory courses) provided by the department in order to make students aware of gender inequalities and more geneally on gender issues?"]
[null,"Are there mentoring programmes for students in place in your Department? 105"]
[null,"Are there mentoring programmes for female students in place in the Department? "]
[null,"Have teachers received specific training on the gender dimension of their core subject?"]
[null,"Have teachers received specific training on gender-sensite teaching?"]
[null,"Is women´s specific reality studied? 106"]
[null,"How often are the subjects in your department specifically linked to gender? 107"]
[null,"Is there an effort to attract both genders made in the Open Days (matriculation campaigns)? "]
[null,"Are gender issues integrated in the course syllabuses in your department? 108"]
[null,"TOTAL",null,{"$f":"SUM(D12:D32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Percentage of subjects tought in your Departments that consider gender issues in their syllabus? 109"]
[null,"On average, how much time of the course topic is dedicated to the gender dimension? (Write approx. percentage %)"]
[]
[]
[null,"NOTES 5.1: "]
[null,"99. Data for Chart 5.1. will be gathered from a questionnaire ( Annex 1) that will be submitted to the Delegates of Departments that each RPO identified in Task 2.2 of PLOTINA. Suggestion for big institution: choose a sample of 1 Department in each scientific area according to the areas suggested by She figures 2015."]
[null,"100. Gather data from questionares. There will be one chart per Department, and it will be completed with an scale where  1 means no/never and 5 means yes/ always; 6 means \"Does not answer/ Does not know\""]
[null,"101. There will be one column to be filled in by each Department Delegate. Responses will be based on the general perception the delegate gets from the department. Please where it says \"Department 1\", \"Department2\", etc write the name of the department."]
[null,"102. From the visiting lecturers within the Erasmus + European programme. "]
[null,"103. Meaning students enrolled in all the years of the curricula."]
[null,"104. Course readers meaning, the reading list or recommendations given to students in each of the taught courses. "]
[null,"105. Meaning mentoring programmes addressed to promote empowering processes that would lead to challenge traditional gender stereotypes. "]
[null,"106. Traditionally we have lived in a male-dominated, androcentric world, where the reality of women was invisivilized. What we ask in this question, is whether an effort is made to challenge androcentrism. Is it all generalized for human beings (the male version dominating our understanding of the reality) or are the specificalities that women´s reality might or might not have in that area taken into account. This question is linked to the following, although it is more specific. Even when a subject is not linked to gender in general terms, it might look at the specific reality of women in an specific moment, topic during the whole year."]
[null,"107. In a way we are asking: \"how many subjects in your department are linked to gender?\". In order to reply this question, you can check if there are any gender connected words in the title of the subject (gender, equal opportunit*, men/man, women/woman, sex* etc)"]
[null,"108.This can be done through content analysis of the subjects syllabus looking for words connected to gender (such as (gender, equal opportunit*, men/man, women/woman, etc).Specify percentage in next line (line 32). Suggestion for big Institution, this analysis could be done for 1 department on each area, according to the She Figures Areas: Education - Humanities and arts - Social sciences, business and law -Science, mathematics and computing - Engineering, manufacturing and construction - Agriculture and veterinary - Health and Welfare Services "]
[null,"109.This can be be calculated by considering the number of subjects that have gender issues in their syllabus out of nr. of total subjects taught in the department"]

{"sheet":"SUMMARY OF MAIN INDICATORS","index":8,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,3,17,5],[18,3,18,5],[14,3,15,5],[14,2,18,2],[14,1,18,1],[13,3,13,5],[11,1,13,1],[16,3,16,5],[10,6,10,7],[11,2,12,2],[11,3,12,5],[7,3,7,5],[8,3,8,5],[5,3,6,5],[5,2,8,2],[9,3,9,5],[5,1,10,1],[10,3,10,5],[2,1,4,1],[2,3,3,5],[4,3,4,5],[4,6,4,7],[2,2,3,2],[24,0,25,1],[40,0,41,1],[56,0,57,1]]}
[]
[]
[null,"KEY AREA 1\nThe governance bodies, key actors and decision-makers ","1.1. Governing and decision-making bodies","Average composition of governing and decision-making bodies",null,null,"Women (%)","Men (%)"]
[null,null,null,null,null,null,{"$f":"'KEY AREA_1'!F20","v":{"$error":"#DIV/0!"}},{"$f":"'KEY AREA_1'!G20","v":{"$error":"#DIV/0!"}}]
[null,null,"1.2. Gender equality structures in the institution","Gender equality structures in the institution",null,null,{"$f":"'KEY AREA_1'!D27","v":0}]
[null,"KEY AREA 2\nRecuitment,career progression and retention","2.1. Student data","N. of undergraduate students",null,null,"Women (%)","Men (%)"]
[null,null,null,null,null,null,{"$f":"'KEY AREA_2'!I31","v":{"$error":"#DIV/0!"}},{"$f":"'KEY AREA_2'!J31","v":{"$error":"#DIV/0!"}}]
[null,null,null,"N of Master students",null,null,{"$f":"'KEY AREA_2'!I60","v":{"$error":"#DIV/0!"}},{"$f":"'KEY AREA_2'!J60","v":{"$error":"#DIV/0!"}}]
[null,null,null,"N. of PhD students ",null,null,{"$f":"'KEY AREA_2'!H88","v":{"$error":"#DIV/0!"}},{"$f":"'KEY AREA_2'!I88","v":{"$error":"#DIV/0!"}}]
[null,null,"2.2. Selection and recruitment","N. of hired peple ",null,null,{"$f":"'KEY AREA_2'!F102","v":{"$error":"#DIV/0!"}},{"$f":"'KEY AREA_2'!G102","v":{"$error":"#DIV/0!"}}]
[null,null,"2.4. Gender pay gap ","Total gender pay gap",null,null,{"$f":"'KEY AREA_2'!E213","v":0}]
[null,"KEY AREA 3\nWork and personal life integration","3.1. Data on Caring-responsabilities of the RPO's academic staff","N. of people with caring responsibilities",null,null,"Women (N)","Men (N)"]
[null,null,null,null,null,null,{"$f":"SUM('KEY AREA_3'!D10:D11,'KEY AREA_3'!D17)","v":0},{"$f":"SUM('KEY AREA_3'!E10:E11,'KEY AREA_3'!E17)","v":0}]
[null,null,"3.2. Work and personal life integration policies in the institution","N. of people using w-L balance measures in the institution",null,null,{"$f":"SUM('KEY AREA_3'!O33:O41,'KEY AREA_3'!O46:O57,'KEY AREA_3'!O59:O65)","v":0},{"$f":"SUM('KEY AREA_3'!P33:P41,'KEY AREA_3'!P46:P57,'KEY AREA_3'!P59:P65)","v":0}]
[null,"KEY AREA 4\nResearchers and Research: gender equality among researchers and gender perspective/sex in research ","4.1. Academic and research staff data","Grade A- Full professor",null,null,"Women (N)","Men (N)"]
[null,null,null,null,null,null,{"$f":"SUM('KEY AREA_4'!F10:F15)","v":0},{"$f":"SUM('KEY AREA_4'!G10:G15)","v":0}]
[null,null,null,"GRADE B- Associatte professor",null,null,{"$f":"SUM('KEY AREA_4'!F16:F21)","v":0},{"$f":"SUM('KEY AREA_4'!G16:G21)","v":0}]
[null,null,null,"GRADE C- Assistant professor",null,null,{"$f":"SUM('KEY AREA_4'!F22:F27)","v":0},{"$f":"SUM('KEY AREA_4'!G22:G27)","v":0}]
[null,null,null,"GRADE D- Research fellow",null,null,{"$f":"SUM('KEY AREA_4'!F28:F33)","v":0},{"$f":"SUM('KEY AREA_4'!G28:G33)","v":0}]

{"sheet":"MENUAK","index":9,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
["Yes","It does not have scheduled meetings, it meets only when necessary"]
["No","It meets at least twice a year ( at the beginning and at the end of the AY)"]
["I don't know","It meets once a year "]
[null,"Other"]
[]
["None"]
[1]
[2]
[3]
[4]
[5]
["More than 5"]
["Other"]