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) |
AC9TDI6K03
Explain how digital systems represent all data using numbers
AC9TDI6K04
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 |
| Organisation | ESA |
| Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
Visual to text coding: Setting Up
This series of lessons is to help students to transition from visual coding to text-based coding with a general-purpose programming language.
-
Visual to text coding: The Basics
This series of lessons is to help students to transition from visual coding to text-based coding with a general-purpose programming language.
-
Visual to text coding: Lesson 1
This is the first in a series of lessons to transition from visual coding to text-based coding with a general-purpose programming language.
-
Visual to text coding: Lesson 2
This is the second in a series of lessons to transition from visual coding to text-based coding with a general-purpose programming language.
-
Visual to text coding: Lesson 3
This is the third in a series of lessons to transition from visual coding to text-based coding with a general-purpose programming language.