Category: Uncategorized

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

 

Year 11 – Cloud Computing

Lesson Aim

  • Pupils will understand what is meant by cloud computing.
  • Pupils will be able discuss benefits of cloud computing
  • Pupils will be able to discuss possible costs of cloud computing

    •  

Starter

Cloud computing video

Your Task

Produce a presentation in Powerpoint explaining what is meant by cloud computing and the benefits and disadvantages of cloud computing.

Use this link Cloud computing

Unit 1 – 2010 AO4 Business letter

Your task is to create a Business letter using your House Style. The letter is for the parents of Year 11 pupils at Newsome wanting to go on the Paris trip.

Here is an example of the content you may put in the letter.

Example letter

 Use the presentation below to help you decide how to layout a business letter:

Copy of Personal Block Style Business Letter on Prezi