Advanced Computer Applications II

Woman working on computerGetting comfortable with Microsoft Office Suite is a great start learning authentic business software.  Advanced Computer Applications I is structured to introduce the world's most popular productivity software in the context of desktop publishing, basic multimedia, and organizing & working with data.

Let's extend that understanding by looking at some important computer applications that are fun, but commonly used in business and in media.  We will use Kahoot to review terms and concepts, but mostly our focus is hands-on, project-based learning.

Links for this week's projectsWe will begin with SQL (Structured Query Language), the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.  Next, we'll revisit desktop publishing & photo editing/adjusting for print. 

We will then move on move on to multimedia including audio mastering, video editing, and basics of video production.  The last weeks, as time permits, we will look at web design & programming

Under construction

  1. MS Access Projects (Access Resources & Tutorials)
    1. MS Access Projects (Tables, Forms, Sorting & Filtering, Queries, and Reports)
    2. Executive Report/Summative Assessment:  Students will create recommendations for constructing and managing an authentic DBMS
  2. MS Publisher Projects (Publisher Resources & Tutorials)
    1. Tri-Fold Brochure w/Template, "About ME!"
    2. Business Card Templates (video tutorial 1 & video tutorial 2)
    3. Birthday & Greeting Cards (video tutorial)
    4. Create a Poster (video tutorial)
    5. Make a Flyer Video Tutorial (2 min 4 second demonstration with no audio).  Flyer Project Rubric.  A flyer is a specialized poster or brochure.  MS Publisher has lots of flyer templates. 
    6. Newsletter (8 1/2" x 11") w/Template (right click to download using SAVE LINK AS).  For text content, we will use a trick from professional designers, dummy text generated by lipson.com. (create a newsletter w/o template video tutorial).
    7. Infographic w/o Template & Example:  Mr. B's Top 5 Favorite Jazz Guitarists (comprehensive video tutorial, 45 minutes)
    8. Summative Assessment:  Create informative tri-fold brochure of your choice (rubric)
  3. Advanced PowerPoint
    1. How to Create Icons (video tutorial)
    2. Picture Accent Process (video tutorial)
    3. Draw a Spotlight Background (video tutorial)
    4. Flashing Bulb Animation (video tutorial)
    5. Create a Moving Spotlight Effect (video tutorial)
    6. Create an Infographic (video tutorial)
    7. Animated Fireworks (complete tutorial w/video)
    8. More AMAZING PowerPoint Tricks 'N Tips (PowerPoint Spice's YouTube channel, tutorials, and blog)
    9. Summative Assessment:  Create an animated graphic of your choice (rubric)
  4. Adobe Photoshop (CS5)
    1. How-To Geek Cheat Sheet:  PhotoShop CS5 (downloadable, printable .pdf)
    2. Getting Started:  Learning the Photoshop Interface (.pdf form) and web tutorial:  What Does Everything Do? Toolbar, Pallets, and More with Practice Image (right-click and SAVE AS)
    3. Cropping, Sizing, Resolution, Levels, and Mode with Practice Image 1 (underexposed) and Practice Image 2 (overexposed)
    1. B/W Conversion with Practice Image
    2. Skin Retouching with Practice Image
    3. Zoom Blur with Practice Image
    4. Change Sky Background with Practice Image & Replacement Sky
    5. Image Noise Reduction with Practice Image
    6. Dodging & Burning with Practice Image
    7. Whitening Eyes with Practice Image
    8. Whitening Teeth with Practice Image
    9. Removing Blemishes with Practice Image
    10. Removing Wrinkles with Practice Image
    11. Brighten Underexposed Photos With The Screen Blend Mode In Photoshop with Practice Image
    12. 30 Very Useful PhotoShop CS5 Tutorials
    13. 50 Excellent Photoshop CS5 Tutorials
    14. Summative Review:  Adjusting & Enhancing Pictures with Overexposed and Underexposed image files
    15. Summative Assessment with Overexposed and Underexposed image files and Rubric
  5. Adobe InDesign (Separate subweb)
  6. Sony Vegas (NOTE:  Current version is owned by Magix Software GmbH)
    1. Mr. B's Easy Video 1-2-3 Web (downloadable, printable .pdf)
    2. Easy Video 1-2-3 Writing Prompts (.pdf form)
    3. Vegas Interface & Workspace
    4. Working with Audio Tracks
    5. Audio Enhancements
    6. Working with Video Tracks
    7. Video Enhancements
    8. Text-Overs & Other Generated Media
    9. Adding Transitions on Video Tracks
    10. Computer Graphics (CGs) & Lower Thirds
    11. Digital Panning & Zooming (Ken Burns Effect)
    12. Finalizing/Rendering Video Projects
  7. Data Analysis:  Advanced Features MS Excel
    1. H Lookup
    2. V Lookup
    3. Inforgraphic in Excel
    4. Random Probabilities & Modeling (Rocks, Paper, Scissors)
  8. Getting Started with HTML
    1. Hello World
    2. Layout Tables
  9. Introduction to CSS
    1. Artists of the World Part 1
    2. Artists of the World Part 2

Top of Page