自學豬類研究追蹤 模板

The Pig Self‑Study Tracker is a multi‑sheet Excel workbook designed to keep students and teachers organized throughout an independent‑learning project on pig biology. 第一張工作表 Schedule（行程表）列出每個上課日，包含「日期」「節次」「活動」（研究、筆記、簡報等）、「具體任務」「地點」以及自由筆記欄位。 A drop‑down menu limits Activity entries to predefined options, ensuring consistent data. 下拉選單將「活動」限制為預先設定的選項，確保資料一致。 The second sheet, Topic Notes, is divided into sections for each major theme – organ anatomy, life cycle, husbandry, cultural references and more. 第二張工作表 Topic Notes（主題筆記）依主要主題分為多個區段——器官解剖、生命週期、飼養管理、文化參考等。 Within each section you record Source, Key Points, Summary, Completion Status and any attached file links. 在每個區段中，您可記錄來源、重點、摘要、完成狀態以及任何附件連結。 The third sheet, Summary, pulls data from the other two sheets with simple formulas and pivot‑tables, showing total study sessions, topics completed, upcoming deadlines and a small bar chart that visualizes progress over weeks. 第三張工作表 Summary（摘要）透過簡易公式與樞紐分析表，從前兩張表匯總資料，顯示總學習時段、已完成主題、即將到期項目，以及以小型長條圖呈現的每週進度。 This layout solves the common problem of scattered notebooks, forgotten deadlines and duplicated effort during a semester‑long self‑study. 此版面配置解決了學期長期自學中常見的筆記分散、截止日期遺忘與工作重複等問題。 By entering a single line for each class period, students instantly see how many sessions they have allocated to research, note‑taking or presentation creation, and the Summary sheet tells them at a glance which pig‑related topics are still pending. 只要在每節課輸入一行資料，學生即可即時看到分配給研究、筆記或簡報製作的時段數量，摘要表則一目了然哪些豬相關主題仍待完成。 The automatic calculations remove the need for manual tallies, while the built‑in chart gives a visual cue that motivates continued work. 自動計算免除手動統計，內建圖表提供視覺提示，激勵持續投入。 Teachers can also use the workbook to monitor each learner’s pace, spot gaps early and provide timely feedback, turning an otherwise informal activity into a measurable component of the curriculum. 教師亦可利用此活頁簿監控每位學習者的進度，及早發現不足並提供即時回饋，將原本非正式的活動轉化為課程可衡量的部分。 The template is ideal for high‑school biology classes, agricultural clubs, or any educational setting where pupils explore animal science independently. 此模板非常適合高中生物課程、農業社團，或任何讓學生自主探索動物科學的教育環境。 It helps students who prefer structured self‑learning, teachers who want to assign and track independent projects, and even parents who wish to follow their child’s progress at home. 它協助喜歡有結構自學的學生、希望布置與追蹤獨立專案的教師，甚至想在家關注子女進度的家長。 Whether the goal is to produce a final slide deck on pig anatomy, compile a research bibliography, or simply keep a tidy record of weekly discoveries, the tracker keeps every piece of information in one place, making revision and presentation preparation far less stressful. 無論目標是製作豬解剖的最終投影片、彙整研究書目，或僅是保持每週發現的整潔紀錄，追蹤器皆將所有資訊集中於一處，使複習與簡報準備不再壓力山大。 How to use

• Open the workbook and go to the Schedule sheet; select the date, period and choose an Activity from the drop‑down, then type the specific task (e.g., “Research organ structure”).
• 開啟活頁簿並前往 Schedule 工作表；選取日期、節次，從下拉選單選擇活動，然後輸入具體任務（例如「研究器官結構」）。
• Switch to Topic Notes, pick the relevant topic from its drop‑down, paste the source link, write key points and mark the status as “In progress” or “Done”.
• 切換至 Topic Notes，從下拉選單挑選相關主題，貼上來源連結，寫下重點，並將狀態標記為「進行中」或「完成」。
• Check the Summary sheet; it will automatically update totals, highlight overdue items and display a progress chart.
• 查看 Summary 工作表；它會自動更新總計、標示逾期項目，並顯示進度圖表。
• When you’re ready, use the filtered notes to copy into PowerPoint or Word for a final presentation, or export the sheet as PDF for submission.
• 完成後，將篩選後的筆記複製至 PowerPoint 或 Word 製作最終簡報，或將工作表匯出為 PDF 以供提交。 You’ll spend less time hunting for scattered notes and more time focusing on learning, while the visual progress tracker keeps motivation high. 您將減少搜尋分散筆記的時間，將更多精力投入學習，同時視覺化的進度追蹤器提升動機。