POST CIS112 2018 November All Assignments Latest

CIS112 Intro to Computing

Unit 3 Assignment

APA Title Page and Headers

In this assignment, you will practice the skills of creating, editing, and saving a Word document by creating an APA formatted Title Page and headers. You will create a template, which you will be able to use for all future classes.

If you need help using OneDrive for this and future assignments, please see the file  Working with OneDrive Working with OneDrive - Alternative Formats

.  It is also located above, under "Readings and Resources."

Refer to the attached document for specific details and grading criteria. You have two attempts on this assignment. Use instructor feedback on the first attempt to revise and resubmit, if necessary, to earn full points.

There is a specific yet simple format to an APA title page; the headers on the title page and other pages also

have a specific format. In this assignment, you will create and format an APA title page document. You will

then be able to use this as a template for any APA paper that you may need to write in future courses. Refer to

the unit resources in Readings and Resources for the specifics of this type of document.

The requirements for your assignment are:

1. The title of the paper will be: APA Template.

2. Open a new Word document in your OneDrive course folder.

3. Set the font to Times New Roman, 12 pt., double spaced with 0 pt. spacing after the paragraph.

4. On the Page Layout menu, set the Top, Bottom, Left, and Right margins to 1 inch.

5. Set up the header on the first page to include the running head and page number.

6. Set up the header on the other pages to include the page number.

7. Set up the title page of the document to display the paper title, your name, and the university name centered on the

center of the page.

8. Create a 2nd page containing the following:

a. The first line should have the title of the paper centered

b. On the second line, center on the page and type the following text:

This is a template that I can use for future APA formatted papers.

9. Run spell check and ignore if your name comes up as misspelled - it should have no red underlines when

submitted

10. Rename the document yourinitials_APAtemplate.docx

11. Your document will look something like this except with your paper name and your full name:

Refer to the grading rubric below for the grading criteria.

Students: Be sure to read the criteria, by which your paper/project will

 

CIS112 Intro to Computing

Unit 4 Assignment

MS Word Assignment 2

Word Assignment Instructions

Please find and download the following file

Please put the file in a location that you will know where to find it.

1. Open the MS Word file and perform the following tasks that you learned in the unit exercises.

2. Adjust the margins on the document to Narrow.

3. Please type the current date into the header of the document. Please make sure that this is on the left side of the header.

4. Please insert your name into the document footer. Please make sure that your name is centered.

5. Format “For Immediate Release” at the top of the page. Make the text Bold, and change the Font to Arial and make the size of the font 24pt. Center-align the text.

6. Under the Benefits of Hotel heading, create the following bulleted list, using the check-mark bullet type:

Quiet

Residential Neighborhood

Restaurants

Stores

Groceries

Cafes and Bars

7. Under the bulleted list, insert a 2-column, 5-row table into the document that shows

the prices for different types of rooms. Your table should have a column header that

specifies the type of room and price for the type of room.

Your table should look like the following:

Type of Room Price

8. Enter the following room types on each row: Single, Double, King, and Suite.

9. Enter the following prices in the following order: $150.00, $200.00, $250.00,

$500.00.

10. Insert a picture of a hotel on the left side of the paragraph which begins with San

Francisco, CA. Event planners, conference organizers, Change the style of the picture

to Beveled, Matte, White (1st row, 2nd column). Your picture size should not be

bigger than 2.00 inches by 2.00 inches for the height and width.

11. After completing all the tasks, please review and make sure that you have made all

the necessary modifications to this document.

12. Please save the document as Your First

InitialLastName_Assignment_File_Word_2.docx (For example:

SJones_Assignment_File_Word2.docx).

13. Please submit your file in Blackboard for grading

 

CIS112 Intro to Computing

Unit 5 Assignment

MS Excel Assignment 1

In this assignment, you will format a worksheet on the number of pens purchased by students. You will

also format the worksheet and insert appropriate formulas. Please remember to save your work as you

go through the steps.

The requirements for your assignment are:

1. Open the Unit 5_Excel1.xlsx document;

2. Save the document as Your First Initial LastName_Pen_Sales.xlsx (For example:

SBrown_Pen_Sales.xlsx);

3. The “Students” worksheet will contain the following data:

4. On the “Students” worksheet, do the following:

a Insert your first and last name in cell A1.

b Italicize your name in cell A1

c Select all the values in Column B. Using the Increase Decimal option, format the

purchased pens in Column B to have 2 decimal places.

d In cell B15, use the AutoSum function to get the Total of all pens purchased;

e Using the Increase Decimal option, format the sum in cell B15 to have two

decimal places;

f Change the cell Background Color in cell B15 to Yellow

5. Save your work and submit the completed worksheet in Blackboard.

 

CIS112 Intro to Computing

Unit 6 Assignment

MS Excel Assignment 2

In this assignment, you will format a worksheet and insert appropriate formulas, and formatting.

