Course Title:
Basic Web Development and Data Management for Healthcare.
Course Overview:
This practical course introduces students to basic web development using HTML and CSS with a focus on healthcare data
management. Students will design simple healthcare web applications (e.g., patient registration forms, appointment scheduling),
manage data using Google Forms and Google Sheets, and explore cloud databases to store and analyze healthcare data.
Course Outcomes (COs):
By the end of this course, students will be able to:
1. Design and develop basic healthcare websites using HTML and CSS.
2. Create and manage web forms for healthcare data collection.
3. Store and analyze healthcare data using Google Sheets and Google Forms.
4. Implement simple cloud databases for managing healthcare information.
5. Visualize healthcare data using charts and graphs in Google Sheets.
Syllabus Outline
Unit 1: Introduction to Web Development (HTML & CSS)
Overview of Web Technologies:
o Introduction to HTML and CSS.
o Basic HTML tags: Headings, paragraphs, lists, links, forms, tables.
o Basic CSS styling: Colors, fonts, layouts, and form styling.
o Activity: Students will create a simple webpage for a healthcare facility using HTML and style it with CSS.
Unit 2: Creating Web Forms for Healthcare Data Collection
HTML Forms for Healthcare Data:
o Introduction to HTML forms: Input fields, radio buttons, checkboxes, dropdown menus, and submit buttons.
o Creating patient registration forms, appointment booking forms, and survey forms.
o Activity: Students will design healthcare-related forms for data collection.
CSS Styling for Forms:
o Styling forms with CSS to make them user-friendly and professional.
o Activity: Students will style their forms to enhance the user experience.
Unit 3: Managing Healthcare Data with Google Forms & Google Sheets
Google Forms for Data Collection:
o Setting up Google Forms to collect healthcare data (e.g., patient information, survey responses).
o Integrating Google Forms with Google Sheets for automatic data storage.
o Activity: Students will create a Google Form for patient registration and link it to Google Sheets.
Data Management in Google Sheets:
o Organizing healthcare data (e.g., patient details, appointment records).
o Using Google Sheets functions: Sorting, filtering, and applying basic formulas.
o Visualizing Healthcare Data: Creating simple charts and graphs to visualize patient data, appointment trends, etc.
o Activity: Students will organize and visualize healthcare data in Google Sheets.
Unit 4: Introduction to Cloud Databases for Healthcare Data
Overview of Cloud Databases:
o Introduction to cloud databases (e.g., Airtable or Zoho Creator) for storing and managing healthcare data.
o Setting up a basic database to manage patient records, appointments, and medical history.
o Activity: Students will set up a simple cloud-based database for healthcare data management.
Connecting Forms to Cloud Databases:
o Integrating Google Forms with cloud databases like Airtable for real-time data storage and management.
o Activity: Students will connect a Google Form to Airtable to automatically populate patient records.
Recommended Tools:
Text Editor: Visual Studio Code, Sublime Text, or any basic text editor (for HTML and CSS).
Google Forms and Google Sheets for data collection and management.
Airtable or Zoho Creator for cloud database management.
