Computer Applications

MARYVILLE

UNIVERSITY

SAINT LOUIS

13550 Conway Road

St. Louis, MO 63141

COURSE SYLLABUS INFORMATION

SEMESTER/YEAR Fall, 2015 INSTRUCTOR Karen Fletcher

COURSE INFORMATION:

Required Text: GO! With Microsoft Office 2013 Volume 1, by Gaskin, Vargas, & McLellan

Or Rent an eBook: http://www.coursesmart.com/go-with-microsoft-office-2013-volume-1/shelley-gaskin-alicia-vargas-carolyn-mclellan/dp/9780133406559

CLASS ISYS 100 07_ TITLE Computer Applications

alpha prefix number section

MW: 3:40PM-4:55PM 8/24 to 12/10

days / times start end

INSTRUCTOR INFORMATION:

INSTRUCTOR Karen Fletcher _

OFFICE LOCATION ABAC 2216 HOURS MW: 9:30-10:30, 1:30 – 3:30

Or by appointment

WORK PHONE 314-529-9691

EMAIL: [email protected] or Comment/Message through Canvas

SKYPE: k.m.fletcher or FACETIME: Can be reached by Facetime at [email protected]

COURSE OVERVIEW: This course provides an introduction to the Microsoft Office 2013 applications suite which includes Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. This course will also work with relational database concepts.

LEARNING OUTCOMES: Students will be able to:

Word:

Design and produce their own documents, formatting text, images and graphics.

Generate citations and references in a research paper.

Excel:

Design and produce their own worksheets, constructing formulas and formatting

worksheets to effectively communicate.

Design and generate charts.

PowerPoint:

Design and produce presentations, formatting text, images, backgrounds and

graphics.

Apply slide transitions and animations.

Database Concepts:

Develop a conceptual data model.

Subject	Topics
Week 1 Welcome!	Welcome! Resources and Apps Canvas, Lynda.com, Office (Versions), Evernote, Keynote
Week 2 Word Part 1	Announcement with Text and Graphics
Week 3 Word Part 2	APA Research Paper Citations and References, Evernote
Week 4 Excel Part 1	Working with numbers
Week 5 Excel Part 2	Functions and Formulas
Week 6 Excel Part 3	Absolute References and Charts
Week 7 Excel Part 4	Charts and Sparklines
Week 8 PowerPoint Part 1	Illustrations and Transitions Keynote
Week 9 PowerPoint Part 2	Illustrations and Animating Slide Shows
Week 10 PowerPoint Part 3	Themes and Backgrounds PowerPoint Tables and Charts
Week 11 Relational Database Concepts 1	Relational Database Fundamentals
Week 12 Relational Database Concepts 2	Relational Database Fundamentals Conceptual Data Model
Week 13 Relational Database Concepts 3	Conceptual Data Model Access
Week 14 Relational Database Concepts 4	Access Database, Table and Report
Week 15 Presentations	Presentations of Final Projects and Critiques

All worksheets and discussions are considered ongoing work and will be graded after the week is completed. All projects are due the night before the start of class on the first day of class for the week unless otherwise stated. All work must be submitted via Canvas. The final comprehensive projects in Word, Excel and PowerPoint are due three weeks after material is discussed in class. The presentations in Week 15 are your final projects. Late work cannot be accepted. Students are encouraged to help each other on their projects. However, all students are expected to turn in their own work.

The Division of Student Success provides assistance and support for all students.  Services include peer tutoring, individual consultation to assist students with achieving their academic goals, study skills materials, Writing Studio, and accommodations for students with documented disabilities.  Academic Success services are located on the main floor of the University Library.  Writing and math tutors are also available for BYOH (Bring Your Own Homework) Sunday through Wednesdays from 6:30PM-8:00PM and Saturdays from 11:00AM-2:00PM.  Call 314-529-9228 or email [email protected] for more information. We provide accommodations and supports for students with documented disabilities as defined by the Americans with Disabilities Act.  If you have a documented disability and wish to discuss academic accommodations, please call 314.529.9374 as soon as possible.

ISYS 100 Computer Applications Comprehensive Project

(Word, Excel, and PowerPoint)

Find a question or problem you want to study. The question or problem must include some type of numeric data. Research and find two sources. You must be able to gather solid numeric data and include an analysis of the question or problem or brief conclusion.

Mini-Research Paper (Due at Beginning of Week 8) (100 points)

· APA Style

· 4 pages long: 1 Title page, 2 pages for the Body, 1 References page

· Submit a copy of paper to Canvas. It must contain:

· Running head: TITLE IN CAPS and page number on first page of your paper in the header

· TITLE IN CAPS and page number on all pages but the first page of your paper in the header

· Your name

· The same title on the title page and the first page of the body of the paper

· The last page has a title of References

· Is double-spaced

