About this course
This self-directed course teaches you how to transform live data from The Everlearner platform into a visual tracking and monitoring tool using a simple conditionally formatted excel spreadsheet found in the Premium Membership package.
Export the raw ‘Live Data’ from The Everlearner Dashboard and transform it into a visual leader board using the conditionally formatted Excel spreadsheet from PE4Learning
The pack contains two resources to transform your raw data into a visually striking leader board. The basic version is a one-off centre snapshot of a selected group from the Everlearner Platform.
The advanced version allows you to export and convert raw data periodically over the course and show progress over time with elements of the basic centre snapshot version incorporated into the design. The spreadsheet visually demonstrate progress made not from the start of the course but from each periodic checkpoint to see who has and who has not spent time on the platform since the last time the teacher checked.
You will learn how to:
- export live data from a .csv file
- copy and paste excel data into a conditionally formatted macro enabled spreadsheet
- track progress on the Everlearner platform using the PE4Learning created spreadsheet
You will need:
- access to a desktop PC
- access to Microsoft Excel
- access to The Everlearner Dashboard