Posts

How fast on average does a cashier serve a customer in our shop? Have you spotted any outlier in the collected service data? If yes, did you include (or exclude) those outliers when coming up the average, and why?

/in /by

Excel Modelling and Individual Report – The University of Puddletown’s Students’ Union Shop

Description of the assignment:

Background

(Any similarities to the student shop at the University of Hertfordshire are entirely coincidental. This is a fictional example.)

The Students’ Union Shop is trying to work out how many cashiers it needs to employ in order to provide an adequate service level. Customers at the shop line up in a single queue and are called forward to pay for their purchases when a till becomes free. To help determine the busy times of the day, the shop has recorded the number of customers arriving at the tills in each 5-minute interval during the shop’s opening hours, from 8am until 6pm (N.B. this is the number who actually make a purchase and does not include customers who are just browsing). Records for a period of 5 weeks are available. All the data were collected during term time.

The shop usually functions with just three cashiers but it has the capacity to support up to 6. The shop is open for approximately 50 weeks each year. The management has also collected data about the time it takes for cashiers to take payment. These data come from term time and 1000 records are available. Management are concerned that customers wishing to buy food, in particular, may be going to other outlets within the university such as the Big Ears Sandwich Shop or the Noddy Bar. Management are also concerned about the turnover of their staff and would like to reduce their stress and also stop them getting bored. They would be interested to hear about any innovative operating strategies for doing this.

You are employed as a consultant for the Students’ Union Shop. The shop management would like to hear insights from you, but does have a few specific questions they would like to ask. These are

  • What is the average customer arrival rate per hour based on the current data?
  • The management reckons there are more customers during the lunch break, and would like you to look into this matter. Could you spot any busier period during the day? If so, what are the busier hours?
    • What is the average customer arrival rate per hour during busier period?
    • What is the average customer arrival rate per hour during quieter period?
  • How fast on average does a cashier serve a customer in our shop?
    • Have you spotted any outlier in the collected service data? If yes, did you include (or exclude) those outliers when coming up the average, and why?
  • How many cashiers does the shop need to have a reasonable performance?
    • When taking the average daily arrival? Would you consider the average daily arrival a good measure for cashier arrangement, and why?
    • During busier period if observed?
    • During quieter period if observed?

The shop management is also interested in hearing your thoughts on how the adoption of business analytics in general could positively impact the shop performance. (For students who participant in the Young Enterprise competition AND wish to work this part in their YE group, please see alternative arrangement here.) They would appreciate that you keep this part under 2 pages.

List the keywords for the selected article as given in the document itself. Explain the thesis of the article and how that relates back to expertise and being an effective expert.

/in /by

GPS Mapping Mission description

This mission requires you to map the NJIT database using the search tool provided on the library main page. Please review this video by my colleague Cristo Leon, that describes our research into the GPS model and how it can be used to assist content analysis and organization.

Links to an external site.  https://njit.webex.com/recordingservice/sites/njit/recording/cb3aef073385103ba7be005056818805/playback

NOTE: This is used to show how to work wiht the database and the GPS model . It isnot a sampel of the search and what needs to be provided exactly in the memo.

Read the directions below.

Items to complete

This task requires you to utilize the GPS model to understand how to narrow the database. The initial map helps us practice the use of the database as well as identify key areas of interest related to experts and expertise. For this submission, create a word document in Memo format to Dr. Lipuma with the following items.

1. Your first step is to create a search of the NJIT database that includes Expert*, AND Communica*, AND Skill. These terms need to be ‘any field’. This will describe the general topic. Record the number of results in this search.

2. Add the limits of date range: 2020 to present, Peer-reviewed articles, available online. Record the total number of results for this search

3. On the left side is the filter of subject. Identify one of these particular subjects and provide an explanation of why you selected it as your area of focus. Within that chosen subject select an article you feel is most related to being an expert and for that article explain your reason for choosing it,

4. List the keywords for the selected article as given in the document itself. Explain the thesis of the article and how that relates back to expertise and being an effective expert. Save the PDF of the article and attach it to the post.

5. Provide an analysis of the quality and trustworthiness of the source. WHo are the authors and why are they able to be relied upon to discuss the chosen article’s topic? Where is the article published and what is the quality of that source? What value does the article content add and why can we trust it? what bias if any is present in the article? Be specific and detailed in the analysis so we see the rationale for answers with evidence about the source

