O bsolete P esticides M anagement S ystem

1. Obsolete Pesticides Management System Training of TrainersRome27 February to 2 March 2006

2. WelcomeBienvenue

3. Start with some questions • Who has been involved in inventory? • Who has done the FAO inventory training? • Who has used the new inventory forms? • Who has used a computer database before • What does the Environmental Management Toolkit do? • Why are you here (let me answer this one!) • Is anyone shy? • Who wants to leave now (it’s your only chance!)

4. Aims of OPMS Training • To introduce Obsolete Pesticide Management System • To understand its links with the new inventory forms • To understand its links with Environmental Management Tookit • To learn to use OPMS to enable you: • To use it yourself for your inventory data • To enable you to teach it to others in your team • To get your feedback of the system

5. What will we be doing? • Using OPMS • Using OPMS • I’ll be lecturing as little as possible • Team working sessions • Group discussions • Individual presentations by you • Using OPMS • Hopefully enjoying the whole process

6. What we will give you • Copies of presentations at end of each day • Handouts • Files • CDs

7. What you will give us • Your undivided attention • Punctuality • A “phone free” environment • Feedback • Your ideas

8. Administration • FAO is a no-smoking building • Fire Exit • Down the stairs to ground floor • Out of building E, on the right • Lavatories • Breaks – Polish Bar in Foyer • webmail – Dedicated PC with internet access. • FAO forbids webmail on training PCs.

9. Agenda

10. Introduction to the Workshop Richard Thompson • Waste Management and Environmental Consultant • Cambridge University Natural Sciences • 20 years experience in international waste management • 10 projects with UN • Tel: 0039 3408768872 • Email: richard.thompson@fao.org

11. Introduction to the Workshop • Mark Davis • Coordinator & Chief Technical Advisor • FAO’s Obsolete Pesticide Program • PANUK • Driving force behind ASP

12. Introductions • Jocelyne Mosseri-Cohen • 10 years with the FAO Obsolete Pesticides Team • Has organized:- • Ale • Mark • Kevin • Translated OPMS French Version and other guidelines • Organized this course

13. Introductions • Grazia Chiu • 5 years with the FAO Obsolete Pesticides Team • Has assisted:- • Ale • Mark • Kevin • Returns from maternity leave 13th March

14. Introductions • Maryse Finka • Assisted with OPMS French Version • Organisation of this course

15. And most importantly who are you? • Take a sheet of flip chart paper • Fill in your details • Name • Country • Ministry / Organization • job title / position • where you are based • Come out and tell us all in your own words • Include what you want to get out of this training

16. Delegates

17. Any questions? Do we all now know why we are here?

18. The agenda for this afternoon • Overview of inventory process • Where does OPMS fit • Paper-based Inventory system • OPMS • Environmental Management Toolkit

19. Before With OPMS Paper-based inventory forms Standardized inventory forms Excel Spreadsheet or Word Table • OPMS • Standardized and simplified data entry • Automatic risk calculations • Integrated prioritization process Manual calculation of comparative risk assessment Manual Prioritization Strategy Development Strategy Development

20. Break 15 minutes

21. New Inventory Forms • Combined Site and Store folder/form • Supplementary store form • 7 Material forms

22. Combined Site and Store Form • A3 format – form and folder • For the first store at the site • Site information • Contact and emergency information • Logistics information • Site plan • Site photos • Store information • Dimensions • Risk analysis questionnaire • Store plan • Store photos

23. Supplementary Store Form • A4 format • For each of the other stores at the site • Store information • Dimensions • Risk analysis questionnaire • Store plan • Store photos

24. Material Form • A4 format • 7 designs for 7 material types • Material types • Pesticides • Veterinary Products • Empty containers • Contaminated soil • Contaminated materials (feed, seeds, fertilizer …) • Contaminated building materials • Contaminated equipment • Material information • Pesticide product or Pesticide contaminant • Physical properties • Condition • Quantity • Photos • Samples

25. OPMS Structure • Web application • Server and database at FAO • Access via internet with web browser (open it) • Advantages • Easy maintenance of the systems at FAO • No complicated software for you to manage • Data • Data is your responsibility • FAO just provide the tools

26. Data Structure

