Excel module 2 sam exam answers

Computer Literacy

Course Assignments

Prof. Mark Marino

marinom@ecc.edu

SUNY

Welcome to Module 1: Microsoft Word 2016! All work for this module is due by Sunday December 30th, 2018 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover Word Chapters 1, 2, 3 in the Shelly Cashman Microsoft Office 2016/365 Introductory book.

http://images.cengagebrain.com/images/42917493319751835571351520723135375179.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

We will be covering the following three chapters:

· Module 1: Creating, Formatting, and Editing a Word Document with a Picture

· Module 2: Creating a Research Paper with References and Sources

· Module 3: Creating a Business Letter with a Letterhead and Table

The following assignments must be completed and will be graded:

Name of Assignment

Number of Attempts Allowed

Word 2016 Training Module 1

99*

Word 2016 Training Module 1 Exam

50*

Word 2016 Module 1 - Textbook Project

5*

Word 2016 Training Module 2

99*

Word 2016 Training Module 2 Exam

50*

Word 2016 Module 2 - Textbook Project

5*

Word 2016 Training Module 3

99*

Word 2016 Training Module 3 Exam

50*

Word 2016 Module 3 - Textbook Project

5*

*Only your highest grade for each assignment will be counted.

Some Important Notes on the Assignments

· Trainings – The trainings can be completed an unlimited amount of times and your highest score will count. Therefore, you should complete these until you achieve 100%!

· Exams – The exams can be completed five times. If you wish to retake an exam, you have to complete the entire exam again.

· Projects – You will complete projects in the actual version of Microsoft Word 2016. You will download the files onto your computer and submit them in the SAM. SAM will automatically grade them once you submit them. Please note that you MUST use the actual real version of Word 2016 to complete these grader project assignments! You can redo these five times so keep redoing them until you earn 100% on them!

Just a reminder that these assignments are by due Sunday December 30th, 2018 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

SUNY

Welcome to Module 2: Discovering Computers Part I! All work for this module is due by Monday December 31st, 2018 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover Chapters 1-3 in the Discovering Computers book. http://images.cengagebrain.com/images/7321920379499015038447573441394049340.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

Prior to completing the work in this folder, you should read the following in your Discovering Computers textbook:

Chapter 1

Introducing Today’s Technologies: Computers, Devices, and the Web

Chapter 2

Connecting and Communicating Online: The Internet, Websites, and Media

Chapter 3

Computers and Mobile Devices: Evaluating Options for Home and Work

These chapters will provide you with the necessary background to be successful with the assignments in this module based upon the reading in the textbook!

After you have read the chapters, you are ready to complete the graded assignments for this module. These assignments will be your only grades for this module.

· Chapter 1 Test

· Chapter 2 Test

· Chapter 3 Test

Here are some general notes about these assignments:

· Each test consists of 25 multiple-choice questions.

· You may take each test only ONE time.

· Once you start an assignment, you must complete it. You cannot close the window and come back to it later so plan accordingly.

· Just a reminder that these assignments are by due Monday December 31st, 2018 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

SUNY

Welcome to Module 3: Microsoft PowerPoint 2016! All work for this module is due by Thursday January 3rd, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover PowerPoint Chapters 1, 2, 3 in the Shelly Cashman Microsoft Office 2016/365 Introductory book.

http://images.cengagebrain.com/images/42917493319751835571351520723135375179.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

We will be covering the following three chapters:

· Module 1: Creating and Editing a Presentation with Pictures

· Module 2: Enhancing a Presentation with Pictures, Shapes, and WordArt

· Module 3: Reusing a Presentation and Adding Media and Animation

The following assignments must be completed and will be graded:

Name of Assignment

Number of Attempts Allowed

PowerPoint 2016 Training Module 1

99*

Powerpoint 2016 Training Module 1 Exam

50*

PowerPoint 2016 Module 1 - Textbook Project

5*

PowerPoint 2016 Training Module 2

99*

Powerpoint 2016 Training Module 2 Exam

50*

PowerPoint 2016 Module 2 - Textbook Project

5*

PowerPoint 2016 Training Module 3

99*

Powerpoint 2016 Training Module 3 Exam

50*

PowerPoint 2016 Module 3 - Textbook Project

5*

*Only your highest grade for each assignment will be counted.

Some Important Notes on the Assignments

· Trainings – The trainings can be completed an unlimited amount of times and your highest score will count. Therefore, you should complete these until you achieve 100%!

