All posts by : chebby

Exp19_Excel_Ch09_HOEAssessment – Ticket Sales 1.0

Exp19 Excel Ch09 HOEAssessment Ticket Sales 1.0

Excel Chapter 9 Hands-On Exercise Assessment – Ticket Sales

Project Description:

You are an assistant to the manager of Sugarhouse District Theatre, where touring Broadway shows are performed. You created a workbook for the weekend evening performances to track the number of seats available and sold in each section of the theatre, along with gross revenue. You are ready to complete the workbook.

Start Excel. Download and open   the file named Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx.   Grader has automatically added your last name to the beginning of the   filename.
 

  Note: When you open the file, Excel prompts you to fix a circular error.   Click OK and continue.

The first column in the Friday   worksheet contains cells with a different font color and levels of   indentation. You want to fill this formatting across the Saturday and Sunday   worksheets.
 

  Group the Friday, Saturday, and Sunday worksheets. Fill the formatting for   the range A5:A20.

You notice that a formula is   missing on three worksheets. You will insert the formula simultaneously.
 

  With the worksheets still grouped, in cell E21, enter a formula to subtract   the Grand Total Percentage Sold from 1. Apply Bold to the cell. Ungroup the worksheets.

The Totals worksheet contains   summary data. You will insert a hyperlink to the number of seats sold in each   respective worksheet.
 

  On the Totals worksheet, in cell A5, insert a hyperlink to cell C21 in the   Friday worksheet with the ScreenTip text Friday. In cell A6, insert a hyperlink to cell C21 in the   Saturday worksheet with the ScreenTip text Saturday. In cell A7, insert a hyperlink   to cell C21 in the Sunday worksheet with the ScreenTip text Sunday. Test the hyperlinks to ensure   the work correctly.

Now you are ready to insert a   formula with a reference to the number of seats sold for Friday’s   performance.
 

  In cell B5, insert a formula with a 3-D reference to cell C21 in the Friday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Saturday’s   performance.
 

  In cell B6, insert a formula with a 3-D reference to cell C21 in the Saturday   worksheet.

Now you are ready to insert a   formula with a reference to the number of seats sold for Sunday’s performance.
 

  In cell B7, insert a formula with a 3-D reference to cell C21 in the Sunday   worksheet.

The next section of the Totals   worksheet is designed to display total gross revenue by section.
 

  In cell B11, insert the SUM function with a 3-D reference to calculate the   total Orchestra Front gross revenue (cell G9) for the Friday, Saturday, and   Sunday worksheets.

You are ready to insert a   function to calculate the total Orchestra Back gross revenue.
 

  In cell B12, insert the SUM function with a 3-D reference to calculate the   total Orchestra Back gross revenue (cell G14) for the Friday, Saturday, and   Sunday worksheets.

You are ready to insert a   function to calculate the total gross revenue for the Tiers.
 

  In cell B13, insert the SUM function with a 3-D reference to calculate the   total Tiers gross revenue (cell G20) for the Friday, Saturday, and Sunday   worksheets.

The third section of the totals   worksheet needs to link to a value in another workbook.
 

  Open the Exp19_Excel_Ch09_HOEAssessment_Venue.xlsx   workbook. Go back to the Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx   workbook. In cell B17 on the Totals worksheet, insert a link to the Weekend   Evening value (cell C5). Close the Venue workbook.

The worksheet contains a   circular error. Now you want to find and correct it.
 

  On the Totals worksheet, check for errors and correct the formula with the   circular reference.

You want to create a validation   rule to prevent the user from entering too many seats sold. For now, you will   create a validation for just one input cell.
 

  In cell C6 in the Friday worksheet, create a validation rule to allow whole   numbers less than or equal to data stored in cell B6. Enter the input message   title Seats   Sold and the   input message Enter the number of seats sold. (including the period). Use the   Stop alert with the error alert title Invalid Number and the error alert message The number   cannot exceed total seats in section. (including the period). Test the data validation   by attempting to enter 200 in cell C6 and then cancel the change.

You want to unlock data-entry   cells so that the user can change the number of seats sold in the worksheets.   
 

  Group the Friday, Saturday, and Sunday worksheets. Select the ranges C6:C8,   C11:C13, and C16:C19 and unlock these cells.

Now that you unlocked data-entry   cells, you are ready to protect the worksheets to prevent users from changing   data in other cells.
 

  Individually, protect each sheet using the default allowances with the   password Expl0r!ng.

Create footer with your name on   the left side, the sheet name code in the center, and the file name code on   the right side of all worksheets.

Mark the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

Save and close Exp19_Excel_Ch09_HOEAssessment_TicketSales.xlsx.   Exit Excel. Submit the file as directed.

-need one page 

-VLANs offer significant flexibility in the design and management of network traffic. From segmenting devices attached to the same switch to blending traffic from different buildings, VLANs allow network admins to design logical traffic flows that are not bound to the layout of physical devices. With  great power comes great responsibility, however, as many wise sages have advised throughout the centuries. The question that emerges is, how can you best manage VLANs so they function efficiently and securely? Do some research online for VLAN best practices and VLAN security, and then respond to the following question:

• List some tips for VLAN configuration that increase security and overall network performance.

• Why silicon is used in photonics?
• What are four applications of photonics?
• What are integrated – photonics devices?
• Why is silicon not efficient in optical applications?
• What are risks and benefits involved with photonics?
• Discuss the Wavelength-Division multiplexing scheme and the associated new network topology ( crossbar, delta, ring, mesh, torus) for photonics.

 Discuss the challenges the organization had that limited their profitability and/or competitiveness and how they planned to leverage Cloud Computing to overcome their challenges. 

Assignment Content

1. STOP!  Have you watched the two, past assigned, short videos on APA 7 Title Page and References Page? If not, you must do that first, because this submission requires both. 

   In class today, you were asked to find your first research article that explores your approved research question. (DO NOT ATTEMPT THIS ASSIGNMENT UNLESS YOU HAVE COMPLETED THE PREVIOUS ASSIGNMENT and gained approval: Brainstorming and Research Question.)

   For this assignment, I want you to create a single, APA 7-compliant, Word document. To earn full credit, you must do the following:

   • Page 1 = 20 pts: Proper APA 7 Title Page (watch the video and see p. 31 in the Foundations text to help you create a perfect title page)
   • Page 2 = 60 pts (breakdown below): Simply answer the following questions
   • (1) What is your approved research question from the Brainstorming Research Question HW assignment? (5 pts) 
   • (2) What is the title of the research article you found? (5 pts)
   • (3) Does the article contain the methodology the researchers used to conduct the study/research? To get full credit, you must (a) name the methodology, (b) cut and paste the paragraph from the article that details the methodology, AND (c) highlight indicator words. (30 pts)
   • (4) Does the article contain findings or results of the research? To get full credit, you must (a) cut and paste excerpts from the article that detail the findings (go to Discussion section or at times Conclusion), AND (b) highlight specific words that detail the findings. (20 pts)
   • Page 3 = 20 pts: Create a proper APA 7 References Page with your ONE research article (refer to the video and see pp. 33-34 for the FORMAT you must use to create your reference and p. 32 for a perfect sample of what a References Page looks like.)

 The COSO framework of internal controls is practiced within companies around the world. The objectives of the COSO framework are closely related to its five components. For this week’s activity, please discuss these five components of the COSO framework. Be sure to include each components’ impact on each of the COSO framework objectives. What do you feel an auditor would most be concerned with during an IT audit? Lastly, discuss suggestions for integrating COSO framework compliance into a company in which you are familiar. Your paper should meet the following requirements:

• Be approximately 2-4 pages in length, not including the required cover page and reference page.
• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

You are required to submit a 1,000-word, double-spaced  on: 

What are the threats to personal privacy posed by the Internet, and what actions can you take to safeguard user privacy?

You will use your textbook, the university digital library and online resources with proper citations.

Your paper must have three parts:

1. Review of source(s)
2. Opinion and commentary
3. Citations

________________________________________

Check spec and template.

· Conduct a risk assessment on the network in Figure 1 of the attached document, based on the ISO 27005 standard.

· Write a detailed risk assessment report (in the required structure as detailed in the attached document). 

