PSU Customizations Academy Assessment

PSU Customizations Academy Self Assessment Tool

Instructions

To answer a question, select or type the correct response(s) and click Submit Answer. Once you have submitted answers for all of the questions, review your personalized assessment results.

Assessment Registration

To begin your self assessment, please provide your information.

First Name:
Last Name:
Email Address:

Section

Select the correct answer and click Submit Answer.

Your instructor asks you to open the Demographics page unframed. How would you do this?

Feedback will appear here

Check the correct answers and click Submit Answer. Check all that apply.

You are now viewing the unframed general demographics page, and your instructor asks you to view the unrendered code. How do you do this? (Select all that apply)

Feedback will appear here

Drag the items into the correct sequence and click Submit Answer.

Put the following lines of code in the correct order.

  • <table>
  • <thead>
  • <tr>
  • <th>
  • Column Title
  • </th>
  • </tr>
  • </thead>
  • <tbody>
  • <tr>
  • <td>
  • Column Data
  • </td>
  • </tr>
  • </tbody>
  • </table>
Feedback will appear here

Check the correct answers and click Submit Answer. Check all that apply.

You have completed your first custom student page, and now need a link to it. How do you add a link to the left navigation menu? (Select all that apply)

Feedback will appear here

Drag each tile on the right on top of its match on the left until you complete each match, then click Submit Answer.

Match each piece of code to its language.

  1. HTML
  2. CSS
  3. JavaScript
  4. PowerSchool code
  • <div class="box-round"></div>
  • .box-round {margin: 10px auto;}
  • var hasRendered = false;
  • ~[if.~[x:studsinset]>0]
Feedback will appear here

Section

Select the correct answer and click Submit Answer.

You are asked to create a customization that will track service learning hours. What type of table would work best to record the hours each time a student performs community service?

Feedback will appear here

Drag the items into the correct sequence and click Submit Answer.

Assuming your new table is called U_SERVICE_HOURS, put the following lines of SQL into the correct order to return all the service hours for the current student:

  • SELECT sh.hours
  • FROM U_SERVICE_HOURS sh
  • INNER JOIN students s
  • ON
  • s.dcid = sh.studentsdcid
  • WHERE
  • s.id = ~(curstudid)
Feedback will appear here

Select the correct answer and click Submit Answer.

What would the following query return?
SELECT lastfirst
FROM students
WHERE enroll_status = 0
ORDER BY grade_level desc

Feedback will appear here

Select the correct answer and click Submit Answer.

You write the following query to return the number of active students in each grade level. What must be added to the SELECT statement to make this work?
SELECT grade_level
FROM students
WHERE enroll_status = 0
GROUP BY grade_level

Feedback will appear here

Select the correct answer and click Submit Answer.

Like JavaScript, SQL is case sensitive and all Oracle keywords must be in uppercase.

Feedback will appear here

Section

Select the correct answer and click Submit Answer.

You created a one-to-one table named U_StudentDemoInfo in an extension group named U_MyTables. Complete the following input tag for a field named shoesize:
<input type="text" name="???" size="4">

Feedback will appear here

Select the correct answer and click Submit Answer.

If you wanted to use the same field in a tlist_sql query, complete the following query:
SELECT s.lastfirst, sd.shoesize
FROM Students s
INNER JOIN ??? sd
ON s.dcid=sd.studentsdcid

Feedback will appear here

Select the correct answer and click Submit Answer.

What will the results look like for the following tlist_sql code?
~[tlist_sql;
SELECT lastfirst, dob, grade_level
FROM students
WHERE last_name='Dailey']
~(dob) ~(grade_level) ~(lastfirst)
[/tlist_sql]

Feedback will appear here

Check the correct answers and click Submit Answer. Check all that apply.

Select the row template(s) that would return all results in comma-separated rows for the following query:
SELECT first_name, last_name, dob
FROM students

Feedback will appear here

Select the correct answer and click Submit Answer.

Which statement in a table tag results in a table that can be sorted by columns?

Feedback will appear here

Section

Select the correct answer and click Submit Answer.

What does PowerSchool use to indicate a jQuery statement?

Feedback will appear here

Select the correct answer and click Submit Answer.

Consider the following code:
<div id="someStuff">
 <ul>
  <li>Item 1</li>
  <li>Item 2</li>
  <li>Item 3</li>
 </ul>
</div>
What would $j('#someStuff').children select?

Feedback will appear here

Drag the items into the correct sequence and click Submit Answer.

Put the following pieces of code in the correct order to create a valid for loop.

  • for
  • (
  • i=0;
  • i<10;
  • i++
  • )
  • {
  • console.log(i);
  • }
Feedback will appear here

Select the correct answer and click Submit Answer.

Consider the following code:
var gradeLevel = '12';
var result = '';
if(gradeLevel = 9) {result = true} else{result = false}
What will be the final value of the variable 'result'?

Feedback will appear here

Check the correct answers and click Submit Answer. Check all that apply.

Consider the following code:
<ul id="itemList">
 <li>Item 2</li>
 <li>Item 3</li>
 <li>Item 4</li>
</ul>
Which of the following statements would insert Item 1 into the correct location? (select all that apply)

Feedback will appear here

Assessment Results

Your assessment results are below. They are organized based on the different sections of this assessment.

Overall Score

/