Please write a 500-word summary.

PROJECT STEPS

1. Takara Hiyashi is on the board of the Green Lake Sports Camp, a recreational summer camp in Syracuse, New York. She is using an Excel workbook to analyze the camp’s financials and asks for your help in correcting errors and solving problems with the data.
Go to the Teams worksheet. Takara asks you to correct the errors in the worksheet. Correct the first error as follows:

a. Use the Trace Precedents arrows to find the source of the #VALUE! error in cell C8.

b. Use the Trace Dependents arrows to determine whether the formula in cell C8 causes other errors in the worksheet.

c. Correct the formula in cell C8, which should add the baseball registration fee per person (cell C4) and the equipment fee (cell C7), and then multiply the result by the minimum number of campers (cell C6).

d. Remove the trace arrows.

2. Correct the Name error in cell C22 as follows:

a. Use any error-checking method to determine the source of the error in cell C22, which should calculate the average revenue per week.

b. Correct the error by editing the formula in cell C22.

3. Correct the divide by zero errors as follows:

a. Evaluate the formula in cell C18 to determine which cell is causing the divide by zero error.

b. Correct the formula in cell C18, which should divide the revenue per session (cell C16) by the minimum number of campers (cell C6).

c. Fill the range D18:G18 with the formula in cell C18. 

4. Takara suspects that the remaining divide by zero errors and the two negative values in the range E16:E18 are related to the zero value in cell E6. She wants to make sure that anyone entering the minimum number of campers enters a number greater than zero.
Add data validation to the range C6:G6 as follows:

a. Set a data validation rule for the range C6:G6 that allows only whole number values greater than 0.

b. Add an Input Message using Number of Campers as the Input Message Title and the following text as the Input message:
Enter the minimum number of campers for this session. 

c. Add an Error Alert using the Stop style, Campers Error as the Error Alert Title, and the following text as the Error message:
The minimum number of campers must be greater than 0. 

5. Identify the invalid data in the worksheet and correct the entry as follows:

a. Circle the invalid data in the worksheet.

b. Type 10 as the minimum number of campers for the lacrosse sessions (cell E6).

c. Verify that this change corrected the remaining divide by zero errors and resulted in positive values in the range E16:E18.

6. Go to the Private Lessons worksheet. This worksheet analyzes financial data for private and semi-private lessons, which the camp runs throughout the day. Takara has already created a scenario named Current Campers that calculates profit based on the current number of campers enrolled for each session. She also wants to calculate profit based on the maximum number of campers.
Add a new scenario to compare the profit with maximum enrollments as follows:

a. Use Max Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Max Campers scenario as shown in bold in Table 1, which are the same values as in the range C8:G8.

Table 1: Cell Values for the Max Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

10

Basketball_Campers (cell D9)

12

Lacrosse_Campers (cell E9)

10

Soccer_Campers (cell F9)

12

Volleyball_Campers (cell G9)

15

7. Takara also wants to calculate profit based on the minimum number of campers.
Add another new scenario to compare the profit with low session enrollment as follows: 

a. Add a scenario to the worksheet using Min Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Min Campers scenario as shown in bold in Table 2.

Table 2: Cell Values for the Min Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

8

Basketball_Campers (cell D9)

8

Lacrosse_Campers (cell E9)

7

Soccer_Campers (cell F9)

8

Volleyball_Campers (cell G9)

7

8. Show the Min Campers scenario values in the Private Lessons worksheet.

9. Go to the Revised Fees worksheet. Takara is considering whether to change the coaching fees for the private lessons. She has created three scenarios on the Revised Fees worksheet showing the profit with a $5 or $10 increase or a $5 decrease to the coaching fees.
Compare the average profit per session based on the scenarios as follows:

a. Create a Scenario Summary report using the average profit per session (range C11:G11) as the result cells to show how the average profit changes depending on the coaching fee changes. 

b. Use Revised Fees Scenario Report as the name of the worksheet containing the report.

10. Takara also wants to focus on one or two types of private lessons at a time when comparing the average profit per session. Return to the Revised Fees worksheet and create another type of report as follows:

a. Create a Scenario PivotTable report using the average profit per session (range C11:G11) as the result cells to compare the average profit depending on the fee changes in a PivotTable.

b. Use Revised Fees PivotTable as the name of the worksheet containing the PivotTable.

c. Format cells B4:F6 in the Revised Fees PivotTable worksheet using the Accounting number format with 0 decimal places and $ as the symbol.

11. Go to the Games worksheet. Takara wants to determine the number of games the camp can hold on Fridays and Saturdays to make the highest weekly profit without interfering with practices, which are also scheduled for Fridays and Saturdays and use the same resources.
Use Solver to find this information as follows:

