SRJC Course Outlines

1/25/2022 9:07:39 PMCS 55.12 Course Outline as of Fall 2015

Inactive Course
CATALOG INFORMATION

Discipline and Nbr:  CS 55.12Title:  INTRO TO ASP.NET  
Full Title:  Introduction to Active Server Pages - ASP.NET
Last Reviewed:9/27/2010

UnitsCourse Hours per Week Nbr of WeeksCourse Hours Total
Maximum3.00Lecture Scheduled3.0017.5 max.Lecture Scheduled52.50
Minimum3.00Lab Scheduled04 min.Lab Scheduled0
 Contact DHR0 Contact DHR0
 Contact Total3.00 Contact Total52.50
 
 Non-contact DHR0 Non-contact DHR Total0

 Total Out of Class Hours:  105.00Total Student Learning Hours: 157.50 

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:
Untitled document
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 10 or CS 19.11A or CS 19.21A


Recommended Preparation:
Course Completion of CS 50.11B ( or CIS 58.51B) AND Eligibility for ENGL 100 or ESL 100

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
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.
(Grade or P/NP)

Prerequisites:Course Completion of CS 10 or CS 19.11A or CS 19.21A
Recommended:Course Completion of CS 50.11B ( or CIS 58.51B) AND Eligibility for ENGL 100 or ESL 100
Limits on Enrollment:
Transfer Credit:
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:Effective:Inactive:
 
UC Transfer:Effective:Inactive:
 
C-ID:

Certificate/Major Applicable: Certificate Applicable Course



COURSE CONTENT

Outcomes and Objectives:
Upon completion of the course, students will be able to:
Untitled document
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 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.NET tutorial sites, newsgroups, and user forums available on the Web as resources.

Topics and Scope
Untitled document
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:
Untitled document
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
    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%
Web site creation and presentation
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 - 10%
Attendance and participation


Representative Textbooks and Materials:
Untitled document
ASP.NET 3.5 Unleashed, by Stephen Walther.  Published by SAMS, 2008.

Print PDF