Are you typing data directly into Excel?
(Rather than exporting it from a database?)
If so, drop-down lists can save time and reduce typos.
Here’s how to make them in Excel with a feature called Data Validation:
the next day for evaluation
Are you typing data directly into Excel?
(Rather than exporting it from a database?)
If so, drop-down lists can save time and reduce typos.
Here’s how to make them in Excel with a feature called Data Validation:

Cuando hablamos de Desarrollo de Capacidades Nacionales de Evaluación (Dentro de nuesta serie NECD), los debates y experiencias acumuladas nos dejan un mosaico complejo pero revelador.
¿Qué patrones se repiten?
¿Qué barreras persisten?
¿Dónde están las oportunidades?
Y los dilemas estructurales que vuelven una y otra vez…
En resumen
El #NECD no avanza en línea recta: es un proceso político, adaptativo y colectivo. La lección transversal es clara: solo cuando personas, organizaciones y sistemas se conectan bajo principios de aprendizaje, inclusión y sostenibilidad, la evaluación se convierte en palanca de transformación social.
¿Qué patrón reconoces en tu contexto?
¿Qué anti-práctica deberíamos abandonar ya para que la evaluación cumpla su promesa?
#Evaluación #CapacityDevelopment #EvidenceUse #Learning #Governance #Innovation #NECD
Nota: Este artículo fue redactado con apoyo de inteligencia artificial, que también sugirió algunas de las referencias bibliográficas incluidas. Sin embargo, las ideas centrales, el enfoque y la selección final del contenido son completamente mías

Como venimos viendo en nuestra serie NECD, la evaluación ya no es solo un ejercicio técnico. Es aprendizaje, poder, participación, innovación y sostenibilidad. Pero… ¿cómo diseñar una estrategia de desarrollo de capacidades en evaluación que realmente transforme?
Tras revisar literatura clave emergen 7 ejes comunes que atraviesan las experiencias más relevantes:
Los 7 ejes de la capacidad evaluativa
Mapa detallado de capacidades en evaluación (con ejemplos prácticos). Así se ven estos ejes cuando se cruzan con los niveles de capacidad (individual, organizacional y sistémico):
| Eje | Individual | Organizacional | Sistémico |
| 1.Aprendizaje y adaptación | Formación en reflexión crítica | Ciclos de aprendizaje interno | Sistemas nacionales que aprenden |
| 2.Participación e inclusión | Habilidades en métodos participativos | Mecanismos de co-creación | Inclusión de sociedad civil en políticas |
| 3.Institucionalización de sistemas | Comprensión de marcos legales | Unidades de evaluación robustas | Marcos normativos y leyes de evaluación |
| 4.Uso de la evidencia | Capacitación en síntesis de evidencia | Procesos internos de gestión de evidencia | Políticas basadas en evidencia |
| 5.Dimensión política y poder | Conciencia de sesgos y ética | Transparencia y legitimidad institucional | Gobernanza clara y rendición de cuentas |
| 6.Metodologías flexibles | Uso de enfoques innovadores | Adopción de metodologías adaptativas | Promoción de enfoques transformadores y decoloniales |
| 7.Sostenibilidad y transferencia | Gestión de conocimiento personal | Memoria institucional (archivos, repositorios) | Sistemas de datos abiertos y sostenibles |
Desarrollo del Mapa, con narrativa detallada con ejemplos y referencias
1. Aprendizaje y adaptación
Referencia: Baser & Morgan (2008) destacan la importancia de la capacidad adaptativa; Rosenberg & Donaldson (2020) profundizan en cómo transferir ese aprendizaje a largo plazo.
2. Participación e inclusión
Referencia: Estrella & Gaventa (1998) problematizan “¿quién cuenta la realidad?”; Segone (2009) insiste en que los sistemas país deben ser conducidos localmente e inclusivos.
3. Institucionalización de sistemas
Referencia: Mackay (2007) explica cómo construir sistemas de M&E en gobiernos; Goldman et al. (2018) muestran la emergencia de sistemas de evaluación en África.
4. Uso de la evidencia
Referencia: Goldman & Pabari (2020) señalan el desafío del uso efectivo de la evidencia en África; Holvoet & Renard (2007) advierten los riesgos de sistemas frágiles (PRSP).
5. Dimensión política y poder
Referencia: Picciotto (2011) subraya que la evaluación es una profesión atravesada por poder; Gornitzka & Stensaker (2014) muestran cómo la legitimidad se disputa en contextos de educación superior.
6. Metodologías flexibles
Referencia: Morgan (2008) propone el pensamiento sistémico como clave; Patton (2010) desarrolla la evaluación de desarrollo para entornos complejos.
7. Sostenibilidad y transferencia
Referencia: Segone (2009) resalta la importancia de sistemas país sostenibles; Rosenberg & Donaldson (2020) muestran cómo lograr transferencia de aprendizajes más allá de proyectos puntuales.
En resumen, este mapa muestra cómo cada eje de capacidad puede ser trabajado en los tres niveles, conectando personas, organizaciones y sistemas.
¿Cómo llevarlo a la práctica?
Innovaciones emergentes
Mensaje final
El desarrollo de capacidades en evaluación no es lineal ni puramente técnico:
es un proceso político, adaptativo y colectivo, que solo funciona si conecta personas, organizaciones y sistemas bajo un mismo principio:
la evaluación como motor de aprendizaje y transformación social.
Referencias
Nota: Este artículo fue redactado con apoyo de inteligencia artificial, que también sugirió algunas de las referencias bibliográficas incluidas. Sin embargo, las ideas centrales, el enfoque y la selección final del contenido son completamente mías

