Using MySQL Explained in Higher Education

I need to update this for MySQL Explained ...

Many colleges and universities have adopted Drupal 7 Explained as a course textbook.

Here are suggested details for a course based around Drupal 7 and the book "Drupal 7! Explained".

1. Course Names

  • Introduction to Drupal 7
  • Introduction to Content Management Systems.

2. Course Description

Covers basic content management system concepts. Students learn how to build, design and manage Drupal 7 and how to implement it for personal and business websites.

3. Student Learning Outcomes 

Students will:

  1. Understand what a Content Management System is and how it differs from traditional, flat websites
  2. Select the appropriate server environment and be able to install Drupal 7's files and database
  3. Successfully organize and present content in Drupal 7
  4. Select and integrate extra Drupal 7 features  
  5. Modify the appearance and layout of Drupal 7 websites
  6. Understand potential threats to CMS websites and understand how to protect and backup such websites

4. Outline of Subject Matter

Course subject matter is directly aligned with Student Learning Outcomes. The number of the corresponding SLO appears in parentheses after relevant content:

Here is our recommendation for how the book can produce 12 course units:

  • Unit 1 / Chapter 1: Drupal 7 and CMSs 
  • Unit 2 / Chapter 2: Planning
  • Unit 3 / Chapter 3: Installations 
  • Unit 4 / Chapter 4: Administration
  • Unit 5 / Chapter 5: Content 
  • Unit 6 / Chapter 6: Fields
  • Unit 7 / Chapter 7: Modules
  • Unit 8 / Chapter 8, 9, 10: Menus, Themes, Blocks
  • Unit 9 / Chapter 11: Views
  • Unit 10 / Chapter 12: Layout Modules
  • Unit 11 / Chapter 13: Users
  • Unit 12 / Chapter 14: Site Management (6)

5. Assessments and Grading System

  • The following units end with practice assignments: 4, 5, 7, 8, 10, 11
  • Unit 12 would make an ideal class project.
  • Consider using unit 13 for the final class project
  • If units 12 and 13 are used in class, consider asking students to build a real-world website using Drupal 7 for their final assessment.

6. Suggested Plan for Course Units

  • For a 10 week course: Use units 1 to 11. Consider combining Units 2 and 3.
  • For a 12 week course: Use units 1 to 12.
  • For a 14 week course: Use units 1 to 12 but allow more time for Units 8 and 9.