SOFTWARE -9 dIS

 

Chapter 10

1. Describe why a project manager needs good verbal and written communication skills.

2. What is meant by the term interpersonal skills? Give some examples of interpersonal skills and explain why they are important.

MS Access is preferable to Open Office which

  

· Projects

 

 
 

o MS Access is preferable to Open Office which is a viable option for those without Access

 
 

o Use your own data. Don’t look to download anything from the site.

 
 

o Make the data realistic. It does not have to be real, but don’t do things like using A, B, C, etc. for names or just whole numbers for GPA. Use 2 decimal position GPAs.

 
 

o Use enough data to test all conditions. Make sure the data proves the queries worked

 
 

o Pay attention to format, spelling, etc. on the report

Part 1:

Course Project Part 1

You are required to use OpenOffice software to build tables, write, and execute queries.

 
 

1. Build a Database named DBMS Course Project. The database should include following tables.

 

 
 

o First Table – Students

 

 
 

§ ID

 
 

§ First Name

 
 

§ Last Name

 
 

§ Address

 
 

§ City

 
 

§ State

 
 

§ Zip Code

 
 

§ Phone Number with area code

 

o Second Table – GPA

 

 
 

§ ID

 
 

§ Current GPA

 
 

§ Class

 

 
 

§ 1 (Freshman)

 
 

§ 2 (Sophomore)

 
 

§ 3 (Junior)

 
 

§ 4 (Senior)

 
 

§ 5 (Graduate Student)

 

o Third Table – Scholarships

 

 
 

§ ID

 
 

§ Major course of study

 
 

§ Academic Scholarship (Yes or No)

 
 

§ Athletic Scholarship (Yes or No)

 

2. Extract the First and Last Name, Address, City, State, Zip Code and Phone Number of each senior on the database. Sort by Last Name, then First Name (1 sort).

 

3. Extract the First and Last Name, and GPA of each student who qualifies for the Dean’s List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean’s List.

Part 2:

Course Project Part 2

You are required to use OpenOffice software to write and execute queries with tables you created in project part 1.

 
 

1. Extract the First and Last Name, Student ID, Course Major and GPA of any students on athletic scholarship. Sort by Student ID.

 

2. Produce a report with the data from Step #1 and Use good headings.

You have been asked by

  

You have been asked by the Payroll department to create a program that will calculate the weekly pay for the company’s 25 employees. The program will prompt the user to provide each employee’s full name, hourly pay rate, and hours worked. The program will then ask if the employee is single or married. If an employee is married, the tax rate is 25%; if single, the tax rate is 20%. Also, if the employee worked more than 40 hours in a week, the number of hours greater than 40 is paid at a rate of 1.5 times of the provided tax rate.
 

The program will display a list of all the employee names and weekly pay. In addition, the program will display the total payroll for the week and the average weekly pay.
 

Design a program using structured pseudocode as demonstrated in the lectures and, ensuring all variables are declared, prompt the user for the appropriate input and display a meaningful output message.
 

Ensure the following input is validated as follows:
If the hours worked per week is less than zero, set the hours worked to zero.
If the hours worked per week is greater than 80, set the hours worked to 80.
If the pay rate is less than $10 per hour, set the pay rate to 10.
If the pay rate is greater than $50, set the pay rate to 50.
 

Provide a program introduction message that tells the user how to use the program.

2/4 Project Phase 1

Although the capstone project is based on a problem-and-solution scenario, some research into the topic area of your project will be necessary. This assignment requests that you supply a preliminary list of references that will be used in the preparation of your paper. The references may include scholarly sources, such as prior research published in journals, or papers or resources from industry or technology websites. You will provide a short annotation for each reference, summarizing the content of the article. Your references should include literature related to the problem, historical research and discussion of the problem, and potential solutions that may exist in the technology field.

  • Identify a set of technology issues or concerns associated with a real-world information technology infrastructure.
  • Explore potential solutions to varying types of real-life technology issues in the business environment.
  • Design a solution that will resolve an identified technology issue.
  • Demonstrate the ability to use appropriate communication strategies to convey a solution to a real-life technology issue.

Instructions: 

  1. Prepare a document that lists each reference you intend to use in your project, along with an annotation of each item (in the form of an annotated bibliography).
  2. The references should be in APA 7th edition format. Follow each reference with a paragraph that gives a summary of the article you are referencing.
    1. For questions on APA style, go to the OCLS APA Style Page.
  3. You should have at least five references by this point in the development of your project.

shopify

good day everyone. guys i have my own website and it works pretty well. but i heard shopify and i would like to know opinion..does it make sense to do a redesign?

CBSC630: Midterm

 Your goal will be to write a 3 to 4-page paper where you discuss the use of Python in the field of Data Analytics.