Spreadsheet-based data entry

Interested in more webinars and material on M&E? Sign up for our newsletter!

About the webinar

This session is ideal for admin users in ActivityInfo.

We’re getting ready to launch an updated version of the Table in ActivityInfo that will support in-line editing, filling down cells, copying, pasting and more features you would expect of a spreadsheet.

Watch our Webinar to get a preview and see what is changing.

Despite being a powerful tool, Excel and spreadsheet-based software haven’t been designed to work as databases or hold large amounts of data. Validating data, enforcing rules, collaborative data editing and scaling up to managing and editing long datasets are too challenging tasks for this type of tools due to their underlying mechanics.

On the other hand, the simplicity in which you can copy, move, fill down and work with the data has been considered a unique advantage of their nature. For this reason, we’ve been working on enhancing the data entry options in the platform.

During the session, we discuss how this functionality brings together the ease of use of spreadsheets with the power and the control offered by the relational database model.

We look into:

  • Data entry basics: adding, editing, copying, pasting, deleting single or multiple records, filling down cells
  • Working with drafts and validation rules or other form logic requirements
  • Cleaning duplicate records for quality data

You can preview this spreadsheet-based data entry here: https://preview.activityinfo.org/login
Please note that this version is connected to the production environment so any changes you make will apply to the live data.
Questions or feedback? You can contact support@activityinfo.org.

Is this Webinar for me?

  • Are you responsible for designing systems or training users in using ActivityInfo?
  • Do you wish to preview the upcoming changes and ask your questions?

Then, watch our Webinar!

About the Presenter

Alexander Bertram, Executive Director of BeDataDriven and founder of ActivityInfo, is a graduate of the American University's School of International Service and started his career in international assistance twenty years ago working with IOM in Kunduz, Afghanistan and later worked as an Information Management officer with UNICEF in DR Congo. With UNICEF, frustrated with the time required to build data collection systems for each new programme, he worked on the team that developed ActivityInfo, a simplified platform for M&E data collection. In 2010, he left UNICEF to start BeDataDriven and develop ActivityInfo full time. Since then, he has worked with organizations in more than 100 countries to deploy ActivityInfo for monitoring & evaluation.

Sign up for our newsletter

Sign up for our newsletter and get notified about new resources on M&E and other interesting articles and ActivityInfo news.

Which topics are you interested in?
Please check at least one of the following to continue.