Ontario Tech University
Ontario Tech University
Log in Sign up

Microsoft Digital Skills - Introduction to Microsoft Excel and Access

Comp 174, 175, 176
Closed
Saskatchewan Polytechnic
Saskatchewan Polytechnic
Regina, Saskatchewan, Canada
Sheldon Miller
Instructor
1
Timeline
  • September 7, 2022
    Experience start
  • September 16, 2022
    Project Scope Meeting
  • December 4, 2022
    Experience end
Experience
3 projects wanted
Dates set by experience
Preferred companies
Canada
Any
Agriculture, Environment, Energy, Mining, forestry & fishery

Experience scope

Categories
Databases Data visualization Data analysis Data modelling
Skills
data analytics database strategy
Student goals and capabilities

Saskatchewan Polytechnic is the first post-secondary institution in Canada to become a Microsoft in Education Global Training Partner.

As a Microsoft in Education Global Training Partner, Saskatchewan Polytechnic offers a range of services provided by fully qualified Microsoft Certified trainers and Microsoft Certified Educators, delivering official Microsoft Learn Curriculum in Microsoft Technical Certifications, Microsoft Fundamentals as well as Microsoft Certified Educator content.

These courses run on a rolling basis throughout the year - please submit to this posting if your project is to be completed in September-October 2022. For projects running future other timeframes, please refer to our subportal on Riipen.

Students in this course are all enrolled in the School of Continuing Education and therefore are more experienced in the workforce.

Students

Students
Certificate
Any level
15 Students
Project
30 hours per Student
Students self-assign
Teams of 4
Expected outcomes and deliverables

This will be dependent on the scope of the given project but could include:

- A report detailing the documents created

- A workflow showing how the data can be manipulated in the Excel and Access data sheets

Project timeline
  • September 7, 2022
    Experience start
  • September 16, 2022
    Project Scope Meeting
  • December 4, 2022
    Experience end

Project Examples

Requirements

Microsoft Excel

Students can complete the following:

- Create, edit and format Excel documents, as well as use several time saving features available in the Excel environment.

- Create, edit and format spreadsheet elements, create simple charts and use simple formulas and functions.

- Work with multiple worksheets, create and modify several chart types, perform data manipulation and use more advanced spreadsheet functions.

Microsoft Access

Students can complete the following:

- Create database tables

- Enter data in tables

- Extract information from tables

- Produce forms and reports based on tables and queries

Additional company criteria

Companies must answer the following questions to submit a match request to this experience:

  • Q - Checkbox
  • Q - Checkbox