DTE Course Learning Objectives

Judicial College of MarylandDepartment of Technology EducationDTE Course Learning ObjectivesThe purpose of identifying DTE learning objectives is to ensure that they are measurable, appropriateforthe content, and consistent across all communications.Areas in which objectives display  Class descriptions on CourtNet  Class manuals  Intro presentations  CONNECT  Course Description and Schedule paper catalog

CoursesAccess Level 1 ....................................................................................................................................1Access Level 2 ....................................................................................................................................1Adobe Acrobat Level 1........................................................................................................................1Computer 101 ....................................................................................................................................1CONNECT Employee Essentials............................................................................................................1CONNECT Employee Time and Absence ...............................................................................................2CONNECT for Managers......................................................................................................................2eWarrant ...........................................................................................................................................2Excel Level 1.......................................................................................................................................2Excel Level 2.......................................................................................................................................3Excel Level 3.......................................................................................................................................3Maryland Electronic Courts (MDEC) New Employee Core Clerk and Manager Training............................3Maryland Electronic Courts (MDEC) New Judge Core Training ...............................................................3Maryland Electronic Courts (MDEC) Refresher: Peace and Protective Orders .........................................4Maryland Electronic Courts (MDEC) Refresher: Task Manager, Peace and Protective Orders, Reports .....4New Employee Technology Orientation (NETO)....................................................................................4Office 365 Overview ...........................................................................................................................4OneNote Overview .............................................................................................................................5Outlook 2013 Overview ......................................................................................................................5PowerPoint Level 1.............................................................................................................................5PowerPoint Level 2.............................................................................................................................5Publisher Level 1.................................................................................................................................5Revenue Collection System (RCS) – Accounting/Back Office ..................................................................6Revenue Collection System (RCS) – Cashier..........................................................................................6Revenue Collection System (RCS) – Supervisor .....................................................................................6SharePoint 2013 Overview ..................................................................................................................6Virtual Desktop Infrastructure (VDI).....................................................................................................7Word Level 1......................................................................................................................................7Word Level 2......................................................................................................................................7Word Level 3......................................................................................................................................7Word 2016 – Level 1...........................................................................................................................8Word 2016 – Level 2...........................................................................................................................8Word 2016 – Level 3...........................................................................................................................8PowerPoint 2016 – Level 1..................................................................................................................8PowerPoint 2016 – Level 2..................................................................................................................8

Outlook 2016 – Level 1........................................................................................................................9Outlook 2016 – Level 2........................................................................................................................9Excel 2016 – Level 1............................................................................................................................9Excel 2016 – Level 2............................................................................................................................9Excel 2016 – Level 3..........................................................................................................................10Access 2016 – Level 1........................................................................................................................10Access 2016 – Level 2........................................................................................................................10Publisher 2016 .................................................................................................................................10SharePoint 2016 – Site User ..............................................................................................................10

Access Level 1  Define the elements of a database  Create a basic database  Create and format tables  Work with tables and records  Create forms, reports, and queries  Manage a databaseAccess Level 2  Work with relationships and referential integrity  Use advanced table tasks  Manage data entry in tables  Create subforms and navigation forms  Create modal dialog boxes  Split a databaseAdobe Acrobat Level 1  Access PDF documents  Create and save PDF documents  Navigate content in a PDF document  Edit and modify PDF documents  Use reviewing tools in PDF documents  Convert PDF files to other softwareComputer 101  Use Windows Explorer to manage files and folders in Windows 7  Create and search folders; move, copy, and sort files  Utilize Libraries to keep files and folders organized  Describe basic Microsoft Word functions  Review remote storage systems, including flash drives, external , and network drives  Detail the basic concepts of computing in the Cloud  Describe safe computing guidelines  Identify online training resourcesCONNECT Employee Essentials  Navigate in CONNECT using Dashboards, Quick Links, and the Main Menu  View and update personal information  Complete HR forms like an ADA Accommodation Request and Grievance Form  Use the Company Directory  Enroll in a Judicial College class  Update and complete the Performance Appraisal document  Apply for an open Judiciary job posting

CONNECT Employee Time and Absence  Complete and submit a weekly timesheet  Record overtime, comp time, and other time categories  Submit a full day absence request  Submit a partial day request  Edit leave requests  Troubleshoot common errors  Request approval for an Extended Absence Request (FMLA)  Record FMLA time on the timesheetCONNECT for Managers  Use the Manager Dashboard  Complete reports in CONNECT  Manage employee’s information  Process timesheets and leave requests  Delegate in CONNECT  Participate in the recruitment process  Process requests for class enrollments  Complete the Annual Performance Appraisal processeWarrant  Access the ShareFile portal (account)  Use ShareFile account to send a link to the law enforcement official who is submitting the warrant for approval  Retrieve the electronic warrant  Access and utilize Adobe DC to review, edit, and save the warrant  Sign the warrant electronically  Use the eSign tool to send the signed warrant to the law enforcement official who initiated the process  Save the warrant in the location of choiceExcel Level 1  Navigate the Excel 2013 environment  Create and enter data in a workbook  Format and modify data in a worksheet  Use basic formulas and functions  Sort and filter data  Insert objects  Print and share an Excel Workbook DTE Course Learning Objectives | 2

