This laboratory procedure can be completed in two weeks (4 three-hour labs). The students are instructed to collect literature research, process data, write reports, and receive additional instruction outside of class time if needed. The SIR model and a modified version SIRV model which considers vaccination rates are introduced and practiced. Pre-laboratory instruction about the SIR model along with information about the history of mathematical modeling in the study of pandemics is necessary to explain the practical usefulness to the students. Microsoft Excel is the only computational program required to conduct this laboratory. While it could be conducted just the same with other programs that allow for data modeling, some students at the undergraduate level find themselves more familiar with Excel than other programs. The loan mortgage calculations are practiced in Excel at the beginning to warm up the students about model simulations in Excel, which has been explained in details in our previous publication. Students will also need to source and download data of COVID case numbers and vaccination rates of the region or regions they are designated to. This could be a state in the United States, it could be just the city of New York, or it could be an entire nation. The only real requirement is that the region being examined has reliable and easily accessed data on COVID case rates per day and vaccination rates. We instructed students to use a state in the United States as their region of interest for this procedure. Both COVID-19 cases and vaccination data in the U.S. are originated from U.S. Centers for Disease Control and Prevention (CDC). The COVID cases are summarized and downloaded from Github site of the New York Times. The vaccination data is downloaded from Our World in Data's State by State data on Covid-19. Both are accessed and downloaded around Jan. 27, 2022 with no further modifications except for sorting over states and time. The pretreatment of the data includes running smooth for a 7-day period from three days before to three days after a given day and filling the gaps of data by copying the available ones before them. Five days are added before the first date and assume one case during these five days. Data is checked and download again on April 14, 2022 after the analysis has been done to check the predictions. The SIR model follows a flow quite like the kinds of simple diagrams you may see drawn out in a modern chemistry textbook showing you the simplest model of chemical reaction kinetics (Figure ). In the model (Figure ), given a set of data with S, I, R in the unit number of people in a community, the two rate constants β/N and γ are the key parameters to predict the spreading trend of the disease. β refers to the average infection frequency of any given carrier and γ the frequency of removing an infected carrier. Both will have units of days -1 as the data provided by public and private sources on the spread of the virus will be most often in days. Students will be working with N refers to the total population of their assigned region.