Assignment Introduction and Leaming Goals

This is an MS Excel assignment and therefore you will require MS Excel to complete it$.$ This assignment will provide you the opportunity to leam, or exercise your MS Excel skills. The topics are somewhat randorn, but as you progress through your other courses you will be using the content reviewed in this assignment.

Course Learning Outcomes

CLO$8$: Generate and interpret project reports

CLO$9.$ Transfer project $$ata to and from other software programs

Assignment Value

Please refer to the grade section of FOL for assignment weighting.

Assignment Instructions

This is an individual assigament. Thut meass that there is to be no sazisting ofhere. You do this on your own' If you have grastiont yoe can aik me wiz email, in class grabefore'sfler

You will be creating a new woribook with multiple wordabeets. You muat follow the pill be requireif to create a time series table with various althbutes and a chart.

Complete the following.

Create a new MS Excel Workbook and name it A$01-$yourlastname. studentid.xkx $($ypurlastrame$,$ should be bow it is refiected in FOOL, even if that is not how you normally represcat your how you normally represcat your latame$)$

Create a new workabect named "Owoall:

In A$1,$ A$2,$ A$3,$ A$4$ and A$5$ put this text respectively, "Lart Name"," "First Name",

"Studert Id$",$ "Due Date of Asnignment" ad "Starting Balance"

Sire the colum so titles fit without wapping

In Calumin $B$ fill in the approprixte values based on the titles from column A and for $6.$ Format the date to diplay as yay$-$mm$-$dd

Format the Sterting Balsoce to be gurency with $2$ digits afler the decimal.

For the next section you will create a timesecties dataver. In Cell C$7$ deraibe the $1.$ Must have $3$ different salues $($clas satiafy these requiraments:

Must have $3$ different values $($class exumple had max temp, min temp, mean teryp and precipitation. Do mot nse these$)$

Must have $6$ dafes $($claus example had $22$ values$)$

Format the cell $30$ all the text is visble $($hint row beight, column witth$)$

Insert a pew worksheet named "Perronal Time Series Data:"

Insert your data with tttes starting in A$1.$ Do not pur blunk rous or colianns!

Insert Data titles in the zcroes columns. See step $8$ for number of onhmmes

At the botrom of each cohem add the following summary rows

Label "Total" $-$ total without uning the sum functivn $($Hint: you can use $+)$

$2$ Label "Total$2"-$ total with a finction

Label "Average" $-$ average of colurrin data

Label "Largest" $-$ largest number

Label $\text{'}$Std$.$ Dev."$-$strodard deviation of columais data $15.$ Format the table:

Bold the columnirow titles mad the columin summary data

Decimal numbers should ouly tave $3$ digits past decimal

Insert a new wocksbeet named 'Arsagnonat Time Series Data" hyperlinkl$)$

In cell A$2$ pat this text "Date"

In B$2,$ C$2,$ D$2,$ E$2,$ F$2$ put the dates starting at $04.15$ mad incrementing by $1$ day $($the year should be $20$ ancic the last $2$ digits of your stadent id$,$ examule ny$.$ id is $123456\%.$ would put $2056$ as the year$)$

Format the dates to look like: Janaary $11,2006$ and adjut columns $90$ we can read them.

In A$3,$ A$4,$ mad A$5,$ A$5$ mat A$4$ put the leat repectingh: "Actrinty $1",$ "Actraty $2^2$;

"Activity $3",$ Total" and 'Cumulatre Iobl"

Fill in the eftimated $*$ of bours for esch Actrity on ench dor $=$ rou would like $($B$3$ trouph, F$?)($B$3$ trough, F$5)$

Use a fimetion to calculate the toet of the row tithed Tibar

Add a column to get tcals fir each tork and the total of this serw column.

Create a line churt of the cimmlative data and ineet lyaide the talle inclading the followng information:

Gart title

Axis $x$ and $y$ titles med labels

Legend Time Saries Dota

Sive the Excel file Submit the fle into the FOL. stersaces wecticn fre Exoel