{"id":33147,"date":"2026-08-06T07:59:48","date_gmt":"2026-08-06T07:59:48","guid":{"rendered":"https:\/\/academicwritersbay.com\/solutions\/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-si\/"},"modified":"2026-08-06T07:59:48","modified_gmt":"2026-08-06T07:59:48","slug":"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-si","status":"publish","type":"post","link":"https:\/\/academicwritersbay.com\/solutions\/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-si\/","title":{"rendered":"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 spr"},"content":{"rendered":"

5L4Z0002 Digital Talents 5L4Z0002 Evaluation Transient Key task and observe count (or identical):<\/p>\n

For this project, that you just might hang to manufacture a Portfolio including the next objects:<\/p>\n

    \n
  1. A single Excel spreadsheet file containing a separate sheet for every of the capabilities (listed within the \u2018Extra Data\u2019 allotment below) that that you just might need gotten applied to a given dataset.<\/li>\n
  2. 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.<\/li>\n<\/ol>\n

    Module Studying Outcomes LO1 Spend presentation and spreadsheet capabilities to fresh recordsdata and records<\/p>\n

    LO2 Form fable templates in conserving with specified requirements.<\/p>\n

    LO3 Assemble written communications acceptable to the nature of the change (formal and informal)<\/p>\n

    This overview will contribute to the achievement of the next Programme Studying Outcomes:<\/p>\n

    PLO2 Our graduates would perchance be effective communicators the usage of a range of media<\/p>\n

    Trait 2.1.3 Display masks digital skills acceptable to level and to discipline<\/p>\n

    Assignment Microscopic print And Directions Evaluation kind: Particular person Work<\/p>\n

    Evaluation layout: Portfolio submission on-line most efficient, two recordsdata to upload (1 Excel and 1 Powerpoint)<\/p>\n

    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%.<\/p>\n

    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.<\/p>\n

    Key initiating aspects\/pondering aspects:<\/p>\n

    The portfolio contains two objects:<\/p>\n

    A. An Excel spreadsheet containing the implications of your dataset prognosis the usage of the next Excel capabilities:<\/p>\n

    Filter IF MIN and MAX Bar chart Moderate VLOOKUP Pivot Table Detailed directions for every feature are:<\/p>\n

    Filter<\/p>\n

      \n
    1. Initiate Assignment Excel file \u20182023 SMMT automobile registration recordsdata\u2019<\/li>\n
    2. Invent a modern worksheet and name it \u2018Filter\u2019<\/li>\n
    3. Copy and paste both \u2018month\u2019 and \u2018new_vehicle_reg\u2019 column to the newly created \u2018Filter\u2019 worksheet and switch the column name \u2018month\u2019 to \u2018date\u2019<\/li>\n
    4. Make a selection the \u2018date\u2019 column and add filter feature on this column<\/li>\n
    5. Spend the filter feature to make a different the automobile registration recordsdata of 2018 and 2019<\/li>\n
    6. Attach all changes<\/li>\n<\/ol>\n

      MIN and MAX<\/p>\n

        \n
      1. Initiate saved Excel file previously historical<\/li>\n
      2. Invent modern worksheet and name it \u2018Min&Max\u2019<\/li>\n
      3. Copy and paste both \u2018month\u2019 and \u2018new_vehicle_reg\u2019 column to the newly created worksheet<\/li>\n
      4. Invent modern columns \u2018yearly min\u2019 and \u2018yearly max\u2019 on column C and D<\/li>\n
      5. Spend the \u2018=min()\u2019 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)<\/li>\n
      6. Spend the \u2018=max()\u2019 feature to name basically the most value in a house of twelve months for every yr, document as above<\/li>\n
      7. Attach all changes<\/li>\n<\/ol>\n

        Bar chart<\/p>\n

          \n
        1. Initiate saved Excel file previously historical<\/li>\n
        2. Invent modern worksheet and name it \u2018bar chart\u2019, copy the columns \u2018month\u2019 and \u2018new_vehicle_reg\u2019 to this newly created worksheet<\/li>\n
        3. Insert a bar chart with monthly modern automobile registration quantity as vertical axis and months as horizontal axis for yr 2011<\/li>\n
        4. Add bar chart title \u2018Monthly Vehicle Registration 2011\u2019<\/li>\n
        5. 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 \u20182011 and 2012 Vehicle Reg Comparison\u2019.<\/li>\n
        6. Attach all changes<\/li>\n<\/ol>\n

          AVERAGE<\/p>\n

            \n
          1. Initiate saved Excel file previously historical<\/li>\n
          2. Invent modern worksheet and name it \u2018Moderate\u2019, copy the columns \u2018month\u2019 and \u2018new_vehicle_reg\u2019 to this newly created worksheet<\/li>\n
          3. In a modern column \u2018monthly average\u2019, 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<\/li>\n
          4. Round up the document of the monthly average values with 0 decimal locations (integers).<\/li>\n
          5. Attach all changes<\/li>\n<\/ol>\n

            IF<\/p>\n

              \n
            1. Initiate saved Excel file previously historical<\/li>\n
            2. Invent modern worksheet and name it \u2018IF\u2019, copy the columns \u2018month\u2019 and \u2018new_vehicle_reg\u2019 to this newly created worksheet<\/li>\n
            3. Invent modern efficiency index column with heading \u2018efficiency\u2019<\/li>\n
            4. Spend the \u2018IF\u2019 feature to populate the newly created column:<\/li>\n<\/ol>\n

              monthly registration above (and including) 150,000 return the value \u201cExcessive\u201d;<\/p>\n

              monthly registration between (and including) 100,000 and 149,999 return the value \u201cMedium\u201d;<\/p>\n

              and monthly registration below (and including) ninety 9,999 return the value \u201cLow\u201d<\/p>\n

                \n
              1. Attach all changes<\/li>\n<\/ol>\n

                VLOOKUP<\/p>\n

                  \n
                1. Initiate saved Excel file previously historical<\/li>\n
                2. Invent modern worksheet \u2018vlookup\u2019 and reproduction the columns \u2018month\u2019, \u2018new_vehicle_reg\u2019, and \u2018Efficiency\u2019 columns from old \u2018IF\u2019 worksheet to this newly created worksheet<\/li>\n
                3. Invent and insert a \u2018id\u2019 column on the front of all three modern columns, just like the modern \u2018id\u2019 column with quantity within the layout of \u2018201001\u2019(four digits yr + two digits month), in conserving with the \u2018month\u2019 column recordsdata, e.g. 201001, 201002,\u2026, 201101, 201102,\u2026, for all modern rows<\/li>\n
                4. Invent modern column heading \u2018selected_months\u2019 in column F, and like within the IDs for August and September for all years, e.g.:<\/li>\n<\/ol>\n

                  Chosen Months 201008 201009 201108 201109 5. Invent modern column heading \u2018perf_lookup\u2019 in column G and and say vlookup feature to feedback the efficiency recordsdata (excessive, medium, and low) to the corresponding rows from column \u2018id\u2019. 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.<\/p>\n

                    \n
                  1. Attach all changes<\/li>\n<\/ol>\n

                    Pivot Table<\/p>\n

                      \n
                    1. Initiate saved Excel file previously historical<\/li>\n
                    2. Invent modern worksheet \u2018pivot_table\u2019;<\/li>\n
                    3. Copy and paste the first four columns \u2018id\u2019, \u2018month\u2019, \u2018new_vehicle_reg\u2019, and \u2018efficiency\u2019 from old \u2018vlookup\u2019 worksheet.,<\/li>\n
                    4. In column E, kind modern index titled \u2018yr\u2019 and just like the column with the years for every role accordingly, e.g. for the first 12 rows, it’s miles \u20182010\u2019 for every row and the next 12 rows \u20182011\u2019.<\/li>\n
                    5. Invent any other modern column \u2018perf_score\u2019 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<\/li>\n
                    6. 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<\/li>\n
                    7. 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.<\/li>\n
                    8. Attach all changes<\/li>\n<\/ol>\n

                      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.<\/p>\n","protected":false},"excerpt":{"rendered":"

                      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 \u2018Extra Data\u2019 allotment below) that that you just might […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-33147","post","type-post","status-publish","format-standard","hentry","category-solutions"],"_links":{"self":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/33147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/comments?post=33147"}],"version-history":[{"count":0,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/posts\/33147\/revisions"}],"wp:attachment":[{"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/media?parent=33147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/categories?post=33147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academicwritersbay.com\/solutions\/wp-json\/wp\/v2\/tags?post=33147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}