1. Download Lastest Version of Assessment Book(epp.zip) here
   After Downloading , If you don't know where is it. Then go to folder c:\Documents and Settings\current user\My Documents\Downloads
   and look for file name epp.zip
    
2. move the downloaded file named epp.zip to your new folder
    
3. extract epp.zip by right click at the file name and choose option extract here. Then open two files named pp5eng.xls and student.xls.
    
4. Save as New file name from epp5eng.xls according to this template 22554ง33102sugun610.xls
   (2=Semester 2554=study year ง33102=subject code sugun=Teacher name 610=Ms.6/10 **for supplement subject ms.6 group 1 change to 6x1**)
    
5. Go to coverKPA sheet and then add all your subject data at cells that show ? mark.
    
6. Go to gpaKPA sheet and change value of cells J1 ,K1, L1 to your total units marks : midterm marks : Final marks ratio accordingly
    
7. Go to KPA sheet, find tan color cells (start at cell D5) and change k,p,a full marks for each unit according to your teaching plan.
   Then k + p + a full marks will become your real unit full marks of each unit. (there are 12 units . First 6 units are above and Last 6 units are below)
    
8. Go to standard1-3 sheets, Start At E5 cell Change your full marks of several tests (highest 5 tests for each unit and 4 units per each standard.. sheet)
   These unit marks in each test will be calculated automatically and will be shown at kpa sheet ,gpaKPA sheet. (if you plan to have tests less than 5 time per unit the other full mark of that unit must be 0,do not leave it blank)
    
9. save all everything you have done. (File --> Save) . This file will be your template of your present subject for another class room.(use File --> Save As)
    
10. save as until your last class room for this subject.( One class room for one file). Please be careful to change data to each class room on coverKPA sheet for Subject Data,Advisor and on period1,5,9,13,17 sheets for Student data,teaching date,learning hours.
     
11. For teaching date and learning hours, go to period1,5,9,13,17 Start at E5 add date and period number there from your teaching schedule.
    (one cell for one hour. If you have two hours for that class in one day you could change date cell to the same date.
     
12. For Students Data , Go to opening student.xls file and then copy all your students from selected sheet and then paste to B6 of Period1sheet.
    (you may copy student data from any workbook that has fields code, name ,class and paste only by value option to B6 of Period1sheet or type all manually)
     
13. For presence and absence of students, go to cell E6 - X57 of period1,5,9,13,17 sheet. Add 0 for non permitted absence and Add 1 for permitted absence.
    If students are present for that hour Do notthing. (you could copy absence data from old workbook and than paste by value option on your new version workbook.
     
14. put students marks in each unit test only on standard1,standard2,standard3 sheet. and midterm marks, Final marks on gpaKPA sheet.
    (you could copy unit marks ,Midterm marks, Final marks from from old workbook and then paste by value option on your new version workbook too.
     
15. on QL sheet, You may change assessment level of Quality marks and Literature marks of each student or let it be there without change.
     
16. IF you want to send students lower 80% learning hours to school.
      lower 80%           goto absence sheet click at present hours < 80% print page 2
      get มส,ร                  go to gpaKPA sheet at cell U6-U52 type ร or มส for that student and then goto grade0 sheet
                                             click button grade= "ร" or button grade= "มส" print p3 or p4
     
17. At Final test. There may be failed students for grade,Quality,Literature. You could make report for these cases by
      grade 0             on sheet grade0 click grade= 0 print Page2
      Quality 0            on sheet QLzero click Quality marks= 0 print P1
      Literature 0        on sheet QLzero click Litterature marks=0 print page 2
     
18. Conclusion on all Assessments for this subject by Copying A24-S24 on coverKPA of each file and then paste by value option to conclusion sheet start at D11,D12,...of last class then print page1for report
     

How to upload pp5eng files to school server?

• open school URL name www.schoolptk.ac.th and then click at "ส่งงานและทดสอบออนไลน์" (below on line counter)
  
   
• on this blue web page(118.174.33.86/workshop) choose level,yearth,Teacher then click For Teacher button
  
   
• on this purple web page (118.174.33.86/workshop/subject.php) Type your password which may be ptk2554
  (ask for your lastest password from Mr.Sugun 0896189567) then click "ดูทั้งหมด"
  
   
• Here is your web page for correct password
  
   
• key data on right panel that are necessary in each text box that having * . Then For the first time click "เพิ่ม" at two positions below for the first time.
  
   
• Next time on above form if you want to sent any more files. You only choose file and click "ปรับ".
  If you want to manage all files that have been sent,Click files manager.
  Here is the page for files manager.
  
   
• You Could Upload and Download at school website all the time. Your .xls files will be benefit for yourself,your students and their parents and our school.
  So, Uploading Your Assessment workbooks are our school Suggestion.