South SCC1031 2020 JUNE Full Course Latest

SCC1031 Computers and Information Literacy

Week 1 Discussion

Share with us a little about yourself. This should include: where you are from, where you see yourself being in 5 years, and 2 goals for being successful in this class. You should also include two tips you've learned using your computer, Microsoft Word, Excel or PowerPoint.  Think about how you have used your computer or the Microsoft Office programs at home, in school, or at work and share with your classmates.

 

SCC1031 Computers and Information Literacy

Week 2 Discussion

Using Microsoft Word, create a document that contains 1-2 paragraphs that talks about someone you admire and why. This can be a personal friend or family member or someone who is well-known. Then, apply three different features of Microsoft Word to the document and write a second short paragraph describing what those three features are.  Attach this document to the discussion board for class discussion.

 

SCC1031 Computers and Information Literacy

Week 3 Discussion

Create a 2 slide presentation about a favorite place that you've visited or would like to visit. Include at least 4-5 PowerPoint features on these slides and in your initial discussion submission, list what those features are and why you chose them.

 

SCC1031 Computers and Information Literacy

Week 4 Discussion

Using Microsoft Excel, create a vacation budget listing 10-12 different things you'll need to purchase for your chosen "dream" vacation.

Include the following columns:

Item Name

Item Description

Cost

Format the spreadsheet using 3-4 different formatting options - the choice is up to you. In addition, make sure to format the Cost column in the currency format, insert a picture, and  create a header row listing the title "Vacation Budget".

Please attach the excel spreadsheet to the discussion board, and list the formatting options you chose in your initial post.

SCC1031 Computers and Information Literacy

Week 5 Discussion

Your final project is to be done using an application of your choice - Microsoft Word, PowerPoint or Excel. For THIS final discussion, choose another application that you will NOT be using for your final project and create a document using that application that lists your favorite recipe and directions on how to create it. Format the document properly based on the application that you're using.

For example, If you decide that for your final project that you would like to use Microsoft PowerPoint, then for this discussion, use Microsoft Word or Microsoft Excel to list your favorite recipe, its ingredients, and the directions on how to create it. Make sure to apply 3-4 "new" features to the document that you did not use in a previous week. When submitting to the discussion, state what those features are that are applied to your document and any difficulties you had with creating the document within the post along with an attachment of your file.

 

SCC1031 Computers and Information Literacy

Week 1 Assignment  

When learning how to use a computer, some important skills that a new user should know include understanding what type of computer they have and its settings. The user should also be able to organize your files and understand file location, attributes as well as how manage these options.

If you are a Mac or Chromebook user, click here for alternative instructions for the individual project. Preview the document

Assignment Instructions:

In a Microsoft Word document, list the following:

Part A

Windows Settings

Go to your computer’s Settings (Windows).

   1. List 5 options that are available under this screen.

   2. Which top 3 options do you think you would find to be the most useful for you as a user?

Snipping Tool

On the desktop, click in the Search Bar and search for ‘Snipping Tool’.  Open up your Snipping Tool. Click on ‘New’.

   3. Take a screenshot of a portion of your desktop (paste into the document).

   4. What two options are available in this tool?

   5. Why might these options be useful here?

   6. How can you use a screenshot when explaining something in an assignment or a presentation?

Windows Applications

Click on the Windows button in the lower left-hand corner of your screen

   7. List 10 applications found on your computer

   8. From your list of 10 applications, choose 3 and explain the purpose of each application.

Part B

Windows Explorer (Your File Management System)

Open up Windows Explorer. Click the ‘View’ tab.

   1. What options are listed under the Layout category?

   2. When would you want to use one option over another?

   3. In the Search bar in Windows Explorer, type in the word ‘windows’. What happens?

   4. Right-click on a folder in the left-hand side of the screen – what options are you able to see here? List 3 of hte options available here.

   5. Create a new folder on your computer with your first name. Create a subfolder within this new folder with your last name. Using the Snipping Tool, take a screenshot of your new folder structure and save it using the file name structure of   SCC1031_Week1.

 

SCC1031 Computers and Information Literacy

Week 2 Assignment  

Background

Microsoft Word is one of the most powerful applications to learn. Understanding the major features is a must to help any user create better documents visually and content-wise. This assignment will help you apply what you’ve learned to your own document using your creativity. 

Assignment Instructions

Create a document about yourself that explains who you are, why you are going to school and what you look forward to learning the most by the end of class. You are allowed to use some information from your introduction. If you are uncomfortable talking about yourself personally or including personal pictures, feel free to use fictitious information. Your document MUST include all of the elements listed below. The document should be 2-3 paragraphs in length at a minimum. Feel free to use your creativity with this document!

