Syllabus: Administrative Technologies II
Illustrated Microsoft Office 365 & Office 2019 Intermediate
Instructor: Mrs. Polynice
Office:n/a
Phone:201-553-4110 x 57312
E-mail:[email protected]
Website:https://app.oncoursesystems.com/school/webpage/382580/509868
Course Description:
As a student in this course, you will learn the most important topics of Microsoft Office 2019. Introductory Computer Applications (year 1) experience is assumed. You will start with Word, followed by Excel, then Access and PowerPoint. On the way you’ll have Modules integrating all four applications together. You’ll wrap up the course by passing a Microsoft Office Specialist Certification in all 4 applications (if you pass each exam) and passing the year according to MHS grade requirements.
Text/Materials:
Text: Beskeen/Cram/Duffy/Friedrichsen/Wermers, Illustrated Microsoft Office 365 & Office 2019 Intermediate
Software: Microsoft Office 2019.
Teaching Methods:
1. Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured outside material relevant to topics being covered.
2. Assignments: End of chapter activities and online activities will be assigned weekly to reinforce material in the text. These assignments may require the application of various software packages.
3. Quizzes: Occasional unannounced quizzes will be given to help ensure students stay up with assigned material.
4. Exams: Four exams will be given. The exams will be closed book/notes and will test assigned readings and material discussed in class. Review sheets will be provided prior to the exam day. The final exam will not be comprehensive in nature. However, the instructor reserves the right to retest on material that was not appropriately comprehended. These items will be noted on exam review sheets.
5. Participation: Student participation will be graded by the level of class participation and attendance.
Grading:
Total points will be based on:
Exams, quizzes, projects, MOS certification scores, and homework
Missed work will be listed as ABS (=0) until work is submitted within the 3 day alloted time frame.
Special circumstances are accepted and discussed with involved parties
NJCU College Credit:
In order to receive NJCU credit you must enroll as a NJCU student (see teacher) and
- pay $350 directly to NJCU
- have a passing grade of B+ or higher
- pass Word and Excel MOS certifications
- complete an eight hour course at NJCU on a Bloomberg Terminal (these are school-led field trips).
Course Policies:
Missed Classes: The student is responsible for obtaining material distributed on class days when he/she was absent. This can be done through Google Classroom. Students have 3 days to submit missed work. After that a zero will stay on your assignment.
Assignments: All assignments are due at the beginning of class on the date due. Work will not be accepted Late.
Academic Dishonesty: For more information refer to the Plagiarism" policy in the student handbook, page 78.
Need for Assistance: If you have any condition, such as a physical or learning disability, please see page 74 in your student handbook. All IEP and 504's are followed as stated in each student's plan.
Posting of Grades: Students can see all of their grades on the Parent Portal.
Incomplete Policy: See Cuts and attendance policies for more information for loss of credit (pages 60-65)
Course Outline
Assignment Descriptions:
- Concepts Review – Includes screen identification, multiple choice, and matching questions.
- Skills Review – Provides additional hands-on exercises that mirror the progressive style of the lesson material.
- Independent Challenges 1, 2 and 3 – Case projects that require critical thinking and application of the Module skills. The Independent Challenges increase in difficulty, with the first being the easiest (with the most step-by-step detailed instructions). Independent Challenges 2 and 3 become increasingly more open-ended
- Real Life Independent Challenge – Using a real world focus to apply the Module skills, students create documents that will benefit their every day lives
- Advanced Challenge Exercises – Optional steps that are set within 2 of the 4 Independent Challenges for each Module. They are designed to challenge more advanced students. 2 solution files are provided for easy grading.
- Visual Workshop – a practical, self-graded capstone project that requires independent problem solving.
- Capstone Projects - 10 projects that you can use to test your students’ knowledge of the applications. Use these projects as homework, pop quizzes or practice for the final exam. They can be integrated in between each application or after you finish the book.
|
Week |
Topic |
Assignment |
|
1 |
Word 2019 Module 5: Creating and Formatting Tables |
none |
|
|
Word 2019 Module 6: Illustrating Documents and Graphics |
Concepts Review |
|
2 |
Word 2019 Module 7: Working with Themes and Building Blocks |
Skills Review
|
|
|
Word 2019 Module 8: Merging Word Documents |
2 Independent Challenges |
|
3 |
Excel 2019 Module 5: Analyzing Data Using Formulas |
Internet Visual Workshop
Office Independent Challenge #1 |
|
|
Excel 2019 Module 6: Managing Workbook Data |
Concepts Review |
|
4 |
Excel 2019 Module 7: Using Tables |
Skills Review |
|
|
Excel 2019 Module 8: Analyzing Table Data |
2 Independent Challenges |
|
5 |
Integration Module 4: Integrating Word and Excel |
Visual Workshop |
|
|
Exam #1 |
None |
|
6 |
Access 2019 Module 5: Modifying the Database Structure |
Concepts Review |
|
|
Access 2019 Module 6: Improving Queries |
Skills Review |
|
7 |
Access 2019 Module 7: Enhancing Forms |
2 Independent Challenges |
|
|
Access 2019 Module 8: Analyzing Data with Reports |
Excel Visual Workshop Integration Visual Workshop |
|
8 |
Integration Module 5: Integrating Word, Excel, and Access |
Skills Review |
|
|
Exam #2 |
None |
|
9 |
PowerPoint 2019 Module 5: Working with Advanced Tools and Masters (part 1) |
Concepts Review |
|
|
PowerPoint 2019 Module 5: Working with Advanced Tools and Masters (part 2) |
2 Independent Challenges |
|
10 |
PowerPoint 2019 Module 6: Enhancing Charts (part 1) |
Visual Workshop |
|
|
PowerPoint 2019 Module 6: Enhancing Charts (part 2) |
Concepts Review |
|
11 |
Exam #3 |
None |
|
|
PowerPoint 2019 Module 7: Inserting Graphics, Media and Objects (part 1 of 3) |
Skills Review |
|
12 |
PowerPoint 2019 Module 7: Inserting Graphics, Media and Objects (part 2 of 3) |
2 Independent Challenges |
|
|
PowerPoint 2019 Module 7: Inserting Graphics, Media, and Objects (part 3 of 3) |
Visual Workshop |
|
13 |
PowerPoint 2019 Module 8: Using Advanced Features (part 1) |
Concepts Review |
|
|
PowerPoint 2019 Module 8: Using Advanced Features (part 2) |
Skills Review |
|
14 |
Integration Module 6: Integrating Word, Excel, Access, and PowerPoint |
2 Independent Challenges |
|
|
Review |
none |
|
15 |
Final Exam |
none |