際際滷

際際滷Share a Scribd company logo
TEST NEXT WEEK
Test RevisionThe Year 9 Test Will Cover Spreadsheets and WebdesignMake sure you understand simple formulae, data filters. Webdesign: Stylesheets, title and backgrounds, links from images
Spreadsheets  Data filtersOpen sca5mob.csv- be carefulSave as Excel file in your folderAdd the filters so that only colour phones with talk time greater than 240 minutes are shownData filters look like this
Data Filter- Go to data filters
DATA FILTER- Select only Colour
DATA FILTER 2
Data FILTER- Finished
Website  two pages, one stylesheetCreate a two page website to show how to use a data filterYour website should include a stylesheet.
Create a folder and copy these files to it
Create a stylesheet
Save it in the same folder as the files you just copied (as Excel_website_stylesheet)
Create a style h1 for the titlesFor text use Class
Set the style h1 as red, font size 20
Set the background as a light yellow colour- For background use tag and bodyfor this you MUST use the body tag not Class
Create and Save Your home page
Attach your style sheet to your first page
Check that the stylesheet worksStyle H1 appears in red size 20Yellow page background
Insert the Excel Image
Create a Page called Data Filters
Add some tables then add the pictures and TEXT
Link the LogO to the Home Page
QuestionsWhat do we need to do to use a data filter?What happens if we create a data filter and then save as .CSV fileWhat 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 EnhancedWhich kind of CSS rule should we use to create a background a Class, b Tag, c EnhancedWhich 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?

More Related Content

Viewers also liked (6)

Memory revision multiple choice test
Memory revision multiple choice testMemory revision multiple choice test
Memory revision multiple choice test
Janine Poole
Exam Revision Self Esteem
Exam Revision Self EsteemExam Revision Self Esteem
Exam Revision Self Esteem
Wellingtonisgreat
Guidelines for Test Administration
Guidelines for Test AdministrationGuidelines for Test Administration
Guidelines for Test Administration
Sue Quirante
Administering the test
Administering the testAdministering the test
Administering the test
enylisac25
Interpreting Test Scores
Interpreting Test ScoresInterpreting Test Scores
Interpreting Test Scores
Elton John Embodo
Administering,scoring and reporting a test ppt
Administering,scoring and reporting a test pptAdministering,scoring and reporting a test ppt
Administering,scoring and reporting a test ppt
Manali Solanki
Memory revision multiple choice test
Memory revision multiple choice testMemory revision multiple choice test
Memory revision multiple choice test
Janine Poole
Exam Revision Self Esteem
Exam Revision Self EsteemExam Revision Self Esteem
Exam Revision Self Esteem
Wellingtonisgreat
Guidelines for Test Administration
Guidelines for Test AdministrationGuidelines for Test Administration
Guidelines for Test Administration
Sue Quirante
Administering the test
Administering the testAdministering the test
Administering the test
enylisac25
Administering,scoring and reporting a test ppt
Administering,scoring and reporting a test pptAdministering,scoring and reporting a test ppt
Administering,scoring and reporting a test ppt
Manali Solanki

Similar to Test revision (20)

