1	"Y9 ICT Jan-July 2008" Y9 ICT Jan-July 2008 By completing this unit you will develop the ability to create files in different software packages, including word processing, DTP, spreadsheet, database and presentation software. You will communicate effectively using email and search the internet efficiently for information. If you complete both OCR units in Year 10 you will achieve a qualification which is equivalent to one GCSE grade this can prove your ICT skills when applying for places at Sixth Form/FE colleges in Year 11. All the tasks for this assignment are included on the following pages, work through the tasks in a logical order making sure you provide enough evidence at the end of each task, to meet your target grade.
2	"‘Downloadable Tunes’" ‘Downloadable Tunes’ You have been employed to assist with the expansion of a 'downloadable tunes’ internet business and will complete a variety of ICT tasks to promote the business. The company web site already includes numerous singles and albums which can be purchased online so that customers can download the tunes they require. The company was previously run by one person from their home - it started as a hobby but has taken off. The website was created and customers have been accessing the site, ordering the tunes online and then after making a payment they are able to download the tracks in a format to suit them. The business owner has been recording all details by hand but it is becoming apparent that if the business is to survive it needs to: 1. Record business transactions in a spreadsheet 2. Record customer details in a database 3. Produce professional documentation that can be used to promote the business, including a newsletter Finally you will produce an electronic slide presentation about the company. Downloadable Tunes are based at: Downloadable Tunes, 478 London Road, Appleton Warrington, WA4 3QW, Tel: 01925 263421
3	"File Management" File Management A You will need to carry out the following file management tasks 1. Create and name at least two new folders to store the files which you will create for this project. 2. Store all the files created within the filing structure. 3. Use suitable filenames. 4. Locate and open existing files. 5. Create shortcut(s) to at least one folder and file. 6. Password protect at least one file. 7. Backup files you have created by copying them to another location. B To achieve a Merit or Distinction you will also need to show evidence of: 1. Creating at last two subfolders to help you organise your work. 2. Locating and opening files from a range of sources. 3. Creating shortcut(s) to at least one directory, program and file. 4. Backing up and restoring files from a removable medium. 5. Deleting, copying and moving files and folders. C To achieve a Distinction you will also need to show evidence of: 1. Locating and opening existing files using operating system search facilities. 2. Creating, editing and deleting shortcuts to at least one program, directory and file.
4	Task 2 (AO2) Select and use tools and facilities to download files/information You will need to use search engines to find out about recent music releases. You will need to provide evidence of the search criteria you have used. A Use internet search engines to search for and collect information about different singles and albums which will be sold on the internet and be advertised in your newsletter (task 7). B Provide the website addresses you have used. To achieve the higher grades you will also need to: C Locate suitable text and images on local media eg CD-ROM. D Use effective/advanced search criteria eg keywords, quotes, Boolean operators. E Comment on the trustworthiness/validity/date of your sources. F Use bookmarks/favourites to store/organise your useful links into folders. G Obtain a number of copyright free text and graphic(s) which can be used in the newsletter. The text/graphics obtained must be "legal, decent and honest". Provide screenshots and an explanation to show how the text/graphics comply with legislation.
5	Task 3 (AO2) Send and receive email messages When sending messages you must ensure that appropriate subject headings and message text are used. A The owner of Downloadable Tunes has sent you an email with an attachment. Save the attachment to a suitable folder in your work area. B Reply to the owner's email attaching at least one of the graphics that you collected in task 2 and comment on the risks of receiving/opening email attachments in your reply. C Forward the email from the owner to at least two work colleagues. To achieve the higher grades you will also need to: D Use an address book to store at least two email addresses. E Create an email signature for all outgoing messages. F Compose a new email to the owner of Downloadable Tunes: 1. Use your address book to cc the message to one of your new contacts 2. Use your address book to bcc the message to the other new contact 3. Set the priority of the message (high OR low) 4. Your email message should suggest actions that could be taken to reduce the risks involved in receiving/opening email attachments
6	Task 4 (AO5) Create a simple business spreadsheet In this task you will create a business spreadsheet for Downloadable Tunes which will allow you to track income and expenditure, so that the company accounts can be produced at the end of each financial year. The attached document shows the recent income/expenditure. A Create a spreadsheet based on the figures provided, to calculate the income and expenditure. The spreadsheet should include appropriate titles and row and column headings. Ensure that you enter text and numeric data accurately. B Format the cells in your spreadsheet appropriately. Consider: 1. Number format (decimal places, percentage, currency, date/time) 2. Text formatting (font, size, style, alignment) 3. Borders and shading C Use appropriate formulae/functions to calculate the income/expenditure for the business to date. D Print your spreadsheet in full showing all the figures. E Print your spreadsheet showing the formulae in full OR annotate your spreadsheet printout to show the formulae used.
7	Task 4 cont … (AO5) F The owner has noticed that order number 1001 has been entered incorrectly. The amount of £15 should be £18 and the VAT should be £3.15. Change this entry. G Reprint the spreadsheet highlighting the changes you have made and how this has affected the totals. H The owner has requested a password be applied to your electronic workbook. Produce a screenshot showing that the password has been set up. To achieve the higher grades you will also need to: I Order 1014 has now been paid and needs to be entered in an appropriate place in the spreadsheet. Order No: 1014, Date received: 28-Jul, Amount: 16, VAT: 2.8 J Order 1006 has been returned by a dissatisfied customer. Delete the entire row for this order from the spreadsheet. K Calculate the income/expenditure for each of the four months for Downloadable Tunes. You will need to display this data by adding new rows/columns to your spreadsheet as appropriate.
8	"To achieve the higher grades..." To achieve the higher grades you will also need to: L Use the average function to calculate the average income over four months. M Use appropriate headers and footers. N Print out the spreadsheet using appropriate orientation and number of pages. You will also need to select the most appropriate print options (eg fit to page, print area, gridlines, page order). O Print out the spreadsheet showing the formulae in full. You have now completed task 4 - you may move onto task 5.
9	"Use a business database" Use a business database The owner of Downloadable Tunes has created an electronic database to record customer details. The database will be used to efficiently store and maintain customer details and to target advertising to specific customer groups. You have been provided with an electronic version of the database. You will need to use it to compete this task: A Open the database and carry out the following tasks: 1. A new order has been received, enter the following customer details into the database; Mr J Lofthouse, 980 Buxton Road, Appleton, Warrington WA4 2TT, Age:17 2. Mr D Tate has asked to be removed from the database. Delete this record. 3. Miss R Green has recently married and is now Mrs R Hill. Amend this record. 4. Create one query showing all the customers that live in Warrington. To achieve the higher grades you will also need to: B Create a query showing all the customers that live in Northwich and who are aged between 16 and 25. Sort this query on the Age field (ascending or descending order). C Create a report using the query for customers living in Northwich and who are aged between 16 and 25. D Create a new report using the query for customers living in Warrington. This report must be in the form of address labels.
10	"Create a variety of business..." Create a variety of business documents The owner has asked you to create a number of business documents for Downloadable Tunes. A Create the following: 1. Business letter - this should explain that Downloadable Tunes will be running a 'buy one get one free' offer throughout the month. 2. Memo - this should advise the owner that the changes requested to the spreadsheet and database have been completed. You may use a standard template. B Apply suitable formatting to your documents eg font style, size and paragraph justification. C Check the documents thoroughly using spelling and grammar checkers.
11	"To achieve the higher grades..." To achieve the higher grades you will also need to: D Ensure that you use a consistent house style in the production of all your business documents E Create a flyer which will be sent out with the business letter to all customers. The flyer will promote the 'buy one get one free' offer and may include information you retrieved in task 2. F Proofread your flyer, business letter and memo and make any necessary changes to ensure they are error free and look professional. G Using the business letter you have created and the customer details in the database from task 5 create a mail merge master document (Distinction ONLY). You have now completed task 6 - you may move onto task 7.
12	"Create a newsletter" Create a newsletter The owner of Downloadable Tunes has asked you to produce a newsletter to be sent out to all customers, promoting the company. You may wish to include information from tasks 2, 4, 5 and 6. A Create a newsletter (of at least 4 pages) which includes: 1. Text - this could be the company history, special offers, music reviews 2. Images/graphics (choose at least two of the following): - scanned images of staff at Downloadable Tunes - digital camera images of staff at Downloadable Tunes - a logo using a graphics package - images from clipart - images from the World Wide Web - graphs - this could be information on the different customer groups eg age, towns B Apply suitable formatting to your document eg font style, size and paragraph justification. C Check the document using a spelling/grammar checker.
13	"To achieve the higher grades..." To achieve the higher grades you will also need to: D Ensure that you use a housestyle consistent with the other business documents that you produced in task 6. E Insert fields, including date and document information. F Proofread your newsletter and make any necessary changes to ensure it is error free and looks professional. You have now completed task 7 - you may move onto task 8.
14	"Create a presentation" Create a presentation A Create an electronic slide presentation of at least three slides which will support you giving a talk to a new colleague about the 'Downloadable Tunes' business. 1. You may use any of the information from tasks 2, 3, 4, 5, 6 and 7 in your presentation. You must include both text and graphics. 2. Check the presentation using spelling and grammar checkers. To achieve the higher grades you will also need to: Merit ONLY B Produce a presentation of at least 4 slides. You need to add slide transitions and printout presentation in handout form. Distinction ONLY C Produce a presentation of at least 5 slides ensuring a consistent style. You need to apply slide transitions and animations. Speaker notes need to be added to at least one slide and you will include printouts as handouts and notes pages.
15	"Evidence of file management" Evidence of file management A You will need to show evidence of: 1. Creating and naming at least two new folders to store files which you have created for this project. 2. Storing all the files created within the filing structure. 3. Using suitable filenames. 4. Locating and opening existing files. 5. Creating shortcut(s) to at least one folder and file. 6. Password protecting at least one file. 7. Backing-up files you have created by copying them to another location. B To achieve a Merit or Distinction you will also need to show evidence of: 1. Creating at least two subfolders to help you organise your work. 2. Locating and opening files from a range of sources. 3. Creating shortcut(s) to at least one directory, program and file. 4. Backing-up and restoring files from a removable medium. 5. Deleting, copying and moving files and folders. C To achieve a Distinction you will also need to show evidence of: 1. Locating and opening existing files using operating system search facilities. 2. Creating, editing an deleting shortcuts to at least one program, directory and file.
16	Unit Assessment