Introducción – El elefante en la sala del NECD
Año tras año, región tras región, se multiplican capacitaciones, talleres y cursos de evaluación. Sin embargo, la pregunta incómoda persiste:
¿Realmente están cambiando los sistemas de evaluación pública, o seguimos atrapados en un modelo de “formar por formar” que no transforma estructuras ni culturas institucionales?
En nuestras realidades, donde la gobernanza se entrelaza con profundas desigualdades, los enfoques tradicionales de desarrollo de capacidades para la evaluación nacional (NECD) muestran límites evidentes. Esta conversación no es nueva. Pero urge actualizarla con una mirada crítica, sistémica, contextualizada… y también creativa.
Aquí entra en escena TRIZ (Altshuller, 1996).
Nudo – Cinco retos estructurales que siguen sin resolverse
El aporte de TRIZ: aprender desde la anti-evaluación
En el panel que se presentará en ReLAC 2025, se propone una provocación:
“¿Qué deberíamos hacer para asegurarnos de que los sistemas de evaluación fracasen rotundamente?”
No es cinismo: es usar TRIZ para pensar al revés y sincerar la conversación.
Las anti-prácticas más comunes
No legislar, ni presupuestar, ni exigir evaluación (Mackay, 2007; Goldman & Pabari, 2020).
Crear unidades de evaluación sin poder ni conexión con decisiones (Segone, 2009).
Capacitar evaluadores sin darles oportunidades reales de práctica (Picciotto, 2011).
Usar la evaluación como castigo, control o trámite (Estrella & Gaventa, 1998).
Desconectar evaluación de los ciclos de política y planificación (UNEG, 2022).
Reproducir silos y fragmentación institucional (Gornitzka & Stensaker, 2014).En otras palabras: muchas veces ya estamos haciendo “anti-evaluación” sin darnos cuenta.
La fuerza de TRIZ está en voltear la lógica: nombrar esas prácticas que garantizan el fracaso y preguntarnos con crudeza:
“¿Qué pasaría si dejáramos de hacer todo esto?”
Conclusiones – Siete pistas para cambiar el rumbo
Preguntas para avanzar
Referencias
Altshuller, G. (1996). And Suddenly the Inventor Appeared: TRIZ, the Theory of Inventive Problem Solving. Technical Innovation Center.
Baser, H., & Morgan, P. (2008). Capacity, change and performance: Study report. ECDPM.
Estrella, M., & Gaventa, J. (1998). Who counts reality? Participatory monitoring and evaluation: A literature review. IDS.
Goldman, I., & Pabari, M. (Eds.). (2020). Using evidence in policy and practice: Lessons from Africa. Routledge.
Goldman, I., Gounou, A., Hoerée, J., Jacob, C., Ntakumba, E., Pabari, M., & Urbaniak, K. (2018). The emergence of government evaluation systems in Africa. African Evaluation Journal, 6(1), 1–12.
Gornitzka, Å., & Stensaker, B. (2014). Evaluation Processes in Higher Education: Impact, Legitimacy and Power. Palgrave Macmillan.
Holvoet, N., & Renard, R. (2007). Monitoring and evaluation under the PRSP: Solid rock or quicksand? Evaluation and Program Planning, 30(1), 66–81.
Lipmanowicz, H., & McCandless, K. (2013). The Surprising Power of Liberating Structures. Liberating Structures Press.
Mackay, K. (2007). How to Build M&E Systems to Support Better Government. World Bank.
Morgan, P. (2008). The Idea and Practice of Systems Thinking and Their Relevance for Capacity Development. ECDPM.
Picciotto, R. (2011). The logic of evaluation professionalism. Evaluation, 17(2), 165–180.
Rosenberg, S., & Donaldson, S. I. (2020). How learning transfer works in evaluation capacity building. American Journal of Evaluation, 41(1), 61–78.
Segone, M. (Ed.). (2009). Country-led Monitoring and Evaluation Systems: Better Evidence, Better Policies, Better Development Results. UNICEF & World Bank.
UNEG – United Nations Evaluation Group. (2022). Theory of Change for National Evaluation Capacity Development. https://www.uneval.org
Nota: Este artículo fue redactado con apoyo de inteligencia artificial, que también sugirió algunas de las referencias bibliográficas incluidas. Sin embargo, las ideas centrales, el enfoque y la selección final del contenido son completamente mías
In this tutorial, you’ll learn how to make a data visualization GIF, like this:

