8Y – Period 4: Friday 24th May

Yacapaca test

Please log on to yacapaca and take the SHR Unit 8.4 test

Marked work

Your marked spreadsheets from last lesson can be found in Shared:\General\ICT\Year 8\8Y 2011 2112

The test was out of 40 and you can find your mark in cell I1

If you finish…

Please have a go at any of the activities on this page;

http://www.reviseict.co.uk/games/index.shtml?searchQuery=excel

8Y – Period 1: Wednesday 16th May

Band Manager Test

Open the test spreadsheet which can be found in: P:\Senior Pupils\ICT\Y08\Unit 8.4 Band Manager\Lesson_8 and is called 8B_The_Shakes_Marketing_Spreadsheet_Res8b.xls

Then, using the sheet to help you, work through the questions on the spreadsheet.

Please save your spreadsheet in the following folder: Shared:\General\ICT\Year 8\8Y 2011 2112\Band manager test making sure that you include your name in the file name.  Remember to save your work regularly!

If you finish…

Please have a go at any of the activities on this page;

http://www.reviseict.co.uk/games/index.shtml?searchQuery=excel

8Y – Period 4: Friday 11th May

Starter: excel quiz – will you be one of the first 3 to 100%?

Task 1 – Discounts and VAT

At the end of last lesson you started adding discounts and VAT to your model – 10% discount on all prices and 20% VAT on all prices.

Make sure you update your revenue and costs calculations to reflect your new prices.

Task 2 – Using goal seek further

Can you use goal seek to answer the following questions;

1. Make a note of your current profit – if VAT goes up to 22% what discount do you need to keep your profit the same?
2. Change your figures back to 10% discount and 20% VAT – what discount should you give to increase your profit by £500?

Task 3 – Creating and Using Charts

Using the data which can be found in Yourbands_Downloadable_Chart_Res4a.doc which is in the folder P:\Senior Pupils\ICT\Y08\Unit 8.4 Band Manager\Lesson_4, create a chart which shows the number of downloads last week for each band.

1. Copy and paste the data into a new tab on your spreadsheet and also create the chart on a separate tab.
2. You need to sort your data – sort by the No. of downloads last week in descending order.  For help with sorting click here but make sure you watch the screencast to the end.
3. Make sure that you label your chart and your axis correctly.

Extension

1. Can you add this week’s downloads to the chart as well?
2. Watch this video on how to change the style of your chart and then change yours as appropriate.

Task 4 – Making changes to your model

Now the band are doing so well you have decided to try and sell some extra merchandise at your concerts.  Can you think of at least two extra things you could sell at your concerts?  Programmes maybe…

Remember, you will need to buy your merchandise before you sell it so you will need to add rows in costs as well as revenue.

Task 5 – Formatting your sheet

Lots of help available here to assist you in making your sheet highly presentable using borders, shading and colours.

Extension

Can you format your profit and loss figure so that the cell changes colour if the profit goes above £1,000?  Use this screencast to help you and test to see if it works by changing some of the variables.  Can you use this technique on any other cells in your spreadsheet?

8Y – Period 1: Wednesday 2nd May

Starter: Look at the words on the board – choose three that you would like to explain to the person sitting next to you and one that you are not sure about and you would like them to explain it to you.

Task 1: Tour Figures worksheet

Using the tour figures worksheet, extract the correct figures from the email and enter them into the table at the bottom of the sheet.

Task 2: Creating the model

Using the table on your sheet, open the file called Tour Spreadsheet – Res2d.xls which can be found in; Pupils:\Senior Pupils\ICT\Y08\Unit 8.4 Band Manager\Lesson_2 and save a copy in your documents.

Now copy the relevant information from your sheet into the model and see if you can create some of the formulas.

Task 4: Powerpoint Quiz

Using the whiteboards – see if you can answer the questions on the board.

Task 5: Using goal seek

Once the model is complete, use goal seek to answer the three questions at the bottom

Extension

If you finish all of the above, grab your headphones and watch these two videos to find out about relative and absolute cell references;

