Year+9+ICT+CAS+Week+Project

toc = Introduction = media type="custom" key="5956611" = Week 1 = You are going to be working in groups of three, and you will each contribute to to the spreadsheet model and presentation. Your final presentation will be presented to a live audience made up of your peers and teachers.

Your will establish where the activity will take place. You have two options:
 * Abroad for Years 10 - 12 (minimum 12 student, maximum 48 students) within the Asia - Pacific region
 * In Hong Kong for all Year 7 (180 students) with a different activity for each of the 5 days.

= Week 2 = Using Spreadsheets - looking at relative and absolute cell referencing and picklists. Using the 'Lesson 2' spreadsheets (copies are in the Homework Drive and attached below) If you are struggling there are some help tutorials listed below from Teach-ICT
 * 1) See the worked example below on both the spreadsheets, then try to do the same task again. //**Save**//
 * 2) Complete the second worksheet in the same way as the first. //**Save**//
 * **@http://www.teach-ict.net/software/excel_2007/excel_2007.htm** - Look for the section on Formulae Basics and Validation

**Task 1** **Task 2**

**Task 3 / Homework** Once you have completed this task, start your online research on travel, activities, and accommodation costs for the trip, keep your information on a spreadsheet, (You may use a Google Docs spreadsheet which can be shared) for your research and use hyperlinks to the original sources / websites. This task is to be completed for homework between the group members.
 * Pick Lists**
 * Drop Down Pick List Video

= Week 3 = Introducing Modelling - looking further into relative and absolute cell references and picklists. Modelling a spreadsheet to manage the saving up of the deposit for CAS week.

Look at the above the spreadsheet … Modeling a students finances to see if they can save the deposit for CAS week. Complete the Task individually. You are going to work in your groups preparing a PowerPoint / Google presentation, next week you will work on them further in the lesson. Use this link to the Year 7 project for some tips and help: http://msc-ks3technology.wikispaces.com/Photos+of+HK What should you include in your presentation: Optional for self running presentation, could be downloaded with activities booklet from Gateway.
 * Research & Homework**
 * Details of place
 * Hotel & Food details
 * Flight Details
 * Luggage details
 * Transportation
 * Activities- Creativity & Action
 * Service
 * Credits
 * Video
 * Narration

= Week 4 = Effective Presentations CountIF and IF Statement in Spreadsheets.Use lesson 4 spreadsheets (students copy lesson 4 student resources). Work through the first worksheet on the spreadsheet on the board … students then do this themselves and try to complete the second worksheet of spreadsheet themselves. Prepare PowerPoint /Google presentations (covering essentials of good presentation, using speaker notes, 5x5 Golden rules) and rehearse = = = Week 5 = Making Presentations - complete as a group the presentations, final touches Present PowerPoints / Google presentations VLookup functions in Spreadsheets Select person 1, 2 and 3 in the group and read the following document: For an example of advertising done for the D&T trips to Cambodia by Mr Atkinson = Week 6 = Communicating with Groups Creating a mail merge from a VLookup spreadsheet (using Word and Excel) Working individually: Person 1: Info leaflet/booklet for parents. Person 2: Costs Spreadsheet. (re-model the ones from week 3) Person 3 Advertisement.
 * Task 1**
 * **COUNTIF Video Tutorial**
 * Task 2**
 * Task 1**
 * Task 2**
 * **VLOOKUP Video Tutorial**
 * **http://msc-technology.wikispaces.com/CAS+-+Cambodia**
 * Task 1**
 * **Mail merge from spreadsheets** (no sound)
 * Resources:**
 * Task 2**



Health Week
Designing a T-Shirt for your group going on your CAS Week trip - to wear to and from the airport, and for CAS Service activities, representing Sha Tin College. Click on the link below for more details:

= Week 7 = Pulling it all together Continue from Week 6

= Week 8 = Conclusion (evaluation) Finish and burn work to CD

= Final Tasks = Burned onto CD PowerPoint / Google presentation … Group Information Booklet for parents … Person 1 Costs Spreadsheet … Person 2 Merged Letter to Parents … Person 1&2 Video Advertisement … Person 3 A document explaining who did each section … Group

= = = Week 9 = **FINAL PRESENTATION TO SENIOR MEMBERS OF STAFF 21st June 2010 in Room 334**