How many fathers were scientists or had an educational background?

/in /by

History of Chemistry

Look at Jeannette Brown’s books 1 and 2.

Have a slide talking about the statistics of Father’s Influences

  • How many fathers were scientists or had an educational background?

Examples of how they were influenced.

Have a good amount of people (3-4 people)

Chose any organization and assume to create an environment of your project. Write a three to four page report about your project. Describe all the above required devices, its purpose and function.

/in /by

Project in Telecommunications

Group Assignment (Max 3 students)

Points 25

Due date: Monday May 8, 2023

Point breakdown

  • Develop and configure the network using Cisco software: 15 pts
  • Present your project: 10 pts (Present project in Cisco Software)

General guideline and instructions:

  1. Create a network diagram using Cisco Packet Tracer that has the following requirements:
  2. The Network has at least 3-5 switches
  3. The network has at least 2-3 routers
  4. The network has at least 2 Wireless routers (Optional)
  5. The network has at least 10 nodes including wireless
  6. The network has at least 4 servers including Web server, DNS, DHCP  servers and others
  7. The network has at least 3 Phones

You will chose any organization and assume to create an environment of your project.

Write a three to four page report about your project. You need to describe all the above required devices, its purpose and function. For Example: what is router, why we need it, what is its function and why here two routers are required. Similarly describe switches, nodes (computer) ,IP Phone, wireless media and all the servers Web server, DNS, DHCP  servers and others

Both Soft copy of the report and your simulator project is required to be submitted.

After the submission a PowerPoint presentation is essential which will carry 10 points

Use 5-7 references. PA Style. While using the references in text citation in the report you justify the function of the corresponding device. For example, why you use a router. So to define and justify use a reference in text.

The report will have proper table of contents

Hint: Download and install the software to start your work

Use the value of enthalpy you determined for CaCl2 to calculate what quantity of salt will be needed to make a chemical hot pack. Assume using 100 g (100 mL) of water and changing the temperature from 25 °C to 60 °C. Show all calculations.

/in /by

The Fundamentals of Calorimetry

Student Name

  • Date
  • Purpose
  • Procedure
  • Experimental Data

Table 1

Time

(min)

 Trial 1

Temp. °C

 Trial 2

Temp. °C
1    
2    
3    
4    
5    
6    
7    
8    
9    
10    

Insert graph of the data from Data Table 1, plotting temperature vs. time, and use the Y intercept to find the temperature at time 0 when the two volumes of water are mixed.

 

Table 2

  Trial 1 (include units) Trial 2 (include units) Calculations (for Trial 1)
Initial temperature of cold water      
Initial temperature of warm water      
Temperature at time 0 from graph, T0      
Heat lost by hot water      
Heat gained by cold water      
Heat gained by calorimeter      
Temperature change of calorimeter      
Heat capacity of calorimeter      
Average Heat capacity of calorimeter    

 

Table  3

Report data with correct units.  Show calculations below the table

  5g CaCl2 10g

CaCl2

 15g

CaCl2

 5g

NH4Cl

 10g

NH4Cl

 15g

NH4Cl
Mass of water

 

            
Mass of salt

 

            
Moles of salt

 

            
Initial Temperature

 

            
Final Temperature

 

            
Change in Temperature            
Heat released/absorbed by water            
Heat released/absorbed by the calorimeter            
Enthalpy of solution

 

            
Molar Enthalpy of solution            
Average molar enthalpy of solution    

Show calculations for first column:

  • Moles of salt
  • Heat released/absorbed by the solution
  • Heat released/absorbed by the calorimeter
  • Enthalpy of solution (J)
  • Enthalpy of solution (kJ)
  • Molar Enthalpy of solution
  • Average molar enthalpy of solution

Insert graphs of ΔT vs. grams of salt for NH4Cl

 

