Examen

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

Puntuación

Vendido

Páginas

Grado

A+

Subido en

24-04-2025

Escrito en

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]

Mostrar más Leer menos

Institución

Grado

Ups! No podemos cargar tu documento ahora. Inténtalo de nuevo o contacta con soporte.

Informar violación de derechos de autor

Libro relacionado

Adriano Fabris Ethics of Information and Communication Technologies

Edición:2018
ISBN:9783319755106
Edición:Desconocido

Escuela, estudio y materia

Institución: University of South Africa (Unisa)
Grado: Ethical Information and Communication Technologies for Development Solutions (EUP1501)

Todos documentos para esta materia (141)

Información del documento

Subido en: 24 de abril de 2025
Número de páginas: 24
Escrito en: 2025/2026
Tipo: Examen
Contiene: Preguntas y respuestas

Temas

eup1501

Vista previa del contenido

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

2,68 €

Accede al documento completo:

100% de satisfacción garantizada

Inmediatamente disponible después del pago

Tanto en línea como en PDF

No estas atado a nada

Conoce al vendedor

VarsityC

4,1

(2821)

Conoce al vendedor

VarsityC AAA School of Advertising

Ver perfil

Seguir

Vendido

28688

Miembro desde

8 año

Número de seguidores

13258

Documentos

3118

Última venta

1 hora hace

4,1

2821 reseñas

1492

581

392

117

239

Recientemente visto por ti

Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes

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.

100% de satisfacción garantizada: ¿Cómo funciona?

Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.

Who am I buying this summary 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 this summary for 2,68 €. You're not tied to anything after your purchase.

Can Stuvia be trusted?

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

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

Libro relacionado

Escuela, estudio y materia

Información del documento

Temas

Vista previa del contenido

Mas cursos para University of South Africa (Unisa) >

Conoce al vendedor

Recientemente visto por ti

Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

¿No estás satisfecho? Elige otro documento

Paga como quieras, empieza a estudiar al instante

Preguntas frecuentes

What do I get when I buy this document?

100% de satisfacción garantizada: ¿Cómo funciona?

Who am I buying this summary from?

Will I be stuck with a subscription?

Can Stuvia be trusted?