適合初學者的 Google 表格
這個自學課程將教授 Google 試算表的基礎知識。學生將獲得可以使用 Google 試算表的現實生活場景。他們將創建並格式化每週計劃、帶有公式的預算，並對奧運統計數據進行排序。
Colleen Smith
平均評分：
5.0
評論數量：(333)
明星教育家
包含什麼
6 預錄課程
3 週
教師的支持1 年訪問權
到內容作業
每週 2-4 小時. Students will watch six recordings and will work in Google Sheets during each recording. They can send me a link to their Google Sheet for review. Feedback will be given on all assignments within 48 hours, although I aim to make it even sooner.評分
I provide feedback on all work that is turned in. Please let me know if you need specific grading.我們無法翻譯此文，請刷新頁面並再試一次。
課堂經歷
英語程度 - 未知
美國 4 - 7 年級
Beginner - Intermediate 等級
During this class, students will learn the basic functions of Google Sheets and get hands-on practice. More details can be found in the 𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨 and 𝙇𝙚𝙖𝙧𝙣𝙞𝙣𝙜 𝙂𝙤𝙖𝙡𝙨sections. 𝗛𝗼𝘄 𝗱𝗼𝗲𝘀 𝗮 𝘀𝗲𝗹𝗳-𝗽𝗮𝗰𝗲𝗱 𝗰𝗹𝗮𝘀𝘀 𝘄𝗼𝗿𝗸? This is a Self-Paced, so there are no live sessions. Students will have access to six pre-recorded lessons that I created exclusively for Outschool. During the recordings, I share my screen so students can watch me using Google Sheets as I describe its capabilities. Learners are encouraged to use Google Sheets as they watch the recording, so that they can follow along and gain hands-on practice. The recordings are about 9-15 minutes, but may take longer to complete, depending on if the student pauses or rewinds as they watch and complete their tasks in Google Sheets. Students can submit their work for feedback and reach out with questions. 𝗪𝗵𝗮𝘁 𝗱𝗼 𝘀𝘁𝘂𝗱𝗲𝗻𝘁𝘀 𝗻𝗲𝗲𝗱 𝗳𝗼𝗿 𝘁𝗵𝗶𝘀 𝗰𝗹𝗮𝘀𝘀? Students do not need any experience with Google Sheets, but should have basic desktop or laptop knowledge, such as the ability to use a mouse or touch pad, be able to use a keyboard and open a program. They must have access to a free Google account in order to access Google Sheets. The account should be created prior to class, as this is not covered.
學習目標
Students will comprehend Google Sheets vocabulary (cell, column, row, worksheet, formula, budget, sum)Students will be able to implement formatting (color, font, number type for currency and time, gridlines)
教學大綱
6 課程
超過 3 週課 1:
Create a Schedule
I'll begin by discussing real-world uses for Google Sheets and related vocabulary. I'll then dive in and begin using the program. Learners will use Google Sheets while watching my recording to create their own weekly schedule. Topics covered will include auto-populating days and times and naming and sharing a Google Sheet. 15 分鐘的影片課程
課 2:
Format Your Schedule
Learners will learn how to add gridlines and change fonts, sizes and colors. 11 分鐘的影片課程
課 3:
Create a Budget
Learners will imagine they are going grocery shopping. We will use Google Sheets to create a budget. New topics covered will include formatting for currency and writing a multiplication formula. 16 分鐘的影片課程
課 4:
More Formulas for Your Budget
Learners will learn the difference between Static and Cell Reference formulas and write addition, subtraction and division formulas and use the SUM function. 12 分鐘的影片課程
其他詳情
父母的引導和規範
Learners will use Google Sheets, which is an Outschool-approved third party tool, but does require a free Google account.
供應清單
In addition to the Outschool classroom, this class uses: Google Sheets Students should have a Google account setup prior to starting class, so they can use the program and follow along as they watch my recordings.
教學語言
英語
外部資源
除了 Outschool 教室外，本課程也使用：
已加入 September, 2021
5.0
333評論
明星教育家
教師專業知識和證書
學士學位 由 Bucknell University
I have virtually tutored over 1,300 young learners on Outschool, but prior to that I enjoyed a thirteen-year corporate career, where I used spreadsheets to make my work more efficient and effective on a daily basis. I hold a Bachelor's of Science in Business Administration from Bucknell University. 
