Year 9 ICT
Holiday Homework (Independent study)
Cascading Style Sheet (CSS)
style1.css | |
File Size: | 1 kb |
File Type: | css |
Homework due: Tues 9th July
Complete and print corrections if you scored <74%
Practical Exam
sf21.zip | |
File Size: | 490 kb |
File Type: | zip |
Theory practice questions
0417_s11_qp_13_revision_paper_new.pdf | |
File Size: | 267 kb |
File Type: |
Graphs and Charts
graphs_and_charts_2013.xlsx | |
File Size: | 523 kb |
File Type: | xlsx |
Selective Colouring
selective_colour.zip | |
File Size: | 5065 kb |
File Type: | zip |
Images for editing
sample_images.zip | |
File Size: | 24409 kb |
File Type: | zip |
Surfshop database
surfshop.csv | |
File Size: | 3 kb |
File Type: | csv |
surfshop.docx | |
File Size: | 137 kb |
File Type: | docx |
Homework
Revise topics 1-4 for a test next Tues:
- Vincent-Cartoon Animation
- Grace-Communications (Mobile, VoIP, E-mail)
- Elvira-Weather stations (The type of sensors and measurements)
- Martina-Cinema/Theatre booking systems
Extension after Wiki
For a topic you are interested in, find a blog which covers this topic.Compare this blog to the Wiki that the class has just created.
Compare the two in terms of:
1) Order of information/articles
2) Number of authors
3) How can other people to collaborate/contribute to content
Compare the two in terms of:
1) Order of information/articles
2) Number of authors
3) How can other people to collaborate/contribute to content
LOGO Programming language revision
logo_lesson_2.pptx | |
File Size: | 203 kb |
File Type: | pptx |
Tues 30th April
Read about data capture here:
http://vispwiki.pbworks.com/w/page/65687165/Data%20Capture
Then create a data capture form for a Doctor's surgery. It should capture all the key information for new patients.
You may do this by hand using pen/paper or using a word processor.
Extension: Format the letterhead so that it has all the key information of the Doctor's surgery. You can also design your own logo.
http://vispwiki.pbworks.com/w/page/65687165/Data%20Capture
Then create a data capture form for a Doctor's surgery. It should capture all the key information for new patients.
You may do this by hand using pen/paper or using a word processor.
Extension: Format the letterhead so that it has all the key information of the Doctor's surgery. You can also design your own logo.
Wiki task
Click login at the top right of this page: http://vispwiki.pbworks.com/
Click on your topic. Create a new page, then begin your article.
Remember to hit save every few minutes.
Click on your topic. Create a new page, then begin your article.
Remember to hit save every few minutes.
Relational Databases
praslin_pets.accdb | |
File Size: | 602 kb |
File Type: | accdb |
relational_databases.pptx | |
File Size: | 58 kb |
File Type: | pptx |
Database Test
Use the file below and answer questions 39-47
j12motors.csv | |
File Size: | 52 kb |
File Type: | csv |
0417_s12_qp_22.pdf | |
File Size: | 135 kb |
File Type: |
Homework: Complete corrections for Q39-47. Time required (1 hour). Due Weds April 24th.
If you did not save your database or have lost it, please use the one below.
If you did not save your database or have lost it, please use the one below.
motors.accdb | |
File Size: | 446 kb |
File Type: | accdb |
If you get stuck on Q 46, please use the video below.
Work for Rachel
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]
Check back for work next week.
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]
Check back for work next week.
Extension Task (After test)
Open Sketchup 8 from the start menu. The default template is already set.
Holiday Homework/Revision Due: Tues 16th April
Q38-45
A* Extension: Q46.
Hint: Group by Staff after you have made your report
0417_s09_qp_2.pdf | |
File Size: | 134 kb |
File Type: |
j9sales.csv | |
File Size: | 12 kb |
File Type: | csv |
Summer 2011 Practice paper Q43-48
jx1cars21.csv | |
File Size: | 51 kb |
File Type: | csv |
Database practice task-Islander's Cinema
1. Import the data file Film Data.csv from below
2. Open the table in design view, ensure the viewers field is formatted as numbers and the Box office field is formatted as currency (£GBP)
3. Produce a query showing all "fantasy" films made after 2009.
4. Create a report based on the previous query.
5. Sort the films in order of viewers with the highest at the top.
6. Add up the box office total at the bottom of the report. Create a label for this called "Total Box office takings"
7. Add your name and centre number (SC420) in a label at the bottom left of the report
8. Change the page layout to landscape.
9. Remove the two fields: Film ID and genre.
10. Ensure the page fits to one page wide.
Extension:
A. Create a second query for a set of films of your choice
B. Produce a report, this time add up the total number of viewers at the bottom of the page.
2. Open the table in design view, ensure the viewers field is formatted as numbers and the Box office field is formatted as currency (£GBP)
3. Produce a query showing all "fantasy" films made after 2009.
4. Create a report based on the previous query.
5. Sort the films in order of viewers with the highest at the top.
6. Add up the box office total at the bottom of the report. Create a label for this called "Total Box office takings"
7. Add your name and centre number (SC420) in a label at the bottom left of the report
8. Change the page layout to landscape.
9. Remove the two fields: Film ID and genre.
10. Ensure the page fits to one page wide.
Extension:
A. Create a second query for a set of films of your choice
B. Produce a report, this time add up the total number of viewers at the bottom of the page.
film_data.csv | |
File Size: | 6 kb |
File Type: | csv |
How to import data
importing_data.ppt | |
File Size: | 2368 kb |
File Type: | ppt |
Shoe Adverts
Presentation Refresher
bodaline_presentation_task.docx | |
File Size: | 14 kb |
File Type: | docx |
borderline_pricelist.xlsx | |
File Size: | 13 kb |
File Type: | xlsx |
Loading brushes on GIMP
loading_brushes_in_gimp.pptx | |
File Size: | 512 kb |
File Type: | pptx |
T-shirts
Save the picture below and open it in GIMP.
Go to Image->Mode->RGB. This will ensure that you have full colour on your t-shirt.
Using only the fill bucket tool and fonts (text tool), Create a new t-shirt design. See below for some inspiration:
Extension: Design a second T-shirt using Brushes in GIMP
SAVE YOUR FINISHED T-SHIRT DESIGNS TO D:/ Y9
Go to Image->Mode->RGB. This will ensure that you have full colour on your t-shirt.
Using only the fill bucket tool and fonts (text tool), Create a new t-shirt design. See below for some inspiration:
Extension: Design a second T-shirt using Brushes in GIMP
SAVE YOUR FINISHED T-SHIRT DESIGNS TO D:/ Y9
Extension Templates (Brushes in GIMP)
Networks practice Q's
networking_practice_exam_questions.docx | |
File Size: | 153 kb |
File Type: | docx |
Networks (Intro)
Computers can be connected in a "Network" by using network cables. This enables organisations to share files, data and resources such as ___________ and ____________. If you need to connect over longer distances, satellites, radio waves and telephone lines can also be used.
Use Section 4 of the IGCSE website to help you to answer the following:
Use Section 4 of the IGCSE website to help you to answer the following:
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/Homework:
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/Homework:
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
Word Processing Test
Q5-37
28 Marks. Guided Time: 42mins
After Q37, please email your finished file to: [email protected]
Then PTO to complete the Presentation task
28 Marks. Guided Time: 42mins
After Q37, please email your finished file to: [email protected]
Then PTO to complete the Presentation task
j9sales.rtf | |
File Size: | 64 kb |
File Type: | rtf |
j9staff.csv | |
File Size: | 0 kb |
File Type: | csv |
0417_s09_qp_2.pdf | |
File Size: | 134 kb |
File Type: |
Tests next week
Word Processing on Tues.
Presentation test on Thurs.
Use Year 10 ICT page to revise
Presentation test on Thurs.
Use Year 10 ICT page to revise
Presentation task Q33-42
JX1PORT21.JPG
jx1pres21.rtf | |
File Size: | 47 kb |
File Type: | rtf |
jx1export21.rtf | |
File Size: | 39 kb |
File Type: | rtf |
Word processing task
0417_s11_qp_21.pdf | |
File Size: | 146 kb |
File Type: |
jx1port21.rtf | |
File Size: | 73 kb |
File Type: | rtf |
Input Output and Storage Devices
input_out_storage.pptx | |
File Size: | 824 kb |
File Type: | pptx |
Homework due Tues 15th
•Pick an Input or Output Device and create a publication which informs our class about it.
•You may choose to make a poster, write an essay, poem, song, do a short (5 min) presentation or film.
•DO NOT copy and paste, do not use lots of technical jargon
•DO Reference fully.
•You may choose to make a poster, write an essay, poem, song, do a short (5 min) presentation or film.
•DO NOT copy and paste, do not use lots of technical jargon
•DO Reference fully.
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
Another site worth looking at is this WIKI
Intro to Year 9
Please bring in a USB memory stick to every lesson. You will need it to transfer work to and from school.
First homework: Finish your business card and your photo editing tasks. Please email these to: [email protected] by 6pm on Mon 24th September.
First homework: Finish your business card and your photo editing tasks. Please email these to: [email protected] by 6pm on Mon 24th September.
IGCSE ICT
We are starting to study some of the IGCSE ICT syllabus. This website can help you immensely through the whole course. LINK It is made by Steve Copley who used to work with me at the Mahe International school. there is a lot of information provided on this site so we will look at it a bit at a time but you can study more from other areas if you wish.
Homework for week beginning 21st May
_You have two tests waiting for you on Yacapaca ..LINK.... Login to your account and complete both assessments.
Homework for week beginning 14th May
You have two tests waiting for you on Yacapaca ..LINK.... Login to your account using and complete both assessments
Homework for week beginning 7th May
You have two tests waiting for you on Yacapaca..LINK.... So login to your account using your login that you were given in ICT class and complete both assessments.
Homework for week beginning 30th April
Revise your knowledge of hardware and software go to LINK and play this game. Also visit this page LINK to select another REVSION GAME which will help you learn.
Homework for the week beginning 23rd April
Select a Podcast from this site, snap judgement, LINK listen to it carefuly (or just part of it; they are quite long) and whilst listening cnsider the mixture of music and talking. Write a short report which you will email to me in the usual way.
The report should:
The report should:
- Explain why you chose this podcast
- State briefly what it is about
- Say what you think are its best features as a sound recording
- Say how a podcast can be powerful
Homework for the week beginning 16th April
1. Watch the video about podcasts.
2. Listen to the podcasts which were made by my students from year 5 in Thailand. Their task was to make an advert for a charity. What do you think, is the message given over clearly? Is there anything to be improved?
3, Write a short report about the explaining a) the purpose of a podcast. b) what you need to make a podcast. c) what you should do to make a successful podcast?
4. Email your report to me at [email protected]
2. Listen to the podcasts which were made by my students from year 5 in Thailand. Their task was to make an advert for a charity. What do you think, is the message given over clearly? Is there anything to be improved?
3, Write a short report about the explaining a) the purpose of a podcast. b) what you need to make a podcast. c) what you should do to make a successful podcast?
4. Email your report to me at [email protected]
Lucy talking about the Listen Campaign
Ohm talking about The United nations
Zinnie talking about the Red Cross
Homework for week 12th March
Read Chapter 3 Storage devices and media. All sections. Login to yacapaca .com with your own login details and complete the quizzes waiting for you.
Podcast about inputs and outputs
Homework for week 5th March
Additional work: Complete your work about inputs and outputs and re-submit you work by email attachment.
Homework task:
Homework task:
- Create a bubbl.us diagram showing hardware and software. Use this link to help you LINK
- Save you work.
- Export your work as a Jpg.
- Place your image onto your eportfolio.
- Email your image as an attachment
Homework for week beginning 27th February
Teach yourself how to use the program bubbl.us LINK Write on the forum what you think you could use a program such as this for. We will be using this program during the lesson so please be prepared.
Homework for week beginning 20th February
Draw a picture, using the computer to show a PC. You can choose which program you would like to use. Label the parts with input or output. Then include in your picture other peripherals (things that can be attached to a computer) and label them with input or output. You can use this LINK to help you. Email me your final picture, as an attachment: to [email protected] (you can use your home email address if you wish)
Homework for 2 weeks beginning 5th February and 13th February
Task 1: Test your knowledge of spreadsheets: Go to.. LINK
Task 2: Formulae worksheet. Open the document below, save onto your computer. Complete the task and email me you work as an attachment.
Do not forget if you have work outstanding from the last few homeworks you MUST CATCH UP.
Task 2: Formulae worksheet. Open the document below, save onto your computer. Complete the task and email me you work as an attachment.
Do not forget if you have work outstanding from the last few homeworks you MUST CATCH UP.
formulas.doc | |
File Size: | 18 kb |
File Type: | doc |
Homework for week beginning 30th January
What is phishing? Find out and leave a message on wallwisher, Click here LINK
Homework for week beginning 23rd January
You have two tests waiting for you on Yacapaca...... So login to your account using your login that you were given in ICT class and complete both assessments.
Homework for week beginning 16th January
If you where starting a new business and opening a restaurant how would ICT be useful? How would you use technology to make your new business a success? Think about your answer and write a minimum of 50 words to explain your thoughts. Post your work on the Secondary forum. Read other student's replies and comment on their ideas.
If you where starting a new business and opening a restaurant how would ICT be useful? How would you use technology to make your new business a success? Think about your answer and write a minimum of 50 words to explain your thoughts. Post your work on the Secondary forum. Read other student's replies and comment on their ideas.
_
Food for thought........