IES_學生資料準備

1.在使用之前，我們要先準備好課程學生的資料，學生資料輸入方式平台有自己的規定格式，可以使用Excel或者Google試算表來輸入檔案，也可以從下方的連結去建立副本到自己的雲端使用。

【備註】限定公館國小學校 Google 帳號使用

https://docs.google.com/spreadsheets/d/1omSv34K6yPsy3_IbtWFDUTaNrhQK9a0g6r67kZIqlx4/edit?usp=sharing

2.規定的格式如下，Name、SeatNo、Gender、StudentNo、LoginID、SubGroup、 SubGroupName這幾個注意要去填寫，尤其是「 StudentNo 」建議直接使用學生註冊入學的學號，如果單純使用班級座號，像是『60301』，隔一年就會出現一個新的學生是『60301』，這樣系統在讀取資料的時候會產生問題，因此記得使用學生註冊入學的學號。

<span class="BCX0 SCXW92359790 TextRun" data-contrast="auto" lang="ZH-TW" style="-webkit-tap-highlight-color:transparent; -webkit-text-stroke-width:0px; -webkit-user-drag:none; background-color:rgb(255, 255, 255); color:rgb(0, 0, 0); font-family:微軟正黑體,微軟正黑體_msfontservice,sans-serif; font-kerning:none; font-style:normal; font-variant-caps:normal; font-variant-ligatures:none !important; font-weight:400; letter-spacing:normal; line-height:20.5042px; margin:0px; orphans:2; padding:0px; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; user-select:text; white-space:normal; widows:2; word-spacing:0px" xml:lang="ZH-TW"> 3. 依據這個規格，將所有的學生資料輸入 <span class="BCX0 SCXW92359790 TextRun" data-contrast="auto" lang="ZH-TW" style="-webkit-tap-highlight-color:transparent; -webkit-text-stroke-width:0px; -webkit-user-drag:none; background-color:rgb(255, 255, 255); color:rgb(0, 0, 0); font-family:微軟正黑體,微軟正黑體_msfontservice,sans-serif; font-kerning:none; font-style:normal; font-variant-caps:normal; font-variant-ligatures:none !important; font-weight:400; letter-spacing:normal; line-height:20.5042px; margin:0px; orphans:2; padding:0px; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; user-select:text; white-space:normal; widows:2; word-spacing:0px" xml:lang="ZH-TW"> 。 <span class="BCX0 EOP SCXW92359790" data-ccp-props="{}" style="-webkit-tap-highlight-color:transparent; -webkit-text-stroke-width:0px; -webkit-user-drag:none; background-color:rgb(255, 255, 255); color:rgb(0, 0, 0); font-family:微軟正黑體,微軟正黑體_msfontservice,sans-serif; font-style:normal; font-variant-caps:normal; font-variant-ligatures:normal; font-weight:400; letter-spacing:normal; line-height:20.5042px; margin:0px; orphans:2; padding:0px; text-align:left; text-decoration-color:initial; text-decoration-style:initial; text-indent:0px; text-transform:none; user-select:text; white-space:normal; widows:2; word-spacing:0px">

<div class="OutlineElement Ltr SCXW16447556 BCX0" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; overflow: visible; cursor: text; clear: both; position: relative; direction: ltr; color: rgb(0, 0, 0); font-family: "Segoe UI", "Segoe UI Web", Arial, Verdana, sans-serif, "Microsoft Jhenghei UI", "Microsoft JHengHei", 微軟正黑體, MingLiU, 細明體, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;"> <p class="Paragraph SCXW16447556 BCX0" paraeid="{3adc9dc6-f496-4a41-b5dc-144a88a5ed5f}{232}" paraid="1265568106" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; overflow-wrap: break-word; font-weight: normal; font-style: normal; vertical-align: baseline; background-color: transparent; color: windowtext; text-align: left; text-indent: 0px;"> 4.如果是在Google 試算表進行製作的話，在下載的時候，要下載CSV檔。

<div class="OutlineElement Ltr SCXW16447556 BCX0" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; overflow: visible; cursor: text; clear: both; position: relative; direction: ltr; color: rgb(0, 0, 0); font-family: "Segoe UI", "Segoe UI Web", Arial, Verdana, sans-serif, "Microsoft Jhenghei UI", "Microsoft JHengHei", 微軟正黑體, MingLiU, 細明體, sans-serif; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;"> <p class="Paragraph SCXW16447556 BCX0" paraeid="{3adc9dc6-f496-4a41-b5dc-144a88a5ed5f}{236}" paraid="1250853959" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; overflow-wrap: break-word; font-weight: normal; font-style: normal; vertical-align: baseline; background-color: transparent; color: windowtext; text-align: left; text-indent: 0px;"> 檔案 - > 下載格式 -> 逗點分隔值檔案（.CSV，目前工作表）

220的詭異世界

歡迎220的詭異世界這裡有各種軟體的教學文章大家提出問題跟想學的東西或者到Youtube上搜尋【木子風雲】也可以聯絡到我喔