To download or view Admin Services and ITFM Theory notes
Click Here
Friday 6 June 2008
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!
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:
DATABASE
Queries
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.
SPREADSHEET
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!
WORD REPORT
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
Concentrate on:
DATABASE
Queries
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.
SPREADSHEET
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!
WORD REPORT
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.
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
ITFM SAQs
Download, print off and answer these short answer questions for Higher Admin ITFM Theory Nab:
ITFM Theory Nab SAQs
ITFM Theory Nab SAQs
Thursday 24 January 2008
H Admin ICT Workbooks
If you wish to practice your skills at home, you can download the booklets from here:
Calculations in Queries
Calculations in Reports
IF Statements
Complex Formulae in Excel
Advanced Word Booklet
Filtering in Excel
Create Charts in Queries
Using Comments in Excel
Calculations in Queries
Calculations in Reports
IF Statements
Complex Formulae in Excel
Advanced Word Booklet
Filtering in Excel
Create Charts in Queries
Using Comments in Excel
Subscribe to:
Posts (Atom)