Spreadsheets

You have now finished spreadsheets.

Here is a wee summary as to what you should now be able to do:

Nested IF Statements

3D Formulae

Pivot Tables

Sub-Totalling

Lookups

Comments

Conditional Formatting

Complex Formulae

Let me know if anything is worrying you from the list – and keep practising at home, using the downloadable files!

Electronic Files

So, I’ve not updated this blog for a while – tut, tut, I hear you cry! Anyway, to make up for it, I’ve now posted a zip file with all electronic files for the whole course. This means that you can collect booklets from the filing cabinet to practice all spreadsheet, wordprocessing and database tasks to your heart’s content. All files for exams are there also, so feel free to do other work at home – perhaps by redoing any exams we’ve already done in class. There are also practice exams – called Versions 1-10. These are “old style” exams but will still give you some work doing IT. Click on the link above and download the file to your home desktop computers. All the files are there – enjoy!!

Holiday Homework!

You’ve now got all your Past Papers for Section 1 – the written paper. The homework for the holiday period – due on Monday 10th January is as follows:

2009 Paper – Section 1 – all questions. There is a Customer Services question but you have the notes and can use the Powerpoint to help you.

also

Section 2 – Question 4

Good luck.

Oh, and Happy Christmas! 😆

Interview Techniques – The Apprentice

Well, did you watch it? I hope so, because it dealt with a lot of areas regarding what should be included in an ideal interview. It opened up lots of issues regarding the Interview. What it highlighted to me included the following:

  • do not be flippant or attempt humour on a CV or application form (Jamie’s attempts at being funny about himself)
  • do not behave in a personal manner with an Interviewer (Stuart’s “hello, Margaret!”)
  • do your research of the company before attending an interview – they will do their homework on you! (Joanna not knowing about Lord Sugar’s companies)
  • be honest in any document you prepare and remember that Interviewers will pick up on anything listed there (Stuart’s Telecom licensing details)
  • be careful of what you say in an interview – your words may well come back and haunt you (Stuart’s big fish in a small pond) or (Chris having so many previous starts in life)
  • try to come over in a personable manner (Chris sounding monotonous in an interview)

Based on the programme, who do you think is the ideal candidate?

Starter Question – Wednesday 15th December

The solution to this week’s Starter Question is given below. Please remember that you really need to build up a Discussion-based answer. Read the actual notes issued for markers for this question.

If no attempt at discussion then only 50% of the marks available. If no discussion please

indicate with “NO D”. Must hit each of the 4 areas to gain the first 4 marks – 2 additional

points from any area to gain final 2 marks.

Internal

  • It gives employees within the company a chance to develop their career.
  • Shorter induction period needed as the employee is likely to be familiar with the company
  • Employers will know more about internal candidates’ abilities – this should reduce the risk of employing the “wrong” person.
  • May be quicker and less expensive than recruiting from outside the business.
  • With internal recruitment another vacancy will be created.
  • Smaller pool of applicants.

External

  • Introduces new or fresh ideas/skills. Could produce a bigger pool of applicants.
  • Candidates might be of better quality.
  • Candidates less well known and therefore more risk in employing the wrong person.
  • Could demotivate existing employees.
  • Expensive
  • Time consuming …

Notes:

  • Accept views of organisation and employees
  • Be aware of awarding an extra mark for simply stating the opposite/flip side of an answer.
  • Second mark can be awarded if there is development.
  • Do not award marks for outsourcing recruitment.
  • Accept 2 separate paragraphs on internal and external as an example of discussion

Admin Services 3 – Homework Sheet 1

This week’s homework was rather well done. However, here are a few pointers for you all:

The recruitment process takes in:

  • identifying that the job exists
  • creating a job description and person specification
  • then advertising the job

Comparing internal and external recruitment for 4 marks means 4 total and complete comparisons. Examples are given below:

  • internal recruitment involves recruiting an existing employee whereas external recruitment involves recruiting someone outside of the organisation.
  • internal recruitment is a cost effective method as posters can be put on a staff notice board but external recuitment is costly as adverts have to be placed on websites and newspapers.
  • internal recruitment requires that the candidate will need less training whereas external recruitment will be more costly and time consuming as the new candidate needs induction training perhaps followed by more specific training.
  • internal recruitment can mean that the new member of staff is already known in the organisation and their strengths are obvious, whereas external recruitment means that “new blood” and fresh ideas can be included in the organisation.

The same goes for the Internet versus a National Newspaper. Examples are given below:

  • The National newspaper is targeted to a specific target market whereas The Internet can be accessed by anyone
  • It is very expensive to advertise a job vacancy in the National newspaper compared to The Internet which is a far cheaper method of advertising
  • The National newspaper has a lifespan of one day in contrast to The Internet which exists on a daily basis
  • In order to see a National newspaper it requires effort and time to gather the information compared to The Internet which can be accessed 24/7 in the comfort of one’s own home or in one’s own working environment
  • The design and positioning of the advert in the National newspaper lies in the hands of the editor compared to The Internet, where the organisation has more freedom to decide where and how the advert is displayed (able to be more specific to the tastes of target market)
  • In order to respond to the advert in the National newspaper the candidate will have to either create a CV, Letter of Application etc whereas Using the Internet often asks the candidate to simply e-mail a response/application form which is far more easier and time effective.

Let me know if you find this helpful. Remember The Apprentice is on Wednesday evening – 15th December – Interview time!

Report a Glow concern
Cookie policy  Privacy policy