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?