infoiess@ug.edu.gh

+233 (0) 302 962 720

Box LG 209, Legon, Accra

University of Ghana C2R-CD Project and Aarhus University to Build Capacity of Researchers and Students on Visual Basic for Application in Excel

02 September 2023

The Coastal Community Resilience to Climate and Diarrhoea (C2RCD) to organize a short course on Visual Basic for Applications (VBA) in Excel, focusing on data handling and modelling in Ghana.

This is a partnership between the University of Ghana and Danish partner, Aarhus University, and forms part of the strides the two universities are making to build the capacities of researchers and students to leverage on critical modern cutting-edge technological tools for academic data handling and modelling.

The course, scheduled to take place on September 7, 2023, at the Centre for Climate Change and Sustainability Studies (CCCSS) Auditorium, would be a one-day, hands-on short course that will provide participants with an introductory understanding of VBA. It is expected to empower researchers and students of the University of Ghana to adopt a VBA macro-based programming to accomplish more complex tasks through the creation of customized forms for data input and output, and manipulations for enhanced research projects. This critical tool builds on the traditional Excel functionalities that rely only on cell-based calculations for research.

Both universities, through the C2R-CD Project, have over the years been modelling the interactions between climatic, hydrological, environmental, epidemiological, institutional, and socio-cultural determinants of diarrhoea to improve diarrhoeal management in coastal communities in Ghana.

At the University of Ghana, the project is led by the Institute for Environment and Sanitation Studies (IESS). The project has been generating long-term data series in Anyako, Anyanui and Atiteti (Volta Region), Eastern Coast; Opetekwei (Greater Accra Region) and Mumford (Central Region), Central Coast of Ghana to model the interactions between climatic, hydrological, environmental, epidemiological, institutional and socio-cultural determinants of diarrhoea with the aim to among other things, improve diarrhoeal management in coastal communities.