{"id":2902,"date":"2015-05-31T22:35:02","date_gmt":"2015-05-31T21:35:02","guid":{"rendered":"https:\/\/mathedup.co.uk\/?p=2902"},"modified":"2015-08-27T13:27:31","modified_gmt":"2015-08-27T12:27:31","slug":"excel-geeking","status":"publish","type":"post","link":"https:\/\/www.mathedup.co.uk\/excel-geeking\/","title":{"rendered":"Excel geeking"},"content":{"rendered":"

I was having a conversation with an NQT the other day about the importance of being around people you can bounce ideas off. My point being that unless you have people around you to force you out of your comfort zone, it is very easy to stagnate as a (maths) teacher. Often, just one teacher to bounce ideas off is enough to provoke thought and inspire creativity. The conversation took me back to my early days as a maths teacher when a colleague and I would stop behind after school and ‘geek out’ on creating interactive teaching resources using Excel. I had already, just a few days earlier, used a percentage spider<\/a> classroom resource which I had put together in 2005 (still going strong and a lovely resource). I was able to show my class\u00a0the date I made the resource in the Excel properties menu.. They were kinda impressed (in a very\u00a0unimpressed looking way).<\/p>\n

\"maxresdefault\"<\/a><\/p>\n

Anyway, for those of you who don’t use Excel as a learning tool much, it really does have limitless capabilities. Years ago, I was\u00a0asked in an interview: “If you could choose just one piece of software to use in the classroom, what would it be?”. \u00a0My answer then was “Excel” and I reckon it would still be that answer today.<\/p>\n

Before I go on, I just thought I would mention that I don’t claim to be an expert. Far from it. There are some really impressive packages out there that use Excel in very clever ways such as eStarters by Trinity Maths<\/a>\u00a0or, for those of you in the game long enough to remember, Virtual Textbook<\/a> (seems to have been discontinued). The point of this post is to highlight how flexible Excel can be and give a few ideas\u00a0on how to use in the classroom.<\/p>\n

So, here is a quick list of the types of activities I have created or used\u00a0with Excel over the years. Some of them just use clever formulae, while others involve a bit of macro programming.<\/p>\n

Self marking worksheets<\/h2>\n

For use in IT rooms or as a homework task, Excel allows you to very easily create self marking worksheets. This is made even easier using a combination of conditional formatting and hidden answer sheets. I will write a guide on this if there is interest, otherwise see these examples<\/a>:<\/p>\n

This slideshow requires JavaScript.<\/p>

<\/div>\n

Random question generator<\/h2>\n

Sometimes you just want to create lots of practice questions. Excel has you covered on this front and it is fairly easy to create different levels of challenge. Essentially, you are just using the random number generator in a clever way. Below is a times tables grid<\/a> I created as a regular starter activity back in the day. Lots of examples of these out there and it is worth checking out Maths to Infinity<\/a> by Kangaroo maths. It is easy enough to gamify these in order to add to engagement.<\/p>\n

\"2015-05-31_1853\"<\/a><\/p>\n

Developing a deeper understanding of algebra<\/h2>\n

Because of the nature of Excel using cells as variables,it is a really powerful way of developing an understanding of Algebra with your students. Being able to\u00a0explore relationships by varying starting conditions is really powerful. See this post<\/a> about a\u00a0year 10 lesson last year focusing on exploring formulae. Here\u00a0are some links<\/a> to different types of activities that focus on developing algebra skills<\/a>.<\/p>\n

This slideshow requires JavaScript.<\/p>

<\/div>\n

Presentation tool<\/h2>\n

This is perhaps my favourite use of Excel. I wrote a post a while back about using show me boards<\/a> with templates, so check this out if you want to know a little more about how I use these in the classroom.<\/p>\n

The fact that you can show\/hide cells in Excel by simply clicking on them opens up all sorts of opportunities to use in the classroom. The beauty of maths is that it is all about relationships and extending thinking can be as simple as\u00a0swapping around what you are trying to work out. For example, when working with circles, instead of starting with the radius and working out the area, you can start with the area and work out the radius. Further to this, you could start with the area and work out the circumference, or vice versa. By linking cells together in Excel\u00a0and using \u00a0show\/hide\u00a0buttons, you are able to\u00a0develop even the most mundane activities into\u00a0rich tasks that force students to think around ideas more deeply. This idea works with just about every area of maths as the gallery below highlights. Here are some examples<\/a> for you to take a look at. I should mention that\u00a0not all of these have been created by me and I don’t recall where some of them have come from.<\/p>\n

This slideshow requires JavaScript.<\/p>

<\/div>\n

If you, like me, enjoy using and learning Excel, can I suggest that you take a look at The Excel Addict<\/a>\u00a0which is a treasure trove of tips, tricks, shortcuts and techniques. Definitely worth subscribing to their weekly newsletter.<\/p>\n

How do you use Excel? Are there any other types of activities I have missed?\u00a0If you have any comments, thoughts or ideas, please share below.\u00a0Also, if you haven’t done so already, make sure you subscribe below.<\/p>\n

[mc4wp_form]<\/p>\n

Edit: All of the\u00a0Virtual Textbook<\/a> resources have now been made freely available. They can be found by following this link<\/a>. I huge thank you to Michael Bawtree who has obviously put in a lot of blood, sweat and tears into this amazing selection of\u00a0resources.<\/p>\n

photo credit: Craig Chew-Moulding<\/a>\u00a0via\u00a0flickr<\/a>\u00a0cc<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I was having a conversation with an NQT the other day about the importance of being around people you can bounce ideas off. My point being that unless you have people around you to force you out of your comfort zone, it is very easy to stagnate as a (maths) teacher. Often, just one teacher […]<\/p>\n","protected":false},"author":1,"featured_media":2962,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[15],"tags":[],"jetpack_publicize_connections":[],"yoast_head":"\nExcel geeking - MathedUp!<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mathedup.co.uk\/excel-geeking\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel geeking - MathedUp!\" \/>\n<meta property=\"og:description\" content=\"I was having a conversation with an NQT the other day about the importance of being around people you can bounce ideas off. My point being that unless you have people around you to force you out of your comfort zone, it is very easy to stagnate as a (maths) teacher. Often, just one teacher […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mathedup.co.uk\/excel-geeking\/\" \/>\n<meta property=\"og:site_name\" content=\"MathedUp!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Mathedup?fref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-31T21:35:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-27T12:27:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mathedup.co.uk\/wp-content\/uploads\/2015\/05\/8399214678_0711089ac6_k.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"1536\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"MathedUp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@TwoBridgesSch\" \/>\n<meta name=\"twitter:site\" content=\"@TwoBridgesSch\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"MathedUp\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mathedup.co.uk\/excel-geeking\/\",\"url\":\"https:\/\/www.mathedup.co.uk\/excel-geeking\/\",\"name\":\"Excel geeking - MathedUp!\",\"isPartOf\":{\"@id\":\"https:\/\/www.mathedup.co.uk\/#website\"},\"datePublished\":\"2015-05-31T21:35:02+00:00\",\"dateModified\":\"2015-08-27T12:27:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/9de9436ab9e6c3e2e23090c2ba83f12d\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.mathedup.co.uk\/excel-geeking\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mathedup.co.uk\/excel-geeking\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mathedup.co.uk\/excel-geeking\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mathedup.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel geeking\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mathedup.co.uk\/#website\",\"url\":\"https:\/\/www.mathedup.co.uk\/\",\"name\":\"MathedUp!\",\"description\":\"FOR YOUR MATHS TEACHING AND LEARNING NEEDS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mathedup.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/9de9436ab9e6c3e2e23090c2ba83f12d\",\"name\":\"MathedUp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/df4dee448a6f45dc0ef58807d1b403f3?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/df4dee448a6f45dc0ef58807d1b403f3?s=96&d=wavatar&r=g\",\"caption\":\"MathedUp\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel geeking - MathedUp!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mathedup.co.uk\/excel-geeking\/","og_locale":"en_US","og_type":"article","og_title":"Excel geeking - MathedUp!","og_description":"I was having a conversation with an NQT the other day about the importance of being around people you can bounce ideas off. My point being that unless you have people around you to force you out of your comfort zone, it is very easy to stagnate as a (maths) teacher. Often, just one teacher […]","og_url":"https:\/\/www.mathedup.co.uk\/excel-geeking\/","og_site_name":"MathedUp!","article_publisher":"https:\/\/www.facebook.com\/Mathedup?fref=ts","article_published_time":"2015-05-31T21:35:02+00:00","article_modified_time":"2015-08-27T12:27:31+00:00","og_image":[{"width":2048,"height":1536,"url":"https:\/\/www.mathedup.co.uk\/wp-content\/uploads\/2015\/05\/8399214678_0711089ac6_k.jpg","type":"image\/jpeg"}],"author":"MathedUp","twitter_card":"summary_large_image","twitter_creator":"@TwoBridgesSch","twitter_site":"@TwoBridgesSch","twitter_misc":{"Written by":"MathedUp","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mathedup.co.uk\/excel-geeking\/","url":"https:\/\/www.mathedup.co.uk\/excel-geeking\/","name":"Excel geeking - MathedUp!","isPartOf":{"@id":"https:\/\/www.mathedup.co.uk\/#website"},"datePublished":"2015-05-31T21:35:02+00:00","dateModified":"2015-08-27T12:27:31+00:00","author":{"@id":"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/9de9436ab9e6c3e2e23090c2ba83f12d"},"breadcrumb":{"@id":"https:\/\/www.mathedup.co.uk\/excel-geeking\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mathedup.co.uk\/excel-geeking\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mathedup.co.uk\/excel-geeking\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mathedup.co.uk\/"},{"@type":"ListItem","position":2,"name":"Excel geeking"}]},{"@type":"WebSite","@id":"https:\/\/www.mathedup.co.uk\/#website","url":"https:\/\/www.mathedup.co.uk\/","name":"MathedUp!","description":"FOR YOUR MATHS TEACHING AND LEARNING NEEDS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mathedup.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/9de9436ab9e6c3e2e23090c2ba83f12d","name":"MathedUp","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mathedup.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/df4dee448a6f45dc0ef58807d1b403f3?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/df4dee448a6f45dc0ef58807d1b403f3?s=96&d=wavatar&r=g","caption":"MathedUp"}}]}},"jetpack_featured_media_url":"https:\/\/www.mathedup.co.uk\/wp-content\/uploads\/2015\/05\/8399214678_0711089ac6_k.jpg","jetpack_shortlink":"https:\/\/wp.me\/p3r3Ao-KO","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/posts\/2902"}],"collection":[{"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/comments?post=2902"}],"version-history":[{"count":10,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/posts\/2902\/revisions"}],"predecessor-version":[{"id":3629,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/posts\/2902\/revisions\/3629"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/media\/2962"}],"wp:attachment":[{"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/media?parent=2902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/categories?post=2902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mathedup.co.uk\/wp-json\/wp\/v2\/tags?post=2902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}