Recent Changes

Digging Data
Brief
e-mails advertising specials.specials exclusive to VIPs in the UK.
The software I will use to solve the problem is Microsoft Access. This has the following useful features that will help to get the job done:
- Queries
One report with the records grouped by a particular category
One query that selects certain records for a particular problem
Tables: ............(explain what they do and how they help) .............
Forms: ....Help by keeping one thing's information on one page and another person's on another page so it is easier to get the information that you want.
Reports: .......................They help by grouping whatever you want. Eg. People from the USA are all together if you program it that way as opposed to having them spread all over the place.
Queries: .............They help by having a particular group of people permanently saved to the database without having to use a filter all of the time.
Making the Table
Show a screenshot in design view and show another in datasheet view with some of the records showing.

Digging Data
Brief
My client Miss Maria Smithers who is the owner of Shop Till You Drop needs a database of the customers that have signed up to the VIP club so she can send out e-mails advertising specials.
The software I will use to solve the problem is Microsoft Access. This has the following useful features that will help to get the job done:
- Queries
- Forms
- Filters
- Fields
Your database must have the following
At least 6 fields
At least one look up field ( drop down)
At least 10 records ( you can make the details)
One input form with a title, resized fields and record navigation buttons
One report with the records grouped by a particular category
One query that selects certain records for a particular problem
Tables: ............(explain what they do and how they help) .............
Forms: ....
Reports: .......................
Queries: .............
Making the Table
Show a screenshot in design view and show another in datasheet view with some of the records showing.
The screenshot below shows the table in design view. This is where I set the feild names and data types.
Making the Input Form
Explain what an input form is and why it is useful
Show a screenshot of your input form here.
Making a Query
State the problem your query will solve.
Show a screenshot in design view and show another in datasheet view with the records showing. Explain what the screenshots show
Making a Report
Explain the problem that your report will solve
Show a screen shot of your report - remember it needs to be grouped by a particular category. Link to the file if it too big to fit on the page.
Evaluation
Say why database skills are important. State the advantages of a computerised database over a paper based database (Remember the pictures we discussed in class). Discuss which methods you found best to learn database skills. What improvements could you make to your database in the future?
Peer Checklist
Checked by:
At least 6 fields
At least one look up field ( drop down)
At least 10 records ( you can make the details)
One input form with a title, resized fields and record navigation buttons
One report with the records grouped by a particular category
One query that selects certain records for a particular problem
All sections of report template are completed
Rate myself
Stink Good
0 1 2 3 4 5
understanding
effort
listening
completing tasks
interested

02/8 - Today I worked on my game. Did all the scripts and test play.
03/8 - Today I added final touches to my game.
08/08 - Wrote theDId work on my Wiki.
09/8 - Completed my video for my game and finished uploading everything onto my wiki.

Game Design
Game Idea
ball is touchedtouched, the player
List of Jobs:
FInd sprites and backgrounds.
Final Product
Evaluation
final game. My game was made in an hour, it was basic but covered most of the skills I'd been taught. Everything turned out fine. I enjoyednever encountered any issues while making my final product. It turned out just as I planned it.
_Learning Journal_
18/7 - Discussion about why Bill Gates is so rich. Why is programming so important?

{Sharks.jpg}
The codes for the sharks.
Final Product
Evaluation
In the unit Taking Control I learnt the basic skills of creating my own game including coding. I found the unit easy and fun. The programme I used, Scratch, made everything simple. Finding my way around the programme itself wasn't difficult. Programming the sprites to move around the screen by themselves and with the control of the keyboard was a simple and useful skill. Who has heard of an inanimate game? Touches such as making the sprites bulge and say things added a simple flare. I covereved all of the basic coding skills that we were taught during practice and a few new ones creating my final game. I enjoyed it.
_Learning Journal_
18/7 - Discussion about why Bill Gates is so rich. Why is programming so important?

Programme background.
Research/Practice
basic skills likesuch as sensitivity and sprites move.
I learnt a lot during the practice lessons. I leant how to use Scratch with ease and it truly is simple to use. Scratch has an easy layout I could easily find what I was looking for and how to get things to work. My final product was completed in an hour as a result. I started off doing the basic code for moving the character around and later started adding things such as lives and points, as well as sensing the other characters.
{Whale.jpg}
The codes for the whale. Makes it move around, lose lives, gain points, say things, bulge, etc.
{Sharks.jpg}
The codes for the sharks.
_Learning Journal_
18/7 - Discussion about why Bill Gates is so rich. Why is programming so important?

Programme background.
Research/Practice
I completed the practice tasks Good Guy and Bad Guy, and the Ball and Block game. Both gave me basic skills like sensitivity and making sprites move.
_Learning Journal_
18/7 - Discussion about why Bill Gates is so rich. Why is programming so important?