NASS 2020 P2

Name: ............................................................................. Register no: .............. Class: ................ NGEE ANN SECONDARY SCHOOL O PRELIMINARY EXAMINATION COMPUTING 7155/02 Paper 2 (Lab-based) 28 August 2020 2 hr 30 min Additional materials: Electronic version of APPLICATION.xlsx file Electronic version of BLOODPRESSURE.py file Electronic version of HASHTAG.py file Insert Quick Reference Glossary Instructions to Candidates Write your name, register number and class at the top of this page. Answer all questions. All tasks must be done in the computer laboratory. You are not allowed to bring in or take out any pieces of work or materials on paper or electronic media or in any other form. Programs are to be written in Python. Save your work using the file name given in the question as and when necessary. The number of marks is given in brackets [ ] at the end of each question or part question. The total number of marks for this paper is 50. Checked by student: _____________________ Date: _________ This document consists of 9 printed pages and 1 blank page. For Examiner’s Use Marks /50

2 NAS/2020/PRELIM/4E/COMPUTING(7155) Task 1 A government agency uses spreadsheet software to calculate the one-time cash payout to help applicants residing in the country tide through the Covid-19 pandemic. The spreadsheet provides the application reference number, monthly family income and number of family members in the applicant’s household. Each Application Reference Number in Column A comprises the following: 1. The first alphabet which represents the citizenship status of the applicant as follows: • “C” represents “Citizen” • “P” represents “Permanent Resident” • “F” represents “Foreigner” 2. The next 4 digits of the Application Reference Number represents the year that the applicant was born. 3. The last 3 digits are random. You are required to finish setting up the spreadsheet to provide useful information and calculate the payout to each applicant.

3 NAS/2020/PRELIM/4E/COMPUTING(7155) Open the file APPLICATION.xlsx. You will see the following data. Save the file as PAYOUT_<your name>_<centre number>_<index number>.xlsx 1 Enter a formula to calculate the current age of the applicants in the Age column at the time of application in the year 2020. [2] 2 Use a conditional statement to identify the citizenship status (Citizen, Permanent Resident or Foreigner) in the Citizenship column. [2] 3 The monthly per capita income is the monthly family income divided by the number of family members in the applicant’s household. Enter a formula to calculate each applicant’s Monthly Per Capita Income, rounded down to the nearest dollar($). [2] 4 All applicants except Foreigner citizenship status will receive the cash payout according to their Monthly Per Capita Income. Use a conditional s