[rev_slider alias=”sahyadri”]

Spreadsheet Application in Business Analytics (SABA) Primer Program Sahyadri MBA (Sem III, 2019-20)

Sahyadri College of Engineering & Management, Sahyadri Campus, Adyar, Mangaluru – 575007, Karnataka, India.
SYLLABUS
  • Course Instructor

    Professor Ratan Gupta, B Tech, IIT KGP, CFA & FRM. He has 13 years of experience in Industry, taught at VCU Graduate programs and successfully coached CFA Level 1, 2 & 3 candidates as well as FRM Level 1 & 2 candidates.

  • Grading Scale

    >=91: A Grade; 81-90: B Grade; 71-80: C Grade; 61-70: D Grade; < =60 Unsatisfactory.

    Instructor reserves the right to curve the grade

  • Assessment Plan

    9 weekly assignment (excluding diagnostic test) with 11% weight each

Course Description: Most often students struggle in MBA program due to lack of clarity in foundation level Business mathematics and statistics concepts as well as spreadsheet skills. This certification program is particularly designed to overcome this difficulty by taking students through a series of business math and stat concepts as well as by carefully selected applications of such selected concepts. This program was originally designed to prepare Masters Students at the Virginia Commonwealth University (VCU) to be successful in MS in Finance, MS in Decision Analytics, MS in Global Marketing Management and MS in Information Systems programs.

 

Expected Learning outcome: At the end of the course, besides familiarity with Microsoft Excel, students will also refresh foundation level concepts in business Mathematics & Business Statistics.

 

Online Pedagogy: Students learn how to solve problems and underlying concepts from video lessons prescribed for the weekly assignment. Thereafter, students will solve Assignment problems in Excel and submit their answers for grading. Students can clarify doubts either by posting comments to the instructor or by chatting with instructor during pre-specified office hours. After the due date, students will receive graded assignments & learn from feedback comments and marks

 

Online Office hours by Course instructor (for doubt clarification): Two days a week 90 minutes each (days and timing will be notified at the beginning of each week)

 

Work Load: Students are expected to spend 2-3 hours per week preferably during evening during online-office hours to learn from video lessons and solve assignment problems. Students should follow the steps below while working on a typical assignment:

  • Step 1: Click the assignment link sent to you by the instructor
  • Step 2: login using your user name (your email ID) and password
  • Step 3: Reset your password (Recommended at the beginning of first assignment)
  • Step 4: Login again (If you have logged out)
  • Step 5: Download video lessons and assignment question files from the link provided
  • Step 6: Watch Videos lessons
  • Step 7: Solve assignment questions
  • Step 8: Clarify doubts with instructor/Subject Matter Expert during office hours on Zoom platform
  • Step 9: Login again (if you have logged out)
  • Step 10: Upload completed assignment file on or before the due date
  • Step 11: View your marks and download graded assignment file and review expert comments to understand where and how you lost marks

 

Certification:  Successful students will be awarded Certificate with grade

 

How to Enroll? Students will be registered into the program using the Name and official email id provided by the Institution. Once registered, students can login using unique username and password to download and upload assignment files.

 

DURATION & SYLLABUS: Nine weeks online program wherein students will be administered nine weekly assignments as below:

 

Technology Requirement: Students must have their own laptop with Microsoft Office 2007 or later or should use the computer lab provided by the Institution. Also, students must have access bandwidth provided either by the institution or personal bandwidth in order to download and upload assignment files and video lessons. Students will be sent Zoom invite for online office hour meetings.

Please download and install zoom in your desktop/laptop/mobile devices before joining a zoom meeting. Here is the link for zoom – https://zoom.us/download#client_4meeting

 

Zoom at Google Play Store: https://play.google.com/store/apps/details?id=us.zoom.videomeetings&hl=en

Zoom at App Store: https://apps.apple.com/us/app/zoom-cloud-meetings/id546505307

 

 

*Note: Assignment start and due dates & office our timings may change due to factors that affect College semester time table.

