 Okay, good morning everyone. Welcome to 314 our course on media and technology could somebody please pray and Then we will get started Anyone could unmute your mic and please pray with a class Man, thank you All right, so We are coming close to the end of this course. I we have just two main topics left one is software platforms Which I'll just kind of run through today. Just It was an idea now of software but platforms that we could use for the ministry and And then tomorrow will be the last chapter, which is a little bit on data protection and privacy just share a little bit on that and I'll just do a quick run-through or overview of everything we've covered in this course on media and technology and ministry and Then what we will do is I will Just post a simple assignment. It'll be a non technical assignment So it's don't get worried. Oh, am I going to be asked technical questions? No, no, that's not the purpose of this course It is it's just a purpose this course just to expose you to you know, different things that are available there In in media and technology, so it'll be a non technical Assessment just to make sure that you followed along through this course. We'll post that After next the next week or the week after and it shouldn't take you more than two hours to finish Okay, so we are most likely going to be done with the course content For this course tomorrow. I will see how things go, but most likely that's what's going to happen now Last week There were some questions about costing, you know, how much do things cost so I just went and you know I got that information from our team So I've shared one PDF Which is This PDF I've shared an addendum Which gives a costing of Audio equipment If you wanted for an auditorium with 500 to 1,000 people so this is kind of what We have so I'm just giving you the cost now all of these are in Indian rupees So depending on you know, whichever country you want currency you want to convert it to so please convert it to That I thought I'll convert it to US dollars, but you know, I'll just leave it as it is So I just shared this PDF. This is all you know, what? What the cost is in Indian rupees if we were to purchase these things locally? And you can convert it to the currency you want, but this is let's say this is what we have Currently in use at our main location. So all locations don't have this It's in our main location, which we call a central That's where all these equipment is being used and that's what it roughly costs right, so It is little more than what I had mentioned when Elisha had asked me the question I'd given him a modest thing for just you know a smaller set up But this is something a little bit more elaborate is what we're using now. We we didn't start like this, right? When we first started 20 years ago, it was very very very simple We had three simple mics and one small mixer and two speaker boxes That's it. So when we actually started it was very very very basic very small and so You know over time slowly we upgraded. So what this is is, you know, we're in a little bit more mature state Place so we can afford to have something like this, but we didn't start like this Okay, just to keep in mind so don't if you are starting your church a ministry don't get Discard it by seeing all these equipment. It's oh, I can't you know, I can have all this right now You know, you know, we never started with this. We got we came to this only more recently Okay, so that's the first thing The next thing was another question was on the video equipment that we use I just went and got the again the the costing of it. So I'll just share it. It was just, you know, the line items I'll just share it in the Chat here So for our I mean and again this these are local amounts. Okay, these are not, you know But you can try to see what it cost you in your place But I said, you know, we we went three cameras So each one Of these cameras that we rent sony fx6 with the video tripod and the camera is about 6,500 rupees We pay And then also we rent The led wall so actually we have three Sections so you don't need to have that much but we have a big LED wall at the back and then we also have two on the side So that people can see clearly because of the the way the auditorium is So for that we spend 22,600 approximately Again, these are just numbers from here locally And of course it doesn't this cost doesn't include their local transportation and And the labor charges, you know for people to come and set it up and all that but this is just the rental cost of the equipment so This is to give you an idea. I mean whether these these numbers these numbers obviously will not make sense In another place. I'm just sharing with you What we are spending But probably gives you some indication So we rent these things and Person they cost is so much But I think overall it serves well because you know people need to be able to hear well They need to be able to see well and plus Now we have audience still now even though you know pandemic is More or less gone and people are back into in-person services. We still have a good number of people who connect online to the live stream and who also watch the video after that So having a good video production is useful for them And so it's worth spending money on the cameras and so on So that's just to give you an information on that Um, so today what I want to do is just to quickly share with you this Part on software platforms that you could use for your ministry Night and again, I'm going to just run through or let me just Sorry, I think I just should share my screen One minute I will share my screen so then I can move across to Yeah so um, what I wanted to is just uh, you know In the work that we do As a church or a christian ministry, it's good to make use of software Platforms that are available for various things and It's good that wherever possible. I'm not I understand that Not every church or every ministry can make use of all these things, but I'm just sharing with you What we do what we use and you know, if there's things that are relevant You're most welcome to make use of them at least you're aware of these things so now All of us are familiar and using software for our regular office work, you know a lot of work that we do today is making use of These office productivity Software where they use microsoft office suite. Oh, you know word spreadsheets part presentations emails Or you could use a google suite of tools Which is free So either one, you know, it's fine, but it really helps if everybody is you know, it makes use of these tools for email for documents for calculation of spreadsheets and presentations and all that I think it's almost like a given these days that people who Work in an office environment are good in these things. I'm familiar with these things. So That's a good thing to do Make sure that in your church or your ministry You have people trained in these things and then everybody agrees to work, you know in this fashion using Documents and spreadsheets and so on Secondly We use in accounting software Here in india we we we use what is known as tally You may use something different in your part of the world But this is for Of course managing your finances the finances that come into your church or your ministry. So make sure That you do use an accounting software and I think some of this we covered last semester when we talked about church administration so Uh, make sure you you know, you're you're all your finances attract and managed in Relevant software system accounting software for your organization The third thing and now, uh, I want to just mention here that Uh, what one of our our approaches has been to use open source software meaning Uh, very very possible. We try not to pay licenses but use what's available open source and then we host it and you know, so we just Uh, our expense would be the hosting part of it. We we hosted ourselves And so we can fully have fully control and be customized the product as we need to so that's been our approach Uh rather than paying licenses and you know, that's a good thing because you can save a lot of money Uh are using these open source products So a lot of the things that I've mentioned here are actually open source products And you're welcome to you know Get them for your own church for your own ministry Uh, if you have a few IT people who can help you out, that'll be very useful So I will I'll just mention these and then I'll walk you through it. Some of you may be familiar with it So for managing other people, uh, this is meaning our church people our congregation We use rock rms. Um, and I've shared this with you before but So I just give you a quick intro on that Then for our staff management that is this is to manage our church staff and consultants people work for the church We use a hrm we use human resource management software So that is to it helps us in a number of things Record the time the hours of work so people are going to get paid for leave We are right now also using it for our recruiting So the person who's kind of handling recruiting puts in selected candidates into that and then from there I pick it up and you know the interview process goes forward We it also has capabilities for Performance review. We are not using that feature as yet, but hopefully We'll start using that as well. Our reviews are being done, you know and independently of that But the human resources management software helps you take care of your church staff And again, this is an open source product Project management management is if you want to run projects and this is typically for the it team to manage it projects Of course, it can be used for the projects as well, but this is mainly designed for that For running the various it projects and that's Again an open source project Websites all of our websites are built with jumlah Again, it's an open source content management product Tertab runs on custom church apps We will probably you know likely be building our own but we're using this Hosted service provider Our e-learning platform uses an open source Software called open edX that's where all our e-learning courses run on Website analytics uses an open source product called matomo matomo That's again something I've shown shown you our Email lists ever uses another open source product called php list We also manage our inventory um We That is we track all our all our assets Actually, there are two ways you can I mean I mentioned an open source ERP product here but we actually use A different product Which I will I will show you I'll just give you a demo of that Then for as a repository, which is We just started doing this we want to you know document all our best practices we want to Have a central repository for all our document artifacts and other things So we are using bookstrap app We just set that up And church metrics is for us to track you know church attendance and so on so forth so All of these are free now Of course, there are there are trade-offs meaning, you know, somebody will look at this list and say well, you've got so many different Software products running. It's a big. It's a challenge to maintain it. You know, I agree that Having you know, so many different systems running is a big challenge. I understand that um Then you know the other the the the common Comment would be why don't you use one? One what is known as an enterprise resource Planning just one some one unified software platform for all of these things So what I mentioned there? Odo.com is an enterprise resource planning system, but it's not it's not gear towards church Work as such it's more for a corporate organization type thing so You know, we had to decide do you want? the best in breed for certain Things that you want to do or do you want a very generalized corporate software then? To try to customize it, you know, it's going to be a challenge So we've taken the second option, which is Let's use the best in breed For specific things that we want to do Yes, it means that we'll have you know eight or nine different platforms running but at least we get the best things that they afford to give us Rather than something that's more genetic as an ERP. So that's our approach And I'll just quickly show you what these things are so you could Just get a feel of it and I've given you the list the pdf there so In case you feel you know in case you feel like Your organization your church would want to use any of these things you can always Go there And you know use any any of these things If you want to make use of them, okay, so Again just to reiterate Other than you know microsoft office and The accounting software Everything else is open source meaning it's free. You can have your own installation of it You don't have to pay for the software So you can take it set up for your church or your ministry and customize it the way you want it So that's a big plus, right? So I'll just quickly give us a little overview Some of these things I may have shown you in the past So forgive me if there's a little bit of overlap or repetition But I'll just give you an overview and then we'll be done With this. Okay, so you just get a look at Look at these things All right, so our hrm It says where this is the human resource management software that I was mentioning Basically when you log in You know, this is where so this is an administrative view. So I've logged in as an administrator Uh, typically people, you know, they report their their time sheet here. I haven't filled up my time sheet for the last couple of days but generally, you know, we we we report our work hours here and then Uh, you know At the the monday of every following week people usually submit their time sheets And then we have our admin person approve them go through them so on but you see there are A lot of things that can be done here people apply for leave here We can see who's applying for leave Our recruitment process happens here We can see, you know, so these people are kind of going through the recruitment process or Maybe we've got some of them. I've you know, some of these positions already filled but So candidates come in here and then we go through the take them through the recruitment process We can maintain a directory of all our staff here Performance reviews could be done. We're not using this part, but we will start using it So we can do stuff performance reviews for our staff Um, uh, people also can submit their expense claims. That means, you know reimbursements They can submit it here. So it has all of these features typically to manage all our Uh staff, right? So that's the uh hrm here just a quick overview of it But it really helps and then of course if you want to have some communication happening We don't use this but it is it is there if you want to make some announcements and so on so forth This this information is useful. Okay So, uh, this is our The orange hrm which I mentioned is a free open source software the This is what we use uh for Asset management, right? So I'm not logging into our actual product because if I log in there, you'll be able to see all our license numbers and Other information, but I'll just show you this demo of the product. It is what it generally look like so So basically you can you know, we like we said we buy all these equipments we buy licenses for certain software, which is like for graphics adobe Adobe Microsoft and some maybe a few other software that we need licenses for But we buy a lot of assets. That's you know, all our hardware computers And so on so we need to track them. Where are they? Who has it? Or what is the model number and all so we use Uh, this asset management software looks like this. I'm just showing you a demo But if I log into our account, you would you know, you probably would see a lot of confidential information so But we track all our assets here and we know where it is. Who's who's having it? And so on so that's what happens here and we try to maintain our inventory. So every three months we Do a check And update, you know, okay. This is where the the product is or that Microphone is or that camera is or that laptop is but even with all that, you know, it is a challenge Keeping track of things because we have so many different locations and events happening that these products keep moving, you know, different places and It's it's it's real challenge to keep track of things so that things don't get lost But we we use this to track So Repository All right, so this is the repository. It's actually it's actually book stack app But this is where we are we just started doing this recently Is where we try to We or our work we're working towards Maintaining a center place of Keeping all our documentation best practices across various ministries, so So it's you know, not everything says so it this is the other concept is bookshelf So every ministry is a bookshelf. So you see accounting bookshelf bible college, you know, they all have a bookshelf And within them there can be many books So, you know, this is where we would write All our details and the book can have many pages So This is the database of all our vendors. So this particular vendor database will have all the vendors for you know different So these are approved vendors so anybody can go in there look up the vendors. They'll have their contact information And if we need for any event we need, you know, uh, I need to call somebody. Okay, you can call them and so on So that's what This whole thing is and we are we just started working on this So all the ministry leaders will have to you know, put in all the information, but Everybody has access to it. So they can go in Read make use of the information And and so on. So this is our repository Okay um I have turned to our church management system e-learning all of you are familiar with e-learning which we Use this our online portal. So we are using open edx for this Uh, this again a free software. It's hosted on open edx and this is that's how this is set up I think most of you are familiar With the e-learning part um church management Yeah, church management system So this is actually built on and a free System I've shown this to you before where We uh, you know, we have uh any log in we have people's birthdays and so on and We can you know, look up people's information here And contact them to keep track of our interactions with them people from the church and so on so this is Built on rock rms Again an open source product. So we track people and it you know, it's only people who Are actually doing member care and so on who have access to this Right and then from here we generate, you know, we could generate reports We can extract information Based on location and so on We can pull data. So if you want to send them an email, we want to send them a WhatsApp message We want to send a target group, you know, certain Usually an email or so on so we we can extract information and target them here and and so on So this is the church management system That we have Yeah Okay projects So this is what I said we Would use for our it projects. We Are not actively using this at the moment. We're going to start transitioning here So you could list out all your and this is mainly for it We could list out all our it projects here And then we create tasks Classroom we haven't used that for a while, but you can you know for each project You could create tasks and then You could assign the tasks to various people And you know and then follow up on those tasks and those Activities and so on so we haven't really actually started using this. We've got this setup But you know we're in the process of building the ed team and allocating work and so on so right now It's it's more of because the team is small It's a little it's just the communication three emails and so on but our goal is to move the whole team to work using our open project to manage our teams and our Tasks and so on mainly for the itt and they'll be working on all of these Different projects that are going on Which basically is for the itt Yeah I think that's covered most of that Yeah Let me see anything more in the pdf that I needed to cover Yeah Yeah, that's it. I think I've shown you most of the Products that we are using Any any quick questions So this is to give you an idea of look you can have these software packages installed for your organization or church and you can use these things for various Functions are things that you want to carry out Any quick questions that you have on this? Okay no questions all right, so Bill I think that's that's all I wanted. I just wanted to give you an idea of software platforms that you could use Okay, Elisha's question. Are these free to use app or yes So Elisha in the list in the pdf that I shared with you Everything after the accounting software so even you can get free, you know open source accounting software But we are just using we are using a commercial software for our accounting package because it kind of picks into account the The local Indian government Regulations, which is a little difficult to keep up with so that software help package helps us take care of that um Other than that all the others that I've mentioned in this list are free open source So you could download them You know from the I've shared you the links of the websites where you can download them from And whatever you need you can have some people set it up for you And then you can customize it for your organization, which is what we've done So we customize it and we put it to use for organization So almost you know After the accounting software everything else is open source and it's free So you can download and use them so if I were to say you know, it's good to have Especially if you're a local church It's good to have something where you manage all your The information of your church people You know So if rock RMS is one that you could use it's designed for churches And it's an open source product so you can take it and customize it use it A paddle to that of course is what you know in the industry in Industries the user The user crm a customer relationship management software, but then it's not tailored for church You can put it to work But since you have a product that's built for church rock RMS It's useful to take that and use it So I'd encourage if you have a few people who can help you I'd encourage you to set it up and use it for your church You know any once your congregation goes above 100 people Then it's very difficult to track people their birthdays their anniversaries how you know using spreadsheets and You know, but if you have something like A church management system it makes so many things easier. You can track you can put comments there You know that the last time I spoke to them This is what they said and so on and And if you have multiple Pastors and people working at least you can see the comments So when I look at it, you know when I look at a person's information I just look at the comments and see that oh Somebody from our church spoke to them on this day And they made this request. Okay, so I get a quick idea of okay. What's going on? So that's very useful So Christopher's question do these software support multi site multi country So the church management software. Yes, it's you know, we have people For example, we use that same thing for all our bible college students So all our bible college students data is also in An installation of rock rms, which is people from all over the world Or many countries of the world So that's so the answer is yeah, the rock rms supports it And the other software also, you know, like for example hrm You could have people from any event the world access and support work on it Yeah So all all of these products can be used From with global access Yeah, so you're hosting it online. They access it from anywhere Yeah, any other questions High level. I know this is very high level, but You know, I thought I'd keep it simple. All right Um, so keep this list handy with you the list of products Um Whenever you feel at need You can go back to this and see if any one of these products are useful for your church or your ministry And of course you could always search online, you know, maybe Couple of years down the road. There may be better products available than obviously Use what's better and best And if anytime you need help You're free to email us, you know, we have our IT team people are there So if you have any questions you email us, we'd be happy to Share whatever knowledge whatever learning we have with you To help you in getting things set up for your church or your ministry We'd be happy to point you in the right direction and assist you so Feel free to reach out, you know, whenever that time comes you need to set something up Uh, we're happy to help Okay so Christopher, what are typical website analytics are captured? How about social media metrics? yeah, so you know, so mutt more is Is one of the best so other than google analytics. So we have google analytics which tracks all our databases That's not all our websites Sorry, so google analytic analytics is already Um, all our websites are There on and it's being tracked by google analytics in addition to that We have our own installation of matrimon where It also tracks and gives us information on what's happening. So there are two analytic products that are tracking what's going on on our website Okay, so your question is What are the analytics? So what we I mean, uh, actually to answer your question There are just numerous data points that are being captured Perhaps I should say a lot more than what we even look at Uh, typically, right? But what is of interest to us would be uh from what mutt more does is okay, which countries How much time do they spend? What are the main pages they're looking at? And maybe what devices are they coming from? So this would be of interest, you know, so For us, okay, these are the countries people are coming from this is where they are going How much time they're spending so but there are lots of other data points that are being captured which Actually data. We are not actually looking at On the google analytics side. We also get a report on the performance of our website In terms of hey, these links are broken. These pages are not rendering well. They're not showing up well on the mobile Etc. So we use that to keep improving our website So for each of our website google gives us that report So which we can see uh, because example our our church apc website has like maybe several thousands of pages So we can't do this manually, but it's nice that we get a report through google A search console that this is how the website is performing. We also get a number of We get other information like how many clicks came through this month. So month on month we can see Where what were the search keys searches for which the website was shown? What are the pop searches for which you know a particular webpage was shown? So that's interesting for us And Where did they come from, you know what device? What search obviously they're searching on google, but what device were they searching from so But these are just a few of the data points. We're looking at but google gives us a lot more information Which we actually don't use About social media metrics. Yes. So youtube Facebook have their own analytics pages Which we can see Again over there what is of interest to us is how many people which countries And also how long have they been looking at so every I think every monday I would get an One of our it people informs me Okay, for the live stream yesterday. These were the Number of concurrent users live users who are watching um And then of course, there are a lot of people who would watch afterwards Of which we will see But that gives us, you know, okay almost like our live stream attendance That means these are people are actually attending the service live Which we can see And then we also have the numbers for those who watch it afterwards But every monday we take a look at How many were actually watching us live and we see that okay, that's the average Of what's happening on youtube facebook twitter So on So that those those those metrics We take and we observe we track them we follow them Yeah Any other questions Okay, so That's that's about it for today Tomorrow, uh, what I'll do is in this in this class. We'll just have a you know short five ten minutes on data protection just keeping information secure And then I'll just do a quick run through of all that we covered in the course on Media and technology just to kind of give us a full picture of all the different things we spoke about So that you have these things in mind. Uh, it's not something you have to memorize or you know You're going to be tested on technically no Just so that you know that these things are available And as and when you find a need in your ministry you start using these things and You're welcome to reach out to us In the future If you need any help and you'd be happy to guide you right So with that let's close for today Uh, somebody could pray and dismiss us, please Who'd like to pray? Okay, go ahead Sorry, Elisha go ahead And I really further once again You want to appreciate you and thank you for your great love We thank you for the gift of life and we thank you for the opportunity To have engaged in this class. We pray that oh god Whatever that you have been taught May it be recalled whenever it is needed in our ministries and in our service to you We pray that you continue to keep us until we meet again in Jesus mighty name. Amen Amen Thank you everyone Thank you for patiently enduring all this I hope these things are useful In the days to come. Okay See you all tomorrow. God bless. Have a good afternoon. Good day