1. Question : (TCO 4) A variable declared before and outside all function blocks
is visible only in main.
is visible to all functions.
is visible to all functions except main.
is not visible to any functions.
2. Question : (TCO 4) What is the value of i after the following code fragment executes?
int i = 2;
int k = 5 ;
i *= k + 1;
7
11
12
14
3. Question : (TCO 4) How many times will variable i be printed to the screen?
for (i = 1 ; i <= 20 ; i = i + 2);
{
cout << “ “ << i ;
}
10
20
1
0
4. Question : (TCO 4) Which looping statement is best if the number of iterations is known?
If/Else
For
While
Do/While
5. Question : (TCO 4) C++ selection statements include
for, while, do-while.
cout and cin.
if, if-else, if-else if, switch.
#include and using namespace std;.
6. Question : (TCO 4) If firstName and lastName are string object variables, which statement can be used to combine (append or concatenate) the two into a single string variable?
fullName = firstName + lastName;
fullName = firstName, lastName;
fullName = firstName & lastName;
fullName = firstName && lastName;
7. Question : (TCO 4) Which type of error does the following code fragment cause?
int main (void)
{
int MAX;
cout << “Enter array size: “ <> MAX;
int foo [MAX];
for (int i = 0; i <= MAX; i++)
{
foo = i * 2;
}
Compiler: Array size must be known at compile time.
Compiler: Variable MAX cannot be all uppercase.
Compiler: Array subscript out of bounds.
Run-time: User cannot enter a value for MAX.
8. Question : (TCO 4) The code below computes the length of a C-style string. What should the value of FLAG be?
char name[20]= “Lancilot”;
int length=0;
while(name[length] != FLAG)
{
length = length+1;
}
cout << length << endl;
‘’
20
NULL
0
9. Question : (TCO 4) Which type of error does the following code fragment cause?
const int MAX = 500;
int main (void)
{
int foo [MAX];
for (int i = 0; i <= MAX; i++)
{
foo = i * 2;
}
Compiler, because of out-of-bounds array subscript
Run-time, because of out-of-bounds array subscript
Compiler, because of invalid array initialization
None of the above. It does not create any type of error.
10. Question : (TCO 4) What is the declaration for a C-style string that can hold a name with up to 3 printable characters (for example, “Ron”)?
int name [3];
char name [3]
int name [4];
char name [4];
11. Question : (TCO 4) What is the output of the following code?
void func(int x)
{
x = x * 2;
}
int main( )
{
int x = 10;
func(x);
cout << x << endl;
}
20
30
10
5
12. Question : (TCO 4) Which of the following function definitions uses pass-by-values?
int myFunc( int * x, int * y );
int myFunc( int x, int y ) ;
int myFunc( int & x, int & y ) ;
int myFunc( int @ value1, int @ value2 ) ;
13. Question : (TCO 4) Which of the following statements call the following function correctly?
int MultiplyValues (int, int);
int a = MultiplyValues (int x, int y);
int a = MultiplyValues (10, 20);
double d = MultiplyValues (int 10, int 20);
All of the above
14. Question : (TCO 4) What is the output of the following code?
void func(int *x)
{
*x = *x * 3;
};
int main()
{
int x = 10;
func (&x) ;
cout << x << endl ;
}
20
30
10
5
15. Question : (TCO 4) A Distance class has two private members, ‘feet’, of type int, and ‘inches’, of type double. Which prototype correctly declares the copy constructor for such class?
Distance Distance(const Distance &);
Distance(const Distance &);
int Distance(int, double);
Distance(feet, inches);
16. Question : (TCO 4) The word const inside the parentheses of the following declaration of isEqual
bool isEqual (const Distance & rightSideObject) const;
ensures the member variables of the called objects are protected (cannot be changed).
ensures the argument passed in to the function is protected (cannot be changed).
ensures the return value of the function is protected (cannot be changed).
ensures the return value is routed to the proper variable.
17. Question : (TCO 4) Given the following class definition and lines of code, Line 1 in main is a call to what?
class Distance
{
private:
int feet;
double inches;
public:
Distance( );
Distance(int initFt, double initIn);
void setFeet(int feetIn);
void setInches(double inchesIn);
int getFeet() const;
double getInches( ) const;
};
int main( )
{
Distance d1; //Line 1
const int MAX = 100; //Line 2
Distance list[MAX]; //Line 3
Distance d2(1, 2.3); //Line 4
Distance * pDist; //Line 5
d1.feet = 5; //Line 6
// etc. – assume the remaining code is correct
}
The 0-argument Distance constructor
The 2-argument, int, double, Distance constructor
The 2-argument, double, int, Distance constructor
The 1-argument, int, Distance constructor
18. Question : (TCO 4) Creating one class from another in a parent/child hierarchy is an example of
encapsulation.
polymorphism.
inheritance.
abstraction.
19. Question : (TCO 4) Which of the following is a valid declaration to overload the following function?
int whatever (double x);
double whatever (double x);
int whatever (int x);
int whatever2 (double x);
int overload (double x);
20. Question : (TCO 4) How many parameters are required to overload the pre-increment operator for a class as a member function?
None
1
2
No limit
21. Question : (TCO 4) Given the following definitions and statements,
void myFunction (double * dptr);;
double data [10];
which of the following statements correctly calls the function passing in the address of the data array?
myFunction(data);
myFunction(&data);
myFunction(*data);
myFunction(data[0]);
22. Question : (TCO 4) Assume you have to write a class that makes use of dynamic memory allocation (the class needs to allocate and de-allocate memory). According to best practices, where would the keyword ‘delete’ be placed?
Classes are smart data types. The compiler takes care of calling new/delete
It is in the constructor.
It is in the destructor.
It is in a separate, dedicated function.
23. Question : (TCO 4) When writing a class, the compiler automatically creates some support functions for the class. What are some of these functions?
Assignment operator function
Copy constructor
Assignment operator and copy constructor
None of the above
24. Question : (TCO 4) Assume you have to write a class that makes use of dynamic memory allocation (the class needs to allocate and de-allocate memory). According to best practices, where would the keyword ‘new’ be placed?
Classes are smart data types. The compiler takes care of calling new/delete.
In the constructor
In the destructor
In a separate, dedicated function
25. Question : (TCO 4) What is wrong with the following C++ statements?
int * iptr;
double d = 123.321;
iptr = &d;
cout << *iptr;
The cout statement does not contain an endl.
The space following the ampersand should not be there.
The iptr variable cannot be given an address of a double.
All of the above