Maths with Google Sheets: Statistics-Univariate & Bivariate Data

 
Maths with Google Sheets: Statistics-Univariate & Bivariate Data
Nazim Khan
Maths Teacher with Passion for Technology Integration, Data Analysis and Modelling
Integrating Google Sheets and Google Docs and using real-world data to discover statistical concepts in Years 7-12.
Target Audience
This PL is intended for teachers of Years 7-12 Mathematics courses.
8 reviews
50
Download PDF

Share on Facebook Share on Twitter Share on LinkedIn

Learning Areas

Teaching Standards

  • 1.1.2 Proficient Level - Physica...

    Use teaching strategies based on knowledge of students’ physical, social and intellectual development and characteristics to improve student learning. (All States:National Standard 1.1 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -1.1.2})
  • 1.5.2 Proficient Level - Differe...

    Develop teaching activities that incorporate differentiated strategies to meet the specific learning needs of students across the full range of abilities. (All States:National Standard 1.5 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -1.5.2})
  • 2.3.2 Proficient Level - Curricu...

    Design and implement learning and teaching programs using knowledge of curriculum, assessment and reporting requirements. (All States: National Standard 2.3 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -2.3.2})
  • 3.1.2 Proficient Level - Establi...

    Set explicit, challenging and achievable learning goals for all students. (All States: National Standard 3.1 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -3.1.2})
  • 3.4.2 Proficient Level - Select ...

    Select and/or create and use a range of resources, including ICT, to engage students in their learning. (All States:National Standard 3.4 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -3.4.2})
  • 4.5.2 Proficient Level - Use ICT...

    Incorporate strategies to promote the safe, responsible and ethical use of ICT in learning and teaching. (All States:National Standard 4.5 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -4.5.2})
  • 6.2.2 Proficient Level - Engage ...

    Participate in learning to update knowledge and practice, targeted to professional needs and school and/or system priorities. (All States:National Standard 6.2 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -6.2.2})
  • 7.1.2 Proficient Level - Meet pr...

    Meet codes of ethics and conduct established by regulatory authorities, systems and schools. (All States:National Standard 7.1 – Proficient Level {NSW uses Australian Professional Standards for Teachers code -7.1.2})

General Description

