Self-marking Hexadecimal Conversion Spreadsheet Activity

An Excel spreadsheet containing two worksheets covering hexadecimal conversion.

The first worksheet takes students through converting denary to hexadecimal via a binary step. Students are shown worked examples and provided with six questions to answer using the denary->binary->hexadecimal process. Students are given feedback on their answers. When they have answered all questions correctly on the worksheet, the tab will turn green. This allows teachers to see progress easily and where students have moved on before getting 100% success. It also encourages students to persevere and compete with neighbours to ‘go green’ first.

Tab two provides worked examples of converting hexadecimal to denary via a binary step. Students then work through six questions independently and receive feedback on their answers. Tab turns green when completed successfully.

The spreadsheet uses macros which must be enabled in order to activate the feedback and tab colouring on completion of tasks.

Used successfully with GCSE Computer Science students and with Level 3 IT Year 12 students.

Works well with my other number representation activity spreadsheets as a revision aid or as a task to be included in a lesson on binary addition.

Also available – Binary conversion and Binary addition spreadsheet activities.
Please leave feedback!