Mt. San Antonio College DISTANCE LEARNING COURSE AMENDMENT FORM (REQUIRED)

(1)

Mt. San Antonio College

DISTANCE LEARNING COURSE AMENDMENT FORM

(REQUIRED)

Process Flowchart

(for new DL courses or amendment of existing traditional courses)

For existing courses, obtain (from ICCIS)

and attach to this form:

• course description

• current course outline

• measurable objectives

• methods of evaluation and sample

assignments

Course information must have been

updated within the last four years

For new courses, create and attach to

this form:

• course description

• current course outline

• measurable objectives

• methods of evaluation/sample

assignments

↓ ↓

Obtain DL Course Amendment Form

↓

Meet with Distance Learning TEAM for mentoring during development phase

↓

Complete online teaching certification process

↓

Complete DL Course Amendment Form

↓

Present course website to Department for tentative approval

↓

Meet with Distance Learning TEAM for any modifications to course

↓

Department Approval, Chair signature

↓

Division Approval, Dean signature

↓

Educational Design Committee Approval

↓

Instruction Office – assigns special designator

↓

Placement in Mt. SAC schedule

↓

Course is offered

↓

Stipend is paid to faculty for *first time development

*The first DL course that is developed by a faculty member results in a stipend being paid to the faculty member in the amount of $1000 after the course is offered and taught by that faculty member. Subsequent course(s) and web development does not result in any further stipend. Training, workshops, and resources are available for

(2)

Mt. San Antonio College

DISTANCE LEARNING COURSE AMENDMENT FORM

(REQUIRED – fill in blanks only)

Course Title ____SQL Server___________________ Prefix/Number ______CISD 21______________

Developer ______ Shui-lien Huang_____ Date___May 9, 2006____ Department __ Computer Information Systems __

Course Content:

Course content of this Distance Learning course must match the approved curricula (course topics, measurable objectives) for the regular course, currently on file. The faculty member submitting this amendment and his/her Department are responsible for reviewing the Distance Learning course content to see if the course outline and measurable objectives may be achieved in the Distance Learning mode selected. To achieve this match, obtain a copy from ICCIS of the current curriculum for the regular course (or create a new curriculum for a new course). Attach that information to this document. In addition, all distance learning course content must be accessible to students with disabilities. For aid in developing accessible course materials, contact Disabled Students Programs and Services.

Delivery:

Any Mt. SAC course that replaces seat time with online learning must have this Form completed and approved. The State of California defines a Distance Learning course as one in which the student’s seat time has been replaced at least 51% of the time by distance learning. Mt. SAC’s distance learning courses (online and hybrid) are courses that have regularly scheduled replacement of seat time, and are published accordingly in each Mt. SAC Schedule. What percentage of seat time will be replaced by distance learning in this course?

___51-99_______ %

Meet with the Online Learning Faculty Mentor (x6614) in order to begin the process of adapting traditional course components for online delivery. Some measurable objectives may not be feasible in the DL mode, and the developer may then plan for a hybrid delivery instead of a strictly online delivery mode. Use the tables provided in Supplemental Information on the Methods of Instruction and the Course Weekly Schedule of Activities below to begin the transformation to online learning components and their delivery. Also, begin development of a course web site to deliver the course materials to students. After the course web site is developed, the new course delivery and web site can be presented to the department for their approval.

Course Information:

Develop a course web site for your distance learning students to use during the course. If you need help in creating web pages, contact the Online Learning Support Center at x5016 or the Online Learning Faculty Mentor (x6614) for assistance. A well-developed course web site should include:

• Course outline (of record)

• Learning objectives/outcomes

• Syllabus

o Schedule of weekly activities(assignments and deadlines) o Instructor contact information

(3)

o Grading policy o Attendance policy

o Make-up policy for missed work

o Campus policies – add/drop, academic dishonesty, repeating courses o Departmental intervention plan for repeating of courses

• FAQs

• Student and instructor expectations

• Accommodations for disabled students

• A variety of web-based learning materials

• Discussion forum (within or out of course web site)

• Interactive and relevant links to assignments or activities

• Site map

• Course web site organized around themes or chunks of information

Course web site address: _____http://elearn.mtsac.edu/shuang/cisd21/_____________ (If a UserID and Password are required to view your web site, please provide that information to Kerry Stern, Dean of Library and Learning Resources, x5658)

Student – Instructor Contact:

Title 5 Regulations, and the California Board of Governors for the California Community Colleges, require that course quality standards are met (same as applied to traditional courses) and that regular, effective contact between the student and instructor are included in the design of the course. Please complete the following Supplemental Information on the Methods of Instruction and the Course Weekly Schedule of Activities, being as descriptive and specific as possible.

Past Training and Certification:

__X __ Web design workshops: ( ___Mt. SAC X Other __Frontpage___software)

__X___ Course management training: ( ___Mt. SAC ___Other __WebCT, X BlackBoard__System) __ __ Online courses: ( ____Mt. SAC __Other )

__X___ *Date of Certification for online teaching (required): ______ Feb. 2006__________ __X__ Other experience: __ I have used PageMill to design my web pages for several years Do you have a computer that you will use to manage this course? Yes __X___ No ________ If yes, tell us about your computer: PC _X_ Mac ___ Year _2004_ Mt. SAC _X__ Yours _____ What additional equipment or software do you need to manage this course most effectively? _____ Computer _____ Printer _____ FAX _____ Other____________ Software ___ SQL Server 2005___

(4)

Course Management and Tools:

How will your course be delivered, managed, and maintained?

__X__ FrontPage Web on Mt. SAC server _____ Web pages on another server

_____ WebCT __X__ Blackboard

_____ eCollege _____ Other

Instructional Design:

Some questions to consider, in the design of your course:

1. How will interaction(s) with the instructor and among the students be accomplished?

Mandatory meetings, face-to-face meetings, discussion forums, email, phone, office hours, campus lab hours

2. What will make this interaction effective? (Explain each one the above)

Mandatory meetings – Students must attend a one-time orientation on campus for a completely online course. The orientation will include reviewing the syllabus, a hands-on tour of the class web site and requirements for successful course completion, answering students’ questions.

Face-to-face meetings – Students are encouraged to meet with instructor to discuss course material and for getting help on assignments.

Discussion forums – Questions from the instructor will be posted in a Discussion Forum in the course web site. Part of their weekly schedule of activities is to participate in the Discussion Forum. There will be instructions for posting an original message and how to reply to at least one other student’s original posting. Instructions will include the suggested topic(s), research and reflection required before posting the original message, expected length of message, posting deadline, amount of credit for the posting, and instructions regarding late or missed postings. Feedback will be posted few times a week during the discussion. Students are required to participate in the discussion forums weekly.

Email – Students are encouraged to send email to the instructor if there are any questions about anything in the course. Emails containing assignments must be addressed in a certain manner in orderfor the instructor email client to filter them in the class folders. Phone – Students are encouraged to contact the instructor for anything regarding the class. Office hours – Students are encouraged to meet with the instructor during the posted office

hours.

Campus lab hours – Students are encouraged to meet with the instructor during the posted lab hours.

3. What problems do you expect to encounter with these interactions?

Discussion forums and email are slower than face-to-face interaction and may raise the student’s level of anxiety especially when they encounter problems online. However a

(5)

student may call the instructor or make an appointment with instructor in computer labs for face-to-face help.

4. How will you enhance student learning through the use of the Internet?

Students will be required to search the Internet to answer and to discuss the

assigned/posted questions by the instructor related to the chapter. Students are also required to read course related material from the course web site and the additional reading from the links (online resources) provided by the instructor. All reading material will be used in the discussion forums.

5. How will you handle assessments (exams, quizzes,etc.)?

Assignments and projects are sent via email or uploaded to course web server.

Instructor will use the online testing component of BlackBoard to provide instantaneous assessment feedback.

6. How will you handle students who need more attention?

Instructor will call and/or email students who are falling behind (as with traditional classes). Tutors can be arranged with LAC support or students can get help from instructor.

7. How do you plan to evaluate the effectiveness of this course?

I will compare retention rate and grade averages to sections that are taught face-to-face. There will be student surveys for all of these online sections to evaluate course effectiveness and student satisfaction.

8. How do you plan to provide “alternate media” for students with disabilities?

The entire course web site will be checked for Section 508 accessibility through

ACCMonitor. Several pages have already passed and all images now have alt tags. There are no multimedia files that require special “translation” for disabled students. The syllabus contains reference to all DSP&S services and contact information.

Mt. SAC Student Resources:

What campus resources will you or your students need for this Distance Learning course? _X__ SOLAR: Skills for Online Learning – Assessment of Readiness

