Posts Tagged ‘ukedchat’
Inbox Zero achieved – a splendiferous day
Today I achieved a personal goal for 2013 – the mythical Inbox Zero.
I’ve always had a staff email account, but only recently has it become almost unbearable to look at. ...
Automating “Best Fit” of sub levels with Excel
Download the BestFit Excel Workbook
As part of our new ARR policy in school, we have been asked to record sub-levels against each pupil, so that we can track internal progress ...
Which day of the week? Excel WEEKDAY() function
It doesn’t happen very often in teaching that we need to know the specific DAY of a week – after all we’re timetabled to be in one place or another, ...
Splendiferous Excel – Quick and dirty averages
Working on some figures in school yesterday I was asked what the mean of a set of numbers was. Instinctively I highlighted the numbers and pronounced the mean being “125.4″ (or ...
What if teaching was like Halo?
This year Santa brought number 1 son a shiny XBOX-360 and the latest games (Hal0-4 and Fifa13). As a 40 something gamer myself, who cut his teeth on Elite and ...
Data Dashboard – a new markbook
Download the Excel spreadsheet here >>>Student Dashboard <<<
I treated myself to some “light” reading over the Christmas break. Dashboards and Reports and The Effective Visual Communication of Data have both contributed to this post ...
Student dashboards – array formula in Excel
For the coming year I am determined to update the whole school use of Excel as a data recording / analysis / presentation tool. For sure, most of us can ...
Making a mobile web site – setting data free
As a teacher I’ve been fascinated with the world of mobile apps and web sites since the first days of the AppStore. The idea that a (humble) teacher could take ...
Random “text” from list in Excel
I was asked today how to use Excel to produce a random sentence from a list of options stored as a list. An interesting question as people are familiar with the RAND() ...
Santa Graphs – seasonal pseudo context
That time of year again and I just can’t watch Elf – no really I can’t.
So I created this bit of pseudo context.
Santa is charting the growth g in numbers ...
Comedy is ruining the economy – Good data gone bad
Comedy films are killing the economy. You heard it first here at www.glengilchrist.co.uk. Remember that come the revolution.
Joking aside, the Internet Movie Data based (IMDB) is a wonderful ...
Automatically save file versions in Excel
As I start to think about timetables and 2013-2014, one thing I must sort out - saving previous versions of my Excel files.
You know the score; you spend all day ...
The educational technology “F-word”
Catching up on my reading I came across a talk from Michael Trucano at World Bank via Educa-Berlin), who talks passionately about the pitfalls of implementing a technology roll out in schools.
In ...
Web 2.0 Site I wish I’d written ;-(
When I set my son up with a web site (Earn your pocket money), the intention was that:
He’d be interested with all things web – (HTML, WordPress, blogging, etc) – ...
Excel sparklines to plot student data
I was looking for a way to compare the trends in test scores for a group of learners. I thought it would be nice to plot the scores for each ...
User defined functions in Excel – percent to levels anyone?
Excel has 300+ defined functions. Things like:
SUM
AVERAGE
COUNTIF
VLOOKUP
And I am sure that you’ve used some of the basic ones when analysing data for exams meetings. But sometimes Excel just does not do ...
Using Excel to automate timetables – array formula
It’s getting to that time of year again – not the Ho, Ho, Ho time, more the Arrrgh, Arrrgh, Arrrgh time. Schools are gearing up to think about next years ...
Scientific ilLiteracy
Having been off school for the past week I’ve engaged in a fair amount of navel gazing and ponderings of all things related to my role as an educator.
Plus, I’ve been reading ...
Excel Graph Paper Maker v1.2
Funny how things can become an obsession. Having been off for a few days with (what looks like) shingles on my face / eyes, I was looking for something to ...
Excel graph paper – version 1.1
I hadn’t intended to create a new version so soon, but the feedback from the first release caused some bug fixes, a tidy of the macro code and the inclusion ...