Maths with Google Sheets is one of a series of three Professional Learning (PL) Courses on how to effectively integrate Google Sheets to enhance the teaching, learning and assessing of Secondary School Mathematics courses. This particular series is called ‘Statistics (Univariate and Bivariate Data Analysis. The other two courses are ‘Maths with Google Sheets: Financial Maths’ and ‘Maths with Google Sheets: Time Series Analysis’. The objective is to empower teachers who will in turn enable their students to make connections between the mathematics that they learn in the classroom with those that is applied in the real-world. This approach has been proven to motivate students to value the subject and increase their engagement and inquisitiveness. This objective is achieved by using real world data and scenarios to develop various mathematical concepts.

Audience

This PL is intended for teachers of Years 7-12 Mathematics courses.

Available Delivery Formats

Format Description

24/7 course access


IMPORTANT INFORMATION:

- If you have a TTA subscription or membership please ignore the pricing when enrolling. Rest assured if your school has a subscription you will not be charged and for Memberships, your invoice will be adjusted accordingly to reflect your discount.

- If you have no subscription or membership but you are interested in placing a bulk discounted order for a team of teachers see the ONLINE TEAM tab above.

- For more details on our Unlimited Online Subscription packages Click here .

- Money-Back Guarantee – If you complete less than 25% of an online course and aren’t impressed, simply visit tta.edu/go/refund to let us know what happened, and we will cancel your enrolment and provide a full refund.

Participants will receive step-by-step written instructions (including reference to further resources on the internet) and the relevant real-world data to work at their own pace in their own time. They will follow the instructions and reproduce the results (statistical calculations and graphics given in the instructions). Assistance will be available via email or via any other means deemed appropriate by TTA.

Participants will download 3 documents from the following weblink:
https://sites.google.com/view/technology-in-mathematics/home
Go to the section named ‘MATHS WITH GOOGLE SHEETS: Statistics (Univariate and Bivariate Data Analyses) and download the following three documents:
1. Instructions
2. Report
3. Data

Participants will be instructed in the later sections on how to create a folder in Google Drive and store these 3 documents in that folder.

Teaching Standards
1.1.2 Proficient Level – Physical, social and intellectual development and characteristics of students
1.5.2 Proficient Level – Differentiate teaching to meet the specific learning needs of students across the full range of abilities
1.6.2 Proficient Level – Strategies to support full participation of students with disability
2.1.2 Proficient Level – Content and teaching strategies of the teaching area
3.1.2 Proficient Level – Establish challenging learning goals
4.5.2 Proficient Level – Use ICT safely, responsibly and ethically
6.1.2 Proficient Level – Identify and plan professional learning needs
7.2.2 Proficient Level – legislative, administrative and organisational requirements

Are you in NSW? If so, this is relevant for you

Completing Maths with Google Sheets: Statistics-Univariate & Bivariate Data before 31 July 2021 under NESA’s interim arrangements will contribute 6 hours and 0 minutes of NSW Education Standards Authority (NESA) Accredited PD in the priority area of Delivery and assessment of NSW curriculum addressing standard descriptors 1.2.1, 1.5.2, 1.6.2, 2.1.2, 3.1.2, 4.5.2, 6.1.2, 7.2.2 from the Australian Professional Standards for Teachers towards maintaining Proficient Teacher Accreditation in NSW.


This course contributes to 6.0 professional development hours.

Occurrences

There are no occurrences of 2. Online in Australia (ACT) at this time.

Check availability of occurrences for Online - Team

Sessions

Introduction to the Course, Google Sheets, Google Docs and Data

2 hours

This session will provide an easy to follow, step-by-step overview of the course content (statistical concepts in Years 7-12 Mathematics courses), introduction to Google Sheets and Google Docs(Google applications that will be used throughout the course) and a real-world data (this will be provided in Google Sheets format) to be analysed using Google Sheets.

Participants will download 3 documents from the following weblink:
https://sites.google.com/view/technology-in-mathematics/home
Go to the section named ‘MATHS WITH GOOGLE SHEETS: Statistics (Univariate and Bivariate Data Analyses) and download the following three documents:
1. Instructions
2. Report
3. Data

Participants will be instructed on how to create a folder in Google Drive and store these 3 documents in that folder.

Two-Way Table and Segmented Bar Chart

40 minutes

Participants will follow step-by-step instructions (given in the Google Docs ‘Instructions’) to reproduce a Two-Way Table and the corresponding Segmented Bar Chart using the given ‘Data’ in Google Sheets. They will copy the output from Google Sheets into the Google Docs ‘Report’. Result interpretation is provided in the Google Docs ‘Instructions’.

Bivariate Data Analyses 1

2 hours

Participants will follow step-by-step instructions (given in the Google Docs ‘Instructions’) to obtain summary statistics, histogram, correlation matrix, scatter plot, regression equation, residual plot and coefficient of determination using the given ‘Data’ in Google Sheets. They will copy the output from Google Sheets into the Google Docs ‘Report’. Result interpretation is provided in the Google Docs ‘Instructions’.

Bivariate Data Analyses 2

40 minutes

Participants will follow step-by-step instructions (given in the Google Docs ‘Instructions’) to obtain separate scatter plots and regression equations for two levels of political rights using the given ‘Data’ in Google Sheets. They will copy the output from Google Sheets into the Google Docs ‘Report’. Result interpretation is provided in the Google Docs ‘Instructions’.

Bivariate Data Analyses 3

40 minutes

Participants will follow step-by-step instructions (given in the Google Docs ‘Instructions’) to examine possible association between a continuous variable and a binary variable using the given ‘Data’ in Google Sheets. They will copy the output from Google Sheets into the Google Docs ‘Report’. Result interpretation is provided in the Google Docs ‘Instructions’.

User Rating

4.1

Latest Reviews

Please note the feedback listed here is unfiltered, and includes all comments and ratings collected.

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/10/2020

The videos were easy to follow and well made. The resrouces we used were easy to access. It was more helpfful when the videos were specifically made for the data we were using and shown in a simple step by step approach. Unfortunately one of the add ons is currently being blocked by Google so I could not complete some components of the training without that add on. Also, this work seemed very advanced and therefore irrelevant to 7-10 and most of the senior years. I could only imagine using 70% of it with very advanced students.

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/10/2020

Excellent. The only drawback would be about the XLMiner add-on that I wasn’t able to install.

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/07/2020

Very interesting and relevant

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/07/2020

The first 75% of the course was relevant to the levels of Mathematics I am teaching and I love the step by step instructions. I was able to work alongside the presenter in real time to produce the graphs and analyse the data.

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/07/2020

80% of the content is relevant and falls within the course work of Year 7 to 12. The rest – 20% is appreciated as it enables us as teachers to develop a greater understanding of where the key elements in statistics are applied in a real-world context.

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
08/07/2020

Some parts of the course were beyond the scoe of the syllabus

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
18/04/2020

Excellent!

Maths with Google Sheets: Statistics-Univariate & Bivariate Data - Nazim Khan
18/04/2020

This course was very interesting. I already knew how to use a spreadsheet software such as Excel with statistics but not so much Google sheets. Our school has decided to use G-suite therefore, I feel more proficient now that I finished the course.


About the team


Nazim Khan

Creator

I am an enthusiastic Mathematics teacher, passionate about integrating technology and real-life data in Mathematics teaching and learning. My specialist fields are Mathematics and Statistics in which I have over 18 years of teaching and 2 years of research experience.

My teaching experience involved over 13 years at various secondary schools and 5 years at various tertiary institutes in Australia and Fiji. Further, for 2 years I have worked at the Australian National University as a Research Assistant.

At secondary school level I have taught Mathematics from Years 7 to 12, and have also been a pastoral care teacher and member of various school committees. At tertiary level, I have taught Mathematics and Statistics (undergraduate level), and Biostatistics (undergraduate and postgraduate levels) via both face-to-face and distance education modes. My other experiences at tertiary level included reviewing and development of courses in Biostatistics, providing statistical advice to students and staff undertaking research, and membership of various staff committees. As a Research Assistant at ANU, I have been involved in analysis of large datasets and preparation of statistical reports.