61 62 63 64 Write your answer here: 65 66 67 Question 3 After an election outcome that literally nobody saw coming you find yourself traveling through the countryside with a wolf, a goat, and a box of cabbage. You come to a river you need to cross. The only way across is a small boat that can hold you and one other item (i.e. the wolf xor the goat xor the cabbage). You cannot leave the goat alone with the cabbages. You cannot leave the wolf alone with the goat. How do you get across the river with your animal friends and your cabbage? 68 Feel free to use the space below as scratch paper. Show your work if you aren't 100% confident in your answer. 69 70 71 72 73 74 75 76 77 JX A B D E K F H J FALSE FALSE TRUE FALSE FALSE TRUE p iffa q FALSE TRUE TRUE Question 2: Recreate the complicated truth table from William Spaniel's video (https://www.youtube.com/watch?v=Zbroc5QCpos&list=PLKI1h_nAkaQq5MDWIKXuOje ZmlDt-510n&index=15) Hint: if you set up the first row correctly you can copy/paste it into the other rows and they'll update automatically. r S p AND p OR S (p AND 9) OR NOT(IF r THEN (P OR S)) IF r THEN (P OR S) P NOT(IF r THEN (P OR s)) g 1 1 1 1 random cell checks 0 0 TRUE 0 (these should all be TRUE) 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 0 0 0 1 1 1 1 0 0 0 1 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 5 1 0 0 1 1 7 3 O O OO 0 0 0 0 2 nuortion J22 fx A B C D E F G H 4 You will be using truth values, symbols, and logical operators to complete the questions below. Remember, TRUE is 1 and FALSE IS O 5 You should only change certain cells 6 Orange cells are 'work' cells. You should be filing these cells in to answer the questions, 7 Light blue cels are "check" cells. You should try different values in these cels to check your work 8 Dark blue cells are "test" cells. Don't change these! They will help you check your work. 9 There is one light green cell. Hover your mouse over it to see my comment 10 I'm looking for an excel function mimicking the truth table using the built in functions AND, OR, NOT, etc. (except for the last question where I want a verbal description of how to solve the puzzle). 11 12 Question : 13 Automate the conditional 14 I've gotten you started on this one. There is an error in the orange cell and your job is to fix it. Once you do, the check cel will update to TRUE. 15 16 Here is the truth table defining the conditionat 17 9 if p then a 18 TRUE TRUE TRUE 19 TRUE FALSE FALSE 20 FALSE TRUE TRUE 21 FALSE FALSE TRUE 22 23 if p then 9 p 9 P AND 24 FALSE FALSE FALSE TRUE FALSE 25 26 Question 1: 27 Automate the biconditional 28 Build a function that will calculate the correct truth value based on the values of p and 29 30 This is the truth table defining the blconditional: 31 p g p iffa 32 TRUE TRUE TRUE 33 TRUE FALSE FALSE 34 FALSE TRUE FALSE 35 FALSE FALSE TRUE 36 37 piffa P 38 FALSE TRUE TRUE 39 Questina 2 an 61 62 63 64 Write your answer here: 65 66 67 Question 3 After an election outcome that literally nobody saw coming you find yourself traveling through the countryside with a wolf, a goat, and a box of cabbage. You come to a river you need to cross. The only way across is a small boat that can hold you and one other item (i.e. the wolf xor the goat xor the cabbage). You cannot leave the goat alone with the cabbages. You cannot leave the wolf alone with the goat. How do you get across the river with your animal friends and your cabbage? 68 Feel free to use the space below as scratch paper. Show your work if you aren't 100% confident in your answer. 69 70 71 72 73 74 75 76 77 JX A B D E K F H J FALSE FALSE TRUE FALSE FALSE TRUE p iffa q FALSE TRUE TRUE Question 2: Recreate the complicated truth table from William Spaniel's video (https://www.youtube.com/watch?v=Zbroc5QCpos&list=PLKI1h_nAkaQq5MDWIKXuOje ZmlDt-510n&index=15) Hint: if you set up the first row correctly you can copy/paste it into the other rows and they'll update automatically. r S p AND p OR S (p AND 9) OR NOT(IF r THEN (P OR S)) IF r THEN (P OR S) P NOT(IF r THEN (P OR s)) g 1 1 1 1 random cell checks 0 0 TRUE 0 (these should all be TRUE) 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 0 0 0 1 1 1 1 0 0 0 1 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 5 1 0 0 1 1 7 3 O O OO 0 0 0 0 2 nuortion J22 fx A B C D E F G H 4 You will be using truth values, symbols, and logical operators to complete the questions below. Remember, TRUE is 1 and FALSE IS O 5 You should only change certain cells 6 Orange cells are 'work' cells. You should be filing these cells in to answer the questions, 7 Light blue cels are "check" cells. You should try different values in these cels to check your work 8 Dark blue cells are "test" cells. Don't change these! They will help you check your work. 9 There is one light green cell. Hover your mouse over it to see my comment 10 I'm looking for an excel function mimicking the truth table using the built in functions AND, OR, NOT, etc. (except for the last question where I want a verbal description of how to solve the puzzle). 11 12 Question : 13 Automate the conditional 14 I've gotten you started on this one. There is an error in the orange cell and your job is to fix it. Once you do, the check cel will update to TRUE. 15 16 Here is the truth table defining the conditionat 17 9 if p then a 18 TRUE TRUE TRUE 19 TRUE FALSE FALSE 20 FALSE TRUE TRUE 21 FALSE FALSE TRUE 22 23 if p then 9 p 9 P AND 24 FALSE FALSE FALSE TRUE FALSE 25 26 Question 1: 27 Automate the biconditional 28 Build a function that will calculate the correct truth value based on the values of p and 29 30 This is the truth table defining the blconditional: 31 p g p iffa 32 TRUE TRUE TRUE 33 TRUE FALSE FALSE 34 FALSE TRUE FALSE 35 FALSE FALSE TRUE 36 37 piffa P 38 FALSE TRUE TRUE 39 Questina 2 an