This course focuses on using features of Microsoft Excel to create spreadsheet models of different kinds of problems. The course coversrepresentative topics on spreadsheet functions, modeling applications, data summarization and interpretation. The skills learnt in the course will facilitate analyzing and synthesizing data in an effective manner.
2. Student Learning Outcomes
· Be able to ….. understand the core concepts of spreadsheet modeling, and the various commands and applications that facilitate different kinds of analysis covered in the sessions.
· Be able to …. usethe spreadsheet applications effectively without any external assistance.
· Be able to …. reflect how problems are solved using a good model and applying a thorough analysis in a straightforward way.
· Be able to … meaningfully analyse data, and summarize information that have practical implications.
3. Required Text Books and Reading Material
Freund, SM, Jones M & Starks JL. Microsoft® Excel® 2013: Comprehensive, 1st Edition, Cengage Learning.
Gross, D. &Akaiwa, F. Succeeding in Business with Microsoft® Excel® 2013: A Problem-Solving Approach, Cengage Learning.
Kros, J. Spreadsheet Modeling for Business Decisions, Kendall Hunt Publishing Company
Winston, W. L., Microsoft Office Excel 2007 - Data Analysis and Business Modeling, Microsoft Press.
4. Tentative Course Coverage
· Introduction to Modeling · Basic Ms. Excel Functions · Data Lookup Functions · Location & Identifier Functions · Working with Text & Arguments · Working with Calendar · Offset Function · Indirect Function · Data Sorting – Filtering – Removing Duplicates · Conditional Formatting · Descriptive Statistics · Working with Data Tables · Decision Analysis and Simulation · Data Validation · Additional Statistical Applications
5. Evaluation
· Classroom Participation: 10% · Quiz (2): 30% · End-term examination: 40% · Group Assignment: 20%
6. Academic Integrity
Students involved in academic dishonesty will receive a minimum of ZERO on the particular component in which the infraction occurred. Academic dishonesty consists of misrepresentation by deception or by other fraudulent means. In an academic setting this may take any number of forms such as copying or use of unauthorized aids in tests, talking during examinations; aiding and abetting another student’s dishonesty; giving false information for the purpose of gaining credits; and resorting to free-riding in group activities. Depending upon the severity of incident, grade deductions or even worse outcome (like getting F) is also likely. Displaying in-appropriate behavior in class during session hours can also lead to marks or grade deduction or even F.
Created By: Alora Kar on 06/08/2016 at 11:41 AM Category: BM-I 2016-18 T-I Doctype: Document