|
|
|
|
|
| |
Pre Task Preparation - What information? Task 1A - Creating and Naming Folders.
Students should Create Print Screens of their Folders and Print them. The Print Screen should then be put in their portfolios under (Task 9A - Part 1)
|
Merit - Print Screen Evidence to Show atleast Two Subfolders to Organise your Work have been Created. The Print Screen should then be put in their portfolios under (Task 9B - Part 1) |
|
|
| |
|
|
|
|
| |
Task 2A - Use Internet Search Engines Task 2B - Provide Web Addresses Used |
Task 2C - Locate Suitable Text and Images on Local Media Task 2D - Use Effective/Advanced Search Criteria |
|
|
| |
|
|
|
|
| |
Printing Task Two and Organising Evidence into Portfolios |
Task 2E - Comment on the Trustworthiness/ Validity / Date of Your Sources Task 2F - Use Bookmarks/Favourites to Store/Organise Useful Links into Folders Task 2G - Obtain Copyright Free Text and Graphics for a Newsletter |
|
Teacher Assessments for Task 2 Begin |
| |
|
|
|
|
| |
Task 3A - Save and Store an Email attachment Task 3B - Create and Send a Reply to an Email Task 3C - Forward an Email |
Task 3D - Use an Address Book to Store Email Addresses Task 3E - Create an Email Signature Task 3F - Compose a New Email |
|
|
| |
|
|
|
|
| |
Completing Task Three - Printing Task Three and Organising Evidence into Portfolios |
|
Completing and providing evidence for Task Three
Checklist
|
Teacher Assessments for Task 2 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
Completing Task Three - Printing Task Three and Organising Evidence into Portfolios |
|
Completing and providing evidence for Task Three
Checklist
|
Teacher Assessments for Task 3 Begin |
| |
HALF TERM |
| |
| |
Spreadsheet Skills Exercise |
|
|
|
| |
|
|
|
|
| |
Task 4A - Enter Data Into a Spreadsheet Accurately and Format the Presentation of the Data |
|
To complete Task 4A do the following:
***Copy the spreadsheet from the Assignment into Excel
***Merge and Centre the title and enlarge the text
***Bold the headings
***Proof read all the information to ensure their are no errors
Screen print the spreadsheet and put it in the workbook under section 4A.
|
Teacher Assessments for Task 3 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
Task 4B - Format Cells Task 4C - Use Formulas and Functions |
|
Put the screen print of your spreadsheet with numbers and text formatted under section 4B of your workbook.
Put the screen print of your spreadsheet showing the formula and functions used under section 4C of your work book..
|
|
| |
|
|
|
|
| |
Task 4D - Print out Spreadsheet in Full Task 4E- Printout Spreadsheet with Formulae in Full |
|
Printing the Spreadsheet
Displaying Formulas
Print out the spreadsheet in full showing all the figures. Stick this in your work book under Section 4D.
Print out the spreadsheet in full showing all the formulas and functions. Stick this in your work book under Section 4E.
|
|
| |
|
|
|
|
| |
Task 4F - Edit a Spreadsheet Entry Task 4G - Reprint the Spreadsheet Task 4H - Password Protect a Spreadsheet |
Task 4I - Add a New Entry Task 4J - Delete a Row Task 4K - Calculating Income and Expenditure |
Put the screen print of your spreadsheet with record 1001 edited under section 4F of your workbook.
Print out the spreadsheet in full showing changes made and the effects of this on the totals. Stick this in your work book under Section 4G.
Put the screen print of your spreadsheet with password protection under section 4H of your workbook.
Password Protect a Spreadsheet
|
|
| |
|
|
|
|
| |
Completing Task Four - Printing Task Four and Organising Evidence into Portfolios |
Task 4L - Calculating Averages Task 4M - Use Headers and Footers Task 4N - Print Out Spreadsheet in Correct Orientation Task 4O - Print Spreadsheet Showing Formula in Full |
Put the screen print of your spreadsheet showing the average income over four months under section 4L of your workbook.
Put the screen print of your spreadsheet showing the use of headers and footers under section 4M of your workbook.
Headers and Footers
Print out the spreadsheet in full showing all the figures in the correct orienation and with the correct number of pages. Stick this in your work book under Section 4N.
Print out the spreadsheet in full showing all the formulas and functions in the correct orienation and with the correct number of pages. Stick this in your work book under Section 4O.
|
|
| |
|
|
|
|
| |
Completing Task Four - Printing Task Four and Organising Evidence into Portfolios |
|
|
Teacher Assessments for Task 4 Begin |
| |
|
|
|
|
| |
Database Skills Exercise |
|
|
|
| |
Christmas Holiday |
| |
| |
Database Skills Exercise |
|
Finish the practice session. Then move onto the real database task in the assignment. |
|
| |
|
|
|
|
| |
Task 5A - Delete, Amend and Query a Database |
Task 5B - Boolean Query and Sort Task 5C - Report Based on a Query Task 5D - Advanced Report |
|
Teacher Assessments for Task 4 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
Task 5A - Delete, Amend and Query a Database |
Task 5B - Boolean Query and Sort Task 5C - Report Based on a Query Task 5D - Advanced Report |
Complete the tasks in the Assignment. The workbook will advise what evidence you need for each task.
|
|
| |
|
|
|
|
| |
Produce Evidence of Database Tasks in the Form of Screen Shots - Organise and Put in Portfolio |
|
|
|
| |
|
|
|
|
| |
Produce Evidence of Database Tasks in the Form of Screen Shots - Organise and Put in Portfolio |
|
|
Teacher Assessments for Task 5 Begin |
| |
|
|
|
|
| |
Task 6A - Create a Business Letter and Memo Task 6B - Format Documents Task 6C - Spelling and Grammar Check |
|
|
|
| |
HALF TERM |
| |
Task 6A - Create a Business Letter and Memo Task 6B - Format Documents Task 6C - Spelling and Grammar Check |
Task 6D - Consistent House Style Task 6E - Produce a Flyer Task 6F - Proofread and Amend Flyer Task 6G - Mail merge |
|
|
| |
|
|
|
|
| |
Task 6A - Create a Business Letter and Memo Task 6B - Format Documents Task 6C - Spelling and Grammar Check Print Task Six and Organise Evidence into Portfolios |
|
|
Teacher Assessments for Task 5 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
SCHOOL CLOSED - GOOD FRIDAY |
|
|
|
| |
|
|
|
|
| |
Print Task Six and Organise Evidence into Portfolios |
|
|
Teacher Assessments for Task 6 Begin |
| |
|
|
|
|
| |
Task 7A - Create a Newsletter |
|
|
|
| |
|
|
|
|
| |
TRAINING DAY |
|
|
|
| |
EASTER |
| |
| |
Task 7B - Format Newsletter Task 7C - Spell check and Grammar Check Newsletter |
Task 7D - Consistent House Style Task 7E - Using Fields Task 7F - Proofread Newsletter |
|
Teacher Assessments for Task 6 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
Print Task Seven and Organise Evidence into Portfolios |
|
|
Teacher Assessments for Task 7 Begin |
| |
|
|
|
|
| |
Task 8A - Create an Electronic Slide Presentation (3 Slides) |
Merit - Task 8B - 4 Slides with Transitions Distinction - Task 8C - 5 Slides with Speaker Notes and Animations |
|
|
| |
|
|
|
|
| |
Task 8A - Create an Electronic Slide Presentation (3 Slides) |
|
|
|
| |
|
|
|
|
| |
Task 8A - Create an Electronic Slide Presentation (3 Slides) |
|
|
Teacher Assessments for Task 7 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
WHITSUN |
| |
Print Task Eight and Organise Evidence into Portfolios |
|
|
Teacher Assessments for Task 8 Begin |
| |
|
|
|
|
| |
Print Screen your Folder Structure Showing all your Files Stored in the Correct Places. Print this out and put in your Portfolio (Task 9A Part 2) Print Screen an example of your File Names. Print this out and put in your Portfolio (Task 9A Part 3) |
|
|
|
| |
|
|
|
|
| |
TRAINING DAY |
|
|
|
| |
|
|
|
|
| |
Create Print Screen Showing how to Locate and Open an Existing File From Your Work. Print this and organise it into your portfolio (Task 9A - Part 4) Create Print Screen Showing how to Create a Shortcut to Open a File and a Folder From Your Work. Print this and organise it into your portfolio (Task 9A - Part 5) |
Merit - Create Print Screen Showing how to Locate and Open Files From a Range of Sources . Print Screen and Print this for Evididence. Put this evidence in the portfolio ( Task 9B - Part 2) Create Shortcuts to a Directory, Program and File. Print Screen and Print this for Evididence. Put this evidence in the portfolio ( Task 9B - Part 3) Distinction Locate and open Files using an Operating System Search. Print Screen and Print this for Evididence. Put this evidence in the portfolio ( Task 9C - Part 1) Edit and Delete Shortcuts to One Program, Directory and File. Print Screen and Print this for Evididence. Put this evidence in the portfolio ( Task 9C - Part 2) |
|
Teacher Assessments for Task 8 Complete and data entered on spreadsheet. Students given feedback sheet with comments for improvement. |
| |
|
|
|
|
| |
Create Print Screen Showing how you Password Protected a File ( Database). Print this and organise it into your portfolio (Task 9A - Part 6) Create Print Screen Showing how you Backed Up your File and Folders to a Memory Stick. Print this and organise it into your portfolio (Task 9A - Part 7) |
Merit - Create Print Screen Showing how you Restored a Back Up of your File and Folders from a Memory Stick. Print this and organise it into your portfolio (Task 9B - Part 4). Create Print Screen Showing how you Deleted, Copied and Moved Files and Folders. Print this and organise it into your portfolio (Task 9B - Part 5) |
|
|
| |
|
|
|
|
| |
Finalising Projects - Hand in Portfolios |
|
|
Teacher Assessments of Task 9 and Overall Project Begin |
| |
|
|
|
|
| |
Spill Over Time |
|
|
Teacher Assessments of Task 9 and Overall Project Complete and Final Marks in Spreadsheet |
|
|
|
|
|
