Transcription
POFI 1301—COMPUTER APPLICATIONS IFall 201716 WEEKS / WEEKLY ASSIGNMENTSTEXTBOOK CHAPTERSMicrosoft Office 2016 (Word, Excel, PowerPoint and Access)INTRODUCTON (Windows 10/Office 2016)Introduction: Instructor, Students, Etc.MY IT LAB for Office 2016—Will be used during this semester!Week 1WindowsChapter 1Getting Started with Windows 10Outcomes/Objectives 1-11, p.1Project 1A, Getting to Know Windows 10, pgs. 2-46Project 1B, Managing Files and Folders pgs. 47-74(MyITLab) Windows 10: End of Chapter QuizOfficeChapter 1Introduction to Microsoft Office 2016 FeaturesOutcomes/Objectives 1-11, p. 95Project 1A, Note Form, pgs. 96-114Project 1B, Memo, pgs. 115-142(MyITLab) Common Features: End of Chapter QuizIntroducing Microsoft WORD 2016Week 2WordChapter 1Creating Documents with Microsoft Word 2016Outcomes/Objectives 1-8, p. 151(Textbook) Project 1A-Flyer, pgs.152-170(MyITLab) Word Chapter 1: Project 1A Simulation Training(Textbook) Project 1B-Information Handout, pgs. 173-192(MyITLab) Word Chapter 1: Project 1B Simulation Training(MyITLab) WD Ch 1 Grader Project 1E: Documentary, pgs. 205-206(MyITLab) Word Chapter 1: End of Chapter Quiz(MyITLab) Word Chapter 1: MOS Quiz
Week 3WordChapter 2Creating Cover Letters and Using Tables to Create ResumesOutcomes/Objectives 1-6, p. 215(Textbook) Project 2A-Resume, pgs.216-230(MyITLab) Word Chapter 2: Project 2A Simulation Training(Textbook) Project 2B-Cover Letter and Envelope, pgs. 234-250(MyITLab) Word Chapter 2: Project 2B Simulation Training(MyITLab) WD Ch 2 Grader Project 2E: Table of Job Listings,pgs. 263-264(MyITLab) Word Chapter 2: End of Chapter Quiz(MyITLab) Word Chapter 2: MOS QuizWeek 4WordChapter 3Creating Research Papers, Newsletters, and Merged Mailing LabelsOutcomes/Objectives 1-7, p. 273(Textbook) Project 3A-Research Paper, pgs.274-292(MyITLab) Word Chapter 3: Project 3A Simulation Training(Textbook) Project 3B-Newsletter with Optional Mailing Labels,pgs. 295-318(MyITLab) Word Chapter 3: Project 3B Simulation Training(MyITLab) WD Ch 3 Grader Project 3E: Skin Protection Report,pgs. 333-335(MyITLab) Word Chapter 3: End of Chapter Quiz(MyITLab) Word Chapter 3: MOS QuizWeek 5Practice ExamExam-Word: CHAPTERS 1-2-3MOS Certification Exam
Introducing Microsoft EXCEL 2016Week 6ExcelChapter 1Creating a Worksheet and Charting DataOutcomes/Objectives 1-11, p. 349(Textbook) Project 1A-Sales Report with Embedded Column Chartand Sparklines, pgs. 350-377(MyITLab) Excel Chapter 1: Project 1A Simulation Training(Textbook) Project 1B-Inventory Valuation, pgs. 379-392(MyITLab) Excel Chapter 1: Project 1B Simulation Training(MyITLab) XL Ch 1 Grader Project 1F: Balance Sales, pgs. 408-409(MyITLab) Excel Chapter 1: End of Chapter Quiz(MyITLab) Excel Chapter 1: MOS QuizWeek 7ExcelChapter 2Using Functions, Creating Tables, and Managing Large WorkbooksOutcomes/Objectives 1-12, p. 415(Textbook) Project 2A-Inventory Status Report, pgs. 416-438(MyITLab) Excel Chapter 2: Project 2A Simulation Training(Textbook) Project 2B-Weekly Sales Summary, pgs. 440-457(MyITLab) Excel Chapter 2: Project 2B Simulation Training(MyITLab) XL Ch 2 Grader Project 2F: Bonus, pgs. 472-473(MyITLab) Excel Chapter 2: End of Chapter Quiz(MyITLab) Excel Chapter 2: MOS Quiz
Week 8ExcelChapter 3Analyzing Data with Pie Charts, Line Charts, and What-If AnalysisToolsOutcomes/Objectives 1-7, p. 481(Textbook) Project 3A-Enterprise Fund Pie Chart, pgs. 482-496(MyITLab) Excel Chapter 3: Project 3A Simulation Training(Textbook) Project 3B-Tourism Spending Projection with Line Chart,pgs. 498-515(MyITLab) Excel Chapter 3: Project 3B Simulation Training(MyITLab) XL Ch 3 Grader Project 3F: Streets, pgs. 529-530(MyITLab) Excel Chapter 3: End of Chapter Quiz(MyITLab) Excel Chapter 3: MOS QuizPractice ExamEXAM – EXCEL CHAPTERS 1-2-3MOS Certification ExamWeek 9Introducing Microsoft POWERPOINT 2016Week 10 intChapter 1 Outcomes/Objectives 1-8, p. 781(Textbook) Project 1A-Company Overview, pgs. 782-805(MyITLab) PowerPoint Chapter 1: Project 1A Simulation Training(Textbook) Project 1B-Itinerary Presentation, pgs. 808-824(MyITLab) PowerPoint Chapter 1: Project 1B Simulation Training(MyITLab) PowerPoint Ch 1 Grader Project 1E: Juneau, pgs.837-838(MyITLab) PowerPoint Chapter 1: End of Chapter Quiz(MyITLab) PowerPoint Chapter 1: MOS Quiz
Week 11PowerPointChapter 2Formatting PowerPoint PresentationsOutcomes/Objectives 1-6, p. 847(Textbook) Project 2A-Employee Training Presentation, pgs. 848871(MyITLab) PowerPoint Chapter 2: Project 2A Simulation Training(Textbook) Project 2B-Event Announcement, pgs. 874-886(MyITLab) PowerPoint Chapter 2: Project 2B Simulation Training(MyITLab) PowerPoint Ch 2 Grader Project 2E: Coasters, pgs.898-899(MyITLab) PowerPoint Chapter 2: End of Chapter Quiz(MyITLab) PowerPoint Chapter 2: MOS QuizWeek 12PowerPoint Enhancing a Presentation with Animation, Video, Tables, and ChartsOutcomes/Objectives 1-5, p. 909Chapter 3(Textbook) Project 3A-Informational Presentation, pgs. 910-929(MyITLab) PowerPoint Chapter 3: Project 3A Simulation Training(Textbook) Project 3B-Summary and Analysis Presentation, pgs.932-948(MyITLab) PowerPoint Chapter 3: Project 3B Simulation Training(MyITLab) PowerPoint Ch 3 Grader Project 3E: Gardens, pgs.961-962(MyITLab) PowerPoint Chapter 3: End of Chapter Quiz(MyITLab) PowerPoint Chapter 3: MOS QuizWeek 13Practice ExamEXAM – PowerPoint CHAPTERS 1-2-3MOS Certification Exam
Introducing Microsoft Access 2016Week 14AccessChapter 1Getting Started with Microsoft AccessOutcomes/Objectives 1-9, p. 539(Textbook) Project 1A-Student Advising Database with Two Tables, pgs. 540-575(MyITLab) Access Chapter 1: Project 1A Simulation Training(Textbook) Project 1B-Student Workshops Database, pgs. 578-590 (MyITLab) AccessChapter 1: Project 1B Simulation Training(MyITLab) Access Ch 1 Grader Project 1G: College Construction, pgs. 612-614(MyITLab) Access Chapter 1: End of Chapter Quiz(MyITLab) Access Chapter 1: MOS QuizWeek 15AccessChapter 2Sort and Query a DatabaseOutcomes/Objectives 1-15, p. 619(Textbook) Project 2A-Instructors and Courses Database,pgs. 620-645(MyITLab) Access Chapter 2: Project 2A Simulation Training(Textbook) Project 2B-Athletic Scholarships Database, pgs.648-672 (MyITLab) Access Chapter 2: Project 2B SimulationTraining(MyITLab) Access Ch 2 Grader Project 2G: Student Scholarships,pgs.695-697(MyITLab) Access Chapter 2: End of Chapter Quiz(MyITLab) Access Chapter 2: MOS QuizWeek 16AccessChapter 3Forms, Filters, and ReportsOutcomes/Objectives 1-8, p. 703(Textbook) Project 3A-Students and Majors Database, pgs. 704-729(MyITLab) Access Chapter 3: Project 3A S (Textbook) Project 3B-JobOpenings Database, pgs. 732-749 (MyITLab) Access Chapter 3:Project 3B Simulation Training(MyITLab) Access Ch 3 Grader Project 3G: Career Books, pgs.772-775(MyITLab) Access Chapter 3: End of Chapter Quiz(MyITLab) Access Chapter 3: MOS Quiz imulation Training
EXAM – Access CHAPTERS 1-2-3COMPREHENSIVE FINAL EXAM REVIEWWeek 16FINAL EXAMNote: This syllabus is subject to change at the discretion of the instructor toaccommodate instructional and/or student needs.
(Textbook) Project 2A-Inventory Status Report, pgs. 416-438 (MyITLab) Excel Chapter 2: Project 2A Simulation Training (Textbook) Project 2B-Weekly Sales Summary, pgs. 440-457 (MyITLab) Excel Chapter 2: Project 2B Simulation Training (MyITLab) XL Ch 2 Grader Project 2F: Bonus, pgs. 472-473 (MyITLab) Excel Chapter 2: End of Chapter Quiz
