Core ICT - End of Second Semester Practical Examination for TASHS Form 2 Students

Students not having e-mail address must create one at Gmail.com

TASHS Form two (2) students are requested to follow the steps below to access their End of Second Semester Core ICT Practical Examination questions and answer both Practical 1 and 2 respectively.

Note:   It it advisable to use Google Chrome or Edge (i.e. Internet Explorer) web browser to download the project work.

• Kindly click on [Assignment] icon below to open the Excel workbook entitle "ICT Practical Exams" in the web browser

• At the top-right corner of the web browser, click on Download button 
• Press Ctrl + W once to close the Excel application tab in the Web browser

Note:    The downloaded file is kept in Downloads folder on your computer

• Open the Excel file from Downloads Folder on your Computer

Project Work 1

Follow the instructions below to complete your Project Work 1

1. Open the Excel file that shows uncompleted Continuous Assessment form
2. Press F12 function key to display the Save As dialogue Box
3. Change the name of the Workbook to [Your Full Name and Class] Example: Adzido Joshua 2D 1
4. Save the Workbook on the desktop or on a flash drive
5. Rename Sheet1 as Assessment
6. Determine the Sub Totals for each student
7. Find the Total Class Score mark for all students by adding all the Sub Total marks
8. Find 30% against the Total Class Score marks for every student
9. Find 70% against the End of Term Exam marks for each student
10. Determine the Overall Total marks obtained by each student by adding the Total Class Score and the End of Term Exams marks respectively
11. Use the table below to determine the Grade and Remark respectively for each student using VLookup or HLookup function: 

Note: The Grading System should be done in Sheet2

    12.  Rename Sheet2 as GradeList

Project Work 2

1. Open to Sheet3 of the workbook and draw an interval table of and perform calculations using the quadratic equation 
2. Rename Sheet3 as Equation
3. Plot a graph into Sheet4 of the equation above using Scatter with Smooth Lines and Markers graph
4. Change the Layout of the Graph to Layout 10 and change all gridlines to colour Green
5. Rename Sheet4 as 
   
6. After you are done, press Ctrl+S to and update the workbook
7. Press Ctrl+W to close the workbook
8. Click on [Submit] icon below to display Google submission form

Note: If you cannot submit your Project Work through the above steps, kindly send the file to e-mail: jadzido@gmail.com

Closing Date: 26th November 2021.

For technical support, WhatsApp or call: 024 311 5791 or 024 609 4456