ISSUE FOUR 2011

The 2011 teaching year is nearly over and shortly the examination season will be upon us, hopefully those tackling new achievement standards are feeling confident. Some of you who have not availed yourself of the CETA Practice Exams should note they are still available.

CETA has been working on the development of more support materials for members. In this newsletter you will find new resources for Business Studies and for Digital Technologies. It should be noted that the CETA Business Studies Teachers Handbook for NZC Level 8 / NCEA Level 3 in nearing completion. There are several more Digital Technologies resources in production, as well as Economics and Accounting materials concentrating on

NZC Level 7 / NCEA Level 2. We will ensure that we send out email notification as materials are completed.

The Term 4 2011 subject catalogues are now available and will be on our website in the next day or two.

Each term we will place this symbol beside the descriptor of all new resources.

We are in the process of refreshing the NZCETA website. The site is intended for information, not as a marketing tool, and to this end we have added another section. You will note a new section called Subject Landscapes, the intent of which is to give a one-stop reference for members to find Ministry of Education and New Zealand Qualifications Authority information and links, as well as other information applicable to each subject. It varies from the Subject Profiles section which provides NZCETA’s policy on the subject in New Zealand secondary schools.

Don’t forget to take a minute or two to complete and send the Members Input form on the website as it does help us to meet your needs and assists with our forward planning.

Please note that there is a comprehensive range of previously advertised resources in each of the Catalogues which can be found on or email requesting the specific catalogue/s you would like emailed to you. NOTE all prices are GST inclusive. All resources are sent on disk with the exception of booklets which can be hardcopy or disk copy and posters which are hardcopy only. Please ensure you read the NZCETA Sales Policy prior to purchasing resource materials. All credit orders MUST include a school order number.

BUSINESS STUDIES

Level 1 Business Studies Code BS 11/4/1Price $28

Demonstrate an understanding of external factors influencing a small business

AS 90838 (1.2)

Economic Influences ppt

Theme: Business Environment

This comprehensive powerpoint addresses the main areas of information and content required for the topic Economic Influences on business within the theme Business Environment and will assist with the coverage required for the achievement standard – demonstrate understanding of external factors influencing a small business. The powerpoint will provide teachers with an excellent starting point for the teaching this unit and save hours of work and research time. 22 slides

Level 1 Business Studies Code BS 11/4/1Price $28

Demonstrate an understanding of external factors influencing a small business

AS 90838 (1.2)

Environmental Influences ppt

Theme: Business Environment

This comprehensive powerpoint addresses the main areas of information and content required for the topic Environmental Influences on business within the theme Business Environment and will assist with the coverage required for the achievement standard – demonstrate understanding of external factors influencing a small business. The powerpoint will provide teachers with an excellent starting point for the teaching this unit and save hours of work and research time. 21 slides

DIGITAL TECHNOLOGIES

Take a Journey with InDesign CS5Code DT 11/4/1 Price $60

NZ Curriculum Levels 6/NCEA Level 1

Learning Objectives How to Guide: learn how to use a range of tools within the Adobe InDesign CS5 software to create an interactive digital story using images, text, buttons and hyperlinks

Digital Technologies Context Digital Media

Assessment Links Could be used in preparation for Internal Digital Technologies Achievement Standard 91073

Contents: Resource Descriptor; Teacher Guidelines; Curriculum Links; Key Competencies; Qualifications Framework; Creative Commons; Activity

This resource package covers the basic skills needed to design and create an interactive photo story using Adobe InDesign CS5. It is a Pick-Up and Go learning activity consisting of a step by step “how to guide” covering the basics of In Design.

Skills covered include: how to set up documents; setting up and applying master pages; creating frames; placing images and text; formatting text; creating drop caps; using the library buttons; covert objects to buttons; creating hyperlinks; saving and exporting; using Adobe Bridge – purging Adobe Cache

All support resources are included with the resource package. It could be used with CETA’s Photoshop resource Using Photoshop Code DTB 1 in preparation for the Level 1 Digital Media Achievement Standard 91073 – implement basic procedures to produce a specified digital media outcome.

Club Secretary – Internal AssessmentCode DT 11/4/2Price $50

NZ Curriculum Level 7

NCEA Level 2 AS 91368 (2.41) Implement advanced procedures to produce a specified digital information outcome with dynamically linked data

Theme Club Secretary – Internal Assessment – 6 credits

Contents: Resource Descriptor; Teacher Guidelines; Curriculum Links; Key Competencies; Qualifications Framework; Content Development; Assessment; Suggested Solutions; Text and data for student use

