In this course, you will use two of the most important data analytics programming languages: the R programming language and the Structured Query Language (SQL). Both languages are in high demand, and both require specific skills and techniques to use them effectively and efficiently. In this assignment, you will use R and RStudio to create an R script (*.R) file to manually (i.e. by entering data manually) compose and manipulate an R data frame in five (5) steps. You will also provide a one-page summary of what you did, an interpretation of the results you obtained, and a reflection on your learning experience. To prepare for this assignment: Review the module’s interactive lecture and its references. Download and install R. Detailed instructions are provided in the Course Resources > R Installation Instructions. Download and install R Studio. Detailed instructions are provided in the Course Resources > RStudio Installation Instructions. View the videos in these sections of the following LinkedIn Learning Course: Learning R (Links to an external site.): Introduction What is R? Getting Started Data Visualization Data Analysis To complete this assignment: Create an R Script (*.R) file to manually (i.e. by entering data manually) compose and manipulate an R data frame in five (5) steps according to the steps below. Give the script file a name that includes your first name and last name like this Solution-W1-FirstName-LastName.R: Create three (3) vectors to store Human Resource employee information. All three vectors have a length of 3 elements. The first vector stores names of employees. Include your own name as an element of this vector. The second vector stores the IDs of employees. And the third vector stores the geographical state of the employee. Combine these three (3) vectors into a data frame. Display the row of the data frame that stores your name. If your name is “Jane”, the row that stores your name would look like this: Display the data type of the row of the data frame that stores your name. Display the data type of the element that stores your ID. Execute your *.R script file and display the results of its execution in the RStudio console and/or the Plots tabs. Take screenshots, showing current date and time, to demonstrate successful completion of your work. The screenshot should show the R commands you applied and the results you obtained. Do not capture trial and error results. Only your final results should be captured. Your screenshot(s) should look something like this: Summarize your work in one page in which you explain what you did, interpret your results, and reflect on your experience: Explain how you completed this assignment and how you resolved the issues you faced, if any. Interpret the results you obtained from your actions. Reflect on your experience with this assignment and the lessons you learned. To submit your response to this assignment: Prepare all the required screenshots. Prepare your summary of your work (what you did, interpretation of results, and reflection).

Summative Discussion Board Review and reflect on the knowledge you have gained from this course. Based on your review and reflection, write at least 3 paragraphs on the following: What were the most compelling topics learned in this course? How did participating in discussions help your understanding of the subject matter? Is anything still unclear that could be clarified? What approaches could have yielded additional valuable information? The main post should include at least 1 reference to research sources, and all sources should be cited using APA format.  Responses to Other Students: Respond to at least 2 of your fellow classmates with at least a 100-word reply about his or her Primary Task Response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions: What did you learn from your classmate's posting? What additional questions do you have after reading the posting? What clarification do you need regarding the posting? What differences or similarities do you see between your posting and other classmates' postings? 1st peer Having never had experience with formal software development, the entirety of this course was compelling, and challenging. The process of working through what a program is expected to do, and documenting how it does it, is daunting, and requires a lot of discipline, however, breaking the process down, as this course does, helps significantly. Specifically, framing the planning and development around use cases (Break, 2017), and building additional models from them, provided a great framework for understanding the subject matter, and the development process as a whole. The discussions were helpful in understanding the topics for each week. While the weekly discussion boards and submissions covered overlapping topics, the discussion boards provided the opportunity to understand the models for the week, independent of how they may reflect or depend on the other models in the key assignment, granting additional clarity. Additionally, seeing how my other classmates ingested the information also helps to provide extra perspectives to the topic. The best addition for this course would be to have an additional submission, or discussion board, assignment for each week, where a first draft or sample of that week's model is submitted for review. Due to it being my first experience with these models, it was periodically difficult to gage whether or not I was adequately understanding a topic. The additional checkpoint would help establish whether my understanding is in line with expectations, or off base. Sources: Break, T. (2017, October 6). The Use Case Approach. TMA World. https://www.tmaworld.com/our-thinking/use-case-approach#:%7E:text=A%20use%20case%20can%20be%20written%20in%20different%20levels%20of,sentences%20summarizing%20the%20use%20case.&text=Fully%20dressed%20use%20case%3A%20A,goals%2C%20tasks%2C%20and%20requirements  2nd peer to respond to This course for me has been more challenging than I had anticipated. I have learned a lot about object-oriented design and how it is used to turn real world problems into software solutions. I believe that one of the more compelling things that I have learned in this class is with the different diagrams that are used to describe a software system from various perspectives. I think that the activity diagram is probably one of my favorites. Though activity diagrams are process based, they can still be beneficial in object-oriented design because they can provide a visual high-level description of operational functionality (Britton & Doake, 2005). For me I felt that the activity diagram was much more intuitive than some of the others because it can clearly depict a logical flow of events. I enjoyed doing the discussion boards for this class a lot. There are always so many perspectives shared about the way others view and understand the information that we are learning, and I feel that it adds more diversity to my own perspective. I believe that it is important to understand how other people can see things in much different ways based on their own experiences and perspectives. I feel as though we have gotten a great introduction to everything that is involved in the process of software design and I look forward to learning more in the future. As far as the overall course design I felt that it is solid in providing the essential knowledge to understand the process of object-oriented design. I did, however, feel that there was a lot of repetitious work throughout the course within the assignments, mainly because we were working with several somewhat generalized use cases that did not necessarily differ from each other as much as it would seem. Though there is definitely a benefit to learning from repetition, I feel that I personally would have liked to learn more of the capabilities of each type of design artifact rather than multiple basic implementations of each. Overall, I felt that this was a great course that has most definitely laid a strong foundation for my future in software design. References Britton, C., & Doake, J. (2005). Activity Diagrams. In A student guide to object-oriented development (pp. 201-220). Oxford: Elsevier Butterworth-Heinemann. 

Class Project – Teddy Bears You are the owner of Veronica’s Teddy Bear store. Create a new database called “Teddy Bear” Create a Products table and add at least 6 products into the table. Include such fields as Item description, cost, and Product ID. Set a validation rule on the cost field so that any value entered must be at least $15.00. The cost field should be formatted as Currency. Create a Customers database and add at least 10 customers into the table. Include such fields as Customer ID, Name, Address, Phone. Make First Name and Last Name required fields. Create an orders table. Include such fields as Order date, Date Shipped, Quantity, Customer ID, and ProductID. Set the data type of both the Customer and Product fields to number. Establish the appropriate relationships between your tables. (Customer ID > Customer, Product ID > Product, etc.) Create a lookup-field in your Orders table that looks up the Customer ID number from the Customer Table. Set the field to display the customer first and last name and to store the Customer ID field in the Customer field in the Orders table. Create another lookup field that looks up the Product ID field from the Products table. Set the field to display the Product name and store the Product ID field in the Product field in the Orders table. Enter at least 5 orders into your Orders table using a different customer for each order. Create a multi-table query that displays a list of Customers and the Products they have ordered. Save the query with the name “qryOrders”. Include the following fields: Last Name, First Name, Product description, Quantity and Price. Make sure that even if a customer has not placed an order that they will display when you run the query. Create a Form and a Report based upon the qryOrders query. Include a calculated field both on the form and report that adds together the cost and the quantity. Name the new field “Total”. Format the form and report so that they are as eye appealing as possible. Save the form as “frmProducts” and the report as “rptProducts”. LESSON 5 – WORKING WITH REPORTS Create a Main Form using your customers table that includes a subform based upon your Orders table. Rearrange and format the controls on your form to make it as appealing to the eye as possible. Save the form as “frmOrderEntry”. Create a query that includes all fields from your products table. Save the query with the name “qryProducts”. Add a calculated field to add a $3.00 shipping charge to the cost of each product. Name the new field “ShipTotal” Close the database.