 the recording. Let's take a moment to pray together and then we will start. Good. One of us pray. Now maybe whoever has a mic, okay. Could just pray and then we will start please. Kanan, yeah, mic is okay. Wanna pray? Or Dave or Karen? Karen, why don't you pray and we'll start. It's us. Okay. How do we come before you're thrown? And we want to say thank you for the good for everything. Thank you for the good. I will give you wisdom and knowledge for the good to the subject that we can understand and and use to the kingdom and guide for the good. Thank you. Rest of the time submitting to you and take care of what you say. Thank you. Thank you. Good morning everyone. So we are now in our almost our last section in this course on media and technology. So this section we're talking about technology systems or software systems that we could use technology platforms that we could use. And I'm just giving you an overview and I will put everything down in a document shared with you. But I'm just letting you see some of the systems that we have been using which we can use for ministry work. So we started last week or we spoke about software for office work like basically using Google personal productivity tools. The Google apps that come for free can be a very good starting point. Then we talked about I made mention of our accounting software that we use, Tali software which we use in India and there could be other systems in other parts of the world. And then we started talking about the software for people management and for that I was just showing you what we were using for what we were using here for people management which is the rock RMS the rock relationship management system which we have customized for our use and we call it the church management system. And so in that we have all the data all the information of church people as and when they come to church or get connected to church we have their data and then from there we follow up with them we can work, follow up with them, meet with them interact with them so on so forth. So this is a very useful system to have and I just wanted to just share a little bit more on what we do so and then we will move on and do some other things. So let me just you know I'm just walking you through the system itself to get an idea. Of course I will mention in the document that I give you I will mention the product so that you know at some point if you want to use it you can download customize it but let me just show you some of the things that we do with this. So this is our and this is the church management system which I had we were talking about last week which I was showing you and you know I was just saying okay so you know I chose you the list of people who have birthdays even there's one Bible college student here who's birthdays today and these are the people so I can wish them and we have member care people who will greet them on their birthdays sent them a message and some very important are the useful things that we set up with is you know we have our first-time visitors information so when people this is some test information is happening but so what happens is the way we've set it up is from our church website so if you go go to our church website and we have a first-time visitor form you know so we tell people you know you could if you're new to our website or you're new to church please fill up the you know a form simple they just give their name the email ID and so on and they submit so what happens is so it's a simple form that we have on our church website right APCWRG connect first-time visitor so anybody could fill it up maybe somebody just came to the website or you know during Sunday service we tell people and if you're watching online please go fill up this form so they can fill it up and that data comes right into this system right and it comes to our ftv list right and so what happens is we can see the data here nothing these are just test people here but there are others who've put in their data and you know over time we have the data and then we have we have our person in the church office who can actually they will follow up with this data right and they can immediately on Monday Tuesday of the week they can go in they can make the calls to these first-time visitors so that's something very useful that you can do when you you know when you have a people management system you know so there is no so basically what I'm trying to say is that you can integrate that people management system to your church website just like what we've done so that it goes directly in here right now like I mentioned last time our the same church management system is also used for our bible college so even our bible college website so if you go to our bible college website where we have right now it's off because we're not taking applications but we have an online application right so usually there will be a button here where people could apply online so we will open up that button and apply online button say in the month of maybe around June or something so we will open up so okay open June 1 so June 1 to July 15 people can the application to be open and so when they apply here again when they go to the application form that whole fall and data go straight into rock RMS right bible college so their data will what did I do here yeah so their data will go into the applicants of course there's nothing now right now because we're not taking anything but their data will come in here and it'll show up here once we open up the application so once again what we are doing is all data is going straight into that management system so we are you know there is no paper form so we used to have paper forms some years ago maybe before we had a bible college website so people had to fill up an application and they would mail it to us so they will come and give it physically in the church office and then we have to store it somewhere and all those kinds of things so it was all paper driven in the past but then now from our website and may people make application it goes straight into the same system but it is it is you know it is categorized in a different way so these are bible college students these are first time visitors and so we have them you know separately we can go and look at these lists and work with those lists separately right and the other additional thing is that we can do is when now just one side note this e-learning portal is a separate portal we will we will I will discuss with you about that software itself that's a totally different thing the if you go to our e-learning portal this is our e-learning portal now when people sign up here that data is maintained in this e-learning system itself because you know it tracks you know everything like every course that they're doing and gives them their certificates for each course and all that but that their data is also connected back to their bible college student data because the same student could be studying here on the e-learning portal doing the course here on the e-learning portal and some students may also be doing you know maybe doing online classes on but there's the same student same email ID which they can use I will talk about this one a little later right so right now I'm talking about our church management system and what I was saying was this system can be connected to various websites like our church website our bible college online application uh data coming from the e-learning it can all come into the same place so that you can manage personal data people data in one central place right so it's very very useful the other thing is when people are it can make life easier for people when they are applying for not applying when they are registering for events so for example you know we have an event so let me go here we have a workshop coming up so christian professionals ministry workshop somebody wants to register right if they enter their mobile number I can pull up their data so double nine example I'm just entering my so double nine so it should yeah so you see I entered my mobile number and my name my email address was defaulted already now we could of course we could of course default this and uh because I go on different church locations uh my church location this little thing but um the moment I put my mobile number I was able to retrieve my name and my email address right so it makes it really easy and of course there's a lot more information about you know in this but where where is this information coming from it's coming from this system here right so to help people you know it just makes this is a very simple example but you know you can you can connect to that same people data from various points and uh you could you know you could use it to make life easier for people in in in various situations right so this is just an example of registering for an upcoming workshop that I can actually pull up that person's data and help them in their process now of course if that person who's registering if that person didn't exist in this system our church management system of course we we won't there's nothing to show we won't be able to do anything with that but in the case where the mobile number is here we can pull up their data so these are some useful things the other thing that we are also doing is certificates you know from the church example uh water baptism certificate so uh when people register for water water baptism okay um we uh we we can uh so they they they register here let me say membership class yeah so for membership class when people register for membership class um what uh let me just talk about membership class and then I'll talk about water baptism so when people register so when people want to become members right they have to register they have to attend a membership class and so they register for their membership class uh and let me the same same thing happens uh but only thing is but this is going to happen on the 26th of March so people can register for membership class right so when they say register when they click register there that data comes in here so we know uh who is attending membership class so once they have attended the membership class we have automated their membership certificate that means once they finish the sorry once they complete all the membership requirements part of which is attending the membership class then you know we check that all the other things are all done then we can give them their membership certificate of course it'll go to them by email but it'll also be attached to their record in the system right so the membership certificate is now attached to the record in the system you know they in case they lose um the email or they lose a certificate it's always here for them uh in this system for them to come back and retrieve it and we we will give them access to it uh the same thing we are doing uh when it comes for water baptism so um if people so we do the same thing so if people register for water baptism they come here and they register online for water baptism we just had one uh two couple of Sundays ago two Sundays ago um they register here they enter the baptism consent form they register here that data goes straight into our system right and um and uh then from here let me see where not sure exactly where it goes um from here we're able to give them their maybe it's all already been processed i'm not able to see that separate list so what'll happen is it comes in here um as a list of people who have come for the water baptism once they are done then we uh give them their uh we say okay yeah uh we give them their we say yeah this person attended the water baptism send them their certificate so what happens is their water baptism certificate is attached to their personal record in the system and of course also emailed to them right so uh we we are using the system in many ways we are using it for let's say our first time visitor enters the data comes straight into the system it doesn't get lost anywhere uh when people are registering for certain uh like a membership class or for water baptism it comes into the system once it's done automatically a certificate is generated a pdf and is given to them it is attached to their record we also use that data for registering for events so when people want to register for a workshop or a conference now if they're already in the system it makes them makes it easy for them to register for those events so this data that we have collected and that we are maintaining of our congregation people and also people outside uh is is is being used in many different ways to serve the people better okay uh and uh whether we store their uh certificates whether it's membership water baptism where we also record interactions from our member care team when our member care team calls them we can record against them okay you know we call them uh this is what they need or this is what they said etc those those things are recorded in the system so later on when we look at it we can know what has happened and then uh like we said by the college data student data is also here and that is handled separately in a different way okay so this system the church management system is something very very useful uh some of the features that uh we are not using is one thing that you could you could track um financial transactions if you're able to uh you know maybe get notifications from the bank or or just record it manually we are not using that here because we don't track uh individual contributions uh at apc uh in some countries example the us uh they would track individual contributions so that uh you send them you know a tax deduct deductible receipt at the end of the year and they get tax benefits for it uh that this that's uh it doesn't happen here in india and i don't know about other countries but there are no tax benefits here so we don't track you know individual contributions or those things um but that's feature that's available here uh you can also form groups and um you know who uh you can volunteer team groups life groups all those kind of things you can form within the system and you know people could interact around that and uh like i may have mentioned it last time uh we have we have plans to enhance this system add our own features to this for job search for helping people exchange you know job openings and people looking for jobs uh also for marriage um you know just just profiles to maintain profiles and if people uh want to search or connect with someone they could do it and of course all of that will be done in a very uh secure manner right so the the thought the thought here is that with this system even you collect uh the data and maintain the data of uh your congregation people in a system like this uh a church management system there's a lot of good things you can do uh when in serving the people but of course one very important thing is we need to protect their data right so uh like like i mentioned last week only authorized people have access to the data and also different people can see only what we allow them to see right so that we control as administrators for the system now i logged in i have administrator rights so i can see everything i can see i can work with any group of data but um example is you can restrict what people can see by their church location so uh uh if you want to uh say that this person can only see data of people belonging to one particular church location you can restrict that uh if you you know so that way we have controls on who can see what kind of data and also uh who works who's able to work with what data and we can give them we can control you know whether they're able to update data etc can they export data out or not oh just one more thing i forgot to mention which i wanted to do was uh we also can generate uh uh data views we can also generate mailing lists okay i forgot to mention this so of a mailing list so you know we have we then we print books uh we send our books out for free by mail by post so we can generate mailing lists out of our system so suppose i want to generate give me all the addresses of people in Bangalore that we have we can generate that give me all the addresses of people in Delhi or people who speak Hindi so when we print a Hindi book that book has to go to people who speak a certain language right so we have so we can generate mailing lists by language which is what we normally do so the English book goes to people who speak English Hindi book will go to people who speak English Hindi like that so we generate our mailing list we give them to the people who handle the dispatch of our books they stick the labels we print the labels and give to them so they stick the labels on those envelopes send it to the post office and that's how it goes right so this again i just wanted to mention that we can uh you know use this data for mailing list generation which is very useful when you're doing you know in mailing stuff mailing things out that's very useful okay so i think that gives us an overview of the church management system and how you know how there are many users that you can put it to and of course there are you know you can come up with more ideas more thoughts on on what can be done but any any questions on this on the church management system and just managing people data and so on anybody has any thoughts any questions any questions on it all okay okay so consider consider using this it's a free free software thank god for the people who've made it and made it available to the body of christ globally so that you could download it and install it and you know make use of it for your church for your ministry and extend it the way you want it and of course like we said rock rms also has their own hosted solutions so if you don't have the people to do it for you but they can you know they have a paid service as well so they could host it for you and you could just use the hosted solution as well okay so yeah thank you i see your and your responses on the chat so the next thing that i would want to go into and i i have shared this with you is on the staff management right so we have the church management which is managing the data of people in the church or in your congregation or in your ministry so if it's not a church then maybe it is the data of your donors or supporters or partners in the ministry that also can be managed right so the same system can be used to manage partners or donors so that's one side but now how about a software that to manage people who are working for the organization right so i did i think i did share about this last year i think but we'll go through it again so generally we call this human resource management system right so that means you're managing the your employees your consultants people are working for the organization right and that is also very important you know you can use it for a managing activity and work you can use it for managing the leaves and the vacations that people take you can use it for performance reviews that means you know whatever frequency once in six months or once in 12 months you want to assess the performance get people's feedback and assess their work it can be done for that and a lot of other things basically managing the staff managing the people who are working for the organization there are a lot of things that you can do so i will share with you what we use or at least the the software that's available and that i would encourage you to use and this is not the only software product of course but there this is what we use so let me share my screen so the product yeah i think you could all see my screen okay so the product that we use is called orient HRM human resource management software it has a lot of features you know you can manage your people of course and then compensation dollar talent management etc and there is there is a free version available and then there is also the paid version available so of course we are using the open source version oh didn't mean to go there so we are using the yeah so we are using the open source version right so we have downloaded our own and we've set it up for ourselves but if you want you know they offer a hosted solution so you could you know you could use it use their hosted solution so on okay so this is what we use orange HRM.com so let's go to what we are using at ABC so we have set up under HRM so this is our installation our own installation which we use right so and so this is very useful from managing your staff consultants and so on right so all our staff people are working for APC all our consultants who are working you know uh hourly that means they're paid by the time they invest they all of them have their access to this system and uh and of course uh you know what you're seeing here is an administrative view because I have administrative access uh not everybody will be able to see this but I've logged in I have administrative access so I'll just show you some other things so what we do is we we have what is called projects right so basically um there are different things people are working on so different basically these are by uh by uh the role that people have so there's accounting there's the audio engineer the bible college you know so we we have all of these projects right uh that people can report their work against and then under each project there there is activity right so under bible college there is all these things these are activities so when I do a bible college lecture I'll report my time against this activity if I'm preparing for the lecture I will do this um if somebody is doing some maintenance work for the bible college they will report their time against this uh when we have a staff meet we report our time against this right so these are all activities under this ministry area which is bible college right so uh when we report our time right so for this we report on a weekly basis so we report against what we've done right so I've reported my time till Tuesday this week I didn't enter my time for yesterday which I have to uh which I have to do now um so what did I spend my time on this week on Sunday uh so this is the project I was ministering at Sunday service about four hours uh was there before and after the service so I spent four hours then on Monday I spent two hours I was doing some search engine optimization work I spent two hours lecturing at the bible college I spent about two hours preparing the Sunday sermon and I spent about an hour and a half um I was visiting some um this is buying the land that we're looking at to buy so I spent about an hour and a half to go see a land and so on so I spent about seven and a half hours doing that then on Tuesday I spent again some more search engine optimization work I did two hours for two lectures for the bible college at three hours on preparing the sermon and I did some other planning coordination work interacting with and usually I could enter comments to say what I was doing and coordinating some things uh for the church and so on so I report my time so like this you know everybody reports their hours so I have to enter yesterday's hours and I'll enter today's hours and so on and that end of the week I I submit my time sheet so for every week right for every week people have to enter their time sheet so this way you know one is it builds accountability that means we all are reporting uh what work we are doing where is our time being spent um secondly of course uh people get paid uh they're based on their work the hours so the uh the accountant at the end of the month looks at the hours and then all the consultants are paid based on the hours they work um and uh for all the full-time staff they have to work a minimum of 40 hours every week and then if you work more than 40 hours the extra hours in chunks of four you can take as compensation uh leave comp off and so on so like that you know uh this builds in some sort of accountability for all your staff and all your consultants uh on on the work that they are doing right so that's you know managing our time sheets then the other thing is about uh leaves right so we can when people apply for leave we can see you know I I'm seeing this as an administrator not everybody can see this um you know uh people apply for leaves and uh the the office manager uh she approves the leaves and uh of course our HR person also sees it he also approves uh he also can approve one of them will approve the leaves the system automatically tracks all the leaves that people are taking uh what type of leaves so you know people can take comp off or imagine sick leave ministry like a vacation leave so on so it tracks so every person or the staff is entitled to a certain number of leaves in each category every year so they apply for it they use up those leaves they can see what is their balance and so on so example I can see my leave uh between 20 um I should not say 2023 it should say yeah so if I look from 2021 one I don't know why it's saying it's not showing me that's right yeah so I I actually haven't applied for any leave so I haven't taken any leave but I can see my entitlement so what am I entitled to so this year I'm entitled to 20 days of vacation leave um six days ministry and so on and this is my compensatory off so I'm entitled to take 43 days off this year I haven't used any yet um so if I use any of these leaves if I use any of these leaves it'll get deducted from if I take a vacation leave it'll take it out of these 20 days if I take a sick leave it'll take it out of this or this this and so on so this is what I'm entitled to this year uh I but I haven't applied for any so that's why it wasn't showing anything there so I can see and uh any employee can go and see what you know what leaves they're entitled to take for this current calendar year so we work based on calendar year so we can apply for leaves we can see what it what it's um what it's done so or what what you can allow be allowed to take so so like this and then of course I can look up uh employee records um so if I want to um uh as an administrator uh you know we maintain people's information staff information in here uh they start date and date all those kinds of things so I can go and look up that information uh and manage people um so we can see you know everybody here we can add new people and so on so I'm not showing you that data but that's possible so we can manage our people here uh and their personal information so on their roles and what they're doing so on uh and then also performance reviews can be done you know uh you can do reviews of people uh put their ratings etc and we you know each each each organization can have their own way of doing it we have our way of doing it uh criteria and based on which we want to um uh review people assess people and so on so basically um this system this human resource management system uh is very useful to take care of all your church staff and consultants or your ministry staff and consultants and again the beautiful thing is this product is free you can download it and you can customize it set it up the way you want it and make use of it right so I would strongly recommend that any church any ministry make use of it and it serves you know serves many purposes not only does it create a sense of accountability you know amongst all the staff who are working but you know it's easy to manage you know who's on leave so I can I can log in and I can see now who's on leave at any time or when they took leave uh so on so forth right so in the dashboard typically I would see you know if people had applied for leave I would see it here um now and uh I guess I can see it here as well I think there would be yeah so these these are you know people have applied recent or so anyway so it helps us in a lot of ways as we all work together and uh do things together okay so I would definitely encourage you to consider setting this up for your church or ministry uh to manage the people who are working in the organization right so we covered two software systems today we talked about the church management system which is the product is called rock rms and then we talked about the human resource management system the product there is called orange hrm which we are using I'm not saying these are the only products but these are free open source products and that's why I would encourage that for your church your ministry for you to use okay any questions all right I will put you know I'll I'll make sure I mention these products to you in that I'm just putting a simple document together just mentioning the products at any time the future if you want to use you could go and download it and use these products okay so we'll stop here for now tomorrow I'll continue just showing you some other products that that and other software systems that we use which you can think of using for your church or your ministry as the opportunities arise in the coming days okay let's close we'll close in prayer thank you for turning the class and just you know just opening up yourself to these these things I'm sure it'll be useful in the ministry in the days to come right okay all right who wants to pray and dismiss us maybe Dave would you like to pray and we can dismiss I'm not sure we can't hear Dave um let's see if you're okay okay Kiran go ahead we pray Father God come before you turn once again and thank you Father God all things Father God that today we learn Father God thank you Father for thank you thanks help us to move forward Father God and apply for your faith in God let's talk that day it's a meeting to your hand Father for thanking you Almighty Jesus Amen all right thank you everyone so I'll see you tomorrow we have three hours together look forward to that God bless uh enjoy the afternoon bye