1. TEST NEXT WEEK

2. Test Revision
The Year 9 Test Will Cover Spreadsheets and Webdesign
Make sure you understand simple formulae, data filters.
Webdesign: Stylesheets, title and backgrounds, links from images

3. Spreadsheets Data filters
Open sca5mob.csv- be careful
Save as Excel file in your folder
Add the filters so that only colour phones with talk time greater than 240 minutes are shown
Data filters look like this

4. Data Filter- Go to data filters

5. DATA FILTER-
Select only Colour

6. DATA FILTER 2

7. Data FILTER- Finished

8. Website two pages, one stylesheet
Create a two page website to show how to use a data filter
Your website should include a stylesheet.

9. Create a folder and copy these files to it

10. Create a stylesheet

11. Save it in the same folder as the files you just copied (as Excel_website_stylesheet)

12. Create a style h1 for the titles
For text use Class

13. Set the style h1 as red, font size 20

14. Set the background as a light yellow colour-
For background use tag and body
for this you MUST use the body tag not Class

15. Create and Save Your home page

16. Attach your style sheet to your first page

17. Check that the stylesheet works
Style H1 appears in red size 20
Yellow page background

18. Insert the Excel Image

19. Create a Page called Data Filters

20. Add some tables then add the pictures and TEXT

21. Link the LogO to the Home Page

22. Questions
What do we need to do to use a data filter?
What happens if we create a data filter and then save as .CSV file
What are CSS rules used for?
a. controlling who can see the different parts of a web page b. helping to format web pages so they look similar c. reviewing the links on a website
Which kind of CSS rule should we use to create a text font,
a Class, b Tag, c Enhanced
Which kind of CSS rule should we use to create a background
a Class, b Tag, c Enhanced
Which tag should we use to create a background?
After we have made a CSS stylesheet, what do we need to do to use it to help format a webpage?
How can you link a picture so that when you click on it, it will open another webpage?
How can you print a large spreadsheet so it prints on just one page?