what is binary and why do we use it?
DESCRIPTION
Introduction to binary numbers and simple calculator using Excel.TRANSCRIPT
![Page 1: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/1.jpg)
What is binary?
Why do computers use it?
![Page 2: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/2.jpg)
The first computer was NOT a binary machine
.. but that was a mistake
![Page 3: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/3.jpg)
Which is clearer?
![Page 4: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/4.jpg)
Which is clearer?
![Page 5: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/5.jpg)
Confident?
![Page 6: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/6.jpg)
recursive
89635839
010011010
![Page 7: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/7.jpg)
How binary works
To convert to decimal, just add them up!0*128 + 1*64 + 0*32 + 1*16 + 1*8 + 1*4 + 1*2 + 0*1
0
Units (1s)
1
2s
1
4s
1
8s
1
16s
0
32s
1
64s
0
128s
Just two numbers, 0 and 1 Place matters
![Page 8: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/8.jpg)
Can you do it?
Decimal number 128 64 32 16 8 4 2 1
0 0 0 0 0 1 1 0
0 1 0 0 0 1 1 1
0 0 0 0 0 0 0 0
0 1 0 1 0 1 0 1
1 0 1 1 1 1 0 1
0 0 1 0 1 0 1 1
1 1 1 1 1 1 1 1
![Page 9: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/9.jpg)
Can you do it the other way?
Decimal number 128 64 32 16 8 4 2 1
6
7
15
23
62
127
96
![Page 10: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/10.jpg)
What’s the bottom of Excel?
![Page 11: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/11.jpg)
Excel binary to decimal
Use eight cells for the binary number
Put the magic numbers below: 128,64,32,16,8,4,2,1 Multiply * Add the results =sum() Make it look good
Can you do it the other way round?
![Page 12: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/12.jpg)
Excel decimal to binary
Use =div() to divide by two Keep doing it Use =mod() to find the remainder That gives you the binary digits
Decimal number here=int(/2)
=mod(,2)
![Page 13: What is binary and why do we use it?](https://reader036.vdocuments.us/reader036/viewer/2022081413/546facefaf79591a068b463e/html5/thumbnails/13.jpg)
Can you ….
Write out a binary number? Convert binary to decimal? Convert decimal to binary? Use multiply in a spreadsheet? Drag-Copy in a spreadsheet? Use =SUM() in a spreadsheet? Use =INT() in a spreadsheet? Use =MOD() in a spreadsheet?