Denary (Decimal) to Binary spreadsheet challenge

Shows a denary to binary conversion algorithm, sets the challenge of implementing in a spreadsheet and provides a solution.

The Algorithm – think of a number: say 47 repeat divide the number by 2 write down the remainder until the number becomes 0 end

The challenge is to represent the algorithm in a spreadsheet.

This task requires the author to be able to use the following functions: mathematics – =INT() =MOD( ,2) text – CONCATENATE( , , ) TEXT( ,”0”)

Level: (Intermediate)

Duration: 40 minutes activity

Teaches: reinforces binary and the application of a spreadsheet; modelling