Year 7 homework # 1

Excel basics

This is image A for question 1. The area outlined in red is called what?


This is image B for question 2. The area outlined in red is called what?


This is image C for question 3. The area outlined by both red boxes is called what?


This is image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what?

This is image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

Year 7 homework # 2

Tables and charts

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is image A for question 1. What is the best way of making the column wide enough to fit all of the text in cell A1?

This is image B for question 2. The text in cell B2 needs to be spread over 4 cells, B2 to E2 and then centred; what is the best way of doing this?

This is image C for question 3. Which formula is the best way of adding up the total number of hats in cell F3?

This is image D for question 4. I want to copy the formula in cell F3 to the 4 cells underneath; which is the best way of doing this?

This is image E for question 5. How do I add the borders in cells B8 to F8?

This is image F for question 6. I want to copy the formula in cell F3 to the 4 cells underneath; which is the best way of doing this?

This is image G for question 7. Which method is the best way of adding up the sales for weeks 2 to 4 and the total?

This is image H for question 8. How do I select the data for the chart that I want to draw?

This is image I for question 9. I have selected my data but what do I do to draw a pie chart?

This is image J for question 10. Which of these methods is the best way to change the background of the pie chart?

Back to the top.

Year 7 homework # 3

Excel calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is image A for question 1. I have written "January" in cell B2, what is the easiest way to get the other months of the year in cells C2 to M2?

This is image B for question 2. How do I centre the words "Sixth Month Visitor Numbers" across cells B1 to G1?

This is image C for question 3. What is the best formula that I should use to find the average number of visitors to the liaons?

This is image D for question 4. I have used fill down to copy the formula for average but how do I make the cells so that they only show the average to two places of decimals?

This is image E for question 5. What is the formula to use in cell B8 that will find the maximum number of animals visited in January?

This is image F for question 6. There are three ways that I can fill in the formula that finds the max for all of the other months. Which of these ways does not fill in the formula?

This is image G for question 7. How did I select the animals in cells A2 to A7 and the averages in cells H2 to H7?

This is image H for question 8. I have managed to change the layout of the chart so that the bars have images, Which if these statements is true?

This is image I for question 9. What sort of chart is this?

This is image J for question 10. What steps have I taken to draw this line chart?

Back to the top.

Year 7 homework # 4

Youth Club

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is the image A for question 1. The area outlined in red is called what?

This is the image B for question 2. The area outlined in red is called what?

This is the image C for question 3. The area outlined by both red boxes is called what?

This is the image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is the image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is the image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is the image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is the image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what

This is the image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is the image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

Year 7 homework # 5

Excel charts

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel spreadhseet for these homework questions.

This is the image A for question 1. What do you have to do to make column D wide enough to see the text?

This is the image B for question 2. If 120 children over 15 visit the youth club what is the formula in cell E32 that works out how much is made?

This is the image C for question 3. If 138 children between 12 and 15 visit the youth club what is the formula in cell E33 that works out how much is made?

This is the image D for question 4. What formula should be typed into cell E25 to work out the total ticket sales?

This is the image E for question 5. What do you have to do to select the shaded cells?

This is the image F for question 6. In which menu are the chart types from which you would have selected the 3D column chart to draw this chart?

This is the image G for question 7. I have selected a part of the chart, which part?

This is the image H for question 8. TheWhat steps did I go through to make this chart?

This is the image I for question 9. Which is these instructions is not necessary when making this chart?

This is the image J for question 10. What is wrong with this chart?

Back to the top.

Year 7 homework # 6

Excel challenge

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel spreadsheet for these homework questions.

This is the image A for question 1. The area outlined in red is called what?

This is the image B for question 2. The area outlined in red is called what?

This is the image C for question 3. The area outlined by both red boxes is called what?

This is the image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is the image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is the image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is the image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is the image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what

This is the image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is the image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

Year 8 homework # 1

Excel "painting by numbers"

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel file that you can use to help you to work out the answers to these questions.

This is image A for question 1. Which of these statements explains how multiple cells can be selected?

This is the image B for question 2. What actions must I carry out to select these cells?

This is the image C for question 3. How can a user add grid lines to the selected cells?

This is the image D for question 4. How do I fill cell C10 so that it is all red?

This is the image E for question 5. If I want all of the cells with a border to have the value 0,1 or 2 which of these do I choose?

This is the image F for question 6. How is it possible to make the cells change colour so that if the user selects 0, 1 or 2 the cell goes red. Blue or green?

This is the image G for question 7. Which of these rules is wrong?

This is the image H for question 8. What steps would I take to extend the set of cells so that they are double the size as shown in the image?

This is the image I for question 9. What steps would I take to change the red cells so that they are now yellow?

This is the image J for question 10. Which if the following ways to count the number of colours is not correct?

 

Back to the top.

Year 8 homework # 2

Excel calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel file that you can use to help you to work out the answers to these questions.

