|
Name: |
Philip Lee |
|
|
E-mail: |
philip.lee@nscc.edu |
|
|
Phone: |
615-353-3418 |
|
|
Office Location: |
C-204F, Clement Building |
|
|
Office Hours: |
Monday Tuesday Wednesday Thursday Friday |
noon - 2:00pm (C-204F) noon - 2:00pm (C-204F) noon - 2:00pm (C-204F) noon - 2:00pm Online (e-mail etc) noon - 2:00pm (C-204F) |
An introduction to the use of microcomputer software in the business environment. Applications include word processing, spreadsheets, data base, and presentation software. It is recommended that Computer Accounting majors complete AIS 1180 before taking AIS 1181. Prerequisites: DSPR 0800 and DSPM 0800
Microsoft Office 2007: Introductory Concepts and Techniques, Windows XP Edition by Shelly, Cashman, and Vermaat, ISBN 141884327X
Casegrader: Autograding Technology for Microsoft Office 2007, ISBN 1423998561. Note: It is not advised to buy Casegrader used because if the access code has been used, you will not be able to use it. Either get at the bookstore or order it directly from course.com
Microsoft Office 2007, version that includes Word, Excel, PowerPoint, and Access
One flash drive is needed to transport data files to class.
Disclaimer: Textbook selection is subject to frequent change. Confirm with the school bookstore that the ISBN listed here is the current prior to buying the textbook.
Note: If you do not have Microsoft Office 2007 version you should consider buying the textbook and Casegrader bundled together in the bookstore with a 180 day trial subscription to Office 2007. The required textbook and software are bundled together in the bookstore under the ISBN: 1428383344.
You will also need access to an Internet connected computer with the minimum operating system of Windows XP or higher and a version of Microsoft Office 2007 that include Microsoft Access.
If you passed either of the following Integrated Input Technologies (#3730) or Spreadsheet Applications (#3729), Database Design/Management (#3735), Interactive Multimedia Presentations (#3746) and Keyboarding/Document Layout and Design (#3727) combined with a B or above, you may receive credit for AIS 1181-Business Software Applications. You will need to have your high school transcript evaluated by either the Dean of Business and Applied Arts or the Program Coordinator for Computer Accounting to receive credit.
To help our students become ethical and competent professionals in their chosen fields by providing a learner-centered environment.
The Business and Applied Arts Division provides programs of study consistent with students’ goals which are intended to develop appropriate skills that our faculty and advisory committees have identified as critical to success. To accomplish this we focus on academic excellence, best practices in teaching and learning, technological competence, and the practical application of discipline-specific principles.
Students will need access to Microsoft Office software outside of class to complete assignments. Office 2007 Professional is available on campus at the following two locations for out of class use:
The
Clement Bldg., Room C-308, check for open hours.
Download from the following site: http://www.course.com Search on the ISBN 141884327X and then click the student download link.
The mission of the Computer Accounting Program is to provide a quality education in computerized accounting that enables students to succeed in a career now and in the future.
Upon successful completion of this course, students will:
1. Produce flyers, resumes, business letters, and research papers in proper format using word processing software.
2. Solve business problems by creating worksheets that include formulas, functions, charts, and reports using spreadsheet software.
3. Organize large volumes of information using database software that allows for the storage and retrieval of data in a useful form.
4. Use presentation software to design a visual presentation that will enhance a speech.
5. Integrate office software applications with the Internet to distribute business information to a wide range of business associates and clients.
The following are detailed course competencies to support the course outcomes:
Given Office software:
1. Format files so that they have a professional appearance.
2. Enhance files by inserting clip art and pictures and formatting as needed.
3. Efficiently copy and move data within and between files.
4. Create footnotes and comments for data that is not part of the main text in a file.
5. Use word count to maintain the desired file size.
6. Add headers and footers to place data outside the main body of the text.
7. Use Spelling and Grammar check to correct mistakes in the text of the file.
8. Create hyperlinks between business files and the Internet to integrate the file with additional information at web sites.
9. Create and format tables as needed to classify information in a useful format.
10. In spreadsheet software, use the AutoSum button to calculate the for sum, average, maximum, and minimum.
11. Give unique names to cells in a spreadsheet.
12. Using data in a file create a chart that emphasizes an important aspect of the data.
13. Enter formulas using the keyboard or point mode. Use Range Finder to verify that the formula is correct.
14. Import business data from a web source.
15. Change worksheet names in a workbook and organize spreadsheets in a useful manner.
16. Resize columns and rows for most useful view of data.
17. Freeze column and row titles, and zoom text to size data for an optimum view.
18. Use the IF function to display the desired result, given alternative circumstances.
19. Apply relative, mixed, and absolute references in formulas so that the correct formula is applied when copied to multiple cells.
20. Select nonadjacent ranges for applying more efficient copying and formatting.
21. Use Goal Seek to determine how much one variable must change to reach a desired goal.
22. Create the structure for a table in a database.
23. Add records to a table in a database.
24. Use a query in a database to retrieve requested data.
25. Create a form to facilitate entering and editing data in a database.
26. Create reports from database information containing relevant data to solve business problems.
27. Use the Help System within the business software to answer questions about how to perform tasks using the software.
28. Convert business files into a format that allows the data to be distributed over the Internet.
29. Create validation rules within database fields that minimize errors and increase speed in data entry.
30. Specify referential integrity within a database to reduce errors in data entry.
31. Use templates and wizards where appropriate in creating business files.
32. Create a visual presentation using slides that guide an audience through a speech.
33. Navigate through a visual presentation using presentation software.
The following are general education competencies to support the course outcomes:
30. Given a business topic to research or business document to generate, produce a clear, well-organized document.
31. Given a business topic, prepare and deliver a well-organized oral presentation.
32. Given an accounting problem, apply basic mathematical concepts to arrive at a solution to the problem.
33. Given a business accounting problem, apply critical thinking skills to determine and support a solution.
34. Given a business or accounting assignment, use and adapt current technologies to increase efficiency and effectiveness in performing routine business applications.
· Word Project One: Check spelling as you type; format text and paragraphs; Undo and redo commands; Insert clip art in document; Correct errors in a document; Use Help to answer questions.
· Word Project Two: Change margin settings and line spacing; use header and footer; modify paragraph indentation; add a footnote/endnote; count words; manual page break; create a hyperlink; sort selected paragraphs.
· Word Project Three: Resume wizard; document templates; tab stops; characters; current date; Auto text entry; tables; labels; smart tags; file properties.
· Excel Project One: Enter text and numbers; AutoSum; fill handle; format a worksheet; charts; AutoCalculate.
· Excel Project Two: Formulas; statistical functions; range finder; conditional formatting; cell size; printing partial worksheets; web queries; naming sheets.
· Excel Project Three: Rotating text; creating a series; Format painter; format symbols; freezing panes; absolute cell references; the IF function; docking toolbars; separate chart sheet; goal seek.
· Access Project One: Create a database; create a table; add records; simple query; forms; reports.
· Access Project Two: Create queries; criteria in queries; compound criteria in queries; join tables; calculations in queries; grouping in queries, crosstab queries.
· Access Project Three: Delete records; search for records; filter records; update table design; format a datasheet; update queries; validation rules, default values; lookup field; referential integrity; sort records, creating indexes.
· PowerPoint Project One: Select a design template; create title and text slides; end show with black slide; slide show view.
· PowerPoint Project Two: Working with outline tab; inserting clip art; animate clip art; animation schemes; printing in various forms.
|
Grading Scale: |
|
|
A |
90 - 100 |
|
B |
80 - 89 |
|
C |
70 - 79 |
|
F |
under 70 |
|
Evaluation: |
|
|
Homework |
30% |
|
Examinations |
50% |
|
Case Grader Chapter Cases |
10% |
|
PowerPoint Project |
10% |
|
Total |
100% |
Homework (30%):
Homework consists of creating files assigned in the course textbook. Files must be submitted through the Assignments page of the online course.
Case Grader Cases (10%):
Case Grader cases are delivered through a web site created by the textbook publishers. You will download a beginning file from the web site and submit your completed file back to the same site. the web site will automatically grade your file and return a grade to you . You have the option of making corrections and resubmitting your file for an improved grade. The instructor will only use your highest grade for each case.
Examinations (50%):
There will be three major examinations. The exams will be delivered in the
classroom for students taking the course with traditional classroom meetings.
The exams will be available in the
PowerPoint Project (10%):
At the end of the semester the student will create a PowerPoint presentation on a chosen topic. This project represents the culmination of work in the course and should represent significant effort. Students in the traditional classroom setting will present the project to the class. Students in the online class setting will present the project online.
Grading evaluations can change from semester to semester. Please consult with your instructor for the weight of each grading criteria.
Students are expected to attend each class session, to arrive on time, and to remain for the entire class period. Students are also responsible for explaining absences and lateness directly to the instructor. Instructors may lower the student’s grade for excessive absences or lateness. If the student is absent, it is the student’s responsibility to find out about missed work and class announcements, etc. during their absence.
Students that miss two consecutive weeks of class and do not contact the instructor during that time will be administratively withdrawn from class and given a grade of WF. If you have a legitimate reason for missing an exam deadline please speak to your instructor concerning a makeup exam.
Students are expected to log into the online course at least twice per week. Students are expected to submit homework, quizzes, exams, and online discussions by the due date.
Students that miss two consecutive weeks of class submitting assignments and do not contact the instructor during that time will be administratively withdrawn from class and given a grade of WF. If you have a legitimate reason for missing an exam deadline please speak to your instructor concerning a makeup exam.
Plagiarism, cheating, and other forms of academic dishonestly are prohibited. Students guilty of academic dishonesty, either directly or indirectly through participation or assistance, are immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions that may be imposed through the regular institutional procedures as result of academic misconduct, the instructor has the authority to assign an "F" or a "zero" for the exercise or examination or to assign an "F" in the course (Student Handbook pages 10 & 11). For information about plagiarism, please see http://www.nscc.edu/library/help.html
Disruptive behavior in the classroom is prohibited and may be defined as, but not limited to, behavior that obstructs or disrupts the learning environment (e.g., offensive language, offensive body odor, harassment of students and instructors, repeated outbursts from a student which disrupt the flow of instruction or prevent concentration on the subject taught, failure to cooperate in maintaining classroom decorum, etc.), and the continued use of any electronic or other noise or light emitting device which disrupts others (e.g., noises from beepers, cell phones, palm pilots, lap-top computers, games, etc.).
Textbook web address is: http://www.course.com search on the text ISBN 141884327X
Students will need access to Microsoft Office software outside of class to complete assignments. Office 2007 is available on campus at the following two locations for out of class use:
The
Clement Bldg., Room C-308, check for open hours.
To learn accounting, it is very important that immerse yourself in the subject. This course does require a lot of work for successful completion. Do not get behind in the work assigned. It is extremely difficult to catch up on back work at the same time current work needs to be completed.
Successful students:
· Read materials and prepare for the course.
· Ask questions and actively participate in the course.
· Complete all assignments prior to due dates.
· Are self-motivated and take responsibility for their own level of success.
· Recognize the power of determination and hard work.
· Allow the instructor to help them become better students.
· Set goals and stick to them.
· Carefully follow written instructions.
· Never think about cheating.
· Carefully manage their time and priorities.
To operate Office 2007 on your computer at home the minimum system requirements are as follows:
|
Microsoft Word Homework Assignments
Assignments:
Work through Chapter 1 – Learn to Ride, pages WD 1 to WD 62
Apply Your Knowledge
Modifying Text and Formatting a Document, pages WD 63 and WD 64
Lab 2: Creating a Flyer with a Picture and Border, pages WD 69 and WD 70.
Cases and Places
2: Design and Create a Property Advertisement Flyer, page WD 72, give the file name Lakefront Property.
Assignments:
Work through Chapter 2 – Wireless Communications Paper, pages WD 74 to WD 132
In the Lab
Lab 1: Preparing a Short Research Paper, pages WD 138 and WD 139.
Lab 2: Preparing a Research Report with a Footnote, pages WD 140 and WD 141.
Assignments:
Work through
Chapter Three – Canaan Cover Letter,
In the Lab
Lab 1: Creating a Cover Letter with a Table, pages WD 209 and WD 210.
Lab 2: Creating a Resume from a Template, pages WD 210 and WD 211.
Cases and Places
4: Create Your Resume and Cover Letter for a Potential Job, page WD 213
WEB FEATURE:
Work through pages WD 215 to WD 223, create the Canaan Resume Web Page
Microsoft Excel Homework Assignments
Assignments:
Work through Chapter 1 – Walk and Rock Music 1st Quarter Sales, pages EX 1 to EX 69
In the Lab
Lab 2: Annual Sales Analysis Worksheet, pages EX 75 to EX 77.
Lab 3: College Cost and Financial Support Worksheet, pages EX 77 to EX 79.
Assignments:
Work through Chapter 2 - Silver Dollars Stock Portfolio Summary, pages EX 82 to EX 144
In the Lab
Lab2: Balance Due Worksheet, pages EX 151 to EX 154.
Cases and Places
2: Create a Profit Potential Worksheet, page EX 157
Assignment:
Work through Chapter 3 – Campus Clothiers Semiannual Projection, pages EX 162 to EX 228
Understanding Logical Tests and Absolute Cell Referencing, pages EX 229 to EX 230.
In the Lab
Lab 2: Modifying a Weekly Payroll Worksheet, pages EX 237 to EX 240 Work Part 1 Only.
Lab 3: Analysis of Indirect Expense Allocations, pages EX 241 to EX 244.
Work through pages EX 250 to EX 261 create the Stonegate Plumbing 1st Quarter Sales Web Page.
Microsoft Access Homework Assignments
Assignment:
Work through Chapter 1 – JSP Recruiters, pages AC 2 to AC 63
In the Lab
Lab 1: Creating the JMS TechWizards Database, pages AC 67 to AC 68.
Lab 2: Creating the Hockey Fan Zone Database, pages AC 68 to AC 69.
Assignment:
Work through Chapter 2 – JSP Recuiters, pages AC 74 to AC 127
In the Lab
Lab 1: Querying the JMS TechWizards Database, AC 131 to AC 132.
Lab 2: Querying the Hockey Fan Zone Database, AC 132 to AC 134.
Assignment:
Work through Chapter Three – JSP Recuiters, pages AC 138 to AC 195
In the Lab
Lab 1: Maintaining the JMS TechWizards Database, pages AC 199 to AC 200.
Lab 2: Maintaining the Hockey Fan Zone Database, pages AC 200 to AC 201.
Integration Feature:
Work through pages AC 206 to AC 230 to create several files through importing and exporting
Microsoft PowerPoint Homework Assignments
Assignment:
Work through Chapter One – Cabo Package, pages PPT 2 to PPT 65
In the Lab
Lab 3: Creating and Updating Presentations, pages PPT 74 to PPT 77.
Cases and Places:
4 Design and Create Your Favorite or Dream Car Presentation, page PPT 80.
Assignment:
Work through Chapter Two – Identity Theft, pages PPT 82 to PPT 131
In the lab
Lab 3: Creating a Presentation with Clips and Shapes, pages PPT 140 to PPT 141.
Cases and Places:
2: Design and Create a Hypertension Presentation, page PPT 143.
Web Feature:
Work through pages PPT 146 to PPT 157 to create Yoga Web Page
Assignment:
Work through Chapter One – Identity Theft, pages PPT 82 to PPT 131