BTEC Unit 5: Data Modelling - Assignment 2 & 3 Learning Aim B & C 2024

BTEC Unit 5: Data Modelling - Assignment 2 & 3 Learning Aim B & C 2024. Software – The use of software that I use will be part of my constraint as there may be compatibility issues with using this project. Success criteria: The success criteria that is needed is to show how my system is successful and is a really good solution of making users aware of what is expected of them and by encouraging them to extend themselves by looking through each bit on my table. User interface design: Here I will show my design layouts and it would usually refer to graphical user interfaces to focus on looks or style and give a quick brief of how the display will look like. This design can then be used for optimisation later. My design is shown below: Main table of data: Cheese Cost per kilo (€) Cost per kilo (£) Quantity Profit + VAT VAT included Volume Sale price (£) Camembert 28 24.94 900 £7.84 £1.57 20 £27.44 Emmental 32 28.50 850 £8.96 1.79 20 £31.36 Gruyere 35 31.17 875 £9.84 1.97 20 £34.44 Edam 29 25.83 825 £8.12 1.62 20 £28.42 Gouda 31 27.61 700 £8.76 1.75 20 £30.66 Table to change data: Export file Exit Copy data Print Settings Main Menu Graph display Data of records Unit 5 – Learning Aim B Exchange rate: Price increase (10p) Profit margin (%) 0.3 £0.10 40.00% 0.4 £0.10 40.00% 0.5 £0.10 40.00% 0.6 £0.10 40.00% 0.7 £0.10 40.00% 0.8 £0.10 40.00% 0.9 £0.10 40.00% Settings table: Exchange rate Change of price Margins 30.00% -0.9 40% 40.00% -0.8 40% 50.00% -0.7 40% 60.00% -0.6 40% 70.00% 0 40% 80.00% 0.1 40% 90.00% 0.2 40% Data validation: Input mask – This would be the string of characters that indicate the format of valid input values. This would be located from the cells menu when a cell is clicked and then from there, format cells would need to be chosen. Finally, when clicking on custom, it will show the type box and I would select the correct type for input mask and it will be “#”:”00. Range check – This would be used on data made up of numbers or dates which must fall into a range. Combo box – This is a type of dialogue containing a combination of controls such as drop-down lists which will be useful for my data model in Microsoft excel. In addition to this, it is used to select one of the options given. These validations above will be beneficial to me as it will make my tables and forms very accurate and convenient. Test plan: Unit 5 – Learning Aim B Purpose of this test: The purpose of this test plan is to ensure all the testing data I provide works in a functional way along with making it seem efficient. This testing would help me indicate whether my data is working or not. Test no Test description Expected result Actual result Pass/ Fail Action taken Re-test numbe r 1 A copy button to take all the information I expect the button to function properly 2 An export button to output the information of data to a different location I expect the button to work in a proper way 3 The charts buttons to display when clicked I predict the charts button to function properly 4 The ascending button to rearrange the cells I predict the button to function properly and display in alphabetical order 5 The descending buttons to rearrange the cells I expect the button to work correctly as expected Expected result: The expected result will display an evidence to show whether it has passed or not and to meet the requirement given. Alternative design solutions: Cheese Cost per in euro Cost per kilo in pound Quantity Price (£) Camembert 28 24.94 900 27.44 Emmental 32 28.50 850 31.36 Gouda 31 27.61 700 30.66 Copy data Exit Unit 5 – Learning Aim B Exchange rate: Price increase 0.3 0.10 0.4 0.10 0.5 0.10 0.6 0.10 0.7 0.10 0.8 0.10 0.9 0.10 Exchange rate Change of price Margins 30.00% -0.9 40% 40.00% -0.8 40% 50.00% -0.7 40% 60.00% -0.6 40% 70.00% 0 40% 80.00% 0.1 40% 90.00% 0.2 40% Review to inform and identify amendments made: I will be reviewing my spreadsheet design layouts to two of my clients to improve the quality, effectiveness and appropriateness of my current designs being made. The feedback that I receive from these two clients will benefit me to fulfil ad meet each of the existing user requirements. Furthermore, these feedbacks will be useful as it will give me some ideas and suggestions by adding more options or features and this would enhance my spreadsheet design overall. Copy data Print Save Print Unit 5 – Learning Aim B Previous design: