ICT

Practice book
for Business School students

Sagdoldanova Aiym
2022-2023
 PURPOSE

This Practice book is specifically designed for Business School students to use during
their ICT course practice hours. The purpose of this practice book is to provide comprehensive
hands-on exercises and practical activities. It serves as a comprehensive guide for students and
individuals interested in leveraging Google for Education, mastering Google Docs, Forms and
Sheets, as well as enhancing their abilities in data analysis, visualization and web application
development using tools like Looker Studio, PowerBI and Figma. The book aims to equip
readers with the necessary knowledge and skills to confidently use these tools and platforms in
their academic, professional, and personal endeavors.

ABBREVIATIONS

RAM - Random Access Memory

HDD - Hard Disk Drive
CPU - Central Processing Unit
APA - American Psychological Association
Add-on - customized applications that integrate with Google Workspace applications
DAX - Data Analysis Expressions
URL - Uniform Resource Locator
SQL - Structured Query Language
UI - User Interface
UX - User Experience
HTML - HyperText Markup Language
CSS - Cascading Style Sheets

1
 How-to-use the Practice Book:
This practice book is designed to be used over a 15-week period, with each week
dedicated to completing one practice work based on the topics outlined in the book's content.
Here's a brief explanation of how to effectively use the practice book:
1. Review weekly topics: Familiarize yourself with the weekly topics listed in the book's
content. The book content is the same as your syllabus. Understand that the practice tasks
focus on applying and reinforcing the knowledge gained from the corresponding lectures.
2. Access lecture recordings: In case you encounter difficulties or have questions while
completing the practice tasks, refer to the lecture recordings available on Moodle. These
recordings serve as a valuable resource for clarifying any misunderstandings or seeking
further guidance.
3. Follow the task instruction: Pay attention to the specific guidelines outlined in the book
for each practice task. These guidelines will provide you with clear expectations, such as
the required deliverables or any specific techniques to use.
4. Grading and Assessment: Take note of the grading associated with each practice task.
Understand the criteria upon which your work will be evaluated. Use the grading as a
means to gauge your progress and strive for continuous improvement
After completing each practice task, take time to reflect on your learning experience.
Assess your understanding of the topic and identify areas where you may need further practice or
clarification.
By following this approach, you will effectively utilize the practice book to reinforce
your understanding of the topics covered in the lectures. The book's practice tasks, along with the
lecture recordings, will help you apply your knowledge and develop the necessary skills.
Remember to actively engage in the learning process, seek support when needed, and
continuously strive for improvement.

2
CONTENT
Week PW Topic Page

1 - Analysis

Week 1 Practice work 1 Google for Education Getting started with Google Docs 4

Week 2 Practice work 2 Sending and Analyzing data with Google Forms 14

Week 3 Practice work 3 Design and Deliver Great Presentations 17

2 - Development

Week 4 Practice work 4 Google Sheet: Essential Functions 19

Week 5 Practice work 5 Google Sheet: Data Analysis 21

Week 6 Practice work 6 Google Sheet: Interactive and visually compelling charts 23

Week 7 Practice work 7 Google Sheet: Advanced Formulas and Function 25

Week 8 Practice work 8 Data Visualization with Looker Studio 27

Week 9 Practice work 9 Data Visualization with PowerBI 30

3 - Testing

Week 10 Practice work 10 Database (Part 1) 33

Week 11 Practice work 11 Database (Part 2) 36

Week 12 Practice work 12 Designing Mobile & Web Applications (Figma) 38

Week 13 Practice work 13 Designing Mobile & Web Applications (Portfolio 42

Design)

4 - Deployment

Week 14 Practice work 14 HTML & CSS Fundamentals (Part 1) 47

Week 15 Practice work 15 HTML & CSS Fundamentals (Part 2) 49

3
Practice Work 1
Google for Education. Getting started with Google Docs

After completing PW 1, learners should be able to:

● create and modify tables, table content, background color, border’s color and width;
● insert and manage dropdown lists;
● work with built-in functions/equations;
● find symbols/characters by drawing;
● insert header/footer and page numbers;
● insert internal and external links;
● insert images with dragging and dropping;
● work with built-in dictionary;
● insert footnote, in-text citations and references list;
● demonstrate documents statistics;
● manage the file with documents outline;
● share the file with different access types;
● manage activity dashboard;
● find all modified data from documents history;
● create a table of contents.

4
 Practice work 1. Google Doc

CONTENT

Task 1: Computer’s characteristics table(10%)........................................................................................ 2

Task 2: Equations & Symbols/Characters (12%)..................................................................................... 3

Task 3: Header/Footer and Page number (10%)...................................................................................... 3

Task 4: Images, Internal & External links and Embedded Dictionary (13%)....................................... 4

Task 5: Footnote citation/In-text citation/ References (20%).................................................................. 5

Task 6: Document’s statistics (5%).............................................................................................................7

Task 7: Document Outline (10%)............................................................................................................... 8

Task 8: File sharing and collaboration (10%)........................................................................................... 8

Task 9: Document’s history (5%)............................................................................................................... 9

Task 10: Table of CONTENTS (5%).......................................................................................................... 9

5
Task 1: Computer’s characteristics table(10%)
● Create a table about your computer’s characteristics (computer type, RAM, HD, CPU,
etc.). Insert -> table 4%
● Change the table's background color, border’s color and width. Highlight the table rows
or columns you need -> background color 3%
● Learn to merge the same cells. Highlight two same cells->click the right side of mouse
->merge cells
● Include a dropdown list. Insert -> dropdown 3%

Example:
ID Computer Type RAM HD CPU
manufacturer memory

1 Apple MacBook Air 8 GB 128 GB Intel Core i5

2 Asus Zenbook 8 GB 1 TB Intel® Core™

i7-8565U

Task 2: Equations & Symbols/Characters (12%)

Learn to insert equations, symbols and characters

● Insert → Equation (select a necessary math operations, relations or greek letters ) 7%
● Insert → Special characters (search by keyword, codepoint or draw them) 5%
Example:
Equations Symbols/Characters

Cos (α + β) = CosαCosβ- SinαSinβ 📖 ✍️

2
𝑥 ♜♝♞♟♛♚
∫𝑒
1

S = 𝑝(𝑝 − 𝑎)(𝑝 − 𝑏)(𝑝 − 𝑐) ♬

P=
𝑛! ♣♦♠♥
(𝑛−𝑟)!

6
Task 3: Header/Footer and Page number (10%)

● Add Header/Footer and Page number to your file (2%)

● As a header, insert your signature. It is possible to insert a signature with the
“HelloSign”, “Signature”, “Sign.co”, etc. add-ons(Extensions->Add-ons) or upload it
from different internet resources (5%).
For example: https://www.signwell.com/online-signature/
In the case of the second method, upload your signature with a transparent background.
See an example below7

● As a footer insert page numbers. Page numbers should start counting from the second
page (3%).
Insert → Page Number->Options->Numbering->Mention starting number and page

Task 4: Images, Internal & External links and Embedded Dictionary (13%)
● Copy any article about the big companies from internet resources and paste it into your
document. 2%
● Insert the official website’s link to the company's name (example: Intel). 3%
Highlight the text -> Insert->Link->Search or paste the link OR accept suggested link
● Insert the image or logo of the company. Make sure text should be wrapped around an
image (see an example below). Also, text alignment: justify(Ctrl+Shift+J) 5 %
Insert->Image->Search the web->Drag and drop the picture
● Highlight the words from your text that you don’t know the definition or synonyms of.
Using the dictionary embedded in Docs(Tools->Dictionary) look for these words and
paste at least one result into the document as a screenshot (see the examples below). 3%
Shortcuts to get cropped screenshots:
Win: Win+Shift+S
Mac: Cmd+Shift+4

