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
-
A matter of style
In this lesson sequence, students using the Zen Garden website reflect on criteria for effective design.
-
Google CS First: Storytelling
CS First: Storytelling guides students to use block-based coding in Scratch projects through a series of themed activities.
-
Baringa State Primary School: Implementation of STEM
Baringa PS uses a cross-disciplinary approach that integrates STEM disciplines around relevant contexts (ie a problem, question, product or issue).
-
Parramatta Marist High: Building a programming mindset
Kelly Bauer explains how video games are the starting point for Year 7 students at Parramatta Marist High to learn about coding.
-
Torrens Valley Christian School: New subject at Year 10
Fiona Clayton describes how their Year 10 Digital Technologies subject has had an impact on numbers opting to go on and study in this area.