Tech4Good Community-Updates Jan 2023

Hello everyone,

Here is what this month’s update is looking like from us at T4GC:

Overall Updates

Our core team now stands at 6- we have welcomed another team member who is handling our nonprofit partnerships piece.

We are running two sets of capacity building workshops- an open cohort & another focussed on organisations working on property inclusivity.

Progress on the goals listed while on-boarding

Deep dive sessions for all cohort NPOs on tools across 6 identified areas i.e. fundraising, project management, data collection, stakeholder management, communication and analytics.

Status: We have concluded 2 sessions out of 6, details of which can be found below.

  1. DataOGram: Affordable & accessible data solutions for organisations to drive process efficiency and impact.

DataOGram is a cutting-edge survey and data visualisation platform designed specifically for the social sector. It’s an offline-compatible, mobile-friendly SaaS solution that simplifies data collection, management, and visualisation, making it scalable and cost-effective for NGOs. It helps organisations track their progress and monitor their adherence to their goals.

Trainer: Santosh Abraham, Co-founder, DataOGram

Session Elements:

  • Create unlimited forms using our simple front end.
  • Set up complex forms using XLSform
  • Use automatic dashboarding to help you visualise their data
  • Edit collected data to fix possible errors
  • Assign validation status to data
  • User role-based access control
  • Host multiple projects with different teams

Tool Highlights:

  • Unlimited Projects
  • Unlimited Users
  • 10,000 submissions per month
  • 10GB Storage
  • Technical Support
  • Paid XLS form creation support

Special T4GC Discount:

INR 5000/month + GST

Participation

32 organisations were a part of this training- less than 20% were aware of this tool and none of them had used it previously.

  1. ERP4Impact: One-stop solution for any Indian NPO to record, track and manage their finances - donations, grants, expenses, budgets, utilisation certificates etc.

ERP4Impact has strived to be the CFO Services firm that philanthropists and charities come to when they are looking for transparency, governance and streamlining processes. They develop practical, customized insights that our NGO partners can benefit from. Monitoring finance is one of the primary aspects to be taken care of in any concern.

What makes them unique is the presence of our ‘homegrown’ leadership team who have been involved in fieldwork for NGOs. They were incorporated with a vision to channelize our team’s finance and accounting expertise into something meaningful and valuable for the sector.

Trainers: Ravi Bagaria & Ritu Jain

Founders ERP4Impact

Topics Covered:

  • Donor Management
  • Donations Management
  • Grant & Pledge Management
  • Budgets Management
  • Expenses Management
  • Automate Entries in Tally
  • Interactive Dashboards

Tool Highlights:

  • Classify donors, comply with FCRA and Income Tax.
  • Be on point with expenditure against the budget. Ensure approvals before payment. No more reimbursement through Excel sheets.
  • Track receivables from monthly donations in a breeze.
  • Hassle free entries directly into Tally in 2 clicks.
  • No going back to MOUs. Tranche schedule reminders. LIVE UC tracking. Ensure timely utilisation and reporting to donors.

Special T4GC Discount:

Customised Pricing- based on the NPOs annual budget and their requirements, with an additional T4GC discount of 20%

Participation

21 organisations were part of this training, less that 30% had heard of this tool and none had used it previously.

Outcomes we are chasing for the next 6 months

We will be conducting 4 more deep dive sessions on Google Analytics, Google Ads, Trello and Zeapl.

In addition to this, we will also be running one on one mentoring sessions for select NPOs, and a few would be a part of a Hackathon event for more specific problem statements.

3 Likes

View the DataOGram training video.
View the ERP4Impact training video.

Hello everyone,

Here is what this month’s update is looking like from us at T4GC

Overall updates (since the last update)

  • We’ve launched a new programme on open source tools, called FOSSFwd and welcomed 2 new interns- Computer Science undergraduates- who are helping us customise Free and Open Source Solutions for Nonprofits.
  • As mentioned in the previous update, we have been running two sets of capacity building workshops and have wrapped up all the sessions.
  • Our revamped website should be online next week.
  • Read all our updates here.

Progress on the goals listed while on-boarding