http://www.teach-ict.net/software/excel_2007/formula/basics/relative_cell_reference.htm

http://www.teach-ict.net/software/excel_2007/formula/basics/absolute_cell_reference.htm

How could you use absolute cell referencing to;

1. Apply a 10% discount to all your prices (tickets, singles and t-shirts)?
2. Add VAT at 20% to all your prices?

Further Extension

Try any of the activities on this page: http://www.reviseict.co.uk/games/index.shtml?searchQuery=excel

8Y – Period 4: Friday 27th April

Starter: Please could you take this survey (click on respond to this survey after following the link) then have a go at Excel Fling the teacher – stickers for the first three flingers…

Unit 8.4 – Band Manager: Introduction

In this unit you are going to be the manager of a new teen band called The Shakes.  You’ve got big plans for them – they are great musicians and have some really catchy songs.  They also put on a great performance and already have a growing fan base.

However, they aren’t very good with money!  They’ve brought you in to help them sort out the business side of the band, to make sure they don’t end up in the bargain bucket too early on in their careers!

You are going to create a business model for the band, in order to keep track of how much money they are spending and how much they are making.

While you are wating for others to finish other activities, have a look on the internet for some pictures which could be the band and save them into your new folder.

Task 1

If you haven’t already done so, please create a new folder called “Unit 8.4 – Band Manager” in your year 8 ICT folder.

Open the file called Shake ‘em up spreadsheet – Res1c.xls which can be found in Pupils:\Senior Pupils\ICT\Y08\Unit 8.4 Band Manager\Lesson_1.  Work through the questions in Activity 1.

Task 2

Before attempting the Activity 2 questions, watch this video about using the goal seek tool – you will need your headphones!

Task 3

Now go on to use goal seek to answer the activity 2 questions.

8Y – Period 1: Wednesday 14th March

MoviePlus Test

I would like you to investigate the wearing of school uniforms in England. Some people say that pupils should not have to wear a school uniform, others say that it is a good thing.

1. I would like you to produce a short movie using MoviePlus, aimed at teenagers aged 13-14. Your research should focus on the following question: Should school uniforms be banned?
2. Your movie should include facts, arguments for and arguments against.

 

Also include;

• At least 5 frames
• Images
• Transitions
• Animations (if appropriate)
• Background music

You have one hour to produce this movie.

Exporting and Uploading your movie

When you have completed your movie, make sure it is saved and then you can export it.  Follow the steps below to export your movie;

1. Choose File – Export Movie – File
2. Choose the 4th option – Windows Media and audio and video (*.wmv) and click Next
3. Choose Local playback and then click finish
4. Save your movie in your 8.3 folder – make sure you include your name in the filename.

When you have exported your movie – please upload it to voicethread

1. Then Click on My Voice
2. Click on 8Y School Uniform Movies
3. Click on the menu button in the top left hand corner and choose edit.
4. Upload your exported movie file and remember to add your name in the title at the bottom
5. If time – add a comment and give yourself 2 stars and a wish
6. Now do the same for others (refresh the page to see new uploads)

 

8Y – Period 4: Friday 9th March

Starter: Pictionary

Using Voicethread – uploading and commenting

Voicethread is a way of sharing your work and allowing others to comment.  If you have already uploaded your work then please add two stars and a wish to the work of others.

Open the voicethread site and log on to your account by clicking the sign in button – your login is your school email address – j.smith@shr.gdst.net for example.  I will tell you what your password is.

After logging in do the following;

