 In this session, we are particularly looking at what you have been able to collect, how do you put it together in terms of analysis. And we're going to use an app called the Events Report, and most of you will have access to that if you have access to that analysis, both here during the training, but also most importantly when you go back home. Because we are training you to go back and utilize your knowledge and skills to enhance the data use within your programs. We've seen quite good programs being designed, but analysis from it has not been really very well presented. So it's called an Events Program, and when we talk about an event from our terminologies on Monday, on day one, I think now you can be able to associate what an event is. In simple terms, let's just call it a report or that captures the data that you've entered in the different program stages, be it in the vaccination. So those different reports that you've captured and saved and synchronized is what we're going to be referring to as events. So in terms of our objectives here, we look to see that we can be able to share with you the functionality that is currently within the Events Report. I also want to share with you that we are taking a whole review of these events up, so very soon, probably maybe 2.38 or 9, you should be able to see a rich events report. So we're going to be able to share with you what functionality you can be able to do within the Events Report, as it is now with the current question of which we are using. A little bit, looking at the terminologies, again explain to you the difference between an event report and an enrollment report. And again, this is something that should be now on your mind in terms of how you've been going through that entry, what is an enrollment and what is an event, the differences. And so when we're doing analysis, these have to be very well differentiated and understood, not to be supplied by the kind of data that you will be able to see. And we'll see that depending on your selections around these two, you will be getting different results and we'll explain why that differs. At what point did you guys lose me? In the beginning. In the beginning? No, after the event reports, but you may proceed. Okay, sorry, apologies. I don't know what exactly happened, but yeah, so in the objectives of this, the objectives would be for this particular session we are going to be able to explain the different functions, what the event reports can basically be able to do for you in terms of producing some nice events reports that you can be able to present in your data analysis and use. Then we are going to be able to use this events report, explain the differences between what an event report is and what an enrollment report is. And again, this is where we will be able to see that, you know, we can be able to generate different results by selecting all the other parameters. But with the difference of the event and the report, the numbers may be different and we'll just be able to show that and explain why that is happening. Then we will be able to design with you to be able to design an event report. From the tracker data that we have been collecting. Then, most importantly, be able to differentiate the difference between repeatable stages and non repeatable stages. When we talk about repeatable stages, we are looking at a situation like for example, Emma been talking about how many lab tests are done. The lab results take was made repeatable meaning that we can be able to have as many lab tests or requests as we can in our program. When you take it to the school, it is as many attendances, the child will be attending school or the runner will be attending school. So you'll be able to use the same stage to capture the daily attendance or monthly attendance or annual attendance. If you take it to outside health wash, you'll be looking at probably maybe somebody's monitoring the cleanness of toilets, how many times it was clean or not clean on the different days. So we will be able to explain that in the events report and how this analysis can come out. And finally, we will be able to show you to show you data from the multiple tracker programs, how you can be able to combine these stages. For example, I want to know the requests against the test results. Those are two different stages and we will be able to show those differences. Then going to our introduction again, this is just basically give you an overview of what we are heading in. Some people's hands are tired and they are put them down, but it's okay. So we're going to be looking at how we can use the events report to be able to produce and to aggregate our data. For example, you've been collecting information about, you know, what type of test is required. You can be able to find out in your poll track instance or for all the clients you've seen how many have ordered for this test. So you'll be able to use this, this I will get type of report, which is here to be able to see that particular in this example is most what is familiar with most of you, both from this academy and what is happening back at home is the vaccination and the vaccination we've had so many different types of vaccines so you may want to find out how many people have received AstraZeneca or other types of vaccine that you have in the country. So you'll be able to get it and then you can even be able to get them by gender, by sex, so being a female and that's a good report that you can be able to click and get your report. And we shall take it also, you know, and as how many learners have attended school in this, in this period and so on. And then in particularly also surveillance and also doing some deep dive analysis and looking for errors, you will find yourself trying to generate what we call line lists or lists of the load that has been entered. For example here, you will be requested to at least give us all the people who have received AstraZeneca and have the second dose that would mean that you know, this probably somebody who has the people who have been fully vaccinated, the system will be able to allow you to generate this kind of list of the events report. We will also further look at, you know, whatever we can be able to generate can be saved and can be downloaded as the Excel, as the JSON, as XML and embedded into your other reports. And also, this being saved, some of you have been logging in, you've been actually into nice dashboards and so we will be able to see that this data that we got, the tables that we have been able to generate and save can be added to the dashboard. We will also further look at the events report, sorry, we will also look at that, you know, for you to be able to the event events report, everything will be based on the program so we will be analyzing that according to the program it would be a vaccination program it could be a TB program, it could be a runner tracking program, it could be your sanitation tracking program so whatever we have designed, we will be basing that to be able to run our events reports. And in these events reports we will be able to see the flexibility in terms of filtering and reading down to some particular data that you may be interested in. It could be for the purposes of, you know, identifying errors, also being able to limit or filter your data according to what the person, and this we look at data elements, you can be able to select what data elements and attributes you want to add into your system, which period, as you've all seen in the different periods, so you have, you know, fixed periods, you have relative periods, you do daily, and when you talk about periods, period I think you, if you all remember this is data that we are entering with a daily basis so we have flexibility to be able to run from a daily report all the way to the financial year reports, and also organization units or filters can also be applied here. And we have two particular types of reports that we can be able to generate, one is the event support and the other is an enrollment report and again I will show you and differentiate this when we come into the and finally, tracker program stages will contain events, if you remember from a model, these are the events we're talking about is a recall of what is being tracked, and these program stages again we probably may not have, some of you may be still really confused about why do we have program stages, why do we, why do we have so many program stages, the program stages really depend on so many different things that you, that your design considers, sometimes it's events which are collected together and you group them together and then you create a particular stage or there's a sequential flow of your data collection that you want to be able to harmonize into different stages and that stage, whatever is going to be there is what we call the program stages, and you will see the different types of outputs, events and reports, and this basically will become very, we will be well understood when we get into the program. Okay, so and we will see the multiple program stages as I said, so we're having like our program of the surveillance has quite a number of multiple programs and how we can be able to analyze that across the different programs. So let's say that's the summary of what we are going to cut now, and I can just now be able to take us to go now dive into the hand zone, which will be the step by step demo. Now, I'm just started as a disclaimer and a warning. I know all of us are itching to get to our computers to go step by step. It's been very interesting when you had the Android because the Android phone was in your hand, and the screen was being projected on the laptop or a smart display in your office. But let's be careful on if we want to follow step by step. If you don't have two displays, I would advise that you probably sit back, relax and watch, but keep attentive, and then you can be able to do some of these steps when we are done. But if you have possibilities of splitting your screen into two so that you can have one where you're seeing what I'm doing, and then you have the other window where you are able to go and practice that is also recommended. But otherwise, let's not get lost into practicing. Otherwise, you may find yourself lagging behind in most of these sessions. So we're going to go step by step and we're going to use two programs in this analysis. One is the vaccination, which is for me, which all of you are familiar with. It is where you've been registering a client for vaccination, taking all your details, their age, their gender, their sex and all that, and then go ahead into a program stage which had vaccination and enter what they have received in terms of the vaccine. What the dosing number was and then you schedule for the next dose and then you get to the second dose and you're so able to enter. So you have two events within every at least track entity. If you are using the two-dose vaccination or if you are using one dose, then you probably have one. And we're also going to be using the COVID surveillance program, which takes us into diagnosis, lab requests, lab results and outcomes. Okay, so for us to be able to do this, we're going to use the demo instance. Yeah, you go to the demo. I might be showing a different one here, but you go to the demo. And please log in if you want to follow, but if you're not going to follow, please keep watching the movie so that you don't miss any step. Okay, so I'm going to log in. And once I log in, as I said, we are actually in by these nice dashboards. And at the end of the day, we shall be able to see where this that comes from. So, at this point, we said we're going to use an app called events reports. So it's automatically exactly here, but depending on your arrangement, again, they've been able to show that you can both search. It is an events report and events to visualize. I want to talk about events, what comes into your mind is the reports that are entered individually in each of those program stages. And once you launch it, and once you launch that, you will be able to see that it loads. And once it loads, depending on your connectivity, this is the window it gives you. Again, let me first take some time to explain this window. It's slightly different from what most of you may have been using the data visualizer, the current data, and we'll get reporting and also describe data. We have this section as the rest, where you select what you want to add into your port. So on this full site here, you have an opportunity to select what you want to add in your port depending on what elements you want to add in, what attributes you want to add in, how you want to filter them, how you want to categorize them and through what period and for what organization unit, for which facility, for which school, for which region, for which district. So that is all selected from this side over there. And it can be collapsed by clicking on these three and then it disappears. So next time you find something like this, don't just say your nature has changed. It's just like it gives you an opportunity to be able to see your analysis in a wider screen. Just these three dots, I mean these three arrows allows you to collapse and expand. Now, on this other side is the actions to be able to update your, your visuals. So like you want to update what you have changed. So when you obtain it here, you've come and added a different attribute or a different element. You come beside and this is where you can do enhance your table, your table, your results and be able to save the results. And then in this area which already shows something that is where all the results that we do, we generate a displayed. So that is part of the, this is the event support as it looks right now. But again, I'll say to you, it's going, it's kind of going some kind of river. And so you will be able to see that it is going now to be looking like exactly the way your data visualizer looks right now. That's what the aim is for the details to be able to make it easy that you can be able to even come and analyze the data if you really been exposed to aggregate reporting. So now in this year we have, we start with the type of analysis we want. So it's either going to be a pivot table and we'll talk about pivot table, think of it as aggregation. You are going to be looking at aggregate numbers for my data. So if I've been collecting sex marriage, this one was a male, that one was a female. At the end of the day I want to be able to get an aggregate of all my males and all my females. So that is what we will be using in case we want to know how many learners attended school on this particular day or how many health workers have been vaccinated. We will use the aggregates because this is the concept of pivoting and aggregating numbers. So we have the line list which I'll come to later on and explain, we've already started talking about it, what are the line lists, and then we will be able to also use this type of output. So we have two types of outputs right now, the aggregate type number and also the line list which is the individual load data by the columns and the rows that you've selected. So let's start with an example of where we are prepared to see to produce the number of COVID suspects by age groups and by sex. So once you see how many in our COVID surveillance report, how many clients, how many suspects between zero and five who are male and female have been registered into a system. So that's the example we are going to use to be able to generate pivot table aggregates. The next step we will select is the output type. So the output types we have two types, one is the event and the other one is the enrollment. At the moment I'm going to come back to it, let me now explain on the event. So the event is now we have a good particular given stage and be able to analyze on that particular stage. For example, we are talking about the number of suspects who are tested positive. That data comes from a table if the stage which if you all recall, what's the stage? We should be getting answers directly, but since we can't see your hands up, you can type what stage would we get the tests from the COVID. If you can type in the chat, you've been entering this letter. Lab results are good. So yeah, so we're going to be now analyzing because we are interested in the number of positives. We are going to be analyzing data from a program stage and this is now to deal with an event. So we click on an event. Okay. And the next step is to select the program that we're going to be working with. So now you can have access to as many programs as your system has. But for example here we have access to all the three programs. For this particular we are going to be looking at the COVID surveillance, the case based surveillance. So you click on that and then it will give you the different program stages and you choose the program stage for where you are going to be able to do your analysis. So at this point, everybody here on the screen is sharing that we are going to be able to get the lab results from the lab stage. But remember I also want to have it by age and by sex. So those ones are going to be able to pick them from the attributes. So every program, every stage you select it will come automatically come with all the attributes of that program. So they are automatically linked. So I'll come here and click on the lab stage and what you will be able to see here, you will be able to see. These are data elements and these are data elements which we have put in our design in that stage that data is entered on and where you see PA that is program attribute. So and it will be associated with every stage of the event that you select. So first of all, I need to select stage three. First of all, I need to select what I want to add in my output. The first is we heard about that somebody wants to be able to show by age so you can be able to pick age here and add it. So that's what it double click and then it gets added there in your art in your selected items to add in your output. The other part we want to add is the is the sex. So if you can be able to see sex here, you can be able to pick it, but you can also be able to use this filter. You can filter and then type sex and then to filter by sex and then you add it there. So again, those are the two in my analysis because the directors or the command center or the team that has faced with this data wants me to look at the sex of the learners or six of the clients that have been able to enter in my system. And lastly, we want to have the lab results because we want to see the positive cases of all that we have tested how many were positive. So again, I can click here to cancel that and I click on it while just read it and then I can put filter by results. In here, I don't want data of the results. I just want the lab. The lab test result. And this is where we are in that specifying positive negative and. And then in terminate and whatever options that we had under test results. So you don't think on it again you add so of all that has been requested. I have selected the parameters or the data elements and attributes that are that I need for my program. So again, they asked you for the period you may they must specify what period you want. And again here we have a variety of how to choose a period you can be able to have fixed periods, where you're just going and have a start date and end date. It could have been a campaign or it could have been an outreach you want to choose from that you can just click on this and you'll get a starting date. Probably starting from this date this date starting from this date and then ending on a particular date you can be able to use that. However, we also have what we call fixed period, you can also be able to look at monthly or weekly or quarterly or financial year can choose from that. Or you can use the relative period. This is exactly the same the same way we do in the in the in the data visualizer. So there is always a default period that is selected by the system. So you make sure you can take that otherwise you get results which will be surprising you and you don't know why because the default date is selected. And you're not active. So let's first select the, the, the last 12 months because our system was defaulted police use the period of last month. Now, particularly for my request, they want to see for this year. This is the year they want to see a company. So you can come and pick one this year and all of us know that this year is 2021. You can either use that or you go to a fixed period and look for yearly and then add that good. And then lastly, for the most important parameters that you need to select is for where for which district for which reason is it for a country is it for a particular facility. For a district and for this request they wanted to see in the entire country, which is allow country, and you just click on that if it was for a region, you can just select a region and just click on it to be able to pick data for that particular organization unit. If it's for a district you can drill down and be able to select that district. But for this particular one, they did say we want for the whole country so I'm going to click on that, and then it will be able to give me all the aggregate numbers for that particular country. So once you've selected all that you want, you've selected what the data elements allow you to go to your port, the period and organization unit, you can update to see your results. So when I update, what it's doing it's getting all the numbers by the parameters that I've selected and it will give me the results not so far from now. So this is my table. That's how it looks like this is my aggregate, it has given me the edge. Now you see these age groups, I will again to share with you where they're coming from. You can see the male, the female and the NA, NA in this event support means that it's missing this missing data. So there was no data in that it's not that it's not applicable that they selected not applicable. This is one thing that is really going to be changed soon, because this has been purchasing quite a number. So there are some, there are some places where they did not enter the sex, and then you will see the different numbers. Now, the first thing is that the person said they only wanted the positive results. So if you give them all this big table, it will be very difficult to analyze and, you know, use for their presentation also. So we now go to what we call the filters, the different filters I talked about. So once you're still here, you go ahead and click on that again. And this is now where we can be able to do some filtering. So under here, we have the edge. So the edge, they did tell us that we need to be able to use the edge groups. And then these are legends that you create and attached your data element with attributes, and you can be able to use your edge ranges from the like 0 to 5, 0 to 4, like the way it is. So for this use, let's use the edge grouping of call facts. Okay, so if I do that, and I update, you will see that my edge range has changed from 0 now to 5, from 0 to 4, 0 to 5. So you can have different edge ranges that you can be able to apply to this. And this again will make it very easy to integrate with our HMIS for those who are, you know, having all these so many desegregation 0 to 5, 5 to 10, 15 and all that. So those, those are can be added in as legends and then control here. Then the other thing that we look at is the results. So for this case, we only want to present a table that only has positives. So how do we filter for these positives? So we go back to our data selection, and we will go to where there is lab, and then all the options that you see here, one of the options that you have in here or appear here. And for this case, I only want positives, I just click on positive, and it will get selected here, and when I update, then my table is now getting some shape and presentable. So this is how I can be able to filter my own positives. So if I want to add positive and negative, I can also go back and be able to add negative, and then I update. You see that negatives are coming, but this is what I'm interested in, what is the positive. So you come here and remove it by clicking back on it, and then it will be removed. Okay, so we are good. So the table still looks a little bit, it can be rearranged and arranged properly so that we can be able to see our good results. So for example, maybe I can put only, I can only put the edges in the rows, and in the columns I can probably add in the results and the gen and the six. So you come to layout, and then you can be able to move these things around. So I may want to put six up there. And then also lab results also up there. So I can push it even further up, I can even since it's only one I can push it in the shoulder, then I update. So this is a kind of table that is a little bit presentable, and we can be able to see these are all the positives, and they are different age groups and by gender. So that is how we are able to be able to come up quickly with aggregate numbers from the data that we have been able to enter. We all together, you can put down your hands and thumbs up. If we are all together. Before we go to the next step, which is going to be able to look at line list. Okay, I'm just trying to see. I am following however I cannot find age data. Age data. So you should be able to have seen that here when if I move the age now here move. I can be able to go in a filter here and then I, I look for age. So when I filter by age here, just double click enter. The age is there. Then you update. That's your age. The age ranges for the group, the groups can be changed here you can call it COVID age and then you'll be able to get that. Good. I really like the table you created. Okay, thank you very much. Okay, good. So now is this we can be able to be able to get back to the list. But before the line is this table can be sent down that you like it and love it. You can go and be able to save it. So to save you just come to favorites here and then click on the self then give it a name. This is probably this was the C 19 surveillance. Then you can add positive positive cases. This year. So you can be able to just save like that you go to favorites, click on save with the description is a description and then click on save the table will be saved. And next time you can be able to come and open it as we shall be able to see and you'll see the name that the name will come on top here. Okay, good. So let's go to the line list and the line is that I said we is trying to reproduce what you'd call maybe your registers or being able to regenerate your own data in the columns and loss. So start from here, let's go and be able to start afresh. So you don't need to close the app and come back to it just come and go to favorites. And then you click on new, then it will refresh and clear the old table remember it has been saved. So we can be able to come back and pick it. But right now we're going to be able to see how we can produce a line list. The request is that we should look at a table that generates that gives us the first name, the surname, their national ID, their sex, their vaccine number, the vaccine that I received. And then what vaccine visit the first dose or second dose. Now, just to be to show you beforehand what I'm going to create. I'm going to make something similar to this if I go to open here, I'll look for a table. This, this convex line list here. And this is what we call the line list just being able to line list everybody. For example, you want to see that when the dose was given which date when they registered, maybe you want to wonder the difference between the registration and when they go with the vaccine. This is the date is given we don't talk about it more when we are designing the program in the case the programs don't worry about it what you interested in interest to you is when the activity was done when it was done and then when they were registered, we talk about where they were registered in which facility in which school in which region in which district. It will appear here and their national ID, your first name, their last name, the sex, the vaccine they received under the dose, whether it was first dose or second dose or even the dose was not captured. Maybe sometimes you want this list to be able to clean your data how many people did not have the dose captured. This would be a good example. Again, don't panic, I just, I just hit this to show you the wider table. So let's look at this one and I will go to you clear it off, and then we start so for a line list. And even that we are going to do a line list with a with COVID vaccination, we will choose a line list here. And if we are interested in only one program stage, it is going to be an event and particularly for this we already have one stage and fortunately, so we will be able to use the event output, and then the program we are going to look at is what vaccination is going to look like. And then we click on that and you'll see it's only one stage so it automatically will select that state. And then we choose the elements that they want us to show in the line list. Again, this has been a little bit disturbing for most people like they want to put it in the very order they want to see it, but I will show you how you can be able to rearrange your table to look exactly in the kind of order that we live if you have sex at the end and you want it at the beginning. It's okay so let's start by selecting what is needed. So they want us to be able to add the surname and the first name and surname, so I can just type name and I filter by that. So it's first name surname, and again they also want us to be able to line list and add in our columns. The national ID, so again it's there when I filter, then they want also to have sex. I filter by that. They also want us to have the vaccine name, I will be able to pick this one here, and then they also want to have the vaccine dose, the dose number, so I can type by dose, and then I'll be able to have those number there. So these are the things that the question of the data would want to have in their line list, and we can go on and go on and go on and add, but this is let's stop here for the purpose of the training and the time. So at this point we choose the period they said we want to see all the COVID vaccinated this year, so you come here and click on the period. So again, I can use this year or I can be able to pick in a given period. So at this point let me pick this year. And then for this one they particularly want for the whole country. So they want the whole country. So again you can be able to antique this because it's what we used previously on that report I opened. So I want it for the whole country, then I will be able to click and update. So this is simply the line list that is required for our list that was requested for. But they went ahead and said, we only want to see a line list of only those people who have second dose. Again, don't crack your head and going back to redo it again, this is now calling for filters. So you will see in this column, we only want to see those who have second dose because in here there also for some with first dose you can see, but only the person asked for second dose. So what we do, we go again to our data elements or the attributes and then filter by that. So at this point I said we only need to see for the dose number so we come here to the dose number. And then when you click on that you will see all the doses so you can be able to save the first dose alone or second dose or third dose or even a booster. Sometimes you may want to also clean out people who have received a booster. For our school people, you may want to fit out only people who are absent, then those options will be available here. So the one second dose, so we should be able to update. And the list now that is going to be generated is basically only those who are second dose. And in these columns you can be able to arrange them again by going to layout and then in layout, you can be able to move them across. For example, I probably want yes, organization, but I want the national ID to be up there. So I click on drag and move it there. So you move it there in the surname, the age, we don't have age so we probably want to add age so we can update here. And then you come and add age, maybe age was something that we missed out there. There is no age in this data set I think here. We're putting date of birth, maybe that's date of birth. So that's what needed to be added there. So when I update, you will see that my date of birth has gone to the bottom here yet in my list, I will want to see where they were registered and what their ID is their names and date of birth before sex. So you come back here to layout and you can move date of birth up there after or before where you want it and you update. So this is basically your line list and this line list you can also be able to save it and be able to download it and use it. Okay, let me just finish this and then I can stop for those two hands. Okay, so this is our nice line list of all this, of what has been requested for us. You can go ahead and save it. You can go ahead and download it either as a CSV or HTML and all that. Okay, let me take a chance to get the two questions. We're not doing well with time. Yeah, you're doing well. Okay. Okay. Yeah, so I have two questions. Sean Paul. Sean Paul, you're raising your hand. Oh, these are the hands from the people who are up. Okay. So we don't have questions. Please lower your hands right now. Not confused us. So do we have any quick questions at this point? Maybe prosper. Can I ask? Yes, you have. Go ahead. Yeah. So in the other people table, we can have like organizational hierarchy, but I'm wondering if we can do that also in the lion's team. Okay. Thank you very much for that question. Yes, I have a question for the dates. I saw in the table, there are three different dates, the vaccination date registration and incident. So I'm wondering, I thought it was even date and enrollment date, but yeah, just what are these three dates? Thank you. Okay. Thank you very much. Any other question? Yes, I have a question on the same on the dates. I've seen most cases of the registration dates or all those days that we enter when you're entering your data. They usually come with the time at the end, but they're all 00s, except for the instant dates. Do we really need this? Like, I don't know the main reason why we do have the zeros at the end goes when you're doing, let's say when you download the data, let's say try to work with the data in Excel. Sometimes they give us some troubles when we're trying to work in the table tables in Excel. So I don't know if they do have any main reason why we do have the zeros. Very good. Thank you very much. Any other question? Please go ahead and shoot the question. Otherwise we close on that. Okay. Good. Thank you. Yeah. Thank you for those three questions. Unfortunately, I don't have good answers for all of you, apart from one. And this is what he actually is being reflected. So organization, you know, hierarchy. Yeah. This is something that has been missing for a long time in this report. And it's, it's one of, actually, sorry, actually added in the new app. It's one of the, yeah, one, one thing that has been quite challenging because these are the last where the data is captured. And it does not show us exactly where the hierarchy, in which district, in which region and so on. So unfortunately that is not supported in this app and since this is going to be revamped, it's not, it has not been added. But again, yeah, we should be able to see that this can be added. Well, it's already added in a new app, but I'm not sure whether there is any possibilities of backpotting, but yeah, just sorry about that, but it is not added. Then the dates. What are these different dates? Yeah. So you remember in our design for the program, we have the date, the event date. This is our event date. The date, the date when it happens. So you will, you will see the name of what it has been called. For example, this one is called the dose vaccine was given. Some of you may be having it as a vaccination date. In other programs, you'll have it as a date of inspecting the toilets. It will also be having it as a date of, you know, a roll calling or attendance date or something like that. So that's the date that we have in the first column here. The second column here is the registration when the person was registered, when the truck entity was registered in your instance. And again, it will also go to bear the name that you have called on the outside registration date. Now, the Eastern date is always given and it is, it is actually in the background. It keeps in the background. In most cases, it's going to be almost the same date as a registration, but don't decide the case. But this is a date which is redundant here. And we've actually been struggling to get it out. If I don't use it because the instant date and the enrollment dates would be different. In most programs, we can be able to use these two, but in some programs, we don't even need to use that too. For example, like a pregnancy monitoring date, we can have the date when the pregnant woman registered, but then we can also be able to have the date when they had the last, the LMP date. So you cannot add it here. Then also for the children tracking, both monitoring and organization, you could have this as a date when they registered in the clinic for tracking. Then you could have this as their birth date. But this is giving and ignoring it whenever you bring analysis right now. It's just redundant. In the new app, it's removed. The last one was the time. Yeah, this is actually picking from the system. Yeah, it's basically really redundant. And it's a good feedback that we should be able to see if this can be quickly removed from here. Because we don't have, we've got set the time where we look at the date type, where we collected the date and also be able to collect the time. So this can be removed. But again, when you export this to Excel, you can be able to trim it off and remove it from your analysis. Yeah, I think those were the questions that we have at this point. And any more, let's go to the next part of our session, which is now basically going to be able to look at how we can be able to look at the line list, maybe for a particular client and see how events, outputs and the enrollment outputs behave in this particular case. So to do this again, if you want to save this table, please save it. If you don't want, you can just be able to just go to file and then click on new to get a fresh look of your table. Okay. I think they are all good answers. Okay, thank you. Okay, now take an example of again the vaccination. The vaccination where we want to do a line list that involves the multiple records. We want to do a line list that involves multiple records of this person. So for example, if it was vaccination, we want to be able to see a line list that shows us the first visit, the first vaccine, the first dose and the second dose if the person received the doses. If it was in a school, we want to see this learner for all the times he came to school, he or she came to school and so that will all be captured in one stage. So we're going to do a line, an event, a line list that is able to show us this to, the many records that the person has in their program stage or the many events. And to do this, let me just first show you what actually we are aiming at doing that. So if I duplicate this, I hope we can all still be able to see my screen. If I duplicate this and I go to data entry, data entry, just go home and then you go to tracker capture for the tracker capture and when you enter tracker capture, so it's taking a little bit longer to load on my side. In surveillance, I have a particular person who had two lab requests and I want to be able to line list all those who have multiple lab requests and because they're all being one on one stage, I'm going to use the events but it's just first so it's taking long to load. So it's running on my side and I hope you're able to follow as I try to load this. Sometimes what happens is if you have multiple tracker captures open, you will experience what I'm experiencing. I'm trying to look for all my windows to see if the other tracker capture is open. And once I close it, it should be able to... Okay, so as it does that I really would have loved to show you the records and see we go to the tracker capture, we open this particular suspected case of COVID and see that this person had two lab results. But since it's not opening, let me just quickly go and show you a lot. So we want to be able to have a line list and this line list should be able to show us all the records of the person in each of the events or in each of the program stages. So I'm going to use a suspected case and that is in the program. So my output is a line list and my output type is again an event. I said I want to pick it from one particular state and be able to show all the events, all the records that the person has been able to... that have been captured for that particular person. Okay, so that's an event and then the program is COVID surveillance and I'm going to look at the lab requests. So when I look at the lab request, it will give me all the attributes and that elements that are within that state. And particularly what I wanted to be able to show you is that I can be able to select the first names again for this person. It's first name, name. So we have the first name, the surname. We want the age. We want the lab test reason. We can type by reason. So reason here. Reason for testing the lab test reason why they are testing and then the specimen type that was collected. So then we have the specimen. So this type of specimen. So I want to be able to look at this and then the ID number. I think we also... Did we put the national ID? Yes, we need the national ID. National ID. Sorry. We will put the... Yeah, the local case ID. It's ID, which is the local case ID. Yeah, we're using the local case ID. Okay, so there are things I want to be able to show in my line list. I will go to the period. The period let me choose last year. For this, they wanted me to look at the last year. I want to see particular lab results, requests for a given last year. And then here, I'm told that I need to be picking it from a particular facility which is the most. So I will come and expand that facility in the first one here. This particular facility. And then I will update. So when I update, it will give me a line list and you'll be able to see that at this particular facility, I had lab requests last year for three events or records. But when you look carefully, you will see that there is Sydney who had... They were being tested because they were contact and this is the specimen that was collected. Then there is also Camp Bear and Angela who had two tests. First he was a contact and then the other one he was seeking healthcare due to suspicion of COVID. So what I'm trying to show here is that when we do an event, it gives us all the records, all the events within that particular state. So it will give me... If Camp Bear or Angela had so many lab requests or had so many school attendances, it will list all of them in that particular. So this was produced because of the event. But if we turn it to the stage, if we turn it to the output of enrollment, what the system does, it is not going to be able to list for you all the events in that particular state, but it will only be able to give you the last record, the last encounter, the last event, the last entry of that particular tract entity that you have selected. So let's change it to this and then you'll be able to see that if I go back again, so it has to do the whole thing, you will go to surveillance, then you pick your lab request and again you pick your case ID, local ID, the names. Again, you can be able to change them. Then there was a lab request, a lab reason for the test, and then the specimen that was collected. So if I do that, and then I'm doing for last year, yeah, still last year, and I pick one for that particular facility and I update. So what it has... Oh, there was nothing. Okay. Okay. Okay. Yeah. But what you will be able to see here is there not going to be any duplication of these reports. It's only going to be able to give you the last event for that particular... That sort of thing. Okay. Okay. Okay. Okay. So in terms of line list, this is what I was trying to be able to use to... The difference between when you use a line list over the event, that will give you all your events, but when you use them, the screen has frozen, sorry. Okay. Yeah, no, it's not. Okay. Yeah, so when you use an event, it gives you all the records that a person has had, while when you use an element in the line list, it will be able to give you only what? The last event of each. So if somebody had four lab requests, then it will be the last... The last request in that. But again also, this will depend on your time period that you choose. So when that event happened, that's when you'll be able to select the one that kind of period. Okay. So that was the best kind to explain a little bit about the line lists of type event and also type enrollment. Okay. Let's take a few minutes to take some breath and then be able to move on to our almost last two pieces of this training. This session, this afternoon. Okay. So let's say, is that a new hand? Yes. Okay. Go ahead, ask your question as we take a breath. One question I have is when we show us edge, you had a legend, I think, of that classified it into by age range, age groups. So is that a legend and how do you set up that? It's a question. Thank you very much. Yeah, it's a legend. It's actually a legend, which is created in maintenance. If I can cheat, this was not supposed to be part of this, but I can cheat and show you where this is created. It's only that my system is really, really slow. Can you pull out data from different program stages? Yes. We won't be able to see that. That's what we're going to next being able to do line list or aggregation from different, we're using different stages. But they say, unfortunately, this is not loading for me to show you, but you know the legend. So this is coming from there. Yeah, yeah. That's okay. I want to make sure that's the legend. I know how it is. It's a legend and why you saw it automatically being attached to age. So, you know, now when you're creating an attribute or that element, you can attach a legend to it so that you can be able to use it in analysis. Okay. Thank you. Thank you. Can you pull data from different stages? Yeah, that's what we are going to be to go to line list enrollment. Okay. And I'm probably already answering you why we can do that, but it's first of all to enrollment. So now going to do produce analytics using enrollment. I touched a little bit of it, but let's see what it does and what it gives us. And to be able to do this, I'm going to do a line list. I'm going to do a list of enrollment type and then you will see actually that's what I last did, but let's see how this comes out in terms of line list. So I come here and I pick on the line list. Then I choose enrollment type. So the program we are going to use here is the COVID surveillance and the stage we are going to use for now is lab request again. So lab request. Lab request here. And then let's choose local ID, local ID. Then we choose the names. The first name and the first name. And then we also choose the test type, type of test. Then we choose a specimen type. And then we go to the results. Then we choose this year. I mean the period. So then we go to the period and then we choose this year. Now last year's sort, not this year's sort. And then we go and select from a virtual facility and then we update. So this is enrollment type kind of output. Once again, as I shared with you, it is going to be able to show you only the last three quotes of the requests. Obviously many people here have more requests, but when you have an enrollment type, it is where it allows you to be able to select only the last three quotes. Again, if you apply the filters, like say, if I want to apply a filter on a PCR and I say, give me an enrollment line list of PCR. Again, it will first have to go in and filter only the PCR and give you the last record or line list of that particular event that has PCR. So that's basically what a line list of an enrollment type gives you. Apologies. I think I've gone off. You're not seeing me on the screen. Apologies. I think I've lost connection. You can hear me, but you can't see me because I'm using two gadgets. Okay. Now I think you can see me. You can see my screen. You can't see me. You will not see me. Okay. So let's go on and further look at the aggregation of type enrollment. So what does it mean when we're doing aggregation and we use type enrollment? Remember, aggregation is given to us by pivot tables. And I would want us to compare two tables here that we are going to show. One that uses events and then the other that uses enrollment type. So that's when actually you'll be able to appreciate the difference between the two. So the enrollment only filters by one record. Which, unfortunately, is the last record of that kind of selection. So to do this, I will open a new one. But I go ahead and open another event capture where I'm going to show you what we're trying to produce. So what I've already saved up front in this is an enrollment type. So I go to open. And then I will look for Kofi cover registration by six over registration by six as well. Over registration by six. Oh, this one here. So it's here. So if I open this, this is the table that was open was was saved there before. You will see that it uses enrollment type to be able to give us the number of those who are enrolled or in the vaccination program by six. Just a simple, a simple table just be able to show you the comparison between the two tables so that we can be able to explain the differences. So at this point, allow me to open so that I can be able to see my to see your questions and hands and who is there, who is following and who is not following. No, this is supposed to be on my side. Okay. So now I can see you or. So now this is a table which was saved and you can see from here you can produce it easily. What it was done is they want the people table because they want aggregate by sex. And it's an enrollment type and the program we are using is vaccination registry and then vaccination stage it's only one there. And they only want to analyze by sex, the program attribute, the period that was selected is this year, and then they use the subunit three. These are also ways of being able to select the district, because the next is a region, this is a national this is the region, this is by actually region, and then the next is by district. So let's go back and play our similar table, but only looking at what are the by event and event kind of reports so here we choose a table to use an event, and then we go to the also we go to the meeting. It's hiding some of these things and just go right out and somehow it's, it's let me just refresh the whole thing. It was hiding where I could be able to select the attributes and the. Yes, so it has come so it's a pivot table, which is aggregate of an event type, and the program we're using is a vaccination and the vaccination stage and all we needed to look at is six, which is this, then for the period, we want to have the same period which is a this year. And then this year, and then for the organization, we want to see at sub level one, which is the region, and then update. I think you did you deselect the past two months on the. Sorry, your network is so bad. I mean, on the period, I think you didn't select or. Okay, sure. No, I didn't say thank you very much. Thank you very much. Okay, so now you see already what it was giving us. It was giving us last year and all the last two months. Okay, thank you very much. Okay, so this is the table that we want to look at, but the layout we want is. Sorry guys, otherwise, sorry guys, I'm not sure why. So you can now see my, my screen. Okay, so this is the table that was produced by by enrollment and this is the table that was produced by event. So let's rearrange it you remember where we can arrange so that the, the, the audience are in the loss so you put layout and pull this one and put it here, and then six words up there, and then you update. So you will be able to see that these two tables are all talking about the same parameters being selected, but they are different types. So if I drag this a little bit out. So that I hope. I think about you about see now I think you're seeing different table now stop sharing and just one minute give me one minute and I rearrange the two of them. Okay, so last night. Next to be sure. Okay, I'm just close this one and have my table. May have to recreate it. Sorry guys. Okay. So we can see that's only one table. Okay, you can, you can see now the one selected. This is the one work by enrollment we first the other one. Quickly. My screen is freezing. I have everything freezing here apologies let me restart this window has been open for long. Just one commercial break just say, as I rearrange my window. The display is the word of today. Make sure that you go to day three and submit the word of today which is blackbird. Okay, I have to use. Okay, and I hope you are all still, but we are back as apologies I switched now to Daisy, I think. So this is plus again. My laptop shows and my laptop shows and we have to switch it up. So, what you see here is a table that has by enrollment and I was going to show you the other table which is by events to compare the two. Outputs so that you can be able to understand the differences here. Okay, so to be able to do this, let me duplicate and then be able to quickly to create that table that we had stopped at and so we have this, and then we have this one. So, fresh one. And then it is an event report before table and the program stage, the program using that works nation, and we are doing it by six. And then the period was again this year, and then the organization unit was a level three, then update. Kind of remove the total of period. You guys, you have one shot. I thank you very much. Yes. Okay, so as a table, then it's rearranged so that we can be able to be able to see the organization in the laws, then the six can be there. If you can be up there, then you update. So I want us to compare these two tables and you see the outputs, and then you will be able to appreciate. So, I want to do what I tried to do and throw to my computer. So you will be able to see that here for this capital region. This is the 71 in female and on this other side we have 600 and the 63 for female in the capital region. So the reason is that when you use events, it will count all the events that are in there. So this particular, these particular people, because you remember they have first, those and second doors, some of them are being counted twice. Because they have two events, and that's why it counts all the events while when it comes to enrollment, because I told you it only picks the last event. So probably what is being counted here is the one record. If somebody has one, one, one event, one attendency or one vaccine vaccination event, it is going to come so you can see almost it's like halfway. And that enrollments will always be picking one record across the entire enrollment so it's looking at an entire enrollment as opposed to looking at the frequency or the events that you have had in that in your program. So that's a difference that you would be able to see and we could be able to stop here and be able to go to our last part of the of this session, which is what our colleagues, our colleagues asked in the question like for example, I want to analyze my data, which probably is going to give me aggregate numbers to look at the requests and the number of tests that have been done. So if you remember, if you have a program in at heart, you do recognize that this data is collected in different stages or at different points. So what happens is, we will need to be able to cut across so the enrollment type of output allows us to be able to cut across the different program stages. So it will be able to allow us to be able to analyze data from the stage one and stage two and combine all those into one output. So to do this, our request was for those who are in disease surveillance and this is going to be very common. But the line lists don't don't only come from one program state or from one section, the line list in this is surveillance, they want you to be able to have a whole cascade of the events of that particular person, meaning that for every suspected person, if you want to see what was the diagnosis, which will be picking from the analysis stage, what was the lab request that was done, and what was the lab result and what was the outcome. So they want to have that list that is complete. So if we go to our school education people, you may want to have an alignment of all your learners, you want to cut all their information, their bio information, you want to cut their attendance, and you also want to cut their performance in class. And this could be created in different stages, performance and the learner attendance could be created from the different stages. So this enrollment type of line list is what will allow you to be able to pick those different elements, certain elements from the different stages. The only unfortunate part here is that it only allows you to pick the last, the last events or the last weekends of each stage. So if it was a vaccination, it will be allowing you to only pick the last event, which probably could be the last, the last vaccination dose, which either goes to, if it's from the learners, it will probably give you the last event, and so on and so on. If it was from the toilets, it will probably give you the wash program, it will give you the last assessment of the particular sanitation facility. Okay, how do we go about this? Again, you can be able to restart this app or go to either refresh the app to clear this or go to favourites and clear it, but let's refresh so that we have a fresh look of this. And the event report will be launched, and here we are going to produce a line list, which has not even been refreshed before. That's what we call new, and then we are able now to generate the line list which cuts across all the different stages. It also applies for people with tables, and that will be your homework to be able to generate a report that combines data elements from the different stages, probably it is sex, test results, and the PCR type, sorry, the test type and the results. Let's go for surveillance, so we are going to look at a line list, you pick that, and then you will pick the output now enrollment because we are going to cut across to be picking data from different stages, you pick enrollment, and then you will pick the program. For this, this program as you all still remember, it has only one stage, so it is not going to bring it out of the way we want to be able to see it. This is for the surveillance which has how many stages, four stages. Okay, so you click that. So we click that, and then we should be able to select the different stages. Now here we can start with. So here we can start generating the list of what we want. So for example, if you still record, I have this in my head. I wanted to know to have a list and be able to show if people have signs and symptoms or they had underlying conditions. So that can only be picked from the stage of clinical diagnosis. So you pick that. But before you do that, they want to be able to look at some bio information. So the first thing they want to be able to have in the list is the, is the case ID, which I can type ID, and it's just there. Then the names, which is a surname, name, which is the name. I'm using a different somebody's laptop. So whatever I type, don't blame it on me, blame it on the laptop. So it is a first name, it is a surname. And then they also want to see the sex in the list, very key for surveillance or for your learners. They also want to see the age, or the age of birth, I think age. I want to see the age of that person. And that is as part of the bio information. You could also go ahead and see where they come from. And that is going to be also very key. You want to see the telephone contacts and all that you can add. But let's stop here for this particular one. Then the next part they want to see is information about the lab request. They want to see information about underlying conditions and whether they had signs and symptoms. So you remember the stage that is going to be selecting from is the clinical diagnosis because that's where the data has been captured. It was organized in a way that data from conditions or signs and symptoms is in there. So I can come here again since I've really selected it. And I can also fit it down and say I want that element. So you can be able to say I want that element and to reduce your size to that. So I want to see underlying conditions. You want to say if they have underlying conditions and they also want to see those the line is to show signs and symptoms. If they also wanted to say you want to see whether they had a cough and fever, you can also add it. But for now, those are the two elements they want to see from here. Then when it comes to lab requests, they want to be able to pick information about lab requests. And in the lab request, they want to see the test results. Why are we testing this person and the test type? What kind of test did we order for? And remember this is COVID, we have the PCR, we have the rapid, we have all the other types that the request of this line list wants to do that. Now you will see that when I pick another stage, what I have selected is not disappearing, which has been common to most of you. And that was because you have an event kind of output. So as I keep selecting, I selected underlying conditions. But when I moved down to that request, I still have them selected here just because this we are looking at anaeromic. We are looking at the entire program of these particular cases. Then when it comes to lab results, they wanted to see the test results. What was the test result? So I come here again and I can be able to see that I have been filtered by data elements. And it is going, we want to see the test results. Sometimes they want to be able to even look at what was a bit of testing. Yeah, so let's add this one. And then we will be able to see the results. And then finally, we want to see the outcome. You will pick from outcome here. And these are the kinds of outcomes. So here's outcome is what we're going to pick. And this will give us the different options on what outcome came out. And of course, you can also add that in case those have died, then you have to go here. So I have been able to construct my nine list. Of all these, the elements that have been asked, and you will see that I have selected them from across different stages. Because of being able to select the one. The enrollment type of output. So you go ahead and choose the period. Maybe they want for the last year. Yes, last year. And then you put the organization in it. And they may probably want it for a particular region for the entire country. So you just pick up a country. And then update. That was last year. No, this year. This year, I think we have that. You didn't select this year. I didn't say it's selected. It's selected. Yeah. The field is selected. Okay. And then update. Using the demo. Do you want analytics? Why is it being selected? Magic is happening here. I don't know what they have everything selected. We have no filter. Okay. Yeah, I think there was the problem was on the edge. If I wanted to add in the age, I should not have been able to add the, the, the. The legend. Because that's what I already moved on then we have our, our. We have our. List which cuts across. So you will be able to see that. There's the date of registration. When the onset was. And where they were just at their IDs. Some of them have no IDs. So these are attributes up to here. Then we have the symptoms. And we have the lab request which is here. And then we have also the what. The test results. So we have the positive ones and then in inclusive. Sorry. Then we have also the cover. So this has been able to allow us to be able to pick elements from older stages for the school people. You will be able to have your results marks and all that. So basically this is the, this is part of our last session. And whatever we have touched is all in the exercises. So if you want to be able to continue and be able to practice this. Please follow the exercises and also be able to follow the guy that has been given to you in terms of your analysis. Okay. So I think this is the end of our session today. In terms of analysis. And we will be able to see how we can be able to get data. By using the table tables. And we'll be able to see how we can do some line list. This is being able to generate a list of all your own data. For you to be able to import, export or use it for data cleaning. Or use it for your presentation. And we will also be able to go through to look at the events. The type of outputs. And again now, I think this rings into your mind is when I use an event type of output. What does that mean? That means that you are dealing with only one stage. And it is taking care of all the events in your. In your. It's taking care of all the elements within that particular state. And then an element is when you are able to cut across the different stages and select different elements from the different stages. We've seen the programs. We've been able to work with this. You can also be able to work with case. Conduct tracing. And we've seen that, you know, you have different stages on where you can be able to select different elements for analysis output. And then we have been able to see the filters. The one last filter that I've not been able to show you is you can filter by even a free text. For example, if you knew a local number, you can be able to filter and say, I want all those which have 23 as part of it. So when I do the filter here, it's only going to give me where the IDs are only containing it with the three somewhere. That would be also filtering. You can filter by name. So you see only the numbers that have come here. It's where the ID at which has in some 23. You can also filter by names. And just say I want to see where there is Emma, whether it is John, you type in there. You can just be able to say I want to contain the name that has Emma there. Then you can also be able to make your filter. So you see that it only gives me only the Emma. So you can, the learners, whatever the toilets by name, you can be able to be able to filter by text here. And then the period and the organization to now select them. So that's what we've all been able to see today. The serving where you go to save and the favorites and then downloads. Those are things you can easily be able to do right now. I can download this as Excel, but just by clicking on that, the layout will be able to look at that. And the options are not so many. So there is including on a completely events where you are picking the complete. Which are also going to be able to form a show. So if they are not in complete, they will not show. So like for example, all those were entered without form, without a click in one complete. That's why they have disappeared. So if I bring them back. So it means somebody just came in and entered and did not click on a complete button. Now one quick last one is I wanted to show you is about the date. So the date that we are using here is the date when it has the event happened. So for example, if you're looking at. Let me do this quickly, quickly. If you're looking at your vaccination. A table for additional and it's an event and it's what the registry. And here we are looking at the dose number. So if I do those number. Here. And this is my table of this year. For not forgetting to, to the select. This last 12 months. So you will see that this is only giving me. Maybe that's just to last 12 months. That would be easier to shoot. What I'm going to explain here. So we have, you can be able to see that these are events. And this is when they were captured. So it means that in December 2020, they entered seven cards for those one, 600 and 28 for those two. That's the date when they were vaccinated. So the event date for the date of vaccination. But it's also when you want to know when it was in entered into the system, like when it was captured. So if I go to options here. It's layout. When I go to layout, I can be able to change by the time here on the timeframe. So you see, this is best on the event date, but you may want to know when the data was entered. So the date when it was created, you just click on that created, get created or last updated and then we update. You will see that because we put it on this data, none of them has been given that it was created. No, they were created this year. Actually they were created this year, but they were the events were last year. Yeah, that's, that's the difference. So sometimes most of you want to know when was that exactly entered and when was the event captured. So this is where you come here and you can choose the time. So when last updated or event date, those are the differences. Okay. Thank you very much. I think let's stop it here. We may not have time for questions. And I think since we had the, we had quite a number of questions in between. We should be, we should be good, but remember, immediately after a year, we have a session for those who want to continue with an interactive session to ask questions or the somebody that answered them, please. You can go to the, you will be able to be given five minutes and you can go to the, to the, that's the only it's