1. Resources Home
  2. Secondary
  3. Computing
  4. Functional IT skills
YEAR 9 SPREADSHEET TEST

YEAR 9 SPREADSHEET TEST

YEAR 9 SPREADSHEET TEST PUPILS HAVE TO INPUT INFO SAVE IT CORRECTLY WIDEN CELLS CARRY OUT A TOTAL CALCULATION PRODUCE BAR GRAPH AND LABEL IT CORRECTLY GREAT RESOURCE TO TEST LEVEL OF UNDERSTANDING AND TO TEST PUPIL LEVELS OF ATTAINMENT.
tesmny
CiDA Unit 1 Developing Web Products - Step by Step Exam Guide (Part 3 - Final)

CiDA Unit 1 Developing Web Products - Step by Step Exam Guide (Part 3 - Final)

Based around one of Pearson Edexcel’s past papers (Impromptoo, January 2017), this presentation (Part 3) covers the remaining elements: converting audio to mp3, formatting titles/text using CSS, image manipulation, creating rollover buttons, using the hotspot tool, and embedding audio (play on click). Using a step by step method, it enables students, when required, to take a degree of ownership for their own learning. Please note, the presentation focuses on use of Dreamweaver CS5.5, Fireworks CS5 and Audacity.
ttootle
JUSTIN BEIBER POSTER IN PUBLISHER

JUSTIN BEIBER POSTER IN PUBLISHER

JUSTIN BEIBER POSTER IN PUBLISHER PUPILS HAVE TO CREATE A POSTER FOR A FORTHCOMING CONCERT AND INCLUDE AND SHOW AS MANY SKILLS AND FEATURES AS POSSIBLE THEY HAVE USED IN PUBLISHER SOFTWARE.
tesmny
SPREADSHEET ASSESSMENT

SPREADSHEET ASSESSMENT

ONE PAGE RESOURCE WITHIN WHICH PUPILS HAVE TO TYPE IN INFO INTO EXCEL AND THEN MAKE CHANGES TO THE INFORMATION . 6 TASKS TO COMPLETE INCLUDING BAR GRAPH AND LABELING.
tesmny
Excel Project from beginner to advanced

Excel Project from beginner to advanced

This is a mini project that lasts about 60-100 minutes depending on the ability of the students. I used this for my year 9 and 10 students but it can also be used for other years. Allow them to create the project themselves as they will learn how to merge cells and add borders to the cells as well as other formatting skills. This project includes using a lot of functions and useful tools in excel and is great if you want the students to learn independently. This project is super easy to mark as all you need to do is check whether they have completed the set tasks and give them a grade and a comment. If the students forget or do not know how to create Vlookups or If statements then I direct them my Youtube channel which actually has a tutorials on how to do both of them. The link can be found below. Let me know if this is useful or helpful to any of you.
MrSaleem
MY FAVOURITE THINGS ACTIVITY

MY FAVOURITE THINGS ACTIVITY

SUPERB COLOURFUL ONE PAGE RESOURCE WITHIN WHICH PUPILS HAVE DRAW SQUARES WITHIN THEIR WORK AND THE SELECT PICTURES OF THEIR FAVOURITE PASSTIMES/ INTERESTS. PUPILS RESIZE THEIR PICTURES AND INSERT IN THE RELEVANT SQUARES. GREAT PUPIL ENGAGEMENT WITH THIS TASK AND IS AN ICEBREAKER AS YOU GET TO LEARN WHAT INTERESTS PUPILS HAVE.
tesmny
YEAR 11 DESIGNING A BROCHURE IN PUBLISHER (3 WEEK HOMEWORK PROJECT )

YEAR 11 DESIGNING A BROCHURE IN PUBLISHER (3 WEEK HOMEWORK PROJECT )

YEAR 11 DESIGNING A BROCHURE IN PUBLISHER (3 WEEK HOMEWORK PROJECT ) BRILLIANT RESOURCE WHEREBY PUPILS HAVE TO DESIGN A BROCHURE TO BE USED TO ATTRACT NEW FIRST YEAR PUPILS TO THEIR SCHOOL. ALL TASKS AND CHECKLISTS ARE LAID OUT IN THIS SEVEN PAGE DOCUMENT AND PUPILS CAN KEEP A TRACK RECORD OF THEIR PROGRESS THROUGHOUT. TASK CAN ALSO BE DONE IN CLASS AS IT IS QUITE A DETAILED TASK WHICH WILL GIVE THE TEACHER THREE WEEKS PEACE.!!!
tesmny
END OF TERM PARTY PROJECT

END OF TERM PARTY PROJECT

WONDERFUL RESOURCE WHICH WOULD ENCOMPASS 3 WEEKS PUPIL WORK ASSUMING 3 TIMETABLED FORTY FIVE MINUTES PERIODS PER WEEK. BRILLIANT FOR YEAR 9, 10 AND 11 WHO REALLY BUY INTO THE ACTIVITY. DETAILED TEACHER SPEAKER NOTES ARE PROVIDED TO COVER ALL THE SKILLS CRITERIA THAT ARE COVERED FOR THE PLEASURE OF INSPECTORS AND DEPARTMENT HEADS. ONCE INSTRUCTIONS ARE GIVEN FOR THE TASK TEACHER SHOULD ONLY HAVE TO BE MONITORING THE PROGESS OF THE PUPILS WORK.
tesmny
Labelling e-mail components

Labelling e-mail components

SIMPLE ONE PAGE RESOURCE IN WORD WHEREBY PUPILS ARE TASKED TO IDENTIFY AND LABEL THE MAIN AREAS RELEVANT TO SENDING A NEW EMAIL.
tesmny