{"id":17721,"date":"2023-03-13T17:24:18","date_gmt":"2023-03-13T17:24:18","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/?p=17721"},"modified":"2023-03-21T17:17:41","modified_gmt":"2023-03-21T17:17:41","slug":"20-march-1600-1500-this-is-data-session-2","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/2023\/03\/13\/20-march-1600-1500-this-is-data-session-2\/","title":{"rendered":"20 March 16:00 &#8211; 17:00, This Is Data Session 2"},"content":{"rendered":"<p>This Is Data<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<ul>\n<li>Sample data files will be provided.<\/li>\n<li>Basic knowledge of excel will be useful.<\/li>\n<li>This set of sessions will make use of Microsoft Excel.<\/li>\n<\/ul>\n<p><a id=\"ttfmake-1677070234\" class=\"ttfmake-button\" style=\"background-color: #171717;color: #ffffff;font-size: 20px;font-weight: bold;padding: 4px 10px;border-radius: 100px\" href=\"https:\/\/www.eventbrite.co.uk\/e\/this-is-data-tickets-558678330927\" data-hover-background-color=\"#171717\" data-hover-color=\"#ffffff\"><i class=\"ttfmake-button-icon fa fa-share-square\"><\/i> Sign up here for some or all of the sessions below<\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Session 1 \u2013 Monday 13<sup>th<\/sup> March 4pm<\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000\">Preparing data for analysis \u00a0&#8211; the importance of structuring data in tables, using slicers to filter data, conditional formatting, data validation, custom views and useful formulae<\/span><\/p>\n<p><strong>Session 2 \u2013 Monday 20<sup>th<\/sup> March 4pm<\/strong><\/p>\n<p>Creating Visual Interactive Dashboards \u2013 using your data to create pivot tables and visualisations then bring them together into a single user dashboard<\/p>\n<p><strong>Session 3 \u2013 Monday 27<sup>th<\/sup> March 4pm<\/strong><\/p>\n<p>Linking Data \u2013 how to link tables and visualise results that draw from more than one data source.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip;<\/p>\n","protected":false},"author":58310,"featured_media":17719,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1952],"tags":[2014,2013],"class_list":["post-17721","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teacher-digital-literacy","tag-mar23","tag-march23"],"jetpack_featured_media_url":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/digilearn\/uploads\/sites\/6913\/2023\/02\/22125246\/This-Is-Data-copy.001.jpeg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/posts\/17721","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/users\/58310"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/comments?post=17721"}],"version-history":[{"count":3,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/posts\/17721\/revisions"}],"predecessor-version":[{"id":17917,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/posts\/17721\/revisions\/17917"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/media\/17719"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/media?parent=17721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/categories?post=17721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/digilearn\/wp-json\/wp\/v2\/tags?post=17721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}