{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"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":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Please follow the instructions below to calculate your course ILOs. "]
["(maximum number of ILOs that this file can calculate is 15 and maximum number of students in a class is 100)"]
["Perform each step on the Data sheet and check the box in the instructions sheet once you finish each step"]
[]
["1- Enter the program ILOs numbers that your course measures in raw 1 starting cell B1 (one ILO per cell)"]
["2- Enter the course ILOs numbers that corresponds to each program ILO in raw 2 staring cell B2 (up to cell P2)"]
["3- Enter the assessment method you used to measure each course ILO in raw 3 staring cell B3 (e.g. Final, first, second, lab, project)"]
["4- Enter the total mark for each assessment method in raw 4 starting cell B4"]
["5- Leave raw 5 empty, the results will appear in it"]
["6- Leave raw 6 empty"]
["7- Copy your students IDs which contains the major  (from Moodle) starting A7"]
["8- Copy students marks in each assessment method under the appropriate column"]
["9- Remove the raws of students' marks that did not pass the course (F, D-, W, I, FA)"]
["10- save your file "]
["11- Press the filter button in the data sheet"]
["12- Make sure that students marks were moved according to their majors into 4 different sheets (CS,CIS,SE,CN)"]
["13- Press calculate percentages button in the data sheet. "]
["14- Make sure that percentages of ILO attainments were calculated in the data sheet and according to majors"]
["15- Save the file"]
["16- Use the percentages of attainments in the data sheet for the QA form"]
["17- upload this file to the Moodle submission course"]

{"sheet":"Data","index":1,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,0,5,15]]}
["Program ILO no.","A.7","A.7","B.2","C.1","I.3","B.1",null,null,null,null,null,null,null,null,null,"Instuctor Name:","Nuha El-Khalili"]
["Course ILO no.","K1","K2","I1","I2","P1","P2",null,null,null,null,null,null,null,null,null,"Course Name: ","Software Engineering"]
["Assessment method ","First","Second","Stage3","stage5","CASE","Stage2",null,null,null,null,null,null,null,null,null,"Course Name:",603392]
["Assessment Total Mark",15,20,20,15,5,15,null,null,null,null,null,null,null,null,null,"Semester:",20161]
["% of attainment"]
["Please leave this raw Empty"]
["201230120_IS",3.5,9,null,null,5,5]
["201510208_SE",8.5,14.5,null,null,5,0]
["201510470_CIS",13,15.5,16.5,null,5,15]
["201510573_IS",13.5,15,17,14,5,15]
["201520273_CIS",12,17.5,18,14,5,14]
["201520595_CS",12,18,19,14,5,15]
["201520705_SE",10.5,8,11,5,2,12]
["201610060_CN",13.5,14,18,14,5,9]
["201610544_IS",8.5,6.5,19,14,5,13]
["201610617_CS",13.5,17,18,14,5,12]
["201620243_CS",13.5,11.5,19,14,5,14]
["201620277_SE",11,12,11,0,5,13]
["201620288_SE",9.5,9,12,2,2,12]
["201620347_IS",12.5,17,18,13,5,13]
["201620423_SE",14.5,18.5,15,12,5,13]
["201620509_SE",10.5,6,null,null,5,0]
["201620749_SE",9,14.5,11,5,3,10]
["201620771_CS",12.5,19,17,14,5,13]
["201710037_CS",9,7,18,14,5,11]
["201710215_CS",12,12,10,5,2,10]
["201710447_CIS",12.5,11.5,15,12,5,13]
["201710639_SE",11.5,10,18,13,3,14]
["201710647_IS",12,15.5,16.5,null,5,11]
["201710693_CS",13,11,11,5,2,11]
["201710944_CS",13.5,18,19,14,5,13]
["201711271_IS",14,19.5,17,14,5,15]
["201720195_IS",11.5,9,18,13,5,10]
["201820111_CIS",11,12,12,2,2,14]