CA-Assignments

Computer Applications does NOT use "TextBook" - we will have on-line assignments.

If you have any questions please feel free to call JilMac 802-254-8628

• SPRING 2021 - Jan 27, 2021 - May 5, 2021 ZOOM Wed Morning 8:30-10:30 am

• Grades: All work to be included in Grade by Tuesday before Midnight on May 11, 2021

I enjoy working with students One-on-One using Online Meeting software: Google Hangouts, Zoom, Skype, etc. plus students who use a One-on-One will get an extra credit point(s). It is the fastest way to solve issues!

Each Assignment will have a Microsoft Office component & a Google Document/Drive component

This way - you do NOT have to purchase any software, but you WILL have to have Internet Access (note: for those students with Limited Internet Access - I have some alternative coursework - Call to discuss)

ASSIGNMENT01 Intro to our Class + Word

Welcome https://www.youtube.com/watch?v=wCPl4gl-SQw

2. Research:

What we have learned so far in WORD Processing - how does that compare to Spreadsheets? Go over what is a Spreadsheet, how is it different than a Document?

What is the Difference Between a Number (1-9) and a Letter (A-Z) ??

https://drive.google.com/open?id=1wO4T1IZJSNWsxUavaBv7P-OPk2CDSq17gWJmRgqwNXE

2. Research:

OK - I said we would start learning about Spreadsheets - although TABLES and Graphics in Word, they are the beginning of understanding Spreadsheets/Excel.

watch https://edu.gcfglobal.org/en/excel/ exercises & videos

Graphics is a HUGH subject. If you find graphics interesting than these courses would be of interest:

· ART-Digital Photography

· CIS-Digital Image Manipulation

· CIS-MultiMedia

Depending on your computer systems, including phones and tablets – there are a variety of image manipulation applications. I use Paint(because I have a windows computer. Mac’s have their own) and Adobe products. Adobe Photoshop - the term "Photoshopping an image" I think is well known. But over the semester we will be doing quick fixes on images, pictures & drawings. Images are more important than ever. To make your Documents interesting you must vary the paragraphs with: Images, Tables, Lists, Indents and Fonts.

I want you to research Images on the Internet. Find me 3 training video/tutorial for 3 of these:

1. Paint ........................................ this is on EVERY Windows computer, Mac's have something

2. Photoshop … Adobe product installed on CCV computers a Standard when looking for jobs.

3. Google+'s Photos Editor ...... everyone who has a gMail address has access to this.

4. GIMP.org https://www.gimp.org/ is a very powerful and opensource (free) graphic editor.

5. And/Or the graphic editor on your computer, phone or tablet.

Give me 100+ words PLUS THE LINK for each and links the tutorials you found interesting & upload to Google Drive.

Note: Free Graphic editors with LAYERS are available such as Paint.NET & Gimp. You are free to use any – but you should use several to get a feel for the differences.

3. Before & After:

• Create an Assign04 folder in your CompApp folder in Google Doc/Drive, put your .xls and/or .xlsx files

• Share it with JilMac.MacRand@gmail.com

• From the Video Training

• select 3 types of documents and demonstrate what you have learned. Note: .xls and .xlsx extensions

  • Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions http://www.gcflearnfree.org/office2013/excel2013 <--unless these don't work for you

4. Extra Credit Ideas - for 1 point extra credit

• What makes a Computer a Computer series https://www.youtube.com/watch?v=mCq8-xTH7jA&index=2&list=PLzdnOPI1iJNcsRwJhvksEo1tJqjIqWbN-

• -or-

  • Give JilMac a call and do an Online meeting - to answer questions or clarify anything - or to just see how Online meetings work.

ASSIGNMENT05 Spreadsheets

Assignment05 of 14 Research due in 1 week, B+A may take more time.

• Updated: 06/09/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set-up

1. Read:

1. On the Handouts page View, Download and read the Computer_Apps_Assign05-14.doc & the Amortization for Excel & Google Sheets!!

2. Watch http://Support.Office.com Excel Advanced NOTE: the handout has Advanced Excel features JilMac feels you should know about because they make you work "More Efficient". Learn how to make Excel work for YOU!

3. NOTE: If you already think you have the Beginner basics - skim it and concentrate more on the Intermediate

4. NOTE: If you don't have the basics YES, then concentrate on the Beginner and skim the Intermediate.

   1. SPEND A FEW MINUTES THINKING ABOUT .....What we have learned so far in WORD Processing - how does that compare to Spreadsheets? Go over what is a Spreadsheet, how is it different than a Document? Have you learned OTHER things that Spreadsheets can do that you had NO IDEA you could do this easily??

      1. Amortization Schedules - Do you know what they are? Do you have one for anything you have borrowed money for? ex: Car, Home, etc. Watch JilMac's Amortization Video

• • Part 1

• Part 2

2. Research:

Spreadsheets are powerful - give me

• 2 tutorials about Excel Graphs (YouTube or a written tutorial. give me with 50 words - what you learned. Include your Links. Copy and Past an EXCEL Graph into the Research Document ... because it is JUST A GRAPHIC! You can Paste it into Paint and add Detail or other Graphics.

• 2 tutorial about SORTING in Excel - Cut and past the cells that you started with, and then the cells after you sorted them. give me with 50 words - what you learned. Include your Links.

• Note: You could substitute a Amortization Schedule tutorial if they interest you. Or do an Amortization Schedule as Extra Credit

3. Before & After:

1. Create an invoice - from a Template in either Excel or Google Spreadsheets - how is this different from a Word doc??- to Bill me for a project. If you are having trouble thinking of what to do ... bill me for a project. Fill it in for the HOURS and WEEKS you have spent working on MicroComputer Applications, CREATE A GRAPH of Hours/Weeks. In your section of "What I learned" you could explain how creating an invoice in spreadsheets is different from creating one in word processing.

2. Do an Amortization Schedule where you compare interest rates, loan amounts, number of years, etc.

3. Select another Spreadsheet example from the text of your choosing.

Upload the Before & After Documents and share them with JilMac.MacRand@gMail.com

• • Create an Assign05 folder in your CompApp folder in Google Doc/Drive

  • Share it with JilMac.MacRand@gmail.com

  • From the Video Training

  • select 3 types of Excel documents and demonstrate what you have learned.

All documents in your Google Shared Computer Applications folder should have sub-folders with each of the 14 Assignments, Automatically Share with JilMac since the folder they are in is shared. Test This in Workshop.

ADVANCED: 3 EXTRA CREDIT POINTS!!! Have you enjoyed Excel? Did you know you can write programs in Excel? Try this tutorial

https://www.freecodecamp.org/news/excel-vba-tutorial/ Show me your examples with a LINK to them - and what you thought about it 100+ words.

ASSIGNMENT06 Spreadsheets + Graphics (A chart is a graph! )

Assignment06 of 14 Research due in 1 week, B+A may take more time.

• Updated: 6/16/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to setup

Graphic Editors: Paint & Pixlr.com (note: Pixlr used to be part of Google+ & Picassa which is being replaced by Google Pictures)

Paint & Pixlr.com Resizing Photos

1. On the Handouts page View, Download and read the Computer_Apps_Assign06-14.doc & the Vermont Population spreadsheet!!

   1. Read/Watch video above, start including images, icons & graphics into each spreadsheet you create

   2. Watch the videos listed in the Computer Apps handout

2. Research:

Spreadsheets are powerful - give me 3 tutorials about Google Spreadsheets (YouTube or a written tutorial). Tell me with 100 words each - what you learned. Include your Links.

http://www.gcflearnfree.org/office2013/excel2013 exercises & videos 17-28

Freezing Panes, Sorting Data, Charts, Protecting, Filtering, What-IF Analysis and more!

PLUS write up from the READ above.

3. Before & After:

Here are 3 solid examples:

Amortization Tables with What If's - put 1,2, 3 on separate TABS of your Spreadsheet.

On the Handouts page, under Computer_Apps_Assign05-14.doc are Sample Amortization files for both Google Sheets & Excel, that can be used.

1. House Loan

2. Car Loan

3. Personal Loan

On EACH Spreadsheet -

House - What IF to include: Amount Borrowed, Interest Rate,

# of Years, Additional Amt,

# of Loan Payments per year 12=1 per month, 24=twice a month

Re-finance or 2nd Mortgage, Variable Rate, Balloon Payment

Car - What IF's to include: Amount Borrowed, Int Rate, # of Years, Additional Amt,

Insurance Amt, Deductible, Maintenance, Fuel MPG, Type of Fuel,

Personal Loan - Int Rate, # of Years, Amt Borrowed, & anything that effects your payment

· Create an Assign06 folder in your CompApp folder in Google Doc/Drive

· Share it JilMac.MacRand@gmail.com (free) or Jil@JilMac.com (paid google acct)

· From the Video Training

· select 3 types of documents and demonstrate what you have learned.

All documents in your Google Shared Drive folder should Automatically Share with JilMac since the folder they are in is shared.

Create an invoice - from a Template in either Excel or Google Spreadsheets - how is this different from a Word doc??- to Bill me for a project

fill it in for the hours you have spent working on Computer Applications.

Break it down into different types of work.

Find a Statistic - Put the data into a Spreadsheet and create a Graph - explain why you chose this type of graph and what you learned. Include a LINK to the data

Upload the Before & After Documents and share them with JilMac.MacRand@gMail.com

On the Handouts page, under Computer_Apps_Assign06-14.doc are is the Vermont Population file that you can use for either Google Sheets or Excel.

ASSIGNMENT07 PowerPoint & Google Slides

Assignment07 of 14 Research due in 1 week

• Updated: 06/24/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to setup

1. Review/Overview/

For a complete list of the LINKS - use the Handouts page - Computer_Apps_Assign07-14 Word or PDF format.

At the end of this Assignment we will have completed the first 1/2 of the class! Time for Mid-Term Grades!

Please complete your Project Overview! JilMac uses it for your Mid-Term Grade!

Info-Graphics – is a way of Visually explaining Data. The History of Pandemics by Death Toll https://www.visualcapitalist.com/history-of-pandemics-deadliest/

Vermont Business for Social Responsibility Organization for Job Seekers Internships' https://vbsr.org/vermont-intern-program/available-internships

Have you ever noticed documents that are just gibberish? They make you think “Is this in Latin?”

Well you were right – it is Latin. Many times, when you are demonstrating what something will look like you don’t want people to READ it for its CONTENTS – you want them to read it for its FORMAT. If you wondered how they created the gibberish – here is one-of-many Lorem Ipsum Generator http://lorem-ipsum.perbang.dk/ when you need to create a paper, but don't know what it should say ... use Lorem Ipsum! All the professionals do! You are free to use it for your Assignments or the Final Project.

Where can I get free images or sound? Images are becoming more important than ever – because our Brain can process Images so completely. Here are two links - to get you thinking differently about images.

• https://www.pexels.com - This is a Creative Commons site free for any LEGAL purpose! https://www.pexels.com/photo-license

• http://pixabay.com/ You need to credit where & who they are from unless it states “No attribution required” ... but be careful - those with an Overlay are NOT FEE, they are ADVERTISING!!! Usually these are at the top under “Sponsored Images” but with the see-more-like-these, it is very easy to lose track.

• Free & Clear Images, Sounds, Video, etc usually grouped into "Media": http://commons.wikimedia.org/ images, sounds, video

Please READ/Watch/Research: Plus, you get Extra Credit opportunity: give me 100 words what you learned each!

· Monitors & Images Future https://www.youtube.com/watch?feature=player_embedded&v=SjbSEjOJL3U

• Using Images to Control a Program http://www.youtube.com/watch?v=PCfsfdOmRcA&feature=em-uploademail

• https://www.grammarly.comWhen you are on the Web – Microsoft’s Spell Checker won’t help you …. But Grammarly will. Use with several different browsers: Google Chrome browser & now Edge.

• Here are 25 up and coming careers in the Automotive industry ... you will have to click the links to find out what they are! A lot of the titles were new even to me! https://angel.co/job-collections/top-self-driving-cars-startups?utm_campaign=platform-newsletter&utm_medium=email&utm_source=platform-newsletter

2. Research:

This assignment we are learning about PowerPoint & Google Slides - and importantly how to combine them with what we already know about Word processing, Spreadsheets & Graphics. Hear is the overview of the GCF Free learning modules http://www.gcflearnfree.org/office2013/powerpoint2013 or https://edu.gcfglobal.org/en/powerpoint2016/ is there any differences in the versions or training?

You are free to do the Microsoft Trainings if you prefer: https://support.microsoft.com/en-us/office/powerpoint-for-windows-training-40e8c930-cb0b-40d8-82c4-bd53d3398787?wt.mc_id=otc_home

NOTE: remember when you are doing a Google Search you can click "Search Tools" > AnyTime > Past Year to get current info

3. Before & After:

Demonstrate your new skills by creating 3 different PowerPoint or Slides.

Be sure to include an Excel Graph!! Create in it Excel and then Copy and Paste it into a PowerPoint and/or Google Presentation!!

Have your Presentation/PowerPoint be many pages long explaining a concept from the Video/Tutorial that you learned the concept

from with clickable link to the Video/Tutorial.

All documents in your Google Shared Drive folder should Automatically Share with JilMac since the folder they are in is shared.

Project Outline:

JilMac does not have tests in any of her classes - she has a Final Project worth 25 points of your final grade. PLUS, the Outline Initial 3pts and the Final outline 2pts - bringing the Project worth 30 points of your final grade.

Project Rubric: https://docs.google.com/viewer?a=v&pid=sites&srcid=ZGVmYXVsdGRvbWFpbnxqaWxtYWN0cmFpbmluZ3xneDo1MGJmNTEwOTI5NTJjMmVl Your FINAL project is to create documents for a Company, Family, Organization or Club, or any other purpose real or imagined. Create a Spreadsheet with the following categories. Decide what you want the document to contain, Give me the Name (real or imagined) of the Company, Family, Organization, and what that group does.

Your final presentation will be a Google site that is easy to access these documents. We will be building a few in the 2nd half of the semester. This week we will be concentrating on the Name and types of Documents we want to create. It is worth 3 points!!

One each page you can demonstrate what you learned by using the different types of documents: They may include, but do not HAVE to include:

1. Letterhead - Microsoft Word or Google Docs

2. Envelope - Microsoft Word or Google Docs

3. Brochure - in both Word & Documents (need to use tables)

4. Resume - from Templates in both Word & Documents

5. Card - Fold the Paper first to create the DESIGN

6. Business Card- from Templates in both Word & Documents

7. Presentation - Microsoft PowerPoint or Google Presenter

8. Invoice - Microsoft Excel or Google Spreadsheet

9. Expense Sheet- Microsoft Excel or Google Spreadsheet

10. Web Site - Google Sites

11. Personal Logo- Microsoft Paint, Google Picture (or another Graphic Editor)

12. Business Plan - MS Word or Excel, Google Doc or Spreadsheet

13. Form - Questionnaire to mail to customers, Google Forms

14. Calendar - Google Calendar

15. Maps - Google Maps - Direction, Location, Register your Company

Now let's add some Favorite Effects:

Screen Capture It can come in very handy

Ctrl-PrintScreen or PRN-SCR - will capture the entire screen What is the equivalent on Win10??

Alt-Ctrl-PrnScrn - will capture the ACTIVE window

16 Inserting Pictures http://www.gcflearnfree.org/office2013/powerpoint2013/16

10 Applying Transitions http://www.gcflearnfree.org/office2013/powerpoint2013/10

20 Animating Text and Objects http://www.gcflearnfree.org/office2013/powerpoint2013/20

Save your work to your Google Drive and share it with me in PROJECT folder.

ASSIGNMENT08 InfoGraphics

Assignment08 of 14 Research due in 1 week, B+A may take more time.

• Updated: 3/17/2021 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to setup

1. Overview/Review

• • We are more than 1/2 of the way through the course. 8/14 assignments= __% of the class. Let's do that Math on a Spreadsheet!

  • What problems did you have with PowerPoint??

  • Info Graphics it's the new way of looking at data, and it is a whole new business. How do you explain information ... https://www.youtube.com/watch?v=QPKKQnijnsM and that was in 2012 … what is it today? https://www.youtube.com/watch?v=DANUXO-GQwU or https://www.youtube.com/watch?v=pmW_q5dmosM EXTRA CREDIT – give me 100 words how seeing the graphics helps you understand the numbers.

  • Google’s New Certificates …. What do YOU need to know to take advantage of them??

  • https://www.inc.com/justin-bariso/inside-googles-plan-to-disrupt-college-degree-exclusive.html

    • Hint!!! You need to KNOW how to LEARN …. On Line …. Hint !! Hint !!

2. Reading Assignment –

Last week and for the next 3 assignments we will be studying PowerPoint & Google Slides - and importantly how to combine them with what we already know about Word Processing, Spreadsheets & Graphics. We will be working on the 2nd half of the GCF Free learning modules first: http://www.gcflearnfree.org/office2013/powerpoint2013 or https://www.gcflearnfree.org/powerpoint2016/ or the version of your choice

More Objects

21 Inserting Videos http://www.gcflearnfree.org/office2013/powerpoint2013/21

22 Inserting Audio http://www.gcflearnfree.org/office2013/powerpoint2013/33

23 Tables http://www.gcflearnfree.org/office2013/powerpoint2013/23

24 Charts http://www.gcflearnfree.org/office2013/powerpoint2013/24

25 SmartArt Graphics http://www.gcflearnfree.org/office2013/powerpoint2013/25

Reviewing Presentations and Collaboration

26 Checking Spelling and Grammar http://www.gcflearnfree.org/office2013/powerpoint2013/26

27 Reviewing Presentations http://www.gcflearnfree.org/office2013/powerpoint2013/27

28 Finalizing and Protecting Presentations http://www.gcflearnfree.org/office2013/powerpoint2013/28

Customizing Your Presentation

29 Modifying Themes http://www.gcflearnfree.org/office2013/powerpoint2013/29

30 Slide Master View http://www.gcflearnfree.org/office2013/powerpoint2013/30

31 Hyperlinks and Action Buttons http://www.gcflearnfree.org/office2013/powerpoint2013/31

32 Advanced Presentation Options http://www.gcflearnfree.org/office2013/powerpoint2013/32

Extras Embedding an Excel Chart, 4 Free Alternatives to Microsoft Office & Quiz(for those that like quizes)

Learn More

PowerPoint Tips http://www.gcflearnfree.org/powerpoint-tips

PowerPoint 2010 http://www.gcflearnfree.org/powerpoint2010

Google Drive http://www.gcflearnfree.org/googledriveanddocs

Microsoft videos for the VERSION of POWERPOINT you have access to:

• PowerPoint 2016 training

• PowerPoint 2013 videos and tutorials

• PowerPoint 2010 videos and tutorials

• PowerPoint 2007 training courses and tutorials

Beginner: Apply and change a theme https://support.office.com/en-us/article/Watch-online-de44b332-00db-4424-8957-00c70646e000 Watch online

Beginner: Apply transitions between slides Watch online

Beginner: Create speaker notes Watch online

Beginner: Create your first PowerPoint 2013 presentation Watch online

Beginner: Highlight text and change fonts Watch online

Beginner: Print slides, notes, or handouts Watch online

Intermediate: Backgrounds in PowerPoint Watch online

Intermediate: Crop a picture to fit a shape Watch online

Intermediate: Group shapes or pictures Watch online

Intermediate: Make the switch to PowerPoint 2013 Watch online

Intermediate: Webinar: Paper handouts for PowerPoint Watch online

Intermediate: Webinar: Using video in PowerPoint Watch online

Intermediate: Webinar: Ways to avoid rebuilding PowerPoints over and over Watch online

Intermediate: Webinar: 5 steps to a better PowerPoint Watch online

Intermediate: Working with watermarks Watch online

Intermediate: Work with handout masters Watch online

3. Discussion/Research Assignment - 2 points

Research either Global Fishing Watch or SkyTruth, spend at least several hours - because these sites are BIG and the concepts very new. Tell me your thoughts in 100+ words in a PowerPoint or Google Slide presentation and upload it to your Assign08 folder (instead of Word – including screen captures and links). Do the OTHER for Extra Credit! Maybe you can even use these for another class, family discussion or other purpose. We are starting to combine and interact with large groups of people - the new products and ways to view information is really about to explode!

• Global Fish Watch https://globalfishingwatch.org/map-and-data/ has great Interactive Maps. You can work with the interactive map to get an appreciation for how data can be integrated into a Tool to understand what is going on in our oceans. Fish are the primary source of protein for more than 1 billion people. A new initiative that uses machine learning to monitor the world’s fishing fleets could be a lifesaver.

• Sky Truth https://skytruth.org/ is another site that takes the power of Google Maps and Satellite Imagery and AI to create a way of understanding issues.

3. Before & After:

From the PowerPoint or Slides reading/watching & research select 3 before & after examples that challenge you. Have each B+A example be several pages long explaining a concept from the videos.

REMEMBER at the end of each AFTER document - document what you changed! Upload

• Create an Assign08 folder in your CompApp folder in Google Doc/Drive

• Share it with JilMac.MacRand@gmail.com

• From the Video Training

• select 3 types of documents and demonstrate what you have learned, that challenged you, that made you think or that finally motivated you to try something new.

All documents in your Google Shared Drive folder should Automatically Share with JilMac since the folder they are in is shared. Test This in Workshop.

ASSIGNMENT09 Google Sites-Organizing Digital Documents

Assignment09 of 14 Research due in 1 week, B+A may take more time.

• Updated: 7/08/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

1. Read:

On the Handouts page View, Download and read the Computer_Apps_Assign09-14.doc

Internet Safety https://edu.gcfglobal.org/en/internetsafety/ read through 1-14

Google Sites – is an application that lets you create Web Sites. The Web Site can have a Domain Name ($15 per year) associated with it. Web Sites are a way to organize your digital data and resources. It will last beyond your time in this Canvas class and at CCV. It is free to use and comes with a long list of other applications that Google gives us for free. They just ask – that we are Productive with them. Most can be easily accessible from the Google Web Site such as: Calendar, Documents, Sheets, Presentations, YouTube, Maps, etc.

Google gives you the ability to Create Web Sites that you can have a Domain Name Access. Think of a Domain Name as a License Plate for your car. The license plate is owned by you - you can move it from car to car - but you own it and you pay a fee for it each year. If you buy a new car - you move the plate from the old car to the new car and you update the department of motor vehicles.

Your Web site - is like your car - you can have many of them - but only 1 can use the license plate at a time.

Google has two types of Web sites that you can create: Sites & Classic. This site is Classes - it gives you more options and takes longer to create - JilMac uses it when she teacher Web Development. For Computer Applications we use just Sites - they are fast and easy and still give you tons of options.

Google Sites - from Support.Google.com From the right-navigation review: https://support.google.com/sites/answer/6372878?hl=en

How to use Google Sites

Create, name, or copy a site

Change how your site looks

Delete or restore your site

Find what's changed in a site

Compare classic Sites & new Sites

What you need to use Google Sites

Learn what's new in Google Sites

2. Research:

Google Sites give me 2 new tutorials about Google Sites (YouTube and/or a written tutorial). Create a Google Site – add an Assign09 web page. Put your 100 words for each tutorial on the Assign09 page – include what learned and links to where you learned them.

NOTE: Use the Advanced Search in Google – so that you can find tutorials that are CURRENT. Old tutorials can give you ideas, but Google changes and updates frequently – so you want to keep current. It saves time.

STEPS:

1. Search for your topic

2. Tabs under your search will be: All, Books, News, Videos, Images, More, Settings, TOOLS

3. Click TOOLS

4. Click Any Time down arrow

5. Past Year – should be enough.

JilMac’s Google CLASSIC sites videos, she uses these concepts when teaching Web Development. Students who want to go on to Web Development may find these interesting. https://sites.google.com/site/jilmactraining/collaboration/jilmac-google-videos shows you show to create a Google CLASSIC SITES – a way to ORGANIZING your Digital Data.

Extra Credit Opportunity:

Watch this TED YouTube video http://www.ted.com/talks/brene_brown_on_vulnerability write up 100 words

• it is about Vulnerability - you have to allow yourself to be Vulnerable in order to grow & learn. When you feel shame (I didn't read the chapter, I didn't do the assignment, I don't know how, I'm not smart enough ... blah blah blah - you ROB yourself of the opportunity to learn.

• You have to have the Courage to be imperfect, then you will learn to FIX things.

• You have to have the Courage to learn when there is NO Guarantee you will Get It in 15 weeks

3. Before & After:

1. Create a Google Site – Use the provided themes or create one of your own. Google allows you to make 20+ web sites, maybe even more! So if you want to create a different site than your research, you are free to.

2. Give me a link(s) to your Assign01-08

3. You can use your Assign01 Intro for an About Me page – since this is a REAL WEB Page – don’t include anything personal that you don’t want to share with the world.

Post the LINK to your WEB Site in Canvas.

Note: if you start to feel uncomfortable – call me! We can walk through this together. I want everyone to enjoy this assignment – it is very empowering!

ASSIGNMENT10 Collecting Form Data

Assignment10 of 14 Research due in 1 week, B+A may take more time.

• Updated: 07/11/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

1. Read:

• On the Handouts page View, Download and read the Computer_Apps_Assign10-14.doc

• We are 10/15 = 2/3 = 67% of the way through the 15 week course.

• We are 10/14 = 5/7= 71% of the way through a Summer 12 wk course.

• http://www.notimpossiblelabs.com - what you ACCOMPLISH with the Technology is KING!!

As you are learning about Computer Applications for this class, we are heavily reliant on the keyboard for input, but as you learn more about computers – you realize that the keyboard, mouse and touchpad are gradually being phased out as we become more reliant on mobile devices. Gestures such as: Swiping right or left, Images, scanning and gravity are becoming the inputs, and this list of what is used as input by computer/mobile devices will continue to grow.

• • WORD - has a COMPARE feature. Click the REVIEW tab > go to COMPARE section

• Google Products including Sites has a HISTORY to see previous versions of your site, or to fall back to a pervious version! You don’t have to save, or do Before & After’s!!

  • Check out the Photo + Sound page on our class web site https://sites.google.com/site/jilmactraining/Photo-Editors It has lots of FREE resources … here are a few of the current favorites!

• FreeSound.org create an account to download the MP3's https://www.freesound.org

  • Game Sounds http://www.freesound.org/people/jalastram/sounds/328281 = 328281__jalastram__fx278.wav

  • ZamZar Free on-Line file converter convert .wav file to a .mp4 file http://www.zamzar.com

  • Audicacity - can convert into MP3 to run on internet http://sourceforge.net/projects/audacity

• Pexels Free Pictures & Videos https://www.pexels.com/photo-license/

2. Research:

Google FORMS - the new way to think about collecting data easily.

Read and use as reference this documentation on Using Google Forms

https://docs.google.com/document/d/15i1AamaA_47cI-9Wc9Rw_A-Tr7h6yM0lp-xofJImgzI/mobilebasic?forcehl=1&viewopt=127&pli=1

How does the data get stored in Google Spreadsheets

• which option do you like better??

  • Save to the SAME Spreadsheet ??

  • OR Save to NEW Spreadsheet??

3. Before & After:

Create three different Google Forms - Make sure that you try out each type of Fields.

• Short Answer (Short Text Box)

• Paragraph (Enter a LOT of text

• Multiple Choice (Radio Button – only one answer)

• Checkboxes (Multiple options – check all that apply)

• Drop Down (Choose from a List)

• Linear Scale (Range)

• Multiple Choice Grid

• Date

• Time

Here are some samples

Questionnaire - https://drive.google.com/open?id=1Pf-KSBKrMGrneroWeQHoBFCo9h73W8DavHsMHjz5c4w

User View https://docs.google.com/forms/d/1Pf-KSBKrMGrneroWeQHoBFCo9h73W8DavHsMHjz5c4w/viewform

What can't you do with Google Forms?

* Manually update the spreadsheet and expect it to show in the Charts

How to Edit your form – after you create it – AND test entering into it – you will want to change it – especially as you learn what different types of fields do:

1. Add another field

2. Move fields to create a different order

3. Create Required Fields

4. Enter multiple forms, View Responses (See previous), Edit your response

5. More Advanced Google Forms https://docs.google.com/document/d/15i1AamaA_47cI-9Wc9Rw_A-Tr7h6yM0lp-xofJImgzI/mobilebasic?forcehl=1&viewopt=127&pli=1

6. LET's compare & discuss Google Forms to Access

7. Add a Google Form to your Google Site: Insert > Drive > Form

Note: Each FORM should have it's own Web page

• Create an Assign10 folder in your CompApp folder in Google Doc/Drive, to store your forms.

• Create an Assign10 page on your web site – embed each of the forms on the page

• Copy the page link to Canvas

Extra Credit

KHAN ACADEMY's new training tutorials (and they are adding subjects every day!) Did you know the water in “Finding Dory” was created out of millions of tiny particles? Learn more in our latest “Pixar in a Box” lesson on Effects:

Create your own special effects Start learning the skills a Pixar artist has! Watch the videos and then give me 100 words what you think of how Pixar animation is created. Why is it interesting?

ASSIGNMENT11 Calendar

Assignment11 of 14 Research due in 1 week, B+A may take more time.

• Updated: 07/19/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

Change the way you think - Dr. Daniel Amen - 3 Quick steps to STOP Negative Thinking. https://www.youtube.com/watch?v=ksB0IXhM-Vc&feature=youtu.be Sad, Mad, Nervous or Out of Control - write down what you are thinking, ask yourself if they are true. If they are not true - then you can discard the thought. Write it down, Challenge the Thought! When you have a thought - your brain releases a chemical - it changes the chemistry in your body good thoughts release one set of chemicals, bad thoughts release another set of chemicals If you think it, you may believe it, and your brain will release that set of chemicals. Choose which chemicals your body releases! YOU can CHOOSE!

Watch one of these Dr. Daniel Amen's videos:

• The most important lesson from 83,000 brain scans | Daniel Amen (note: it is past 100,000 now) In only 15 minutes https://www.youtube.com/watch?v=esPRsT-lmw8

Same Story - More Detail:

• · Brain Health Tips from Dr. Daniel Amen - SuperheroYou https://www.youtube.com/watch?v=nMzi0kvcKR0

• · or

• · The Most Important Lesson Learned from 87,000 Brain Scans - Dr. Daniel Amen https://www.youtube.com/watch?v=FTtKpBGjxd8

• · Dr. Amen's emotional talk with his Church and JilMac's favorite talk: https://www.youtube.com/watch?v=FTtKpBGjxd8

EXTRA CREDIT OPPORTUNITY: Give me 100 words and a link to the video you reviewed.

1. Read:

For Assignment11

• On the Handouts page View, Download and read the Computer_Apps_Assign11-14.doc

  • watch/skim Access Training Videos: Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions http://www.gcflearnfree.org/office2013/access2013 or https://edu.gcfglobal.org/en/access2016

2. Research:

Part 1: Research Access - Find me 1 introduction to Access Training in Video or WebPage, Link to it and give me 100 words what you learned.

NOTE: you may or may not have access to Microsoft Access. If you don’t just browse the videos to make yourself AWARE of what Microsoft’s Database = Access is.

Part 2: Research Google Calendar, give me links to 2 tutorials (video or WebPage) and 100 works what you learned.

NOTE: Everyone has the ability to create 10+ calendars with each gMail account!

3. Before & After:

Office 365 does not have Access, so for many of you the only exposure you will have with Access in on the Classroom Computers. Create an Access Database, create at least two tables, 1 report and one data entry screen. Upload the file to your Google Drive for Assignment11.

OR … if you don’t have Access or are not interested in Databases do:

Create another Calendar in Google. Maybe for a shared car or other resource.

Add a web page for Calendar

Combine Calendars: Your Personal Calendar, the Resource Calendar and US Holidays Calendar to the web page are suggestions - combine at least 3 calendars to display together on your page.

All documents in your Google Shared Drive folder should Automatically Share with JilMac since the folder they are in is shared. Test This in Workshop.

IF YOU HAVE ACCESS ... then use an Access Database from the training, make some changes, add, update, modify and upload the modified database to your Google Drive.

ASSIGNMENT12 LinkedIN & Khan Academy

Assignment12 of 14 Research due in 1 week, B+A may take more time.

• Updated: 4/14/2021 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

1. Read:

• On the Handouts page View, Download and read the Computer_Apps_Assign12-14.doc has LOTS more detail and options for extra credit work! - this is an overview.

  • watch/skim Microsoft Access 2013 (or the version of Access you have) training series: https://support.office.com/en-us/article/Access-2013-training-courses-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce?ui=en-US&rs=en-US&ad=US

2. Research:

Research why Linked-IN is the Standard On-Line Resume site and how it is being used by Professionals. If you have not already created a Linked-IN account - do it now and search for Jil MacMenamin and CONNECT with Me. Can you search for People who work at a particular Company? How can you use this to research a company that you are interviewing for? Give me 200 words and 3 links to your research.

Note: If you are in a military/government/etc position - please make a generic account, and leave data blank. Having an account allows you to see information about companies, etc. So that when you leave the military/government/etc you will have the basic knowledge - because everyone leaves the military/government/etc and 98% still need employment. At that time you can create a real account. Because you will need to research companies you are applying to, unless it is more government/etc. If you have strong opinions - select an alternative assignment.

Post a LINK to your LinkedIN account on your Assign12 Web Page. Yes - from now on - each Assignment should have it's own page and not just a link to your Google Folder ... Because you are starting to learn how much richer a web page is than a folder ... you can get to information Quicker on a Web Page ... then opening and closing documents!! IF you make information EASY and QUICK to get to, people will use it rather than bug you and say "I can't find it". Think of your Boss or Family. If it is easy for them to get the infomation - they will. Because People are basically Efficient(I didn't want to use lazy, because lazy kind-of a way to be efficient LOL).

3. Before & After:

Do the Khan Academy "Hour of Code" for Databases https://www.khanacademy.org/computing/hour-of-code/hour-of-sql. Create a document of the SQL statements you used, just cut and paste them into a document comment what each group does in your own words. Give me 100 words (in the same document that you cut & pasted your SQL statements) what you learned about SQL.

ASSIGNMENT13 Mailing Groups

Assignment13 of 14 Research due in 1 week, B+A may take more time.

• Updated: 8/07/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

1. Read:

• On the Handouts page View, Download and read the Computer_Apps_Assign13-14.doc

Read about Google Groups.

• Documentation on Groups: https://support.google.com/groups

• Learn about Google Groups https://groups.google.com/support/

• What’s new in Google Groups–If you are not familiar with Google Groups Select “new Groups”

• Are you in any Groups already? https://groups.google.com/my-groups

Groups are in most Applications, Facebook you can have groups, LinkedIN has groups, probably one of the first successful Groups was Yahoo Groups - and they are still very powerful!

• JilMac will send you an invite to this classes Google Group, the email is: CCV-ComputerApps-2020SU@googlegroups.com (note: if she has not - then send her an email to remind her)

• You will be receiving an email from our class group ccv-computerapps-2020su@googlegroups.com

• When you receive the email – reply ALL – so everyone knows who is active in the group.

2. Research:

Read about Google Groups. Find 3 additional Tutorials on Google Groups. Put the links to the tutorials in your research.

Documentation on Groups: https://groups.google.com/forum/?fromgroups#!overview

Create and Assign13 page on your Class Web Page. Embed a Word/Document from your Google Drive that has the research to these tutorials and what you learned from them 100+ words and 3 reference links.

3. Before & After:

1 point – Set up your own Google Group using “new Groups” https://support.google.com/groups/answer/2464926?hl%3Den%26ref_topic%3D2458761

Set up your own Google Group:

1. Log into your Google Account

2. https://groups.google.com/my-groups

3. Click the “+ Create Group” button in the upper left-hand corner of the Groups window

4. Fill in the Group Name and Group email name and give it a description

5. Click the NEXT link in the lower right-hand corner of the window.

6. Fill in the rest of the fields, if you don’t know what to choose – just use the defaults

7. On the Add members window – in the Group Members field, enter your email addresses. Everyone has their InitialMMDD@ccv.edu and you also have InitialMMDD@ccv.vsc.edu also add my two emails: Jil@JilMac.com and JilMac.MacRand@gmail.com and jam08260@ccv.edu and jam08260@ccv.vsc.edu now you will have 6 people in your group. Plus, you can test groups by yourself – just by sending emails from CCV and your Gmail account. As I am testing your group – you will be receiving emails from me!

1 point – send an email to the Group – when I receive your email you will earn the second point.

1. Can you see your new email group in your “My Groups”?? Do a Print Screen and post the picture on your Assign13 web page to earn the third 1 point.

2. If you are a PART of a group, it will be listed in your "My Groups"

If you are looking to be part of a group look under “Explore Groups"

If you want to see what types of groups are available look under the "Search for a Group"

Documentation on Groups: https://groups.google.com/forum/?fromgroups#!overview

At the bottom of this message - it defaults to displaying these links:

To post to this group, send email to CCV-ComputerApps-2020SU@googlegroups.com

To unsubscribe from this group,

send email to CCV-ComputerApps-2020SU+unsubscribe@googlegroups.com

Visit this group at https://groups.google.com/d/forum/CCV-ComputerApps-2020SU

View this message at https://groups.google.com/d/msg/ CCV-ComputerApps-2020SU/topic-id/message-id

For more options, visit https://groups.google.com/d/optout

EXTRA CREDIT Fun with Favicons

What is a Favicon??? It is a FAVorite-ICON, something that you associate a product or thing with a person, business, or organization. It could be the Nike Swish or JilMac’s Red Heart with a Cow in it.

Favicons appear on the TABS in your browser

Every Web Site puts a Logo in browser address bars, favorites & tabs.

At the top of your Browser (Chrome, Firefox, Internet Explorer/Microsoft Edge, or Safari)

The example below shows Google Groups, Gmail, JilMac.com, http://google.com and http://www.cnn.com

A Google Search on “favicon generator” gives you a lot of choices: http://www.google.com/search?sourceid=navclient&aq=7&oq=favicons&ie=UTF-8&rlz=1T4ADBF_enUS236US238&q=favicons+generator

Each of the Favicon Generators does something a little different. Some create a Favicon and similar icons for all kinds of branding on your documents and web work.

Favicons help you know what browser TAB has what website displaying.

Written Directions for adding a Favicon: https://www.steegle.com/google-sites/how-to/add-favicon

YouTube Video for adding a Favicon: https://www.youtube.com/watch?time_continue=43&v=PUbqI0MYiks&feature=emb_logo

Have fun with learning how to use graphic logo’s in another way to identify your Digital Documents.

70% of our Brains are dedicated to processing images. Training videos are getting us closer - but we can do better.

ASSIGNMENT14 Graphic Editing

Assignment14 of 14 Research due in 1 week, B+A may take more time.

• Updated: 8/08/2020 by http://JilMac.com

• eMail: Jil@JilMac.com or Jil.MacMenamin@ccv.edu

• Phone: 802-254-8628 M-F 6am-8pm, S-S 8am-8pm or for additional hours call to set up

1. Read:

• On the Handouts page View, Download and read the Computer_Apps_Assign14-14.doc

  • Read about Graphic Image Editing with Layers. https://en.wikipedia.org/wiki/Layers_(digital_image_editing)#:~:text=Layers%20are%20used%20in%20digital,integral%20feature%20of%20image%20editors.

2. Research:

Research Graphic Editors with LAYERS

Everyone’s computer has some graphic editor. If you are using a Windows computer, you probably have Paint. If you are using a Mac, you may have Image Editor. But there are many more powerful image/picture/graphic editors that have LAYERS – photo editing, image enhancement, adding text or additional “things” to an image are important when you are creating documents – let’s research some products that can help you do the basics to images/pictures/graphs.

These could include: Google's Pixlar (there is a free version) Photoshop (what they ask for in Job Applications), Gimp(free-Open Source) or Paint.NET (free download) or others.

Create a Google Web page with your research about these three Graphic Editors with Layers.

and why Layers are important. 200+ words total and a reference link to each editor.

3. Before & After: Graphic Examples/3 Before & After - 3 points

Create a Web Page (or a Web Page and Sub Pages for each example) to demonstrate your 3 BEFORE & AFTER Graphics that you used to learn about Graphic Editors with LAYERS

NOTE: You can choose just 1 graphic editor with Layers, for all 3 of your B+A Graphics.

NOTE: I am NOT grading on the beauty of your image … I am grading on can you change it. Have fun, call if you want to work one-on-one, I still have days left open.

GRAPHIC Editors with LAYERS