btt1o_productivity

include component="page" wikiName="jmcintyre" page="course_tabs_header" include component="page" wikiName="jmcintyre" page="menu_btt1o_crumbs" =Productivity Software= The goal of productivity software in business is to enhance communication and to speed up daily tasks associated with a business. Productivity Software encompasses everything from word processing (like MS Word, Google Docs, Open Office, LIbre Office) and spreadsheet programs (like MS Excel, Google Sheets, Open Office, Libre Office) to database software (dBase, MS Access, SQL, Apache). In this course we will examine the following productivity packages supplied by Microsoft under our licensing agreement:

Word Processing - MS Office Spreadsheets - MS Excel Database software - MS Access

 =Word Processing= Some of the word processing software functionality has already been examined in this course. Deliberately the first few assignments introduced you to indents, tables, text formats and fonts. We will go on to examine these in a bit more depth now.



Assignment #9 - Setting up a timetable
In this assignment you'll refresh yourself how to insert tables, but additionally you'll learn about formatting cells in a table, how to arrange the layout of a page, how to align text and how to insert graphics into a Word document.

__**Step 1: Change the page to landscape**__ Click on PAGE LAYOUT on y our ribbon (the toolbar is called a ribbon) at the top. Notice ORIENTATION? Click on that and choose Landscape.

__**Step 2: Arranging table size and location**__ We are going to insert a table that is 8 columns wide by 2 rows tall. We are then going to ensure that it fits the correct size of what we want to see. However, we will wind up with something like this (see left). This is not particularly useful when we want to have a full page table layout like at top. What we need to do is the following:

• Click on your table. Notice the handle on the top left? RIGHT CLICK THE TABLE HANDLE and click on TABLE PROPERTIES. Standard North American paper size is 8.5 inches by 11 inches. [|Other standard paper sizes are found here]. We want our table to be 10 inches wide so under the TABLE TAB we want the preferred width to be set at 10 inches. Yes, inches are a US measurement system, but it is still relatively common in Canada since our software is by-and-large developed in the US as well as much of our commercial business dealings. This leaves 1 inch of unused paper on the side of our table. We want this to be evenly spread out.

• Go to PAGE LAYOUT on the ribbon. Choose the MARGINS dropdown. Now choose CUSTOM MARGINS. Since our table is 10 inches wide and we have 1 inch of unused space, we want the remainder to be evenly split at 0.5 inches on each side. As such, we will choose 0.5 inches on the LEFT and 0.5 inches on the RIGHT.



• Next we will adjust the top and bottom of our table to fill most of the vertical space. We want to leave room at the top for our company logo as a watermark and your name. As such in the PAGE SETUP (where we were before) we want to change the top margin to 2 inches, and the bottom margin to 0.5 inches. This makes the table all compressed, but part-way down the page.



__**Step 3 - Adjusting individual row and column size**__

• Now we want to to make our rows big enough to fill up the space and we can put in our content (your courses). As such we will click on the table to get our table-handle again. RIGHT CLICK THE TABLE HANDLE and click on TABLE PROPERTIES. We want to now click on the ROW tab. We will specify each row to be 2.5 inches in height.

• We also don't need all our columns to be the same size. We are going to allow the breaks to be narrower and the period blocks to be larger. To accomplish this we will hover our cursor over the top of the right column until we see A BLACK ARROW POINTING DOWN. Right click at this point and go into TABLE PROPERTIES as before. Notice now we have a Column number listed (Column 1). Set our preferred width if it isn't already to 2 inches. Next click on NEXT COLUMN (you should be on column 2 now) and adjust it to 2 inches (it should be that already). Click on NEXT COLUMN to adjust column 3 to 0.5 inches. Then adjust column 4 to 2 inches, column 5 to 0.5 inches, column 6 to 2 inches, column 7 to 0.5 inches and leave column 8 at 2 inches



//NB :Now these aren't actually 2 inches wide, it is just a preferred width should the table have sufficient room. If you counted up our space we'd actually be using up 12.5 inches of space including our boundaries, so our columns are actually going to be a bit smaller than 2 inches and 0.5 inches respectively.//

__**Step 4 - Setting up table information**__ • We are now going to set up our table. In row 1 column 1 we are going to put in "Day 1". Notice it occurs in the top left corner of the cell. We are going to center it both vertically and horizontally in the cell. To do so we are going to right click on our cell and choose the icon representing both vertical and horizontal center seen in the image below.

