WorksheetsCSMI Passing Strategy
Total questions: 45
Worksheet time: 23mins
What is the minimum number of marks required to pass BTEC Unit 2?
18 marks
24 marks
33 marks
40 marks
What is the total number of marks available in BTEC Unit 2?
50 marks
66 marks
80 marks
100 marks
How many marks is Part A of the exam worth?
26 marks
33 marks
40 marks
46 marks
How many marks is Part B of the exam worth?
20 marks
26 marks
30 marks
40 marks
Which activity is worth the MOST marks?
Activity 1: Relationships
Activity 3: Queries & Report
Activity 6: Forms
Activity 5: Evaluation
How many marks is Activity 6 (Forms) worth?
(a)
According to the Pass First strategy, what is a realistic target for the entire exam?
18-24 marks
25-28 marks
29-37 marks
40-50 marks
Which activities are considered 'accessible' for guaranteed marks?
Activities 3 and 6
Activities 1, 2, 4, 5, and 8
Only Activity 1
Activities 6 and 7
How many validation types must you demonstrate in Activity 2?
3 types
4 types
5 types
6 types
What validation rule is used for a Presence Check in Access?
Required = Yes
Is Not Null
Not Empty
Must Have Value
Which validation expression checks the length of a field?
Size([FieldName])>=4
Len([FieldName])>=4
Length([FieldName])>=4
Count([FieldName])>=4
What Access feature is used for a Format Check?
Validation Rule
Data Type
Input Mask
Field Size
In an Input Mask, what does '>L' represent?
A required lowercase letter
A required uppercase letter
An optional letter
A required number
What is the correct syntax for a Range Check between 7 and 10?
>=7 And <=10
Between 7 And 10
>7 And <10
Range(7,10)
How do you implement a Table Lookup validation?
Using a combo box
Using Referential Integrity
Using a validation rule
Using an Input Mask
Where should you screenshot validation rules from?
Datasheet View
Query Design View
Field Properties panel
Relationship Window
What does a Presence Check prevent?
Duplicate entries
Fields being left empty
Invalid characters
Values outside a range
Which validation type ensures a value exists in another table?
Presence Check
Format Check
Range Check
Table Lookup
The three types of test data you must use are:
Normal, erroneous, and extreme
Normal, random, and duplicate
Extreme, duplicate, and missing
Erroneous, random, and duplicate
Which of the following are the three main types of test data?
Good, Bad, Ugly
Valid, Invalid, Boundary
Normal, Extreme, Erroneous
Input, Output, Process
What is 'Normal' test data?
Data at the boundaries
Valid data that should be accepted
Invalid data that should be rejected
Random data
What is 'Extreme' test data?
Invalid data
Data outside the range
Valid data at the boundaries
Random characters
What is 'Erroneous' test data?
Valid data that should be accepted
Data at the boundaries
Invalid data that should be rejected
Typical expected data
If a Range Check is Between 7 And 10, which value is EXTREME?
5
8
10
12
If a Range Check is Between 7 And 10, which value is ERRONEOUS?
7
8
9
5
Should you document test failures in your test log?
No, only document successes
Yes, it shows you understand testing
Only if asked to
What does each test row in your test log need?
Just the test data
Only expected result
Number, description, data, expected, actual, screenshot
Just a screenshot
How many paragraphs should your evaluation typically have?
1 paragraph
2 paragraphs
3 paragraphs
5 paragraphs
What should the FIRST paragraph of your evaluation discuss?
Limitations
How structure minimises data duplication
Future improvements
Testing results
What should the THIRD paragraph of your evaluation include?
How requirements are met
Data duplication
Limitations and improvements
Table descriptions
Which phrase is useful for discussing data integrity?
'The database is complete'
'This ensures data integrity because...'
'The tables are linked'
'Data is stored correctly'
Being honest about failures in your evaluation will:
Lose you marks
Not affect your grade
Earn you marks by showing understanding
Confuse the examiner
How long is Part A of the exam?
2 hours
2.5 hours
3 hours
4 hours
How long is Part B of the exam?
1 hour
1.5 hours
2 hours
2.5 hours
How much time should you allocate to Activity 1 (Relationships)?
20 minutes
30 minutes
40 minutes
60 minutes
What should you do when time is running low?
Keep trying to finish building
Stop building and start documenting
Skip to the next activity
Ask for extra time
What does 'at least 5' translate to in query criteria?
>5
<5
>=5
=5
What does 'more than 10' translate to in query criteria?
>=10
>10
=10
<>10
How do you create a parameter query prompt?
Use a text box
[Enter value:]
Even if your query is wrong, what should you ALWAYS do?
Delete it
Leave it blank
Screenshot Design View AND Datasheet View
Only save the design
What is the 'Golden Rule' of the Pass First strategy?
'Perfect answers only'
'Something is better than nothing'
'Speed over accuracy'
'Skip difficult questions'
A blank response will earn you:
1 mark for attempting
Partial credit
Zero marks
Half marks
A wrong attempt that shows understanding can earn you:
Zero marks
Partial marks
Full marks
Negative marks
What is MORE valuable: a half-finished database with full documentation OR a complete database without evidence?
Complete database without evidence
Half-finished with full documentation
Neither has value
They are equal
Which students typically FAIL this exam?
Those who struggle with queries
Those who leave sections empty
Those who attempt everything
Those who document failures
