3/15/2025 1:40:23 AM	CS 55.12 Course Outline as of Fall 2009	Changed Course
CATALOG INFORMATION
Discipline and Nbr:  CS 55.12	Title:  INTRO TO ASP.NET
Full Title:  Introduction to Active Server Pages - ASP.NET
Last Reviewed:9/27/2010

Units		Course Hours per Week			Nbr of Weeks	Course Hours Total
Maximum	3.00	Lecture Scheduled	2.00		17.5 max.	Lecture Scheduled	35.00
Minimum	3.00	Lab Scheduled	0		17.5 min.	Lab Scheduled	0
		Contact DHR	3.50			Contact DHR	61.25
		Contact Total	5.50			Contact Total	96.25
		Non-contact DHR	0			Non-contact DHR Total	0

Total Out of Class Hours:  70.00

Total Student Learning Hours: 166.25

Title 5 Category:  AA Degree Applicable
Grading:  Grade or P/NP
Repeatability:  00 - Two Repeats if Grade was D, F, NC, or NP
Also Listed As: 
Formerly:  CIS 54.36

Catalog Description:

For students wishing to learn the server-side scripting language ASP.NET (Active Server Pages) and integrate a relational database into a Web site. A project will be created using a relational database, password protection, session processing, and other ASP.NET constructs.

Prerequisites/Corequisites:
Course Completion of CS 10A ( or CS 10 or CIS 10 or CIS 10A or CIS 10 or BDP 10) OR Course Completion of CS 19.11A ( or CIS 16A or CIS 16 or BDP 16 or BDP 57)

Recommended Preparation:
Completion of CS 50.11B (formerly CIS 58.51B) AND eligibility for ENGL 100 or ESL 100.

Limits on Enrollment:

Schedule of Classes Information
Description:

For students wishing to learn the latest server-side scripting language and integrate a relational database into a Web site. A project will be created using a relational database, password protection, session processing, and other ASP.NET: Introduction to Active Server Pages constructs.

(Grade or P/NP)
Prerequisites:Course Completion of CS 10A ( or CS 10 or CIS 10 or CIS 10A or CIS 10 or BDP 10) OR Course Completion of CS 19.11A ( or CIS 16A or CIS 16 or BDP 16 or BDP 57)
Recommended:Completion of CS 50.11B (formerly CIS 58.51B) AND eligibility for ENGL 100 or ESL 100.
Limits on Enrollment:
Transfer Credit:CSU;
Repeatability:00 - Two Repeats if Grade was D, F, NC, or NP

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

Associate Degree:		Effective:		Inactive:
Area:
CSU GE:	Transfer Area			Effective:	Inactive:
IGETC:	Transfer Area			Effective:	Inactive:
CSU Transfer:	Transferable	Effective:	Fall 2004	Inactive:	Fall 2015
UC Transfer:		Effective:		Inactive:
C-ID:

Certificate/Major Applicable: Certificate Applicable Course

COURSE CONTENT

Outcomes and Objectives:
At the conclusion of this course, the student should be able to:

Upon completion of this course, students will be able to:

1.  Employ ASP.NET to create a web site that utilizes dynamic web

   pages including:

   a.  Password protection

   b.  A connection to a back-end relational database (MS Access) with

       related tables via an OLE (object linking and embedding)

       DB (database) connection

   c.  Input forms with validated fields

   d.  ASP.NET scripts to process form data

   e.  Structured Query Language (SQL) queries using inserts, deletes,

       updates, selects, stored procedures and multi-table join

       conditions

   f.  Session processing

   h.  Full user interface

2.  Analyze the site to ensure that it retains its functionality and

   aesthetics on multiple platforms and multiple browsers

3.  Optimize the design of the database for speed

4.  Identify and use ASP/ASP.NET tutorial sites, newsgroups,

   and user forums available on the Web as resources

Topics and Scope

1.  Building ASP.NET pages

   a.  ASP.NET framework

   b.  Namespaces

   c.  Web.Config file

2.  Review of basic programming structures

   a.  Variables, data types

   b.  Assignment, comparisons

   c.  Arithmetic calculations

   d.  Conversion functions

   e.  Naming conventions

   f.  Scope

   g.  Arrays

   h.  Control structures

       1)  Branching

       2)  Looping

       3)  Conditional statements

3.  ASP.NET objects

   a.  Properties

   b.  Events

   c.  Methods

   d.  Sessions

   e.  Cookies

   f.  Redirection

4.  Forms

   a.  Introduction to web forms

   b.  Server controls

   c.  Server control events

   d.  Posting and postback

   e.  Saving state information

5.  Web forms

   a.  User controls

   b.  Custom controls

   c.  Properties and state

   d.  Viewstate

6.  Validating ASP.NET pages

   a.  Custom validation

   b.  Error messages

7.  Debugging in ASP

   a.  Web.Config file

   b.  Error handlers

8.  Structured Query Language (SQL)

   a.  SQL Insert

   b.  SQL Select

   c.  SQL Delete

   d.  SQL Update

   e.  Multi-table joins

9.  Databases with ASP.NET

   a.  ADO.NET (ADO = Active Data Objects)

   b.  Datasets

   c.  Filling datasets

   d.  Data binding

   e.  Repeater data control

   f.  Datalist control

   g.  Datagrid control

   h.  Editing in the datagrid

10. ADO.NET

   a.  ADO.NET and XML (eXtensible Markup Language)

   b.  Properties and methods of datasets

   c.  Viewing and modifying data

   d.  Data readers

11. Introduction to XML

   a.  The XML data model

   b.  XML schemas

   c.  Reading XML

   d.  Writing XML

   e.  Modifying XML

12. Advanced database techniques

   a.  Parameters

   b.  Stored procedures

   c.  Transactions

   d.  SQL scripts

13. Reading and writing files on the server

14. Separating code from content

Assignments:

1.  Create a web site which contains the following elements:

   a.  Password protection via database lookup

   b.  A connection to a back-end relational database with

       related tables via an OLE-DB connection

       (DB-database)

   c.  Input forms with validated fields

   d.  ASP.NET scripts to process the form data

   e.  Extract information from the database with

       SQL queries using inserts, selects, deletes, and

       updates

   f.  Process sessions to track users

   g.  Use ASP.NET components

2.  Research ASP.NET resource sites and newsgroups for assistance with

   problems, and to exchange ideas

3.  Present web site to the class

4.  Two to four exams

5.  Read approximately 25-35 pages per week in the textbook

Methods of Evaluation/Basis of Grade.

Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing.		Writing 0 - 0%
None
This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments are more appropriate for this course.
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.		Problem Solving 40 - 60%
Homework problems, Project
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.		Skill Demonstrations 0 - 0%
None
Exams: All forms of formal testing, other than skill performance exams.		Exams 40 - 60%
Multiple choice, Completion, Correcting syntax, analyzing programs and commands
Other: Includes any assessment tools that do not logically fit into the above categories.		Other Category 0 - 0%
None

Representative Textbooks and Materials:

2.0 "ASP.NET Unl edition Stephen Walther

Prentice Hall,  2006

Print PDF