• In row 2 column 1 we are going to type Day 2 and do the same thing with respect to centering it as above. • In column 2 row 1 you are going to put your first period class on a day 1, column 3 will remain empty (your break time) then put in your second period class in column 4 etc... Once complete adjust each of those cells so that the text is aligned BOTTOM CENTER in the cells. Do the same for a Day 2 but in reverse seen as such (picture below)

• Huston, we have a problem. We don't have a header description for each column. We have to insert a column to accommodate this. As such we are going to have to insert a row. To do so, right click on the left edge of the top row and we will INSERT ROW ABOVE. But this destroys all of the planning we did before. so, we're going to go into TABLE PROPERTIES again. We will click on the ROW tab and adjust it so row 1 is 0.5 inches tall, but keep row 2 and row 3 at 2.5 inches. • This allows us some freedom to put in our column headers. Let's do that now by entering Period 1, Break, Period 2, Lunch, Period 3, break and Period 4 in the first row of the table. CENTER THESE COMPLETELY IN THEIR CELL AS WITH THE DAY 1 AND DAY 2 TEXT. You can center multiple cells simply by selecting all the cells at once and adjusting text alignment as in the previous method. You should have something that looks like this:



• Lastly we're going to add the times for each period and for breaks and lunch. So please [|look up the times]and put them under the appropriate block.

__**Step 5: Let's add 37 pieces of flair! ([|reference])**__

• We don't want to do just the bare minimum. We want to do more. We come to MS Word for the whole cheeseburger experience not just the cheeseburger. In light of that we will choose the first row and choose a type of font that has SLIGHT SERIF. That is, it has some flair, but not too much. If Britannic Bold exists, that is what I will continue to use in my example. If not look for something similar to what you see.

• Next we are going to thicken our table lines. To do so we will RIGHT CLICK ON THE TABLE and choose BORDERS AND SHADING. We are going to choose BOX (4) under what it's to be applied to. We will then choose the line you see at (3) for style. And set the width to 1-1/2 point (2). Make sure this says apply to table (1) and you can see a preview at (5).



Yikes - this isn't what we wanted.



We wanted to have the outside border be nice, but we still want inside grid lines. What the presets show at left under the (4) area is for either the box, OR all, OR grid. What we want is a mix of heavy outer box lines, and thinner, stylish inner grid lines. This means we'll use CUSTOM instead. • Go back into BORDERS AND SHADING. We're going to use the preview window at the right side to do our adjustments now. Ensure CUSTOM is clicked on the bottom left (1). Choose the top, regular line under style (2) and ensure the width of the line is 1 point (3). Finally click on the middle icon on the left side of the preview (4) to apply this style choice to the horizontal grid lines of the table, then again to the middle icon at the bottom which will apply it to the vertical lines in the table.



Once complete you should have something that looks like this:



• Let's go ahead and add a couple more pieces of FLAIR. We're going to thicken a few lines and lighten a few others. See if you can't reproduce on your own what you see in this next picture. [hint: you get this by manipulating individual cells and rows - select what you want and try the border options for various row and column and cell combinations - I've used double lines as the line type]



• Next we are going to begin shading. Our breaks aren't important (ok, to you they are, but in terms of our timetable they're place-holders for your timetable). We will select the two cells under the first break by clicking and dragging that column. Once selected you are going to go back into our BORDERS AND SHADING but now we're going to click on the SHADING tab. Choose WHITE BACKGROUND SHADING 15%. Alternatively you can select the SHADING dropdown at the top of the ribbon and choose the 15% grey that way too.



• Next choose your classes and colour code them so that each period is assigned its own colour. Ex. period 1 on day 1 has the same colour that period 2 on day 2 has. Also, choose a colour for your header column and header row ensure it is a dark colour of some kind. Here is what I chose.



• Notice how hard it is to read the titles of the rows/column now though. Let's fix that by changing the colour of our text to white. To do so, go back to the HOME tab on the ribbon. There is an icon that has a letter and a colour behind it (the cursor hover -over tooltip says font colour). Choose WHITE. While that helps we can make it better. SELECT THE TEXT IN THE TOP ROW CLICK ON THE LITTLE BOX BELOW THE FONT ICON. This will pop open a font panel. Keep all the defaults except click on the EMBOSS option. In Word 2010 this changes. EMBOSS IS NO LONGER AVAILABLE AS SUCH. We're going to click on This will make it "pop" out from the page when using a negative colour.

