Assignments
Periods 3 & 4 Computer Applications 1
 Instructor
 Jan Callow
 Term
 20172018 School Year
 Department
 Business
 Description

In addition to learning the standards associated with this class, which include: proper file management techniques and computer fundamentals, as well as Microsoft Office 2013 PowerPoint, Word, & Excel applications, students will have opportunities to receive industry certification at no cost!
Through a partnership between Washington State and Microsoft, Columbia High School is an official Microsoft Imagine Academy site. This means while you’re learning to apply these business programs, you’ll also be able to become certified. These certification exams normally cost between $100$300!
The Microsoft Imagine Academy provides students with the future ready technology skills they need to be successful in college and a career—skills that enable them to collaborate, communicate, and be critical thinkers, innovators, problem solvers and citizens of a global economy.
Files
Upcoming Assignments
No upcoming assignments.
Past Assignments
Due:
 Using the instructions for "Projected Budget for Eagle Lake Camp," create a spreadsheet and appropriate chart
 Have Mrs. Callow check when complete
Due:
 Finish Excel spreadsheet additional practice Project 9G from GO! 2007 (review of learning targets for this week)
Due:
 Independent Excel practice: Project 9E from GO! 2007 textbook
 Go over instructions at tables prior to beginning assignment
Due:
 Open Excel Intro activity from yesterday
 Create basic formulas and format worksheet, rename sheet
Due:
 After an overview, students will complete the intro activity "Rio Rancho Auto Gallery"
Due:
 Certification Exam for those students not able to test yesterday
 Complete Word Lessons 5 & 6 Assessment
 Review Word for next Certification Exam OR
 Continue working in Excel if already started
Due:
 Finish Lesson 6 Assessment if necessary
 Continue with Lesson 7: Working with References
Due:
 Word Lessons 5 & 6 Assessment
 Begin Lesson 7: Working with References
Due:
 Hand back Lesson 4 Assessment
 Word Lesson 6, pp. 190202 (2 "Learn the Skill" exercises)
 Drink Can Design Activity
Due:
 Classroom Activity to learn skills in Word Lessons 5 and 6 OR
 Complete "Learn the Skill" exercises independently
Due:
 Hand back Assessment 3 rubrics
 Lesson 4 Assessment
Due:
 Certification Exam OR
 Lesson 4, pp. 122137 (4 "Learn the Skill" exercises)
Due:
 Word Lessons 13 Assessment/Part 2
Due:
 Word Lessons 13 Assessment/Part 1
Due:
 Word Lesson 3, pp. 8599 (2 "Learn the Skill" exercises)
 Overview of Styles
 Learn the Skill, pp. 9799
 Learn the Skill, pp. 9192
Due:
 Lesson 3 Overview using Word Practice document OR
 completing "Learn the Skill" exercises independently
Due:
Assignment:
 Overview of Word Lessons 1 & 2
Due:
 Go over PowerPoint Presentation Rubric/Score
 Discuss PowerPoint Certification Scores/Review
 Beginning Word Activity
Due:
 PowerPoint Certification Exam
OR Continue in Word Lessons
Due:
Due:
 Presentations
Due:
 Make any final changes to presentations and email to meuse "Final Presentation" as the subject of your email
 Continue working through PowerPoint Lessons 7 & 8 OR if you have already passed the PowerPoint Certification exam, you can begin Word
Due:
 Practice presentations in small groups (34 per group)
Due:
 Go over presentation rubric
 Watch a presentation video
 Prepare Speaking Notes
 If you are ready for your presentation, continue working in PowerPoint Lessons 7 & 8
Due:
 PowerPoint Assessment #2due today
 When finished, prepare speaking notes
Due:
 PowerPoint Lesson 7, pp. 209235
 Work independently through Lesson 7 using "Learn the Skill" exercises
Due:
 Using Homecoming Presentationpractice adding transitions and animations
Due:
 PowerPoint Lesson 5, pp. 155170
 Independently or using Homecoming Presentation
Due:
 PowerPoint Lesson 5, pp. 141154
 Independently or using Homecoming Presentation
Due:
 Log into computer
 Double click the Console 8 icon on your desktop
 Click "Yes" on the pop up box
 Log in with your user name and password
 Follow prompts as instructed
 Enter the Proctor username and password