· Exams – The exams can be completed five times. If you wish to retake an exam, you have to complete the entire exam again.

· Projects – You will complete projects in the actual version of Microsoft PowerPoint 2016. You will download the files onto your computer and submit them in the SAM. SAM will automatically grade them once you submit them. Please note that you MUST use the actual real version of PowerPoint 2016 to complete these grader project assignments! You can redo these five times so keep redoing them until you earn 100% on them!

Just a reminder that these assignments are by due Thursday January 3rd, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

SUNY

Welcome to Module 4: Microsoft Excel 2016! All work for this module is due by Saturday January 5th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover Excel Chapters 1, 2, 3 in the Shelly Cashman Microsoft Office 2016/365 Introductory book.

http://images.cengagebrain.com/images/42917493319751835571351520723135375179.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

We will be covering the following three chapters:

· Module 1: Creating a Worksheet and a Chart

· Module 2: Formulas, Functions, and Formatting

· Module 3: Working with Large Worksheets, Charting and What-If Analysis

The following assignments must be completed and will be graded:

Name of Assignment

Number of Attempts Allowed

Excel 2016 Training Module 1

99*

Excel 2016 Training Module 1 Exam

50*

Excel 2016 Module 1 - Textbook Project

5*

Excel 2016 Training Module 2

99*

Excel 2016 Training Module 2 Exam

50*

Excel 2016 Module 2 - Textbook Project

5*

Excel 2016 Training Module 3

99*

Excel 2016 Training Module 3 Exam

50*

Excel 2016 Module 3 - Textbook Project

5*

*Only your highest grade for each assignment will be counted.

Some Important Notes on the Assignments

· Trainings – The trainings can be completed an unlimited amount of times and your highest score will count. Therefore, you should complete these until you achieve 100%!

· Exams – The exams can be completed five times. If you wish to retake an exam, you have to complete the entire exam again.

· Projects – You will complete projects in the actual version of Microsoft Excel 2016. You will download the files onto your computer and submit them in the SAM. SAM will automatically grade them once you submit them. Please note that you MUST use the actual real version of Excel 2016 to complete these grader project assignments! You can redo these five times so keep redoing them until you earn 100% on them!

Just a reminder that these assignments are by due Saturday January 5th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

SUNY

Welcome to Module 5: Microsoft Access 2016! All work for this module is due by Tuesday January 8th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover Access Chapters 1, 2, 3 in the Shelly Cashman Microsoft Office 2016/365 Introductory book.

http://images.cengagebrain.com/images/42917493319751835571351520723135375179.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

We will be covering the following three chapters:

· Module 1: Databases and Database Objects: An Introduction

· Module 2: Querying a Database

· Module 3: Maintaining a Database

The following assignments must be completed and will be graded:

Name of Assignment

Number of Attempts Allowed

Access 2016 Training Module 1

99*

Access 2016 Training Module 1 Exam

50*

Access 2016 Module 1 - Textbook Project

5*

Access 2016 Training Module 2

99*

Access 2016 Training Module 2 Exam

50*

Access 2016 Module 2 - Textbook Project

5*

Access 2016 Training Module 3

99*

Access 2016 Training Module 3 Exam

50*

Access 2016 Module 3 - Textbook Project

5*

*Only your highest grade for each assignment will be counted.

Some Important Notes on the Assignments

· Trainings – The trainings can be completed an unlimited amount of times and your highest score will count. Therefore, you should complete these until you achieve 100%!

· Exams – The exams can be completed five times. If you wish to retake an exam, you have to complete the entire exam again.

· Projects – You will complete projects in the actual version of Microsoft Access 2016. You will download the files onto your computer and submit them in the SAM. SAM will automatically grade them once you submit them. Please note that you MUST use the actual real version of Access 2016 to complete these grader project assignments! You can redo these five times so keep redoing them until you earn 100% on them!

Just a reminder that these assignments are by due Tuesday January 8th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

SUNY

Welcome to Module 6: Discovering Computers Part I! All work for this module is due by Wednesday January 9th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date.

This module will cover Chapters 1-3 in the Discovering Computers book. http://images.cengagebrain.com/images/7321920379499015038447573441394049340.jpg All work in this module will be completed at the SAM website: http://sam.cengage.com Please navigate to that website and login.

Prior to completing the work in this folder, you should read the following in your Discovering Computers textbook:

Chapter 4

Programs and Apps: Productivity, Graphics, Security, and Other Tools