Excel Level 2  Use advanced formulas with relative and absolute cell references, multiple cell references, and 3D references  Use advanced functions, including vlookup and hlookup  Organize worksheet and table data  Outline and group data  Use charts to present data  Analyze data using pivot tables, slicers, and pivot chartsExcel Level 3  Import and export data  Insert and use a slicer  Integrate Excel data with the web  Apply conditional formatting  Link and consolidate workbooks  Pivot consolidated dataMaryland Electronic Courts (MDEC) New Employee Core Clerk and Manager Training  Articulate the benefits of a statewide electronic case management system  Add/modify Cases, Parties, Events, Hearings, Exhibits, Bonds and Warrants  Use Court Calendars to view and manage court dockets  Process hearing results through Courtroom Minutes  Add and modify charges  Manage and generate case-related documents, forms, and reports  Log in to, navigate in, and process File and Serve submissions  Create, manage, route, and track tasks  Locate and process documents in Queues  Add/modify judgments, pleas, dispositions, and sentences  Assess, modify, and waive fees on cases  Manage tills and process payments  Process intra-court cases  Process peace and protective orders  Log in to, navigate, and process cases using Clerk Edition  Locate court learning resources for business process and troubleshooting issuesMaryland Electronic Courts (MDEC) New Judge Core Training  Open, navigate, and use the Odyssey and Judge Edition applications in chambers and in the courtroom  Open and view cases and case documents  View daily, weekly, and monthly court dockets  Use Task Manager Queues to view tasks and move tasks from their que ues to other queues  Annotate documents in Task Manager  Add notes to cases in Task Manager DTE Course Learning Objectives | 3

Maryland Electronic Courts (MDEC) Refresher: Peace and Protective Orders  Initiate and process new Protective Order cases  Edit/modify existing Protective Order cases  Update the Petition Event and scan the document  Schedule Related Hearings  Generate the Judge’s Worksheet  Add, view, modify, and copy Protective Orders  Add additional Protected Parties and Addresses  Complete the Interview Tool  Generate an Order and scan a signed OrderMaryland Electronic Courts (MDEC) Refresher: Task Manager, Peace and ProtectiveOrders, Reports  Process peace and protective orders  Submit, schedule, and print reports  Create, manage, route, and track tasks  Locate court learning resources for business process and troubleshooting issuesNew Employee Technology Orientation (NETO)  Identify technical resources  Utilize various office phone features  Update personal information  Submit and edit a leave request  Complete and edit a timesheet  Initiate and submit a help incident  Identify additional learning resourcesOffice 365 Overview  Access and navigate Office 365  Customize Office 365 settings  Use Mail features, including searching, sorting, and responding to Email  Use Calendar features, including viewing, using, and sharing calendars  Create and manage Groups  Review Contacts features  Utilize Skype for Business through Office 365 DTE Course Learning Objectives | 4

OneNote Overview  Navigate in OneNote 2013  Create notebooks, sections, and pages  Format and edit text and notes  Insert spacing, tables, files, and images  Use the Send to OneNote tool  Use tags to organize a notebook  Email, export, and print a notebookOutlook 2013 Overview  Open, reply to, forward, and delete messages  Create and format an email message  Create and manage folders  Schedule a meeting  Customize the calendar view  Customize the ribbon and quick access toolbarPowerPoint Level 1  Create a basic presentation  Format text on slides  Add/modify graphical objects  Insert charts and tables  View and print a presentation  Use presenter viewPowerPoint Level 2  View and use slide masters  Create slide layouts  Create, save, edit, and use templates  Add SmartArt graphics to a presentation  Add special effects to a presentation  Secure and distribute a presentationPublisher Level 1  Navigate in Publisher  Create and format a publication  Add elements to a publication, including shapes, images, backgrounds, and other page elements  Use and format tables in a publication  Add and customize pages in a publication  Print and share a publication DTE Course Learning Objectives | 5

Revenue Collection System (RCS) – Accounting/Back Office  Logon to RCS  Navigate report categories and reports  Enter report parameter values  Preview and navigate reports in the Crystal Reports Viewer  Print and export reports  Reset the RCS user passwordRevenue Collection System (RCS) – Cashier  Process cash, check, and credit card payments  Process special transactions including fee waived payments for Government Instruments, split payment transactions, overpayment by check, and expenditure credit items  Cancel a current transaction  Recall and void completed transactions  Void single items and partial payments  Print, review, and action end of day process reports including the cash register report and cash summary sheet  Reset the RCS user passwordRevenue Collection System (RCS) – Supervisor  Void completed transactions  Edit a cash summary sheet  Open, reopen, edit, and close batches  Complete overage and shortage processes  Run end of day reports  Reset terminals  Reset the RCS user passwordSharePoint 2013 Overview  Access and navigate in SharePoint 2013  Open and edit existing documents  Create a new SharePoint folder  Work with SharePoint documents, including creating, uploading, and downloading a document  Check documents out and in  Use a SharePoint calendar  Create alerts DTE Course Learning Objectives | 6

