Thursday, 9 August 2007

Annual Leave Spreadsheet

This is something I did years ago and the other day someone asked if I still had a copy I could let them have.

I think it's fun sometimes to understand how something works (I draw the line at cars - I just drive them!) and therefore...

Click the images for a larger view.

This is the spreadsheet as seen for a single user. The blue squares representing a day's leave have a value of 1, but you could make the text colour the same as the background so all you see is a square. Equations in the columns to the right add up the number of coloured squares for the month and then deduct it from your allocation.

For a manager to keep track of a team's annual leave it's a case of adding more rows for each month (a different colour for each team member can be good) and ensuring the equations match the relevant line as leave is taken month by month.


B16: =B5
Then copy that down to B17:B25, B27:B36 etc. You will only have to enter staff names once now as it will automatically copy down from the first month into all other months.

AI5: =SUM(C5:AG5)
Then copy that down to AI6:AI14, AI16:AI25 etc. It adds all the taken leave for the row.

AJ5: =AK5+AL5-AI5
Then copy down to AJ6:AJ14 only. It adds the initial leave allocation (AK5) plus any leave brought forward from the previous year (AL5) and then takes off any leave taken during the current month (AI5)

AJ16: =AJ5-AI16
Then copy down to AJ17:AJ25, AJ27:AJ36 etc. It ensures that each month's remaining leave is based on the remaining allocation from the end of the preceding month.

Using the Spreadsheet

That's it! Fairly simple. Note that the coloured square in C1 has a value of 1 and the coloured and patterned square in C2 has a value of 0.5 to enable half day leave to be calculated.

When you add leave for anyone, copy and paste from either C1 or C2, rather than change the colour of cells to match - as that would not give them a value to be included in the calculations.

The coloured boxes for Sick Leave and Allowed Leave of Absence do not have a value as they would not be counted against annual leave allocations.

Every year you have to create a new blank and move the weekends (grey boxes) to match the dates of the new year.

Have a go!

Please note that as I am now retired this spreadsheet is no longer available as an attachment or emailed copy.

Thursday, 2 August 2007

JISC Inquiry into Learner Experiences

JISC have announced a Committee of Inquiry into the changing experiences and expectations of learners coming up to the age where they may enter Higher Education.

Young people's perceptions and expectectations of what HE might be like can sometimes be at odds with what they experience once they walk through the door.

Today's 17-year-olds have never known a world without the Internet. They were born in 1990, so their perception even of the Millenium is "something that happened when I was a kid"... "Star Wars" means Ewan McGregor, not Alec Guinness; for many of them TV will have always meant dozens of channels, vinyl records are antiques, even CDs are in danger of becoming quaint. They may have never had to take a film in to be processed.

Their experience of Information Technology, encompasses a far wider remit than just computers. Digital TV, digital cameras, mobile phones that take photographs, video, record audio and playback music in high quality. Internet use that includes new Social Software like MySpace and Facebook allowing groups of friends to share ideas and create networks globally, other web 2.0 sites such as Flickr and YouTube where photographs and videos can be stored, shared and accessed, blogging sites that allow anyone to be an author, a diarist, a philsopher, a critic.

The natural tendency is for youngsters to use these sites for friendship and other informal uses. It is important to understand the uses made of them in the more formal settings of schools and sixth forms.

The potential is huge for craft workers, or tradesmen such as carpenters to use a blog and perhaps Flickr to showcase work, to hold references from satisfied customers.

Do youngsters recognise this type of use for social software sites? Do schools make use of such technological advances? Is the demand for use so strong that the networks and connection capacity of schools and colleges become swamped and unable to cope with demand? Do institutions see only the negative aspects to such sites and ban their use?

Do youngsters see access to IT as a right? Will they want to bring and use their own laptops on the university network, disdaining the institution's own computers? Will they want to store their work and have it assessed on the university Virtual Learning Environment, or on an Internet-based wiki? Where will they want to store things like e-Portfolios, so that they can access them during work interviews from employers' premises and showcase both university achievements and other non-university achievements?

The Committee of Inquiry will be asking these and many more questions I am sure. They are currently seeking members from the Education Sector and Employers. The JISC announcement, by Dr Malcolm Read, JISC's Executive Secretary, is given below.
JISC will be running a Committee of Inquiry into the changing learner experience. The Inquiry is to address the implications for Higher Education Institutions of the experience and expectations of learners approaching full-time higher education both in the light of their increasing use of Web 2.0 technologies and other factors affecting the student experience. The focus is to be on young learners since their experience and expectation is immediate and also indicative of that of future entry cohorts. The consequences for other learners who may not be as familiar with new technologies will also be considered. The Inquiry is to extend over a period of approximately 9 months from autumn 2007, and its findings are intended to inform senior management discussions at the strategic level will and provide advise to universities and colleges about how they might wish to respond to the issues raised.

The committee is likely to comprise a group of perhaps 12 members in order to accommodate a spread of perspectives - senior management in HEIs and FECs, institutional technical services staff, schools, student as well as the research community and employers. The Inquiry and its committee will be supported and facilitated by a small secretariat

The Inquiry and committee will be headed by a Chair. The Chair will need to be credible in context, effective in that capacity and, ideally, prepared to be involved in the work and process of the Inquiry. Rather than being, for instance, an e-learning expert the chair should ideally be interested in the widest possible issues relating to the student experience and able to direct the Inquiry on this basis

Suggestions of potential candidates for the role of Chair are invited, as are suggestions of possible members for the committee itself. Suggestions should be emailed to Robert Haymon-Collins, JISC Director of Communications and Marketing,, and copied to Emma Charlick, as soon as possible and in any case by 24 August 2007.