CS w4 – Linux Terminal – Basics

Little bit simpler challenge this week, as we return to the basics of the almighty Linux Terminal! Either in Terminal on Linux or through PuTTY, screenshot a session of you completing the following:

1.       Opening the manual of a command (add a separate screenshot showing you have a manual open for this step);

2.       Creating a directory;

3.       Navigating to the directory;

4.       Listing contents of the directory;

5.       Creating a .txt file;

6.       Adding some text to the .txt file using Vi (add a separate screenshot showing you have Vi open for this step);

7.       Outputting the text of the .txt file to the terminal.

You can include multiple steps on 1 screenshot (e.g. steps 2 -5 can all be in one screenshot), but attach as many screenshots as needed. Include these as image files.

This tutorial (section 1 to 6) should have all information needed to complete steps 1 – 7: https://ryanstutorials.net/linuxtutorial/

I don’t think I learned a whole lot from this challenge as we had some something really similar in the past. However, I think it was a good refresher for using Vi, a tool which I’m still not entirely comfortable with.

CS W6 – Access – Tables, Forms, and Queries

Following the attached tutorial document, create your own Microsoft Access database file with tables for Customers, Products, and Orders (with the same fields and formulas as the tutorial, for example date should be auto generated using “=Now()”). Create at least 5 records in each table, showing a completed “Orders Query” in your file that displays customerId, first name, last name, product name, and price.

Quick note on section 3 – if you get an error when trying to create the data relationships, make sure your other tables are closed and saved.

 

CS W5 – PowerPoint – Templates

Create your own “The Commons” PowerPoint template (following the “Creating a Template” instructions below) of at least 5 unique slide layouts. Your template should have images and background(s). Use your template to create a 8 slide slideshow showcasing the Commons services with pictures and information (pictures, etc. can be found on our webpage). Attach both the PowerPoint you create (.pptx) and your template file (.potx) in your reply.

Creating a Template – https://support.office.com/en-us/artic…f8169c8aca

Complete file HERE

For this challenge, I think I made good use of the image editing tools available on PowerPoint. Firstly, I used the “set transparent color” tool to remove the background on each picture, and then I inserted the edited picture as a fill in a polygon so that I could also change the transparency settings.  I also tried using soft edges effect on Dilbert’s image and I think it turned out really nice.