Welcome to the Higher Administration blog of Mr McGowan.

It is the intention of this blog to be an additional and flexible resource allowing pupils to have more say in how, what and when they learn.

Higher Admin is challenging. But by using technology we can make it more accessible.

Do you wish a practice Nab for ITFM Outcome 3?

Friday, 6 June 2008

Higher Admin Core Notes

To download or view Admin Services and ITFM Theory notes

Click Here

Wednesday, 26 March 2008

Higher Admin Bible New Edition

I know this may not help some of you who will be leaving, but then help me to help others.

What do you want me to put into the second edition of our bible for H Admin?

I think I should put in COUNTOF (Database Query)
Totalling in a query

COUNTIF for spreadsheets (I can't recall if I have already done that?)

So again, rack your brains as I think that booklet has been an invaluable resource. Don't go thanking me all at once....

Anyway let me know!

Second Prelim

Okay so for the Second Prelim you know the types of questions you may be asked.

Concentrate on:


Labels (I hope you are all seeing the pattern like the past papers!)
A Query based report

BTW remember the use of the wildcard *.

The wildcard is used to search for things beginning and ending with letters.

eg Like "*m" turns up everything with m at the end. Like "m*" turns up everything with m at the start.

Normally you will also be asked to do some aggregate function in a query. This is normally a COUNTOF function.


The usual again. You have to do calculations and totalling. You probably will be asked to do some sort. You will also be required to do a VLOOKUP or an HLOOKUP. We've done this tons of times, so I am really expectant here!

Remember the printing options (ie Row/Column Headings, Formulae or Values view, and with or without Gridlines).

You may also have to create an IF STATEMENT. Remember if you can't do it don't waste time on it. There are enough marks to get you a pass and indeed an A or B.

There will also be a chart involved. If stuck for sorting, then sort the table/spreadsheet BEFORE doing the chart!


This will contain the usual also. Comments, footnotes etc. Inserting in previous queries, charts etc.

Just try and not loose silly marks. Have all the page numbering correct, the format correct and pay attention to portrait or landscape for printing.

Good luck

Friday, 29 February 2008

Additional Prelim

The next Prelim is provisionally booked for Thursday 27th March 2008 at 9.15am in room 316.

Tuesday, 26 February 2008

ITFM Nab News

The date for the final Nab, Outcome 3, has to be brought forward!

We will now conduct the Nab on Thursday the 13th March.

All resits will be resat on Thursday the 20th of March.

These new dates were decided at a Faculty Meeting. I am sorry about the late notice, but if we conduct a Practice Nab this week in class, that will be good practice and focus us all on the nab.

Tuesday, 19 February 2008


Download, print off and answer these short answer questions for Higher Admin ITFM Theory Nab:

ITFM Theory Nab SAQs