Last Week before the exams !!!

*** Your Christmas exam will be in IT1 on Mon 18th Dec, between 11 - 12:30. ***

You SHOULD have completed the Jun 05 Past Paper exercises and marked them against the mark scheme yourself.

This week you must concentrate on completing the Jun 06 Past Paper, and also mark it yourself.

You should make the most of your time in the IT suite this week. I expect to see you coming in during your study periods.

>>> THIS TIME NEXT WEEK YOU WILL BE DOING THE EXAM <<<

Christmas Exam Preparation

Gentlemen,

I have already informed you that your Christmas exam will be one of two papers.
For the next 2 weeks, we will work through each of these papers, practising the skills involved.

Today you will all read through and attempt to complete the Summer 2005 exam paper:

S:\ICT\GCE APPLIED ICT\AS Modules 1-2-3\Module 2\Christmas Exam Prep\May 05 RS\Exam

1) Copy the 'May 05 RS' folder to your own area.
2) Create a folder called 'Practice' in the same folder along with 'Data Files' and 'Exam'.
3) Create a document template. Store this in the 'Practice' folder you just created.
This will be the template you use to store your screenshots / evidence.
It should contain the following in either a header :

• Candidate number (if you know it) & your Name
• Centre Number (71865)
• Question Number e.g. Task DB1, DB2 etc
• An empty box for writing in the 'Label'.

Footer:

• 'Page of Page' e.g. "1 of 3"
• Y13 AS Applied ICT - Christmas Exam 2006 Practice

In this template I would also have the following:

• At least one arrow created from Autoshapes. (to identify the key point of evidence)
• An empty Text Box (to label the key point of evidence)
• An empty circle (to highlight the key point).

Having this set up correctly should help you organise your work.

4) Start working through the exam, pasting screenshots into individual documents based on your template. Save each document as instructed.

Dont bother printing until you have completed all of the tasks.

You *** MUST *** work at this independently during your own study periods.

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.