CO1098–Information Management
Practical 8 will take place over two sessions, and forms the final part – worth 40% – of the continuous assessment that makes up the mark for CO1098. Again, this should be an individual piece of work. The document file produced in this exercise must be handed in via Blackboard by Friday, 9th December, 8pm. Failure to do so on time will result in marks being deduced in accordance with University policy (Study Guide for information.)
You can obtain 100 marks in total: 20 marks each for Parts 1, 3 and 4, and 40 marks for Part 2.
Submission
Please submit your finished Excel 2013 document via Blackboard as usual. In addition, as per departmental policy for assessed coursework, you will need to submit the Cover Sheet for Coursework. Please download the file coversheet_practical8.doc, fill in the data required (we will accept your name typed in the Signature line as your electronic signature) and submit it on Blackboard with your assignment.
Premise
For this practical you will design a car loan repayment calculator, and use it to explore a few scenarios.
First, we will collect the different parameters, and calculate payments, then build a payment table and calculate interest. We will then look at different scenarios using a data table. The whole schedule will be the basis of an Excel Dashboard, whereby all the parameters can be inputted in one worksheet, and where the results will also be presented together with three charts illustrating various scenarios.
Start with a blank Excel 2013 spreadsheet.
CO1098 – Information Management Practical 8
2 | P a g e
1. Parameter input and repayment calculations
In order to provide the customer with the necessary information for what they can afford we have to collect some information. The following parameters have to be taken into consideration:
Create an area within your worksheet (name that worksheet ‘Parameters’) that can serve as an inputting table.
Format the cells in column C appropriately
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
