讲解CSE 148程序语言、辅导SQL编程设计、SQL留学生编程讲解 辅导R语言程序|辅导Python编程
- 首页 >> Python编程 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
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