A1 - CELL REFERENCING (Aug 12 - 19, 2019)
  • Assignment Topic:

    Constructing Cell Formula to perform simple calculations & formatting Cells

  • Start Date | Due Date

    Aug 12, 2019 | 1PM Aug 19th

  • Online Office hours #1:

    Aug 14, Wed 7.30PM – 9PM

    Zoom Online Meeting: https://zoom.us/j/370618959

  • Online Office hours #2:

    Aug 16, Fri 7.30PM – 9PM

    Zoom Online Meeting: https://zoom.us/j/544306024

  • Online Video Lessons: Additional Reading/Viewing Materials

    Click here to download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Download Question File | Upload Answer File | Download Graded Answer File

    (Requires Log-in)

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss.  (Requires Log-in)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A2 - FUNCTIONS & LOGICAL FUNCTIONS (Aug 19 - 26, 2019)
  • Assignment Topic:

    Frequently used Functions, Logical Functions & Conditional Formatting

  • Start Date | Due Date

    Aug 19, 2019 | 1PM Aug 26th

  • Online Office hours #1:

    Aug 21, Wed, 7.30PM- 9PM

    Zoom Online Meeting: https://zoom.us/j/199260112  | View Office hour recording: Watch/Download

  • Online Office hours #2:

    Aug 23, Fri, 7.30PM -9PM

    Zoom Online Meeting: https://zoom.us/j/735122022 | View Office hour recording: Watch/Download

  • Online Video Lessons: Additional Reading/Viewing Materials

    Click here to download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Download Question File | Upload Answer File | Download Graded Answer File

    (Requires Log-in)

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this) in jeopardy.

  • Discussion:

    Click here to Discuss.  (Requires Log-in)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A3 - V&H LOOK UP; SORT & FILTER (Aug 26 - Sept 3, 2019)
  • Assignment Topic:

    Working with Data: V & H Lookup, Sort & Filter

  • Start Date | Due Date

    Start Date: Aug 26, 2019

    1st deadline (soft deadline): 11 PM, 1st Sept
    2nd deadline (hard deadline): 11 PM, 2nd Sept with penalty of 10% marks

  • Online Office hours #1: Webinar Lecture

    Aug 28, Wed, 7.30PM-9PM

    Zoom Online Meeting: https://zoom.us/j/540769446 View Webinar Recording: Watch/Download

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: Doubt Solving Session

    Aug 30, Fri, 7.30PM-9PM

    Zoom Online Meeting: https://zoom.us/j/169266692

     

    This online hour is meant for solving assignment problem. Your Course Instructor will be available online during this time to help you. If you face difficulty, then join zoom meeting and chat with instructor. Some times instructor will share you screen and explain where the mistake lies. We strongly encourage students to use this hour and aim to complete assignment at the end of this office hour.

  • Online Video Lessons: Additional Reading/Viewing Materials

    Click here to Download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Click here to Download Question File | Upload Answer File | Download Graded Answer File

    (Requires Log-in)

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this) in jeopardy.

  • Discussion:

    Click here to Discuss. (Requires Log-in)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A4 - LOAN & INTEREST RATES (Sept 3 - 9), 2019
  • Assignment Topic:

    Solving Loans and Interest Rate problems using Spreadsheets

  • Start Date | Due Date

    Sept 3, 2019 | 1PM Sept 3rd

  • Online Office hours #1: Webinar Lecture

    Sept 4, Wed, 7.30PM-9PM

    Zoom Online Meeting: https://zoom.us/j/768208084 View Webinar Recording: Watch/Download

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: Doubt Solving Session

    Sept 6, Fri, 7.30PM- 9PM

    Zoom Online Meeting: https://zoom.us/j/958087407

     

    This online hour is meant for solving assignment problem. Your Course Instructor will be available online during this time to help you. If you face difficulty, then join zoom meeting and chat with instructor. Some times instructor will share you screen and explain where the mistake lies. We strongly encourage students to use this hour and aim to complete assignment at the end of this office hour.

  • Online Video Lessons: Additional Reading/Viewing Materials

    Download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Download Question File | Upload Answer File | Download Graded Answer File

    (Requires Log-in)

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A5 - ANNUITY & PERPETUITY (Sept 9 - 16, 2019)
  • Assignment Topic:

    Solving annuities and perpetuity problems using Spreadsheets

  • Start Date | Due Date

    Sept 9, 2019 | 1PM Sept 16th

  • Online Office hours #1: Webinar Lecture

    Sept 11, Wed, 7.30PM-9PM

    Zoom Online Meeting: https://zoom.us/j/387524114  |  View Webinar Recording: Watch/Download

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: Doubt Solving Session

    Sept 13, Fri, 7.30PM-9PM

    Zoom Online Meeting: https://zoom.us/j/781426763

     

    This online hour is meant for solving assignment problem. Your Course Instructor will be available online during this time to help you. If you face difficulty, then join zoom meeting and chat with instructor. Some times instructor will share you screen and explain where the mistake lies. We strongly encourage students to use this hour and aim to complete assignment at the end of this office hour.

  • Online Video Lessons: Additional Reading/Viewing Materials

    Download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Click here to Download Question File | Upload Answer File | Download Graded Answer File

    (Requires Log-in)

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss  (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A6 - DEPRECIATION & AMORTIZATION (Sept 16 - 23, 2019)
  • Assignment Topic:

    Solving depreciation and amortization problems using spreadsheets

  • Start Date | Due Date

    Sept 16, 2019

    Sept 22, 2019, Sunday 11PM: Assignment due date without penalty

    Sept 24, 2019, Tuesday 11PM: Assignment due date with 10% penalty
  • Online Office hours #1: ONLINE CLASS

    Sept 18, Wed, 6PM-7.30PM

    Zoom Online Meeting: https://zoom.us/j/866506859      |     Watch Webinar recording: CLICK HERE

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: MARKS CLARIFICATION

    Sept 24, Tue, 6PM-7PM

    Zoom Online Meeting: https://zoom.us/j/218699161

     

    This online hour is meant for Feedback & Doubts clarification regarding marks awarded on the assignment assignment problem. Your Course Instructor will be available online during this time to help you. If you face difficulty, then join zoom meeting and chat with instructor. Some times instructor will share you screen and explain where the mistake lies. We strongly encourage students to use this hour and aim to clarify your  assignment doubts.

  • Online Video Lessons: Additional Reading/Viewing Materials

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    IMPORTANT – Your assignment link will be emailed to your email ID. Please update on WhatsApp if you dont receive the link by 7 PM Friday 20th September 2019

    Use the link sent through email to Download Question File,  Upload Answer File and Download Graded Answer File

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A7 - FREQUENCY DISTRIBUTION & PIVOT TABLES (Sept 23 - 30, 2019)
  • Assignment Topic:

    Constructing Frequency distribution, two-way tables using PIVOT Function

  • Start Date | Due Date

    Wednesday, Sept 25, 2019: Assignment Start Date

    Sept 29, 2019, Sunday 11PM: Assignment due date without penalty

    Sept 30, 2019, Monday 11PM: Assignment due date with 10% penalty
  • Online Office hours #1: ONLINE CLASS

    Sept 29, Saturday, 7PM – 8.30PM

    Zoom Online Meeting:  https://zoom.us/j/274031257        |        Watch webinar recording: CLICK HERE

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: MARKS CLARIFICATION

    Oct 3, Thursday, 8PM – 9PM

    Zoom Online Meeting:  https://zoom.us/j/860788831

     

    This online hour is meant for Feedback & Doubts clarification regarding marks awarded on the assignment assignment problem. Your Course Instructor will explain common mistakes made by the students in your class and answer marks related questions.

  • Online Video Lessons: Additional Reading/Viewing Materials

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Your assignment link will be shared by email or in WhatsApp.

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A8 - CENTRAL TENDENCY & DISPERSION (Sept 30 - Oct 9, 2019)
  • Assignment Topic:

    Computing Central Tendency and Dispersion statistics using Excel Functions

  • Start Date | Due Date

    Oct 3rd Thursday, 2019: A8 Assignment Start Date

    Oct 9th Wednesday 11PM: A8 Assignment Due Date

  • Online Office hours #1: ONLINE CLASS

    Oct 4, Fri, 7.30PM-9PM

    Zoom Online Meeting:  https://zoom.us/j/786016474        |        View Webinar Recording:  CLICK HERE

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: MARKS CLARIFICATION

    Oct 11, Fri,  8PM-9PM

    Zoom Online Meeting:  https://zoom.us/j/500258162

     

    This online hour is meant for Feedback & Doubts clarification regarding marks awarded on the assignment assignment problem. Your Course Instructor will explain common mistakes made by the students in your class and answer marks related questions.

  • Online Video Lessons: Additional Reading/Viewing Materials

    Click here to Watch/Download videos

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Your assignment link will be shared by email or in WhatsApp.

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

A9 - GRAPHS & CHARTS (Oct 9 - 14, 2019)
  • Assignment Topic:

    Representing data using Graphs and Charts

  • Start Date | Due Date

    Oct 10, 2019 Thursday: Start Date

    Oct 13, 2019 Sunday 11PM: Assignment due date without penalty

    Oct 14, 2019, Monday 11PM: Assignment due date with 10% penalty
  • Online Office hours #1: ONLINE CLASS

    Oct 10, Thu, 7 PM – 8.30 PM

    Zoom Online Meeting:  https://zoom.us/j/520013963         |       Watch Webinar Recording: CLICK HERE

     

    Course instructor will explain the underlying concepts and will go over the problem sets assigned for the week. At the end of this session, students may begin to solve the problem. We strongly encourage students to attend live meeting. If for any reason, some students can’t attend live session, then they can watch its recorded version before trying to solve assignment problems.

  • Online Office hours #2: MARKS CLARIFICATION

    Oct 18, Fri, 8 PM & 9PM

    Zoom Online Meeting:  https://zoom.us/j/527318541

     

    This online hour is meant for Feedback & Doubts clarification regarding marks awarded on the assignment assignment problem. Your Course Instructor will explain common mistakes made by the students in your class and answer marks related questions.

  • Online Video Lessons: Additional Reading/Viewing Materials

     

    These additional video lessons will be very useful to students who want to master the concepts in depth. Here concepts are explained elaborately and with more than one example. And these videos unlike webinars, are well designed to be excellent self help materials. Students can watch these videos before or after Webinar Lecture OR before or after submission. Learning from these videos goes beyond scoring marks in the assignment.

  • Assignment Link:

    Your assignment link will be shared by email or in WhatsApp.

     

    Students are encouraged to attempt these assignment questions independently. You can discuss amongst your small group or your classmate. But you SHOULD NOT simply ask your classmate to solve it for you. You SHOULD NOT submit your class mate’s work either in full or in part as your work. After any such discussion, YOU SHOULD ENTER THE ANSWER IN YOUR ANSWER FILE BY YOURSELF. DO NOT VIOLATE THIS HONOR CODE. If found violated, this puts your work in all assignments (including this one) in jeopardy.

  • Discussion:

    Click here to Discuss (Log-in required)

     

    This is the discussion forum for this assignment. Here you find previous discussions moderated by the course instructor. You will find answers to many of your doubts here as one or more of your seniors would have asked similar doubts. If, after a search, you could not find answer to your questions, then you can post here. Course instructor might answer your question or some of your classmates may answer your questions. At times specially staffed moderators answer your questions. You can also answer questions by your classmates here. We strongly encourage you to be active here. Because, being active here will get a special mention in the award of course completion certificate. Students can start posting on the forum at any time after the start date and can post even beyond its due date as we believe discussions can continue even after the assignment due date.

  • Overall Feedback Video:

    WILL BE SHARED IN WHATSAPP GROUP

     

    This video summarizes student answers for each one of the sub points in the assignment question. It tells you how many students got it right and how many didn’t. What are the most common mistakes committed by the students and how to avoid them in future, or sometimes, which are good practices and which aren’t. Ideally, students should download corrected answer file and feedback video in one sitting and then watch this video while reviewing your correct answer file.

CERTIFICATE DISTRIBUTION
  • DATE & PLACE:

    TO BE ANNOUNCED

  • CERTIFICATE OF COMPLETION:

    Certificate of completion will be issued to those students who have scored at least 60% on an average and should have submitted at least 6 out of nine assignments (excluding diagnostics test).

– Sample Certificate –