Virtual Desktop Infrastructure (VDI)  Connect to VDI using the desktop client  Connect to VDI using the mobile client  Navigate the Windows 10 environment  Recognize the difference between Office 365 and Office 2016  Access the Outlook Web Client (OWA)  Disconnect and Log off from VDIWord Level 1  Edit text in a Word document  Modify the appearance of text  Insert special characters and objects  Organize data in tables  Use Microsoft tools to proofread a document  Modify page layout  Print a documentWord Level 2  Create customized styles and themes  Create, save, use, and edit templates  Perform a mail merge  Insert content using Quick Parts  Insert, customize, navigatethrough, and delete sections  Collaborate on document review using track changes and commentsWord Level 3  Create a bibliography  Create Forms  Create and work with a master document and linked subdocuments  Embed objects in a Word document  Record/write, edit, and run macros  Assign a macro to a keystroke DTE Course Learning Objectives | 7

Microsoft Office 2016 – Logical OperationsWord 2016 – Level 1  Open, view, edit, save, and print documents  Format text and paragraphs  Perform repetitive operations using Find and Replace, Format Painter, and Styles  Sort, renumber, and customize list styles  Create and format tables  Insert graphic objects into a document  Format the appearance of a page  Correct problems with spelling,grammar, readability, and accessibilityWord 2016 – Level 2  Organize content using tables and charts  Customize formats using styles and themes  Insert content using quick parts  Use templates to automate document formatting  Control the flow of a document  Simplify and manage long documents  Use mail merge to create letters, envelopes, and labelsWord 2016 – Level 3  Use images in a document  Create custom graphic elements  Collaborate on documents  Add reference marks and notes  Secure a document  Create and manipulate forms  Create macros to automate tasksPowerPoint 2016 – Level 1  Identify the basic features and functions of PowerPoint 2016  Perform advanced text editing operations  Add graphical elements to a presentation  Modify objects in a presentation  Add charts and tables to a presentationPowerPoint 2016 – Level 2  Customize design templates  Add SmartArt and math equations to a presentation  Insert media and animations  Customize a slide show  Secure and distribute a presentation DTE Course Learning Objectives | 8

Outlook 2016 – Level 1  Navigate Outlook 2016 to read and respond to email  Create new messages using the Address Book  Attach files and insert illustrations to messages  Customize read and response options  Use flags, categories, and folders to organize messages  Create and work with Contacts  Create Calendar appointments and schedule meetings  Create and work with Tasks and NotesOutlook 2016 – Level 2  Modify messages and set global options  Organize, search, and manage messages  Automate message management  Manage contacts and groups  Use tasks to manage activities  Share workspaces with others  Manage Outlook data filesExcel 2016 – Level 1  Perform calculations  Modify a worksheet  Format a worksheet  Print workbooks  Manage workbooksExcel 2016 – Level 2  Customize the Excel environment  Create advanced formulas  Analyze data by using functions and conditional formatting  Organize and analyze datasets and tables  Visualize data by using basic charts  Analyze data by using PivotTables, slicers, and Pivot Charts DTE Course Learning Objectives | 9

Excel 2016 – Level 3  Work simultaneously with multiple worksheets and workbooks  Share and protect workbooks  Automate workbook functionality  Apply conditional logic  Audit worksheets  Use automated analysis tools  Present data visuallyAccess 2016 – Level 1  Navigate within the Microsoft Access application environment  Create a simple database  Customize Access configuration options  Organize and manage data stored within Access tables  Use queries to join, sort, and filter data from different tables  Use forms to make it easier to view, access, and input data  Create and format custom reportsAccess 2016 – Level 2  Design a relational database  Join tables to retrieve data from unrelated tables  Validate data entered into a database  Use advanced queries to manipulate data  Organize a database for efficiency and performance, and to maintain data integrity  Customize reports to organize information and produce specific print layoutsPublisher 2016  Perform basic tasks in the Microsoft Publisher interface  Add content to a publication  Format text and paragraphs in a publication  Manage text in a publication  Work with graphics in a publication  Prepare a publication for printing and sharingSharePoint 2016 – Site User  Interact with SharePoint Team Sites  Open and edit existing documents  Create, upload, and download documents  Check documents out and in  Interact in SharePoint  Work with Lists  Integrate SharePoint with Microsoft Office DTE Course Learning Objectives | 10