Course Description

IMED 2309 – Internet Commerce-- 3 sem. hrs. (2 lecture, 3 laboratory, 0 external hours per week)

An overview of the Internet as a marketing and sales tool with emphasis on developing a prototype for electronic commerce. Topics include dynamic data, integration, and creating web sites in order to collect information, performing on-line transactions.

TSI Requirement: M1; R2; W1.

Prerequisites: none Corequisite: IMED 1316 and ITSW 1307

Lab Fee: $24.

Course Focus

This course is highly focused on the development and maintenance of Web sites.

Course Outcomes:

Perform audience analysis; state marketing objectives; analyze design strategies for secure data transfer; design a web project to use real-time processing capabilities intended to interact with a database.

Text and References

Morrison, Mike and Morrison, Joline. Database-Driven Web Sites. 2nd ed. Course Technology, 2003. ISBN 9780619064488

Textbooks may be purchased at any SWTJC bookstore or through most educational servicing bookstores or on the Internet.

Technology Requirements

Students will be expected to have keyboard operation knowledge and basic computer skills.

Program Outcomes for "Administrative Information Technology"

The program outcomes noted with an asterisk (*) are addressed in this course.

1. Students will utilize various team work strategies to fulfill the roles and responsibilities of an effective team player.

* 2. Students will use software applications to complete an integrated semester project.

3. Students will utilize terminology applicable to technical and business writing.

4. Students will communicate ideas and information effectively orally.

* 5. Students will analyze a case study of ethical dilemma within the organization.

6. Students will develop an understanding of critical thinking and problem solving in the workplace.

* 7. Demonstrate an understanding of professional and ethical responsibility.

8. Communicate ideas and information effectively both orally and in writing.

Program Outcomes for "Computer Information Systems"

The program outcomes noted with an asterisk (*) are addressed in this course.

1. Design and implement a simple Ethernet Local Area Network.

2. Assemble and troubleshoot a computer.

3. Configure and troubleshoot a router.

4. Configure and troubleshoot a switch.

* 5. Write and document a Web page.

6. Write and document a computer program.

7. Identify and secure the vulnerabilities on a network.

* 8. Demonstrate professional and ethical responsibilities.

9. Install and manage operating systems.

*10. Demonstrate proficiency in word processing, spreadsheets, databases, and presentation graphics

11. Integrate students into the current economy

Course Outcomes

The following list of master course outcomes will be addressed in the course.

1. Become familiar with the architecture of the World Wide Web

2. Learn about communication protocols and Web addressing

3. Learn how multiple server processes can run on the same Web server

4. Become familiar with data-based Web pages, and examine different technologies that you can use to create data-based Web pages that interact with a database

5. Understand the role that the eXtensible Markup Language (XML) plays in data-based Web applications

6. Understand the role that client-side scripts play in validating user inputs in data-based Web pages

7. Learn about the Visual Web Developer 2008 Express Edition (VWD) integrated development environment

8. Become familiar with HTML documents and basic HTML commands

9. Use the VWD Source HTML Designer to create static Web pages

10. Create HTML tables

11. Use HTML commands to create hyperlinks in HTML documents

12. Create HTML forms that accept user inputs

13. Learn how to reference objects in HTML documents using the HTML Document Object Model and dot syntax

14. Learn how to create and debug client-side scripts that use JavaScript methods, event handlers, and custom functions

15. Create and manipulate JavaScript variables

16. Create and use JavaScript built-in objects

17. Learn how to use JavaScript global functions to perform data type conversions

18. Become familiar with JavaScript decision control and looping structures

19. Understand the differences between JavaScript and Java

20. Learn how to create JavaScript programs to validate HTML form inputs

21. Use arrays to structure data and reference form elements

22. Use JavaScript commands to validate values represented by HTML form option buttons, check boxes, and selection list

23. Learn how to use the Script Debugger to locate and correct errors in client-side scripts

24. Learn different ways to display messages in JavaScript programs

25. Use JavaScript commands to create and read cookies

26. Use JavaScript commands to change the page that appears in an existing browser window and open a new browser window

27. Learn about Internet Information Services (IIS)

28. Become familiar with the components of a Web server, and specify the Web server's home directory and default document

29. Create and configure Web server physical directories, virtual directories, and applications

30. Learn how to organize a Web server

31. Learn how to reference files on a Web server

32. Understand the factors that impact Web site performance

33. Learn about the VWD framework, ASP.NET, and server controls

34. Become familiar with the VWD class libraries

35. Learn how to create Web application projects

36. Learn how to use the VWD integrated development environment to create and manage Web application projects

37. Learn how to create and modify Web application project components

38. Learn how to access and reference Web forms

39. Learn how to move a Web application project's files to a different physical folder

40. Learn about the Visual BASIC (VB) VWD programming language

41. Learn how to declare variables and assign values to variables

