Additional Work for Final Week

In the Physical Education folder in the shared area, you will find a PDF document called 'Sports Day Results 2015'. If you have completed all of your work from this half-term, I would like you to uses the Sports Day results to create a poster/infographic or presentation using whichever programme best suits your needs.

Work for Thursday 9th July

You should be nearing completion of your project where you have produced 4 pieces of work on a topic of your choice. If you have finished, you should design a poster for Sports Day. Some things you may wish to consider:

• Date
• Events
• Times of Events
• Details about your house

You can use any program you like, but why not try www.piktochart.com to make a really eye-catching poster? For more details and to see the actual Sports Day programme, CLICK HERE

Year 8: Promotional and Advertising Campaign

This term we will be working on a promotional and advertising campaign based on an idea of your choice, something we have covered in ICT this year or a current event/product (I'll give you more ideas later):

Here is what you need to produce over the next 6 weeks:

Mandatory:

• Presentation (PowerPoint or Prezi)
• Poster (use format of your choice but you may wish to try Piktochart )

Optional (choose 2 from the following):

• PowToon
• Radio Advert (Audacity)
• Video (Movie Maker/Premier Pro/iMovie)
• Animation

If you have enjoyed a particular aspect of ICT this year then you could base your project on that. You may wish to use a particular film/celebrity/video game/app etc as the basis of your project

If you are still struggling to think of an idea, you could use one of the following as a theme:

• Music Festival(s)
• The Rugby World Cup (starts in September and hosted by England)
• A new governing body for Football (to take over from FIFA)

The theme of your project is not the most important thing. It is the quality of the 4 pieces of work that you produce over the next 6 weeks that count. You will be asked to present your campaign in the last week of term and show the class what you have done.

You can work in pairs or on your own. If you are working in pairs, you need to make sure that BOTH PEOPLE ARE WORKING. It would also be a good idea to save work in both of your documents so that the work can continue if one of you is absent.

The important thing is to take your time and make sure that the work you produce is of the highest quality. Remember you have 6 weeks to complete these tasks!

Finally, I am thinking of emailing your work at the end of the project to your parents to show them what you have done. Make sure it's good!

 

Year 7 - Creating and Advert for your Campaign using Powtoon

Today I would like you to use a website called Powtoon to create an advert for your trainers. You may remember using this before but I have made a tutorial for you below if you want some more help:

Things to include in your advert:

• Your logo, picture of trainers, price and slogan
• A good voice over
• Music
• Animation
• Slick changes between 'slides'
• No wasted time

You have over 3 weeks to work on this project so do not rush, take your time and make every part of your advert perfect.

Kahoot!

Use this link to join the quiz:

HERE

Year 8: Video Games Review

Now that you have completed your Games Console Time-Line, I would like you to review 3 different video games of your choice. Try to choose games from different genres. Download the sheet by clicking on the link below and save it into your ICT folders:

HERE

On the worksheet , you will have to answer questions about each game such as:

• Target Audience
• Console
• Genre
• Rating
• Review

If you would like to add further details, you could add screen shots of the game and find out where the game could be purchased for the cheapest price.


 

Year 7: Work for this week

 

1. Finish your 3 trainers and questionnaire
2. Summarise the findings of the questionnaire on your PowerPoint
3. Create a Special Edition Trainer based upon the feedback you received
4. Now get AT LEAST 10 people in the class to look at you 4 trainers and vote for their favourite
5. Make a graph/Pie Chart to show these results on your PowerPoint

 

Create a Promotional Poster of your number 1 design to include:

• A new logo (not Nike)
• Name of Company
• Price
• Name of Shoe
• Available colour schemes

 

Market Research

Once you have completed the Logo Review task, you should begin the 'Market Research' task that I presented to you at the start of the lesson. The PowerPoint presentation can be found by clicking on the link below:

Market Research Task

Once you have pasted your 3 designs onto your PowerPoint, you must complete some Market Research on your product. Here are some questions you may wish to consider:

• Which is your favourite design?
• Why?
• How much would you pay for your favourite design?
• Would you wear these as a fashion item or for sport?

Now you need to write 5 questions for your research (use mine or make some of your own). You must ask these questions to at least 5 members of the form (must be at least 1 boy and girl). You should make a note of their answers and then summarise the results on a final slide on your PowerPoint presentation.

 

Year 8: A History of Game Consoles

You can use this template (or create your own) to make your own timeline for computers, games consoles or other pieces of technology:

CLICK HERE FOR TEMPLATE

You are going to do a bit of research on Games Consoles and create your own timeline. Below are a couple of examples:

 

 

 

1.       Research using the internet and the links below

2.       Pick 5 consoles and the date they were released & create timeline

3.       You must include: DATE in large letters, A picture of the console and a small write up in your own words.

 

 Video games consoles history - http://www.hongkiat.com/blog/evolution-of-home-video-game-consoles-1967-2011/

History of computer games timeline - http://www.timetoast.com/timelines/history-of-computer-games--2

 Video games platforms - http://en.wikipedia.org/wiki/Category:Video_game_platforms

 History of gaming platforms - http://www.gamasutra.com/view/feature/131956/a_history_of_gaming_platforms_.php?print=1

 Some game engines - http://www.develop-online.net/news/the-top-14-game-engines-the-list-in-full/0114330

 

Year 7 - Walk this Way

This term, we will be completing a project where we design a pair of trainers. In addition to this, we will be designing a company logo, creating adverts for our product and slogans for our advertising campaign.

Click the links below to complete a quiz on famous company logos and advertising slogans:

Logo

Logo 2

Logo 3

Logo 4

Slogan 1

Slogan 2

Take a screenshot of your completed quiz (by pressing 'PrtScr') and then paste it onto a Word document in your ICT folders.

Once you have completed the quizzes, use the sheet from Mr Bidwell to complete a review on different logos.

Year 8 - Computer Game Genres

I have just shown you the PowerPoint on Computer Game Genres. Now try to complete the worksheet below (remember to download it into your documents):

Worksheet

If you would like to see the PowerPoint again to help you to complete the worksheet, it is HERE
 

Year 7 - Scratch Project for Last 4 Lessons

Download this Project Planning document by clicking on the link below:

PLAN

You should complete the plan for the project in the lesson today and save it into your ICT folders. If you finish the plan, you may start your Scratch project. The last 3 lessons of term will be spent completing the project. You should try to design a game or an animated story.

Try to use all of the skills that you have learned by completing the tutorials over the last week.


 

Work for Today

You now have 4 lessons to complete your quiz. You should use images, line up cells and change the background; making it as visually appealing as possible.

For those who have already completed a lot of questions, you could add another IF formula which will allow you to accept multiple answers for a particular question and still be correct.

For example, if you had the Spurs badge as your image, but somebody typed 'Tottenham' it would say they were wrong. You can now change this using this formula as an example:

=IF(OR(A1="Spurs",A1="Tottenham"),"Correct","Wrong")

This could be useful in other ways too. For instance, if you have a celebrity quiz, now you can accept full names or surnames as a correct answer. Try to use this formula at some point in your quiz.

Year 7: Preparation for your Scratch Project

You have 2 lessons to complete as many of the word tutorials that are in the folder named below:

W:\Professional Studies\Professional Studies\ICT\KS3\2.Spring\Year 7 Spring 2 - Sequencing\Tutorials

Once you have completed each tutorial, you should save the scratch file in your ICT folder (in a new folder called 'Scratch').

Using the IF Formula in Excel

Have a go at the the quiz created by Miss Goodwin on excel by downloading the file on the link below:

HERE

Today, I'd like you to start making your own quiz on excel. This can be on music, pictures, movies, apps, footballers....anything really!

Watch the video below on how you can use the IF formula in excel to automatically tell the person whether they have got the question right or wrong:

Here is the formula I used in the video above:

=IF(A14="Gareth Bale","CORRECT","WRONG")

As you begin to build your quiz, it is really important to include conditional formatting to make it more visually appealing. You should also try to line up the images and cells beneath where you want the participant to add their answers.

Good luck!

Year 7 - Introduction to Scratch

Below you will find links to the Scratch tutorial that I gave you today and another one that I found that you may use if you require further help/support:

Introduction to Scratch

Scratch Tutorial

Below is a simple task for you to try to complete in the lesson today:

Task

Once you have leant the basics, you can begin to plan your project for the rest of the half-term using scratch:

Here

Finally I have posted these two video tutorials on the basics and how to create a game. Use your headphones to watch these for more ideas and advice:

Year 8 - Using formula on Excel Spreadsheets

Click the link below and then download the excel spreadsheet to your ICT folder in your documents. Try to complete as many of the exercises as possible (if you look across the tabs at the bottom of the spreadsheet, you will see that there are 8 different tabs):

Click here

Below are video tutorials which show you how to complete each exercise:

Year 8: Using Formula on Excel Spreadsheets

I have completed the supermarket spreadsheet for you to use from Monday's lesson. You can download it here:

Supermarket Spreadsheet

I would like you to add formula to the spreadsheet to work out:

• the best price per item
• the average price per item
• the total cost per supermarket
• the cheapest/most expensive supermarket for those 6 items

Here are some useful formula for you:

=AVERAGE(write cells here)

=SUM(write cells here)

=MIN(write cells here)

You can watch the video of me completing the task below:

Also use some conditional formatting to help illustrate the cheapest options for all of your items.

Which supermarket is the cheapest?

Here are some further tips and tutorials:

http://www.gcflearnfree.org/excel2013/13

If you finish, you should start to design your own spreadsheet for items that you are interested in (clothes, music, games, footballers etc).

Year 8 - Spreadsheets

Click on the links below and download the documents and save in your ICT folders (click on 'Direct Download'). Try to complete both tasks by the end of the lesson:

Find the buried treasure

Shopping Challenge

Once you have made the spread-sheet for the second task, save it in your ICT folder as we will be using this in the lesson on Thursday.

Year 7 - Sequencing

Today we are starting a new topic called 'Sequencing' and will be focussing on Flowcharts. The PowerPoint and Flowchart document that Mr Bidwell went through in the lesson can be found below (if you need help):

Flowchart PowerPoint

Flowchart Document

Once you are happy with the concepts, you can work your way through the following tasks. Before starting each one, you should download the file to a 'Sequencing' folder in your ICT folders:

Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7


In Mr Livesey's lesson you will be completing the task below. Be sure to have finished all of the tasks above before attempting this though:

Task 1

Year 7 - Build your own Database using Microsoft Access

Your task for the next 4 lessons is to build your own database using Access. Ideas for your database could include:

• Your favourite films, music, games
• FIFA Ultimate Team Database
• Countries of the World
• Animals

Watch my demonstration carefully. The first 2 lessons will be about building a database. Next week we will be using the data to create 'forms'.

HELPFUL TIP No. 1: Think carefully about the fields you want to create for example, for 'Countries of the world' the fields I might create would be:

• Name
• Population
• Continent
• Flag
• Neighbours
• Capital City

HELPFUL TIP No. 2: When you create a new field, think carefully about the data that will be displayed. You must choose from text, attachments (if you want a picture), currency, date etc.

Animation - House Competition

You have 4 lessons to create a House themed animation using PowerPoint, Adobe Flash or Stop-Motion. Some ideas for your entry to include:

• the name of your house
• your house mascot/animal
• the name of your head of house
• the colours of your house
• your house charity
• house events
• your name

If you'd like to see some of the finalists from last year, follow this path:

W:\Professional Studies\Professional Studies\ICT\KS3\2.Spring\Year 8 Spring 1 - Animation\Animation competition entries

To perform some of the skills in those animations, you will need to watch the YouTube video tutorials on my post below.

Year 8 - Flash Animation

We are going to use a new program to create an animation. Click on the Start button in the bottom left corner of your screens. Then click 'All Programs' then the folder called 'CS3 Master Collection'. Finally, you should open 'Adobe Flash CS3 Professional'.

Below are some video tutorials for you to work through at your own pace. Any work that you produce for now will be experimental and will not be assessed. Once you have learnt all the skills from the tutorials I will set you a project to create your own animation for a House Competition. Unti then, work your way through the tutorials and try out the new skills:

Year 8 - Stop-Motion Animation

Your best animations will feature here. Send them to dlb@johnwarner.herts.sch.uk

 

Stop-Motion Animation

Today you must create your own stop-motion animation using your phones. Even if you do not have the app, you can take the photos on your phone and then we can create an animation with the photos another time.

Tips:

• work in pairs
• one person holds the camera, the other moves the objects
• keep the camera as still as possible
• the more photos and smaller the movement, the more realistic your animations will look
• be creative - use inanimate objects from your pencil case/bag
• you have until 3:20 to create your animation

The animations below only took about 5 minutes to make (I was working with a partner for all of them):

 

Work for Thursday 8th January

YOUR TASK - FIND OUT AND PRESENT YOUR IDEA’S, USING POWERPOINT.

ANSWER THE FOLLOWING QUESTIONS…

1.                        WHAT IS ANIMATION?

2.                        WHAT ARE THE DIFFERENT TYPES OF ANIMATION?

3.                        WHAT DOES ANIMATION LOOK LIKE?

4.                        MAKE A LIST OF FEATURES THAT GOOD ANIMATIONS WILL CONTAIN

5. LINK TO 5 DIFFERENT ANIMATIONS THAT YOU HAVE FOUND ON YOUTUBE

6. SAY WHY YOU HAVE CHOSEN THEM AND WHAT MAKES THEM INTERESTING/ENTERTAINING

Animation

Watch the following videos on animation and then open the Animation Review document and fill it in for 3 of the videos (you must include the Simpsons and Shrek videos in your review):