Adult Technology Education Curriculum Outline

Week 1 – Computer Basics

This course will focus on the basics of operating the Microsoft Windows XP Operating System. By the end of the course, students will be comfortable creating files and directories, organizing in a structure that is comfortable and intuitive for them. Here is an overview of what we will cover:

1. Day 1 : Discovering Computers and Windows Basics : This course will cover operating a mouse, keyboard and learn how to browse the start menu and browse for software on the computer. Students will learn how to do the following:
   

1. Basic typing overview

2. Understand how the file system works

3. Create a text file inside “My Documents”

4. Browse the start menu and find the programs that they are looking for 2. Day 2: System Maintenance: This course will cover basic operating system maintenance: Students will learn how to do the following
   

a. Run the disk scan tool

b. Understand the disk defragmenter and running it

3. Understand spyware and running the spyware scan
   

3. Day 3: Browsing the Internet : This course will cover how to browse the Internet using Internet Explorer. Students will learn how to do the following:

1. Use the address bar to manually type in an internet address

2. Use bookmarks and save their favorite website
   

3. Day 4: Discovering Outlook: Students will learn to use the basics of Outlook:

   1. Setting up email accounts

   2. Sending and receiving emails

   3. Sending files and pictures through email

   4. Setting up a contact list and calender

3. Day 5: Wrap up project: This course will guide students through the daily tasks that are performed in an office environment. This wrap-up project combines the abilities above.
   

Week 2 – Office Administration

This course will focus on students learning how to operate basic office tasks such as running Microsoft Office Suite (XP/2003). After completion, students will feel comfortable in a typical office setting in various positions: Office Administrator, Administrative Assistant, HR positions and many other types of clerical positions. The following things will be covered:

Microsoft Word

1. Day 1 : Discovering Microsoft Word : This course will cover basic functions of word:

   1. Creating and saving a new document

   2. Understanding and utilizing the toolbar to format and manipulate fonts and paragraphs

   3. Printing the document

2. Day 2 : Basic Word : In this course students will learn how to:

   1. Use paragraph formatting tools such as indenting and spacing

   2. Use page layout with margins and page setup

   3. Use spell-check and wordcount tools

3. Day 3 : Mastering Word : In this course students will learn how to:

   1. Create and manipulate tables

   2. Use basic macros

   3. Import data from excel

   4. Create and format a report

4. Day 4 : Basic Web Design : In this course students will take an existing report in word, save it as a web page, preview it in the browser, and learn how to :

   1. Format a word document for the web

   2. Publish the webpage and view it in the browser
      

5. Day 5 : Basic Office Skills : In this course students will learn how to:

   1. Create a template

   2. Create an unordered and ordered list

   3. Build an outline to hand out to employees

Week 3 – Microsoft Excel

1. Day 1 : Discovering Microsoft Excel : This course will cover basic functions for excel:
   

1. Understanding rows and columns

2. Cell formatting

3. Basic calculations

4. Understanding the toolbar

2. Day 2 : Basic Excel: Students will learn how to:
   

1. Create reports

2. Create formulas

3. Create simple graphs
   

3. Day 3 : Mastering Excel I: Students will learn how to:

1. Intermediate formulas

2. Import data

3. Analyze and review data

4. Day 4 : Mastering Excel II : Students will learn how to:
   

1. Aggregate data

2. Research external sources for data and import it into excel

5. Day 5 : Putting it all together : Students will take all their completed projects and put them together into a full worksheet. This wrap-up project worksheet will go over the following things:

1. Advanced formulas

2. Creating a template

3. Bar graphs

Week 4 – Microsoft Access

1. Day 1 : Discovering Microsoft Access : This course will introduce students to the basic concepts of databases and their common uses.
   

1. Understanding Data types

2. Creating tables

3. Sorting and formatting tables

4. Understanding rows and columns in databases

2. Day 2 : Basic Access : Students will learn how to:
   

1. Create a database based on a real life model

2. Learn how to create basic queries

3. How to output a table to a report
   

3. Day 3 : Data Manipulation with Access : Students will learn how to:

1. Put together queries based on human questions

2. Create “conditions” in queries

3. Learn how to output a query to a report

4. Day 4 : Forms in Access : Students will learn how to:
   

1. Create a data entry form based on a table

2. Work with and understand form elements

3. Create a splash page
   

5. Day 5 : Putting it all together : Students will take all their completed assignments through the week and create an access program that can be used in a restaurant for managing recipes. In this final project they will learn the following things:
   

1. How to create a splash page

2. How to tie in reports to a form

3. How to build an interface

Week 5 – Microsoft PowerPoint

1. Day 1 : Discovering Microsoft PowerPoint : This course will introduce students the basic concepts of putting together presentations in PowerPoint. The will be introduced to the following things:

1. Slides

2. Drawing tools

3. Fonts and typography

4. Shape tools

2. Day 2 : Basic PowerPoint : Students will learn how to:

   1. Create a basic slideshow based on a template

   2. Use basic graphic effects

   3. Import images for other programs

   4. Apply a background image or color

   Day 3 : Intermediate PowerPoint : Students will learn how to:

   1. Add in a chart from excel

   2. Add in links from a website

   3. Play and review their slideshow

4. Day 4 : Advanced PowerPoint : Students will learn how to :

   1. Insert in a table

   2. Add in sound to their presentation

   3. Make their presentation

5. Day 5 : Putting it all together : Students will compile all their assignments from previous days and create a full blown presentation

1. Creating slide notes

2. Change the color scheme/theme of presentation

3. Copy all assignment to a CD/Create a digital portfolio on a CD

4. Receive Certificates of completion for the classes
   
   

1. Day 4: Integration: Students will learn how to:

   1. Import results from the previous excel assignments

   2. Import results from the previous access assignments

   3. Format the data in PowerPoint and prep it for their presentation

• Programs
• Community Award
• Board of Commision