Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
Weighting: 20%
Module Title: Business Analytics Programming
|
Days Late: |
Mark: |
| 1 |
(final agreed mark) * 0.9 |
| 2 |
(final agreed mark) * 0.8 |
| 3 |
(final agreed mark) * 0.7 |
| 4 |
(final agreed mark) * 0.6 |
| 5 |
(final agreed mark) * 0.5 |
|
More than 5 |
0 |
This assessment relates to the following module learning outcomes:
|
A. Knowledge and Understanding |
A1. The software development techniques that constitute good programming practice; A2. Object-oriented programming; A3. The importance of correctness, usability and readability in programming. |
|
B. Subject Specific Intellectual and Research Skills |
B1. Design and implement an algorithm to conduct technical calculations, manipulate data and create graphical user interfaces; B2. Be able to handle files using a programming language and integration with other packages such as Excel; B3. Use techniques for debugging an algorithm. |
|
C. Transferable and Generic Skills |
C3. Use your analytic skills in problem solving; C4. Communicate effectively, in both oral and/or written form |
Terry is the Chief Financial Officer (CFO) of a private fund - SW Asset Management. He is going to prepare an investment plan to manage the asset in the next five years. In this plan, Terry needs to take factors such as the potential pandemic and economic recession into consideration. Assuming you are Terry’s Executive assistant, you are tasked to build a model for the allocation of firms’ capital.
SW Asset Management has £10 Billion cash available, and Terry has planned three investment classes:
For each investment class, Terry has provided a sub-sector allocation plan as detailed below:SEMESTER 1 2024/25
|
Sub-sector |
Investment Class 1 |
Investment Class 2 |
Investment Class 3 |
|
Artificial Intelligences (AI) and Information Technology (IT)
|
20% |
20% |
|
|
Banks |
|
60% |
|
|
Energy |
50% |
20% |
25% |
|
Global Supply Chain |
|
|
25% |
|
Real Estate |
30% |
|
|
|
Smart Automotive |
|
|
50% |
|
Sub-sector |
Annual return minimum |
Annual return maximum |
|
Artificial Intelligences (AI) and
Information Technology (IT)
|
3% |
8% |
|
Banks |
2% |
5% |
|
Energy |
0% |
8% |
|
Global Supply Chain |
6% |
10% |
|
Real Estate |
5% |
9% |
|
Smart Automotive |
10% |
15% |
Your routine must:
- allow Terry to enter the expected annual return for each sub-sector he would like to invest in (e.g. the worst-case scenario and best-case scenario).
- allow Terry to enter the investment duration (e.g. 1 year, 3 years, 5 years, etc.)
- ensure input data are valid (e.g. ensure that some numbers, such as percentages, are non-negative).
- display appropriate error messages (e.g. through MsgBox).
- calculate and then display the results (e.g. through MsgBox).
Notes: What type of input information should the program include (e.g., investment amount, expected annual return, best/worst annual return rate for each sub-sector)?
Answer: No specific kind of information is required. You need to ensure that your program has a clear storyline. Based on this storyline, choose the related variables and enable the user to input their information. This input must be used in the latter stage of calculation and display.
Once you have successfully completed the basic routine as specified above, work on extending its flexibility and range of usage. Extensions could include, but not limited to, the following considerations:
Submit to blackboard:
SEMESTER 1 2024/25
Please name your files using the final eight digits of your student ID number prefixed by VBA2, e.g. VBA2_12345678.xlsm and VBA2_12345678.pdf. Do not include your name.
Collaboration, plagiarism and cheating
Marking Criteria:
You are reminded that if the statement Option Explicit is not included at the top of the source code in every non-empty module, class and UserForm in your project, you will lose credit for the assignment.
Word Limit: +/-10% either side of the word count (see above) is deemed to be acceptable. Any text that exceeds an additional 10% will not attract any marks. The relevant word count includes items such as cover page, executive summary, title page, table of contents, tables, figures, in-text citations and section headings, if used.
The relevant word count excludes your list of references and any appendices at the end of your coursework submission.
Title/Cover Page: You must include a title/ cover page that includes: your Student ID, Module Code, Assignment Title, Word Count. This assignment will be marked anonymously, please ensure that your name does not appear on any part of your assignment.
Submission Deadline: Please note that the submission deadline for Southampton Business School is 16.00 for ALL assessments.
Turnitin Submission: The assignment MUST be submitted electronically via Turnitin, which is accessed via the individual module on Blackboard. Further guidance on submitting assignments is available on the Blackboard support pages.
It is important that you allow enough time prior to the submission deadline to ensure your submission is processed on time as all late submissions are subject to a late penalty. We would recommend you allow 30 minutes to upload your work and check the submission has been processed and is correct. Please make sure you submit to the correct assignment link.
Email submission receipts are not currently supported with Turnitin Feedback Studio LTI integrations, however following a submission, students are presented with a banner within their assignment dashboard that provides a link to download a submission receipt. You can also access your assignment dashboard at any time to download a copy of the submission receipt using the receipt icon. It is vital that you make a note of your
Submission ID (Digital Receipt Number). This is a unique receipt number for your submission, and is proof of successful submission. You may be required to provide this number at a later date. We recommend that you take a screenshot of this page, or note the number down on a piece of paper.
It is your responsibility to ensure that the version received by the deadline is the final version, resubmissions after the deadline will not be accepted in any circumstances.
Late Penalties: Further information on penalties for work submitted after the deadline can be found here.
Special Considerations: If you believe that illness or other circumstances have adversely affected your academic performance, information regarding the regulations governing Special Considerations can be accessed via the Governance and Policies landing pages: Regulations Governing Special Considerations (including Deadline Extension Requests) for all Taught Programmes and Taught Assessed Components of Research
|
Breach |
How to avoid |
|
Plagiarism – using the work, words, or ideas of another without proper acknowledgement. This includes citing work that you haven’t read.
|
- Always cite your sources.
- Only cite what you have read and used.
- “Direct quotes must be in quotation marks” with a page number if applicable.
- If you read about the work of another in a source, say ‘cited in’ and cite where you read it (see here for more info).
|
|
Collusion – Collaborating with others in an unauthorized way to produce academic work meant to be done independently.
|
- Unless permitted in a group assignment, don’t work with/alongside others.
- Don’t share your work with others.
- Ensure you are clear on where the line is. If in doubt, don’t do it.
|
|
External authorship – Obtaining or attempting to obtain unauthorized input from another person or service for academic work, e.g GenAI
|
- Ensure you are clear on if you are permitted to use GenAI.
- Ensure your work is always your own.
- Never send your work to others or upload it to a website.
- Keep records of your work including notes, drafts, and reading.
|
Penalties for the above include mark reduction, resubmitting for a capped mark, or a ‘0’ for the module.
If you are in any doubt, please ask.
Further learning and advice can be found in the Academic Conduct & Responsibility Toolkit, and the Library Website.
Feedback: Southampton Business School is committed to providing feedback within 4 weeks (University working days). Once the marks are released and you have received your feedback, you can meet with your Module Leader / Module Lecturer / Personal Academic Tutor to discuss the feedback within 4 weeks from the release of marks date. Any additional arrangements for feedback are listed in the Module Profile.
Student Support: Study skills and language support for Southampton Business School students is available at: http://www.sbsaob.soton.ac.uk/study-skills-and-language-support/.