Using Excel for Teachers

Focused View

Justin Brodie

3:02:54

35 View

1. Introduction

1. Introduction to the Course.mp4

02:24

2. Layout of Excel.mp4

04:10

3. Quiz on the Layout of Excel.html

2. Project 1 - A Weekly Planner

1. Introduction to the Weekly Planner Project.mp4

00:32

2. Setting up the Page.mp4

04:20

3. Entering Content.mp4

05:56

4. Adding Borders and Colours.mp4

05:25

5. Printing out the Weekly Planner.mp4

01:02

6. Project 1 Quiz.html

7. Weekly Planner Activity.mp4

00:30

3. Project 2 - A Timetable

1. Introduction to the Timetable Project.mp4

00:33

2. Setting up the Grid.mp4

09:29

3. Adding Content (1).mp4

03:07

4. Adding Content (2).mp4

08:44

5. Finishing Touches and Printing.mp4

03:16

6. Project 2 Quiz.html

7. Timetable Activity.mp4

00:37

4. Project 3 - Setting up a Register

1. Introduction to the Register Project.mp4

00:32

2. Setting up the Names (1).mp4

01:02

3. Setting up the Names (2).mp4

04:07

4. Adding a Week and Formatting the Date.mp4

06:59

5. Adding Totals.mp4

08:25

6. Adding Conditional Formatting.mp4

06:14

7. Preparing the Register for a full Term.mp4

09:07

8. Project 3 Quiz.html

9. Register Activity.mp4

00:23

5. Project 4 - Using the Names from the Register

1. Introduction to the Project.mp4

00:19

2. Copying Data to a New Sheet.mp4

04:01

3. Creating a Tick List.mp4

05:25

4. Creating a Seating Plan.mp4

07:42

5. Project 4 Quiz.html

6. Activity.mp4

00:19

6. Project 5 - Creating a Mark Book

1. Introduction to the Mark Book Project.mp4

00:25

2. Adding Names and Marks.mp4

07:01

3. Calculating Percentages.mp4

04:54

4. Adding Grades.mp4

11:57

5. Adding Formatting including Conditional Formatting.mp4

11:59

6. Making Changes.mp4

14:03

7. Adding another Assessment.mp4

15:14

8. Adding an overall Grade.mp4

11:36

9. Project 5 Quiz.html

10. Creating a Mark Book Activity.mp4

00:27

7. Conclusion

1. Conclusion to the Course.mp4

00:38

Description

Learn how to use Excel, focusing on the most important features necessary for a teaching and educational environment

What You'll Learn?

Get to grips with using Microsoft Excel confidently
Master the basics of Excel as well as some of the more advanced features
Be able to use the most important functions of Excel that a teacher or other educator will need
Complete several short projects relevant to teaching and education which focus on particular areas of use of Excel

Who is this for?

Any teacher who has little or no previous knowledge of using Excel

Intermediate users who wish to refresh or build on their knowledge

Anybody in the world of education who has only found Excel courses aimed at businesses

What You Need to Know?

No prior knowledge of Excel required

Will work with any version of Microsoft Excel from 2007 onwards

More details

Description
Are you a teacher or do you work in education?Â Do you wish to master the basics of Excel?Â Have you only found courses on Excel aimed at people in business rather than education?Â If so, this is the course for you.Â The course will enable you to develop the following spreadsheet skills:

Set up a page or spreadsheet, including adding a header, so that it is suitable for printing out.
Enter and format data, so the presentation is clear and looks professional.
Use functions in order to summarise data and make calculations.
Copy and paste or move around data and formulas in order to save duplicating work.
Use conditional formatting to highlight specific data.
Use lookup tables to assign grades to marks, for example.
Develop strategies to ensure that formulas are correct, by making changes and checking results, especially after copying formulas from one place to another within a spreadsheet.
The course is presented through a series of projects, progressing in complexity, to produce the kinds of spreadsheets that a teacher or other educator should find useful.Â The ideas can easily be adapted or individualised.Â The projects are the following:

Create a weekly planner.
Create a timetable.
Set up a register.
Use the names from the register to produce a tick list and a seating plan.
Use the names from the register to produce a mark book.
Who this course is for:
Any teacher who has little or no previous knowledge of using Excel
Intermediate users who wish to refresh or build on their knowledge
Anybody in the world of education who has only found Excel courses aimed at businesses

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Justin Brodie

Instructor's Courses

My name is Justin, and I have been a teacher for nearly 30 years, working in schools both in the UK and internationally. Over this time I have developed IT and computing skills in order to aid with administration, in particular data management, exams administration and timetabling. I often find that my colleagues ask me for help with spreadsheets and data management, so I decided to put my expertise to use by producing my first online course.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.