office solution development

office solution development follow the module booklet, and you can fin" rel="nofollow">ind the lecturer as well on the college website http://elearnin" rel="nofollow">ing.ukcbc.co.uk username : batch6 password: batch6.and write the references Module Booklet Unit 22 Office Solutions Development Unit level 4 Unit code R/601/1971 Qualification BTEC HND in" rel="nofollow">in Computin" rel="nofollow">ing Term Start Date 22/02/2016 Hand out date 29/02/2016 Submission Deadlin" rel="nofollow">ine 15/07/2016 Lecture 15 Weeks Revision Clin" rel="nofollow">inic 3 Weeks Module Leader Gasso Wilson Lecturer CONTENTS TABLE OF CONTENTS 1.0 INTRODUCTION 2 1.1 Aim: 2 1.2 Objectives: 2 2.0 Unit Content 2 3.0 Learnin" rel="nofollow">ing outcomes and assessment criteria 2 4.0Teachin" rel="nofollow">ing plan for the term 2 5.0 ASSIGNMENT FRONT SHEET 2 5.1 ASSIGNMENT BRIEF SECTION 2 1.0 INTRODUCTION Within" rel="nofollow">in an organization, a range of busin" rel="nofollow">iness processes are functional at operational, tactical and strategic levels within" rel="nofollow">in the busin" rel="nofollow">iness structure. Some busin" rel="nofollow">iness processes are quite simplistic, especially at the operational level where routin" rel="nofollow">ine, non-complex decisions and tasks are undertaken. However as you advance through the levels of an organization, the strategic levels, more complex busin" rel="nofollow">iness processes and decision makin" rel="nofollow">ing is required that may need support from more automated, on-demand in" rel="nofollow">information systems and solutions. Providin" rel="nofollow">ing office solutions to support a range of busin" rel="nofollow">iness functions and decision makin" rel="nofollow">ing can range from the implementation of a simple rule or macro, through to the design of a more complex piece of code or program to support different end users. This unit is designed to build upon existin" rel="nofollow">ing skills and knowledge previously gain" rel="nofollow">ined from usin" rel="nofollow">ing different types of application and design software. Learners will be expected to demonstrate more advanced skills in" rel="nofollow">in terms of data manipulation, configuration, application and implementation of software packages to enhance a given busin" rel="nofollow">iness processes or processes. On completion of this unit the learner should be able to use design application software at an advanced level of proficiency. Learners will engage with a range of software, and select the most appropriate application(s) to offer feasible and workin" rel="nofollow">ing busin" rel="nofollow">iness solutions. 1.1 AIM: To equip learners with the knowledge and skills needed to develop application solutions that can be used to automate busin" rel="nofollow">iness processes. 1.2 OBJECTIVES: On successful completion of this unit a learner will: 1. Understand how application software can support busin" rel="nofollow">iness processes 2. Be able to design and implement office solutions 3. Be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced/improved. 2.0 UNIT CONTENT: 1 Understand how application software can support busin" rel="nofollow">iness processes Applications software: Types e. g, spreadsheets, database, presentation, graphics, desk-top publishin" rel="nofollow">ing, word processin" rel="nofollow">ing Busin" rel="nofollow">iness processes: management e. g, supportin" rel="nofollow">ing decision makin" rel="nofollow">ing, problem solvin" rel="nofollow">ing; operational eg sales, purchasin" rel="nofollow">ing, Marketin" rel="nofollow">ing; Support eg accountin" rel="nofollow">ing, technical Supportin" rel="nofollow">ing processes: Improvin" rel="nofollow">ing the efficiency of a busin" rel="nofollow">iness process e. g, forecastin" rel="nofollow">ing, decision makin" rel="nofollow">ing, and predictive reasonin" rel="nofollow">ing; Automatin" rel="nofollow">ing processes e. g, prin" rel="nofollow">int runs, salary slips supportin" rel="nofollow">ing the user: User requirements e. g, accessibility, usability, clarity, help 2 Be able to design and implement office solutions Solutions: supportin" rel="nofollow">ing a busin" rel="nofollow">iness process e.g, end user requirements, systems requirement, application to automate procedures, designin" rel="nofollow">ing a tool, program or package that can perform a specific task to support problem-solvin" rel="nofollow">ing or decision-makin" rel="nofollow">ing at an advanced level, creatin" rel="nofollow">ing an e-Commerce function for a website to support a specific busin" rel="nofollow">iness process, designin" rel="nofollow">ing a program for a specific end user that will support another application or process. Design: considerations e.g., addressin" rel="nofollow">ing the user or system requirement; user-friendly and functional in" rel="nofollow">interface; consideration of user engagement and in" rel="nofollow">interaction with the designed solution; customization of the solution to satisfy the user and system requirements Advanced tools and techniques: tools e.g. analysin" rel="nofollow">ing data with in" rel="nofollow">interactive PivotTables and Pivot Charts, lin" rel="nofollow">inkin" rel="nofollow">ing Excel spreadsheets with SharePoin" rel="nofollow">int, team collaboration and document management with Win" rel="nofollow">indows SharePoin" rel="nofollow">int; techniques e.g. creatin" rel="nofollow">ing decision-makin" rel="nofollow">ing macros, programmin" rel="nofollow">ing Access objects, buildin" rel="nofollow">ing in" rel="nofollow">intuitive user in" rel="nofollow">interfaces with VBA, buildin" rel="nofollow">ing ASP.net web applications Testin" rel="nofollow">ing: Functionality: e. g, checkin" rel="nofollow">ing again" rel="nofollow">inst requirements, error handlin" rel="nofollow">ing, documentation 3 Be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced/improved User engagement: engagement through e. g, meetin" rel="nofollow">ings, questionnaires, in" rel="nofollow">interviews Enhanced/improved: Comparisons e. g, more efficient, faster results, more user friendly, improved compatibility with other systems and processes, improved management in" rel="nofollow">information 3.0 LEARNING OUTCOMES AND ASSESSMENT CRITERIA Learnin" rel="nofollow">ing outcomes LO1 Understand how application software can support busin" rel="nofollow">iness processes 1.1 discuss ways in" rel="nofollow">in which applications software can support busin" rel="nofollow">iness processes 1.2 justify the use of different application software to support a given user requirement or busin" rel="nofollow">iness process 1.3 discuss the importance of addressin" rel="nofollow">ing both user and busin" rel="nofollow">iness requirements LO2 be able to design and implement office solutions 2.1 design a solution to address a busin" rel="nofollow">iness or user need 2.2 use advanced tools and techniques to implement a solution 2.3 test a solution again" rel="nofollow">inst expected results LO3 be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced/improved 3.1 discuss ways in" rel="nofollow">in which end user engagement has taken place 3.2 provide evidence that busin" rel="nofollow">iness processes have been enhanced/improved 3.3 evaluate possible further improvements that could be made to enhance the system. 4.0 TEACHING PLAN FOR THE TERM Accreditin" rel="nofollow">ing Body: EDEXCEL Accreditin" rel="nofollow">ing Body: EDEXCEL Course: BTEC HND IN Computin" rel="nofollow">ing and Systems Development Unit: 22. Office Solutions Development Wk Lecture Schedule Outcome of session Activity/semin" rel="nofollow">inar and formative assessment Resources 1 Introduction to Office Solution Development. Introduction to the module, mode of assessment, awareness of the awardin" rel="nofollow">ing body, assessment criteria and the mode of assessment. Role play and in" rel="nofollow">individual in" rel="nofollow">induction, helpin" rel="nofollow">ing to know each other. Module handbook. 2 Applications software: types eg spreadsheets, database, presentation, graphics, desk-top publishin" rel="nofollow">ing, word processin" rel="nofollow">ing By the end of the session you will be able to discuss ways in" rel="nofollow">in which applications software can support busin" rel="nofollow">iness process.. Spreadsheets, database, presentation, graphics, desk-top publishin" rel="nofollow">ing and word processin" rel="nofollow">ing software’s in" rel="nofollow">in busin" rel="nofollow">iness context. Review of Task P1.1 Case study, tutorial and addressin" rel="nofollow">ing the learnin" rel="nofollow">ing outcome 1.1 Activities- Research- Identify the features of spreadsheets, database, presentation, graphics, desk-top publishin" rel="nofollow">ing and word processin" rel="nofollow">ing software. Power poin" rel="nofollow">int slides from: Heathcote P, MSN Tutorial, . 3 Busin" rel="nofollow">iness processes: management eg supportin" rel="nofollow">ing decision makin" rel="nofollow">ing, problem solvin" rel="nofollow">ing; operational eg sales, purchasin" rel="nofollow">ing, marketin" rel="nofollow">ing; support eg accountin" rel="nofollow">ing, technical By the end of the session Learners will be able to justify the use of different applications software to support given user requirements. Case study, tutorial and addressin" rel="nofollow">ing the learnin" rel="nofollow">ing outcome 1.2 Activities -Research How applications software such as word processin" rel="nofollow">ing, spreadsheets, graphics, supports busin" rel="nofollow">iness. Power poin" rel="nofollow">int slides from: Heathcote P, MSN Tutorial, 4 Supportin" rel="nofollow">ing processes: improvin" rel="nofollow">ing the efficiency of a busin" rel="nofollow">iness process eg forecastin" rel="nofollow">ing, decision makin" rel="nofollow">ing, predictive reasonin" rel="nofollow">ing; automatin" rel="nofollow">ing processes eg prin" rel="nofollow">int runs, salary slips Learners’ will be able to understand the followin" rel="nofollow">ing: • Busin" rel="nofollow">iness Process • Decision makin" rel="nofollow">ing • Forecastin" rel="nofollow">ing, salary slip. Review of Task P1.2 Case study, tutorial and addressin" rel="nofollow">ing the learnin" rel="nofollow">ing outcome 1.3 Research-Activity Select a company and identify and explain" rel="nofollow">in how busin" rel="nofollow">iness process are supported by the application software such as word processin" rel="nofollow">ing ,spreadsheets etc. Course Notes, 5 Supportin" rel="nofollow">ing the user: user requirements eg accessibility, usability, clarity, help Learners will be able to understand the busin" rel="nofollow">iness and user requirements. Review of Task P1.3 Tutorial usin" rel="nofollow">ing MS Excel and recap the learnin" rel="nofollow">ing outcome 1.1, 1.2 and 1.3 Course Notes, Practical 6 Be able to design and implement office solution Solutions: supportin" rel="nofollow">ing a busin" rel="nofollow">iness process eg end user requirements, systems requirement, application to automate procedures, designin" rel="nofollow">ing a tool, program or package that can perform a specific task to support problem-solvin" rel="nofollow">ing or decision-makin" rel="nofollow">ing at an advanced level, creatin" rel="nofollow">ing an e-Commerce function for a website to support a specific busin" rel="nofollow">iness process, designin" rel="nofollow">ing a program for a specific end user that will support another application or process Learners’ will be able to understand the busin" rel="nofollow">iness process and end user requirements and identify the suitable solution to support busin" rel="nofollow">iness process for decision makin" rel="nofollow">ing. Case study and tutorial and address the LO 2.1 Research activity Based on the case study given identify the requirements of the users and advise them how application software can support specific task such as problem solvin" rel="nofollow">ing, decision makin" rel="nofollow">ing etc. Course Notes, Practical 7 Design: considerations e.g. addressin" rel="nofollow">ing the user or system requirement; user-friendly and functional in" rel="nofollow">interface; consideration of user engagement and in" rel="nofollow">interaction with the designed solution; customization of the solution to satisfy the user and system requirements Learners’ will be able to prepare spread sheet for busin" rel="nofollow">iness requirements such as budget, fin" rel="nofollow">inancial report, salary slip usin" rel="nofollow">ing MS Excel accordin" rel="nofollow">ing to user requirements. Review of Task P2.1 Case study and tutorial MS Excel 2007 and address partly the LO 2.2 Activity – Prepare a spreadsheet model for enter staff details, hours worked etc and to calculate salaries. Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 8 Advanced tools and techniques: tools e.g. analyzin" rel="nofollow">ing data with in" rel="nofollow">interactive PivotTables and Pivot Charts, lin" rel="nofollow">inkin" rel="nofollow">ing Excel spreadsheets with SharePoin" rel="nofollow">int, team collaboration and document management with Win" rel="nofollow">indows SharePoin" rel="nofollow">int; techniques eg creatin" rel="nofollow">ing decision-makin" rel="nofollow">ing macros, programmin" rel="nofollow">ing Access objects, buildin" rel="nofollow">ing in" rel="nofollow">intuitive user in" rel="nofollow">interfaces with VBA, buildin" rel="nofollow">ing ASP.net web applications Learners’ will be able to crate pivot tables and chart, pie and bar chart from the table to support to make busin" rel="nofollow">iness decision. Review of Task P2.2 Tutorial and address the LO 2.3. Activity- Prepare a spreadsheet for enter sales data, calculation of vat and total sales and analysis the sales data and produced sales data in" rel="nofollow">in a chart Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 9 Advanced tools and techniques: tools eg analyzin" rel="nofollow">ing data with in" rel="nofollow">interactive PivotTables and Pivot Charts, lin" rel="nofollow">inkin" rel="nofollow">ing Excel spreadsheets with SharePoin" rel="nofollow">int, team collaboration and document management with Win" rel="nofollow">indows SharePoin" rel="nofollow">int; techniques eg creatin" rel="nofollow">ing decision-makin" rel="nofollow">ing macros, programmin" rel="nofollow">ing Access objects, buildin" rel="nofollow">ing in" rel="nofollow">intuitive user in" rel="nofollow">interfaces with VBA, buildin" rel="nofollow">ing ASP.net web applications Learners’ will be able to crate pivot tables and chart, pie and bar chart from the table to support to make busin" rel="nofollow">iness decision. Review of Task P2.3 Tutorial and address the LO 2.3. Activity- Prepare a spreadsheet for enter sales data, calculation of vat and total sales and analysis the sales data and produced sales data in" rel="nofollow">in a chart Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 10 Testin" rel="nofollow">ing: functionality: eg checkin" rel="nofollow">ing again" rel="nofollow">inst requirements, error handlin" rel="nofollow">ing, documentation Learners’ will be able to produce the test plan and test outcomes Review of Task P3.1 Tutorial and address the LO 3.1 Activity –Produce a test plan accordin" rel="nofollow">ing to the requirements and show evidence of the spreadsheet model is workin" rel="nofollow">ing. Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 11 Testin" rel="nofollow">ing: functionality: eg checkin" rel="nofollow">ing again" rel="nofollow">inst requirements, error handlin" rel="nofollow">ing, documentation Learners’ will be able to test the data and handle the error on created application solution and be able to create documentation for busin" rel="nofollow">iness use. Tutorial and address the LO 3.1 Activity –Produce a test plan accordin" rel="nofollow">ing to the requirements identified in" rel="nofollow">in task 2 and show evidence of the spreadsheet model is workin" rel="nofollow">ing. Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 12 Able to demonstrate that busin" rel="nofollow">iness process have been enhanced/improved User engagement: engagement through e.g. meetin" rel="nofollow">ings, questionnaires, in" rel="nofollow">interviews Learners’ will be able to understand the importance of user in" rel="nofollow">involvement and the ways to engage the user with the software solution. Review of Task P.3.2 Tutorial and address the LO 3.2 Research – Why it is important of user in" rel="nofollow">involvement and the ways to engage the user with the software solution such as in" rel="nofollow">interviews and observations. Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 13 User engagement: engagement through e.g. meetin" rel="nofollow">ings, questionnaires, in" rel="nofollow">interviews Learners’ will be able to understand the importance of user in" rel="nofollow">involvement and the ways to engage the user with the software solution. Tutorial and address the LO 3.2 Research – Why projects failure? Does it matter to identify the user requirements when design a new system? Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. 14 Enhanced/improved: comparisons e.g. more efficient, faster results, more user friendly, improved compatibility with other systems and processes, improved management in" rel="nofollow">information Learners’ will be able to understand, how the software solution will enhance and improve the busin" rel="nofollow">iness process with better in" rel="nofollow">information management. Case study and tutorial and address the LO 3.3 Research – based on the case study task 2 identify and describe how the model improves the busin" rel="nofollow">iness process of the company. Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. Research activity- 15 Enhanced/improved: comparisons e.g. more efficient, faster results, more user friendly, improved compatibility with other systems and processes, improved management in" rel="nofollow">information Learners’ will be able to understand, how the software solution will enhance and improve the busin" rel="nofollow">iness process with better in" rel="nofollow">information management. Review of Task P3.3 Case study and tutorial and address the LO 3.3 Course Notes, and Lab Practical, onlin" rel="nofollow">ine video tutorial. Research activity- 16 ASSIGNMENT SUPPORT AND ADVISE 17 ASSIGNMENT SUPPORT AND ADVISE 18 REVISION AND ASSIGNMENT SUBMISSION Recommended text and lin" rel="nofollow">inks Books Heathcote P – Successful ICT Projects in" rel="nofollow">in Excel (Payne Galway, 2002) ISBN-10: 1903112710 Jellen B – Brilliant Microsoft Excel 2007 VBA and Macros (Brilliant Excel Solutions) (Prentice Hall, 2007) ISBN-10: 0273714058 Jellen B – Excel VBA and Macros with Excel (Video Train" rel="nofollow">inin" rel="nofollow">ing) (Live lessons) (QUE, 2009) ISBN-10: 0789739380 Rendell I, Mott J – Advanced Spreadsheet Projects in" rel="nofollow">in Excel (Hodder, 2008) ISBN 0340929243 Websites http://spreadsheets.about.com/od/advancedexcel/Advanced_Topics_in" rel="nofollow">in_Excel_Spreadsheets.htm www.ehow.com/topic_2573_advanced-excel-tutorial.html Wk Session Update Date Signature 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Lecturer: Gasso Wilson Campus: Wentworth house Contact details: [email protected] Assessment: The module will be assessed meetin" rel="nofollow">ing all the LO as specified by the awardin" rel="nofollow">ing body, Ed Excel. Please read the in" rel="nofollow">instructions carefully while addressin" rel="nofollow">ing the tasks specified. Contribution: 100% of the module Outlin" rel="nofollow">ine Details: Individual report approx 4000 words. Details enclosed in" rel="nofollow">in the assignment brief. Teachin" rel="nofollow">ing and Learnin" rel="nofollow">ing Activities The module tutor(s) will aim to combin" rel="nofollow">ine lectures with tutorial activities. This environment will provide opportunities for the student to understand the course material through case study and text and to apply it in" rel="nofollow">in a practical way. The in" rel="nofollow">intent is to facilitate in" rel="nofollow">interactive class activities, and discussion about the significant role of research in" rel="nofollow">in a global and local busin" rel="nofollow">iness environment. 2.3 Teachin" rel="nofollow">ing Ethos The college’s approach towards teachin" rel="nofollow">ing and learnin" rel="nofollow">ing is simple and effective. The main" rel="nofollow">in aim of UKCBC is to assist learners in" rel="nofollow">in maximisin" rel="nofollow">ing their potential by ensurin" rel="nofollow">ing that they are taught clearly and effectively. This will enable students to engage in" rel="nofollow">in the learnin" rel="nofollow">ing environment and promote success in" rel="nofollow">in both their academic studies and subsequent career. 2.3.1 Methods of Delivery: LECTURES: These will be developed around the key concepts as mentioned in" rel="nofollow">in the in" rel="nofollow">indicative course content and will use a range of live examples and cases from busin" rel="nofollow">iness practice to demonstrate the application of theoretical concepts. This method is primarily used to identify and explain" rel="nofollow">in key aspects of the subject so that learners can utilise their private study time more effectively. SEMINARS: These are in" rel="nofollow">in addition to the lectures. The semin" rel="nofollow">inars are designed to give learners the opportunity to test their understandin" rel="nofollow">ing of the material covered in" rel="nofollow">in the lectures and private study with the help of reference books. This methodology usually carries a set of questions identified in" rel="nofollow">in advance. Semin" rel="nofollow">inars are in" rel="nofollow">interactive sessions led by the learners. This method of study gives the learner an excellent opportunity to clarify any poin" rel="nofollow">ints of difficulty with the tutor and simultaneously develop their oral communication skills. CASE STUDIES: An important learnin" rel="nofollow">ing methodology is the extensive use of case studies. They enable learners to apply the concepts that they learn in" rel="nofollow">in their subjects. The learners have to study the case, analyse the facts presented and arrive at conclusions and recommendations. This assists in" rel="nofollow">in the assessment of the learner’s ability to apply to the real world the tools and techniques of analysis which they have learnt. The case study serves as a supplement to the theoretical knowledge imparted through the course work. Plagiarism: Any act of plagiarism will be seriously dealt with accordin" rel="nofollow">ing to the colleges and awardin" rel="nofollow">ing bodies’ regulations. In this context the defin" rel="nofollow">inition and scope of plagiarism are presented below: Plagiarism is presentin" rel="nofollow">ing someone’s work as your won. It in" rel="nofollow">includes copyin" rel="nofollow">ing in" rel="nofollow">information directly from the web or books without referencin" rel="nofollow">ing the material; submittin" rel="nofollow">ing join" rel="nofollow">int coursework as an in" rel="nofollow">individual effort; copyin" rel="nofollow">ing another student’s coursework; stealin" rel="nofollow">ing coursework form another student and submittin" rel="nofollow">ing it as your own work. Suspected plagiarism will be in" rel="nofollow">investigated and if found to have occurred will be dealt with accordin" rel="nofollow">ing to the college procedure. (For further details please refer to the plagiarism policy and the student code of conduct.) Assessment: The module will be assessed meetin" rel="nofollow">ing all the LO as specified by the awardin" rel="nofollow">ing body, Ed Excel. Please read the in" rel="nofollow">instructions carefully while addressin" rel="nofollow">ing the tasks specified. Contribution: 100% of the module Outlin" rel="nofollow">ine Details: Individual report approx 4000 words. Details enclosed in" rel="nofollow">in the assignment brief. 5.0 ASSIGNMENT FRONT SHEET Unit: 22 – Office Solutions Development Learnin" rel="nofollow">ing Hours: 45 Hours. Self-learnin" rel="nofollow">ing hours: 90 hours. Course: HND CSD – Level 4 CREDIT VALUE: 15 CREDITS Term: Module Leader: Gasso Wilson Lecturer: Internal Verifier: Raj Kanapathi ASSIGNMENT TITLE: Office Solutions Development Guidance in" rel="nofollow">in addition to the Pass criteria’s, this assignment gives you the opportunity to submit evidence in" rel="nofollow">in order to achieve the followin" rel="nofollow">ing Merit and Distin" rel="nofollow">inction grades. Assessment Grid in" rel="nofollow">indicatin" rel="nofollow">ing their pass, merit and distin" rel="nofollow">inction Unit: 22- Office Solutions Development Outcomes/criteria: Indicative characteristics Possible evidence Contextualisation In this assessment you will have the opportunity to present evidence that shows you are able to : Feedback LO1-Task1. Understand how application software can support busin" rel="nofollow">iness processes LO2-Task 2. Be able to design and implement office solutions LO3.-Task 3 Be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced/improved As per the assessment criteria specified for pass Do Do Addressin" rel="nofollow">ing 1.1,1.2 and 1.3 as in" rel="nofollow">instructed Addressin" rel="nofollow">ing 2.1,2.2 and 2.3 as in" rel="nofollow">instructed Addressin" rel="nofollow">ing 3.1,3.2 and 3.3 as in" rel="nofollow">instructed Merit Description: Contextualisation M1. Identify and apply strategies to fin" rel="nofollow">ind appropriate solutions. An effective approach to study and research has been used .. To achieve M1 an effective approach of study with good research skills bein" rel="nofollow">ing used across the assignment to address the criteria’s with reference to the given case study. M2. Select/ design and apply appropriate methods/ techniques. . A range of methods and techniques has been applied. To achieve M2, you will have used range of methods and techniques have been applied with special reference to task2. M3. Present and communicate appropriate fin" rel="nofollow">indin" rel="nofollow">ings. . Appropriate structure and approach has been used. To achieve M3 the work should be appropriately structured addressin" rel="nofollow">ing the Learnin" rel="nofollow">ing outcomes as specified with appropriate fin" rel="nofollow">indin" rel="nofollow">ings with special reference to given case studies across the assignment and Technical language accurately used with special reference to task 2 design and implement a system for the given requirements. Distin" rel="nofollow">inction Description: D1. Use critical reflection to evaluate own work and justify valid conclusion. . Synthesis has been used to generate and justify valid conclusions . To achieve D1 you will have addressed the Criteria’s with valid conclusions, justifyin" rel="nofollow">ing improvements and characteristics of success. For example how applications can support busin" rel="nofollow">iness process for the given case study. D2. Take responsibility for managin" rel="nofollow">ing and organizin" rel="nofollow">ing activities. Autonomy/in" rel="nofollow">independence demonstrated To achieve D2 you will have demonstrated autonomy across your assignment, with effective in" rel="nofollow">independent research and met the deadlin" rel="nofollow">ines to submit all the tasks and achieve the unit assessment criteria. D3. Demonstrate convergent, lateral and creative thin" rel="nofollow">inkin" rel="nofollow">ing Ideas generate and decisions taken To achieve D3 the learner demonstrates new ideas or suggestions for example task 3 for the given case study and your writin" rel="nofollow">ing demonstrate research and shows some creative thin" rel="nofollow">inkin" rel="nofollow">ing across the tasks. 5.1 ASSIGNMENT BRIEF SECTION ASSIGNMENT Unit Number and title Unit 22/OFFICE SOLUTIONS DEVELOPMENT Qualification BTEC HND Computin" rel="nofollow">ing (Level 4) Term Start Date 22 February 2016 Assignment hand out date 29 February 2016 Deadlin" rel="nofollow">ine/ Hand-in" rel="nofollow">in 15 July 2016 Case study World Wide Publishin" rel="nofollow">ing Co. Ltd publishes road Atlases which are sold by three different methods: 1. To wholesalers, who in" rel="nofollow">in turn sell them on to retailers (Bookshops etc.) 2. To retailers such as bookshops, service stations, shops specialisin" rel="nofollow">ing in" rel="nofollow">in Car accessories; 3. To in" rel="nofollow">individual members of the public who order directly by phone or mail in" rel="nofollow">in response to advertisement. World Wide Publishin" rel="nofollow">ing Ltd uses a specialised Accounts package to enter orders, prepare in" rel="nofollow">invoices and keep records of Customer accounts. Each day they accept orders by phone, fax, email or regular mail and prepare in" rel="nofollow">invoices accordin" rel="nofollow">ingly. There are normally about 5-15 orders each day. These in" rel="nofollow">invoices together with an extra copy of each one, are then mailed the same day to Oxford Warehouse, a separate organisation which stores large quantities of books for hundreds of different publishers. Oxford warehouse packs and dispatches the books, enclosin" rel="nofollow">ing one copy of the in" rel="nofollow">invoice with the books and keepin" rel="nofollow">ing the other copy for their records. A “Pickin" rel="nofollow">ing List” report has to be enclosed with the in" rel="nofollow">invoices sent daily to Oxford Warehouse, tellin" rel="nofollow">ing them the total number of each title that has to be dispatched that day. The Warehouse covers several acres and a forklift truck driver has to be sent to collect the correct number of books from the specified bin" rel="nofollow">ins and take them to the dispatch area where they are packed and collected for delivery by Securicor. The end of each month World Wide Publishin" rel="nofollow">ing Ltd receives an in" rel="nofollow">invoice from Oxford Warehouse for their services, based on the sales value of books dispatched that month. The Current System The user (Mrs. Joanne Bernard, the owner of World Wide Publishin" rel="nofollow">ing Ltd) was in" rel="nofollow">interviewed to ascertain" rel="nofollow">in how the current system of producin" rel="nofollow">ing Pickin" rel="nofollow">ing Lists works, and exactly what are the requirements of the new system. Mrs. Joanne Bernard does not want any changes to the current method of recordin" rel="nofollow">ing customer orders and prin" rel="nofollow">intin" rel="nofollow">ing in" rel="nofollow">invoices usin" rel="nofollow">ing the software package sage sterlin" rel="nofollow">ing. However, the Pickin" rel="nofollow">ing List as described above cannot be generated by this system in" rel="nofollow">in the format required by Oxford Warehouse, and producin" rel="nofollow">ing this by hand is time-consumin" rel="nofollow">ing and prone to error. At present the Pickin" rel="nofollow">ing List is prepared by addin" rel="nofollow">ing up the total quantity of each book from in" rel="nofollow">invoices and enterin" rel="nofollow">ing the figures on to a photocopied form. Sometimes the Sales clerk uses a spreadsheet as a calculator just to make sure the addition is correct. But there is no set method of preparin" rel="nofollow">ing the report. Mrs. Joanne Bernard would also like to be able to get in" rel="nofollow">instant in" rel="nofollow">information on total monthly sales, which is not available from Sage Accounts system in" rel="nofollow">in the format in" rel="nofollow">in which she would like it. Samples of an Invoice Output from Sage but used as in" rel="nofollow">input document for the Pickin" rel="nofollow">ing List, and a copy of the Pickin" rel="nofollow">ing List are as shown below: Source Document1: Invoices Source Document2: Current Pickin" rel="nofollow">ing List Report Objectives of the new System: The new System should be able to perform the followin" rel="nofollow">ing: • Allow data from the in" rel="nofollow">invoices (Quantity of each book and total in" rel="nofollow">invoice value) to be recorded quickly and accurately; • Calculate totals and produce a pickin" rel="nofollow">ing list from this automatically • Produce monthly sales summaries • Produce a chart showin" rel="nofollow">ing monthly sales over the past year, and in" rel="nofollow">indicatin" rel="nofollow">ing predicted sales based on these sales figures • The system must be robust and easy to use You have been appoin" rel="nofollow">inted as a Systems Analyst and Software Developer. For the purpose documentation you are required to adhere to the followin" rel="nofollow">ing procedure: 1. You must draw a Context Diagram preceded by a table of catalogue of requirements 2. You must draw a Data Flow Diagram (Level 1) outlin" rel="nofollow">inin" rel="nofollow">ing the process of orderin" rel="nofollow">ing, in" rel="nofollow">invoicin" rel="nofollow">ing and dispatchin" rel="nofollow">ing books 3. On this DFD(Level 1) clearly show the boundary of the system with dotted lin" rel="nofollow">ines 4. Implement the system for the given case study. 5. Include performance in" rel="nofollow">indicators as follows: • It should not take longer than 30 seconds to enter each in" rel="nofollow">invoice • Data entry should be made so simple that the resultin" rel="nofollow">ing Pickin" rel="nofollow">ing List is 100% accurate • The Pickin" rel="nofollow">ing List will be produced in" rel="nofollow">in one operation by the user – for example selectin" rel="nofollow">ing from a menu or clickin" rel="nofollow">ing a button on a customised toolbar • The monthly sales summary and chart will be produced in" rel="nofollow">in a similar way, usin" rel="nofollow">ing a menu item or button. • The system must cater for any number of titles to be added at a future date as the company expands • It must be impossible to accidentally erase formulae, headin" rel="nofollow">ings etc.. • The System should be easy to use for anyone with rudimentary knowledge of Excel Based on your analysis of the requirements, you should be able to recommend the type of computer system to use both Hardware and Software. There are two users of this system namely Mrs Joanne Bernard who is not in" rel="nofollow">involved in" rel="nofollow">in the Data entry and Mrs. Nicholson who will be extensively in" rel="nofollow">involved in" rel="nofollow">in enterin" rel="nofollow">ing data together with a new recruit, James Sunday. In terms of the choice of software, you are restricted to usin" rel="nofollow">ing Excel and MS ACCESS and MS Word. Worksheet Design The System will be based on two workbooks: 1. A Products workbook contain" rel="nofollow">inin" rel="nofollow">ing details of all products 2. A Template contain" rel="nofollow">inin" rel="nofollow">ing a number of separate worksheets for data entry, reports and summaries( Detailed design next) At the begin" rel="nofollow">innin" rel="nofollow">ing of each year the user will be able to open a new workbook based on this Template and enter daily in" rel="nofollow">invoice data which will be accumulated day by day over the year. Reports and charts will be produced from this accumulated data by means of options on a Custom Menu stored in" rel="nofollow">in the template. In addition a front end menu will enable the user to choose which task they wish to perform e.g., enter data from in" rel="nofollow">invoices, prin" rel="nofollow">int a monthly sales summary or chart. Data to be entered in" rel="nofollow">include product number, title, and Bin" rel="nofollow">in number and for in" rel="nofollow">invoice data this will in" rel="nofollow">include date, in" rel="nofollow">invoice number, quantity, sales etc. The application Template will contain" rel="nofollow">in 5 sheets as follows: Sheet1 – Menu: This sheet will act as a front end and will be selected automatically usin" rel="nofollow">ing an autoexec macro when the workbook is loaded. It will have 4 Options: Enter Invoices, View Pickin" rel="nofollow">ing List, Monthly Sales Summary, and Exit Sheet2 – Invoices: This is where the daily in" rel="nofollow">invoices will be entered Sheet3 – Pick List: This sheet will take the form of the Pickin" rel="nofollow">ing List which will have formulae lin" rel="nofollow">inkin" rel="nofollow">ing it both to the World Wide Publishin" rel="nofollow">ing Ltd Atlas Products workbook for the product titles and the Bin" rel="nofollow">in numbers, and the Invoices worksheet from where it will get the Totals. It will be as follows: Sheet4 – Sales: This will contain" rel="nofollow">in all the daily Sales amounts for the current year. It will have just two columns: Date Amount The day’s data will be automatically added to this list when the user presses Add to monthly sales button on Invoices sheet Sheet5 – Monthly: This sheet will hold a PivotTable that will show year-to-date monthly sales. The user can create the PivotTable report by selectin" rel="nofollow">ing the option monthly sales summary either from a custom menu (Atlas) on the menu bar or from the front end menu. This runs a macro called Monthly Pivot which groups sales totals by month. The user can produce a chart and trend lin" rel="nofollow">ine from these figures usin" rel="nofollow">ing the standard chart button. The followin" rel="nofollow">ing are suggested macros that you are required to create: 1. Insert Product 2. Enter Invoices 3. View Pickin" rel="nofollow">ing List 4. Add To Monthly Sales 5. Monthly Pivot 6. Auto-Open(Runs automatically when the Atlas workbook is opened) 7. Auto-Close(Runs automatically when the Atlas workbook is closed) 8. Transfer data to ACCESS Database 9. Mail Merge ACCESS data with Standard Letter in" rel="nofollow">in MS Word to send to Customers 10. Make sure to use advanced features such as VLOOKUP and HLOOKUP in" rel="nofollow">in your data manipulation Fin" rel="nofollow">inally: 1. Test your System 2. Write user and Technical manuals 3. Write evaluation and fin" rel="nofollow">inish all documentation. TASK 1 to TASK 3: You are required to follow the in" rel="nofollow">instructions as specified towards each task and support with research by usin" rel="nofollow">ing supportive materials like books, websites, etc., and give feedback on the fin" rel="nofollow">indin" rel="nofollow">ings by relatin" rel="nofollow">ing your arguments to the relevant case study as specified towards each task. Answers without reflectin" rel="nofollow">ing the case study practice will be referred. Your report should fully follow the Harvard Referencin" rel="nofollow">ing model. LO1 Understand how application software can support busin" rel="nofollow">iness processes TASK 1: The objective for this task is to address and exhibit an understandin" rel="nofollow">ing of how application software can support busin" rel="nofollow">iness process. You are required to address the task as specified and research by usin" rel="nofollow">ing supportive materials like books, websites, etc to address the learnin" rel="nofollow">ing outcomes as specified: Please note that the research and subjective skill needs to exhibit transferable skill by reflectin" rel="nofollow">ing it to the chosen Case Study “World Wide Publishin" rel="nofollow">ing Co. Ltd.”. Answers without reflectin" rel="nofollow">ing the case study practice will be referred. A.C 1.1 Discuss ways in" rel="nofollow">in which applications can support busin" rel="nofollow">iness processes of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C1.2 Jjustify the use of different application software to support a given user requirement or busin" rel="nofollow">iness process of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C1.3 Ddiscuss the importance of addressin" rel="nofollow">ing both user and busin" rel="nofollow">iness requirements of World Wide Publishin" rel="nofollow">ing Co. Ltd LO2 Be able to design and implement office solutions TASK 2 The objective for this task is to design and implement office solution. You are required to address the task as specified and research considerin" rel="nofollow">ing the given case study for task 2 and address the learnin" rel="nofollow">ing outcomes as specified: A.C 2.1 Ddesign a solution to address a busin" rel="nofollow">iness or user needs of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C2.2 use advanced tools and techniques to implement a solution for World Wide Publishin" rel="nofollow">ing Co. Ltd A.C2.3 test World Wide Publishin" rel="nofollow">ing Co. Ltd solution again" rel="nofollow">inst expected results. LO3 Be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced / improved TASK 3: The objective for this task is to d demonstrate that busin" rel="nofollow">iness processes have been enhanced / improved .You are required to address the task as specified and research considerin" rel="nofollow">ing the case study assigned for task2 to address the learnin" rel="nofollow">ing outcomes as specified A.C3.1 discuss based on World Wide Publishin" rel="nofollow">ing Co. Ltd, ways in" rel="nofollow">in which end user engagement has taken place A.C 3.2 provide evidence that World Wide Publishin" rel="nofollow">ing Co. Ltd busin" rel="nofollow">iness processes have been enhanced/improved. A.C 3.3 Evaluate possible further improvements that could be made to enhance the system Merit Description: Contextualisation M1. Identify and apply strategies to fin" rel="nofollow">ind appropriate solutions. An effective approach to study and research has been used To achieve M1 an effective approach of study with good research skills bein" rel="nofollow">ing used across the assignment to address the criteria’s with reference to the given case study. M2. Select/ design and apply appropriate methods/ techniques. . A range of methods and techniques has been applied. To achieve M2, you will have used range of methods and techniques have been applied with special reference to task2. M3. Present and communicate appropriate fin" rel="nofollow">indin" rel="nofollow">ings. . Appropriate structure and approach has been used. To achieve M3 the work should be appropriately structured addressin" rel="nofollow">ing the Learnin" rel="nofollow">ing outcomes as specified with appropriate fin" rel="nofollow">indin" rel="nofollow">ings with special reference to given case studies across the assignment and Technical language accurately used with special reference to task 2 design and implement a system for the given requirements. Distin" rel="nofollow">inction Description: D1. Use critical reflection to evaluate own work and justify valid conclusion. . Synthesis has been used to generate and justify valid conclusions To achieve D1 you will have addressed the Criteria’s with valid conclusions, justifyin" rel="nofollow">ing improvements and characteristics of success. For example how applications can support busin" rel="nofollow">iness process for the given case study. D2. Take responsibility for managin" rel="nofollow">ing and organizin" rel="nofollow">ing activities. Autonomy/in" rel="nofollow">independence demonstrated To achieve D2 you will have demonstrated autonomy across your assignment, with effective in" rel="nofollow">independent research and met the deadlin" rel="nofollow">ines to submit all the tasks and achieve the unit assessment criteria. D3. Demonstrate convergent, lateral and creative thin" rel="nofollow">inkin" rel="nofollow">ing Ideas generate and decisions taken To achieve D3 the learner demonstrates new ideas or suggestions for example task 3 for the given case study and your writin" rel="nofollow">ing demonstrate research and shows some creative thin" rel="nofollow">inkin" rel="nofollow">ing across the tasks. Assignment Guidelin" rel="nofollow">ines: • Use a standard report structure, Word-process the report and use Normal script of a proper font size 12. • Produce an academic report, detailin" rel="nofollow">ing the above issues with a word limit of approx. 4000 to 4500 words. • Complete the title page and sign the statement of authenticity. • The Assignment sheet should be attached in" rel="nofollow">in the front. • Submit the document in" rel="nofollow">in a folder in" rel="nofollow">in the form of a file as well as a soft copy on the submission date. • It should be uploaded on E-Learnin" rel="nofollow">ing platform before the deadlin" rel="nofollow">ine and submitted to -------- and sign the submission form of the college. • Assignments submitted after the deadlin" rel="nofollow">ine will not be accepted unless mitigatin" rel="nofollow">ing and may be entitled for a late fee. • Collusion and Plagiarism must be avoided. • Start each answer on a new page and pages should be numbered. Highlight each question clearly. • Include a Bibliography at the end of the assignment and use the Harvard referencin" rel="nofollow">ing system. • All work should be comprehensively referenced and all sources must be fully acknowledged, such as books and journals, websites (in" rel="nofollow">include the date of visit), etc. • Try to give the page numbers, publishers' details and the year of publication • In order to pass you need to address all the LO • In order to get a merit you need to first pass and then address the characteristics of M1, M2,M3 • In order to get a Distin" rel="nofollow">inction you need to first pass, address all the merit characteristics and then address the characteristics of D1, D2 Use a common format for the questions, for example: ? Introduction (analyze the question.) ? Underpin" rel="nofollow">innin" rel="nofollow">ing Knowledge (write about the relevant theory/poin" rel="nofollow">ints) ? Applied knowledge (Data Analysis) ? Conclusions and Recommendations (summarizin" rel="nofollow">ing the whole scenario keepin" rel="nofollow">ing in" rel="nofollow">in view pass, merit, distin" rel="nofollow">inction criteria.) Achievement Summary The Followin" rel="nofollow">ing Sections to be completed by the assessor: Centre Name: UKCBC Campus: Centre Number: Please note that the assessor’s signature below denotes conformation that he/she has in" rel="nofollow">in no way in" rel="nofollow">influenced the outcome of the assessment: Assessors Name: Assessors Signature: Learners Name (to be filled by the Assessor) Intake: Batch: Term: Campus: Learners Edexcel Reference Number Has the unit been Internally Verified? Y/N Date of verification: Name of the Internal Verifier: Internal verifiers signature: If Sampled ,Internal verifiers comments on the assignment brief: Evidence Checklist Summary of the evidence required by the student Evidence presented Task 1 Task 2 Task 3 Outcomes Evidence for the criteria to pass. Assessors decision Internal verification decision. (agree, disagree) TASK 1 The objective for this task is to address and exhibit an understandin" rel="nofollow">ing of how application software can support busin" rel="nofollow">iness process. You are required to address the task as specified and research by usin" rel="nofollow">ing supportive materials like books, websites, etc. to address the learnin" rel="nofollow">ing outcomes as specified: Please note that the research and subjective skill needs to exhibit transferable skill by reflectin" rel="nofollow">ing it to the chosen Case Study “World Wide Publishin" rel="nofollow">ing Ltd”. Answers without reflectin" rel="nofollow">ing the Case study practice will be referred. L01. Understand how application software can support busin" rel="nofollow">iness processes A.C1.1 discuss ways in" rel="nofollow">in which applications can support busin" rel="nofollow">iness processes of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C 1.1 (P,M,D) A.C 1.1 (P,M,D) A.C1.2 justify the use of different application software to support a given user requirement or busin" rel="nofollow">iness process of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C 1.2 (P,M,D) A.C 1.2 (P,M,D) A.C1.3 discusses the importance of addressin" rel="nofollow">ing both user and busin" rel="nofollow">iness requirements of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C 1.3 (P,M,D) A.C 1.3 (P,M,D) Contextualised feedback for Task 1 (reflectin" rel="nofollow">ing 1.1, 1.2 and 1.3 Pass merit and distin" rel="nofollow">inction.) IV comments towards Task 1 Task 2 The objective for this task is to design and implement office solution. You are required to address the task as specified and research considerin" rel="nofollow">ing the given case study and address the learnin" rel="nofollow">ing outcomes as specified: L02. Be able to design and implement office solutions A.C2.1 design a solution to address a busin" rel="nofollow">iness or user needs of World Wide Publishin" rel="nofollow">ing Co. Ltd A.C2.1 (P,M,D) A.C2.1 (P,M,D) A.C2.2 use advanced tools and techniques to implement a solution for World Wide Publishin" rel="nofollow">ing Co. Ltd A.C2.2 (P,M,D) A.C2.2 (P,M,D) A.C2.3 test World Wide Publishin" rel="nofollow">ing Co. Ltd solution again" rel="nofollow">inst expected results. A.C2.3 (P,M,D) A.C2.3 (P,M,D) Contextualised Feedback for Task 2 (reflectin" rel="nofollow">ing 2.1, 2.2 and 2.3 Pass merit and distin" rel="nofollow">inction.) IV comments towards Task 2 Task 3 The objective for this task is to d demonstrate that busin" rel="nofollow">iness processes have been enhanced / improved .You are required to address the task as specified and research considerin" rel="nofollow">ing the case study assigned to address the learnin" rel="nofollow">ing outcomes as specified L03. Be able to demonstrate that busin" rel="nofollow">iness processes have been enhanced / improved A.C3.1 discuss based on World Wide Publishin" rel="nofollow">ing Co. Ltd, ways in" rel="nofollow">in which end user engagement has taken place A.C 3.1 (P,M,D) A.C 3.1 (P,M,D) A.C3.2 provide evidence that World Wide Publishin" rel="nofollow">ing Co. Ltd busin" rel="nofollow">iness processes have been enhanced/improved. A.C 3.2 (P,M,D) A.C 3.2 (P,M,D) A.C3.3 Evaluate possible further improvements that could be made to enhance the system A.C 3.3 (P,M,D) A.C 3.3 (P,M,D) Contextualised feedback for Task 3 (reflectin" rel="nofollow">ing 3.1, 3.2 and 3.3 Pass merit and distin" rel="nofollow">inction.) IV comments towards Task 3 Merit grades awarded M1 M2 M3 P1 P2 P3 P4 Distin" rel="nofollow">inction grades awarded D1 D2 D3 Resubmit : Any other comments Grade given by the Assessor: Pass Merit Distin" rel="nofollow">inction Resubmission Assessors Signature: Date: IV Gradin" rel="nofollow">ing Check: Comments if any: Agree Disagree Modify grade to IV signature: Date: Students feedback: Student Signature: Date: Any act of plagiarism will be seriously dealt with accordin" rel="nofollow">ing to the colleges and awardin" rel="nofollow">ing bodies’ regulations. In this context the defin" rel="nofollow">inition and scope of plagiarism are presented below: Plagiarism is presentin" rel="nofollow">ing someone’s work as your won. It in" rel="nofollow">includes copyin" rel="nofollow">ing in" rel="nofollow">information directly from the web or books without referencin" rel="nofollow">ing the material; submittin" rel="nofollow">ing join" rel="nofollow">int coursework as an in" rel="nofollow">individual effort; copyin" rel="nofollow">ing another student’s coursework; stealin" rel="nofollow">ing coursework form another student and submittin" rel="nofollow">ing it as your own work. Suspected plagiarism will be in" rel="nofollow">investigated and if found to have occurred will be dealt with accordin" rel="nofollow">ing to the college procedure. (For further details please refer to the plagiarism policy and the student code of conduct.)