http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm

Part A – you need to know how to:·

• identify errors (eg in hardware and software you are using) and their causes·
• observe copyright and/or confidentiality when it is necessary·
• how to minimise health risks·
• how to minimise risks from viruses·
• send and receive email

Find and select information·

• identify suitable sources of information (eg written documents, material to be scanned, files, CD ROMs, the Internet)·
• search for information using multiple search criteria (eg using AND or ‘<’ and ‘>’, or tools such as search engines)·
• interpret information and select what you need for different purposes (eg to respond to an enquiry, write a project report, design or make something).

Develop information·

• enter and combine information (eg copy and paste or insert text, images and number),using formats that help development (eg using table structures, text boxes or textwrap to position information)·
• develop information in the form of text, images and numbers (eg organise information under headings, structure tables, generate charts and graphs from data, use queries to select records)·
• derive new information (eg compare information from different sources to reach a conclusion, use formulas to calculate information such as a total or average).

Present information·

• select and use layouts and techniques to suit different tasks (eg document structures such as indents, columns and headings, borders for images and text, tables, highlight information to improve its impact, make sure it suits the needs of the audience)·
• develop the presentation to suit your purpose and audience and the types of information used ie. text, images and numbers (eg format information to improve its impact, refine layout making sure it suits the needs of your audience)·
• present information in a consistent way (eg paragraph layouts, sizes and styles of text, alignment, fonts).·
• ensure your work is accurate and clear.

Part B – you must:

 Overall, through two or more activities you must:·

• include at least one ICT based information source·
• include at least one non ICT based information source·
• use at least one example of text, one example of image and one example of number·
• present evidence of purposeful use of email.

Evidence must show you can:

ICT2.1

Search for and select information to meet your needs.

Use different information sources for each task and multiple search criteria in at least one case.

2.1.1 select information relevant to the tasks.

ICT2.2

Enter and develop the information to suit the task and derive new information.

2.2.1 enter and combine informationusing formats that help development

2.2.2 develop information and derive new information as appropriate.

ICT2.3

Present combined information such as text with image, text with number, image with number.

2.3.1 develop the presentation so that the final output is accurate and shows consistent use offormats

2.3.2 use layout appropriate to the types of information.