See the example below

Problem: Create a solution to find the area of a circle.

Problem Definition: Create a program which prompts the user to enter the radius of a circle, and outputs its area.

Algorithm in narrative form:

1. Welcome the user and proceed to prompt the user to enter the radius of the circle.

2. Store the entered radius in a variable.

3. Use the formula for the area of a circle: Area = π × radius² (where π is approximately 3.14159).

4. Calculate the area by squaring the radius and multiplying the result by π.

5. Output the calculated area of the circle to the user.

6. End the program with a thank you message.

Algorithm in Pseudocode:

START
    R ← 0
    AREA ← 0
    pi ← 3.14159    
    OUTPUT "Welcome to the Area of a Circle Calculator"    
    OUTPUT "Please enter the radius of the circle:"
    INPUT R    
    AREA ← pi * (R * R)    
    OUTPUT "The area of the circle is: ", AREA    
    OUTPUT "Thank you for using the calculator!"
STOP

See Flowgorithm File And flowchart graphic here: https://drive.google.com/drive/folders/1Lbf_A-SdV5F4P1YEFui1scGLc3FGVFG1?usp=sharing

© 2024  Vedesh Kungebeharry. All rights reserved. 

1. Storyboard Creation:
   • Create a storyboard with at least 4 scenes or backgrounds.
   • Include two characters speaking at least a total of 4 sentences per scene.
   • Incorporate at least 2 animations across the four scenes.
2. Storyboard Development:
   • Begin with rough sketches in your notebook during class with guidance from your teacher.
   • Finalize the storyboard in your notebook with:
     • One column for the visual description of the scene (drawing).
     • Another column for the text narration, including character positioning and animation.
3. Scratch Project Implementation:
   • Create a shared Scratch project based on your storyboard.

Submission Requirements:

1. Your completed storyboard must be drawn in your ICT notebook. Submit visible screenshots of your notebook either as a series of images or within a PDF document.
2. Include a link to your shared Scratch project. (See here for sharing a Scratch project: How to Share a Scratch Project)
3. If working in a group, only the group leader needs to submit the above. Include the names of all other group members.

Rubric

© 2024  Vedesh Kungebeharry. All rights reserved. 

Practice the tutorial shown here:

Optional Tutorials:

Create a scratch Script/Program which uses the pen tool to draw a rectangle
slanted at a 45 degree angle. Ensure that the rectangle occupies a large   portion of the stage.

Submit a link to you scratch project for marking 

1  – When Green flag is clicked
1  – Immediately erasing all pen activity before drawing the rectangle
2 – orienting the pen to 45 degrees
2 – Correct use of a loop
2 – correctly drawing the length
2 – correctly drawing width
2 – correct use of the turn block
3 – Good positioning of the rectangle withing the stage

© 2024  Vedesh Kungebeharry. All rights reserved. 

Scratch Project: https://scratch.mit.edu/projects/999695955/editor/

See video below:

© 2024  Vedesh Kungebeharry. All rights reserved. 

Step 1: Create Sample Data

First, we will create a sample dataset. We have a list of students with their names, grades, and scores.

Step 2: Enter Data in Excel

Open Excel and enter the following sample data into a new worksheet:

Step 3: Sorting Data

To sort the data:

1. Click on any cell in the column you want to sort by (e.g., Grade).
2. Go to the Data tab on the Excel ribbon.
3. Click on Sort A to Z (ascending order) or Sort Z to A (descending order).

Step 4: Subsorting (Multi-level Sorting)

Subsort the data by Grade, then by Score, and finally by Name:

1. Select any cell in the data range.
2. Go to the Data tab on the Excel ribbon.
3. Click on the Sort button to open the Sort dialog box.
4. For the first level, choose Grade from the Sort by dropdown, select Values in the Sort On dropdown, and choose A to Z for the order.
5. Click Add Level to add a second sort condition.
6. For the second level, choose Score from the Then by dropdown, select Values in the Sort On dropdown, and choose  Largest to Smallest for the order.
7. Click Add Level again to add a third sort condition.
8. For the third level, choose Name from the Then by dropdown, select Values in the Sort On dropdown, and choose A to Z for the order.
9. Click OK to apply the multi-level sort to your data.

Step 5: Review Sorted Data

What happens when 1 student has the same grade and score as another?

Sample Data

Download a file containing the sample data here:

https://drive.google.com/drive/folders/1JXTLenz8FvsX9GijfMCKkGCzQfnrlkS5?usp=drive_link

Updates to this post

2023/11/17 – Changed values for score to make the example more reasonable.

© 2023  Vedesh Kungebeharry. All rights reserved. 

Task:

Create a bar chart which compares the income, expenses, and profit for the first four months of the year.

Setup a table as shown below with values of your choosing create the chart:

Tutorial (TA-Note)

Creating the Table:

1. Open Excel.
2. Click on “Cell A1” and type “Month”.
3. Starting from “Cell A2” downwards, type the months: Jan, Feb, Mar, and Apr.
4. Click on “Cell B1” and type “Income”. Similarly, fill in “Cell C1” with “Expenses” and “Cell D1” with “Profit”.
5. You now have your table headings ready. You can enter your data in the cells below each heading.

Creating the Bar Chart:

1. Select the Data: Click and drag to select the cells from A1 through D5 (assuming you have data entered till the April row).
2. Insert a Bar Chart:
   • Go to the “Insert” tab in the Excel ribbon.
   • In the “Charts” group, click on the “Column or Bar Chart” icon (it looks like a column/bar chart).
   • A drop-down menu will appear. Choose the first option under “Clustered Bar” or any other bar chart type you prefer.
3. Adjusting the Chart (Optional):
   • Click on the chart. This will reveal three new tabs in the ribbon: “Chart Design,” “Format,” and a third contextual tab related to the type of chart.
   • Use the “Chart Design” tab to quickly adjust the chart’s layout, style, and other elements.
   • Use the “Format” tab to refine the chart’s appearance further.
4. Title & Labels:
   • By default, Excel might add a title, axis labels, and a legend. You can click on these elements to edit them.
   • To add labels or other elements, right-click on the chart and select the desired option from the context menu.
5. Once satisfied with the appearance and data representation of the chart, you can save your Excel sheet.

Solution

See the attached excel file:

https://drive.google.com/drive/folders/1r78T3OnNbjDJoIxOdBOXtmkAGUboqRlT?usp=sharing

© 2023  Vedesh Kungebeharry. All rights reserved.