Posts Tagged ‘ukedchat’
Using Google Url Shrinker inside Excel
The project I’m currently working on requires me to collate web links into a regular Tweet. All good – use of Excel to collate the list and liberal CONCATENATES() soon ...
Consuming XML with Excel 2013 Webservices
Big data is the darling of newspapers at present – you know, everything we do is logged and if we could just, in some way makes sense of it all, ...
Using Excel 2013 Webservice to get Latitude and Longitude for a PostCode
My previous post on getting the distance between postcodes with Google Maps API and Excel, got me thinking about mapping and Excel – one thing led to another and I ...
Distance between postcodes (Using Excel and Google Maps API)
I’m lucky enough to be on a sabbatical from being STL Science. As a result I need to claim travelling expenses – no biggie and the electronic system that the Welsh ...
Non “recalculating” random numbers in Excel
I’ve blogged before about using Excel to create data for learners to analyse (specifically in BTEC Science) . To create a different set of data for each learner we use ...
Personalised “flipped” revision
I’m fortunate enough to tutor a few learners in GCSE Science - fortunate as it allows me to spend more than 2 or 3 minutes actually diagnosing learning “blocks” and it gives me the ...
Using Webservice to pull data straight from the web into Excel
When I were a lad….. we used to live in a Welsh village by the name of Raglan. My father used to insist that Raglan had the most expensive petrol ...
The startling link between FSM and Average Points Score (KS4)
I’m a data nut – I love numbers and visualising the relationship between often seemingly disparate sets of measurements. When the Welsh Government published MyLocalSchool the intention was for interested ...
Change cell values by clicking (in the cell)
If you run BTEC courses you will know that it can be death by marksheet – tracking 150+ learners over 6 modules and 20+ assignments takes the organisation skills of ...
Use Excel to speak the contents of a cell
You know the oft repeated phrase “90% of Excel users only use 10% of the functionality” (or numbers to that effect). Well I came across a feature today that I ...
Rounding time to the nearest 15 minutes
I was asked the other day to write an Excel sheet to record visitors to a local Primary school. Specifically they wanted to monitor the most popular time for visitors to ...
Averaging the top 5 scores from a list
Download finding the average of the top 5 scores worksheet
I seen splendiferous Excel come up with time saving formula before, but the other day I was faced with selecting the highest 5 ...
Keyword Bingo with Excel
I’m not one for Bingo in general, but the other day I needed to create a unique list of numbers from a larger set of numbers – and this made ...
Using SUMPRODUCT to count test scores BETWEEN 2 values
I’ve found myself recently having to count test score for learners – things like “How many students scored between 50% and 90%” - not overly complex, but when the numbers ...
Finding the largest difference between 2 columns
If you have a set of data and you want to indicate what has changed the most between columns, you need to calculate the difference, take the absolute value (neither positive ...
Does TV make you stupid?
As with other posts on this subject, the data is real but my conclusions are tongue in cheek
Over the past 3 years I’ve had the privilege to teach a number of ...
Using live web data in Excel 2013 with Webservice
A splendiferous new function of Excel 2013 is the function Webservice, which returns data from a web “service”. What does that mean?
It means that you can pull into Excel data ...
Science sentence starter spinner made in Excel
Download Sentence Starter Worksheet (macro enabled)
Having used my random name generator in class for a while now (shown here) I re purposed it to display a random sentence starter to be used ...
Automatically shade alternate rows in a spreadsheet
Download alternate row shading worksheet
We all know that adding alternative rows of shading on a spreadsheet aids readability - indeed in a table of results it can help considerably with drift when ...
Using Datedif() to calculate age
Download Date difference Workbook
I don’t know why, but my data maths sucks – there I’ve said it. But fortunately in splendiferous Excel world there is a function that allows us to calculate ...
