Inserting rows and Columns, Formatting Cells and Formula Revision

January 21, 2021 vkunge1 Comment

Instructions

Practise the skills shown in the video above using this tutorial file : tu torial03

If you don’t have the file you can simply copy and paste the table below into excel and follow along:

Student Name	Math	English	Science	Art	Total Marks	Average	Pass?	Rank	Grade	Comment
Bob Williams	14	88	99	65
Robin Hood	22	22	40	85
Kern Williams	76	97	77	76
David Ken	14	50	12	65
Len Brooke	65	17	77	44
Ava Thor	76	65	55	88
Maximum
Minimum Value

Summary
Pass Mark	50
No. Students
No. Passed

Grades
Grade Range	Grade	Comment
0	F	Must work harder
50	C	Keep Trying
60	B	Good
80	A	Excellent

Creating and managing Passwords online.

January 20, 2021January 20, 2021 vkungeLeave a comment

For all of your online accounts,

Use Strong Passwords. a strong password is long and difficult to guess
- Use long passwords , at least 8 characters long
- Use a combination of capital and common letters
- Use numbers
- Use special characters.
- E.g “P@ssw0rD”
Change your passwords frequently
- Change your password at least once per year
- Change your password if you suspect that someone has accessed your online account.
- Change your password if someone’s behavior appears that they intend to access your online account.
Do not use the same password for any two online accounts.

Choose complex but memorable passwords. Although your passwords can be complex, ensure that the password is memorable to you. e.g ” F@c3b00k_Tr!p_T0_Th3_M00n “. This password example can be thought of as “Facebook trip to the moon” but you replaced

letter a with @,
letter o with 0 (zero) ,
letter i with !
letter e with 3
spaces with _ (underscore) and
the first letter of each word is capitalized, all others were either lower case or symbols.

Once you choose a memorable phrase and you settle on your symbol replacements, you’ll be good to go with creating a strong and manageable passwords!

Catch by Coordinate – Scratch Game Assignment

January 20, 2021May 8, 2026 vkungeLeave a comment

The following task was discussed in class today:

Task : Create a game where a sprite moves around a few times to a random position and asks the player (user) to guess his x and y coordinates. If both the x and y coordinates entered by the player are within 10 units of the sprites location, say a message which indicates success, otherwise, say that the player missed and tell the player to try again.

A sample of blocks below shows how to move the sprite around:

Hint

A previously recorded class shows how guessing can be improved to include a range.

https://islandclass.org/2026/05/08/how-to-tolerate-a-guess-withing-a-certain-range-using-the-abs-function-3n-2026-05-08_10-03-41/

Updates to this post

2026-05-08: Added hint section

Introduction to Scratch Programming

January 13, 2021January 13, 2021 vkungeLeave a comment

See the live capture from class on Wednesday 13th January 2021:

Introduction to typing (Live class)

January 13, 2021September 17, 2022 vkungeLeave a comment

In this class , we use the online web application provided by http://typingclub.com . Visit the website and create an account and attempt the first 20 lessons under the typing jungle lesson plan

See the video capture from class today on Wednesday 13th January 2021:

https://youtu.be/Xw_fF7ef_mI

Making a Sprite Jump In Scratch

January 13, 2021October 24, 2025 vkunge1 Comment

See the following video (Notes after VIdeo):

Blocks used in this project

See the project below and observe the blocks that were used:

https://scratch.mit.edu/projects/473323685

Selection Statements: Practise Exercise(s)

November 10, 2020November 20, 2020 vkungeLeave a comment

For these flowchart solutions, you may opt to:

Draw the solution in your notebook OR
Draw the solution in a word processing document OR
Draw the solution in an online tool OR
Create a solution using flowgorithm.

Exercise 1

Create a flowchart solution which prompts the user to enter a student’s math mark and outputs “You have passed” if the mark is 50 and/or greater or “You have failed” if the mark is less than 50.

Exercise 2

Create a flowchart solution which prompts the user to enter two numbers, A and B, and outputs the larger number.

Hyperlinks

November 4, 2020November 4, 2020 vkunge1 Comment

Definition: A hyperlink is actionable text or an object found in a hyper text document which navigates the user to the start of another hypertext document or a specific location within a hypertext document. An action could be from a gui : a click or a tap; or using the keyboard to press the “enter key” on a selected link.

Examples:

This is a hyperlink to wikipedia.org

This is a hyperlink to wikipedia.org opened in a new tab or browser.

This is a link to ……..