” 写作CSE 148程序语言、 辅导SQL编程设计Page | 1CSE 148: Final Exam Excel AccessThe only applications and files you may have openare 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 havecompleted the Exam and your instructor checks that your filesare turned in Correctly.Part A: Connect to Exam Server1. Close down all applications on your computer, except your CSE 148 Canvas course site in the GoogleChrome 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 instructor3. In Canvas Modules, navigate to the Day 42 Take Final Exam pagea) the page Contains a link to these instructions4. 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 pageb) Now click the Begin Final Exam link to sign-on to the AppPortal and begin your examc) 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 apassword 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 YesPart B: Obtain Files Start ExamPage | 21. Navigate to L:\ Drive and the Handouts\CSE148 folder2. COPY the FinalExam_RI folder and PASTE it to your M:\ drive3. Rename the folder as uniqueID_FinalExam_RI folder4. 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 Content7. If requested, select NO to Trust this File8. On the Documentation sheet, press STARTTHIS BEGINS YOUR TIMED EXAM YOU WILL HAVE90 MINUTESa. The Documentation sheet Lists the Expected End time check that time with the current time in the lower righthandcorner of the system tray to see how much time youhave remaining.b. Failure to close BOTH Excel and Access files by the expected end time may result in significantdeductions!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 CLOSEACCESS13. 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 toL:\turnins\CSE148\yourSection\.3. Wait for your instructor to tell you its OK to Log-out, and then press START and theperson 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 tosave for Possible partial credit?Place an apostrophe () to the leftof the equal sign. For example:=IF(xyz, abc, def)Page | 3Database DesignPage | 4SQL Syntax Sheet如有需要，请加QQ：99515681 或邮箱：99515681@qq.com
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
