Business Management with Marketing
Michelle_Michy
10_Seminar_Presentation_DecisionSupportSystem-MSExcel-Part21.pptxHaider Zuhair Bilal
BBE / BUS / LSBU
Seminar 10: Decision Support System
MS Excel – Part 2
(Laudon Chapter 12 & Valacich Chapter 6)
Outline
Review last week’s activities
Excel Exercises – Financial Forecasting
Review & Feedback - MIS Coursework (Individual Report)
Blogging throughout the session!
https://www.lynda.com/PowerPoint-tutorials/PowerPoint-From-Outline-Presentation/147021-2.html
Time: ~5 minutes
2
Review of Week 9
Excel Exercises – Timesheet Analysis and Income Projection
Review MIS Coursework Criteria & the ‘Individual Report Template’
Introduce the business case (10%)
Describe the IS Project (the business Challenge) (10%)
Discuss the proposed IS solution and its benefits (10%)
The impact of the IS solution and its limitations (10%)
Ethical issues & compliance with the IS solution (10%)
Social issues & compliance with the IS solution (10%)
Cybersecurity threats with using the IS solution (10%)
Proposed human & technological safeguards (10%)
Time: ~5 minutes
3
Excel Exercise: Financial Forecasting
How to complete a Financial Forecasting exercise
Time: ~50 minutes
Class presentation / discussion: They will need to complete it by themselves during the seminar time, can ask questions as well, while you are reviewing students’ coursework and providing them with feedback.
Please take the register while they are working on their excel exercise, using the shared students list SS.
4
Excel Exercise: Financial Forecasting
Your turn to complete the ‘Financial Forecasting’ exercise
Time: ~5 minutes
Show them the answers, but not the formulae. I will upload it next week or so.
5
Time: ~50 minutes
Highlight the 8 required criteria.
Please remember the Business case analysis criteria is not part of the requirements.
Click on the slide to open up the individual report template.
6
Debrief
Excel Exercises – Financial Forecasting
Review & Feedback - MIS Coursework (Individual Report)
Introduce the business case (10%)
Describe the IS Project (the business Challenge) (10%)
Discuss the proposed IS solution and its benefits (10%)
The impact of the IS solution and its limitations (10%)
Ethical issues & compliance with the IS solution (10%)
Social issues & compliance with the IS solution (10%)
Cybersecurity threats with using the IS solution (10%)
Proposed human & technological safeguards (10%)
Use the ‘Individual Report Template’
Paraphrase & avoid Plagiarism like the ‘plague’!
Time: ~5 minutes
7
