【Notebook LM × Google 試算表，老師工作效率大升級！】

你會學到

• 透過 NotebookLM 結合 Google 試算表，可大幅提升老師撰寫學生學習表現評語的效率。
• 自訂提示詞是實現自動化生成的關鍵，能精確定義 AI 潤飾評語的風格與規則。
• NotebookLM 支援與 Google 雲端硬碟的資料同步，確保評語資料的即時更新與靈活性。
• 無論是代碼輸入、質性文字或語音轉文字，多樣化的輸入方式都能有效驅動 AI 生成評語。
• AI 僅為輔助工具，教師仍需對最終生成的評語進行審核與把關，確保內容的準確性與適宜性。

跟著做

1. 準備YAML格式的自訂行為指示並貼入NotebookLM。
2. 準備學生評語試算表和代碼分類表。
3. 將上述檔案從Google Drive匯入NotebookLM。
4. 在提示詞區輸入「開始」以生成評語。
5. 在Google Sheet中修改後，點擊同步按鈕即可更新。

教學金句

「Notebook LM結合試算表實在是太犯規了」 「只要是跟你的試算表有關的，都可以用這樣的方式來套用」 「1的話就是幾乎不改，然後5的話保留原意換成好聽的話，10的話高度美化，負面也能夠轉為對未來的期許」 「嚴格遵守三明治溝通法」 「AI的話只是幫我們去做調整跟潤飾，所以最後輸出，老師還是要再看過檢查一遍，不要偏離原意太多，千萬不要沒有檢查就輸入」

適用情境

這部影片適合放在 AI 工具應用或教育科技課程的「AI 輔助教學管理」段落。主要受眾為 K12 教育工作者（尤其是導師）以及對 Google Workspace (Sheets) 和 AI 工具整合有興趣的進階使用者。學員應具備 Google 試算表基本操作能力，並對 AI 輔助寫作的概念有基礎認識。前置知識包括對 NotebookLM 的基本介面熟悉度，以及對教學評語撰寫有一定了解。

延伸主題

• 深入探討 NotebookLM 自訂提示詞的進階寫作技巧與 YAML 語法實踐。
• 結合 Google Apps Script 或其他自動化工具，實現評語生成後的自動匯入學校系統流程。
• 討論 AI 在教育場景中生成式內容的倫理考量、偏見風險與最佳實踐。
• 探索其他 AI 工具在教育管理（如教案設計、試題生成、學習路徑規劃）中的應用案例。
• 學生學習行為數據分析與評語個人化：如何利用數據洞察提升 AI 評語的精準度。

---en---

What You’ll Learn

• Integrating NotebookLM with Google Sheets significantly boosts efficiency for teachers when drafting student performance reviews.
• Custom prompts are crucial for automated generation, precisely defining the AI’s style and rules for refining comments.
• NotebookLM supports data synchronization with Google Drive, ensuring real-time updates and flexibility for review data.
• Diverse input methods, including code input, qualitative text, or speech-to-text, can effectively drive AI to generate comments.
• AI is merely a supplementary tool; teachers must still review and gatekeep the final generated comments to ensure accuracy and appropriateness.

Teaching Quote

“The combination of Notebook LM and spreadsheets is simply unfair.” “Anything related to your spreadsheet can be applied this way.” “A ‘1’ means almost no changes, ‘5’ means retaining the original meaning but in a pleasant way, ‘10’ means highly beautifying, even turning negatives into future aspirations.” “Strictly adhere to the sandwich communication method.” “AI merely helps with adjustment and refinement, so for the final output, teachers must still review and inspect to ensure it doesn’t deviate too much from the original meaning. Never submit without checking.”

When to Use

This video is highly suitable for an “AI-Assisted Teaching Management” segment within AI tool application or educational technology courses. Its primary audience includes K12 educators (especially homeroom teachers) and advanced users interested in integrating Google Workspace (Sheets) with AI tools. Learners should possess basic Google Sheets operational skills and a fundamental understanding of AI-assisted writing concepts. Prerequisite knowledge includes familiarity with the basic NotebookLM interface and a certain level of understanding of writing teaching reviews.

Related Topics

• In-depth exploration of advanced writing techniques for NotebookLM custom prompts and YAML syntax implementation.
• Combining Google Apps Script or other automation tools to achieve automated import of generated reviews into school systems.
• Discussion on ethical considerations, bias risks, and best practices for AI-generated content in educational settings.
• Exploring application cases of other AI tools in educational management (e.g., lesson plan design, test generation, learning path planning).
• Student learning behavior data analysis and personalized reviews: How to use data insights to enhance the accuracy of AI reviews.