Portfolio with challenges completed for The Commons @ MUN
Using the attached PDF tutorial from our very own tech guru Rick Kelly, your challenge is to make a .tex file containing: Multiple sections and subsections Table of contents At least one equation A list One other interesting feature (lots of Read More …
Mail Merge gives you a lot of flexibility when it comes to generating the same document for a number of users and purposes. Send ranking scores to 12 imaginary Commons staff. Your letters should include: – their name – their Read More …
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 Read More …
We are using Bheem Seewoodharry challenge to wrap our heads around some fundamental programming concepts through the use of an educational program called “Scratch“. Read the attached tutorial created by Bheem. Your submission will be a short animation and it must include Read More …
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 Read More …
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! TUTORIAL (Conditional Formatting) TUTORIAL (Countif Function) Upload your file as a response to this Read More …
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 Read More …
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 Read More …
It’s the most wonderful time of the semesterrrrr! Create an original, short but comprehensive tutorial on a topic or a function/tool you find really useful that you’d like to pass on. Challenges should only take an hour or two to Read More …
Using this tutorial as a guideline, create a poster sized jpg for YOUR band’s new album: https://www.digitalartsonline.co.uk/tu…toshop/#11 Yes, I realize that most of you are not in bands, but let’s pretend! Post the finished product as a jpg in a Read More …