{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["student 1","Global","Config"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":1,"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":"student 1","index":0,"n_rows":94,"n_cols":23,"rows_kept":94,"cut":false,"hidden":false,"merged":[[60,1,60,2],[62,15,66,15],[62,16,66,16],[62,17,66,17],[62,18,66,18],[62,19,66,19],[62,20,66,20],[62,21,66,21],[62,22,66,22],[64,3,64,13],[65,3,65,13],[66,3,66,13],[67,3,67,13],[68,3,68,13],[69,3,69,13],[1,4,1,18],[11,3,11,13],[12,3,12,13],[13,3,13,13],[14,3,14,13],[7,1,7,2],[15,3,15,13],[16,3,16,13],[34,1,34,6],[34,8,34,13],[34,15,38,15],[32,1,32,2],[39,22,42,22],[40,3,40,6],[40,10,40,13],[42,1,42,6],[42,8,42,13],[19,19,23,19],[19,20,23,20],[19,21,23,21],[19,22,23,22],[24,19,28,19],[24,20,28,20],[24,21,28,21],[24,22,28,22],[19,3,19,13],[19,15,23,15],[19,16,23,16],[19,17,23,17],[19,18,23,18],[24,15,28,15],[24,16,28,16],[24,17,28,17],[24,18,28,18],[38,3,38,6],[38,10,38,13],[39,15,42,15],[39,16,42,16],[39,17,42,17],[39,18,42,18],[39,19,42,19],[39,20,42,20],[39,21,42,21],[34,16,38,16],[34,17,38,17],[34,18,38,18],[34,19,38,19],[34,20,38,20],[34,21,38,21],[43,18,47,18],[43,19,47,19],[43,20,47,20],[43,21,47,21],[43,22,47,22],[44,3,44,6],[44,10,44,13],[45,3,45,6],[45,10,45,13],[46,3,46,6],[46,10,46,13],[47,3,47,6],[47,10,47,13],[43,15,47,15],[43,16,47,16],[43,17,47,17],[39,3,39,6],[39,10,39,13],[34,22,38,22],[36,3,36,6],[36,10,36,13],[37,3,37,6],[37,10,37,13],[48,22,52,22],[48,3,48,6],[48,10,48,13],[48,15,52,15],[48,16,52,16],[48,17,52,17],[48,18,52,18],[48,19,52,19],[48,20,52,20],[48,21,52,21],[74,1,74,2],[76,15,79,15],[76,16,79,16],[76,17,79,17],[76,18,79,18],[76,19,79,19],[76,20,79,20],[76,21,79,21],[76,22,79,22],[78,3,78,13],[79,3,79,13],[80,3,80,13],[80,15,83,15],[80,16,83,16],[80,17,83,17],[80,18,83,18],[80,19,83,19],[80,20,83,20],[80,21,83,21],[80,22,83,22],[81,3,81,13],[82,3,82,13],[83,3,83,13],[84,3,84,13],[84,15,88,15],[84,16,88,16],[84,17,88,17],[84,18,88,18],[84,19,88,19],[84,20,88,20],[84,21,88,21],[84,22,88,22],[85,3,85,13],[86,3,86,13],[89,15,92,15],[89,16,92,16],[89,17,92,17],[89,18,92,18],[89,19,92,19],[89,20,92,20],[89,21,92,21],[89,22,92,22],[90,3,90,13],[91,3,91,13],[92,3,92,13],[93,15,95,15],[93,16,95,16],[93,17,95,17],[93,18,95,18],[93,19,95,19],[93,20,95,20],[93,21,95,21],[93,22,95,22],[9,15,13,15],[9,16,13,16],[9,17,13,17],[9,18,13,18],[9,19,13,19],[9,20,13,20],[9,21,13,21],[9,22,13,22],[14,15,18,15],[14,16,18,16],[14,17,18,17],[14,18,18,18],[14,19,18,19],[14,20,18,20],[14,21,18,21],[14,22,18,22]]}
[]
[null,null,null,null,"Assessment of the IDiverSE Learning Process"]
[]
[null,"Name of the student: ",null,null,null,null,null,null,null,null,null,null,"Group:"]
[]
[null,"A) Assessment of the Design Thinking process"]
[]
[null,"STEP 1: ",null,"Gathering evidences",null,null,null,null,null,null,null,null,null,null,null,"STEP 2: ","Assessment Rubric"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1","Level 2","Level 3","Level 4","1st assessment","2nd assessment","Final assessment"]
[null,"Can be used to assess performance in OSOS Platform",null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Thinking: FEEL","Does not clearly understand the problem and has difficulty in identifying the factors that influence the problem. ","Understands the problem but has difficulty identifying the factors that influence the problem. ","Clearly understands the problem, and understands which are the factors that originate this problem.","Is empathetic with the problem and is able to understand the factors and consequences in their environment and in other contexts.",3,4,{"$f":"AVERAGE(U10:V14)","v":3.5}]
[null,"1st","2nd"]
[null,null,null,"Participates in the process of knowing and understanding the problem."]
[null,null,null,"Proposes solutions to the problem."]
[null,null,null,"Participates in the  design of a final product based on the solutions proposed."]
[null,null,null,"Collaborates with community agents in the process.",null,null,null,null,null,null,null,null,null,null,null,"Design Thinking: IMAGINE","Has difficulties in proposing solutions. ","Proposes several solutions but has difficulties in reflecting on the suitability and effectiveness of the solutions and in choosing one. ","Is able to propose several possible solutions and to choose a solution, however in the selection process, has difficulties in evaluating the suitability and effectiveness of solutions. ","Is able to propose a large number of possible solutions and to evaluate collaboratively the suitability and effectiveness of the proposed solutions until a common solution is found.",2,3,{"$f":"AVERAGE(U15:V19)","v":2.5}]
[null,null,null,"Exposes the results to the community."]
[null,null,null,"Participates in the editing of the project on the platform."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Thinking: CREATE","Has difficulties in developing a final product based on the possible solutions proposed.  ","Is able to develop a final product based on a solution but has not investigated whether it has served to solve the problem raised.","Is capable of developing a final product based on a solution and test it to assess whether or not the solution has served to solve the problem.","Is able to develop a final product based on a solution, test it to assess whether or not the solution has served to solve the problem and is aware of the limitations inherent in the product and the problems.",3,4,{"$f":"AVERAGE(U20:V24)","v":3.5}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Thinking: SHARE","Does not share the problem in community. ","Makes the community aware of the problem but has difficulties in generating interest and inspiring others towards change.","Makes the community aware of the problem and generates debate and awareness, but has difficulty inspiring others and involving them in change.","Is capable of Sharing the knowledge with a community, generating awareness, inspiring them and involving them in change.",1,3,{"$f":"AVERAGE(U25:V29)","v":2}]
[]
[]
[]
[]
[]
[null,"B) Assessment of the 21st Century Skills Development"]
[]
[null,"STEP 1: ",null,"Gathering evidences",null,null,null,null,null,null,null,null,null,null,null,"STEP 2: ","Assessment Rubric"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1","Level 2","Level 3","Level 4","1st assessment","2nd assessment","2nd assessment"]
[null,"Skill 1: Creativity",null,null,null,null,null,null,"Skill 2: Critical Thinking and Problem Solving",null,null,null,null,null,null,"Skill 1: Creativity","Is not open to new points of view, has difficulty proposing and implementing innovative ideas and is not very ingenious in interpreting conclusions and theories.","Is open to new points of view and new learning experiences, asks original questions but has difficulty proposing and implementing innovative ideas as well interpreting conclusions and theories.","Is open to new points of view and new learning experiences, asks original questions and correctly interprets conclusions and theories but has difficulty proposing and implement innovative ideas.","Is open to new points of view and new learning experiences, asks original questions, proposes and implements innovative ideas and is ingenious in interpreting conclusions and theories.",2,2,{"$f":"AVERAGE(U35:V39)","v":2}]
[null,"1st","2nd",null,null,null,null,null,"1st","2nd"]
[null,null,null,"Be open to new points of view and things that are unknown.",null,null,null,null,null,null,"Be critical of the information presented and reason when relating experiences."]
[null,null,null,"Ask original questions and propose innovative ideas.",null,null,null,null,null,null,"To question the why of things, to analyze and value all ideas and to propose new ones."]
[null,null,null,"Implement innovative ideas for data collection and be open to new learning experiences.",null,null,null,null,null,null,"Be accurate, rigorous and methodical in collecting data and drawing conclusions."]
[null,null,null,"Be ingenious in interpreting conclusions and theories and be open to new learning.",null,null,null,null,null,null,"Interpret information and draw conclusions based on the best analysis.",null,null,null,null,"Skill 2: Critical Thinking and Problem Solving","Has difficulty proposing and analysing ideas and is not rigorous and methodical in collecting data and drawing conclusions.","Proposes ideas but is not critical enough regarding the information. Has difficulty collecting data and drawing conclusions. ","Proposes ideas, analyses and values all the ideas and information but is not rigorous and methodical enough in collecting data and drawing conclusions. ","Proposes ideas, analyses and values all ideas and information, gives logical reasons, questions the why of things and is rigorous and methodical in collecting data and drawing conclusions.",2,3,{"$f":"AVERAGE(U40:V43)","v":2.5}]
[null,null,null,"Be ingenious and open when it comes to connecting conclusions with everyday life.",null,null,null,null,null,null,"To reflect and analyze on the research processes, the conclusions reached and the relationship with everyday life."]
[]
[null,"Skill 3: Communication",null,null,null,null,null,null,"Skill 4: Collaboration"]
[null,"1st","2nd",null,null,null,null,null,"1st","2nd",null,null,null,null,null,"Skill 3: Communication","Has difficulty formulating hypotheses and communicating or disseminating the research results and the methods used for data collection.","Communicates the research results but has difficulty formulating hypotheses and using innovative dissemination tools.","Formulates hypotheses, argues and reasons different points of view, disseminates rigorously the research results but has difficulty using innovative dissemination tools.","Formulates hypotheses, argues and reasons different points of view, disseminates rigorously and through innovative ways the research results and the methods used for data collection.",3,4,{"$f":"AVERAGE(U44:V48)","v":3.5}]
[null,null,null,"Express and argue previous views and experiences.",null,null,null,null,null,null,"Be open to sharing opinions and experiences."]
[null,null,null,"Formulate hypotheses, argue and reason the different points of view.",null,null,null,null,null,null,"Propose collaborative test systems accepting the contribution of others."]
[null,null,null,"Disseminate rigorously the research results and data collection methods used.",null,null,null,null,null,null,"Collaborate in obtaining data with other members and jointly contribute to the extraction of conclusions."]
[null,null,null,"Express  the interpretation of the conclusions and listen to the interpretations of others.",null,null,null,null,null,null,"Contribute to the correct interpretation of results and the definition of new theories."]
[null,null,null,"To show innovative ways of communicating research results and actively participating in discussions.",null,null,null,null,null,null,"Contribute to the group in the process of analysis and reflection of the research process..",null,null,null,null,"Skill 4: Collaboration","Has problems working in groups and making important contributions at different stages of the research process. ","Is open to work in group and share opinions, but does not contribute to the interpretation of results, the extraction of conclusions and the reflection about the research process.","Is open to work in group and share opinions, collaborates in obtaining data with other members, but does not contribute enough in the extraction of conclusions or in the reflection about the research process.","Is open to share opinions, collaborates in obtaining data with other members and contributes to the group in the interpretation of results, the extraction of conclusions and the reflection about the research process.",3,4,{"$f":"AVERAGE(U49:V53)","v":3.5}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,"C) Assessment of the Collaborative Data Collection"]
[]
[null,"STEP 1: ",null,"Gathering evidences"]
[]
[null,"Can be used to assess performance in Globallab platform"]
[null,"1st","2nd"]
[null,null,null,"Follows a protocol to collect valid data."]
[null,null,null,"Understands the process of collecting scientific data."]
[null,null,null,"Knows how to collaborate effectively with teammates in the data collection process."]
[null,null,null,"Communicates effectively with others from different countries and cultures."]
[null,null,null,"Shows respect when communicating with others."]
[null,null,null,"Shows initiative in the exchange of ideas with other students from other islands."]
[]
[]
[null,"E) Assessment of the Inquiry process"]
[]
[null,"STEP 1: ",null,"Gathering evidences",null,null,null,null,null,null,null,null,null,null,null,"STEP 2: ","Assessment Rubric"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Level 1","Level 2","Level 3","Level 4","1st assessment","2nd assessment","Final assessment"]
[null,"Can be used to assess performance in Graasp platform",null,null,null,null,null,null,null,null,null,null,null,null,null,"1: Orientation","Does not pay attention to what others say and does not share personal views on the subject. ","Gives attention to what others say but does not share personal views and ideas with others.","Gives attention to what others say and shares personal opinions.","Gives full attention to what others say taking time to understand, asking questions and sharing personal opinions and refers to previous knowledge.",2,3,{"$f":"AVERAGE(U77:V80)","v":2.5}]
[null,"1st","2nd"]
[null,null,null,"Shows interest in knowing the problem to be addressed."]
[null,null,null,"Listens to the contributions of others."]
[null,null,null,"Participates by contributing ideas and opinions.",null,null,null,null,null,null,null,null,null,null,null,"2: Conceptualisation","Has difficulty understanding the research problem, designing and developing an implementation plan to solve the problem.","Understands the research problem but has difficulty to design and develop an implementation plan to solve the problem.","Understands the problem, develops an implementation plan to solve the problem but does not identify the strengths/weaknesses of the investigation plan.","Understands the problem, develops an implementation plan to solve the problem and uses logic and reasoning to identify the strengths/weaknesses of the investigation plan.",3,3,{"$f":"AVERAGE(U81:V84)","v":3}]
[null,null,null,"Formulates hypotheses and/or questions based on the problem. "]
[null,null,null,"Understands the relationship between variables."]
[null,null,null,"Collects data in an organized way."]
[null,null,null,"Is based on data when making conclusions.",null,null,null,null,null,null,null,null,null,null,null,"3: Investigation","Has difficulty in making predictions, asking questions, identifying variables of the research problem and performing the experimentation.","Makes predictions and asks questions but has difficulty dentifying variables of the research problem and collecting data.","Makes predictions and questions, identifies variables of the problem but does not use  scientific rules to perform experimentation.","Uses logic and reasoning to make predictions and questions, identifies variables of the problem and uses scientific rules effectively to perform experimentation.",3,4,{"$f":"AVERAGE(U85:V89)","v":3.5}]
[null,null,null,"Expose findings in a clear way."]
[null,null,null,"Participates in discussions."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4: Conclusion","Does not take into account the proposals given by others and does not make conclusions based on solid arguments.","Takes into account the proposals of others but does not assess the results to obtain conclusions. Conclusions are not based on solid arguments.","Takes into account the proposals by others and communicates conclusions based on solid arguments but does not assess the results to obtain the conclusions.","Assesses the results in order to draw correct conclusions, takes into account the proposals by others and communicates conclusions based on solid arguments. ",3,3,{"$f":"AVERAGE(U90:V93)","v":3}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5: Discussion","Has difficulty communicating the results and preparing presentations to show the research process. ","Communicates the results using solid arguments but has difficulty preparing successful presentations to show the research process. ","Communicates the results using solid arguments and prepares successful presentations to show the research process.","Communicates the results using scientific terms properly as well as valid arguments and prepares successful presentations including the most relevant information. ",2,3,{"$f":"AVERAGE(U94:V96)","v":2.5}]

{"sheet":"Global","index":1,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,2,6,5],[7,2,7,5],[0,8,2,13],[6,10,6,14],[7,10,7,14],[6,6,6,9],[7,6,7,9]]}
[null,null,null,null,null,null,null,null,"Final Assessment of the IDiverSE Learning Process"]
[]
[]
[]
[null,"STEP 3: ","Global Assessment"]
[]
[null,null,"Design thinking",null,null,null,"21st Century Skills",null,null,null,"Inquiry"]
[null,null,0.4,null,null,null,0.4,null,null,null,0.2]
[null,"N Student","FEEL","IMAGINE","CREATE","SHARE","S1: Creativity","S2: Critical Thinking","S3: Communica-tion","S4: Collaboration","1: Orientation","2: Conceptuali-sation","3: Investigation","4: Conclusion","5: Discussion","final grade (out of 10)","Comments"]
[null,"student 1",{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$10\"))","v":3.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$15\"))","v":2.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$20\"))","v":3.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$25\"))","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$35\"))","v":2},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$40\"))","v":2.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$44\"))","v":3.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$49\"))","v":3.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$77\"))","v":2.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$81\"))","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$85\"))","v":3.5},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$90\"))","v":3},{"$f":"INDIRECT(CONCATENATE(\"'\",$B10,\"'!$W$94\"))","v":2.5},{"$f":"((AVERAGE(C10:F10)*$C$8))*10/4+((AVERAGE(G10:J10)*$G$8)*10/4)+((AVERAGE(K10:O10)*$K$8)*10/4)","v":7.2000000000000011}]
[]
[null,"Average",{"$f":"AVERAGE(C10:C11)","v":3.5},2.5,3.5,2,2,2.5,3.5,3.5,2.5,3,3.5,3,2.5,7.2000000000000011]

{"sheet":"Config","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Number of students:"]
[null,5]
[]
[null,"Instructions:"]
[null,"1) Change the number of students (cyan cell)  [possitive - between 2 and 50]"]
[null,"2) Press the \"CREATE\" button"]
[null,"3) Wait some seconds to sheets to be created"]
[null,"4) Sheet \"Global\" will have a row for each student"]
[null,"Notice that sheets will not be deleted (if there already are sheets for n students and you want to create less than n, nothing will happen)"]
[]
[null,"Please, don't change the structure of sheets or data formulas could stop working!!!"]