CISY 102 - Computer Literacy - Spring 2018

YouTube Video List

I have made a series of videos to accompany the course. Some of them are total disasters and I left them as is because that's what would have happened in the classroom if we met in the classroom.

The videos accompany the book: GO! All in One: Computer Concepts and Applications, 3rd Edition, Gaskin, Graviett, Geoghan & Vargas, ISBN-13: 9780134505749

Picture of book: (click me)

These videos were created the Summer of 2017 and most mention Summer 2017. But only 3 videos are specific to the way the class was taught that Summer which was a 9 week session with 2 deadlines a week. The class this Spring 2018 is a 14 week session and deadlines 1 a week.

As of 1/22/2018 9:15 am two of the videos specific to Spring 2018 have been created. I left the one Summer 2017 video here for now.

• Course Overview
• Spring 2018: Course Overview: https://youtu.be/FHWVRq2G16E
• Spring 2018: Discussion Forums: https://youtu.be/xdQHCajlCTQ
• Office Ch 11B
• https://youtu.be/Oz9T7Q8SaHQ
  In this video I have a few comments and what I can see when I grade and what I can't. I can't tell how you selecting text, I can just see that the proper paragraph is formatted. I can't tell if you used the format painter, I can just see that the proper text is formatted. I will look for author, tags, subject
• Spring 2018: https://youtu.be/crAHqmIhBxo
  Shows an alternative way to download the starter file
• https://youtu.be/AA1wedngqz0
  Part 1 Demo of File Explorer for CISY 102 Computer Literacy for Summer 2017
• https://youtu.be/jAMg6FLgHR0
  Part 2 Demo of File Explorer for CISY 102 Computer Literacy for Summer 2017
• https://youtu.be/pXO3aHN8sQ4
  Part 3 Demo of File Explorer for CISY 102 Computer Literacy for Summer 2017
• Ch 3 System Software
• https://youtu.be/s1D5IfEo1uE
  Windows 10 Addendum - shows command line commands, system info using GUI, how to access a USB Drive that is connected to Linksys router
• https://youtu.be/4PFRilxPc5U
  Mac accessing a shared drive addendum - shows how to access a USB Drive that is connected to Linksys router
• https://youtu.be/aJWSlcZta8Y
  Mac GUI Addendum - shows how to see some Systems Information and to kill a process
• https://youtu.be/VdkPgqMrSIw
  Mac command line Addendum shows some linux commands that can be typed
• Ch 4 Networking Addendum
• https://youtu.be/_K3KOozv3rY
  A brief explanation of some networking terms using my home network setup as a vehicle to touch on some topics...and then an aside on how I use a computer to run my TV
• Word
• https://youtu.be/vZxi0ok0QYg
  CISY 102 MLA part 1 ( all but footnotes )
• https://youtu.be/RKh6aFfX-4c
  CISY 102 MLA part 2 ( footnotes )
• Excel
• Intro to Excel for Novices
• Part 1: https://youtu.be/vB0Ac3JCUWo
  This part contains: Entering data and AutoSum
• Part 2: https://youtu.be/GOB-Z1h4L7s
  This part contains: Explaining Relative Cell References, ESC ( hitting Escape...good...bad...ugly), Merge & Center, Applying Cell Styles (but does not match Excel 15A)
• Part 3: https://youtu.be/d6DFt10xoDM
  This part contains: Inserting a pie chart (mmmmm pie!), Sheet tabs, Setting Header/Footer (pretending Excel is Word)
• Part 4: https://youtu.be/Sws27PylZQU
  This part contains: Fixing demo to be closer to Excel 15A, Clear Formatting - (wasn't planned), Cell Styles like 15A, Accounting Format $, Comma Format , ####### showing in cell - (wasn't planned), Active Cell - saved (park in empty area), Changing Page Layout to Normal View, END key followed by an arrow, Max columns / max rows, Ctrl-` to Show Formulas
• Demo of Check book ( in the old days we wrote checks )
  • https://youtu.be/09XJ5h5oLk0
    Silly demo on using Excel for a checkbook ( ledger of transactions )
• Demo of Gradebook in Excel
  • Part 1: https://youtu.be/xO1q3P1DXow
    This part contains: =IF( ), =COUNTIF( ), Formulas based on other sheets, =RANDBETWEEN( ), Copy / Paste Special - Values
  • Part 2: https://youtu.be/h9c1VtcaVK8
    This part contains: =AVERAGE( ), Using blank columns for range formulas
• Access
• Brief Overview: https://youtu.be/bXSOtj3uQ4E
  A brief overview of Access for chapters 17A and 17B. This briefly shows datasheet view for tables, queries, reports, a form with a lookup field, database relationship one to many
• Part 1 of 17A: https://youtu.be/ZbFgH_EXy2M
  The beginning of Access Chapter 17A - This shows the creation of the table
• Part 2 of 17A: https://youtu.be/uekXIYzZUjw
  The latter part of Access Chapter 17A - This shows appending a table with data from an excel file, creating a table from excel, creating a simple query, creating a simple form, creating a simple report using the wizard.
• PowerPoint
• https://youtu.be/eMGx6KI73o4
  Starting PowerPoint, Place Holders, Layout, Designs, Running a Presentation, Handouts: Header/Footer, Notes Pages, KISS, 7x7 Rule, Inserting Pictures
• https://youtu.be/ZpZ7p1C_Zus
  Page # on Slides, Changing Slide Master (I made a goof), Inserting Slide(s), Splitting text over 2 slides, Transitions, Shapes, Grouping Shapes, Animations, Using Pen while in presentation