PRIDE INTERNATIONAL SCHOOL MYANMAR
(Academic Year 2022-2023)
INFORMATION AND COMMUNICATION TECHNOLOGY March 2023
Data Manipulation Continuous Assessment
50 minutes
You will need: source files (listed on page 2)
Total mark: 25
You are supplied with following files:
[Link]
[Link]
[Link]
You work for Tawara University and are going to carry out some clerical
tasks.
Task 1 – Evidence Document
Open the file [Link]
• Make sure your name, Centre number and candidate number will appear
on every page of
your Evidence Document.
• Save this as a word-processed document in your work area with the
filename EVIDENCE followed by your candidate number, for example,
EVIDENCE9999.
You will need your Evidence Document during the examination to enter
answers to questions and to place your screenshots in when required.
Task 2 – Database
1. You are now going to prepare some reports for the university.
Examine the data in the files [Link] and [Link]
• Using a suitable database package, import the file [Link]
• Use these field names and data types:
• Set the Course_Code field as the primary key.
• Save the data.
EVIDENCE 1
Take screenshot evidence showing the field names and data types used in
the table. Insert this screenshot into your Evidence Document.
[3]
2. Restrict the data entry in the Length field to accept only numbers of 6 or less.
EVIDENCE 2
Take screenshot evidence showing how you have limited data entry in the
Length field. Insert this screenshot into your Evidence Document
[2]
3. Add this record:
Check your data entry for errors. Save the data. [1]
4. Import the file [Link] as a new table in your database and set the
Faculty_Code field as the primary key.
• Create a relationship between the Faculty_Code field in the faculty table
and the Faculty_Code field in the degree table.
EVIDENCE 3
Take screenshot evidence showing the relationship between the tables.
Insert this screenshot into your Evidence Document. [1]
5. Using fields from both tables, produce a report which:
• selects only those records where the
– Qual_Code is PHD
– Length is 4 or more
• shows only the fields Subject, Length, Head_of_Faculty and Campus
in this order with data and labels displayed in full sorts the Length in
descending order then ascending order of Subject has a page
orientation of portrait
• fits on a single page includes the heading Extended Doctoral
Options at the top of the page
• calculates the total number of subjects in this selection and positions
this below the Subject column has a label to the left of this number
Total subjects
• has your name, Centre number and candidate number on the report.
• Save and print your report.
PRINTOUT 1
Make sure that you have entered your name, Centre number and
candidate
number on your report.
EVIDENCE 4
Place in your Evidence Document screenshot(s) showing the formula used
to
calculate the number of subjects
[9]
6. Using fields from both tables produce a report which:
• contains a new field called Total_Enrolled which is calculated at run-time
and displayed as integer. This field will calculate the total number of students
enrolled by adding Male plus Female.
• selects only those records where the
– Subject contains the word Science
– Qual_Code is BS or BA
– Full_Time is Yes
o shows only the fields Course_Code, Qual_Code, Subject,
Faculty, Male, Female, Full_Time and Total_Enrolled in
this order with data and labels displayed in full
o sorts the data into ascending order of Qual_Code
o has a page orientation of landscape
o fits on a single page wide
o includes the report title Selected Tawara Degrees at the top
of the page
• has your name, Centre number and candidate number at the top right
of the report.
• does not display a page number when printed.
• Save and print your report
PRINTOUT 2
Make sure that you have entered your name, Centre number and candidate
number on your report.
[9]
Total: [25] marks
………………………………………………… ….. End of Paper…………………………………………………………………