New assignments
Applied ICT GCSE
Applied ICT GCSE Unit 1 Module 04
Select students
Finish
Select the assessment(s) you want to assign. The icon on the left indicates the assessment type.
Key:  Quiz Quiz,  Multi-choice survey Multi-choice survey,  ePortfolio ePortfolio,  Short-text test Short-text test
Popularity
67
Quality
58%
Reviews
2
Author: at
Assessments covering Unit 1 Module 4. Spreadsheet. 1 quiz, 3 tasks

To be used in conjunction with the Applied ICT GCSE workbook.
Select one or more assessments from the list below
1.04.1 Spreadsheets (quality 61%)
If you want to revise this topic before you take the test, you will find this section of our online encyclopedia useful.
1.04.2 Spreadsheet - Drills

You are going to create a spreadsheet, containing 4 worksheets, which shows the profit made from an open day at a donkey sanctuary.

Go to this introductory page and then complete the drills.

Don't forget to save copies of any draft versions of your spreadsheet as well as the final version. You may upload these to your portfolio if you wish.
1.04.3 Spreadsheet - External Portfolio
Imagine that your school is to perform a play for one night only.

You are going to create a spreadsheet that includes a seating plan of the hall and indicates where a seat has been sold.

Your spreadsheet should include all the items that are being bought and sold (you choose what these are to be). You will need to record revenue, costs and final profit.

You will need to use all the spreadsheet features that you have learned so far, including data validation, spinners, drop down lists, macros and graphs.

You will need to upload all your images and files to the appropriate cards in this task.

Useful links to help you:
When your teacher has approved your work, export it and copy it into an appropriate software application and create your spreadsheet to add to your portfolio.

Remember to save each version of your work with a separate file name. You will get more marks if you can show the process you have gone through to create the finished version.
1.04.4 Spreadsheet - Internal Portfolio
You are going to compare and contrast invoices from two businesses.

Download the documents below. Use them to complete the first 7 cards in this task. You may choose to complete either task 8 or task 9, or both if you wish. Upload all your images and files to the appropriate cards in this task.

Prontaprint: Invoice
Corsehill Consultants Ltd: Invoice

Useful links to help you:
Invoices for checking and editing:
Remember to save each version of your work with a separate file name. You will get more marks if you can show the process you have gone through to create the finished version.
Select one or more assessments from the list above
Reviews and comments