{"id":9468,"date":"2023-05-09T09:30:00","date_gmt":"2023-05-09T08:30:00","guid":{"rendered":"https:\/\/blogs.sussex.ac.uk\/tel\/?p=9468"},"modified":"2023-05-04T09:16:57","modified_gmt":"2023-05-04T08:16:57","slug":"utilizing-exported-data-from-teaching-and-learning-systems","status":"publish","type":"post","link":"https:\/\/blogs.sussex.ac.uk\/tel\/2023\/05\/09\/utilizing-exported-data-from-teaching-and-learning-systems\/","title":{"rendered":"Utilizing exported data from teaching and learning systems"},"content":{"rendered":"\n
\"\"<\/a><\/figure><\/div>\n\n\n\n

Over the years I have seen and responded to academic and senior management interest in usage data to support teaching and learning. Digital tools often provide access to data to provide insight to how they are being used. This helps better manage our time and effort, as well as resource. For this post, I have asked Benoit Sharp, the ITS trainer, to contribute and help promote the support and resources the University offer.<\/p>\n\n\n\n

Having already mentioned analytics in Online teaching spaces: Exploring the digital myths<\/a>, Microsoft Excel<\/a> allows us to view data in a manageable and meaningful way. Excel files are often referred to as workbooks, which can contain one to many worksheets. Good management of these worksheets, help us utilise these in the longer term. Data can be sorted<\/a> into one or multiple fields\/columns to make it easier to analyse.<\/p>\n\n\n\n

Data, for example Panopto usage data<\/a>, can have filters<\/a> added to reduce what we see to specific areas of interest. There are other options available to manage and view, but another of my favourites is the freeze panes option<\/a>, which allows me to be sure what fields the data is part of with large volumes of data. There is often a need to do more with exported data, like make checks and extract parts of it, and this is where functions and formulas come in. Here are some examples:<\/p>\n\n\n\n