Creating my own spreadsheet to convert binary to decimal

A spreadsheet can be used to do calculations quickly using formulas. How can we make a spreadsheet that converts a binary number to a decimal number? This lesson provides some guidance and Excel files for student and teacher use.

Additional details

Year band(s) 5-6, 7-8
Content type Lesson ideas
Format Web page
Core and overarching concepts Data representation
Australian Curriculum Digital Technologies code(s)

Explain how digital systems represent all data using numbers


Explore how data can be represented by off and on states (zeros and ones in binary)

Keywords Noline, Protocols, Share information, Graphs, Doubling, Digital Citizenship
Integrated, cross-curriculum, special needs Mathematics, Digital Literacy



Creative Commons Attribution 4.0, unless otherwise indicated.