Spreadsheets

LO:  To be able to use spreadsheets to perform different calculations


Video

TASK 1:

Complete the 3 workbooks from Google Classroom:

TASK 2:

Click the two links below to complete the spreadsheet challenge:

instructions

spreadsheet

EXTENSION:

Use your knowledge to produce a Battleships style game

Binary and ASCII

Understand how to decode binary numbers and convert them to letters using ASCII.

8x1:   CLICK FOR GOOGLE CLASSROOM

8w2:  CLICK FOR GOOGLE CLASSROOM

8y4:   CLICK FOR GOOGLE CLASSROOM

Year 10 Web Exam

1. Open the ESCAPADES brief
2. Open DREAMWEAVER
3. Manage Site to your new ESCAPADES project folder
4. Click File > New Template to set up a new BLANK HTML template that looks appropriate
5. Click on edge of template and set to 100% width
6. Change some of the colours of your template
7. Highlight all text in the white section of your template and click: Insert > Template Objects > Editable Region and click OK
8. Save Template by clicking File > Save As Template and call it 'Template'. It should now be calledtemplate.dwt
9. Create new pages by clicking File > New > Page from Template
   *If your template does not appear in the little window here, you have not done step 3 correctly - do it now!*
10. Save your new HTML page by clicking File > Save As and saving it as an appropriate name (Home, Contact Us, etc...). This shouldnt Save in your templates folder
11. Repeat step 9 and 10 as much as you need. These pages should all end .html
    
    Your template.dwt IS NOT your home page, do not put home page information on it, put this on your home.html page
12. On your template, change the link names from 'Link One' to 'Home' and so on. Pressing Enter after 'Link Four' will create more space for more pages
13. Highlight where you have written 'Home' and click the little folder icon at the bottom (next to Link), to link the text to your home page
14. Repeat for all links
    
    When you 'Save' your template.dwt after making new .html pages, it SHOULD now ask you to 'update', which you should agree to
    
    After saving and updating your template, you will need to save each .html page too

The insides of a Computer

Presentation Skills

Task 1:
In groups of 4:
1) Write down all the things wrong with each of the slides displayed on the board.

2) What would you do differently?


Task 2:
1) Download the following presentation by clicking HERE

2) In your groups - discuss how you could improve this presentation.
Think about the following:
Image editing
Design Features (font etc)
Transitions
Animations
Slide Show settings

3) How could you make this appear more professional?

           
Extension:
Pick a topic of your choice and begin to make a high-quality, professional presentation.


Review:
Class discussion - What changes have you made and why?