In Word 2010:

• Similarly select all of the sans-serifed content text (e.g. your room #, your courses, and the teacher) and click on the FONT selector and choose SMALL CAPS and BOLD. You should have something that looks like this.



__**Step 6: Adding pictures final touches**__ • Finally - add some last pieces of flair. We're going to add photos in each of our periods to help us quickly identify what subject we're in. To do so, find some photos online we think represent the subjects you're taking. Bring them into __**Paint.net**__. Under IMAGE>RESIZE (or control+R) make sure they're 2 inches in width. When you copy them over and paste them into your table you'll find that they don't fit and make the column bigger right? That's because, if you recall, we set our IDEAL width to 2", but we have too many columns. In fact, you're safer to SET THE WIDTH AS 1.6 INCHES.

• Do this for each of your courses in each of the cells. You should wind up with something like this:



• Two last things now. First - notice how the pictures are all over instead of lined up in the table? That's because they're tied to a spot in the text instead of floating in front of the cells. Also, we're going to add your identifier information at the top of the table. • To that end, right click each picture and change the TEXT WRAPPING to IN FRONT OF TEXT.



• Now position each picture at roughly the same height into each cell and roughly centered IN each cell. Once complete you should have something that looks like this.



• Lastly we're going to add a header image. It will float above the page and be centered. Design it in Paint.NET. Take your business card logo and I want you to size it so it fits and is centered at the top of your timetable. You may need to alter it so it fits, or include things so it has a more appropriate appearance for your page, but generally when you're done you should wind up with something like this (below). WHEN COMPLETE SUBMIT THE ASSIGNMENT into the hand-in folder.



Evaluation
by teacher and documentation of progress in journal), but required reminders on one or more occasions to do so. || Used time poorly (as shown by observation by teacher and/or documentation of progress in journal) in spite of several reminders to do so. ||
 * **CATEGORY** || **4** || **3** || **2** || **1** ||
 * **Diligently follows instruction**
 * ** || Judicious use of elements lead to an exemplary product. || Generation of a product of expected quality || Product approaches expected quality. There are some steps missed or done with a quality that misses what was expected. || Product does not approach expected quality/reproduction. ||
 * **Product fundamentals**
 * ** || Fundamental concepts clearly demonstrated beyond expectations. Product follows convention in a way superior to what was expected. || Fundamental concepts generally demonstrated at level expectations. Product follows convention in a way that was expected. || Concepts generally demonstrated at level slightly below expectations. Product generally follows convention. || Concepts demonstrated at a level below expectations. Product needs refinement in order to approach expectations. ||
 * **Use of Time**
 * ** || Used time well during each class period (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well during most class periods (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well (as shown by observation

 =Assignment #10 - Resume=

One of the most valuable tasks you can complete is to create a resume for yourself (often called curriculum vitae or CV in more professional jobs). You are to use a combinations of tables, colours, and line art to create a resume for yourself. Look on google images and get some ideas and try to recreate one of those using your information. When complete submit the word document into my handin folder. Each job you apply for should have its own, tailored resume that highlights the things that employer is looking for. In this exercise I expect you to read [|THIS]and use tabs and indents in the creation of your resume. I require you to have the following resume CONTENT for a High School Student:

1. Your Contact Information The first section of your resume should include information on how the employer can contact you.

First Last Name Street Address City, Province, Postal Code Phone (Landline or Cell) Email Address

2. Education In the education section of your resume, list the school you attend and any awards or honors (like the National Honor Society) you have earned.

High School Awards, Honors

3. Experience This section of your resume includes your work history. If you have had a job before, list the company you worked for, dates of employment, the positions you held and a bulleted list of responsibilities. If you haven't had a regular job before, it's fine to include positions like baby sitting or pet sitting and any volunteer experiences you might have.

Company #1 • City, State • Dates Worked • Job Title • Responsibilities / Achievements • Responsibilities / Achievements

Company #2 • City, State • Dates Worked • Job Title • Responsibilities / Achievements • Responsibilities / Achievements

4. Skills Include skills related to the position / career field that you are applying for i.e. • Computer skills, • Language skills • Certifications (First Aid, Life Guard etc.)

5. References available upon request There is no need to include references on your resume. Rather, have a separate list of references to give to employers upon request.

Evaluation:

 * **CATEGORY** || **4** || **3** || **2** || **1** ||
 * **Element Choices**
 * ** || The choice of elements like indents and tabs complements the resume style chosen || The product largely reflects good choice in indentation, reflecting the resume style. || The piece has distracting structure and that doesn't aid the professionalism of the resume. || Element choices lead the viewer to be distracted rather than enhance the piece. ||
 * **Presentation & placement of fonts**
 * ** || Stylistic choices show no errors in judgment || Overall the piece is well constructed, but the presentation is somewhat lacking due to choices in font size/readability. || Generally the piece is satisfactorily constructed, but the business card is lacking in many areas (either in font placement, colour, or size) || The piece is incomplete, or shows signs of obvious neglect in presentation. ||
 * **Use of Time ** || Used time well during each class period (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well during most class periods (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well (as shown by observation by teacher and documentation of progress in journal), but required reminders on one or more occasions to do so. || Used time poorly (as shown by observation by teacher and/or documentation of progress in journal) in spite of several reminders to do so. ||
 * **Overall impact**
 * ** || The work clearly readable, and well thought-out || The work clearly reflects the career chosen. It is readable, but in some cases misses the target with either style, colour or placement choices. || Style, colour or placement choices lead the viewer to have a hard time reading the business card or understand the relevancy of the graphics chosen. || The piece doesn't work because principles of design have not been met, or the apparent effort is missing. ||

 =Spreadsheets - Excel in a work environment= [ [|source] ]

Wikipedia defines a spreadsheet as an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations. Functionally, that means you can enter information (data) into cells (the individual unit of data) and manipulate that data. 

Basic Navigation in Excel



 * Opening a File- Excel files have a .xls extension as opposed to a .doc extension for MS Word Documents and a .mdb for MS Access. Excel files are also referred to as Worksheets and Workbooks.




 * Activating a Cell -When you are working with an Excel worksheet, you can activate a particular cell simply by left clicking on it. Active cells are outlined and the corresponding row and column are highlighted.




 * Cell Coordinates -Cell coordinates refer to the row and column intersection in which the cell is found. In this case the intersection occurs at Row 4, Column C.




 * Formula Bar -The formula bar in Excel is where all the information entered for that cell will appear. Depending on what is entered in the cell, you may see text, numbers or formulas/functions here.




 * Worksheets - In Excel, one Workbook you may have many different worksheets. These tabs located at the bottom of the window enable you to control which worksheet you are working on at a given time and allow you to navigate through all of your available worksheets.




 * Scroll Bars -Excel worksheets often have many columns and rows. You can use the vertical and horizontal scroll bars to move around within your worksheet.




 * Keyboard Navigation
 * Left Arrow -- Moves left
 * Right Arrow -- Moves Right
 * Up Arrow -- Moves Up
 * Down Arrow -- Moves Down
 * Control Home -- Returns to cell A1
 * Control End -- Goes to last row, column and cell
 * Control Down Arrow -- Goes to last cell in column with data
 * Control Up Arrow -- Goes to first cell in column with data
 * Control Right Arrow -- Goes to last right hand cell with data
 * Control Left Arrow -- Goes to last left hand cell with data




 * Otherwise you can simply use the mouse to click on cells to make them active and/or use the scroll bars to move around in a worksheet.


 * Data Types**




 * Labels - are typically used as column or row headers or simply to identify whatever you have entered into the cell.




 * Constants - refer to the (typically) numerical data that you have entered into cells. Constants are the entries in your spreadsheet that are not derived from equations or other analysis tools.




 * Function & FormulasFunctions and formulas are expressions that you can use to manipulate or analyze information that you have entered into a cell. These expressions always begin with an = sign.


 * Sorting Data**


 * Select the cells that you would like to sort and then Select **Data** from the menu and click on **Sort**.



 > > > > Or by... > > > Or by > > > > There are a number of different format options in Excel. For example, you may want to specify how numbers in a given cell should appear. > > You may also need to align data within a cell. For example, you can adjust the horizontal and vertical alignment and/or make the characters within a cell wrap to fit a particular cell size. > > This shows how a cell with **Wrap Text** selected will appear. > > You have numerous options available in the **Formatting Toolbar** to adjust the appearance of you spreadsheet. > > To add/remove borders in your spreadsheet, you can use the **Borders Button**. >
 * Alignment & Formatting**
 * Inserting DataTo insert data into a cell simply select it (i.e. make it active) and enter your information. Excel has a useful auto entry function that enables you to simply drag from the bottom right-hand corner of a cell to populate cells in any direction. After a few entries, Excel is often capable of deciphering the pattern that you are creating and can fill in remaining cells based on the pattern. To test this feature, start by typing a sequence of numbers and then highlight those cells and drag downward from the bottom right-hand corner of the last cell you entered data into.
 * Inserting Formulas & FunctionsFunctions always begin with an = sign. You can insert functions just like you are entering text or numbers and when you press enter, the result of your function will appear.
 * Inserting ColumnsYou can insert columns into a worksheet by:
 * 1) Right clicking, and
 * 2) Selecting **Insert** from the menu.
 * 1) Clicking on the **Insert** tab, and
 * 2) Selecting **Columns**
 * Inserting RowsYou can insert rows into a worksheet by:
 * 1) Right clicking, and
 * 2) Selecting **Insert** from the menu.
 * 1) Clicking on the **Insert** tab, and
 * 2) Selecting **Rows**
 * Copying DataTo copy data in cells
 * 1) Select one or more cells
 * 2) Select **Edit** in the menu
 * 3) Select **Copy**
 * Formatting CellsTo format cells
 * 1) Select **Format** in the menu
 * 2) Select **Cells...**

 Statistical Functions
 * Functions**


 * First select a blank cell into which you want your formula to go and then insert a function into the cell by going to **Insert** in the menu and selecting **Function.**




 * The **Insert Function** window allows you to search for functions, or select them by category. You should spend some time getting acquainted with the different functions by scrolling through the list and reading the descriptions that appear on the bottom of the menu.




 * In this example, we are selecting the built-in **Standard Deviation (STDEV)** function from the **Statistical category**.




 * The **Function Arguments** menu is where you specify the cells that you would like to be used in the formula.




 * Here an answer is displayed in the selected cell and the formula appears in the formula bar.




 * Charts & Graphs**

