Back 

✅ Specific Outcome 1: Create and Edit a Graph

---

Assessment Criteria 1: Define Graph Types and Their Purpose

You should be able to explain and use at least three of these:

• Pie Chart – shows parts of a whole (e.g., budget breakdown)

• Bar Chart – compares categories (e.g., sales by region)

• Column Chart – same as bar chart, but vertical

• Line Chart – shows trends over time

• Scatter Chart – shows relationships between values

• Area Chart – like a line chart, but shaded

Activity: In Excel, list 6 months and corresponding sales. Try creating each type of chart and explain what it shows best.

---

Assessment Criteria 2: Create a Graph from Given Data

You must:

• Select appropriate data

• Insert a graph (at least two different types)

Steps in Excel:

1. Highlight the data

2. Go to Insert > Chart

3. Choose a chart type (e.g., Pie or Line)

4. Insert it into your spreadsheet

---

Assessment Criteria 3: Edit a Graph

Edit at least three of the following:

• Chart Title

• Axis Titles

• Data Labels

• Background Colour

• Line or Bar Colour

Tip: Right-click on chart elements or use the Chart Tools tab.

---

Assessment Criteria 4-7: Modify Graph

You should be able to:

• Change chart type (e.g., from Column to Line)

• Move or copy chart:

  • To another worksheet

  • To another workbook

• Resize the chart (drag the corners)

• Delete the chart

Practice:

1. Insert a Column chart

2. Change it to Pie using Chart Tools > Design > Change Chart Type

3. Copy and paste it to Sheet2

4. Resize it

5. Delete it when done

---

✅ Specific Outcome 2: Load Data from an External Source

Assessment Criteria 1-2: Check and Format External Data

You must:

• Open a file (e.g., .CSV, .TXT)

• Check the format (columns, commas, headers)

• Make sure it can be used correctly in Excel

Steps:

1. Open Excel

2. Go to File > Open > Browse for the file

3. Use the Text Import Wizard if needed

---

Assessment Criteria 3-4: Copy and Use the Data

• Copy the data from the external source

• Paste it correctly into your spreadsheet

• Ensure it looks like the example or expected result

Tip: Use Paste Special to keep formatting or values only.

---

✅ Specific Outcome 3: Insert and Edit Objects

Assessment Criteria 1: Insert Objects (At least 2 types)

Examples:

• Picture (e.g., company logo)

• Image (clipart)

• Chart (already covered)

• Autoshape (rectangle, arrow)

Insert Steps:

1. Go to Insert > Pictures or Shapes

2. Select and place in spreadsheet

---

Assessment Criteria 2: Manipulate the Object (At least 2 actions)

Actions:

• Move – click and drag

• Copy – Ctrl+C, Ctrl+V

• Resize – drag corners

---

Assessment Criteria 3: Use Drawing Tools

Use the Drawing Tools in Excel to draw a shape:

• Click Insert > Shapes

• Choose shape (e.g., circle)

• Draw in the spreadsheet

Edit the shape using format options: color, outline, effects

---

Helpful Tips

• Save your work often

• Practice on different datasets (e.g., monthly sales, product prices)

• Use Excel’s Help feature if unsure

• Ask for clarification before the assessment

---

Back