Your document must include:

Page or art border

Page header

Two different fonts

Two different font sizes

Colored font at some point in the document

Underlined or bolded text

At least 1 inserted image

1 table (any size)

Bullet points

Indentation

Save your Word document as SCC1031_Week2_ InsertYourFirstandLastname_Word.docx and submit the Word document for grading.

 

SCC1031 Computers and Information Literacy

Week 3 Assignment  

Background

PowerPoint helps make visually appealing presentations and allows a user to ‘see’ what the speaker is talking about and the point that they’re trying to get across. In this assignment, you will have the opportunity to create a presentation to help a user understand something that they may not know much about it.

Assignment Instructions

Choose a favorite topic (this can be a hobby or anything that you enjoy talking about or know a lot about) and create a 5-slide PowerPoint presentation educating the user about it.

In your presentation, you must include the following elements at least once:

Picture

Shape

WordArt

Table

Use of Speaker Notes

The following must be applied to the whole document:

Design of your choice

Transitions between on each slide

Animation on each slide

Header or footer

Make your presentation visually appealing and have fun with this!

 

SCC1031 Computers and Information Literacy

Week 4 Assignment  

Background:

Excel is a simple but also complicated tool that can help with analyzing data, creating charts, and creating calculations. It’s important for a user new to Excel to understand how to apply the basics of Microsoft Excel to a document before moving on to the more advanced features of Excel.

Assignment Instructions:

You are going to create an Excel spreadsheet that discusses the costs of school supplies. The following items should be included as line items:

Item	Quantity	Cost (per item)
Plastic Folders	8	$1.99
1-inch binders	4	$1.99
Markers (10 count set)	2	$2.79
Graphing Calculator	2	$19.24
18-pack Pencils	2	$3.79
10-pack Pens	3	$0.99
Notebooks	10	$2.49
Tissues	3	$1.79
Index Cards (100 cards each)	4	$0.89

In the first row, create a header row called ‘School Supplies Needed’. Shade the header and use the Merge and Center feature to center the header.

Create column headers called ‘Item’, ‘Quantity’, and ‘Cost (per item)’, ‘Total Cost’. Shade the column headers a color of your choice. Expand the columns to show each column header title.

Format the font of the column headers to Arial Rounded MT Bold in 14 font.

Under each column header, list each item, quantity and cost (per item). Use the Calibri font in 11 font.

Using a formula, create the ‘Total Cost’ per item.

Using formulas, create the sum of the following column – quantity, total cost.

Format the cost (per item) column and total cost using the currency format.

Add a cell border in between all of the cells in the data set.

For any total costs over $15.00, use conditional formatting to highlight the total in red.

Insert a stock picture of any type of school supplies on the sheet.

Create a simple pie chart showing the quantity of each item to purchase. Add data labels showing that quantity. Choose any design to apply to the pie chart.

Rename the sheet that the data is on to ‘School Supplies’. Color the tab any color of your choice.

 

SCC1031 Computers and Information Literacy

Week 5 Assignment  

Background:

Over the past 4 weeks, you have been working with the various applications of Microsoft Office and learned a bit about your computer. In this final week, you are going to take what you’ve learned and apply it to a final project for class.

Final Assignment Instructions:

You are going to create your final project by creating it in the Microsoft Office application of your choice – Word, PowerPoint, or Excel.

Create a document that would be considered relevant to the field that you’re going to school for. This document can use real or fictitious information. This document should be deemed as useful – for example if you choose Microsoft Word, consider writing a short training document. For Microsoft Excel, you can create an Excel spreadsheet discussing a set of data of your choice or a budget. For Microsoft PowerPoint, create a presentation about a topic relevant to your field or a fictitious (or real) project you’d like to work on.

Make sure to include all of the elements below in your selected format. These are listed below:

Microsoft Word

Your document must include:

Minimum of 3 pages

Page or art border

Page header

Page Footer

Two different fonts

Two different font sizes

Colored font at some point in the document

Underlined or bolded text

At least 1 inserted image

1 table (any size)

Bullet points

Indentation

Microsoft PowerPoint

In your 6-7 slide presentation, you must include the following elements at least once:

Picture

Shape

Word Art

Table

Use of Speaker Notes

The following must be applied to the whole document:

Design of your choice

Transitions between on each slide

Animation on each slide

Header or footer

Microsoft Excel

In your spreadsheet, you must include the following elements at least once:

Create a header row

Create 2 new worksheets

Color code and name the worksheets

Use the Merge and Center feature

Use cell shading

Apply cell borders

Insert an image

Apply at least 3 different formulas (one including the SUM function)

Create a chart of your choice and place it on the second worksheet