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

Completing Maths with Google Sheets: Statistics - Univariate and Bivariate Data  will contribute 6 hours of NSW Education Standards Authority (NESA) Accredited PD in the priority area of Delivery and assessment of NSW Curriculum/Early Years Learning Framework addressing standard descriptors 2.6.2, 3.4.2 from the Australian Professional Standards for Teachers towards maintaining Proficient Teacher Accreditation in NSW.

Course 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.    

 Teaching Standards

2.6.2 Proficient Level - Know the content and how to teach it - Information and Communication Technology (ICT):  Use effective teaching strategies to integrate ICT into learning and teaching programs to make selected content relevant and meaningful

3.4.2 Proficient Level - Plan for and implement Effective Teaching and Learning - Select and use resources:  Select and/or create and use a range of resources, including ICT, to engage students in their learning

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

    Summary

    • 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 $1250 + 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.