代做CSE 148程序语言、代写SQL编程设计、SQL留学生编程代做

日期：2020-12-02 11:18

Page | 1

CSE 148: Final Exam – Excel & Access

The only applications and files you may have open

are the ones associated with this exam.

You must remain in the designated CSE Exam Server.

Do NOT log out of the CSE 148 Exam Server until you have

completed the exam and your instructor checks that your files

are turned in correctly.

Part A: Connect to Exam Server

1. Close down all applications on your computer, except your CSE 148 Canvas course site in the Google

Chrome web browser. Remember, you must have the Proctorio extension installed in Chrome!

2. Use the link provided by your instructor to start the Zoom or WebEx session with your instructor

3. In Canvas Modules, navigate to the Day 42 – Take Final Exam page

a) the page contains a link to these instructions

4. Click the NEXT button at the bottom of the Day 42 page, which will take you to the Final Exam page.

a) Click the Final Exam link at the bottom of the page

b) Now click the Begin Final Exam link to sign-on to the AppPortal and begin your exam

c) Your instructor will guide you as to which Exam server to use (EX3 or EX4)

d) Do NOT use the CSE 148 Desktop to take the exam!

e) Once you have connected to the designated exam server, you will be presented with a

password dialog box.

5. Enter the 4-character password provided by your instructor to logon to the exam server.

a) NOTE: If you get a yellow warning box, select “Yes”

Part B: Obtain Files & Start Exam

Page | 2

1. Navigate to L:\ Drive and the Handouts\CSE148 folder

2. COPY the FinalExam_RI folder and PASTE it to your M:\ drive

3. Rename the folder as uniqueID_FinalExam_RI folder

4. Open the folder and rename the Access & Excel files with your uniqueID_CSE148_ …

5. Open your uniqueID… Excel file.

6. If requested, “Enable Macros” or “Enable Content

7. If requested, select “NO” to Trust this File

8. On the Documentation sheet, press START

THIS BEGINS YOUR TIMED EXAM – YOU WILL HAVE

90 MINUTES

a. The Documentation sheet Lists the Expected End time –

check that time with the current time in the lower righthand

corner of the system tray to see how much time you

have remaining.

b. Failure to close BOTH Excel and Access files by the expected end time may result in significant

deductions!

NOTE: The last 2 pages of these instructions has SQL Syntax sheet and the Database Design.

9. Select sheet S1-Design View Queries and complete the instructions. [35 points].

10. Select sheet S2-SQL Queries and complete the instructions. [100 points].

11. Select sheet S3-Analysis and complete the instructions. [65 points].

12. In Access, SAVE and CLOSE all queries and/or tables, then CLOSE

ACCESS

13. In Excel, SAVE your Excel file, then CLOSE EXCEL.

14. IMPORTANT – both files must be close before submitting.

TURNING IN YOUR EXAM FOLDER:

1. Confirm both Access and Excel are closed.

2. From your M-drive, COPY uniqueID_FinalExam_RI folder to

L:\turnins\CSE148\yourSection\.

3. Wait for your instructor to tell you it’s OK to Log-out, and then press START and the

“person icon” and select Sign-Out.

4. You must return to the Final Exam page in Canvas and click the Submit Quiz button!

Function not working and want to

save for possible partial credit?

Place an apostrophe (‘) to the left

of the equal sign. For example:

‘=IF(xyz, abc, def)

Page | 3

Database Design

Page | 4

SQL Syntax Sheet