Author: Mr Ali

Functional Skills – Practice Tasks

Lesson Aim 

Practice creating formulas, formatting and creating a graphs in MS Excel.

Your task is to download the spreadsheet below:

Meals Spreadsheet

Now you need to do the following:

  • Create formulas to calculate Profit Margin
  • Create formulas to calculate Total Profit
  • Format your spreadsheet (nb. remember to  format money as currency)
  • Sort your spreadsheet on course into alphabetical order
  • Create Graph for profit margin for each product
  • PDF print it in normal view (nb. you need to add a footer with your details)
  • PDF print it in formula view

Using MS Publisher

Aim of the Session

  • Creating flyers in Publisher (using text, pictures and word art)
  • Extended features of MS Publisher (Page folds, Backgrounds)
  • Manipulating images effectively

Video Tutorials

Your tasks

Task 1

You have 15 minutes to produce a Flyer/Poster promoting the boys Hockey practice on Thursdays 3:00 – 4:15. Meeting place – Outside sports college office and include a couple of images, and the school and sports college logos. 

Task 2

You will create a menu (using book fold) for an Indian Takeaway. The name of the restaurant could be Newsome Bhagis.  You will need to include appropriate images from the Internet.  Use the Information provided below to create your Menu.

Menu Items

Example Menus

 

Unit 1 AO1 re-visited

Your task today is to improve the work you have done for AO1.  You need to clearly explain any measures you have suggested and clearly explain how they will protect the Health and Safety of computer users.

You will also explain clearly what measure you would take to protect files from loss and unauthorised access.

Use links below to help you

Teach -ICT health and safety

BBC Bitesize

You need to add a significant amount of detail to ensure that you pass AO1. If you finish AO1 then you may complete another AO which you have not finished.

Year 9 – AO1 Revisited

Lesson Aims:

  • Improve explanations for health and safety measures suggested in AO1 task
  • Improve explanation for measure to protect files from loss and unauthorised access
  • Explain how to create a strong password

Starter

Health and Safety

Main

Your task today is to improve the work you have done for AO1.  You need to clearly explain any measures you have suggested and clearly explain how they will protect the Health and Safety of computer users.

You will also explain clearly what measure you would take to protect files from loss and unauthorised access.

Use links below to help you

Teach -ICT health and safety

BBC Bitesize