Exam II question distribution

Exam II Question Distribution

Time and Place

Times:
Two completely different exams will be provided for campus and online students, respectively.
- Campus: 03:30pm – 04:45pm, Thursday, November 21, 2019
- Online: 06:00pm-06:30pm (75 minutes), Thursday, November 21, 2019

Place: CEC 205

Question Style

Closed books and closed notes

Though this exam will not cover Exam I materials, you may need the previous learned knowledge such as HTML to answer questions.

This exam is programming-intensive. Methods used in Programming Exercise III or mentioned in classes will be asked.

To help you code, a list of keywords, like Dispose, MapPath, Parameters, Repeater, SelectCommand, Server, and SqlDataSource, but not all the keywords used, will be given. Though the keywords are provided, you still need to know where and how to put them.

You are not likely to do well on the exam if you could not (almost) finish implementing the Exercise III before the exam.

Question types may include: (i) true-or-false, (ii) multiple choices, (iii) matching, (iv) blank filling, (v) question-and-answer, and (vi) programming.

If the ASP.NET control SQLDataSource is needed such as:

<asp:SqlDataSource ID="authors" runat="server" ConnectionString=
  "<%$ ConnectionStrings:ConnectionString %>" ProviderName=
  "<%$ ConnectionStrings:ConnectionString.ProviderName %>"
  SelectCommand="SELECT [authorName] FROM [authors]">
</asp:SqlDataSource>

only the values of the attributes ID and Command need to be specified.

The following code will be given in the exam if needed:

public partial class _Default : System.Web.UI.Page {
  protected void Page_Load( object sender, EventArgs e ) {

  ...

  }
  protected void Button1_Click( object sender, EventArgs e ) {

  ...

  }
}

<%@ Page Language="C#" AutoEventWireup="false"
    CodeDatabase="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
  <body>
    <form id="form1" runat="server">

    ... 

    </form>
  </body>
</html>

using System;
using System.Data.OleDb;

public partial class _Default : System.Web.UI.Page {
   
  Protected Sub Event_Click( object sender, EventArgs e ) {
    OleDbConnection conn = new OleDbConnection(
      @"Provider=Microsoft.ACE.OleDb.12.0;Data Source=" +
      Server.MapPath( "Access\\database.mdb" ) )

    ...

  }
}

Major Question Distribution

Covering Class Slides 6 – 10 and Programming Exercise III

Technology Survey and video contents will not be covered.

Databases (15% – 25%)
- Microsoft Access database management (including programming)
- Interface / questions ⇒ SQL commands (including SQL commands used in Exercise III)

C# (25% – 40%)
- C# is a large, complicated language. If the C# features were not mentioned in classes, they will not be asked in exam.
- C# commands and syntax
- C# scripts ⇒ output
- Interface / questions ⇒ C# scripts

ASP.NET (40% – 55%)
- Microsoft ASP.NET (including programming)
- Knowing how the examples in slides work and apply them to Exercise III
- Web interface / questions ⇒ ASP.NET scripts
- ASP.NET tags / controls and their properties

^†One question may include several subjects. For example, an ASP.NET question may include topics of C# and databases.