Session 1
Summary
This on-demand teaching session led by Medical Director Jana A offers valuable insights into data collection, creating online tools, and other vital topics. Jana provides clear, step-by-step guidance on how to process and analyze data using tools like Google forms and SPSS software. By translating complex processes into understandable concepts, attendees will learn how to properly gather, clean, and evaluate data for practical use. This course is perfect for medical professionals wanting to sharpen their data analysis skills to improve patient care and medical outcomes.
Learning objectives
- Understand the process and essential steps of data collection, including what to include and what to omit, and understand how to generate and interpret reports.
- Gain proficiency in creating and using online tools, including Google forms, for data collection and analysis.
- Learn the techniques of data cleaning and manipulations including filtering, replacement, coding, transposing etc., particularly in the context of SPSS.
- Grasp the specifics of handling different kinds of data, including sociodemographic data, Likert scale responses, numerical values, binary responses etc., and understand the key considerations for each type.
- Understand the importance and methodology of descriptive analysis and how this analysis can be represented and interpreted, including the use of graphs, charts and other visualisation techniques.
Related content
Similar communities
Similar events and on demand videos
Computer generated transcript
Warning!
The following transcript was generated automatically from the content and has not been checked or corrected manually.
The other one, we with the manager are responsible for organizing to S PSS Strange. This first session is presented by the founder and Director of Medical Jana A aiming to understand data collection, creation of online tools and other topics. We hope that each one of you find this session beneficial and profit from it. Now, I leave you with Jana. Hi, everyone. Um I please raise your hand, uh raise your hand. Abel Mal. OK. Uh uh In December, I was the coordinator and responsible for the reports about a, basically we had several uh uh G Google uh form report. Uh I will get you through the process the first uh we will recover for what to do and what not to do, specifically volunteered to do the report. So uh about the report. So uh at the same time, uh actually put it on about frequency or about descriptive analysis. OK. Then a session will be with doctor. Uh she will be more uh explaining about the actual test, the different test analysis, all sp so um every, every step is important, every step she will be continuing. So the session I recorded any question you have you can ask me uh you do the actual test. OK. We'll be starting. I will share my screen uh bus arm will share screen questions. Will the chart so click on to our phone and but OK, it's not sure. OK, so OK, so you know everything Damon, Damon make sure to put sociodemographic information. Uh never sign the form below uh social demographic information, any reports you want to do but the specific population information, the university, it's more about a university and a name information are important are actually medical students. OK? I put some universities. OK? Same for uh medical year ma for medical year, second year, second year choices in the second year for me as a. So to avoid that just OK, this is an actual, so this part is called the mono about the same topic. Usually you have to put the question to on. So OK. Uh as I can handle a scale, a specific doctor you have to put up explain, right? Uh It's put to assess uh a specific uh so social accountability or uh uh progress and medical education or whatever. Always explain. Hi. OK. I know uh PSS is a software that analyzes data and descriptive analysis. OK? So a an ha and so 200. OK, once you download it as Excel, I Excel. OK? Any questions so far? OK. So actual data? No ha OK. So this is so how to move on there? Love this sport. OK. At the same time, it's very important for you. Uh, again, it's all, it's very normal. OK. So this is the word, all words, numbers. I can actually some questions in your numbers. Yes. No. Liquid scale. And the liquid scale, you know, we are shown a liquid scale. Uh It's a scale, agree, strongly, agree, disagree strongly. Exactly. So it's the same concept. So how to deal with all types of? OK. OK. So let's start good. So um the number one. So uh coding for the types of uh oh uh COVID infection. A international co so ba oh I don't want that. So no, but I double click kill our row. OK. So who have that or no? But the basil uh mas this is a 502 104 101 or two missing uh to do that plus so uh uh female. OK. One equal male, two equal female. OK. OK. Mm The oh OK. So filtering know two ways to uh to clean the daughter replace, replace uh a male B1 or female B2. So it hurt. Not this way, not filter. OK. You sit on there one. Mm OK. And to think of so I it G double the hall of filter. Oh If you can pick up some, pick up some filter, you say I'm gonna filter in tobacco. OK. Select unselectable OK. Hot Bassel, hot one, ba OK. That's it. OK. Select all the female, buy one Psa Fort B will unselected female put. OK. But number two law drug. No OK. Halo or OK. A female male 1212. OK. Hold on. I'm AJ mi it's underactive. Mhm. Ok. Uh help me six months but concerning the coding for the data, an empty space, a male female here automatically this is coding and we don't have to write anything or double click. Oh she as I will explain it more to avoid the mistakes. Female colleague, your doctor, female. OK. De perfect. Thank you. OK, welcome. Sorry. And come here is blank one. OK. How many immunity tests did you do? Ok. And every question is OK. OK. What about uh uh does it make sense? It makes sense. OK. Bad. Uh Hi. OK. OK. Yes or no. No. 12012. This is not a H there men. Yes and help that one. OK. And OK. VHA select all. Yes. No. What the number two and I OK. OK. That's why we have cleaning, select all option if I'm not blank. Coming up blank an ovarian type of infection. Mm. How many times did you get infected? Ok. Hello. Number two delta. Number three. OK. We do the same filter. OK. Is it clear? Is it uh afi sword? II can't find them. Uh uh No, no. OK. Uh OK. All OK. So. Oh, ok. OK. I see. OK. Five minutes. I OK. Uh who will lecturer in classroom lecturer, lecturer? OK. Two, they are the same category lecturer and a class of studying. Not a color. Uh, it an old or did column four, insert, column four. Ok. Didn't apply to iphone one. Ok. Additional assessment assessment, practical work to avoid that coordinated. Ok. The result time reporting. Ok. How is, uh, recording? Was he had a daughter recording? Mm. Regarding the cleaning, I'm not, not a clean. I'm, I'm not S PSS and, and I so sophisticated. Ok. So he hunts the H 11. So ZC Plazo to 11 point the skills of speaking or whatever. And 15 ma 1110. Ok. So still 100 and 1951 10. Monte A, a one. Ok. Ok. Oh, he blind. Must vote the block, hide the blood but IV no, so. Ok. Mosb the filter. Mm. Ok, man. Uh, ok. Be loan. Ok. Ok. Yes. Two. So how you doing? Missing missing this year? Ok. Ok. Sure. Hey, there numbers numbers are already in there already know rate from 1 to 5. Ok. Not in. So I on how we go there. Yeah. Along with the filtering method. Master share. Well, I usually on it. Woman health. No author than one. Um, Mazo. No touch. Ok. So no, not even that the statements for, you know, she is small place. So will select the ho OK, I IIC here bea B place. Mm. So about the, um, find what b taste but the, the find oil replace all. OK. They are about the normal, replaced for I, how are you doing? Levels and a heart attack holding one. Ok. It all I let replace. Ok. Military place after one? Ok. C OK. Face there all through her. I call it very to avoid. OK, ma OK. So put on recording. No f a rare color. Uh, you know, we have two languages, English and Arabic, English, Arabic English. And no, I'm usually, if he forms the English he forms a lot. Oh, yeah. No. Oh, ok. The same thing. A star. Mm. Good love. Lotto. Same thing. Numbers are numbers, data cleaning is data cleaning. OK. Scale of assessment or whatever. I agree is one. Did I answer your question somehow in case one form in English and one form in Arabic, do we merge them the language? I know. No, it doesn't matter. No. And, and started to file one two. You can OK. How long, how long her next step is you there? It's better. OK. Thank you. Yes. OK. Uh Yeah. All actual fine. Now we clean the daughter. No, be there on the sit down there. Hi, I'm Sean. This. Oh my. How to do that NAFTA has us after no version about 24. So it should be the same. No, the but uh Excel type of uh file uh with the hand. Bye. Diet is more data exercise. One open this but the hand is she a small worksheet worksheet and here here. OK. OK. My hair. But they coded cod. OK. OK. Head do do the hospital. So point point. OK. And how about up to your home? But until you ask me a question about, hello. Hey doctor. OK. Label label. So and on the gender, on the male, on female measure value about the G about three points show the values and the one you want to here I ba two it in there. So change. Ok. So Ala has almost around the two values. Good morning. Are you infected with COVID-19? Not this year? One a year. Yes. Uh I II can copy. Ok. One a year. All good. I agree. Uh huh. Don't worry about it. I agree a year, a year. Not uh report anyway. Oh, now I'm a HF to fix this problem so I fix it. But two numbers vision hole, it's fixed mission hall. Ok. About 10 years. I the communication score and you have uh three decimal come in. Hello uh four acre loan it. Ok. Female female, female. I know we call male the automatically s one and one and two descriptive normal frequency frequency. No, no female. Mm cat, female, female one. So is that a female? Let us know? Ok. Uh How do the questions? I is that what you know? Ok, I know but the Excel. Oh this will excel. Ok. Ok. Ok. Uh One. OK. Heart two. Why not? 20? Mhm. You came in OK, we are smart enough and so what I do an Obama 15 sh on you. Ok. Ok. A doctor. No, no, your bottom ma same doctor. Ok. So uh ok. Ok. And OK, here she can do any, any uh test on here uh it, male or female. OK. Cause a resolved uh descriptive age, age group. G OK. Yeah, I'm looking at on there ba la send me Amazon on uh results one. OK. Here's the last is oh no, this is it. So this is I'm on the bar something but the gender is for sure. Um Let me on that and that's not tested by the way. Um Oh yeah. OK. Hello uh group. Uh so don't worry about it but results are there. OK. Come on mom will say you accept, you got you. So I had the results so far. Why is this important? But could she break or not? The what guys? OK. Uh has questions? Oh OK. Now in your shirt, I'm a, I'm a little I want to use the types of so do my arm in your word Doc sure.com. I am um uh editing. I this is a picture. Uh So uh home the shots. Yeah. Yeah, let's go here um face and uh OK. And uh did uh what hand? No, I didn't apply on 1/5 year on 1/6 year. I applied to iphone. It's very easy to you. Double click. Hello? Mm Pick up sign and uh thanks for coming on uh uh blue or OK. Five. He is how to go from this d to this output. Uh OK. Meeting in two minutes for small port. It's open for questions. Uh We can do it uh is not hard on food uh but not much 1015 minutes record recording uh trans no X LR. Mhm Any answers. OK. Right. Transpose is OK. So, but so what I do will select ba ba paste, transpose trans four de voa. So like literally you past us and paste them. Uh you can do that. And so then you do this test. OK. Uh Sounds good. Not sure. Efficiency now. Um OK. But uh 555544, I think it should be uh you something hold on five and had five as in OK. OK. So we always put questions. This is not good. It doesn't make sense. I had the 555. OK. Hello um of zip on carry ports puna. So uh 55. Uh usually, yeah, usually with the liquid scale of oh the band that oh, you have to question the keep in mind to make sense of I don't want to, I like it very much. OK. OK. December reports um in activation and also known as um I don't think I sure you can come in. Hey, hey, hey, good, excellent Black Horn Air uh vital statement. Yeah. OK. OK. How did the Zoe down there. But I did remember en yeah, my arm anyway, especially reports for the uh always, always some ground rule um uh the and output uh the results but a bit. So always, always and you uh problem it. This is one report. OK? The report um introduction table. Every table is and now I can double, hello. Usually I can double click with I edit. So um it's just analyzing uh I will I know discussion. I'm not sure. Uh I think how to. So I know this is an example and that report last year I think you got letters of uh appreciation. So uh should look on that. OK. Something not to do. Uh not to do who were a uh problem? OK. OK. Hi. Sure. OK. Something not to do. He hated it for him. Hey, did you put the one on? Uh OK. It's good. It's fair for me. It's not fair for, it's good. I think as statisticians think as statistics can you can buy any po these numbers? I know uh and uh suggestion for improvement. I give you on all this to include more pictures, interaction information was false numbers. How many numbers? How many number of students? Mm OK. Oh, did I have that report? Just a script of uh maximum normal box, blood muscle alone. Uh No, I didn't stop taking it. I know. OK. Get off G so P hi, a sense of how you get the Yeah. OK. And for me, uh, mother and the year I will open, uh, the fluid for questions at number one, we have to eight. Um, how about your one head and exercise? So please guys. So. Ok. Ok. Ok. I created AC S Oh, yeah. Have some new cleanse. Ok. They cleaned here here. Um, you have to, ok, find out. Ok, I cleaned it. Statement. Make a ok, she, ok. Number and, uh, ok, that's it for today. I almost stop shedding. Um, let you know if you have any questions and, uh, and go for now if you are good with, how do you know? Mhm. Reports. Reports. Hold on. Ok. I think we can, uh, stop recording. Oh, thank you for joining us. Any anytime recording stopped. Ok. Hello, sir. Hello?