Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

preview_player
Показать описание

See:
1. (00:10) How Decaying Average in Standards-Based Grading works
2. (02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References
3. (04:02) Explaining logic of how IF function works. See LEN Function to check and see what IF function actually puts into the cell.
4. (05:30) Calculating in Excel Method 2: One formula that use two IF functions and Absolute Cell References, and the column Header is empty
5. (07:17) Calculating in Excel Method 3: One formula that use two IF functions, ISTEXT function and Absolute Cell References, and the column Header contains text
6. (08:05) Calculating in Excel Method 4: One formula that use two IF functions and Absolute Cell References, and the column Header contains a zero with Custom Number Formatting to show the text “Decaying Ave.”
  1. excelisfun
  2. Highline College
  3. Mike Girvin
  4. excelisfun
  5. Michael Girvin
  6. Mike excelisfun Girvin
Рекомендации по теме
Excel Magic Trick 0:09:53

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel

Excel Magic Trick 0:07:08

Excel Magic Trick 1176: CONVERT Function to convert units in Excel (Excel CONVERT Joke at 05:27)

Excel Magic Trick 0:03:06

Excel Magic Trick 1171: SUMIFS & SUMIF Treat 0500 & 00500 the Same! Use SUMPRODUCT Instead

Excel Magic Trick 0:04:47

Excel Magic Trick 1165: Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Function...

Drop Down List 0:03:24

Drop Down List in Excel

Excel Magic Trick 0:13:14

Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

How To Create 0:03:12

How To Create A Grade Book with Weights in Excel

Excel Gradebook Printouts 0:04:00

Excel Gradebook Printouts

Semester Scoring - 0:06:42

Semester Scoring - Weighted Percentages (CCP)

Gradebook-Grading a Standards 0:07:58

Gradebook-Grading a Standards Based Assignment

UEN Canvas Outcomes 0:05:38

UEN Canvas Outcomes

Canvas - Weighting 0:03:24

Canvas - Weighting Grades

Grade Blender: Microsoft 0:20:34

Grade Blender: Microsoft Excel Gradebook for Standards Based AND Traditional Grading

Excel 2013 -video 0:09:22

Excel 2013 -video 1 - Match and Index Functions in one formula

Introduction to Standards-based 0:05:50

Introduction to Standards-based Grading

How to set 0:09:03

How to set up your Excel Standards Based Grading grade book

Hitung Jumlah Laki 0:07:12

Hitung Jumlah Laki Laki dan Perempuan Berdasarkan Alamat Desa

Vlog: Quit Averaging 0:00:43

Vlog: Quit Averaging Grades

Excel 2013 Statistical 0:05:23

Excel 2013 Statistical Analysis #46 Standard Error: Standard Deviation of Xbar Sampling Distribution

EDU 2.0 for 0:07:52

EDU 2.0 for Proficiencies or Standards Based Grading

Using a Standards 0:10:33

Using a Standards Based Gradebook

Automate State Standards 0:01:19

Automate State Standards Tracking and Standards Based Report Cards

My foray into 0:09:20

My foray into Standards Based Grading

Creating a Mastery-based 0:02:51

Creating a Mastery-based Grade Book

Комментарии
Автор

Excel Magic Trick 1175: Decaying Average in Standards-Based Grading in Excel
See:
1. (00:10) How Decaying Average in Standards-Based Grading works
2. (02:00) Calculating in Excel Method 1: Two formulas that use IF function and Absolute Cell References
3. (04:02) Explaining logic of how IF function works. See LEN Function to check and see what IF function actually puts into the cell.
4. (05:30) Calculating in Excel Method 2: One formula that use two IF functions and Absolute Cell References, and the column Header is empty
5. (07:17) Calculating in Excel Method 3: One formula that use two IF functions, ISTEXT function and Absolute Cell References, and the column Header contains text
6. (08:05) Calculating in Excel Method 4: One formula that use two IF functions and Absolute Cell References, and the column Header contains a zero with Custom Number Formatting to show the text “Decaying Ave.”

excelisfun
Автор

Do you have concerns that it appears as though you are taking averages of averages. Is that mathematically sound?

MarkPhillipsgms
Автор

Thanks Mike. I'm with pmsocho I have never used decaying average.

krn
Автор

Great! I have never used Decaying Average. Shame on me!

pmsocho
Автор

The math is incorrect. For scores of {4, 3, 3, 4}, the decaying average should be avg(4+3+3) *.35 + 4*.65 = 3.766. You can't just take the previous weighed average as the new average to be weighed again.

jellioso