5L4Z0002 Digital Talents 5L4Z0002 Evaluation Transient Key task and observe count (or identical):
For this project, that you just might hang to manufacture a Portfolio including the next objects:
- A single Excel spreadsheet file containing a separate sheet for every of the capabilities (listed within the ‘Extra Data’ allotment below) that that you just might need gotten applied to a given dataset.
- A PowerPoint presentation with different of a design template of no extra than 750 words in which you designate two of the key findings out of your portfolio item 1 dataset prognosis.
Module Studying Outcomes LO1 Spend presentation and spreadsheet capabilities to fresh recordsdata and records
LO2 Form fable templates in conserving with specified requirements.
LO3 Assemble written communications acceptable to the nature of the change (formal and informal)
This overview will contribute to the achievement of the next Programme Studying Outcomes:
PLO2 Our graduates would perchance be effective communicators the usage of a range of media
Trait 2.1.3 Display masks digital skills acceptable to level and to discipline
Assignment Microscopic print And Directions Evaluation kind: Particular person Work
Evaluation layout: Portfolio submission on-line most efficient, two recordsdata to upload (1 Excel and 1 Powerpoint)
Supplementary predominant aspects: Maximum of 1000 words with the exception of References for the Powerpoint element. No most observe restrict for the Excel file. Shuffle value is 40%.
There would perchance be alternatives for formative feedback and pork up out of your module tutor in your timetabled tutorials by the usage of designated activities and by scheduling time for questions and solutions.
Key initiating aspects/pondering aspects:
The portfolio contains two objects:
A. An Excel spreadsheet containing the implications of your dataset prognosis the usage of the next Excel capabilities:
Filter IF MIN and MAX Bar chart Moderate VLOOKUP Pivot Table Detailed directions for every feature are:
Filter
- Initiate Assignment Excel file ‘2023 SMMT automobile registration recordsdata’
- Invent a modern worksheet and name it ‘Filter’
- Copy and paste both ‘month’ and ‘new_vehicle_reg’ column to the newly created ‘Filter’ worksheet and switch the column name ‘month’ to ‘date’
- Make a selection the ‘date’ column and add filter feature on this column
- Spend the filter feature to make a different the automobile registration recordsdata of 2018 and 2019
- Attach all changes
MIN and MAX
- Initiate saved Excel file previously historical
- Invent modern worksheet and name it ‘Min&Max’
- Copy and paste both ‘month’ and ‘new_vehicle_reg’ column to the newly created worksheet
- Invent modern columns ‘yearly min’ and ‘yearly max’ on column C and D
- Spend the ‘=min()’ feature to name the minimal value in a house of twelve months for every yr and document the min value on the identical row as January for every yr (as an instance on the identical row of Jan-10, then on the identical row of Feb-10 etc for all years, there would perchance be 12 particular person min values in complete)
- Spend the ‘=max()’ feature to name basically the most value in a house of twelve months for every yr, document as above
- Attach all changes
Bar chart
- Initiate saved Excel file previously historical
- Invent modern worksheet and name it ‘bar chart’, copy the columns ‘month’ and ‘new_vehicle_reg’ to this newly created worksheet
- Insert a bar chart with monthly modern automobile registration quantity as vertical axis and months as horizontal axis for yr 2011
- Add bar chart title ‘Monthly Vehicle Registration 2011’
- Insert any other bar chart with 2011 and 2012 recordsdata on the identical chart and for every month the values, i.e. the two bars, are when put next (gift that to realize this you can desire to organise a modern dataset). Title the chart ‘2011 and 2012 Vehicle Reg Comparison’.
- Attach all changes
AVERAGE
- Initiate saved Excel file previously historical
- Invent modern worksheet and name it ‘Moderate’, copy the columns ‘month’ and ‘new_vehicle_reg’ to this newly created worksheet
- In a modern column ‘monthly average’, generate modern automobile registration monthly average recordsdata on a yearly basis (for 2021 say the modern months recordsdata), document this average value on the identical row as every January
- Round up the document of the monthly average values with 0 decimal locations (integers).
- Attach all changes
IF
- Initiate saved Excel file previously historical
- Invent modern worksheet and name it ‘IF’, copy the columns ‘month’ and ‘new_vehicle_reg’ to this newly created worksheet
- Invent modern efficiency index column with heading ‘efficiency’
- Spend the ‘IF’ feature to populate the newly created column:
monthly registration above (and including) 150,000 return the value “Excessive”;
monthly registration between (and including) 100,000 and 149,999 return the value “Medium”;
and monthly registration below (and including) ninety 9,999 return the value “Low”
- Attach all changes
VLOOKUP
- Initiate saved Excel file previously historical
- Invent modern worksheet ‘vlookup’ and reproduction the columns ‘month’, ‘new_vehicle_reg’, and ‘Efficiency’ columns from old ‘IF’ worksheet to this newly created worksheet
- Invent and insert a ‘id’ column on the front of all three modern columns, just like the modern ‘id’ column with quantity within the layout of ‘201001’(four digits yr + two digits month), in conserving with the ‘month’ column recordsdata, e.g. 201001, 201002,…, 201101, 201102,…, for all modern rows
- Invent modern column heading ‘selected_months’ in column F, and like within the IDs for August and September for all years, e.g.:
Chosen Months 201008 201009 201108 201109 5. Invent modern column heading ‘perf_lookup’ in column G and and say vlookup feature to feedback the efficiency recordsdata (excessive, medium, and low) to the corresponding rows from column ‘id’. Characterize that you just can desire to make say of vlookup capabilities to full this, eyeballing the guidelines and like in manually is no longer going to be really appropriate fine reply.
- Attach all changes
Pivot Table
- Initiate saved Excel file previously historical
- Invent modern worksheet ‘pivot_table’;
- Copy and paste the first four columns ‘id’, ‘month’, ‘new_vehicle_reg’, and ‘efficiency’ from old ‘vlookup’ worksheet.,
- In column E, kind modern index titled ‘yr’ and just like the column with the years for every role accordingly, e.g. for the first 12 rows, it’s miles ‘2010’ for every row and the next 12 rows ‘2011’.
- Invent any other modern column ‘perf_score’ in column F by IF feature: monthly registration above (and including) 150,000 return the value 3; monthly registration between (and including) 100,000 and 149,999 return the value 2; and monthly registration below (and including) ninety 9,999 return the value 1
- Generate annual efficiency pivot table on the identical worksheet with annual aggregated efficiency salvage and safe out the supreme and least performing years, value the very supreme and least by the facet of the pivot table
- Insert any other pivot table below the first one and this time calculate the smartly-liked of new_vehicle_reg for every yr and safe out the very supreme and least performing yr and value by the table.
- Attach all changes
B. A PowerPoint Presentation with a design template that’s no extra than 750 words focussed on two key discovering of the dataset prognosis undertaken in portfolio item 1. Guidance on presentation layout and convey material would perchance be equipped at school and on the unit Moodle Page.
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
