MN-3526 Spreadsheets and Databases for Business Analysis
Swansea University School of Management MN-3526 Spreadsheets and Databases for Business Analysis
The module provides an overview of the advanced use of spreadsheets and databases for business management and analysis. The use of spreadsheets and databases are key skills for business employers.
This booklet contains:
- an introduction to the module
- lecture and seminar locations
- details of recommended reading
- information on assessment and feedback, including the coursework
- an overview of the entire module
The full reading list for this module is available via Blackboard in the ‘Reading List’ folder.
The core textbook for the module is:
- Business Data Analysis u sing Excel. David Whigham. OUP.
- Access 2013 Bible. Michael Alexander and Dick Kusleika. Wiley.
A core textbook is only a starting point and provides introductory and background information only. Supplemental reading will be identified at each lecture. To achieve high marks in this module students will need to do the background and supplemental reading as well as conduct their own independent research for instance through the reading of academic journals, into the topics identified.
The assessment for the module is structured as follows:
- 2 x 50% individual assignments of 1500 words
Moderation of Marks Moderation is the process of assuring that assessments have been marked in an academically rigorous manner with reference to agreed marking criteria.
Moderation applies to all aspects of student assessment that contribute to the award or final classification of an award, including:
- formally assessed coursework
Where modules include more than one method of assessment (e.g. include continuous assessment and a formal written examination) all methods of assessment weighted 25% or more are subject to moderation.
It is accepted that undergraduate year 1 (CQFW level 4 ) does not contribute to the final award, but it is still subject to moderation in the School of Management. Failed work and work close to the borderline for toleration (30%) is given careful consideration.
The Schools’ adopted method of moderation is by sampling with the exception of final year projects, dissertations and independent directed learning which must be double marked. An explanation of each is listed below:
Moderation by Sampling
The second marker samples work already first marked, with feedback for students and marks attached, in order to check overall standards. The sample of work for second marking is drawn from each grade boundary, assessments marked as fails, borderlines, marks just below the lower boundary of a classNameand firsts.
Univers al Double BlindMarking
The first marker makes no notes of any kind on the work being marked and the second marker examines the dissertation/directed independent learning submission as it was submitted by the student. Both examiners record their marks and feedback separately and then compare marks and resolve differences to produce an agreed mark. The agreed mark and feedback from both markers may only then be released.
The University - wide policy on double marking is published in the Academic Guide:
Individual Coursework Assignment
1) Individual Coursework Assignment 1
This assignment is worth 50% of the overall module mark.
A Profit and Loss statement based on Sales Revenue and Costs provided. Your solution should be calculated in an Excel spreadsheet. You may use appropriate Excel functions (such as NPV) or program the calculations yourself. You should submit a Word processed report to show calculations and your own understandings of the calculations and relevant topics , by giving a detailed account of the methods you have used, the reasons you have chosen those particular methods, the meaning of any values calculated, and the conclusions you have drawn.
You must complete a Profit and Loss statement for a five - year period in which the Sales Revenue and Costs in the categories of Labour, Material and Overheads are listed in the following table (all quantities in thousands of pounds):
|Year 1||Year 2||Year 3||Year 4||Year 5|
There is also an initial plant cost in Year 0 of 1000 (=£1,000,000), which is equally spread over the five years, producing the same depreciation each year .
- You need to work out Total Costs, Trading Profit, Taxation and Net Profit for each of the five trading years. Use a taxation rate of 3 0%.
- Then calculate the Net Cash Flow from the Trading Pro fit, Depreciation and Taxations.
- From the Net Cash Flow you should calculate the Net Present Value (NPV), using a discount rate of 10%, and finally calculate the Internal Rate of Return (IRR).
- If the depreciation is computed using the double - declining balance method, with a salvage of 8 0 (=£ 8 0,000) by the end of Y ear 5 , calculate the corresponding NPV and IRR. Explain their differences from the answers in (c).
Key Marking criteria will include:
- Accuracy: Accuracy of the Excel calculations and the methods used
- Assignment Structure: clarity of structure and presentation
- Writing Quality : Readability and ability to convey key message(s) concisely and logically
- Insightfulness of Analysis: Interest and usefulness of findings, conclusions drawn
- Understanding: Demonstration of understanding of the key topics
- Evaluation : Evidence of independent thinking and critical awareness
- Overall Quality of Assignment
2) Individual Coursework Assignment 2
This assignment is worth 50% of the overall module mark.
You must design a database from a list of requirements based on the contents of lectures , producing an entity - relationship diagram , a determinancy diagram and a relational schema, with a detailed account of how the requirements have been translated into the diagrams. These should be submitted in a Word file.
Design a database system to maintain data associated with a company. The text below has been produced fro m a requirements elicitation exercise.
- The company has some factories for production, as well as one sales office.
- Each factory has several production departments, and the sales office includes a number of subdivisions.
- In each production department, a manager oversees its overall operation, as well as all workers working in the production department.
- Production departments produce both product parts and products .
- Each product is comprised of a number of product parts, and each product part could be used to make up multiple products.
- Both products and product parts are stored in the warehouses owned by each factory .
- Each product is only produced by one factory and sold by one subdivision of the sales office
- Produce an entity - relationship diagram which represents the domain of the company , together with the detailed explanations and justifications of each entity, relationship, cardinality, and participation constraint in the diagrams. Note that some attributes should be created and assigned to the entities in the domain.
- Produce a determinancy diagram to document the dependencies between data - items, together with clear and reasonable explanation s and justifications.
- Accommodate both the entity - relationship diagram and the determinancy diagram produced to a relational schema expressed in the bracketing notation.