Course Syllabus
Below is a syllabus template that includes WSU's required syllabus elements. Please complete all items highlighted in yellow.
Title of Course [Data Management, Analysis & Visualization]
Prefix and Number [ECONS 215]
Semester and Year [tbd]
Number of Credit Hours [3]
Prerequisites [Econs 101 or 198]
Course Details
Day and Time: [tbd]
Meeting Location: [tbd]
Instructor Contact Information
Instructor Name: [tbd]
Instructor Contact Information: [office location, phone, email] [tbd]
Instructor Office Hours: [click here for best practices] [tbd]
TA Name: [tbd]
TA Contact Information: [office location, phone, email]: [tbd]
TA Office Hours: [click here for best practices] [tbd]
Course Description
[Course Prerequisite: EconS 101 or 198. This course is designed to develop data management, analysis and visualization skills for students, primarily through the software Microsoft Excel. The course is intended to be taught within a computer lab setting, with one day per week of lecture/explanation and one day completing the hands-on assignment (homework).]
Course Materials
Books: [None]
Other Materials: [None]
Fees: [None]
|
Course Learning Outcomes (students will be able to:) |
Activities Supporting the Learning Outcomes | Assessment of the Learning Outcomes |
|---|---|---|
| [Understand the value of being proficient at basic analytical capabilities utilizing Excel and solving practical problems utilizing Excel functions and capabilities.] | [Students will solve specific problems within excel, in a computer lab with instructor oversight and guidance. These problems and applications originate from real-world applications.] | [Lab Assignments, quizzes and exams] |
| [Being able to transform raw data into meaningful business and economic intelligence and solve specific, real -world problems.] | [Students will solve specific problems within excel, in a computer lab with instructor oversight and guidance. These problems and applications originate from real-world applications.] | [Lab Assignments, quizzes and exams] |
| [Develop various data visualizations and apply the outcomes in decision making.] |
[Students will develop a wide variety of data visualizations, including bar, line and area charts, scatter plots, stacked, two/three dimensional visualizations.] |
[Lab Assignments, quizzes and exams.] |
| Develop dynamic dashboards to inform/educate target audiences. |
Students will develop a variety of data dashboards for reporting different types of information, including market prices, financial assessment, risk assessment, production activities, etc. |
Lab Assignments, quizzes and exams. |
| Complete advanced scenario analysis, incorporating solver, what if analysis and goal seek functions. |
Students will solve optimizations for a variety of applications in scheduling, processing, transportation, simulation, etc. |
Lab Assignments, quizzes and exams. |
| Dates | Lesson Topic | Assignment | Assessment |
|---|---|---|---|
|
Week 1 |
[Introduction to the Basic Functions of Excel] |
a. Learning spreadsheet fundamentals and commands. b. Learning formatting spreadsheet layout c. Customizing spreadsheets d. Optimal spreadsheet design |
[Lab Assignments] |
| Week 2 [dates] |
[Introduction to Basic Functions of Excel] |
[a. Customizing spreadsheets b. Optimal spreadsheet design |
[Lab Assignments] |
| Week 3 [dates] |
[Introduction to Data Analysis |
[a. Importing different data files & formats. b. Reformatting data c. Transforming and Logical Functions |
[Lab Assignments and Quiz] |
| Week 4 [dates] |
[Financial Analysis, Functions and Concepts] |
[a. IDepreciation b.Deflating Data c. Accrued Interest Calculation ] |
[Lab Assignments & Exam] |
| Week 5 [dates] |
[Financial Analysis, Functions and Concepts |
[a. Amortization b. Future Value c. Yield Calculations |
[Lab Assignment] |
| Week 6 [dates] |
[LP Optimization Applications] |
[a. Inventory Control b. Manufacturing] |
[Lab Assignments] |
| Week 7 [dates] |
[LP Optimization Applications] |
[a. Transshipment Models b. Assignment Models c. Max-Flow Models] |
[Lab Assignments & Quiz] |
| Week 8 [dates] |
[LP Optimization Applications] |
[a. Shortest Path Model b. Minimal Span Tree Model] |
[Lab Assignments & Exam] |
| Week 9 [dates] |
[Statistical & Data Analysis Applications] |
[a. T-test, ANOVA & descriptive statistics b. Regressions |
[Lab Assignments] |
| Week 10 [dates] |
[Statistical & Data Analysis Applications] | [Forecasting & Prediction] | [Lab Assignments] |
| Week 11 [dates] |
[Creating Visual Graphics] |
[a. Charts and Figures b. Plots, Bubble, Waterfall c. Funnel Graphics] |
[Lab Assignments] |
| Week 12 [dates] |
[Creating Visual Graphics] |
[a. Combination, Multi-Axis Graphs and Figures. b. Formatting Graphics] |
[Lab Assignments & Quiz] |
| Week 13 [dates] |
[Creating Data Dashboards] |
[a. Designing for various audiences. b. Data feeds and reporting metrics cations and changes.] |
[Lab Assignments] |
| Week 14 [dates] |
[Transitioning Away from Spreadsheets] | [Relational database structures] | [Lab Assignments] |
| Week 15 [dates] |
[Transitioning Away from Spreadsheets |
[MySQL, Microsoft SQL Server and Oracle. Introduction to R and Python.] | [Lab Assignments & Final Exam] |
Expectations for Student Effort
[Describe how much time students should expect to invest in the course each week. Graduate courses should state: "For each hour of lecture equivalent, students should expect to have a minimum of two hours of work outside of class." Note that Global campus courses will automatically include credit hour equivalents in the syllabus.] [
As a general rule, you should expect to spend approximately 3 hours per week for
each credit hour of a class. Since this is a 3 credit hour class, you should expect to spend 9 hour per week on this class attending lectures, labs, reading material and working assignments.
]
Grading [add more lines if necessary]
| Type of Assignment (tests, papers, etc) | Points | Percent of Overall Grade |
|---|---|---|
| [In-lab Assignments] | [40] | [40%] |
| [Quizzes] | [25] | [25%] |
| [Exams] | [35] | 35%] |
| Total | 100 | 100% |
| Grade | Percent | Grade | Percent |
|---|---|---|---|
| A |
93.4 - 100%] |
C | [73.4 -76.5%] |
| A- | [90.0 - 93.3%] | C- | [70.0 - 73.3%] |
| B+ | [86.6 - 89.9%] | D+ | [66.6 - 69.9%] |
| B | [83.4 - 86.5%] | D | [60.0 - 66.5%] |
| B- | 80.0 - 83.3%] | F | [Below 60%] |
| C+ | [76.6 - 79.9%] |
[Provide information about how grades will be rounded (eg, if 89% earns a B+ and 90% earns an A-, what grade is given to a student with an 89.5?]
Attendance and Make-Up Policy
[Provide details on how attendance affects final course grades. Indicate whether and how missed exams, laboratory sessions, etc. can be made up. Sample attendance statement: “Students should make all reasonable efforts to attend all class meetings. However, in the event a student is unable to attend a class, it is the responsibility of the student to inform the instructor as soon as possible, explain the reason for the absence (and provide documentation, if appropriate), and make up class work missed within a reasonable amount of time, if allowed. Missing class meetings may result in reducing the overall grade in the class.” ] [While there is no required attendance for this class, I will occasionally give extra credit for attending class. This will be sporadic and will add a bonus point onto the next test grade. There is no chance to make up any attendance points.]
Academic Integrity Statement
You are responsible for reading WSU's Academic Integrity Policy, which is based on Washington State law. If you cheat in your work in this class you will:
-[fail the exam or assignment, will not have the option to withdraw from the course pending an appeal, and will be reported to the Office of Student Conduct.]
-Be reported to the Center for Community Standards
-Have the right to appeal my decision
-Not be able to drop the course of withdraw from the course until the appeals process is finished
If you have any questions about what you can and cannot do in this course, ask me.
If you want to ask for a change in my decision about academic integrity, use the form at the Center for Community Standards website. You must submit this request within 21 calendar days of the decision.