Business scenario
LPC ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief Deadline for Submission: Week 9 Submit this coursework through the Student Portal with a Turn-it-in Report Word Limit: 1500 (Plus or minus 10%) Learning outcomes assessed: Demonstrate the fundamentals of operating a computer to store, retrieve, analyse and present data; Describe ways in which information technology can contribute to increased productivity and enhance the quality of management; Describe the scope of hardware and software currently in use and the technological advances taking place. This coursework is worth 100% of the total marks for this module. ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 1 of 14 Coursework Instructions Please read carefully • Carefully read the module handbook, the marking criteria and the grade descriptors. Academic Misconduct You are responsible for ensuring you understand the policy and regulations about academic misconduct. You must: • Complete this work alone except where required or allowed by this assignment briefing paper and ensure it has not been written or composed by or with the assistance of any other person. • Make sure all sentences or passages quoted from other people’s work in this assignment (with or without trivial changes) are in quotation marks, and are specifically acknowledged by reference to the author, work and page. ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 2 of 14 Blank ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 3 of 14 Assignment Tasks Your assignment consists of two tasks (worth 100% of the total marks for the assignment). Business Scenario You have just joined X fashion, a small retail outlet with three stores in three shopping centres around London. Your first task is to calculate the which months the stores are in profit, and which they are in loss. Your second task is to show your manager how Microsoft Office can help with productivity and enhancement of management and discuss future trends in technology in business. Please follow the instructions below for both tasks 1 and 2 below and prepare a report to show your results and findings. Task 1:LO1- (30% of total marks) Use the figures from the table below in your calculations: ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 4 of 14 Create a spreadsheet to store and analyse your date Name the spreadsheet "2017" Add the title "X Fashion 2017" at the top of your worksheet. Enter the data provided above into your worksheet. Format the worksheet to ensure that you use an appropriate font size and colour, and choose an appropriate width of column. Insert the date at the top of the spreadsheet using the TODAY function. Write a formula to calculate the total takings for each of month. Calculate total for each month after subtracting the VAT (Divide the total by 120%) Format all currency as £, to two decimal places, e.g. £2.00. Using an IF function, for each club, output the words "Profit" where the total paid fees to the taxi company is greater than or equal to £30,000 or “Loss” otherwise. Generate a bar graph or pie chart to show the total takings earned per month against the month (total takings vs the month). How to submit your spreadsheet: Take screenshots of your spreadsheet in data view AND formula view and place them in the report that you will write for Task 2. You MUST capture and save BOTH views. Example of data view Example of formula view Task 2: Report (LO2&3; 70% of total marks) You have been asked by the owner of the taxi firm to write a report, to demonstrate the benefits of implementing technology to increase productivity and enhance management. To do this, prepare a report by completing the following: 1. Write a brief introduction outlining the purpose of the report (100-150 words). ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 5 of 14 2. Outline the current monthly figures for the drivers using your findings from task 1 and note anything interesting that the figures show. You must place your saved screenshots of your spreadsheet from task 1 to demonstrate that you have completed all required steps. You MUST include BOTH data view and formula view screenshots (150-200 words). 3. Explain how Microsoft Office can help to increase productivity for a business (500 words). 4. Describe three technological advancements that the business should be aware of to ensure that it does not get left behind. These may be specific to the retail industry, or to business in general. Discuss both the hardware and the software (500 words). 11. Write a conclusion summarising the main points of your report (150-200 words). Structure your report using the appropriate word processing tools: Suggested report structure Cover Page Assignment title, module code, student name, student number and submission date. Table of Contents A list of headings and page numbers. 1.0 Introduction (about 10% of word count) What question/topics are you going to explore? Why? Explain the steps you will take to address the question. (Discussion about 80% of word count) 2.0 Presentation & Explanation of Business Data Place your screenshots of your Excel spreadsheet here. Label them. Using the data from your screenshots, discuss the financial situation of the business. You could discuss which seasons or months seem to be more profitable and whether the business is making money (or not) overall. 3.0 The Benefits of Microsoft Office to Business Productivity Define Microsoft Office. Discuss some ways that the software may allow a business to do things faster and with less human errors. You may provide subheadings here if you want to discuss different software, for example: 3.1 Microsoft Word 3.2 Microsoft Excel 3.3 Microsoft PowerPoint ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 6 of 14 4.0 Technological Advancements for Business Discuss three technological advancements that can increase productivity in the business world. You can start with a brief statement about how businesses increasingly use technology. You could then use some subheadings e.g. 4.1 Technology Advancement 1 Describe the technology and discuss how it can help the business. 4.2 Technology Advancement 2 Describe the technology and discuss how it can help the business. 4.3 Technology Advancement 3 Describe the technology and discuss how it can help the business. 5.0 Conclusion (about 10% of word count) Do not introduce any NEW material here. Restate what you consider the main points to be and make one or two key recommendations. 6.0 Reference List An alphabetically ordered list of the references cited in your report, in Harvard style. 7.0 Appendix Include any supporting information that you did not think appropriate to include in the main body of the text. You must label each piece of information that you provide and refer to it in the main body of your text e.g. see appendix 2 for further information. INTRODUCTION TO COMPUTING marking criteria and SELF- ASSESSMENT form Strength Adequate Needs Improvement Knowledge and Understanding 50% Includes all required factual content required by the assignment brief, accurately summarised. All content is relevant. Demonstrates a clear understanding of: The functions of Excel to store, retrieve, analyse and present data. Ways in which Microsoft Office can contribute to increased productivity and enhance the quality of management. The technological advances taking place and their benefits to the business world. Demonstrates evidence of independent reading and research, appropriate to this ICSK3005 Introduction to Computer Skills Summer 2018 Resit Coursework Brief GSM LONDON Page 7 of 14 level. Demonstrates effective use of class materials to develop knowledge and understanding of key concepts and theories. Intellectual and Cognitive Skills 25% Material is clearly and logically structured