BIOL260_SHFYR_2019_ALL_U: Science Literacy Assessment 4 - Handling Data 27/8/19, 5*46 pmBIOL260_SHFYR_2019_ALL_U: Science Literacy Assessment 4 - Handling Data Page 1 of...

please read and follow the instructions and if any questions please message me


BIOL260_SHFYR_2019_ALL_U: Science Literacy Assessment 4 - Handling Data 27/8/19, 5*46 pmBIOL260_SHFYR_2019_ALL_U: Science Literacy Assessment 4 - Handling Data Page 1 of 3https://ilearn.mq.edu.au/mod/page/view.php?id=5306572 My home / Units / BIOL260_SHFYR_2019_ALL_U / Science Literacy Assessments / Science Literacy Assessment 4 - Handling Data BIOL260 Science of Sex Science Literacy Assessment 4 - Handling Data Data, data, data…. That is what science is really about in the end. Regardless if the experiment requires recording behavioural videos, timing responses, blood samples taken, counting number of sperm, or measuring fertilised eggs. All the hours collecting samples, can then require hours more processing the samples collected to turn them into numbers that can be statistically analysed and turned often into figures. For example, behavioural videos have to be watched and scored and translated into numbers, and blood samples can be used for genetic work, hormone analysis, or to count parasites. Goal of Assessment: In this assessment you will learn how to select and organise the right part of a basic data and how to handle it to help you make statements about the research findings and to make figure. You will also learn about the interpretation of statistics. The Assessment: You will be provided with a small data set that you will have to answer questions about. --------------------- Handling data tutorial: Using excel and interpreting the data When you collect data from an experiment you often collect information about multiple variables that are categorized, some time in multiple ways. This means that you will have multiple columns of data that contain a category or numbers. The categories can help you group the numbers for analysis. Watch the video on ECHO for a demonstration of how to use excel . You will learn: 1) How to take averages of multiple cells of data and calculate the standard deviation. 2) How to make a basic figure, and add in error bars. 3) How to save the figure and put it in a document. Statistics https://ilearn.mq.edu.au/my/ https://ilearn.mq.edu.au/course/index.php https://ilearn.mq.edu.au/course/view.php?id=35828 https://ilearn.mq.edu.au/mod/page/view.php?id=5306572 27/8/19, 5*46 pmBIOL260_SHFYR_2019_ALL_U: Science Literacy Assessment 4 - Handling Data Page 2 of 3https://ilearn.mq.edu.au/mod/page/view.php?id=5306572 We are not asking you to run any statistical tests in the course. You just need to be able to interpret the outputs that we give you. What statistical tests you run depend on what kind of data you have and the distribution. For example, if you have measures or value data (e.g. weight of egg) vs. count data (e.g. number of eggs) In statistical terms this means you have continuous (i.e. can take on any value) vs. a discrete (i.e. whole number or category) data set. The statistics that will be presented to you for the posters will be simple ANOVAs or t-tests. Both tests essentially are looking to test fro differences between groups. The outputs will give you information that needs to be reported in your Results section. What you need to report: T-Tests – you need to report the t-stat number, the degrees of freedom, and the p-value. e.g. t = -1.593, df = 12, p = 0.297 ANOVA – you will get an F statistic, degrees of freedom in group sand individuals, and a p-value. e.g. F = 0.47, p = 0.73 BUT, what does it mean!! The test you run on the data puts different constraints on the data, but with a-priori (before you run the test based on assumptions you make before running the experiment). The classic way to judge if groups significantly differ is the p-value. If the p-value is p < 0.05 then the groups are considered to be significantly different. typically a p = 0.001 represents a stronger difference between groups then p =0.04. by stronger, i mean it is a result more likely to stand up to further testing. science is generally moving away from the p-value though, so donʼt be surprised if you see significance presented in papers in different ways – especially more recent papers. however, for this course you donʼt need to worry about this!. --------------------- the assessment use the following data set (as xlsx or as doc) answer the following questions, put them into a document for submission into turnitin. to be completed in a document and submitted to turnitin - you only get one upload. please include you name, student id number, and number your answers as they are asked below to avoid confusion with marking. you do not need to include a title page with your name and id. please use a legible font and text size. normal spacing is fine. please save file with at least sir name, your student number, and assessment #. 1. (1 point) what is the average and standard deviation of the right testis collected from site a? 2. (1 point) which season has the largest follicle volume? name it and give the average and standard 3,31.2 https://ilearn.mq.edu.au/pluginfile.php/5915872/mod_page/content/7/data%20for%20example%20for%20assignment%20v2.xlsx https://ilearn.mq.edu.au/pluginfile.php/5915872/mod_page/content/7/data%20for%20example%20for%20assignment%20v2%20word.docx 27/8/19, 5*46 pmbiol260_shfyr_2019_all_u: science literacy assessment 4 - handling data page 3 of 3https://ilearn.mq.edu.au/mod/page/view.php?id=5306572 © copyright macquarie university | confidentiality & privacy statement you are logged in as amanuel assefa (log out) 2. (1 point) which season has the largest follicle volume? name it and give the average and standard deviation. 3. (3 points) make a graph of averages with error bars of the oviduct weights across season. last modified: monday, 19 august 2019, 2k12 pm general ilearn or it question? help.mq ilearn info library handbook unit guides learning and teaching policies security confidentiality & privacy statement students ilearn quick guides for students general question? ask.mq it information (printing, ilab, technologies) student life - help and advice email estudent student policy gateway staff ilearn quick guides for staff l&t workshops and services iteach (ilearn & unit guides setup) echo360 lecture recordings info teds (evaluation surveys) http://www.mq.edu.au/ilearn/student_info/confidentiality.htm https://ilearn.mq.edu.au/user/profile.php?id=227879 https://ilearn.mq.edu.au/login/logout.php?sesskey=watwrvtkad http://help.mq.edu.au/ http://help.ilearn.mq.edu.au/ http://www.mq.edu.au/on_campus/library/ http://handbook.mq.edu.au/ http://unitguides.mq.edu.au/ https://staff.mq.edu.au/work/strategy-planning-and-governance/university-policies-and-procedures/policy-central http://www.mq.edu.au/security https://ishare.mq.edu.au/prod/file/dbc1a9c8-7bcd-4a60-a4a1-f46ab50af7b2/1/ilearn%20confidentiality%20and%20privacy%20collection%20statement.pdf https://students.mq.edu.au/support/study/tools-and-resources/ilearn/ilearn-quick-guides-for-students http://ask.mq.edu.au/ http://students.mq.edu.au/it_services/ http://students.mq.edu.au/support/ https://mail.google.com/ https://student1.mq.edu.au/ https://students.mq.edu.au/support/study/student-policy-gateway https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/ilearn-quick-guides-for-staff https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/ilearn-training-and-workshops https://iteach.mq.edu.au/ https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/lecture-recordings https://staff.mq.edu.au/teach/design-for-learning/teaching-evaluation 0.05="" then="" the="" groups="" are="" considered="" to="" be="" significantly="" different.="" typically="" a="" p="0.001" represents="" a="" stronger="" difference="" between="" groups="" then="" p="0.04." by="" stronger,="" i="" mean="" it="" is="" a="" result="" more="" likely="" to="" stand="" up="" to="" further="" testing.="" science="" is="" generally="" moving="" away="" from="" the="" p-value="" though,="" so="" donʼt="" be="" surprised="" if="" you="" see="" significance="" presented="" in="" papers="" in="" different="" ways="" –="" especially="" more="" recent="" papers.="" however,="" for="" this="" course="" you="" donʼt="" need="" to="" worry="" about="" this!.="" ---------------------="" the="" assessment="" use="" the="" following="" data="" set="" (as="" xlsx="" or="" as="" doc)="" answer="" the="" following="" questions,="" put="" them="" into="" a="" document="" for="" submission="" into="" turnitin.="" to="" be="" completed="" in="" a="" document="" and="" submitted="" to="" turnitin="" -="" you="" only="" get="" one="" upload.="" please="" include="" you="" name,="" student="" id="" number,="" and="" number="" your="" answers="" as="" they="" are="" asked="" below="" to="" avoid="" confusion="" with="" marking.="" you="" do="" not="" need="" to="" include="" a="" title="" page="" with="" your="" name="" and="" id.="" please="" use="" a="" legible="" font="" and="" text="" size.="" normal="" spacing="" is="" fine.="" please="" save="" file="" with="" at="" least="" sir="" name,="" your="" student="" number,="" and="" assessment="" #.="" 1.="" (1="" point)="" what="" is="" the="" average="" and="" standard="" deviation="" of="" the="" right="" testis="" collected="" from="" site="" a?="" 2.="" (1="" point)="" which="" season="" has="" the="" largest="" follicle="" volume?="" name="" it="" and="" give="" the="" average="" and="" standard="" 3,31.2="" https://ilearn.mq.edu.au/pluginfile.php/5915872/mod_page/content/7/data%20for%20example%20for%20assignment%20v2.xlsx="" https://ilearn.mq.edu.au/pluginfile.php/5915872/mod_page/content/7/data%20for%20example%20for%20assignment%20v2%20word.docx="" 27/8/19,="" 5*46="" pmbiol260_shfyr_2019_all_u:="" science="" literacy="" assessment="" 4="" -="" handling="" data="" page="" 3="" of="" 3https://ilearn.mq.edu.au/mod/page/view.php?id="5306572" ©="" copyright="" macquarie="" university="" |="" confidentiality="" &="" privacy="" statement="" you="" are="" logged="" in="" as="" amanuel="" assefa="" (log="" out)="" 2.="" (1="" point)="" which="" season="" has="" the="" largest="" follicle="" volume?="" name="" it="" and="" give="" the="" average="" and="" standard="" deviation.="" 3.="" (3="" points)="" make="" a="" graph="" of="" averages="" with="" error="" bars="" of="" the="" oviduct="" weights="" across="" season.="" last="" modified:="" monday,="" 19="" august="" 2019,="" 2k12="" pm="" general="" ilearn="" or="" it="" question?="" help.mq="" ilearn="" info="" library="" handbook="" unit="" guides="" learning="" and="" teaching="" policies="" security="" confidentiality="" &="" privacy="" statement="" students="" ilearn="" quick="" guides="" for="" students="" general="" question?="" ask.mq="" it="" information="" (printing,="" ilab,="" technologies)="" student="" life="" -="" help="" and="" advice="" email="" estudent="" student="" policy="" gateway="" staff="" ilearn="" quick="" guides="" for="" staff="" l&t="" workshops="" and="" services="" iteach="" (ilearn="" &="" unit="" guides="" setup)="" echo360="" lecture="" recordings="" info="" teds="" (evaluation="" surveys)="" http://www.mq.edu.au/ilearn/student_info/confidentiality.htm="" https://ilearn.mq.edu.au/user/profile.php?id="227879" https://ilearn.mq.edu.au/login/logout.php?sesskey="WAtwrvTKad" http://help.mq.edu.au/="" http://help.ilearn.mq.edu.au/="" http://www.mq.edu.au/on_campus/library/="" http://handbook.mq.edu.au/="" http://unitguides.mq.edu.au/="" https://staff.mq.edu.au/work/strategy-planning-and-governance/university-policies-and-procedures/policy-central="" http://www.mq.edu.au/security="" https://ishare.mq.edu.au/prod/file/dbc1a9c8-7bcd-4a60-a4a1-f46ab50af7b2/1/ilearn%20confidentiality%20and%20privacy%20collection%20statement.pdf="" https://students.mq.edu.au/support/study/tools-and-resources/ilearn/ilearn-quick-guides-for-students="" http://ask.mq.edu.au/="" http://students.mq.edu.au/it_services/="" http://students.mq.edu.au/support/="" https://mail.google.com/="" https://student1.mq.edu.au/="" https://students.mq.edu.au/support/study/student-policy-gateway="" https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/ilearn-quick-guides-for-staff="" https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/ilearn-training-and-workshops="" https://iteach.mq.edu.au/="" https://staff.mq.edu.au/teach/learning-technologies-and-spaces/teaching-technologies-and-tools/ilearn/lecture-recordings="">