7
Example:
Intel Corporation, commonly known as Intel, is an American
multinational corporation and technology company
headquartered in Santa Clara, California. It is the world's largest
semiconductor chip manufacturer by revenue, and is one of the
developers of the x86 series of instruction sets, the instruction
sets found in most personal computers (PCs). Incorporated in
Delaware, Intel ranked No. 45 in the 2020 Fortune 500 list of the largest United States
corporations by total revenue for nearly a decade, from 2007 to 2016 fiscal years.
Intel supplies microprocessors for computer system manufacturers such as Acer, Lenovo, HP,
and Dell. Intel also manufactures motherboard chipsets, network interface controllers and
integrated circuits, flash memory, graphics chips, embedded processors and other devices related
to communications and computing.
Intel (integrated and electronics) was founded on July 18, 1968, by semiconductor pioneers
Gordon Moore (of Moore's law) and Robert Noyce (1927–1990), and is associated with the
executive leadership and vision of Andrew Grove. Intel was a key component of the rise of
Silicon Valley as a high-tech center. Noyce was a key inventor of the integrated circuit
(microchip). Intel was an early developer of SRAM and DRAM memory chips, which
represented the majority of its business until 1981. Although Intel created the world's first
commercial microprocessor chip in 1971, it was not until the success of the personal computer
(PC) that this became its primary business.

8
Task 5: Footnote citation/In-text citation/ References (20%).

Continue working with text based data. In this exercise you can continue the selected topic from
the previous task or select another one. Depending on your choice do the followings:
● Insert 1 footnote citation based on your selected topic 5%

A footnote is a piece of information that is added at the bottom of a page in a book,

document, or article. It is typically used to provide additional context, clarification, or
citation for a particular point or statement made in the main text. Footnotes are often
marked with a superscript number or symbol in the main text, which corresponds to the
corresponding note at the bottom of the page (See an example below).

Tools->Explore → Search the web → Click the quote mark (Cite as footnote)
You might use this example in case you'd like to show the original resource of your taken
paragraph. However, remember you can add your own footnotes. To do so go for
Insert->Footnote-> Insert data

● Insert at least 2 in-text citations using APA format based on your text data (See an
example below). 10%

APA style provides rules for formatting papers, citing sources, and referencing in-text
citations. It includes guidelines for the structure and content of the paper, such as title
page, abstract, introduction, methods, results, discussion, and references. The goal of
APA style is to ensure clarity, consistency, and accuracy in academic writing.

Tools → Citations->Choose APA format->Add citation source (As a source select the one
based on your topic)->Cite.

9
 ● Insert References with auto-fill (see an example below). 5%
Tools->Citations->Insert References

Example:
Apple Inc. is an American multinational technology company headquartered in
Cupertino, California. Apple is the world's largest technology company by revenue, with
US$394.3 billion in 2022 revenue. As of March 2023, Apple is the world's biggest company by
market capitalization. As of June 2022, Apple is the fourth-largest personal computer vendor by
unit sales and second-largest mobile phone manufacturer. It is one of the Big Five American
information technology companies, alongside Alphabet Inc. (parent company of Google),
Amazon, Meta Platforms (formerly for Facebook Inc), and Microsoft1.
Apple was founded as Apple Computer Company on April 1, 1976, by Steve Wozniak,
Steve Jobs and Ronald Wayne to develop and sell Wozniak's Apple I personal computer. It was
incorporated by Jobs and Wozniak as Apple Computer, Inc. in 1977. The company's second
computer, the Apple II, became a best seller and one of the first mass-produced microcomputers.
Apple went public in 1980 to instant financial success (Kahney, 2009). The company developed
computers featuring innovative graphical user interfaces, including the 1984 original Macintosh,
announced that year in a critically acclaimed advertisement. By 1985, the high cost of its
products, and power struggles between executives, caused problems. Wozniak stepped back from

1
"Apple Inc. - Wikipedia." https://en.wikipedia.org/wiki/Apple_Inc.. Accessed 9 Apr. 2023.

10
Apple amicably and pursued other ventures, while Jobs resigned bitterly and founded NeXT,
taking some Apple employees with him (Linzmayer, 2004, 56).

References

Kahney, L. (2009). Inside Steve's Brain. Atlantic.

Linzmayer, O. W. (2004). Apple confidential 2.0 : the definitive history of the world's most

colorful company. No Starch Press.

Segall, K. (2013). Insanely Simple: The Obsession That Drives Apple's Success. Penguin

Publishing Group.

Task 6: Show document’s statistics (5%)

Tools->Word count

11
Task 7: Create Document Outline (10%)
● To get document outline click the icon which is located on the left side of your doc
● To add items into outline, apply paragraph styles

Task 8: Share your file for collaboration (10%)

● Share your document with three friends. And let your first friend fill his/her computer
details in the first table (Task 1), your second friend has a right only to comment in the
table (Task 1) and the third friend can only read the whole document.
● Check your “activity dashboard” to control your friends' visits.
Tools -> Activity dashboard

Task 9: Document’s history (5%)

● Check your file’s version history. File → Version history → See version history
And name it as your PW title.

12
TASK 10: Table of CONTENTS (5%)
● Create your document’s content: Insert → Table of contents
● Make sure the content is clear and has data to read! (Example is on the first page)

13
Practice Work 2
Sending and Analyzing data with Google Forms

After completing PW 2, learners should be able to:

● built forms, surveys and quizzes;
● administer quizzes;
● create various question types, such as multiple choice, short answer, checkboxes, linear
scale, grids, etc.
● gather data, receive in the moment feedback;
● customize the design of the form, including colors, fonts, and images;
● logic branching to show different questions based on a respondent's answer;
● analyze data collected from the form using charts and graphs;
● share the form with others and collect responses in real-time;
● set up notifications to receive;
● release the score;
● find/install different add-ons;

14
 Practice work 2. Google Form

Create a new Google Form with 3 sections. In the first section, ask users preference to fill
a survey or quiz with logic branching. Based on the user's choice, direct them from one section to
another using “Go to section based on answer”. 10%

Part 1: When the user chooses a survey (40%).

1. Create a survey (5 questions maximum) based on your major. Make sure questions are
clear and concrete! 5%
2. Answer types should be different for each 5 questions. 1 multiple choice, 1 checkbox, 1
linear scale, 1 dropdown and 1 multiple choice grid. 15%
3. Upload an image in the question or in answer types (at least one question OR answer
options) 5%
4. Set a limit of date and time. 5%
Hint: Use add-on FormLimiter to set the limit types.
5. Set a limit of responses (set a limit for 5 responses) 5%
6. Customize your form’s appearance(cover picture, background style, font style, etc.). 5%

Part 2 : When the user chooses a quiz (50%).

1. Open your google form’s setting and “make this a quiz” active from Quizzes options
2. Now, create a quiz (5 questions max, with correct answers) based on the topic
“Computer types”.
Answer types should be multiple choice (2 questions), short answer (1 question),
checkbox (2 questions). 20%
3. Don’t forget to indicate CORRECT versions of answers. 10%
Please consider all answer combinations for short answer types!!!
For example:
Question: Where does most data go first within a computer memory hierarchy?
Make sure, answers might be: RAM, ram, Random access memory, etc.
4. For each question give points, depending on the complexity of your question (total should
be 100%). 5%
5. In the setting part make sure you’ve turned on the “limit to 1 response”, release grade as
“immediately after each submission” and respondents have to see their “missed
questions”, “correct answers” & “point values”. 5%

15
6. Share your survey among 2 people and send a certificate for those who have gained score
>=75% with add-on certify’em. 10%
HINT:
In order to send certificate install an add-on “certify’em”.
Change the status to “ON”
Change the passing score to 75%
Select certificate styles from templates and save
Control user results in certify’em records file.
7. Upload your G.form link and Certify'em Records to Moodle.

16
Practice Work 3
Design and Deliver Great Presentations

After completing PW 3, learners should be able to:

● Plan and organize a presentation, including setting clear objectives and selecting
appropriate content;
● Create visually appealing slides, including selecting appropriate fonts, colors, and
images;
● Use effective presentation techniques, including using clear and concise language,
engaging with the audience, and using appropriate body language;
● Incorporate multimedia elements, including videos, images, and audio, to enhance the
presentation.
● Use different presentation software, such as PowerPoint, Google Slide, SlidesGo, Canva,
Prezi, etc.

17
 Practice work 3. Game based Slide

In this practice work you’re free to choose platforms to create presentations. However,
the main idea of the presentation should remain as described in this PW whatever platform
you’ve selected. Below you can see sample examples of game based slides which are completed
using PowerPoint and Google Slide.
Examples: Game based slide.pptx Google slide

1. Start by creating a blank slide in PowerPoint, Google slide, Canva, Prezi, etc.
Slide should be a game based (see an example above). Topic: free.
2. Insert a background image or color that fits your game’s theme. For example, if you're
making a puzzle game, you might use a background with jigsaw puzzle pieces.
3. Create a game board using shapes or images. Depending on the type of game you're
making, this could be a crossword board, a maze, or a board with spaces for players to
move, table, etc.
4. Add text boxes to label the game board and provide instructions or hints for the players
5. Insert images or icons that relate to the game, such as images of puzzle pieces, arrows to
move players, or icons representing different game elements.
6. Add animations or transitions to make the game more engaging.
7. Create interactive elements that allow players to interact with the game board. You could
use hyperlinks to take players to different parts of the game, or add buttons to allow
players to roll a dice or choose a game piece.
8. Slide should contain the main page section, where questions are divided into categories.
Based on selected category slide links should direct the user to the corresponding
page(7).
Number of categories: min 2
Number of questions: min 5 in each category
9. Links have to work correctly (if the answer is correct, then move to the next question,
otherwise return back to the previous one until the user finds the correct answer). Also,
when the user finishes first category questions, return the player to the main menu to
select and play another category/game type.
10. Test the game slide by playing it yourself or asking someone else to try it out. Make sure
it's easy to understand and engaging for players.
11. Grading: slide design - 30%, slide content - 35%, correct links - 35%

18
Practice Work 4
Google Sheet: Essential Functions

After completing PW 4, learners should be able to:

● Learn to create/modify/edit tables;
● Learn how to use basic functions like SUM, AVERAGE, MAX, MIN and COUNT to
manipulate and analyze data in a spreadsheet;
● Organizing data: Learn how to use functions like SORT and FILTER to organize data in a
spreadsheet and make it easier to work with;
● Find and replace values;
● Learn how to use Conditional formatting to dynamically change a cell's text style and
background color based on custom rules;
● Add and manage dropdown list.

19
 Practice work 4. Google Sheet: Essential Functions

Practice works between 4-7 are available in spreadsheet file format only. All these files
are accessible only with a corporate SDU account.

Please open the file below or scan QR code to start practice work №4. Before doing
exercises make a copy of the file(File->Make a copy) and start with any task that you find easy.
Practice work 4

20
Practice Work 5
Google Sheet: Data Analysis

After completing PW 5, learners should be able to:

● learn how to structure and organize data in a way that makes it easier to analyze and draw
insights from;
● understand the difference between absolute and relative references;
● learn to search for a specific value in a table or range of cells and return a corresponding
value from another column in the same row with VLookUp;
● learn to automate decision-making processes based on certain conditions with logical
functions such as IF/AND/OR;
● perform calculations based on certain criteria with SumIF, AverageIf and CountIf;
● combine text from different cells into one cell with CONCATENATE function;
● learn to extract text from the left or right side of a text string;
● learn to freeze the rows and columns;
● learn to protect the entire sheet or specific ranges from editing.

21
 Practice work 5. Google Sheet: Data Analysis

Practice works 5 is available in spreadsheet file format and it’s accessible only with a
corporate SDU account.

Please open the file below or scan the QR code to start practice work №5. Before doing
exercises make a copy of the file(File->Make a copy) and start with any task that you find easy.

Practice work 5.xlsx

22
Practice Work 6
Google Sheet: Interactive and visually compelling charts

After completing PW 6, learners should be able to:

● visualize data and make it easier to identify patterns and trends;
● analyze and interpret data;
● create different types of charts such as column chart, pie chart, doughnut chart, line chart
and others;
● learn to display small, inline sparklines within cells, providing a visual representation of
data trends and patterns;
● create charts that can be dynamically updated based on user input with dropdown menus;
● simplify data analysis by allowing users to filter data easily with dynamic charts.

23
 Practice work 6. Google Sheet: Interactive and visually compelling charts

Practice works 6 is available in spreadsheet file format and it’s accessible only with a
corporate SDU account.
Please open the file below or scan the QR code to start practice work №6. Before doing
exercises make a copy of the file(File->Make a copy) and start with any task that you find easy.

Practice work 6

24
Practice Work 7
Google Sheet: Advanced Formulas and Function

After completing PW 7, learners should be able to:

● learn how to use the SumIF, SumIFs functions to sum values that meet a single and
multiple criteria responding;
● learn to construct the formula with the range, one or more criteria, and optional
sum_range;
● use various comparison operators and logical operators, such as AND and OR, to define
the criteria;
● learn to analyze and summarize large amounts of data quickly and easily with pivot table;
● know how to customize the appearance of a pivot table, such as changing the layout,
formatting, and design;
● know how to filter, sort, and group data in a pivot table to focus on specific aspects of the
data;
● combine text from different cells into one cell with CONCATENATE function;
● learn to extract text from the left or right side of a text string;
● know how to record and run a macro;
● understand how to edit a macro to modify its functionality or correct errors;

25
 Practice work 7. Google Sheet: Advanced Formulas and Function

Practice works 7 is available in spreadsheet file format and it’s accessible only with a
corporate SDU account.
Please open the file below or scan the QR code to start practice work №7. Before doing
exercises make a copy of the file(File->Make a copy) and start with any task that you find easy.

Practice work 7

26
Practice Work 8
Data Visualization with Looker Studio

After completing PW 8, learners should be able to:

● collect, analyze and import the data to visualize;
● determine the main message of data to convey with Looker Studio;
● create visually appealing and interactive data visualizations using various chart types,
graphs, and widgets in Looker Studio;
● gain skills in selecting appropriate visualizations to effectively communicate insights and
patterns in data;
● learn how to design and build comprehensive reports and dashboards in Looker Studio;
● understand how to organize and present data in a structured manner, allowing users to
easily analyze and interpret information;
● gain skills in using filters, dimensions, measures, and other tools to slice and dice data,
identify trends, and discover actionable insights;
● understand how to schedule and distribute automated reports, as well as grant appropriate
access permissions to ensure data security and confidentiality;
● learn about advanced features and customization options in Looker Studio, such as
implementing custom calculations, creating derived tables, using LookML (Looker
Modeling Language) for data modeling, and integrating with other data sources and tools.

27
 Practice work 8. Data Visualization with Looker Studio

Here is given for you a dataset about Global Internet users from kaggle.com :
Dataset PW8

The following dataset has information about internet users from 1980-2020. Details about the
columns are as follows:

- Entity - Contains the name of the countries and the regions.

- Code - Information about country code and where code has the value 'Region', it denotes
division by grouping various countries.
- Year - Year between 1980-2020
- Cellular Subscription - Mobile phone subscriptions per 100 people. This number can get
over 100 when the average person has more than one subscription to a mobile service.
- Internet Users(%) - The share of the population that is accessing the internet for all
countries of the world.
- No. of Internet Users - Number of people using the Internet in every country.
- Broadband Subscription - The number of fixed broadband subscriptions per 100 people.
This refers to fixed subscriptions to high-speed access to the public Internet (a TCP/IP
connection), at downstream speeds equal to, or greater than, 256 kbit/s.

Using the dataset above complete the following tasks in Looker Studio:

Link: https://lookerstudio.google.com

1. Create a new blank report and import the prepared dataset into Looker Studio 5%
2. Create interactive dashboards in Looker Studio that showcase the visualizations and
insights derived from the Global Internet users dataset above. Design the layout in a way
that provides a clear overview of the data and allows users to interact with the charts for
deeper exploration:
● Determine the key metrics and dimensions to analyze and visualize in the dataset.
This may include metrics like total Internet users by country/year, or the rate of
subscriptions and others. 15%

28
 ● Consider different types of visualizations, such as bar charts, line charts, pie
charts, maps, scorecards or tables to effectively represent the data. For example
line chart showing the internet users by year OR bar chart showing the internet
users by subscription, etc. 20%
3. Enable filtering and drill-down capabilities in the Looker Studio dashboards to allow
users to focus on specific countries, time periods, or number of subscriptions. 10%
4. Customize the appearance of the visualizations and dashboards in Looker Studio to align
with your desired branding or design aesthetics. This includes selecting appropriate color
schemes, fonts, and layout styles. 35%
5. Review the visualizations and dashboards to ensure accuracy, clarity, and usability. Seek
feedback from users to improve the visualizations and make any necessary refinements.
10%
6. Share your dashboards. 5%

Here is one of the best dashboard example in Looker Studio:

29
Practice Work 9
Data Visualization with PowerBI

After completing PW 9, learners should be able to:

● learn how to connect Power BI to various data sources, including databases, spreadsheets,
and cloud-based services;
● learn how to analyze and interpret data effectively, discovering key insights and trends
through interactive visualizations and reports;
● understand how to import, transform, and model data from various sources to create
meaningful relationships and hierarchies in Power BI;
● learn how to design and build interactive dashboards that provide a comprehensive view
of data, allowing users to explore and drill down into specific metrics and dimensions;
● understand how to aggregate and summarize data using DAX functions like SUM,
AVERAGE, COUNT and more;
● combine DAX calculations with Power BI visualizations to create interactive and
insightful reports and dashboards;
● learn to collaborate with team members by sharing dashboards and reports, controlling
access permissions, and creating data-driven presentations.

30
 Practice work 9. Data Visualization with PowerBI

Part 1 (60%)

1. Download and Install PowerBI (5%): https://powerbi.microsoft.com/en-us/desktop/

2. Overview the data that you’re going to transform into PowerBI.
Cookie Company Financials.xlsx
3. Transform data from spreadsheet using Power Query Editor (6%):
- Product: Remove the product line which is ‘Fortune Cookie’ since in the past
profitability of selling this product wasn’t high
- Unit sold: eliminate decimals
- Rename the column “Month Name” as “Month”
4. Get additional web source from wikipedia and transform it into PowerBI (5%):
https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population
Home - New Source - Web - URL
5. Rename the wikipedia table as “Country population” (2%)
6. Remove all extra columns from the “Country population” table except the “Country” and
“Population” columns. (3%)
7. Apply filter for Country column which transfers only those countries which were
indicated in the main dataset such as Canada, France, Germany, Mexico and the United
States. (3%)
8. Join two tables by merging queries (3%)
9. Visualization of data:
- Insert title for this report. Name it as “Cookie company performance report” (3%)
- Insert a line chart to illustrate profit by date (5%)
- Insert profit by geography with map visualization (5%)
- Insert a table to demonstrate the county, population and unit sold for each
countries (5%)
- Insert a bar chart showing sales by product (5%)
- Insert a slicer and adjust all your visuals by countries (5%)
10. Apply theme and change style (5%)
11. Review the dashboard to ensure accuracy, completeness, and usability. Make any
necessary adjustments or refinements to improve the overall user experience.
12. Submit your report

31
 Part 2. DAX basics (40%)

1. Import all below data and create data model

Cookie type
Customers
Orders
2. Define relationships between 3 tables (3%)
3. Create several measures using different functions:
- Define sum of total number of cookies sold across all different orders. Sum up all
values in the “Unit sold” field. Show the result in the dashboard indicating the
customer names; (6%)
- Count the number of total orders. Count all values from the “Unit sold” field.
Show the result in the dashboard indicating the customer names; (6%)
- Create a new measure using a distinct function to count the number of unique
customers; (6%)
- Calculate the total profit for cookies. Total Profit = sum(revenue)-sum(cost); (6%)
- Calculate profit margin as a percentage. Profit margin % = Total Profit /
Sum(revenue); (6%)
- Display the number of cookies sold on each day of a week. (7%)

32
Practice Work 10
Database (Part 1)

After completing PW 10-11, learners should be able to:

● understand relational databases;
● define relationships between tables;
● learn how to write SQL queries to extract specific information from large datasets,
perform calculations, filter data, and sort results;
● create, modify, and manage databases;
● retrieve, insert, update, and delete data from databases;
● learn how to use aggregate functions;
● learn advanced SQL features like joins and subqueries;
● understand how to define user roles and permissions, enforce data privacy, and protect
databases from unauthorized access or modifications.

33
 Practice work 10. Database (Part 1)

Platform to practice: https://livesql.oracle.com/

SQL tutorial: https://www.w3schools.com/sql/default.asp

Schema = HR, table = employees (40%)

1. Write a SQL statement to display all EMPLOYEES data from HR schema

2. Write a SQL statement to display employees’ last name, phone number and hire date
from employees table
3. Write a SQL statement to return unique job_id
4. Rename job_id column as “job positions” with alias
5. Write a SQL statement to display employee’s last name and their annual salary AS
“Annual” with alias
6. Write a SQL statement to display all employees where job_id is “IT_PROG” (IT
programmer)
7. Write a SQL statement to display all employees where job_id is financial accountant and
salary is greater than or equal to 8000
8. Write a SQL statement to return all employees whose hire date was after 2007 ( date
syntax: ‘01-JUN-07’)

Schema = Customer Orders, table = customer_order_products (25%)

9. Write a SQL statement to display all customers whose order status was “cancelled”
10. Write a SQL statement to display all customers sorted ascending by full name column
11. Write a SQL statement to display customers where order status is “complete” and sorted
ascending by full name column
12. Count the number of customers
13. Count the number of customers where order status was “cancelled”

Schema = Order Entry, table = customers (35%)

14. Write a SQL statement to return the max and min income of customers
15. Write a SQL statement to return all female customers
16. Write a SQL statement to return a list of unique countries
17. Write a SQL statement to return number of customers from Italy
18. Write a SQL query to return average credit limit for all customers
19. Write a SQL statement to return the number of customers whose territory Italy, Germany
and Switzerland

34
20. Write a SQL statement to return all customers whose credit limit is between 3000 and
5000, and territory is ‘America’

35
Practice Work 11
Database (Part 2)

After completing PW 10-11, learners should be able to:

● understand relational databases;
● define relationships between tables;
● learn how to write SQL queries to extract specific information from large datasets,
perform calculations, filter data, and sort results;
● create, modify, and manage databases;
● retrieve, insert, update, and delete data from databases;
● learn how to use aggregate functions;
● learn advanced SQL features like joins and subqueries;
● understand how to define user roles and permissions, enforce data privacy, and protect
databases from unauthorized access or modifications.

36
 Practice work 11. Database (Part 2)

Platform to practice: https://livesql.oracle.com/

SQL tutorial: https://www.w3schools.com/sql/default.asp

Schema: Order Entry, tables: customers, orders (60%)

1. Write a SQL statement to return all customers whose languages is not ‘us’
2. Write a SQL query to return all customers who spoken language is italian sorted by first
name column in ascending order
3. Write a SQL statement to return the first three customers list from China
4. Write a SQL statement to return the first 3 customers from India whose credit limit is
greater than 4700
5. Write a SQL statement to return all customers whose last name starts with ‘L’
6. Write a SQL statement to return all customers whose last name starts with ‘A’ and ends
with ‘r’
7. Write a SQL statement to rename ‘nls_territory’ column as a ‘country’ temporary
8. Write a SQL statement to return the number of customers in each country
9. Write a SQL query to return customers last name from customers table and their orders
date and order mode from orders table with inner join
10. Add ‘quantity’ from order_items table to the output of above query

Now go for the “schema” → “my schema” and select the option as follows: “Entering
SQL CREATE statements in the SQL Worksheet” (40%).

11. Create a students table with columns as student_id, first_name, last_name,

phone_number and email
12. Write a SQL query to insert the new records into student table (insert at least 4 records)
13. Add new ‘city’ column to the students table
14. Update records for email column
15. Delete the last entered student’s records from the table

37
Practice Work 12
Designing Mobile & Web Applications (Figma)

After completing PW 12, learners should be able to:

● understand UI design principles;
● learn how to design various UI components such as navigation bars, feed layouts, color
theory, visual hierarchy, profile screens and others;
● explore different design patterns commonly used in apps;
● develop skills in creating visually appealing and user-friendly interfaces;
● design intuitive interactions, seamless navigation, and meaningful user flows to showcase
the functionality of the app;
● create interactive prototypes with animations and transitions;
● create responsive designs that adapt to different screen resolutions;
● work collaboratively on design projects, enabling real-time editing, commenting, and
version control;

38
 Practice work 12. Figma

- Create a new Figma project for your Instagram UI/UX design;

- Name your project and add new frames to the canvas;
- Use Figma's shape tools, text tools, and vector editing capabilities to create buttons, input
fields, icons, navigation bars, and other UI elements;

Figma design has to include the following sections:

1. Header/Navigation Bar:
● At the top of the page, add a header that includes the Instagram logo, a like and
direct messenger field with plug-ins. 5%

● On the bottom side, add a footer that includes the navigation bar. The navigation
bar commonly includes buttons for the home feed, explore/search, reels, and the
user's profile. The navigation icons should be organized and grouped as a single
unit. Also, the grouped navigation icons position has to be fixed. 10%

2. User Stories:
● At the top of the feed, add a row of circular profile pictures representing stories
from accounts that the user follows. Fill all your story circles with pictures using
the unsplash plugin. Furthermore, in the back side of stories circles apply gradient
color. 15%

● Stories are typically displayed in a slideshow format, therefore add an action

which allows users to tap on a profile picture to view the corresponding story.

39
 ● To complete the above task create another frame and design the content as a story
page. At least two of your story profiles have to be clickable. Moreover, the story
page should return the reader back to the main feed or direct to another user’s
story page (See an example below). 20%

3. Feed Posts:
● The main section of the page should consist of a vertically scrolling list of feed
posts from accounts the user follows. Each post should include the profile picture
of the user who made the post, the post image or video, the post caption, and
buttons for engagement (e.g., like, comment, and share). Posts also have to
display the number of likes and comments they have received, as well as any
relevant tags or hashtags. 20%
● It’s important to apply vertical scrolling to the feed. It’s necessary to use the
“grouping” option to complete this part of the task (See an example below). 10%

40
 4. Actions and Engagement:
● The navigation bar that includes buttons like home feed, explore/search, reels or
user's profile also should get an action. It’s enough to add an action only for one
preferred icon. Do not forget to design the new frame to complete this part of the
task. 20%

Additionally:
- Pay attention to details such as spacing, alignment, and consistency to maintain a
cohesive design;
- Ensure that your design reflects the overall aesthetic and familiarity of the Instagram app
- Connect the frames together to demonstrate how a user would navigate through the app.

41
Practice Work 13
Designing Mobile & Web Applications (Portfolio Design)

After completing PW 13, learners should be able to:

● understand the basic features and functions of the website constructor platform, such as
templates, widgets, and drag-and-drop interface;
● create a visually appealing and cohesive design for the portfolio using various design
tools such as color schemes, typography, and graphics;
● organize and present portfolio content effectively, such as selecting and arranging work
samples, writing descriptions, and adding multimedia;
● customize the website's layout, navigation, and functionality to best showcase the
portfolio, such as adding contact forms, social media links, and other interactive
elements;
● optimize the website for search engines and mobile devices, such as adding keywords,
meta descriptions, and responsive design;
● add and manage multi language option to display content in different languages;
● understand the importance of branding and personal style in portfolio design, and
incorporating these elements into the website's overall look and feel;
● continuously evaluating and refining the portfolio website based on user feedback,
analytics, and industry best practices.

42
 Practice work 13

Designing Mobile & Web Applications: Portfolio Design

Web site constructors: Google Site/ WIX / Tilda

Wix: wix.com, Tilda: tilda.cc, Google Site: sites.google.com

Portfolios are documents that can show your professional or creative talents in greater
detail than a resume can show. The exact nature of your portfolio may depend on the field you
work in, but some basic aspects of portfolio-making apply across all fields. A portfolio can also
contain your resume, a personal statement, proof of awards and recognitions, testimonials,
references and a portrait photograph of yourself.
Using preferred website constructor (wix, tilda, google site, etc.), please create your own
portfolio. Your portfolio should consist of the following sections(most important sections):

1. Hero section (Homepage/main page).

The hero section is the first thing people see when they enter your portfolio.

It is displayed under your logo and menu.

The hero section helps the reader to understand what you offer, why someone should work with
you, and the value that you provide with your services.

It often contains a call to action button like "contact me", "book a meeting" or similar.

43
2. About me section(Resume).

Give the reader a short summary about yourself.

Include subjects such as your education, work experience, projects and interests.

Help the reader to understand what you are passionate about and your superpowers (the things
that you are really good at).

Remember to keep it short and simple.

3. Projects/Interests section.

List the projects that you have worked on. The most used way is to order the list by date, but in
some cases it can make sense to order them in another logical way.

Add details to each project, which includes your role, what you did, and how the project turned
out.

Adding pictures to showcase what you built is a plus! Showcase the things that you are proud of.

44
4. “Contact me” section.

Let the reader know how and where they can get in touch with you.

Add your contact details and other contact channels such as your GitHub profile, LinkedIn,
Youtube and so on.

45
Grading

1. Content: Replace the template content with your own text, images, and other media. This
includes changing the wording and structure of pages, updating images or videos, and
adding your own branding. 10%
2. Design: The template comes with a default design that you have to customize to match
your preferences. This includes changing colors, fonts, and layout elements. 10%
3. Navigation: The template comes with a pre-set navigation menu that you have to update
to reflect your own portfolio’s content. This includes adding or deleting pages, and
reordering menu items. In case of landing pages navigate your site with scrolling 10%
4. Functionality: Depending on your needs, you need to add or remove certain features from
the template. This may include adding forms, social media integration or other third-party
apps and widgets. 10%
5. Clickability of buttons. 10%
6. Multi Language option: site should automatically detect and translate portfolio’s content.
10%
7. Mobile Optimization: It's important to ensure that the site is optimized for mobile
devices, so you need to adjust the layout and design elements to ensure a good user
experience on small screens. 15%
8. Add animation/transitions to a group of elements/blocks/sections 10%
9. Correctly arranged order of sections (Welcome page -> About me -> Resume ->
Projects/Interest -> Contact). Please remember, section titles might be different based on
site purpose. 10%
10. Publish your portfolio. 5%

46
Practice Work 14
HTML & CSS Fundamentals (Part 1)

After completing PW 14, learners should be able to:

● identify the developer tools and integrated development environments (IDEs) used by web
developers;
● understand the fundamental elements of a webpage, such as headings, paragraphs,
images, links, lists, tables, forms, and more;
● develop a deep understanding of how web content is organized and how different
elements work together to create a cohesive user experience;
● modify the structure, layout, and content of existing web pages to achieve desired
outcomes

47
 Practice work 14.
HTML & CSS Fundamentals: Building a personal website

Suggested soft to complete the task: VSCode, SublimeText OR Online HTML Editors like
Programiz.
Additional resource: You can take the following free short course from codecademy to
learn HTML basics: https://www.codecademy.com/learn/learn-html

Building a Personal Website using some of the most common HTML elements
Create a personal website that showcases your skills, experience, and interests. Use HTML to
structure the content of the website and CSS to style the elements. Include sections such as an
introduction, education background, work experience, projects, and contact information.

- Create a new HTML file;

- Set up the basic HTML structure by adding the <!DOCTYPE html> declaration, opening
and closing <html>, <head> and <body> tags; 5%
- Inside the <body> tag, create a <div> with a class or id to serve as the header section; 5%
- Within the header <div> use appropriate HTML tags like <h1> for your name , <p> for
the introduction and <img> for photo; 10%
- Below the header <div>, create separate <div> sections for skills, experience, and
interests. Assign appropriate classes or ids to each <div> for styling and targeting; 5%
- Inside each <div> section, add content using HTML tags. Use <em> and <strong> tags to
emphasize text and line breaks with <br> tag; 10%
- Use <ul> and <li> tags to list your skills, job experience details, and interests; 10%
- Create another <div> at the bottom of the page to serve as the footer section. Add contact
information, social media links with <a href> and any additional details you want to
include within the footer <div>. 10%

- Create a CSS file named "styles.css" and link it to your HTML file using the <link> tag
in the <head> section; 10%
- Define CSS styles in the "styles.css" file to format the content, layout, colors, and
typography of your personal website. 15%
- Use CSS selectors to target the appropriate classes or ids assigned to the <div> sections
and apply styles to them. 10%

- Make any necessary adjustments to the content or styling based on your preferences. 10%

48
Practice Work 15
HTML & CSS Fundamentals (Part 2)

After completing PW 15, learners should be able to:

● create static web pages and understand the fundamental building blocks of the web;
● learn how to structure content, apply styling, and create visually appealing layouts for
websites;
● understand how to design user-friendly interfaces by utilizing HTML elements and CSS
styles effectively;
● acquire the knowledge to design websites that adapt and respond to different screen sizes
and devices;
● learn to inspect elements from browser;
● ​enhance problem-solving skills by debugging HTML and CSS code and resolving common
web design issues.

49
 Practice work 15.

HTML & CSS Fundamentals: Building a Google’s main page

Build the basic structure of google homepage by making the center part which will
include logo, search bar and buttons with HTML and CSS.

To create a simplified version of Google's main page using HTML and CSS, follow these steps:
1. Create two separate files for this project. One is the HTML file which will add structure
of the project and the other is a CSS file which will add style to structure given by the
html elements;
2. Link your style.css file in the <head> of the html file using the link tag; 5%
3. Create a container using <div> tag and assign class=”main” to it. Add CSS for the div tag
and set text-alignment property to center so that all the elements inside the div appear at
the center of webpage; 15%
4. Add the google image using <img> tag and and the image source using src attribute; 10%
5. Add a search box and give class=”search”. Use input tag for type=”text”. It’s optional to
add add an image of the voice search option which will be displayed inside the search
box; 10%
6. Create two buttons for ‘Google Search’ and ‘I’m Feeling Lucky’ using the button tag.
Assign classes to both the buttons, class=”btns”; 10%
7. Add some styling to make a page eye-catching using CSS. You already created a separate
CSS file style.css above and linked it to the html file. Open it and start the styling process
step-by-step using the classes which you defined inside html elements;
8. To style the search bar for google homepage, set the followings: display: block; width:
400px; line-height: 24px; margin-left: auto; margin-right: auto; border: 1px solid

50
 #dfe1e5; border-radius: 24px; padding-top: 10px; padding-bottom: 10px; padding-left:
30px; padding-right: 30px; (15%)
9. To style the google image and buttons set the followings: display: block; width: 300px;
margin-bottom: 10px; margin-left: auto; margin-right: auto; (15%)
10. The buttons will be styled in the following way: margin-top: 30px; margin-left: 4px;
margin-right: 4px; background: #dfe1e5; border:none; border-radius: 4px;
padding-top:8px; padding-bottom: 8px; padding-right: 16px; padding-left: 16px;
font-size:14px; (15%)
11. Make any necessary adjustments to the content or styling based on your task and share
your result. 5%

51
 CONCLUSION
Throughout the practice book, readers are guided step-by-step through practical exercises
and activities, allowing them to gain hands-on experience and develop a strong foundation in
using Google Docs, Forms, Slides and Sheets. They are equipped with the knowledge and skills
to create, collaborate and present information effectively. Furthermore, readers explore advanced
functions and techniques to unlock the full potential of Google Sheets, including data analysis
and visually compelling charts.
The practice book also delves into the realm of data visualization, providing guidance on
using Looker Studio and PowerBI to transform raw data into insightful visual representations.
Additionally, students learn about database management, enabling them to organize and retrieve
information efficiently.
Moreover, the practice book offers insights into web application design, covering
fundamental concepts such as HTML and CSS. Learnersare introduced with Figma, a powerful
design tool, and learn how to create visually appealing and user-friendly mobile and web
applications.
By combining theoretical knowledge with practical exercises, this practice book
empowers learners to apply their newfound skills in real-world scenarios.
In summary, this practice book not only facilitates the mastery of essential tools and
technologies, but also fosters creativity, critical thinking and problem-solving skills. It aims to
empower learners to become proficient users and leverage these tools to enhance their
productivity, analyze data effectively, visualize information intuitively, manage databases
efficiently and design compelling web applications. The journey through this practice book is an
invitation to unlock new possibilities and achieve success in various academic, professional and
personal endeavors.

52
 REFERENCES

1. Academica. (n.d.). Analytics. Retrieved from https://analytics.academica.kz/

2. Career Principles. (n.d.). Excel for Business Finance. Retrieved from
https://www.careerprinciples.com/courses/excel-for-business-finance
3. Coursera. (n.d.). Excel Advanced. Retrieved from
https://www.coursera.org/learn/excel-advanced
4. Stratvert, K. (n.d.). Free Tutorials. Retrieved from
https://kevinstratvert.com/free-tutorials/
5. Udemy. (n.d.). Google Sheets Masterclass. Retrieved from
https://www.udemy.com/course/google-sheets-masterclass/
6. Scrimba. (n.d.). Learn HTML and CSS. Retrieved from
https://scrimba.com/learn/htmlandcss

53