培訓暫用
培訓暫用
培訓暫用
昨天我Emailed各位5檔Files.
01. 網站總檔-20240908T081928Z-001.zip
02. Training Guide -複製松柏會網站 (Please print your hard copy)
03. 松柏固定活动月曆.zip
04. 松柏特別活动月曆.zip
05. Training Guide -複製松柏會月曆 (Please print your hard copy)
01. 網站總檔.zip (iecsa168web@google.com) ----------------> 網站總檔(您的 Google Drive)
02. 松柏固定活动月曆.zip (iecsa168web@google.com)----> 松柏固定活动月曆 (您的 Google Calendar)
03. 松柏特別活动月曆.zip(iecsa168web@google.com)-----> 松柏固定活动月曆 (您的 Google Calendar)
Once we clone the (website's page data folder) and the (two calendars used by the website) into your Google account, we will be ready to clone the entire website (page by page) into your account. This cloning process will provide us with valuable insights and "how-to" knowledge.
Unzipping:
Navigate to the Downloads folder.
Right-click on the file named 網站總檔-20240908T081928Z-001.zip.
Select Extract All from the context menu.
Choose the destination folder (e.g., Downloads or Desktop), and click Extract.
The extracted folder 網站總檔 will now appear in the chosen location.
Uploading:
Open Google Drive.
Drag and drop the 網站總檔 folder into your Google Drive.
Wait for the upload to complete.
Your 網站總檔 folder will now be available in Google Drive.
Unzip the File:
Locate the file 松柏固定活动月曆.zip.
Right-click on the file and select "Extract All".
This will produce an .ics file.
Create a New Calendar:
Open Google Calendar.
On the left sidebar, under "Other calendars," click the + button.
Select "Create new calendar."
Enter a name and description for the new calendar, then click "Create calendar."
Import the .ics File:
On the left sidebar, click the + sign next to "Other calendars" and select "Import."
Click "Select file from your computer" and choose the .ics file you extracted earlier.
From the "Calendar" dropdown, select the newly created calendar as the destination for the imported events.
Click "Import" to complete the process.
Your events should now be visible in the new calendar you created.
Locate the Documents:
Open Google Drive and navigate to the “首頁” folder.
Locate the two Word documents: "松柏會簡介Web.doc."
Copy Text from the First Document:
Open "IECSA English Introduction."
Select all the text (you can use Ctrl+A or Command+A).
Paste Text into the First Text Box:
Open the application or document where you need to paste the text.
Paste the text into the first text box (use Ctrl+V or Command+V).
Copy Text from the Second Document:
Open "The Introduction of Irvine Evergreen Chinese Senior Association."
Select all the text.
Copy the text.
Paste Text into the Second Text Box:
Navigate to the second text box in your application or document.
Paste the text into the second text box.
Adjust Text Box Properties:
Resize the text boxes as needed to fit the content properly.
Adjust the background color of each text box section to match your desired style.
Locate the Documents:
Open Google Drive and navigate to the “會長的話” folder.
Locate the two Word documents: "松柏會簡介Web.doc."
Copy Text from the First Document:
Open "IECSA English Introduction."
Select all the text (you can use Ctrl+A or Command+A).
Paste Text into the First Text Box:
Open the application or document where you need to paste the text.
Paste the text into the first text box (use Ctrl+V or Command+V).
Copy Text from the Second Document:
Open "The Introduction of Irvine Evergreen Chinese Senior Association."
Select all the text.
Copy the text.
Paste Text into the Second Text Box:
Navigate to the second text box in your application or document.
Paste the text into the second text box.
Adjust Text Box Properties:
Resize the text boxes as needed to fit the content properly.
Adjust the background color of each text box section to match your desired style.
Displaying PDFs on the Board of Directors Page:
Open the First PDF:
Go to the folder and open the first PDF titled "Board Of Directors 2024-2025".
Click the Share button in the upper right corner.
Define the sharing settings as needed, then click Copy Link to copy the URL.
Insert the First PDF:
Return to the page where you want to display the PDFs.
Click Insert, then choose Embed.
In the Embed from web pop-up, select By URL.
Paste the copied URL into the field and click Insert.
The PDF will now be embedded on the page.
Open and Embed the Second PDF:
Go back to the folder and open the second PDF titled "Board Of Directors 2020-2024".
Repeat the steps above to share and embed this PDF.
Open and Embed the Third PDF:
Go to the folder and open the third PDF titled "Board Of Directors 2016-2020".
Repeat the steps above to share and embed this PDF.
Displaying PDFs on the 賀函賀狀 Page:
Open and Embed the First PDF:
Go to the folder and open the first PDF titled "賀函賀狀.pdf".
Click the Share button in the upper right corner.
Define the sharing settings as needed, then click Copy Link to copy the URL.
Return to the page where you want to display the PDFs.
Click Insert, then choose Embed.
In the Embed from web pop-up, select By URL.
Paste the copied URL into the field and click Insert.
The PDF will now be embedded on the page.
Open and Embed the Second PDF:
Go back to the folder and open the second PDF titled "長期贊助.pdf".
Repeat the steps above to share and embed this PDF.
Creating the Monthly Activity Schedule Page:
Source of Information:
The data comes from the 每月活動時間表夾 folder.
The page will display one PDF file and two calendars.
Procedure:
1.Embed the PDF File:
Go to the 每月活動時間表夾 folder and open the PDF file.
Click the Share button in the upper right corner.
Set the sharing permissions as needed and click Copy Link to copy the URL.
Return to the page where you want to display the content.
Click Insert, then select Embed.
In the Embed from web pop-up, choose By URL.
Paste the copied URL into the field and click Insert.
The PDF file will now be embedded on the page.
2. Insert the First Calendar:
Click Insert, then select Calendar.
Google Calendar will appear on the right side.
Choose the calendar you want to display, such as 松柏固定活动月曆.
Click to insert this calendar onto the page.
3. Insert the Second Calendar:
Repeat the process to insert the second calendar, 松柏特殊活动月曆, onto the page.
Your Monthly Activity Schedule page is now complete with the embedded PDF and both calendars.
Displaying Teacher Articles:
Requirements:
The folder 老師們的話夾 contains 7 PDFs, each with an article from a different teacher.
On the page, a text box on the left side will list the titles of all 7 articles and the names of the authors.
Viewers can click on an article title to view the corresponding PDF.
Procedure:
Create Multiple Pages:
Duplicate the 老師們的話 page 6 times, renaming them as follows:
老師們的話-2
老師們的話-3
老師們的話-4
老師們的話-5
老師們的話-6
老師們的話-7
Each page should display the title 老師們的話.
Insert PDFs:
In the Google Drive 老師們的話夾 folder, insert each PDF into the corresponding page:
PDF-1 into 老師們的話
PDF-2 into 老師們的話-2
PDF-3 into 老師們的話-3
Continue this pattern for the remaining PDFs.
Create a Table of Contents:
On the 老師們的話-2 page, add a table of contents with one line per article.
Highlight each article title and create a hyperlink to the corresponding page (e.g., 老師們的話-2, 老師們的話-3, etc.).
Copy the Table of Contents:
Copy the table of contents from 老師們的話-2 to all subsequent pages (老師們的話-3, 老師們的話-4, etc.).
Your 老師們的話 page setup is now complete, allowing viewers to easily navigate and access each article.
Displaying 會員會友的 Article
Requirements:
The folder 會員會友的話 contains 16 PDFs, each with an article from a different 會員會友
On the page, a text box on the left side will list the titles of all 16 articles and the names of the authors.
Viewers can click on an article title to view the corresponding PDF.
Procedure:
Create Multiple Pages:
Duplicate the 會員會友的話 page 16 times, renaming them as follows:
會員會友的話-2
會員會友的話-3
會員會友的話-4
.......................
會員會友的話-16
Each page should display the title 會員會友的話
Insert PDFs:
In the Google Drive 會員會友的話夾 folder, insert each PDF into the corresponding page:
PDF-1 into 會員會友的話
PDF-2 into 會員會友的話-2
PDF-3 into 會員會友的話-3......
Continue this pattern for the remaining PDFs.
Create a Table of Contents:
On the 會員會友的話-2 page, add a table of contents with one line per article.
Highlight each article title and create a hyperlink to the corresponding page (e.g.,會員會友的話, 會員會友的話-2, 會員會友的話-3, etc.).
Copy the Table of Contents:
Copy the table of contents from 會員會友的話-2 to all subsequent pages (會員會友的話-3, 會員會友的話-4, etc.).
會員會友的話page setup is now complete, allowing viewers to easily navigate and access each article.
Inserting and Formatting a Content Box with a Linked Image:
Insert a Content Box:
Add a content box to the page with two sections:
Image Box on the left
Text Box on the right
Add the Image:
In the Image Box, locate the image file from the 聯絡我們夾 folder.
Insert the image into the box.
Link the Image to Google Maps:
Select the image in the Image Box.
Add a hyperlink to the image:
Click on the image to activate the hyperlink option.
Enter the Google Maps URL where you want the image to link to. (e.g., https://www.google.com/maps/place/Your+Location)
Apply the link.
Enter Contact Information:
In the Text Box, type the contact information for 爾灣華人松柏會.
Adjust Formatting:
Adjust the size and color of both the Image Box and Text Box as needed.
Ensure the overall layout of the section is visually appealing and aligned properly.
Under Construction。。。。。
Access and Placement:
Ester Hsiao shared two folders: IECSA Monthly Notice (月会) and IECSA Board Minutes (会议记录) with the email iecsa168web@google.com.
Rosalind placed these folders inside 10. 松柏Forms&Docs夹.
Process the IECSA Board Minutes Folder:
Navigate to the IECSA Board Minutes folder within 10. 松柏Forms&Docs夹.
a. Set the sharing options:
Click the Share button in the upper right corner.
Set access permission to Restrict with options for our director to view.
Click Copy Link to obtain the URL.
b. Insert the link on the Forms & Docs page:
Select a text box.
Click Embed and paste the copied link.
Click Insert and then Apply.
Process the IECSA Monthly Notice Folder:b
Repeat steps 2a to 2b for the IECSA Monthly Notice folder.
Finalize the Page:
Adjust the sizes, background, and color of the sections as needed.
The page processing is now complete.
Procedure to Create Mailing Labels Template in Word Using Excel
Open Word Document:
Launch Microsoft Word and open a new blank document.
Start Mail Merge:
Go to the Mailings tab.
Click on Start Mail Merge and select Labels from the dropdown menu.
Label Options:
In the Label Options window that appears, select Avery 5160 (or your preferred label type).
Click OK.
Select Recipients:
Click on Select Recipients in the Mailings tab.
Choose Use an Existing List.
Navigate to find your Excel file (e.g.,Ruby's Membership File) and click Open.
Select the appropriate sheet from the Excel workbook and click OK.
Edit Recipient List:
Click on Edit Recipient List.
You can define any filters or sorting keys if needed, then click OK.
Insert Merge Fields:
Click on Insert Merge Field to place the fields you want on the label (e.g., Name, Address).
Format the label as needed (font size, style, alignment).
Update Labels:
Click Update Labels to apply the same layout to all labels.
Finish & Merge:
Click on Finish & Merge in the Mailings tab.
Select Edit Individual Documents.
Choose All and click OK to generate the complete set of labels.
Review and Print:
Review the generated labels for accuracy.
Save your document and print the labels as needed.
1. Sign in to your Gmail account. Click 9 Dots Icon next to your profile photo, chose “Account”
2. Go to Security in the left menu.
3. Under "Signing in to Google," click on 2-Step Verification.
4. Enter your password again if prompted.
5. Click on Turn off at the top of the page.
6. Confirm your choice by clicking Turn off again
Open the Google Photos app.
Tap on "Albums" at the bottom of the screen.
Tap on the "+" icon or "Create album."
Select photos you want to include in the album.
Tap "Done" (or "Next") after selecting the photos.
Name your album and tap "Save."
Go to Google Photos in your web browser.
Click on "Albums" on the left sidebar.
Click on the "+" icon or "Create album."
Select photos you want to add.
Click "Done."
Name your album and click "Save."
You can share the album with others, add more photos, or change settings anytime!
Sharing(分享) Google Photos with another Google account:
Open the Google Photos app.
Select the album or photos you want to share.
Tap the share icon (a triangle with dots).
Choose "Share" or "Send".
Select the Google account you want to share with, or enter the email address and permission "Editor". (They are allowed to add their photos or videos to the shared album).
Tap "Send" or "Share" to complete.
Go to Google Photos in your web browser.
Select the album(相簿) or photos(相片) you wish to share.
Click the share icon.
Enter the email address of the Google account you want to share with.
Click "Send" or "Share".
你还可以build一个共享相册,多个Accounts 可以添加他们要加的照片。
Click (相簿)
Enter the email address of the Google accounts you want to share with ("Editor") permission.
Adding a Video to a Playlist
1. Sign In to YouTube:
Click on your profile photo in the top right corner.
2. Go to Your Channel:
Click (View your Channel) from the dropdown menu.
3. Manage Videos:
Click on Manage Videos to see a list of your uploaded videos.
4. Select Videos:
Check the box next to the video(s) you want to add to a playlist.
5. Add to Playlist:
Click Add to Playlist.
Check the box next to the desired playlist name, or click Create new playlist to add a new one.
6. Save:
Click Save to add the video to the selected playlist(s).
One video can be added to multiple playlists, allowing you to organize content in various ways.
Open Google Photos, locate the album you wanted to post.
Get Shareable Link:
Open the Album.
Click on "Share" Icon.
Choose create Link and copy the shareable Link.
Open Google site, find the page, Click on the spot where you want to insert your album.
Click "embed" from right -hand sidebar.
Chose "BY URL" tab and paste the link from prior step.
Step 1: Open Word Document
Launch Microsoft Word and open a new blank document.
Step 2: Start Mail Merge
Go to the Mailings tab.
Click on Start Mail Merge and select Labels from the dropdown menu.
Step 3: Label Options
In the Label Options window, select Avery 5160 (or your preferred label type).
Click OK.
Step 4: Select Recipients
Click on Select Recipients in the Mailings tab.
Choose Use an Existing List.
Navigate to your Excel file (e.g., Ruby Membership Master File) and click Open.
Select the appropriate sheet from the Excel workbook and click OK.
Step 5: Edit Recipient List
Click on Edit Recipient List.
Define any filters or sorting criteria if needed, then click OK.
Step 6: Insert Merge Fields
Click on Insert Merge Field to place the desired fields on the label (e.g., Name, Address).
Format the label as needed (adjust font size, style, alignment).
Step 7: Save the Template
Save the Word document as Monthly Mailing Labels Template.doc.
Log In: Go to YouTube and sign in to your account.
Find a Video: Search for the video you want to add to your playlist.
Add to Playlist:
Click on the video to open it.
Below the video, click on the "Save" button (it looks like a plus sign).
In the pop-up, you can either add it to an existing playlist or create a new one by clicking "Create new playlist."
If creating a new playlist, give it a title and select the privacy settings (Public, Unlisted, or Private).
Click "Create."
Add More Videos: Repeat the process for any other videos you want to add.
Open the YouTube App: Make sure you're signed in.
Find a Video: Search for the video you want to add.
Add to Playlist:
Tap on the video to open it.
Tap the "Save" icon below the video.
You can select an existing playlist or tap "Create new playlist."
Enter a title and set the privacy, then tap "Create."
Add More Videos: Continue adding videos as desired.
You can find your playlists by going to your Library (in the side menu on desktop or the bottom tab on mobile) and selecting "Playlists."
Create an Empty Album in iecsa168web@gmail.com
Sign in to the website’s Google Photos account. iecsa168web@gmail.com
Click on the “Albums” tab.
Select “Create Album” and name the album as "yyy-mm-dd Event"
Share the Album
Open the newly created album.
Click on the “Share” button.
Enter your Google account email address and permission as "Editor" . All others can "view".
Click “Send” to share the album.
Sign In to Personal Google Account
Sign in to your personal Google Photos account.
Access the Shared Album
Check the “Sharing” section in Google Photos to find the shared album.
Upload Photos and Videos
Open the shared album.
Click the “Add” button (plus icon) to load your photos and videos into the shared album.
Confirm
Double-check that all intended photos and videos have been successfully loaded to the album IN google photos, iecsa168web@gmail.com
7 Posting album on website page: (Refer to Google Photo- How to post the google album? Using Shareable Link.)
Visit a QR Code Generator:
qr-code-generator.com
Enter Your URL: www.iecsa168.org
Generate the QR Code: Click the button to generate your QR code.
Download the QR Code: Once generated, download the QR code image to your computer.
The QR Code image is ready to used. (scan with your cell phone camera, it will take you to our website)
Step 1 :Create a google form:
Open Google Drive:
Go to Google Drive and sign in.
Click on the “+ New” button in the top left corner.
Select “More” and then choose “Google Forms” from the dropdown menu.
Choose “Blank form” to create a new form.
Add Questions:
Add the necessary fields to collect membership information (e.g., name, email, membership type, etc.).
Set Up Confirmation Message:
Click on the settings gear icon (⚙️) in the top right corner.
Under the "Presentation" tab, customize the confirmation message that users will see after submitting the form.
Get the Embed Code:
Click the "Send" button at the top right.
Select the embed icon (< >) and copy the HTML code provided.
Under 入會聯絡我們 Page, add a sub Page: Name :綫上入會
Embed the Google Form:
Go to the "Insert" tab on the right sidebar.
Click on "Embed".
Paste the Google Form embed code you copied earlier into the embed field.
Click "Next", then "Insert" to add the form to the page.
Publish the Page:
Click on the "Publish" button in the top right corner to save your changes.
Navigate to the 入會聯絡我們 Page.
Insert a Button:
In the right sidebar, click on the "Insert" tab.
Select "Button".
Set Up the Button:
Name the button "綫上入會".
In the link field, select the "綫上入會" page you created.
Publish Changes:
Click the "Publish" button again to save the changes to your site.
Visit www.iecs168.org
Click “入會聯絡我們” Page
Click the Button:
Click on the "Apply Membership Online" button to ensure it takes you to the new page.
Fill Out the Form:
Complete the form and submit it to confirm that everything works correctly, including the confirmation message.
Google 表單是一種電子版的問卷或表格,方便用戶在電腦或手機上使用,簡單易用。
容易填寫:只需點擊或輸入答案,無需手寫。
快速方便:填寫後點擊【提交】,我們立即收到回覆。
自動收集答案:所有回覆的资料會自動儲存在 Google Sheets 中。不需再次manual Key In From 手填的资料到digital file。
我們利用 Google 表單來處理以下事務:
申請入會, Renewal 及 會員地址和電話的變更。收集的數據會儲存在 Google Sheets。 包括會員的個人資料、會費繳納情況、收费人員及支付方式(現金或支票等)。Google 表單今后將主導資料收集,理事在處理手填申請表時,可以使用 Google 表單form作為輸入工具,以便更新集中管理的會員資料庫。我們將逐步完成這一轉型,實現自動化數據庫。
調查問卷及報名:無論是課程或活動報名、活動更改通知等,均可通過 Google 表單進行。將表單連結分享至 Line 群組或通過電子郵件發送,會員的回覆將即時更新至回覆表格中。
将鼓励Director 运用Google Form Broadcast 她主导的活动。作好她的Google form 她可有多重管道broad cast 她的活动。如需要RSVP 的。Google Form 是 很好的Tool。
To unlink the response sheet from your Google Form:
Open your Google Form.
Click on the "Responses" tab.
Click the three vertical dots (more options) in the top right corner.
Select "Unlink form."
This will disconnect the response sheet from the form. If you need to delete the sheet afterward, you can do so from Google Drive.
To delete an unlinked response sheet from Google Drive, follow these steps:
Go to Google Drive: Open your Google Drive in your browser.
Find the Response Sheet: Locate the Google Sheets file that you want to delete.
Delete the Sheet Right-click on the file
Select "Move to Trash" from the dropdown menu.
Website: www.iecsa168.org
Google Account for the Site: iecsa168web@gmail.com Password: web00168 (Account Name : Iesca168-web Senior Display Name: IECSA168-Web)
Domain Platform: www.Squarespace.com
Squarespace Login iecsa168@gmail.com Password:Irvine168
Our Journey
Starting date - August 11, 2024 : Kick off meeting
Website went live - August 29, 2024 :
As the author and designer of the website, I aimed to create a platform that effectively reflects our mission and values. To enhance security, I proposed establishing a dedicated Google account, which received unanimous approval from President Chang and President Hwu.
Training and Empowerment
Following the website launch, we organized two training sessions at the Lakeview Senior Center to empower our directors in utilizing Google Sites effectively. Participants learned to share the master production folder within their personal Google accounts, enabling them to clone our website and adapt it for their specific needs. Our goal was to ensure that directors could manage their work more effectively through this platform. Notably, Ruby and Esther showcased exceptional proficiency in using the website, becoming valuable resources for our team
Jerry Chang, Annh Hwu, Rosalind O'Coonor, Ruby Lin, Esther Hsaio, Cynthia Chen, Bill Chao
Open your Google Form.
Click on the Settings gear icon at the top right.
Go to the Presentation tab.
In the Confirmation message box, type your message (e.g., "Thank you for your response!").
Click Save.
step-by-step guide from creating your ID card layout to saving it as a template:
Step 1: Set Up Your ID Card Layout
1. Open Microsoft Word.
2. Set Up the Page for ID Cards:
Go to Mailings > Labels.
Click Options and select a label size that matches your ID card dimensions.
If there’s no exact match, you can use New Label to create a custom size.
(Once you’ve chosen or created your size, click OK and then New Document. This will open a document formatted for ID cards)
3. Design the Layout: At the top of each ID card space, insert your Association Name Banner and Logo by going to Insert > Pictures.
Position and resize them as needed.
4. Add Placeholders for Member Information:
Click within the ID card layout where you want the member’s details to appear.
Go to the Mailings tab, select Insert Merge Field, and choose fields like Name, ID, and Membership Status from your data source.
Place each field in the desired location and format (font size, style, color).
Arrange these placeholders so they fit nicely with the overall layout.
Step 2: Save as a Template
1. Save the Document as a Template:
Go to File > Save As.
Select the location on your computer where you want to save the template.
In the Save as type dropdown menu, select Word Template (*.dotx).
Name your template, e.g., “Membership_ID_Card_Template,” and click Save
Now, this file is saved as a template. When you want to create new ID cards, you can open this template, connect your data source, and proceed with adding photos and finishing the mail merge.
Folder Location:
Google Drive: iesca168web@gmail.com
Path: My Drive → 會籍-by Ruby → Mailing Labels Template
Monthly Membership Updates:
Ruby updates the IECSA168 Membership Master.xlsx file each month. Once the file is ready, follow these steps to produce the mailing labels:
(This is the membership master file!!!)
Step 1: Open the Template
Open the Monthly Mailing Labels Template.doc file.
Step 2: Update Labels
Go to the Mailings menu.
Click on Update Labels to apply the existing data to all labels.
Step 3: Finish & Merge
In the Mailings menu, click on Finish & Merge.
Select Edit Individual Documents.
Choose All and click OK to generate the complete set of labels.
Step 4: Save the document as " 2014 October Mailing Labels.Doc" or 2014 November Labels.doc", " 2024 December Labels.Doc"
Step 5: Print the "2014 October Mailing Labels.Doc" on Avery5160 Paper.
Select Your Form
Access your google. Form, Click on the “Responses” tab at the top of the form.
3. **View Linked Spreadsheet**: If the responses are linked to a Google Sheets spreadsheet, you'll see a green Sheets icon. Click on it to open the linked spreadsheet.
4. **Delete the Spreadsheet**: In Google Sheets, you can either:
- **Delete the spreadsheet**: If you want to permanently remove the response data, click on "File" > "Move to trash."
- **Unlink the spreadsheet**: If you want to keep the spreadsheet but just unlink it from the form, go back to the Google Form, click on the three dots (More) in the upper right corner of the “Responses” tab, and select “Unlink form.”
5. **Confirm Deletion**: If you chose to delete the spreadsheet, confirm that you want to move it to the trash.
Keep in mind that if you delete the linked spreadsheet, the response data will be lost unless you have a backup. Let me know if you need more help!the responses for.
Access the Responses Tab:
Once your form is open, look at the top of the page. You’ll see two tabs: Questions and Responses. Click on the Responses tab.
View Responses:
Here, you can see a summary of responses,