challenge 2

profileamanali786
Challenge2LogicGateExerciseSimple2.xlsx
Home>Information Systems homework help>challenge 2

Step 1_Logic Gates

AND Gate OR Gate NOT Gate
Transistor Diagram Transistor Diagram Transistor Diagram
0 0 0
0 0
The AND operator gives the value one if and only if all the inputs are 1. Insert a formula in the yellow shaded cell that gives the correct output. The OR operator gives the value 1 if at least one input has a value of 1. Insert a formula in the yellow shaded cell that gives the correct output. A NOT gate performs logical negation on its input. In other words, if the input is 1, the output is 0 and vice versa. Insert a formula in the yellow shaded cell that gives the correct output.
NAND Gate NOR Gate A logic gate is a conceptualized or physical device that performs a logical operation on one or more binary inputs and produces a single binary output. Using Microsoft excel formulas, provide the proper output for the AND, OR, NOT, NAND, and NOR gates. (There may be more than one way to implement the logic in excel!)
Transistor Diagram Transistor Diagram
0 0
0 0
The NAND operator gives the value of 0 if and only if all the inputs have a value of 1, otherwise it has a value of 1. It is equivalent to a NOT AND. Insert a formula in the yellow shaded cell that gives the correct output. A NOR gate is a logic gate which gives the value of 1 only when both inputs are 0. It is equivalent to a NOT OR. Insert a formula in the yellow shaded cell that gives the correct output.

Step 2_Decoder

0
0
**Watch the YouTube video here the complete items 1 & 2: https://www.youtube.com/watch?v=p8xLrtRM7U0. Item 1: Input an Excel formula in each of the shaded cells above to indicate the correct output of the initial step in a decoder circuit (Far left selectable bits.) Item 2: Input an Excel formula in each of the shaded cells above to indicate the correct output of the final step in a decoder circuit.
https://www.youtube.com/watch?v=p8xLrtRM7U0.

Step 3_Reading from memory

A B C D
0
E F G H
0
I J K L
M N O P
Complete the same items from step 2 in the above shaded fields. In this circuit, you will be applying the decoder output to indicate which 4 bits of data will be placed in memory. Keep in mind there are 4 sets of 4 bits that will be allocated to an address in the register. These 4 bits are represented by capital letters, but actually are values of 0 or 1.
Input Excel formulas in ranges X4:X7, X10:X13, X16:X19, & X22:X25 to indicate which row of bits will indicate a 1 ("On") based on decoder output values (Column Q). Next, input Excel formulas in merged cell range Z33:AC33 to show the correct values for bits loaded into the register (Hint: Embedded "IF" functions)

image1.gif

image10.png

image2.gif

image3.gif

image4.gif

image5.png

image6.png

image7.png

image8.png

image9.jpeg