Course Syllabus Software Applications and Design B
Instructor: Richard W. Smith Email:Richard_W_Smith@mcpsmd.org
Phone 240-497-6348
Software Applications by Design B – Grades 9-12
Prerequisite: Attainment of the outcomes of Software Applications
by Design A
2904 # ½ credit
Learning Outcomes: Students design and complete authentic databases as they continue to use software applications in a project-based environment. Students then learn how to post these presentations on the Internet and use their speaking skills to share their presentations with the class. Development of simple web pages using an editor will be included. Students may elect to take the Microsoft Office Specialist (MOS) certification core-level examinations for Microsoft Access and Microsoft PowerPoint at the conclusion of this course.
Description: The primary software will be Microsoft Office 2000 Access (third quarter) and Power Point (fourth quarter). Our study of databases (Access2000) includes collecting information and organizing the data to make finding specific data easy. We will study Tables, Forms, Queries and Reports. A major third quarter project will require collecting data, placing it into a database, analyzing data and presenting the results in a meaningful manner. Our study of presentation software (PowerPoint 2000) will include designing and creating professional-quality slide presentations. We will apply skills from Word, Excel and graphic manipulation to create the presentations. All students will do a group PowerPoint presentation for the final exam.
Students can use the media center after school until 3:30 and the cyber café until 4:00 to complete work out side of class. Also the labs will be open for one-half hour after school except Mondays for help and makeup. All missed quizzes must be made up at lunch or after school. All students will take a pre and post-test based on MOS objectives. The MOS test enables one to be certified by Microsoft.
Evaluation: The following B–CC policies are consistent with the new MCPS Grading and Reporting Policy as outlined in Learning, Grading and Reporting Guidelines (MCPS, 2004). These will apply in all courses offered at B–CC.
l Teachers will assign grades to reflect individual achievement on course objectives.
l Teachers will determine grades based on a variety of assessment methods.
l Teachers will issue progress reports at the 4½-week mark in each quarter.
l Teachers will establish clear due dates and deadlines. The maximum penalty for work submitted after the due date but before the deadline is one letter grade on an A-E scale or 10% on a 100% scale.
l Teachers will record 50% as the lowest possible grade if percentages are used except in cases of academic dishonesty.
This applies to both written work and oral presentations. Examples of academic dishonesty include, but are not limited to, the following: the willful giving or receiving of an unauthorized text, unfair, dishonest, or unscrupulous advantage in academic work over other students using fraud, duress, deception, theft, trickery, talking, signs, gestures, copying, or any other methodology.
Plagiarism:
· Submitting or presenting another person's work as your own without proper documentation, including downloaded information from the Internet and lab data.
· Using another student's material without prior approval.
Cheating:
· Giving or receiving information during a test, quiz, and/or class work assignment without teacher authorization.
· Using hand signals, gestures, and the like during tests or quizzes to obtain/give information.
· Using unauthorized materials during a test or quiz.
Class assignments, from the text, must be completed with the student following all directions. Notes will be taken and graded on each lesson. Students that don’t get a C or better on the open note quizzes will have points deducted from the note grade. Each lesson will count 46 points (notes 10 points, book assignments: White pages 5 points, Skills Review 10 points, Lesson Applications 3 points, objective list 3 points and Quiz 15 points). Also special projects will be included in the grade. Homework will be very limited. All points accumulated will carry the same weight. Grading Scale: A 90-100; B 80-89; C 70-79, D 60-69
Topical/Time Outline
Software Applications and Design B
|
1/23 |
- |
1/27 |
Access Lesson 3 Finding Data, Sorting Records, and Using Filters |
|
1/30 |
- |
2/3 |
Access Lesson 4 Adding Tables to a Database |
|
2/6 |
- |
2/10 |
Access Lesson 5 Adding forms to a Database Choose project 5% |
|
2/13 |
- |
2/17 |
Access Lesson 6 Adding Reports to a Database Have data for project 10% |
|
2/20 |
- |
2/24 |
Access Lesson 7 Adding Queries to a Database Have data for project entered 10% |
|
2/27 |
- |
3/3 |
Access Lesson 8 Using Joins and Relationships |
|
3/6 |
- |
3/10 |
Access Lesson 9 designing Advanced Queries |
|
3/13 |
- |
3/17 |
Access Lesson 10,11 Additional Report Features |
|
3/20 |
- |
3/24 |
Project |
|
3/27 |
- |
3/31 |
PowerPoint Lessons 3-4 white pages only |
|
4/3 |
- |
4/7 |
PowerPoint Lesson 6 PowerPoint Objects |
|
4/10 |
- |
4/14 |
Spring Break |
|
4/17 |
- |
4/21 |
PowerPoint Lesson 7 Lines, Fills and Colors |
|
4/24 |
- |
4/28 |
PowerPoint Lesson 8 Manipulating PowerPoint Objects |
|
5/1 |
- |
5/5 |
PowerPoint Lesson 10 Advanced Drawing Techniques |
|
5/8 |
- |
5/12 |
PowerPoint Lesson 11 Animation and Slide Show Effects |
|
5/15 |
- |
5/19 |
PowerPoint Lesson 12 Creating a Chart in PowerPoint |
|
5/22 |
- |
5/26 |
PowerPoint Lesson 13 Creating a Table |
|
5/29 |
- |
6/2 |
PowerPoint Lesson 14 Flowcharts & Organization Charts |
|
6/5 |
- |
6/9 |
Review &Exams |
|
6/12 |
|
6/16 |
Exams |