This is the spreadsheet that you are going to make. The next 5 questions all relate to this image.

  1. 1. How did you centre “Entrance Prices for Visitors” across cells B2 to E2?
  2. 2. How did you change the column widths of these cells?
  3. 3. How did you ensure that the costs and totals all have £ signs?
  4. 4. What is the formula that you typed into cell E5?
  5. 5. What is the formula that you typed for the total ticket sales into cell E7?

The owners have conducted some research and found that the number of children who buy tickets is related to the price of the ticket. The more expensive the ticket the fewer children will buy one. For example the numbers of over 15s arriving has this formula =(5.25-Cost)/Cost*300 so that if the cost is £3.50 then 150 over 15s will buy a ticket. This is the formula that Excel needs in cell D4 =(5.25-C4)/C4*300 This is the formula that Excel needs in cell D5 =(4.2-C5)/C5*300 and in D6 =(2-C6)/C6*300

Questions 6 to 10 relate to this image. There is a link to a working copy of the spreadsheet here. Right click on the link and select the “save target as” option. You can then upload the file to Office365 and then open it even if you do not have excel at home.

Here are some “What if” questions based on this spreadsheet. Reset all the values back to the start before you begin each question.

  1. 6. What is the maximum price that can be charged to over 15s and the centre still get £1000?
  2. 7. How many 12 to 15s attend if the centre is to make £1,200?
  3. 8. What is the maximum price for an under 12 ticket if the centre is to make £1,150?
  4. 9. What was the “Set Cell” in question 8?
  5. 10.What was the “By Changing Cell” in question 7?

Back to the top.

Year 8 homework # 3

More Excel calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


    You may wish to use Excel to try these questions out.

    Here is the Excel file that you can use to help you to work out the answers to these questions.

    Questions 1 to 10 relate to this image. There is a link to a working copy of the spreadsheet here. Right click on the link and select the “save target as” option.

You can make use of the notes from the lessons here to help if you are not quite sure how to answer some of the questions.

Don’t forget to reset any changed values for the next question.

  1. 1. If jackets now cost £25.00 what is the total profit?
  2. 2. If there is a sale on jeans and the price is lowered to £19.50 what is the total profit?
  3. 3. If the cost of bags increases by 50p and the cost of hats falls by 25p what is the total profit?
  4. 4. If there is a sale on jackets and the price is slashed to £29.99 and 2000 are sold what is the total profit?
  5. 5. If the number of jeans sold is 1500 what is the lowest that they can be sold for so that they still make £60,000 profit?
  6. 6. What is the selling price of bags if 1,200 are sold and they want to make a profit of £62,000?
  7. 7. What was the “Set Cell” in question 4?
  8. 8. What was the “By Changing Cell” in question 2?
  9. 9. What was the “Set Cell” in question 6?
  10. 10. What was the “By Changing Cell” in question 6?

Back to the top.

Year 8 homework # 4

Excel "What if" calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel file that you can use to help you to work out the answers to these questions.

Questions 1 to 10 relate to this image. There is a link to a working copy of the spreadsheet here. Right click on the link and select the “save target as” option.

You can make use of the notes from the lessons here to help if you are not quite sure how to answer some of the questions.

This question shows a number of books being sold at the highest or lowest price.

Don’t forget to reset any changed values for the next question.

  1. 1. If the % sold at the highest price is 60 how many books must be sold to make £3,250 in profit?
  2. 2. If the % sold at the highest price is set to 75, how many books must be sold to make £2,400 in profit?
  3. 3. If 250 books are sold what is the % sold at the highest price (to 1 decimal place) to make £3,100 in profit?
  4. 4. If 610 books are sold what is the % sold at the highest price (to 1 decimal place) to make £15,600 in profit?
  5. 5. What was the “Set Cell” in question 4?
  6. 6. What was the “By Changing Cell” in question 3?
  7. 7. If the % sold at the highest price is 80 how many books must be sold to make £3,095 in profit?
  8. 8. If the % sold at the highest price is set to 25, how many books must be sold to make £1,999 in profit?
  9. 9. If 350 books are sold what is the % sold at the highest price (to 1 decimal place) to make £8,995 in profit?
  10. 10. What was the “By Changing Cell” in question 9?

Back to the top.

Year 8 homework # 5

More Excel "What if" calculations

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel file that you can use to help you to work out the answers to these questions.

Questions 1 to 10 relate to this image. There is a link to a working copy of the spreadsheet here. Right click on the link and select the “save target as” option.

You can make use of the notes from the lessons here to help if you are not quite sure how to answer some of the questions.

This question shows a number of books being sold at the highest or lowest price.

Don’t forget to reset any changed values for the next question.

  1. 1. If the % sold at the highest price is 60 how many books must be sold to make £3,250 in profit?
  2. 2. If the % sold at the highest price is set to 75, how many books must be sold to make £2,400 in profit?
  3. 3. If 250 books are sold what is the % sold at the highest price (to 1 decimal place) to make £3,100 in profit?
  4. 4. If 610 books are sold what is the % sold at the highest price (to 1 decimal place) to make £15,600 in profit?
  5. 5. What was the “Set Cell” in question 4?
  6. 6. What was the “By Changing Cell” in question 3?
  7. 7. If the % sold at the highest price is 80 how many books must be sold to make £3,095 in profit?
  8. 8. If the % sold at the highest price is set to 25, how many books must be sold to make £1,999 in profit?
  9. 9. If 350 books are sold what is the % sold at the highest price (to 1 decimal place) to make £8,995 in profit?
  10. 10. What was the “By Changing Cell” in question 9?

