Jefferson-Morgan Middle/High School

Skip to main content

Advanced Computer Applications

Course Description

This comprehensive course provides students with advanced concepts in word processing, spreadsheet, presentation and database applications by utilizing the Microsoft Office Suite. The instruction in this class provides students the skills needed to become a Microsoft Office Specialist at the Expert level for Word and Excel; Specialist level for Access and PowerPoint.

To take this course, students must have successfully completed Computer Applications with a grade of C or better.
 
Date Objective/Standard Description of Lesson Assignment/HW
1/22   - Students wrote a 150 word paper introducing themselves  
1/23  
- Went over syllabus
- Students sent a test email
- Students downloaded two files needed for Unit E Word
- Signed syllabus due 1/29
1/24
- Insert a table
- Insert and delete rows and columns
- Modify rows and columns
- Sort table data
- Split and merge cells
- Perform calculations in tables
- Apply a table style
- Customize a table format
- As a class, we worked on Unit E Word pages 106-111 in class together
- Students emailed the practice to the teacher to grade
1/25
- Same as 1/24
- As a class, we worked on Unit E Word pages 112-117 in class together - Students emailed the practice to the teacher to grade
1/26   - Study hall  
1/29 - Same as 1/24 - As a class, we worked on Unit E Word pages 118-121 in class together - Signed syllabus due today!
1/30 - Same as 1/24 - Students worked on their graded projects - Skills Review, Independent Challenge 1, Visual Workshop
- Grade projects due Friday
- Test Monday
1/31 - Same as 1/24 - Students worked on their graded projects - Skills Review, Independent Challenge 1, Visual Workshop
- Graded projects due Friday
- Test Monday
2/1 - Same as 1/24  - Students worked on their graded projects - Skills Review, Independent Challenge 1, Visual Workshop
- Graded projects due Friday
- Test Monday
2/2 - Same as 1/24 - Students worked on their graded projects - Skills Review, Independent Challenge 1, Visual Workshop
- Graded projects due today
- Test Monday
2/5 - Same as 1/24 - Because of the delay, students had the opportunity to fix their errors on their graded projects for full credit
- Test moved until Tuesday
2/6 - Same as 1/24 - Unit E Word test today  
2/7   NO SCHOOL  
2/8   - Went over the Unit E Word test together in class  
2/9
- Insert a graphic
- Size and scale a graphic
- Position a graphic
- Create a text box
- Create WordArt
- Draw shapes
- Create a chart
- Finalize page layout
- As a class, we worked on Unit F Word practice, pages 130-135 today
 
2/12  
- Catchup day (delay)
 
2/13  
- Study Hall
 
2/14 - Same as 2/9 - As a class, we worked on Unit F Word practice, pages 136-141 today  
2/15 - Same as 2/9 - As a class, we worked on Unit F Word practice, pages 142-145 today  
2/16 - Same as 2/9 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop for Unit F Word
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Test Wednesday
 2/19 - Same as 2/9  - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop for Unit F Word - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
2/20 - Same as 2/9  - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop for Unit F Word - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
2/21 - Same as 2/9  - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop for Unit F Word - Skills Review, Independent Challenge 1, and Visual Workshop due today
2/22 - Same as 2/9 - Review for test with study guide - Unit F Word test tomorrow
2/23 - Same as 2/9 - Unit F Word Test  
2/26 - Same as 2/9
- Went over Unit F Word Test in class
- Students downloaded files for Unit G Word
 
2/27  
- As a class , we worked on pages 154-159 as practice for Unit G Word
 
2/28
 - Apply styles to text
- Apply a theme
- Customize a theme
- Insert a sidebar
- Insert Quick Parts
- Add a cover page
- Create building blocks
- Insert building blocks
- Catchup day (because over half of the class was missing)
 
3/1
- Same as above
- As a class, we worked on pages 160-163 as practice for Unit G Word
 
3/2
- Same as above
- Catchup day (because over half of the class was missing)
 
3/5
- Same as above
- Students typed or wrote out their vocabulary words for Unit G to help them study for the upcoming test
 
3/6 - Same as above
- As a class, we worked on pages 164-169 as practice for Unit G Word
 
