CTS Module INF 1050

Computers 20/30 Alphanumeric Code and Title

Introductory
CTS Level
INF 1050 Introductory, Intermediate, Advanced

Teacher Name: Miss Peters Duration

Total Instructional Hours Allotted
7 classes

Lesson # 1 Create and structure flat-file databases (assignment 1)

Outcome(s) 1.1, 1.2, 1.3, 1.4, 1.5
Assessment Evidence(s)
Purpose Summative
Device Do
Criteria Checklist
Students ability to complete task by the end of class via direct instruction
Learning Activity(s) Direct instruction on:
Creating databases using a predefined template
Defining data needs and types by planning a database and identifying the key features
needed for later entry
Creating a blank database
Defining and creating a primary key
Using help functions and references as appropriate
Start assignment 1

Lesson # 2 Create and structure flat-file databases (assignment 1)

Outcome(s) 1.1, 1.2, 1.3, 1.4, 1.5
Assessment Evidence(s)
Purpose Summative
Device Do
Criteria Assignment
Students ability to complete task by the end of class
Learning Activity(s) Work on assignment 1 (based on material learned last class)

Lesson # 3 Create and format database elements (assignment 2)

Outcome(s) 2.1, 2.2, 2.3, 2.4, 2.4, 2.6, 2.7
Assessment Evidence(s)
Purpose Formative
Device Do
Criteria Checklist
Students ability to complete task by the end of class via direct instruction
Learning Activity(s) Direct instruction on:
Identifying the key features of a database system needed to create a simple table
Creating and modifying tables
Creating fields and modifying field properties using different methods of editing; e.g., design
view, datasheet view, wizards
Creating forms from the fields identified
Modifying the form layout
Creating reports to meet different audiences
Modifying the report layout and page setup for presentation and printing
Start working on assignment 2

Lesson # 4 Create and format database elements (assignment 2)

Outcome(s) 2.1, 2.2, 2.3, 2.4, 2.4, 2.6, 2.7
Assessment Evidence(s)
Purpose Summative
 Device Do
Criteria Assignment
Students ability to complete task by the end of class
Learning Activity(s) Work on assignment 2 (based on material learned last class)

Lesson # 5 Enter and modify data (assignment 3)

Outcome(s) 3.1, 3.2, 3.3, 3.4, 3.5
Assessment Evidence(s)
Purpose Formative
Device Do
Criteria Assignment
Students ability to complete task by the end of class via direct instruction
Learning Activity(s) Direct instruction on:
Entering, editing and deleting records
Navigating among records and fields
Finding and replacing data
Importing data from other sources; e.g., spreadsheets
Accessing data and defining problems; e.g., manage information, make decisions
Start working on assignment 3

Lesson # 6 Enter and modify data (assignment 3)

Outcome(s) 3.1, 3.2, 3.3, 3.4, 3.5
Assessment Evidence(s)
Purpose Summative
Device Do
Criteria Assignment
Students ability to complete task by the end of class
Learning Activity(s) Working on assignment 3 (based on material learned last class)

Lesson # 7 Present and share data (assignment 4)

Outcome(s) 4.1, 4.2, 4.3, 4.4, 4.5, 4.6, 4.7, 4.8
Assessment Evidence(s)
Purpose Formative
Device Do
Criteria Assignment
Students ability to complete task by the end of class via direct instruction
Learning Activity(s) Direct instruction on:
Creating and modify queries
Sorting data in a variety of elements; e.g., tables, forms, queries
How to filter data
How to export data
Splitting databases
Saving database objects as other file types
Printing database objects, including reports and queries
Backing up a database
Start working on assignment 4

Lesson # 8 Present and share data (assignment 4)

Outcome(s) 4.1, 4.2, 4.3, 4.4, 4.5, 4.6, 4.7, 4.8
Assessment Evidence(s)
Purpose Summative
Device Do
Criteria Assignment
 Students ability to complete task by the end of class
Learning Activity(s) Work on assignment 4 (based on material learned last class)

Lesson # 9 Apply consistent and appropriate workstation routines

Demonstrate basic competencies
Make personal connections to the cluster content and processes to inform possible pathway
choices
Outcome(s) 5.1, 5.2, 6.1, 6.2, 6.3, 7.1, 7.2
Assessment Evidence(s)
Purpose Formative
Device Do
Criteria Checklist
Ongoing formative assessments