Using our external flash and wireless triggers, create six versions of someone portrait as illustrated in the attached handout. Combine all six headshot into a single jpg and post as a reply.
The trigger attached to the flash should be set to “Rx”. The trigger attached to the camera should be set to “Tx”.
Week 10 – Excel
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.
https://www.gcflearnfree.org/excel2016…nalysis/1/
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 .
Post your completed excel file in a reply to this thread.
Below are the table and chart that resulted from this challenge.
Week 9 – Gimp
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. https://www.gimp.org/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. Tutorial https://www.gimpshop.com/tutorials/how…ate-a-logo
Week 8 – Mail Merge
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 overall score
– separate scores for customer service, technical and professionalism
– 1 short comment about something they do well.Additional tutorial if helpful
Tutorial (text, no audio needed) for 2007 but should function the same
This a very interesting challenge that might be really useful in the future. The guide was very straightforward and I thought it would be nice to use names commonly seen in Brazil. Here are some screenshots:
Week 7 – More Excel
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!