What major do you want to study? Do you wish to earn an Associate degree and/or transfer to a university? If you wish to transfer, which institution(s) do you intend to apply to for transfer?

Santa Monica College Personal Statement

Write a personal essay (must be at least 500 words) explaining your reason(s) for applying to Santa Monica College.

Be sure to include the following information in your personal statement:

  • What major do you want to study?
  • Do you wish to earn an Associate degree and/or transfer to a university?
  • If you wish to transfer, which institution(s) do you intend to apply to for transfer?

Implement a graph data structure in Java and write a method to perform a depth-first search (DFS) starting from a given vertex.

Algorithms & Data Structures Question

Given an array of integers, find all possible subsets of the array. For example, if the input array is [1, 2, 3], the output should be [], [1], [2], [3], [1,2], [1,3], [2,3], [1,2,3].

Implement a graph data structure in Java and write a method to perform a depth-first search (DFS) starting from a given vertex.

Given two linked lists, each representing a non-negative integer (in reverse order), add the two numbers and return it as a linked list (also in reverse order). For example, given 2->4->3 and 5->6->4, return 7->0->8.

Create an app that can calculate the calories and ingredients in a food through scanning.

Make an app that can calculate the calories and ingredients in a food through scanning

Create an app that can calculate the calories and ingredients in a food through scanning.

Who are the stakeholders in early childhood and what are their roles?

533 Discussion

When students write in journals, they are not writing to perform; instead, they are writing to think on paper about new ideas they are encountering. Journals provide a great opportunity for students to learn by writing, and they encourage students to be reflective. Each week a journal prompt will be provided that is based on the topic of the week. The journal is a way to demonstrate rigorous engagement with the material in a less academic-feeling format. Each one should be an approximately 1-2 page entry.

Who are the stakeholders in early childhood and what are their roles?

Pick two personal finance topics (including but not limited to: credit cards, student loans, budgeting, saving, banking, and investment, etc.). Explain the role they play in your financial and general well-being. Explain why they are important for you to have a successful college experience and beyond.

Financial literacy for college students/young adults

Today’s college students are bombarded with ads, commercials and mailings telling us that we need to spend money to be happy. At the same time, many of us come to college very ill-equipped to handle our finances. Financial literacy, defined as “the ability to use knowledge and skills to manage one’s financial resources effectively for lifetime financial security,” is important in our money matters as well as academic performance.

Based on your understanding of financial literacy and experience (or lack thereof) of personal finance,
1) Pick two personal finance topics (including but not limited to: credit cards, student loans, budgeting, saving, banking, and investment, etc.);
2) Explain the role they play in your financial and general well-being;
3) Explain why they are important for you to have a successful college experience and beyond.

(300 – 500 words)

Determine which orders haven‘t yet shipped and the name of the customer who placed the order. Sort the results by the date on which the order was placed. Sort data by orderdate with most current date at the top.

Week 4 70 pts

This week assignment has a little of everything: Some CREATE TABLE statements with FOREIGN KEYS, ALTER TABLE, string functions (CONCAT, SUBSTR), UPDATES, copy tables, DISTINCT, WHERE, ORDER BY, and JOINS. It just gets more fun!

1. Write 3 create table statements to create the tables below. Include datatypes as listed and appropriate foreign and primary key syntax. Run your statements to make sure they work. The order you create your tables will make a difference. (10)
Yellow Key = Primary Key
Red filled Diamond = Foreign Key
Blue Filled Diamond = required field or not null
Blue unfilled Diamond = optional field or null

2. Determine which categories are represented in the current book inventory. List each category only once. (5)

3. List all customers who have been referred to the bookstore by another customer. List each customer’s firstname, lastname, and the number of the customer who made the referral. Do not use ‘Where Referred is > 0’ (5)

4. Determine the length of data stored in the lastname field of the customers table. Make sure each different length value is displayed only once. Sort data in ASCENDING order(5)

5. Copy the books table. Call the new table New_books. Put all the books from the original books table into the new_books table. (5)

6. Add 10% to the cost of all books in the new_books table from the category Family Life. Actually, change the values in the database, not just select and display. (5)

7. Alter the newbooks table to include a column called Cat_isbn with data type char. (5)

8. Using string functions, write an update statement that add the following values to Cat_isbn column created in previous problem. CAT_ISBN should contain the first two characters from the category followed by the last 3 digits of the ISBN. Include a dash between the two values. (see picture below). (5)

