Lab2

docx

School

San Jose State University *

*We aren’t endorsed by this school

Course

104

Subject

Electrical Engineering

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by CountWolfMaster424

San Jose State University Department of Electrical Engineering EE104, Fall 2022, Pham Laboratory Assignment #2 Objectives This lab introduces you the art of integration a few tools that you are already familiar to provide a business solution that you can use in the real life application. In this lab, we will implement a COVID-19 registration GUI using a new method, a simple database application using Excel, an email method to send a reminder emails for the 2 nd vaccination shot, and a text method to send a reminder text message to a given phone number for the 2 nd vaccination shot. Grading Refer to the section Python Programming for grading criteria. Bibliography I would like to acknowledge the Python open-source community and respective suppliers for making the material available. Jose Estrada Ramirez from EE104 Spring 2021 contributed some parts to this lab. References: https://www.simplifiedpython.net/python-gui-login/ https://stackoverflow.com/questions/46268167/how-to-search-for-data-in-an-xlsx-file-using-python-3 https://pythonguides.com/python-tkinter-label/ https://stackoverflow.com/questions/42491486/setting-an-image-as-a-tkinter-window-background https://www.geeksforgeeks.org/python-simple-registration-form-using-tkinter/?ref=rp https://riptutorial.com/tkinter/example/29713/grid--#:~:text=tkinter%20grid()&text=The%20grid()%20geometry%20manager,%2C%20row%20%2C %20rowspan%20and%20sticky%20 . https://stackoverflow.com/questions/17267140/python-pack-and-grid-methods-together https://northernlights.imanet.org/home?ssopc=1 https://www.freecodecamp.org/news/exception-handling-python/ https://www.twilio.com/docs/sms/quickstart/python https://medium.com/paul-zhao-projects/sending-emails-with-python-c084b55a2857 High-level Process It is time for a person to receive a COVID19 vaccination. The following is a typical process in the Santa Clara County. 1. IT staff creates 2 databases. One for medical staff admins, and one for patient records. 2. IT staff creates an admin record for a medical staff and save the information to the staff database. 3. The medical staff creates a patient record and saves in the patient database with name, DOB, phone number, email, etc. 4. The medical staff administer a vaccination shot for the patient, and log in today’s date. a. At this time, the patient database saves the first shot record, and automatically schedule the 2 nd shot for 21 days later. b. An IT automated messaging service sends the first text message to the patient congratulating on the 1 st vaccination, and show the date for the 2 nd shot. c. An IT automated email service sends the first email to the patient congratulating on the 1 st vaccination, and show the date for the 2 nd shot. 5. Three days before the 2 nd appointment: a. An IT automated messaging service sends the reminding text message to the patient for the 2 nd shot date. b. An IT automated email service sends the reminding email to the patient for the 2 nd shot date Of course the process continues for the 3 rd and 4 th shots, but we will stop at Step 5 above because when you know how to do it to this point, you can extend the program to any number of steps. Because of the text messaging and email services, you will need to leverage 3 rd party tools. Continue to the next sections below. 1

Download, Installation, and Licensing 1. Install necessary Python packages You will need to PIP INSTALL the followings: pip install twilio Reference to https://www.twilio.com/the-current/what-is-twilio-how-does-it-work , we will use Twilio to send SMS phone messages. Invoke Anaconda Powershell Prompt Type pip install twilio at the prompt. 1. Procedure to create a free-trial Twilio Account Overview WITH TWILIO YOU CAN BUILD:  SMS marketing  Omnichannel contact center  Call tracking  Web chat  Push notifications  Alerts and notifications  Phone verification 2

Application: Lab 2 to send SMS text messages Procedure to create a free-trial Twilio account Go to https://www.twilio.com/try-twilio and fill out the form: You will receive an email with a link to confirm your email. Click on the link or copy and paste the URL into a browser to confirm: Then you can log in Now you must provide a phone number to start the free trial: 3

Your preview ends here