a. Use the total weekly profit (cell H17, named Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell.

b. Use the number of Friday and Saturday games for the five sports (range C5:G6) as the changing variable cells.

c. Determine and enter the constraints based on the information provided in Table 3.

d. Use Simplex LP as the solving method to find a global optimal solution.

e. Save the Solver model in cell B27.

f. Solve the model, keeping the Solver solution.

Table 3: Solver Constraints

Constraint

Cell or Range

Each game is scheduled at least once on   Friday and once on Saturday

C5:G6

Each Friday and Saturday game value is   an integer

C5:G6

Each sport is scheduled for a game 1   time per week or more

C7:G7

Each sport is scheduled for a game 3   times per week or less

C7:G7

The total number of Friday games is 10   or less

Total_Friday_Games (H5)

The total number of Saturday games is   15 or less

Total_Saturday_Games (H6)

The total number of games per week is   13

Total_Weekly_Games (H7)

The total number of Friday practices is   2 or less 

Friday_Practices (E21)

The total number of Saturday practices   is 2 or less

Saturday_Practices (E22)

The total number of practices per week   is 5 or less

Total_Practices (E23)

12. Takara wants to document the answer Solver found, including the constraints and a list of the values Solver changed to solve the problem. Produce an Answer report for the Solver model as follows:

a. Solve the model again, this time choosing to produce an Answer report.

b. Use Games Answer Report as the name of the worksheet containing the Answer report.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then 

Which of the following statements will retrieve the text of a Label called “lblFirstName” and place it in a string variable called “str”?
string str = lblFirstName.Selection();
string str = lblFirstName.Text;
string str = lblFirstName.getText();
string str = lblFirstName.SelectedItem;
 

Often, multiple _____ objects are placed together on a Panel or _____ control. The user can only select one of them.
CheckBox, TextBox
ListBox, GroupBox
RadioButton, GroupBox
TextBox, ListBox
 

When the user of your fast-food ordering GUI selects the “checkBoxBurger” CheckBox, the string “Burger” should appear in the “listBoxOrder” ListBox. To implement this functionality, write _____ in the ckBoxBurger_CheckedChanged() event handler.
if
(ckBoxBurger.Checked == true)
{
listBoxOrder.Add(“Burger”);
}
 

if (ckBoxBurger.Checked() == true)
{
listBoxOrder.AddItem(“Burger”);
}
 

if (ckBoxBurger.Checked == true)
{
listBoxOrder.Item.Add(“Burger”);
}
 

if (ckBoxBurger.Checked == true)
{
listBoxOrder.AddItem(“Burger”);
}

A(n) _____ application calls on the operating system to perform input/output functions, whereas a(n) _____ application reacts to event notifications from the operating system.
console, Windows
GUI, Windows
Windows, console
Windows, GUI

Because _____ inherit members from the Control class, they both have the methods Show() and Hide().
Buttons and Events
TextBoxes and Events
RadioButtons and Forms
ListBoxes and ComboBoxes
 

Although a _____ usually accepts text input from the user, it can also be used to display text.
ComboBox
Label
MessageBox
TextBox
 

The first time a programmer double-clicks on a Button object in Design Mode, the Button’s default event handler method _____ is added to the code.
Click()
Clicked()
Double_Click()
Double_Clicked()
 

In Design Mode, put words next to a CheckBox by modifying _____ property in the Properties Window.
Label
Font
Name
Text
 

Type _____ to append “New Year’s Day” to an existing list of holidays in the “listHolidays” ListBox object at runtime.
listHolidays.Items.Add(“New Year’s Day”);
listHolidays.Items.Append(“New Year’s Day”);
listHolidays.Add(“New Year’s Day”);
listHolidays.Append(“New Year’s Day”);

Chapter: 1-13

Assignment: Your term project is to create a complete web site. The topic of the web site is of your choosing

Requirements: Must be fully HTML5, CSS3, and accessibility compliant (hint: use the validators)
Must contain between 6-10 pages with at least 2 levels of folders
Must use a consistent 2 column page layout with sections for navigation, body, heading, and footer (created via an external CSS file)
Must have at least 4 graphics, with at least 2 of them being hyperlinks
Must have a vertical navigation bar with links/graphics that change appearance with hover, click, etc
Must contain at least 1 of each of the following:
block quote
unordered list
ordered list
character entity
Must use colors for text, background, or both using both in-line and internal/embedded CSS
Must include a background image for at least a portion of the page layout (typically the heading)
Must configure CSS to have a different appearance for printing (using media types)
Must have at least 1 table with at least 1 numeric column that is right justified
Must have at least 1 embedded video that works with a typical Windows PC with Internet Explorer and Microsoft Media Player. Do not link to another site (such as YouTube), you must include the actual video file itself in your web site submission. Please pick a small video… as this will make uploading your zip file much faster
Must have a form for users to submit name, email, and comments. Use input validation where practical and use the form hosting service from chapter 9
Note: I recommend that you make a checklist of all of these required parts of the assignment, so that you don’t miss one

Expectations: A single zip file with your entire web site

Instructions: Submit your file using the naming convention in the syllabus, for example: “CIS3315 TermProject Grayson.Vernon.zip”

 After loading “Labor Market 2018 & Projected 2018–28” data set (you can download it in this assignment folder), please answer below questions. (Data is provided by U.S. Bureau of Labor Statistics, https://www.bls.gov/careeroutlook/2019/article/wages-and-openings.htm)
Create a scatter plot that shows “Median Annual Wage 2018” in Y axis and “Annual Average Openings, Projected 2018-2028” in X axis, bubble sized by number of records and colored by occupational group. Please create your title of this figure and copy and paste it on this below box
Q1) Please locate the jobs that are related to data systems in this data. What are the median annual wages in 2018 and annual average openings projected from 2018 to 2028?
Q2) After exploring the data, are you willing to have this job for your future career?  If you changed your mind, why? Then, locate the jobs that interest you for your future placements and lable them in your figure. Please elaborate on your decision.  

