Revision Activities for Term 2 Exams 2017-18

Dear Students of Year 5,
Please note that Computing Exam-2nd Term 2017-18 will be conducted on

Monday, March 05, 2018.
The Portions are given below;

Handling Data (MS Excel)
-Calculations in a Restaurant Bill (basic arithmetic operations)
-Calculating Business Profit/Loss
-Spreadsheet Charts (Graphs) for Business
*Conclusions
*Decisions
*Predictions

Please note that exam will be a practical session in the lab.

Revision Guidelines:
You are advised to revise all the activities attached to this post.
Wish you the best.
Ms. Zeenat

Term 2 Revision Activities

Graphs for Business Decisions

Time for Activities is 15 minutes
Go back to nearpod lesson at Reflection Time

1. Download this file ------> Activity File
2. Follow Instructions on Sheet > Activity 4
3. Post screen shot of completed task on seesaw.

Welcome to Computing Class

10-Sept-17 to 14-Sept-17

Objectives (students will be able to ...)

• know Computing course outline and tentative assessment plan.
• define Sorting
• perform selection sort

Resources

• Reading Content
• Lego Demonstration of Selection Sort
• Animations
• Gypsy Folk Dance - Selection Sort Demo
• Selection Sort Activity

Activity

• Group Activity to perform sorting
• Write the steps how you performed sorting.

Assessment

• Compare your steps of sorting with another group.

Data Handling - Assessment

Instructions:

1. Download file HERE
2. Follow instructions in Pink Sheet 1 and Pink Sheet 2
3. SAVE your file on desktop with the following filename format

                    <year><section>space<student name>
                  example          5D Asma

Data Handling Lesson 3

Calculating Total Profit 

Working with multiple worksheets in Excel

OBJECTIVES:

1. Describe the purpose of Profit and Loss calculation.
2. Calculate values available on other sheets.

Download Activity File

MS Excel - Adding Formulas (Prepare a Restaurant Bill)

Tune into the lesson objectives (5min):

Find Out What and How (10 min): 

Watch demonstration : How a digital spreadsheet helps in business calculations.
Question Time

Now try to calculate profit using a digital spreadsheet............. 
Link to download Activity 1 File

Tune in to today’s objectives (5 minutes)

Click here to watch an animated gif and answer the question below;

What animation event i shown in this animated gif?

             A-     Jump/Dive  

             B-      Kick

             C-      Punch

             D-     Hi Five

             E-      Turn/change direction

How does it work? (5 Minutes)

Let’s explore how can we control sprite's movement in Scratch.

Click here to watch how an animated character turns by keyboard control in Scratch (Application).

Learn by doing (15 Minutes)

Select any one Task to do

Task 1

       1- Import a sprite of your own choice.      

       2- Import a background.
       3- Prepare a script to control your sprite’s turn in 4 absolute direction by Arrow Keys.

Task 2:

·                1- Import a sprite of your choice.

            2- Import a background.

             3- Prepare a script to control your sprite’s turn Up and Down and change color on turning.

  

Calculate Success (5 Minutes)

        How many are the successful curious coders?

        What is the total count of students?

        How would you calculate Success Percentage?