Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel for Teachers

Who can take this course and what it includes?Everyone can take this course. Microsoft Excelis taught through developing a project.This project keep, format,...
/5
(0 reviews)
35 students
Created by

7.8

CourseMarks Score®

6.0

Freshness

N/A

Feedback

9.1

Content

Platform: Skillshare
Video: 37m
Language: English
Next start: On Demand

Top Teacher Tools courses:

Detailed Analysis

CourseMarks Score®

7.8 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

6.0 / 10
This course was last updated on 8/2018.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

We analyzed factors such as the rating and the ratio between the number of reviews and the number of students, which is a great signal of student commitment. If a course does not yet have a rating, we exclude Feedback Score from the overall CourseMarks Score.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.1 / 10
Video Score: 7.6 / 10
The course includes 37m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
Detail Score: 9.6 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Table of contents

Description

Who can take this course and what it includes?
Everyone can take this course. Microsoft Excel is taught through developing a project. This project keep, format, and compute course result.

What will learners get from this course?
Students will learn to:
a) apply excel formatting features
b) use excel formulas
c) create graph
d) set printing options
e) change percentage

What is the teaching methodology?
Project based learning methodology is adopted. In this course a project is developed incrementally. All skills are taught by working on this project.

What this course teaches?

Video 1: Course Introduction
This video introduces teacher and course.

Video 2: Excel Interface and Basic Formatting
This video covers graphical user interface of Excel and basic formatting like cut, copy, paste.

Video 3: Formatting
This video teaches following formatting features: bold, italic, underline, font size, resize column width, fill (background color), table border, merge and center, center align and middle align, and wrap text.

Video 4: Formatting and SUM Formula
This video covers SUM formula and following formatting features: auto fill, paste by value, and decimal places.

Video 5: Formatting and VLOOKUP Formula
This video teaches how VLOOKUP formula can assign grades (A, B, C, etc).

Video 6: COUNTIF Formula
This video shows how excel COUNTIF formula can count number of As, Bs, and Cs in a class.

Video 7: Graph, Print Setting and Password
This video covers graph, print setting, and file protection by setting password.

Video 8: Change Percentage
This video teaches how to change the percentage of an assessment component.

You will learn

Create class result according to the following specification.

1. Data Entry

Fill following data items: title, course name, student ids, student name

2. Marks Distribution

a) Marks distribution is given below enter marks according to the given distribution.

  • Quizzes (15%): Give three quizzes, 7.5 marks each, and choose best two quizzes.
  • Assignments (15%): Give three assignments, 5 marks each, and count all three.
  • Mid Term Exam (20%): Give 50 marks final exam and scale down it to 20%.
  • Course Project (20%): Give 20 marks course project.
  • Final Exam (30%): Give 100 marks final exam and scale down it to 30%.

b) Perform formatting

c) Compute ‘Quiz Total’ and ‘Assignment Total’ by applying appropriate formulas. 

d) Change the percentages of mid-term and final exam according to the given requirement.

e) Compute ‘Grand Total’

3. VLOOKUP Formula

Compute grades by using VLOOKUP formula.

4. COUNTIF Formula

Compute occurrence of each grade by using COUNTIF formula.

5. Create Graph

Requirements

Basic knowledge of Teacher Tools is required to start this course, as this is an intermediate level course.

This course is for

This course was made for intermediate-level students.

How much does the Microsoft Excel for Teachers course cost? Is it worth it?

You can enrol in this course with a Skillshare subscription that costs $8/month, but you start with a FREE 7-day trial. You can also enrol in thousands of courses on a variety of topics with your subscription, including several Teacher Tools courses.

Does the Microsoft Excel for Teachers course have a money back guarantee or refund policy?

There is no money-back guarantee with Skillshare, but you can start with a free one-week trial to learn without risk. With the subscription, you can download classes to your tablet or phone using the Skillshare app.

Are there any SCHOLARSHIPS for this course?

At the moment we couldn't find any available scholarship forMicrosoft Excel for Teachers, but you can access more than 30 thousand classes for $8/month on Skillshare, including this one!

Who is the instructor? Is Humera Ghani Khan a SCAM or a TRUSTED instructor?

Humera Ghani Khan has created 2 courses that got 2 reviews which are generally positive. Humera Ghani Khan has taught 125 students and received a 3.5 average review out of 2 reviews. Depending on the information available, Humera Ghani Khan is a TRUSTED instructor.

7.8

CourseMarks Score®

6.0

Freshness

N/A

Feedback

9.1

Content

Platform: Skillshare
Video: 37m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Microsoft Excel for Teachers rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/microsoft-excel-for-teachers/" target="_blank" title="Microsoft Excel for Teachers on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/cmrated.svg" width="200px" alt="Microsoft Excel for Teachers rating"/></a>