EXCEL / SPREADSHEET WEEK 3

Dear students,
Welcome back.

Learning Objectives:

1. Work in a group of three students to plan a class party.
2. Open Excel and enter the following columns,  items, quantity, price for each, the total cost
3. Enter budget data from the template shared and include the actual prices, hence calculate the total cost.
4. Determine if they underspend or overspend from the given budget of 500 Egyptian pounds. Give reasons.

The Assignment:

Students create a class party budget using a spreadsheet to show how much they have to spend (500 Egyptian pounds), the total costs of the items they buy, and how much they are over or under the budget amount.

 Students create a chart of the costs ONLY. Hint: select only the items column and the costs column to create the chart.

Homework

1. Students to plan their lunch budget at school for one week. 

2. Think of the foods you buy for a whole week, their prices, total cost. draft /draw the plan in a book at home.

3. During computing, each student creates his/her budget using Excel to show the total cost.

Enjoy your Excel project.

Mr. Wamurwa

EXCEL / SPREADSHEET WEEK 2

Dear Students,
As we continue with spreadsheets, we will be exploring the following areas;

Learning Objectives;
1. Enter data into Excel and calculate sum and subtractions.
2. Enter business transaction data into Excel and calculate profits.


Task 1

Use the picture below to enter the Souq Supermarket transaction to the spreadsheet.

Calculate the following;
1. Total or sum of the amount spent on buying items.
2. Total or sum of the amount received on selling items.
3. Profits received once the products/items were sold.
4. Format the column for profits to a blue color.
5. Format the row for totals to a green color.

Task 2.

Mr. Abdel bought items from Souq Supermarket as shown in the table below.

Calculate the following;
1. Total or sum of the amount spent by Mr. Abdel on buying items.
2. Total or sum of the amount received as a discount on items bought.
3. Calculate the amount paid for each item after the discount.
4. Format the column for discount to a red color.
5. Format the row for totals to a yellow color.

Enjoy your Excel Journey.
Mr. Wamurwa

EXCEL / SPREADSHEETS WEEK 1

Dear students,
Welcome to our lessons. on Excel/ Spreadsheets.

Learning Objectives:
1. know what a spreadsheet is,( columns, rows, cells/grids) 
2. Name the cells/cell reference.
3. Enter simple data into spreadsheet cells.

What is a spreadsheet?
A spreadsheet is a software application that enables a user to save, sort and manage data in an arranged form of rows and columns.
It helps users to calculate mathematical operations; addition, subtraction, multiplication and division.

Task1.

- Open Microsoft Excel.
- Enter the data shown in the table.

sports	House Points
Football	22
Basketball	16
Cricket	7
Swimming	32
Total

- Calculate the total points.

Enjoy your Excel Journey.
Mr. Wamurwa

MOVIE MAKING

Dear Students,

Welcome to Movie Making lesson.

Learning Objectives:

1. Create folders on the desktop (Computer screen).
2. Research and save images from Google images.
2. Plan and create a Movie using Windows Movie Maker,


How do you create a folder?

• Right-click on desktop or computer screen.
• Select New, then folder after that name the folder Movie. 

Save Images to the folder.

• Once you have named the folder,
• Select the required image from Google images 
• Right-click the image and select Save Image As.
• Select the folder on the desktop (Movie),
• Save the image as 1, 2, 3, 4, 5,.............,10

How do you create the Movie?

• Check on the desktop and open Windows Movie Maker.
• Add images using  (+ button)
• Arrange the images in the storyboard.
• Add transition.
• Add music 
• finally, click Export to the end

Enjoy the movie-making Process.

Mr. Wamurwa

CREAT A POSTER

Dear Students,
 Welcome to our lesson today.

LEARNING OBJECTIVES:

1. Use publisher to complete the brochure on Online Safety and print it.
2. Login to https://purplemash.com/tbs and use the template to create a poster on eSafety.
3. You can also create a poster using Microsoft Word, Publisher or PowerPoint slide.
4. In the last 5 minutes, we will have an educational game on kahoot about internet safety.

Requirements:
- The poster must have an attractive and visible title.
- It must have clear and summarized information about how to be safe online.
- must have graphics or images to support your title. "Remember LESS IS MORE"

ENJOY YOUR COMPUTING LESSON.

MR. WAMURWA

GAMING AND CODING

Dear students,
Welcome to fifth week. This week we shall focus on games on online safety and coding using purple mash to help us understand online safety .

Learning Objectives:

1. Play a kahoot game on Online safety;  

https://kahoot.com

2. Use this link to access purple mash and design a class poster on eSafety.

https://purplemash.com/tbs

- We will think about eSafety poster in our school boards. Create the poster on purple mash.

Use the guiding questions on the left side of the poster.

Enjoy the learning experience

Mr. Wamurwa

STEPS TO CREATE A BROCHURE.

FOLLOW THESE STEPS TO CREATE A BROCHURE.

1. On the Start button, type Publisher.
2. Click on Built in.
3. Once the Built in is open, type and search for brochure.
4. select the tri-fold (three columns) template.
5. Right click and delete the first page, use the second page
6. Double click and delete the text on the template and type your information on it.
7. save a few pictures on desktop screen an use them.
8. save the brochure on the desktop. click save as then select desktop and save with your name.

Enjoy your experience of design.

Regards

Mr. Wamurwa

ONLINE SAFETY: CREATE A BROCHURE TO SHARE YOUR RESEARCH

Dear students,
Welcome to the lesson on online safety. This page will guide you on how to remain safe while using the internet to research and work on your class assignments and projects.

Learning Objectives:

1. Inquire and learn different tips or ways of keeping safe on the internet.

2. Research and create a brochure on how to keep safe online / on the internet.

3. How strong is your password? https://howsecureismypasswo rd.net/

Task 1. 

What does internet safety or online safety mean?







Task 2


How do you protect yourself while using the internet or when researching online? 
Tips of online safety.

Task 3: 
How do you create a brochure?



Homework:
Task 4:

Create a brochure on how to stay safe while online.  Use this website to help you research and create a brochure.  
http://www.safetynetkids.org.uk/personal-safety/staying-safe-online/

Enjoy the research and stay safe online.

Regards

Mr. Wamurwa

COMPUTING CURRICULUM OVERVIEW

Dear students,

Welcome to our computing class blog.    https://yr6computing.blogspot.com/

This blog will provide you with a record of all computing classes for you to be able to use it at school and at home.

Learning Objectives:
By the end of year 6 you will be able to use the following computing skills effectively to solve day to day ICT problems;

1.  Coding using Purple Mash and Minecraft.
2. ICT Skills; Publisher- Brochures, PowerPoint, Movie Maker, Excel/ Spreadsheet, Animations
3. Online Safety. How do you keep safe while online?
4. Gaming using Kahoot, and Sploder.
5. Blogging
6. Quizzing
7. Networks

important websites addresses

1. https://purplemash.com/tbs   for coding, online safety, 

2.  https://yr6computing.blogspot.com/      for the class blog

Enjoy your learning experiences.

Regards

Mr. Wamurwa