Grade 9

Learning to Program with Scratch

• Learning to program with Scratch: worksheet 1

• Learning to program with Scratch: worksheet 2

• Learning to program with Scratch: worksheet 3

Hosting your website on Github using Publii

Hosting your website on Github using Publii

Finish off your website with a homepage and a menu

Big Project for Gr 9

Plan an event of your choice that includes a list of attendees

(e.g. school trip, charity event, 

Excel Spreadsheet

Use a spreadsheet to store the names and any other important information (e.g. vegetarian, contact details, address etc)

Use at least three of the following Excel functions in your spreadsheet to determine important information (e.g. total number of attendees, amount of vegetarian meals, total cost of ticket etc)

• sum

• average

• count (counta, countblank, countif)

• max/min

Use multiple tabs in your spreadsheet that also include budgets for the event that calculates the total profit/costs/expenses.

You should consider all expenses like venue hire cost, entertainment cost, food/drink cost, etc

Word Document + Mail Merge

Create a neatly formatted invitation or information document that uses Mail Merge to generate a letter for each attendee containing important information and their names/details.

PowerPoint Presentation

Create a presentation that gives a complete overview of the event to management of your events company. 

Include:

• Details of the event

• The budget

• A summary of the attendees numbers etc.

• A sample advert for the event

List of fictional names and details

Mail Merge

• May Dance Booking Form

• Booking Spreadsheet

• Mail Merge instructions

Structured Query Language

• Learn to write Structured Query Language, TopSellingArtistsDB - What is a database (youtube video), What is the cloud (youtube video)

Advanced HTML

• Advanced HTML 1

• Advanced HTML 2

• Advanced HTML 3

• Make a complete promotional one page website using HTML

Making a mobile application using a no code platform

• Complete tutorial here.

Disk Defragmentation, Excel Conditional Formatting, RandBetween

• Examine the HDDs at the front of the class

• What the following videos on HDD and Disk Defragmentation

• Follow the two videos on Excel Macros: Part 1, Part 2

• Make an Excel 8-bit landscape pic and use Macro buttons to change the seasons of the landscape. Art examples.

The Internet and the World Wide Web

• Binary Code - Adafruit video. Binary Bonanza Game, Binary Puzzle, Binary Code in Excel

• What is the internet: video. Internet cables: video. What is a distributed network?

• The physical infrastructure of the internet: submarine cables, internet satellites, ltt submarine cable video, shark, 

• Internet vs WWW

• Digital Footprint. When we browse we automatically create metadata

• Web crawlers, how the internet is indexed

• Indexed web, deep web and the dark web

• Content control, access, and net neutrality

• Interesting links: https://louisedrulhe.fr/internet-atlas/

The Cloud

• tbc

Networks

• tbc

AI

• thispersondoesnotexist.com - training set

• deep.ai, hotpot.ai etc. - Create your own images/album art/ai portrait

• Watch these videos on AI: https://youtu.be/SVcsDDABEkM (stop this one early), https://youtu.be/0gNauGdOkro 

• Emotions training set (from Kaggle.com). Use the training set on Teachable Machine

• Make a PowerPoint that uses the following as points for each slide:

1.   Explain how Generative AI is able to make new images, music and other content.

2.   Research and give examples of any recent court cases against AI using artist/performer’s content as a source for creating new content. 

       Or research the Actors/Writers strike in Hollywood.

3.   How can AI help you in your academic life?

4.   How could AI hinder you in your academic life?

5.   How could AI help the world?

6.   How could AI hinder the world?

7.   Do you think AI should be allowed in school and for studies? Justify your answer.

8.   Create a set of rules that you think are useful when using AI.

Compression

• Download these files: text_document, image_document

• Download and compare these two images: Kingfisher, Kingfisher

  • Discuss image resolution, pixels, aspect ratios, screen resolutions, bandwidth, bits/bytes/mb/kb/gb

  • Use gimp to compress a jpg and compare the different file size.

• Learn about zipping and unzipping files in Windows. Compare the file sizes.

• Watch video on compression.

  • Crash Course on Compression

  • How does jpeg compression work

  • How does video compression work

  • MKBHD video compression

  • Huffman coding

  • Different sound quality comparison

Godot Game Development (Asteroids game)

• Godot Game Development (Asteroids Game)

• Asteroids project setup

Animation with Blender

• Blender Doughnut Tutorial Playlist

• Blender Sound Animation

Photo editing/manipulation with GIMP

Use one of the following video tutorials to make a cool image or find your own GIMP tutorial.

• Make an image of yourself floating mysteriously

• Create a tiny planet (Miami photo used in tutorial, Merrifield campus shot alternative)

• Put yourself on a Magazine Cover

• Put yourself on an Album Cover

• There are many other tutorials on daviesmediadesign.com and elsewhere.

Game Development with the Godot Game Engine

• Part 1 - User Interface

• Part 2 - Code - Final Code for Part 2

• Part 3 - Visual and Sound Effects

Game Development with the Defold Game Engine

• Star Collector worksheet 1

Netbeans GUI

NumberGuess Game

A few short fun activities

Photographer Booking

Random Destination

Excel

Learning to use a spreadsheet 1

Learning to use a spreadsheet 2

Learning to use a spreadsheet 3, fruit spreadsheet

Make a Love Calculator in Excel

Myers-Briggs Personality Test

Excel Functions

Statistics

MineCraft Education

1. Open MCEducation

2. Sign in using your school account

3. Play

4. View Library

5. Subject Kits

6. Computer Science

7. Block-Based Coding

8. Coding Fundamentals - Keyboard

9. Coding Fundamentals: 1

10. Lesson 1: Basic Moves

11. Create World

Learning to code in Java

• Learning to program with Java: worksheet 1

• Learning to program with Java: worksheet 2

• Learning to program with Java: worksheet 3

• Learning to program with Java: worksheet 4

Please complete this feedback form once you completed the programming course.

Learning to code SQL with Access

• SQL Lesson 1

• Learn to use an Access Database 1 (Download TopSellingArtists.csv here)

• Learn to use an Access Database 2

• Learn to use an Access Database 3

Digital ePortfolio

• ePortfolio

Word Processing Skills

• Learning to use a word processor - Newspaper article

• Formatting a large document with styles, page numbers and a table of contents