42. Use the VB VWD Debugger to monitor program execution

43. Learn how to create user-defined procedures

44. Work with complex numeric and string expression in VB VWD

45. Crate decision and repletion (looping) structure

46. Create and reference object classes

47. Learn about the VB VWD collection class

48. Learn how Web servers use server-side processing to create dynamic Web pages

49. Learn how to create event handlers for VWD server controls

50. Understand the differences between HTML server controls and rich server controls

51. Create HTML elements in Web forms

52. Create HTML server controls

53. Create list, radio button, check box, and calendar rich server controls

54. Learn how to create validation controls

55. Learn what a relational database is, become familiar with the structure of a relational database, and understand relational database concepts and terms

56. Understand the differences between personal and client/server databases, and become familiar with the Oracle91 client/server database

57. Explore the structure of the Clearwater Traders and Northwoods University relational databases

58. Understand how Web forms communicate with databases and learn how to create a data connection in VWD

59. Write SQL queries to retrieve records from a single database table, and learn how to sort and filter retrieved values

60. Write SQL queries that join multiple database tables

61. Write SQL queries to perform operations on groups of data values

62. Write SQL queries to insert, update, and delete data records

63. Write VB VWD commands to create data components and retrieve and display database data on Web forms

64. Create DataList and DataGrid rich server controls that allow users to display, update, and delete database data

65. Learn how to validate user inputs in DataList and DataGrid controls

66. Crate a Web form that allows users to insert data into a database

67. Create a Web form that displays data that has master-detail relationships

68. Become familiar with integrated Web application that contains multiple Web forms

69. Understand how to transfer processing from one Web form to another

70. Learn how to share data values across multiple Web forms

71. Learn how to insert records simultaneously in master and detail tables

72. Learn how to add template columns to a DataGrid control

73. Implement security using forms-based authentication

74. Deploy a completed Web application on a production Web server

Attendance and punctuality are critical for successful progress in this course. Each student is expected to study two hours outside of class for each hour in class, take an active role in lectures, laboratories, participate fully in group activities, and assume a self-directed approach to completing class work and home work.

Evaluations and laboratory assignments are imperative. Students must turn in completed assignments by appropriate deadlines.

Course Evaluation

Your performance will be evaluated by satisfactory mastery of the learning objectives listed above. Four exams will be given during the course. The point system below will be used to determine your grade:

After your numerical grade has been calculated, your letter grade will be determined as a percentage of points possible:

A 100% to 90% B less than 90% to 80% C less than 80% to 70% D less than 70% to 60% F less than 60%

Classroom Policies

Plagiarism, the representation of someone else's work as your own, or cheating on an examination will not be tolerated. Either case will result in a grade of zero on work or examination in question. Two or more infractions will be reported to the Dean of Instructional Services for disciplinary action.

Evaluations and laboratory assignments are imperative. Students must turn in completed assignments by appropriate deadlines.

Americans with Disabilities Act (ADA) Statement

Any student with a documented disability needing academic adjustments is requested to speak directly to the Counseling Department (see below) as early in the semester (preferable within the first week) as possible. All discussions will remain confidential.

Crystal City Idalia De La Cruz (830/374-2828) Del Rio Marilyn Casson (830 775-1560)

Academic Integrity Statement

Academic integrity is highly valued in our campus community. Academic integrity directly concerns ethical behaviors which affect both the academic environment and the civic community. Academic dishonestly seriously violates the integrity of the academic enterprise and will not be tolerated at Southwest Texas Junior College. Academic dishonesty is regarded as any act of deception, benign or malicious in nature, in the completion of any academic exercise. Examples of academic dishonesty include cheating, plagiarism, impersonation, misrepresentation of idea or fact for the purpose of defrauding, use of unauthorized aids or devices, falsifying attendance records, violation of testing protocol, inappropriate course assignment collaboration, and any other acts that are prohibited by the instructor of record.

Quality Enhancement Plan (QEP)

Southwest Texas Junior College is accredited by the Southern Association of Colleges and Schools (SACS). SACS requires that every institution develop a Quality Enhancement Plan (QEP). SWTJCs QEP is entitled Enhancing Critical Reading Skills. SWTJC enhances students' critical reading skills by implementing reading instructional interventions in the Gatekeeper classes (History 1301, Math 1314, and English 1301). SWTJC also facilitates reading skills improvement throughout the institution by providing reading tutorial support. For questions about the QEP, please contact Charles Garabedian or Rachel Rivera, QEP Co-Directors, at cagarabedian@swtjc.edu and rrivera17001@swtjc.edu, respectively.

Class Schedule and Office Hour

The class meets for two lecture hours and three laboratory hours per week starting a 4:00 PM and ending at 8:50 PM Thursday at the Del Rio Campus in Room 9; Eagle Pass Campus Room E200; Uvalde Campus Matthews Student Center Computer Room 2. (Total Contact hours: 80)