Syllabus for AD101_Tripp_Fall2007
AD101 – Introduction to Microcomputer Applications
INSTRUCTOR: Instructor: Ms. Anna Tripp
Department: Accounting and Management Information Systems
Office Hours: 5:15 - 7:00 p.m. By Appointment Only
Office Room: Dempster Room 237
Home Phone: 573-200-0120
Email:
This course is divided into course work from:
· the textbook Shelly Cashman Series Microsoft Office 2007 from Course Technology that you can rent from Textbook Services at the University
· assignments you will submit to the DropBox
· unit test using UTest
· checking your grade using the GradeBook
You can work the assignments at your own pace; however, the unit quizzes and exams will be scheduled following this syllabus.If you are not familiar with the University's Instruction Suite (OIS), please click here for a tutorial to show you how to do what is required for UTest, the DropBox, the GradeBook and other activities used in this course.
· You will be using your Southeast Key for all correspondence and for logging on to my web page to take quizzes, submitting your course assignments, and checking your grade.
· For all assignments from the textbook where the instructions indicate you are to "print" the item, you will NOT print the item, but will be instructed in this course to drop the assignment into the DropBox.
· All Quizzes will remain open from the beginning of a unit until the date of the next exam for that unit. Be sure to check the dates the Quizzes are available for each unit.
· You can follow the Links in the GradeBook to keep track of the assignments, quizzes and exams that are required and what your current score is.
· Click here for a weekly schedule of course work and exams. Click on the links at the top of this page for instructions for each unit covered in this course.
· You will need to purchase a USB flash drive to be used to save all of your work from the labs on campus.
Weekly Schedule and Syllabus for AD101 – Tripp - Fall 2007
Week of / Chapters CoveredAug 20 / Intro to Computers & the Internet
Aug 27 / Intro to Windows XP & Start Word 1
Sept 3 / No Class
Sept 10 / Word 2
Sept 17 / Word 3 & Web Feature
Sept 24 / Word Exam
Oct 1 / Excel 1 & 2
Oct 8 / Excel 3 & Web Feature
Oct 15 / Excel Exam
Oct 22 / Access 1 & 2
Oct 29 / Access 3 & Integration
Nov 5 / Access Exam
Nov 12 / PowerPoint 1
Nov 19 / PowerPoint 2 & Web Feature
Nov 26 / PowerPoint Presentations
Dec 3 / Integration 2007
Dec 10 / Final
Instructions for Word Chapters
Download the appropriate Word project files from the DropBox link to your "My Documents" folder on your computer or on a USB flash drive. The textbook will refer to the file as this: 'from the Data Files for Students'. All of the student’s data files are available for you to download from the DropBox. (I recommend this option) or you can click on this link to find the file: http://www6.semo.edu/acct&mis/Courses/AD101/AD101_information_page.htm
When the textbook indicates you are ready to print, do not print, but submit the saved document to the appropriate DropBox.
- Chapter 1
o READ & COMPLETE Word Chapter 1, “Creating and Editing a Word Document,” pages WD 1-62. You will need the Horse and Rider.jpg picture file from the DropBox. Submit the completed file to the DropBox: Horse Back Riding Lessons Flyer.
o COMPLETE Apply Your Knowledge, pages WD 63-64. Submit this file to the DropBox: Apply 1-1 Autumn Fest Flyer
o COMPLETE Lab 1, page WD 67-68. Submit this file to the DropBox: Lab 1-1 Airplane Rides Flyer
o COMPLETE one out of the five Cases and Places, pages WD 71-72. Submit it to the DropBox..
o Answer Word Chapter 1 On-line Quiz. Go to: Tests & Quizzes.
2. Chapter 2
o READ & COMPLETE Word Chapter 2, “Creating a Research Paper” pages WD 74-132. Submit this file to the DropBox: Wireless Communication Paper.
o COMPLETE Apply Your Knowledge, pages WD 133-134. Submit this file to the DropBox: Apply 2-1 Software Paragraphs Draft
o COMPLETE Lab 2 page WD 140-141. Submit this file to the DropBox: Lab 2-2 Antivirus Programs Paper
o COMPLETE one of the five Cases and Places, pages WD 143-144. Submit it to the DropBox.
o Answer Word Chapter 2 On-line Quiz. Go to: Tests & Quizzes
- Chapter 3
o READ & COMPLETE Word Chapter 3, “Creating a Cover Letter and a Resume,” pages WD 145-204. Submit these files to the DropBox: Canaan Cover Letter and Canaan Resume. Each are worth 10 points.
o COMPLETE Apply Your Knowledge, pages WD 205-206. Submit this file to the DropBox: Apply 3-1 Expenses Table Draft.
o COMPLETE Lab 1, pages WD 209-210. Submit this file to the DropBox: Lab 3-1 Owens Letterhead.
o COMPLETE Lab 2, pages WD 210-211. Submit this file to the DropBox: Lab 3-2 Marsh Resume.
o Answer Word Chapter 3 On-line Quiz 4 WD-3. Go to: Tests & Quizzes.
4. Chapter Word Web Feature
o READ & COMPLETE Word Web Feature Chapter, “Creating a Web Page Using Word” pages WD 216-. Submit this file to the DropBox: Canaan Resume Web Page.
o COMPLETE Lab 1 page WD 224. Submit this file to the DropBox: Lab WF-1 Computer Forensics Paper Web Page A.
o COMPLETE Lab 2 page WD 224. Submit this file to the DropBox: Lab WF-2 Marsh Resume Web Page.
o Answer Word Web Feature On-line Quiz 5 WD-4. Go to: Tests & Quizzes
Instructions for Excel Chapters
Download the appropriate Excel project files from the DropBox link on my home page to your "My Documents" folder on your computer or save it to a USB flash drive. The textbook will refer to the file as: 'from the Data Files for Students'. All of the student’s data files are available for you to download from the DropBox (I recommend this option) or you can click on this link to find the file: http://www6.semo.edu/acct&mis/Courses/AD101/AD101_information_page.htm
When the textbook indicates you are ready to print, do not print, but submit the saved spreadsheet to the appropriate DropBox. There is a separate DropBox for each of the following assignments:
1. Chapter 1
o READ & COMPLETE Excel Chapter 1, “Creating a Worksheet and an Embedded Chart,” pages EX 1-69. Submit this file to the DropBox: Walk and Rock Music 1st Quarter Sales.
o COMPLETE Apply Your Knowledge, pages EX 70-71. Submit the completed file to the DropBox: Apply 1-1 Bicycle Shop 3rd Quarter Sales.
o COMPLETE In the Lab: Lab 1, pages EX 74-75. Submit this file to the DropBox: Lab 1-1 Konas Expresso Coffee Annual Cost of Goods.
o COMPLETE In the Lab: Lab 3, pages EX 77-78. Submit this file to the DropBox: Lab 1-3 Part 1 College Cost and Financial Support.
o Answer Excel Chapter 1 On-line Quiz. Go to: Tests & Quizzes.
2. Chapter 2
· READ & COMPLETE Excel Chapter 2, “Formulas, Functions, Formatting, and Web Queries” pages EX 81-143. Submit this file to the DropBox: Silver Dollars Stock Club Portfolio Summary.
· COMPLETE Apply Your Knowledge, pages EX 145-146. Submit this file to the DropBox: Apply 2-1 Car-B-Clean Profit Analysis.
· COMPLETE In the Lab 1: Sales Analysis Worksheet– Instructions Part 1 (Only) pages EX 149-151. Submit this file to the DropBox: Lab 2-1 Part 1 Facade Importers Sales Analysis.
· COMPLETE In the Lab 2: Balance Due Worksheet Instructions Part1 and Part 2 (only), pages EX 151-154. Submit these files to the DropBox: Lab 2-2 Part 1 Jackson’s Bright Ideas Monthly Balance Due Report and Lab 2-2 Part 2 Jackson’s Bright Ideas Monthly Balance Due Report. (They are each worth 10 points.)
· Answer Excel Chapter 2 On-line Quiz. Go to: Tests & Quizzes
3. Chapter 3
· READ & COMPLETE Excel Chapter 3, “What-If Analysis, Charting, and Working with Large Worksheets’” pages EX 161-228. Submit this file to the DropBox: Campus Clothiers Semiannual Financial Projection.
· COMPLETE Apply Your Knowledge - Instructions Part 3 (only), pages EX 229-230. Submit this file to the DropBox: Apply 3-1 Absolute Cell References.
· COMPLETE Extend Your Knowledge – Instructions Part 2 (only) page EX 231. Submit the completed worksheet to the DropBox: Extend 3-1 Create Series Complete.
· COMPLETE In the Lab 3-2 Modifying a Weekly Payroll Worksheet - Instructions Part 1 (only) pages EX 237- 240. Submit this file to the DropBox: Lab 3-2 Britney’s Music Emporium Weekly Payroll Report.
· Answer Excel Chapter 3 On-line Quiz. Go to: Tests & Quizzes
4. Chapter Web Feature
· READ & COMPLETE Excel Web Feature, “Creating Web Pages Using Excel’” pages EX 250-261. Submit this file to the DropBox: Stonegate Plumbing 1st Quarter Sales Web Page.
· COMPLETE In the Lab 1- Creating a Web Page I, page EX 262. Submit this file to the DropBox: Lab WF-1 Aunt Leonas Pizza Annual Sales.
· COMPLETE In the Lab 2 - Creating a Web Page II, page EX 262. Submit this file to the DropBox: Lab WF-2 What-a-Racket Tennis Club Projections.
· Answer Excel Chapter 3 On-line Quiz. Go to: Tests & Quizzes
Instructions for Access Chapters
Download the appropriate Access project files from the DropBox link on my home page to your "My Documents" folder on your computer or save it to a USB flash drive. The textbook will refer to the file as: 'from the Data Files for Students'. All of the student’s data files are available for you to download from the DropBox (I recommend this option) or you can click on this link to find the file: http://www6.semo.edu/acct&mis/Courses/AD101/AD101_information_page.htm
When the textbook indicates you are ready to print, do not print, but submit the completed database to the appropriate DropBox. There is a separate DropBox for each of the following assignments:
1. Chapter 1
o READ & COMPLETE Access Chapter 1, “Creating and Using a Database,” pages AC 2-63. Submit this completed database to the DropBox: JSP Recruiters.
o COMPLETE Apply Your Knowledge, pages AC 64-65. Submit this completed database to the DropBox: The Bike Delivers.
o COMPLETE In the Lab: Lab 1, pages AC 67-68. Submit this completed database to the DropBox: JMS Tech Wizards.
o COMPLETE In the Lab: Lab 2, pages AC 68-69. Submit this completed database to the DropBox: Hockey Fan Zone.
o Answer Access Chapter 1 Online Quiz. Go to: Tests & Quizzes.
2. Chapter 2
· READ & COMPLETE Access Chapter 2, “Querying a Database” pages AC 74-127. Submit this completed database to the DropBox: JSP Recruiters.
· COMPLETE Apply Your Knowledge, pages AC 128-129. Submit this completed database to the DropBox: The Bike Delivers.
· COMPLETE In the Lab 1 pages AC 131-132. Submit this completed database to the DropBox: JMS Tech Wizards.
· COMPLETE In the Lab 2 pages AC 132-133. Submit this completed database to the DropBox: Hockey Fan Zone.
· Answer Access Chapter 2 Online Quiz. Go to: Tests & Quizzes
3. Chapter 3
· READ & COMPLETE Access Chapter 3, “Maintaining a Database”, pages AC 137-196. Submit this completed database to the DropBox: JSP Recruiters
· COMPLETE Apply Your Knowledge, pages AC 196-197. Submit this completed database to the DropBox: The Bike Delivers
· COMPLETE In the Lab 1: Maintaining the JMS Tech Wizards Database, pages 199-200. Submit the completed database to the DropBox.JMS Tech Wizards
· COMPLETE In the Lab 2: Maintaining the Hockey Fan Zone Database, pages AC 200-201. Submit the completed database to the DropBox: Hockey Fan Zone
· Answer Access Chapter 3 Online Quiz. Go to: Tests & Quizzes
4. Chapter Access Integration Feature
· READ & COMPLETE Access Integration Feature, “Sharing Data Among Applications’” pages AC 206-230. Submit this completed database to the DropBox: JSP Consulting
· COMPLETE In the Lab 1- Importing Data to an Access Database, pages AC 230-231. You will need Customer.csv and Product.xlsx from the DropBox. Submit this completed database to the DropBox: TAL Woodworks.
· COMPLETE In the Lab 2 – Exporting Data to Other Applications, page AC 232. Submit this completed database to the DropBox: JMS Tech Wizards
· Answer Access Integration Feature Online Quiz. Go to: Tests & Quizzes
Instructions for PowerPoint Chapters
Download the appropriate PowerPoint project files from the DropBox link on my home page to your "My Documents" folder on your computer or save it to a USB flash drive. The textbook will refer to the file as: 'from the Data Files for Students'. All of the student’s data files are available for you to download from the DropBox (I recommend this option) or you can click on this link to find the file: http://www6.semo.edu/acct&mis/Courses/AD101/AD101_information_page.htm
When the textbook indicates you are ready to print, do not print, but submit the saved presentation to the appropriate DropBox. There is a separate DropBox for each of the following assignments:
1. Chapter 1
o READ & COMPLETE PowerPoint Chapter 1, “Creating and Editing a Presentation,” pages PPT 2-65. Submit this completed presentation to the DropBox: Cabo Package.