AB0403 Outlines PDF

Preview

Summary

Download AB0403 Outlines PDF

Description

Nanyang Technological University Nanyang Business School AB0403 Decision Making with Programming and Data Analytics

Semester 2, AY2019-20 Academic Unit: 3.0 Pre-requisite: Course Description & Scope This is an introductory course designed for business or accountancy undergraduate student who has no programming background and is interested to learn how to manage data and conduct business analytics programmatically. It is oriented to enhance your technical skillset. The aim of this course is to provide a broad understanding on how to manage data, the process of preparing data for analysis, basic of analytics, and the means to communicate analytics outcome. This course will equip you with the ability to write customized solutions to inform business decision, integrate statistical libraries for data analysis, and construct visuals or reports for business understanding. This module will provide you with individual hands-on practices to hone your coding skillset and opportunity to develop coding solution in a team. We utilize Python language as the medium of learning because it is one of the most in-demand coding language and its user-friendly syntax is well suited for beginner level. You will utilise modern development tools to turn information into insights. Intended Learning Outcomes (ILO): By the end of this course, you (as a student) would be able to: 1.

Interpret different elements of programming components like programming syntax, control structures, data types and design methods.

2.

Write codes that allow you to solve simple business problem programmatically.

3.

Construct data models that connect external data model to codes.

4.

Derive analytics outcome from managing data.

5.

Present data graphically that aid and support decision with appropriate statistical and graphing modules or use visualization software.

Learning and Teaching Method This course adopts a blended learning approach where asynchronous e-learning and synchronous teaching in seminar setting are combined to achieve learning objectives. You will learn through a wide range of learning materials, such as online references, textbooks, videos, pre-readings, in-class activities, coding discussion and group work. Students are to complete pre-seminar materials prior to each week of seminar. - Total 13 sessions. 1

-

Weekly online 1 hour of LAMS video lesson to be completed before seminar. Weekly 2 hours of seminar. Course starts in week 1.

Course Assessment Component

ILO Tested

Weightage

1. Class Participation 2. LAMS Attempts 3. Assignment 4. Practical Assessment (PA) 5. Project

1, 2

15%

Team / Individual Individual

1, 2, 3

10%

Individual

1, 2, 3 1, 2, 3

15% 30%

Individual Individual

4, 5

30%

Group1

Assessment Rubrics See Rubric 1

See Rubric 2 See Rubric 3

See Rubric 4, 5

1Group

project: All team members must present. Peer evaluation will be incorporated. Peer evaluation will adopt the use of peer evaluation form as attached in Rubrics 5 to assess individual team member’s contribution. It will be a mandatory submission for all students. Each student is required to fill in the percentage of contribution of all team members in the same group. Readings and References You may refer to any resources that aids your understanding, some suggested references are listed below. Recommended Online Reference:

(PT) Python 3 Tutorial: https://docs.python.org/3/tutorial/ (SQ) SQLite Library: https://www.sqlite.org/index.html (PL) Pandas Library: https://pandas.pydata.org/ (MP) Matplotlib Library: https://matplotlib.org/ Textbooks: (WP) William F. Punch, The Practice of Computing Using Python, 3rd Edition, 2017, Pearson, ISBN 9781-2921-6668-1. (ML) Mark Lutz, Learning Python, 5th Edition, 2013, O’Reilly Media, ISBN 978-1-4493-5573-9. (WW) William Wesley McKinney, Python for Data Analysis, 2nd edition, 2017, O’Reilly Media, ISBN 978-1-4919-5766-0.

2

Course Schedule Week 1

2

3

4

5

6

7

8

9

10

11 12 13

Topic Introduction & Programming Basic: • Installation and programming environment • Programming syntax • Variables • Basic data types Operators in Python and Debugging: • Mathematical operators • Comparison operators • Logical operators • Debugging and Exception Handling Control and Function: • Decision • Iterations • Function design Data Types: • String • List • Tuple • Dictionary File Input and Output: • List and Dictionary Comprehension • File reading and writing • Processing text/CSV files Structured Query Language (SQL): • SQL basic • Data Manipulation Language

Readings/ Activities

Connect Codes to External Data Source: • sqlite • Database programming

WP Chapters 5 ML Chapters 9 SQ PA I (29 Feb)