Deep dive sessions for all cohort NPOs on tools across 6 identified areas i.e. fundraising, project management, data collection, stakeholder management, communication and analytics and an additional session on Human Centred Design that was held today.

Status: We have concluded the T4GC<><Rainmatter Foundation Spotlight Series.

Session 1 | Google Ads

Topic:

Gaining visibility to companies and individuals looking for your organisation.

Duration:

80 minutes

Session Facilitator:

Sakshi Y, Search Specialist at Google.

Session Details:

Google Ad Grants works towards enabling growth for all nonprofit organisations. With the essential verification documents, a Nonprofit would be able to use the most popular search engine in the world. This would help them scale their growth to the right audiences. Sakshi, from the Google team presented the elaborate ways Google Ads can help scale nonprofit organisations reach for free.

Subtopics covered in the session:

  1. What is Google Ad Grants?

  2. Keywords

  3. Keyword planner

  4. Ad Rank

  5. Quality Score

  6. The Auction

  7. How helpful are Ad Words?

  8. Steps to maintain a good CTR

  9. Types of goals for NPOs

  10. Key components for search advertising

  11. Google Analytics: Free tool that helps measure the online marketing performance by tracking users’ pathways on websites/platforms and social media.

Special T4GC Discount:

This is a free tool for NPOs.

Session 2 | Trello

Topic:

Automating project management to stay on top of deadlines and more.

Duration:

60 minutes

Session Facilitator:

Manjunath Basaralu Srinivasa, Atlassian

Session Details:

Atlassian has been one of our long term corporate partners. They offer complete tech solutions worldwide, one of the most popular being Jira Software and Trello. Trello uses the Kanban style board system to help users visualise their progress and manage their workflow. There is an endless need to prioritise and stay on top of all that goes on within a nonprofit organisation. Manjunath demonstrated how to create boards, set deadlines and add cards for seamless and sleek project management.

What is Trello?

Trello, by Atlassian, is a powerful project management tool that helps nonprofits stay organised and on track. It is a cloud-based platform that allows teams to collaborate on projects, assign tasks, and track progress. With Trello, nonprofits can easily manage their projects, tasks, and resources in one place. Trello can be used on desktop and mobile. It helps nonprofits stay organised by allowing them to create boards for each project, assign tasks to team members, and track progress. It also allows users to create checklists, add comments, and attach files to tasks. This makes it easy to keep track of tasks and ensure that everyone is on the same page. You can integrate your favourite services such as Google Drive, Dropbox, GitHub, Slack, Evernote and MailChimp.

Trello also helps nonprofits stay on track by providing real-time updates on tasks and progress. This allows teams to stay up to date on the status of their projects and ensure that tasks are completed on time.

Finally, Trello helps nonprofits save time and money by providing a centralised platform for project management. This eliminates the need for multiple tools and allows teams to focus on the tasks that matter most.

Overall, Trello is a powerful project management tool that helps nonprofits stay organised and on track. It provides a centralised platform for project management, real-time updates, and collaboration tools that make it easy to manage projects and tasks. With Trello, nonprofits can save time and money while ensuring that their projects are completed on time.

Watch the Google Ads training.
Watch the Trello training.

Hello everyone,

Here is what this month’s update is looking like from us at T4GC

Overall updates (since the last one)

  1. Of the 1000+ NPOs that T4GC has worked with over the past 5 years, 90% report struggling with siloed data due to a lack of centralised data management systems, data collection & visualisation tools. We have put together the first edition of our FOSSFwd Handbook aimed at increasing awareness of FOSS for NPOs, the benefits of adopting it and tools that will support NPOs with all their data requirements.
  2. T4GC is working on 10 FOSSFwd projects between April and May. Here are a few the day-to-day operational systems that we are customising on FOSS:
  • Finance and HR Management
  • Project Management
  • Inventory management
  • Data visualisation
  • Learning Management Systems
  1. We have also started building our pipeline of tech vendors, mentors and student interns in and around Bangalore to help implement FOSS at scale.
  2. We are progressing on customising ERPNext for organisations across different domains - Health, Education and Livelihood that can be easily replicated and customised at scale.

Progress on the goals listed while on-boarding

