Changing subjek order in setup of WinPMR66

1. Importing Marksheet from Excel Template

 Here you have to select Pindah2 to import excel file with names, jantina, kaum and kelas together with the exam marks for all subjects. After you select Pindah2, you have to navigate via Window to search the excel file with the name TING_1.xls. Once you found it, select it and click Pilih button. The import file will be displayed in a temporary file of the system. If it is confirmed that the content is correct, you can close it.

After you select Pindah2, you have to navigate via Window to search the excel file with the name TING_1.xls. Once you found it, select it and click Pilih button. The import file will be displayed in a temporary file of the system. If it is confirmed that the content is correct, you can close it.

 Go to the same menu to select Edit fail pindahan. You need to remove the first row which is the title row of your Excel file. The exam content starts from 2^nd row down. The row containing tiles normally appears a the first record. You need to Delete this record by selecting Del/Undel button. (See Diagram 4)

 

Once you Exit the data entry screen, system will prompt you if you want to remove the marked record for deletion.

Click Ok button to accept. The marked record will then be removed. You can now go to the next step Import ke fail kelas. Select Import2.

Once you do that, the data will be brought into the file TING_1.DBF. This will be your TOV, which resides in your headcount folder where you want to prepare Headcount. Make sure you pick it when you search for TOV.

After you had successfully imported your excel file into the system file of the name TING_1.DBF, you can then use this file as your TOV. You need to run the proses and Analisis again to make sure all the grades are in for all the subject marks. The Analisis will generate RESU_1.TMP for you to do HC5. Remember that it is created in the headcount folder where you do the import. Your search for TOV should be in the same folder where you prepare headcount.

 

 

 

 Save the excel file with the same class name in the same folder where you login. You can then go to the folder to open it to shift the subject columns to follow the subject order of this year.

Next is to login to the headcount folder of F2. Select any class to go in and in Menu Utiliti, go to Bina fail to build a file with the name TING_1 to represent F1 combined file. Select the combined file to go into the system. It is blank. You can now import your Excel file that you had created earlier into it. 

 

 Go to Data > Pindah Dari Excel > Data Excel > Pindah data dari Excel. (See diagram below)

 

 

 

 

Changing Subject order in the Setup file

When using WinPMR65 or WinSPM65, many schools have problem in preparing headcount when they make changes in the subject order in the setup. For headcount to be successfully implemented, they were advised to preserve the subject order. However, sometime there is a need to change the order based on current needs.

I would like to explain how subject order in the setup can be altered by not following the subject order of the previous year when importing TOV, using Final Exam results of the previous year.

This can be done via Excel file since in Excel, user can insert and shift columns around with ease.

You have to note down the new order of subjects before you start to shift around the columns in Excel.

The following procedure uses WinPMR65 as an example. The example makes use of F1 combined file as TOV for preparing headcount for the current year F2.

First login to the Final Exam folder of the previous year and select the combined file. 

Select TING_1.DBF as TOV and go to menu Utiliti, select Pindah ke Excel > fail kelas. (See diagram 2)

Import/Export SAP Data To WinPMR66

How to import/export SAP data to WinPMR66

SAP123 is a school assessment software which was developed in ACCESS by Exam Unit, Johore Education Department. If you have been using this system and wish to imgrate to WinPMR66, you can do so by importing the text files which store exam data. SAP123 produces 5 types of text files which you sent to PPD. These files are TSekolah, Dkelas, DPInduk, DPelPep and tblMPAMb. They have extension TXT to denote that they are text files. You can open to see text file by using NotePad.

Text files are the standard way of sharing information between different databases. To be able for any system to share data, it must be able to generate text files as well as import them.

To import exam data from SAP123 into WinPMR66, you need to copy DPelPep.txt file into the exam data folder of WinPMR66. You then run WinPMR66, create a blank class file by following rules set in creating class of WinPMR66. With this file open, you go to Menu SAP123. Select Import Data SAP. You will be prompted to transfer the content of DPelPep into WinPMR66 temporary file. From this file, you can select the Form and class for you to import into the system. It will populate the class file which was open.

After the import is successful, you need to make sure that the subject order is similar to the order set in SAP123. Go to Menu Utiliti, Setup to change the order of subjects. Save the new subjecct setup file. Next you have to fix the criteria on how you want to rank your students’ performance. Go to Utiliti > Parameter and select your choice. save it. You are now ready to process the SAP data that you imported. WinPMR66 only import the name, gender, race, IC No and exam marks. There is no grade. You need to process it and also to do subject analysis. After that you are now ready to print your marksheet and subject analysis report. You can also print student’s report card.

Export Data to SAP Text Files

If you are using WinPMR66 and wish to export data files in text format for use in SAP123, you may do so by selecting SAP123 menu. Before you do that, you need to process and analyse all classes and then generate the combined file. System will make use of the combine file to export to SAP text files. You need to fill up all information required by SAP123. Make sure you go through each item in SAP123 menu. Then you process the data for each type so that you can generate 5 types of text files as required by SAP123. After you process each type, you may check to see if the format is correct. You can also edit and re-export the text file.

After you had finished all the 5 types of text files, you can then export them to floppy in drive A.

 

Note: To enlarge image, hover your mouse pointer over it and click. To read readers’ comment, click Comments RSS at the side bar.

School assessment software – WinSPM and WinPMR

 

 

The school assessment software was first developed in dbase3+ in 1987. Later from 1993, I use Clipper 5.0 – 5.3 to compile the software so that it could run as a stand alone, not depending on application programmes. The software was converted to Windows using Visual Foxpro and was named as WinSPM30 and WinPMR30 to denote version 3.0. It had been regularly upgraded based on the school requirements. In 2004, version 4.5 with Laporan Adab was included. From 2007, version 6.5 with headcount was added in to meet current requirements in schools.

When Selangor State Education Department through PPD enforced the use of SAP  in schools, the systems were upgraded to version 6.6 to include import and export exam data to SAP.

Registered users of my assessment systems can upgrade to the latest version. All upgrading will be done via email attachment by compression of the programme files.

For registered users who have not received the new upgrade, you may write to me via kohtenggee@hotmail.com. Users must have Hotmail or Yahoo email account to be able to receive the zip files. Unfortunately, gmail from Google rejected zip file attachment.