Use basic numerical operations with whole numbers, integers, fractions, and decimals. 2 Calculate ratios and proportions, percentages, averages.

Introduction to Numeracy, Data and IT

COM3006NFC                                  

Portfolio of Tasks

Assignment Brief

As part of the formal assessment for the programme you are required to submit a presentation demonstrating how you have met the learning outcomes for Academic Skills. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments.

Learning Outcomes:

After completing the module, you should be able to:

1 Use basic numerical operations with whole numbers, integers, fractions, and decimals. 2 Calculate ratios and proportions, percentages, averages.

3 Construct and use appropriate graphical techniques to present simple data.

4 Construct and use a spreadsheet application to record numerical data and use simple formula functions.

Your assignment should include: a title page containing your student number, the module name, the submission deadline and a word count; the appendices if relevant; and a reference list in Arden University (AU)Harvard format. You should address all the elements of the assignment task listed below. Please note that Lecturers will use the assessment criteria set out below in assessing your work.

Equivalent maximum word count: 3000 words

You must not include your name in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number.

TASK 1– FORMATIVE

Week 1: Please complete the Multiple Choice Questions (MCQs) set on Aula                

Please speak to your lecturer if you are having issues accessing your Multiple Choice Questions (MCQs).

Week 3: Please complete the Multiple Choice Questions (MCQs) set on Aula

Please speak to your lecturer if you are having issues accessing your Multiple Choice Questions (MCQs).

 Week 5: 

Given below is the Salespersons’ Revenue Book Breakdown for TechFast Solutions:

Write the Excel formula that would work for calculating:

1. The individual total number of sales for Anna, Amal, Charles, Ricky, Angela, Rayan, and Nancy.
2. The individual average sales amount for Anna, Amal, Charles, Ricky, Angela, Rayan, and Nancy

 Week 7:  Arden University surveyed 20 students on what size shoe they were. The following set of data states the results:

10, 11, 12, 9, 7, 6, 8, 12, 4, 6, 10, 12, 13, 10, 10, 6, 7, 8, 10, 10

Form a frequency distribution and find the mean of this data using your frequency distribution.

TASK TWO – SUMMATIVE

This final task must be submitted for final marking.

Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3.

Question 1: Answer the following questions:

a) Which are the top 3 countries in terms of projected annual revenue (state them in descending order of amount.

b) Which quarter is projected to bring in the most revenue?

Please copy the completed excel spreadsheet into a word document and submit as your final assessment.

If you have problem for copy and pasting excel spreadsheet then you must ask for help from your lecturer.

Question 2

a) Produce an appropriate fully labelled chart to reflect the quarterly totals for each region.

b) Use a suitable and fully labelled chart to reflect the contribution of each region to the overall project annual revenue.

Question 3

Imagine a scenario where you are the CEO of the AllTech group. What information could you gather from calculating the mean, median, mode, and range of each region? Discuss the importance of each measure of central tendency separately (max. 300 words).

Formative Feedback

Each week you will be expected to submit an example of your work to demonstrate that you have completed the weekly activities. Your tutor will give you continuous feedback whilst you are on your foundation programme.

Guidelines

You MUST underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using AU Harvard referencing.

Additional notes:

Students are required to indicate the exact word count on the title page of the assessment.

The word count excludes the title page, tables, figures, diagrams, footnotes, reference list and appendices. Where assessment questions have been reprinted from the assessment brief these will also be excluded from the word count. ALL other printed words ARE included in the word count. See ‘Word Count Policy’ on the homepage of this module for more information.

Assignments submitted late will not be accepted and will be marked as a fail.

Weekly tasks will be submitted via your portfolio on Aula and this will enable the academic team to give you feedback. The Final task needs to be submitted via the ilearn portal. There will be a link to this within your Aula Platform. Please seek for advice from your Lecturers on this.

You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is on the homepage of your module and also in the Induction Area). Use basic numerical operations with whole numbers, integers, fractions, and decimals. 2 Calculate ratios and proportions, percentages, averages.

New Foundation Year Assessment criteria for the following Pass/Fail Module assignments:

• Introduction to Research Skills
• Academic Skills Practice
• Ethics, Working Collaboratively and Values
• Introduction to Numeracy, Data, and IT

The following generic assessment criteria will be used to mark students’ work on a Pass/Fail basis. Specific guidance on how to meet these criteria will be contextualised to specific modules by providing the marking scheme.