User Manual for CO
& PO Attainment Macro
Step-by-step procedure
- Download
the OBE raw data for each course from Contineo-software. Copy all the raw
data files into a folder (Say D:/ NBA-Criteria3/Attainment/Rawdata)
- Download
the CO-PO mapping report from HoD login of contineo. Note: The report (excel format) should have the
CO-PO mappings of all the courses for which OBE raw data is downloaded.
- Download
“Batch_Attainment_Template.xlsx”
from this link.
The CO-PO mappings should be pasted in the sheet “Co-Relation REPORT” of “Batch_Attainment_Template.xlsx”
- Download
the macro using the following Link.
It requires SIT email
- Unblock
the macro by right clicking the downloaded file
- Open
the excel file and update the (i) paths to the OBE raw data (say D:/
NBA-Criteria3/Attainment/Rawdata ) (ii) path for the output files (iii) path for CO-PO
mapping file (iv) path for the summary file-
- Also
Download the “AttainmentData_Template” from the following link.
Save it in the same folder as the Raw Data
- Execute
“Process Workbooks” macro using Command button in RawData2Attainment.xlsm