Chapter 5

Digital Security, Ethics, and Privacy: Threats, Issues, and Defenses

These chapters will provide you with the necessary background to be successful with the assignments in this module based upon the reading in the textbook!

After you have read the chapters, you are ready to complete the graded assignments for this module. These assignments will be your only grades for this module.

· Chapter 4 Test

· Chapter 5 Test

Here are some general notes about these assignments:

· Each test consists of 25 multiple-choice questions.

· You may take each test only ONE time.

· Once you start an assignment, you must complete it. You cannot close the window and come back to it later so plan accordingly.

· Just a reminder that these assignments are by due Wednesday January 9th, 2019 at 11:59:59 P.M. NO LATE WORK WILL BE ACCEPTED!!! You will not be able to access the assignments after the due date. Technical problems are not a valid excuse for not completing work by the due date.

Good luck and have fun!!!

Module 7 Assignment CS101 Summer 2018

COMPUTER LITERACY MINI RESEARCH PAPER
Submit a five hundred (500)-word paper on a computer related topic by Thursday January 10th, 2019. Do not exceed 550 words or 2 pages. Some topic suggestions follow. Obtain the instructor’s approval of other computer related topics.

Artificial Intelligence

Computers in a Particular Career

Motherboard Contents

Charles Babbage

Computer Viruses

Network Configurations

Cim (Computer Integrated Manufacturing)

Fifth-Generation Computers

Optical Fiber

Computer Crimes

John V. Atanasoff

Other Computer Related Topic

Computer Ethics

Type the paper using Microsoft Word and demonstrate the skills listed in the grading section below. Use double spacing, a 12 point font size, and first line indents of 0.3.” Do not place blank lines between paragraphs. Save as Your Last Name Research Paper. Submit the file using the SAM Dropbox.

Paper requirements will vary among instructors, so always inquire. My requirements are to include an APA style title page, which includes a page number. Place the title page, document, and references page in one file. The references page must include at least three references (one book, one periodical, and one Internet) in APA format using .3” first line and hanging indents. Use APA parenthetical documentation within the paper to cite words that are quotations or paraphrases, or express an idea gleaned from an author. See the writing lab for assistance. Use APA for topics in such fields as computer science, psychology, and medicine because the information in these fields changes rapidly making dates more important to the reader; therefore, APA places dates in the parenthetical documentations and also locates dates earlier in the citations on the references page. In contrast, MLA is used for topics in more static fields such as literature and history, and requires a works cited page rather than a references page. Read and abide by ECC’s plagiarism policy .

In the first paragraph, create a clear thesis statement, that is, a claim or an opinion. In the next paragraphs, relate the main points and details, which prove the thesis. In the final paragraph, write a conclusion related to the thesis without adding new material but avoiding redundancies (sum reason thesis was proved and by what). Keep control of your paper; do not allow quotations to take control. To keep paper readable, pretend that the reader is not a good reader. Write as if the reader is 12 years old, maybe even 10 years old. Use simple sentences: subject-verb-object. Complicated sentences can confuse the reader causing he/she to read and reread many times. The writer has the responsibility of clearly explaining the material. Always consider the audience’s background. Use no more than four (4) quotes per page or one quote per paragraph. Avoid encyclopedias because they are someone else’s research.

GRADING:

To create an APA style title page (12 point font size), start with the 6 blank lines as described in the figure below and continue. To add page numbering, see the next paragraph. Press Enter and Ctrl+Enter to insert a hard page break. Visit these links for more details about APA and MLA: http://www.nutsandboltsguide.com/apa.html and http://www.nutsandboltsguide.com/mla.html

APA Title Page

APA First Page

Artificial Intelligence (Short Title) 1

(about 6 blank lines, double-spaced)

(entire title page, paper, & references page are double-spaced)

(another version of an APA title page places the title about half way down the page and subsequent data—see below—on separate lines without blank lines between. Both versions center all but line with page number.)

Artificial Intelligence:

(above is Full Title or just main title: if using a subtitle)

Past, Present and Future

(above is optional subtitle or leave line blank)

(about 4 or 5 blank lines)

Student’s Name

(about 7 blank lines)

Computer Literacy 101, Section Number

Professor Marino

Thursday January 10th, 2019

Artificial Intelligence (Short Title) 2

Artificial Intelligence:

(above is Full Title or just main title: if using a subtitle)

Past, Present and Future

