Logo Research

Make a page of logos you found using a search engine. For each one explain what you like / dislike about it and explain what company it is for. Mention the choice of colours and shapes used.
See an example.

Initial Sketch Designs (on paper or computer versions)

Make a page of 4 to 8 sketch designs. Each should have a suitable shape ( clipart) and the name or initials of the company.
You could print a page of your final logo in different colour schemes.
See an example.

Design Logo

Make a large scale version of your logo and label the colours, shapes and ideas you used. Explain why you like it.

See a finished example.

Evaluation Sheet 1

Now evaluate the logo in detail explaining how it meets the company's requirements. How could you have made it with different software (programs) or using different techniques?

Design Data Capture Form (Timesheet)

You need to collect information from each employee about how much they are currently getting paid, how much tax they pay etc. Make a questionnaire to ask them for this information.
See an example.

Create, save and print pay spreadsheet

Use the worksheet and the spreadsheet file to fill in the data required and make formulas to calculate the correct tax deductions
See an example.

Printout showing formulas

In Excel click 'Tools... Options...' then on the 'View' tab choose 'formulas' and click OK.
Show me.
See an example.

Graph showing output per worker

Copy and paste the staff names and hours worked (with overtime if applicable) from your pay spreadsheet onto a new spreadsheet. Use the graph wizard to graph these columns.
You could also add a text box to explain who has worked hardest (in case the management want to give bonuses).
See an example.

Evaluation Sheet 2

Now evaluate the spreadsheet in detail explaining the formulas you used.
How could the staff have done this before computers were around?

Pay slip showing merge fields

You will do best to use Word. Insert a table and show the mail merge toolbar. Then use 'open data source' to browse for your pay spreadsheet. Then use 'Insert merge fields' to insert the column headings you need from the pay spreadsheet.
Print the version
showing the <<merge codes>>
See an example.

Merge staff details with pay slip and print results

You then need to click 'View merged data' to show that the merge is working. It should pull the correct data out of your pay spreadsheet into Word automatically.
Don't print everyone's pay slip (waste of paper!) Just print one employee's pay slip.
See an example.

Evaluation Sheet 3

Now evaluate the mail merge in detail explaining how it meets the company's requirements. How could you have made it with different software (programs) or using different techniques? Would it save the company time and effort? How?