(http://elearn.mtsac.edu/olsc/readiness)

_X__ Learning Resources (Library – http://library.mtsac.edu)

__X___ LTC/Learning Assistance Center (tutoring – http://ts.mtsac.edu) _____ Placement/Assessments (English, Math, Chemistry, etc.)

_X___ DSP & S accessibility adaptation

(6)

Future Support and Certification Needed:

What additional training or technical support will be needed to create this Distance Learning course? Additional Blackboard training (level II, III, etc) and Blackboard hotline support would be helpful.

To start the certification process for online teaching, contact the Online Learning Faculty Mentor at x6614.

(7)

Supplemental Information on the Methods of Instruction in a Distance Learning Course

Please use the table below to describe each method of instruction/learning that is to be used in this Distance Learning course. Use a unique abbreviation for each method listed, that later can be placed in the Course Weekly Schedule of Activities (following this table). Provide a detailed description of each method or activity, and clearly explain how a student will use this method. Also, indicate whether this activity is an active or passive learning method for the student. An example is provided. This information will become a part of the official course information, so include all methods that

may be used.

Abbreviation Detailed description of method/activity Active or Passive? _{(A or P)}

AN

Announcements: There will be an announcements page on the course web site that will give students up-to-date information and deadlines. Students will be directed to check this page weekly.

P

AS

Assignments: There will be one assignment each week for the covered lecture. Students must turn in the assignment the following week to get full credit.

A

DF

Discussion Forum – Questions from the instructor will be posted in a Discussion Forum in the course web site.

Part of their weekly schedule of activities is to participate in the Discussion Forum. There will be instructions for posting an original message and how to reply to at least one other student’s original posting. Instructions will include the suggested topic(s), research and reflection required before posting the original message, expected length of message, posting deadline, amount of credit for the posting, and instructions regarding late or missed postings.

A

DL

Downloads: Students will download applications required for this course. They will also download exercises related to the covered topics.

A

EM

Email: Students are encouraged to send email to the instructor if there are any questions about anything in the

course. Emails containing assignments must be addressed in a certain manner in order for the instructor email

client to filter them in the class folders.

A

EX

Exam: Midterm and final exams should be taken on campus following the posted time periods, location on the course web site.

A

F2F

Face-to-Face Meetings: The class has 3 scheduled meetings: orientation, midterm, and final exams. Students can also come to campus during the office hours.

A

LB/HO

Lab/Hands-on exercise: Since this is a class that includes a hands-on lab component, students will be creating,

modifying and analyzing database queries appropriate to the current topic(s), in either face-to-face or online delivery methods. There are several hands-on exercises in most of the chapters. Students must finish all hands-on exercises within a specified time periods.

(8)

Abbreviation Detailed description of method/activity Active or Passive? _{(A or P)}

IC

Instructor Contact: Online students are encouraged to contact the instructor for anything regarding the class.

This can be done by email, by phone or face-to- face meetings during office hours. Instructor office hours, email

address, and phone number are included in the syllabus and posted on the web site.

A

MM

Mandatory Meeting: Students must attend a one-time orientation on campus for a completely online course.

The orientation will include reviewing the syllabus, a hands-on tour of the class web site and requirements for

successful course completion, answering students’ questions, and adding students to the class.

A

QZ

Quizzes – Students will be given quizzes based on current course material. The quizzes will consist of true/false and multiple choice. This will be done online using BlackBoard. The instructor will post the results of the quizzes

for students.

A

RA

Reading Assignments: The class web site will indicate the textbook reading assignments. It will also contain lecture notes.

P

(9)

Course Weekly Schedule of Activities

Enter the information from ICCIS, the traditional method of course content delivery, and the abbreviations used from the above

table on the DL course delivery in the appropriate box below. Estimate a student’s time on task expected for each activity listed.

Week Topic(s) Covered _{(matches ICCIS)} Traditional Course DL Course time on taskEstimated

(hrs)

1

Lecture: Introduction to SQL and SQL

Server database

Lab: Connect to a database server, and view the definition of the columns in a table / table properties

Reading assignment, lecture, review syllabus and course requirements

RA, DF, AS, DL, EM, MM, LB/HO RA: 2 DF: 1 AS: 2, LB DL: 3 EM: .5 MM:1.5 LB/HO: 1.5

2

Lecture: Retrieving data from tables

Lab: Create queries with functions, and search options. Join multiple tables

Reading assignment, lecture, question

and answer period RA, DF, AS, DL, EM, LB/HO RA: 2 DF: 1

AS: 2, LB DL: .25 EM: .5 LB/HO: 1.5

3

Lecture: Creating summary queries

Lab: Summarize data using aggregate functions

Reading assignment, lecture, question and answer period, hands-on exercises, quiz

RA, DF, AS, DL, LB/HO , QZ, EM RA: 2 DF: 1 AS: 2 DL: .25 LB/HO: 1.5 QZ: .25 EM: .5

4

Lecture: Using subqueries

Lab: Display data using subqueries

Reading assignment, lecture, question and answer period, hands-on exercises

RA, DF, AS, DL, LB/HO , EM RA: 2

DF: 1 AS: 2 DL: .25 LB/HO: 1.5 EM: .5

5

Lecture: Inserting, updating and deleting

data

Lab: Modify database data using Insert / Update / Delete statements

RA, DF, AS, DL, LB/HO , QZ, EM RA: 2 DF: 1 AS: 2 DL: .25 LB/HO: 1.5 QZ: .25 EM: .5

(10)

Course Weekly Schedule of Activities

Enter the information from ICCIS, the traditional method of course content delivery, and the abbreviations used from the above

table on the DL course delivery in the appropriate box below. Estimate a student’s time on task expected for each activity listed.

(hrs)

6

Lecture: Defining data types and using

functions

Lab: Convert data, perform date search

and answer period, hands-on exercises RA, DF, AS, DL, LB/HO , EM RA: 2 DF: 1 AS: 2 DL: .25 LB/HO: 1.5 EM: .5

7

Lecture: Creating and maintaining databases

and tables

Lab: Create databases, tables, and indexes

8

Lecture: Creating and managing views

Lab: Create and use the views

lecture, question and answer period,

hands-on exercises RA, DF, AS, DL, LB/HO , EM RA: 2 DF: 1

AS: 2 DL: .25 LB/HO: 1.5 EM: .5

9

Midterm, review Reading assignment, Take midterm,

question and answer period RA, DF, EX, EM RA: 2 DF: 1, LB

EX:1.5 EM: .5

10

Lecture: Writing scripts

Lab: Use transact-SQL statements for script processing

(11)

Course Weekly Schedule of Activities

Enter the information from ICCIS, the traditional method of course content delivery, and the abbreviations used from the above

table on the DL course delivery in the appropriate box below. Estimate a student’s time on task expected for each activity listed.

(hrs)

11

Lecture: Creating stored procedures and

functions

Lab: Develop stored procedures and function

12

Lecture: Coding triggers and cursors

Lab: Define cursors and code triggers

13

Lecture: Working more on cursors

Lab: Use advanced cursor techniques

Reading assignment, lecture, question and answer period, hands-on exercises

RA, DF, AS, DL, LB/HO , EM RA: 2

DF: 1 AS: 2 DL: .25 LB/HO: 1.5 EM: .5

14

Lecture: Managing transactions and locking

Lab: Manage transactions to maintain data integrity

15

Lecture: Assigning database security

Lab: Assign database access and user permissions

(12)

Course Weekly Schedule of Activities

Enter the information from ICCIS, the traditional method of course content delivery, and the abbreviations used from the above

table on the DL course delivery in the appropriate box below. Estimate a student’s time on task expected for each activity listed.

Week Topic(s) Covered

(matches ICCIS) Traditional Course DL Course

Estimated time on task

(hrs)

(13)

DISTANCE LEARNING COURSE AMENDMENT FORM

Verification of Process

The following steps must be signed and approved in this order.

1. Distance Learning Team (faculty from Distance Learning Committee / OLFM) Date:___________________ Signature:_____________________________________________________________________ Recommendations:______________________________________________________________ _____________________________________________________________________________ ______________________________________________________________________________________ 2. Presentation to Department

Department: Approval_______ Denial_______ Date______________ Signature(s)____________________________________________________________________ Recommendations:______________________________________________________________ _____________________________________________________________________________

______________________________________________________________________________________

_____________________________________________________________________________ 3. Division: Approval_______ Denial_______ Date______________ Div. Dean Signature_____________________________________________________________ Reason for denial_______________________________________________________________ 4. Educational Design Cmte: Approval_______ Denial_______ Date______________ EDC Co-Chair Signature__________________________________________________________ Reason for denial_______________________________________________________________ 5. Date Received in Instruction Office: ____________________