Back to the top.

Year 8 homework # 6

Excel challenge

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address (school login name that has the date in it @sirharrysmith.cambs.sch.uk) and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them to your own device and then upload them to office365.


You may wish to use Excel to try these questions out.

Here is the Excel file that you can use to help you to work out the answers to these questions.

Questions 1 to 10 relate to this image. There is a link to a working copy of the spreadsheet here. Right click on the link and select the “save target as” option.

You can make use of the notes from the lessons here to help if you are not quite sure how to answer some of the questions.

This question shows a number of books being sold at the highest or lowest price.

Don’t forget to reset any changed values for the next question.

  1. 1. If the % sold at the highest price is 60 how many books must be sold to make £3,250 in profit?
  2. 2. If the % sold at the highest price is set to 75, how many books must be sold to make £2,400 in profit?
  3. 3. If 250 books are sold what is the % sold at the highest price (to 1 decimal place) to make £3,100 in profit?
  4. 4. If 610 books are sold what is the % sold at the highest price (to 1 decimal place) to make £15,600 in profit?
  5. 5. What was the “Set Cell” in question 4?
  6. 6. What was the “By Changing Cell” in question 3?
  7. 7. If the % sold at the highest price is 80 how many books must be sold to make £3,095 in profit?
  8. 8. If the % sold at the highest price is set to 25, how many books must be sold to make £1,999 in profit?
  9. 9. If 350 books are sold what is the % sold at the highest price (to 1 decimal place) to make £8,995 in profit?
  10. 10. What was the “By Changing Cell” in question 9?

Back to the top.

Year 9 homework # 1

Excel basics

To do some of these homework tasks you will need to have access to Excel. You can access Excel through the school website. Select the mail icon.

When prompted, log in with your normal school credentials – the username is your full school email address and the password is the one that you use in school.

There are files associated with some of the exercises, you can download them and then upload them to office365.

This is image A for question 1. The area outlined in red is called what?


This is image B for question 2. The area outlined in red is called what?


This is image C for question 3. The area outlined by both red boxes is called what?


This is image D for question 4. The formula to add up the 5 numbers on the screen is what?

This is image E for question 5. The formula to add up the 5 numbers in the right hand column is what?

This is image F for question 6. The formula to add up the blue shaded numbers and put the answer in D9 is what?

This is image G for question 7. The formula to add up the orange shaded numbers and put the answer in F5 is what?

This is image H for question 8. The formula to add up 9, 53, 3 and 59 on this spreadsheet is what?

This is image I for question 9. The formula to subtract 3 from 27 and put the answer in cell E3 is what?

This is image J for question 10. The formula to subtract 9 from 43 and put the answer in cell E7 is what?

Back to the top.

Year 9 homework # 2

Excel charts

This is the image A for question 1.

 

Back to the top.

Year 9 homework # 3

More Excel charts

This is the image A for question 1.

 

Back to the top.

Year 9 homework # 4

Website terms

This is the image A for question 1.

 

Back to the top.

Year 9 homework # 5

Business terms

This is the image A for question 1.

 

Back to the top.

Year 9 homework # 6

Excel challenge

This is the image A for question 1.

 

Back to the top.

Recent Posts

May 24

Repairing a hyperspace window

You may have noticed the time shift in the Blue coridor, there is a redshift at certain times of the day; this has caused the bells to malfunction and the PCs are runing slow as the server room is also moving ever so slowly into the 5th dimension. The Lightspeed engineers are working hard to fix the hyperspace window being generated by the tidal effects of big data and the weaknesses in the walls caused by excessive data mining. Cambridge Analytica's data scraping has also contributred to the weakness in the space time continuum. There is no need to be afraid as everything is should be resolved in the near future; nevertheless steps are being taken, mostly from the gold staircase.

Any further information will be included here when and if we get it.

July 18

Adventuring with A GDPR SUrveyor

The GDPR surveyors will be in the College in the near future checking that you understand your obligations under GDPR. Are you aware of the consequences? Do you know who knows about you? Do you know what the people you don't know about, know about you? Have you checked your own settings? Are you privacy minded? The GDPR surveyors will check. They know you, possibly better than you do but maybe not as well as the Internet knows you.

July 14

Games for Free

There are a number of games that you can get for free that are really good. They are really good at collecting all of your data and passing it on to someone else. You don't know who they are and you don't know why they are collecting your data. They have your data and access to your friends. In minutes they have your friends' data and are collecting the data from their friends. If its a good game you will even tell your friends about it so you do their sneakiness for them and still tell your friends. It will never happen to you but hey that game...

Spotlight

Neural Implants

The pros and cons. Mostly cons.

Be permanently connected to Google and you can ask Alexa in your head; only you can hear the answer...