9_3_11

Activity 1

Many aspects of this outcome were covered in 9_3_9. You may want to watch this video again to remind yourself:

Activity 2 - READ

Any spreadsheet that you make, must be fit for purpose. You should always ask yourself - is this allowing me to carry out the intended task?

By following the rules of spreadsheet design, you should be able to carry out the task that you require.

You need to make sure that:

• Data is separated
• Data is formatted correctly
• Data is easy to read
• Borders and colours are used to enhance not hinder
• Charts are used when needed
• Automation has been considered if the spreadsheet is to be used long term (e.g. =today())

Activity 3 - READ

Any spreadsheet that you make, must be suitable for the audience.

You must always consider the needs of the audience:

• Might they have a visual impairment? (see this website for tips: https://support.office.com/en-gb/article/Make-your-Excel-spreadsheets-accessible-6cc05fc5-1314-48b5-8eb3-683e49b3e593 )
• Might they see colours differently? (see this website: http://www.colourblindawareness.org/colour-blindness/colour-blindness-experience-it/ )
• Will they understand my spreadsheet?
• Is it clear enough, can I simplify it?
• Is the data easy to analyse?
• Am I showing them too much data?
• Am I showing them too little data?

These questions should always be considered when presenting a spreadsheet for a particular audience.

Create a section of your guide that shows how to meet the needs of the audience.

Students will need some time to practice the different formulas in the tutorials. It may be best to let students work through these tutorials independently.