Spreadsheet-based data entry

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.

Join 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 will 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 will 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

We will also host a longer QA session to hear your feedback and reply to your questions.

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, join 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.

Register

Even if you can't attend, register to receive a recording.

Can we contact you in the future with more resources on M&E and other interesting articles and ActivityInfo news?
Please check at least one of the following to continue.