CTSS 2019 P2

[Turn over Name: _____________________________ Register Number: ______ Class: _______ Clementi Town Secondary School Preliminary Examination 2019 Secondary 4 Express Computing 7155/02 28 August 2019 2 hours 30 mins CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL CLEMENTI TOWN SECONDARY SCHOOL Additional Materials: Electronic version of MEMBERS’S_SAVING.XLSX date file Electronic version of SCORE.PY file Electronic version of BMI.PY file Data Resource Files Quick reference for Python sheet READ THESE INSTRUCTIONS FIRST 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. _______________________________________________________________________ This question paper consists of 7 printed pages, including this cover page. For Examiner’s Use 50

2 Clementi Town Secondary School Computing Secondary 4 Express Preliminary Examination 2019 Answer all the questions. Task 1 A bank uses spreadsheet software to record the amount and duration that members save in their fixed deposit account. The bank offers compounded interest to all its savers. You are required to finish setting up the spreadsheet to record the interest they will be getting. Open the file MEMBER’S_Savings. You will see the following data. Save the file as MEMBER’S_Savings _<your_name>_<class>_<index number>. 1 In cell B23 enter a formula to calculate the total amount of savings. [1] 2 In cell B24 enter a formula to count how many members there are. [1] 3 In cell B25 enter a formula to count the longest duration. [1] 4 Use an appropriate function to search for the Rate in the Interest Rates table and use it to complete the Rate column. [2]

Clementi Town Secondary School 3 Preliminary Examination 2019 Secondary 4 Express Computing [Turn over 5 Enter a formula to calculate the interest members will be earning and use it to complete the Interest Earned column. [3] 6 Use a conditional statement to identify those savers who are eligible for bonus. They will have to save more than $2000 and over a period more than THREE years. Put a YES in the Bonus Eligibility column. Otherwise, put NO in the Bonus Eligibility column. [2] Save and close your file. Task 2 begins on the next page.

4 Clementi Town Secondary School Computing Secondary 4 Express Preliminary Examination 2019 Task 2 The following program accepts scores for TEN students and prints out the lowest in score and the highest in score. The program should accept values from 0 to 100 marks. highest = 0 lowest = 1000 students = 10 for count in range(students): score = int(input("Enter a score for the student: ")) if score > highest: highest = score if score < lowest: lowest = score print ("The highest score is ", highest) print ("The lowest score is ", lowest) Open the file SCORE.py. Save the file as SCORE_<your name>_<class>_<index number> 7 Edit the program so that it: (a) Accepts score for only 15 students. [1] (b) Prints out the average score of the 15 students. [3] (c) Tests if the score is between 0 to 100 marks, and if not, asks the user for input again with a suitable prompt. [4] Save your program. 8 Save the file as VARSCORE_<your name>_<class>_<index number> Edit your program so that it works for any number of students. Save your program. Task 3 begin on the next page. [2]

Clementi Town Secondary School 5 Preliminary Examination 2019 Secondary 4 Express Computing [Turn over Task 3 In a nation-wide survey, the BMI (Body Mass Index) of all students are being measured. The formula for BMI is as follows: 𝐁𝐌𝐈=𝐌𝐚𝐬𝐬 (𝐢𝐧 𝐤𝐢𝐥𝐨𝐠𝐫𝐚𝐦𝐬)𝐇𝐞𝐢𝐠𝐡𝐭𝟐 (𝐢𝐧 𝐦𝐞𝐭𝐫𝐞𝐬) The classification of BMI is in the table below. Health Risk BMI (kg/m2) Risk of developing problems such as nutritional deficiency and osteoporosis. under 18.5 Low Risk (healthy range). 18.5 to under 23 Moderate risk of developing heart disease, high blood pressure, stroke and diabetes. 23 to 27.5 High risk of developing heart disease, high blood pressure, stroke and diabetes. over 27.5 Students with BMI under 18.5 or over 27.5 are classified as “at risk”. A program is used to calculate and store the values of “at risk” BMI. There are several syntax errors and logical errors in the program. risk = {} count = 0 bmi_total = 0 while counter <= 10: height = int(input("Please enter your height in meters: ")) weight = int(input("Please enter your weight in kg: ")) bmi = weight/height*height bmi_total += bmi if bmi > 18.5 or bmi < 27.5: print("You are at risk.") risk = risk + bmi counter += 1 bmi_average = bmi_total/counter print("Average BMI "+ bmi_average) print("The following students with these BMI are at risk.") for i in risk: print(i) Open the file BMI.py Save your program as BMI_<Your name>_<Class>_<Index Number> 9 Identify and correct the errors in the program so that it works correctly according to the rules above. Save your program. [10]

6 Clementi Town Secondary School Computing Secondary 4 Express Preliminary Examination 2019 Task 4 CT Generation is a handphone application used to deliver discounts to household bills. You are a member of the app design team responsible for the final step – calculate the discount entitlement of each family. To register, each household is to enter the year of birth for all its family members. The app will receive an input in the following format: Eg 1. 1965, 1970, 2004, 2007 Every household will be entitled to 5% for each member above 55 years old, and 1% for each member below 16 years old. Using the program CT_Generation(), the program should give the following output. Input Output 1965, 1970, 2004, 2007 There are 4 members. There is/are 0 members above 55 years old. There is/are 2 members below 16 years old. You are entitled to 2% discount. 1950, 1955, 1979. There are 3 members. There is/are 2 members above 55 years old. There is/are members below 16 years old. You are entitled to 10% discount. Table 1 Your program should be able to perform the following with necessary validation: (a) Enter data in the format a,b,c,d, e, … where a refers to the year of birth. (b) Only allow data entry of numbers for member in the household. (c) Find the total number of family members in each household. (d) Calculate and display the total discount entitlement. (e) Your output must look like the output in Table 1. 10 Write your program and test that it works. [8] Save your program as CT_Mart_<Your name>_<Class>_<Index Number>

Clementi Town Secondary School 7 Preliminary Examination 2019 Secondary 4 Express Computing