Category Archives: CS Winter 2018

CS Challenge W10

Question: Create an excel file with your marks for a hypothetical course. You are heading into the final exam and trying to figure out with grade that you need to get on the final exam to get a mark good enough to get into grad school.  You will use Excel’s What If function to figure this out. Create a second column of data. Enter in how many hours that you studied/worked for each assignment/test. Create a bar graph with TWO data series, one for grades and a second for the hours .

Answer: Link to Excel sheet

CS Challenge W9

Question: Creating your own graphics can make a presentation or report look really slick! Create a fake logo using the free image editor Gimp You will probably need to download and install it if you do not already have it on your computer.
Add your own initials inside the sphere and unique gradient colours. Save it will as a PNG with a transparent background and post the png as a reply to this tread.

Answer: 

CS Challenge W7

Question: In Excel, demonstrate conditional formatting, the countif function, and 1 other function of your own choosing. You will need to find or create your own data for this!

Answer: Conditional Formatting: Cells highlighted if the value of the units and the total were between the numbers 60-100
Countif was used to see how many of the dates were above 11/01/2016
And for the use your own, I used the sum function to calculate the added total of blocks E9 to E14

File Link: CS.w7

CS Challenge W6

Question: Using the web based Sketchup, create a dream house for your ideal pet (I prefer cats myself). Focus more on architectural design than objects imported from the 3d warehouse please.

Answer: 

For the record I hated this buggy awful site.

CS Challenge W5

Question: Use the following excel file and data to present net value (total worth) and future net value (ignoring compounding). Here are the formulas that you will need. Use absolute cell referencing in your equations.
PNV (present net value) = savings – debt
FNV (future net value) = (income * saving % * 30) + (income * saving % * 30 * interest) + PNV
Use conditional formatting to highlight in the cell in green with the highest number for each category of income, savings, debt, saving %, PNV and FNV. Do the same for the lowest number in yellow.
On a separate sheet, make a bar graph with two series of data, future net value and present net value.

Answer: CS.w5.W2018

Screen capture: 

CS Challenge W4

Question: The challenge is to use VLOOKUP function, one of the lookup and reference functions. You should use VLOOKUP when you need to look in a single row or column and find a value from the same position in a second row or column. More info in the attached PDF.

Answer: 

CS Challenge W2

Question: Your submission will be a short animation and it must include THREE animated sprites. One of the sprites should be a cutout image of YOU! You are able to erase the background in images within Scratch. Post your finished product as a youtube video in a reply to this post.

Answer:

https://scratch.mit.edu/projects/200034993/

CS Challenge W1

Question:  Find a sample document online that is approximately 2 pages (or one that is bigger and just use 2 pages of it). Go by the attached pdf tutorial and use the Tracking changes and comments feature on word to revise and edit a document.