Due:
 If absent yesterday, create Certiport & MS Office Accounts
 Make corrections (if desired) to PowerPoint Assessment #1 & resend
 Continue with PowerPoint Lesson 4, pp. 111140
Due:
 Create Certiport & Microsoft Office accounts for Certification Exam
 Continue working independently OR
 Follow classroom activity using Homecoming presentation
Due:
 Finish Lessons 13 Assessment
 Begin Lesson 4, pp. 111140
Due:
 Go over Assessment instructions & rubric
 Complete Lessons 13 Assessment
Due:
 PowerPoint Lesson 3, pp. 7386
 Continue working independently
 OR with class using Homecoming presentation
Due:
 PowerPoint Lesson 2, pp. 6263 Draft Template for Review (you'll need this for Lesson 3)
 PowerPoint Lesson 3, pp. 7386, 7 "Learn the Skill" exercises
Due:
 Use "Columbia High School" practice presentation to learn Lesson 2 skills OR
 Work independently completing Lesson 2 "Learn the Skill" exercises, pp. 4372
Due:
 Answer any questions from Lesson 1
 Use "Columbia High School" practice presentation to learn Lesson 2 skills OR
 Work independently completing Lesson 2 "Learn the Skill" exercises, pp. 4372
Due:
 PowerPoint Lesson 1, pp. 3342
 Discuss "backward compatability"
 Quick Access Toolbar
 Opening blank and template presentations
 Arrange and switch between presentations
 Add & modify document properties
Due:
 PowerPoint Lesson 1
 Overview of PowerPoint
Due:
Assignment:
 Discuss Friday's Presentation
 Discuss above Learning Target
 Introduce MicroType and have students work on that while loading textbooks & files
Begin with Lesson 1
Due:
Due:
 Excel Assessment: Homecoming spreadsheet & chart
Due:
 Using the instructions for "Projected Budget for Eagle Lake Camp," create a spreadsheet and appropriate chart
 Have Mrs. Callow check when complete
Due:
 Finish Excel spreadsheet additional practice Project 9E & 9G from GO! 2007 (review of learning targets for this week) THEN
 Review for Office Certification ExamPowerPoint, Word, or ExcelR
Due:
Assignment:
 Finish Project 9E from GO! 2007 textbook/Teacher check
 Begin Project 9G
Due:
 Open Excel Intro activity from yesterday
 Create basic formulas and format worksheet, rename sheet & delete unused sheets
Due:
 After an overview, students will complete the intro activity "Rio Rancho Auto Gallery"
Due:
Due:
 Microsoft Word Certification Exam
Due:
 Finish Word Lessons 46 Assessment
 Word Lesson 7, pp. 214224 (3 "Learn the Skill" exercises)
Due:
 Word Lessons 46 Assessment
Due:
 Hand back Word Assessment #1
 Word Lesson 6, 197end
 Word Lesson 7, pp. 203211 (2 "Learn the Skill" exercises)
Due:
 Complete Drink Can Design activity
Due:
 Word Lesson 6, pp. 187201
 Drink Can Design Activity
Due:
 If working independently, Word Lesson 6, pp. 171189 (3 "Learn the Skill" exercises) OR
 Open practice and follow with teacher demonstrations
Due:
Assignment:
 Practice skills from Lesson 4
 Choice: Continue working independently OR follow along with class activity
Due:
 Word Lesson 5, pp. 139159
 Choice: Continue working independently if you have already started Lesson 5 OR
follow along with class activity
 Choice: Continue working independently if you have already started Lesson 5 OR
Due:
 Lessons 13 Assessment
 Continue in Lesson 4 or 5
Due:
Assignment:
 Lessons 13 Assessment
Due:
Due:
 Complete Lesson 3 Review
 Continue with Lesson 3, pp. 7692 (3 "Learn the Skill" exercises)
Due:
 Continue with Lesson 3, pp. 7692
 Teacher demonstrate Stylesapply, modify, create
 Students complete "Learn the Skill" exercises, pp. 9192; 9799; & 101
Due:
Due:
 Review various ways to select text, including using the 'selection bar'
 Students open Word and key two paragraphs about their school year
 Use this paragraph to practice above learning targets
Due:
Due:
 Presentations
 PowerPoint Reflection
 Go through PowerPoint Lessons 7 & 8
Due:
Due:
 Hand back PowerPoint Assessment #2 Rubrics
 Watch short video regarding presentation skills
 Practice Presentations in small groups
 Revise presentations based on feedback
 Class presentations will begin on Tuesday
Due:
 Go over presentation rubric
 Prepare Speaking Notes
 PowerPoint Lesson 7, pp. 209235
Due:
 PowerPoint Assessment #2 due today
 When finished, prepare speaking notes
Due:
 PowerPoint Assessment #2 due today
 When finished, continue with Lesson 7, pp. 209235 (9 "Learn the Skill" exercises
Due:
 Using Homecoming Presentationpractice adding transitions and animations
Due:
 Finish Lesson 5Photo Album, pp. 162163
 Using Homecoming Presentationpractice adding transitions and animations
Due:
 PowerPoint Lesson 5, pp. 144182classroom activities using Homecoming presentation OR
 Independently completing "Learn the Skill" activities
Due:
 Discuss Certification Results & how to study
 PowerPoint Lesson 5, pp. 144182classroom activities using Homecoming presentation OR
 Independently completing "Learn the Skill" activities
Due:
 Create a Certiport & Microsoft testing account
 Practice learned skills using Homecoming presentation
 MicroType
Due:
 Create a Certiport & Microsoft testing account
 Review Lesson 14 to prepare for exam
 MicroType
Due:
 Review Lesson 4 using Homecoming Presentation
Due:
 Lesson 4, pp. 128140 (3 "Learn the Skills")
Due:
 Lesson 4, pp. 123127 (2 "Learn the Skills")
Due:
 Overview of Lesson 4
 Lesson 4, pp. 111122 (3 "Learn the Skills")
Due:
Assignment:
 PowerPoint Assessment #1
Due:
Assignment:
 Apply skills taught in Lesson 3 to our Homecoming presentation
Due:
 Continue with Lesson 2, pp. 4672 either working independently and completing all the "Learn the Skill" exercises or following along with class Homecoming presentation
Due:
 Opening Activity: Review Lesson 1 using p. 42ask students what they need to know from the Lesson Summary and demonstrate
 Students can complete Lesson 2 independently by completing all the "Learn the Skill" exercises or follow teacher demonstration using "Homecoming" presentation
Due:
 Open PowerPoint
 Review pp. 2342 together
 Follow in the book independently or follow class demonstration
Due:
 Students practice keyboarding using MicroType while I will copy the files you'll need for PowerPoint and Word
 Create folders for Computer Apps
 Overview of PowerPoint
Due:
 Complete "Expectations Activity"
 Students practice keyboarding using MicroType while I will copy the files you'll need for PowerPoint and Word
 Create folders for Computer Apps
 Overview of PowerPoint
Due:
 Finish the 9E & 9G Excel practice activities
 Using the instructions for "Projected Budget for Eagle Lake Camp," create a spreadsheet and appropriate chart
 Have Mrs. Callow check when complete
Due:
 Finish Excel spreadsheet additional practice Project 9E & 9G from GO! 2007 (review of learning targets for this week) OR
 Attempt an Office Certification Exam
Due:
 Open Excel Intro Activity from yesterday
 Apply formatting & insert a chart following verbal instructions and demo
 Next students will complete Project 9E from GO! 2007 textbook
Due:
 Open Excel Intro activity from yesterday
 Create basic formulas and format worksheet, rename sheet & delete unused sheets
Due:
 After an overview, students will complete the intro activity "Rio Rancho Auto Gallery"
Due:
 Hand back Word Lessons 5 & 6 Assessment
 Go over any certification exam questions/demo skills
 Students choose to review MS Word objectives for certification OR
 an independent project
Due:
Assignment:
 Word Certification Exam
 Review Word Lessons OR Keyboarding practice
Due:
 Word Lessons 56 AssessmentMonster Mash Flyer
Due:
 Go over Word Lesson 4 Assessment
 Share "Drink Can Design" project from Friday
 "Did You Know" activity
Due:
 Drink Can Design Project
Due:
 Word Lesson 6, pp. 187201
 Drink Can Design Activity
Due:
 Word Lesson 5, pp. 139159
 Choice: Continue working independently if you have already started Lesson 5 OR
 follow along with class activity
Due:
Word Lesson 4 Assessment
Due:
 Lesson 4, pp. 122137 (4 "Learn the Skill" exercises)
Due:
 Word Lesson 4, pp. 103119 (4 "Learn the Skill" exercises)
Due:
Due:
 Finish Lessons 13 Assessment
 Review for PowerPoint Certification Exam retake OR
 Continue with Word Lessons
Due:
 Click on the files below to download the documents for this assessment
Due:
 Continue working independently or as a whole class pp. 81101
 Complete "Learn the Skill," pp. 9192
Due:
 Word Lesson 3, pp. 69102working independently or using practice story
Due:
 Review Word window/discuss using Lesson 1 as a resource
 Open story from yesterday to use as our practice document
 Complete the exercises pp. 4547; pp. 4951; 5658 (using practice document)
Due:
 Discuss exam scores from yesterday
 Create story
Due:
 Log in to your computer
 Open the "Console 8" icon
 Click "yes" on first pop up dialog box
 Log in with your Certiport data
 Click through steps until exam opens
 Proctor username = columbiahs
 Proctor password = password
Due:
Due:
 Student presentations
 Keyboarding Activity
Due:
Due:
 Final presentations need to be emailed by the end of class today
 Presentations begin on Monday
Due:
 Opening Activity: Watch a short presentation videodo's and don'ts
 Practice Presentations in small groups (34 per group)
Due:
 Go over presentation rubric
 Prepare Speaking Notes
 PowerPoint Lesson 7, pp. 209235
Due:
 PowerPoint Assessment #2 due today
 When finished, continue with Lesson 7, pp. 209235 (9 "Learn the Skill" exercises
Due:
 Using Homecoming Presentationpractice adding transitions and animations
Due:
 Opening Activity: Go over Certification Exam results & how to use for studying
 Hand back PowerPoint Assessent #1 Rubrics/discuss
 Show examples of effective presentations
 Show prior student presentations to demonstrate internal & external hyperlinks
 Practice above skills using "Homecoming" presentation
Due:
 PowerPoint Certification exam if unable to take yesterday
 Others will continue working on PowerPoint Lesson 5, pp. 144182
Due:
Due:
Due:
 Create a Certiport & Microsoft testing account
 Practice learned skills using Homecoming presentation
 MicroType
Due:
 PowerPoint Lesson 4, pp. 114122practice using Homecoming presentation
Due:
 PowerPoint Assessment #1
Due:
 Finish PowerPoint Lesson 3 skills from Friday
 PowerPoint Assessment #1begin
Due:
 Go over Student Work Record
 Review Homecoming presentation skills from Lesson 2
 Apply skills taught in Lesson 3 to our Homecoming presentation
Due:
 Answer questions on p. 72 (see Lesson 2 pp. 4371 for answers
 Turn in when completed
 Practice keyboarding skills using MicroType
Due:
Use technology to enhance oral presentations & Work Ethic
 Continue with Lesson 2, pp. 4672 either working independently and completing all the "Learn the Skill" exercises or
 following along with class Homecoming presentation
Due:
Assignment:
 Opening Activity: Review Lesson 1 using p. 42ask students what they need to know from the Lesson Summary and demonstrate
 Lesson 2, pp. 4372
 Students can complete Lesson 2 independently by completing all the "Learn the Skill" exercises or
 follow teacher demonstration using "Homecoming" presentation
Due:
 Introduce MicroType ProgramAfter creating account, edit spacing preferences and take 1st timing assessment.
 Then choose either keyboard review or practice option
 I will copy the files you'll need for PowerPoint and Word while you practice your keyboarding
 Create folders for Computer Apps
 Overview of PowerPointOpen the PowerPoint program and in the search bar type "Welcome to PowerPoint (Take a Tour) presentation and review independently to become familiar with some of the PowerPoint features.
 Next we will open our PDF textbooks and discuss layout and uses. Scroll to page 16 where we will begin.
Due:
 Introduce Website
 Course outline
 IT Academy & certifications
 Student Activity
 MicroType