27. Home Page • Language selection • Menu Bar • Log-in • Quick search • Outstanding actions

28. OPMS WorkFlow Process DATA ENTRY VALIDATION REPORTING PRIORITIZATION

29. OPMS WorkFlow – Data Entry Create 1 new Site, store Create Forms for it DATA ENTRY Finish the Site, Store when data entry is complete in ALL its forms Data Entry in its forms Complete data entry in a form

30. Log-in • Explore home page • Menu • Language selection • Have fun!

32. DATA ENTRY Day 2

33. Data Entry • Complete the one record as your country • We’ll then enter data as Mali • To build up sufficient data for demonstrating OPMS reports • Forms • Store form (has site and store information) • Risk analysis • Material forms

34. Wizard • Coloured Bars • Shows you where you are • Use to navigate forwards and backwards • Colour coding used throughout (matches the printed forms)

35. Mandatory Fields • Immediately Mandatory Fields • Required to be entered before you can advance • Marked with • Necessary Fields • Required before the form can be “completed” *

36. Help • Click on the field name in the wizard • Hover over the menu items

37. Save & Session time-out Save by: • Move to next STEP in wizard • For Products, click ADD or UPDATE Session time-out • Server disconnects after 60 minutes from previous save

38. Store Data • Admin areas • Geopolitical areas • Linked to maps in Prioritization Report • Site and Store name • Combination of Site, Store name, Country must be unique, OPMS warns when it is duplicated • Address

39. Store Data – for planning clean-up • Services • Contacts • Logistics

40. GPS field North + East + West - South - Latitude = degrees north (+ve) or south (-ve) of Equator Longitude = degrees east (+ve) or west (-ve) of Greenwich meridian

41. GPS coordinate units • It is easy to confuse Latitude with Longitude. • It is therefore important that the inventory teams should include the point of the compass when they record GPS co-ordinates • Latitude should show N or S • Longitude should show E or W • OPMS uses Decimal Degrees to 4 decimal places • +xxx.xxxx° or - xxx.xxxx° • Decimal point “.” Not Decimal comma “,” • 0.0001° = 11 metres on the world’s surface • Accurate to specify a store • Gazetteer can be used to look up coordinates of cities and towns OPMS may be re-designed to also include N or S with latitudes, and E or W with longitudes

42. Photos and scans • Smallest file size suitable for use • Scans – can be very large files, generally not required • Used a compressed format like .jpg or .gif (NOT .bmp or RAW) • Photos of labels – must be readable • crop photo to the label • compress to document quality 1.5MB » ~ 200kb • General photos (drums, buildings, views) • compress to web quality 1.5MB » ~ 50kb

43. Comment field Inactive comment iconComment field is always open and visible Active comment iconComment field only appears when icon is clicked. When a comment is saved, comment closes and icon turns green.

44. Enter Risk Analysis Questionnaire • Click with mouse • Use: • Tab to move • Space-bar to select Y or N

45. Entering a material form • Material type • Pesticide look-up • In the OPMS list • Not in the OPMS list • Unknown • if 2 or more Active Ingredient, only the most toxic one is shown. • Think of 50 pesticides that you’ll find in your inventory • Look them up • list any that are not there • Hazards • Physical condition • Packaging

46. Entering a material form • Quantity - 3 methods • 27a based on the size of the containers • 27b Estimate using the dimensions of a pile • 27c Estimate using other units • Photos • Size considerations as before • Comments • Comments on the reverse of paper form • Using the Comment icon

47. Modes • Edit mode • Wizard bars visible • Fields editable and shown with white rectangles • Review mode • Overview bar visible • Fields not editable or enterable • Store form becomes one continuous document

48. Entering another stores on the same site • Edit mode • At end of risk analysis form – “create another store at this site” button • Creates a new store with the same site information • Enter each of the material types • Enter similar batches of material with the copy button

49. Samples • When do you need a sample? • Adding Samples • Sample number • Workflow of chasing sample • Sample results • Excel or Word file • Scanned paper report

50. Overview bar & Quick Search • Overview bar • Available in review mode • Shows status of “site, store” and all its forms • Quick search • With field blank, Click to show all stores in your country • Type name of a “store” in field, then click to show all stores that match what you typed.