Lesson 1 - Cyberbullying & Netiquette

In today's lesson:

We are learning what the term cyber bullying means and to understand ways to protect ourselves against cyber bullying.

‘netiquette’ is a set of agreements about how to behave in online communication.

Tasks:

1. Open Google Chrome 
2. Log into Robert Clack Apps
3. Make a copy of the Netiquette worksheet by clicking File and Make a Copy.
4. Add your worksheet to your eportfolio.

Extension Task:

1. Log into Robert Clack Apps
2. Create a new document by clicking Create document.
3. Write a pretend diary entry for the boy we saw in the film. 
4. It should start: The cyber bullying in my school could have been avoided if my school had taught us tips on how to communicate online properly. Tips such as…
5. It should include netiquette tips that he thinks could have made a difference if he and his year group had been taught them in school. 

Creating an ePortfolio

In today's lesson we are learning: 

• What an ePortfolio is, 
• How we are going to use one in ICT lessons
• and how to setup your ePortfolio for the first time.

Tasks:

1. First you will need to open Google Chrome by clicking on Start, All Programs, and Google Chrome.
2. Next go to www.ictwithmissp.co.uk
3. Click on the Eportfolio button.
4. or if you are already in google chrome click here.
5. You need to log in to Robert Clack Apps using the password given to you by your teacher.
6. Next watch these videos to help you setup your ICT ePortfolio correctly.

Video 1

Video 2

Homework:

Log into your ePortfolio outside of class, either at home or at lunchtime in ICT Club and add an element to it:

• An image

• Some text

• A link

Remember you will need to load Google Chrome first, so you may need to install this onto your computer at home.

Welcome to computing & ICT at Robert Clack

Class rules:

• We are silent when the teacher is speaking.
• We are polite, pleasant and respect everyone.
• We save our food and drink for meal times.
• We arrive on time to our lesson.
• We come into the classroom quietly, log on and start any tasks displayed on the screen or board.
• We only play games at home, not in ICT lessons.

 

 

During our lesson today you will have:

• logged in to the school network for the first time and changed your password.

Homework due next lesson:

Take this survey.

Revision for End of Year Exam

In today's lesson:

• We are learning to identify topics for revision
• collaborate with others to produce a revision booklet.

Tasks:

1. We will recap the assessment you took last lesson.
2. Get into groups of 3 or 4:

• Make a list of topics that we have studied over this past year in one google presentation and share it with the rest of the group.
• Divide the topics between members of the group.
• Each member of the group is responsible for creating slides giving information about that topic to help the rest of the group revise.
• Write a list of questions to test yourself on these topics.

Homework:

Use the booklet you have made in Google Docs to revise for your end of year exam.

End of Unit Assessment

In today's lesson:

• You will take an end of unit assessment
• Before spending some time organising your eportfolio and preparing revision for your end of year test.

Tasks:

1. Log into Robert Clack Apps by clicking here
2. Take your spreadsheet unit assessment by clicking here.
3. Ensure all your spreadsheet work is attached to your eportfolio spreadsheet unit page. 
4. Check to see if you have any badges to add to your eportfolio by looking in the 'shared with you' folder in Google Drive.

Extension:

In a few weeks time you will be sitting an end of year 7 exam in all your subjects including ICT.

1. Begin to make a list of topics that we have covered in ICT this year in a Google document.
2. Write down any questions you have, or any areas that you are not sure about for each topic.
3. Plan when you are going to find out the answers to those questions and revise for your exam.

Lesson 4 and 5 - Developing a model further and creating graphs

Charts (called Graphs in Maths lessons) are used to present information - numbers or data - in a way that is easier to read. There are different types of charts, the most common are pie charts, bar charts and line charts. We can use different types of charts to show us different things.

In today's lesson we are learning:

• to understand what happens if we change the values of variables
• to understand why different charts can be useful for different things
• be able to create a chart to represent the data in your spreadsheet model.

Tasks:

1. Complete your shop model to include both a 'costs' table and a 'revenue' table. 
2. Calculate the profit you would make on selling your products.
3. Identify variables and rules in your model using labels.
4. Use the chart wizard to make a chart that shows you what revenue each product is making.
5. Make a copy of this Spreadsheet Charts document and answer the questions.

Extension:

Consider how many visitors you may get to your shop. Is it realistic to expect millions of visitors in one month? Imagine for example I was selling my sweets to Year 7 only. There are approximately 300 students in year 7. I should adapt my spreadsheet model to include this information. Do I have enough stock for them? Will they buy from me every day?

Lesson 3 - Developing a Model

In today's lesson we are learning to:

• Identify variables and rules
• Make adjustments to a spreadsheet model
• Add correct formula to a spreadsheet model

Tasks:

1. You are starting you own shop in which you can sell any range of stock. For example you might want to run a sweet shop, or a shoe shop.

2. Once you have chosen your stock, using google search shopping find some stock and the cost price for each item. You need at least 6 items. For example, Haribo, Skittles, Mars Bars, etc.

3. Using Robert Clack Apps, Create a spreadsheet model for your shop, by clicking Create and Spreadsheet.

4. You will need to include a column for:

• Products
• Price per item
• Number of items
• Total Revenue

5. Calculate the total revenue using a formula.

Extension:

Underneath your completed model add a table with these column headings:

• Costs
• Cost per item
• Number of items
• Total Costs

Calculate the total costs using a formula. Then calculate your profit using a formula. Remember Profit = Costs - Revenue