Recess Week Data Preparation & Descriptive Analysis: • Dataframe • Data wrangling • Data cleaning • Descriptive analysis Data Visualization: • Plotting in Python • matplotlib Object Oriented Programming: • Object • Class • Inheritance Revision & Practical Assessment: Web Scraping (eLearning) Project Presentation

3

Installation guide; WP Chp 1; ML Chp 2, 3

WP Chp 1, 2

WP Chp 2, 5 ML Chp 12, 13, 16

WP Chp 7 ML Chp 7, 8

WP Chp 7, 9 ML Chp 14 SQL Documentation

WW Chp 4, 5, 7 PL Documentation

MP Documentation

WP Chp 11, 12 ML Chp 25 PA II (3/4 Apr)

Rubric 1 (Participation) Traits

Performance 2

1

Engagement

Contribution frequency

Contribution quality

3 Engages fully in class

Hardly focuses in class (e.g. using mobile phone, unnecessary chatting)

Occasionally engages in distracting activities (e.g. using mobile phone, unnecessary chatting) in class.

Does not speak up/contribute in class

Occasionally speaks up/contributes in class

Speaks up/contributes in all classes

No contributions/Contri butions lack substance

Contributions demonstrate knowledge of subject matter

Contributions are constructive and insightful

Rubric 2 (Assignment) Traits

Demonstrates understanding in data types

Performance Not Yet Does not demonstrate understanding of programming. Confuse about the usage of data types. Evaluation: Not Yet 1

2

3

Substantially Developed Able to differentiate and use suitable data types in programming. Make good judgement base on the given problem. Good naming convention and coding practice. 4

5

Not Yet Does not demonstrate Demonstrates ability of ability to use coding using appropriate coding element. elements. Evaluation: Not Yet 1

Demonstrates ability to draw relevant reference to solve the problem

2

3

4

5

Not Yet Does not demonstrate or not able to understand references. Evaluation: Not Yet 1

2

3

4

6

7

8

9

10 Substantially Developed

Substantially Developed Excellent use of good coding practice, effective application of coding elements and algorithm. Good use of control structures, iteration and function design.

4

6

7

8

9

10 Substantially Developed

Substantially Developed Good understanding on the reference and quote external reference needed to solve the problem and ability to adopt it into different context. 5

6

7

8

9

10 Substantially Developed

Rubric 3 (Practical Assessment) Traits

Demonstrates understanding in data types

Performance Not Yet Does not demonstrate understanding of programming. Confuse about the usage of data types. Evaluation: Not Yet 1

2

3

Substantially Developed Able to differentiate and use suitable data types in programming. Make good judgement base on the given problem. Good naming convention and coding practice. 4

5

Not Yet Does not demonstrate Demonstrates ability of ability to use coding using appropriate coding element. elements. Evaluation: Not Yet 1

Demonstrates ability to draw relevant reference to solve the problem

3

4

5

6

Not Yet Does not demonstrate or not able to understand references. Evaluation: Not Yet 1

Devise strategies to construct proper model or code for analysis

2

2

3

3

4

5

7

8

9

10 Substantially Developed

4

5

7

8

9

10 Substantially Developed

Substantially Developed Good understanding on the reference and quote external reference needed to solve the problem and ability to adopt it into different context. 5

Not Yet No data model or code was developed to suitably aid the analysis.

Evaluation: Not Yet 1 2

6

Substantially Developed Excellent use of good coding practice, effective application of coding elements and algorithm. Good use of control structures, iteration and function design.

6

7

8

9

10 Substantially Developed

Substantially Developed Well-constructed solution and code and form comprehensive analysis which examine the data from different perspectives.

6

7

8

9

10 Substantially Developed

Rubric 4 (Group Project) Traits

Demonstrates a basic understanding of essential coding elements

Performance Not Yet

Substantially Developed

Does not demonstrates understanding on coding basic.

Excellent use of good coding practice, effective application of coding elements and algorithm. Good use of control structures, iteration and function design.

Evaluation: Not Yet 1 2

Analyses and evaluates problem and implements appropriate solution

Relevant Content

4

5

6

7

8

9

10 Substantially Developed

Substantially Developed

No analysis of problem and no solution is provided. Contradicting analysis is given.

