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.