Jan and Kim Levering have decided to expand their IT consulting business. They have leased space in a nearby building. The following are the details: They will have an entire floor that has the following: a receptionist area 2 offices (one for Jan and one for Kim) a conference room an office that will accommodate 15 cubes for their consultants a computer room to house their server(s) They currently have 8 Windows XP systems set up in a workgroup They would like you to develop a 2-phased plan. The first phase involves moving from the current office to the new office. In a 3–4-page report, you need to do the following: Diagram the network and identify the topology and components: Their existing equipment is as follows: 8 XP systems 1 each in Jan and Kim’s offices 6 systems cubes (1 per cube) 1 Windows Server 2008 (standard edition) system in the computer room 1 printer in the computer room Include the following: IP addressing scheme (use static addressing) subnetting/supernetting subnet mask for phase 1 Provide an installation guide on how to set up the Windows Server 2008 system and the network, including the following: illustrations of the server installation process a minimum of 8 Windows Server 2008 screenshots, with detailed explanations descriptions of the settings for the following: server roles naming conventions disk format (NTFS or FAT) joining security centralized versus decentralized administration a discussion of TCP/IP configuration a comparison of settings between workgroup and domain an explanation of typical installation problems/difficulties related to the following: hardware software the network The second phase, to be completed later, will be to expand their network to accommodate additional equipment. The answer should be in a 3-4 page Words Document.

200 words+

Hackers break into systems and disrupt web site services: 

Discuss are they criminals, or are they challenging computer specialists discover faults within computer networks and systems?

                                             Please list your reference/s

Rather than writing a full-length literature review for your topic, you will practice developing your theoretical framework for your mock dissertation topic in this assignment and then develop your literature review funnel for upcoming assignment 15.1.                             

• The purpose of the theoretical framework is to tie the dissertation together. As the researcher, you should approach the proposed research from a theory or set of theories that provide the backdrop for the work (researchers do not create theory; they use established theory in which to embed their work).
• This section should describe how this study will relate to existing theories and discuss how the methodology being used in the study links to those theories
• The theoretical framework justifies the methods you plan to use for conducting the study and presents how this research will contribute to the body of knowledge and/or practice. Further, it describes the context within which to locate the intended project and suggests why doing such a study is worthwhile.

Directions:

1. Review the rubric and examples to make sure you understand the expectations of this assignment.
   1. Sample Theoretical Framework.pdf
   2. Rubric for Theoretical Framework.docx
2. Develop a 1 page (more is fine) theoretical framework for your mock dissertation topic.  Consider (but do NOT directly answer) the following questions when you write your theoretical framework:
   1. Is the theoretical foundation strong?
   2. Are the theoretical sources apparent?
   3. Are they appropriate for the topic?
   4. Do they need further explanation?
3. Submit your theoretical framework to the submission box.

aight so here we go again…. most of the work is already done I just need help with making the working storage section in the excel document and then finishing the hierarchy chart I’ve created. I’ll also give my problem statement so you know what means what. It’s due tomorrow at 12pm ty ty 🙂

Any one expert in flowchart using RAPTOR.