Southwest Texas Junior College Lynn Masterson
207 Wildcat Drive Del Rio campus, room E1
Del Rio TX 78840-8402 (830) 703-1573
(830) 775-1612 lemasterson@swtjc.edu
IMED 2309
Internet Commerce
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 Co-requisite: IMED 1316 and ITSW 1307
Lab Fee: $24.
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.
Morrison, Mike and Morrison, Joline. Database-Driven Web Sites. 2nd ed. Course Technology, 2003. ISBN 0-619-06448-X
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.
The following list of master course outcomes will be addressed in the course.
1. Perform audience analysis
2. State marketing objectives
3. Analyze design strategies for secure data transfer
4. Design a web project to use real-time processing capabilities intended to interact with a database
Upon completion of this course, students will be able to perform tasks related to the following:
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
Student Contributions
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.
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:
All regular exams 300 points (3 exams 100 points per exam)
Laboratory work 10 points per lab
Final exam 100 points
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%
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.
Attendance will be taken during each class meeting.
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)
Eagle Pass Brenda Hoffman (830/758-4102)
Uvalde Melissa Deleon (830/591-7352)
Class Schedule
The class meets for two lecture hours and three laboratory hours per week starting a 4:00 PM and ending at 8:50 PM Tuesday at the Crystal City Instructional Facility in Room 11; Del Rio Campus in Room 9; Eagle Pass Campus Room E200; Uvalde Campus Matthews Student Center Computer Room 2. (Total Contact hours: 80)
Office Hours:
Monday Tuesday Wednesday Thursday Friday
Will be posted as soon as possible
IMED 2309 – Developed/Revised: January 13 2010