Outschool
開啟貨幣、時區和語言設置
登入

Microsoft Excel 初學者-現實生活中的例子

這門自定進度的四課課程將教授 Excel 的基礎知識。學生將在現實生活中使用 Excel。他們將創建迪士尼度假時間表、派對預算、小吃攤業務圖表等。
Colleen Smith
平均評分:
5.0
評論數量:
(330)
明星教育家
班級

包含什麼

8 預錄課程
4 週
教師的支持
1 年訪問權
到內容
作業
每週 1-2 小時. Students will create Excel files as they watch the recordings. They can submit them to me for review.
等級
Please let me know if you need specific grading or a certificate of completion for this class.
我們無法翻譯此文,請刷新頁面並再試一次。

課堂經歷

英語程度 - 未知
美國 4 - 7 年級
Beginner - Intermediate 等級
During this class, students will learn the basic functions of Microsoft Excel and get hands-on practice. This class will not only teach the basics of Excel, but it will excite students to discover ways they can use Excel in their everyday lives.  

This is a "Self-Paced" class, so there are no live sessions. Students will have access to four pre-recorded lessons that I created exclusively for Outschool. During the recording, I share my screen so students can watch me using Excel as I describe its functions. Learners are encouraged to use Excel as they watch the recording, so that they can follow along and gain hands-on practice. 

After the learner has completed a recording and created the Excel file described, they can submit it to me for review.  Next, there will be a recommended activity to add to the file in order to reinforce the skills the learner learned during the most recent recording. 

For a detailed lesson plan, please see the "Syllabus" section. 

Topics covered will include:
•	Vocabulary (cell, column, row, worksheet, formula, budget, sum)
•	Organizing data
•	Gridlines
•	Formatting cells (color, font, currency, time)
•	SUM, COUNT, and AVERAGE functions
•	Multiplication, Subtraction, Division, Addition formulas
•	Sorting and filtering cells
•	Pie, bar, and line graphs 

Students do not need any experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program.
學習目標
At the end of the class, students will be able to name parts of an Excel worksheet, input information into cells, format cells, use the sum function, input a multiplication formula, sort, filter, and create graphs.
學習目標

教學大綱

8 課程
超過 4 週
課 1:
Create a Schedule
 I'll begin by discussing real-world uses for Excel and related vocabulary. I'll then dive in and begin using the program.  Learners will imagine they are planning a trip to Disney. We'll use Excel to create a vacation schedule. Topics covered will include organizing data, formatting cells, auto-populating, and saving the file. 
課 2:
Add to Your Schedule
 Learners will post their own additions to their schedule. 
課 3:
Create a Budget
 Learners will imagine they are throwing their family member a birthday party!  We will use Excel to create a party budget. New topics covered will include formatting for currency, sorting, using sum function, and writing a multiplication formula. 
課 4:
Add to Your Budget
 Learners will add three additional items to their budgets and share why they added these items and their costs. 

其他詳情

先決條件
Students do not need any experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program.
供應清單
In addition to the Outschool classroom, this class uses: Microsoft Excel.

Students should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as they watch my recordings.
 1 註冊後即可取得文件
外部資源
學習者無需使用標準 Outschool 工具以外的任何應用程式或網站。
已加入 September, 2021
5.0
330評論
明星教育家
教師檔案
教師專業知識和證書
學士學位 由 Bucknell University
I have virtually tutored over 1,300 young learners, but prior to that I enjoyed a thirteen-year corporate career, where I used Excel 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. 

評論

自訂進度課程
分享

US$10

每週或US$40 所有內容
8 預錄課程
4 教師支援週
自行選擇何時開始
1 年內容存取權

有57 位學習者完成此課程
自行選擇何時開始
年齡: 10-14

立即報名,隨時開始
關於
支援
安全隱私加州隱私學習者隱私管理資料首選條款
下載這個軟體
在應用程式商店下載在 Google Play 上取得
© 2024 校外