Scribd
Upload
568 views3 pages

Elective Ict Parcticals 2025 Shs 3 First Term

The document outlines the instructions for an End of First Semester Examination in Elective ICT Practicals for 2025. It includes tasks such as creating an HTML login page, designing a database schema, and analyzing student results using a spreadsheet. Each task has specific requirements and marks allocated, emphasizing practical skills in ICT applications.

Uploaded by

contactandrelatedsites
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
568 views3 pages

Elective Ict Parcticals 2025 Shs 3 First Term

The document outlines the instructions for an End of First Semester Examination in Elective ICT Practicals for 2025. It includes tasks such as creating an HTML login page, designing a database schema, and analyzing student results using a spreadsheet. Each task has specific requirements and marks allocated, emphasizing practical skills in ICT applications.

Uploaded by

contactandrelatedsites
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

NAME:....……………………………………………………………………..…. CLASS:…………..

END OF FIRST SEMESTER EXAMINATION - 2025


ELECTIVE ICT PRACTICALS – PAPER 3
INSTRUCTIONS
Answer all questions
Create a folder on the desktop and rename the folder using your full name and class. ( Eg.
AbdulmanaSherif_3TechA). Save all your works in this folder.
1. With the help of appropriate text editor, create HTML code to produce the log in page below:

a) Set the title of the page to your full name. The programme code must be properly indented.
b) The input field for the password should be encrypted when the user is entering
c) Save your document as “Loginpage”
[15 marks]
2. Using an appropriate database application create a schema and save as MOCK in your created folder on the
desktop.
TABLE ST_ID MATHS ENGLISH FRENCH
1.LEVEL
1 210097 66 54 46
2 210099 34 55 76
3 210077 88 75 66
2 210064 45 53 55
4 210022 89 53 43
(a) Create:
i) the structure for the table 1 using ST_ID as the primary key save as EXAMS.
ii) a form that will enable users to enter data into EXAMS and save as EFORM.
b) Use the form in 2(a)(ii) to enter data as shown in table 1.
c) create a query to sort the table EXAM by LEVEL and MATHS in ascending order and save as SRTEXAMS.
[15 Marks]

1
NAME:....……………………………………………………………………..…. CLASS:…………..

3. (a) Using a spreadsheet application, create a workbook with the following data formatted below:
WASSCE 2024 RESULTS ANALYSIS
SUBJECTS Total Student
INDEX NO NAME ENGLISH MATHS ICT Score Average
0021102001 Enyo Awuni 50 60 50
0021102008 Kumi Arthur 68 77 68
0021102045 Walker Din 65 80 74
0021102062 Cudjoe Kwaku 68 77 65
0021102090 Adis Ibrahim 80 70 68
0021102075 Yaa Mansah 69 75 55
SUBJECT TOTAL SCORE
(b) Use a function/formula to determine the:
(i) total score for each candidate
(ii) average score for each candidate
(iii) total score for each subject
(c) Format the average student score to two decimal places
(d) Insert your full name using the header tool
(e) Save the workbook as RESULTS in your folder on the desktop
[15 marks]
SCORESHHET (FOR TEACHERS’ USE ONLY)
HTML Basic Indenting Set Title Saving Encryption Finished SUB-TOTAL
Structure Product
3 2 1 2 2 5

Your Score

DATABASE Creating and Creating Table Creating Entering Creating query SUB-TOTAL
saving table and data forms and data with and naming
naming types naming form
Weight 3 2 2.5 2 2.5 3

Your score

SPREADSHEET Creating and Merging Typing Formatting calculations 2 decimal places SUB-TOTAL
saving cells text and header tool
i ii iii d e
Weight 1 2 2 2 2 2 2 1 1

Your score

TOTAL SCORE
2
NAME:....……………………………………………………………………..…. CLASS:…………..

You might also like