Creating a Pie Chart

 * 1) Select **Insert** from the menu

2. Select the **Pie** chart type and choose your **Chart sub-type** and click next.



3. Click on the **Series** tab to begin selecting cells in order to populate the chart.



4. To select a range of cells to populate your chart **Name**, **Values**, and **Category Labels,** click the button to the right of each blank. A smaller **Chart Source Data** window will appear (as seen below) and you can select a range of cells to populate it. Once you have selected the cells, click the button again to return to the main **Chart Source Data** screen.



5. When you are done selecting values, click **Next**



6. The next screen enables you to adjust various chart options, including how the **labels** will appear on your chart.



7. The final step is to specify where you would like your chart to appear. You can have it appear as a new worksheet or as an object in your current worksheet or others.



8. The finished object will look like this.



Creating a Bar Chart with Two Series
1. Select the **Bar** chart type and choose your **Chart sub-type** and click **next**.



2. Click on the **Series** tab to begin selecting cells in order to populate the chart. Next click the **add** button to begin adding your first series.



3. Select the **Name**, **Values** and **Category Labels** for the first series.



4. Click the Add button again to create your next series. Once again, select the **Name**, **Values** and **Category Labels** for the second series.



5. Make adjustments to the layout and design of your chart. In this example we have added Values to the bar graph.



