Grade9bbt.weebly.com



To search the document: use the keyboard commands CTRL+F to search for keywords (i.e. “activity”)General Resources (Specifically for Information Technology 120, but also for other teachers)Please note this website changes their links regularly so you need to visit the main site and scroll to the bottom of the page and click the link for technology: Microsoft Tools and Resources for educators: Meeting resources: Creating, attending, and running meetings while using Teams for distance learningBBT9 resources: resources: Resources (GCO 1; SCO 1.1, 1.2, 1.3, 1.6, 1.7) DescriptionPrerequisiteLinkNotes (rubrics etc)Office 365 Q&ALinkHow to’s for opening & logging on etc.Installing desktop Office AppsLinkHave all students do this at the beginning of the yearWindows fundamentalsNoneLinkLab assignment (grades 6-8)MS AccessLevel – Intermediate (grades 9-12)DescriptionPrerequisiteLinkNotes (rubrics etc)Introduction - video noneYoutube LinkIntroduction - video none (1 tutorial – See notes) Video only: Youtube Link Scroll to bottom of page – select technology – select Access– Tutorial # 1What is RDBMS (Relational Database Management System) LinkGood overview of how a relational database deals with dataSaving and back-up a Database LinkSaving in a different formatNoneMS LinkSaving as a PDFNoneavantixlearning.ca/ LinkBasics: Introduction to Objects, Getting started in Access, Managing Databases and objectsExcel intermediate (3 tutorials – See notes) Video only: Youtube LinkYoutube LinkYoutube Link Scroll to bottom of page – select technology – select Access– Tutorial # 2-4Microsoft training videos Excel - Intermediate MS Link Working with data: Tables, Forms, Sorting and filtering RecordsExcel intermediate (3 tutorials – See notes) Video only: Youtube LinkYoutube LinkYoutube Link Scroll to bottom of page – select technology – select Access– Tutorial # 5-7Modifying and edit formsBasicsYoutube LinkModifying and edit formsBasicsMS LinkCreate a table and add fieldsBasicsMS LinkTable field propertiesWorking with dataYoutube LinkData types and Field propertiesWorking with dataMS LinkCreate relationships between tablesWorking with dataMS LinkSee also: MS LinkAdditional links as well: add a lookup field, compare 2 tables...Create relationships between tablesWorking with dataYoutube LinkImporting excel data into AccessWorking with dataYoutube LinkImporting excel data into AccessWorking with dataYoutube LinkImporting excel data into AccessWorking with dataMS LinkRunning Queries and Reports: Designing a simple Query, a multi-table Query, More Query designsExcel intermediateWorking with data (3 tutorials – See notes) Video only: Youtube LinkYoutube LinkYoutube Link Scroll to bottom of page – select technology – select Access– Tutorial # 8-10Introduction to QueriesExcel intermediate, Working with dataMS LinkCreate a simple select QueryWorking with DataMS LinkRunning Queries and Reports: Creating reports, Advanced report optionsExcel intermediateWorking with data (2 tutorials – See notes) Video only: Youtube LinkYoutube Link Scroll to bottom of page – select technology – select Access– Tutorial # 11-12Introduction to reportsWorking with DataMS LinkSee also: MS LinkReport BasicsWorking with LinkModifying TablesExcel; Working with data (1 tutorials – See notes) Video only: Youtube LinkScroll to bottom of page – select technology – select Access– Tutorial # 13Modifying reportsWorking with dataMS LinkCreating and Formatting FormsExcel; Working with data (2 tutorials – See notes) Videos: Youtube LinkYoutube LinkScroll to bottom of page – select technology – select Access– Tutorial # 14-15Text formatsWorking with dataMS LinkLong text or Memo formatWorking with dataMS LinkNumber formatWorking with dataMS LinkAutoNumber formatWorking with LinkDefinition with additional linksDesigning your own DatabaseWorking with data ( tutorial – See notes)Scroll to bottom of page – select technology – select Access– Tutorial # 16 Creating calculated fields and Total rowsWorking with data ( tutorial – See notes)Scroll to bottom of page – select technology – select Access– Tutorial # 17 Create a find duplicates QueryWorking with data ( tutorial – See notes)Scroll to bottom of page – select technology – select Access– Tutorial # 18Create a Parameter QueryWorking with data ( tutorial – See notes)Scroll to bottom of page – select technology – select Access– Tutorial # 19Query criteria quick reference guideWorking with data ( tutorial – See notes)Scroll to bottom of page – select technology – select Access– Tutorial # 20Query criteria quick reference guideWorking with dataMS LinkUsing table data to perform a mail mergeWorking with dataMS LinkUse Mail merge to send data to WordMS LinkSharing a database fileWorking with dataMS LinkCreate a link to share dataWorking with dataMS LinkSee links at bottom of page 2 hour on-line course (video) Excel - Intermediate Youtube Link MS Access Quick Reference LinkA printable guide in 3 levels: Basic, Intermediate, advancedMS AccessLevel – Advanced (grades 9-12)DescriptionPrerequisiteLinkNotes (rubrics etc)Design Your own databaseWorking with dataedu.Calculated fieldsWorking with dataedu.Create a Find duplicates QueryWorking with dataedu.Creating a Parameter QueryWorking with dataedu.Query Tips and techniquesWorking with dataAdditional Access Resources: (Plenty of resources here) (Whole course here with a linked list of topics) (free video tutorials courses) (Course text – Access Basics) (Course text)Project Management (GCO 2, SCO 2.1, 2.2)Level - Intermediate (grades 9-12)DescriptionPrerequisiteLinkNotes (rubrics etc)Short introductory video Youtube LinkProject Management toolkit for teachers Link You need to sign up for a free account to get the resourcesArticle and LinkProject Life CycleIntroductionopentextbc.ca LinkProgram Management text book, look at table of contents for more chaptersProject management team rolesLife Link see also: elearningindustry See also: linkArticles.Key skills of a project managerTeam Link See also: Link and: LinkArticles. Creating a matrix to decide what tasks each team member should be assigned none LinkArticles.Project constraintsTeam Link See also: projectmanager And: Link And: LinkArticles.Planning tools for Project ManagementConstraintsprojectsmart.co.uk Link see also: LinkAnd: critical-path-analysisArticles.Gantt LinkArticleGantt LinkArticle & tutorialGantt ChartsConstraintsMS Link See also: Link tutorialsGantt LinkThorough TutorialProject scope statementPlanning Link See also: Link And: LinkArticles, And: how to.Schedule of ActivitiesPlanning toolsopentextbc.ca Link See also: Short article And: Short article And: How to Articles, And: how to.Measuring progressScope and Schedulesuccess see also: Link and: short articleArticles, And: how to.MS Project Link See also: LinkArticleMS Project softwareYoutubeOverview of MS ProjectMS Project softwareYoutube tutorial Free PM Institute course on Project Management for beginners Link Additional resources for Project Management (Creative commons textbook – see table of contents)MS TeamsDescriptionPrerequisiteLinkNotes (rubrics etc)ASD-South Resource pageNoneLinkAll kinds hereVarious resourcesDescriptionPrerequisiteLinkNotes (rubrics etc)Countdown Timer (customizable)countingdowntoPut into Teams, webpages, or use on white boardOffice 365 Q&ALinkHow to’s for opening & logging on etc.How to install Office Desktop AppsLinkHave all students do this at the beginning of the year ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download