SS1 Data Processing Practical Examination
SS1 Data Processing Practical Examination
CATEGORY ONE
CATEGORY TWO
Details 1: ______________________ Details 4: ____________
CATEGORY THREE
DEPT
MOTTO: Education is the best legacy……….
INSTRUCTION
1|Page
Use Microsoft Word 2013 and above to produce the format and perform the
tasks above
APPLICATION
Header
(i) Use any header design of your choice, replace the SCHOOL in “SCHOOL MULTIPURPOSE COLLEGE” with
your full name in upper case using font size 16 and bold it
(ii) Replace the school address with your home address and asterisks in RC with your registration number.
(iii) Use the initial of your names (first name and surname), to create a logo at the top most left-hand side
using Word Art
(iv) Use digits between 2 and 8 to form an eight-digit numbers to replace the telephone number using 080 as
its prefix.
Footer
(v) Insert a page number in the footer area roman numerals
(vi) Inside the footer area change the Motto: Education is the best legacy: to any phrase of your choice and
vitalize it.
Body
1
(vii) Using a line shape, draw a horizontal line after the header with a weight shape outline of 1 points
2
(viii) Change "CATEGORY ONE " to general information" in upper case and bold it.
(ix) Replace Name 1, Name 2, Name 3 and Name4 with the father's name, Mother's name, Best teacher's
Name, Best Friend’s Name, respectively in upper case and bold. provide corresponding information.
(x) Key/type any date of birth in the space provided for date.
(xi) Replace "CATEGORY TWO" with "student details" in upper case and bold it.
(xii) Replace Detail 1, Detail 2…. Details 6 with the student's first name, student's surname, date of birth,
registration number, e-mail address and gender respectively in upper case. Key/type any corresponding
information for each of the details replaced.
(xiii) Using a line shape draw a horizontal line below CATEGORY TWO section with a weight shape outline of
1
1 points
2
(xiv) Replace "Category three" with " academic information" in uppercase and bold it.
(xv) Draw a table with four rows and four columns.
(xvi) Type in Serial No. in the first column, Department in the second column, subject in the third column and
grade in the last column each should be in upper case and bold it
(xvii) In the department column you are to type science and merge all the cell.
(xviii) You are to type any three subjects of your choice
(xix) Key/type either excellent, very good, good, pass or fail under the grade column.
(xx) Use Calibri font style throughout and export to PDF
2|Page
QUESTION 2 (MICROSOFT)
The data below shows the students Surname, First Name, Gender, Home Address and their overall Scores in a
federal school examination
a. Musa Zainab, Female, No. 23, Davis street, Lagos, score 158
b. Ajuwon Janet, score 195, No. 2 Araromi Street, Abeokuta, Female
c. Okoro Delight, No. 5, Lugbe Road, Abuja, Female, Score 145
d. Raji Oyisi, Female, score 171, No, 3, Odenigbo street Nsukka
e. Agomoh Daniel, Male, 40 Bosso Road Minna, score 152
f. Ajibade Ayomide, Male, No. 105, ECOWAS Road, Jos, score 163
g. Joseph Precious, Female, score 182, 4 Awujale street, Ijebu Ife
h. Ogunbawo Toluwani, No. 32, Novel street, Enugu, score 170, female
i. Akinboro Kamiye, female, No. 48, Dutse Road Kano, score 170,
j. Joseph Joshua, male, Awujale street, Ijebuife, score 179
3|Page