Mobile phones don’t just make call anymore. You can play games, socialise, do you food shopping, check the train times, read the news, watch the latest cinema trailers and more...

Some people have made millions of pounds by designing new mobile phone apps and selling them.

Can you do the same?

This is a 12 page topic booklet in which students are asked to think about their audience when planning and designing a new mobile phone app. They will consider purpose, usability, layout, colours, fonts etc.

A complex spreadsheet that models a cinema booking system.

You can use this to showcase the simple elements with weaker classes or get confident classes to attempt to fully recreate it. This file should be used as an example to demonstrate to students how to build their own. Techniques students will develop in order to build a similar model include:

• Merging Cells
• Formatting Cells (colour, font size, centre alignment)
• Borders
• Conditional Formatting
• Data Validation (Selection from a drop down list)
• SUM function
• The IF function to display a 'sold out' message