NASS 2019 P2 Solution

Marking Scheme 1 In cell C3 enter an appropriate formula to extract the year of purchase of the car from the purchase date given, and use it to complete the Year of Purchase column. =RIGHT(B3,4) - 1 mark 2 Use an appropriate function to search for the Annual Interest Rate (%) and use it to complete the Annual Interest Rate (%) column. =VLOOKUP(E3,$A$14:$B$17,2,FALSE) - 1 mark - 1 mark for $ sign and correct column values 3 In cell H3 enter an appropriate formula to calculate the monthly principal payment of the car, and use it to complete the Monthly Principal Payment ($) column. =PPMT(G3/100/12,F3,10*12,D3) - 1 mark - 1 mark for correct column values 4 In cell I3 enter an appropriate formula to calculate the monthly interest payment of the car, and use it to complete the Monthly Interest Payment ($) column. =IPMT(G3/100/12,F3,E3*12,D3) - 1 mark - 1 mark for correct column values 5 In cell J3 enter an appropriate formula to calculate the total monthly payment of the car, and use it to complete the Total Monthly Payment ($) column. =H3+I3 - 1 mark 6 The company uses a credit status system to classify its customer. There are 3 groups: A: total monthly payment is less than $1000 B: total monthly payment is less than $2000 C: total monthly payment is $2000 or more Use a conditional statement in cell K3 to indicate if the customer belongs to group A, B or C, and use it to complete the Credit Status column. =IF(J3>-1000,"A",IF(J3>-2000,"B","C")) - 1 mark for outer condition, 1 mark for inner condition

7 word = input ("Enter a word: ") longest_word = word [Q7(b): M1] shortest_word = word num_words = 9 [Q7(a): A1] palindrome = 0 [Q7(c): M1] for count in range (num_words): word = input ("Enter a word: ") if len (longest_word) < len(word): longest_word = word [Q7(b): M1] if len(shortest_word) > len(word): shortest_word = word if word == word [::-1]: [Q7(c): M1] palindrome += 1 [Q7(c): M1] print ("Longest word is " + longest_word) [Q7(b): A1] print ("Shortest word is " + shortest_word) print ("There are " + str(palindrome) + " palindrome word(s)") [Q7(c): A1] 8 word = input ("Enter a word: ") longest_word = word shortest_word = word num_words = int(input(“Enter the number of words to input”)) [Q8: 2 marks] palindrome = 0 for count in range (num_words): word = input ("Enter a word: ") if len (longest_word) < len(word): longest_word = word if len(shortest_word) > len(word): shortest_word = word if word == word [::-1]: palindrome += 1