Instructions to students: All questions are compulsory.
Dictionaries are not permitted.
Question 1.
(a) Goldilocks is shopping for a new bed in the January sales. She is 1.60m tall and is rather particular about what bed would be just right for her.
Supposed that we have named two cells in the spreadsheet Bed length and Goldilocks height. Write down the command line expression using Excel built-in functions that would return the phrase “Too small.” if the bed is less than 1.60m. It should return “Too big.” if the bed is 1.80m or longer. In all other cases it should return the phrase “This bed is just right and it has ” and this should be followed by the amount of extra space, which in turn should be followed by “meters space”. So, for example, if their calculation gave 0.1 meters, then the function should all-together return“This bed is just right and it has 0.1 meters space” [8 marks]
(b)In Fairy tale Kingdom, there is soon to be an election of a new Prime Minister. The Animal Party is currently thinking about asking Mr Wolf to stand for them against Miss Muffet However, while they think he is right for the job they worry about the fact that he is typically seen as “big and bad”. They wonder if educating the public could lead voters to think that he is actually just “misunderstood” and so vote for him. So they plan to take a look at small sample groups of 10 at a time.
Assume that the data is entered in A1:C10. In the first column are the numbers 1-10 denoting the participants in the group. In the second column is the reaction of the participant based on their existing knowledge. There are only two types of response and they are “big and bad” or “misunderstood”. In the third column are the replies after being re-educated and again only “big and bad” or “misunderstood” are entered.
Write a user defined program called voters that takes in the entries of A1:C10 as input. The program, voters, should count how many people initially said “big and bad” and count how many later said “misunderstood”. If more than half of those who initially said “big and bad” change to “misunderstood” then it should return the phrase “The strategy can work.”. If not then it needs to return “Back to the drawing board.”. You should define variable types of the input and output of the function, as well as of any other variables you may use in your program.
BEN02 Planning and Presenting a Micro-Enterprise Idea BTEC Level 1/2
Read MoreBTEC Unit 35: Engineering Services Delivery Plan for Sector-Specific Organizations | HND Level 5 Assignment 2
Read MoreTQUK Level 3 Administering Medication and Monitoring Effects in Adult Care Assignment
Read MoreUnit 10: 3D Modelling and Assembly Drawing for Vice – Engineering Design Portfolio BTEC Level 3
Read MoreWhy is it important that you correlate the appropriate information of the patient when they arrive for their appointment?
Read MoreNCFE Level 3 Roles and Responsibilities in Health And Social Care
Read MoreMP3395 Turbocharger Performance Evaluation and System Analysis CW2 Assessment, AY2024-25
Read MoreKey Research Policies and Funding Models at University of Strathclyde
Read MoreCIPD Level 5 Associate Diploma Key Assessment Questions
Read MoreLaw Assignment Questions Critical Legal Analysis & Solutions
Read More