This resource covers the documents a club secretary would need to be familiar with and is an assessment for AS91368. The scenario is a new club secretary preparing a presentation to their club’s committee to persuade the committee to update their systems for communicating with members. It involves the creation of a data base and the design of queries, reports and forms for that database. The data base is linked to two different covering letters depending on the role of the member in the club. Attached to the letters is a newsletter which is designed as a template and has a spreadsheet and graph embedded in it. The minutes are also attached for the committee members.

Where did I come from?Code DT 11/4/3Price $40

NZ Curriculum Levels 4 and 5

Learning Objectives Learning the technology process and Developing, trialling and modifying

Digital Technologies Context Digital Media

Assessment Links Could be used in preparation for AS91073 (1.43)

Contents: Resource Descriptor; Teacher Guidelines; Curriculum Links; Key Competencies; Qualifications Framework; Content Development; Student Task; Student-Designed Checklist; Teacher assessment schedule

This resource is a junior technology project to develop the technology process for either year 9 or 10. It sets out the steps for the student to follow in developing, testing and modifying a digital technology media outcome and a student self-assessment check list. The student explore own family history and produces a booklet for a family reunion.

Skills covered include: Writing a brief and specifications; Preparing conceptual designs; Researching a topic (legal and ethical issues); DTP booklet design skills; Using the appropriate elements of design; Trialling the outcome in terms of folding, page order and data integrity; Entering the text and graphics that have been researched by the student; Stakeholder consultation (Teacher) Final production; Student evaluation of their outcome

US 111 – School Sports CommitteeCode DT 11/4/4Price $50

NZ Curriculum Level 7/NCEA Level 2

Learning Objectives to assess Unit Standard 111

Theme School Sports Committee

Domain Business Administration

Digital Technologies Context Digital Media

Assessment Links Could be used in preparation for AS91073 (1.43)

Contents: Resource Descriptor; Pre Assessment Checksheet; Assessment Task; Observation Sheets; Suggested Solutions; Evidence and Judgement Statements; Marking Sheet

This resource is a suggested assessment activity for Unit Standard 111 version 7. It includes the necessary

components to ensure that the students can meet the standard and also extents their skills in Microsoft Word.

The theme used is a sports committee. All support resources are included in this resource package.

Prior Knowledge Prior to completing this assessment students should have cover a range of tasks in Microsoft Word and built up confidence in the program. Students need to not only be able to format a document but also ensure that the document has been formatted appropriately for the situation. The assessment is not only restricted to the evidence of the techniques listed but also includes things such as section breaks to ensure that borders can be on some pages, page numbering using footers and page numbering.

Prior Learning CETA resources that could be used as learning tasks in preparations for this assessment DT 06/1/11 Word Processing to create outcomes and DT 07/1/3 Pre Assessing Word Processing could be used as learning material prior to this assessment.

Wonders of Word! A touch on advance Code DT 11/4/5 Price $60

NZ Curriculum Levels 7/NCEA Level 2

Learning Objectives To build students confidence up in using some of the advanced tools of Microsoft Word. Giving them the opportunity to explore and discover using different advanced tools and techniques

Digital Technologies Context Digital Information

Theme: 10 Must-Do’s For Kiwis

Assessment Link Could be used in preparation for Internal Digital Technologies Achievement Standard 91368 Digital Information Implement advanced procedures to produce a specified digital information outcome with dynamically linked data

Contents: Resource Descriptor; Teacher Guidelines; Curriculum Links; Key Competencies; Qualifications Framework; PowerPoint Instruction and Activity PowerPoint; Retrieval Files; Suggested Solutions at different stages; Checklist for Peer Review at the end of the task

This resource pack includes a PowerPoint covering the advanced skills, how to use them and an activity for students to complete for each skill. The resource could be used as a self-paced learning tool or used by the teacher as a way of introducing the tools and giving students the knowledge to discover and explore these further.

Skills covered include: Styles; Table of Contents; Breaks; Footnotes; Mulitlevel numbering; Linking and Embedding; Referencing; Review Tools; Templates

All support resources (retrievals and suggested solutions) are included with the resource package. This resource could be used with CETA’s DT 11/4/6 and DT 10/4/2 or any other resources that include word tools.

Dabbling with DatabasesCode DT 11/4/6Price $45

NZ Curriculum Levels 5

Learning Objectives How to Guide: - learn how to use a range of tools within Microsoft Access software to create a simple dataset, followed by creating simple queries and creating a report using the wizard functions

Digital Technologies Context Digital Information

Assessment Links Could be used in preparation for Internal Digital technologies AS 91071

Contents: Resource Descriptor; Teacher Guidelines; Curriculum Links; Key Competencies; Qualifications Framework; Creative Commons; Activity

