https://wiki.openoffice.org/w/api.php?action=feedcontributions&user=Ggurley&feedformat=atomApache OpenOffice Wiki - User contributions [en]2024-03-29T15:45:54ZUser contributionsMediaWiki 1.23.13https://wiki.openoffice.org/wiki/Documentation/Dashboard/Who_is_WhoDocumentation/Dashboard/Who is Who2010-09-24T16:54:36Z<p>Ggurley: </p>
<hr />
<div>{{DISPLAYTITLE:Who is Who on the OOo Documentation Project}} <br />
This is a list of Documentation Project members. The purpose of this list is to give us an idea of who the various team members are. <br />
<br />
{| cellspacing="0" cellpadding="5" border="1" width="80%" style="border-color: rgb(51, 51, 51); border-collapse: collapse;" class="sortable"<br />
|- style="background-color: rgb(222, 222, 222);"<br />
! width="180" | Doc Project user name <br />
! width="150" | Name (optional) <br />
! width="150" | Location <ref>Do '''NOT''' enter home addresses or other personal information in the Location column. If you fill in this column, just enter the country you live in.</ref> <br />
! Comment<br />
|-<br />
| [[User:Ccornell|ccornell]] <br />
| Clayton <br />
| Germany <br />
| Doc Project co-lead; developer docs; [http://smaug42.wordpress.com personal blog]<br />
|-<br />
| [[User:Jeanweber|jeanweber]] <br />
| Jean <br />
| Australia <br />
| Doc Project co-lead; mainly user docs<br />
|-<br />
| [[User:Therabi|therabi]]<br />
| Andy<br />
| USA<br />
| User docs; helping users<br />
|-<br />
| [[User:Clairedwood|clairedwood]]<br />
| Claire<br />
| UK<br />
| Volunteer, mainly user docs & wiki<br />
|-<br />
| [[User:ggurley|ggurley]]<br />
| Gabriel<br />
| USA<br />
| Contributor, [http://wiki.services.openoffice.org/wiki/Documentation/OpenOffice.org_Conceptual_Guides Conceptual Guides] and User Guides; [http://gabrielgurley.com personal site]<br />
|-<br />
| <br />
| <br />
| <br />
| <br />
|-<br />
| <br />
| <br />
| <br />
| <br />
|-<br />
| <br />
| <br />
| <br />
| <br />
|-<br />
| <br />
| <br />
| <br />
| <br />
|-<br />
| <br />
| <br />
| <br />
| <br />
|}<br />
<references/><br />
<br />
[[Category:Documentation/Dashboard]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/6_ObjectivesCertificaton/6 Objectives2009-12-17T15:53:46Z<p>Ggurley: /* Level 3 */</p>
<hr />
<div>This is the ability to use Base to organise and store structured information and generate reports.<br />
<br />
'''Summary'''<br />
<br />
'''A. A foundation user can use basic database software tools and techniques to:'''<br />
<br />
*enter straightforward or routine information into Base<br />
*set up a single table in a flat file database;<br />
*retrieve information by running routine queries; and<br />
*produce reports using predefined menus or short cuts.<br />
<br />
The structure and functionality of the database will be predefined. Any aspects that are unfamiliar will require support and advice from others.<br />
<br />
'''Database tools and techniques will be described as ‘basic’ because:'''<br />
<br />
*the tools and functions will be predefined or commonly used; and<br />
*the techniques for inputting, manipulation and outputting will be straightforward or routine.<br />
<br />
'''B. An intermediate user can select and use intermediate database software tools and techniques to:'''<br />
<br />
*enter information into databases, that is at times non-routine or unfamiliar;<br />
*retrieve information by creating queries using multiple selection criteria; and<br />
*produce reports by setting up menus or short cuts.<br />
<br />
They will also be able to create and modify single table, non-relational databases. Any aspects that are unfamiliar may require support and advice from others.<br />
<br />
'''Database tools, functions and techniques will be described as ‘intermediate’ because:'''<br />
<br />
*the software tools and functions involved will at times be non-routine or unfamiliar; and<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements.<br />
<br />
'''C. An advanced user can select and use advanced database software tools and techniques efficiently to:'''<br />
<br />
*enter complex information into databases;<br />
*retrieve information by creating queries using multiple selection criteria; and<br />
*produce reports by setting up menus or short cuts.<br />
<br />
They will also be able to design, create and interrogate multiple-table relational databases.<br />
<br />
'''Database tools, functions and techniques will be described as ‘advanced’ because:'''<br />
<br />
*the software tools and functions involved will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying; and<br />
*the input, manipulation and output techniques involved will be complex, which will involve research, identification and application.<br />
<br />
<br />
==Level 1==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Enter, edit and organise structured information in a database''' <br />
<br />
To demonstrate this competence they can<br />
<br />
A1.1 Identify the main components of a database <br />
<br />
A1.2 Create a database table for a purpose using specified fields<br />
<br />
A1.3 Enter structured data into records to meet requirements<br />
<br />
A1.4 Locate and amend data records<br />
<br />
A1.5 Respond appropriately to data entry error messages<br />
<br />
A1.6 Check data meets needs, using IT tools and making corrections as necessary<br />
<br />
'''A2 Use database software tools to extract information and produce reports''' <br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Identify queries which meet information requirements<br />
<br />
A2.2 Run simple database queries<br />
<br />
A2.3 Identify reports which meet information requirements<br />
<br />
A2.4 Generate and print pre-defined database reports<br />
<br />
'''Content examples'''<br />
<br />
'''Database design''' What types of information are stored: tables, forms, queries, reports<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records; format; using help<br />
<br />
'''Amend data records''' Find, search and replace; edit record, sort, use wild cards<br />
<br />
'''Enter data''' Tables, fields, records. Use of data entry form; create new record; add record to table<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria<br />
<br />
'''Check database data''' Completeness, accuracy, security<br />
<br />
<br />
==Level 2==<br />
<br />
At level 1, the competent person will<br />
<br />
'''B1 Create and modify non-relational database tables''' <br />
<br />
To demonstrate this competence they can<br />
<br />
B1.1 Identify the components of a database design<br />
<br />
B1.2 Describe the properties for the required data fields <br />
<br />
B1.3 Create and modify database tables using a range of field types<br />
<br />
B1.4 Describe ways to maintain data integrity<br />
<br />
<span style="color:#FF0000;">B1.5 Respond appropriately to problems with database tables</span><br />
<br />
<span style="color:#FF0000;">B1.6 Use database tools and techniques to ensure data integrity is maintained</span><br />
<br />
'''B2 Enter, edit and organise structured information in a database'''<br />
<br />
B2.1 Create forms to enter, edit and organise data in a database<br />
<br />
<span style="color:#FF0000;">B2.2 Select and use appropriate tools and techniques to format data entry forms</span><br />
<br />
B2.3 Check data entry meets needs, using IT tools and making corrections as necessary<br />
<br />
<span style="color:#FF0000;">B2.4 Respond appropriately to data entry errors</span><br />
<br />
'''B3 Use database software tools to run queries and produce reports''' <br />
<br />
B3.1 Create and run database queries using multiple criteria to display or amend selected data<br />
<br />
B3.2 Plan and produce database reports from a single table non-relational database<br />
<br />
<span style="color:#FF0000;">B3.3 Select and use appropriate tools and techniques to format database reports</span><br />
<br />
B3.4 Check reports meet needs, using IT tools and making corrections as necessary<br />
<br />
'''Content examples'''<br />
<br />
'''Format database reports''' Data fields; page and section layout; add text or images; adjust page set up for printing<br />
<br />
'''Format data entry forms''' Field characteristics and layout, tables, colour, lookups<br />
<br />
'''Problems with database tables''' Security, redundant data, duplication, table structure, field characteristics and validation, sources of help<br />
<br />
'''Modify database table''' Add/amend/delete field; field characteristics<br />
<br />
'''Database design''' What types of information are stored, use of data entry form, routine queries, how data is structured in a single table non-relational database; use of indexes and key field to organise data<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records, format, using help; data that does not fit parameters, alerts, reminders; problems with forms<br />
<br />
'''Enter data''' Select and update fields, create new records, locate and amend records; using wildcards, search operators; error checking; data validation<br />
<br />
'''Data integrity''' Methods for maintaining integrity of existing data in a single table non-relational database, how field characteristics contribute to data validation<br />
<br />
'''Field characteristics''' Data type, field name, field size, field format<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria, multiple criteria<br />
<br />
'''Check database data''' Completeness, accuracy, security, spell checking, sorting, formatting, layout<br />
<br />
==Level 3==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Plan, create and modify relational database tables to meet requirements''' <br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Explain how a relational database design enables data to be organised and queried<br />
<br />
C1.2 Plan and create multiple tables for data entry with appropriate fields and properties<br />
<br />
C1.3 Set up and modify relationships between database tables<br />
<br />
C1.4 Explain why and how to maintain data integrity<br />
<br />
<span style="color:#FF0000;">C1.5 Respond appropriately to problems with database tables</span><br />
<br />
<span style="color:#FF0000;">C1.6 Use database tools and techniques to ensure data integrity is maintained</span><br />
<br />
'''C2 Enter, edit and organise structured information in a database'''<br />
<br />
C2.1 Design and create forms to access, enter, edit and organise data in a database<br />
<br />
<span style="color:#FF0000;">C2.2 Select and use appropriate tools and techniques to format data entry forms</span><br />
<br />
C2.3 Check data entry meets needs, using IT tools and making corrections as appropriate<br />
<br />
<span style="color:#FF0000;">C2.4 Respond appropriately to data entry errors</span><br />
<br />
'''C3 Use database software tools to create, edit and run data queries and produce reports'''<br />
<br />
C3.1 Explain how to select and generate information from queries according to requirements<br />
<br />
C3.2 Create and run database queries to display, amend or calculate selected data<br />
<br />
C3.3 Plan and produce database reports from a multiple-table relational database<br />
<br />
<span style="color:#FF0000;">C3.4 Select and use appropriate tools and techniques to format database reports</span><br />
<br />
C3.5 Check reports meet needs, using IT tools and making corrections as appropriate<br />
<br />
'''Content examples'''<br />
<br />
'''Format database reports''' Data fields; page and section layout; add text or images; adjust page setup for printing; styles<br />
<br />
'''Format data entry forms''' Field characteristics and layout, tables, colour, lookups, styles, subforms<br />
<br />
'''Problems with database tables''' Redundant data, duplication, table structure, field characteristics and validation; sources of help; access control, data type; indexing; analytical tools<br />
<br />
'''Database relationships''' One to one; one to many; many to many<br />
<br />
'''Database design''' What types of information are stored, use of data entry form, routine queries, how data is structured in a single table non-relational database, use of indexes and key field to organise data, how relationships are established in a multiple-table database, how data is structured in a multiple-table database, what logical operators are and how to use them; schema<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records; format; using help, error codes, troubleshooting; logging, reporting and dealing with application errors<br />
<br />
'''Enter data''' Select and update fields, create new records, locate and amend records; using wildcards, search operators; error checking; data validation; menus, sub-forms<br />
<br />
'''Data integrity''' Methods for maintaining integrity of existing data in a single table non-relational database, how field characteristics contribute to data validation, methods for maintaining integrity of data in a multiple table database<br />
<br />
'''Field characteristics''' Data type, field name, field size, field format, validation<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria, multiple criteria, update, append<br />
<br />
'''Check database data''' As for level 2<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/6_ObjectivesCertificaton/6 Objectives2009-12-17T15:52:06Z<p>Ggurley: /* Level 2 */</p>
<hr />
<div>This is the ability to use Base to organise and store structured information and generate reports.<br />
<br />
'''Summary'''<br />
<br />
'''A. A foundation user can use basic database software tools and techniques to:'''<br />
<br />
*enter straightforward or routine information into Base<br />
*set up a single table in a flat file database;<br />
*retrieve information by running routine queries; and<br />
*produce reports using predefined menus or short cuts.<br />
<br />
The structure and functionality of the database will be predefined. Any aspects that are unfamiliar will require support and advice from others.<br />
<br />
'''Database tools and techniques will be described as ‘basic’ because:'''<br />
<br />
*the tools and functions will be predefined or commonly used; and<br />
*the techniques for inputting, manipulation and outputting will be straightforward or routine.<br />
<br />
'''B. An intermediate user can select and use intermediate database software tools and techniques to:'''<br />
<br />
*enter information into databases, that is at times non-routine or unfamiliar;<br />
*retrieve information by creating queries using multiple selection criteria; and<br />
*produce reports by setting up menus or short cuts.<br />
<br />
They will also be able to create and modify single table, non-relational databases. Any aspects that are unfamiliar may require support and advice from others.<br />
<br />
'''Database tools, functions and techniques will be described as ‘intermediate’ because:'''<br />
<br />
*the software tools and functions involved will at times be non-routine or unfamiliar; and<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements.<br />
<br />
'''C. An advanced user can select and use advanced database software tools and techniques efficiently to:'''<br />
<br />
*enter complex information into databases;<br />
*retrieve information by creating queries using multiple selection criteria; and<br />
*produce reports by setting up menus or short cuts.<br />
<br />
They will also be able to design, create and interrogate multiple-table relational databases.<br />
<br />
'''Database tools, functions and techniques will be described as ‘advanced’ because:'''<br />
<br />
*the software tools and functions involved will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying; and<br />
*the input, manipulation and output techniques involved will be complex, which will involve research, identification and application.<br />
<br />
<br />
==Level 1==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Enter, edit and organise structured information in a database''' <br />
<br />
To demonstrate this competence they can<br />
<br />
A1.1 Identify the main components of a database <br />
<br />
A1.2 Create a database table for a purpose using specified fields<br />
<br />
A1.3 Enter structured data into records to meet requirements<br />
<br />
A1.4 Locate and amend data records<br />
<br />
A1.5 Respond appropriately to data entry error messages<br />
<br />
A1.6 Check data meets needs, using IT tools and making corrections as necessary<br />
<br />
'''A2 Use database software tools to extract information and produce reports''' <br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Identify queries which meet information requirements<br />
<br />
A2.2 Run simple database queries<br />
<br />
A2.3 Identify reports which meet information requirements<br />
<br />
A2.4 Generate and print pre-defined database reports<br />
<br />
'''Content examples'''<br />
<br />
'''Database design''' What types of information are stored: tables, forms, queries, reports<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records; format; using help<br />
<br />
'''Amend data records''' Find, search and replace; edit record, sort, use wild cards<br />
<br />
'''Enter data''' Tables, fields, records. Use of data entry form; create new record; add record to table<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria<br />
<br />
'''Check database data''' Completeness, accuracy, security<br />
<br />
<br />
==Level 2==<br />
<br />
At level 1, the competent person will<br />
<br />
'''B1 Create and modify non-relational database tables''' <br />
<br />
To demonstrate this competence they can<br />
<br />
B1.1 Identify the components of a database design<br />
<br />
B1.2 Describe the properties for the required data fields <br />
<br />
B1.3 Create and modify database tables using a range of field types<br />
<br />
B1.4 Describe ways to maintain data integrity<br />
<br />
<span style="color:#FF0000;">B1.5 Respond appropriately to problems with database tables</span><br />
<br />
<span style="color:#FF0000;">B1.6 Use database tools and techniques to ensure data integrity is maintained</span><br />
<br />
'''B2 Enter, edit and organise structured information in a database'''<br />
<br />
B2.1 Create forms to enter, edit and organise data in a database<br />
<br />
<span style="color:#FF0000;">B2.2 Select and use appropriate tools and techniques to format data entry forms</span><br />
<br />
B2.3 Check data entry meets needs, using IT tools and making corrections as necessary<br />
<br />
<span style="color:#FF0000;">B2.4 Respond appropriately to data entry errors</span><br />
<br />
'''B3 Use database software tools to run queries and produce reports''' <br />
<br />
B3.1 Create and run database queries using multiple criteria to display or amend selected data<br />
<br />
B3.2 Plan and produce database reports from a single table non-relational database<br />
<br />
<span style="color:#FF0000;">B3.3 Select and use appropriate tools and techniques to format database reports</span><br />
<br />
B3.4 Check reports meet needs, using IT tools and making corrections as necessary<br />
<br />
'''Content examples'''<br />
<br />
'''Format database reports''' Data fields; page and section layout; add text or images; adjust page set up for printing<br />
<br />
'''Format data entry forms''' Field characteristics and layout, tables, colour, lookups<br />
<br />
'''Problems with database tables''' Security, redundant data, duplication, table structure, field characteristics and validation, sources of help<br />
<br />
'''Modify database table''' Add/amend/delete field; field characteristics<br />
<br />
'''Database design''' What types of information are stored, use of data entry form, routine queries, how data is structured in a single table non-relational database; use of indexes and key field to organise data<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records, format, using help; data that does not fit parameters, alerts, reminders; problems with forms<br />
<br />
'''Enter data''' Select and update fields, create new records, locate and amend records; using wildcards, search operators; error checking; data validation<br />
<br />
'''Data integrity''' Methods for maintaining integrity of existing data in a single table non-relational database, how field characteristics contribute to data validation<br />
<br />
'''Field characteristics''' Data type, field name, field size, field format<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria, multiple criteria<br />
<br />
'''Check database data''' Completeness, accuracy, security, spell checking, sorting, formatting, layout<br />
<br />
==Level 3==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Plan, create and modify relational database tables to meet requirements''' <br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Explain how a relational database design enables data to be organised and queried<br />
<br />
C1.2 Plan and create multiple tables for data entry with appropriate fields and properties<br />
<br />
C1.3 Set up and modify relationships between database tables<br />
<br />
C1.4 Explain why and how to maintain data integrity<br />
<br />
C1.5 Respond appropriately to problems with database tables<br />
<br />
C1.6 Use database tools and techniques to ensure data integrity is maintained<br />
<br />
'''C2 Enter, edit and organise structured information in a database'''<br />
<br />
C2.1 Design and create forms to access, enter, edit and organise data in a database<br />
<br />
C2.2 Select and use appropriate tools and techniques to format data entry forms<br />
<br />
C2.3 Check data entry meets needs, using IT tools and making corrections as appropriate<br />
<br />
C2.4 Respond appropriately to data entry errors<br />
<br />
'''C3 Use database software tools to create, edit and run data queries and produce reports'''<br />
<br />
C3.1 Explain how to select and generate information from queries according to requirements<br />
<br />
C3.2 Create and run database queries to display, amend or calculate selected data<br />
<br />
C3.3 Plan and produce database reports from a multiple-table relational database<br />
<br />
C3.4 Select and use appropriate tools and techniques to format database reports<br />
<br />
C3.5 Check reports meet needs, using IT tools and making corrections as appropriate<br />
<br />
'''Content examples'''<br />
<br />
'''Format database reports''' Data fields; page and section layout; add text or images; adjust page setup for printing; styles<br />
<br />
'''Format data entry forms''' Field characteristics and layout, tables, colour, lookups, styles, subforms<br />
<br />
'''Problems with database tables''' Redundant data, duplication, table structure, field characteristics and validation; sources of help; access control, data type; indexing; analytical tools<br />
<br />
'''Database relationships''' One to one; one to many; many to many<br />
<br />
'''Database design''' What types of information are stored, use of data entry form, routine queries, how data is structured in a single table non-relational database, use of indexes and key field to organise data, how relationships are established in a multiple-table database, how data is structured in a multiple-table database, what logical operators are and how to use them; schema<br />
<br />
'''Data entry errors''' Due to field size, data type, validation checks; duplicate records; format; using help, error codes, troubleshooting; logging, reporting and dealing with application errors<br />
<br />
'''Enter data''' Select and update fields, create new records, locate and amend records; using wildcards, search operators; error checking; data validation; menus, sub-forms<br />
<br />
'''Data integrity''' Methods for maintaining integrity of existing data in a single table non-relational database, how field characteristics contribute to data validation, methods for maintaining integrity of data in a multiple table database<br />
<br />
'''Field characteristics''' Data type, field name, field size, field format, validation<br />
<br />
'''Database reports''' Using menus or short cuts<br />
<br />
'''Database queries''' Alphanumeric sort, filter, single criteria, multiple criteria, update, append<br />
<br />
'''Check database data''' As for level 2<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/5_ObjectivesCertificaton/5 Objectives2009-12-17T15:50:06Z<p>Ggurley: /* Level 3 */</p>
<hr />
<div>This is the ability to use Draw to produce 2D drawings and plans, such as flowcharts, mindmaps and technical drawings.<br />
<br />
'''Summary'''<br />
<br />
'''A. The Level 1 user can select and use basic tools and techniques to produce straightforward or routine drawings and plans. Any aspects that are unfamiliar will require support and advice.''' <br />
<br />
2D drawing and planning software tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine<br />
<br />
'''B. The intermediate user can select and use intermediate tools and techniques to produce drawings and plans that are at times multi-step or non-routine. Any aspects that are unfamiliar may require support and advice.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. The advanced user can select and use advanced tools and techniques to produce complex and non-routine drawings and plans.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
==Level 1==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input, organise and combine information for drawings or plans'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A1.1 Identify what types of 2D shapes and other elements will be needed<br />
<br />
A1.2 Identify which template or blank document to use<br />
<br />
A1.3 Select the appropriate groups of shapes, from those available, to meet needs<br />
<br />
A1.4 Input the relevant shapes and other elements into existing templates or blank documents so that they are ready for editing and formatting<br />
<br />
<span style="color:#FF0000;">A1.5 Identify what copyright constraints apply to the use of shapes or other elements</span><br />
<br />
A1.6 Combine information of different types or from different sources for drawings and plans<br />
<br />
A1.7 Store and retrieve drawing files effectively, in-line with local guidelines and conventions where available<br />
<br />
'''A2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned</span><br />
<br />
<span style="color:#FF0000;">A2.2 Use appropriate software tools to manipulate and edit shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.3 Select and use appropriate software tools to format shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
<span style="color:#FF0000;">A2.5 Select and use presentation methods and accepted page layouts</span><br />
<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, number<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates (eg fax, letter, web page) and tables, working from an example<br />
<br />
==Level 2==<br />
<br />
At level 2, the competent person will<br />
<br />
To demonstrate this competence they can<br />
<br />
'''B1 Input, organise and combine information for drawings or plans'''<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of shapes and other elements will be needed</span><br />
<br />
B1.2 Review templates and describe how they need to be changed to meet needs<br />
<br />
B1.3 Select, input and use the appropriate shapes to meet needs, including importing shapes from other sources<br />
<br />
B1.4 Select, adapt and use appropriate templates or blank documents<br />
<br />
<span style="color:#FF0000;">B1.5 Identify what copyright constraints apply to the use of shapes or other elements</span><br />
<br />
B1.6 Combine information for drawings or plans including importing information produced using other software<br />
<br />
<span style="color:#FF0000;">B1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''B2 Use tools and techniques to edit, manipulate, format and present drawings or plans''' <br />
<br />
<span style="color:#FF0000;">B2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned </span><br />
<br />
<span style="color:#FF0000;">B2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision</span><br />
<br />
<span style="color:#FF0000;">B2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes</span><br />
<br />
B2.4 Check drawings or plans meet needs, using IT tools and making corrections as appropriate<br />
<br />
B2.5 Identify and respond to any quality problems with drawings or plans to make sure they meet needs<br />
<br />
B2.6 Select and use appropriate presentation methods and accepted page layouts<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation), other elements (eg scale, thickness, colour, connections), page layout<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
==Level 3==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input, organise and combine information for drawings and plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">C1.1 Identify what types of shapes and other elements will be needed</span><br />
<br />
C1.2 Evaluate templates and explain why and how they need to be changed to meet needs<br />
<br />
C1.3 Select, adapt, create and use the appropriate shapes to meet needs, including shapes imported from other sources<br />
<br />
C1.4 Select, adapt, define and create appropriate templates and styles to meet needs<br />
<br />
C1.5 Provide guidance on what copyright constraints apply to the use of own and others’ shapes or other elements<br />
<br />
C1.6 Combine information for drawings or plans including exporting outcomes to other software<br />
<br />
<span style="color:#FF0000;">C1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''C2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
C2.1 Explain what drafting guides to use so that the shapes and other elements are appropriately positioned <br />
<br />
<span style="color:#FF0000;">C2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision</span><br />
<br />
<span style="color:#FF0000;">C2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes</span><br />
<br />
<span style="color:#FF0000;">C2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
C2.5 Identify and respond to quality problems with drawings and plans to make sure that they are fit for purpose and meet needs<br />
<br />
C2.6 Explain what context the drawings and plans will be used in and how this will effect how they are presented<br />
<br />
<span style="color:#FF0000;">C2.7 Select and use presentation methods and accepted page layouts</span><br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation, unwanted content), other elements (eg scale, thickness, colour, connections), page layout, proportion, balance, symmetry<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example:Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, grammar check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/5_ObjectivesCertificaton/5 Objectives2009-12-17T15:48:21Z<p>Ggurley: /* Level 2 */</p>
<hr />
<div>This is the ability to use Draw to produce 2D drawings and plans, such as flowcharts, mindmaps and technical drawings.<br />
<br />
'''Summary'''<br />
<br />
'''A. The Level 1 user can select and use basic tools and techniques to produce straightforward or routine drawings and plans. Any aspects that are unfamiliar will require support and advice.''' <br />
<br />
2D drawing and planning software tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine<br />
<br />
'''B. The intermediate user can select and use intermediate tools and techniques to produce drawings and plans that are at times multi-step or non-routine. Any aspects that are unfamiliar may require support and advice.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. The advanced user can select and use advanced tools and techniques to produce complex and non-routine drawings and plans.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
==Level 1==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input, organise and combine information for drawings or plans'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A1.1 Identify what types of 2D shapes and other elements will be needed<br />
<br />
A1.2 Identify which template or blank document to use<br />
<br />
A1.3 Select the appropriate groups of shapes, from those available, to meet needs<br />
<br />
A1.4 Input the relevant shapes and other elements into existing templates or blank documents so that they are ready for editing and formatting<br />
<br />
<span style="color:#FF0000;">A1.5 Identify what copyright constraints apply to the use of shapes or other elements</span><br />
<br />
A1.6 Combine information of different types or from different sources for drawings and plans<br />
<br />
A1.7 Store and retrieve drawing files effectively, in-line with local guidelines and conventions where available<br />
<br />
'''A2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned</span><br />
<br />
<span style="color:#FF0000;">A2.2 Use appropriate software tools to manipulate and edit shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.3 Select and use appropriate software tools to format shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
<span style="color:#FF0000;">A2.5 Select and use presentation methods and accepted page layouts</span><br />
<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, number<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates (eg fax, letter, web page) and tables, working from an example<br />
<br />
==Level 2==<br />
<br />
At level 2, the competent person will<br />
<br />
To demonstrate this competence they can<br />
<br />
'''B1 Input, organise and combine information for drawings or plans'''<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of shapes and other elements will be needed</span><br />
<br />
B1.2 Review templates and describe how they need to be changed to meet needs<br />
<br />
B1.3 Select, input and use the appropriate shapes to meet needs, including importing shapes from other sources<br />
<br />
B1.4 Select, adapt and use appropriate templates or blank documents<br />
<br />
<span style="color:#FF0000;">B1.5 Identify what copyright constraints apply to the use of shapes or other elements</span><br />
<br />
B1.6 Combine information for drawings or plans including importing information produced using other software<br />
<br />
<span style="color:#FF0000;">B1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''B2 Use tools and techniques to edit, manipulate, format and present drawings or plans''' <br />
<br />
<span style="color:#FF0000;">B2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned </span><br />
<br />
<span style="color:#FF0000;">B2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision</span><br />
<br />
<span style="color:#FF0000;">B2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes</span><br />
<br />
B2.4 Check drawings or plans meet needs, using IT tools and making corrections as appropriate<br />
<br />
B2.5 Identify and respond to any quality problems with drawings or plans to make sure they meet needs<br />
<br />
B2.6 Select and use appropriate presentation methods and accepted page layouts<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation), other elements (eg scale, thickness, colour, connections), page layout<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
==Level 3==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input, organise and combine information for drawings and plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Identify what types of shapes and other elements will be needed<br />
<br />
C1.2 Evaluate templates and explain why and how they need to be changed to meet needs<br />
<br />
C1.3 Select, adapt, create and use the appropriate shapes to meet needs, including shapes imported from other sources<br />
<br />
C1.4 Select, adapt, define and create appropriate templates and styles to meet needs<br />
<br />
C1.5 Provide guidance on what copyright constraints apply to the use of own and others’ shapes or other elements<br />
<br />
C1.6 Combine information for drawings or plans including exporting outcomes to other software<br />
<br />
C1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available<br />
<br />
'''C2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
C2.1 Explain what drafting guides to use so that the shapes and other elements are appropriately positioned <br />
<br />
C2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision<br />
<br />
C2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes<br />
<br />
C2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate<br />
<br />
C2.5 Identify and respond to quality problems with drawings and plans to make sure that they are fit for purpose and meet needs<br />
<br />
C2.6 Explain what context the drawings and plans will be used in and how this will effect how they are presented<br />
<br />
C2.7 Select and use presentation methods and accepted page layouts<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation, unwanted content), other elements (eg scale, thickness, colour, connections), page layout, proportion, balance, symmetry<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example:Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, grammar check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/5_ObjectivesCertificaton/5 Objectives2009-12-17T15:46:21Z<p>Ggurley: /* Level 1 */</p>
<hr />
<div>This is the ability to use Draw to produce 2D drawings and plans, such as flowcharts, mindmaps and technical drawings.<br />
<br />
'''Summary'''<br />
<br />
'''A. The Level 1 user can select and use basic tools and techniques to produce straightforward or routine drawings and plans. Any aspects that are unfamiliar will require support and advice.''' <br />
<br />
2D drawing and planning software tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine<br />
<br />
'''B. The intermediate user can select and use intermediate tools and techniques to produce drawings and plans that are at times multi-step or non-routine. Any aspects that are unfamiliar may require support and advice.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. The advanced user can select and use advanced tools and techniques to produce complex and non-routine drawings and plans.'''<br />
<br />
2D drawing and planning software tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
==Level 1==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input, organise and combine information for drawings or plans'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A1.1 Identify what types of 2D shapes and other elements will be needed<br />
<br />
A1.2 Identify which template or blank document to use<br />
<br />
A1.3 Select the appropriate groups of shapes, from those available, to meet needs<br />
<br />
A1.4 Input the relevant shapes and other elements into existing templates or blank documents so that they are ready for editing and formatting<br />
<br />
<span style="color:#FF0000;">A1.5 Identify what copyright constraints apply to the use of shapes or other elements</span><br />
<br />
A1.6 Combine information of different types or from different sources for drawings and plans<br />
<br />
A1.7 Store and retrieve drawing files effectively, in-line with local guidelines and conventions where available<br />
<br />
'''A2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned</span><br />
<br />
<span style="color:#FF0000;">A2.2 Use appropriate software tools to manipulate and edit shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.3 Select and use appropriate software tools to format shapes and other elements</span><br />
<br />
<span style="color:#FF0000;">A2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
<span style="color:#FF0000;">A2.5 Select and use presentation methods and accepted page layouts</span><br />
<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, number<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates (eg fax, letter, web page) and tables, working from an example<br />
<br />
==Level 2==<br />
<br />
At level 2, the competent person will<br />
<br />
To demonstrate this competence they can<br />
<br />
'''B1 Input, organise and combine information for drawings or plans'''<br />
<br />
B1.1 Identify what types of shapes and other elements will be needed<br />
<br />
B1.2 Review templates and describe how they need to be changed to meet needs<br />
<br />
B1.3 Select, input and use the appropriate shapes to meet needs, including importing shapes from other sources<br />
<br />
B1.4 Select, adapt and use appropriate templates or blank documents<br />
<br />
B1.5 Identify what copyright constraints apply to the use of shapes or other elements<br />
<br />
B1.6 Combine information for drawings or plans including importing information produced using other software<br />
<br />
B1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available<br />
<br />
'''B2 Use tools and techniques to edit, manipulate, format and present drawings or plans''' <br />
<br />
B2.1 Identify what drafting guides to use so that the shapes and other elements are appropriately positioned <br />
<br />
B2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision<br />
<br />
B2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes<br />
<br />
B2.4 Check drawings or plans meet needs, using IT tools and making corrections as appropriate<br />
<br />
B2.5 Identify and respond to any quality problems with drawings or plans to make sure they meet needs<br />
<br />
B2.6 Select and use appropriate presentation methods and accepted page layouts<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation), other elements (eg scale, thickness, colour, connections), page layout<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example: Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg downloads of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Inputting information''' Inputting tools and techniques will vary according to the technology being used: for example, interface devices (eg keyboard, mouse, stylus, touch screen), microphone (eg headset, built-in), camera (eg web cam, video camera, mobile phone camera)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
==Level 3==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input, organise and combine information for drawings and plans '''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Identify what types of shapes and other elements will be needed<br />
<br />
C1.2 Evaluate templates and explain why and how they need to be changed to meet needs<br />
<br />
C1.3 Select, adapt, create and use the appropriate shapes to meet needs, including shapes imported from other sources<br />
<br />
C1.4 Select, adapt, define and create appropriate templates and styles to meet needs<br />
<br />
C1.5 Provide guidance on what copyright constraints apply to the use of own and others’ shapes or other elements<br />
<br />
C1.6 Combine information for drawings or plans including exporting outcomes to other software<br />
<br />
C1.7 Store and retrieve drawing files effectively, in line with local guidelines and conventions where available<br />
<br />
'''C2 Use tools and techniques to edit, manipulate, format and present drawings or plans '''<br />
<br />
C2.1 Explain what drafting guides to use so that the shapes and other elements are appropriately positioned <br />
<br />
C2.2 Select and use appropriate software tools to manipulate and edit shapes and other elements with precision<br />
<br />
C2.3 Select and use appropriate software tools to format shapes and other elements, including applying styles and colour schemes<br />
<br />
C2.4 Check drawings and plans meet needs, using IT tools and making corrections as appropriate<br />
<br />
C2.5 Identify and respond to quality problems with drawings and plans to make sure that they are fit for purpose and meet needs<br />
<br />
C2.6 Explain what context the drawings and plans will be used in and how this will effect how they are presented<br />
<br />
C2.7 Select and use presentation methods and accepted page layouts<br />
<br />
'''Content examples'''<br />
<br />
'''Drafting guides''' Grids, snap to grid, snap to shape, rulers, guidelines<br />
<br />
'''Quality problems with drawings or plans''' Will vary according to the content, for example, text (eg formatting, styles, positioning), shapes (eg size, position, orientation, unwanted content), other elements (eg scale, thickness, colour, connections), page layout, proportion, balance, symmetry<br />
<br />
'''Format shapes and other elements''' Will vary, for example: text (eg font, paragraphs, text block, tabs, bullets), lines (eg width, length, colour, endings, beginnings), drawing elements (eg fill, shadow, corners), connections between shapes and other elements. Protection: length, width, axis; Behviour: interaction, selection highlighting<br />
<br />
'''Manipulate and edit shapes and other elements''' Will vary, for example:Edit: select, insert, delete, cut, copy, paste, drag and drop, find, replace Text: font, colour, alignment Shapes: size, colour, orientation, connections to other shapes and elements, add labels<br />
<br />
'''Check drawings or plans''' Spell check, grammar check, accuracy of numbers, labelling and size of shapes, connections between shapes and other elements<br />
<br />
'''Shapes and other elements''' Shapes will vary according to the required outcome, for example: flow chart shapes, building plan shapes, audit. Other elements: graphic elements (eg lines, arrows, borders, backgrounds, clip art), text, numbers<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation methods''' Methods will vary according to the software and task, for example, on screen display, publishing on a web site, hard copy print out, digital file<br />
<br />
'''Combining information techniques''' Insert, size, position, wrap, order, group<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/4_ObjectivesCertificaton/4 Objectives2009-12-17T15:41:38Z<p>Ggurley: /* Level 3 */</p>
<hr />
<div>The objective is to certify the ability to use Impress to produce presentations, which include a combination of media (eg photos from digital cameras, animation and sound) for education, entertainment or information sharing.<br />
<br />
'''Summary'''<br />
<br />
'''A. Level 1''' A level 1 user can use a range of basic Impress tools and techniques to produce straightforward or routine presentations. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
Presentation tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine.<br />
<br />
'''B. Level 2''' A level 2 user can select and use a wide range of Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. Level 3''' An level 3 user can select and use a wide range of advanced Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
== Level 1 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are required for the presentation</span><br />
<br />
A1.2 Select and use different slide layouts as appropriate for different types of information<br />
<br />
A1.3 Enter information into presentation slides so that it is ready for editing and formatting<br />
<br />
A1.4 Identify copyright or other constraints on using other people's information<br />
<br />
<span style="color:#FF0000;">A1.5 Combine information of different forms or from different sources for presentations</span><br />
<br />
<span style="color:#FF0000;">A1.6 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''A2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Identify what slide template to use<br />
<br />
A2.2 Select and use an appropriate template to structure slides<br />
<br />
A2.3 Select and use appropriate tools and techniques to edit slides<br />
<br />
A2.4 Select and use appropriate tools and techniques to format slides<br />
<br />
'''A3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A3.3 Check presentation meets needs, using IT tools and making corrections as appropriate<br />
A3.1 Identify how to present slides to meet needs and communicate effectively<br />
<br />
<br />
'''Content examples'''<br />
<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Prepare and present slides''' View, re-order, rehearse timing, present slide show<br />
<br />
'''Check slides''' Orientation, layout, slide order, text alignment and formatting<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text, add lines and simple shapes<br />
<br />
'''Presentation slide structure''' Layout; use existing templates, designs and styles; organisational guidelines<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
== Level 2 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''B1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of information are required for the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.2 Enter text and other information using layouts appropriate to type of information</span><br />
<br />
B1.3 Insert charts and tables into presentation slides<br />
<br />
<span style="color:#FF0000;">B1.4 Insert images, video or sound to enhance the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.5 Identify any copyright or other constraints which may affect the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.6 Organise and combine information of different forms or from different sources for presentations</span><br />
<br />
B1.7 Store and retrieve presentation files effectively, in-line with local guidelines and conventions where available<br />
<br />
<br />
'''B2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B2.1 Identify what slide structure and theme to use<br />
<br />
B2.2 Select, change and use an appropriate structure for slides<br />
<br />
B2.3 Select and use appropriate techniques to edit slides and presentations to meet needs<br />
<br />
B2.4 Select and use appropriate techniques to format slides and presentations<br />
<br />
B2.5 Identify what presentation effects to use to enhance the presentation<br />
<br />
B2.6 Select and use animation and transition effects appropriately to enhance slide sequences<br />
<br />
'''B3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B3.1 Describe how to present slides to meet needs and communicate effectively <br />
<br />
B3.2 Prepare a slide show for presentation<br />
<br />
<span style="color:#FF0000;">B3.3 Check presentation meets needs, using IT tools and making corrections as necessary</span><br />
<br />
B3.4 Identify and respond to any quality problems with presentations to ensure that presentations meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles Images: Size, position, orientation Effects: Timing, brightness, contrast, sound levels, order of effects and animations<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Presentation effects''' Video, sound, animation, slide transitions, visual and sound effects, hyper-links<br />
<br />
'''Prepare and present slides''' View and re-order slides; rehearse timing and effects; present slide show through a computer live; save presentation as a stand alone show or as web pages<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyper-links and action buttons<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text; add lines and simple shapes; change orientation<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video, import information produced using other software, reference external information with hyper-links, object linking or embedding<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
== Level 3 ==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Explain what types of information are required for the presentation<br />
<br />
<span style="color:#FF0000;">C1.2 Enter text and other information using layouts appropriate to type of information</span><br />
<br />
C1.3 Insert charts and tables and link to source data<br />
<br />
<span style="color:#FF0000;">C1.4 Insert images, video or sound to enhance the presentation</span><br />
<br />
<span style="color:#FF0000;">C1.5 Identify any copyright or other constraints which may affect the presentation</span><br />
<br />
C1.6 Organise and combine information for presentations<br />
<br />
<span style="color:#FF0000;">C1.7 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available</span><br />
<br />
<br />
<br />
'''C2 Use presentation software tools to structure, edit and format presentations'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Explain when and how to use and change slide structure and themes to enhance presentations<br />
<br />
C2.2 Create, amend and use appropriate templates and themes for slides<br />
<br />
C2.3 Explain how interactive and presentation effects can be used to aid meaning or impact<br />
<br />
C2.4 Select and use appropriate techniques to edit and format presentations to meet needs<br />
<br />
C2.5 Create and use interactive elements to enhance presentations<br />
<br />
C2.6 Select and use animation and transition techniques appropriately to enhance presentations<br />
<br />
<br />
'''C3 Prepare slides for presentation'''<br />
<br />
C3.1 Explain how to present slides to communicate effectively for different contexts<br />
<br />
C3.2 Prepare slides for presentation<br />
<br />
<span style="color:#FF0000;">C3.3 Check presentation meets needs, using IT tools and making corrections as necessary</span><br />
<br />
C3.5 Respond appropriately to quality problems to ensure that presentations meet needs and are fit for purpose<br />
<br />
C3.4 Evaluate presentations, identify any quality problems and discuss how to respond to them<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location, contexts<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles, structure Images: Size, position, orientation, unwanted content Effects: Timing, brightness, contrast, sound levels, order of effects and animations, action buttons that do not work, sound clip out of sync<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation effects''' As for level 2<br />
<br />
'''Prepare and present slides''' As for level 2<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes, apply and create transitions, apply animations<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyperlinks and action buttons<br />
<br />
'''Editing techniques for presentation slides''' As for level 2<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' As for level 2<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/4_ObjectivesCertificaton/4 Objectives2009-12-17T15:38:29Z<p>Ggurley: /* Level 2 */</p>
<hr />
<div>The objective is to certify the ability to use Impress to produce presentations, which include a combination of media (eg photos from digital cameras, animation and sound) for education, entertainment or information sharing.<br />
<br />
'''Summary'''<br />
<br />
'''A. Level 1''' A level 1 user can use a range of basic Impress tools and techniques to produce straightforward or routine presentations. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
Presentation tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine.<br />
<br />
'''B. Level 2''' A level 2 user can select and use a wide range of Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. Level 3''' An level 3 user can select and use a wide range of advanced Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
== Level 1 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are required for the presentation</span><br />
<br />
A1.2 Select and use different slide layouts as appropriate for different types of information<br />
<br />
A1.3 Enter information into presentation slides so that it is ready for editing and formatting<br />
<br />
A1.4 Identify copyright or other constraints on using other people's information<br />
<br />
<span style="color:#FF0000;">A1.5 Combine information of different forms or from different sources for presentations</span><br />
<br />
<span style="color:#FF0000;">A1.6 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''A2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Identify what slide template to use<br />
<br />
A2.2 Select and use an appropriate template to structure slides<br />
<br />
A2.3 Select and use appropriate tools and techniques to edit slides<br />
<br />
A2.4 Select and use appropriate tools and techniques to format slides<br />
<br />
'''A3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A3.3 Check presentation meets needs, using IT tools and making corrections as appropriate<br />
A3.1 Identify how to present slides to meet needs and communicate effectively<br />
<br />
<br />
'''Content examples'''<br />
<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Prepare and present slides''' View, re-order, rehearse timing, present slide show<br />
<br />
'''Check slides''' Orientation, layout, slide order, text alignment and formatting<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text, add lines and simple shapes<br />
<br />
'''Presentation slide structure''' Layout; use existing templates, designs and styles; organisational guidelines<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
== Level 2 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''B1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of information are required for the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.2 Enter text and other information using layouts appropriate to type of information</span><br />
<br />
B1.3 Insert charts and tables into presentation slides<br />
<br />
<span style="color:#FF0000;">B1.4 Insert images, video or sound to enhance the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.5 Identify any copyright or other constraints which may affect the presentation</span><br />
<br />
<span style="color:#FF0000;">B1.6 Organise and combine information of different forms or from different sources for presentations</span><br />
<br />
B1.7 Store and retrieve presentation files effectively, in-line with local guidelines and conventions where available<br />
<br />
<br />
'''B2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B2.1 Identify what slide structure and theme to use<br />
<br />
B2.2 Select, change and use an appropriate structure for slides<br />
<br />
B2.3 Select and use appropriate techniques to edit slides and presentations to meet needs<br />
<br />
B2.4 Select and use appropriate techniques to format slides and presentations<br />
<br />
B2.5 Identify what presentation effects to use to enhance the presentation<br />
<br />
B2.6 Select and use animation and transition effects appropriately to enhance slide sequences<br />
<br />
'''B3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B3.1 Describe how to present slides to meet needs and communicate effectively <br />
<br />
B3.2 Prepare a slide show for presentation<br />
<br />
<span style="color:#FF0000;">B3.3 Check presentation meets needs, using IT tools and making corrections as necessary</span><br />
<br />
B3.4 Identify and respond to any quality problems with presentations to ensure that presentations meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles Images: Size, position, orientation Effects: Timing, brightness, contrast, sound levels, order of effects and animations<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Presentation effects''' Video, sound, animation, slide transitions, visual and sound effects, hyper-links<br />
<br />
'''Prepare and present slides''' View and re-order slides; rehearse timing and effects; present slide show through a computer live; save presentation as a stand alone show or as web pages<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyper-links and action buttons<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text; add lines and simple shapes; change orientation<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video, import information produced using other software, reference external information with hyper-links, object linking or embedding<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
== Level 3 ==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Explain what types of information are required for the presentation<br />
<br />
C1.2 Enter text and other information using layouts appropriate to type of information<br />
<br />
C1.3 Insert charts and tables and link to source data<br />
<br />
C1.4 Insert images, video or sound to enhance the presentation<br />
<br />
C1.6 Organise and combine information for presentations<br />
<br />
C1.7 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available<br />
<br />
C1.5 Identify any copyright or other constraints which may affect the presentation<br />
<br />
<br />
'''C2 Use presentation software tools to structure, edit and format presentations'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Explain when and how to use and change slide structure and themes to enhance presentations<br />
<br />
C2.2 Create, amend and use appropriate templates and themes for slides<br />
<br />
C2.3 Explain how interactive and presentation effects can be used to aid meaning or impact<br />
<br />
C2.4 Select and use appropriate techniques to edit and format presentations to meet needs<br />
<br />
C2.5 Create and use interactive elements to enhance presentations<br />
<br />
C2.6 Select and use animation and transition techniques appropriately to enhance presentations<br />
<br />
<br />
'''C3 Prepare slides for presentation'''<br />
<br />
C3.1 Explain how to present slides to communicate effectively for different contexts<br />
<br />
C3.2 Prepare slides for presentation<br />
<br />
C3.3 Check presentation meets needs, using IT tools and making corrections as necessary<br />
<br />
C3.5 Respond appropriately to quality problems to ensure that presentations meet needs and are fit for purpose<br />
<br />
C3.4 Evaluate presentations, identify any quality problems and discuss how to respond to them<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location, contexts<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles, structure Images: Size, position, orientation, unwanted content Effects: Timing, brightness, contrast, sound levels, order of effects and animations, action buttons that do not work, sound clip out of sync<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation effects''' As for level 2<br />
<br />
'''Prepare and present slides''' As for level 2<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes, apply and create transitions, apply animations<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyperlinks and action buttons<br />
<br />
'''Editing techniques for presentation slides''' As for level 2<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' As for level 2<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/4_ObjectivesCertificaton/4 Objectives2009-12-17T15:36:26Z<p>Ggurley: /* Level 1 */</p>
<hr />
<div>The objective is to certify the ability to use Impress to produce presentations, which include a combination of media (eg photos from digital cameras, animation and sound) for education, entertainment or information sharing.<br />
<br />
'''Summary'''<br />
<br />
'''A. Level 1''' A level 1 user can use a range of basic Impress tools and techniques to produce straightforward or routine presentations. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
Presentation tools and techniques will described as ‘basic’ because:<br />
<br />
*the software tools and functions will be predefined or commonly used;<br />
*the range of entry, manipulation and outputting techniques will be straightforward or routine; and<br />
*the inputting, manipulating and outputting of the information will be predetermined, straightforward or routine.<br />
<br />
'''B. Level 2''' A level 2 user can select and use a wide range of Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘intermediate’ because:<br />
<br />
*the software tools and functions used will be multi-step and at times non-routine or unfamiliar;<br />
*the choice and use of input, manipulation and output techniques will need to take account of a number of factors or elements; and<br />
*the user will take some responsibility for inputting, structuring, editing and presenting the information, which at times may be non-routine or unfamiliar.<br />
<br />
'''C. Level 3''' An level 3 user can select and use a wide range of advanced Impress tools and techniques effectively to produce presentations that are at times non-routine or unfamiliar.<br />
<br />
Presentation tools and techniques will be described as ‘advanced’ because:<br />
<br />
*the software tools and functions used will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
*the inputting, manipulating and outputting techniques will be multi-step and complex, and will involve research, identification and application; and<br />
*the user will take full responsibility for inputting, structuring, editing and presenting the information.<br />
<br />
== Level 1 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''A1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are required for the presentation</span><br />
<br />
A1.2 Select and use different slide layouts as appropriate for different types of information<br />
<br />
A1.3 Enter information into presentation slides so that it is ready for editing and formatting<br />
<br />
A1.4 Identify copyright or other constraints on using other people's information<br />
<br />
<span style="color:#FF0000;">A1.5 Combine information of different forms or from different sources for presentations</span><br />
<br />
<span style="color:#FF0000;">A1.6 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''A2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Identify what slide template to use<br />
<br />
A2.2 Select and use an appropriate template to structure slides<br />
<br />
A2.3 Select and use appropriate tools and techniques to edit slides<br />
<br />
A2.4 Select and use appropriate tools and techniques to format slides<br />
<br />
'''A3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A3.3 Check presentation meets needs, using IT tools and making corrections as appropriate<br />
A3.1 Identify how to present slides to meet needs and communicate effectively<br />
<br />
<br />
'''Content examples'''<br />
<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgement of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Prepare and present slides''' View, re-order, rehearse timing, present slide show<br />
<br />
'''Check slides''' Orientation, layout, slide order, text alignment and formatting<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text, add lines and simple shapes<br />
<br />
'''Presentation slide structure''' Layout; use existing templates, designs and styles; organisational guidelines<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
== Level 2 ==<br />
<br />
At level 1, the competent person will<br />
<br />
'''B1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B1.1 Identify what types of information are required for the presentation<br />
<br />
B1.2 Enter text and other information using layouts appropriate to type of information<br />
<br />
B1.3 Insert charts and tables into presentation slides<br />
<br />
B1.4 Insert images, video or sound to enhance the presentation<br />
<br />
B1.5 Identify any copyright or other constraints which may affect the presentation<br />
<br />
B1.6 Organise and combine information of different forms or from different sources for presentations<br />
<br />
B1.7 Store and retrieve presentation files effectively, in-line with local guidelines and conventions where available<br />
<br />
<br />
'''B2 Use presentation software tools to structure, edit and format slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B2.1 Identify what slide structure and theme to use<br />
<br />
B2.2 Select, change and use an appropriate structure for slides<br />
<br />
B2.3 Select and use appropriate techniques to edit slides and presentations to meet needs<br />
<br />
B2.4 Select and use appropriate techniques to format slides and presentations<br />
<br />
B2.5 Identify what presentation effects to use to enhance the presentation<br />
<br />
B2.6 Select and use animation and transition effects appropriately to enhance slide sequences<br />
<br />
'''B3 Prepare slides for presentation'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B3.1 Describe how to present slides to meet needs and communicate effectively <br />
<br />
B3.2 Prepare a slide show for presentation<br />
<br />
B3.3 Check presentation meets needs, using IT tools and making corrections as necessary<br />
<br />
B3.4 Identify and respond to any quality problems with presentations to ensure that presentations meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles Images: Size, position, orientation Effects: Timing, brightness, contrast, sound levels, order of effects and animations<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Presentation effects''' Video, sound, animation, slide transitions, visual and sound effects, hyper-links<br />
<br />
'''Prepare and present slides''' View and re-order slides; rehearse timing and effects; present slide show through a computer live; save presentation as a stand alone show or as web pages<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyper-links and action buttons<br />
<br />
'''Editing techniques for presentation slides''' Drag and drop, find, replace, undo redo, size, crop and position; wrap text; add lines and simple shapes; change orientation<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' Combine images with text, use of text boxes, presentation with audio and/or video, import information produced using other software, reference external information with hyper-links, object linking or embedding<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
<br />
<br />
== Level 3 ==<br />
<br />
At level 3, the competent person will<br />
<br />
'''C1 Input and combine text and other information within presentation slides'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Explain what types of information are required for the presentation<br />
<br />
C1.2 Enter text and other information using layouts appropriate to type of information<br />
<br />
C1.3 Insert charts and tables and link to source data<br />
<br />
C1.4 Insert images, video or sound to enhance the presentation<br />
<br />
C1.6 Organise and combine information for presentations<br />
<br />
C1.7 Store and retrieve presentation files effectively, in line with local guidelines and conventions where available<br />
<br />
C1.5 Identify any copyright or other constraints which may affect the presentation<br />
<br />
<br />
'''C2 Use presentation software tools to structure, edit and format presentations'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Explain when and how to use and change slide structure and themes to enhance presentations<br />
<br />
C2.2 Create, amend and use appropriate templates and themes for slides<br />
<br />
C2.3 Explain how interactive and presentation effects can be used to aid meaning or impact<br />
<br />
C2.4 Select and use appropriate techniques to edit and format presentations to meet needs<br />
<br />
C2.5 Create and use interactive elements to enhance presentations<br />
<br />
C2.6 Select and use animation and transition techniques appropriately to enhance presentations<br />
<br />
<br />
'''C3 Prepare slides for presentation'''<br />
<br />
C3.1 Explain how to present slides to communicate effectively for different contexts<br />
<br />
C3.2 Prepare slides for presentation<br />
<br />
C3.3 Check presentation meets needs, using IT tools and making corrections as necessary<br />
<br />
C3.5 Respond appropriately to quality problems to ensure that presentations meet needs and are fit for purpose<br />
<br />
C3.4 Evaluate presentations, identify any quality problems and discuss how to respond to them<br />
<br />
'''Content examples'''<br />
<br />
'''Present slides''' Timing, content, meaning; organisation of information; audience needs; location, contexts<br />
<br />
'''Problems with presentations''' Will vary according to the content, for example: Text: Formatting, styles, structure Images: Size, position, orientation, unwanted content Effects: Timing, brightness, contrast, sound levels, order of effects and animations, action buttons that do not work, sound clip out of sync<br />
<br />
'''Copyright constraints''' Effect of copyright law (eg on music downloads or use of other people’s images), acknowledgment of sources, avoiding plagiarism, permissions<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Presentation effects''' As for level 2<br />
<br />
'''Prepare and present slides''' As for level 2<br />
<br />
'''Check slides''' As for level 1<br />
<br />
'''Formatting techniques for presentation slides''' Bullets, numbering, line spacing, alignment, colour, fonts, size, backgrounds, master slides, colour schemes, apply and create transitions, apply animations<br />
<br />
'''Editing techniques for presentation effects''' Cutting, rendering, editing and exporting video clips; digitising and cutting sound clips; animating elements of text, charts or diagrams; slide transitions; adding and removing hyperlinks and action buttons<br />
<br />
'''Editing techniques for presentation slides''' As for level 2<br />
<br />
'''Presentation slide structure''' Layout, templates, design and style<br />
<br />
'''Combine presentation information''' As for level 2<br />
<br />
'''Charts and tables for presentations''' Pie chart, graph, diagram, organisational chart<br />
<br />
'''Images for presentations''' Clip-art, borders, create diagrams or graphics, download photos from a camera, scan images<br />
<br />
'''Types of information''' Text, numbers, images, sound<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/3_ObjectivesCertificaton/3 Objectives2009-12-17T15:33:16Z<p>Ggurley: /* LEVEL 3 */</p>
<hr />
<div>'''Level 1'''<br />
A level 1 user can use a range of basic tools and techniques to produce, present and check spreadsheets that are straightforward or routine. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘basic’ because:'''<br />
<br />
*the range of data entry, manipulation, formatting and outputting techniques are straightforward;<br />
*the tools, formulas and functions involved will be pre-determined or commonly used (for example, sum, divide, multiply, take away and fractions); and<br />
*the structure and functionality of the spreadsheet will be pre-determined or familiar.<br />
<br />
'''Level 2'''<br />
A level 2 user can select and use a wide range of spreadsheet software tools and techniques to produce, present and check spreadsheets that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘intermediate’ because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be multi-step and at times non-routine or unfamiliar;<br />
*the tools, formulas and functions need to analyse and interpret the data requires knowledge and understanding (for example, mathematical, logical, statistical or financial); and<br />
*the user will take some responsibility for setting up or developing the structure and functionality of the spreadsheet.<br />
<br />
'''Level 3'''<br />
A level 3 user can select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check spreadsheets that are complex and non-routine.<br />
<br />
'''Calc tools and techniques will be defined as 'advanced' because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be complex and non-routine;<br />
*the tools, formulas and functions needed to analyse and interpret the required information requires complex and non-routine knowledge and *understanding (for example, data restrictions, data validation using formula, pivot tables, data maps); and<br />
*the user will take full responsibility for setting up and developing the functionality of the spreadsheet.<br />
<br />
== LEVEL 1 ==<br />
<br />
'''At level 1, the competent person will ''' <br />
<br />
'''Use Calc to enter, edit and organise numerical and other data (learning outcome)'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">*A1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
<span style="color:#FF0000;">*A1.2 Enter and edit numerical and other data accurately</span><br />
<br />
<span style="color:#FF0000;">*A1.3 Combine and link data across worksheets</span><br />
<br />
*A1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Use appropriate formulas and tools to summarise and display spreadsheet information'''<br />
<br />
*A2.1 Identify how to summarise and display the required information<br />
*A2.2 Use functions and formulas to meet calculation requirements<br />
*A2.3 Use spreadsheet tools and techniques to summarise and display information<br />
<br />
'''Select and use appropriate tools and techniques to present spreadsheet information effectively'''<br />
<br />
*A3.1 Select and use appropriate tools and techniques to format spreadsheet cells, rows and columns<br />
*A3.2 Identify which chart or graph type to use to display information<br />
<span style="color:#FF0000;">*A3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs</span><br />
*A3.4 Select and use appropriate page layout to present and print spreadsheet information<br />
<span style="color:#FF0000;">*A3.5 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, relevant common methods for simple data<br />
* '''Check Calc data''' Accuracy of numbers and any text<br />
* '''Formatting techniques for charts and graphs''' Title, chart type, axis titles, legend<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal places, font and alignment<br />
* '''Functions and formula''' Formulas with a single operator (eg SUM function), percentages<br />
* '''Enter and edit spreadsheet data''' Insert data into single cells, replicate data, add and delete rows and columns, clear cells, cell data types<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets) and lay out<br />
* Numerical and other information Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 2 ==<br />
<br />
'''At level 2, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
<br />
<span style="color:#FF0000;">*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
<span style="color:#FF0000;">*1.2 Enter and edit numerical and other data accurately</span><br />
<br />
<span style="color:#FF0000;">*1.3 Combine and link data across worksheets</span><br />
<br />
<span style="color:#FF0000;">*1.4 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''Select and use appropriate formulas and data analysis tools to meet requirements'''<br />
<br />
*2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements <br />
*2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements<br />
*2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirements<br />
<br />
'''Select and use tools and techniques to present and format spreadsheet information'''<br />
<br />
*3.1 Plan how to present and format Calc spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate Calc tools and techniques to format cells, rows and columns of information<br />
*3.3 Select and format Calc charts and graphs as appropriate to display selected information<br />
*3.4 Select and use an appropriate Calc page layout to present and print spreadsheet information<br />
*3.5 Check Calc spreadsheet information meets needs, using IT tools and making corrections as appropriate<br />
*3.6 Describe how to find errors in spreadsheet formulas<br />
*3.7 Respond appropriately to any problems with Calc spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references<br />
* ''' Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, relevant common methods for more complex data<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, validity of analysis, layout and formatting<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational<br />
* '''Enter and edit spreadsheet data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 3 ==<br />
<br />
'''At level 3, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
<br />
<span style="color:#FF0000;">*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
*1.2 Enter and edit numerical and other data data accurately<br />
<br />
<span style="color:#FF0000;">*1.3 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''Select and use appropriate formulas and data analysis tools and techniques to meet requirements''' <br />
<br />
*2.1 Explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them<br />
*2.2 Select and use a wide range of functions and formulas to meet calculation requirements<br />
*2.3 Select and use a range of tools and techniques to analyse and interpret data to meet requirements<br />
*2.4 Select and use forecasting tools and techniques<br />
<br />
'''Use tools and techniques to present, format and publish spreadsheet information'''<br />
<br />
*3.1 Explain how to present and format spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate tools and techniques to format cells, rows and columns effectively<br />
<br />
<span style="color:#FF0000;">*3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs effectively</span><br />
<br />
*3.4 Select and use appropriate page layout to present, print and publish spreadsheet information<br />
*3.5 Explain how to find and sort out any errors in spreadsheet formulas<br />
<br />
<span style="color:#FF0000;">*3.6 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate</span><br />
<br />
*3.7 Use auditing tools to identify and respond appropriately to any problems with spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Forecasting tools and techniques''' What-if scenarios, goal seek; data tables; views<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references, calculations and results; data validation, locate invalid data<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, data restrictions, data validation, adding messages to data, using formulae to determine valid entries for cells, displaying by interest, pivot tables, data maps<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, layout and formatting validity, relevance and accuracy of analysis, interpretation of calculations and results<br />
* '''Formatting techniques for charts and graphs''' Title, axis titles, legend, change chart type, move and resize chart, axis scale, annotation, layout, pivot table reports<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for spreadsheet cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders; conditional formatting<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational, look-up, arguments, arrays and formulas for validating data<br />
* '''Enter and edit Calc data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart, hide and protect cells, create, modify and merge multiple copies of a shared workbook<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/3_ObjectivesCertificaton/3 Objectives2009-12-17T15:31:19Z<p>Ggurley: /* LEVEL 2 */</p>
<hr />
<div>'''Level 1'''<br />
A level 1 user can use a range of basic tools and techniques to produce, present and check spreadsheets that are straightforward or routine. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘basic’ because:'''<br />
<br />
*the range of data entry, manipulation, formatting and outputting techniques are straightforward;<br />
*the tools, formulas and functions involved will be pre-determined or commonly used (for example, sum, divide, multiply, take away and fractions); and<br />
*the structure and functionality of the spreadsheet will be pre-determined or familiar.<br />
<br />
'''Level 2'''<br />
A level 2 user can select and use a wide range of spreadsheet software tools and techniques to produce, present and check spreadsheets that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘intermediate’ because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be multi-step and at times non-routine or unfamiliar;<br />
*the tools, formulas and functions need to analyse and interpret the data requires knowledge and understanding (for example, mathematical, logical, statistical or financial); and<br />
*the user will take some responsibility for setting up or developing the structure and functionality of the spreadsheet.<br />
<br />
'''Level 3'''<br />
A level 3 user can select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check spreadsheets that are complex and non-routine.<br />
<br />
'''Calc tools and techniques will be defined as 'advanced' because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be complex and non-routine;<br />
*the tools, formulas and functions needed to analyse and interpret the required information requires complex and non-routine knowledge and *understanding (for example, data restrictions, data validation using formula, pivot tables, data maps); and<br />
*the user will take full responsibility for setting up and developing the functionality of the spreadsheet.<br />
<br />
== LEVEL 1 ==<br />
<br />
'''At level 1, the competent person will ''' <br />
<br />
'''Use Calc to enter, edit and organise numerical and other data (learning outcome)'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">*A1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
<span style="color:#FF0000;">*A1.2 Enter and edit numerical and other data accurately</span><br />
<br />
<span style="color:#FF0000;">*A1.3 Combine and link data across worksheets</span><br />
<br />
*A1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Use appropriate formulas and tools to summarise and display spreadsheet information'''<br />
<br />
*A2.1 Identify how to summarise and display the required information<br />
*A2.2 Use functions and formulas to meet calculation requirements<br />
*A2.3 Use spreadsheet tools and techniques to summarise and display information<br />
<br />
'''Select and use appropriate tools and techniques to present spreadsheet information effectively'''<br />
<br />
*A3.1 Select and use appropriate tools and techniques to format spreadsheet cells, rows and columns<br />
*A3.2 Identify which chart or graph type to use to display information<br />
<span style="color:#FF0000;">*A3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs</span><br />
*A3.4 Select and use appropriate page layout to present and print spreadsheet information<br />
<span style="color:#FF0000;">*A3.5 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, relevant common methods for simple data<br />
* '''Check Calc data''' Accuracy of numbers and any text<br />
* '''Formatting techniques for charts and graphs''' Title, chart type, axis titles, legend<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal places, font and alignment<br />
* '''Functions and formula''' Formulas with a single operator (eg SUM function), percentages<br />
* '''Enter and edit spreadsheet data''' Insert data into single cells, replicate data, add and delete rows and columns, clear cells, cell data types<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets) and lay out<br />
* Numerical and other information Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 2 ==<br />
<br />
'''At level 2, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
<br />
<span style="color:#FF0000;">*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
<span style="color:#FF0000;">*1.2 Enter and edit numerical and other data accurately</span><br />
<br />
<span style="color:#FF0000;">*1.3 Combine and link data across worksheets</span><br />
<br />
<span style="color:#FF0000;">*1.4 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available</span><br />
<br />
'''Select and use appropriate formulas and data analysis tools to meet requirements'''<br />
<br />
*2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements <br />
*2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements<br />
*2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirements<br />
<br />
'''Select and use tools and techniques to present and format spreadsheet information'''<br />
<br />
*3.1 Plan how to present and format Calc spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate Calc tools and techniques to format cells, rows and columns of information<br />
*3.3 Select and format Calc charts and graphs as appropriate to display selected information<br />
*3.4 Select and use an appropriate Calc page layout to present and print spreadsheet information<br />
*3.5 Check Calc spreadsheet information meets needs, using IT tools and making corrections as appropriate<br />
*3.6 Describe how to find errors in spreadsheet formulas<br />
*3.7 Respond appropriately to any problems with Calc spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references<br />
* ''' Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, relevant common methods for more complex data<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, validity of analysis, layout and formatting<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational<br />
* '''Enter and edit spreadsheet data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 3 ==<br />
<br />
'''At level 3, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
<br />
*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured<br />
*1.2 Enter and edit numerical and other data data accurately<br />
*1.3 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Select and use appropriate formulas and data analysis tools and techniques to meet requirements''' <br />
<br />
*2.1 Explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them<br />
*2.2 Select and use a wide range of functions and formulas to meet calculation requirements<br />
*2.3 Select and use a range of tools and techniques to analyse and interpret data to meet requirements<br />
*2.4 Select and use forecasting tools and techniques<br />
<br />
'''Use tools and techniques to present, format and publish spreadsheet information'''<br />
<br />
*3.1 Explain how to present and format spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate tools and techniques to format cells, rows and columns effectively<br />
*3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs effectively<br />
*3.4 Select and use appropriate page layout to present, print and publish spreadsheet information<br />
*3.5 Explain how to find and sort out any errors in spreadsheet formulas<br />
*3.6 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate<br />
*3.7 Use auditing tools to identify and respond appropriately to any problems with spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Forecasting tools and techniques''' What-if scenarios, goal seek; data tables; views<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references, calculations and results; data validation, locate invalid data<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, data restrictions, data validation, adding messages to data, using formulae to determine valid entries for cells, displaying by interest, pivot tables, data maps<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, layout and formatting validity, relevance and accuracy of analysis, interpretation of calculations and results<br />
* '''Formatting techniques for charts and graphs''' Title, axis titles, legend, change chart type, move and resize chart, axis scale, annotation, layout, pivot table reports<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for spreadsheet cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders; conditional formatting<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational, look-up, arguments, arrays and formulas for validating data<br />
* '''Enter and edit Calc data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart, hide and protect cells, create, modify and merge multiple copies of a shared workbook<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/3_ObjectivesCertificaton/3 Objectives2009-12-17T15:28:13Z<p>Ggurley: /* LEVEL 1 */</p>
<hr />
<div>'''Level 1'''<br />
A level 1 user can use a range of basic tools and techniques to produce, present and check spreadsheets that are straightforward or routine. Any aspect that is unfamiliar will require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘basic’ because:'''<br />
<br />
*the range of data entry, manipulation, formatting and outputting techniques are straightforward;<br />
*the tools, formulas and functions involved will be pre-determined or commonly used (for example, sum, divide, multiply, take away and fractions); and<br />
*the structure and functionality of the spreadsheet will be pre-determined or familiar.<br />
<br />
'''Level 2'''<br />
A level 2 user can select and use a wide range of spreadsheet software tools and techniques to produce, present and check spreadsheets that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.<br />
<br />
'''Calc software tools and techniques will be defined as ‘intermediate’ because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be multi-step and at times non-routine or unfamiliar;<br />
*the tools, formulas and functions need to analyse and interpret the data requires knowledge and understanding (for example, mathematical, logical, statistical or financial); and<br />
*the user will take some responsibility for setting up or developing the structure and functionality of the spreadsheet.<br />
<br />
'''Level 3'''<br />
A level 3 user can select and use a wide range of advanced spreadsheet software tools and techniques to produce, present and check spreadsheets that are complex and non-routine.<br />
<br />
'''Calc tools and techniques will be defined as 'advanced' because:'''<br />
<br />
*the range of data entry, manipulation and outputting techniques will be complex and non-routine;<br />
*the tools, formulas and functions needed to analyse and interpret the required information requires complex and non-routine knowledge and *understanding (for example, data restrictions, data validation using formula, pivot tables, data maps); and<br />
*the user will take full responsibility for setting up and developing the functionality of the spreadsheet.<br />
<br />
== LEVEL 1 ==<br />
<br />
'''At level 1, the competent person will ''' <br />
<br />
'''Use Calc to enter, edit and organise numerical and other data (learning outcome)'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">*A1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured</span><br />
<br />
<span style="color:#FF0000;">*A1.2 Enter and edit numerical and other data accurately</span><br />
<br />
<span style="color:#FF0000;">*A1.3 Combine and link data across worksheets</span><br />
<br />
*A1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Use appropriate formulas and tools to summarise and display spreadsheet information'''<br />
<br />
*A2.1 Identify how to summarise and display the required information<br />
*A2.2 Use functions and formulas to meet calculation requirements<br />
*A2.3 Use spreadsheet tools and techniques to summarise and display information<br />
<br />
'''Select and use appropriate tools and techniques to present spreadsheet information effectively'''<br />
<br />
*A3.1 Select and use appropriate tools and techniques to format spreadsheet cells, rows and columns<br />
*A3.2 Identify which chart or graph type to use to display information<br />
<span style="color:#FF0000;">*A3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs</span><br />
*A3.4 Select and use appropriate page layout to present and print spreadsheet information<br />
<span style="color:#FF0000;">*A3.5 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, relevant common methods for simple data<br />
* '''Check Calc data''' Accuracy of numbers and any text<br />
* '''Formatting techniques for charts and graphs''' Title, chart type, axis titles, legend<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal places, font and alignment<br />
* '''Functions and formula''' Formulas with a single operator (eg SUM function), percentages<br />
* '''Enter and edit spreadsheet data''' Insert data into single cells, replicate data, add and delete rows and columns, clear cells, cell data types<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets) and lay out<br />
* Numerical and other information Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 2 ==<br />
<br />
'''At level 2, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured<br />
*1.2 Enter and edit numerical and other data accurately<br />
*1.3 Combine and link data across worksheets<br />
*1.4 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Select and use appropriate formulas and data analysis tools to meet requirements'''<br />
<br />
*2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements <br />
*2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements<br />
*2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirements<br />
<br />
'''Select and use tools and techniques to present and format spreadsheet information'''<br />
<br />
*3.1 Plan how to present and format Calc spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate Calc tools and techniques to format cells, rows and columns of information<br />
*3.3 Select and format Calc charts and graphs as appropriate to display selected information<br />
*3.4 Select and use an appropriate Calc page layout to present and print spreadsheet information<br />
*3.5 Check Calc spreadsheet information meets needs, using IT tools and making corrections as appropriate<br />
*3.6 Describe how to find errors in spreadsheet formulas<br />
*3.7 Respond appropriately to any problems with Calc spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references<br />
* ''' Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, relevant common methods for more complex data<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, validity of analysis, layout and formatting<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for Calc cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational<br />
* '''Enter and edit spreadsheet data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
== LEVEL 3 ==<br />
<br />
'''At level 3, the competent person will'''<br />
<br />
'''Use Calc to enter, edit and organise numerical and other data'''<br />
<br />
*1.1 Identify what numerical and other data is needed in the spreadsheet and how it should be structured<br />
*1.2 Enter and edit numerical and other data data accurately<br />
*1.3 Store and retrieve Calc files effectively, in line with local guidelines and conventions where available<br />
<br />
'''Select and use appropriate formulas and data analysis tools and techniques to meet requirements''' <br />
<br />
*2.1 Explain what methods can be used to summarise, analyse and interpret spreadsheet data and when to use them<br />
*2.2 Select and use a wide range of functions and formulas to meet calculation requirements<br />
*2.3 Select and use a range of tools and techniques to analyse and interpret data to meet requirements<br />
*2.4 Select and use forecasting tools and techniques<br />
<br />
'''Use tools and techniques to present, format and publish spreadsheet information'''<br />
<br />
*3.1 Explain how to present and format spreadsheet information effectively to meet needs<br />
*3.2 Select and use appropriate tools and techniques to format cells, rows and columns effectively<br />
*3.3 Select and use appropriate tools and techniques to generate, develop and format charts and graphs effectively<br />
*3.4 Select and use appropriate page layout to present, print and publish spreadsheet information<br />
*3.5 Explain how to find and sort out any errors in spreadsheet formulas<br />
*3.6 Check spreadsheet information meets needs, using IT tools and making corrections as appropriate<br />
*3.7 Use auditing tools to identify and respond appropriately to any problems with spreadsheets<br />
<br />
'''Content examples'''<br />
<br />
* '''Forecasting tools and techniques''' What-if scenarios, goal seek; data tables; views<br />
* '''Problems with spreadsheets''' Using help; sorting out errors in formulas, circular references, calculations and results; data validation, locate invalid data<br />
* '''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
* '''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering, columns, adjust page set up for printing<br />
* '''Analysis and interpretation of spreadsheet data''' Automatic sub-totals and sorting a cell range, filter rows and columns, data restrictions, data validation, adding messages to data, using formulae to determine valid entries for cells, displaying by interest, pivot tables, data maps<br />
* '''Check Calc data''' Accuracy of numbers and any text, accuracy of results, sorting out errors in formulas, layout and formatting validity, relevance and accuracy of analysis, interpretation of calculations and results<br />
* '''Formatting techniques for charts and graphs''' Title, axis titles, legend, change chart type, move and resize chart, axis scale, annotation, layout, pivot table reports<br />
* '''Formatting techniques for rows and columns in spreadsheets and tables''' Height, width, borders and shading<br />
* '''Formatting techniques for spreadsheet cells''' Numbers, currency, percentages, number of decimal place, dates, font, alignment, colour, shading and borders; conditional formatting<br />
* '''Functions and formulae''' Mathematical, statistical, financial, relational, look-up, arguments, arrays and formulas for validating data<br />
* '''Enter and edit Calc data''' Insert data into multiple cells at once, replicate data, use absolute and relative cell references, add data and text to a chart, hide and protect cells, create, modify and merge multiple copies of a shared workbook<br />
* '''Calc structure''' Worksheet components (eg cells, rows, columns, tabs, pages, charts, workbooks, worksheets, panes) and lay out<br />
* '''Numerical and other information''' Numbers, charts, graphs, text, images<br />
<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/2_ObjectivesCertificaton/2 Objectives2009-12-17T15:24:04Z<p>Ggurley: /* At level 3, the competent person will */</p>
<hr />
<div>The objective is to certify the ability to use Writer to edit documents.<br />
<br />
'''Summary'''<br />
<br />
'''A. A foundation user can use Writer to produce appropriate straightforward or routine documents. Any aspect that is unfamiliar will require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as 'basic' because:<br />
<br />
* the software tools and functions will be pre-determined or commonly used; and<br />
* the techniques needed for text entry, manipulation and outputting will be straightforward or routine.<br />
<br />
'''B. An intermediate user can use Writer to produce multi-step documents that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as ‘intermediate’ because:<br />
<br />
* the software tools and functions will be at times non-routine or unfamiliar;<br />
* the choice of techniques will need to take account of a number of factors or elements; and<br />
* the user will take some responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
'''C. An advanced user can use Writer to produce complex and non-routine documents.<br />
'''<br />
Writer tools and techniques will be described as ‘advanced’ because:<br />
<br />
* the software tools and functions will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
* the techniques required will be multi-step and complex, and the process of selecting appropriate techniques may involve research, identification and application; and<br />
* the user will take full responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
<br />
==At level 1, the competent person will==<br />
<br />
<br />
'''A1. Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are needed in documents</span><br />
<br />
A1.2 Identify what templates are available and when to use them<br />
<br />
A1.3 Use keyboard or other input method to enter or insert text and other information<br />
<br />
A1.4 Combine information of different forms or from different sources within a document<br />
<br />
A1.5 Enter information into existing tables, forms and templates<br />
<br />
A1.6 Use editing tools to amend document content<br />
<br />
A1.7 Store and retrieve document files effectively, in line with local guidelines and conventions where available<br />
<br />
'''A2. Structure information within word processing documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Create and modify tables to organise tabular or numeric information<br />
<br />
A2.2 Select and apply heading styles to text<br />
<br />
'''A3. Use Writer tools to format and present documents'''<br />
<br />
A3.1 Identify what formatting to use to enhance presentation of the document<br />
<br />
<span style="color:#FF0000;">A3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
A3.3 Select and use appropriate page layout to present and print documents<br />
<br />
<span style="color:#FF0000;">A3.4 Check documents meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
'''Page layout for documents''' Size, orientation, margins, page breaks, page numbering; standard document layouts (eg letter, memo)<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders)<br />
<br />
'''Tables and forms''' Add table, insert and delete rows and columns, adjust column width<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately<br />
<br />
'''IT tools to check text''' Spell check, grammar check, word count<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline and italic<br />
<br />
'''Combine Writer information''' Insert, size and position<br />
<br />
==At level 2, the competent person will==<br />
<br />
'''B1 Enter and combine text and other information within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of information are needed in documents</span><br />
<br />
B1.2 Use a keyboard or other input device to enter text and other information accurately and efficiently<br />
<br />
B1.3 select and use appropriate templates for different purposes<br />
<br />
B1.4 Identify when and how to combine and merge information from other software or other documents<br />
<br />
B1.5 Select and use a range of editing tools to amend document content<br />
<br />
B1.6 Combine or merge information within a document from a range of sources<br />
<br />
B1.7 Store and retrieve document and template files effectively, in line with local guidelines and conventions where available<br />
<br />
'''B2 Create structures and styles for Writer documents'''<br />
<br />
B2.1 Identify the document requirements for structure and style<br />
<br />
B2.2 Identify what templates and styles are available and when to use them<br />
<br />
B2.3 Create and modify columns, tables and forms to organise information<br />
<br />
B2.4 Select and apply styles to text<br />
<br />
<span style="color:#FF0000;">B2.5 Select and use appropriate page and section layouts to present and print documents</span><br />
<br />
'''B3 Use Writer tools to format and present documents effectively to meet requirements'''<br />
<br />
B3.1 Identify how the document should be formatted to aid meaning<br />
<br />
<span style="color:#FF0000;">B3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
<span style="color:#FF0000;">B3.3 Select and use appropriate page and section layouts to present and print documents</span><br />
<br />
<span style="color:#FF0000;">B3.4 Check documents meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
B3.5 Describe any quality problems with documents<br />
<br />
B3.6 Respond appropriately to quality problems with Writer documents so that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Requirements for structure and style''' Document layout; house style<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations)<br />
<br />
'''Format columns''' Add and delete columns, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position, change templates<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section, define styles for different elements of common documents<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face and size; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
<br />
==At level 3, the competent person will==<br />
<br />
'''C1 Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Summarise what types of information are needed for the document and how they should be linked or integrated<br />
<br />
C1.2 Use a keyboard or other input method to enter text and other information accurately and efficiently<br />
<br />
C1.3 Create, use and modify appropriate templates for different types of documents<br />
<br />
C1.4 Combine and merge information within a document from a range of sources<br />
<br />
C1.5 Explain how to combine and merge information from other software or multiple documents<br />
<br />
C1.6 Store and retrieve document and associated files effectively, in line with local guidelines and conventions where available<br />
<br />
C1.7 Select and use appropriate tools and techniques to work with multiple documents or users<br />
<br />
C1.8 Customise interface to meet needs<br />
<br />
'''C2 Create and modify appropriate layouts, structures and styles for Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Analyse and explain the requirements for structure and style<br />
<br />
C2.2 Create, use and modify columns, tables and forms to organise information<br />
<br />
C2.3 Define and modify styles for document elements<br />
<br />
C2.4 Select and use tools and techniques to organise and structure long documents<br />
<br />
'''C3 Use Writer tools and techniques to format and present documents effectively to meet requirements'''<br />
<br />
C3.1 Explain how the information should be formatted to aid meaning<br />
<br />
<span style="color:#FF0000;">C3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
C3.3 Select and use appropriate page and section layouts to present and print multi-page and multi-section documents<br />
<br />
C3.4 Check documents meet needs, using IT tools and making corrections as appropriate<br />
<br />
<span style="color:#FF0000;">C3.5 Evaluate the quality of the documents produced to ensure that they are fit for purpose</span><br />
<br />
C3.6 Respond appropriately to any quality problems with Writer documents to ensure that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Customise interface''' Shortcuts, toolbars, menus; default settings; start-up, language<br />
<br />
'''Requirements for structure and style''' Document layout; house style; branding<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing or web publishing, facing pages, booklets<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations); links, cross references, versions<br />
<br />
'''Work with multiple documents or users''' Version control, audit and track changes, compare and merge documents, document sharing and collaboration<br />
<br />
'''Format columns''' Add and delete columns, add column breaks, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort, position, headings, totals; heading rows; embedded spreadsheet data<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Structure Writer documents''' Sections, bookmarks, cross-referencing using indexes and contents page, master documents<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section; define, organise and use new styles<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently, keyboard short cuts, customise keys<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face, size and kerning; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols, spacing, position<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/2_ObjectivesCertificaton/2 Objectives2009-12-17T15:22:00Z<p>Ggurley: /* At level 2, the competent person will */</p>
<hr />
<div>The objective is to certify the ability to use Writer to edit documents.<br />
<br />
'''Summary'''<br />
<br />
'''A. A foundation user can use Writer to produce appropriate straightforward or routine documents. Any aspect that is unfamiliar will require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as 'basic' because:<br />
<br />
* the software tools and functions will be pre-determined or commonly used; and<br />
* the techniques needed for text entry, manipulation and outputting will be straightforward or routine.<br />
<br />
'''B. An intermediate user can use Writer to produce multi-step documents that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as ‘intermediate’ because:<br />
<br />
* the software tools and functions will be at times non-routine or unfamiliar;<br />
* the choice of techniques will need to take account of a number of factors or elements; and<br />
* the user will take some responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
'''C. An advanced user can use Writer to produce complex and non-routine documents.<br />
'''<br />
Writer tools and techniques will be described as ‘advanced’ because:<br />
<br />
* the software tools and functions will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
* the techniques required will be multi-step and complex, and the process of selecting appropriate techniques may involve research, identification and application; and<br />
* the user will take full responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
<br />
==At level 1, the competent person will==<br />
<br />
<br />
'''A1. Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are needed in documents</span><br />
<br />
A1.2 Identify what templates are available and when to use them<br />
<br />
A1.3 Use keyboard or other input method to enter or insert text and other information<br />
<br />
A1.4 Combine information of different forms or from different sources within a document<br />
<br />
A1.5 Enter information into existing tables, forms and templates<br />
<br />
A1.6 Use editing tools to amend document content<br />
<br />
A1.7 Store and retrieve document files effectively, in line with local guidelines and conventions where available<br />
<br />
'''A2. Structure information within word processing documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Create and modify tables to organise tabular or numeric information<br />
<br />
A2.2 Select and apply heading styles to text<br />
<br />
'''A3. Use Writer tools to format and present documents'''<br />
<br />
A3.1 Identify what formatting to use to enhance presentation of the document<br />
<br />
<span style="color:#FF0000;">A3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
A3.3 Select and use appropriate page layout to present and print documents<br />
<br />
<span style="color:#FF0000;">A3.4 Check documents meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
'''Page layout for documents''' Size, orientation, margins, page breaks, page numbering; standard document layouts (eg letter, memo)<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders)<br />
<br />
'''Tables and forms''' Add table, insert and delete rows and columns, adjust column width<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately<br />
<br />
'''IT tools to check text''' Spell check, grammar check, word count<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline and italic<br />
<br />
'''Combine Writer information''' Insert, size and position<br />
<br />
==At level 2, the competent person will==<br />
<br />
'''B1 Enter and combine text and other information within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<span style="color:#FF0000;">B1.1 Identify what types of information are needed in documents</span><br />
<br />
B1.2 Use a keyboard or other input device to enter text and other information accurately and efficiently<br />
<br />
B1.3 select and use appropriate templates for different purposes<br />
<br />
B1.4 Identify when and how to combine and merge information from other software or other documents<br />
<br />
B1.5 Select and use a range of editing tools to amend document content<br />
<br />
B1.6 Combine or merge information within a document from a range of sources<br />
<br />
B1.7 Store and retrieve document and template files effectively, in line with local guidelines and conventions where available<br />
<br />
'''B2 Create structures and styles for Writer documents'''<br />
<br />
B2.1 Identify the document requirements for structure and style<br />
<br />
B2.2 Identify what templates and styles are available and when to use them<br />
<br />
B2.3 Create and modify columns, tables and forms to organise information<br />
<br />
B2.4 Select and apply styles to text<br />
<br />
<span style="color:#FF0000;">B2.5 Select and use appropriate page and section layouts to present and print documents</span><br />
<br />
'''B3 Use Writer tools to format and present documents effectively to meet requirements'''<br />
<br />
B3.1 Identify how the document should be formatted to aid meaning<br />
<br />
<span style="color:#FF0000;">B3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
<span style="color:#FF0000;">B3.3 Select and use appropriate page and section layouts to present and print documents</span><br />
<br />
<span style="color:#FF0000;">B3.4 Check documents meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
B3.5 Describe any quality problems with documents<br />
<br />
B3.6 Respond appropriately to quality problems with Writer documents so that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Requirements for structure and style''' Document layout; house style<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations)<br />
<br />
'''Format columns''' Add and delete columns, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position, change templates<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section, define styles for different elements of common documents<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face and size; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
<br />
==At level 3, the competent person will==<br />
<br />
'''C1 Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Summarise what types of information are needed for the document and how they should be linked or integrated<br />
<br />
C1.2 Use a keyboard or other input method to enter text and other information accurately and efficiently<br />
<br />
C1.3 Create, use and modify appropriate templates for different types of documents<br />
<br />
C1.4 Combine and merge information within a document from a range of sources<br />
<br />
C1.5 Explain how to combine and merge information from other software or multiple documents<br />
<br />
C1.6 Store and retrieve document and associated files effectively, in line with local guidelines and conventions where available<br />
<br />
C1.7 Select and use appropriate tools and techniques to work with multiple documents or users<br />
<br />
C1.8 Customise interface to meet needs<br />
<br />
'''C2 Create and modify appropriate layouts, structures and styles for Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Analyse and explain the requirements for structure and style<br />
<br />
C2.2 Create, use and modify columns, tables and forms to organise information<br />
<br />
C2.3 Define and modify styles for document elements<br />
<br />
C2.4 Select and use tools and techniques to organise and structure long documents<br />
<br />
'''C3 Use Writer tools and techniques to format and present documents effectively to meet requirements'''<br />
<br />
C3.1 Explain how the information should be formatted to aid meaning<br />
<br />
C3.2 Select and use appropriate techniques to format characters and paragraphs<br />
<br />
C3.3 Select and use appropriate page and section layouts to present and print multi-page and multi-section documents<br />
<br />
C3.4 Check documents meet needs, using IT tools and making corrections as appropriate<br />
<br />
C3.5 Evaluate the quality of the documents produced to ensure that they are fit for purpose<br />
<br />
C3.6 Respond appropriately to any quality problems with Writer documents to ensure that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Customise interface''' Shortcuts, toolbars, menus; default settings; start-up, language<br />
<br />
'''Requirements for structure and style''' Document layout; house style; branding<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing or web publishing, facing pages, booklets<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations); links, cross references, versions<br />
<br />
'''Work with multiple documents or users''' Version control, audit and track changes, compare and merge documents, document sharing and collaboration<br />
<br />
'''Format columns''' Add and delete columns, add column breaks, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort, position, headings, totals; heading rows; embedded spreadsheet data<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Structure Writer documents''' Sections, bookmarks, cross-referencing using indexes and contents page, master documents<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section; define, organise and use new styles<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently, keyboard short cuts, customise keys<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face, size and kerning; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols, spacing, position<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
[[Category:Certification]]</div>Ggurleyhttps://wiki.openoffice.org/wiki/Certificaton/2_ObjectivesCertificaton/2 Objectives2009-12-17T15:19:16Z<p>Ggurley: /* At level 1, the competent person will */</p>
<hr />
<div>The objective is to certify the ability to use Writer to edit documents.<br />
<br />
'''Summary'''<br />
<br />
'''A. A foundation user can use Writer to produce appropriate straightforward or routine documents. Any aspect that is unfamiliar will require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as 'basic' because:<br />
<br />
* the software tools and functions will be pre-determined or commonly used; and<br />
* the techniques needed for text entry, manipulation and outputting will be straightforward or routine.<br />
<br />
'''B. An intermediate user can use Writer to produce multi-step documents that are at times non-routine or unfamiliar. Any aspect that is unfamiliar may require support and advice from others.'''<br />
<br />
Writer tools and techniques will be described as ‘intermediate’ because:<br />
<br />
* the software tools and functions will be at times non-routine or unfamiliar;<br />
* the choice of techniques will need to take account of a number of factors or elements; and<br />
* the user will take some responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
'''C. An advanced user can use Writer to produce complex and non-routine documents.<br />
'''<br />
Writer tools and techniques will be described as ‘advanced’ because:<br />
<br />
* the software tools and functions will be complex and at times involve having the idea that there may be a tool or function to do something (eg improve efficiency or create an effect), exploring technical support, self-teaching and applying;<br />
* the techniques required will be multi-step and complex, and the process of selecting appropriate techniques may involve research, identification and application; and<br />
* the user will take full responsibility for the inputting, manipulating and outputting of the information.<br />
<br />
<br />
==At level 1, the competent person will==<br />
<br />
<br />
'''A1. Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
<br />
<span style="color:#FF0000;">A1.1 Identify what types of information are needed in documents</span><br />
<br />
A1.2 Identify what templates are available and when to use them<br />
<br />
A1.3 Use keyboard or other input method to enter or insert text and other information<br />
<br />
A1.4 Combine information of different forms or from different sources within a document<br />
<br />
A1.5 Enter information into existing tables, forms and templates<br />
<br />
A1.6 Use editing tools to amend document content<br />
<br />
A1.7 Store and retrieve document files effectively, in line with local guidelines and conventions where available<br />
<br />
'''A2. Structure information within word processing documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
A2.1 Create and modify tables to organise tabular or numeric information<br />
<br />
A2.2 Select and apply heading styles to text<br />
<br />
'''A3. Use Writer tools to format and present documents'''<br />
<br />
A3.1 Identify what formatting to use to enhance presentation of the document<br />
<br />
<span style="color:#FF0000;">A3.2 Select and use appropriate techniques to format characters and paragraphs</span><br />
<br />
A3.3 Select and use appropriate page layout to present and print documents<br />
<br />
<span style="color:#FF0000;">A3.4 Check documents meet needs, using IT tools and making corrections as appropriate</span><br />
<br />
'''Content examples'''<br />
<br />
'''Page layout for documents''' Size, orientation, margins, page breaks, page numbering; standard document layouts (eg letter, memo)<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders)<br />
<br />
'''Tables and forms''' Add table, insert and delete rows and columns, adjust column width<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find)<br />
<br />
'''Page layout''' Size, portrait, landscape, margins, header and footer, page breaks, page numbering<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately<br />
<br />
'''IT tools to check text''' Spell check, grammar check, word count<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline and italic<br />
<br />
'''Combine Writer information''' Insert, size and position<br />
<br />
==At level 2, the competent person will==<br />
<br />
'''B1 Enter and combine text and other information within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
B1.1 Identify what types of information are needed in documents<br />
<br />
B1.2 Use a keyboard or other input device to enter text and other information accurately and efficiently<br />
<br />
B1.3 select and use appropriate templates for different purposes<br />
<br />
B1.4 Identify when and how to combine and merge information from other software or other documents<br />
<br />
B1.5 Select and use a range of editing tools to amend document content<br />
<br />
B1.6 Combine or merge information within a document from a range of sources<br />
<br />
B1.7 Store and retrieve document and template files effectively, in line with local guidelines and conventions where available<br />
<br />
'''B2 Create structures and styles for Writer documents'''<br />
<br />
B2.1 Identify the document requirements for structure and style<br />
<br />
B2.2 Identify what templates and styles are available and when to use them<br />
<br />
B2.3 Create and modify columns, tables and forms to organise information<br />
<br />
B2.4 Select and apply styles to text<br />
<br />
B2.5 Select and use appropriate page and section layouts to present and print documents<br />
<br />
'''B3 Use Writer tools to format and present documents effectively to meet requirements'''<br />
<br />
B3.1 Identify how the document should be formatted to aid meaning<br />
<br />
B3.2 Select and use appropriate techniques to format characters and paragraphs<br />
<br />
B3.3 Select and use appropriate page and section layouts to present and print documents<br />
<br />
B3.4 Check documents meet needs, using IT tools and making corrections as appropriate<br />
<br />
B3.5 Describe any quality problems with documents<br />
<br />
B3.6 Respond appropriately to quality problems with Writer documents so that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Requirements for structure and style''' Document layout; house style<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations)<br />
<br />
'''Format columns''' Add and delete columns, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; folders (eg create, name)<br />
<br />
'''Editing techniques for different types of information''' Editing techniques will vary in line with the type of information, for example: copy, cut, paste, undo, redo, drag and drop, find, replace, size, crop, position, change templates<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section, define styles for different elements of common documents<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face and size; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols<br />
<br />
'''Templates, tables and documents''' Use existing templates, set up new templates for common documents<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
<br />
==At level 3, the competent person will==<br />
<br />
'''C1 Enter and combine text and other information accurately within Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C1.1 Summarise what types of information are needed for the document and how they should be linked or integrated<br />
<br />
C1.2 Use a keyboard or other input method to enter text and other information accurately and efficiently<br />
<br />
C1.3 Create, use and modify appropriate templates for different types of documents<br />
<br />
C1.4 Combine and merge information within a document from a range of sources<br />
<br />
C1.5 Explain how to combine and merge information from other software or multiple documents<br />
<br />
C1.6 Store and retrieve document and associated files effectively, in line with local guidelines and conventions where available<br />
<br />
C1.7 Select and use appropriate tools and techniques to work with multiple documents or users<br />
<br />
C1.8 Customise interface to meet needs<br />
<br />
'''C2 Create and modify appropriate layouts, structures and styles for Writer documents'''<br />
<br />
To demonstrate this competence they can<br />
<br />
C2.1 Analyse and explain the requirements for structure and style<br />
<br />
C2.2 Create, use and modify columns, tables and forms to organise information<br />
<br />
C2.3 Define and modify styles for document elements<br />
<br />
C2.4 Select and use tools and techniques to organise and structure long documents<br />
<br />
'''C3 Use Writer tools and techniques to format and present documents effectively to meet requirements'''<br />
<br />
C3.1 Explain how the information should be formatted to aid meaning<br />
<br />
C3.2 Select and use appropriate techniques to format characters and paragraphs<br />
<br />
C3.3 Select and use appropriate page and section layouts to present and print multi-page and multi-section documents<br />
<br />
C3.4 Check documents meet needs, using IT tools and making corrections as appropriate<br />
<br />
C3.5 Evaluate the quality of the documents produced to ensure that they are fit for purpose<br />
<br />
C3.6 Respond appropriately to any quality problems with Writer documents to ensure that outcomes meet needs<br />
<br />
'''Content examples'''<br />
<br />
'''Customise interface''' Shortcuts, toolbars, menus; default settings; start-up, language<br />
<br />
'''Requirements for structure and style''' Document layout; house style; branding<br />
<br />
'''Page layout for documents''' Paper size and type, change page orientation, margins, page breaks, page numbering, section breaks; header and footer, date and time, adjust page set up for printing or web publishing, facing pages, booklets<br />
<br />
'''Types of information for documents''' Text, numbers, images, other graphic elements (eg lines, borders); hyperlinks, charts, objects<br />
<br />
'''Quality problems with documents''' Will vary according to the content, for example, text (eg styles, structure, layout), images (eg size, position, orientation), numbers (eg decimal points, results of any calculations); links, cross references, versions<br />
<br />
'''Work with multiple documents or users''' Version control, audit and track changes, compare and merge documents, document sharing and collaboration<br />
<br />
'''Format columns''' Add and delete columns, add column breaks, modify column width, add columns to whole document and part of a page<br />
<br />
'''Tables and forms''' Insert and delete cells, rows and columns, adjust row height and column width; Add and amend table structure, merge cells, complete forms and tables, insert and modify form fields, convert text to table; , merge and split cells, horizontal and vertical text alignment, cell margin, add borders and shading, sort, position, headings, totals; heading rows; embedded spreadsheet data<br />
<br />
'''Store and retrieve''' Files (eg create, name, open, save, save as, print, close, find, share); version control; import/export; file size; file properties; folders (eg create, name); archive (backup, restore)<br />
<br />
'''Structure Writer documents''' Sections, bookmarks, cross-referencing using indexes and contents page, master documents<br />
<br />
'''Styles''' Apply or change existing styles to a word, line, paragraph or section; define, organise and use new styles<br />
<br />
'''Keyboard skills''' Using the full range of keys, typing accurately and efficiently, keyboard short cuts, customise keys<br />
<br />
'''IT tools to check text''' Spell check; grammar check; type face, size and kerning; hyphenation, line and page breaks<br />
<br />
'''Paragraph formatting''' Alignment, bullets, numbering, line spacing, borders, shading, tabs and indents, outline, sub-numbering<br />
<br />
'''Formatting techniques for characters''' Size, font style (typeface), colour, bold, underline, italic, special characters and symbols, spacing, position<br />
<br />
'''Templates, tables and documents''' Use existing templates; create, amend and delete templates<br />
<br />
'''Combine Writer information''' Insert, size and position, link information in a document, link information from one type of software to information produced using different software<br />
[[Category:Certification]]</div>Ggurley