Jaqvascript Landing Page

 

For this project, you will be writing most of your code in js/app.js

Rubric Tip: All the points mentioned below will help you to satisfy the criteria for the project rubric. Please make sure to re-review the rubric for detailed project requirements prior to submission.
Start by linking your app.js.
Build out your HTML and at least 4 content sections. The rest of your functionality relies on these sections.
Take a quick look at all the HTML elements in index.html. Note the values for their id, class, and data attributes.
Think about how you can create, say, an unordered list (i.e., bulleted list) in HTML from this structure, and where you be placing that list.
Think about how you’ll test whether a section is in the viewport.
What actions are you performing that will cause interactivity with the DOM?
Build the navigation menu.
Add functionality to distinguish the section in view.
How can we use classList methods to change the CSS being displayed? What about removing that CSS?
Add the functionality to scroll to sections
Add an active state to your navigation items when a section is in the viewport.
Detect the element location relative to the viewport using .getBoundingClientRect() built-in function.
Set CSS class active state when the element is in the viewport.

Exp19 Excel Ch04 HOEAssessment Investments

 Exp19 Excel Ch04 HOEAssessment Investments

  

Exp19_Excel_Ch04_HOEAssessment_Investments

Project Description:

You have been hired as a junior financial analyst at Bristol Investments. As part of your tasks, you will help track transactions, commodity prices, and broker efficiency. To complete the task, you will create an Excel table, use data filters, conditional formatting, and lastly you will prepare the document to print.

     

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

 

Create a table named Transactions based on the data in the Range   A4:E248. 

 

Freeze the first row containing   column headings. 

 

Apply White, Table Style Medium   4. 

 

Add a new column named Percent   Change

 

Enter a formula in the Percent   Change column using unqualified structured references to calculate the   percent change between the commodity purchase price and the current price.   (Purchase Price/Current Price).

 

Apply Percentage Number format   to the range F5:F248.

 

Add a Total Row to the Percent   Change column. Set the totals to display the average of percent change   column. 

 

Apply Solid Blue Data Bars   formatting to the Percent Change column. 

 

Filter the data to only display   Stocks and Bonds.

 

Sort the data by Broker, then by   Commodity, then by Purchase Price. 

 

Click and drag to set the range A4:F249, which is the   Transactions table, as a print area. Be sure the value [#All] follows the table name in the Print area box.

 

Set row 4 to repeat when   printed.

 

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

Unit 5 Practical – Packet Filtering

  

United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following description of operations, create the appropriate fully labeled Crow’s Foot ERD.
Volunteer carry out the tasks of the organization. The name, address, and telephone number are tracked for each volunteer. Each volunteer may be assigned to several tasks, and some tasks require many volunteers. A volunteer might be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment.
 

Each task as a task code, task description, task type, and task status. For example, there may be a task with task code “101” a description of “answer the telephone” a type of “recurring”, and a status of “ongoing.” Another task might have a code of “102” a description of “prepare 5,000 packages of basic medical supplies,” a type of “packing and a status of “open”.
 

For all tasks of type “packing,” there is a packing list that specifies the contents of the packages. There are many packing lists to product different packages, such as basic medical packages, child-care packages, and food packages. Each packing list has an ID number, a packing list name, and a packing list description, which describes the items that should make up the package. Every packing type is associated with only one packing list. A packing list my not be associated with any task, or it may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list.
 

Packing tasks result in the creation of packages. Each individual package of supplies produced by the organization is tracked, and each package is assigned an ID number. The date the package was created and it’s total weight are recorded… A given package is associated with only one task. Some tasks (such as “answer the phones”) will not produce any packages, while other tasks (such as “prepare 5,000 packages of basic medical supplies”) will be associated with many packages.
 

The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different items, and a given item can be used in many different packages.
 

Each item that the organization provides has an item ID number, item description, item value, and item quantity on hand stored in the system. Along with tracking the actual items that are placed in each package, the quantity of each item placed in the package must be tracked as well. For example, a packing list may state that basic medical packages should include 100 bandages, 4 bottles of iodine, and 4 bottles of hydrogen peroxide. However, because of the limited supply of items, a given package may include only 10 bandages, 1 bottle of iodine, and no hydrogen peroxide. The fact that the package includes bandages and iodine needs to be recorded along with the quantity of each item included. It is possible for the organization to have item that have not been included in any package yet, but every package will contain at least one item.