| No. | Lecture's ／ Class Theme and Description | Lecture's ／ Class Goal | Homework（Preparation） | Homework（Review） |
| 1 | guidance | After understanding and being convinced of the contents of the syllabus, you can take this lecture. | Read the syllabus posted on the web in advance before attending the class. | Read the materials posted in class and write down your questions. |
| 2 | Data analysis steps, data analysis preparation (data shape, type, population and sample, data collection, data cleansing) | Understand and practice what you need to prepare for before engaging in data analysis in Excel. | Read Chapter 1 of the textbook (before starting data analysis) and Appendix (Let's format data suitable for analysis). | Review the content of the class and review the parts that you did not understand enough. |
| 3 | Data observation/trend (descriptive statistics: typical, mean, variance/standard deviation, minimum/maximum value) | Understand "descriptive statistics" that grasp trends and characteristics from data, and utilize representative methods in Excel. | Read Chapter 2 of the textbook (Start by identifying trends in the data). | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 4 | Data visualization (1) (cross tab, bar chart, line chart, pie chart, stacked chart) | You can use Excel's pipot tables and graphing functions to visualize data. | Read Chapter 3 (Let's visualize data) Step1 (Visualize data), Step 2 (Create a summary table using a pipot table), and Step 3 (Visualize the size, transition, and percentage of data) of Chapter 3 (Let's visualize data). | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 5 | Data visualization (2) (histogram, heat map, time series data analysis) | You can visualize data by utilizing Excel's graphing function and analysis tools. | Read Chapter 3 (Let's visualize data) of Step 4 (Visualize using heat maps), Step 5 (Visualize the distribution of data), and Step 6 (Visualize the movement of time series data) of the textbook. | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 6 | Hypothesis test (1) (Hypothesis test is t-test, F-test) | After understanding the concept of hypothesis testing, you can perform tests using Excel analysis tools. | Read Chapter 4 (Let's Formulate a Hypothesis and Test) Step 1 (Formulate a Hypothesis) and Step 2 (Compare the Average Sales of Two Stores) of the textbook. | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 7 | Hypothesis test (2) (practice in test marketing) | Based on examples used in society (companies), it is possible to perform tests using Excel analysis tools. | Read Chapter 4 (Let's Formulate and Verify a Hypothesis) Step 3 (Check for Popular Products and Non-Popular Products) and Step 4 (Consider New Product Proposals) of the textbook. | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 8 | Data Analysis (1) (Scatter Plot, Correlation Coefficient, Simple Regression Analysis) | Understand methods for analyzing the relationship between two or more variables, and use Excel analysis tools to create scatter plots, correlation coefficients, and simple regression analysis. | Read Chapter 5 (Analyze Relationships to Find Business Hints) of Step 1 (Visualize Variable Relationships), Step 2 (Expressing Variable Relationships with Objective Numerical Values), and Step 3 (Check Points to Note for Correlation Analysis) of the textbook. | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 9 | Data Analysis (2) (Multiple Regression Analysis, Logistic Regression Analysis) | Understand the concepts of multiple regression analysis and logistic regression analysis, and be able to perform multiple regression analysis and logistic regression analysis by utilizing Excel analysis tools. | Read Step 5 (Analyze Survey Results) of Chapter 5 of the textbook (Let's analyze relationships and find business tips). | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 10 | Optimization (searching for the optimal solution by simulation) | After understanding the concept of optimization, you will be able to analyze optimization by using Excel analysis tools. | Read Chapter 6 of the textbook (Let's find the optimal solution by simulation). | Review the content of the class and review the parts that were poorly understood and the items that were not used sufficiently in Excel. |
| 11 | Data utilization practice (1) - Data collection (confirmation of data required for analysis, collection of target data) | You can examine open data (official statistics) and collect data of your interest. | Access the site "e-Stat" provided by the Statistics Bureau of the Ministry of Internal Affairs and Communications to understand the overview. | Complete a review of what you have learned in class and the collection of data of interest. |
| 12 | Data Utilization Practice (2): Data processing and analysis (data cleansing, sampling, creation of simple explanatory variables, analysis by descriptive statistics, tests, and regression) | Be able to analyze what you want to clarify from the collected data and interpret the results. | Based on the collected data, think about what you want to clarify through data analysis. | If there is an analysis that was insufficient in the class, analyze it and consider the analysis results. |
| 13 | Data Utilization Practice (3) - Interpretation and expression of data (expressing what was revealed from the analyzed data) | Be able to convey the results of data analysis in an easy-to-understand manner. | Summarize the results of data analysis in PowerPoint, etc. | Based on comments and reactions from others, summarize what can be used in future data analysis. |
| 14 | summary | Students will be able to look back on and organize the results they have learned in this class. | Organize what you've learned so far. | Think about how data analysis can be utilized in future university studies and society. |