I'm sorry, but I cannot fulfill that request.
Added by Cristian W.
Close
Step 1
Is it due to limitations, constraints, or other factors? Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Data File needed for this Case Problem: Storm.accdb (cont. from Module 5) Drain Adopter Tandrea Austin wants you to create several forms, including a custom form that displays and updates the location and information of drains that volunteers have signed up for. Complete the following steps: 1. Open the Storm database you worked with in the previous module. 2. Remove the lookup feature from the VolunteerID field in the tblDrain table, and then resize the Volunteer ID column to its best fit. Save and close the table. 3. Define a one-to-many relationship between the primary tblVolunteer table and the related tblDrain table. Select the referential integrity option and the cascade updates option for this relationship. 4. Use the Documenter to document the tblDrain table. Select all table options; use the Names, Data Types, and Sizes option for fields; and use the Names and Fields option for indexes. Export the report produced by the Documenter as a PDF file with the filename NP_AC_6_DrainDocumenter.pdf and without saving the export steps. 5. Create a query called qryDrainsByVolunteer that uses the tblVolunteer and tblDrain tables and includes the fields FirstName and LastName from the tblVolunteer table, and the fields DrainID, MainStreet, CrossStreet, and Direction from the tblDrain table. 6. Use the Multiple Items tool to create a form based on the qryDrainsByVolunteer query, change the title to Drains by Volunteer, and then save the form as frmDrainsByVolunteerMultipleItems. 7. Use the Split Form tool to create a split form based on the qryDrainsByVolunteer query, and then make the following changes to the form in Layout view. a. Size each field value box as necessary to fit a reasonable amount of data. b. Remove the MainStreet, CrossStreet, and Direction controls and their labels from the stacked layout, move these six controls to the right and then to the top of the form, and then anchor them to the top right. c. Remove the DrainID control and its label from the stacked layout, and then anchor the pair of controls to the bottom left. d. Change the title to Drains by Volunteer, and then save the modified form as frmDrainsByVolunteerSplitForm. 8. Use Figure 6–53 and the following steps to create a custom form named frmSupply based on the tblSupply table. a. Make sure the form’s Record Source property is set to tblSupply, and then add a combo box in the Form Header section to find SupplyID field values. b. Add a calculated control that displays the total value of current inventory (cost multiplied by number on hand). Hint: Use the * symbol for multiplication. Set the calculated control’s Tab Stop property to No, set the format to Currency, and use Calculated value of stock on hand as the ControlTip text value. c. Add a line in the Form Header section, add a second line below it, and then add a second pair of lines near the bottom of the Detail section. Set the line thickness of all lines to 1 pt. d. Use the Label tool to add your name below the pair of lines at the bottom of the Detail section. e. For the labels in the Detail section, except for the Total Hours label and the label displaying your name, use the Aqua Blue 5 font color (row 6, column 9 in the Standard Colors palette) and make the text bold. f. For the background fill color of the sections, the calculated control, and the Supply ID combo box, apply the Brown 2 color (row 3, column 10 in the Standard Colors palette). g. Make sure the tab order is top-to-bottom, left-to-right for the main form field value boxes. 9. Make a backup copy of the database, compact and repair the database, and then close the database. Figure 6–53 Storm database custom form design Supply pair of lines in Form Header and Detail sections calculated control your values might be aligned differently in the text boxes.
Akash M.
Option 2: Probabilities of Graduation and Publication Instructions: In the following study, three different universities have been tracking a select group of professors over the course of their employment at that university to determine the number of students who are in a particular professor’s classes, how many of those students have graduated, and if any of them have had their work published. In the attached Excel file, Probabilities, are the totals for each of the professors at the three different universities that participated in the study. The purpose of this study is to find the probabilities of graduation and publication for the students in the different professors’ courses. While a causal relationship may not be found between a professor and student graduation or publication, we need to rank the professors based on the different probabilities found with the data sets as described below. Prepare a report with your ranking of the professors based on the probabilities and conditional probabilities as well as the analysis of each university. Include the following seven (7) items in table format which is provided in the Probabilities file to support your ranking. Note: Be sure to use five (5) decimal places for your probabilities in the table, as some of them will be quite small. Do not convert to percentages as we are interested in probabilities only here. 1. The overall probability of students graduating at each of the three universities. 2. The overall probability of students having a publication at each of the three universities. 3. The overall probability of students having a publication, given that they graduated at each of the three universities. 4. The probability of a student graduating for each professor. 5. The probability of a student having a publication for each professor. 6. The probability of a student having a publication given that they graduated for each professor. 7. Rank the professors within each university for each of the probabilities in 4–6. Then find the sum of the ranks and determine an overall ranking for each professor. Be sure to critically analyze the above calculations in your body paragraphs, explaining how you found each type of probability and then the results you obtained. Be sure to also explain your criteria for ranking in steps 4–7, and defend why you chose that ranking method—as your way might not be the typical method. Paper Requirements: Write a report that uses the Written Assignment Requirements under the heading Expectations for CSU-Global Written Assignments found in the CSU-Global Guide to Writing and APA. Items that should be included, but are not limited to, are a title page, an introduction, a body which answers the questions posed in the problem, and a conclusion paragraph that addresses your findings and what you have determined from the data and your analysis. As with all written assignments, you should have in-text citations and a reference page. Please include any tables of calculations, calculated values, and graphs associated with this problem in the body of your assignment response. University/College | Professor/Instructor | Number Students Taught | Graduated | Publications | P(Graduated) | Rank by P(G) | P(Publications) | Rank by P(P) | P(P|G) | Rank by P(P|G) | Sum of Ranks | Overall Rank WWCC | J.W. Blake | 2560 | 2304 | 876 WWCC | K.R. Cunningham | 599 | 599 | 300 WWCC | R.H. Doughty | 472 | 425 | 162 WWCC | L.M. Edwards | 1027 | 904 | 434 WWCC | W.H. Greiner | 138 | 121 | 44 WWCC | I.D. Jackson | 817 | 809 | 307 WWCC | O.P. Lawson | 2218 | 2018 | 726 WWCC | G.F. Nelson | 870 | 835 | 367 WWCC | A.F. Paul | 1789 | 1735 | 503 WWCC | D.K. Raulson | 329 | 280 | 81 WWCC | T.R. South | 2087 | 1628 | 716 WWCC | E.A. Thomas | 1991 | 1971 | 986 WWCC | C.F. Viney | 1438 | 1237 | 594 WWCC | F.E. Yousef | 2049 | 1824 | 492 Totals EWCC | A.D. Blaise | 163 | 155 | 64 EWCC | I.A. Frank | 2854 | 2397 | 1079 EWCC | S.D. Gundel | 533 | 442 | 150 EWCC | P.O. Hogan | 2993 | 2903 | 1364 EWCC | W.M. Kraft | 418 | 326 | 150 EWCC | L.I. Luebbers | 1110 | 977 | 479 EWCC | J.H. Nye | 1411 | 1129 | 531 EWCC | J.A. O'Dell | 609 | 518 | 130 EWCC | R.W. Pauly | 2773 | 2357 | 1179 EWCC | K.G. Ross | 2209 | 2076 | 664 EWCC | D.S. Smith | 1036 | 881 | 247 EWCC | J.P. Trost | 296 | 249 | 87 EWCC | M.M. Wall | 2353 | 2071 | 559 Totals NWCC | D.H. Allen | 2448 | 1983 | 575 NWCC | T.G. Black | 2878 | 2820 | 1382 NWCC | M.A. Carter | 2649 | 2490 | 1096 NWCC | M.P. Drake | 2031 | 1686 | 708 NWCC | J.K. Elmsworth | 2243 | 1750 | 823 NWCC | P.T. Grey | 231 | 173 | 52 NWCC | C.R. Heines | 1616 | 1374 | 522 NWCC | D.R. Jones | 2703 | 2027 | 791 NWCC | B.M. Keith | 2455 | 2332 | 816 NWCC | G.H. Matheson | 1981 | 1882 | 678 NWCC | P.R. Neighbors | 2032 | 1748 | 752 NWCC | S.T. Orion | 979 | 871 | 314 NWCC | A.P. Tracey | 376 | 365 | 150 Totals
Sri K.
SAMPLE CODE:- //ASMCNT JOB 1,NOTIFY=&SYSUID //CMPLNK EXEC HLASMCLG //C.SYSIN DD * ADD TITLE 'contest program' ADD CSECT ADD AMODE 31 ADD RMODE 24 * *--------------------------------------------------------------------* * * * register equates * * * *--------------------------------------------------------------------* * R0 EQU 0 register 0 BASEREG EQU 12 base register SAVEREG EQU 13 save area register RETREG EQU 14 caller's return address ENTRYREG EQU 15 entry address RETCODE EQU 15 return code EJECT * *--------------------------------------------------------------------* * * * standard entry setup, save area chaining, establish * * base register and addressibility * * * *--------------------------------------------------------------------* * USING ADD,ENTRYREG establish addressibility B SETUP branch around eyecatcher DC CL8'ADD' program name DC CL8'&SYSDATE' program assembled date SETUP STM RETREG,BASEREG,12(SAVEREG) save caller's registers BALR BASEREG,R0 establish base register DROP ENTRYREG drop initial base register USING *,BASEREG establish addressibilty LA ENTRYREG,SAVEAREA point to this program save area ST SAVEREG,4(,ENTRYREG) save address of caller's save * area ST ENTRYREG,8(,SAVEREG) save address of this program * save area LR SAVEREG,ENTRYREG point to this program savearea EJECT * *--------------------------------------------------------------------* * * * program body * * * *--------------------------------------------------------------------* OPEN (PRTLINE,OUTPUT) Open output file MVC LINE(26),MSGX PUT PRTLINE,LINE MVC LINE,BLANK LOOPINIT DS 0H SR 2,2 Clear reg 2 L 2,=F'20' Store 10 in reg 2 L 3,=F'1' Store 1 in reg 3 * LOOP DS 0H * CVD 3,PACKAREA Convert to decimal, store in packarea UNPK OUT,PACKAREA Convert to printable, store in out MVC LINE(8),OUT Move characters from out to line MVZ LINE+7(1),LINE Move zone bits PUT PRTLINE,LINE Put line in output file A 3,=F'1' Add 1 to current total in reg 3 * BCT 2,LOOP Subtract 1 from reg 2, if not zero * then go to LOOP label CLOSE (PRTLINE) Close output file * *--------------------------------------------------------------------* * * * standard exit - restore caller's registers and * * return to caller * * * *--------------------------------------------------------------------* * EXIT DS 0H halfword boundary alignment L SAVEREG,4(,SAVEREG) restore caller's save area addr L RETREG,12(,SAVEREG) restore return address register LM R0,BASEREG,20(SAVEREG) restore all regs. except reg15 BR RETREG return to caller EJECT * *--------------------------------------------------------------------* * * * storage and constant definitions. * * print output definition. * * * *--------------------------------------------------------------------* * LINE DS 0CL80 DC C' ' DC CL79' ' PRTLINE DCB DSORG=PS,DDNAME=PRTLINE,MACRF=PM, X RECFM=FB,LRECL=80 SUM DC P'01' ONE DC P'01' TOT DS PL2 OUT DC X'4040404040404040' MSGX DC CL26'Hi! I can count very fast.' BLANK DC CL80'' PACKAREA DS CL8 SAVEAREA DC 18F'-1' register save area END ADD //G.PRTLINE DD DSN=&SYSUID..OUTPUT(MYOUTPUT),DISP=SHR OUTPUT :- Hi! I can count very fast. 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000009 00000010 00000011 00000012 00000013 00000014 00000015 00000016 00000017 00000018 00000019 00000020 QUESTION :- 1. Upload the sample to your PDS IBM dataset JCL as member name ASMPGM in your JCL dataset. 2. SUBMIT it so that it will execute correctly (return code 0). It will create a member called MYOUTPUT in your OUTPUT dataset. Screen print the member ASMPGM in your JCL PDS. Also print out the member MYOUTPUT in your OUTPUT dataset. The expected result in MYOUTPUT will be: Hi! I can count very fast. 00000001 00000002 00000003 00000004 00000005 00000006 00000007 00000008 00000009 00000010 00000011 00000012 00000013 00000014 00000015 00000016 00000017 00000018 00000019 00000020 3. Now modify your program to reduce the count to 11 and print out a message at the end in caps - THIS IS MY FINAL ASSIGNMENT. 4. Screen print the modified source program ASMPGM in your JCL dataset and the MYOUTPUT member in your OUTPUT dataset.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD