10GCSE – Period 1: Tuesday 22nd May

Starter: With a partner, please see if you can find the answers to these questions;

1. What is the difference between a solid state drive (or disk) and a hard disk drive?
2. Can you find 3 advantages and 1 disadvantage of using a SSD instead of a HDD?
3. What devices make use of a SSD?
4. Can you find out the price difference of upgrading a laptop to a SSD instead of a HDD?

Controlled Assessment

If you think you have finished your model today then you need to make sure you have done the following (see last lesson’s post for more detail);

1. Tested your model
2. Completed your review
3. Updated your sources (either on the spreadsheet or in your sources table)

If you finish….

Let me know so I can stop your clock.  You can then get on with some revision.

10GCSE – Period 2: Friday 17th May

Starter: Input/Output/Storage

Controlled Assessment

Your model will be marked out of 12 – here is the criteria for the 9-12 mark range;

The student has selected relevant data, developed a complex spreadsheet model that generates sufficient reliable and meaningful information to fully inform the decision-making process. Effective testing has been carried out. (9-12 marks)

How do you get these marks?

• Make sure you have commented on the relevance and reliability of the data you have selected – sources table and review
• Make sure your model works and fulfils its purpose – check the CAB
• In your review explain how you have tested your model to make sure the results are reliable.

Completing your review

Here are some of the design decisions that you should discuss in your review;

• How many different sheets do you have?  Why?  What is on each sheet? Why?
• What colours, font styles, font sizes have you used and why?  Have you included any images – if yes, why?
• What tools have you used – =vlookup, =if, conditional formatting, spinners, sliders, validation etc. why have you used them?

Feedback

Make sure you have recorded at least 5 bits of feedbck from me or your buddy.  Also make sure you have explained what you did as a result of the feedback.  Adding a date and maybe even a time to your feedback is a good idea.

Selecting data;

You will have used the internet to find data which you have used in your model.  Why did you decide to use this data?  Was it relevant, reliable, up-to-date?  How do you know?

Testing;

How do you know that your BMI calculation is correct? What could you do to test it?  Are there any other calculations that would be useful to test.

Sources table;

Make sure you have recorded your sources somewhere (in your sources table or in your spreadsheet).  Make sure that you have;

• included comments about copyright
• explained where and how you will use the information
• explained why you think the information is reliable
• included some sources of information you didn’t use and explain why you didn’t use them

 

10GCSE – Period 5: Wednesday 16th May

Starter: Media Players (e.g. iPod)

1. Do you own a media player? Answer these questions – use the internet to help you if you are not sure;
   • What type of interface does it have? Touch screen or buttons?
   • Does it have a screen, if so what resolution is the screen?
   • How much memory does it have?
   • How can it connect with other devices?
2. using a whiteboard in groups of 5, write down all the things you can do with a media player.

Controlled Assessment

Please make sure that you are getting feedback (at least once a lesson) and that you are completing your reviews.  If you think you have finished, have a look at some of the ideas to make your model more useful – the ideas are on the last page of your help sheets.

Homework

Revision

10GCSE – Period 5: Friday 11th May

Starter: Head to Head Acronyms

Revision List

Here are some of the topics you might want to revise before your exam;

• Online shopping
• Internet privacy
• Optical Media (CD, DVD, Blu-ray)
• Streaming and Downloading music and video
• Social Networks
• Sat Navs

Test Feedback

Controlled Assessment

Please continue with your controlled assessment

Homework

None set due to DofE

10GCSE – Period 1: Tuesday 8th May

Starter: Streaming vs Downloading Worksheet

Controlled Assessment

Please continue with your models.  Remember;

1. get regular feedback
2. open your Activity 2 review and complete it when possible
3. record the sources of your information that you use

Homework – Revision

Please revise GPS and Downloading vs Streaming for a short test on Thursday.

10GCSE – Period 1: Friday 4th May

Starter: Pictionary

Homework feedback – What are some of the consequences if….

1. a photo you shared only with friends is made public?
2. a company collects lots of personal data about you when you signed up to their internet service?
3. somebody obtains your name and address details online?
4. you accidentally make a facebook post public that contains your current location?

Controlled Assessment

Please open your Activity 2 reviews and read through the model section.

Spend some time filling in anything that you can in your review.

Then continue to work on your models – remember to fill in your feedback and your sources table as necessary.

10GCSE – Period 5: Wednesday 2nd May

Starter: Look at the words on the board – choose three that you would like to explain to the person sitting next to you and one that you are not sure about and you would like them to explain it to you.

Controlled Assessment

Please continue to work on your spreadsheet models.

Remember to get at least one bit of feedback this lesson which you write down.

Homework – due in on Friday

Streaming vs Downloading – find at least one advantage and one disadvantage for streaming and downloading.  Try and avoid your advantages and disadvantages simply being opposites.  You might find the video below useful;

 

10GCSE – Period 5: Friday 27th April

Starter: Wordwall acronyms

Controlled Assessment

Feedback – please obtain at least one piece of feeback before you continue to work on your models.

The following 3 videos may help you with your controlled assessment spreadsheets

Avoiding #NA problems when using vlookup

Avoiding_#NA_problems

►

If vlookup stops working when you use the fill handle

absolute_cell_reference_and_vlookup

►

Using =if to pick up different values for male or female

Using_If_to_pick_up_different_values

►

10GCSE – Period 4: Thursday 26th April

Starter: Understanding your homework

Controlled Assessment

Please continue with your spreadsheet models.

Ensure that you have the CAB, your sources table and your review open at the same time.

Remember, your model should allow someone to enter their personal details (height and weight), choose a diet, choose some exercises and then see what impact this has on their BMI over a period of ten weeks.

Homework

1. Please list all the internet accounts you have (facebook, ebay, amazon, gmail etc.).
2. What information do these companies hold about you?
3. When you use these services online is there anything that might affect your privacy or you should be worried about?

10GCSE – Period 1: Tuesday 24th April

Starter: Using a whiteboard, please write down all the COMPUTER PERIPHERALS you can think of (a mouse is an example of a computer peripheral)

Controlled Assessment

Please continue with your spreadsheet models.

Ensure that you have the CAB, your sources table and your review open at the same time.

Remember, your model should allow someone to enter their personal details (height and weight), choose a diet, choose some exercises and then see what impact this has on their BMI over a period of ten weeks.

Homework

Please complete the Acronyms Sheet and bring it to Thursday’s lesson.