Database Practical Work - For Friday 1st Dec

Copy out notes from Ch 1 in your HB book:
(Can be typed up, printed & stuck in book if preferred)
Pg 6 - 'A Sample Database' : 1st paragraph & bullet points
Pg 7 - 'Table Design': down as far as the table
Pg 8 & 9 - ALL OF 'Elements of an Access Database' AND 'Naming Conventions'

Create a Folder in your 'My Docs' area to keep all this database material.
Work through Chapters 2,3,4 & 6, saving your work!!!
(Don't worry about Task 6.5, drawing a chart if it doesn't seem to work)

You will have a test on Friday during P9 which we will then correct P10.

Introduction to Databases

Data can be stored within a database, the database can be queried to produce information.
This information can be used to make decisions within an organisation.

You will need to:

• understand the role of key fields within the table structure;
• select fields and link at least two tables together on a common field;
• enter data into a database;
• query a database using up to three criteria;
• create and use onscreen and printed reports from within a database and evaluate them interms of purpose and intended audience;
• create and use data capture screens and evaluate their effectiveness in terms of fitness for purpose.

Sorting, Filtering & Subtotalling

Today we will complete the Sorting, Filtering & Subtotalling exercise. (Excel 5 Data Management)

•Task (1) Screenshot each procedure you do and explain how you get the answers to the questions.
•Task (2) We will then produce a graph / chart based on the data.
•Task (3) We will create a suitable report for the NuClean company (Due Friday)

All relevant files in the Datapool:
S:\ICT\GCE APPLIED ICT\AS Modules 1-2-3\Module 2\Using Office Applications\Spreadsheets

Spreadsheet Progress

For Today's class you will log into your Blog (created last week, don't dare tell me you have forgotten your password or username).

1) You will create a new post which outlines what you have learned this week, showing some sample screenshots from the tasks you have completed.
Easiest way to do this is to:
-Take a screenshot
- Paste it into Powerpoint
- Explain / highlight key points using text boxes, arrows etc
- Save the PPT.
- Then 'Save as' and choose 'png' from the filetype drop down box.
- Choose 'Every slide'
- The slides are then saved as images in a subfolder in your area.
- Upload these to your blog (only 5 per post).

HOMEWORK

You should have completed Tasks 1 - 4 for today.
We will start working through 5 & 6 next week, then work through some sample scenario / past paper examples.

You MUST have printed off the worksheets for Tasks 5 & 6.
Copy out the explanations given for Data Management Techniques into your HB book.
Your notes should include explanations and instructions for:

• Filters
• Sorts
• Subtotals
• Advanced Filter
• Pivot table

Next Friday you will have a test on spreadsheets PERIOD 9 in THE STUDY.
We will then correct it during my class, Period 10.

Welcome to the Blogosphere!!!

You have now joined the world of online publishing.
Bear in mind that this blog is ONLY for AS Applied ICT related material, and is an extension of your school work.

All posts and comments you make should be appropriate and respectful of your peers, teachers and the school.

If you want a personal publishing outlet you can create another blog using the same account and use this outside of school time.

Once you have created your own blog, you have to then:

1) Create your first post (blog will not be active until you do)
This should be an amended version of your initial letter to me at the start of the year.
(Check your email / area for a saved version).
You should add in sentences covering how you used the blog facilities appropriately to improve your writing and communication skills, as an online diary of your work in this subject...

2) Leave your blog address as a COMMENT on this post.