SCMS 3711
Business Analysis - Tools
Module 3 Review
Pivot Tables, Dashboards,
And Forecasting
Chapters 3 & 9
1
Topics
Chap 3: Pivot Tables
– Show Values As; Summarize Values As
– Grouping
– Slicers & Timelines
– Dashboards
Chap 9: Forecasting
– Methods
– Error Measurements
2
Quiz and Exam Info
If we didn’t cover it (i.e., not on our slides),
it’s not tested (homework, quiz, or exam)
The results become available just after
midnight the day the quiz or exam closes
3
Module 3
Practice Quiz Summary
Items Points
10 concept, 30
True / False, Multiple Choice
7 calculation 35
65
• This practice quiz does not count towards
your grade at all
• This 120 min quiz has the same number of
questions and problems as the actual quiz
• There are an unlimited number of attempts
4
Quiz 3 Summary
Problems Points
10 concept, simple calculation 30
True / False, Multiple Choice
7 calculation 35
65
• Quiz scores are usually low because it’s the first
time you have seen all of this material together in
one place and in a time limit
• This 120 minute quiz has one attempt
• Exams scores are almost always much higher
5
Exam 3 Summary
Problems Points
11 concept, simple calculation 31
True / False, Multiple Choice
7 calculation 35
66
Maximum points = 60
• This 120 minute exam has one attempt
• Only the first 60 points count towards
your grade
6
Exam Scoring (not Quiz)
SO:
If you score 62 out of 66,
you earn 60 out of 60 (100.00%)
If you score 48 out of 66,
you earn 48 out of 60 ( 80.00%)
You’ll see two entries in the gradebook:
62 out of 66 (0%) and 60 out of 60 (17%)
or 48 out of 66 (0%) and 48 out of 60 (17%)
Questions?
