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!
Wednesday 26 March 2008
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
Subscribe to:
Posts (Atom)