BVSS 2019 P2

2 Task 1 Anna is considering opening a cafe. To help in her decision-making process, she uses a spreadsheet to plan out the expenditure and loan components. Complete the spreadsheet according to the following instructions. Open the file CAFE_STARTUP.xlsx. Save the file as MYCAFE_<your name>_<centre number>_<index number>.xlsx. 1 Change the format of cells B6:C11 to currency with two decimal places. [1] 2 In cell C12, enter a formula to count the number of items which contribute towards the initial expenditure. [1] 3 In cell B17, enter a formula to search for the Interest Rate (per annum) in the Interest Rates Table. [1]

3 4 Let us assume that Anna would like to loan $20000 to be repaid over 12 months. In cell B18, enter a formula to calculate the monthly instalment. Give your answer as a positive value. [1] 5 In cell B19, enter a formula to calculate the total repayment amount at the end of 12 months. [1] 6 In cell B22, enter a formula to calculate the principal payment for the first month and use it to complete the Principal Payment column. Give your answer as a positive value. [2] 7 In cell C22, enter a formula to calculate the interest payment for the first month and use it to complete the Interest Payment column. Give your answer as a positive value. [1] 8 In cell D22, enter a formula to calculate the remaining principal after payment is made for the first month and use it to complete the Remaining Principal column. [1] 9 In cell E22, enter a conditional statement to determine if the interest payment exceeds 2% of the monthly instalment in the first month. Use Y for Yes and N for No. Complete the Is Interest > 2%? column. [1]

4 Task 2 For over 90 years, The Walt Disney Studios has brought quality movies, music and stage plays to consumers throughout the world. Three well-known Disney movies are Aladdin, Bambi and Cinderella. Five students were tasked to vote for their favourite movie among the three. The following program prompts each student to enter his/her choice and stores the vote counts in an array. After all the students have cast their votes, the program returns the title of the most popular movie and number of votes it received. Should there be a tie in the number of votes for the most popular movie, the title with the lowest array index is returned. Open the file MOVIE_VOTING.py. Save the file as MYMOVIE_<your name>_<centre number>_<index number>.py. 10 Edit the program such that it: (a) Accepts entries from ten students. You may assume that only positive whole numbers are entered. [1] (b) Validates entries. When an invalid entry is entered, the program should continuously prompt the student to enter a valid entry with an error message. The program proceeds only after a valid entry is entered. [2] (c) Prints the message “Vote accepted” when a valid entry is entered. [1] (d) Additionally, returns the title of the least po