Канал: Newport High ICT

4 Graphics Lesson 4

4 Graphics Lesson 4

Converting Denary To Binary Numbers

Converting Denary To Binary Numbers

3 Graphics Lesson 3

3 Graphics Lesson 3

2 Graphics Lesson 2

2 Graphics Lesson 2

1 Graphics Lesson 1

1 Graphics Lesson 1

10 Rounding Up Numbers Using =Roundup

10 Rounding Up Numbers Using =Roundup

9 Replacing Blank Values

9 Replacing Blank Values

8 Removing A Number Of Characters Using =Replace

8 Removing A Number Of Characters Using =Replace

7 Forcing Capital Letters Using =Upper

7 Forcing Capital Letters Using =Upper

6 Output A Single Character Form A Text Value Using =Left

6 Output A Single Character Form A Text Value Using =Left

5 Removing Leading And Trailing Spaces Using =Trim

5 Removing Leading And Trailing Spaces Using =Trim

4 Rounding Down Numbers Using =Rounddown

4 Rounding Down Numbers Using =Rounddown

3 Formatting Cells

3 Formatting Cells

2 Removing Duplicate Values

2 Removing Duplicate Values

1 Importing Data

1 Importing Data

Formatting a Data Entry Form

Formatting a Data Entry Form

Creating a Data Entry Form

Creating a Data Entry Form

2 Reset Your Game Maker Password

2 Reset Your Game Maker Password

Create An Account For Game Maker

Create An Account For Game Maker

9 Creating and formatting a report

9 Creating and formatting a report

8 Creating a complex search

8 Creating a complex search

7 Creating a simple search

7 Creating a simple search

6 Adding buttons to your data entry form

6 Adding buttons to your data entry form

Importing Data Into a Database

Importing Data Into a Database

5 Creating a data entry form

5 Creating a data entry form

4 Importing data into the table

4 Importing data into the table

3 Entering Data Into The Table

3 Entering Data Into The Table

Reports - Creating Reports From Queries

Reports - Creating Reports From Queries

2 Creating a Database and Table

2 Creating a Database and Table

Query 2 - Multiple Table Query With Multiple Criteria

Query 2 - Multiple Table Query With Multiple Criteria

Query - Create A Calculation In A Query

Query - Create A Calculation In A Query

Query 3 - Parameter Search

Query 3 - Parameter Search

Query 1 - Single Table Query With Single Criteria

Query 1 - Single Table Query With Single Criteria

9 - Working with text

9 - Working with text

8 - Working with layers

8 - Working with layers

7 - Brightness, colour and effects

7 - Brightness, colour and effects

6 - Pencil, brush, shapes and effects

6 - Pencil, brush, shapes and effects

5 - Send objects to front or back

5 - Send objects to front or back

4 - Removing backgrounds

4 - Removing backgrounds

3 - Distort tool

3 - Distort tool

2 - Duplicate, move, rotate and group objects

2 - Duplicate, move, rotate and group objects

1 - Using the selection tools

1 - Using the selection tools

8 Ticket Sales Pt 2

8 Ticket Sales Pt 2

8 - Ticket Sales Pt 1

8 - Ticket Sales Pt 1

7 - Staff

7 - Staff

6 - Facilities

6 - Facilities

5 - Organising Space

5 - Organising Space

4 - Charts and Graphs

4 - Charts and Graphs

3 - Conditional Formatting on the Choosing your Dinosaurs Sheet

3 - Conditional Formatting on the Choosing your Dinosaurs Sheet

2 - Drop down lists and lookup on the Choosing your Dinosaurs Sheet

2 - Drop down lists and lookup on the Choosing your Dinosaurs Sheet

1 - Formatting Data on the Dino Data Page

1 - Formatting Data on the Dino Data Page

23 - Adding Music and Sound Effects to the Game

23 - Adding Music and Sound Effects to the Game

22 - Creating Music and Sound Effects for the Game

22 - Creating Music and Sound Effects for the Game

21 - Creating a Start Screen and Adding Navigation Buttons to the Game

21 - Creating a Start Screen and Adding Navigation Buttons to the Game

20 - Creating and Using a Win Screen

20 - Creating and Using a Win Screen

19 - Creating an End of Game Boss

19 - Creating an End of Game Boss

18 - Creating and Using a Lose Screen

18 - Creating and Using a Lose Screen

17 - Adding a Backgound Image to a Room

17 - Adding a Backgound Image to a Room

16 - Displaying the Score on all Levels (Persistence of objects)

16 - Displaying the Score on all Levels (Persistence of objects)

15 - Moving Between Levels

15 - Moving Between Levels

14 - Adding Points to the Score When you Shoot an Enemy

14 - Adding Points to the Score When you Shoot an Enemy

13 - Using Parent and Child Objects to Create Multiple Enemies

13 - Using Parent and Child Objects to Create Multiple Enemies

12 - Removing Bullets and Enemies When They Collide

12 - Removing Bullets and Enemies When They Collide

11 - Using a Health Bar Instead of Lives

11 - Using a Health Bar Instead of Lives

10 - Remove a Life When Colliding With an Enemy

10 - Remove a Life When Colliding With an Enemy

22 - Exporting The Game

22 - Exporting The Game

21 - Playing Sounds in the Game

21 - Playing Sounds in the Game

20 - Creating And Importing Sound

20 - Creating And Importing Sound

19 - Game Win Screen And Testing

19 - Game Win Screen And Testing

18 - Game Over Screen And Game Restart

18 - Game Over Screen And Game Restart

17 - Welcome Screen And Starting The Game

17 - Welcome Screen And Starting The Game

16 - Calculating Score And Lives

16 - Calculating Score And Lives

15 - Displaying Score And Lives

15 - Displaying Score And Lives

14 - Parent And Child Objects

14 - Parent And Child Objects

13 - Moving Between Levels

13 - Moving Between Levels

12 - Adding Collectables

12 - Adding Collectables

11 - Collision Masks

11 - Collision Masks

10 - Dealing With Bullet Collisions

10 - Dealing With Bullet Collisions

9 - Shooting Bullets

9 - Shooting Bullets

7 - Enemies With Random Movement

7 - Enemies With Random Movement

8 - Colliding With The Enemy

8 - Colliding With The Enemy

6 - Dealing With Collisions with the Wall

6 - Dealing With Collisions with the Wall

5 - Creating The Maze

5 - Creating The Maze

4 - Character Movement With Keys

4 - Character Movement With Keys

3 - Creating Objects And Rooms

3 - Creating Objects And Rooms

2 - Creating Sprites

2 - Creating Sprites

1 - Introduction To GameMaker

1 - Introduction To GameMaker

20 - Counting on Multiple Criteria Using =COUNTIFS

20 - Counting on Multiple Criteria Using =COUNTIFS

19 - Advanced Pivot Tables

19 - Advanced Pivot Tables

18 - Create a Pivot Table & Chart

18 - Create a Pivot Table & Chart

17 - Using a Filter

17 - Using a Filter

16 - Creating a Column Chart

16 - Creating a Column Chart

15 - Creating a Pie Chart

15 - Creating a Pie Chart

14 - Conditional Formatting

14 - Conditional Formatting

13 - Non Number In Cell Representations

13 - Non Number In Cell Representations

12 - More =COUNTIF (Percentages)

12 - More =COUNTIF (Percentages)

11 - Using Find & Replace

11 - Using Find & Replace

10 Analysing Data With =COUNTIF

10 Analysing Data With =COUNTIF

9 - Find the Target Audience Using =QUARTILE

9 - Find the Target Audience Using =QUARTILE

8 - Find the Most Frequent Number Using =MODE

8 - Find the Most Frequent Number Using =MODE

7 - Calculate the Range Between two Numbers

7 - Calculate the Range Between two Numbers

6 - Find the Smallest Value Using =MIN

6 - Find the Smallest Value Using =MIN

5 - Find the Largest Value Using =MAX

5 - Find the Largest Value Using =MAX

4 - Rounding Numbers With =ROUND

4 - Rounding Numbers With =ROUND

3 - Find the Mean Using =AVERAGE

3 - Find the Mean Using =AVERAGE

2 - Naming Cell Ranges

2 - Naming Cell Ranges

1 - Sorting Data

1 - Sorting Data

11 - Organising And Formatting Cleansed Data

11 - Organising And Formatting Cleansed Data

10 - Check Numbers Using the ISNUMBER Function

10 - Check Numbers Using the ISNUMBER Function

9 - Force Upper Case Using The UPPER Function

9 - Force Upper Case Using The UPPER Function

8 - Remove Text Using the REPLACE Function

8 - Remove Text Using the REPLACE Function

7 - Save Storage Space Using the LEFT Function

7 - Save Storage Space Using the LEFT Function

6 - Removing Leading And Trailing Spaces Using the Trim Function

6 - Removing Leading And Trailing Spaces Using the Trim Function

5 - Using The Find Tool To Identify Spaces

5 - Using The Find Tool To Identify Spaces

4 - Removing Blank Values

4 - Removing Blank Values

3 - Removing Duplicate Values

3 - Removing Duplicate Values

2 - Formatting Data Types

2 - Formatting Data Types

1 - Importing Data Into A Spreadsheet

1 - Importing Data Into A Spreadsheet

05 - Making Enemies Move Automatically

05 - Making Enemies Move Automatically

04 - Stop Objects Moving Through Walls

04 - Stop Objects Moving Through Walls

03 - Moving a Character Using the Keyboard

03 - Moving a Character Using the Keyboard

02 - Creating a Room and Resizing Objects

02 - Creating a Room and Resizing Objects

01 - Sprites and Objects

01 - Sprites and Objects

06 - Creating Bullets

06 - Creating Bullets

07 - Players and Enemies Colliding

07 - Players and Enemies Colliding

08 - Score and Lives Setup

08 - Score and Lives Setup

09 - Adding Points to the Score

09 - Adding Points to the Score