07 Jun kaplan it133 all units assignments [ all 10 units assignment ]
Question
<pstyle=”color: rgb(0,=”” 0,=”” 0);=”” font-size:=”” 12px;”=””>Assignment Grading RubricCourse: IT133 Unit: 2 Points: 65
Unit 2 Assignment
Outcomes addressed in this activity:
Unit Outcomes:
· Practice basic file management techniques.
· Use cloud-based services to manage files and folders.
Course Outcome:
IT133-1:Use the computer operating system and cloud-based services to set preferences and manage files.
Installing Office and Activating OneDrive
Instructions
Step 1:If you do not already have either Office 2013 or 365 installed on your computer, download and installOffice 365 from the KU Student Store.
NOTE: If you already have Office installed on your computer, please skip Step 1 and move onto Step 2.
There are two versions of Office 2013 available to you: Office 365 and Office 2013. Each has their advantages. Although this course focuses specifically on Office 365, you can certainly use Office 2013 to complete this course and its associated modules.
Watch these videos:
The difference between Office 365 and Office 2013.Available at http://youtu.be/u78nDj5TYJk
Office 365 on Windows8.Available at http://youtu.be/B13VCal5ITU
SkyDrive Desktop App.Available at http://youtu.be/-TqmnfqrDd0
Source:YouTube. Retrieved from www.YouTube.com.
After you have viewed the videos, you are ready to install and activate Office 365 on your computer. Once you have successfully completed this by installing Office 365 on your computer, please move onto the next step in this Assignment. If you already have Office 2013 or Office 365 installed on your computer, move on to Step 2.
Step 2: Activate OneDrive
Getting to know your new Office 365 subscription, setting up your OneDrive account to sync, and managing your Office subscription online are the powerful features of cloud computing.
Please watch the following videos to learn more about your subscription, what new in Office 365, managing your Office 365 subscription, and setting up your OneDrive, accessing your applications and files in the cloud, and finally learning about the Office Web-Apps.
Copyright Kaplan University
Assignment Grading Rubric
Course: IT133 Unit: 2 Points: 65
Get to know the new Office 365.Available at: http://blogs.office.com/b/office_blog/archive/2013/01/28/office– 15-minute-webinar-new-office.aspx
Source:Microsoft Corp.: Retrieved from www. blogs.office.com
Office 365 subscription activation.Available at: http://youtu.be/umkQcnNeXdo
Source:YouTube. Retrieved from www.YouTube.com.
Managing your Office subscription online.Available at: – http://office.microsoft.com/en-us/support/install-office– on-more-than-one-computer-HA102901468.aspx?videoId=460a50fa-8c0e-4fd4-8a70–eb5d896179f1&from=sharepermalink&src=v5:share:sharepermalink:
Source:Microsoft Corp: www. office.microsoft.com
Office on demand:Available at: http://youtu.be/YdC1nu_yUI4
Source:YouTube. Retrieved from www.YouTube.com.
Office Web-A. Available at: http://office.microsoft.com/en-us/web–apps/player.aspx?assetid=VA102929716&vwidth=640&vheight=360&locat=frame&autoplay=true&videoId=322 ee672-f1a4-41b3-8731-ba279e3a0862&from=sharepermalink&src=v5:share:sharepermalink:pps
Source:Microsoft Corp: www. office.microsoft.com
Managing files and folders on the cloud is much the same as you do on your computer. You can easily create folders and files in the cloud on your OneDrive.
Please view this video that shows how to sync files on your computer with your OneDrive account: Saving with the OneDrive Desktop App
Now that you have watched these videos and learned how to navigate through Office 365, you are now ready to move onto Step 3.
Step 3: Setting up a folder in OneDrive for your class files
You will create one folder and add one file to that folder and take a screenshot of your OneDrive screen at http://onedrive.live.com andplace in a Microsoft Word Document. Here is an example of what it might look like.
Assignment Grading Rubric
Course: IT133 Unit: 2 Points: 65
Directions for Submitting Your Assignment
Compose your Assignment
<pstyle=”color: rgb(0,=”” 0,=”” 0);=”” font-size:=”” 12px;”=””>Outcomes addressed in this activity:Unit Outcomes:
- Utilize document formatting techniques.
Course Outcome:
IT133-2: Create documents using various functions of word processing software.
Unit 5 Assignment
Outcomes addressed in this activity:
Unit Outcomes:
- Design an Excel Spreadsheet.
Course Outcome:
IT133-3: Create spreadsheets using basic spreadsheet functions.
Assignment Grading Rubric
Course: IT133 Unit: 5 Points: 65
Unit 5 Assignment
Outcomes addressed in this activity: Unit Outcomes:
· Design an Excel Spreadsheet
Course Outcome:
· IT133-3: Create spreadsheets using basic spreadsheet functions
Introduction to Microsoft Excel
Scenario
You have decided that it might be a good idea to create a personal household budget. You want to be able to save money to purchase a house after you graduate. You decide to create a personal budget. You may either gather your pay stubs and the bills you pay each month or create fictional expenses to complete this assignment.
Project Details Part 1
Open Microsoft Excel 2013. You will begin with a new worksheet.
1. Create and format row 1 to show the months for the year (Jan-Dec).
a. Begin adding months in cell B1
2. Create and format row 3, to show monthly income for each month (Jan-Dec),
a. For the income amount you can use the same amount for each month.
b. Label the row values as currency, 2 decimal places, and a dollar sign.
3. Create and format a row for 8 separate expenses and do not format to currency.
a. For the 8 expenses create a year’s history by month. Use different values for each month.
b. For example, for electric, you would pick a number between $125 and $142 for January (or use your actual data), a different number between $125 and $142 for February, and so on.
4. Select an appropriate style for your budget and apply it to your worksheet.
Directions for Submitting Your Assignment
Complete your Spreadsheet in Microsoft Excel and save as Unit_5_Lastname.xslx and submit it to the Assignment Dropbox for Unit 5.
Copyright Kaplan University
Assignment Grading Rubric
Course: IT133 Unit: 5 Points: 65
Review the grading rubric = 65 points
| Project Requirements |
Assignment Grading Rubric
Course: IT133 Unit: 4 Points: 65
Unit 4 Assignment
Outcomes addressed in this activity:
Unit Outcomes:
· Utilize document formatting techniques.
Course Outcome:
IT133-2:Create documents using various functions of word processing software.
Creating a Table in a Word Document
Scenario
During your time here at Kaplan University you believe you have collected a good listing of websites related to your program of study and you want to share this information with some of your classmates. You want to be able to present this information in a readable format for others. You have learned how to create tables and hyperlinks in Microsoft Word and decide that creating a table with a description of the sites and a hyperlink to the web site would make it easy to use.
Assignment Details
· Using WordArt – place a title at the top of your document and center align it.
o The title should describe the table of hyperlinks you are about to create
§(example: Helpful Websites Links for Criminal Justice degrees)
· Create a two (2) column table with seven (7) rows.
o Add the style “Medium List 1 – Accent 6” to your table
· Label the columns in the top row.
o The left column should be labeled “Hyperlink”
o The right column should be labeled “Description.”
o Format the row titles as Tahoma 14, bold, and orange font color.
· Add, in the left column, working hyperlinks (not just the URL) to your selected web sites for the five remaining rows.
o See example below of how the hyperlink should appear in your table
o Use the hyperlink option located on the Insert tab
· Provide, in the corresponding right column, the name of the web site, and describe the information available for each of your sites in the next five (5) rows.
· Add a piece of clip art in the last row of your table
o Add the clipart to the last row (row 7) in the left column
o In the right column explain why you selected the clip art you did
§Does it signify your program of study?
§Does it show an interest or hobby you might have?
· Add a Header with your name aligned right.
· Add a Footer with the page number aligned center.
Copyright Kaplan University
Assignment Grading Rubric
Course: IT133 Unit: 4 Points: 65
· Write a paragraph, below the table, explaining how you plan to use the hyperlinks during your studies at Kaplan University. Add three bullet statements, below the paragraph as to why you chose the web sites you did.
· Ensure your paper is free of all spelling and grammatical errors.
Example of what your table might look like:
Hyperlink Description
Kaplan University Kaplan University is accredited by The Higher Learning
Commission (HLC) and a member of the North Central
Association of Colleges and Schools (NCA).
Directions for Submitting Your Assignment
Save your Assignment as Unit_4_Lastname.docx and submit it to the Assignment Dropbox for Unit 4
.
Review the grading rubric below before beginning this activity.
Assignment 4 grading rubric = 65 points
| Assignment Requirements | Points | Points Earned |
| Possible | ||
| Using WordArt – place a title at the top of your | 0–7 | |
| document and center align it. | ||
| The title should describe the table of hyperlinks | ||
| you are about to create. | ||
| Create a two (2) column table with seven (7) rows. | 0–7 | |
| Add the style “Medium List 1 – Accent 6” to your | ||
| table. |
Assignment Grading Rubric
Course: IT133 Unit: 6 Points: 65
Unit 6 Assignment:
Outcomes addressed in this activity:
Unit Outcomes:
· Create formulas.
· Use functions.
· Design charts.
Course Outcomes:
IT133-3:Create spreadsheets using basic spreadsheet functions.
GEL-2.3:Solve real-world problems using mathematical skills.
Exploring Formulas, Functions, and Charts
Scenario
Note: You use the Spreadsheet you created in Unit 5 to complete this Assignment.
Now that you have all the appropriate budget data added to your workbook, you want to analyze it to determine how much your expenses are each month and year as well as how much you make per year to determine if you are spending too much and where you are spending it.
- Create a formula or use the AutoSum function to have Excel calculate the total the expense for each month.
- Create a formula or use the AutoSum function to have Excel compute the Total Annual Income.
- Create a formula or use the AutoSum function to have Excel calculate the Total Annual Expenses.
- Create a formula to determine the percentage of income used for each annual expense total.
-
- Be sure to format it as a percentage. Place that formula in the column next to the total of each monthly expense. (GEL 2.3)
- At the bottom of your budget add the following three functions to calculate the following based on the monthly expenses:
-
- Min
-
- Max
- Average
- In cell A1 add a function to show the current date
- Rename your worksheet tab to Budget Detail.
Now that you have successfully set up your personal budget, formatted it to look professional, and added some formulas and functions analyze your overall income and expenditures, now you will add a pie chart to visually display your expenses.
Using only your monthly expense labels and your Annual expense totals, create a Pie Chart in a worksheet that will show how you are spending your money.
Copyright Kaplan University
Assignment Grading Rubric
Course: IT133 Unit: 6 Points: 65
8. Highlight the appropriate data and create the pie chart and add that chart to a new worksheet.
a. Highlight the Monthly Expenses (not the title, just the expenses; i.e… electric, water, phone…)
b. Highlight the Annual totals for each expense
9. Insert a 3D Pie Chart from the Insert Tab
a. Ensure you move the chart to a new worksheet.
10. Add Data labels to your Pie Chart
11. Format the data labels
a. Show Category name
b. Show Percentages
c. Show Leader Lines
12. Add a title to your Pie Chart
13. Rename the worksheet tab to Pie Chart.
Directions for Submitting Your Assignment
Complete your Spreadsheet in Microsoft Excel and save as Unit_6_Lastname.xslx and submit it to the Assignment Dropbox for Unit 6.
Review the grading rubric below before beginning this activity.
Assignment 6 grading rubric = 65 points
| Assignment Requirem
<pstyle=”color: rgb(0,=”” 0,=”” 0);=”” font-family:=”” verdana,=”” arial,=”” sans-serif;=”” font-size:=”” 12px;”=””>Assignment Grading RubricCourse: IT133 Unit: 7 Points: 65 Unit 7 Assignment Outcomes address in this activity: Unit Outcome: · Design a PowerPoint presentation. Course Outcome:: IT133-4:Create computer generated, on-screen presentations. Using PowerPoint to Create your Auto-Biography Scenario: You have been hired by an Internet company and you will be working from home. Your new boss has asked you to create a presentation that will introduce you to the rest of your virtual team. Your task is to create a personal Auto-Biography PowerPoint presentation. Assignment Details: Your presentation will have a total of 6 slides. You will also select an appropriate slide layout for each slide. 1. Select the slide design theme, Slice, and apply to all slides. 2. Start the presentation with a title slide. a. The title slide must include an appropriate title for your presentation, Ensure you include your first and last name, and the date created. b. Do Notadd a picture. Ensure all slides have a title. Titles on slides are important because they provide your audience with an idea of the information you will discuss. 3. Add a slide: Where you live. a. Add a title. b. Add content. c. Include a bullet and sub-bullets on this slide. d. Add one picture. 4. Add a slide: Your favorite vacation spot. a. Add a title. b. Add content. c. Add one picture. 5. Add a slide: Your hobby. a. Add a title. b. Add content. c. Add one picture. 6. Add a slide: Your family. a. Add a title. Copyright Kaplan University Assignment Grading Rubric Course: IT133 Unit: 7 Points: 65 b. Add content. c. Add one picture. 7. Add a slide: Contact information. a. Add a title. b. Add content. c. Include your name, email address, and IM name. 8. Ensure your presentation is free of spelling and grammatical errors. Directions for Submitting Your Assignment Complete your prese <pstyle=”color: rgb(0,=”” 0,=”” 0);=”” font-family:=”” verdana,=”” arial,=”” sans-serif;=”” font-size:=”” 12px;”=””>Assignment Grading RubricCourse: IT133 Unit: 8 Points: 65 Unit 8 Assignment Outcomes address in this activity: Unit Outcome: · Create an enhanced PowerPoint presentation. Course Outcome: IT133-4:Create computer-generated, on-screen presentations. Using Advanced PowerPoint Features Scenario:Good news! Your boss really liked the presentation you submitted and recommend you add someanimation effects to make it more interactive. Your task is to add some of PowerPoints more advanced tools to the presentation you created in Unit 7. Open the presentation you created in Unit 7.
2. Include one animation on each slide.
b. Animation allows you to alter how the text, graphic and other information is added to the slide when it is displayed. You may have your bullets appear one at a time, fade in, and fade out.
Directions for Submitting Your Assignment Complete your presentation in Microsoft PowerPoint and save as Unit_8_Lastname.pptx and submit it to the Assignment Dropbox for Unit 8. Review the grading rubric below before beginning this activity. Copyright Kaplan University Assignment Grading Rubric
</pstyle=”color:></pstyle=”color:> |
</pstyle=”color:></pstyle=”color:>
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