6. The finished two series bar chart will look like this.



 =Stock Trading using Investopedia= [|Using the following tutorial]you are to navigate the Investopedia website and sign in to the game BTT1OMAC (password macbtt1o). Once in, follow the links in the tutorial and READ what they mean. Every step in the tutorial will be explained in class.

 =Assignment #11 - Stock Research=

You are to create a spreadsheet that tracks stock you want to research. In your Excel spreadsheet you will input the historical data for 20 stocks of your choice for the past 6 months, then compare graphs for each stock and choose 10 to "keep" and start trading.


 * If you're not already in the __**Simulator**__ on [|Investopedia]go there now.
 * Click on __**Markets**__ in your navigation bar at left.
 * If you know the symbols of the companies you want to research, input the symbol. If you don't know the symbols, [|look them up at MarketWatch]
 * Once entered look at the stock overview (picture at right) - it tells you the basics of the stock at present and allows a glancing view of how the stock has performed over time (the graph at the bottom) and the current market numbers (table in the middle) 
 * In the main stock page for your chosen stock - click on __**HISTORICAL**__.
 * Use the default settings for historical. Using a calendar find the market closing information for every Friday for the last 6 months.
 * In Excel, you are to create a column that will be for the date of each Friday, as well as columns representing all 20 business that you chose.
 * Go down to the bottom of the sheet and **__rename it 00-RESEARCH instead of Sheet1__**
 * Knowing that Microsoft has unified much of its products with the ribbon, colour each column according to your desire, and make sure you have logical borders on your columns and/or headers. You may use a style preset if you want for colouring the table.
 * Notice how the date, as you enter it (e.g. 4/10/2015) in some cases looks like how we entered it, but in other cases it says 27-Mar? This is because this first column is considered to be general text. Let's (1) __**highlight**__ the cells of the first column and go up to the (2) __**toolbar**__ and adjust the entry type to (3) __**DATE**__.
 * Once you have entered all of the relevant data you are going to plot out the data by making LINE graphs. The graph will appear on your sheet by default. On the top right of your MS ribbon you'll notice a __**MOVE CHART**__ option (double click your chart if that button it isn't there). Move it to a new sheet and name it with the company that represents that column.
 * Once you have inserted your 20 tables, decide which 10 are your "Keepers".
 * Insert a new sheet called summary, put a small version of each of your 10 keepers on this page (copy/paste from the other sheets)
 * Submit the assignment.