Chapter 12
Chapter 12Chapter 12
Chapter 12
application developer
You Can Take Your HAT Off
You Can Take Your HAT OffYou Can Take Your HAT Off
You Can Take Your HAT Off
Jeff Haas
ARTICULOENINGLES
ARTICULOENINGLESARTICULOENINGLES
ARTICULOENINGLES
M坦nica S叩nchez Crisostomo
Css Founder.com | Cssfounder se
Css Founder.com | Cssfounder seCss Founder.com | Cssfounder se
Css Founder.com | Cssfounder se
Css Founder
Css training tutorial css3 & css4 essentials
Css training tutorial css3 & css4 essentialsCss training tutorial css3 & css4 essentials
Css training tutorial css3 & css4 essentials
QA TrainingHub
Tutorial5
Tutorial5Tutorial5
Tutorial5
tutorialsruby
Tutorial5
Tutorial5Tutorial5
Tutorial5
tutorialsruby
WELCOME-FOLKS--CSS.-AND-HTMLS.pptx
WELCOME-FOLKS--CSS.-AND-HTMLS.pptxWELCOME-FOLKS--CSS.-AND-HTMLS.pptx
WELCOME-FOLKS--CSS.-AND-HTMLS.pptx
HeroVins
Css
CssCss
Css
Venkat Krishnan
Introduction to css
Introduction to cssIntroduction to css
Introduction to css
nikhilsh66131
Intermediate Web Design.doc
Intermediate Web Design.docIntermediate Web Design.doc
Intermediate Web Design.doc
butest
Intermediate Web Design.doc
Intermediate Web Design.docIntermediate Web Design.doc
Intermediate Web Design.doc
butest
Walkthrough asp.net
Walkthrough asp.netWalkthrough asp.net
Walkthrough asp.net
Aravindharamanan S
Lesson 2 cs5
Lesson 2   cs5Lesson 2   cs5
Lesson 2 cs5
dtelepos
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docxITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
christiandean12115
Dreamweaver CS3
Dreamweaver CS3Dreamweaver CS3
Dreamweaver CS3
University of Washington, Bothell
Introduction to Branding SharePoint
Introduction to Branding SharePointIntroduction to Branding SharePoint
Introduction to Branding SharePoint
K.Mohamed Faizal
Lesson 8 Computer Creating your Website.pdf
Lesson 8 Computer Creating your Website.pdfLesson 8 Computer Creating your Website.pdf
Lesson 8 Computer Creating your Website.pdf
AshleyJovelClavecill
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog TemplateBP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
Sean Burgess
Introduction to Bootstrap: Design for Developers
Introduction to Bootstrap: Design for DevelopersIntroduction to Bootstrap: Design for Developers
Introduction to Bootstrap: Design for Developers
Melvin John
You Can Take Your HAT Off
You Can Take Your HAT OffYou Can Take Your HAT Off
You Can Take Your HAT Off
Jeff Haas
Css Founder.com | Cssfounder se
Css Founder.com | Cssfounder seCss Founder.com | Cssfounder se
Css Founder.com | Cssfounder se
Css Founder
Css training tutorial css3 & css4 essentials
Css training tutorial css3 & css4 essentialsCss training tutorial css3 & css4 essentials
Css training tutorial css3 & css4 essentials
QA TrainingHub
WELCOME-FOLKS--CSS.-AND-HTMLS.pptx
WELCOME-FOLKS--CSS.-AND-HTMLS.pptxWELCOME-FOLKS--CSS.-AND-HTMLS.pptx
WELCOME-FOLKS--CSS.-AND-HTMLS.pptx
HeroVins
Introduction to css
Introduction to cssIntroduction to css
Introduction to css
nikhilsh66131
Intermediate Web Design.doc
Intermediate Web Design.docIntermediate Web Design.doc
Intermediate Web Design.doc
butest
Intermediate Web Design.doc
Intermediate Web Design.docIntermediate Web Design.doc
Intermediate Web Design.doc
butest
Lesson 2 cs5
Lesson 2   cs5Lesson 2   cs5
Lesson 2 cs5
dtelepos
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docxITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
ITECH2106-6106 Lab01-HTML CSS Intro and Needs Analysis.pdf.docx
christiandean12115
Introduction to Branding SharePoint
Introduction to Branding SharePointIntroduction to Branding SharePoint
Introduction to Branding SharePoint
K.Mohamed Faizal
Lesson 8 Computer Creating your Website.pdf
Lesson 8 Computer Creating your Website.pdfLesson 8 Computer Creating your Website.pdf
Lesson 8 Computer Creating your Website.pdf
AshleyJovelClavecill
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog TemplateBP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
BP304 - Blog It Up, Baby! Extending the new IBM Lotus Domino Blog Template
Sean Burgess
Introduction to Bootstrap: Design for Developers
Introduction to Bootstrap: Design for DevelopersIntroduction to Bootstrap: Design for Developers
Introduction to Bootstrap: Design for Developers
Melvin John

More from Andrew Duckworth (6)

Using photoshop to create printable route maps
Using photoshop to create printable route mapsUsing photoshop to create printable route maps
Using photoshop to create printable route maps
Andrew Duckworth
Text tweens
Text tweensText tweens
Text tweens
Andrew Duckworth
Screen input forms
Screen input formsScreen input forms
Screen input forms
Andrew Duckworth
Digital+safety+powerpoint
Digital+safety+powerpointDigital+safety+powerpoint
Digital+safety+powerpoint
Andrew Duckworth
Game Maker Workshopslides
Game Maker WorkshopslidesGame Maker Workshopslides
Game Maker Workshopslides
Andrew Duckworth
Computer Control Your Presentation
Computer Control Your PresentationComputer Control Your Presentation
Computer Control Your Presentation
Andrew Duckworth
Using photoshop to create printable route maps
Using photoshop to create printable route mapsUsing photoshop to create printable route maps
Using photoshop to create printable route maps
Andrew Duckworth
Digital+safety+powerpoint
Digital+safety+powerpointDigital+safety+powerpoint
Digital+safety+powerpoint
Andrew Duckworth
Game Maker Workshopslides
Game Maker WorkshopslidesGame Maker Workshopslides
Game Maker Workshopslides
Andrew Duckworth
Computer Control Your Presentation
Computer Control Your PresentationComputer Control Your Presentation
Computer Control Your Presentation
Andrew Duckworth

Test revision

  • 2. Test RevisionThe Year 9 Test Will Cover Spreadsheets and WebdesignMake sure you understand simple formulae, data filters. Webdesign: Stylesheets, title and backgrounds, links from images
  • 3. Spreadsheets Data filtersOpen sca5mob.csv- be carefulSave as Excel file in your folderAdd the filters so that only colour phones with talk time greater than 240 minutes are shownData filters look like this
  • 4. Data Filter- Go to data filters
  • 5. DATA FILTER- Select only Colour
  • 8. Website two pages, one stylesheetCreate a two page website to show how to use a data filterYour website should include a stylesheet.
  • 9. Create a folder and copy these files to it
  • 11. Save it in the same folder as the files you just copied (as Excel_website_stylesheet)
  • 12. Create a style h1 for the titlesFor 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 bodyfor 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 worksStyle H1 appears in red size 20Yellow page background
  • 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. QuestionsWhat do we need to do to use a data filter?What happens if we create a data filter and then save as .CSV fileWhat 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 EnhancedWhich kind of CSS rule should we use to create a background a Class, b Tag, c EnhancedWhich 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?