Spring 1: Spreadsheets (Excel)
Download and Save (not open) the files for the exercise when needed. Always use Formuli and cell references like A1!
1. Watch the first 2 lessons in Excel 2007(1) then try the Self Formuli Test click to download> Spreadsheet file
2. Watch lessons 3-6 in Excel 2007(1) then attempt Exam Scores click to download> Spreadsheet file
3. (You will need to watch Excel 2007(2) Nos1&2 before trying the bar charts) Now watch lessons 3 and 6 in Excel 2007(2) then attempt Student Measurements click to download> Spreadsheet file
4. Watch lessons 7 and 8 in Excel 2007(1) then attempt Food Values click to download> Spreadsheet file and Word file
5. Disco! click to download> Word file (Not in use faulty 2007 doc)
6. Profit and Loss click to download> Spreadsheet file and Word file
7. Throwing Coins - we look at the use of random numbers! click to download> Word file
8. Two Dice! click to download> Word file
FINAL EXCEL LESSON
Whilst you are downloading the following files for the lesson plese write down as many KEY TERMS that relate the spreadsheets, graphs and excel.
1) You will need to download the instructions here = Final-Lesson-Exercise
2) You will need the excell starter here. = Final-Excel-Lesson
The Assessment will be based on all skills so far (Formuli, Layout, Functions, Fill & Graphs- Bar / Pie / Scatter) - Try the Skill Check Now! The assessment will be in the last week of this half term. Click for Teach-ICT Unit 7.4 Spreadsheet website
Spring 2: Manipulation of Images (Photoshop). Click for Link to All Support Files @ KES Only
You should apply these ideas / concepts and skills to the following Exercises...
1. Madagascar in Bath. Support files (@KES Only).
2. Elvis at the Abbey Support files (@KES Only).
3. Spot the Ball Support files (@KES Only).
4. Create a large map of
Bath and the surrounds.
and 5. On Thu 24 March you went to Bristol Zoo with the Biology Dept. Now create a Poster to advertise Bristol Zoo.Support files (@KES Only).
End of Term. |
