Final Project: Modality of the Students of UPRB

SICI 4997 - Special Topics and New Technologies

IDE: Python 3.9 and RStudio

You create a database called UPRB_System has information related to each semester of the courses created. The information contains the teacher's name, course code, section, name of the course, day and time it is offered, amount of credits, capacity, room and modality. The UPR Bayamon wants to summarize all the information that they gather since 2017. Write a program in Python and R to answer the following questions.

  1. How many students are in the hybrid mode?
  2. How many students are in the face-to-face mode?
  3. How many students are in the distance mode?
  4. How many students of the COTI3101 course are face-to-face mode?
  5. How many courses have been created from COTI3101 for semester C11?
  6. How many courses have been created from SICI4036 course are hybrid?
  7. How many courses were offered on Tuesdays and Thursdays in semester C11?
  8. How many courses were offered on Wednesdays in semester C11?
  9. How many courses were offered in the summer C03?
  10. How many courses were offered in C01 and C11? How much was the difference?