Group Planning Task (40%)Each GROUP must write a Code Plan for Spreadsheet Task

Group Planning Task (40%)Each GROUP must write a Code Plan for Spreadsheet Task 2. One member per group should submit this file at the designated time above. The code plan will be marked by your tutor, with feedback offered after class over email, Marking is based on the code plan’s; Structure, Algorithmic Thinking, Breakdown of Task, Language Used and Robustness of Solution.Individual Spreadsheet Task 1 (30%) In this task you are required to write a modified dot product FUNCTION which will be called within a pre-existing matrix multiplication function. The modified dot product function must for the following conditions: – Convert all the numbers in the second matrix to positive (absolute) values. – Replace any number in the first matrix that is greater than 5 with 5 – Replace any number in the second matrix that is over 6 with 4 – If the final dot product result is greater than 20, double it The matrix multiplication function which calls your modified dot product is supplied below: This code above will also be pre-written into your spreadsheet file to save you time.
Requirements: 1111111   |   .doc file

Leave a comment

Your email address will not be published.