Third Party Validation of Performance of PTCs of Khyber Pakhtoonkhwa Pakistan Project Assigned By:
Education Department of Khyber Pakhtoonkhwa Pakistan Project Assigned To:
HRDC, IMSciences Peshawar Pakistan Project Field Work Domain:
All Schools of Khyber Pakhtoonkhwa Pakistan (No of Sample Schools 5400) Software for Statistical Analysis and Its Reporting: First Time OpenEPR used as Statistical Analysis Software and for its Statistical Reporting Software Tools Used:
OpenERP Framework, Python, Postgresql, PDF & MSExcel and Linux platform as OS First Time OpenERP for Statistical Analysis and Its Reporting:
First Time OpenERP is used for strong statistical analysis and its reporting. Approximately 89 users entered 5400 schools data using OpenERP interface from different terminals.Each school have 5 different survey forms i.e. Auditors Form, EDO Form, Secretary Form and Member Council Form.Each form has 40-50 different questions representing school different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate and much more. Overview of Modules Developed in OpenERP for Statistical Analysis There are two modules developed for this project
- Module hrdc includes objects, tree views, forms views, update data files, wizards, menus and security rights files.
- Module hrdc_reporting includes 15 different statistical reports (including summary and details). These reports first print in pdf and we also export these report in MSExcel for report writing purpose.
If You want to change the order of tabular data in MS Excel from vertical to Horizontal or Horizontal to vertical then follow the steps.
Step 1: Copy The Tabular data in excel sheet.
Step 2: Select Paste Special where ever u want to paste in same sheet or another sheet.
Step 3: Enable the ‘Transpose’ option from Paste Special Dialog Box and press ok.
Step 4. Finish. u can check the following video for demonstration.