Year 8 ICT
Learning how to code using HTML and CSS
Hardware and software
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
hardware_vs_software_lesson_1.pptx | |
File Size: | 181 kb |
File Type: | pptx |
Binary number system
Decimal and Binary numbers
Binary number quiz
Use the table here to write your name using binary (ASCII): http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/The_Characters.asp
Checker: http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/Binary_To_Text.asp
Binary number quiz
Use the table here to write your name using binary (ASCII): http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/The_Characters.asp
Checker: http://www.roubaixinteractive.com/PlayGround/Binary_Conversion/Binary_To_Text.asp
Year 8 exam
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
year_8_exam_markscheme.docx | |
File Size: | 11 kb |
File Type: | docx |
![](http://www.weebly.com/weebly/images/file_icons/file.png)
hotels.accdb | |
File Size: | 401 kb |
File Type: | accdb |
Hotel Images (Click to enlarge)
Top Trumps
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
2_create_a_top_trumps_database.docx | |
File Size: | 590 kb |
File Type: | docx |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
1_top_trumps_intro.docx | |
File Size: | 1507 kb |
File Type: | docx |
T-shirts and Brushes
Download->Unzip to D:-> Load Brushes
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
brush_guide.pptx | |
File Size: | 4070 kb |
File Type: | pptx |
![](http://www.weebly.com/weebly/images/file_icons/gz.png)
photoshop_brushes.zip | |
File Size: | 41201 kb |
File Type: | zip |
![](http://www.weebly.com/weebly/images/file_icons/image.png)
t-shirt_template.psd | |
File Size: | 2778 kb |
File Type: | psd |
![](http://www.weebly.com/weebly/images/file_icons/image.png)
dress.psd | |
File Size: | 205 kb |
File Type: | psd |
Homework-Due Mon 3rd
•Add 3 new songs
•Make a new playlist which includes the new songs, stylize and print
•Make a new playlist which includes the new songs, stylize and print
Music Database
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
disco_1.ppt | |
File Size: | 776 kb |
File Type: | ppt |
![](http://www.weebly.com/weebly/images/file_icons/file.png)
music_database.accdb | |
File Size: | 679 kb |
File Type: | accdb |
Database revision
Produce three separate searches (queries) for:
1) All boards whose brand is "Ripcurl"
2) All boards whose brand is "Billabong" and condition is "new"
3) Under board type, find all "surf" boards whose price is less than 450
The queries presentation below will remind you how to create a query. For each search, also produce a report which would be used as a printout for the surfshop.
1) All boards whose brand is "Ripcurl"
2) All boards whose brand is "Billabong" and condition is "new"
3) Under board type, find all "surf" boards whose price is less than 450
The queries presentation below will remind you how to create a query. For each search, also produce a report which would be used as a printout for the surfshop.
![](http://www.weebly.com/weebly/images/file_icons/file.png)
surfshop.accdb | |
File Size: | 679 kb |
File Type: | accdb |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
queries.pptx | |
File Size: | 1216 kb |
File Type: | pptx |
Hwk due Thurs 23rd
Finish and print poster for your advertised products
Radio adverts
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
radio_advert_evaluation.docx | |
File Size: | 11 kb |
File Type: | docx |
Sabine, Kelly, Alex
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
leisure_centre_model_profit.doc | |
File Size: | 46 kb |
File Type: | doc |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
leisure_centre_profit_model.xls | |
File Size: | 25 kb |
File Type: | xls |
Intro to radio adverts
Download the file below then listen to and comment on the radio adverts below.
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
radio_advert_analysis.docx | |
File Size: | 10 kb |
File Type: | docx |
Advanced spreadsheet skills-Respectable Spectacles
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
eyetest.xlsx | |
File Size: | 532 kb |
File Type: | xlsx |
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
eyetest.ppt | |
File Size: | 4830 kb |
File Type: | ppt |
Homework due Mon 29th
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
cinematicketsales.xls | |
File Size: | 17 kb |
File Type: | xls |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
cinemaspreadsheet.doc | |
File Size: | 47 kb |
File Type: | doc |
Graphs revisited
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
surveys_and_graphs.docx | |
File Size: | 418 kb |
File Type: | docx |
Spreadsheet test
Coats and Hats, one of the shops in the Farside Shopping Centre, runs many special offers. The shop buys clothes from other companies like Radman and Jingle.
It buys the clothes at a certain cost, but sells them to customers at a higher price so that it makes a profit. It has to be careful not to lower their prices too much or it will not make a profit.
Your task is complete the spreadsheet model hosted below:
It buys the clothes at a certain cost, but sells them to customers at a higher price so that it makes a profit. It has to be careful not to lower their prices too much or it will not make a profit.
Your task is complete the spreadsheet model hosted below:
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
coats_and_hats_model.xls | |
File Size: | 22 kb |
File Type: | xls |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
spreadsheet_test_questions.docx | |
File Size: | 13 kb |
File Type: | docx |
Your model should show:
a) the profit made on each item
b) the total amount of profit per item
c) the total amount of profit for all items. (cell F11)
d) the averages for all items
a) the profit made on each item
b) the total amount of profit per item
c) the total amount of profit for all items. (cell F11)
d) the averages for all items
Student animations
Spreadsheet recap
The Shakes have recently launched their first single ‘Shake 'em up’. They have printed 2,000 copies of the single, and want to know if they are making a profit or a loss on it.
Can you remember what the terms ‘profit’ and ‘loss’ mean? Share your ideas as a class.
Now open the file Spreadsheet model.xls, which shows you how much money The Shakes have had to pay out to produce the single (Costs), and how much money they have made so far on single sales (Revenue).
Can you remember what the terms ‘profit’ and ‘loss’ mean? Share your ideas as a class.
Now open the file Spreadsheet model.xls, which shows you how much money The Shakes have had to pay out to produce the single (Costs), and how much money they have made so far on single sales (Revenue).
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
goal_seek_1b.xls | |
File Size: | 203 kb |
File Type: | xls |
Complete Activity 1 on the spreadsheet, then save your work. As a group, discuss your approach to questions 9 to 11. What did you have to do to find an answer?
Find an outcome using Goal Seek
We can make answering the type of queries you made in questions 9 to 11 a lot easier by using a tool called Goal Seek. This allows us to tell the spreadsheet what we want an output to be, such as £1,000 profit, and what cell we want it to alter to reach this figure.
To find out how to use Goal Seek in Excel, follow the tutorial below:
Find an outcome using Goal Seek
We can make answering the type of queries you made in questions 9 to 11 a lot easier by using a tool called Goal Seek. This allows us to tell the spreadsheet what we want an output to be, such as £1,000 profit, and what cell we want it to alter to reach this figure.
To find out how to use Goal Seek in Excel, follow the tutorial below:
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
activity_2_helpsheet.docx | |
File Size: | 423 kb |
File Type: | docx |
Making your own game
CD Cover Back Checklist
- Tracklist
- Barcode (find a suitable one in google images)
- Image or colour fill
- Your logo / company name
- Copyright details
Logo's Quiz
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
logo_quiz.docx | |
File Size: | 167 kb |
File Type: | docx |
Fonts
Open the attached file and complete the tasks in MS Word.
![](http://www.weebly.com/weebly/images/file_icons/pdf.png)
y8_cover_fonts.pdf | |
File Size: | 340 kb |
File Type: |
CD Cover template
![](http://www.weebly.com/weebly/images/file_icons/file.png)
cd_cover.pub | |
File Size: | 84 kb |
File Type: | pub |
Stop Motion Evaluation
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
stop_motion_evaluation.docx | |
File Size: | 10 kb |
File Type: | docx |
Spreadsheet test
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
lunchbox_test.xls | |
File Size: | 30 kb |
File Type: | xls |
If you finish the test early, please design a menu for the school tuckshop. It should be based on the spreadsheet and have sale prices and appropriate pictures. Ensure all pictures are of a similar style. Do not mix cartoon/illustrated images with photos. Use 2-3 fonts maximum. This can be designed on Publisher or Powerpoint
Printing spreadsheets
Island Boutique
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
island_boutique_y8.xls | |
File Size: | 1145 kb |
File Type: | xls |
Pizza Palace Spreadsheet
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
pizza_palace.xlsx | |
File Size: | 11 kb |
File Type: | xlsx |
Logic game
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 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
Select a Podcast from this site, Snap jJudgement, 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 week beginning 23rd April
_You will be making a sound track for an advert about smartphones. In preparation, log into your wiki and write a script which you can use to make your sound advertisement. Please have it completed before our next lesson so we can work on the next stage of the project.
Homework for week beginning 16th April
Download Stykz from this site. Link Investigate how to use this program to make animations. Look at the You tube video if it helps you to learn. We will be using this program so you need to be prepared. Write a comment about Stykz on the forum.
ICT Lesson for Thursday 22nd March
Task 1
Open the document below and complete spreadsheet activity. It is an assessment task so there is no need to talk or ask for help. When you have finished email it to me as an attachment.
Task 2
Eportfolio: Go to your portfolio and upload any pictures you have or work you have done for ICT and other subjects. Think about what you have done in Art, English, Science and your recent trips. When you have finished email me a link to your eportfolio so I can admire it!
Note: I will expect to receive 2 emails from you by the end of the lesson.
Note: I will expect to receive 2 emails from you by the end of the lesson.
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
spreadsheets_yr8_what_do_you_know.doc | |
File Size: | 347 kb |
File Type: | doc |
Homework for week beginning 12th March
Go to yacapaca.com and login. Complete, both of the assignments waiting for you on internet safety and ICT in the home. ( you will need your username and password. )
Homework for week beginning 5th March
Prepare for you next lesson:
Task 1 Go to LINK read and think about this page then go to task 2.
Task 2 ; Go to LINK try out the activity on programming a screen turtle.
Task 3: Answer the questions below and email me your answers. ( you can copy and paste the questions into an email to save you time)
Test Bite
1. What is a program to control a robot written in?
English
computer language
encryption
2. Which of the following is a simple computer programming language?
LOGO
LEGO
LIGO
3. What is a turtle?
a fixed triangle on the screen
a programming language
a simulated robot controlled by computer
4. In LOGO what shape would these commands draw: FD100, RT 90, FD 50, RT 90, FD 100, RT 90, FD 50, RT 90?
rectangle
square
parallelogram
5. Jane's program to cut out a shape with a cutting tool cuts out the wrong shape. What's likely to be wrong with it?
the wrong material has been put in the cutter
the program code is not in the right order
the wrong operating system has been used
6. John wants to draw a letter L. The turtle is pointing towards the top of the screen. Which series of commands will draw the shape?
BACK 100 LEFT 90 FORWARD 50
BACK 100 RIGHT 90 FORWARD 50
RIGHT 180 FORWARD 100 RIGHT 90 FORWARD 50
7. What could you use to simplify the code to draw a square?
encryption
an instruction
a repeat command
8. Which of these commands is NOT a valid LOGO command?
FORWARD
BAKWARD
BK
Task 1 Go to LINK read and think about this page then go to task 2.
Task 2 ; Go to LINK try out the activity on programming a screen turtle.
Task 3: Answer the questions below and email me your answers. ( you can copy and paste the questions into an email to save you time)
Test Bite
1. What is a program to control a robot written in?
English
computer language
encryption
2. Which of the following is a simple computer programming language?
LOGO
LEGO
LIGO
3. What is a turtle?
a fixed triangle on the screen
a programming language
a simulated robot controlled by computer
4. In LOGO what shape would these commands draw: FD100, RT 90, FD 50, RT 90, FD 100, RT 90, FD 50, RT 90?
rectangle
square
parallelogram
5. Jane's program to cut out a shape with a cutting tool cuts out the wrong shape. What's likely to be wrong with it?
the wrong material has been put in the cutter
the program code is not in the right order
the wrong operating system has been used
6. John wants to draw a letter L. The turtle is pointing towards the top of the screen. Which series of commands will draw the shape?
BACK 100 LEFT 90 FORWARD 50
BACK 100 RIGHT 90 FORWARD 50
RIGHT 180 FORWARD 100 RIGHT 90 FORWARD 50
7. What could you use to simplify the code to draw a square?
encryption
an instruction
a repeat command
8. Which of these commands is NOT a valid LOGO command?
FORWARD
BAKWARD
BK
Homework for week beginning 20th February
Open the document below and complete the Questions. Email me your completed work at ..... [email protected] (you can use your home email address if you wish)
![](http://www.weebly.com/weebly/images/file_icons/xls.png)
customer_orders_database_with_questions.xls | |
File Size: | 15 kb |
File Type: | xls |
Homework for 2 weeks; beginning 5th February and the 13th February.
Task 1. Mircrosoft Access is a program which creates databases. Use the revision quiz to answer 20 questions to find out more ... Go to LINK
Task 2. Download the document below on database questions, complete the activity and then email it to me as an attachment, at..... [email protected]
Task 2. Download the document below on database questions, complete the activity and then email it to me as an attachment, at..... [email protected]
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
database_questions.doc | |
File Size: | 31 kb |
File Type: | doc |
Homework for week beginning 30th January
Task: Go to Bitesize ICT and read though the 5 pages about data. Then answer the following questions . LINK (Click here)
Copy and paste these questions into an email, type in your answers, and then email it to me before the next class. (Thursday)
1. What are numbers, pictures or words without context known as?
2. What are a collection of words, numbers or pictures with meaning known as?
3. What does putting data into a framework or structure provide?
4. What is the ability to understand information and to then form judgements, opinions, make predictions and decisions based on that understanding also known as?
5. Which of the following is correct? Data leads to information, and information leads to knowledge. Knowledge leads to information, and information leads to data.
Data leads to knowledge and knowledge leads to information.
6. The statement 'it was raining outside' is which of these? data. information knowledge
7. which of the following is NOT an example of data? 301062; blue; 32, Primrose Hill
8. 'The petrol gauge was showing almost empty. I decided to look out for the next petrol station'. What is the statement 'I decided to look out for the next petrol station' an example of? Data; information; knowledge
9. What is a computer program that makes decisions based on the large quantity of information it stores known as?
10. Which is the most suitable program for storing large quantities of data?
Copy and paste these questions into an email, type in your answers, and then email it to me before the next class. (Thursday)
1. What are numbers, pictures or words without context known as?
2. What are a collection of words, numbers or pictures with meaning known as?
3. What does putting data into a framework or structure provide?
4. What is the ability to understand information and to then form judgements, opinions, make predictions and decisions based on that understanding also known as?
5. Which of the following is correct? Data leads to information, and information leads to knowledge. Knowledge leads to information, and information leads to data.
Data leads to knowledge and knowledge leads to information.
6. The statement 'it was raining outside' is which of these? data. information knowledge
7. which of the following is NOT an example of data? 301062; blue; 32, Primrose Hill
8. 'The petrol gauge was showing almost empty. I decided to look out for the next petrol station'. What is the statement 'I decided to look out for the next petrol station' an example of? Data; information; knowledge
9. What is a computer program that makes decisions based on the large quantity of information it stores known as?
10. Which is the most suitable program for storing large quantities of data?
__Homework beginning 23rd January
_Log into Yacapaca using you individual login which was given to you in the ICT lesson and complete two tests.
www.yacapaca.com
www.yacapaca.com
Homework: Week begins 16th January
Log into Yacapaca using you individual login which was given to you in the ICT lesson and complete the Quiz.
www.yacapaca.com
www.yacapaca.com