(above is optional subtitle or no blank line)

The first paragraph of paper begins here. Continue to double-space—all parts of paper are double-spaced. Do not use blank lines between paragraphs. Left indent quotations greater than 40 words by 1 inch (do not right indent).

Continue . . .

Note: Title and possible subtitle, above, are centered.

In the header, add page numbering to the top right corner as required by APA: since APA requires page numbers preceded by words, the Header and Footer command will be used instead of the Page Numbers command. Click at beginning of page after title page. Click View, Header and Footer, & Align Right button. Reset Font & Font Size to match document. For APA, type your short title followed by about 5 spaces. Click Insert Page Number button (2nd from left) on floating Header and Footer toolbar and activate double spacing or press Enter (not both).

Form a hard page break at the end of the document. Add a double spaced “References” page with a 0.3” hanging indent: Press Ctrl+Enter & Center button; type the words References; press Enter; click Align Left button, Format, Paragraph, drop arrow under Special Indentation, hanging; By should already be set at 0.5, so for APA, click the down arrow to change the By to 0.3; click OK, & type a minimum of three references (one book, one periodical, and one Internet) without skipping lines between them. For each reference, at least one parenthetical documentation should be placed in the document. See an appropriate book, English Skills Lab handout, or Web page for the correct format for parenthetical documentations and for the citations on the references page. The format of the citations on the references page will vary depending on the type of reference (i.e. book, periodical, Internet). For an alternate means of creating a hanging indent, click Help, Microsoft Word Help; type indentation; click Indent paragraphs & Create hanging indent.

When borrowing an idea, paraphrase, or quotation, use parenthetical documentation, otherwise the researcher plagiarizes. To earn a position on a references page, cite the reference at least once.

Change left and right margins to 1 inch.

Writing Assignment Check List
I have proofread to confirm that my paper has:

· A clear and appropriate thesis statement (a claim or opinion) with a conclusion that relates to the thesis without adding new material or being redundant.

· Main points and details that prove the thesis.

· No run on or fused sentences.

· No sentence fragments.

· No unclear or overly complicated sentences.

· No sentences to which the subject has been wandered.

Incorrect When you pump your gas pedal, you may find that you will flood your car.)

Revised: Pumping the gas pedal causes flooding.

· No contractions (i.e. change can’t to cannot , doesn’t to does not , etc.).

· No case errorsmisuse of upper or lower case letters).

· No homonym (homophone) errors (i.e. to, two, or too; there or their; whole or hole; etc.).

· Correct parallel constructions (parallelism)

Incorrect: A college graduate can think critically, articulate fluently, and is able to be a thorough reader.

Revised: A college graduate can think critically, articulate fluently, and read thoroughly. (Note that the three (3) verb tenses and adverb forms match.)

· Other: ___________________________________________________________________________________

I have proofread to be sure that I have (am):

· Written in the third person.

Incorrect: I think that the subject of my paper affects you and me, and I will tell you what we will need to do in the future.

Correct: Computer ethics affects society today more than ever.

· Avoided the unclear use of pronouns.

· Avoided expletive constructionsthe use of filler pronouns followed by verbs of being

Incorrect: It is interesting that Joe. . . Incorrect: There are many problems in society.

Correct: Interestingly, Joe . . . Correct: Society possesses many problems. or Many problems exist in society.

· Said what I really want to say.

· Used proper punctuationcommas (,), colons (:), semi-colons (;), quotation marks, periods, question marks, etc.

· Avoided announcements.

Incorrect: The topic I chose is . . . Incorrect: In conclusion; this paper has discussed . . .

Revise: Artificial Intelligence is . . . Revise by relating the conclusion to the thesis statement.

· Introductory tags for all quotations.

Incorrect: “The proper study of mankind is man.”

Correct: Pope wrote, “The proper study of mankind is man.”

· Parenthetically documented quotations, paraphrases, and other people’s ideas properly using APA or MLA format. (APA is used for topics where the information changes rapidly as in medicine, psychology, and computer technology. MLA is more appropriate for static subjects such as history and literature.)

· Included a References (APA) page.

· Alphabetized References page by the authors’ last names.

· Avoided using “a lot” or “a lot of.” Invoke the Thesaurus command in Word and select a synonym.

· Avoided plagiarism.

· Varied word choices and avoided words such as get, got, . . .

· Other: ___________________________________________________________________________________

I have:

· Read my paper out loud.

· Spell checked my document.

· Other: