ICSK3005 Introduction to Computer Skills Spring 2017 Coursework Brief Handout: [ 02:00 pm, 02/03/2017] Deadline for Submission: [02:00 pm, 27/04/2017] Submit this coursework through the Student Portal Word Limit: 1,500 words (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.Module Code Module Title Spring 2017 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.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 2 of 14 BlankModule Code Module Title Spring 2017 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 got a job at Tesco Mini, with 10 employees. Your manager asked you to calculate the profit and loss for the previous 12 months, prepare a report to show your results and findings. Task 1: Data (LO1; 30% of total marks) You have been asked to calculate the profit and loss for the previous 12 months. Use the figures from the table below in your calculations: Create a spreadsheet to store and analyse your data. 1. Name the spreadsheet "Profit/Loss". 2. Add the title" "Revenue for year 2016" at the top of your worksheet. 3. Format the title - consider font style, font size, text colour, cell background colour, text alignment or merged cells. 4. Insert today's date at the top of the spreadsheet, using the DATE function. 5. Write a formula to calculate the profit/month after VAT of 17%. 6. Draw a graph, chart or pie to show the profit per month (month vs. profit). 7. Format all currency as £, to two decimal places, e.g. £2.00. 8. Using an IF function, output the words "Profit" where the total revenue after VAT is greater than or equal to £ 25000, or "Loss" otherwise. 9. Create table/columns showing the number of profit and loss over the year.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 4 of 14 How to submit your spreadsheet: Take screenshots of your spreadsheet in data view AND formula view and save them in a word processed document. You MUST capture and save BOTH views. Example of data view Example of formula view Task 2: Report (LO2&3; 70% of total marks) A number of Tesco staff in your store are extremely technophobic. They are reluctant to make full use of the software available to them and sceptical about the introduction of new technologies into the business. You have been asked by the managing director to prepare a report, with the aim of demonstrating to Tesco staff that information technology advances, such as self-checkout systems, increases their productivity and enhances the quality of Tesco's management. To do this, prepare a report for your team on the following. 1. Write a brief introduction outlining the background and purpose of the report (100-150 words). 2. Explain your findings from Task 1. You must place your saved screenshots from task 1 of your spreadsheet to demonstrate that you have completed all points in Task 1. You MUST place BOTH data view and formula view (150-200 words). 3. Explain how Microsoft Office could help Tesco to increase its business productivity (500 words). 4. Describe three technological advances in terms of software and hardware that are taking place at Tesco (500 words).Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 5 of 14 5. Your conclusion should summarise the main points and encourage your team to value how information technology supports them in their job and how it can be used to increase profits (150-200 words). Structure your report using the appropriate word processing tools: • Cover page • Table of contents, and headings • Reference List • Appendix 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. 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. Analysis and Evaluation (about 80% of word count) Separate your analysis into topics – create a subheading per topic. Create a chain of paragraphs under each subheading (1 idea per paragraph). In each paragraph, you should explain: o What is this paragraph about? o What evidence have you found to support your idea? What does the evidence tell us? o How does this paragraph link to the report title? o How does it link to the topic in the next paragraph? Charts, diagrams and tables can be used to reinforce your ideas. Conclusion (about 10% of word count) o Do not introduce any NEW material here. Restate what you consider the main points to be. Make it clear why your conclusions are important or significant.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 6 of 14 In your last sentence, link your conclusions or recommendations back to the questions. Did you answer your main question? What was the answer? Reference List An alphabetically ordered list of the references cited in your report, in Harvard style.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 1 of 14Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 1 of 14 Marking Criteria KNOWLEDGE & UNDERSTANDING INTELLECTUAL & COGNITIVE SKILLS GRADUATE SKILLS: TRANSFERABLE, EMPLOYABILITY, PRACTICAL AND ACADEMIC SKILLS Factual and conceptual knowledge and understanding; use of class materials; independent reading Critical thinking; conceptualisation; creativity; synthesis, analysis and evaluation; application; problem solving and research/investigation Written, oral and presentation skills; interpersonal, group and teamwork skills; leadership skills; numeracy; digital skills; practical, professional and academic skills (including referencing/presentation) MARKING BAND MODULE LEARNING OUTCOMES CLASSIFICATION WEIGHTED AT 50% WEIGHTED AT 25% WEIGHTED AT 25% 86 - 100% Achieved at this level FIRST (1ST) Includes all required factual content, accurately summarised. Well developed, relevant introduction and conclusions. Within word count or presentation time. Includes relevant factual content only. Clearly and logically structured material. Accurate spelling, grammar, punctuation, paragraphing. Very accurate identification of pre-defined concepts, theories and/or principles, appropriaate to this level. Information or data selected from highly relevant sources, and categorised, analysed or evaluated using a recommended format. Fluent, interesting writing style, appropriate to the assignment OR engaging, confident, audible and well- paced presentation. Excellent understanding of factual and conceptual material, relative to this level. Well-developed arguments, referencing a range of literature, appropriate to this level. Appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are accurate, clearly set out, with explanations. Relates theory to practice effectively, appropriate to this level. Correct use of academic conventions, references and bibliography. Very good independent reading and research, beyond standard texts, appropriate to this level. Very good application of numerical and statistical methods to defined problems. Outstanding, consistent delivery of group work obligations, for this level. Effective use of class materials to develop knowledge and understanding. Precise, relevant recommendations. Very good awareness of ethical issues, where relevant. Insightful reflection on own strengths and weaknesses in relation to defined professional and practical skills. 70 - 85% Achieved at this level FIRST (1ST) Includes all required factual content, accurately summarised. Relevant introduction and conclusions. Within word count or presentation time. Includes relevant factual content only. Clearly structured material. Accurate spelling, grammar, punctuation, paragraphing. Accurate identification of pre-defined concepts, theories and/or principles, appropriate to this level. Information or data selected from relevant sources, and categorised, analysed or evaluated using a recommended format. Fluent writing style, appropriate to the assignment OR engaging, confident, audible and well-paced presentation.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 2 of 14 Very good understanding of factual and conceptual material, relative to this level. Coherent arguments, referencing a range of literature, appropriate to this level. Appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are accurate, clearly set out, with explanations. Relates theory to practice, appropriate to this level. Correct use of academic conventions, references and bibliography. Good independent reading and research, beyond standard texts, appropriate to this level. Good application of numerical and statistical methods to defined problems. Very good, consistent delivery of group work obligations, for this level. Effective use of class materials to develop knowledge and understanding. Relevant recommendations. Good awareness of ethical issues, where relevant. Good reflection on own strengths and weaknesses in relation to defined professional and practical skills. 60 - 69% Achieved at this level UPPER SECOND (2:1) Includes most required factual content, mostly accurately summarised. Mostly relevant introduction and conclusions. Within word count or presentation time. Includes relevant factual content only. Clearly structured material, with a few gaps. Mostly accurate spelling, grammar, punctuation, paragraphing. Mainly accurate identification of pre-defined concepts, theories and/or principles, appropriate to this level. Information or data selected from relevant sources, and categorised, analysed or evaluated using a recommended format, with some gaps or errors. Mainly fluent writing style, appropriate to the assignment OR mainly engaging, audible and well-paced presentation. Good understanding of factual and conceptual material, relative to this level. Mostly coherent arguments, referencing a range of literature, appropriate to this level. Mostly appropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are mainly accurate, clearly set out, with mostly good explanations. Relates theory to practice, appropriate to this level, but with some gaps or errors. Mostly correct use of academic conventions, references and bibliography. Reasonable independent reading and research, beyond standard texts, appropriate to this level. Mainly good application of numerical and statistical methods to defined problems. Good and generally consistent delivery of group work obligations, for this level. Mostly effective use of class materials to develop knowledge and understanding. Mostly relevant recommendations. Sound awareness of ethical issues, where relevant. Clear reflection on own strengths and weaknesses in relation to defined professional and practical skills. 50 - 59% Achieved at this level LOWER SECOND (2:2) Includes most required factual content, but with some gaps or misunderstandings. Adequate introduction and conclusions. Within 10% of word count or presentation time. Includes some irrelevant factual content. Adequately structured material. Some mistakes in spelling, grammar, punctuation, paragraphing.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 3 of 14 Some identification of pre-defined concepts, theories and/or principles, appropriate to this level. Information or data selected, categorised, analysed or evaluated with an attempt at using a recommended format and with gaps or errors. Writing style is mostly appropriate but not always fluent OR a presentation that is not always engaging, audible or well-paced. Adequate understanding of factual and conceptual material, relative to this level. Limited arguments referencing limited literature. Includes personal opinion. Inconsistent visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations may have inaccuracies, or issues relating to set out and explanation. An attempt to relate theory to practice, appropriate to this level. Inconsistent use of academic conventions, references and bibliography. Some limited independent reading and research, beyond standard texts, appropriate to this level. Adequate application of numerical and statistical methods to defined problems, with gaps or errors. Inconsistent delivery of group work obligations, for this level. Adequate use of class materials to develop knowledge and understanding. Some recommendations. Some awareness of ethical issues, where relevant. Some evaluation of own strengths and weaknesses in relation to defined professional and practical skills. 40 - 49% Marginal achievement at this level THIRD (3RD) Includes limited factual content, with many gaps or inaccuracies. Basic introduction and conclusions. Within 10% of word count or presentation time. Includes significant irrelevant factual content. Unevenly structured material. Frequent mistakes in spelling, grammar, punctuation, paragraphing. Limited identification of pre-defined concepts, theories and/or principles, appropriate to this level. Information or data poorly selected, categorised, analysed or evaluated, and may not use recommended format. Awkward or inappropriate writing style OR a presentation that is not engaging, audible or well-paced. Limited understanding of factual and conceptual material, relative to this level. Little argument, mainly descriptive or personal opinion, with little reference to literature. Inappropriate visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are often inaccurate, with many issues relating to set out and explanation. Very limited or inadequate attempt to relate theory to practice. Inconsistent or incomplete use of academic conventions, references and bibliography. Minimal independent reading and research beyond standard texts, appropriate to this level. Weak application of numerical and statistical methods to defined problems. Unreliable delivery of group work obligations, for this level. Limited use of class materials to develop knowledge and understanding. Confused recommendations. Little awareness of ethical issues, where relevant. Limited reflection on own strengths and weaknesses in relation to defined professional and practical skills. 30 - 39% Marginal failure at this level FAIL. POSSIBLE COMPENSATION. Includes insufficient required factual content, with significant gaps or inaccuracies. Incoherent or irrelevant introduction and conclusions. More than 10% outside word count or presentation time. Includes substantial irrelevant factual content. Incoherently structured material. Serious mistakes in spelling, grammar, punctuation, paragraphing.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 4 of 14 Very limited or inaccurate identification of pre-defined concepts, theories and/or principles, appropriate to this level. Minimal selection of information or data, and little attempt at collation, categorisation, analysis or evaluation. Poor writing style OR a presentation that is not engaging, audible or well-paced. Very limited understanding of factual and conceptual material, relative to this level. Little or no argument, entirely descriptive or personal opinion, with no reference to literature. Poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are mostly inaccurate, or incorrectly set out or explained. Theory not related to practice. Inaccurate or incomplete use of academic conventions, references and bibliography. Minimal independent reading and research, appropriate to this level. Limited use of standard texts. Very weak application of numerical and statistical methods to defined problems. Poor delivery of group work obligations, for this level. Very limited use of class materials to develop knowledge and understanding. Irrelevant or no recommendations. Little or no awareness of ethical issues, where relevant. Very limited reflection on own strengths and weaknesses in relation to defined professional and practical skills. 16 - 29% Not achieved at this level FAIL. NO COMPENSATION. Includes almost no required factual content, and with very significant inaccuracies. No introduction and conclusions. More than 10% outside word count or presentation time. Includes mainly irrelevant factual content. Very incoherently structured material. Serious and extensive mistakes in spelling, grammar, punctuation, paragraphing. No identification of pre-defined concepts, theories and/or principles, appropriate to this level. No evidence of the selection, categorisation, analysis or evaluation of information or data. Incoherent writing style OR an inaudible, poorly paced and unengaging presentation. No understanding of factual and conceptual material, relative to this level. Little or no argument, entirely descriptive or personal opinion, with no reference to literature. Very poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are inaccurate, with no explanations. Theory not related to practice. Very inaccurate or no use of academic conventions, references and bibliography. No independent reading and research, appropriate to this level. Very minimal use of standard texts. Minimal application of numerical and statistical methods and techniques to defined problems, with significant errors. Very poor delivery of group work obligations, where relevant. Minimal use of class materials to develop knowledge and understanding. No recommendations. No awareness of ethical issues, where relevant. Minimal evaluation of own strengths and weaknesses in relation to defined professional and practical skills. 0 - 15% Not achieved at this level FAIL. NO COMPENSATION. Does not include required factual content. No introduction and conclusions. More than 10% outside word count or presentation time. Includes entirely irrelevant factual content. Very incoherently structured material. Serious and extensive mistakes in spelling, grammar, punctuation, paragraphing.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 5 of 14 No identification of pre-defined concepts, theories and/or principles, appropriate to this level. No evidence of the selection, categorisation, analysis or evaluation of information or data. Incoherent writing style OR an inaudible, poorly paced and unengaging presentation. Demonstrates no understanding of factual and conceptual material and ideas. No argument, entirely personal opinion, with no reference to sources. Exceptionally poor visual presentation, including font, spacing, margins, headings, graphics, images and appendices. Calculations are missing, with no explanations. Theory not related to practice. No use of academic conventions, references and bibliography. No independent reading and research, or use of standard texts, appropriate to this level. No application of numerical and statistical methods to defined problems. No delivery of group work obligations, for this level. No use of class materials to develop knowledge and understanding. No recommendations. No awareness of ethical issues, where relevant. No evaluation of own strengths and weaknesses in relation to defined professional and practical skills.Module Code Module Title Spring 2017 Coursework Brief GSM LONDON Page 1 of 14