Catch by Coordinate – Scratch Game Assignment

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:

© 2021  Vedesh Kungebeharry. All rights reserved. 

Modifying An Existing Database, Understanding Cascade Delete (adding Fields, Relationships, Updating Forms)

In this video, we aim to understand the structure of our database and add relevant fields to better keep track of enrollments and registrations.

We also examine relationships and how they become useful to us; in this case, performing a cascade delete.

Homework:

Add data to your database to represent at least 25 students and 15 subjects. Ensure that all students are at least enrolled in 6 subjects.

© 2021  Vedesh Kungebeharry. All rights reserved. 

Importing Data From Excel into An access Database.

Follow along with the video using the provided files and tutorial.

The steps in the video can be found in the tutorial and files below:

Files

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

Tutorial

In this tutorial , we wish to import the following data from RegionData.xlsx:

RegionPopulation Size
Couva–Tabaquite–Talparo178,410
Diego Martin102,957
Mayaro–Rio Claro35,650
Penal–Debe89,392
Princes Town102,375
San Juan–Laventille157,258
Sangre Grande75,766
Siparia86,949
Tunapuna–Piarco215,119

NOTE: If you don’t have the provided excel file, you can always copy and paste the table above into a new excel document, save it, and use it for this tutorial.

  1. Add a new table named Region. The design View Is shown Below:

Close the table after creation.

2. “RegionData.xlsx” contains data formatted to match the region and population size of our Region table. The column names are the same in both tables. Start the process to Import the data from “RegionData.xlsx”:


a) Select the  “External Data” tab

b) Choose “New Data Source”

c) Hover over “From File”

d) Choose Excel

3. Use the wizard:

a) Browse to and select “RegionData.xlsx”

b) Choose “Append a copy…”

c) Select the region table from the dropdown

4. Choose Next:

5. Choose Finish


6. Choose Close:

7. Done! Open your table to verify that the data was imported:

© 2021  Vedesh Kungebeharry. All rights reserved. 

Internal Assessment Discussion – Unit 1

This video is a live capture from today’s class (Monday 18th January 2021).

In this video:

  • We discuss a template for your IA
  • View A past Naparima College Sample
  • View A past Sample from a past student
  • View An Online sample
  • Observe code for a Mini IA
  • Discuss our First IA Deadline

© 2021  Vedesh Kungebeharry. All rights reserved.