Watch it here:
Ann Emery: [00:00:00] In this tutorial, I’m gonna teach you how to make a DataViz GIF like this.
This is a before and after that I made just a few minutes ago, because I wanted to post it on LinkedIn.
And it’s really fast. It’s really easy. You can make it all with free software.
I get a lot of questions about like practical stuff like, “wait, you made a GIF?! How?!”
You know, people are on board, they understand the power of simple, engaging visuals like gifs, but then they’re like, “I don’t know exactly how you did that.”
So I wrote out for us the four really easy steps. Let’s do it.
Okay, so step one is you’re gonna lay out each frame. And I use good old PowerPoint for that. So I’m gonna show you behind the scenes it would look something like this. Each frame gets its own slide.
And a couple key tips here. Okay. So you have to make sure that you only have one [00:01:00] change per frame or one change per slide. For example, Let me go big screen so you can see what this would look like.
If you go from this to this, there’s actually two changes there. Do you see the title here? The title? And then the visual. If you jump here, the title changes and the visual changes. It’s a little bit too jarring, a little bit too hard, I think, for people to keep up with that, when like, everything’s changing all at once with the gif.
So you’re gonna need a lot of intermediate slides. You’re gonna need tons of these. You’re gonna probably need twice as many slides, or three times as many slides as you think you need. Okay.
Do you see the progression where it’s only one change at a time? It’s like this. And then second, just the text changes. Third, just the visual changes. Fourth, just the [00:02:00] text changes. Fifth, just the visual changes.
Okay, so you’re gonna need lots and lots of slides. Only one change per slide.
And then the second tip with this is, make sure you don’t jiggle the slides. You don’t want them to look shaky. Okay? So here’s what I mean.
I always make the after slide first. And let me copy this one and I’ll show you what I mean. Okay. Don’t jiggle it. No, no jiggling, no shaking. It’s gonna make people’s eyes roll around in their head and they’re gonna get really angry at you.
Okay, so here’s the after version, and then what a lot of people do is they just add a new slide and they’re like, yeah, I’ll just like.
I’ll just like copy paste this stuff over and they’re clicking so quickly that this one accidentally moves up just a little bit or accidentally moves to the side a little bit. And then when you go from one slide to [00:03:00] the next, do you see how it’s like a little jiggly? It’s a little shaky. Okay. So what I would recommend doing is do a copy of the whole slide.
Like see the little slide previews, you do a copy. And then a paste, and then you change one thing. So I always start with gifs and with a lot of DataViz makeovers like this, I start with the finished version that I know I have to make anyway, and then I delete, you know, I delete one thing, or I just change the text box that’s already there.
I’m not making a brand new text box because you want it to go from one slide to the next and see how the visual, the table itself stays exactly in place. Okay.
It’s these little details that really differentiate, like a homemade blah gif from a really nice, really impressive gif. Okay, so that’s step one.
You’re just gonna open up good old PowerPoint. You’re gonna lay out each frame across different slides.
And then step two is also really easy. You’re gonna save each frame or each slide as an [00:04:00] image.
Okay, let me delete these two ’cause we don’t want those to go into the final version. Okay. You can be clicked on any of any of these slides.
You’re gonna do a file, save as, and let me put it in my folder. I’ve got actually not that folder, I’m gonna put it in. This folder for the second tutorial of the day. Okay. By default, a PowerPoint is gonna save as a PowerPoint, but we don’t want it to be a PowerPoint. We want it to be an image file. So you go to save as type, and there’s a few different types of image files.
I will tell you jPEGs are the best for gifts because then it saves a white background where PNGs save a transparent background. And if you share your GIF someplace on a white background, but then somebody looks at it on a black background, like I have my computer set to white background, but then my phone often has a black background.
It’s gonna look funny. Okay, so you [00:05:00] want a jpeg, you want the white background like this.
Then you do a Save and PowerPoint’s, like, which, which slide? Which, which slide or slides? And you want all, you want all slides to turn into JPEGs. And then this gobbly go is just saying, we made a separate folder for you.
And you’re like, thank you, thank you so much. That’s so sweet of you. Okay, it looks like nothing happened. But then what you’re gonna get is you’re gonna get a folder. With all of those images, seven of them in this case. Okay. Step three is you upload your images to a free GIF website. Now there’s a bunch of free ones.
Uh, the one that I used in the past for years, it doesn’t exist anymore, so I’m gonna show you the new one that I use now. It’s called Easy gif. You can just go to Google though, and like. Make a free gif and you’re gonna find a million options here. Easy GIF is great though. It’s got all the [00:06:00] editing stuff you’d ever want, okay?
Easy gif.com. We’re gonna head to their GIF maker and then we’re just gonna upload those files, the little jpeg files that we have. They are, let’s see, where is my folder? Right about here.
Okay. When you open up your folder, I recommend clicking on the slides in order. So don’t click on this one first, and then this one, you know you’re gonna start here, and then you’re gonna click on them in order so you don’t have to manually sort them or manually drag them in the right order. Later you say, okay, you upload.
Okay.
It takes about this long, you know, maybe 10 seconds, 15 seconds. Okay. And then on this screen, I do highly recommend adjusting the delay between each slide. Now, [00:07:00] 20 throws people off. They’re like, what is a 20? Well, it’s in. Parts of a second. Okay. So I would recommend the first picture, the first frame. The first slide is the longest.
Maybe even something like two seconds so people can just like see what they’re even looking at, you know? So if it shakes too much, people get angry. They’re not gonna like your gif. It needs to go a little bit slower than you may anticipate, and the, the fastest I ever do is a half second between slides.
I’m gonna do a full second here. You know what? And let me save myself some time. Let’s set these all to be a full second, and then the first one, and probably the last one are gonna be a little slower. Sound good? Okay. I would say half second minimum. Probably more like a full second is gonna be, uh, better for a lot of your audiences.
So they don’t look at it and say, what is this flashy thing? It’s like, I’m getting a seizure looking at this. We don’t want any of that. And then you just say, make a [00:08:00] gif. Okay? And then you’re gonna see it down below in just a moment.
Here’s your preview if you don’t like it, if you want longer transitions, if you want it to play.
Three times and then stop. You can change all that. You would just click make a gif a second time or a third time as you make your edits. Okay, and then I’m just gonna save as, save image. As you know, you pick your folder, et cetera, where you want it to go.
And then step four is you get to share it and you can share it.
Anywhere that you’d normally share gifs. So on social media sites, a lot of them let you upload gifs. You know, social media, that the settings change all the time. So, you know, read into your specific, uh, platform before you do it. LinkedIn, which I’m on a lot obviously lets us do gif. You can share it in a website.
It can be embedded in a website. It can be shared in a PowerPoint slide. It can go in a [00:09:00] report like a Word document, but then if or when you PDF it, the GIF doesn’t show, right? It turns back into statics. So it may take a little bit of experimenting to kind of see which formats you can share gifs in.
All right, an alternative solution, because I know at least one of you is thinking this.
A lot of people are like, “Ann, you don’t even have to use EZGIF. You can actually make gifs natively in PowerPoint.”
And yes, you can make gifs natively in PowerPoint, but it is not my favorite. So I’m gonna show you for kicks how to do that, but then I’m gonna show you why I, I don’t like doing it.
Let’s go back to PowerPoint and I’ll show you the thing that’s very tempting. It’s very tempting to do this. If you go to file and you save as it’s very, very tempting when you get to save as type. Remember, we were there a couple minutes ago. It’s very tempting to just pick a gif off this list. Where is my gif?
[00:10:00] Animated GIF format? Okay. That’s what people always say, like, and don’t why? Why don’t you just do that? Just do this thing. Okay, I’ll show you. It’s because you can’t adjust the transitions between the frames. Okay. Where is the one I just made? It would be right here. Okay. You don’t get to adjust how many seconds.
It just gives you the time. That it, it gives, which is a little bit too fast in my opinion. It doesn’t let you add more time to the first frame or more time to the last frame. It’s just the, the timing that is there. Okay? So yes possible in PowerPoint with the caveat that you don’t get all the editing features that you would probably wanna have with a free site like EZGIF.com.
Have fun making your gifts, and when you make one, please tag me. Please comment below this video. I can’t wait to see what you make.
The easiest way to stay connected to our work is to join our newsletter. You’ll get updates on projects, learn about new events, and hear stories from those evaluators whom the field continues to actively exclude and erase.
Want to take further action or join a pod? Click here to learn more.