Evaluation
by teacher and documentation of progress in journal), but required reminders on one or more occasions to do so. || Used time poorly (as shown by observation by teacher and/or documentation of progress in journal) in spite of several reminders to do so. ||
 * **CATEGORY** || **4** || **3** || **2** || **1** ||
 * **Diligently follows instruction**
 * ** || Judicious use of elements lead to an exemplary product. || Generation of a product of expected quality || Product approaches expected quality. There are some steps missed or done with a quality that misses what was expected. || Product does not approach expected quality/reproduction. ||
 * **Product fundamentals**
 * ** || Fundamental concepts clearly demonstrated beyond expectations. Product follows convention in a way superior to what was expected. || Fundamental concepts generally demonstrated at level expectations. Product follows convention in a way that was expected. || Concepts generally demonstrated at level slightly below expectations. Product generally follows convention. || Concepts demonstrated at a level below expectations. Product needs refinement in order to approach expectations. ||
 * **Use of Time**
 * ** || Used time well during each class period (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well during most class periods (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well (as shown by observation



Assignment #12 - Market Game
Over the next month and a half, our class will be playing an investment game using real stocks. You will be given $250,000 to start with, and it will be up to you to decide which stocks you will buy and sell over the next 30 days in order to make the most money.

A few things:
 * create a new excel "book" that is called Market Game. In this book you will create new sheets for each of your companies (name the sheets accordingly - e.g. Boeing, Capitol One etc...).
 * In each sheet you will will make the first column a date column. In addition you will make the following columns:
 * OPEN
 * HIGH
 * LOW
 * CLOSE
 * YOU ARE TO GET THE MARKET VALUES FROM THE PREVIOUS DAY EVERY CLASS. Record it in the respective sheet in excel.
 * there is a $20 commission for each transaction (buying or selling stock), so buying and selling a lot is not going to be pay off
 * no one stock can make up more than 50% of your portfolio
 * try to have a diversified portfolio – choose different types of stocks (i.e. gold, tech, oil, etc.) in order to protect yourself from market fluctuations
 * it’s possible that you could earn some dividends (when a company pays its shareholders a portion of its profits), but most of your earnings will come from capital gains (when the share price of your investment goes up)
 * you make money by buying “low” and selling “high”, not the opposite, so don’t panic just because one of your stocks has dropped (in fact, that may be a good time to buy more).
 * don't blow all of your money on day 1. Buy some stock from each of your 10 companies. Sit and hold tight while examining the fluctuations over the next month and a half.
 * YOU DON'T HAVE TO STICK WITH YOUR ORIGINAL 10. If you want to diversify by buying, or selling, do so. In the end, succeeding on the market is a combination of smarts, timing and luck.
 * At the end of the competition, you will prepare a report on how your investment portfolio turned out. You will keep a journal about your transactions – when you buy or sell a stock record your rationale. Why did you choose to invest in that particular company? Why did you decide to sell? This information will be important later on when you submit your report, so record it as you make each transaction so you don’t forget.

__**EVALUATION**__:


 * Most of your mark for this assignment will be based on your report that will include your
 * journal
 * tracking spreadsheet
 * As an extra incentive part of your grade will be based on rank in the class in terms of the value of your portfolio at the end of the game, so invest wisely!

The competition starts April 14th (Tuesday)

 =Assignment #13 - Creation of a Paystub=

You are to to create the above paystub in Excel. The first sheet is going to be the paystub iteslf as seen EXACTLY as above (you'll have faint grid lines in your sheet, but those won't print). The difference is that you'll replace the sample company name/address with the fictitious company you have been using so far over the past few weeks (and throw your logo in on the header someplace).



Step 1: Setting up sheets

 * You are to create a few sheets. The first, as mentioned above, will be called the Paystub. Sheet 2 is going to be called EMPLOYEES and the third is EIN (employee identification number).
 * Using your knowledge of borders, and background shading set up the paystub so it looks like the picture above (minus the yellow). Yellow cells are, for now, going to be blank.

Step 2: Entering Raw Data

 * You are to enter the following employees to your company in the employees sheet.
 * Xurxo Abreu
 * Johannes Vinter
 * Una McClellan
 * Hudson Morin
 * Rune Fernández
 * Raymond Chevalier
 * Nuh Albaf
 * Ama Afolayan
 * Dione Hollands
 * Talulla Hanigan
 * Still in the employees sheet - as a series of columns next to the employees name enter the dates of the work week (use the existing work dates) and the number of hours worked (to be given later on in the assignment)
 * Use [[file:btt1o_hours_worked.csv]]for their hours worked
 * In a column at the far right you are to create a weekly total category. Using your knowledge of the [|SUM function]in excel, tally their weekly total.
 * To the right of the Week Total create a column with OVERTIME (anything greater than 44 hours is considered overtime). Use [|the IF function]in EXCEL to automatically calculate this number. For example, if Xurzo, as in this case, worked 38.65 hours, he doesn't qualify for any overtime, thus it would be 0. I find saying an IF statement out loud works well to figure it out. E.g. IF the HOURS WORKED is GREATER THAN 44 THEN show OVERTIME only. Mathematically this works out pretty exactly. IF hours>44 then(hours worked - 44) = Overtime.
 * Now, create a column to the right of Week Total that lists YEARLY TOTAL. Make up a realistic # of hours based on 40 hour work weeks and based on this being the 14th full week since January.
 * To the right of the YEARLY TOTAL, create one last column called YTD GROSS Pay (which is the # hours * their base salary of 22.50/hour). Assume there's no overtime prior to this week.

Step 3: EIN sheet

 * On your EIN sheet you will have 2 columns. Employee name and EIN
 * make up a random 4 digit employee number for each of your employees.

Step 4: Setting up formulas for paystub

 * Now is when you're going to enter the formula information on to your paystub for Xurxo.
 * Where the yellow field where John Smith is, press EQUAL SIGN and link it to your first employee on the EMPLOYEE sheet (Xurxo).
 * On the paystub, under employee ID, link the # to the sheet in which it can be found (EIN sheet). To enter this link you simply press the equal sign, then click on the sheet EIN and click on Xurxo's EIN.
 * Do the same for PERIOD ENDING, PAY DATE (which in this case is the period ending).
 * For the CHECK NUMBER enter a random number (normally, this would be for tracking in a company).
 * For YTD GROSS PAY grab the numbers for Xurxo from the EMPLOYEE sheet.
 * You are to give them all a base salary of $22.50/hour. If they work overtime they get time and a half. Overtime is when you work > 44 hours per week.
 * Under RATE list 22.50 for regular and $33.75/hour for overtime.
 * Using Xurxo's weekly hours, calculate his Current Total for REGULAR income.
 * Using Xurxo's overtime hours, calculate his current total for OVERTIME income.

Step 5: Deductions

 * Here is the schedule of deductions based on pay. Please note, they're more complex than what's being listed below, but assume all employees receive the EXACT SAME deductions.
 * CPP - 3.8%
 * EI - 1.7%
 * Income Tax - 19%
 * Union Due - 0.6%
 * Life Insurance - 0.3%
 * LTD - 0.6%
 * CSB's - 0.7%

Step 6: Finishing up

 * To finish the paystub, you are going to calculate Xurxo's current pay. It is the $ made from regular pay plus the $ made from overtime. This goes into CURRENT TOTAL (e.g. put the forumla into the CURRENT TOTAL spot that reflects [# hours * $22.50 + # overtime hours * $33.75]
 * Pull in the YTD Gross info from the EMPLOYEES sheet. Add to that the current pay GROSS TOTAL. Assume YTD deductions are 26.7% of their paycheque.
 * Make a formula for YTD NET PAY (e.g. yearly gross minus ytd deductions).
 * Tally up the deductions in the deductions area and have it display in the DEDUCTIONS area.
 * The NET PAY will be the CURRENT TOTAL minus the DEDUCTIONS.
 * Right click the paystub sheet and choose MOVE or COPY. You're going to copy and name it XURXO
 * repeat this process for each other employee. See if you can't find a fast way of doing it for everybody (HINT: edit the forumlas so that all you're doing is grabbing a new cell)

Evaluation
by teacher and documentation of progress in journal), but required reminders on one or more occasions to do so. || Used time poorly (as shown by observation by teacher and/or documentation of progress in journal) in spite of several reminders to do so. ||
 * **CATEGORY** || **4** || **3** || **2** || **1** ||
 * **Diligently follows instruction**
 * ** || Judicious use of elements lead to an exemplary product. || Generation of a product of expected quality || Product approaches expected quality. There are some steps missed or done with a quality that misses what was expected. || Product does not approach expected quality/reproduction. ||
 * **Product fundamentals**
 * ** || Fundamental concepts clearly demonstrated beyond expectations. Product follows convention in a way superior to what was expected. || Fundamental concepts generally demonstrated at level expectations. Product follows convention in a way that was expected. || Concepts generally demonstrated at level slightly below expectations. Product generally follows convention. || Concepts demonstrated at a level below expectations. Product needs refinement in order to approach expectations. ||
 * **Use of Time**
 * ** || Used time well during each class period (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well during most class periods (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well (as shown by observation

 =Assignment #14 - Survey=

Create a list of every student in the class:
 * Day ONE**
 * Create a column to record each student's WEEKLY TIME ON COMPUTER and WEEKLY TIME WATCHING TV
 * Create a column that totals each student's "screen time"
 * Create totals at the bottom of each column that SUMS the total class time on each activity
 * Create a GRAND TOTAL of "screentime" hours spent by the class.

Use your results to answer the following questions:
 * 1) How many hours per DAY does the average student watch TV?
 * 2) How many hours per DAY does the average student spend on the computer?
 * 3) How many TOTAL HOURS does the average student spend on "screen time"?

Gather MORE data to record Use appropriate functions to determine if there are correlations between the TYPE of screen activity, and the gender of the user. Create a __**stacked bar graph**__ to graphically present your findings
 * Day TWO**
 * Lastnames
 * Video Game Time
 * Gender

Evaluation
by teacher and documentation of progress in journal), but required reminders on one or more occasions to do so. || Used time poorly (as shown by observation by teacher and/or documentation of progress in journal) in spite of several reminders to do so. ||
 * **CATEGORY** || **4** || **3** || **2** || **1** ||
 * **Diligently follows instruction**
 * ** || Judicious use of elements lead to an exemplary product. || Generation of a product of expected quality || Product approaches expected quality. There are some steps missed or done with a quality that misses what was expected. || Product does not approach expected quality/reproduction. ||
 * **Product fundamentals**
 * ** || Fundamental concepts clearly demonstrated beyond expectations. Product follows convention in a way superior to what was expected. || Fundamental concepts generally demonstrated at level expectations. Product follows convention in a way that was expected. || Concepts generally demonstrated at level slightly below expectations. Product generally follows convention. || Concepts demonstrated at a level below expectations. Product needs refinement in order to approach expectations. ||
 * **Use of Time**
 * <C4>** || Used time well during each class period (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well during most class periods (as shown by observation by teacher, and documentation of progress in journal) with no reminders. || Used time well (as shown by observation

 =Relational Databases= A database is an organized collection of data. The data is typically organized to model aspects of reality in a way that supports processes requiring information. For example, if we a sales company it is valuable to keep track of inventory and prices for that inventory. Both cost OF those products, then sales price FOR those products. We are going to use Microsoft Access to that end - which is a relational database management system (DBMS). At the most basic level, a DBMS is a program that facilitates the storage and retrieval of structured information and clearly falls under the database umbrella. Other software packages that are database managements systems are MySQL, PostgreSQL, Microsoft SQL Server (whose front-end is MS Access), Oracle, Sybase and IBM DB2. Access can provide the graphical front-end for many of the other database softwares listed as well.

We are going to use [|this package] developed by Michael Brydon at UBC over 18 years ago. Interestingly, much of the information used within is still valid.