Login
Menu

Introduction to Computing Skills

Home / Blog / Introduction to Computing Skills

Introduction to Computing Skills

Introduction to Computing Skills

Assignment Tasks

Your assignment consists of two tasks: Task 1 and Task 2

How much is task 1 worth?

It is worth 40% of the total marks for the module.

What will it look like?

It is a spreadsheet file, containing text, numbers and formulas. Word count is unlimited.

 

How will I submit it?

Add screenshots of your spreadsheet in data view and in formula view to your Task 2 document.

 

Keywords

Data view: results of your formulas

Formula view: on the Formulas tab, click Show Formulas; or press (CTRL + ` )  to see the formulas that are hidden behind your calculations

Screenshot: Press PRTSCR or a similar button to take a picture of your screen

 

Example of data view                                                                    Example of formula view

 

 

 

 

How much is task 2 worth?

It is worth 60% of the total marks for the module.

What will it look like?

It will be a word processed file or a presentation file (your choice). The file will contain text and pictures. Do not write more than 650 words.

 

How will I submit it?

You will upload your word processed file to Turnitin.

 

 

 

When will I submit it?

You will submit a single document, containing Task 1 and Task 2, by 12pm (midday) Tuesday 15th December 2015.

Business Scenario

Healey Ltd is a small management consultancy, with 25 employees.  The Managing Director is considering purchasing office productivity software for her employees but is unsure of the cost, or the benefits, of such a purchase.

You have been employed to achieve two tasks: task 1) to calculate the costs of this purchase, and task 2) to describe some benefits of the software.

 

Task 1: Costings for office productivity software and training (40% of total marks)

You have been asked to calculate total training and product costs for Healey Ltd.

Use the figures from the table below in your calculations:

 

Training Types Cost per person (excluding VAT) Number of staff undertaking training
Basic £30.00 10
Intermediate £40.00 25
Advanced £50.00 14

 

 

Office productivity products Cost per licence (excluding VAT) Number of products required
Office 365 £100.00 10
Office 2013 £140.00 15

 

 

 

 

Task 1 Instructions

Create a workbook, with 2 worksheets, to store your cost estimates for Healey Ltd.

Worksheet 1:

 

  • Name the first worksheet “Training”. (1 mark)

 

  • Add the title “Training Costs” at the top of your worksheet. (1 mark)

 

  • Format the title – consider font style, font size, text colour, cell background colour, text alignment or merged cells. (1 mark)

 

  • Insert today’s date at the top of the worksheet, using the DATE function. (3 marks)

 

  • For each training type (basic, intermediate, advanced), write a formula to calculate the total cost excluding VAT. (6 marks)

 

  • For each training type (basic, intermediate, advanced), write a formula to calculate the total cost including 17.5% VAT. (9 marks)

Make your formulas more robust, by using absolute referencing. (3 marks)

 

7) Format all currency as £, to two decimal places, e.g. £2.00 (1 mark)

 

Worksheet 2:

 

  • Name the second worksheet “Products”. (1 mark)

 

  • Add the title “Product Costs” at the top of your worksheet. (1 mark)

 

  • Format the title – consider font style, font size, text colour, cell background colour, text alignment or merged cells. (1 mark)

 

  • For each product type (Office 365, Office 2013), write a formula to calculate the total cost excluding VAT. (4 marks)

 

  • Calculate the total cost of products using SUM function. (3 marks)

 

  • Your manager has allocated a budget of £1500 for software purchases. Using an IF function, compare the total cost of products to your budget, and return the text ”costs are within budget” if costs are less than or equal to £1500. Return “costs are over budget” if costs are greater than £1500. (4 marks)

 

  • Format all currency as £, to two decimal places, e.g. £2.00. (1 mark)

 

Prepare to submit your work: Place screenshots of your spreadsheet in data view AND formula view in your Task 2 word-processed document.  You must show both views.

Task 2: Benefits of office productivity software (60% of total marks)

 

What is my aim?

Describe how 3 features of office productivity software can contribute to increased productivity and enhance the quality of management for Healey Ltd.

 

What will it look like?

It will be a word-processed file, containing text and images.

 

What steps should I follow to achieve this?

Step 1

Select 3 features from the tables in page 6 – one from each table.

 

Step 2

In a word-processed document, insert images showing your selected features in use by:

  • screenshot from the exercises you carried out throughout the module OR
  • use an image sourced from the Internet

 

(5 marks per image-documented feature)

 

Step 3

Beneath image(s) of each feature, write a paragraph or more describing how that feature can contribute to increased productivity, and enhance the quality of management, within Healey Ltd.

(15 marks per text-documented feature)

 

Step 4

All text and images drawn from external sources must be Harvard referenced.

 

Step 5

Don’t forget to add the screenshots of your spreadsheet in data view AND formula view!

Upload your finished document to Turnitin by 12 midday Tuesday 15th December 2015.

Word processing software features – choose one from this table

Feature Some ways to describe that feature
Tables Describe using table tool to present data,Modify column width, row height

Add shading/background colour to cells

Modify cell border line style, width, colour
Graphical Objects Identify the benefits of inserting an object (picture/image/drawn object) in a document.Describe how objects can be edited, such as resized and cropped.

Describe how object can affect document layout, e.g. wrapping.
Mail Merge Describe the input, process and output of a mail merge.

 

Presentation software features – choose one from this table

Feature Some ways to describe that feature
Slides Describe at least 3 good practices in designing slide content.Discuss at least 2 types of slide layout.
Charts & tables Describe how to use charts and tables to improve presentation of, and add value to data.Compare the benefits of adding a chart, compared to benefits of adding a table.
Graphical objects Discuss how graphical objects such as SmartGraphics can add value to a presentation.Describe at least 2 drawn objects such as arrows and text boxes

 

Spreadsheet software features – choose one from this table

Feature Some ways to describe that feature
Managing worksheets Describe role of workbook, worksheet, rows, columns and how to identify a cell reference.Describe benefits of formatting, copying, editing, moving and deleting content of cells.
Formulas and functions Describe good practice in creating formulas.Discuss the benefit of using at least one function, such as SUM, DATE, IF or AVERAGE.
Charts and graphs Describe how to use charts and graphs to improve presentation of, and add value to data.Compare at least 2 types of charts or graphs.

Is this the question you were looking for? If so, place your order here to get started!