{"id":504,"date":"2011-06-11T09:30:35","date_gmt":"2011-06-11T09:30:35","guid":{"rendered":"http:\/\/blogs.loucoll.ac.uk\/learningtechnology\/?p=504"},"modified":"2013-01-31T16:27:08","modified_gmt":"2013-01-31T16:27:08","slug":"spreadsheet-software","status":"publish","type":"post","link":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/2011\/06\/11\/spreadsheet-software\/","title":{"rendered":"Spreadsheet software"},"content":{"rendered":"<p><a href=\"http:\/\/blogs.loucoll.ac.uk\/learningtechnology\/files\/2011\/06\/Microsoft-Office-Excel-icon-StaffZone.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-723\" src=\"http:\/\/blogs.loucoll.ac.uk\/learningtechnology\/files\/2011\/06\/Microsoft-Office-Excel-icon-StaffZone-150x150.png\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/files\/2011\/06\/Microsoft-Office-Excel-icon-StaffZone-150x150.png 150w, https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/files\/2011\/06\/Microsoft-Office-Excel-icon-StaffZone.png 256w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>Spreadsheet software is an\u00a0application\u00a0where data is arranged within a table structure on separate sheets where the parts of the table interlink with other parts.\u00a0 This enables the management of data, through the\u00a0implementation of formulas, formatting and the creation of figures.\u00a0\u00a0<a href=\"http:\/\/office.microsoft.com\/en-us\/excel\/\">Microsoft excel\u00a0<\/a>is the most commonly known spreadsoft package, however Google now offers\u00a0<a href=\"http:\/\/www.google.com\/google-d-s\/spreadsheets\/\">spreadsheet<\/a>\u00a0functionality as part of the Google Docs suite.<\/p>\n<p>The table below shows some potential uses of this technology in both Further Education (FE) and Higher Education (HE). \u00a0Below this are videos which demonstrate how this technology could be used in teaching and learning.<\/p>\n<table class=\"lsistable\" border=\"1\">\n<tbody>\n<tr>\n<th>Uses in FE<\/th>\n<th>Uses in HE<\/th>\n<\/tr>\n<tr>\n<td>To create drag and drop activities<\/td>\n<td>To perform basic data analysis (mean, standard deviation)<\/td>\n<\/tr>\n<tr>\n<td>To create matching activities<\/td>\n<td>To assess the distribution of a set of data<\/td>\n<\/tr>\n<tr>\n<td>To review\/recap learning<\/td>\n<td>To determine the difference between data sets (t-tests and ANOVA)<\/td>\n<\/tr>\n<tr>\n<td>For formative assessment<\/td>\n<td>To determine the association between data sets (Pearson\u2019s correlation)<\/td>\n<\/tr>\n<tr>\n<td>To produce tables and charts\/figures<\/td>\n<td>To produce tables and charts\/figures<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Spreadsheet software is an\u00a0application\u00a0where data is arranged within a table structure on separate sheets where the parts of the table interlink with other parts.\u00a0 This enables the management of data, through the\u00a0implementation of formulas, formatting and the creation of figures.\u00a0\u00a0Microsoft excel\u00a0is the most commonly known spreadsoft package, however Google now &hellip;<\/p>\n","protected":false},"author":51,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[39,34,37],"class_list":["post-504","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-excel","tag-formative-assessment","tag-google"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/posts\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/users\/51"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/comments?post=504"}],"version-history":[{"count":25,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/posts\/504\/revisions"}],"predecessor-version":[{"id":970,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/posts\/504\/revisions\/970"}],"wp:attachment":[{"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/media?parent=504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/categories?post=504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.loucoll.ac.uk\/learningtechnology\/wp-json\/wp\/v2\/tags?post=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}