1. Change your password – preferably to your school network password by clicking on your name and then account information.
2. Change your time zone to Greenwich Mean Time (it’s in the middle of the list without any ‘+’ or ‘-’
3. Then Click on My Voice
4. Click on 8Y Animal Testing Movies
5. Click on the menu button in the top left hand corner and choose edit.
6. Upload your exported movie file and remember to add your name in the title at the bottom
7. Add a comment and give yourself 2 stars and a wish
8. Now do the same for others (refresh the page to see new uploads)

Challenge Corner

If you are wating for others to upload their work or want a break from commenting try this….

Split Screen Video – tutorial can be found at: http://www.serif.com/appresources/MPX5/Tutorials/en-gb/movieplus.htm or use one of the available printouts.

You can find some video to use in: S:\Media Library\Video\General Access (Read Only)\Chemistry or anywhere else where you can find .wmv files.

 

8Y – Period 1: Wednesday 29th February

Starter: Watch the first comment which explains how to comment and doodle on a video in voicethread. http://voicethread.com/?#q.b21651.i122786

Working on your movies

Today is the last lesson on your movies.

Please remember to save your work regularly!  Every time you insert a new picture /add some text / add a transition or animation – hit ctrl S!

Look at the assessment criteria, work from your plans, use your research for information, get help from your buddies and http://www.serif.com/appresources/MPX5/Tutorials/en-gb/movieplus.htm

Exporting your movies

When you have completed your movie, make sure it is saved and then you can export it.  Follow the steps below to export your movie;

1. Choose File – Export Movie – File
2. Choose the 4th option – Windows Media and audio and video (*.wmv) and click Next
3. Choose Local playback and then click finish
4. Save your movie in your 8.3 folder – make sure you include your name in the filename.

Using Voicethread

Open the voicethread site  and log on to your account by clicking the sign in button – your login is your school email address – j.smith@shr.gdst.net for example.  I will tell you what your password is.

After logging in do the following;

1. Change your password – preferably to your school network password by clicking on your name and then account information.
2. Change your time zone to Greenwich Mean Time (it’s in the middle of the list without any ‘+’ or ‘-’
3. Then Click on My Voice
4. Click on 8Y Animal Testing Movies
5. Click on the menu button in the top left hand corner and choose edit.
6. Upload your exported movie file and remember to add your name in the title at the bottom
7. Add a comment and give yourself 2 stars and a wish
8. Now do the same for others (refresh the page to see new uploads)

8Y – Period 4: Friday 24th February

Starter: Charades

Working on your movies

Please remember to save your work regularly!  Every time you insert a new picture /add some text / add a transition or animation – hit ctrl S!

Look at the assessment criteria, work from your plans, use your research for information, get help from your buddies and http://www.serif.com/appresources/MPX5/Tutorials/en-gb/movieplus.htm

Getting Feedback

During today’s lesson, when it is convenient for you.  Please ask at least one other person to give you feedback on your movie so far.  Ask them to give you two stars and a wish using the assessment sheets.

Is there a good structure to your movie, is it consistent and is there an appropriate sound track?

Exporting your movies

When you have completed your movie, make sure it is saved and then you can export it.  Follow the steps below to export your movie;

1. Choose File – Export Movie – File
2. Choose the 4th option – Windows Media and audio and video (*.wmv) and click Next
3. Choose Local playback and then click finish
4. Save your movie in your 8.3 folder – make sure you include your name in the filename.

Saving a copy of your movie on the media drive

Please also save a copy of your movie file in;  Media:\Video\Pupils (Full Access)\ICT\Year 8\8Y 2011-2012\Animal Testing Movies

Creating a new discussion on the portal and attach your movie to receive feedback

1. Under 8.3 Movies (https://portal.gdst.net/school/shr/Faculties/ICT/y08ICT/8.3InformationSuperhigway/SitePages/Home.aspx), click on add new discussion
2. In the subject box enter a message similar to – “Please watch my movie and leave me two stars and a wish.”
3. Next click on the Attach File icon and browse for your movie file, then click OK
4. Finally, click on Save and your movie will be available for others to watch and to leave feedback.

8Y – Period 4: Friday 3rd February

Starter: Back Scratching

Working on your movies

Please remember to save your work regularly!  Every time you insert a new picture /add some text / add a transition or animation – hit ctrl S!

Look at the assessment criteria, work from your plans, use your research for information, get help from your buddies and http://www.serif.com/appresources/MPX5/Tutorials/en-gb/movieplus.htm

After about 30 minutes of today’s lesson you will have a look at each other’s work and help them out by giving them 2 stars and a wish.