Information Technology 2 Assignment: Climate Change Survey Analysis and PowerPoint Findings Presentation

Read The Instructions Carefully:

The Information Technology 2 Year 1 2025 Autumn assessment is an assignment consisting
of 2 components each worth 50%

1. Word Report: 50%
2. PowerPoint Presentation: 50%

General Information

The assignment requires students to produce a report in Microsoft Word interpreting the
findings of the Excel survey provided (downloadable from Blackboard labelled ‘Sample Data
IT 2 Autumn Assessment 2025’) and present key findings using Microsoft PowerPoint.

Submissions:

Students must upload 2 separate documents to Blackboard.

They must upload their Word Report through a Turnitin Folder labelled ‘Information
Technology 2 Autumn 2025 Repeat Assessment Word Report’.

The must upload their PowerPoint Presentation through a folder labelled ‘Information
Technology 2 Autumn 2025 Repeat Assessment PowerPoint Presentation’

Both folders are in the ‘Assessment Submissions’ section of Blackboard.

Upload each document labelled with your student number and either MS Word Report or MS
PowerPoint – depending on the project. No pdfs accepted – documents must be in the MS
Word or MS PowerPoint format.

Deadline: Weds 27th August 2025 6pm.

Both parts must be completed and submitted. Late submissions will be subject to a penalty of
10% per day.

i.e., one day late project marked out of 90% etc.

Part 1: Write up Report in MS-Word

Download the ‘Sample Data IT2 Autumn Assessment 2025’ Excel Spreadsheet on
Blackboard (in the Assessment Submissions Folder).

Write a report to interpret the survey in MS Word.

Read the questions in tab 1 of the spreadsheet to understand what the data is about so you can write an introduction (tip: the survey is about climate change and sustainability but expand on this).

Use the questions in tab 3 as ‘your own questions’.

Content:

Create a professional report analysing and interpreting your data. Your report
should include:

• A brief introduction to your topic and survey: include your four questions that were
  asked about how and when the survey was carried out
• Insert appropriate tables, charts, and data from your spreadsheet along with brief
  commentary (explanations,) interpreting what you have found out, and drawing
  our points of interest
  • You need to include your analysis and interpretation of each of your four questions
  • Tables, charts, and statistics must be presented, formatted, and labelled
• A reflection on what you have learnt in undertaking the project. You should also
  consider and address potential weaknesses in the approach taken
• Note that, if required, appropriate references should be given using the Harvard
  system (see Referencing section of the TLC Learning Development Blackboard
  course)

Report Structure:

The structure of the report should be as outlined below. Marks
will be allocated for the overall professionalism of the report. Features of Word should be
used as appropriate to enhance the appearance of the report and to show your knowledge and appreciation of the features.

Include these features: Styles and Themes, Tables, Page numbering, Automatic TOC,
Header and footer, Page breaks between pages, Graphics, SmartArt, images, cover
page, header, footer, charts and tables (created in Word), page borders.

Recommended Structure of Report

1. Cover Page
2. Table of Contents
3. Introduction
4. Findings
   • Category 1 analysis
   • Numerical 1 analysis
   • Category 2 analysis
   • Numerical 2 analysis
5. Discussion
6. Reflection
7. References
8. Appendices

Part 2: Create PowerPoint Presentation

Create a PowerPoint presentation to present your findings.

Create a PowerPoint presentation presenting the most interesting findings from your Report.
The presentation should be as visual as possible – do not overload your slides with
text! Ensure that you do not have everything on the slides that you intend to say (use the
‘notes’ function in PowerPoint).

Try to use images, SmartArt, and charts as much as possible and talk around them. If you use
text, please keep your bullet points short.

Try to present the most interesting findings only – no pivot tables!! Remember also at the end
to have a conclusion slide summarising the findings of the survey.

PowerPoint features should be used to enhance your presentation and highlight your
knowledge and appreciation of the features. Examples include:

• Cover Slide, themes, transitions, animations, slide numbers, footers, graphics,
  SmartArt, slide master for page numbers, headers and footers, images, Hidden Slide,
  End Slide.

Students will also be graded on spelling, grammar, punctuation, and use of language as well
as the overall professional standard of the document.

Remember, the more you can show that you can do in PowerPoint, whilst keeping the
presentation professional looking, the higher the mark you will receive!

Presentation Structure

Recommended Structure of Presentation

1. Cover Slide
2. Outline/Overview
3. Introduction/Background
4. Findings
   • Key Finding 1 with discussion point/observation
   • Key Finding 2 with discussion point/observation
5. Summary/Conclusion
6. Request for Questions/Thank You Slide