eWorksheet User Manual
Contents
1. Provincial unit District unit Independent community group Collaborative management agency between private sector government and community groups Privately managed MPA Collaborative community and government group Collaborative community Government and NGO group Collaborative NGO and Government O O OOO So oo Collaborative community and NGO oO Name of Management Body Year management body was formed Year management body was active wo m Figure 14 List of Questions of Table A part 1 17 G IA Has the management body received preliminary training Document what training has been provided if the table below is not and capacity building to run the MPA sufficient you can make a list in separate file Name of staff member Position in Training received including management Management Body duration of training representative Have biophysical baseline results been used for setting SMART goal s and target s for what the MPA hopes to conserve in the biophysical environment i e xx of reef habitat maintained xx turtle nests yr reduction in destructive fishing practices by xx annually etc Have results of socio economic baseline survey s been Please describe these goal s and target s used for setting SMART goal s and target s for what the MPA hopes to achieve in terms of socio economic intervention s i e xx population with alternative livelihoods t2. Has the management plan of the MPA been Evidence is available to show adoption of MPA management plan by adopted by the local government local government This evidence is in the form of 13 O Q Q gt gt gt gt gt gt gt QO examples are agreed changes to fisheries permitting systems improvement in prosecution of MPA related cases Etc de Is the MPA being used for research and education please add as necessary Figure 18 List of Questions of Table C part 1 23 Note Y Yes N No DK Don t Know NA Not Applicable Cat category B biophysical SE socio economic G governance CC Conseration Criteria IA Implementation Activity OP Output OC Outcome CE Conservation Effect B Total score expected Total number of questions 14 number of Not Applicable answers Proportional Yes results Total Yes recorded Total score expected x 100 0 00 Reset Total Responses Notes for reviewer Q 6 this training may have been provided by the management agency but equally may have been provided by government and or other partners Q 10 amp 11 endorsed here means received support only from local communities government but does not necessarily mean adopted yet Q 12 amp 13 adopted here means local communities governments use management plan in their decision making process and consider it in daily activities Figure 19 List
3. Conservation Effect rating is Figure 26 Final Results of Management Level and Conservation Effect Rating 33 Notes 1 This form presents final result of MPA Management Level and Conservation Effect Rating 2 To open this worksheet click MPA Review Result MPA Review Result tab at the bottom of MS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button 3 Do not forget to save your work after you finish with this section In case you did not activate the auto save facility FINAL NOTES We have prepared this MPAME eWorksheet User Manual carefully and we hope it is quite clear so you can use it easily However there is nothing perfect in this world and may there be something incorrect or do not work in this Manual please send your comments critiques and suggestions for future improvement to us Nyoman Suardana Conservation Database Specialist email nsuardana tnc org Arisetiarso Soemodinoto PhD Measures and M amp E Manager email asoemodinoto tnc org We both can also be reached at TheNature Conservancy Protecting nature Preserving life The Nature Conservancy Indonesia Marine Program Jalan Pengembak No 2 Sanur 80228 Bali Indonesia Telephone 62 36
4. MPA Code beforehand this does not mean that you can not fill out the remaining sections You can still work with the MPA Management Effectiveness eWorksheet You can obtain MPA Code later Please note that if you do not have the Code for your MPA the database manager specialist will assign a code later when your work arrive at TNC database in Bali We will let you Know about this too 3 Then you are required to provide information such as MPA Name MPA Size in hectares and the province and the district where the MPA is located To fill out the applicable columns you can just type in the required data and information For example you can type 100000 at MPA Size ha column or type West Papua at Province column 4 Next you should fill out the coordinates of MPA boundary Boundary coordinates degree minute second Point Latitudes e g N 9 41 11 8 Longitudes e g E 123 30 25 4 Degree Minute Second Degree Minute Second 1 a 3 4 a 6 T a g t Please add another row as needed Fill the column with relevant number value Refers to instruction of inputting number see sub section 3 1 3 above for guide If the number of table s row is not enough you can add or insert new row s by referring to instruction described in sub section 3 1 1 above 5 Completing data of the establishment of MPA is the next step Fill out Year of Legal Establishm
5. Size ha Province Dm A Cut 53 Copy dinates degree minute second 16 AL Paste Latitudes e g N 9 41 11 47 Longitudes e g E 123 30 25 4 Paste Special f Degree Minute Second Degree Minute Second Clear Contents Row Height Hide Unhide kd Please add another row as needed Year of legal establishment Figure 2 Adding inserting row to table 3 1 2 Changing the cell height This feature s function is to change the cell height especially when the inputs usually texts exceed cell capacity and much of them become not visible The cell height can be changed by taking steps as follows 1 Put cursor at the number column corresponding to row of the table that will be modified see Figure 3 C District Decree C Others Specify Figure 3 Changing the cell height 2 Move cursor carefully to line at the base of the selected number column and wait a second or so until the cursor changes itself into a form of plus sign with double up and down directions arrows see Figure 4 Then click hold and drag the cursor up and down to change the cell height as required Figure 4 Cursor for changing the cell size 3 1 3 Inputting number e Thousand separator Inputting number over 999 or one thousand or more does not require separator because MS Excel will add it automatically For example to have 10 000 appear in the eWorksheet you just simp
6. are an enforcement group groups in place to enforce MPA regulations i e patrols Enforcement group groups are in place Organizations agencies communities involved are please list Are enforcement activities being undertaken on a Enforcement activities are undertaken regularly regular basis Describe enforcement schedule Have the local judiciary received the necessary Reportdocumentation available outlining training received by judiciary information raining to support them in their role in any prosecution process Are alll information boards boundary markers Maintenance schedule plan is available O and anchor buoys in place and maintained Information regarding compliance requirements and enforcement measures for people within and outside the MPA is available Has the zoning plan of the MPA been endorsed Endorsement from local communities is evident e g correspondence by the local communities indicating support from relevant Village Head Has the zoning plan of the MPA been endorsed Endorsement from government is evident e g letter decree endorsing by the local government management plan forward written in the plan etc Has the management plan of the MPA been Evidence is available to show adoption of MPA management plan by adopted by the local community local community This evidence is in the form of 10 11 12 examples are results of perception monitoring Changes in resource use behavior Etc
7. be filled with position title of a team member in his her organization Connection to MPA should be filled with the relationship between a team member or his her organization and the MPA For example stakeholder MPA managers resident community of MIPA Contact Details shouldbe filled with address telephone number or email of a team member 3 Note if the inputted information is exceeding form s cell height you do not need to adjust it manually because it will be changed automatically to accommodate the inputs 4 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 13 3 2 4 MPA Financial Management This sub section describes the aspect of MPA financial management including the source the annual budget and details of most expenses of MPA C MPA Financial Management Source s of financial support CL Government budget allocation Cl Non Governmental Organization L Others specify Annual budget of MPA usp Annual gross income of MPA uso OOOO Annual operational costs usp What are primary expenses to run the MPA Please thick 1 Salary C 2 Program C 3 Training C 4 Other C 5 Other Fut ongoing fiscal year budget when the review is being carned out Example if the review Is conducted in May 27 2010 then the value of MPA budget is of year 2010 Figure 11 MPA Financial Management screen Instructions 1 To
8. in the Guide eWorksheet stored in the accompanying CD is consisted of two sections i e 1 MPA Management Effectiveness Worksheet with two sub sections of MPA Background Information and MPA Management Scorecard and 2 Scorecard Final Result of MPA Management Effectiveness Review A user after fully understand the concept and steps described in the Guide should be able to calculate scores of Management Level and Conservation Effect Rating using eWorksheet automatically In addition s he also will automatically have a soft copy of a completed Scorecard with relevant data and indicator s that demonstrate management performance of the MPA being studied With an assumption that filling out eWorksheet is conducted correctly the result will at least be more accurate when compared to the result of manual calculation This is simply because all of the calculations are done automatically by MS Excel software In this User Manual instructions will be given on how to fill out and complete the following materials described at length in the Guide A MPA Management Effectiveness Worksheet section 1 Background Information of MPA A MPA Description and Status B MPA Management Effectiveness Review Team C MPA Financial Management D MPA Enforcement E Additional Information section 2 MPA Management Scorecard e Table A e Table B e Table C e Table D e Table E B MPA Management Effectiveness Review Scor
9. the content provides critical functionality and you trust its source More information File Path C DOC MPAMES TOOLS Form MPAME Guide eWorksheet Indonesian xls Help protect me from unknown content recommend Figure 8 Security option dialogue box 5 Before you start to fill out eWorksheet save the file using Save As facility and rename using the recommended standard file naming as follows MPAME underscore lt MPA name gt underscore lt date of exercise gt Example MPAME_Wakatobi_23May09 xls 3 2 2 MPA Description and Status After opening the file at the first page of eWorksheet you will see an outline like the following see the active tab 4 MPA Description and Status at the bottom of MS Excel screen Date of exercise To facilitate easy retrieval in the future it is recommended to save this electronic file under a name that reflects the date of filling out the Scorecard such as MPAME underscore lt MPA name gt underscore lt date of exercise gt For example MPAME_Wakatobi 23May09_xls Section 1 MPA Background Information A Description and Status MPA Code MPA Name MPA Size ha Province District Boundary coordinates deqree minute second Point Latitudes e g N 9 41 11 4 Longitudes e g E 123 30 25 47 Degree Minute Second Degree Minute Second h to M X X Y X 4 JJ D g ca on Pease add another row as needed Year o
10. 1 287272 Facsimile 462 361 270737 34
11. C Patch C Atol C Offshore reefishoal Special features Others please specify Important species e g threatened species In this instance there are say several habitats or ecosystems in MPA where you work They are coral reef mangrove and seagrass bed To indicate these ecosystems are in your MPA just click the relevant boxes You can also add quantitative information about these ecosystems in terms of percentage of total area of each ecosystem relative to MPA total area if any A note for percentage you just need to fill out the number value without the percent sign because MS Excel will automatically assign it You can employ a proxy to give the percentage but the most close number value is highly recommended Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 12 3 2 3 MPA Management Effectiveness Review Team B Management Effectiveness Evaluation Review Team NME O ORGANIZATION POSITION TITLE CONNECTION TO MPA CONTACT DETAILS Figure 10 MPA Management Effectiveness Review Team screen Instructions 1 To open this worksheet click B MPAME Review Team PAME Review Team tab at the bottom of MS Excel screen 2 Fill out the form as required Name should be filled with name of a Review Team member Organization should be filled with name of the organization a team member come from Position Title should
12. Guide for Improving Marine Protected Area Management Effectiveness MPAME in Indonesia eWorksheet User Manual Version 1 0 January 2011 Prepared by Nyoman Suardana amp Arisetiarso Soemodinoto r The Nature G Conservancy Sa Protecting nature Preserving life The Nature Conservancy Indonesia Marine Program Jalan Pengembak No 2 Sanur 80228 Bali Indonesia Telephone 62 361 287272 Facsimile 62 361 270737 Table of Contents BS COFON cree ener eee eee er ene ee eee eee E ee eee ee eee eee 3 Od 6 10 eeneneneteee eter ie enennetene eee A ee ee eee 4 2 General Review of eWorksheet sspcecatycscs2 co seceecedetpeeseccsdancseteagadtdetncesctee dsnscetaseectce cate sadzoedatsessesccedeoenstaecdelviclec 4 3 APUNTO O NOS CE eE E E 5 3 1 General Instruction ce csessesessssssessesesessesesessesessesescssesesssesessssesesssestsussesesussesssueseacssesescsessescsessesnsestsceseaeeess 5 3 1 1 Adding inserting rOW S tO table esssesesesessessssssssssessssssesssesssessesesesesesssescsssesseecsesesesseseess 5 3 1 2 Changing the cell heigl eisses enee ela eee ee ar error aE 6 3 1 3 dayo tiedn Ewann r tert E E E T A E TA 6 3 1 4 SAVING CWOrKSNEEL cccccesscsesessesesssscsessesesessssesessesesessesesesesessesescssesesessesesessesssesseseseesesessesesesseseees 7 3 2 Special Instructions to Fill Out CWorksheet ee eessesesessesessssesessesesessesesessesssessessseeseseseessseseeseees 8 3 2 1 FUT Al VO Me pe
13. ation Activity OP Output OC Outcome CE Conservation Effect a Total score expected Total number of questions 14 number of Not Applicable answers Total Ranaponnes Proportional Yes results Total Yes recorded Total score expected x 100 Notes for reviewer Q 3 for example an easy to read board is constructed in easy to reach places rules amp regulations in forms of book brochure etc are easily accessible by all MN Q 4 i possible biophysical aspects to be monitored may include for example reef health fish spawning aggregations FSAs focal species abundance trophic structure fish diversity abundance size mangrove abundance water quality coral bleaching disease benthic habitat composition rugosity coral recruitment algae Cover cetacean observations turtle nesting activities etc Q 4 ii The four or less priority biophysical aspects being monitored are the four areas that are considered most important to the MPAs integrity Here the reviewer is asked to identify maximum four priorities of the management agency for example reef health FSAs turtle nesting activities and mangrove community structure Q 5 possible social aspects to be monitored may include for example community perceptions resource use patterns alternative livelihoods socio economic trends Social impact assessment educational attainment trends etc Q 9 amp 10 endors
14. doption of MPA zoning plan by local local government community This evidence is in the form of examples are results of perception monitoring Changes in resource use behavior Etc OC ls the designated enforcement system fully The most common breaches of compliance are operational functioning list in order 1 most common cause to 5 least common cause Fishers using legal gears in legal areas but without the correct permits Fishers with legal but destructive fishing gears that are not permitted in the MPA Tea fishers exploiting traditional use areas zones a the MPA en ca active inside the No Take Zones Areas O orcs Oo p using nationally recognized illegal gears i e ai cyanide etc Are No Take Zones Areas NTZ ASs included in the Soole Reports of patrolling activity are available patrolling OC Does monitoring show that local stakeholders are Monitoring Report is available showing percentage of local aware that extractive practices are prohibited in stakeholders aware that extractive practices are prohibited in the NTZ A Percentage is NTZ As Livelihood analysis is available mn the MPA than prior to the MPAs establishment 8 OC Have the results of biophysical monitoring analysis developed recommendations for improving management governance planning and associated 7 OC Does monitoring show that local communities are now less dependent on extracting resources within Documen
15. e tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button Give your response to every question by clicking either Yes No Do Not Know or Not Applicable at the associated circle Then fill out linked sections in Indicators and Data Collation column with appropriate MPA situation and or the availability of supporting data information For Question 9 fill out the table with goal s target s listed in MPA Management Plan and the achievement s observed at the time when the exercise is being done For Question 10 state threats to MPA and percentage of abatement that has been achieved at the time when the exercise is being done Result and Score for Table E will be calculated automatically by MS Excel software Calculation of Conservation Effect is carried out automatically as well Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 30 3 2 12 Scorecard Final Result Calculating the Management Level Total Dont Total Not Proportional Yes results Results Table Total Yes Total Noa Knox Applicable Total Yes recorded Recorded Recorded are __ Total score expected Recorded Recorded NAs x 100 TABLE A Level 1 o o 0 0 0 0 0 00 TABLE B Level 2 o
16. ecard Final Result 3 inputting Data to eWorksheet 3 1 General Instruction This section explains several general instructions to fill out every part of eWorksheet Each instruction has its own function as follows 3 1 1 Adding inserting row s to table The function of this feature is to add or insert row s to a table when their number is not sufficient to accommodate the data being inputted Not all table in eWorksheet can be altered for this purpose and one example of adjustable tables is the Boundary Coordinates table The following are steps to add or insert row s in a modifiable table 1 Put cursor at the number column located at the most left side column of MS Excel screen corresponding to last row of the table that will be modified in this case table of Boundary Coordinates see Figure 1 and then right click to call Pop Up Menu to appear see Figure Boundary coordinates degree minute second Point Latitudes e g N 9 41 11 4 Longitudes e g E 123 30 25 4 Degree Minute Second Degree Minute Second 1 2 3 4 5 6 7 8 Please add another row a Year of legal establishment Figure 1 Selecting row s number 2 After Pop Up Menu appear See Figure 2 select Insert Then an additional row will be added inserted automatically Repeat the steps as needed Section 1 MPA Background Information A Description and Status MPA Name MPA
17. ed interventions For Question 10 state the level of reduction of illegal and destructive practices within the MIPA since its establishment and the dates For example reduced from 75 levels in 2008 to 55 levels in 2010 For Questions 11 to 14 state four priority biophysical being monitored refer to the list of four biophysical components stated in Question 4 of Table B and their condition when the exercise is being carried out In Indicators and Data Collation column list the title date of publication and storage location of monitoring report of respective biophysical component Result and Score for Table D will be calculated automatically by MS Excel software Calculation of Conservation Effect is carried out automatically as well Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 28 3 2 11 List of Questions of Table E Question Table E OF Question Table E C Response Indicators amp Data Collation OY N DK NA 1 IA Has the MPA management plan been Review is available Where relevant sequential management plan is regularly reviewed and where relevant available and or addendum to plan to show refinement over time updated and refined for adaptive management 2 G IA Have expansion strategies or programs to Networking plan proposal available support connectivity with neighboring MPAs and or networking in the reg
18. ed here means received support only from local communities government but does not necessarily mean adopted yet Q 11 if required please give more information in Section 1 sub section E regarding your MPA zoning Figure 17 List of Questions of Table B part 2 21 Instructions 1 10 11 12 13 14 To open this worksheet click Questions Table B Questions Tabe B8 tab at the bottom of MIS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button Give your response to every question by clicking either Yes No Do Not Know or Not Applicable at the associated circle Then fill out linked sections in Indicators and Data Collation column with appropriate MPA situation and or the availability of supporting data information For Question 3 list places locations where MPA rules amp regulations been posted within and adjacent to MPA area For Question 4 list biophysical components being monitored and their monitoring interval List four or less priority biophysical components that are being monitored For Question 5 list socio economic components being monitored and their monitoring interval If the number of rows is not sufficient you can add or insert m
19. eee see seceecsc esac seen exsescecen eee ces eecey en sce docs seeeses teecicacecoees ce comes desscscenat5seecsuscunceese eee cents sees 8 3 2 2 IN Re PPA SU MOEN NN ENG Sta lUS eesse EErEE EEEE ERSE EEEE EEEE 10 3 2 3 MPA Management Effectiveness Review eam csssseesssesssesessssesssesesestseseessesteneen 13 3 2 4 MIPA FHnancial WiaAMNAGCINGMIN sicie esisiini eeaeee 14 3 2 5 VIPAT VOD CCUM IN zee etesccnccsee says ex cpcenst a E E ES 15 3 2 6 Additional TET ORIV AU ON sssr seene eE eSa eA SEERE 16 3 2 7 LISCO Questions or Table Asssrsrrssiense ieceeeeceeeeeecte eee metees 17 3 2 8 List of Questions of Table Baw essessssssssessssesessesssessessssssesessesesssessescsnssesessesesessesesessessseeseass 20 3 2 9 Li stof QUESTIONS of Table C sescscccsccescdcescecesesssoceathcdsesteedencdeccsexcostnsscessthaidccasedeseesszocennetoetneaoteoavert 23 3210 LIStOP uesuons ol Table Dsrrericrn EE E 26 3 2 11 LSO Questions or Table Eses e nee eerste err enn ern 29 3 2 12 Scorecard Final Result ues sssssesessssesessssesessesesessesesessesesesscseseeseseseesesessesesessesesesessssesescseeseass 31 3 2 13 Results Management Level and Conservation Effect Rating csceseseeseseeseees 33 List of Figure Figure W296 1 CHG TOW sS TILING itaccatcccsesteasacsetteecscetey aesnsbeqssse Gee R E RETE anne 5 Figure 2 Adding inserting row to table ssssssssssssseeeeeeressssssssssssssseerererressssssssssseeeerrereeeeessssssssseserene 6 Figu
20. ent and Basis for Legal Establishment on the related column 11 Year of legal establishment Basis for legal establishment C Ministerial Decree Provincial Decree District Decree C Others Specify For example if Ministerial decree is the basis of MPA establishment then click the box before Ministerial Decree and type the decree in detail at the associated column for example Minister of Marine Affairs amp Fisheries Decree Number 1 Year 2010 on the Establishment of Manokwari Coastal MPA When more than one decree basing the establishment of an MIPA for instance there is a Bupati decree of designation reservation and a Minister decree of declaration then click relevant boxes and type the decrees in detail at the associated columns For decrees published by officials such as Director General or a level below or by Village Head of Village or by Community Group you can use Others option and followed by typing in detail the decree at the associated column On the next sections you are asked to select one or more variables or aspects of MPA Similarly you will select them by clicking on relevant boxes Habitatlecosystem s within the MPA Percentage Percentage Mangrove Rocky intertidal Estuary detta Sandy bottom Coral reef Soft bottom Seagrass bed Open water Macro algal bed Deep sea C Other specify Type of coral reef Fringing Barrier Pinnacle rock seamount Lagoonal
21. f legal establishment Basis for legal establishment L Ministerial Decree L Prowincial Decree L District Decree C Others Specify Habitatecosystem s within the MPA Percentage Percentage C Mangrove L Rocky intertidal C Estuary detta C Sandy bottom C Coral reef C Soft bottom C Seagrass bed C Open water C Macro algal bed C Deep sea C Other specify Type of coral reef C Fringing C Barrier C Pinnacle rock seamount C Lagoonal C Patch Atol C Offshore reefishoal Special features LJ Historicalcutturalsacred site s please specify Others please specify Important species e g threatened species Figure 9 MPA Description and Status screen 10 Instructions 1 Fill out the Date of Exercise column with the date when the review is was carried out The file should then be saved using the recommended standard file naming such as MPAME underscore lt MPA name gt underscore lt date of exercise gt See point 5 sub section 3 2 1 above for the detail A Description and Status 2 Write MPA Code at the applicable column If you have not yet had the Code for your MPA you can obtain it from MPAME database manager specialist at The Nature Conservancy Indonesia Marine Program by writing email to Nyoman Suardana nsuardana tnc org and Arisetiarso Soemodinoto asoemodinoto tnc org or via telephone 62 361 287272 or facsimile 462 361 270737 While it is recommended to have
22. g used as the basis for MPA official delaration Result and Score for Table B will be calculated automatically by MS Excel software Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 22 3 2 9 List of Questions of Table C Question Table C Q Question Table C Indicators amp Data Collation Y N DK NA Is the management body actively implementing Annual report making reference to overarching management plan goals following the management plan and targets is available a gt Have avenues for sustainable financing for the Some form of sustainable financing options analysis is available i e MPA been explored options paper feasibility analysis etc gt Is there a mechanisms for local communities to Document the mechanism used raise concerns if relevant with the management body gt Have the results of the regular biophysical Monitoring reports showing appropriate analysis are available monitoring measuring components as described in Table B Q 4 been appropriately analyzed in order to extract observational trends in condition on m D D D wo D gt Have the results of the socially related Monitoring reports showing appropriate analysis are available monitoring measuring components as described in Table B Q 5 been appropriately analyzed in order to extract observational changes over time Is
23. ing scheme for the MPA is started 5 For Question 2 state evidences that MPA Zoning Plan has been adopted by local communities use examples provided as guide 6 For Question 3 state evidences that MPA Zoning Plan has been adopted by local government use examples provided as guide 7 For Question 4 fill the grey colored column with number corresponding to relevant type of breach 27 10 11 12 13 14 15 The most common breaches of compliance are dist in order 7 most common cause fo 5 least common cause Fishers using legal gears in legal areas but without the correct permits Fishers with legal but destructive fishing gears that are not permitted in the MPA Outside fishers exploiting traditional use areas zones within the MPA Fishers active inside the No Take Zones Areas NT ZIAS Fishers using nationally recognized illegal gears i e dynamite cyanide etc Figure 22 Answer options of Table D Question 4 For Question 6 write down the percentage of local stakeholders which aware that extractive practices are prohibited in No Take Zones Areas For Question 8 list examples of biophysical monitoring analysis that are used for making recommendations to improve management governance planning and associated interventions For Question 9 list examples of socio economic monitoring analysis that are used for making recommendations to improve management governance planning and associat
24. ion been initiated 3 E Are gt 80 of all staff in the management body Staff appraisals and post training progress reportmonitoring review did fully trained to meet their required Hada results are available proficiencies and tasks 4 G OC ls the MFA zoning plan fully integrated with the Report or official decree is available Wa various government agency spatial planning M processes 5 SE OC Do studies show thatthe development and Report or livelihoods analysis is available maintenance ofthe MPAis an integral part of local economic development 6 Is local government committed to ensuring a POS Or O Report or official decree is available sustainable future for the MPA T OC Has analysis been undertaken to determine Ecosystem services analysis available the extent and impact of ecosystem services the MPA is effectively conserving enabling 8 G Oc ls a sustainable financing plan being Financial report available implemented that covers more than 80 of the annual operational costs 9 CE Are the goal s and target s identified in the management plan achieving 80 of the planned results according to monitoring or survey results 10 G CE Have the identified threats to the MPA been abated significantly 80 reduced no a 11 G CE re illegal and destructive activities reduced Reportis available showing results of monitoring and evidence of W halted within the MPA ial ia K ba reduction halting of illegal and destructive practice
25. ise To facilitate easy retrieval in the future it is recommended to save this electronic file under a name that reflects the date of filling out the Scorecard such as MPAME underscore lt MPA name gt underscore lt date of exercise gt For example MPAME_Wakatobi_23May09_xls Section 1 MPA Background Information A Description and Status MPA Code MPA Name MPA Size ha Province District Boundary coordinates degree minute second Point Latitudes e g N 9 41 11 4 Longitudes e g E 123 30 25 4 Degree Minute Second Degree Minute Second M lt gt gt A MPA Description and Status B MPAME Review Team C MPA Financial Management D MPA Enforcement Ready Figure 7 Security Warning that Macros has not yet activated 4 After the dialogue box Security Warning Macro appears select Enable this content and then click OK see Figure 8 The eWorksheet is now ready for you to work with Please note that you must do this step every time you open the file to repeat working with eWorksheet Microsoft Office Security Options Security Alert Macro Macro Macros have been disabled Macros might contain viruses or other security hazards Do not enable this content unless you trust the source of this file Warning It is not possible to determine that this content came from a trustworthy source You should leave this content disabled unless
26. l MS Excel based software to accommodate easy and automated calculation of Management Level and Conservation Effect Rating More importantly the software will also help us on standardizing typical governance biophysical and socio economic aspects being reviewed in each MIPA studied This in turn will facilitate us to compare all MPAs that have been reported and stored in MPAME database The result will be really helpful when we want to map spatial distribution of MPAs throughout Indonesia based on their management effectiveness along with their temporal progress if any and to prioritize activities to improve management performance and or to build management capacity to anticipate pressures and threats facing by each MPA The objective of this User Manual is to provide detailed steps to assist users in filling out and completing sections of electronic worksheet eWorksheet for reviewing MIPA Management Effectiveness which the hard copy is available at the Appendix of MPAME Guide book Minimum Requirements Below are minimum requirements to utilize the software properly User e Should be familiar with Microsoft Windows based softwares particularly Microsoft Excel version 2003 System e Computer with Pentium 4 processor or above e 1 GB RAM e A minimum 100 MB space on your computer hard disk after installation the program requires approximately 6 MB space 2 General Review of eWorksheet Similar to those described
27. ly type 10000 e Decimal value Decimal value can be obtained by inserting a point right before they appear For example to have a figure of 1 678 65 then you should type 1678 65 3 1 4 Saving eWorksheet For safety and convenience it is recommended to save eWorksheet regularly This is to avoid the review results from being lost because the computer for instance crash or hang Steps for saving eWorksheet are as follows 1 Press Windows button at the top left corner of MS Excel screen then select and click Save see Figure 5 Or alternatively you can save your work anytime by pressing both Ctrl and S button on the keyboard simultaneously Figure 5 Options for MS Excel document management 2 If you work using MS Excel version 2007 for completing eWorksheet a Compatible Checker dialogue box will appear on your screen when you try to save your work See Figure 6 Ignore this dialogue box and save your document by pressing Continue button Microsoft Office Excel Compatibility Checker The following features in this workbook are not supported by earlier versions of Excel These features may be lost or degraded when you save this workbook in an earlier file format Click Continue to save the workbook anyway To keep all of your features dick Cancel and then save the file in one of the new file formats Summary Number of occurrences Significant loss of functionality Some cells have more conditi
28. nformation E Additional Information tab at the bottom of MS Excel screen 2 You can do it simply by typing the information you have in the grey box as required 3 To start a new line or paragraph press ALT Enter keys Press lt Backspace button to return to previous line paragraph 4 If the inputted texts are exceeding column size you can modify the column s cell height by referring to sub section 3 1 2 above 5 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 16 3 2 7 List of Questions of Table A Section 2 MPA Management Scorecard Response N O Q Cat Question Table A Indicators amp Data Collation b Was the MPA site selected based on biophysical criteria A baseline survey report is available Title amp Date Location Name the method s followed for biophysical surveying identified through baseline assessment N m gt Was the MPA site selected based on socio economic criteria identified through baseline assessment A baseline survey reportis available Title amp Date Location Name the method s followed for socioeconomic surveying Were site surveys and or baseline assessments conducted in a collaborative way with relevant parties stakeholders Documented details of the stakeholders that participated in the surveys assessmentis available Location gt oO m g
29. o 0 0 0 0 0 00 TABLE C Level 3 ee 0 0 0 0 00 TABLE D Level 4 o oo o 0 0 0 00 TABLE E Level 5 PE 0o 0 0 0 00 100 00 90 00 60 00 50 00 40 00 30 00 20 00 10 00 0 00 TABLE A TABLE B TABLE C TABLE D TABLE E Level 1 Level 2 Level 3 Level 4 Level 5 Calculating the Conservation Effect Please copy your final results from Tables D and E into the below table Total CE Total Yes Total No Total Don t Total Not Applicable questions in Recorded Recorded Know Recorded Table Recorded TABLE D 5 0 0 ee ee TABLE E 6 amp 6 0 o o 0 _ Total Number of Expected Results Number of possible CE questions 11 minus number of Not Applicable answers 11 0 11 CE rating calculation Number of Total Yes answer Total Number of Expected Results above x 100 0 11 X 100 0 Figure 25 Calculation of Scorecard Final Result Notes 1 This final result will be calculated automatically by MS Excel software The result is obtained with assumption that user s understand fully the concept and has have made informed selection of answering options derived from appropriate MPA situation and or the availability of supporting data information 31 2 To open this worksheet click Scorecard Final Result lt Scorecard Final Result tab at the bottom of MS Excel screen If the tab title is not appear properly or the tab i
30. o destructive fishing by 20xx yr State the decree title and date of publication Note Y Yes N No DK Don t Know NA Not Applicable Cat category B biophysical SE socio economic G governance CC Conseration Criteria IA Implementation Activity OP Output OC Outcome CE Conservation Effect Result Total score expected Total number of questions 14 number of Not Applicable answers For example lf there were 3 answers that were NA the total expected score for List A would be 14 3 11 Proportional Yes results Total Yes recorded Total score expected x 100 For example If the Total Yes recorded were 6 and the total score expected was 11 then the proportional results would be 6 11 x 100 54 5 Total Responses Reset Notes for reviewer Q 6 have there been efforts to gain the support of local peoples or stakeholder s through e g capacity building alternative livelihoods outreach and are these activities ongoing At this level the question is gauging whether efforts have been made to get affirmative support from local communities At later stages in the scorecard this affirmative support can be measures in a variety of ways including census statements perception monitoring and or studies polls of public opinion 1 SMART Specific Measureable Attainable Results oriented amp Time bound Figure 15 List of Questions of Table A part 2 Instruc
31. of Questions of Table C part 2 Instructions 1 10 11 12 To open this worksheet click Questions Table C Questons Tablec _ tab at the bottom of MIS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button Give your response to every question by clicking either Yes No Do Not Know or Not Applicable at the associated circle Then fill out linked sections in Indicators and Data Collation column with appropriate MPA situation and or the availability of supporting data information For Question 3 state mechanisms to raise local communities concerns to MPA management body For Question 6 state each name of the groups for MPA enforcement if the have been formed For Question 7 list the schedule of MPA enforcement activities i e surveillance patrolling monitoring etc For Question 9 click the relevant box if maintenance plan schedule is available and if information regarding compliance requirements and enforcement measures for local people within and outside the MPA is available For Question 10 list evidences that MPA Zoning Plan has been endorsed accepted by local communities for example evidences outlined in the examples provided For Question 11 li
32. onal formats than are supported by the selected file format Only the first three conditions will be displayed in earlier versions of Excel Location Hasil Tinjauan KKL Conditional Formatting Some cells have overlapping conditional formatting ranges Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells The overlapping cells will show different conditional formattina Check compatibility wh Figure 6 Compatibility Checker dialogue box 3 If you use MS Excel version 2003 step number 2 above will not appear lips to ensure that the inputted data are not lost because you forget to save or because other causes such as power failure it is highly recommended to activate auto save facility of the MS Excel software With this facility on you can save your work automatically every say 15 or 30 minutes and avoid unnecessary annoying data lost To activate the auto save facility please consult MS Excel User Manual or MS Excel Help facility by pressing F1 button 3 2 Special Instructions to Fill Out eWorksheet This section describes in detail how to fill out every part of MPA Management Effectiveness worksheet 3 2 1 Preparation Prior to fill out MPA Management Effectiveness worksheet you need to make preparation They are 1 Copy eWorksheet from the accompanying CD or download it directly from MPAMES website http mpames coraltrianglecenter org to your deskt
33. oned dismis Figure 12 MPA Enforcement screen Instructions 1 To open this worksheet click D MPA Enforcement MPA Enforcement tab at the bottom of MIS Excel screen 2 List law s and regulation s that are referred to enforce MPA rules amp regulations Use coma C to separate multiple law s and regulation s 3 On Apprehensions Recorded table list the nature of violation the date and final outcome of each apprehension 4 If the number of rows is not sufficient you can add or insert more row s by referring to sub section 3 1 1 above 5 If the inputted texts are exceeding column size you can modify the column s cell height by referring to sub section 3 1 2 above 6 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 15 3 2 6 Additional Information In this sub section you can provide additional relevant information regarding the MPA that is not captured via the MPA Management Effectiveness Scorecard E Additional Information After completing the next section the scorecard if you have additional relevant information regarding your MPA that you feel appropriate to capture in this evaluation please elaborate in the box below Note Press ALT Enter to move to next line Figure 13 Additional Information of MPA screen Instructions 1 To open this worksheet click E Additional I
34. op laptop computer We named the file MPAME Guide eWorksheet_EngVerJan11 xls The copy is usually saved in a folder of your working directory in the hard disk C For easy access later it is recommended to create a short cut and put it on your Desktop screen 2 After copying and saving eWorksheet file on your desktop laptop computer open the file by putting the cursor at the file name and double clicking on it 3 When the program is opened a Security Warning stating that the Macros has not yet been activated Macros have been disabled will appear on your screen See Figure 7 You need to activate Macros to enable the software working properly To activate Macros click the Option button as appeared in Figure 7 Ca ae 9 D F MPAME Guide eWorksheet_EngVerJan11 xls Compatibility Mode Microsoft Excel E ER y Home Insert Page Layout Formulas Data Review View Add Ins a x sf en i ar mmm 4 K E LA Show Hide Comment HR a X Protect and Share Workbook VOU QV Wy Show All Comments g Allow Users to Edit Ranges Spelling Research Thesaurus Translate New Delete Previous Next Protect Protect Share as ke 3E Comment gt Show Ink Sheet Workbook Workbook E Track Changes Proofing Comments U 7 Wt 7 JL Changes F z Security Warning Macros have been disabled Options v A E me en ee nT eee Teen Sy p K Date of exerc
35. open this worksheet click C MPA Financial Management lt 4 Financial Management tab at the bottom of MS Excel screen 2 Indicate Source s of Financial Support by clicking relevant box es You can select more than one when they are coming from multiple sources For Others source of funding you must type the detail in the associated column 3 Then you can fill out the column of Annual Budget of MPA Annual Gross Income of MPA and Annual Operational Costs Refers to instruction of inputting number see sub section 3 1 3 above to guide you filling out these columns 4 Next you can select primary expenses to run the MPA by clicking relevant box es For Other options you can first type the activity before clicking at the associated box 5 If the inputted data information is exceeding column size you can modify the column s cell height by referring to sub section 3 1 2 above 6 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 14 3 2 5 MPA Enforcement In this sub section we will deal with law s and regulation s for the basis of MPA Enforcement and to list apprehensions that have occurred within the MPA and how they are were handled D MPA Enforcement Enforced laws regulations and rules for managing the MPA Apprehensions recorded Final outcome Nature of violation Date committed e g fined impris
36. ore row s by referring to sub section 3 1 1 above For Question 6 write down total annual budget to manage MPA Refers to the one that has been listed in C MPA Financial Management above Next fill out columns of sources of funding amount and duration of funding of the table If the number of rows is not sufficient you can add or insert more row s by referring to sub section 3 1 1 above For Question 7 state the starting and ending years of MPA management plan document Also state in detail the title of the document and its storage location For Question 11 type the title of MPA zoning plan document report and the location where it is being stored State regulations being referred to for making MPA zoning plan Then list names of zones being planned on the table their number and total area for each zone If the number of rows is not sufficient you can add or insert more row s by referring to sub section 3 1 1 above Finally select one answer regarding spatial data of each zone and the location where they are being stored For Question 12 state title purpose and GPS location of buoys being installed within MPA area If the number of rows is not sufficient you can add or insert more row s by referring to sub section 3 1 1 above For Question 13 state infrastructure and facilites that have been developed to support management of MPA For Question 14 state title and publication year of decree that is bein
37. re 3 Changing the Cell NeIQGNt cccceecsssssssccececessssssseeeeeeeesssessnsseeeeesesseesaeeeeeeeessesesnaeeeeeeesees 6 Figure 4 Cursor for Changing the Cell SIZC cccccccccccessssssseceececessessneeeeeeeceseesseeeeeeeessessensaeeeeeeesses 6 Figure 5 Options for MS Excel document MANAGEMENL cccccesesssssseeececessesssseeeeecessesssstaeeeeeeeeess 7 Figure 6 Compatibility Checker dialogue DOX ccccccccessssssssececeeessssnneeeeeceeesesssneseeeeeesssessnaeeeeeeeeses 7 Figure 7 Security Warning that Macros has not yet activated c cccccccccsssssssseceeeeeessssssseeeeeeeeeess 8 FIGUIE 8 Security OPTION dialogue DOX soicssccscessseeseccasnsscsssudenecuvsntewssandeeeacensasessaudererncsinesvssandeveddentesessevies 9 Figure 9 MPA Description And Status SCrEEN cccccccesssssssececccessssssseeeeeeecesssssnaeeeeeeeesessesaeeeeeeeees 10 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 MPA Management Effectiveness Review Team screen ccssscsscccccscceceeeeesssesssessnnnaees 13 MPA Financial Management SCIEN cccccsccccccccccceeesssssesssssnnnseseeeeeeeeceeeeeessseesseeesnaaaaas 14 MPA Enforcement SOC OMe aceancacctan nantes E ENR EAE 15 Additional Information of MPA SCIreeN ccccccsseeessssssnncceeeeeeeeecececee
38. rvation Effect B v es Total score expected Total number of questions 14 number of Not Applicable Total Responses EE Proportional Yes results Total Yes recorded Total score expected x 100 Q 2 amp 3 adopted here means local communities governments use the zoning plan in their decision making process and consider it in daily activities Notes for reviewer Q 11 12 13 amp 14 these four priorities are as identified in the question 4 in List B as critical biophysical components to ensure the MPAs integrity Conservation Effect calculation Total CE questions in Table fa Figure 21 List of Questions of Table D part 2 Instructions 1 To open this worksheet click Questions Table D Questions Table 0 tab at the bottom of MS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button 2 Give your response to every question by clicking either Yes No Do Not Know or Not Applicable at the associated circle 3 Then fill out linked sections in Indicators and Data Collation column with appropriate MPA situation and or the availability of supporting data information 4 For Question 1 state the year when sustainable financ
39. s 42 CE Are extractive practices effectively stopped o olo o Resource use reportis in place showing effective halting of extractive within the MPAs no take zone area practices in NTZ A CE ls the judiciary able and efficient in dealing Testimonial evidence available showing efficient and able with the prosecution process regarding MPA prosecution responses enfractions 14 Sl CE Are education and outreach programs Clear plan for long term education and outreach available planned and ongoing with sustainable support within the MPA Note Y Yes N No DK Don t Know NA Not Applicable Cat category B biophysical SE socio economic G governance CC Conservation Criteria IA Implementation Activity OP Output OC Outcome CE Conservation Effect Figure 23 List of Questions of Table E part 1 29 Result Total score expected Total number of questions 14 number of Not Applicable answers Total Responses z EA P Proportional Yes results Total Yes om recorded Total score expected x 100 0 00 Reset Conservation Effect calculation Not Total CE questions in Table Yes Appli cable 6 ERE SE SES Figure 24 List of Questions of Table E part 2 Instructions 1 To open this worksheet click Questions Table E Questions TableE lt tab at the bottom of MIS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respectiv
40. s not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button 3 Do not forget to save your work after you finish with this section In case you did not activate the auto save facility 32 3 2 13 Results Management Level and Conservation Effect Rating RESULTS Based on the above calculations your MPA Management Level is This means that your MPA is Level LEVEL 1 LEVEL 2 LEVEL 3 LEVEL 4 LEVEL 5 Initiated O O O OOOO OOOO O O O Established SS Enforced O OO O O O Sustainable O O O O OOOO O OOOO O Institutionalized Fully Functional Based on the above calculations your MPA Conservation Effect meets which rating please tick as relevant in the below box Rating 1 Conservation Effects have yet to be measured or observed or are observed in less than a quarter potential effect areas Conservation Effects have been measured or observed in more than a quarter gt 25 but less than a half lt 50 of the recognized potential effect areas Conservation Effects have been recognized in more than half gt 50 but less than three quarters lt 5 of the recognized potential effect areas Conservation Effects have been recognized in more than three quarters gt 75 of the recognized potential effect areas This means that your
41. s production of MPA management plan Minutes of meetings reports of collaborative processes available been conducted in collaboration with all key stakeholders G Has the management plan been endorsed Endorsement from local communities is evident e g correspondence by local communities indicating support from relevant village head 10 G Has the management plan been endorsed Endorsement from government is evident e g letter decree endorsing by local government management plan forward written in the plan etc Figure 16 List of Questions of Table B part 1 20 11 G OP Does the MPA have a zoning plan either as Zoning plan is available a component of the MPA management plan oO O O O Title amp or produced seperately Date Location Zoning is based on law s please list Zoning plan includes the following zones Which ofthe above listed zones are fully protected i e No Take Zones GIS Spatial data is available for all of the zones If d Yes spatial data is store Location Number installed amp Purpose add more rows if needed 13 Has infrastructure been established to Document all infrastructure developed support operations i e ranger station field station field offices etc 14 7 State the decree title and date of publication Note Y Yes N No DK Don t Know NA Not Applicable Cat category B biophysical SE socio economic G governance CC Conservation Criteria IA Implement
42. seseessssnsnaaeaeeeeseeeees 16 List of Questions of Table A part 1 ooo ecccccsssccccecessssssseeeeeeeessssssnseeeeeeeesssessnaeeeeeeenns 17 List of Questions of Table A part 2 00 0 ccccccsssccccccesssssssseeeeeceeesssesnseeeeeeeseseessnaeeeeeeeeeses 18 LISt OF QUESTIONS OF Table B parn 1 scckeicsccincecosacnedstrciudesonasiccssesdudecsoactictabesdubesosasserneesdusen 20 LIST OF QUESTIONS OF Table B pan Z sacceicsccdudscosastedstoedudesossseenteedusesoastedatesiubesosesseentadusean 21 EISLOF Q estions OF Table C parl Tsrsmcnnsee e 23 LISt OF QUESTIONS of Table C parl 2 arnser EE O 24 Listof QUESTIONS OF Table D part Lermccennninia E 26 List of Questions of Table D parl 2 0 0 0 ccccccceesssssssseceeeeeessssssseeeeeeeessesssnaeeeeesenens 27 Answer options of Table D QUESTION 4 c cccccccscssssseceeeeecesesssnseeeeeeessesssnaaeeeeeeeesessaaes 28 List of Questions of Table E part 1 iscccscsccectaveusonettannesgerneevsnntasevcdavsusonchtasneceervenssenteceesdeabe 29 Listo Questions OF Table E part Zsarnai 30 Calculation of Scorecard Final R Sult ccccccsssssscccceessssssseeeeeeeessesssnseeeeeesesssessaeeeees 31 Final Results of Management Level and Conservation Effect Rating cccccceeeee 33 1 Introduction This Guide for Improving Marine Protected Area Management Effectiveness MIPAME in Indonesia was purposefully designed to be user friendly It is accompanied with a Microsoft Exce
43. st evidences that MPA Zoning Plan has been endorsed accepted by local government for example evidences outlined in the examples provided For Question 12 state evidences that MPA Management Plan has been adopted by local communities For Question 13 state evidences that MPA Management Plan has been adopted by local government For Question 14 list research project and education activities that have been carried out in MIPA 24 13 If the inputted texts are exceeding column size you can modify the column s cell height by referring to sub section 3 1 2 above 14 Result and Score for Table C will be calculated automatically by MS Excel software 15 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 25 3 2 10 List of Questions of Table D Question Table D 2 Response s i Q Question Table D Indicators amp Data Collation Y N DK NA 4 G Does the MPA have a sustainable financing plan Sustainable financing plan is available Sustainable financing for the MPA will be secured by OC Has the zoning plan of the MPA been adopted by the Evidence is available to show adoption of MPA zoning plan by local local community community This evidence is in the form of examples are results of perception monitoring Changes in resource use behavior Etc OC Has the zoning plan of the MPA been adopted by the Evidence is available to show a
44. t gt Has a baseline survey on MPA associated livelihoods among local communities been completed A livelihoods survey report or similar document is available Title amp Date Postion If asked local communities and local government groups would be able to verify a conceptual understanding of an MPA or has an evaluation or assessment been completed gt Has the concept of an MPA been introduced to local communities and government gt Has a situation analysis to identify conflicts if any with local people or stakeholders been completed AReportis available Title amp Date Location Has an education program to raise awareness about MPA functions and benefits started List what key activities have been undertaken to raise awareness about MPA functions amp benefits 4 2 3 4 5 8 SE IA Have there been efforts to gain the support of local Document here what key activities have been carried out to gain the peoples or stakeholder s through e g capacity building support of local peoples and stakeholder s alternative livelihoods outreach and are these activities ongoing 1 2 3 4 5 o h gt Have public consultations been conducted Minutes of meetings are available Location Has a management body been established A management body has been established in the form of tick where relevant National unit i e Taman Nasional National unit i e Reserve
45. t examples where the results of monitoring have been used for adaptive management interventions 9 OC Have the results of socially related monitoring analysis developed recommendations for improving management governance planning and associated interventions for adaptive management Surveying shows illegal and destructive practices are 10 CE Have the incidence of illegal and destructive fishing practices reduced within the MPA since its reduced from levels in year levels in year Since the MPAs establishment are the priority biophysical components stable and or improved in condition CE Biophysical priority 1 condition is stable and or improved CE Biophysical priority 2 condition is stable and or improved Figure 20 List of Questions of Table D part 1 f Document examples where the results of monitoring have been used 26 13 B CE Biophysical priority 3 Monitoring report s available Title condition is stable and or condition is stable and or improved ee Location CE Biophysical priority 4 iain in riority 4 Monitoring report s available Title condition is stable and or improved is stable and or condition is stable and or improved Location Note Y Yes N No DK Dont Know NA Not Applicable Cat category B biophysical SE socio economic G governance CC Conservation Criteria IA Implementation Activity OP Output OC Outcome CE Conse
46. tions 1 To open this worksheet click Questions Table A Questions Table A tab at the bottom of MIS Excel screen If the tab title is not appear properly or the tab is not visible you can move to the respective tab by clicking the forward button situated on the left hand bottom corner of MS Excel screen You can return to previous tab anytime by clicking the backward lt 4 button 2 Give your response to every question by clicking either Yes No Do Not Know or Not Applicable at the associated circle 3 Then fill out linked sections in Indicators and Data Collation column with appropriate MPA situation and or the availability of supporting data information Questions about report title and report date should be answered accordingly So too for the location where the report can be found and the method s employed to collect data and information 5 For Question 10 select one form of MPA management body by clicking relevant option 18 6 If the inputted texts are exceeding column size you can modify the column s cell height by referring to sub section 3 1 2 above 7 Result and Score for Table A will be calculated automatically by MS Excel software 8 Note do not forget to save your work after you finish with this section In case you did not activate the auto save facility 19 3 2 8 List of Questions of Table B Question Table B Question Table B YT N T ok TNA Indica
47. tors amp Data Collation 1 G IA Were are local communities involved in MPA Minutes of meetings reports of collaborative planning processes planning processes available Was is government involved in MPA planning Minutes of meetings reports of collaborative planning processes processes Have MPA rules and guidelines been posted at strategic locations so that the general public people in the area of the MPA can easily see read reference them Has regular biophysical monitoring started w N available MPA rules amp guidelines are posted in strategic locations i e please list Inomuredare addmoerossneecer protocol s is are in place Biophysical components being monitored are add more rows as needed Period conducted i e monthly annually every 2 years Etc The top four or less priority biophysical components being monitored are Has regular socially related monitoring started Inomeredare addmorerow asneeceay nanoa protocol s is are in place Socially related components being monitored are Inomeredare addmorerow asneeceay nanoa more rows as needed Has a budget been allocated and is accessible for MPA management from central or local government or from other sources Annual total budget for MPA management is in USD See section C MPA Financial Management above Has a management plan for the MPA been produced A management plan is available Timescale of plan is to year G Ha
Download Pdf Manuals
Related Search