Candidate Na
THE SCHRAM ACADEMY
CYCLE TEST - I
Candidate Name : Avehi Vivek Grade: IGCSE/0417
Date: 6 / 7 / 2021
Information Communication Technology MAX MARKS: 40
1 hr
READ THESE INSTRUCTIONS FIRST
Write your name on all the work you hand in. Write in dark blue or black pen.
Do not use staples, paper clips, glue or correction fluid.
Answer all questions.
At the end of the examination, fasten all your work securely together.
The number of marks is given in brackets [ ] at the end of each question or
part question.
TOTAL MARKS:
This question paper contains 4 pages
0417/ICT/CT 1 / JULY /202 1 1
SECTION A - Theory
1. Should the internet be policed? Discuss the advantages and disadvantages.
Advantages: -Prevents illegal material from being posted
___________________________________________________________________________
-Helps children from gaining access to Undesirable content
___________________________________________________________________________
Disadvantages: - Police force would need to be set up which would cost a lot of money
___________________________________________________________________________
-Sometimes important website would be labelled illegal
___________________________________________________________________________
___________________________________________________________________________ [4]
2 What is meant by software piracy?
It is the illegal copying, distributing and sharing of software
___________________________________________________________________________
___________________________________________________________________________ [2]
3. What are the rules to be followed when software is supplied on CD or DVD?
____________________________________________________________________________
___________________________________________________________________________
___________________________________________________________________________ [4]
SECTION –B Practical
1. Using a suitable database package, import the file J216ADSPORTS.CSV
2. Use these field names and data types:
3. Set the Course_Code field as a Primary key
2
4. Save the data.
5. Take screenshot evidence showing the field names and data types used in the table. Place this [6]
screenshot into your Evidence Document.
6. Create a data entry form which will:
include all fields from the Adsports table
use a radio button in the Location field to accept only:
• Cornwall
• Ireland
• Scotland
• Wales France
7. Place into your Evidence Document screenshot(s) to show the radio button option and how you [5]
have limited data entry to these five values only.
8. Add the following record to the Adsports table using your form:
9. Check your data entry for errors. Save the data.
10 Place in your Evidence Document screenshot(s) showing this data in your form. [2]
11. Using a suitable database package, import the file J225DATA.CSV Use the following field
names and data types:
12 Place a screenshot showing the field names and data types used into your Evidence Document. [5]
3
13 Insert the following two records:
[4]
Check your data entry for errors.
14 Save the data.
15 Create a query design to shows only the fields Chart_position, Game, Publisher, Platform,
Genre, North_America, Global and Market_share where the Chart_position is 300 or less
16 Place screenshot of the query design in the evidence document. [4]
17 Create a query design to shows all the records where Game contains the word Mario
18 Place screenshot of the query design in the evidence document. [4]