This resource package covers the basic skills required to introduce NZC Level 5/Year 10 students to a basic flat file database using Microsoft Access 2010. If you have an older version this resource can be adapted easily as the process is the same. Dabbling with Databases could be used as a Year 11 resource if you wish to use databases for AS 91071 Implement basic procedures to produce a specified digital information outcome. Included in this resource are three short PowerPoints to assist teachers in introducing Databases, student activities and suggested outcomes.

Skills covered include: Creating a database; Saving the database; Sorting the database; Extracting a query; Create a report; Data integrity. Additional Resources: Power Point Presentations - History of Databases; Hints for Using a Database; Introducing Databases NZC Level 5/Year 10 Templates: KWHL template to be used at the beginning of the unit; Planning template

Dabbling with DatabasesCode DT 11/3/1Price $60

NZ Curriculum All Levels

Learning Objectives How to Guide: - learn how to use VBA tools by creating a simple, interactive quiz slide within Microsoft PowerPoint

Contents: Resource Descriptor; Using VBA; Creative Techniques; Glossary of Terms; Creating a Quiz; Task 1 – 5 steps on How To with screen shot assistance; Task 2 extra project with new tricks – 8 steps on How To with screen shot assistance; Review Activity; PowerPoint Review Quiz with Answers.

This easy to follow, comprehensive user friendly teaching resource will guide you through a step by step tutorial teaching you how to create simple, fun and funky interactive quiz slides within Microsoft PowerPoint.

You will quickly learn how to link PowerPoint with Visual Basic Editor tools to design pop-up message boxes, feedback statements and easy navigation structures within your slideshows.

The resource includes a quick revision test and examples of cross curricular, student designed learning activities.

Students can work through these tasks individually and also choose to extend themselves and try different challenges along the way.

Please note that all CETA resources are produced using Microsoft Windows XP

Ordering Resources from NZCETA

All prices are GST inclusive.

  • The order form lists all the new resources which are described in the newsletter.
  • Only use the correct order form. Orders will be accepted via email, fax or post – no telephone orders are acceptable. If payment is not attached, a school order number must be given.
  • When ordering resources from the CETA catalogue, write the name and number of the resource in the blank space provided at the end of the order form.
  • All resources are available on disk only with the exception of booklets which can be in hardcopy or disk and posters which are in hardcopy only.
  • When an order is received CETA prepares a Tax Invoice, including the CETA GST number. If payment accompanies the order, the invoice is stamped ‘Paid’, if not it is stamped “Payment Due within Seven Days”. The invoice is sent with the order.
  • Members’ differential: to take advantage of the differential we offer to CETA members, it is essential that you complete the appropriate section on the order form with your membership number. To receive this differential the order must be made by a member and not on behalf of another person, or by quoting another member’s number. We know that members appreciate this differential, and we are keen to continue our policy, but we must ensure that it is not abused, or it will be necessary to reconsider.

Delivery of Resources

 All resources are sent using courier services.

 Postage fee: A flat fee of $11.00 is payable on all orders to cover courier and packaging costs. Please remember to include this in the order total.

 Courier service: The courier service CETA uses requires all mail to be addressed to a street address. For this reason, it is essential to supply a school street address on all resource material orders. A post office box or private bag is not acceptable.

Payment for Resources

  • CETA prefers payment with order.
  • Please make cheques payable to NZCETA, and crossed Not Transferable.
  • CETA would like to encourage members and schools to use direct crediting when paying for subscriptions, professional development, and resource purchases. Schools will need to send a Direct Credit Authorisation Form to CETA for bank account details. Please note that if this type of payment is used it is essential to indicate what the payment is for, example “resources”, “PD”, “subs – name of member”.
  • All prices include GST.

Resource Reviewing/Moderation/Evaluation

All CETA resources have been checked by experienced subject experts. Please note that this is not an official NZQA moderation.

NZCETA Copyright

A copyright statement has been included in the C & MS Newsletter for a number of years. We wish to emphasise this statement as we know some people have breached Copyright and NZCETA wishes to make it clear that it will not hesitate to take action if this continues. Reference can be made to The Copyright Act 1994, Section 44 (revised in January 1998) regarding educational establishments. The purchasing of a resource is not gaining prior permission. Please note the following statement which appears on all NZCETA resource materials.

Use of NZQA copyright materials: CETA has obtained permission from NZQA to use, where appropriate, Achievement Standards Criteria and Unit Standards Criteria, as well as NZQA produced NCEA resources to support CETA produced resources. Links with The New Zealand Curriculum where appropriate are indicated by NZC Links. Should you have any queries, please do not hesitate to contact us.

Educating Young People Who Will Be

Significantly Different!