Lab Questions

  1. What sort of relationship exists between the temperature change and the mass of the salt dissolved? Explain your answer.
  2. The actual molar enthalpy of solution for calcium chloride is -81.3 kJ/mol, whereas the molar enthalpy of solution of ammonium chloride is 14.8 kJ/mol. Calculate the percent error of your results. Show the calculations.
  3. Use the value of enthalpy you determined for CaCl2 to calculate what quantity of salt will be needed to make a chemical hot pack. Assume using 100 g (100 mL) of water and changing the temperature from 25 °C to 60 °C. Show all calculations.
  4. Use the graph you drew for NH4Cl to determine the amount of salt needed to make a chemical cold pack. Assume using 100 g (100 mL) of water. The temperature should go down to 3.0 °C from a room temperature of 25 °C. Show all calculations.
  5. Suggest practical ways in which the calorimeter or lab protocol could be improved to decrease percent errors.

How could you use Excel descriptive statistics for data analysis research? What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data?

/in /by

Discussion Question

Using the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants.

This week, you learned about the statistical software applications used to analyze data for research analysis. For this week’s discussion, you will use Excel sheet provide to run descriptive statistics, create graphs and respond to the following:

  • How could you use Excel descriptive statistics for data analysis research?
  • What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data?

Refer to this week’s readings and video tutorials before starting this two part discussion question assignment.

Step 1: Entering Data

Open a blank worksheet in the Excel program

You will now use Excel to view a sample dataset

Dataset Options

In many cases, researchers may have the data from their study in another software package like Microsoft Excel. However, if the data is not available in a software spreadsheet you can manually enter the data. Option 2: Manual Data Entry

In the Worksheet window, type “Age” in C1. Enter the numbers as shown in the dataset below. Enter the remaining data as shown below (set up your column labels i.e., variable). The measure reflects math anxiety and the study variables (cringe, uneasy, afraid, worried, understand) the math anxiety range is from 1–5 with low being the least and 5 the highest.

 Age  Cringe  Uneasy  Afraid  Worried  Understand
 28  5  3  4  4  3
 34  2  5  3  2  1
 25  4  4  4  2  5
 56  3  4  3  1  2
 23  5  4  3  3  4
 29  1  5  3   2  3
 30  3  3  5  2  5
 59  2  5  5  1  2
 45  4  2  5  3  3
 38  1  2  4  1  1
 33  3  2  4  3  2
 47  4  2  3  4  5
 24  1  5 3  4  4
 29  5  4  2  1  3
 53  3  1  5  2  1
 48  4  4  1  5  3
 27  2  5  4  3  4
 34  4  4  3  2  5
 26  4  5  2  3  2
 36  5  5  5  4  3

Step 2: Click on Excel tab for Add Ins; if you do not see statistics; you will need to open the file option; click on Add ins; click on ok; a box will open which will allow you to choose Statistics package; place a check mark in the box and click ok. How to Run Descriptive Statistics

Now that your data is in Excel, you will look at the descriptive statistics for this dataset. Select the data in all the columns except the top that has words for the columns; however you have the file already completed and a picture of the descriptive statistics..See end of page for a copy of the excel sheet and descriptive statistics output.

Discussion Question Part 1

How could you use Excel descriptive statistics for data analysis research? Write about your experience running descriptive statistics. Use the results in the Session Window to support your response. Then add to your discussion with the information you learn writing up your analysis.

Step 3: Excel and Graphs

You will now look at graphing. Select insert graph located at the top of the sheet; highlight the data you want to use for a chart; select the type of chart; select ok. Try using the histogram  feature for one of the variables and select “Ok”. You can create other Histogram graphs by choosing different variables. You can also choose from the other ten graph choices shown on the insert chart function.

Discussion Question Part 2

What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data? Copy and paste your graph(s) in a Word document and attach to your discussion response.

 

Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing.

/in /by

Final Portfolio Project

Final Portfolio Project (submission in Week 15)

Class, the final project is due next week (week 15). Please use this week to get a start on this final project. Start working on a draft that you can continue to work on into next week for submission in Week 15 (nothing is submitted to Week 14).

Final Project Prompt:

The final portfolio project is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 sources cited).

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing.

