AO1 - Understand how safe working practices are applied in a business
environment.
|
| |
Pass |
Merit |
Distinction |
|
A
|
Candidates will explain, with examples, some safe working practices when
using ICT in a business environment. Their explanations will include the
potential danger that each measure is designed to address. Explanations will
include:
- at least one measure to protect health
- at least one measure to protect physical safety
- at least one measure to protect files from loss
- at least one measure to protect files from
unauthorised access
|
Candidates will explain, with examples, a range of safe working practices
when using ICT in a business environment. Their explanations will include the
potential danger that each measure is designed to address.
Explanations will
include:
- measures to protect health
- measures to protect physical safety
- different measures to protect files from loss
- at least one measure to protect files from unauthorised access
- at least one measure to protect files from modification.
|
Candidates will explain fully, with examples, a wide range of safe working
practices when using ICT in a business environment.
Their explanations will include the potential danger that each measure is
designed to address.
Explanations will include:
- measures to protect health
- measures to protect physical safety
- measures to protect files from loss
- at least one measure to protect files from unauthorised access
- measures to protect files from modification
- guidance on choosing a strong password
|
|
B |
Info:
- In this task you will learn about safe working practices
Task:
- For this task you will be required to perform research on the internet
and then create a presentation which will be used to explain safe working
practices to new employees of Yodafone.
- Explain the safe working practices (including the danger they are
supposed to address) for:
- at least 1 measure to protect health
- at least 1 measure to protect physical safety
- at least 1 measure to protect files from loss
- at least 1 measure to protect files from unauthorised access
- Use this worksheet to help you.
|
Info:
- In this task you will learn about safe working practices
Task:
- For this task you will be required to perform research on the internet
and then create a presentation which will be used to explain safe working
practices to new employees of Yodafone.
- Explain the safe working practices (including the danger they are
supposed to address) for:
- at least 2 measures to protect health
- at least 2 measures to protect physical safety
- at least 2 measures to protect files from loss
- at least 1 measure to protect files from unauthorised access
- at least 1 measure to protect files from modification
- Use this worksheet to help you.
|
Info:
- In this task you will learn about safe working practices
Task:
- For this task you will be required to perform research on the internet
and then create a presentation which will be used to explain safe working
practices to new employees of Yodafone.
- Explain the safe working practices (including the danger they are
supposed to address) for:
- at least 2 measures to protect health
- at least 2 measures to protect physical safety
- at least 2 measures to protect files from loss
- at least 1 measure to protect files from unauthorised access
- at least 2 measures to protect files from modification
- guidance on choosing a strong password
- Use this worksheet to help you.
|
AO2 - using appropriate software, select and use tools and facilities to
download files/information and to understand how to use email in a business
context.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates will use a search engine to source
information for a specific purpose using the Internet. They will store some
information and will provide the website address(es) for the information found.
Candidates will demonstrate an understanding of the use of email to communicate
information for business purposes, including sending a message to more than one
recipient, sending, receiving and saving/opening an attachment safely, the
appropriate use of forward and reply, and the need for appropriate use of
subject and message text in email.
Candidates will make a brief comment about the risks of receiving and opening
email attachments. |
Candidates will use a search engine to source
information for a specific purpose using the Internet, using effective search
criteria, eg keywords.
They will store some information and will provide the website address(es) for
the information found commenting on the trustworthiness of the source(s).
They will use bookmarks/favourites to store useful links.
They will demonstrate an understanding of the implications of copyright for
business use.
Candidates will demonstrate an understanding of the use of email to communicate
information for business
purposes, including sending a message to more than one recipient, sending,
receiving and saving/opening an
attachment safely, the appropriate use of forward and reply, and the need for
appropriate use of subject and
message text in email.
Candidates will summarise the risks of receiving and opening email attachments.
They demonstrate an understanding of at least two of the extended email features
as listed in the KUS:
- Setting priority (high & low importance)
- Use of an address book to store, retrieve and use email addresses and
details of personal contacts
|
Candidates will use a search engine to
source information for a specific purpose using the Internet, making effective
use of advanced search criteria eg quotes, wildcards, advanced search pages.
They will store some information. They will comment on the validity of their
sources: provide details of their source website addresses, note trustworthiness
of sources and date of
information.
They will use bookmarks/favourites to store useful links and will organise these
bookmarks/favourites into folders.
They will demonstrate an understanding of the implications of copyright for
business use.
Candidates will demonstrate an understanding of the use of email to communicate
information for business
purposes, including sending a message to more than one recipient, sending,
receiving and saving/opening an
attachment safely, the appropriate use of forward and reply, and the need for
appropriate use of subject and
message text in email.
Candidates will summarise the risks of receiving and opening email attachments
and suggest actions that
could be taken to reduce these risks.
They demonstrate an understanding of at least four of the extended email
features as listed in the KUS:
- Setting priority (high & low importance)
- Use of an address book to store, retrieve and use email addresses and
details of personal contacts
- Email signature
- Effective use of Cc and Bcc
|
| A |
Info:
- In this task you will use a search engine to find out about the
risks of receiving and opening email attachments.
Task:
- Download and complete this
worksheet.
- Save this document in your Unit 1 AO2 folder as
Internet-Pass.
|
Info:
- In this task you will use a search engine effectively to find out about
the risks of receiving and opening email attachments.
Task:
- Download and complete this
worksheet.
- Save this document in your Unit 1 AO2 folder as
Internet-Merit.
|
Info:
- In this task you will use a search engine effectively to find out about
the risks of receiving and opening email attachments.
Task:
- Download and complete this
worksheet.
- Save this document in your Unit 1 AO2 folder as
Internet-Distinction.
|
| B |
Info:
- This task checks you can send an email with an appropriate subject and
message to multiple recepients.
Task:
- Create a new email addressed to
eryan@educ.somerset.gov.uk
and
smackenzie@educ.somerset.gov.uk
- Add an appropriate subject
- Add a note to the message body explaining that you would like to say
what the risks of opening an email attachment is.
- In the message body copy and paste the research you did in the previous
task about the risks of opening email attachments
- Send the email
- Find the message in your outbox, open it up and print-screen the email,
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task C.
|
Info:
- This task checks you can store contacts in your address book.
Task:
|
Info:
- This task checks you can store contacts in your address book.
Task:
|
| C |
Info:
- This task checks you can receive an email with an attachment which you
can safely save and open.
Task:
- In your inbox you will have received an email from your teacher.
- Open the email you have received and print screen this as evidence and
paste this evidence into a new word document
- Save one of the attachments from the email into your unit 1 ao2
folder print screen this as evidence and paste this into the word document.
- Open the attachment you have saved and print screen this as evidence and
paste this into the word document.
- Save this document in your Unit 1 AO2 folder as
email task D.
|
Info:
- This task checks you can send an email with an appropriate subject and
message to multiple recipients.
Task:
- Create a new email addressed to Mr E Ryan and Mr S Mackenzie
- Set the priority as high.
- Add an appropriate subject
- Add a note to the message body explaining that you would like to say
what the risks of opening an email attachment is.
- In the message body copy and paste the research you did in the previous
task about the risks of opening email attachments
- Send the email
- Find the message in your outbox, open it up and print-screen the email,
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task C.
|
Info:
- This task checks you can create and use an email signature.
Task:
- Create a formal email signature to be added to your outgoing emails.
- Print screen your signature settings.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task B
|
| D |
Info:
- This task checks you can forward an email.
Task:
- Open the email you have received from your teacher
- Forward this message onto smackenzie@educ.somerset.gov.uk
- Leave the subject as it is.
- Add a message to the email body asking if the attachments you have
received from your teacher are safe to open.
- Send the email
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task E.
|
Info:
- This task checks you can receive an email with an attachment which you
can safely save and open.
Task:
- In your inbox you will have received an email from your teacher.
- Open the email you have received and print screen this as evidence and
paste this evidence into a new word document
- Save one of the attachments from the email into your unit 1 ao2
folder print screen this as evidence and paste this into the word document.
- Open the attachment you have saved and print screen this as evidence and
paste this into the word document.
- Save this document in your Unit 1 AO2 folder as
email task D.
|
Info:
- This task checks you can send an email with an appropriate subject and
message to multiple recipients.
Task:
- Create a new email addressed to Mr E Ryan and Mr S Mackenzie
- Set the priority as high.
- Add an appropriate subject
- Add a note to the message body explaining that you would like to say
what the risks of opening an email attachment is.
- In the message body copy and paste the research you did in the previous
task about the risks of opening email attachments
- Add your signature to the email
- Send the email
- Find the message in your outbox, open it up and print-screen the email,
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task C.
|
| E |
Info:
- This task checks you can reply to an email.
Task:
- Open the email you have received from your teacher
- Reply to this message sending it to your teacher.
- Leave the subject as it is.
- Add a message to the email body thanking him for the attachments.
- Send the email
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task F.
|
Info:
- This task checks you can forward an email.
Task:
- Open the email you have received from your teacher
- Forward this message onto
smackenzie@educ.somerset.gov.uk
- Leave the subject as it is.
- Add a message to the email body asking if the attachments you have
received from your teacher are safe to open.
- Send the email
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task E.
|
Info:
- This task checks you can receive an email with an attachment which you
can safely save and open.
Task:
- In your inbox you will have received an email from your teacher.
- Open the email you have received and print screen this as evidence and
paste this evidence into a new word document
- Save one of the attachments from the email into your unit 1 ao2
folder print screen this as evidence and paste this into the word document.
- Open the attachment you have saved and print screen this as evidence and
paste this into the word document.
- Save this document in your Unit 1 AO2 folder as
email task D.
|
| F |
|
Info:
- This task checks you can reply to an email.
Task:
- Open the email you have received from your teacher
- Reply to this message sending it to your teacher.
- Leave the subject as it is.
- Set the priority as low.
- Add a message to the email body thanking him for the attachments.
- Send the email
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task F.
|
Info:
- This task checks you can forward an email.
Task:
- Open the email you have received from your teacher
- Forward this message onto
smackenzie@educ.somerset.gov.uk
- Leave the subject as it is.
- Add a message to the email body asking if the attachments you have
received from your teacher are safe to open.
- Add your signature to the email.
- Send the email.
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task E.
|
| G |
|
|
Info:
- This task checks you can reply to an email.
Task:
- Open the email you have received from your teacher
- Reply to this message sending it to Mr Ryan, CC it to a friend and BCC
it to Mr Mackenzie
- Leave the subject as it is.
- Set the priority as low.
- Add a message to the email body thanking him for the attachments.
- Add your signature to the email.
- Send the email.
- Find the message in your outbox, open it up and print-screen the email.
- Paste the print screen into a new word document and save this document
in your Unit 1 AO2 folder as email task F.
|
AO3 - Design and create a business presentation to accompany a talk, using
presentation software
|
| |
Pass |
Merit |
Distinction |
| |
Candidates will design and create a business
presentation of at least five slides selecting and using text and graphics.
There may not be a consistent style to the slides.
There will be some evidence that the candidate has checked for errors and the
presentation will be largely fit for purpose. |
Candidates will design and create a business
presentation of at least five slides selecting and using appropriate text and
graphics.
There will be some consistency of style used on the slides, although there may
be some exceptions.
Slide transitions will have been set, but these may not always be the most
effective.
The presentation will be checked and free from obvious errors.
The candidate will print out the presentation in handout form. |
Candidates will design and create a business
presentation of at least five slides selecting and using appropriate
text and graphics.
A consistent house style will be used on all the slides.
Slide transitions and animations will have been set and these will be
appropriate for the purpose and
audience.
The final presentation will be checked and will be of near professional quality.
Speaker notes will be added where appropriate.
The candidate will print out the presentation in handout form, and showing the
notes pages. |
| A |
Info:
- You are required to create a 5 slide presentation for Yodafone to
advertise their new mobile phone collection for PAYG & contract.
- The target audience for this presentation is teenagers so choose
appropriate content to meet this.
Task:
- Create a new presentation
- Add slides so the presentation has 5 in total
- Add titles to the slides
- Using mobile phone sites such as
Carphone warehouse or
Bing images to collect
information (images & text) and add it to your slides.
- Save this presentation in your Unit 1 AO3 folder as
Yodafone presentation.
|
Info:
- You are required to create a 5 slide presentation for Yodafone to
advertise their new mobile phone collection for PAYG & contract.
- The target audience for this presentation is teenagers so choose
appropriate content to meet this.
Task:
- Create a new presentation
- Add slides so the presentation has 5 in total
- Add titles to the slides
- Make sure the presentation has a common house style across most slides.
- Using mobile phone sites such as
Carphone warehouse or
Bing images to collect
appropriate information (images & text) and add it to your slides.
- Add appropriate transitions to the slides.
- Save this presentation in your Unit 1 AO3 folder as
Yodafone presentation.
|
Info:
- You are required to create a 5 slide presentation for Yodafone to
advertise their new mobile phone collection for PAYG & contract.
- The target audience for this presentation is teenagers so choose
appropriate content to meet this.
Task:
- Create a new presentation
- Add slides so the presentation has 5 in total
- Add titles to the slides
- Make sure the presentation has a common house style across all slides.
- Using mobile phone sites such as
Carphone warehouse or
Bing images to collect
appropriate information (images & text) and add it to your slides.
- Add appropriate transitions to the slides.
- Add slide animations and GIF animations.
- Save this presentation in your Unit 1 AO3 folder as
Yodafone presentation.
|
| B |
Info:
- Before Yodafone lets the public see the presentation they need check it
for errors. (spelling & grammar check)
Task:
- Spell check the presentation.
- Print screen the spell check results.
- Complete this worksheet.
- Save the word document in your Unit 1 AO3 folder as
presentation evidence.
|
Info:
- Before Yodafone lets the public see the presentation they need check it
for errors. (spelling & grammar check)
Task:
- Proof read the presentation to ensure it is free from obvious errors.
- Spell check the presentation.
- Print screen the spell check results.
- Complete this worksheet.
- Save the word document in your Unit 1 AO3 folder as
presentation evidence.
|
Info:
- Yodafone have asked that you add speaker notes to the slides (where
appropriate) so that when the presentation is given the speaker knows what
to say.
Task:
- Add speaker notes where appropriate
|
| C |
|
Info:
- Yodafone will need a printed copy of the presentation to give to the
speaker.
Task:
- Print the presentation in handout form.
|
Info:
- Before Yodafone lets the public see the presentation they need check it
for errors. (spelling & grammar check)
Task:
- Check the presentation is of near professional quality.
- Proof read the presentation to ensure it is free from obvious errors.
- Spell check the presentation.
- Print screen the spell check results.
- Complete this worksheet.
- Save the word document in your Unit 1 AO3 folder as
presentation evidence.
|
| D |
|
|
Info:
- Yodafone will need a printed copy of the presentation to give to the
speaker.
Task:
- Print the presentation as a handout.
- Print the presentation as notes pages.
|
AO4 - Design and create business documents using word processing or DTP
software.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates will design and create straightforward
business documents.
These will include a letter and at least two other documents such as a business
card, flyer, newsletter, invoice, memo, agenda, report or minutes.
At least one document will include graphics using more than one source, eg clip
art, the World Wide Web, scanner, digital camera, drawing package, spreadsheet
or database.
All documents will have been checked using a spelling checker but some errors
may remain.
Some formatting features, eg font style and size and paragraph justification
will have been used.
The final documents will be largely fit for purpose |
Candidates will design and create at least three types
of business document, including a letter and a document of
more than one page.
They will include graphics from a range of sources.
They will use spelling and grammar checks and will edit the documents to improve
and correct them so that few
errors remain.
There will be some consistency to the layout of the documents, although there
may be some exceptions.
There will be evidence of the use of a range of software tools/facilities and
these will have been used appropriately.
The final documents will be fit for purpose. |
Candidates will design and create at least three types
of business document, including a mail merged letter and a
document of several pages.
They will include graphics from a wide range of sources.
Candidates will design a house style and will use this in the production of all
documents.
They will insert fields, including date and document information.
There will be evidence of the use of a wide range of software tools/facilities
and these will have been used
appropriately.
All documents produced will have been thoroughly checked using spelling and
grammar checks, and proof read, so that they are virtually error-free |
| A |
Info:
- In this task you will create a business letter.
Task:
- Open a new word document.
- This document should be A4, include a company logo, date, address &
message.
- Create a letter which will be sent
to existing customers explaining that Yodafone International will be running
a buy one get one free offer on accessories next month.
- Save this in your Unit 1 AO4 folder as business
letter
|
Info:
- In this task you will create a business letter.
Task:
- Open a new word document.
- This document should be A4, include a company logo, date, address &
message.
- Create a letter which will be sent
to existing customers explaining that Yodafone International will be running
a buy one get one free offer on accessories next month.
- Save this in your Unit 1 AO4 folder as business
letter
|
Info:
- In this task you will create a business letter.
Task:
- Open a new word document.
- This document should be A4, include a company logo, address & message.
- The date should be inserted using a date field.
- Create a letter which will be sent
to existing customers explaining that Yodafone International will be running
a buy one get one free offer on accessories next month.
- Mail merge the letter to customers in this database and then print
screen the letter showing merge fields.
- Paste the print screen into a new word document called mail
merge evidence and save this into your Unit 1 AO4
folder.
- Save the letter in your Unit 1 AO4 folder as
business letter
|
| B |
Info:
- In this task you will create a business card.
Task:
- Open a new publisher document.
- This document should be business card size (8.5cm*5.5cm),
include a company logo, title, position & contact details.
- Using your design plan to help you, create a business card for Dan which
he can use to hand out when he is at conferences.
- Save this in your Unit 1 AO4 folder as business
card
|
Info:
- In this task you will create a business card.
Task:
- Open a new publisher document.
- This document should be business card size (8.5cm*5.5cm),
include a company logo, title, position & contact details.
- Using your design plan to help you, create a business card for Dan which
he can use to hand out when he is at conferences.
- Save this in your Unit 1 AO4 folder as business
card
|
Info:
- In this task you will create a business card.
Task:
- Open a new publisher document.
- This document should be business card size (8.5cm*5.5cm),
include a company logo, title, position & contact details.
- Using your design plan to help you, create a business card for Dan which
he can use to hand out when he is at conferences.
- Save this in your Unit 1 AO4 folder as business
card
|
| C |
Info:
- In this task you will create a business memo.
Task:
- Open a new word document.
- This document should be A4, include a company logo, to, from, subject,
date & message.
- Using your design plan to help you, create a memo which will be sent to
employees of Yodafone International from the CEO which will inform them that
this Christmas they will all receive a bonus of 10%.
- Save this in your Unit 1 AO4 folder as business
memo
|
Info:
- In this task you will create a business memo.
Task:
- Open a new word document.
- This document should be A4, include a company logo, to, from, subject,
date & message.
- Using your design plan to help you, create a memo which will be sent to
employees of Yodafone International from the CEO which will inform them that
this Christmas they will all receive a bonus of 10%.
- Save this in your Unit 1 AO4 folder as business
memo
|
Info:
- In this task you will create a business memo.
Task:
- Open a new word document.
- This document should be A4, include a company logo, to, from, subject,
date & message.
- Using your design plan to help you, create a memo which will be sent to
employees of Yodafone International from the CEO which will inform them that
this Christmas they will all receive a bonus of 10%.
- Save this in your Unit 1 AO4 folder as business
memo
|
| D |
Info:
- In this task you will produce evidence that you have have checked the
documents using a spelling checker.
Task:
- Open this worksheet
- For each of the documents you have created use a spelling checker and
print screen the results and paste them in to the worksheet.
- Save this in your Unit 1 AO4 folder as document
checks
|
Info:
- In this task you will create a double sided newsletter that will be
given out to employees of yodafone.
- This newsletter must include:
- top 5 phones (using images from the WWW)
- sales figures over the past 12 months (using a chart from a
spreadsheet package)
- business person of the year (using a picture taken from a
digital camera or scanner)
Task:
- Open a new publisher document.
- This document should be A4, be 4 pages, have page numbers and include a
company logo.
- Save this in your Unit 1 AO4 folder as
newsletter
|
Info:
- In this task you will create a double sided newsletter that will be
given out to employees of yodafone.
- This newsletter must include:
- top 5 phones (using images from the WWW)
- sales figures over the past 12 months (using a chart from a
spreadsheet package)
- business person of the year (using a picture taken from a
digital camera or scanner)
Task:
- Open a new publisher document.
- This document should be A4, be 4 pages, have page numbers and include a
company logo.
- This document must also include a piece of clipart and an image from a
drawing package.
- Save this in your Unit 1 AO4 folder as
newsletter
|
| E |
|
Info:
- In this task you will produce evidence that you have have checked the
documents using a spelling & grammar checker and made improvements.
Task:
- Open this worksheet
- For each of the documents you have created use a spelling & grammar
checker and print screen the results and paste them in to the worksheet.
- Make changes to spelling and grammar and then print screen the spelling
& grammar checks again so that it shows an improvement.
- Save this in your Unit 1 AO4 folder as document
checks
|
Info:
- In this task you will produce evidence that you have have checked the
documents using a spelling & grammar checker, had the document proof
read and made improvements.
Task:
- Open this worksheet
- For each of the documents you have created use a spelling & grammar
checker and print screen the results and paste them in to the worksheet.
- Make changes to spelling and grammar and then print screen the spelling
& grammar checks again so that it shows an improvement.
- Get others to proof read your documents then fill in the worksheet to
show that they agree the documents are virtually error free.
- Save this in your Unit 1 AO4 folder as document
checks
|
AO5 - Design, create and use a business spreadsheet.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates will design and create a business
spreadsheet for a given purpose using at least two different calculations.
The functions/formulas may not be efficient, but will work.
There will be sufficient row/column headings to make the spreadsheet reasonably
easy to understand.
Some formatting will be applied to improve the appearance of the spreadsheet.
Candidates will change some of the numeric data in the spreadsheet to model the
expected outcome of at least two different scenarios. They will note the
results.
Candidates will print out their spreadsheet. |
Candidates will design and create an effective business
spreadsheet for a given purpose displaying accurate figures.
Several different formulas, including at least one function and at least one
arithmetic operator will have been used.
The spreadsheet will contain a title and
appropriate row/column headings.
A range of formatting will be applied to
improve the appearance of the
spreadsheet.
Candidates will change some of the
numeric data in the spreadsheet to
model the expected outcome of at least
two different scenarios. They will note
and explain the results.
Candidates will preview and print out
their spreadsheet using appropriate
page orientation and number of pages.
Formula printout(s) will be included. |
Candidates will design and create an
effective business spreadsheet for a
given purpose displaying accurate
figures.
Several different formulas will be used
efficiently and will include the
appropriate use of more than one
function and at least two different
arithmetic operators.
The spreadsheet will contain a title and
appropriate row/column headings.
The spreadsheet will be formatted
effectively using a range of format
options to improve the appearance of
the spreadsheet.
Candidates will change some of the
numeric data in the spreadsheet to
model the expected outcome of at least
two different scenarios. They will note
and explain the results.
Candidates will preview and print out
their spreadsheet using appropriate
page orientation and number of pages.
They will use appropriate headers
and/or footers and will set at least one
further print layout feature
appropriately.
Formula printout(s) will be included. |
| A |
Info:
- In this task you will design your spreadsheet
- The spreadsheet must be suitable for the purpose listed below.
Purpose
- The spreadsheet needs to be an invoice sent from Yodafone to one of its
customers for a recent order from their website.
Task:
- Use this worksheet to help you create a design plan.
- Save this in your Unit 1 AO5 folder as design
plan
|
Info:
- In this task you will design your spreadsheet
- The spreadsheet must be suitable and effective for the purpose listed
below. The spreadsheet must also display accurate figures.
Purpose
- The spreadsheet needs to be an invoice sent from Yodafone to one of its
customers for a recent order from their website.
Task:
- Use this worksheet to help you create a design plan.
- Save this in your Unit 1 AO5 folder as design
plan
|
Info:
- In this task you will design your spreadsheet
- The spreadsheet must be suitable and effective for the purpose listed
below. The spreadsheet must also display accurate figures.
Purpose
- The spreadsheet needs to be an invoice sent from Yodafone to one of its
customers for a recent order from their website.
Task:
- Use this worksheet to help you create a design plan.
- Save this in your Unit 1 AO5 folder as design
plan
|
| B |
Info:
- In this task you will create the spreadsheet
Task:
- Open a new Excel document
- Make sure your spreadsheet has a company title, company logo, date at
the top of the sheet.
- In the main section of the sheet you need to set column or row titles
then list items names, quantities, cost and line cost.
- Underneath the main section you need to have titles and calculations
that display the sub total, delivery charge, VAT percentage and grand total.
- You will need to specify line total, sub total and grand total using
formulas. (note the line total and grand total will require the use of
arithmetic operators)
- Set some cell formatting
- Set borders and background colours
- Rename the sheet as original
- Save this in your Unit 1 AO5 folder as Invoice
|
Info:
- In this task you will create the spreadsheet
Task:
- Open a new Excel document
- Make sure your spreadsheet has a company title, company logo, date at
the top of the sheet.
- In the main section of the sheet you need to set a document title,
column or row titles then list items names, quantities, cost and line cost.
- Underneath the main section you need to have titles and calculations
that display the sub total, delivery charge, VAT percentage and grand total.
- You will need to specify the date using a function, the line total, sub
total and grand total using formulas. (note the line total and grand total
will require the use of arithmetic operators)
- Set a range cell formatting so that improves the appearance of the sheet
- Set borders and background colours
- Rename the sheet as original
- Save this in your Unit 1 AO5 folder as Invoice
|
Info:
- In this task you will create the spreadsheet
Task:
- Open a new Excel document
- Make sure your spreadsheet has a company title, company logo, date at
the top of the sheet.
- In the main section of the sheet you need to set a document title,
column or row titles then list items names, quantities, cost and line cost.
- Underneath the main section you need to have titles and calculations
that display the sub total, delivery charge, VAT percentage and grand total.
- You will need to specify the date and delivery using functions, the line
total, sub total and grand total using formulas. (note the line total and
grand total will require the use of arithmetic operators)
- Set a range of effective cell formatting so that improves the appearance
of the sheet
- Set borders and background colours
- Rename the sheet as original
- Save this in your Unit 1 AO5 folder as Invoice
|
| C |
Info:
- In this task you will edit the spreadsheet
Task:
- Open the excel sheet from the previous task
- Copy the sheet within Excel and rename it as changed
- Change the VAT rate so it increases by 2.5%
- Save this in your Unit 1 AO5 folder as Invoice
|
Info:
- In this task you will edit the spreadsheet
Task:
- Open the excel sheet from the previous task
- Copy the sheet within Excel and rename it as changed
- Change the VAT rate so it increases by 2.5%
- Save this in your Unit 1 AO5 folder as Invoice
|
Info:
- In this task you will edit the spreadsheet
Task:
- Open the excel sheet from the previous task
- Copy the sheet within Excel and rename it as changed
- Change the VAT rate so it increases by 2.5%
- Save this in your Unit 1 AO5 folder as Invoice
|
| D |
Info:
- In this task you will print the spreadsheet
Task:
- Open the excel sheet from the previous task
- Print the original sheet
- Print the changed sheet
|
Info:
- In this task you will print the spreadsheet
Task:
- Open the excel sheet from the previous task
- Print the original sheet making sure it fits onto one
piece of paper
- Print the changed sheet making sure it fits onto one
piece of paper
- Print the original formula sheet making sure it fits
onto one piece of paper
- Print the changed formula sheet making sure it fits
onto one piece of paper
|
Info:
- In this task you will print the spreadsheet
Task:
- Open the excel sheet from the previous task
- Set a footer on both the original and changed
sheet that displays the page number and date.
- Print the original sheet making sure it fits onto one
piece of paper
- Print the changed sheet making sure it fits onto one
piece of paper
- Print the original formula sheet making sure it fits
onto one piece of paper
- Print the changed formula sheet making sure it fits
onto one piece of paper
|
| E |
Info:
- In this task you will collect print screen evidence from the spreadsheet
Task:
- Open the excel sheet from the previous task
- Open a new word document
- Print screen the original sheet and paste it into the
word document (set an appropriate title).
- Print screen the changed sheet and paste it into the
word document (set an appropriate title).
- Note the results
- Save the word document in your Unit 1 AO5 folder as
Invoice results
|
Info:
- In this task you will collect print screen evidence from the spreadsheet
Task:
- Open the excel sheet from the previous task
- Open a new word document
- Print screen the original sheet and paste it into the
word document (set an appropriate title).
- Print screen the changed sheet and paste it into the
word document (set an appropriate title).
- Note and explain the results
- Save the word document in your Unit 1 AO5 folder as
Invoice results
|
Info:
- In this task you will collect print screen evidence from the spreadsheet
Task:
- Open the excel sheet from the previous task
- Open a new word document
- Print screen the original sheet and paste it into the
word document (set an appropriate title).
- Print screen the changed sheet and paste it into the
word document (set an appropriate title).
- Note and explain the results
- Save the word document in your Unit 1 AO5 folder as
Invoice results
|
AO6 - Select and use tools and facilities in database software to enter,
sort and search for information for business purposes using a realistic database
provided by the centre.
|
| |
Pass |
Merit |
Distinction |
| |
Candidates will enter, edit and delete data in a
database.
These changes will be largely accurate.
They will select data for a specified purpose by creating and using at least one
query with at least one search criterion. |
Candidates will enter, edit and delete data in a
database.
These changes will be made accurately.
They will select data for a specified purpose by creating and using at least one
query with at least one search criterion, sorting on at least one field.
They will present the results of the query in an appropriate report. |
Candidates will enter, edit and delete data in a
database.
These changes will be made accurately.
They will select data for a specified purpose by creating and using at least one
query with more than one search
criterion, sorting on at least one field.
They will present the results of query(s) using at least two different reports.
The two reports will display data in different formats, eg address labels, table
format, list.
The reports will display the selected data well. |
| A |
Info:
- In this task you will add a record into a database
- You will need to download and save this
database as mobile for the task
Purpose
- A new customer has joined the Yodafone mailing list.
Task:
- Open the database
- Open a new word document
- A new customer has joined Yodafone, open the database and enter the following
customer details into the database
- Initial: M
- Surname: Khan
- Address1: 31
- Address2: Haystings Close
- Address3: York
- Postcode: YO4 2TT
- Age: 15
- Print screen the database table and paste it into the word document.
- Save the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will add a record into a database
- You will need to download and save this
database as mobile for the task
Purpose
- A new customer has joined the Yodafone mailing list.
Task:
- Open the database
- Open a new word document
- A new customer has joined Yodafone, open the database and enter the following
customer details into the database
- Initial: M
- Surname: Khan
- Address1: 31
- Address2: Haystings Close
- Address3: York
- Postcode: YO4 2TT
- Age: 15
- Print screen the database table and paste it into the word document.
- Save the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will add a record into a database
- You will need to download and save this
database as mobile for the task
Purpose
- A new customer has joined the Yodafone mailing list.
Task:
- Open the database
- Open a new word document
- A new customer has joined Yodafone, open the database and enter the following
customer details into the database
- Initial: M
- Surname: Khan
- Address1: 31
- Address2: Haystings Close
- Address3: York
- Postcode: YO4 2TT
- Age: 15
- Print screen the database table and paste it into the word document.
- Save the word document in your Unit 1 AO6 folder as
Database Evidence
|
| B |
Info:
- In this task you will delete a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has requested that they no longer on the Yodafone mailing
list
Task:
- Open the database
- Open the word document
- Print screen the database table during the delete and paste it into the
word document.
- A Smith has asked to be removed from the database.
Delete this record.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will delete a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has requested that they no longer on the Yodafone mailing
list
Task:
- Open the database
- Open the word document
- Print screen the database table during the delete and paste it into the
word document.
- A Smith has asked to be removed from the database.
Delete this record.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will delete a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has requested that they no longer on the Yodafone mailing
list
Task:
- Open the database
- Open the word document
- Print screen the database table during the delete and paste it into the
word document.
- A Smith has asked to be removed from the database.
Delete this record.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
| C |
Info:
- In this task you will edit a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has got married and wishes to update her details
Task:
- Open the database
- Open the word document
- Print screen the database table during the edit and paste it into the
word document.
- T Park has recently married and is now T
Forrest. edit this record, to reflect this change.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will edit a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has got married and wishes to update her details
Task:
- Open the database
- Open the word document
- Print screen the database table during the edit and paste it into the
word document.
- T Park has recently married and is now T
Forrest. edit this record, to reflect this change.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will edit a record in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- A customer has got married and wishes to update her details
Task:
- Open the database
- Open the word document
- Print screen the database table during the edit and paste it into the
word document.
- T Park has recently married and is now T
Forrest. edit this record, to reflect this change.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
| D |
Info:
- In this task you will create a simple query in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone are going to write to customers that live in Leeds and need to
form a list.
Task:
- Open the database
- Open the word document
- Create a query showing all of the customers that live in Leeds.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will create a query in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone are going to write to customers that live in Leeds and need to
form a list.
Task:
- Open the database
- Open the word document
- Create a query called Leeds showing all of the
customers that live in Leeds and is sorted alphabetically by surname.
- Print screen the design view and table once it has been queried and
paste into the word document.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
Info:
- In this task you will create an advanced query in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone are going to write to customers that live in Leeds and need to
form a list.
Task:
- Open the database
- Open the word document
- Create a query called Leeds showing all of the
customers aged between 16 and 25 that live in Leeds
and is sorted alphabetically by surname.
- Print screen the design view and table once it has been queried and
paste into the word document.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence
|
| E |
|
Info:
- In this task you will create a report based on a query in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone need the printed copy of the list that looks neat.
Task:
- Open the database
- Open the word document
- Create a report called Leeds showing based on the query
called Leeds.
- Print screen the query and paste into the word document.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence1
|
Info:
- In this task you will create a report based on a query in a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone need the printed copy of the list that looks neat.
Task:
- Open the database
- Open the word document
- Create a report called Leeds showing based on the query
called Leeds.
- Print screen the report and paste into the word document.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence1
|
| F |
|
|
Info:
- In this task you will create an address label report based on a query in
a database
- You will need to use the database downloaded previously called
mobile and the word document created previously called
Database evidence
Purpose
- Yodafone need the addresses printed onto sticky labels for the
envelopes.
Task:
- Open the database
- Open the word document
- Create a label report called LeedsLabel showing based on
the query called Leeds.
- Print screen the report and paste into the word document.
- Resave the word document in your Unit 1 AO6 folder as
Database Evidence2
|
