Students will use self marking worksheets to learn to create their own formulae and understand why they should use formulae. Included are tasks that cater for the lower ability, middle ability and higher ability students. Learning pitstops and challenges are provided to check students understanding and learning of the spreadsheet skills needed for the exam. The functions and formula that students will learn include, SUM, AVERAGE, MAX, IF, COUNTIF, =TODAY(), =NOW(), sorting data, absolute cell referencing, * multiplication, + addition and, autosum. Students will have the chance to practise all the skills using the practice skills 1 and 2.xls included in the resources. These are self marking (they have been adapted to suit the needs of my students) so students can work independently. This allows me to provide small group intervention sessions if necessary for the skills that the students struggle with.
I found these images and created a noise monitoring presentation for my class. The visual aids mean that I don't need to raise my voice when the class are making too much noise. I display the first slide and the students know that they need to be quiet.
This resource is for the teachers and students - Cambridge Nationals Creative iMedia L1/2. It includes the purpose, use and content of the pre-production documents needed to be learnt for the exam unit R081.
These resources are the starting point that I used with my year 9 students after they completed the P.Point unit for ECDL. I have included the skills checklist that I used, the letter that students edit, the big picture to show the students after they complete the tasks for tasks 1-5 on the Word Processing sample test, all the resources that are needed for the sample test, top trumps for group or independent study, TIF (Take It Further) activity trumps cards to challenge the HA students.
I have included a selection of resources / templates that can be adapted to suit your own lessons based on the ECDL spreadsheet unit. I used the intended learning and learning outcomes ECDL file attached to give to the lower ability students. The intended learning and learning outcomes spreadsheet file includes a Take It Further (TIF) / Challenge for the more able. The practice skills 1 and 2.xls are self marking worksheets and allow students top practice some spreadsheet skills.
Covered is the content for the topic 'work plans' for the R081 exam for L1/2 in Creative iMedia. Students need to know the purpose, use and content of work plans. This lesson is a revision lesson with a separate exam question with answers to check students understanding.
Fractions and equivalent fractions. This has been created to be printed out and laminated. The students can then write in the space at the bottom of the sheet with white board pens to work out answers to questions while using the prompts on the sheet.
This resource contains a comprehensive help sheet which allows students to follow it step-by-step to create an interactive quiz in PowerPoint with Visual Basic. It also has learning pit stops and challenges along the way to stretch students of all abilities.
This is lesson 1 in a series of lessons that will allow students to create a PowerPoint with consistent house style, using master slides, etc. (ICT) All 6 lessons in the scheme will teach the students how they can use Visual Basic code to make the presentation interactive and more engaging for an audience. (CS)
A workbook for students to practice the skills they have learnt in class.
Covers curriculum areas:
KS1.2.M.3 recognise and use symbols for pounds (£) and pence (p); combine amounts to make a particular value;
Coin values N.1, count 1p, 2p, 5p and 10p coins N.2, Count all coins N.3, Compare money amounts N.7, Least number of coins N.3