Prompt 2 “Big Data” (1-2 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology?

Prompt 3 “Green Computing” (1-2 pages): One of our topics in Chapter 13 surrounds IT Green Computing. The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link. You can find examples in the UC Library.

Analyze an annual report and audit reports, and to prepare financial statements for a selected company, including an income statement, balance sheet, and statement of cash flows.

/in /by

Financial Reporting Summative Assessment

Purpose of this Assessment

The final assessment for this competency is to analyze an annual report and audit reports, and to prepare financial statements for a selected company, including an income statement, balance sheet, and statement of cash flows. Items Required for Submission In order to demonstrate mastery of your competency, you will submit:

  1. A one- to two-page analysis of a selected Annual Report and audit reports
  2. An income statement
  3. A balance sheet
  4. A statement of cash flows
  5. A reflection on what the numbers in the statements mean.

Describe how employing a large number of new workers requires strategic recruiting planning and operational efforts, and discuss what aspects might be different in smaller firms.

/in /by

Week 3 Case Study

Recruiting at Kia

As economic conditions became more demanding for some employers, other firms continued to recruit people for jobs. One firm, Kia Motors America, added a large number of jobs at one of its newer facilities. As a subsidiary of a South Korean corporation, Kia Motors America added tons of equipment at its West Point, Georgia, plant, so that ultimately about 300,000 vehicles would be produced annually.

As the firm sought recruits to fill its Georgia plant workforce, more than 40,000 individuals applied for the jobs, the bulk of which were production and maintenance positions. However, the need for people in a variety of other occupations, including air-conditioning service people, cafeteria workers, and medical staff, added to the depth and scope of Kia’s recruiting. A limited time frame for applications was set by Kia as part of its recruitment planning.

In the recruiting process, a variety of regional and area sources were contacted as part of the Kia broad publicity and inclusive efforts in the area. Randy Jackson, HR Director, spent a month visiting colleges and churches, appearing on radio and television shows, and using other means to market Kia’s recruiting and employment efforts. All of these activities were done to inform applicants about the numerous jobs at Kia and the month-long time frame for application.

To make its recruiting system effective in screening the large number of applicants, Kia established an online-only application process on a special website. As part of its recruiting efforts, Kia and a Georgia Department of Labor agency worked together. One of the agency activities was to make computers available at a local technical college, libraries, and other locations for those persons without home-based Internet. Having the online system allowed Kia’s HR staff to move quickly to identify those applicants who matched available jobs. The use of this system by HR recruiters and managers doing the hiring made the selection process more efficient.

To aid in the selection of employees, recruiting software was used to sort applicants into electronic “buckets,” divided by work experiences and education. Then an eight-step process was established to let applicants obtain a realistic job preview of working at Kia. These recruiting actions resulted in the hiring of more than 500 new employees within six months. During the rest of the year, an additional 1,200 workers were hired, primarily for the second shift, and more were hired later.

Although smaller employers might not use such an extensive recruiting process, the Kia process illustrates the kinds of recruiting planning, activities, Internet linkages, and other means that can be used by both large and small employers doing recruiting. The long-term success of Kia’s efforts to staff its Georgia operation demonstrates ways in which HR can use both time- and cost-effective recruiting to hire qualified individuals.

Case Study Questions

  1. Describe how employing a large number of new workers requires strategic recruiting planning and operational efforts, and discuss what aspects might be different in smaller firms.
  2. Discuss how utilizing the Internet, like Kia did and other employers do, is changing how recruiting efforts are occurring for a variety of jobs in employers of different sizes.

You will be expected to have a Similarity Index of less than 15%. If your Similarity Index is greater than 15%, you will need to review your Originality Report to ensure that you have paraphrased your work appropriately and cited your sources correctly.

Address at least two posts of your classmates. Read your classmates’ posts and compose at least two responses (min. 200 words each) to your classmates’ original post.

/in /by

3: Discussion

In addition, you are required to address at least two posts of your classmates. Read your classmates’ posts and compose at least two responses (min. 200 words each) to your classmates’ original post. Your comments need to be substantive, well-written and critical. You have to use at least 2 readings in your comment. Note that the APA style applies to your answers and comments.

When posting on DB, you should:

  • Make posts that are on topic and within the scope of the course material;
  • Take your posts seriously and review and edit your posts before sending;
  • Be as brief as possible while still making a thorough comment;
  • Always give proper credit when referencing or quoting another source;
  • Be sure to read all messages in a thread before replying. Do not repeat someone else’s post without adding something of your own to it;
  • Avoid short, generic replies such as, “I agree.” You should include why you agree or add to the previous point;
  • Always be respectful of others’ opinions even when they differ from your own. When you disagree with someone, you should express your differing opinion in a respectful, non-insulting way.