Transcript replaced with your own work

©M Robinson (All Saints College)
Instructions
(this slide should be deleted before final hand-in)
• This is an OCR National Unit 1 evidence book.
• The yellow slides contain information on what you will
need to do to achieve a pass. They are all compulsory
(have to do) elements.
• The blue slide contain information on how to achieve
merit and distinction grades. These slides are not
compulsory (discuss these with your teacher).
• The information within the slides is for instruction
only and can not be used as evidence, it must be
deleted and replaced with your own work.
• The only thing that will remain the same on the slides is
the title which contains important assessment
references.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g1
©M Robinson (All Saints College)
Assessment Information
(this slide should be deleted before final hand-in)
•
•
Blue slides must be attempted independently, teachers can clarify what has
to be done but should not give direct instructions on how to do the tasks in
the case study. If you are not sure try using the help information on the main
toolbar of most applications. Teachers can give demonstrations of some
application features to the class. (So pay attention!).
The difference between Merit and Distinction is often quality of explanation
do not be afraid to add more slides if you want to put in more evidence to
achieve these grades. However be sure to include the assessment
references on the slide. See below.
Assessment
References
Explained
Assessment
Objective
Number
A01Da
Pass, Merit or Distinction Criteria
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
A reference to
statements on the
unit grading grid
contained in the
units OCR
Specification
g2
For Teachers Use Only
Assessors Initials
©M Robinson (All Saints College)
Internal Verifiers Initials
Final Assessment Objective Grade
AO6
Select and use tools and facilities in database
software to enter, sort and search for
information for business purposes using a
realistic business database provided by the
centre
View Header and
Footer
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g3
©M Robinson (All Saints College)
A06Pa Candidates will enter, edit and delete data
in a database.
• Screenshot entering
data into the
database part a in the
case study.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g4
©M Robinson (All Saints College)
A06Pa ctd Candidates will enter, edit and
delete data in a database.
Screenshot editing data
in the database part b
in the case study.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g5
©M Robinson (All Saints College)
A06Pa ctd Candidates will enter, edit and
delete data in a database.
Screenshot deleting
data from the
database part c in the
case study.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g6
©M Robinson (All Saints College)
A06Pb They will create and use at least one simple query
i.e. using a single search criterion.
• Screenshot of the
design grid you used
to create your query.
• Screenshot of the
results in table view.
• Explain what you did
here.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g7
©M Robinson (All Saints College)
A06McThey will create and use at least one simple query
ie using a single search criterion, sorting on at least one
field.
• You should show and describe
how you sorted a further query
on the database this query
should answer a specific
question of your own choosing
and design.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g8
©M Robinson (All Saints College)
A06Mc They will create and use a report to print out
selected data for a specific need.
•
•
•
Produce the report asked for in the
case study. Produce two screenshots
one showing the wizard used and the
second showing the completed report.
Describe the process step by step
here.
The report should also be published
and saved in Microsoft Word. This will
be in Tools and Office Links in Ms
Access.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g9
©M Robinson (All Saints College)
A06Da aCandidates will enter edit and delete data in a
database and will use the data to meet a wide range of
business purposes.
• Show screenshots of
completing the
additional distinction
tasks in the case
study which are
underlined.
• The reports should be
saved to MS Word.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g10
©M Robinson (All Saints College)
A06Db bThey will create and use at least two queries
•
You should show screenshots of using your
two queries in the making of your reports.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g11
©M Robinson (All Saints College)
A06Dc They will create and use at least two reports to print
out selected data in different formats eg address labels
•
•
You should produce the reports for
Merit and the extra one for
distinction provide screenshots of
the extra one and a copy of the
finished report save to MS Word.
Describe the process here.
Replace this with your
full name
OCR Unit 1 ICT Skills for
Business
g12