메뉴

US$10

weekly

or US$40 for all content

초보자를 위한 Microsoft Excel - 실제 사례

66 명의 학생이 수업을 완료함

연령대: 10-14 세

자율 학습 과정

이 4개 레슨의 자기 주도 수업은 Excel의 기본을 가르칩니다. 학생들은 Excel을 사용할 수 있는 실제 시나리오를 제공받습니다. 그들은 디즈니 휴가 일정, 파티 예산, 간식 스탠드 사업 그래프 등을 만들 것입니다.

Colleen Smith

평균 평점:

5.0

수강 후기 수:

(334 수강 후기)

지금 등록하고 언제든 시작하세요

자신만의 속도로 학습해 보세요

학습자가 원할 때 학습을 시작하고 자신에게 가장 적합한 진도로 학습할 수 있습니다.

지금 등록하고 원할 때 시작하기

원하는 시점에 시작하세요.

자신의 진도에 맞춰 학습하세요

수업 자료를 1년 동안 이용할 수 있어요.

선생님의 실질적인 지원을 받을 수 있어요.

아웃스쿨 소개 학습 개요 내 스케줄 선생님 리뷰

무엇이 포함되어 있나요?

사전 녹화된 수업 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수강 후기

교사 전문성 및 자격증

학사 학위 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.