Ethics and Professional skills module unit 7

To solve the abacus problem you just need to read VERY carefully the explanation of values top and bottom (rather than make any assumptions).

Here is the hint for the question of predicted sales: "To get the predicted sale you need to load the Data Analysis Tab if not loaded already and follow the procedure to use the linear regression prediction following the instruction given on the module. You need to understand how to identify the constant and the coefficient and you will get the predicted sale easily. If you are not able please get back"

I went through this with a professional data scientist and got the first two questions wrong. The reason was because I entered the data to two decimal places. There was nothing to suggest we’d be penalised for this. ACCA are usually very clear when they want it rounded to the nearest dollar so this is disappointing. It is meant to be simulating real life after all. If you are getting these wrong try answering without decimals.

Hi all, I am loosing the will to live. I am doing Unit 7 - "Types of data visualisation - Composition" In 2017 how much was the total sales in $m (excluding bakery sales)?. Maybe I am just looking at this wrong. I don't want someone to tell me the answer as that won't help me, but to see am I actually going mad or just tired. This was my thinking on it. The departments are stacked - exclude bakery. I was working the basics Deli 25000000 Homeware 20000000 Grocery 15000000 Min Total 60000000 Then I added the little parts above the break line and was getting these figures Homeware 2500000 Grocery 500000 So I put in my answer, including all the zeros, then I thought maybe I have the little extra number wrong so tried a few of them. Then I thought maybe I am just tired so I had a colleague look at it and she got the same numbers I did. Any help on this would be great as I am cracking up. Rgds Caroline

Try answering without the zeros. For instance 25 instead of 25000000

In $m means the # of millions - i.e. the number before the 000000.

Hi.. I really need help. Im stucked at level 7 of the end of unit assessment, where i had to answer questions relating to the data analysis of the ticket sales and all that. But im totally lost, had no idea where to refer to for the analysing of the data from the spreadsheet. Can anyone guide me along please :(

thjxxacca - I suggest you start at the beginning of this thread reading my posts - I tell you exactly what you are supposed to have done before you tackle the assessment.

Can someone help me to advise on Module 7 Q2? I am so desperate to complete the Professional Ethics. Whole week wasted :(

I managed to solve the abacus question within 10 minutes but the predicted sales (Q2) and other final questions are disaster..

@kjayale - please spend 5 minutes reading through my posts on this thread - I tell you everything you need to pay attention to, to pass this module.

Regarding the 250k investment question. Probably we should first calculate the expected revenues by updating the barrier cost variable value in the equation? But, what about the next step? Should we deduct from the calculated sales the 250k investment cost to find the profit and to elaborate further, or simply to compare the sales based on 250k and 30k investments variables?

Please read through my posts on this thread - you need to look to the illustration in the module, that I have clearly signposted, to understand what you are trying to achieve in the task.

I read several times your posts. What we are looking for is the impact on profits if $250,000 were spent on automated ticket barrier investment. First calculate the expected sales with change of X Variable 3 to 250K, and then take into account the increase in cost of investment with 220K. Probably I do not understand properly the question?

Just to correct the above comment, that the 220K investment cost increase I deduct from the increase of expected sales.

But have you gone back to the illustration in the module? You don't seem to understand the point of the formula. As I explain in previous posts increase in revenue is increase in profit because there is no variable/direct cost of sales. It cannot be correct to deduct cost of investment - i.e. CAPITAL cost (which would be asset in SoFP) from revenue in the derivation of profit.

Well, I change one of the variables (the investment spend) and predict the new sales using the rest variables values from Q2. Then compare with sales initially calculated with 30k spend. The delta is not accepted as a correct answer. Spent plenty of hours by making various trials but without any result. Even, I'm asking myself, are unit 7 assessment Q2 and Q3 related?

No the questions are independent of each other.

Hi, I used the formula Y = deleted I got the following : DELETED This is the correct answer!!!

Good day, Can someone please help me out. I am struggling to find correct answers for question 2, 3 and 5 of unit 7 of Ethics module. I have followed through all Kim's notes, plugged in figures in to the formulas and even used Excel Spreadsheet for accuracy of my calculation but I am still not winning. Kindly please assist asap. I do understand the fundamental principle, but I am just not sure why I am not getting the correct answers!

@valentinoh - I can't suggest anything else short of giving you the answers - which would be unethical of me(!) If you have read through all my tips on this thread (not just those on this page) it is really not as difficult as it may look. When you say "even used excel spreadsheet" I would expect you to have downloaded the one provided. Then if you have worked through the illustration earlier in the module, you should be able to interpret the coefficients.

I need help with the Predictive analytics questions been failing since morning

@mbulukimanake - please read through my "tips" on this post - you need to start by working through the illustration earlier in the unit - then all you are doing is replicating the same process.

Hi All, I was about to create a topic, but now see that not just me who's struggling with this unit 7. I'm totally stuck, as the instructions don't make any sense. They say you need to download the spreadsheet (Ok, I did), then "enable" it, choose Data tab and something from the drop-down... Where should I be enabling it? There is only one tab an no drop-downs at all. Extremely confusing. I'd appreciate any tips, experiences, suggestions. Thank you

@kate108 - when files are downloaded from the internet, a computer will often open them only in "protected view" - there will be a yellow stripe across the top of the docx/xlsx/pptx when it is opened and it will say something like "This file originated from ....." followed by the words "Enable Editing" in a box. You just click on that box and the yellow box goes away and the xlsx will be enabled.

Yes, I've expected something like that, but in this case there wasn't any yellow stripes nor buttons Enable. I know how it looks normally. This is where my confusion comes from, also other instructions don't make any sense. And what are we supposed to calculate there? Thank you

You're not supposed to understand the assessment without having first worked through the module - in particular the "types of analytics" section and in that section focus on "predictive analytics" - where you will find an example BBQ Sales. You don't have to be able to create the spreadsheet or the statistics that it contains - only to interpret a given output table.

Sir! Thank You very much I Almost forgot about regression but your help made my day.

Thank you for the feedback Zain!

This thread really helped me to under the calculation for q1 on Unit 7 and I am now able to move onto Unit 8 - Thanks!