{"id":5900,"date":"2019-02-12T12:13:07","date_gmt":"2019-02-12T12:13:07","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/fa\/ICTFalkirkPrimaries\/?p=5900"},"modified":"2026-01-16T12:05:11","modified_gmt":"2026-01-16T12:05:11","slug":"excel","status":"publish","type":"post","link":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/2019\/02\/12\/excel\/","title":{"rendered":"Excel Online"},"content":{"rendered":"<section id=\"builder-section-text_1016\" class=\"builder-section-first builder-section builder-section-text builder-section-last builder-text-columns-1\" style=\"background-size: cover; background-repeat: no-repeat;background-position: center center;\">\n<div class=\"builder-section-content\">\n<div class=\"builder-text-row\">\n<div class=\"builder-text-column builder-text-column-1\" id=\"builder-section-text_1016-column-1\">\n<div class=\"builder-text-content\">\n<p data-path-to-node=\"4\">Microsoft Excel Online is more than just numbers, it is a powerful tool for data handling, visualisation, and problem-solving.<\/p>\n<h2 style=\"text-align: center;\" data-path-to-node=\"5\"><b data-path-to-node=\"5\" data-index-in-node=\"0\">\ud83d\udd0d What does it do?<\/b><\/h2>\n<p data-path-to-node=\"5\">Microsoft Excel is a spreadsheet application. While often seen as a tool for accountants, in the classroom it is a powerful canvas for organising information, performing calculations, and turning raw data into visual charts and graphs. As part of <b data-path-to-node=\"5\" data-index-in-node=\"285\">Glow<\/b>, it is available online, allowing pupils to collaborate on the same spreadsheet in real-time.<\/p>\n<h2 style=\"text-align: center;\" data-path-to-node=\"6\"><b data-path-to-node=\"6\" data-index-in-node=\"0\">\ud83c\udf93 Why is it useful?<\/b><\/h2>\n<ul data-path-to-node=\"7\">\n<li>\n<p data-path-to-node=\"7,0,0\"><b data-path-to-node=\"7,0,0\" data-index-in-node=\"0\">Visualising Data:<\/b> Instantly turn a table of survey results (like traffic surveys or favorite foods) into colorful bar charts or pie graphs to help pupils spot trends.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"7,1,0\"><b data-path-to-node=\"7,1,0\" data-index-in-node=\"0\">Real-Time Collaboration:<\/b> Multiple pupils can enter data into a single shared spreadsheet simultaneously &#8211; perfect for whole-class experiments.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"7,2,0\"><b data-path-to-node=\"7,2,0\" data-index-in-node=\"0\">Maths in Action:<\/b> It brings numeracy to life by using formulas to solve real-world problems, from managing a budget to tracking fitness results in PE.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"7,3,0\"><b data-path-to-node=\"7,3,0\" data-index-in-node=\"0\">Anywhere Access:<\/b> Works on iPads, PCs, and through any web browser via Glow, so learning can continue at home.<\/p>\n<\/li>\n<\/ul>\n<h2 data-path-to-node=\"8\">\u00a0<\/h2>\n<h2 style=\"text-align: center;\" data-path-to-node=\"8\"><b data-path-to-node=\"8\" data-index-in-node=\"0\">\u2699\ufe0f How does it work?<\/b><\/h2>\n<ol start=\"1\" data-path-to-node=\"9\">\n<li>\n<p data-path-to-node=\"9,0,0\"><b data-path-to-node=\"9,0,0\" data-index-in-node=\"0\">Log In:<\/b> Access Excel via the <b data-path-to-node=\"9,0,0\" data-index-in-node=\"29\">OneDrive<\/b> or <b data-path-to-node=\"9,0,0\" data-index-in-node=\"41\">Teams<\/b> tile on your Glow Launchpad.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"9,1,0\"><b data-path-to-node=\"9,1,0\" data-index-in-node=\"0\">Create a Table:<\/b> Enter your labels in the top row and your data in the cells below.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"9,2,0\"><b data-path-to-node=\"9,2,0\" data-index-in-node=\"0\">Insert Chart:<\/b> Highlight your data, go to the <b data-path-to-node=\"9,2,0\" data-index-in-node=\"45\">Insert<\/b> tab, and choose a chart type (e.g., Column or Pie).<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"9,3,0\"><b data-path-to-node=\"9,3,0\" data-index-in-node=\"0\">Collaborate:<\/b> Use the <b data-path-to-node=\"9,3,0\" data-index-in-node=\"21\">Share<\/b> button (top right) to invite others to edit the document with you.<\/p>\n<\/li>\n<\/ol>\n<p>Check out this handy Sway with detailed instructions on how to set up and use an Excel document online:<\/p>\n<p><div class=\"ttfmake-embed-wrapper aligncenter\" style=\"max-width: 960px;\"><iframe loading=\"lazy\" frameborder=\"0\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" width=\"960\" height=\"631\" src=\"https:\/\/sway.office.com\/s\/EBK7EW13DfPJl5to\/embed\" allowfullscreen webkitallowfullscreen mozallowfullscreen msallowfullscreen ><\/iframe><\/div>\n<\/p>\n<h3 data-path-to-node=\"11\">\u00a0<\/h3>\n<h2 style=\"text-align: center;\" data-path-to-node=\"11\"><b data-path-to-node=\"11\" data-index-in-node=\"0\">\ud83d\ude80 Beyond the Basics<\/b><\/h2>\n<ul data-path-to-node=\"12\">\n<li>\n<p data-path-to-node=\"12,0,0\"><b data-path-to-node=\"12,0,0\" data-index-in-node=\"0\">Automatic Graphs:<\/b> After a class survey, have pupils use Excel to generate different types of graphs to see which one displays their data most clearly.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"12,1,0\"><b data-path-to-node=\"12,1,0\" data-index-in-node=\"0\">Data Types:<\/b> Type a list of countries or cities, then use the <b data-path-to-node=\"12,1,0\" data-index-in-node=\"77\">&#8220;Geography&#8221; Data Type<\/b> (under the Data tab) to automatically pull in facts like population, area, and capital cities.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"12,2,0\"><b data-path-to-node=\"12,2,0\" data-index-in-node=\"0\">Fitness Tracking:<\/b> Record heart rates before and after exercise directly into a spreadsheet and use the <b data-path-to-node=\"12,2,0\" data-index-in-node=\"117\">&#8220;AutoSum&#8221;<\/b> or <b data-path-to-node=\"12,2,0\" data-index-in-node=\"130\">&#8220;Average&#8221;<\/b> formulas to analyse the class results instantly.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"12,3,0\"><b data-path-to-node=\"12,3,0\" data-index-in-node=\"0\">Budgeting:<\/b> Give pupils a &#8220;Virtual Budget&#8221; for a class trip. They can use Excel to track costs and see how changing one item (like the bus price) affects their total spend.<\/p>\n<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<hr class=\"ttfmake-hr\" style=\"border-style: dotted; border-top-width: 2px;\" \/>\n<h2 style=\"text-align: center;\"><span class=\"math-inline\" data-math=\"\ud83d\udd17\" data-index-in-node=\"33\"><span class=\"katex\"><span class=\"katex-html\" aria-hidden=\"true\"><span class=\"base\"><span class=\"mord\">\ud83d\udd17 Teacher <\/span><\/span><\/span><\/span><\/span>Quick Links<\/h2>\n<p style=\"text-align: center;\"><a href=\"https:\/\/support.microsoft.com\/en-gb\/excel\">Microsoft Excel support webpage\u00a0<\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/basic-tasks-in-excel-dc775dd1-fa52-430f-9c3c-d998d1735fca\">Microsoft Basic Tasks in Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"builder-text-row\">\n<div class=\"builder-text-column builder-text-column-2\" id=\"builder-section-text_1016-column-1\">\n<div class=\"builder-text-content\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div class=\"builder-text-row\">\n<div class=\"builder-text-column builder-text-column-3\" id=\"builder-section-text_1016-column-1\">\n<div class=\"builder-text-content\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel Online is more than just numbers, it is a powerful tool for data handling, visualisation, and problem-solving. \ud83d\udd0d What does it do? Microsoft Excel is a spreadsheet application. While often seen as a tool for accountants, in the classroom it is a powerful canvas for organising information, performing calculations, and turning raw data &hellip;<\/p>\n","protected":false},"author":8391,"featured_media":10638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[621],"tags":[361],"class_list":["post-5900","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tool","tag-microsoft"],"jetpack_featured_media_url":"https:\/\/blogs.glowscotland.org.uk\/fa\/public\/digilearnfalk\/uploads\/sites\/3070\/2019\/02\/15174319\/81.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/posts\/5900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/users\/8391"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/comments?post=5900"}],"version-history":[{"count":10,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/posts\/5900\/revisions"}],"predecessor-version":[{"id":10652,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/posts\/5900\/revisions\/10652"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/media\/10638"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/media?parent=5900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/categories?post=5900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/fa\/digilearnfalk\/wp-json\/wp\/v2\/tags?post=5900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}