Deep dive sessions for all cohort NPOs on tools across 6 identified areas i.e. fundraising, project management, data collection, stakeholder management, communication and analytics and an additional session on Human Centred Design.

Status: We have concluded the T4GC<><Rainmatter Foundation Spotlight Series.

Session | Human Centred Design

Topic:

How nonprofit organisations can use Human Centred Design to improve their communication strategies.

Duration:

60 minutes

Session Facilitator:

Soujanya Raj, Professional Web Designer (UI/UX)

Session Details:

Soujanya Raj is one of the tech mentors at the Tech4Good Community. She has 14 years of experience in Australia. She researches all the new ways to improve user experience and design. Keeping user interface and user experience in mind, an organisation can maximise their online outreach and scale their impact with the added humane element online.

Subtopics covered in the session:

  • What is Human Centred Design? (HCD)
  • Focus Points.
  • The 4 principles of HCD
  • How does it benefit NPOs?
  • Purposes for organisations to have a website.
  • Useful guidelines of User Experience for NPOs to keep in mind.
  • Useful tools.
  • Case Study.

Useful Tools

  • Miro: Helps with brainstorming and is a collaborative tool for information architecture. Monitor Kanban boards.
  • Figma: Prototyping and designing tool to help you design on live boards what a call to action button would look like etc. charitywater.org used Figma to design their entire website.
  • Invision: Learning how your website would look by creating a live clickable prototype. Can import designs from Sketch.
  • User Zoom: User testing. Need to build it to find out what users need. Hire and test using a moderator.
  • Askable: Moderated research. Where they hire people for you.

Case Study

  • this is an NPO Soujanya worked with independently of Tech4Good Community’s intervention

The Cerebral Palsy Alliance is a nonprofit that helps provide services to thousands of people with disabilities and their families. Soujanya’s team - Team Design Snuggles won third place in the Design-athon by Remarkable Tech. The design-athon was centred around a cause by the Cerebral Palsy Alliance. They had to showcase their user experience skills on how we can use technology to elevate the lives of young people living with disabilities.

Implementation Details

So far, we’ve had 40 requests for this set of tools, 5 of which are for DataOGram, 9 for ERP4Impact, 19 for Google Analytics, and 5 for Google Ads and 2 for Trello. There were 3 tool requests for Danamojo and 3 tool requests for Google Earth which were not featured in this Spotlight.

Way Forward

  1. We will be introducing the cohort to our newly launched FOSSFwd program: We customise open source low-cost replicable solutions through our FOSSFwd (Free and Open Source Software) program where students are provided with internships exposing them to the developmental sector. Through this our aim is to build a solid engineering ecosystem. The cohort along with Rainmatter grantees will get access to this program from May 2023. They will also have access to the open source playbook.

  2. As an extension of the sessions in the Spotlight Series, several organisations in the cohort have signed up for customised 1-1 mentorships on tools like Trello, Google Ads, Google Earth and Google Analytics in partnership with Atlassian & Google. This will continue from May 2023 - July 2023.

  3. Rainmatter grantees like - Vidhi Legal, Waste Warriors, Janaagraha, Souramandala Foundation, Technology For Wildlife Foundation, Saahas, SWMRT, WRI, Industree, Centre for Environment Concerns, Slam Out Loud, Fields of View, T4G Labs, Shakti Sustainable Energy Foundation, Lipok Social Foundation and SSRDP have attended some of our Spotlight Series sessions. We will be working with them to support further on tech requirements that have been identified from these sessions.

  4. We are also working on collecting stories of impact and testimonials from the cohort to inspire the larger nonprofit community on various tools, learnings and experiences. This includes specific set up success stories and overall programme highlights and improvement for the future.

1 Like

Hello everyone,

Here is what this month’s update is looking like from us at Tech4Good Community.

Overall updates

  • We have an engineering team in place to ensure that our FOSSFwd programme is able to produce replicable solutions for many common system requirements of NPOs.
  • Tech4Good Community’s platform OTTER and website have been merged. Our new website now functions as a resource hub for NPOs to learn about proprietary and free and open source software. Visit us here.

Programme Updates

  1. FOSSFwd (FF)

