AO2 Format a spreadsheet to make it user friendly

Pass

Merit

Distinction

Candidates will use text and background colour and cell borders although these may not show the different types of cell in the most helpful way.

They will adjust row height or column width and will merge cells.

They will set the direction of text in a cell.

They will add at least one example of help for the user, such as an instruction on the sheet, a cell comment, an input message or validation, although this may not be of a high quality.

Candidates will use text and background colour and cell borders to distinguish between different types of cell (eg cells to input data, cells which automatically calculate).

They will adjust row height or column width, hide and show rows or columns and will merge cells.

They will set the direction of text in a cell and will set some text to wrap in a cell.

They will add help for a new user. This help will include at least one cell comment and appropriate validation in at least one row/column.

They will use conditional formatting.

Candidates will appropriately use text and background colour and cell borders to distinguish between different types of cell (eg cells to input data, cells which automatically calculate).

They will adjust row height or column width, hide and show rows or columns and will merge cells.

They will set the direction of text in a cell and will set some text to wrap in a cell.

They will add sufficient help to enable a beginner to use the spreadsheet with ease. This help will include suitable cell comments and validation with useful feedback to users.

They will set cells for input from a drop-down list.

They will use conditional formatting to make the output clearer.

They will use worksheet protection to prevent a user changing/deleting formulas whilst allowing data to be added/edited as needed by a user.

Diweddarwyd diwethaf: Tuesday, 8 May 2012, 4:16 PM