Please see attached questions
Excel_9E_Operations
Excel_9E_Operations
Project Description:
In the following project, you will assist Bill Roman, Project Director, in creating a macro that will assign an operations department heading required on all reports. You will modify the macro by changing the Visual Basic Code.
Navigate to your Excel Chapter 9 folder, and then double-click the Excel file you downloaded from MyLab IT that displays your name—Student_Excel_9E_Operations.xlsx. Verify that the Developer tab is enabled and the Macro Settings are set to Disable all macros with notification. Display the Save As dialog box, navigate to your Excel Chapter 9 folder, set the Save as type to Excel Macro-Enabled Workbook, and then save your file.
With cell A1 active, record a macro with the name Operations_Header and the shortcut key Ctrl + m. (Mac users, use Option + Command + m.) Store the macro in This Workbook. As the description, type Fills in Operations report heading and then click OK to begin recording the macro.
Insert two blank rows at the top of the worksheet, and then click cell A1. Type WPHRC Operations Department and then Merge & Center the text you typed across the range A1:E1. Apply the Title cell style. In cell A2, type Quarterly Report and then Merge & Center the text you typed across the range A2:E2. Apply the Heading 1 cell style. Center the worksheet Horizontally, click cell A1, and then stop recording the macro.
Delete rows 1:2, click cell A1, and then test the macro.
On the Developer tab, in the Code group, click Macros. Verify that the Operations_Header macro is selected, and then click Edit. Scroll down and locate the first instance of End With, and then in the fourth line following End With, edit Quarterly Report to indicate Quarterly Operations Report.
Click File, and then click Close and Return to Microsoft Excel. Delete rows 1:2, click cell A1, and then use the keyboard shortcut to run the macro to test that Quarterly Operations Report displays as the subtitle of the report.
Insert a footer with the file name in the left section, and then display the worksheet in Print Preview to verify that the worksheet is centered horizontally. Display the file properties. As the Tags, type operations department report and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author. Save your workbook.
On the Developer tab, in the Code group, click Macros. Select your Operations_Header macro, and then click Edit. Select and Copy all of the code. Close and Return to Microsoft Excel. In the sheet tab area, click New sheet to insert a new worksheet. Rename the inserted sheet Macro Code and then with cell A1 active, Paste the code to the new worksheet. AutoFit column A.
Click the File tab, and then click Save As. Navigate to your Excel Chapter 9 folder, and then click the Save as type arrow. Click Excel workbook. In the File name box, type Student_Excel_9E_Operations_VBA and then click Save. In the displayed message box, click Yes. Close your file and submit your Student_Excel_9E_Operations_VBA file as directed.
IG Wk10
2 full pages – 550 words
We learn from our readings that the use of mobile devices in our society today has indeed become ubiquitous. In addition, CTIA asserted that over 326 million mobile devices were in use within The United States as of December 2012 – an estimated growth of more than 100 percent penetration rate with users carrying more than one device with notable continues growth. From this research, it’s evident that mobile computing has vastly accelerated in popularity over the last decade due to several factors noted by the authors in our chapter reading. In consideration with this revelation, identify and name these factors, and provide a brief discussion about them.
PostgresSQL Procedures
This editor formats code poorly. Please see the linked file: create_function_2.sql
You will complete the procedure: proc_insertGame beginning on line 120.
Test your code, save it, and upload the SQL script.
Homework
Start with this file and complete the procedure: proc_insertGame
Write the code to call the procedure and test it. You may change
the table definition if you have a good reason… document it!
Document your error codes.
Place all of the code in one SQL file and submit via Canvas. Remember
that I’m fussy about format! This is *not* the obfuscated C contest!
The prcedure proc_insertGame begins about line 118.
Assignment
PFA – Application Security
In 2021, the tuition for a full time student is $6,549 per semester
In 2021, the tuition for a full time student is $6,549 per semester, the tuition for a part time student is $3,325. The tuition will be going up for the next 7 years at a rate of 3.5% per year. Write a program using if-else and a loop. Ask the user if they are a full time or part time student, then display the projected semester tuition for the next 7 years. You should display the actual year (2021, 2022, through 2027) and the tuition amount per semester for that year using python
Dominos case study
1. what impact does social media have on public relations practices particularly crisis communication and reputation management? how significant is for organizations today to monitor content on social media sites, including hash tags and other signs of internal and external dialogue ?
2.how should crisis communication preparedness plan address the proliferations of social media
outlets ?
3.From the perspective of crisis communicators concerned with social media , what else could dominos have done or said to prove with action that it’s key messages are sincere? what other messages could Domino’s have delivered ?
Instructions:
Submission Format: MS Word
Length: minimum 400 words per question
Citations Required: Cite any resources used
SLR paper
Course Paper
A systematic Literature review paper on analyzing and visualizing data
Guidelines
· There are two main goals to conduct this SLR paper in this course:
o Help you toward your PhD thesis. My experience advising many phd students in different universities is that one of the “easiest” approaches to reach the “difficult” task of finding your research subject in your phd is to start by conducting an SLR in your general subject. It can help you as an output of this work to know what are some of the hot topics or trending research subjects in your area of interest.
o As a phd student or soon to be graduate, publications are key factors in evaluating your profile. A good SLR paper in this course can be publishable whether in a conference or a journal whether directly or through extending the work after the end of the course
· The overall grade for this course paper is 25 or 25% of the overall course grade.
· The paper to be submitted no later than June 10th, a firm-deadline.
· We will follow APA guidelines (Please read relevant material about that)
· It is important to write in your own words. Paper will be evaluated using University integrity checking services.
· Systematic Literature Review has a structured approach that you have to follow. You can find online many references on how to conduct SLR. Below is a table as an example describing SLR steps (https://lib.guides.umd.edu/SR/steps). As an alternative to the 8 steps described below, minimum steps in SLR can be 5 (see https://www.ncbi.nlm.nih.gov/pmc/articles/PMC539417/). You will be graded based on following one of those two SLR templates in completing each step properly.
· You may have issue reaching or accessing some papers. Use University library or any available resources, to the best of your abilities.
· You can always submit progress documents for me to discuss and evaluate (i.e. before your final submission throughout the semester).
· In terms of the subjects to pick from, I will create a discussion board for that in which students should not pick repeated subjects and so you can reserve your subject earlier through the discussion board.
· Verify with me through an email before finalizing your paper subject
· Remember, instead of selecting a paper subject, you can start from framing a question to review or even from few selected keywords.
Tools
Steps
1. Identify your research question. Formulate a clear, well-defined research question of appropriate scope. Define your terminology. Find existing reviews on your topic to inform the development of your research question, identify gaps, and confirm that you are not duplicating the efforts of previous reviews. Consider using a framework like PICO or SPIDER to define you question scope. Use Database Search Log Excel spreadsheet to record search terms under each concept.
Optional: It is a good idea to register your protocol in a publicly accessible way. This will help avoid other people completing a review on your topic. Similarly, before you start doing a systematic review, it’s worth checking the different registries that nobody else has already registered a protocol on the same topic.
- Cochrane Collaboration – Systematic reviews of health care and clinical interventions
- Campbell Collaboration – Systematic reviews of the effects of social interventions
- F1000 Research – The protocol is published immediately and subjected to open peer review. When two reviewers approve it, the paper is sent to Medline, Embase and other databases for indexing.
- Joanna Briggs Institute – Systematic reviews of healthcare practices to assist in the improvement of healthcare outcomes globally
- Open Science Framework (OSF) Registries – Registry of a protocol on OSF creates a frozen, time-stamped record of the protocol, thus ensuring a level of transparency and accountability for the research. There are no limits to the types of protocols that can be hosted on OSF.
- *** PROSPERO – International prospective register of systematic reviews. This is the primary database for registering systematic review protocols and searching for published protocols. Scoping reviews are not accepted. PROSPERO accepts protocols from all disciplines (e.g., psychology, nutrition) with the stipulation that they must include health-related outcomes.
- Research Registry – Similar to PROSPERO. Based in the UK, fee-based service, quick turnaround time.
- Zenodo – Share your search strategy and research protocol. No limit on the format, size, access restrictions or license.
Example outlining the details and documentation necessary for conducting a systematic review:
Hersi, M., Traversy, G., Thombs, B. D., Beck, A., Skidmore, B., Groulx, S., … Stevens, A. (2019). Effectiveness of stop smoking interventions among adults: protocol for an overview of systematic reviews and an updated systematic review. Systematic Reviews, 8(1), 28. https://doi.org/10.1186/s13643-018-0928-
Inclusion/exclusion criteria template
2. Define inclusion and exclusion criteria. Clearly state the criteria you will use to determine whether or not a study will be included in your search. Consider study populations, study design, intervention types, comparison groups, measured outcomes. Use some database-supplied limits such as language, dates, humans, female/male, age groups, and publication/study types (randomized controlled trials, etc.).
3. Search for studies. Run your searches in the databases that you’ve identified as relevant to your topic. Work with a librarian to help you design comprehensive search strategies across a variety of databases. Approach the grey literature methodically and purposefully. Collect ALL of the retrieved records from each search into a reference manager, such as Endnote, Zotero or Mendeley, and de-duplicate the library prior to screening.
Rayyan – export your Endnote results in this screening software
4. Select studies for inclusion based on pre-defined criteria. Start with a title/abstract screening to remove studies that are clearly not related to your topic. Use your inclusion/exclusion criteria to screen the full-text of studies. It is highly recommended that two independent reviewers screen all studies, resolving areas of disagreement by consensus.
5. Extract data from included studies. Use a spreadsheet, or systematic review software (e.g. Rayyan, RevMan), to extract all relevant data from each included study. It is recommended that you pilot your data extraction tool, to determine if other fields should be included or existing fields clarified.
6. Evaluate the risk of bias of included studies. Use a Risk of Bias tool (such as the Cochrane RoB Tool) to assess the potential biases of studies in regards to study design and other factors. Read the Cochrane training materials to learn about the topic of assessing risk of bias in included studies. You can adapt existing tools (PDF p.5) to best meet the needs of your review, depending on the types of studies included.
7. Present results and assess the quality of evidence. Clearly present your findings, including detailed methodology (such as search strategies used, selection criteria, etc.) such that your review can be easily updated in the future with new research findings. Perform a meta-analysis, if the studies allow. Provide recommendations for practice and policy-making if sufficient, high quality evidence exists, or future directions for research to fill existing gaps in knowledge or to strengthen the body of evidence.
For more information, see:
- Liumbruno, G. M., Velati, C., Pasqualetti, P., & Franchini, M. (2013). How to write a scientific manuscript for publication. Blood Transfusion, 11(2), 217–226. https://doi.org/10.2450/2012.0247-12
- Academic Phrasebank – Get some inspiration and find some terms and phrases for writing your manuscript
- GradeProof – Automated high-quality spelling, grammar and rephrasing corrections using artificial intelligence (AI) to improve the flow of your writing. Free and subscription plans available.
8. Find the best journal to publish your work. Identifying the best journal to submit your research to can be a difficult process. To help you make the choice of where to submit, simply insert your title and abstract in any of the journal finder tools listed under the Publishing your Systematic Review tab.
GO19_AC_CH02_GRADER_2A_HW – Instructors and Courses 1.1
GO19_AC_CH02_GRADER_2A_HW – Instructors and Courses 1.1
Start Access. Open the file Student_Access_2A_Instructors_Courses.accdb downloaded with this project. Then, in your textbook, turn to Project 2A and complete all of the steps in Activities 2.01-2.16.
Complete Activity 2.01 Opening an Existing Database and Viewing Tables.
Complete Activity 2.02 Selecting the Tables and Common Field to Establish the Table Relationship.
Complete Activity 2.03 Setting Relationship Options.
Complete Activity 2.04 Saving a Relationship Report. Save the report as Relationships for 2A_Instructors_Courses.
Complete Activity 2.05 Displaying Subdatasheet Records.
Complete Activity 2.06 Testing Cascade Options.
Complete Activity 2.07 Sorting Records in a Table in Ascending or Descending Order.
Complete Activity 2.08 Sorting Records in a Table on Multiple Fields.
Complete Activity 2.09 Creating a New Select Query in Design View.
Complete Activity 2.10 Running, Saving, Printing, and Closing a Query.
Complete Activity 2.11 Copying an Existing Query.
Complete Activity 2.12 Modifying the Design of a Query.
Complete Activity 2.13 Sorting Query Results.
Complete Activity 2.14 Specifying Text Criteria in a Query.
Complete Activity 2.15 Specifying Criteria and Hiding the Field in the Query Results.
Complete Activity 2.16 Using Is Null Criteria to Find Empty Fields.
Save and close the database, and then submit for grading.
discussion assignment
In this first week’s discussion, please introduce yourself to the class and include your responses to the following questions:
- What do you expect from taking this course?
- What fascinates you about computer architecture?
- Which programming languages you are familiar with ?
- Do you have any project or research idea/interest in mind ?