We customise open source low-cost replicable solutions for NPOs through our FOSSFwd (Free and Open Source Software) program where students are provided with internships exposing them to the developmental sector. Through this our aim is to build a solid engineering ecosystem.

Interested NPOs can reach out to us here.

Engineering4Good

The student internship programme is underway, we have 1 intern and 30 fresh applicants in the pipeline for this programme.

RMF Project

Transform Schools were part of the Spotlight Series and have expressed interest to be a part of the FOSSFwd programme. They reached out to us with their requirements around HR and Finance Management, which were as follows:

  1. HR Management: personnel records, payroll management, benefits administration, attendance tracking, time sheets, performance evaluation
  2. Finance and Accounting: general ledger, accounts payable and receivable, budgeting, expense management, financial reporting, project performance tracking, invoicing, vendor management, resource planning, inventory management and procurement, compliance and governance

We are in the process of customising a workspace for them on ERPNext, they will confirm their participation once we have demonstrated the capabilities of the system to them.

5 Other FF Case Studies

  1. Earth Focus is a non profit organisation dedicated to promoting environmental awareness and sustainability. With a mission to foster a global movement for a greener and healthier planet, Earth Focus envisions a future where human activities coexist harmoniously with nature.

The Earth Focus team shared with us a wishlist of the kind of data they would like to be able to collect and visualise… These included village details, farmer information, replacement of crops, tracing the number of bags distributed, costs, what was planted, the timeline of planting, market rates changes, identify which crop is affected seasonally, tracking farmer profits, uploading of photos of the crops, geotags of the sites they work in, addition of new field staff & volunteers to name a few.

Along with this they were looking to visualise and identify which plant requires treatment as an intimation from the data collected and overall reports on how the programme is being delivered on ground.

The Tech4Good Community team has completed training them on Kobo Toolbox - on creating the form, the available templates with a step by step walk through on the basics of using it along with understanding how to deploy the forms onto the mobile app. We have helped them create the form based on skip logic (similar to skip code but automatic and have added type form responses where the interviewer can type answers.

Next step is to ensure we help them take this to the field and then introduce, customise & train them to use Metabase for data visualisation.

2.Centre for Migration & Inclusive Development is a nonprofit advocating for and promoting the social inclusion of migrants and other socially disadvantaged populations in India. Their priorities include designing, piloting and implementing programmes for mainstreaming as well as improving the quality of life of migrants.

Our tech team conducted a thorough research and suggested ERPNext as the solution. ERPNext is an open-source tool which can be customised according to the requirements of CMID’s clinical workflow. It is also an affordable solution and uses a simple interface which does not require a tech team to handle the system from the backend. With this in mind, our team created a sample workspace in the existing healthcare system of ERPNext and presented it to the CMID team.

The T4GC team created a prototype with the patient workflow and added all the requested features by the CMID team to it. After this was presented, CMID team highlighted their additional requirements as below:

  • Ability to track the day, date and time of the patient coming in along with the location they are coming from. In short, they should be able to track patient history.
  • Ability to track the services taken by an individual who visited the clinic.
  • Ability for drivers to track parkings and registrations when the vehicle is parked at a certain locality as a part of HR/Payroll and Stock Management System.
  • They also requested to host their systems on an Indian server. AWS credit points were available to them and it can be used to cover the hosting charges.
  • Requested for a unique ABHD ID and a drop down field to be added for each field.

Currently the T4GC team is working on embedding the additional drop-down options into the healthcare system and also drafting a plan for the technical architecture. We are also working closely with the CMID team to help them apply and get AWS credits for hosting of this solution.

3.Anahata United Efforts is an organisation whose mission is to expand new age career opportunities to the youth in our society. They expand the awareness of various career opportunities not just by career guidance counselling but by closely monitoring each student’s set of skills and providing them options with career paths.

They have faced challenges with their data visualisation tool, including frequent payments for bug fixes and a substantial number of initial bugs in the platform. This proved inefficient for a rapidly scaling nonprofit who already works with around 4000 students per district. This also provides inaccurate data for reporting.

Upon our visit to their office, they broke down their requirements in accordance to their priorities which did end up being reshuffled after review. Due to the rapid scaling of nonprofits, it can be hard for them to decide on a method to carry output. Depending on how rapid their growth rate is, their change in requirement would be equally ever changing. By using open source software like Metabase, BIRT and others, it can be considered that they are frequently updated by a community of developers and have a strong user base that contributes to bug identification and resolution. Besides this, the process of migrating students when they pass 8th Standard to 9th Standard is an arduous process with which they tend to spend a lot of time on.

Metabase is a highly intuitive digital tool that displays visual representations on the data you provide. Users save a lot of time making graphs for specific reasons, Metabase however allows the user to pose questions in the form of keywords. Being open sourced, Metabase has faster bug fixes as there are 50,000 other organisations using the tool.

Anahata United Efforts collects data of about 8.2 lakh students in India, hence one of the main concerns they had about using open source software like Metabase was security of data. However, Metabase, like most open source software, follows strict permission guidelines and data sandboxing. Metabase follows GDPR and CCPA guidelines in order to maintain transparency with its users. They allow users to have a thorough view of what Metabase has access to. United Efforts are to host Metabase on their local server. Metabase can also send updates to team members within the organisation using Slack Messenger which allows users within an organisation to function smoothly as it offers transparency and free flowing communication on changes made.

The Tech4Good Community puts its effort into ensuring that nonprofit organisations check off all the boxes in their requirements for a specific tool. Nonprofit organisations like Anahata United Efforts need intuitive tools to visualise their own data in accordance with all the data they collect. Metabase allows for the freedom of choosing what you want to display productively. Our team works around the clock to ensure delivery of demonstrations and implementations are up to the mark, which is why installing and adding these accounts on our servers to demonstrate examples in relation to the organisation, has proven useful to display how beneficial the tool can be for them.

This is the first organisation that we have worked with to implement Metabase. So far we’ve used sample data to demonstrate the features and customisable aspects to Metabase. During our learning period with the Metabase platform we encountered a problem with regards to environmental variables on their local server which in layman’s terms are code buttons embedded into Metabase to help it perform in accordance with an organisations requirement, rather than changing the code of Metabase, environmental variables are placed as part of the elaborate plan for the future of Metabase. After thorough deliberation, we have decided to use MySQL to import their datasets onto Metabase via Amazon RDS. Amazon RDS was used because we had some credits in our AWS account which we wanted to initiate as it gives us user friendly operations and various features to play with the API aspect, which would help with further developments on Metabase. Amazon RDS is a managed database service by AWS, providing a scalable and reliable platform for hosting relational databases, simplifying administration and offering features like backups and high availability.

  1. Plustrust provides micro-incubation support for changemakers from resource poor communities, particularly from rural areas through our fellowship programs. Their vision is to create a world where all people – especially those from resource poor communities – have the opportunity to create an impact for themselves and others.

The first time we interacted with this fantastic organisation was at the Tech4Good Community Spotlight Series 2021 supported by EdelGive Foundation. Plustrust was one of the 100 NPOs who attended it.

From our Tech Maturity Assessment through this Spotlight, we found that 44% of nonprofits from this cohort used Microsoft Excel, Google Forms or Paper. Plustrust had been using Microsoft Excel and Google Forms and was making a move to a new MIS at that point in time.

Our next insightful interaction was on April 3rd 2023 at the Amazon Web Services HIVE event by Tech4Good Community hosted by AWS. Our team met with Lalitha Iyer, Managing Trustee and Priyanshi Sharma, Program Manager at Plustrust. We learnt about their interest in open source software and cloud hosting platforms as well as their organisation’s requirements.

A month later, we were thrilled to have the opportunity to present our FOSSFwd project to them as we saw the potential of using FOSS rather than their current system due to the problems being nullified.

On the 14th of May, 2023 the Tech4Good Community met with Lalitha from Plustrust on our first field visit with them. With a strong commitment to sustainable development and social progress, Plustrust works tirelessly to address pressing issues such as poverty, inequality and social injustice. To achieve this process, they’re in need of a better data management system to track and manage their women volunteer programs with which we recommended ERPNext.

We found that their requirement was for a data management tool and volunteer management system to track progress and success rates. They also require tracking aspects of various projects like tracking the selected participants in their Microinclubation project and what happens over the period of our engagement. Because of the number of varied objectives, they found it difficult to streamline this process on their existing software.

They also wanted an easy overview of how many are in the fellowship project and the ability to profile those who have completed the fellowship along with a seamless reporting system.

Plustrust highlighted the challenges faced by them on their existing system and how they would like to overcome them in the new system. The cost for using this platform is around 17k per annum including an approximate implementation charge of Rs.2000/- Below are a few other observed issues reported by them:

  • Frequent server issues with the system
  • Issues with demographics - Existing modules are not very precise and clear
  • These modules are also not editable and would like to have it added to the ERPNext system
  • They also want to generate MPR(Monthly Performance Report) directly from beneficiaries and update it instead of doing it manually which is their current system.
  • Unable to edit the forms available and lot of these categories are very confusing
  • Data sheet is not easy for them to analyse. Analysing their static and dynamic data is very difficult.
  • Though MPR is filled, they are unable to see the details when clicked on the module.
  • Programs and varieties of projects have increased and their system does not support their current requirements
  • Requested for a monthly performance review system to track the performance of their current programs

We also found that they needed to track the CHE (one of their programmes), which has shown to be very data heavy as they need to track the women based on various aspects such as skill development, treatment of clients and number of active medical units at their disposal. The system they were using, didn’t have the capacity to create dashboards when it came to visualising these elements from their work.

ERPNext is an open-source Enterprise Resource Planning System which could double up as financial accounting, project management, human resources and inventory management systems. It is a powerful tool that could potentially allow them to manage their volunteers, track their activities, and measure their impact. Additionally, ERPNext is free and easily integratable with other systems.

“ERPNext has shown to be much easier to use from the demonstration by Santhosh and Ibtisam (from the Tech4Good Community product and engineering team respectively). I liked the ease with which one could develop many drop down menus. The data we require, there’s a static element and a dynamic element and doesn’t require changing after that. We need to ensure that the data is more accurately collected and our systems feedback loop isn’t up to par. ERPNext has shown to be much more intuitive and easy to use overall. ”- Lalitha Iyer, Managing Trustee, Plustrust

This is the second project the Tech4Good Community has done with regards to ERPNext, our engineering and core team went through an internal capacity building training on this specific tool. The team took 17 working days to create a brand new workspace and demonstrate the prototype to Priyanshi and Lalitha. Plustrust had shared a document detailing the demographics and details they would then have to graft and filter from their teams, anchors, fellows and the CHE projects.

Our team developed and demonstrated the prototype for Plustrusts new ERPNext workspace and encountered a few challenges with regards to creating a new workspace as well as how to change the DocType. A DocType is what ERPNext uses like folders, to organise data in accordance to needs and the type of information it holds. They’ve added customised drop down options and a new workspace as the pre existing workspace on the ERPNext health domain wasn’t enough. Tech4Good Community’s product and engineering team spent a total of 72 hours working on the prototype for Plustrust’s possible new workspace. While looking for hosting options for ERPNext, we suggested AWS as a possible solution. Plustrust has an FCRA certificate, which means they are eligible for AWS credits. They are in the process of registering on BigTech.

5.Way for Life is a registered, youth-driven NGO, based in Bengaluru, Karnataka, founded in the year 2017. The footsteps of their approaches to community development and environmental sustenance have been ideated and undertaken by the energetic body of youth volunteers who write their story through reshaping ours.

A Volunteer Management System came up as a priority item during our conversations, since they did not have any system in place to manage this. They were using excel sheets to track the data of over 10k - 15k students from various universities. They stressed the need for a system that would allow them to track the tasks assigned to these students as part of their ongoing volunteer engagement programmes-the idea behind which is to provide them with opportunities to gain hands-on experience in order to build a career within the nonprofit sector.

We received detailed notes from Way for Life on the extent of customisations required by them. This was based on the previous paid system they had in place which came packed with almost all the required features and functionality. Team T4GC has been in the process of researching the replicable components of this system and eliminating the redundancies as we customised an open source solution for them.

As things stand, the activities and tasks of volunteers are uploaded in Google Classroom but it is not the most effective method to track assignments given the volume of volunteers. They would ideally like for it to be simpler. We presented Moodle as an option to see if a learning management system (LMS) would meet their requirements but the unavailability of any active courses from their end, made us eliminate the suggestion.

We recommended ERPNext as a solution for their volunteer management system. It is a powerful tool that could potentially allow them to manage their volunteers, track their activities, and measure their impact. Additionally, ERPNext is free and easily integratable with other systems. This makes it an ideal solution for Way for Life.

In order for us to build a prototype, we had to request access to their registration forms including student registration forms. We appraised the existing data distribution & arrangement and are working out ways to embed these in one system, eradicating the need to switch between systems.

Way for Life also wants the reports to be visible to the students’ respective universities and the ability to track their volunteering hours & attendance. The option to track their assignments and a function to assess and review them is a priority requirement .

Team T4GC has requested for sample data to explore these solutions and build a prototype based on it for the volunteer management system and grant management system. We are in the process of customising & creating a new Workspace on ERPNext for them.

We are working with 15 other NPOs as part of our FF initiative. More on them in the next update.

  1. Mentorships

As an extension of the sessions in the Spotlight Series, several organisations in the cohort had signed up for customised 1-1 mentorships on tools like Trello, Google Ads, Google Earth and Google Analytics in partnership with Atlassian & Google.

Google Ads: Public Health Foundation of India, Sarthak Foundation, Madurai Health and Leprosy Relief Centre, Transform Schools, YCDA - 5 NPOs are being mentored by Googlers as part of our Google4Good initiative on understanding their usage and to improve the efficiencies of their Google Ads account.

Google Analytics: 34 NPOs are currently in the process of getting mentored 1-1 by Googlers. They have two sessions per organisation: one to set up a new account/help migrate the NPOs to the newly updated Google Analytics - GA4 from the previous Universal Analytics accounts and a second session to understand the setting up of their organisational goals to analyse their website traffic.

Trello: CMID, Yuva Rural Association, National Institute of Women Child and Youth Development, Swmrt, SeSTA- 5 NPOs have been mapped to 1-1 mentorship with our partners at Atlassian to help with the set up and using the Trello project management software.

1 Like

Overall updates

Hello everyone,

Here is what this month’s update is looking like from us at Tech4Good Community.

Team

Our Engineering team is now 5 members strong with 2 new hires; an intern and an engineering manager.

FOSSFwd

  • With great enthusiasm, we announce that the FOSSFwd Grid learning events will now be a regular part of our initiatives. These sessions will provide a platform to share our experiences, best practices, and insights into FOSS implementation. By hosting these events regularly, we aim to foster a vibrant community of like-minded individuals and organisations passionate about leveraging technology for social good. Our FOSSFwd programme has solidified the importance of open-source software in making a real difference.
  • These events aim to showcase our significant work with nonprofits and system implementations while promoting the power of Free and Open-Source Software (FOSS) in driving positive change.
  • During the event, we had the privilege of hosting four incredible nonprofits i.e. Agro Rangers, Way for Life, Anahata & Plus Trust, who showcased the systems we built for them and the significant gaps these solutions addressed. The event served as a powerful platform to highlight the real-world impact of our FOSS Management Systems implementation and how it has been instrumental in driving positive change in the nonprofit sector. Read about our work with each of them here.

Also, here are some key learnings that have been fundamental in our journey:

  • In-Depth Understanding: Our product and tech team delved deep into FOSS management systems, particularly ERPNext, gaining invaluable knowledge in code refactoring, doctypes, API integrations, and more.
  • Code Customization: We learned the art of customising FOSS code to cater precisely to the unique needs of the nonprofits we serve. This flexibility empowered us to create tailored solutions for their success.
  • Data Engineering Expertise: Handling large data volumes taught us data migration, validation, and transformation techniques, ensuring top-notch data integrity throughout the process.
  • Hosting and Infrastructure Management: We honed our skills in hosting FOSS solutions on platforms like AWS, creating scalable, reliable, and secure environments for nonprofits to thrive.
  • Synergy with Other FOSS Tools: Exploring the magic of tool integration, we built comprehensive ecosystems by combining different FOSS solutions, unlocking endless possibilities.

FOSS United- Goa Meetup

The idea for Goa FOSS came at one of the first OASIS meetings where we met the FOSS United team. Given our presence in the state, we gladly supported the commencement of the first-ever Goa meet up, with the vision of hosting many more in the future.

This community-based event was a melting pot of ideas, bringing together students, professors, policy makers, journalists, developers, designers, and nonprofits with a common mission - to explore the transformative power of Free and Open-Source Software (FOSS) in shaping India’s future.

The highlight of the Monsoon Weekend was an engaging panel discussion titled “The Role of FOSS in shaping India’s Future.” Esteemed panellists from diverse backgrounds shared their insights, inspiring attendees to envision the untapped potential of FOSS in driving innovation, sustainability, and positive social change.

Panellists included- Vipul Siddharth, Open Source Technical Advisor, UNICEF; Frederick Noronha, Journalist Rinju Rajan, Co-founder & CEO, Tech4Good Community; moderated by Vishal Arya, FOSS United.

The event is a testament to the growing significance of FOSS in India. It reinforced the importance of cultivating a strong FOSS community and highlighted the potential of collaborative efforts in driving innovation and positive social impact.

Spotlight Wrap Up | Google Analytics Mentorship Program

The Tech4Good Community hosted one of the biggest Google Analytics 1-0-1 mentorship programs which is almost nearing its end in July. After our Spotlight Session ‘23 which was conducted in March, 35 nonprofits from various domains signed up for this program. T4GC partnered with Google and allocated over 35 individual trainers for each organisation to help the nonprofits with GA setup and GA4 migration which was scheduled to automatically happen on the 1st of July. All the mentors were trained by the internal Google team through a “Train the Trainer” session to equip them with enough information to assist the nonprofits.

We split this cohort of 35 organisations into 3 categories:

  1. Nonprofits who do not have a Google Analytics platform
  2. Nonprofits who have an existing account but were not aware of its usage and GA4 migration
  3. Nonprofits who have an advanced existing system but needed training on a few specific features.

The program’s key aspects and learnings are as follows:

  • Website Traffic Tracking: Nearly half of the enrolled organisations sought assistance in tracking website traffic, including landing pages and additional links like newsletter subscriptions. Google trainers guided them in setting up tracking mechanisms to monitor user visits, revisits, and enrollment in subscriptions and newsletters.
  • Conversions and Reports: Nonprofits recognized the importance of tracking conversion rates and generating reports, which was facilitated through the mentorship program. By analysing viewer counts, they gained valuable insights to make informed decisions.
  • GA4 Migration: The mentorship calls successfully completed GA4 migration for 21 organisations ahead of the scheduled date. This ensured data backup and prevented potential data loss during Google’s update.
  • Round 2 of Mentorship Calls: Due to additional requests, a second round of mentorship calls is planned to address remaining doubts not covered in the first round. The program is expected to conclude in the first week of August, benefiting over 30 organisations with effective use of Google Analytics.

Spotlight Wrap Up | Engage4Good Programme

TheTech4Good Community partnered with Atlassian to cultivate a cohort of enthusiastic technical mentors who are active in assessing the requirements for Nonprofit Organisations across India. The 2023 Engage4Good series was in collaboration with 2 NPOs namely - Vihaan and IIPH.

Vihaan is an organisation that actively breaks the cycle of crime - human trafficking, while providing rehabilitation and communal support to survivors. They provide free education for the survivors till the 10th Standard after which they extend their support by ensuring they complete 12th Standard with financial help provided by Vihaan. They reached out to the Tech4Good Community looking for a Project and Participant management systems. Their main goal was to improve their monitoring and evaluation for their education platform.

IIPH is based in Delhi and they are academic institutions of higher learning established by the Public Health Foundation of India (PHFI). We have engaged with the Public Health Foundation of India through our previous Spotlights in the years 2020 and 2023. They were looking to revamp their website specifically for IIPH and all the various establishments in the Education sector.

More on this in the next update!