{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Acknowledgements","Instructions","Assessment","Students","Marks","Feedback DEMO","Blank"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Acknowledgements","index":0,"n_rows":42,"n_cols":2,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Feedback Spreadsheet for HWB"]
[]
["Originally designed by John S Kirkwood (FDS), with assistance from Sue Drew (LTI) and Richard Mather (LTI)."]
[]
["Version date","2013-09-19"]
[null,"(Modifed by Alison Purvis (HWB) and Jon Wheat (HWB))"]
[]
["Comments","Feel free to modify this model in any way that you feel is necessary to suit your purposes."]
[null,"However, it would be helpful if you could send John Kirkwood any amendments as the aim is "]
[null,"to create a generalised model that can be used by all staff."]
[]
[null,"Any questions about this version of the spreadsheet, please contact Alison Purvis x5699"]
[]
["Macros:","CNTRL + SHFT + F = create new feedback worksheet"]
[null,"CNTRL + SHFT + D = create new feedback worksheet with student details included from STUDENTS spreadsheet (see STUDENTS spreadsheet for more information), automatic tab naming and automatic mark sheet generation."]
[null,"CNTRL + SHFT + P = output all student feedback sheets as PDF files with student name as file"]
[null,"name"]
["2006-01-19"]
["Modifications made by AP:","Feedback sheet formatting to match the standard hand-in sheet and arrange to fit A4."]
[null,"Macros added to make generation of student feedback sheets semi-automatic.  Only need to rename tab."]
[null,"Column B with marks for each section /100, white text hidden on white background"]
[null,"Marks for each section, generated from column B - rounded up using the CEILING function to avoid mismatch with SUM at bottom of sheet"]
["2008-01-31"]
["Modifications made by JW:","Automatic Sheet naming added to the macro."]
[]
["2009-04-21"]
["Modifications made by AP:","Full instructions included and some minor changes made to the set-up."]
[]
["2010-03-22"]
["Modifications made by AP & JW:","Automatic generation of a marks sheet has been added to the CNTRL + SHFT + D Macro."]
[]
["2010-05-06"]
["Modifications made by AP:","Added hidden row (3) to mark sheet to contain the final mark to stop the macro being broken robust"]
[null,"when rows are deleted."]
["2010-10-15"]
["Modifications made by JW:","Added code to output each worksheet as a PDF with naming suitable for batch upload to the SHU"]
[null,"assignment handler. Subsequent change made 19/09/2013 to withdrawl of SHU handler."]
["2011-12-19"]
["Modifications made by AP:","Added zero comment to each criteria and conditional formatting to comment cells in blank"]
[null,"feedback sheet - to prevent accident missing of marks.  Also tidied some formatting on blank."]
["2013-09-19"]
["Modifications made by AP:","Changed PDF naming to Student Name followed by student number"]

{"sheet":"Instructions","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[20,4,20,6]]}
["To get the spreadsheet working for your assessment task:"]
[]
["Intro:","This spreadsheet works with macros and cell formulas to provide feedback comments that consistently match marks awarded.  You can also enter individualised feedback comments.  To benefit from the automatic functions (such as automatic sheet naming with student names) you need to make sure that various parts of this workbook are set up for your module.  Review the \"Feedback DEMO\" sheet to get an idea of how the workbook works."]
[]
["Part 1:","The \"Assessment\" sheet includes the basic information about the assessment as well as the grid of feedback comments.  The first step is to modify the assessment information at the top of the sheet and then edit the criteria and feedback comments."]
[]
[null,"This step is probably the most time consuming and you may need to spend some time working on the feedback comments to get them right for your assessment."]
[]
["Part 2:","Once you have edited the assessment sheet and are happy with your comments, check that the \"Blank\" feedback sheet is showing the correct information.  The majority of the information is drawn automatically onto this sheet so you probably only need to check that the \"Session\" is correct (i.e. 2008/9) and that you are giving feedback to undergraduates or postgraduates."]
[]
[null,"If you have added more criteria that are currently shown in this demo you will need to modify the \"Blank\" sheet to incorporate the additional criteria in new rows with the same formulas as the rows already displayed.  If you have less criteria then you only need to delete the unnecessary rows."]
[]
["Part 3:","You are now ready to input your student details into the \"Students\" sheet.  Copy a class list from the class lists available from the online timetable area of the staff intranet.  See the \"Students\" sheet for the information required.  The main thing to make sure is that the student name is in the format of \"Surname,Forename\" in a single cell rather than the surname and forename in two cells."]
[]
[null,"With all the student names listed in the \"Students\" sheet, select cell B11 and re-sort the list with the last surname first (use sort from the DATA menu and resort the list with surnames descending from Z to A). New feedback sheets are created to the left of existing sheets.  Resorting the list allows the worksheet to be listed from A-Z once they have all been created."]
[]
[null,"Now you can use one of the macros within this sheet to create a new feedback worksheet with student details automatically inputted.  If you press CNTRL + SHFT + D, a worksheet will be created for the first student in the list.  Each newly created sheet will have the student details inputted, and the sheet will be named with the student's name. Student names are deleted from the list once the feedback sheet has been created.  Press CNTRL + SHFT + D to create the next sheet using the new details at the top of the list."]
[]
[null,"If you need to create a new feedback sheet after this point, you can create a new sheet by pressing CNTRL + SHFT + F."]
[]
[null,"Note that names with an apostrophe will break the macro, so remove any apostrophes (i.e. O'Connor should be changed to OConnor.)"]
[]
["Part 4:","You are now ready to mark!  Column B (B16-B21 in the \"Feedback DEMO\" sheet) contains white text on a white background and is therefore hidden.  Input a mark out of 100 for each criterion in this column.  When you press the enter or tab key you will see the mark awarded change and the corresponding comment. The mark awarded will be the product of the weighting of that criterion and the % mark that you have entered."]
[]
[null,"Continue to mark each criterion in this way and when completed the sheet will also have the final mark calculated (cell A25 in the demo).  A space is also included for individual comments to be inputted.  On this example the box is titled \"Things to think about next time:\".  "]
[]
["Part 5: ","These sheets can be printed as PDF. The file name will be the student name (in cell G2) followed by the student number. Make sure that student names as surname, firstname to ensure easy sorting."]
[]
[null,"Use the included macro to output all the student feedback sheets once all the marking has been completed: CNTRL + SHFT + P"]

{"sheet":"Assessment","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Faculty name","Faculty of Health and Wellbeing"]
["Programme/Course","Course title here"]
["Module Title","Module title here"]
["Module Code","Module code here"]
["Level","Level of study"]
["Marker(s)","Tutor name here"]
["Date of Submission","Date of Submission here"]
["Date of Marking","Date of marking here"]
[]
["Criteria","First","First","Upper Second","Lower Second","Third","Fail","Zero","Weighting %"]
[null,null,null,null,null,null,null,null,0]
["Overall comment",">80 First","70-79 First","60-69 2i","50-59 2ii","40-49 Third","<39 Fail","0"]
["Criteria 1","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 2","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 3","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 4","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 5","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 6","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 7","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 8","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 9","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
["Criteria 10","Comments","Comments","Comments","Comments","Comments","Comments","No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback",10]
[]
[null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(I13:I22)","v":100}]

{"sheet":"Students","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,1,6,2],[0,0,0,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
["Instructions for Automatic Student Detail Input to Feedback Sheets"]
[]
["Step 1:","Copy and paste details from your Excel spreadsheet module list. "]
["Step 2:","Place the cursor in the B11 and re-sort the list with the last surname first (use sort from the DATA menu and resort the list with surnames descending from Z to A). New feedback sheets are created to the left of existing sheets.  Resorting the list allows the worksheet to be listed from A-Z once they have all been created."]
["Step 3:","Press CNTRL + SHFT + D to create new feedback worksheet with student details automatically inputted.  "]
["Step 4:","Each newly created sheet will have the student details inputted, and the sheet will be named with the student's name."]
["Step 5:","Student names are deleted from the list once the feedback sheet has been created.  Press CNTRL + SHFT + D to create the next sheet using the new details at the top of the list."]
[]
[]
["STU NO.","NAME","ROUTE"]

{"sheet":"Marks","index":4,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["STU NO.","NAME","MARKS"]

{"sheet":"Feedback DEMO","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,4,18,5],[0,1,0,3],[1,1,1,3],[7,1,7,4],[8,1,8,4],[9,0,9,5],[10,0,10,5],[11,0,11,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[19,4,19,5],[20,0,20,5],[21,0,21,5],[23,1,23,3],[25,0,25,5]]}
["Student Reg. No:","Course",null,null,"Level of Study:","Name:"]
["Filled by the macro","Filled by the macro",null,null,"Filled by the macro","Filled by the macro"]
[]
["UNDERGRADUATE PROGRAMME",null,null,null,null," SESSION 2009/2010"]
["ASSIGNMENT COVER/FEEDBACK SHEET"]
["INTERNAL EXAMINER’S COURSEWORK ASSIGNMENT REPORT"]
[]
["Unit Code:","Unit Title:",null,null,null,"Hand-in date:"]
["19-6X08-00L","Applied Physiology of Sport Performance",null,null,null,"2009-02-23"]
["Mitigating circumstances requested against this unit? Yes  ¨     No  ¨ "]
["(If ‘yes’ a mitigating circumstances form, EC1, must be submitted to the Level Manager/Route Leader)"]
["Tutor Comments:"]
["Criteria",null,"Max Marks","Mark Awarded","Comment"]
[null,null,"%","%"]
["Background and Supporting Information",100,15,15,"Your supporting background information is highly detailed for each task.  You have analysed areas relevant to the chosen sport in a highly critical, thorough and appropriate way.  You have used a variety of primary literature sources in a comprehensive and articulate way."]
["Presentation",100,15,15,"You have used high quality scientific language with accurate SI units and SHU Harvard Referencing."]
["Content",50,30,15,"You have used evidence from literature to illustrate issues relevant to your chosen sport.  Your descriptions of applied physiology are generally appropriate for your chosen sport.  You have broadly applied theory to your chosen sport."]
["Use of Relevant Literature",100,15,15,"You have used a range of current and relevant literature sources. You have used sources that are specific and have not just relied upon the recommended resources.  You have clearly shown a reasoned choice of research evidence.  You have used key detail in an advanced way to illustrate the key aspects of the summary."]
["Critical Evaluation",100,15,15,"Your critical evaluation of the research evidence is advanced and of a high scientific quality.  You have considered the performance elements of your chosen sport well.  You have made links with a variety of research outcomes in the literature and your evaluation and analysis of conflicting evidence is demonstrated well."]
["Summarising and conciseness",100,10,10,"Your summary is well balanced and concise.  You include the key points of the specific topic in the context of your chosen sport. Your work draws out the most important aspects of the sport and the topic and you do so in a clear and scientific style and structure."]
["Things to think about next time:"]
["Add your individualised comments here."]
["Proposed Mark:","Name of Marker(s):",null,null,null,"Date:"]
[85,"Dr Alison Purvis",null,null,null,"2009-02-25"]
[]
["THIS MARK/GRADE IS PROVISIONAL AND IS SUBJECT TO CHANGE FOLLOWING INTERNAL AND/OR EXTERNAL MODERATION AND SCRUTINY"]

{"sheet":"Blank","index":6,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,1,1,4],[10,4,10,8],[7,6,7,8],[8,6,8,8],[0,1,0,4],[7,1,7,5],[8,1,8,5],[17,4,17,8],[27,0,29,8],[9,4,9,8],[20,0,20,8],[21,0,21,8],[19,4,19,8],[16,4,16,8],[15,4,15,8],[18,4,18,8],[14,4,14,8],[13,4,13,8],[11,4,11,8],[12,4,12,8]]}
["Student Reg. No:","Course:",null,null,null,"Level:","Student Name:"]
[null,null,null,null,null,{"$f":"Assessment!B5","v":"Level of study"}]
[{"$f":"A26","v":0},null,"Do not delete this row!!!!"]
["UNDERGRADUATE PROGRAMME",null,null,null,null,null,null,null," SESSION 2010/2011"]
["ASSIGNMENT COVER/FEEDBACK SHEET"]
["INTERNAL EXAMINER’S COURSEWORK ASSIGNMENT REPORT"]
[]
["Module Code:","Module Title:",null,null,null,null,"Hand-in date:"]
[{"$f":"Assessment!B4","v":"Module code here"},{"$f":"Assessment!B3","v":"Module title here"},null,null,null,null,{"$f":"Assessment!B7","v":"Date of Submission here"}]
["Criteria",null,"Max","Awarded","Feedback"]
[{"$f":"Assessment!A13","v":"Criteria 1"},0,{"$f":"Assessment!I13","v":10},{"$f":"CEILING((B11/100)*C11,0.5)","v":0},{"$f":"IF(A11=\"\",\"\",IF(B11>79,Assessment!B13,IF(AND(B11<80,B11>69),Assessment!C13,IF(AND(B11<70,B11>59),Assessment!D13,IF(AND(B11<60,B11>49),Assessment!E13,IF(AND(B11<50,B11>39),Assessment!F13,IF(AND(B11<40,B11>0),Assessment!G13,IF(AND(B11=0),Assessment!H13))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A14","v":"Criteria 2"},0,{"$f":"Assessment!I14","v":10},{"$f":"CEILING((B12/100)*C12,0.5)","v":0},{"$f":"IF(A12=\"\",\"\",IF(B12>79,Assessment!B14,IF(AND(B12<80,B12>69),Assessment!C14,IF(AND(B12<70,B12>59),Assessment!D14,IF(AND(B12<60,B12>49),Assessment!E14,IF(AND(B12<50,B12>39),Assessment!F14,IF(AND(B12<40,B12>0),Assessment!G14,IF(AND(B12=0),Assessment!H14))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A15","v":"Criteria 3"},0,{"$f":"Assessment!I15","v":10},0,{"$f":"IF(A13=\"\",\"\",IF(B13>79,Assessment!B15,IF(AND(B13<80,B13>69),Assessment!C15,IF(AND(B13<70,B13>59),Assessment!D15,IF(AND(B13<60,B13>49),Assessment!E15,IF(AND(B13<50,B13>39),Assessment!F15,IF(AND(B13<40,B13>0),Assessment!G15,IF(AND(B13=0),Assessment!H15))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A16","v":"Criteria 4"},0,{"$f":"Assessment!I16","v":10},{"$f":"CEILING((B14/100)*C14,0.5)","v":0},{"$f":"IF(A14=\"\",\"\",IF(B14>79,Assessment!B16,IF(AND(B14<80,B14>69),Assessment!C16,IF(AND(B14<70,B14>59),Assessment!D16,IF(AND(B14<60,B14>49),Assessment!E16,IF(AND(B14<50,B14>39),Assessment!F16,IF(AND(B14<40,B14>0),Assessment!G16,IF(AND(B14=0),Assessment!H16))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A17","v":"Criteria 5"},0,{"$f":"Assessment!I17","v":10},0,{"$f":"IF(A15=\"\",\"\",IF(B15>79,Assessment!B17,IF(AND(B15<80,B15>69),Assessment!C17,IF(AND(B15<70,B15>59),Assessment!D17,IF(AND(B15<60,B15>49),Assessment!E17,IF(AND(B15<50,B15>39),Assessment!F17,IF(AND(B15<40,B15>0),Assessment!G17,IF(AND(B15=0),Assessment!H17))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A18","v":"Criteria 6"},0,{"$f":"Assessment!I18","v":10},0,{"$f":"IF(A16=\"\",\"\",IF(B16>79,Assessment!B18,IF(AND(B16<80,B16>69),Assessment!C18,IF(AND(B16<70,B16>59),Assessment!D18,IF(AND(B16<60,B16>49),Assessment!E18,IF(AND(B16<50,B16>39),Assessment!F18,IF(AND(B16<40,B16>0),Assessment!G18,IF(AND(B16=0),Assessment!H18))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A19","v":"Criteria 7"},0,{"$f":"Assessment!I19","v":10},0,{"$f":"IF(A17=\"\",\"\",IF(B17>79,Assessment!B19,IF(AND(B17<80,B17>69),Assessment!C19,IF(AND(B17<70,B17>59),Assessment!D19,IF(AND(B17<60,B17>49),Assessment!E19,IF(AND(B17<50,B17>39),Assessment!F19,IF(AND(B17<40,B17>0),Assessment!G19,IF(AND(B17=0),Assessment!H19))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A20","v":"Criteria 8"},0,{"$f":"Assessment!I20","v":10},0,{"$f":"IF(A18=\"\",\"\",IF(B18>79,Assessment!B20,IF(AND(B18<80,B18>69),Assessment!C20,IF(AND(B18<70,B18>59),Assessment!D20,IF(AND(B18<60,B18>49),Assessment!E20,IF(AND(B18<50,B18>39),Assessment!F20,IF(AND(B18<40,B18>0),Assessment!G20,IF(AND(B18=0),Assessment!H20))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A21","v":"Criteria 9"},0,{"$f":"Assessment!I21","v":10},0,{"$f":"IF(A19=\"\",\"\",IF(B19>79,Assessment!B21,IF(AND(B19<80,B19>69),Assessment!C21,IF(AND(B19<70,B19>59),Assessment!D21,IF(AND(B19<60,B19>49),Assessment!E21,IF(AND(B19<50,B19>39),Assessment!F21,IF(AND(B19<40,B19>0),Assessment!G21,IF(AND(B19=0),Assessment!H21))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
[{"$f":"Assessment!A22","v":"Criteria 10"},0,{"$f":"Assessment!I22","v":10},0,{"$f":"IF(A20=\"\",\"\",IF(B20>79,Assessment!B22,IF(AND(B20<80,B20>69),Assessment!C22,IF(AND(B20<70,B20>59),Assessment!D22,IF(AND(B20<60,B20>49),Assessment!E22,IF(AND(B20<50,B20>39),Assessment!F22,IF(AND(B20<40,B20>0),Assessment!G22,IF(AND(B20=0),Assessment!H22))))))))","v":"No mark has been entered for this criterion.  If the mark should be zero, please overwrite this comment with appropriate feedback"}]
["Additional Feedback"]
[]
["Maximum mark =",null,{"$f":"SUM(C11:C20)","v":100}]
["Your mark =",null,{"$f":"SUM(D11:D20)","v":0}]
["Proposed Mark %:",null,"Name of Marker(s):",null,null,null,"Date:"]
[{"$f":"(C24/C23)*100","v":0},null,{"$f":"Assessment!B6","v":"Tutor name here"},null,null,null,{"$f":"Assessment!B8","v":"Date of marking here"}]
[]
["THIS MARK/GRADE IS PROVISIONAL AND IS SUBJECT TO CHANGE FOLLOWING INTERNAL AND/OR EXTERNAL MODERATION AND SCRUTINY"]