CURRICULUM MAP: 10266.map

Advanced Computer Applications (SCP) 615
Unit--Access

TIME FRAME: 8 Weeks
GRADE: 9-12
CONTACT:

         MAP LEVEL: 2
12.0 BUSINESS EDUCATION

12.0.8.9.8 -- Students will use, plan, develop, and maintain database management systems.

12.0.8.9.10 -- Students will analyze and design information systems using appropriate development tools.

12.0.8.9.5 -- Students will identify, evaluate, select, install, use, upgrade, and customize application software; diagnose and solve problems resulting from an application software’s installation and use.

12.0.8.9.6 -- Students will use input technologies appropriately to enter and manipulate text and data.

04.2 LRIT - COMPUTER TECHNOLOGY

04.2.1.9.2 -- Students will produce a variety of products using the advanced features of personal productivity software

04.2.3.9.1 -- Students will use technology tools and resources for managing and communicating personal/professional information

04.2.5.9.7 -- Students will demonstrate the ability to solve problems by collecting, analyzing and interpreting data through the use of data management software (databases, spreadsheets, etc.)

04.2.5.9.9 -- Students will use technology tools to generate findings and organize results for presentation

04.2.3.9.3 -- Students will create written, oral, numeric and visual communications using appropriate applications (spreadsheet, database, hypermedia, etc.) to construct, organize, and analyze and interpret ideas and data, and present conclusion



1. How do you choose and apply effective Access features for increased productivity?
2. How do you input technologies appropriately and accurately to enter and manipulate data?



1. Access basics.
2. Manipulating data.
3. Creating and modifying forms.
4. Finding and ordering data.
5. Reports and macros.
6. Integrating Access with other Microsoft applications.




Students will be able to:
1. Create a database, and enter records.
2. Edit/select records/fields in Datasheet view, cut/copy/paste data, change datasheet layout, change field properties.
3. Create/modify forms, compact/repair a database.
4. Use techniques to search for data and order records.
5. Create/modify reports and use macros.
6. Integrate Access with other Office programs.
7. Find ways to help prevent data entry errors.
8. Create relationships in tables and queries.



1. Students will realize that knowledge and mastery of specific hardware or software skills are not the end goals of information technology courses.
2. Students will develop the ability to analyze, synthesize, and evaluate situations at home, school, or work and then apply technology to solve problems and complete tasks effectively and efficiently.

(National Standards for Business Education, 2001)



1. Computers and printers.
2. Teacher-led/student-created step-by-step activities w/computer LCD projector
3. Textbook projects.
4. Critical thinking activities.
5. Sam and Tom (on-line tutorial and test).




1. Templates (student data files).
2. Textbook/workbooks.
3. On-line/networked tutorial and testing.
4. Teacher-created projects.




Students may opt to test into this course to fulfill the technology graduation requirement in place of Foundations of Technology.