LINKS
The SAAIR Learner Analytics Workshop, hosted by North-West University, was a virtual event held on the 27th-28th May 2021. The response from our SAAIR community was overwhelming, with all 30 spaces fully booked.
The workshop aimed to provide participants with basic skills in a SQL server environment and SQL programming. Participants acquired a range of skills including how to install, setup and use the SQL Server environment. They were also taught how to use SQL programming to view, join, aggregate, filter and edit database tables.
As our first virtually-run technical workshop, the Learner Analytics event, was not without a few minor challenges. Thanks to the excellent team at North-West University, however, these initial challenges were quickly resolved, and the event offered valuable insights for future online technical workshops.
Feedback attests to the event’s success, with participants having rated the workshop as excellent in terms of theme relevance, content and presentation. Members mentioned that while they enjoyed engaging within the workshop and breakout rooms, they missed face-to-face engagements with peers, which offered the opportunity to build and strengthen networks.
Overall, the workshop was a resounding success and SAAIR would like to commend Jan-Hendrik and his team for an exceptional effort in hosting and running a successful Learner Analytics Workshop in 2021.
Hosted by North-West University
Further information about the Learner Analytics Workshop:
Based on the survey we did last year we have decided that the Learner Analytics workshop on 27-28 May 2021 will focus on introducing attendees to SQL and SQL server. Therefore, this workshop will be aimed at people with little to no experience in these areas. SAAIR members with previous SQL experience will not benefit from the workshop.
In the workshops attendees will learn how to:
- Install and setup the SQL Server environment
- Create databases, tables and import data
- About Fact tables and dimensions
- Views
Attendees will learn how to use SQL programming to:
- View your data
- Aggregate data
- Join multiple data sets
- Filter and sort data
- Edit data
- Create temporary data tables
The skills transfer will be done by working with typical Institutional Research and MIS examples.
To assist attendees to master the skills taught in the workshop we will be presenting and demonstrating concepts in a session and then follow it by a breakaway session where attendees will attempt to implement the subject matter learnt in the demonstration. There will be a facilitator in each breakaway room to assist should it be needed.
We can unfortunately only accommodate a maximum number of 30 attendees. (5 per facilitator)
It would assist us if we can close registrations a week or two before the workshop as to assist those registered with installing SQL Server before the workshop takes place. We will be sending a link to all those registered with installation instructions and a contact to assist them should they struggle with the installation.
VERY IMPORTANT – please take note : Attendees need to attend the entire session on both days, or they will get lost and the workshop will have no meaning at all!
Kind regards
Carin Strydom
SAAIR Coordinator/Administrator
Tel 071 160 5458
Email : admin@saair.net