Personal tools
You are here: Home Academics Syllabi Fall 2011 MIS 24053 Fall 2011 Bozan

MIS 24053 Fall 2011 Bozan

Computer Applications – Fall 2011

KarolyBozan

A409 College of Business

Kbozan1@kent.edu

 

Office Hours:

·        Monday & Wednesday: 10:30-12:15 (appointment must be made by email at least 3 hours prior to the meeting time)

·        Tuesday & Thursday: 4:15-5:15 Walk in

·        Tuesday after class (6:45-8:00pm)

 

Objective

 

The fundamental objective is for you to develop an appreciation for the contribution that computers and software can make to your life as a student and as a professional. It is expected that during this term you will develop competency in the operation of the computer programs to which you are exposed. It is further expected that as you master the course material your confidence and productivity will increase.

 

 

Sources of Information

 

You have five main sources of information for this course:

 

·         Class lecture / discussion

·         Course Notes

·         Me (email me with questions or visit me)

·         Online material

 

 

Other Materials

 

·         Microsoft Office

 

For this course you will use software including Microsoft Office (2007 or 2010). Office may be used on your computer if you have it or in the College of Business computer lab or other labs on campus.

 

If you do not have Office installed but would like it you can obtain a 60 day trial copy from www.microsoft.com for free. NOTE: many computers have Office without Access. You will need Access for this course.

 

You can purchase Office for a special price here:http://www.kent.edu/is/helpdesk/microsoft.cfm

 

 

 

 

 

 

 

Your Grade 

 

                               

Your grade is the weighted average of and quizzes as follows:   

This grading scale is used:

 

 

Three Projects @ 30% each                                                      90%                          

Participation (presentation, discussion, note taking,

proper use Dropbox)                                                        10%

100%

90+         A

80+         B

70+         C

60+         D

0+           F

 

                                                                                                                                               

Projects

 

·         Homework

 

The projects are built on homework assignments. While homework is not graded, they are cumulative works, which eventually evolve into your projects. The instructor will monitor your progress and will help as needed. If you are unable to proceed with a particular assignment in spite of honest attempts, please contact the instructor for further assistance. Be proactive!

You are responsible for properly using Dropbox(see details below), the file sharing application. Homework, projects can only be “submitted” through Dropbox. I will not accept email attachments, printed copies… etc.

 

·         Project

 

The projects are conclusive works of each major subject. They will involve homework assignments and a conclusive write up.

 

Participation

While class attendance is not mandatory, it is encouraged to be present to fully understand the material. Also, students might be randomly called upon to share their thoughts on the topic. I will require four students in each class to take notes, type them up and post them in the class folder in Dropbox, to share with other students. You are responsible for signing up for note taking and properly undertaking this responsibility. You will then be responsible for posting your notes (typed up or scanned) in the public folder in Dropbox.

 

 

Dropbox

     Assignments will be distributed to the students through Dropbox, which is a file sharing and online backup application. You may download it from www.dropbox.com. It will be demonstrated and discussed in class. Homework and projects will be saved in the Dropbox folder, so that the instructor can monitor them at anytime.

 

 

 

 

 

 

 

Schedule

 

Class and Projects Schedule

 

 

Week

Date

Topic

Note Taker 1

Note Taker 2

Note Taker 3

Note Taker 4

1

8/30 TUE

Introduction

 

 

 

 

 

9/1 THU

Intro/Excel – basic formulas, formatting

jtelmani

 

 

 

2

9/6 TUE

Dropbox, Excel – basic formulas, formatting

Spatadia

Aprice28

Jmill134

 

 

9/8 THU

Excel – text manipulation, formulas

drymer

 

Hmacdow1

 

3

9/13 TUE

Excel – import, export

Cliggett

Jcoulte3

Jhoove11

Dfishel4

 

9/15 THU

Excel – links, print reports

SVanMen

Kmorri10

tdeck

Jworman

4

9/20 TUE

Excel – conditional formatting

ghiteman

Afother1

Mhusk

 

 

9/22 THU

Excel - Major specific Data Review

 

 

 

 

5

9/27 TUE

Excel - conditional formatting

Kdavies7

Jbonnet2

showard

 

 

9/29 THU

Excel - Major specific Data Review

 

 

 

 

6

10/4 TUE

Excel – Pivot Tables

 

 

 

 

 

10/6 THU

Excel - Major specific Data Review

 

 

 

 

7

10/11 TUE

Access– Introduction

Project #1 is due

lmurdock

 

 

 

 

10/13 THU

Excel - Major specific Data Review

 

 

 

 

8

10/18 TUE

Access–field types, importing data

 

 

 

 

 

10/20 THU

Excel - Major specific Data Review

 

 

 

 

9

10/25 TUE

Access – basic join queries

 

 

 

 

 

10/27 THU

Advanced Excel Topic - VLOOKUP

 

 

 

 

10

11/1 TUE

Access – Sum / Group By

 

 

 

 

 

11/3 THU

Advanced Excel Topic – Linear Regression

 

 

 

 

11

11/8 TUE

Access / RDMS

 

 

 

 

 

11/10 THU

Advanced Excel Topic – Access Expression Builder

 

 

 

 

12

11/15 TUE

SQL – Intro and basic SQL statements

Project #2 is due

 

 

 

 

 

11/17 THU

Advanced Review – Server Management (demonstration)

 

 

 

 

13

11/22 TUE

MS Word

 

 

 

 

 

11/24 THU

Thanksgiving

 

 

 

 

14

11/29 TUE

MS Powerpoint

 

 

 

 

 

12/1 THU

Operating Systems

 

 

 

 

15

12/6 TUE

Cloud Computing, Open Source

 

 

 

 

 

12/8 THU

Data Communications and Networking / Security

 

 

 

 

16

12/13 TUE

Project #3 is due

 

 

 

 

 

 

 

 

 

 

 

 

Attendance is optional on days highlighted(Material covered on these days is not subject of testing or being part of a project) –When your major is discussed on major specific data review days, your attendance is strongly encouraged.

 

 

 

--- Official KSU/Business Information Follows ---

 

Cheating and Plagiarism

Academic honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit.   In addition, it is considered to be cheating when one cooperates with someone else in any such misrepresentation.  The use of the intellectual property of others without giving them appropriate credit is a serious academic offense.  It is the University's policy that cheating or plagiarism result in receiving a failing grade for the work or course.  Repeat offenses result in dismissal from the University.

Disabled Students

University policy 3342-3-01.3 requires that students with disabilities be provided reasonable accommodations to ensure their equal access to course content. If you have a documented disability and require accommodations, please contact the instructor at the beginning of the semester to make arrangements for necessary classroom adjustments. Please note, you must first verify your eligibility for these through Student Accessibility Services (contact 330-672-3391 or visit www.kent.edu/sas for more information on registration procedures).

Official Registration

Students have responsibility to ensure they are properly enrolled in classes.  You are advised to review your official class schedule (using Student Tools on FlashLine) during the first two weeks of the semester to ensure you are properly enrolled in this class and section.  Should you find an error in your class schedule it is your responsibility to correct the error.  If registration errors are not and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester for any class in which you are not properly registered. 

Document Actions