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)
See the worked example below on both the spreadsheets, then try to do the same task again. Save
Complete the second worksheet in the same way as the first. Save
If you are struggling there are some help tutorials listed below from Teach-ICT
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
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. Research & Homework
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:
Details of place
Hotel & Food details
Flight Details
Luggage details
Transportation
Activities- Creativity & Action
Service
Credits
Optional for self running presentation, could be downloaded with activities booklet from Gateway.
Video
Narration
Week 4
Effective Presentations Task 1
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. Task 2
Prepare PowerPoint /Google presentations (covering essentials of good presentation, using speaker notes, 5x5 Golden rules) and rehearse
Week 5
Task 1
Making Presentations - complete as a group the presentations, final touches
Present PowerPoints / Google presentations Task 2
VLookup functions in Spreadsheets
Task 2
Working individually:
Person 1: Info leaflet/booklet for parents.
Person 2: Costs Spreadsheet. (re-model the ones from week 3)
Person 3 Advertisement.
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
Table of Contents
Introduction
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:
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)
- See the worked example below on both the spreadsheets, then try to do the same task again. Save
- Complete the second worksheet in the same way as the first. Save
If you are struggling there are some help tutorials listed below from Teach-ICTTask 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
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.
Research & Homework
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:
- Details of place
- Hotel & Food details
- Flight Details
- Luggage details
- Transportation
- Activities- Creativity & Action
- Service
- Credits
Optional for self running presentation, could be downloaded with activities booklet from Gateway.Week 4
Effective PresentationsTask 1
CountIF and IF Statement in Spreadsheets.Use lesson 4 spreadsheets (students copy lesson 4 student resources).
- COUNTIF Video Tutorial
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.Task 2
Prepare PowerPoint /Google presentations (covering essentials of good presentation, using speaker notes, 5x5 Golden rules) and rehearse
Week 5
Task 1Making Presentations - complete as a group the presentations, final touches
Present PowerPoints / Google presentations
Task 2
VLookup functions in Spreadsheets
- VLOOKUP Video Tutorial
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 GroupsTask 1
Creating a mail merge from a VLookup spreadshe
- Mail merge from spreadsheets (no sound)
Resources:Task 2
Working individually:
Person 1: Info leaflet/booklet for parents.
Person 2: Costs Spreadsheet. (re-model the ones from week 3)
Person 3 Advertisement.
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 togetherContinue from Week 6
Week 8
Conclusion (evaluation)Finish and burn work to CD
Final Tasks
Burned onto CDPowerPoint / 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 STAFF21st June 2010 in Room 334