CA Activity 1 - Database

BA2 identify the key requirements for the third section of the Controlled Assessment by adding, searching and reporting on a Database
The artist database stores information about artists who might be available to perform at your festival.
You will need to add some artists of your own choice to the database.

You will need to select the artists from the database that suit the preferred music genres of your target audience.

TASK 1:

Find details for between three and five more artists and add them to the database. These artists can be people that you know.

TASK2:

You must create a list of the artists you require for the festival. Festivals UK’s booking agent will use this list to try to book them.

The list of artists must:

• include between five and ten artists that suit your target audience
• be grouped or sorted so that it is easy for the booking agent to use
• include the logo and strapline for your festival
• include a sensible title and column headings
• include relevant fields so that the agent can discuss the booking
• be easy to read on screen, avoiding unnecessary scrolling or extra pages.

To export your logo ready for your report you need to go to File > Export and select PNG and 32 Bit Depth if you want it transparent

Exporting from DrawPlus as a PNG

TASK 3:

Make sure that your Sources Table has all of the artist added to it that you added to your database

TASK 4: Screenshots you must have in your review (you may end up having more):

Complete your Review document for the Datbase section

1. 5 new entries to the database
2. First (basic) search/query
3. Results of first query
4. Adapted second (advanced) query (2 or more criteria)
5. Results of second query
6. Sort query results
7. How you did it
8. Report of the query

TB2L8 Can You See What it is Yet?

BA2 breakdown the components of a movie clip by producing a full storyboard

STARTER:

Storyboards allow you to visualise and fine-tune key frames in a shoot before filming or editing.

Why? - Think, Pair, Share...

TASK:

So what kind of Digital Products do you think would benefit from a design document such as a Timeline Storyboard?

Using the resource: O:\ICT\GCSE ICT Unit 3\TB2 B\Timeline StoryBoard develop a storyboard for a 5 minute movie of your choice.

Rules:

1. The theme of the movie can be your choice (action/adventure/sports/rom com etc)
2. It can be an original idea or a film you have seen
3. You can develop a 'whole movie' or just the trailer for it, but it must have a coherent storyline
4. It should last between 4 and 5 minutes
5. Your designs should be hand drawn
6. You need to list the time that the scene lasts (and the overall movie time) as well as briefly describing any audio, special effects and scene transition that happens

An example of a hand drawn storyboard

This video may help you!!!

There is a selection of trailers for you to follow, if you need help, in: O:\ICT\GCSE ICT Unit 3\TB2 B\Trailers

PLENARY:

Where else have you seen storyboards in use? Discuss in pairs, be prepared to feedback!

HWK:

ShowMyHomework