Gold INGOT

Open Systems and general knowledge

• I know that access to fully open systems is not dependent on permission from copyright or patent holders.
• I understand the term interoperability.
• I know the difference between open source and open standards.
• I understand the term intellectual property and I am familiar with the data protection act and the freedom of information act
• I know how copyright and licensing work together to protect intellectual property
• I understand the need for regular back ups and how backup strategies work.
• I know how to use a live CD to allow work to continue in an emergency
• I work safely and collaboratively with others at all times
• I understand the dangers of computer viruses and know how to reduce risk of infection

Producing documents

• I can set up and edit document templates.
• I can set up and edit styles within documents.
• I know how to layout text and graphics effectively.
• I can set up tables with a variety of styles.
• I can set up headers and footers with automatic page numbering.
• I can set up a table of contents and an index for a lengthy document.
• I can set up a mail merge to send out a circular to many people.
• I can change dictionaries and the language settings in the software.
• I can export my documents in pdf format for read only download from the Internet.

Graphic design

• I specify precise angles and distances to draw scale diagrams and plans with accuracy.
• I can group and ungroup objects to manage them effectively.
• I can use grid locking selectively to help improve the precision of my drawing.
• I can change the units and scales used in a drawing to suit particular tasks.
• I regularly illustrate my own work with my own designs.
• I can use 3D objects and lighting effects to make my drawing look more attractive.
• I can export and input drawings to and from other applications and I understand different graphics file formats and related issues.

Spreadsheets

• I can use a spreadsheet to set up a financial model and use it to look at a range of possible outcomes from different starting points.
• I can copy data and formulae using fixed references for rows columns and cells.
• I can use functions such as SUM, AVERAGE, MIN and MAX routinely.
• I can set up and edit styles for my spreadsheet.
• I can present a completed spreadsheet attractively so it prints appropriately and looks good on the screen.
• I can import and export data from my spreadsheet to other programs.
• I can define macros to automate several operations operations in a spreadsheet.

Producing documents

• I can set up and edit document templates.
• I can set up and edit styles within documents.
• I know how to layout text and graphics effectively.
• I can set up tables with a variety of styles.
• I can set up headers and footers with automatic page numbering.
• I can set up a table of contents and an index for a lengthy document.
• I can set up a mail merge to send out a circular to many people.
• I can change dictionaries and the language settings in the software.
• I can export my documents in pdf format for read only download from the Internet.

Graphic design

• I specify precise angles and distances to draw scale diagrams and plans with accuracy.
• I can group and ungroup objects to manage them effectively.
• I can use grid locking selectively to help improve the precision of my drawing.
• I can change the units and scales used in a drawing to suit particular tasks.
• I regularly illustrate my own work with my own designs.
• I can use 3D objects and lighting effects to make my drawing look more attractive.
• I can export and input drawings to and from other applications and I understand different graphics file formats and related issues.

Community Service

• I have set up a blog on the INGOT community site in order to document my project for presentation to a wide audience
• I have provided appropriate links to the NOS at level 2
• I have licensed my work appropriately to be used by others and made it available in downloadable files
• I can get the information I need from a range of sources in order to carry out my project
• I can select appropriate ICT tools and say why I used them
• My project provided useful resources or support for the Worldwide community supporting digital resources
• I have discussed my work with my assessor and indicated why it is intended to be of benefit to society
• I have evaluated my project saying how it might be improved by others and how it might be enhanced