Author: Brian Clark

27 March 16:00 – 15:00, This Is Data Session 3

This Is Data

You may have seen spreadsheet dashboards that react to use interactions, automatically filtering and updating charts and tables. Ever wondered how to do it? This short course will support you to develop you skills to store and process data using tools you already use.

These sessions will show you how to use tables, slicers, pivot tables and charts to bring your data to life. You will be able to use these skills to look at your own data and / or share these skills with pupils as part of their learning.

  • Sample data files will be provided.
  • Basic knowledge of excel will be useful.
  • This set of sessions will make use of Microsoft Excel.

Sign up here for some or all of the sessions below

Session 1 – Monday 13th March 4pm

Preparing data for analysis  – the importance of structuring data in tables, using slicers to filter data, conditional formatting, data validation, custom views and useful formulae

Session 2 – Monday 20th March 4pm

Creating Visual Interactive Dashboards – using your data to create pivot tables and visualisations then bring them together into a single user dashboard

Session 3 – Monday 27th March 4pm

Linking Data – how to link tables and visualise results that draw from more than one data source.

20 March 16:00 – 17:00, This Is Data Session 2

This Is Data

You may have seen spreadsheet dashboards that react to use interactions, automatically filtering and updating charts and tables. Ever wondered how to do it? This short course will support you to develop you skills to store and process data using tools you already use.

These sessions will show you how to use tables, slicers, pivot tables and charts to bring your data to life. You will be able to use these skills to look at your own data and / or share these skills with pupils as part of their learning.

  • Sample data files will be provided.
  • Basic knowledge of excel will be useful.
  • This set of sessions will make use of Microsoft Excel.

Sign up here for some or all of the sessions below

Session 1 – Monday 13th March 4pm

Preparing data for analysis  – the importance of structuring data in tables, using slicers to filter data, conditional formatting, data validation, custom views and useful formulae

Session 2 – Monday 20th March 4pm

Creating Visual Interactive Dashboards – using your data to create pivot tables and visualisations then bring them together into a single user dashboard

Session 3 – Monday 27th March 4pm

Linking Data – how to link tables and visualise results that draw from more than one data source.

13 March 16:00, This Is Data Session 1

This Is Data

You may have seen spreadsheet dashboards that react to user interactions, automatically filtering and updating charts and tables. Ever wondered how to do it? This short course will support you to develop your skills to store and process data using tools you already use.

These sessions will show you how to use tables, slicers, pivot tables and charts to bring your data to life. You will be able to use these skills to look at your own data and / or share these skills with pupils as part of their learning.

  • Sample data files will be provided.
  • Basic knowledge of excel will be useful.
  • This set of sessions will make use of Microsoft Excel.

Sign up here for some or all of the sessions below

Session 1 – Monday 13th March 4pm

Preparing data for analysis  – the importance of structuring data in tables, using slicers to filter data, conditional formatting, data validation, custom views and useful formulae

Session 2 – Monday 20th March 4pm

Creating Visual Interactive Dashboards – using your data to create pivot tables and visualisations then bring them together into a single user dashboard

Session 3 – Monday 27th March 4pm

Linking Data – how to link tables and visualise results that draw from more than one data source.

Computing Science: Skill Building CLPL for CfE Level 3

Join us for one or more computing science skill building sessions every Tuesday at 4pm for 6 weeks from 10th January.

This first set of sessions are designed to support teachers build their own knowledge and confidence in aspects of Computing Science at 3rd Level (CfE) including:

  • Coding with Scratch to create animations, simulations and games
  • Web Development with HTML and CSS

Each workshop will last 1 hour and include template resources and activities.

These workshops will suit those who are / would like to offer Computing Science experiences at 3rd Level of the BGE and would like support in developing their understanding of these topics.  Sign up to all or some of the sessions using the button at the end of this post.

 

Tuesday 10th January

  • Animating with Scratch – learn how Scratch can be used to bring a story/topic to life using code

Tuesday 17th January

  • Creating interactions with Scratch – learn how to code simple programs that interact with the user (eg quizzes)

Tuesday 24th January

  • Creating Games with Scratch – create simple games with Scratch, building on skills and knowledge from the two previous sessions.

Tuesday 31st January

  • Build a simple web page that includes text, media and links with HTML and CSS

Tuesday 7th February

  • Learn to style web pages using cascading style sheets

Tuesday 14th February

  • Create multi page websites, building on skills and knowledge from the two previous sessions.

 

Sign Up To Sessions

 

Practitioner enquiry

CLPL Home

Practitioners should be able:

  • To engage in self and collaborative review to measure the impact of digital tools and technologies. 

  • To produce and share practitioner enquiry into the use of digital tools and technologies. 

Support and Examples

Explore Practitioner Enquiry from The General Teaching Council for Scotland

Find out more about the Educator Leadership Programme from Education Scotland

Research and evidence informed practice

CLPL Home

Practitioners should:

  • Engage with the main theoretical perspectives and research in the digital learning domain.

  • Be critically aware of the evidence and impact that digital tools, spaces and cultures can have on childhood and society and how digital learning and teaching can adapt to meet the needs of learners. 

Support and Resources

Digital Education Research Articles from Imperial College
Over 60 collated articles on the topic of digital education, including: “How multimedia can improve learning and instruction”, “Using Cognitive Load Theory to improve slideshow presentations” and “Using technology to promote metacognition”

Digital learning research | Teaching and Learning and Leadership
This collection of research from the Australian Council for Educational Research includes recent papers such as “Rapid review of effective practice principles in the design and delivery of digital resources for teachers” (Syeda Kashfee Ahmed, Pru Mitchell, and Jenny Trevitt) amd “What sources of data did teachers use to inform remote teaching under Covid-19?” (Anne-Marie Chase, Kathryn Richardson, and Nathanael Reinertsen)

Using Digital Technology to Improve Learning 
From 2019, the Educational Endowment Foundation set out 4 recommendations
1. Consider how technology will improve teaching and learning before introducing it
2. Technology can be used to improve the quality of explanations and modelling
3. Technology offers ways to improve the impact of pupil practice
4. Technology can play a role in improving assessment and feedback

Digital Learning and Teaching on the National Improvement Hub
This page from Education Scotland will support policy makers and practitioners from all sectors to embed digital learning and teaching across the curriculum.

Call Scotland
Call Scotland have been a Research and Development centre as well as a working Service unit since 1983, supporting teachers and learners overcome barriers to learning.  This site provides access to support and resources to enable all learners access the curriculum using digital teachnology.

 

You may wish to look at digital learning theories and approaches, such as  RAT, SAMR, TPACK, Digital Blooms, Connectivism, Design Thinking and Peeragogy 

Other Interesting Links