Exam II rules and question distribution

Exam II Rules and Question Distribution

Exam Time

Exam Rules
By using the following exam rules, it could greatly simplify and flex the exam taking (e.g., more time could be given if needed), and make you feel more comfortable while taking the exam. Therefore, please be honest because we want to avoid using a much stricter method like ProctorU.

The whole exam will be monitored from Zoom. Finish setting up and signing in to the Zoom (at https://und.zoom.us/j/2489867333) 30 minutes before the exam.

Have to use your real name, not nickname, for Zoom, so the instructor can identify the students correctly.

Turn on the webcam and speaker, mute the microphone, and keep them active during the exam. Take one of the following approaches:

If you have a printer and a wired/wireless webcam (or two computers), point the webcam to show you, (exam) paper, desk, computer (if for Zoom), and scanner or phone (if for photoing the answers), like the figure above.

If you have a wired/wireless webcam, point the webcam to show you, (exam) paper, desk, computer (for exam questions), and scanner or phone (if for photoing the answers).

If you have a phone installed with Zoom, point the phone to show you, (exam) paper, desk, computer (for exam questions), and scanner or phone (if for photoing the answers).

If you have a computer webcam, point the webcam to show you, (exam) paper, desk, and scanner or phone (if for reading the exam questions or photoing the answers).

If you do not have anything, 🤐

The .pdf exam will be emailed to your UND email account a few minutes before the exam time.

Start the exam as soon as you receive it. You can either
1. Print the exam and write the answers on the exam, or
2. Read the exam questions from the computer or phone and write the answers on papers.

It is an exam of closed books and notes. During the exam, you are NOT allowed to use the computers, keyboards, mice, and cell phones, other than reading the exam questions or communicating with the instructor. All communications are through Zoom chat. In addition, you can only leave your seat after asking.

At the end of the exam, you can either
1. Scan the exam or papers, or
2. Take pictures of the exam or papers.
Make sure the result files are correct and clear!

Submit the files via either one of the following two methods immediately:
- Upload them to the Blackboard or
- Email them back to the instructor at wenchen@cs.und.edu .
Do not leave until you receive a confirmation from the instructor.

The exam will be highly suspected if fail to follow the above rules.

Question Style

Closed books and closed notes

All questions are from or derived from the class slides and programming exercises.

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

You are NOT likely to do well on the exam if you could NOT (almost) finish implementing the exercises before the exam.

HTML questions will not be asked, but you have to understand fundamental HTML because PHP is closely related to HTML. For example, how PHP handling the radio buttons is related to the HTML script.

The basic SQL, but not the advanced one, needs to be used.

Though this exam will not cover the Exam I materials, you may need all the knowledge such as PHP learned from this course to answer the questions.

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

To help you code, a list of keywords, like query, num_rows, fetch_assoc, createStatement, ResultSet, setContentView, moveToFirst, findViewById, setOnClickListener, RelativeLayout, intent-filter, and EditText, 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.

Android program templates may be given to help you program.

You do not need to memorize the file DigiCertGlobalRootCA.crt.pem .

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

 $host     = "undcemmysql.mysql.database.azure.com";
 $username = "your-id";
 $password = "your-password";
 $database = "your-db";
 $conn     = mysqli_init( );
 mysqli_ssl_set( $conn, NULL, NULL, "DigiCertGlobalRootCA.crt.pem", NULL, NULL );
 mysqli_real_connect( $conn, $host, $username, $password, $database, 3306 );

 if ( $conn->connect_errno )
   die( 'Failed to connect to MySQL: ' . $conn->connect_error );

Major Question Distribution

The following materials will be covered:
- Class slides of Weeks 6, 7, 8, 10, 11, & 12,
- Programming Exercises I & II, and
- NO reference links (under the label ☂ References), NO video clips, jokes, idioms, and quotes (they are for refreshing your memory while studying).

PHP embedded with SQL (Weeks 6 & 7 and Programming Exercise I): 40% – 60%
- Questions ⇒ HTML, PHP, and SQL code
- Web interface + results ⇒ HTML, PHP, and SQL code

Android (Weeks 8, 10, 11, & 12 and Programming Exercises II): 40% – 60%
- Programming questions will be asked. If you fully understand the code in slides and did your Programming Exercise II, then you should have no problems answering the questions.
- Incomplete Android code/template ⇒ Complete Android code
- Questions/results ⇒ Android, XML, PHP, and SQL code

Recommendations
To prepare the exam:

Everything will come from the slides of Weeks 6, 7, 8, 10, 11, & 12, and Programming Exercises I & II, so study them very carefully and one by one.
Try to (almost) finish your Programming Exercises I & II before the exam.