Overview
The unit is designed so that students should be able to evaluate a range of experimental designs and statistical analyses appropriate to investigations in exercise and sport science. Students will be provided with statistical knowledge and skills to organise, analyse and interpret scientific data. Students will be required to utilise and apply statistical software to determine both descriptive and inferential statistical outcomes. The use of statistical/spreadsheet computer package for data analysis is covered. Lecture material will be supplemented by tutorials throughout the unit. Practical examples across all of the scientific disciplines are used in lectures and tutorials.
Details
Pre-requisites or Co-requisites
There are no requisites for this unit.
Important note: Students enrolled in a subsequent unit who failed their pre-requisite unit, should drop the subsequent unit before the census date or within 10 working days of Fail grade notification. Students who do not drop the unit in this timeframe cannot later drop the unit without academic and financial liability. See details in the Assessment Policy and Procedure (Higher Education Coursework).
Offerings For Term 2 - 2019
Attendance Requirements
All on-campus students are expected to attend scheduled classes – in some units, these classes are identified as a mandatory (pass/fail) component and attendance is compulsory. International students, on a student visa, must maintain a full time study load and meet both attendance and academic progress requirements in each study period (satisfactory attendance for International students is defined as maintaining at least an 80% attendance record).
Recommended Student Time Commitment
Each 6-credit Undergraduate unit at CQUniversity requires an overall time commitment of an average of 12.5 hours of study per week, making a total of 150 hours for the unit.
Class Timetable
Assessment Overview
Assessment Grading
This is a graded unit: your overall grade will be calculated from the marks or grades for each assessment task, based on the relative weightings shown in the table above. You must obtain an overall mark for the unit of at least 50%, or an overall grade of ‘pass’ in order to pass the unit. If any ‘pass/fail’ tasks are shown in the table above they must also be completed successfully (‘pass’ grade). You must also meet any minimum mark requirements specified for a particular assessment task, as detailed in the ‘assessment task’ section (note that in some instances, the minimum mark for a task may be greater than 50%). Consult the University’s Grades and Results Policy for more details of interim results and final grades.
All University policies are available on the CQUniversity Policy site.
You may wish to view these policies:
- Grades and Results Policy
- Assessment Policy and Procedure (Higher Education Coursework)
- Review of Grade Procedure
- Student Academic Integrity Policy and Procedure
- Monitoring Academic Progress (MAP) Policy and Procedure – Domestic Students
- Monitoring Academic Progress (MAP) Policy and Procedure – International Students
- Student Refund and Credit Balance Policy and Procedure
- Student Feedback – Compliments and Complaints Policy and Procedure
- Information and Communications Technology Acceptable Use Policy and Procedure
This list is not an exhaustive list of all University policies. The full list of University policies are available on the CQUniversity Policy site.
Feedback, Recommendations and Responses
Every unit is reviewed for enhancement each year. At the most recent review, the following staff and student feedback items were identified and recommendations were made.
Feedback from Unit Evaluations and Moodle Forums
Students found the step-by-step tutorial videos helped them understand basic features of Excel and how to perform statistical analyses within Excel. However, some differences in the version of Excel used to record tutorial videos and versions students were using caused confusion.
Tutorial videos will continue to be provided along with additional resources related to Excel basics which should address differences between versions. Students will also be encouraged to see additional resources and use the Forums to seek clarification.
Feedback from Unit Evaluations
Students enjoyed the assessment items and seeing how statistics are applied in the real world.
Continue to provide authentic assessments that align with learning outcomes of the unit.
Feedback from Unit Evaluations and Self-reflection
Lectures tend to be long and contain a large amount of information. Students appear to gain more from the tutorial activities.
A review of the lecture content will be undertaken to determine best mode of delivery for the unit. Including opportunities for flipped classroom with lectures pre-recorded and the face-to-face delivery involving tutorial activities.
- Evaluate a range of experimental designs and statistical analyses appropriate to investigations in exercise and sport science.
- Demonstrate knowledge and ability in collating, organising and displaying affective data
- Utilise descriptive and inferential statistics to make decisions
- Apply statistical software to analyse, manage and describe statistical relationships.
Alignment of Assessment Tasks to Learning Outcomes
| Assessment Tasks | Learning Outcomes | |||
|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |
| 1 - Online Quiz(zes) - 20% | ||||
| 2 - Written Assessment - 35% | ||||
| 3 - Written Assessment - 45% | ||||
Alignment of Graduate Attributes to Learning Outcomes
| Graduate Attributes | Learning Outcomes | |||
|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |
| 1 - Communication | ||||
| 2 - Problem Solving | ||||
| 3 - Critical Thinking | ||||
| 4 - Information Literacy | ||||
| 5 - Team Work | ||||
| 6 - Information Technology Competence | ||||
| 7 - Cross Cultural Competence | ||||
| 8 - Ethical practice | ||||
| 9 - Social Innovation | ||||
| 10 - Aboriginal and Torres Strait Islander Cultures | ||||
Alignment of Assessment Tasks to Graduate Attributes
| Assessment Tasks | Graduate Attributes | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
| 1 - Online Quiz(zes) - 20% | ||||||||||
| 2 - Written Assessment - 35% | ||||||||||
| 3 - Written Assessment - 45% | ||||||||||
Textbooks
Statistics for People Who (Think They) Hate Statistics :Using Microsoft Excel 2016
Edition: 4th edn (2016)
Authors: Salkind , Neil
Sage Publications
London London , UK
ISBN: 9781483374086
Binding: Paperback
Additional Textbook Information
Electronic version of this textbook can be found online via a number of sources listed on Sage Publishing. However, if you prefer a paper text, they are still available at the CQUni Bookshop here: http://bookshop.cqu.edu.au
IT Resources
- CQUniversity Student Email
- Internet
- Unit Website (Moodle)
- Adobe Acrobat Reader (or similar) software for viewing PDF documents
- Excel 2016 (onwards) with Data Analysis Toolpak
- ZOOM Videoconferencing software. A ZOOM account is available with your student credentials. We will use this software for review meetings.
All submissions for this unit must use the referencing style: American Psychological Association 6th Edition (APA 6th edition)
For further information, see the Assessment Tasks.
b.humphries@cqu.edu.au
s.fien@cqu.edu.au
Module/Topic
Introduction to Statistics and the Wonderful World of Excel
Chapter
Chapter 1 Statistics or Sadistics? It's Up to You
Chapter 6 Just the Truth: An Introduction to Understanding Reliability and Validity
Appendix A Excel-erate Your Learning
Events and Submissions/Topic
Module/Topic
Descriptive Statistics and How to Present Them
Chapter
Chapter 2 Computing and Understanding Averages: Means to an End
Chapter 3 Vive la Difference: Understanding Variability
Chapter 4 A Picture Really Is Worth a Thousand Words
Events and Submissions/Topic
Module/Topic
So You Want to Be a Scientist?
Introduction to Research and Hypothesis Testing
Chapter
Chapter 7 Hypotheticals and You: Testing Your Questions
Online Material
Events and Submissions/Topic
Module/Topic
Testing Your Research Question: Importance of Normal Distribution and Introduction to Inferential Statistics
Chapter
Chapter 8 Are Your Curves Normal? Probability and Why It Counts
Chapter 9 Significantly Significant: What It Means for You and Me
Events and Submissions/Topic
Module/Topic
Analysing Categorical Data
Chapter
Chapter 17 What to Do When You’re Not Normal: Chi-Square and Some Other Nonparametric Tests
Online Material
Events and Submissions/Topic
Module/Topic
Chapter
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 1: Testing for Differences with a Single Sample
Chapter
Chapter 10 Only the Lonely: The One-Sample Z-Test
Online Material
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 2: Testing for Differences between Two Independent Samples – Parametric and Nonparametric Tests
Chapter
Chapter 11 t(ea) for Two: Tests Between the Means of Different Groups
Online Material
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 3: Testing for Differences between Two Dependent Samples – Parametric and Nonparametric Tests
Chapter
Chapter 12 t(ea) for Two: Tests Between the Means of Related Groups
Online Material
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 4: Testing for Differences between More Than Two Independent Samples – Parametric and Nonparametric Tests
Chapter
Chapter 13 Two Groups Too Many? Try Analysis of Variance
Online Material
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 5: Testing for Differences between More Than Two Dependent Samples – Parametric vs Nonparametric Tests
Chapter
Online Material
Events and Submissions/Topic
Module/Topic
Analysing Interval/Ratio Data Part 6: Testing for Associations and Predictions – Parametric and Nonparametric Tests
Chapter
Chapter 5 Ice Cream and Crime: Computing Correlation Coefficients
Chapter 15 Cousins or Just Good Friends? Testing Relationships Using Correlation Coefficient
Chapter 16 Predicting Who’ll Win the Super Bowl: Using Linear Regression
Events and Submissions/Topic
Module/Topic
Unit Wrap-up
Chapter
Events and Submissions/Topic
Module/Topic
Chapter
Events and Submissions/Topic
Module/Topic
Chapter
Events and Submissions/Topic
1 Online Quiz(zes)
This assessment item consists of one (1) online quiz and will assess a wide range of unit material covered in Week 1 through to (and inclusive of) Week 4.The quiz is to be completed individually using multiple resources (i.e. lecture and tutorial videos with accompanying notes, and the textbook) to help answer the questions. The quiz will consist of forty (40) multiple-choice questions that will be drawn randomly from a larger pool of questions.
The quiz will be available during the following times: Open Date: Week 4 Wednesday (7 August 2019) at 5:00 pm AEST.
Close Date: Week 5 Wednesday (14 August 2019) at 5:00 pm AEST.
It is your responsibility to log on to Moodle and complete the quiz during the time the quiz is available. You can only attempt the quiz once and it must be completed in a single session. Once you have commenced the quiz, you will have one (1) hour to complete the quiz. You cannot save your answers and return to the quiz at a later time. In the absence of an approved extension there will be no late submissions allowed.
1
Other
Week 5 Wednesday (14 Aug 2019) 5:00 pm AEST
You must log onto Moodle between the specified Open and Close Dates to complete the quiz using the Moodle Online Quiz System.
Week 5 Wednesday (14 Aug 2019)
You will receive the overall result for the quiz upon completion; however, you will see feedback regarding the correct answers for each question upon closure of the quiz (Week 5 Wednesday at 5:00 pm AEST).
Answers will either be correct or incorrect and tabulated by the Moodle Online Quiz System.
- Evaluate a range of experimental designs and statistical analyses appropriate to investigations in exercise and sport science.
- Demonstrate knowledge and ability in collating, organising and displaying affective data
- Communication
- Critical Thinking
- Ethical practice
2 Written Assessment
You will be provided with an Excel file that will contain a set of data for which you will need to perform a series of analyses. The assessment questions will be based on material covered in Week 1 through to (and inclusive of) Week 7 and will include the following:
1. Use of Built-in Excel Functions
2. Construction of a Frequency Distribution Table and Histograms
3. Calculating and Summarising Descriptive Statistics
4. Statistical Analysis of Categorical Data and Summarising Findings of the Analysis
5. Conducting a Statistical Test of Differences and Summarising Findings of the Analysis
To complete this assessment, you must answer the questions on the provided Excel file. Answers must be clearly organised and using APA formatting as required. This task is to be completed individually. You may use multiple resources to help answer the questions. A copy of the data sets and questions for this assessment will be made available (as an Excel file) at the start of Week 3 on the unit Moodle site. Each question will provide a breakdown of marks available for the correct answers.
Week 8 Wednesday (11 Sept 2019) 5:00 pm AEST
The completed Excel file will be submitted via the Moodle Online Assignment upload link.
Week 10 Wednesday (25 Sept 2019)
Feedback and grade will be returned via the unit Moodle site.
Marking will be based on the following criteria:
1. Appropriate use and presentation of Excel functions and statistical analyses
2. Appropriate summary of statistical findings including APA formatting
- Evaluate a range of experimental designs and statistical analyses appropriate to investigations in exercise and sport science.
- Demonstrate knowledge and ability in collating, organising and displaying affective data
- Utilise descriptive and inferential statistics to make decisions
- Apply statistical software to analyse, manage and describe statistical relationships.
- Communication
- Problem Solving
- Critical Thinking
- Information Literacy
- Information Technology Competence
3 Written Assessment
For this assessment item, you will be provided an Excel file with a set of data and six (6) research scenarios/questions. For each research scenario you will be required to conduct an appropriate statistical analysis to answer the proposed question. You may also need to conduct some preliminary analyses to determine the appropriate statistical analysis necessary to answer the question. In addition to the statistical analysis, you will also provide a written summary detailing the analysis that was completed and the results of the statistical analysis.
To complete this assessment, you must upload two (2) files (one (1) Excel file and one (1) Word file):
1. Excel file – For each data set and associated research question, you must conduct the appropriate analyses on the provided Excel file. Your data and analyses must be clearly formatted/organised.
2. Word file – For each data set and associated research question, you must write a brief summary reporting the statistical analysis and the findings (along with any requested tables or figures) in APA format. The summary for each data set and associated research question should be no more than 150 words. NOTE: Simply copying data from the Excel spreadsheet and embedding into the Word file will NOT suffice for this assessment piece.
This task is to be completed individually. You may use multiple resources to help answer the questions. A copy of the data sets and research questions for this assessment will be made available (as an Excel file) at the start of Week 7 on the unit Moodle site. Please note, the analyses required for this assessment will be based on material covered in Week 7 through to (and inclusive of) Week 11.
A marking rubric is available on the unit Moodle site.
Review/Exam Week Wednesday (16 Oct 2019) 5:00 pm AEST
Both the Excel and Word files will be submitted via the Moodle Online Assignment upload link.
Assessment results will be returned upon certification of grades.
Marking will be based on the following criteria:
1. Appropriate use and presentation of Excel statistical analyses to answer each proposed research question
2. Appropriate summary and interpretation of statistical findings including APA formatting (including tables and figures)
- Evaluate a range of experimental designs and statistical analyses appropriate to investigations in exercise and sport science.
- Demonstrate knowledge and ability in collating, organising and displaying affective data
- Utilise descriptive and inferential statistics to make decisions
- Apply statistical software to analyse, manage and describe statistical relationships.
- Communication
- Problem Solving
- Critical Thinking
- Information Literacy
- Information Technology Competence
As a CQUniversity student you are expected to act honestly in all aspects of your academic work.
Any assessable work undertaken or submitted for review or assessment must be your own work. Assessable work is any type of work you do to meet the assessment requirements in the unit, including draft work submitted for review and feedback and final work to be assessed.
When you use the ideas, words or data of others in your assessment, you must thoroughly and clearly acknowledge the source of this information by using the correct referencing style for your unit. Using others’ work without proper acknowledgement may be considered a form of intellectual dishonesty.
Participating honestly, respectfully, responsibly, and fairly in your university study ensures the CQUniversity qualification you earn will be valued as a true indication of your individual academic achievement and will continue to receive the respect and recognition it deserves.
As a student, you are responsible for reading and following CQUniversity’s policies, including the Student Academic Integrity Policy and Procedure. This policy sets out CQUniversity’s expectations of you to act with integrity, examples of academic integrity breaches to avoid, the processes used to address alleged breaches of academic integrity, and potential penalties.
What is a breach of academic integrity?
A breach of academic integrity includes but is not limited to plagiarism, self-plagiarism, collusion, cheating, contract cheating, and academic misconduct. The Student Academic Integrity Policy and Procedure defines what these terms mean and gives examples.
Why is academic integrity important?
A breach of academic integrity may result in one or more penalties, including suspension or even expulsion from the University. It can also have negative implications for student visas and future enrolment at CQUniversity or elsewhere. Students who engage in contract cheating also risk being blackmailed by contract cheating services.
Where can I get assistance?
For academic advice and guidance, the Academic Learning Centre (ALC) can support you in becoming confident in completing assessments with integrity and of high standard.
What can you do to act with integrity?