Excellent analysis of problem and propose well supported solution. Solution illustrates coherent understanding to solve the problem. Provides convincing analysis and solution.

Evaluation: Not Yet 1 2

Identifies and assesses the quality of data and provides additional analysis related to the issue.

3

Not Yet

3

4

5

6

7

8

9

10 Substantially Developed

Not Yet

Substantially Developed

Merely repeats information provided, taking it as truth, or denies evidence without adequate justification. Analyses inadequately and understanding of the data.

Examines the data and source of evidence; questions its accuracy, precision, relevance, and completeness. Carefully examines data with substantiated analysis supported by evidence.

Evaluation: Not Yet 1 2

3

4

5

6

7

8

9

10 Substantially Developed

Not Yet

Substantially Developed

Content is erroneous or irrelevant; references and supporting materials are absent. Lacks of depth in content and little insights are exhibited. Presentation falls outside set time parameters. Lack of appropriate visualization.

Content is accurate, thorough, and directly on point; strong support and references are provided. Exhibits depth and insight in content. Effective use of time and stays within time parameters. Excellent use of visualization to present data.

Evaluation: Not Yet 1 2

3

4

6

5

6

7

8

9

10 Substantially Developed

Rubric 5 (Peer Evaluation) CONFIDENTIAL PEER EVALUATION FORM FOR TEAM PROJECT

Member’s name: Seminar group and team number: Please use the attached Peer Evaluation Rubric to evaluate yourself and your team members on each of the 5 stated attributes (on a scale of 1 to 7). State your ratings for yourself and each of your team members in the table below. For your self-assessment, insert “(Self)” after your name in the table below. Index #

Name of team members

1 - RR

2 - CM

3 - CR

4 - CT

5 - RS

Average Rating

1 2 3 4 5 6

If any of your ratings above is < 4, please provide a brief explanation to justify the ratings. Index #

Brief explanation to justify a rating of < 4

You may attach supporting documents (like emails and screen shots), if any, to support your explanations above.

7

Teamwork & Interpersonal Skills (Peer Evaluation) Rubric Learning Objective: The ability to work effectively with others in a group setting. Traits 1. Roles and Responsibility (RR) Behaves professionally by upholding responsibility and assuming accountability for self and others in progressing towards the team’s goal. 2. Communication (CM) Identifies appropriate mechanisms to coordinate and correspond with team members. 3. Conflict Resolution (CR)

Performance Substantially Developed Always fulfills responsibilities; performs his/her role within the group with enthusiasm and demonstrates willingness to work collaboratively.

Scant Unclear about his/her own role; refuses to take a role in the group; insists to work individually and has limited coordination or communication with others. Evaluation: Scant 1

2

3

4

Scant Modes of communication are not appropriate, causing confusion and miscommunication among team members. Evaluation: Scant 1

2

3

4

Contributes positive input for the team; effectively utilizes one’s knowledge and expertise. 5. Relationship (RS) Maintains cooperative interaction with other team members regardless of individual /cultural differences and respects diverse perspectives.

2

3

4

Scant Largely disinterested in working in a group and refuses to participate; observes passively or is unwilling to share information with other team members. Evaluation: Scant 1

5

6

7 Substantially Developed

2

3

2

5

6

7 Substantially Developed

Substantially Developed Actively attends and participates in all activities and provides meaningful contribution in articulating ideas and opinions. 4

Scant Rarely listens to others and does not acknowledge the opinions that differ from his/her own. Evaluation: Scant 1

7 Substantially Developed

Substantially Developed Consistently resolves conflicts through facilitating open discussion and compromise.

Resolves conflicts using a variety of approaches.

4. Contributions (CT)

6

Substantially Developed Modes of communication are appropriate, and maintaining timely communication and correspondence with team members.

Scant Does not recognize conflicts or is unwilling to resolve conflicts. Evaluation: Scant 1

5

5

6

7 Substantially Developed

Substantially Developed Engages in respectful relationships with all other members in the team. Embraces and accepts diverse points of view without prejudice. 3

4

5

6

7 Substantially Developed

References: Teamwork Value Rubric - Association of American Colleges and Universities. Retrieved from http://www.aacu.org/value/rubrics/pdf/teamwork.pdf

8...