Question:

INSTRUCTIONS Copy this card, assign it to yourself and add your name to the title. All submissions should be on your copy. Unclick “Keep Members” when copying the card. Move your card to “Week X Completed” when finished. Do not check the “Due Date” when finished, I will check this once reviewed.

CS W10 CHALLENGE
Create a challenge that showcases a software/tool/function/etc. that you find useful and would like to pass on to others! Your challenge should include a concise tutorial of how to complete the challenge, along with what the goal of the challenge is. The tutorial should not be a general “guide” but rather tailored to the specific area you are focusing on. The tutorial should be created by you, and not copied directly from other material online (you are free to use any other tutorials as reference, just do not copy-paste them). Challenges should be able to be completed in about an hour.

Possible topic areas include:
– Microsoft Office Suite (Word, Excel, Powerpoint, Access, or Publisher)
– Linux (Terminal commands, Linux specific software, Utilising a Linux OS)
– AT Software (Kurzweil, Dragon Naturally Speaking, Read and Write Gold, Inspiration)
– Programming (Scripting, web programming, language concepts)
– Any other area you’d like to focus on (See me for approval first!)

This one is a bit more open ended than our usual challenges, and as such, if you’re questioning your idea, please don’t hesitate to talk through it with me first, rather than finish it only for it to not meet the requirements.

Answer:

CSW10.Final

Question:

Pivot Tables are a powerful way to display and organize data in excel. Following the below instructions, create a pivot table from at least 3 columns and 20 rows of data (use your own created data or data found online). Modify your pivot table after generation to customize the way the data is presented in some way. Additionally, add a pivot chart to give a visual representation of your data. Submit an image of your finished table and chart as well as the excel file.

Answer:

Question:

This challenge comes from Jacob House! This one is a bit more open ended than usual. Using one of the tools Jacob mentions in the challenge document (or any other alternative, draw.io is another online, easy to use chart tool that I recommend) complete a flowchart showing steps to complete some work related task/fix some work problem (it does not have to necessarily be a LabNet issue as outlined in the document, it can be a flow chart for any work related task such as completing the rounds, helping a client with email set up, troubleshooting a faulty monitor, helping with excel formulas, etc.) I’d like these flowcharts to be as accurate as possible, so if in doubt please consult the documentation on Bitrix or ask a supervisor for clarification before submitting. This challenge is more about the troubleshooting process, so accuracy is crucial.

Answer:

Question:

Using your own created data (at least 3 columns and 6 rows), follow the below linked instructions on how to create a combination chart in excel. Create a combination chart with one series on the primary axis and one on the secondary axis, separate axis titles and labels, a graph title, and graph legend. Include your submission as an excel file.

Answer:

Question:

The return of sololearn! This week, we’re going to learn a bit about HTML. Complete at least the first 3 sections of the HTML course on https://www.sololearn.com and post a screenshot of your progress.

For those of you already familiar with HTML, you can click the “Take A Shortcut” button to be tested on your proficiency and get credit for all the sections previous to the test. Feel free to utilize this if you feel comfortable enough with the language already.

Answer:

Question:

This week’s challenge comes courtesy of Anush! Following the attached tutorial, create a brush photo in PowerPoint with an image of your choosing. The font used to style the photo and styling of the brush photo that comes out is up to you!

Answer: