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.



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


Teaching Standards

1.1.2 Proficient Level - Know students and how they learn - Physical, social and intellectual development and characteristics of students:  Use teaching strategies based on knowledge of students’ physical, social and intellectual development and characteristics to improve student learning,

1.5.2 Proficient Level - Know students and how they learn - Differentiate teaching to meet the specific learning needs of students across the full range of abilities:  Develop teaching activities that incorporate differentiated strategies to meet the specific learning needs of students across the full range of abilities,

1.6.2 Proficient Level - Know students and how they learn - Strategies to support full participation of students with disability:   Design and implement teaching activities that support the participation and learning of students with disability and address relevant policy and legislative requirements,

2.1.2 Proficient Level - Know the content and how to teach it - Content and teaching strategies of the teaching area:  Apply knowledge of the content and teaching strategies of the teaching area to develop engaging teaching activities,

3.1.2 Proficient Level - Plan for and implement Effective Teaching and Learning - Establish challenging learning goals:   Set explicit, challenging and achievable learning goals for all students,

4.5.2 Proficient Level - Create and maintain supportive and safe learning environments - Use ICT safely, responsibly and ethically:  Incorporate strategies to promote the safe, responsible and ethical use of ICT in learning and teaching,

6.1.2 Proficient Level - Engage in Professional Learning - Identify and plan professional learning needs:  Use the Australian Professional Standards for Teachers and advice from colleagues to identify and plan professional learning needs,

7.2.2 Proficient Level - Engage professionally with colleagues, parents/carers and the community -  legislative, administrative and organisational requirements:   Understand the implications of and comply with relevant legislative, administrative, organisational and professional requirements, policies and processes


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

Completing “Maths with Google Sheets: Statistics-Univariate & Bivariate Data” before 4th February 2022 under NESA’s interim arrangements will contribute 6 hours of NSW Education Standards Authority (NESA) Accredited PD in the priority area of Delivery and assessment of NSW curriculum addressing standard descriptors  1.1.2, 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.


Course curriculum

  • 1

    Getting Started

    • Introduction

    • Aims and Objectives

    • Overview & Resources

    • Organising Your Google Drive

    • Reflection

  • 2

    Two-Way Table & Segmented Bar Chart

    • Aims and Objectives

    • Re-coding Variables

    • Constructing Two-Way Table

    • Constructing Segmented Bar Chart

    • Reflection

  • 3

    Bivariate Data Analyses 1

    • Aims and Objectives

    • Summary Statistics

    • Histogram

    • Correlation Matrix

    • Scatter plot

    • Residual Plot

    • Multiple linear regression

    • Centering about the mean

    • Reflection

  • 4

    Bivariate Data Analyses 2

    • Aims and Objectives

    • Examining confounding (Part A)

    • Examining confounding (Part B)

    • Binary explanatory variable

    • Reflection

  • 5


    • Key Ideas

    • Course Feedback

Features of TTA Online PD

  • Availability

    Online courses are available 24/7. Designed to be done in your own time at your own pace.

  • Team Online

    All online courses are available for team purchase. Unlimited teachers from the one Campus for any course for $990 + GST

  • Money back Guarantee

    If you complete less than 25% of an online course and aren't completely satisfied, let us know, and we will cancel your enrolment and provide a full refund.