Unlocking Nature’s Secrets: SLinCA Boosts Ecological Data Skills with Excel & R
Training!
Unlocking Nature’s Secrets: SLinCA Boosts Ecological Data Skills with Excel & R
Training!
Kumasi, Ghana – May 2025 – The Sustainable Livelihoods and Nature Conservation
Alliance (SLinCA) has taken a major step in building the capacity of students and early
career professionals in conservation in Ghana by hosting a four-day ecological data analysis
training at the Faculty of Renewable Natural Resources (FRNR), Kwame Nkrumah
University of Science and Technology (KNUST). The training brought together over 18
participants, including students, alumni, teaching assistants, NGO members, researchers, and
conservation leaders, to build practical skills in using Microsoft Excel and R programming
for ecological research and restoration planning.
The training aimed to bridge the gap between data collection and meaningful conservation
decisions. Participants were introduced to Excel for cleaning, sorting, and visualizing
ecological datasets. From there, they advanced to introductory exercises using the R
programming language, a free statistical computing tool. Using real-world datasets from
SLinCA’s restoration projects, they practiced importing ecological dataset into R, data
exploration, graphing and visualization as well as basic statistical analysis such as t-test,
correlation and regression.
Dr. Mohammed Armani (KNUST and SLinCA) led the sessions with support from the
SLinCA’s research team. “We start with Excel because it’s familiar to most participants,” he
explained. “Then we guide them through R, showing how even complex analysis can be
accessible with the right examples and support.”
The impact was clear. “Before this, I had been collecting data, but analysing it effectively was
a challenge,” said Cornelius Teye a student at KNUST. “Now I can interpret ecological trends
with confidence and contribute more meaningfully to restoration efforts.” The training
emphasized that data analysis is not just for academics. The training program focused on how
this basic analysis can support decision making regarding species selection and tree planting
initiatives.
Each participant received a digital toolkit with Excel templates and annotated R scripts, ready
for use in their own biodiversity monitoring, soil assessment, and reporting work. Dr. Armani
highlighted the broader goal of the initiative: to build a data-literate generation of
conservationists who can drive science-based action in their communities.
What’s Next?
This training marks the beginning of the SLinCA Train – Capacity building initiative. The
initiative focuses on capacity building for local communities, private sector and professionals
working in the field of nature conservation and sustainable development. Dr. Armani
indicated that several of such training programs will be rolled out in the coming months,
particularly in the areas of green value chain development, ecosystem restoration, ESG
(environmental, social and governance), ESIA (environmental and social impact assessment),
AI tools, etc.