· Has proper APA-style in-text cites

· Has proper APA-style references

· All work referenced must have an in-text cite, and all in-text cites must have a reference

· Contains some type of conclusion

Spreadsheet and Chart (Due at Beginning of Week 11) (100 points)

The comprehensive projects build on each other. Using Word, you created a small APA-style research paper. Look through your paper and choose information from your paper or information related to your paper to create at least one Excel spreadsheet and one chart. Any worksheets and charts must be contained within one workbook.

· The spreadsheet must contain the following functions:

· A function that displays the current day whenever opened

· A total using the appropriate function

· An average using the appropriate function

· A maximum value using the appropriate function

· A minimum value using the appropriate function

· Use appropriate formatting. You do not have to use both decimals and currency. If you do, then pay close attention to:

· Decimals

· How many decimals of precision are included?

· Currency

· Use correct accounting form (discussed on page 319)

· Any tables must be easy to read using shading and borders

Chart

· Use an appropriate chart for your topic (You don’t have to chart everything)

· Is your chart meaningful?

PowerPoint Presentation (Due at Beginning of Week 8) (100 points)

The PowerPoint presentation is the last piece to your comprehensive project. You are presenting your findings to the class. Use the APA paper and Excel spreadsheet and chart and create a PowerPoint presentation to present your findings. Your PowerPoint presentation must be related to your topic, paper and spreadsheet. You can supplement it with additional information, if there is a need.

· The presentation must contain the following:

· 5 minutes in length (approximately)

· At least 8 slides

· At least 4 images

· PowerPoint transition or animation on at least one slide

· Suitable theme for your topic

· It must be set up so that you can click on an image and get to a web page

· Include at least one chart in your PowerPoint (can be the same as created in Excel)

· Include a SmartArt Graphic

GRADING: (~950 Total Points)

	Activities	Points	Comments
Required	Practice: Worksheets and Discussion	10 points each ~	~ 25 Practice
	Projects	50 points each ~	8 Projects
	Comprehensive Projects	100 points each ~	1 Word, 1 Excel, 1 PowerPoint
Bonus	Posting Question to Help Forum	10 points for first post, other points as deemed by instructor
	Answering Question on Help Forum	5-10 points for complete, valid answers
	Posting Supplemental Material	5 points for first post, other points as deemed by instructor

A	94-100%	A-	90-93.9%
B+	87-89.9%	B	83-86.9%	B-	80-82.9%
C+	77-79.9%	C	73-76.9%	C-	70-72.9%
D	60-69.9%
F	59.5% and below

THIS SYLLABUS IS SUBJECT TO CHANGE AT THE DISCRETION OF THE INSTRUCTOR

Learning Outcomes: Students will be able to:

Word:

Design and produce their own documents, formatting text, images and graphics.

Generate citations and references in a research paper.

Excel:

Design and produce their own worksheets, constructing formulas and formatting

worksheets to effectively communicate.

Design and generate charts.

PowerPoint:

Design and produce presentations, formatting text, images, backgrounds and

graphics.

Apply slide transitions and animations.

Database Concepts:

Develop a conceptual data model.

The following table summarizes the minimum clock hour estimates for this course in compliance with Maryville University credit hour policy and Federal Guidelines (34 CFR Section 668.8).

Note : The hours presented in the table below provide estimates for the average time required for completion of course components. Students may require additional time to successfully master topics, complete projects or to comprehend required readings. Completing the times listed below does not guarantee a specific level of success in the course.

Hours of Instruction1	Hours
Classroom	45
Labs
Studio
Field Experience (Clinical, Practicum)
Total In-class Hours	45
Hours of Student Work Outside of Class2
Required Discussions/Conferences/Field	20
Classroom Preparation (Readings/Practice/Assignments/Tutorials/Problems) · 8 Projects (2 Word, 2 Excel, 2 PowerPoint, 2 Database) - 24 · Readings (text and links) – 16 · Tutorials (Lynda.com) - 15	55
Quiz Study, Exam Study and Take Home Exams	15
Final Projects (Research/Papers/Presentations) · APA research paper, Excel spreadsheet and chart , PowerPoint Presentation	45
Total Out-of-Class Hours	135
Grand Total Hours of Engagement	180

1 Minimum requirements for 1 credit hour are defined as 15 hours of in-class instruction accompanying a minimum of 30 hours of out-of-class preparation. An equivalent amount of work may substitute the 15 in-class and 30 out-of-class minimum hours for other academic activities as established by the institution (this could include laboratories, studio work, practica, clinicals or other academic work leading to the award of credit hours). Hours listed may exceed minimum requirements. 2 30 hours of out-of-class preparation per 1 credit hour is typical. Courses that deviate from this minimum due to particular pedagogical needs must meet the equivalent work requirement as specified in note 1 above. Hours listed may exceed minimum requirements.