9. Produce a list of all customers’ names in which the first letter of the first and last names is in uppercase and the rest are in lower case. You will need to nest string functions to make this work. MySQL doesn’t have a Proper string function like some languages. You will need to grab the last characters and make them lowercase and attach them to the first character which is already upper case. (5)

10. What books did author James Austin write? (Show isbn, title, author first and last name concatenated together into one column). (5)

11. Determine which orders haven‘t yet shipped and the name of the customer who placed the order. Sort the results by the date on which the order was placed. Sort data by orderdate with most current date at the top. (5)

12. Write a query to show the isbn, title, pubdate and publisher name for all books in the family life category. (5)

13. Show me the customers from Florida and all the books they ordered. Display the columns as shown below and order the data by last name.. (5)

Summarize what you have learned as a result of the presentations and your participation.

Humanities Question

The purpose of this assignment is for you to summarize what you have learned as a result of the presentations and your participation. It should be a fairly in-depth narrative that explores the impact of moving differently, but the depth is also relative to the course length and purpose. The paper must be no less than two pages (not including your title/headings), typed, one inch margins (R & L)

Discuss different types of strategies for competitive advantages (2), and then select and discuss the most appropriate strategies to improve the performance of the organization (2).

Project Report Structure: Part 1

Submission: week 7 Thursday 04/05/2023                                                   

Marks: 17 Marks

1. Cover Page (1 Mark).

  • This must contain topic title (0.25), student names and Students ID (0.5), section number and course name (0.25).
  • (You can find the cover page in the blackboard)

2. Table of Contents (0.5 Mark).

  • Make sure the table of contents contains and corresponds to the headings in the text, figures, and tables.

3. Executive Summary (2.5 Marks).

  • What does the assignment about (1), The name and field of the chosen company (0.5), and briefly explain the distinct features (1).

4. Organizational Profile (3 Marks).                               

Brief background of the business including organization details (1), purpose (1), and organizational structure (1).

5. Strategies (4 Marks).

  • Discuss different types of strategies for competitive advantages (2), and then select and discuss the most appropriate strategies to improve the performance of the organization (2).
  • (You can discuss any points that you learned in this course and its related to your selected organization)

6. Technology Involved (3 Marks).                         

  • How is the organization set up in terms of its IT infrastructure? Discuss the hardware (0.5), software (0.5), telecommunication (0.5), information security (0.5), networks (0.5), and other elements (0,5).
  • (You can discuss any points that you learned in this course, and it’s related to your selected organization)

7. Data Management (2 Marks).

  • Discuss the methods the organization uses to manage and process data (1), and then give one advantage and one disadvantage of these methods (1).
  • (You can discuss any points that you learned in this course (chapter 3) and link it to your selected organization)

8. Identify the Stakeholders (1 Mark)

  • Who are the main individuals, groups, or departments affected by the information system?
  • (You can choose any stakeholder who has a major influence on the IS or vice versa. You can choose 1 stakeholder to discuss)

 

9. Analysis of Existing System (5 Marks).

Analyze the key problems of the existing system used by the company (2). Also, discuss the Information Systems used within the company (3) for example:

  • Transaction processing systems (TPS)
  • Enterprise Resource Planning (ERP) Systems
  • Functional Area Information Systems
  • Business intelligence
  • DSS

(You can discuss any points that you learned in this course and it’s related to your selected organization)

 

10. System Evaluation (2 Marks).

Evaluate the current system that the company use (your chosen company) with one of the following options (1):

  • Success
  • Partial failure/partial success
  • Total failure

Then, State the reasons for your choice (1)

 

11. Suggestions for the company (3 Marks)

Design or choose a system to help the company solve its main problems. State the following:

  • The new system name (1)
  • Its features (1)
  • Problems that will be solved (1)

(If the system that the company uses is successful and does not need to be changed, you can mention that (1), mention its features (1), and mention the problems that it solved or prevented from happening (1).)

  • (You can discuss any points that you learned in this course and it’s related to your selected organization)

12. Conclusion (2 Marks).

  •  Summarize your report (including part 1)

13. References (1 Mark).

  •  Use APA referencing style format

What is the expected number of guests from Germany who stayed at the hotel during the last month? Calculate the variance and the standard deviation of this binomial distribution.

 

S M 9115 Data Analytics for Decision Making 2

Problem 1 (35 pts)
A hotel manager wants to analyze the nationality of the guests who stayed at the hotel during the last month. The data shows that approximately 20% of the guests were from Germany. Suppose that you choose randomly 50 guests:

1. Find the probability that exactly 10 guests are from Germany.
2. Find the probability that at least 15 guests are from Germany.

3. Find the probability that at most 5 guests are from Germany.

