Good morning guys,
Please disregard the email I send previously concerning VLookup. Since I was encountering difficulties we will focus on spreadsheet conversion only for this week. It should give you enough time to complete all outstanding work. This means that your test will not be next week, but the week after. That also means that I am giving you an additional week to make sure your exercise books are in good condition. All the classwork and homework needs to be completed. All the work needs to be in your exercise books, regardless if it was done on the computer or not.
See me lunch time second half if you have difficulties with the conversions.
Create a spreadsheet that will automatically convert decimal numbers into their binary equivalent and into the corresponding ASCII letter. For example, if you type in the number 71. It will show you the binary code 1000111 and the letter G. Set the spreadsheet up so that it can be used to read and write short messages.
The short message I want you to write is “ Computing Homework: Using spreadsheets to encrypt and decrypt data ” (This has to be in decimal, binary and finally binary)
Extend your spreadsheet so that it can also be used to convert:
Binary codes into decimal numbers and ASCII letters and ASCII letters into binary codes and decimal numbers
Make sure you convert at least 10 numbers