Please remember to save your work as you go through the steps.

The requirements for your assignment are:

1. Open the Unit 6 Charting.xlsx document;

2. Save the document as Your Initials_Unit 6_Charting.xlsx (i.e. SB_Unit6_Charting.xlsx);

3. Select Column Q on the worksheet and hide the entire column Q;

4. Format the values in cells B3:M6 as a Number format with 2 decimal points;

5. Select cell A7 and enter the text “Total”;

6. Using the SUM function, calculate the Totals for each month. Your worksheet should look

like the following:

7. Select cells A2:M6 and create a Line chart for the data; Your Line chart should look like the

following:

Note: If your chart does NOT look like the chart above, but looks like the chart below, you

should choose the Switch Row/Column

Option, which is located under the Chart

Tools Menu.

8. Adjust the size of your line chart and move it so that the chart fits in cells A12:H20.

9. Add a legend to the bottom of your line chart;

10. Add the following title to the chart: “Sales by Month by Region”. Your chart with the legend

and title should like the following:

11. Below is how your completed worksheet should look:

12. Save your document and upload into Blackboard.

Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you

write, and again after you write.

 

CIS112 Intro to Computing

Unit 7 Assignment

MS PowerPoint Assignment 1

In this assignment, you will create a basic PowerPoint presentation using the skills learned

in this unit.

The requirements for your assignment are:

1. Create a new PowerPoint document.

o Open the PowerPoint application.

o Choose a New blank presentation.

2. The title for your presentation will be My Dream Vacation: For example, if your

dream vacation is France, your title will be My Dream Vacation: France

3. Follow the instructions below for the 3 slides you will create.

o SLIDE 1: On the first slide, which by default is a title slide layout:

? Fill in a title appropriate to the subject of the presentation (the

presentation title).

? Fill in your name in the subtitle area.

? Your slide should look like this except with your title and your

name:

o SLIDE 2: Add a new slide after the title slide using the Title and Content

layout. This slide is going to be about the items you will bring with you on

your dream vacation.

? TITLE AREA:

• Make the title of this slide “Items I Will Bring on Vacation”.

• Change the font of the title to Arial Black and change the

font size to 48pt.

• Center the title of the slide.

? MAIN CONTENT AREA

• Create a list of 5 items that are important for you to bring

with you on your dream vacation. For example, Passport,

Family, etc.

• Bullet the list, using the numbered bulleted list option

• Create at least one sub-bullet on one of the items by adding

additional information. For example if you chose to include

your laptop, then the sub-bullet can be homework.

• Pick one word on the list, and change the formatting to bold

and underline.

• Change the text color to Blue, Accent 1 (First row, 5th

column).

• The slide should look similar to this except with your

content, and formatting choices:

4. Choose the Theme of your choice for the presentation.

5. Go to the FIRST SLIDE and insert an image to the left of the title that represents

your dream vacation. Add the animation of your choice to the image. An example

of the image could be an airplane, a beach, an island, etc. Your slide should look

similar to the following:

SLIDE 3: Add a new slide after the title slide using the Title and Content

layout. This slide is going to be about what you will do on your dream

vacation.

? TITLE AREA:

? Choose the Two-Content layout and make the title “What I

Will Do On Vacation”

? MAIN CONTENT AREA

o Format the title by centering it across the slide and making it

BOLD.

o Change title font to Cambria and size to 54pt.

o Add the Basic Block List SmartArt diagram (1st

 row, 5th item) in

the first content box, and enter 5 things you will do on your

vacation;

o Change the background color of the blocks to Colored Fill, Accent 3

(Located under the Accent 3 option).

o Add the Fly In Animation to the SmartArt diagram

Your slide should look like this except listing the activities you will do on your

vacation:

? In the second content box on this slide, type the words “My

favorite Airline.” Make the text BOLD and CENTERED within

the content box.

? Make the text “My Favorite Airline” a hyperlink to the website

of your favorite airline. The text My Favorite Airline should

display and not the URL of the website.

6. Move the “What I Will Do on Vacation” slide so that it becomes the 2nd slide in

the presentation.

7. Add Notes to the Title slide regarding who you will bring with you on vacation.

8. Choose a Slide Transition of your choice for the presentation, and Apply it to All

slides.

9. Name the document asYourinitials_Unit7_PPT1.pptx (for example:

SB_Unit7_PPT1.pptx).

10. Download a copy of the presentation to your computer.

11. Upload the copy of the presentation, which you downloaded to your computer, to

the assignment in Blackboard.

• From the Blackboard course, click on the title of the

assignment.

• Scroll down to the Assignment Submission area.

• Click on the Browse Computer button.

• Locate the file on your computer and click Open to attach it

to the assignment.

• Add comments if necessary to the Comments text box

below the submission area.

• Click Submit.

Refer to the grading rubric below for the grading criteria.