Grants:APG/Proposals/2014-2015 round1/Wikimedia Eesti/Impact report form
Purpose of the report
This form is for organizations receiving Annual Plan Grants to report on their results to date. For progress reports, the time period for this report will the first 6 months of each grant (e.g. 1 January - 30 June of the current year). For impact reports, the time period for this report will be the full 12 months of this grant, including the period already reported on in the progress report (e.g. 1 January - 31 December of the current year). This form includes four sections, addressing global metrics, program stories, financial information, and compliance. Please contact APG/FDC staff if you have questions about this form, or concerns submitting it by the deadline. After submitting the form, organizations will also meet with APG staff to discuss their progress.
- 1 Purpose of the report
- 2 Global metrics overview - all programs
- 3 Telling your program stories - all programs
- 3.1 Education
- 3.2 Progress towards Education Program objectives
- 3.3 Program specific 2015 targets and benchmarks
- 3.4 Featured activities
- 3.5 Community
- 3.6 Progress towards Community Program objectives
- 3.7 Program specific 2015 targets and benchmarks
- 3.8 Featured activities
- 3.9 Organizations
- 3.10 Progress towards Organizations Program objectives
- 3.11 Program specific 2015 targets and benchmarks
- 3.12 Featured story
- 3.13 Learning pattern
- 4 Revenues received during this period (6 month for progress report, 12 months for impact report)
- 5 Spending during this period (6 month for progress report, 12 months for impact report)
- 6 Compliance
- 7 Signature
- 8 Resources
Global metrics overview - all programs
We are trying to understand the overall outcomes of the work being funded across our grantees' programs. Please use the table below to let us know how your programs contributed to the Global Metrics. We understand not all Global Metrics will be relevant for all programs, so feel free to put "0" where necessary. For each program include the following table and
- Next to each required metric, list the outcome achieved for all of your programs included in your proposal.
- Where necessary, explain the context behind your outcome.
- In addition to the Global Metrics as measures of success for your programs, there is another table format in which you may report on any OTHER relevant measures of your programs success
For more information and a sample, see Global Metrics.
|1. # of active editors involved||26||At least 5 edits in 30 days prior to competition.|
|2. # of new editors||65||Registered during program activity period.|
|3. # of individuals involved||183 (160 / 20 / 3)||Total (contest participants / jury members / organizers)|
|4a. # of new images/media added to Wikimedia articles/pages||518|
|4b. # of new images/media uploaded to Wikimedia Commons||1969|
|5. # of articles added or improved on Wikimedia projects||864 (747 / 117)||Total (new / complemented)|
|6. Absolute value of bytes added to or deleted from Wikimedia projects||5,941,803|
|Metric||Total||UT Biol.||UT Chem.||UT Comp. Sc.||UT Ecol.||UT Envir. Sc.||UT Gen. Tech.||UT Geog.||UT Geol.||UT Mat. Sc.||UT Phys.||KIK||Comments|
|1. # of active editors involved||23||0||0||0||0||0||0||0||0||0||0||23||At least 5 edits in 30 days prior to competition|
|2. # of new editors||173||20||13||9||13||10||33||13||7||8||9||38||Registered during competition period|
|3. # of individuals involved||245 (63/13/2)||24||14||15||15||12||37||18||7||9||13||81 (79/2)||Total (participants/organizers)|
|5. # of articles added or improved on Wikimedia projects||292 (234 / 58)||29 (20 / 9)||21 (19 / 2)||18 (14 / 4)||18 (11 / 7)||15 (7 / 8)||40 (31 / 9)||24 (12 / 12)||7 (5 / 2)||8 (7 / 1)||15 (11 / 4)||97||Total (new / complemented)|
|6. Absolute value of bytes added to or deleted from Wikimedia projects||2,218,507||277,991||201,677||220,229||193,590||153,371||538,669||206,258||84,693||87,282||152,532||102,215|
|Metric||Total||Lääne-Viru article||Translation bee||CEE Spring||Psychology bee||Latvian competition||Comments|
|1. # of active editors involved||18||5||12||11||2||5||At least 5 edits in 30 days prior to competition|
|2. # of new editors||25||5||14||1||5||0||Registered during competition period|
|3. # of individuals involved||80 (64/13/3)||15 (10 / 3 / 2)||(42 / 6 / 3)||19 (13 / 3 / 3)||13 (11 / 2 / 0)||7 (6 / 0 / 2)||Total (contest participants / jury members / organizers)|
|5. # of articles added or improved on Wikimedia projects||669 (610 / 59)||41 (30 / 11)||340 (304 / 36)||259 (253 / 6)||24 (17 / 7)||32 (32 / 0)||Total (new / complemented)|
|6. Absolute value of bytes added to or deleted from Wikimedia projects||3,825,511||99,405||2,850,422||807,016||194,788||53,856|
|Metric||Total||WLE||WLM||Science Photo||Vana-Vigala exp.ˇ||Põhjarannik exp.||Mudeliklubi||Osmussaare exp.||Setumaa exp.||Comments|
|1. # of active editors involved||13||3||7||2||2||1||2||8||2||At least 5 uploads in 30 days prior to project|
|2. # of new editors||46||20||6||12||1||0||0||0||0||Registered during project period|
|3. # of individuals involved||107 (100 / 7)||50 (47 / 3)||31 (27 / 4)||36 (35 / 1)||3||1||2||9||2||Total (contest participants / organizers)|
|4a. # of images or media used in Wikimedia projects||518||167||126||73||63||1||22||85||47|
|4b. # of new images/media uploaded to Wikimedia Commons||1969||600||812||206||100||9||101||243||57|
Due to failure to achieve common understanding between project partners Estonian Republic 100 project was halted in the beginning of year 2015 and also collaboration with city of Tartu has not progressed. As a result there are no global metrics to be reported in this field of activity.
Telling your program stories - all programs
Please tell the story of each of your programs included in your proposal. This is your chance to tell your story by using any additional metrics (beyond global metrics) that are relevant to your context, beyond the global metrics above. You should be reporting against the targets you set at the beginning of the year throughout the year. We have provided a template here below for you to report against your targets, but you are welcome to include this information in another way. Also, if you decided not to do a program that was included in your proposal or added a program not in the proposal, please explain this change. More resources for storytelling are at the end of this form. Here are some ways to tell your story.
- We encourage you to share your successes and failures and what you are learning. Please also share why are these successes, failures, or learnings are important in your context. Reference learning patterns or other documentation.
- Make clear connections between your offline activities and online results, as applicable. For example, explain how your education program activities is leading to quality content on Wikipedia.
- We encourage you to tell your story in different ways by using videos, sound files, images (photos and infographics, e.g.), compelling quotes, and by linking directly to work you produce. You may highlight outcomes, learning, or metrics this way.
- We encourage you to continue using dashboards, progress bars, and scorecards that you have used to illustrate your progress in the past, and to report consistently over time.
- You are welcome to use the table below to report on any metrics or measures relevant to your program. These may or may not include the global metrics you put in the overview section above. You can also share your progress in another way if you do not find a table like this useful.
Revenues received during this period (6 month for progress report, 12 months for impact report)
Please use the exchange rate in your APG proposal.
Table 2 Please report all spending in the currency of your grant unless US$ is requested.
- Please also include any in-kind contributions or resources that you have received in this revenues table. This might include donated office space, services, prizes, food, etc. If you are to provide a monetary equivalent (e.g. $500 for food from Organization X for service Y), please include it in this table. Otherwise, please highlight the contribution, as well as the name of the partner, in the notes section.
Revenue source Currency Anticipated Q1 Q2 Q3 Q4 Cumulative Anticipated ($US)* Cumulative ($US)* Explanation of variances from plan Wikimedia Foundation Euros €63,476.63 €37,028.00 €0.00 €0.00 €0.00 €37,028.00 $83,344.81 $48,617.76 These are funds related to current grant. Wikimedia Foundation PEG Euros €0.00 €0.00 €0.00 €0.00 €18,816.90 €18,816.90 $0.00 $24,706.59 WMCEE Meeting grant Estonian Ministry of Education and Research Euros €20,034.00 €4,235.64 €0.00 €0.00 €0.00 €4,235.64 $26,304.64 $5,561.39 Funds transferred from the pilot project. Estonian Environmental Investment Centre Euros €16,380.00 €0.00 €0.00 €0.00 €7,991.15* €7,991.15* $21,506.94 $10,492.38 Targeted project funding for environmental awareness project. Organization team for Estonia 100 Euros €5,300.00 €0.00 €0.00 €0.00 €0.00 €0.00 $6,958.90 $0.00 Funds that were foreseen for cultural heritage project. City of Tartu Euros €2,750.00 €0.00 €0.00 €0.00 €0.00 €0.00 $3,610.75 $0.00 Funds that were foreseen for Tartupedia project. Fenno-Ugria Foundation Euros €1,700.00 €0.00 €0.00 €2,150.00 €0.00 €2,150.00 $2,232.10 $2,822.95 Funds to be received for Finno-Ugric seminar Estonian Research Council Euros €0.00 €0.00 €2,942.00 €0.00 €0.00 €2,942.00 $0.00 $3,862.85 Targeted funding for European Science Photo Competition Other Euros €1,958.08 €59.03 €0.00 €300.00 €520.97 €880.00 $2,570.96 $1,155.44 Funds to be received for Finno-Ugric seminar Total Euros €111,598.71 €41,322.67 €2,942.00 €2,450.00 €27,329.02 €74,043.69 $146,529.11 $97,219.36 Total amount of funds received
* Provide estimates in US Dollars
- *Exchange rate calculated according to proposal, i.e. 1,313 USD for 1 EUR
- *Funds from Environmental Investments Centre actually payed out in July 2016.
Spending during this period (6 month for progress report, 12 months for impact report)
Please use the exchange rate in your APG proposal.
|Expense||Currency||Budgeted||Q1||Q2||Q3||Q4||Cumulative||Budgeted (US)||Cumulative (US)||Percentage spent||Explanation of variances to the plan|
|General costs||€ Euro||8,994.38||1,435.61||1,548.25||647.6||1,645.66||5,277.12||11,809.62||6,928.86||58.67%|
|Office costs||€ Euro||2,822.40||880.63||582.9||579.76||671.1||2,714.39||3,705.81||3,563.99||96.17%|
|Communication costs||€ Euro||300||57.82||52.62||9.91||323.46||443.81||393.9||582.72||147.94%||Costs higher than expected|
|General IT costs||€ Euro||120||0||0||6.49||9.9||16.39||157.56||21.52||13.66%||No investments made|
|Banking fees||€ Euro||120||0||22.27||0||138.96||161.23||157.56||211.69||134.36%||Costs higher than expected|
|Translation fees||€ Euro||500||0||0||0||0||0||656.5||0||0.00%||Wikimedia Eesti human resources used|
|Other office costs||€ Euro||120||114.32||0.19||12.82||0||127.33||157.56||167.18||106.11%|
|Technological support||€ Euro||1,000.00||0||0||0||0||0||1,313.00||0||0.00%|
|Accounting||€ Euro||600||0||540||0||0||540||787.8||709.02||90.00%||Time consumed for financial statement in H1|
|Memorabilia||€ Euro||0||335.4||231.84||0||52.05||619.29||0||813.13||N/A||Overlooked during budgeting process|
|Human resources||€ Euro||34,535.53||7,326.93||7,326.93||4,836.87||9,701.14||29,191.87||45,345.15||38,328.93||84.53%|
|Assistant||€ Euro||10,537.85||1,692.36||1,692.36||963.34||2,305.52||6,653.58||13,836.20||8,736.15||63.14%||Calculation mistake during budget planning|
|Executive director||€ Euro||23,997.68||5,634.57||5,634.57||3,873.53||7,395.62||22,538.29||31,508.95||29,592.77||93.92%|
|Education program||€ Euro||21,114.00||4,235.64||0||0||27.5||4,263.14||27,722.68||5,597.50||20.19%|
|Coordinator||€ Euro||12,564.00||0||0||0||19.4||19.4||16,496.53||25.47||0.15%||Result of restructuring of education program|
|University staff support||€ Euro||7,950.00||0||0||0||8.1||8.1||10,438.35||10.64||0.10%||Result of restructuring of education program|
|Program team costs||€ Euro||600||4,235.64||0||0||0||4,235.64||787.8||5,561.40||705.94%||Result of restructuring of education program|
|Environmental awareness||€ Euro||16,380.00||1,947.07||1,947.06||1,947.06||0||5,841.19||21,506.94||7,669.48||35.66%|
|Training||€ Euro||16,080.00||1,947.07||1,947.06||1,947.06||0||5,841.19||21,113.04||7,669.48||36.33%||Project did not go as well as planned|
|Other costs||€ Euro||300||0||0||0||0||0||393.9||0||0.00%||Project did not go as well as planned|
|Network building||€ Euro||600||0||0||0||9.47||9.47||787.8||12.43||1.58%||Activities postponed|
|Illustration project||€ Euro||300||250||0||0||0||250||393.9||328.25||83.33%||Costs related to 2014 project|
|Community||€ Euro||24,188.70||596.05||6,296.35||27,311.55||7,395.65||41,599.60||31,759.76||54,620.27||171.98%||CEE Meeting 2015 not correctly budgeted|
|General assemblies||€ Euro||800||0||0||267.66||0||267.66||1,050.40||351.44||33.46%|
|End of the year meeting||€ Euro||330||0||0||0||659.95||659.95||433.29||866.51||199.98%||Events not correctly budgeted|
|Strategy meeting||€ Euro||0||0||0||0||33.25||33.25||0||43.66||N/A|
|Summer days||€ Euro||250||0||0||0||100||100||328.25||131.3||40.00%||Costs related to 2014 meeting|
|Other meetings||€ Euro||200||47.1||37.07||19.01||49.42||152.6||262.6||200.36||76.30%|
|Wikiexpeditions||€ Euro||450||0||364.65||49.7||292.19||706.54||590.85||927.69||157.01%||Proved to be successful and thus more investments|
|Informational events||€ Euro||600||0||0||0||0||0||787.8||0||0.00%|
|Greek-themed competition||€ Euro||0||80.16||54.48||0||0||134.64||0||176.78||N/A|
|LÃ¤Ã¤ne-Viru competition||€ Euro||400||13.6||33.06||0||0||46.66||525.2||61.26||11.67%||Event was not as successful as hoped|
|Translation bee||€ Euro||300||0||220||20.85||0||240.85||393.9||316.24||80.28%|
|WMCEE Spring||€ Euro||350||0||520||0||0||520||459.55||682.76||148.57%||Collaborative event bigger than planned|
|Psychology bee||€ Euro||0||0||50||0||0||50||0||65.65||N/A|
|Wiki Loves Earth||€ Euro||1,450.00||0||950||145.3||0||1,095.30||1,903.85||1,438.13||75.54%|
|Cultural heritage bee||€ Euro||800||0||0||0||0||0||1,050.40||0||0.00%|
|Wiki Loves Monuments||€ Euro||1,450.00||398.75||34.8||0||438.26||871.81||1,903.85||1,144.69||60.12%||Including costs related to 2014 project|
|Science Photo of the Year||€ Euro||1,000.00||0||0||0||2,476.55||2,476.55||1,313.00||3,251.71||247.66%||Good external support and international coordination|
|Latvian competition||€ Euro||500||0||0||0||0||0||656.5||0||0.00%||2016 grant funds used for prizes|
|Wikimedia Conference||€ Euro||1,983.70||0||2,214.14||20.7||0||2,234.84||2,604.60||2,934.34||112.66%||Prices different than in planning period|
|Wiki Sabantui||€ Euro||0||0||774.54||0||0||774.54||0||1,016.97||N/A|
|Finno-Ugric seminar||€ Euro||4,850.00||0||0||5,324.53||20.6||5,345.13||6,368.05||7,018.16||110.21%|
|Wikimedia CEE Meeting||€ Euro||4,700.00||0||0||20,257.51||1,559.36||21,816.87||6,171.10||28,645.55||464.19%||Not properly budgeted during planning phase|
|Big Fat Brussels||€ Euro||0||0||0||0||1,324.06||1,324.06||0||1,738.49||N/A|
|Tartupedia||€ Euro||3,125.00||24||0||0||0||24||4,103.13||31.51||0.77%||Project cancelled|
|QR codes||€ Euro||2,500.00||0||0||0||0||0||3,282.50||0||0.00%||Project cancelled|
|Workshops||€ Euro||125||0||0||0||0||0||164.13||0||0.00%||Project cancelled|
|Other||€ Euro||500||24||0||0||0||24||656.5||31.51||4.80%||Domain cost|
|International community||€ Euro||0||32.44||0||27||60.24||119.68||0||157.14||N/A||Not foreseen during planning|
|Cultural heritage program||€ Euro||6,370.00||163.38||89.43||136||0||388.81||8,363.81||510.51||6.10%|
|Training||€ Euro||740||0||0||0||0||0||971.62||0||0.00%||Project paused|
|Meetings||€ Euro||330||0||0||0||0||0||433.29||0||0.00%||Project paused|
|Feedback team||€ Euro||5,300.00||0||0||0||0||0||6,958.90||0||0.00%||Project paused|
|International participation||€ Euro||0||163.38||89.43||136||0||388.81||0||510.51||N/A||GLAM coordinators meeting not foreseen|
|Library project||€ Euro||220||0||0||0||0||0||288.86||0||0.00%||Project cancelled|
|Tartu project||€ Euro||300||0||0||0||0||0||393.9||0||0.00%||Project cancelled|
|Wikimaps||€ Euro||0||2,271.60||0||0||0||2,271.60||0||2,982.61||N/A||Activities not finished in 2014 as planned|
|Local coordination||€ Euro||0||2,271.60||0||0||0||2,271.60||0||2,982.61||N/A||Activities not finished in 2014 as planned|
|Transportation||€ Euro||0||0||0||0||0||0||0||0||N/A||Activities not finished in 2014 as planned|
- Exchange rate calculated according to proposal, i.e. 1,313 USD for 1 EUR.
Is your organization compliant with the terms outlined in the grant agreement?
As required in the grant agreement, please report any deviations from your grant proposal here. Note that, among other things, any changes must be consistent with our WMF mission, must be for charitable purposes as defined in the grant agreement, and must otherwise comply with the grant agreement.
- Some of the program activities were cancelled or postponed. Related comments are given in respective sections.
Are you in compliance with all applicable laws and regulations as outlined in the grant agreement? Please answer "Yes" or "No".
Are you in compliance with provisions of the United States Internal Revenue Code (“Code”), and with relevant tax laws and regulations restricting the use of the Grant funds as outlined in the grant agreement? Please answer "Yes" or "No".
- Once complete, please sign below with the usual four tildes.
Resources to plan for measurement
- Global metrics are an important starting point for grantees when it comes to measuring programmatic impact (Learning Patterns and Tutorial) but don’t stop there.
- Logic Models provide a framework for mapping your pathway to impact through the cause and effect chain from inputs to outputs to outcomes. Develop a logic model to map out your theory of change and determine the metrics and measures for your programs.
- Importantly, both qualitative and quantitative measures are important so consider both as you determine measures for your evaluation and be sure to ask the right questions to be sure to capture your program stories.
Resources for storytelling
- WMF storytelling series and toolkit (DRAFT)
- Online workshop on Storytelling. By Frameworks institute
- The origin of storytelling
- Story frames, with a focus on news-worthiness.
- Reading guide: Storytelling and Social change. By Working Narratives
- The uses of the story.
- Case studies.
- Blog: 3 Tips on telling stories that move people to action. By Paul VanDeCarr (Working Narratives), on Philanthropy.com
- Building bridges using narrative techniques. By Sparknow.net
- Differences between a report and a story
- Question guides and exercises.
- Guide: Tools for Knowledge and Learning. By Overseas Development Institute (UK).
- Developing a strategy
- Collaboration mechanisms
- Knowledge sharing and learning
- Capturing and storing knowledge.