4. Find the probability that more than 30 guests are from Germany.

5. What is the expected number of guests from Germany who stayed at the hotel during the last month?

6. Calculate the variance and the standard deviation of this binomial distribution.

Problem 2 (35 pts)
The manager of a hotel chain is interested in knowing whether there is a relationship between the number of positive reviews a hotel receives online and its occupancy rate. The manager collected data from 10 hotels and recorded the number of positive reviews each hotel received on a popular travel website and the corresponding occupancy rate (in percentage) for the same period. The data is shown below:

Hotel Positive Reviews                       Occupancy Rate%
               45
                                                        72
               65
                                                        82
               55
                                                        78
               80
                                                        89
               75
                                                         86
               70
                                                         81
               90
                                                         92
               50
                                                         76
               60
                                                         77
               85
                                                         88

1. Determine the dependent and independent variables.
2. Calculate the correlation coefficient and comment.

3. Determine the regression equation 𝑌̂ = 𝑎 + 𝑏𝑋.

4. Give a brief interpretation for the values of “a” and “b”.

5. If the hotel had no positive reviews, what would the occupancy rate be?

Problem 3 (30 pts)
The revenue manager of a hotel chain wants to analyze the distribution of room rates for a particular hotel location. Based on historical data, she estimates the following probability distribution for the daily room rates:

    Probability         Room Rate
          30%                     $100

          40%                     $150

          20%                     $200

          5%                        $250

           5%                       $300

Based on this distribution, what is the coefficient of variation for the room rates at this hotel location?

Construct a frequency table showing the categories, frequencies, and relative frequencies. Is data Qualitative or Quantitative? Based on the given data, which cuisine type is most preferred among the restaurant customers? Can you justify your answer using percentage relative frequency?

Data Analytics for Decision Making

Problem 1(12 pts)
Tell whether each variable, in the below statements, is quantitative or qualitative, then specify the level of measurement (Nominal, Ordinal, Interval, or Ratio) for each variable:

Variable                                                   Type of Variable                                Level of Measurement
Room temperature (0F) in
manager’s office.

The number of hours spent
on your laptop while
studying for the Data
Analytics exam

The color of walls in Al
Campo Hotel rooms

Student’s Rating
(Evaluation) of the Data
Analytics professor

The most popular Resort in
Marbella is Puente Romano

Number of employees
working at Moch restaurant
in Marbella

Problem 2 (18 pts)
A restaurant has collected data on the preferred cuisine types of its customers. The data collected from a sample of 30 customers is as follows:
Italian, Mexican, Chinese, Indian, Italian, Mexican, Italian, Italian, Indian, Chinese, Mexican, Italian, Italian, Chinese, Indian, Mexican, Italian, Mexican, Chinese, Indian, Chinese, Italian, Indian, Mexican, Chinese, Italian, Italian, Indian, Chinese, Mexican

1. Construct a frequency table showing the categories, frequencies, and relative frequencies.
2. Is data Qualitative or Quantitative?

3. Based on the given data, which cuisine type is most preferred among the restaurant customers? Can you justify your answer using percentage relative frequency?

4. Represent your data using a pie or bar chart.

Problem 3 (35 pts)
The hotel manager of a luxury hotel is interested in analyzing the room occupancy rate for a given month. The manager has collected data on the number of rooms occupied per day and wants to represent this data in a frequency distribution.

1. What is the number of classes?
2. What is the class interval?

3. Construct a frequency distribution showing classes, class frequency & cumulative frequency.

4. Show your data using a graphical chart.

Data:
36, 41, 45, 52, 55, 58, 62, 66, 69, 70, 71, 72, 74, 76, 78, 79, 81, 83, 86, 88, 92, 95, 98, 101,104, 107, 110, 112, 115, 118, 121.

Problem 4 (35 pts)
A hotel manager wants to analyze the revenue generated by the hotel’s different room types during the last quarter. The revenue data for 10 different room types are given below:

Room Type A: $100,000
Room Type B: $120,000

Room Type C: $90,000

Room Type D: $80,000

Room Type E: $130,000

Room Type F: $110,000

Room Type G: $85,000

Room Type H: $95,000

Room Type I: $115,000

Room Type J: $125,000

1. Calculate the mean revenue generated by the hotel’s different room types during the last quarter.
2. Calculate the median revenue generated by the hotel’s different room types during the last quarter.

3. Identify the mode of the revenue data.

4. Compare the mean, median, and mode of the revenue data. Comment on the skewness of the distribution.

5. Calculate two measures of dispersion of your choice for this population or sample.