Integrasi Word dan Excel - TIK-K10-01

Main ideas / lessons conveyed

• What “integration of office application content” means

  • Integration (merging/uniting) is the process of uniting several objects or data from different office applications into one document/workflow.
  • Example: create work in Microsoft Word, but the content/data (e.g., table/graph data) is managed using Microsoft Excel. When the Excel data changes, the graph updates in Word.

• Structure of the Student Worksheet (LK)

  • The LK (Student Worksheet) is divided into two parts:
    • Student Worksheet 1
    • External Student Worksheet
  • For the chosen LK1, there are multiple activities/sections (described as 5 student worksheets) practiced one by one.

• Goal of the demonstration

  • Build an OSIS election graph in a Word document using integrated Excel data.
  • Example scenario:
    • 3 candidates
    • Several classes (up to Class 10-5) that select the candidates
    • Each class has a specified number of voters for each candidate
  • When Excel data is edited, the graph in Word updates accordingly.

---

Method / step-by-step instructions (as shown)

A) Create the Word document and insert the chart linked to Excel

1. Open Microsoft Word.
2. Create/open a Blank document.
3. Go to Insert.
4. Select Chart (choose a chart style as demonstrated).
5. Choose a chart style:
   • The speaker first chooses a “normal”/default style to avoid confusion.
   • Then selects a more specific/custom style (referred to as “beautiful”).
6. The embedded Microsoft Excel sheet appears as part of the chart setup—use Excel to input/update the graph data.

B) Enter election data in the embedded Excel sheet

1. Delete or clear the existing default data in the Excel sheet.
2. Set up the table for the chart:
   • Columns: Candidate 1, Candidate 2, Candidate 3
   • Rows: Classes, e.g. Class 10-1, 10-2, 10-3, 10-4, 10-5
3. Fill in the number of votes per class for each candidate (example counts are provided in the subtitles).
4. After entering the data, the chart in Word updates automatically.

C) Finish the chart in Word (title, design, save)

1. Close the embedded Excel/chart editing area.
2. Change the chart title (example: “Grafik Pemilihan OSIS 2022/2023”).
3. (Optional) Change the chart design:
   • Use available design options
   • Edit chart elements (e.g., add/change items shown)
   • The speaker demonstrates selecting an element so it appears immediately.

D) Save the file to the specified folder

1. Save the LK file with a name matching the LK title.
   • Example: “TIK Kelas 10 01 Integrasi Word dan Excel”
2. If it’s a new file, a Save As prompt may appear.
3. Choose the save location using Browse.
4. Create a new folder structure (example):
   • Folder: “Zain”
   • Subfolder: “Kelas 10 1”
5. Click Open to confirm the destination.
6. Save changes (including selecting file type/name/title fields in Save As).
7. Close the file.

E) How to find the saved file

1. Open File Explorer.
2. Navigate to the folder/drive where it was saved (example: Drive D).
3. Open the created folder.
4. Double-click the saved file to open it.

---

Speakers / sources featured

• Speaker (video presenter/instructor): No name provided in the subtitles.
• Software/source materials used:
  • Microsoft Word
  • Microsoft Excel