Year 10 ICT
IGCSE
Fluency in HTML->Click on the first image
Homework Due Tues 9th July
Practical corrections if you scored less than 84%
Knowledge base, inference engine and databases in action
Summer Exam
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
n32.zip | |
File Size: | 1398 kb |
File Type: | zip |
Theory Practice Q's
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_s11_qp_13_revision_paper_new.pdf | |
File Size: | 267 kb |
File Type: |
Web revision
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
0417_31_jun_2011_sf.zip | |
File Size: | 214 kb |
File Type: | zip |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
website_revision_2011_s11_qp31.docx | |
File Size: | 1329 kb |
File Type: | docx |
The difference between Memory and Storage
Horizons, cloning and spot healing
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
sample_images.zip | |
File Size: | 24409 kb |
File Type: | zip |
Selective Colouring
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
selective_colour.zip | |
File Size: | 5065 kb |
File Type: | zip |
Surf shop DTB practice
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
surfshop.csv | |
File Size: | 3 kb |
File Type: | csv |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
surfshop.docx | |
File Size: | 137 kb |
File Type: | docx |
Homework Due Tues 21st
Revise for test on Wiki topics 1-4
Homework-Due Weds 15th
Stick in all loose single sheets in book.
Add 1 image per paragraph to your wiki article
Add 1 image per paragraph to your wiki article
Wiki research project
Write a short article about the use of ICT on the given topics.How were these tasks completed before computing technology and how technology has facilitated or changed these tasks? What are the advantages/disadvantages of ICT for your given topic? Do not copy and paste text, keep the language simple. You may copy and paste images to support your article.
http://vispwiki.pbworks.com
http://vispwiki.pbworks.com
Adding your images to tables:
Create a new web page using the following tables as guides.
Add in the images from the previous task ensuring that their widths/heights are adjusted in Frontpage as indicated. Maintain their Aspect Ratio. Centre align all images.
A hint is given for the first one: The first table is 4 columns wide by 3 rows tall. Some cells have been merged. You can merge cells by highlighting and right clicking.
Add in the images from the previous task ensuring that their widths/heights are adjusted in Frontpage as indicated. Maintain their Aspect Ratio. Centre align all images.
A hint is given for the first one: The first table is 4 columns wide by 3 rows tall. Some cells have been merged. You can merge cells by highlighting and right clicking.
Extension:
Add a title to the webpage "Creating tables and placing images". Format this title as <H1>
Add the text "Click here to return to the top" under each table, when clicked on, these should take the viewer back to the top of the page.
Add a title to the webpage "Creating tables and placing images". Format this title as <H1>
Add the text "Click here to return to the top" under each table, when clicked on, these should take the viewer back to the top of the page.
Image Tasks
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
images_for_edit.zip | |
File Size: | 11810 kb |
File Type: | zip |
Each image should be edited as instructed. Printscreen the evidence (i.e. Save For Web box or File Properties).
Relational Databases
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
relational_databases.pptx | |
File Size: | 58 kb |
File Type: | pptx |
![](http://www.weebly.com/weebly/images/file_icons/file.png)
praslin_pets.accdb | |
File Size: | 602 kb |
File Type: | accdb |
Today's lesson
Q40 and Q41-labels
Extension:
Produce a report which shows all the fields from all the data and:
• Contains a new field called Tax which is calculated at run-time. This field will calculate the Price multiplied by 20 divided by 100
• Contains a new field called Total which is calculated at run-time. This field will be calculated by adding together the two previously calculated fields, Price and Tax
• Has the Tax and Total fields set as currency with 2 decimal places
• shows only the records where the Size is greater than or equal to 10
• shows all the fields and their labels in full
• fits on a single page wide
• has a page orientation of landscape
• sorts the data into descending order of Total (with the largest at the top)
• calculates the grand total value of these kites (including tax) and
o shows this grand total value at the bottom of the Total column
o formats the grand total value to currency with 2 decimal places
o has the label "Grand total value of stock"
• includes the heading Large Kites at the top of the page
• has your name, Centre number and candidate number on the right in the header.
Extension:
Produce a report which shows all the fields from all the data and:
• Contains a new field called Tax which is calculated at run-time. This field will calculate the Price multiplied by 20 divided by 100
• Contains a new field called Total which is calculated at run-time. This field will be calculated by adding together the two previously calculated fields, Price and Tax
• Has the Tax and Total fields set as currency with 2 decimal places
• shows only the records where the Size is greater than or equal to 10
• shows all the fields and their labels in full
• fits on a single page wide
• has a page orientation of landscape
• sorts the data into descending order of Total (with the largest at the top)
• calculates the grand total value of these kites (including tax) and
o shows this grand total value at the bottom of the Total column
o formats the grand total value to currency with 2 decimal places
o has the label "Grand total value of stock"
• includes the heading Large Kites at the top of the page
• has your name, Centre number and candidate number on the right in the header.
Homework
From the ski website that you created last week, complete the presentation task (Q44-58) Skip Q57.
Please e-mail this to [email protected] by Tues 30th April.
Please e-mail this to [email protected] by Tues 30th April.
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_w10_qp_3.pdf | |
File Size: | 126 kb |
File Type: |
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
2010_qp3.zip | |
File Size: | 726 kb |
File Type: | zip |
Database revision
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_w10_qp_paper_2.pdf | |
File Size: | 126 kb |
File Type: |
Winter 2010 QP2-Q35-41
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
n10eks.csv | |
File Size: | 8 kb |
File Type: | csv |
Tutorial for how to import data
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
importing_data.ppt | |
File Size: | 2368 kb |
File Type: | ppt |
Tutorial for how to do a complex query with a calculated field for a printed report:
Homework: Complete corrections up to Q43.
Due: Weds 24th
Q paper below
Due: Weds 24th
Q paper below
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_w10_qp_3.pdf | |
File Size: | 126 kb |
File Type: |
Work for Hayley
Read the notes in section 5: Data Types.
Make sure you click on all the red links to the right, then answer these questions:
1) In a doctor's database, give an example of a field name
2) For the following fields, what would be a suitable data type:
a)Age
b)Address PO Box
c)Smoker (Yes/No)
d)Date of birth
3a) What does a key field do?
3b) Could you use somebody's surname as a key field? Give reasons
4) What are the advantages of using a relational database?
5) What kind of devices use a Digital to Analogue converter
6) Give examples of digital and analogue data
Please email answers to [email protected]
Make sure you click on all the red links to the right, then answer these questions:
1) In a doctor's database, give an example of a field name
2) For the following fields, what would be a suitable data type:
a)Age
b)Address PO Box
c)Smoker (Yes/No)
d)Date of birth
3a) What does a key field do?
3b) Could you use somebody's surname as a key field? Give reasons
4) What are the advantages of using a relational database?
5) What kind of devices use a Digital to Analogue converter
6) Give examples of digital and analogue data
Please email answers to [email protected]
Assessment leaderboards
Hardware theory:
1) Kit (71%)
2) Lisa (70%)
3-) Brandon & Megan (67%)
Word Processing:
1) Emmanuel (96%)
2-) Brandon and Megan (92%)
Presentation:
1) Devina (100%)
2) Lisa (94%)
3) Megan (88%)
Database:
1-) Megan and Emmanuel (93%)
3) Lisa (89%)
Web Authoring:
1) Wendy (81%)
2) Hayley (76%)
3) Emmanuel (71%)
Overall:
1-) Emmanuel (80%) / Lisa (85%)*
3) Megan (78%)
4) Devina (69%)
5) Wendy (67%)
1) Kit (71%)
2) Lisa (70%)
3-) Brandon & Megan (67%)
Word Processing:
1) Emmanuel (96%)
2-) Brandon and Megan (92%)
Presentation:
1) Devina (100%)
2) Lisa (94%)
3) Megan (88%)
Database:
1-) Megan and Emmanuel (93%)
3) Lisa (89%)
Web Authoring:
1) Wendy (81%)
2) Hayley (76%)
3) Emmanuel (71%)
Overall:
1-) Emmanuel (80%) / Lisa (85%)*
3) Megan (78%)
4) Devina (69%)
5) Wendy (67%)
Web Authoring Test
1 Create a new word processed document. You will use this to show screen shots of how you have completed the tasks.
2 Place your name, Centre number and candidate number in the header of this document.
Save this with the filename Evidence in your work area.
Using the files below, complete Q24-59. Do not do Q57
2 Place your name, Centre number and candidate number in the header of this document.
Save this with the filename Evidence in your work area.
Using the files below, complete Q24-59. Do not do Q57
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
2010_qp3.zip | |
File Size: | 726 kb |
File Type: | zip |
Practice task for test Q26-42
Holiday HWK
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_w09_qp_3.pdf | |
File Size: | 137 kb |
File Type: |
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
0417_w09_sf_03.zip | |
File Size: | 222 kb |
File Type: | zip |
Mark scheme
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_s09_ms_3.pdf | |
File Size: | 428 kb |
File Type: |
Sample images for editing
Image DSC07749A
Crop to 500px wide
JPEG file less than 200Kb in size
Image DSC07781A
Resize 800px wide-Preserve aspect ratio
JPEG file less than 200kb in size
Crop to 500px wide
JPEG file less than 200Kb in size
Image DSC07781A
Resize 800px wide-Preserve aspect ratio
JPEG file less than 200kb in size
![](http://www.weebly.com/weebly/images/file_icons/image.png)
dsc07749a.jpg | |
File Size: | 1171 kb |
File Type: | jpg |
![](http://www.weebly.com/weebly/images/file_icons/image.png)
dsc07781a.jpg | |
File Size: | 1374 kb |
File Type: | jpg |
Homework Q1-25
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
0417_s09_sf_3.zip | |
File Size: | 243 kb |
File Type: | zip |
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_s09_qp_3.pdf | |
File Size: | 133 kb |
File Type: |
2008 Practice Paper 3
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
0418_w08_su3.zip | |
File Size: | 32 kb |
File Type: | zip |
Question paper
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
2008_qp3_web_authoring.docx | |
File Size: | 219 kb |
File Type: | docx |
Adding a Mailto link
In the example below we use the <a href> tag as it is a hyperlink reference.
Here we have specified a mailto email address and then a subject. The syntax is very specific- follow the spaces, quotes and question marks carefully.
Here we have specified a mailto email address and then a subject. The syntax is very specific- follow the spaces, quotes and question marks carefully.
Webpage checklist
On (CSS) Style Sheet:
•All H1 in one style of font
•All H2 in a different style of font (i.e. do not use serif for both H1 and H2)
•Border colour of the table matches the H2 font colour
In HTML:
•All images linked to the relevant webpages
•All images 500px wide
•Back to top links
•All H1 in one style of font
•All H2 in a different style of font (i.e. do not use serif for both H1 and H2)
•Border colour of the table matches the H2 font colour
In HTML:
•All images linked to the relevant webpages
•All images 500px wide
•Back to top links
Independent project
Choose one of the projects below to complete in Frontpage. Try to use as much code as possible and only go to Design view for hyperlinking images/inserting a table. All formatting should be done in a separate CSS (make a copy of your previous CSS and modify it).
Mobile Devices
Design a webpage which discusses different mobile devices (netbooks, tablets, mobile phones) and their uses. For the section on mobile phones or tablets, ensure that you compare at least 3 devices (in a table).
Sports Club
Design a webpage about your favourite football/basketball club. It should cover the club’s history, prominent players and their records/achievements (in a table) and the club’s results in competition.
Cities of the world
Design a webpage which informs people about a City that you have visited. It should cover geographic location, amenities/attractions, transport links (air/road/sea/rail), famous buildings/landmarks (in a table).
Mobile Devices
Design a webpage which discusses different mobile devices (netbooks, tablets, mobile phones) and their uses. For the section on mobile phones or tablets, ensure that you compare at least 3 devices (in a table).
Sports Club
Design a webpage about your favourite football/basketball club. It should cover the club’s history, prominent players and their records/achievements (in a table) and the club’s results in competition.
Cities of the world
Design a webpage which informs people about a City that you have visited. It should cover geographic location, amenities/attractions, transport links (air/road/sea/rail), famous buildings/landmarks (in a table).
Anchors CSS and Tables
On the about me page (index.htm) If you have added a video section, underneath this add a section called "Links" this should be a subtitle using the heading style <H2>.
Switch from Code view to Design view and underneath the subheading "Links" add some hyperlinks to your favourite websites. Write a bit about each of your favourite websites. You may also wish to add images of these websites (use Google images). An example of a finished section is below:
Links
Here are a few links to my favourite websites:
www. Youtube.com
Switch from Code view to Design view and underneath the subheading "Links" add some hyperlinks to your favourite websites. Write a bit about each of your favourite websites. You may also wish to add images of these websites (use Google images). An example of a finished section is below:
Links
Here are a few links to my favourite websites:
www. Youtube.com
Youtube is a website where I like to access music videos and tutorials. Some of my favourite videos are shown in the section above.
www.fubiz.net
www.fubiz.net
Fubiz is a site which showcases graphic design and artistic projects. It is written mainly in French but a translation tool is also available. An inspiring site.
Extension
Open the (CSS) style sheet in frontpage. Modify the styles for H1, H2, P and background by going to "Format Styles". You should create your own style sheet for your about me page.
Cascading Style Sheet (CSS) for your first webpage
![](http://www.weebly.com/weebly/images/file_icons/src.png)
style1.css | |
File Size: | 1 kb |
File Type: | css |
Logo programming (theory exam)
Workshops: http://fmslogo.sourceforge.net/workshop/
More fun tutorials that you can try at home: http://mckoss.com/logo/
More fun tutorials that you can try at home: http://mckoss.com/logo/
Networks Practice Exam Q's:
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
networking_practice_exam_questions.docx | |
File Size: | 153 kb |
File Type: | docx |
Networks (intro)
Use Section 4 of the IGCSE website to help you to answer the following:
Computers can be connected in a "Network" by using network cables. If you need to connect over longer distances, what are 3 different ways of connecting other computers? Think about a company with global offices and also people who need to move around with their laptop when they work.
Computers can be connected in a "Network" by using network cables. If you need to connect over longer distances, what are 3 different ways of connecting other computers? Think about a company with global offices and also people who need to move around with their laptop when they work.
Aside from sharing files, data and resources, what are two other advantages of using a network in a workplace?
What are three disadvantages of using a network in a workplace?
What are the two main ways of connecting computers/devices wirelessly and how are they different?
Extension:
Use the following step by step simulation and find out what the following devices do in a Network:
Hub
Router
Web Cache/Proxy Server
File Server
Switch
What are three disadvantages of using a network in a workplace?
What are the two main ways of connecting computers/devices wirelessly and how are they different?
Extension:
Use the following step by step simulation and find out what the following devices do in a Network:
Hub
Router
Web Cache/Proxy Server
File Server
Switch
Database and Presentation Test
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_s12_qp_22.pdf | |
File Size: | 135 kb |
File Type: |
Q3-14 and Q39-47
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
j12sales.rtf | |
File Size: | 44 kb |
File Type: | rtf |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
j12microsales.csv | |
File Size: | 0 kb |
File Type: | csv |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
j12motors.csv | |
File Size: | 52 kb |
File Type: | csv |
Database Task
Right click the file below and "save target as" . Save to the D: drive. Then use the PDF below and answer Q 43-50
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
jx1cars21.csv | |
File Size: | 51 kb |
File Type: | csv |
Homework Due: Weds 9th Jan
Complete Q's 33-42
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
0417_s11_qp_21.pdf | |
File Size: | 146 kb |
File Type: |
![](http://www.weebly.com/weebly/images/file_icons/image.png)
jx1port21.jpg | |
File Size: | 100 kb |
File Type: | jpg |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
jx1pres21.rtf | |
File Size: | 47 kb |
File Type: | rtf |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
jx1export21.rtf | |
File Size: | 39 kb |
File Type: | rtf |
IGCSE Specification
CLICK HERE for the full specification. This lists all the content that you will need to be familiar with for your IGCSE exam.
Useful websites
IGCSE ICT, run by a former teacher from ISS Mahé. The site covers all theory and practical aspects in detail.
The ICT Lounge offers straightforward material for the IGCSE. Some of the files open as seperate PDF's. Useful for revision and self-study purposes.
Another site worth looking at is this WIKI
Autumn Assessment
Revise for theory test on Tuesday using notes in your orange books. Main topics:
Input, Output and Storage Devices.
Complete practice task for Wednesday Q24-Q59:
2008 Paper 2
File required
Image required:
Input, Output and Storage Devices.
Complete practice task for Wednesday Q24-Q59:
2008 Paper 2
File required
Image required:
First homework
Please bring in a USB memory stick to every lesson. You will need it to transfer work to and from school.
Finish your business card with your logo. Please email this to: [email protected] by 6pm on Tues 25th September.
Finish your business card with your logo. Please email this to: [email protected] by 6pm on Tues 25th September.