Exam (elaborations)

EUP1501 Assignment 3 (DETAILED ANSWERS) Semester 2 2025 - DISTINCTION GUARANTEED

Rating

Sold

Pages

Grade

A+

Uploaded on

24-04-2025

Written in

2025/2026

EUP1501 Assignment 3 (DETAILED ANSWERS) Semester 2 2025 - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED - DISTINCTION GUARANTEED Answers, guidelines, workings and references , 9. From the Home ribbon, use “Format as Table” to select the style for the dataset (use any purple style). Make sure you select the dataset before you start. [5] 10. Save the spreadsheet as Surname-StudentNumber (e.g. 2324567_Brown) --------------------------------------------------------------------------------------------------------------------------------------- Section Sections B: PowerPoint Presentation (45 Marks) Download the provided PowerPoint Presentation (Formative Assessment 3 – ClimateChange), and perform the following tasks: Create a 5-slide PowerPoint presentation summarizing your findings from the Excel analysis. 1. Slide 1: Title Slide [8] o Title: "Drones and Climate Change Report" (Bold, 60, any Blue Color) o Insert any picture related to climate change (Center aligned) o Include your name and the date. (Center aligned, any light blue) 2. Slide 2: Overview on Drones and Climate Change [6] o Provide a short overview of how drones can be used as a tool against climate change 3. Slide 3: Drone Sales Data [10] o Copy and Paste the Pie charts (from Task 8 of Section A) o Embed your Section A Excel Spreadsheet 4. Slide 4: Chosen Drone and reason [10] o Provide drone specifications and a picture 5. Slide 5: Conclusion [5] o Provide insights on drones. o Add an image or icon to enhance presentation aesthetics 6. Additional formatting [4] o Slide numbers o Date (current) o Footer - include student Number o Theme - Droplets 7. Save your PowerPoint Presentation as StudentNumber_SurnameDrones (e.g. 333333_BrownDrones) Section A: Ms Excel (45) Open a blank spreadsheet. Create the Drone Sales Dataset using the data provided below, and complete the tasks: [4] No Drone Model Sales Region Units Sold Unit Price Total Revenue Profit Margin (%) Profit Amount 1 DJI Phantom 4 North America 2 Parrot Anafi Europe 3 DJI Mavic Air 2 Asia 4 Skydio 2 South America 5 Autel Evo II Africa 6 Sum 7 Average 8 Max 9 Min Tasks: 1. Apply bold headers and change the font size to 12pt. [2] 2. Calculate Total Revenue for all drone models using the formula  Total Revenue = Units Sold × Unit Price [5] 3. Calculate Profit Amount for all drone models using the formula:  Profit Amount = (Profit Margin / 100) × Total Revenue [5] 4. Format all currency values (Unit Price, Total Revenue, Profit Amount) as currency (use rands, 2 decimal places). [5] 5. Apply conditional formatting to highlight sales regions where revenue exceeds R50,000.00. [5] 6. Adjust column widths to ensure data visibility. 7. Apply SUM, AVERAGE, MAX, and MIN functions for Total Revenue and Profit Amount. [8] 8. Generate two charts for visualization purposes:  A Bar Chart comparing revenue across different sales regions. [3]  A Pie Chart showing the market share of each drone model (use “Drone model” and “Profit Amount” columns). [3]

Show more Read less

Institution

Course

Whoops! We can’t load your doc right now. Try again or contact support.

Report Copyright Violation

Connected book

Adriano Fabris Ethics of Information and Communication Technologies

Edition:2018
ISBN:9783319755106
Edition:Unknown

Written for

Institution: University of South Africa (Unisa)
Course: Ethical Information and Communication Technologies for Development Solutions (EUP1501)

All documents for this subject (141)

Document information

Uploaded on: April 24, 2025
Number of pages: 24
Written in: 2025/2026
Type: Exam (elaborations)
Contains: Questions & answers

Subjects

eup1501

Content preview

EUP1501
Assignment 3 Semester 1 2025
Unique #:

Due Date: 30 April 2025

Detailed solutions, explanations, workings
and references.

+27 81 278 3372

, SECTION A

COMPLETE ANSWER WITH STEP BY STEP GUIDELINES

Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8
No Drone Model Sales Region Units Sold Unit Price Total Revenue Profit (%) Profit Amount
1 DJI Phantom 4 North America 5000 R1 200,00 R6 000 000,00 25% R1 500 000,00
2 Parrot Anafi Europe 3000 R800,00 R2 400 000,00 30% R720 000,00
3 DJI Mavic Air 2 Asia 7000 R1 000,00 R7 000 000,00 28% R1 960 000,00
4 Skydio 2 South America 2500 R1 500,00 R3 750 000,00 32% R1 200 000,00
5 Autel Evo II Africa 1800 R1 100,00 R1 980 000,00 27% R534 600,00
6 Sum R5 600,00 R21 130 000,00 R5 914 600,00
7 Average R1 120,00 R4 226 000,00 R1 182 920,00
8 Max R1 500,00 R7 000 000,00 R1 960 000,00
9 Min R800,00 R1 980 000,00 R534 600,00

Total Revenue by Sales Region
R8 000 000,00
R7 000 000,00
R6 000 000,00
R5 000 000,00
R4 000 000,00
Total Revenue
R3 000 000,00
R2 000 000,00
R1 000 000,00
R0,00
North America Europe Asia South America Africa

Market share of each drone model

Autel
Evo II
9%
DJI Phantom 4
Skydio 2
26%
20%

Parrot Anafi
12%

DJI Mavic Air 2
33%

Varsity Cube 2025 +27 81 278 3372

, STEP-BY-STEP GUIDELINE INSTRUCTIONS FOR SECTION A

Step 1: Create the Drone Sales Dataset

1. Open Microsoft Excel and create a blank spreadsheet.
2. Enter the column headers exactly as follows:
o Drone Model, Sales Region, Units Sold, Unit Price, Total Revenue,
Profit Margin (%), Profit Amount
3. Input the 5 rows of drone data as provided.
4. Leave rows for Sum, Average, Max, and Min under the dataset.

Step 2: Format Headers [2 marks]

 Bold all column headers.
Select the headers:

o Click and drag to highlight all the column headers (e.g. “Drone Model”,
“Sales Region”, “Units Sold”, etc.).
Make the text bold:

o On the Home tab (in the Excel ribbon at the top),
o Click the “B” button in the Font group, or press Ctrl + B on your keyboard.

 Change font size of headers to 12pt.
While the headers are still selected,

Locate the Font Size box in the same Home tab, usually next to the font name
(e.g., Calibri).

Varsity Cube 2025 +27 81 278 3372

$3.13

Get access to the full document:

100% satisfaction guarantee

Immediately available after payment

Both online and in PDF

No strings attached

Get to know the seller

VarsityC

4.1

(2820)

Get to know the seller

VarsityC AAA School of Advertising

View profile

Sold

28687

Member since

8 year

Number of followers

13258

Documents

3117

Last sold

3 days ago

4.1

2820 reviews

1491

581

392

117

239

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller VarsityC. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $3.13. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews) 41389 documents were sold in the last 30 days Founded in 2010, the go-to place to buy study notes for 16 years now

EUP1501 Assignment 3 (DETAILED ANSWERS) Semester 2 2025 - DISTINCTION GUARANTEED

Connected book

Written for

Document information

Subjects

Content preview

Get to know the seller

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Didn't get what you expected? Choose another document

Pay as you like, start learning right away

Frequently asked questions

What do I get when I buy this document?

Satisfaction guarantee: how does it work?

Who am I buying these notes from?

Will I be stuck with a subscription?

Can Stuvia be trusted?