3/7 - Same as above
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Unit G Word graded projects due Friday
- Test Monday
3/8 - Same as above
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Unit G Word graded projects due Tuesday (I forgot about the day off)
- Test Wednesday
3/12 - Same as above
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Unit G Word graded projects due Tuesday (I forgot about the day off)
- Review for test 
- Test Thursday
3/13 - Same as above
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Unit G Word graded projects due Tuesday
- Review for test 
- Test Thursday
3/14 - Same as above
- Students reviewed for the test tomorrow (with the study guide I gave them)
- Test tomorrow
3/15 - Same as above
- Test today 
 
3/16 - Same as above
- We went over the test in class and then students downloaded the files needed for Unit H word
 
3/19  
- Study hall because missing 1/3 of the class due to Blood Drive
 
3/20
 - Understand mail merge
- Create a main document
- Design a data source
- Enter and edit records
- Add merge fields
- Merge data
- Create labels
- Sort and filter records
 
- As a class, we worked on pages in Unit H word as practice
 
3/21   - Snow day  
3/22  - Same as 3/20 - Catchup day  
3/26 - Same as 3/20 - As a class, we worked on pages in Unit H word as practice  
3/27 - Same as 3/20  - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Graded projects due Tuesday
- Test Wednesday next week
3/28  - Same as 3/20  - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class  
- Graded projects due Tuesday
- Test Wednesday next week
3/29  - Same as 3/20  - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Graded projects due Tuesday
- Test Wednesday next week
4/3   - Same as 3/20  - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class 
- Graded projects due tomorrow
- Test Thursday
 
4/4 - Same as 3/20  - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class 
- Graded projects due today
- Test tomorrow
4/5 - Same as 3/20 - Test today on Unit H Word  
4/6 - Same as 3/20 - Go over test in class  
4/9   - Catchup day  
4/10   - Computer issues  
4/11   - Computer issues  
4/12   - Computer issues  
4/13   - Computer issues  
4/16   - Computer issues - MOS Test after school on April 18
4/17   - Work on in class review for MOS Word Test - MOS Test after school on April 18
4/18  
- Finish in class review for MOS Word Test
- MOS Test today afterschool at CM
- MOS Test after school today
4/19   - Study hall because over half of the class was missing  
4/20   - Download files for Unit E Powerpoint  
4/23
- Draw and format connectors
- Use advanced formatting tools
- Customize animation effects
- Create custom slide layouts
- Format master text
- Change master text indents
- Adjust text objects
- Use templates and add comments
- Worked on Unit E PowerPoint pages 98-99 today in class  
4/24 - Same as 4/23  - Worked on Unit E PowerPoint pages 100- 105 today in class  
4/25   - Catchup day  
4/26 - Same as 4/23 - Worked on Unit E PowerPoint pages 106-113  
4/27 - Same as 4/23 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Test Wednesday
4/30 - Same as 4/23 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Test Wednesday
5/1 - Same as 4/23 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Test Wednesday
5/2 - Same as 4/23 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Test Wednesday
5/3  - Same as 4/23 Test today  
5/4   - We backpacked as a class today  
5/7   - Reviewed the Unit E PowerPoint Test in class and downloaded files needed for Unit F PowerPoint  
5/8   - Students downloaded files and receive packets for Unit F PowerPoint  
5/9
- Work with charts in PowerPoint
- Change chart design and style
- Customize a chart
- Format chart elements
- Animate a chart
- Embed an Excel shart
- Link an Excel worksheet
- Update a linked Excel worksheet
- Worked on Unit F PowerPoint practice in class pages 122-129  
5/10 - Same as 5/9 - Over half of the class was missing, so study hall  
5/11 - Same as 5/9 - Worked on Unit F PowerPoint practice in class pages 130-131  
5/14 - Same as 5/9 - Catchup day  
5/15 - Same as 5/9 - Student finished the Unit F PowerPoint practice on their own and emailed to the teacher
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
5/16 - Same as 5/9 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
5/17 - Same as 5/9 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop (missing over half of class because of Keystone testing)
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
5/18 - Same as 5/9 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop (missing over half of class because of Keystone testing)
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
5/21 - Same as 5/9 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop (missing over half of class because of Keystone testing)
- Skills Review, Independent Challenge 1, and Visual Workshop due Thursday
5/22 - Same as 5/9 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop (missing over half of class because of Keystone testing)
- Skills Review, Independent Challenge 1, and Visual Workshop due Thursday