Answer Question #1 to #10 of the Algorithm Workbench section on page 310.
Type out your answers and number each question clear.
Submit a pdf file that has all your answers.
Answer Question #1 to #10 of the Algorithm Workbench section on page 310.
Type out your answers and number each question clear.
Submit a pdf file that has all your answers.
1. label each response as DQ1, DQ2, DQ3, DQ4.
2. APA format
3. Minimum 1 resources
4. Minimum 150 words each DQ
5. no plagiarism it is checked
Discussion Questions:
DQ1: SQL Standard
What are some of the advantages and disadvantages to an SQL standard?
DQ2: Dynamic & Embedded SQL
Briefly discuss dynamic and embedded SQL. Cite an example of how either enhance database design and performance .
Discussion Questions:
DQ3: Data Joins
In your own words, explain the difference between and outer and inner join. Use an example.
DQ4: Triggers
How can triggers and stored procedures be used to enhance database design and performance? Are there hidden dangers in using triggers and stored procedures?
#Exp19 Excel Ch12 CapAssessment_Teaching_Schedule
#Exp19 Excel Ch12 CapAssessment_Teaching_Schedule
#Excelch12CapAssessmentTeachingSchedule
#You have just started your first career as a high school teacher. To jump start your planning process, you would like to create a teaching schedule template to help plan your weekly tasks. You will create a template, create custom macros to automatically insert dates, and inspect the document for issues.
#
Clear all data validation in the range A1:G19.
Delete the sample text in cell B2
Type Teaching Schedule in cell B1.
Type prepared by: in cell F1.
Delete the value in cell G1.
Add the following comment in cell G1 Enter Name.
#Type Monday in cell C4 and use the fill handle to fill the range D4:G4 with the remaining days of the week.
#Use the document inspector to inspect the document. Remove document properties and personal information and then click close.
Note: Mac users, from the Excel menu, open your preferences, click Security, and then click the check box to Remove personal information from this file on save.
#Use the accessibility checker to check the document for issues. Accept the recommended actions for merged cells and use the recommended action to select Rose, Table Style Medium 23. Close the accessibility checker pane.
#Record a macro named ClearSchedule using the shortcut CTRL+SHIFT+J. Add the description When run, this macro clears the values in the schedule (no period). When run, the macro should delete the values in cell G1 and in the ranges C3:G3, C5:G6, C8:G9, C11:G12, C14:G15, C17:G19, in that order.
Create a form control button that fills cell F2. Assign the ClearSchedule macro and edit the button text to Clear.
Create a form control button that fills cell G2 and edit the button text to Insert Dates.
Open the VBA editor and create a new module named DateStamp. Create a procedure named InsertDate. Insert the comment Inserts weekly dates, then enter the following code Range(“C3:G3”) = Array(Date, Date + 1, Date + 2, Date + 3, Date + 4) and exit the VBA editor.
Assign the InsertDate macro to the Insert Dates form control button.
Test both macros and then open the VBA editor. Locate the module containing the ClearSchedule macro. Copy the code and paste it starting in cell B2 in the Code worksheet.
Locate the module containing the InsertDate macro. Copy the code and paste it starting in cell D2.
Check the document for compatibility with Excel 2010, 2013, and 2016.
Note: Mac users, skip this step.
4 pages
APA format
No plagiarism
Data analysis and summary are required
Please use data analysis software for data analysis, complete data analysis and conclusions, and put forward corresponding suggestions
project showed in the file below
answer (a) and (b)
i realy need help
pick one tool related to JTAG or RIFF and describe the tool. What usefull information could be retreived?
Post your main response to the question (400 words minimum). Reply to 2 other students in the class (minimum 100 words).
PowerPoint_3E_Garden
Open the PowerPoint file Student_PowerPoint_3E_Garden.pptx downloaded with this project.
Using the tools on the Design tab, change the Colors for the presentation to Green, and the Fonts to Cambria.
On Slide 1, format the background by changing the Fill Color to, in the fourth column, the last color.
Select Slides 2 and 3, and then format the background of the two selected slides with the Canvas Texture.
On Slide 2, select the paragraph on the right side of the slide, and then apply the Split entrance effect. Change the Effect Options to Horizontal Out. Change the Start setting to After Previous, and then change the Duration to 01.00.
Use Animation Painter to apply the same animation from the paragraph on Slide 2 to the bulleted list on Slide 3. Then, on Slide 3, remove the animation from the title.
On Slide 4, hide the background graphics. Format the background with the downloaded picture file p03E_Flower.jpg. Change the Transparency to 50%.
Format the title placeholder with a Shape Fill color, in the fifth column, the last color.
On Slide 4, from your downloaded project files, insert the video p03E_Video.mp4. Change the Video Height to 5.
Using the Align to Slide option, apply the Align Center and Align Middle options.
Format the video by applying, from the Video Styles gallery, a Moderate style—Beveled Oval, Black.
Change the video Start setting to Automatically. Trim the video to an end time of 00:12. Compress the video using the Standard Quality setting.
(Mac users, the Compress Media feature is not available in the Mac version of PowerPoint.)
Insert a Header & Footer on the Notes and Handouts. Include the Date and time updated automatically, the Page number, and a Footer with the text 3E_Garden. Display the document properties. As the Tags, type botanical gardens
Save and close the file, and then submit for grading.
Several Big Data Visualization tools have been evaluated in this weeks paper. While the focus was primarily on R and Python with GUI tools, new tools are being introduced every day. Compare and contrast the use of R vs Python and identify the pros and cons of each. Provide an example of both programming languages with coding examples as well as your experience in using one or both programming languages in professional or personal work. If you have no experience with either language, please discuss how you foresee using either/both of these languages in visualizing data when analyzing big data.
Just copy from file( class mates final technical report) to new one in own words. Instructions are also given in Instructions of project 1 file as well. In simple words, copy from given file to own words. Try to look like not simple. Only keep the numbers exact same. That’s all.