Graphic Design w/QR Codes & Excel


  • Goals and Objectives
    • Approach new computer-based tasks more easily and with greater confidence
    • Locate, open, and use the following software applications at an intermediate level: e-mail, word processing, spreadsheet, presentation, web page development, internet search strategies, and BlackBoard course management system
  • Add Excel
  • Module Screencasts
  •  Please watch the following screencast videos. After viewing the videos, you can determine which La[B]rid option you will follow for this module.

    Be sure to check the Meeting Schedule (left navigation) to see when our next one-on-one meeting is scheduled. Click here to see how to retrieve your meeting log from Google Drive.

  • Deliverables
    The following are due by the end of this module:

    1. Graphic Design w/QR Code (added to your graphic design) – image file submitted to Blackboard
      • Graphic Design w/QR Code project added to your website – image file
    2. Excel -1 project submitted to Blackboard – Excel file format

Reading(s) and Website(s)


As always, you can see a full list of websites from previous semesters.

  •  Here are a few high quality examples of projects that were previously completed for this module: (*note: combining the Canva and QR Code was not part of the previous assignment so it may not be visible in all examples. You will combine your QR code with your Canva graphic design project, by adding it to your design.)
  • Self-Check Activity
  • Use this document as you build your website throughout the semester.
    • Includes information for Citing Media
  • Support Information – Create a Website
  • M6.1 Graphic Design with QR Code

  • Attached Files:

    Grading Rubric attached above: 50 points


    Learning Activity orange icon   QR Code is short for Quick Response Code (they can be read quickly by a cell phone).

    They are used to take a piece of information from a transitory media and put it in to your cell phone. You may have seen QR Codes in a magazine advert, on a billboard, a web page or even on someone’s t-shirt. Once it is in your cell phone, it may give you details about that business (allowing users to search for nearby locations), or details about the person wearing the t-shirt, show you a URL which you can click to see a trailer for a movie, or it may give you a coupon which you can use in a local outlet.

    The reason why they are more useful than a standard barcode is that they can store (and digitally present) much more data, including url links, geo coordinates, and text. The other key feature of QR Codes is that instead of requiring a chunky hand-held scanner to scan them, many modern cell phones can scan them.

    1. Watch How to Use QR Codes.
    2. Read 5 Ways to Use QR Codes.
    3. Download a QR Code reader app (I use the i-nigma QR Code Reader app) to your mobile device so that you can test it out with the QR Code that you create. Here are a few that you can test out. Where do they go?
      •  Go to a free QR Code GeneratorQR Code Generator. You will create your own QR Code for YOUR WEBSITE (or a page on your website) that you can download or embed.
    4. Download a copy of your QR Code. This is not a stand alone project;you will add it to your [Canva] Graphic Design in the next Learning Activity #2.

    Here are a few that you can test out. Where do they go?
    2 QR Code Examples

    LEARNING ACTIVITY #2: CANVA Graphic Design

    Learning Activity orange icon Canva makes graphic design simple for everyone. Create designs for Web or print: blog graphics, presentations, Facebook covers, flyers, posters, invitations and so much more.

    Your goal for this project is to create a Canva Design that fits with the theme of your site. TAKE A LOOK AT ALL OF THE OPTIONS YOU HAVE YOUR CANVA DESIGN.

    1. Read through the Canva Design/QR Code Scoring Guide.
    2. Watch the Canva tutorial.
    3. OPTIONAL: Preview the Design ESSENTIALS tutorials for additional tips on how to design your Canva designs.
    4. View
    5. To create your Canva Design, go to the Canva Website [] . You can design anything that you want that fits the theme of your website.
    6. Add your QR Code file to your Canva Design
    7. Download a copy of your Canva Design (Image: for Web (JPG))
    8. SUBMIT your image to Blackboard in the assignment below.
    9. Insert the image file it into the appropriate page of your website. Please make a note in the Comments box where (page) your Canva graphic design is located on your website.

AssignmentM6.1 Assignment – GRAPHIC DESIGN W/QR CODE

Attached Files:

Grading Rubric attached above: 50 points

Complete the Learning Activities #1 & #2 above, to produce your graphic design with a QR code included in your design.
Download from Canva (Save) as an image file.
An IMAGE FILE is NOT A LINK. DO NOT submit a link.

Submit icon - greenSubmit your IMAGE File into this assignment, using the Attach File option.

After submitting your Graphic Design w/QR Code project in Blackboard, be sure to add it to an appropriate page on your website. 

AssignmentM6.2 Excel – 1

AssignmentM6.2 Assignment – EXCEL -1

Attached Files:

Grading Rubric attached above: 20 points

This assignment is designed to introduce you to Microsoft Excel, and begin to expand upon your existing knowledge of the software to include some of the more advanced features. In this Lesson, you will be exploring Microsoft Excel features by viewing online tutorials and practicing with a data set provided.

  1. Download and save the attached file. Use this file to learn how to use Excel.
  2. Watch these two screencasts that will show you how to use Excel:
    1. Excel Introduction: Background and Basics (10:07) This screencast shows how to use features in Excel.
    2. Excel Demo/Tutorial (39:09) will take you through this step-by-step practice activity. [Note: the screencast does not tell you to submit your practice file, but you are expected to.
  3. Save your practice file to your computer or My Files, after you have followed and completed the steps in the tutorial. Name your file with “your name” and “PracticeTutorial”
  4. Submit your Excel file to this assignment, in EXCEL format ONLY, using the Attach File option.