メニュー

$10

weekly

or $40 for all content

初心者のための Microsoft Excel - 実例

66 人が学習を完了しました

年齢 10 歳-14 歳

自分のペースで学べるコース

この 4 レッスンの自習クラスでは、Excel の基礎を学習します。生徒は Excel を実際に使用できるシナリオを学習します。ディズニーの休暇スケジュール、パーティーの予算、スナックスタンドのビジネスグラフなどを作成します。

Colleen Smith

平均評価:

5.0

レビュー数:

(334 レビュー)

Star Educator

8 録画済みレッスン

4 間の講師サポート

開始日を選択してください

コンテンツへの 1 年間のアクセス

今すぐ登録して、いつでも始められます

自分のペースで進んでください

学習者は好きなときに学習を開始し、自分に最適な速度で学習を進めることができます。

今すぐ登録して、いつでも始められます

いつでも始められます。

自分のペースで学ぼう

1 年間コース教材にアクセスできます。

教師から実践的なサポートを受けられます。

About 学習の概要スケジュール講師レビュー

含まれるもの

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が提供する基本ツール以外のアプリやウェブサイトを使用する必要はありません。

先生について

Colleen Smith

参加しました September, 2021

5.0

334レビュー

Star Educator

プロフィール

教師の専門知識と資格

学士号 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.