This is a very good scheme of work on paper. However do feel some of the topics are done over a too short a time period. Also - perhapssome work on Gimp or Photoshop and perhaps some HTML/CSS would be a good idea? Not all kids like to code and some really enjoy the graphics side. It would make the Art Department very happy! I like the Green Screen/animation softwartware - but my school would not pay for this - do you know of any alternatives?
Good mix of ICT and Computer Science activities. We have been using stop go animation and scratch for some time. Both will add the academic rigour as well as the fun and enjoyment that you are looking for. Many of your ideas tie in to what we are trying to build at our school. With stop go we used movie maker and it works very well.
All units follow the UK National Curriculum for Computing and contain all teaching materials, lesson activities, assessments, mark schemes, homework activities, videos, code samples, help sheets, software tutorials and full solutions.<br />
Purchase the Scheme at http://www.heatonmoordigital.co.uk/Secondary<br />
Individual Year Schemes and individual units can be purchased also to suit your requirements.<br />
A three year scheme of work for Key Stage 3 students in Computing<br />
Lesson resources available through subscriptions or for purchase at:<br />
These are all the assets needed to create the Fly Splat app with your students.<br />
It is intermediate/advanced level in that it uses TinyWebDB among other components to make it multi-user.<br />
You'll find the app and the link here:<br />
A series of video tutorials aimed at GCSE Computer Science students.
The tutorials teaches exam relevant concepts useful for all exam boards that offer GCSE Computing or Computer Science.
Teaches Intermediate and Advanced level skills and assumes some basic previous knowledge of App Inventor (i.e. they have done the cat/paint-pot/mole-masher standard tutorials on the App Inventor Website).
An selection of easy to follow task sheets and accompanying Excel spreadsheet to develop more complex spreadsheet skills. Techniques covered include working with 3D cell references in a formula, beginning to use VLOOKUP, using AND within an IF statement, the PMT function, Data Validation and applying Conditional Formatting.<br />
These Advanced Spreadsheets resources were developed originally to help students build skills required for the Level 3 Advanced ECDL, but are also useful for developing more complex spreadsheet skills for other purposes, both at KS4 and KS5.<br />
3D Referencing and LOOKUP<br />
3D-Referencing-and-LOOKUP-in-Excel.docx - instructions / task sheet<br />
3D-Ref---Student-Markbook.xlsx - 4 worksheets to be used with this task<br />
Conditional Formatting<br />
Conditional-Formatting---Quick-Practice.xlsx - 5 sets of data requesting different conditional formatting<br />
Data Validation<br />
Data-Validation-in-Excel.docx - instructions / task sheet<br />
Data-Validation-Workbook.xlsx - 3 worksheets to be used with the Data Validation task<br />
IF and AND<br />
IF-AND-in-Excel.docx - instructions / task sheet<br />
Animal-Rescue-Worksheet.xlsx - 4 worksheets to use with the IF and AND task<br />
PMT Function<br />
Loans-Spreadsheet.xlsx - a worksheet containing details of 6 loans to calculate the repayments on<br />
PMT-in-Excel.docx - instructions / task sheet
Video tutorials of using a variety of tools in Adobe Fireworks.<br />
These video tutorials have two activities for students to complete, creating a vector bunny and creating a bitmpa desert island.<br />
6 Videos in total.<br />
This is great as a guide/differentiation of how to use Fireworks.
Based on Kagan's collaborative learning techniques.<br />
A wide range of questions all about the features and functions in Microsoft Excel<br />
Lucky Dip is carried out in groups of 4.<br />
Student 1 picks one of the questions, randomly from either a basket or envelop placed on their desk and reads it out<br />
Student 2 answers the question as best as she or he can<br />
Student 3 records the answer on paper for the group<br />
Student 4 see's if he/she agrees with the answer, either corrects or debates another possible answer, or praises student 2 for their answer.<br />
The roles then rotate.